Setup Store Using Tabular Data (Business Analyst)
Zusammenfassung
Allows you to turn tabular data (.dbf, .txt, or RDBMS format) into store points.
Verwendung
-
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 | Erläuterung | Datentyp |
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 |
Codebeispiel
# Name: SetupStoreByTable.py # Description: Geocodes San Francisco customers using tabular data. # Author: ESRI # Import system modules import arcpy arcpy.ImportToolbox("C:\Program Files\ArcGIS\Desktop10.0\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:/Program Files/ArcGIS/Business Analyst/Datasets/Tutorial/sf_stores.dbf" OutFC= "C:/temp/sf_store.shp" Locator = "C:/Program Files/ArcGIS/Desktop10.0/Business Analyst/Data/USA Geocoding Service/USA Geocoding Service" 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)