Setup Customers Using Tabular Data (Business Analyst)
Zusammenfassung
Geocodes tabular data and defines the output feature class as a customer file for use in the Analysis And Trade Areas tools.
Verwendung
-
When geocoding stores, it is best to have address, city, state, and ZIP Code 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 also 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 input table used for setting up your customer layer. | Table View |
Locator |
The predefined address locator service. | Address Locator |
MatchFields |
Input fields for geocoding addresses. | Field Info |
NameField |
The unique identifier for the input feature class (commonly the customer name). | Field |
LinkField |
Unique ID linking the customer file with the store file. | Field |
OutputFeatureClass |
The feature class that will contain the customer points. | Feature Class |
CS_AppendsegmentationCodes (optional) |
Appends Tapestry Segmentation codes to the customer layer.
| Boolean |
CS_CreateCustomerProfile (optional) |
Creates a Tapestry Segmentation Profile based on the customer layer.
| Boolean |
CSCustomerProfileName (optional) |
The name of the customer profile. | String |
InputVolumeInfoFieldName (optional) |
The field containing your volumetric field. Typically this is a sales filed associated with customer data. | Field |
SegmentationBase |
The base data to be used in creating the customer profile.
| String |
Codebeispiel
# Name: SetupCustomersByTable.py # Description: Geocodes San Francisco customers using tabular data. # Author: ESRI # Import system modules import arcview 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 Customers Using Tabular Data tool Input = 'C:/Program Files/ArcGIS/Business Analyst/Datasets/Tutorial/sf_custs.dbf' OutFC= "C:/temp/sf_customers.shp" Locator = "C:/Program Files/ArcGIS/Desktop10.0/Business Analyst/Data/USA Geocoding Service/USA Geocoding Service" CustName = "NAME" StoreId = "STORE_ID" FldCol = "Addr ADDRESS VISIBLE;City City VISIBLE;State State VISIBLE;ZIP ZIP VISIBLE" # Generate customer layers with tabular data arcpy.SetupCustomersByTable_ba(Input, Locator, FldCol, CustName, StoreId, OutFC) # Release extension license arcpy.CheckInExtension("Business") except: print arcpy.GetMessages(2)