Setup Store Using Tabular Data (Business Analyst)
Summary
Allows you to turn tabular data (.dbf, .txt, or RDBMS format) into store points.
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
| Parameter | Explanation | Data 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.
| Boolean |
UsePictureSymbol (Optional) |
Inserts custom store symbology into point feature class.
| Boolean |
ImagePath (Optional) |
The file location containing the custom store symbology. | File |
PictureSymbolSize (Optional) |
Set the symbol size by points. | Long |
Code Sample
# 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.2\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_2013/Datasets/Tutorial/sf_stores.dbf"
OutFC= "C:/temp/sf_store.shp"
Locator = "C:/ArcGIS/Business Analyst/US_2013/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)