ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Setup Store Using Tabular Data

  • Summary
  • Usage
  • Syntax
  • Code Sample
  • Environments
  • Licensing Information

Summary

Allows you to turn tabular data (.dbf, .txt, or RDBMS format) into store points.

Learn more about how Setup Store Using Tabular Data works

Usage

  • When geocoding stores, it's best to have address, city, state, and ZIP fields to ensure the best results for the geocoder.

  • View the geocoding output log to examine the match rate of your input addresses.

  • The standard input tabular data formats used are .dbf (IV), .csv, and tab-delimited text (.txt).

  • Relational database files can be accessed through this tool utilizing the Database Connections wizard in ArcCatalog.

  • If importing from Excel to .dbf, make sure your field headers are eight characters or less and do not have special characters embedded in the description.

Syntax

SetupStoreByTable_ba (Table, Locator, MatchFields, NameField, StoreIDField, OutputFeatureClass, {WayToSpecifyStoreIDField}, {UsePictureSymbol}, {ImagePath}, {PictureSymbolSize})
ParameterExplanationData Type
Table

The tabular data (.dbf, .txt, or RDBMS format) that will be used to geocode your stores.

Table View
Locator

The address locator service to use to geocode addresses.

Address Locator
MatchFields

Input fields for geocoding addresses.

Field Info
NameField

The field containing the store name.

Field
StoreIDField

The name used to identify the store ID.

String
OutputFeatureClass

The feature class that will contain the store points.

Feature Class
WayToSpecifyStoreIDField
(Optional)

Selects an existing store ID field or creates a new field.

  • USE_EXISTING —Uses an existing store ID field.
  • CREATE_NEW —Creates a new store ID field. This is the default.
Boolean
UsePictureSymbol
(Optional)

Inserts custom store symbology into point feature class.

  • True —Inserts custom symbology.
  • False —Will not insert custom symbology. This is the default.
Boolean
ImagePath
(Optional)

The file location containing the custom store symbology.

File
PictureSymbolSize
(Optional)

Set the symbol size by points.

Long

Code Sample

SetupStoreByTable Example (Stand-alone Script)
# Name: SetupStoreByTable.py
# Description: Geocodes San Francisco customers using tabular data. 
# Author: Esri

# Import system modules

import arcpy

arcpy.ImportToolbox("C:\Program Files (x86)\ArcGIS\Desktop10.3\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx")
 
try:
  # Acquire extension license 
  arcpy.CheckOutExtension("Business") 
 
  # Defines the parameters for the Setup Store Using Tabular Data tool
  Input = "C:/ArcGIS/Business Analyst/US_2014/Datasets/Tutorial/sf_stores.dbf"
  OutFC= "C:/temp/sf_store.shp"
  Locator = "C:/ArcGIS/Business Analyst/US_2014/Data/Geocoding Data/USA Geocoding Service.loc"
  StoreName = "NAME"
  StoreId = "STORE_ID"
  FldCol = "Addr ADDRESS VISIBLE;Addr2 <none> VISIBLE;City <none> VISIBLE;State <none> VISIBLE;ZIP ZIP VISIBLE;ZIPExt <none> VISIBLE;Firm NAME VISIBLE"
 
  # Setup Store Using Tabular Data
  arcpy.SetupStoreByTable_ba(Input, Locator, FldCol, StoreName, "USE_EXISTING", StoreId, OutFC)
 
  # Release extension license 
  arcpy.CheckInExtension("Business")
 
except:
  print arcpy.GetMessages(2)

Environments

This tool does not use any geoprocessing environments

Licensing Information

  • ArcGIS for Desktop Basic: Requires Business Analyst
  • ArcGIS for Desktop Standard: Requires Business Analyst
  • ArcGIS for Desktop Advanced: Requires Business Analyst

Related Topics

  • An overview of the Store Setup toolset
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal