Setup Customers Using XY Data (Business Analyst)
Summary
Transforms x,y (latitude-longitude) coordinate data into a customer layer.
Usage
-
This tool allows you to create a customer layer based on x and y columns from an input table.
-
To add a table of x,y coordinates to your map, the table must contain two fields: x-coordinates (longitude) and y-coordinates (latitude).
-
Latitude and longitude coordinates that are in degrees, minutes, seconds (DMS) format must be converted to decimal degrees before using this tool.
-
If using latitude and longitude coordinates, verify that the latitude is a positive integer and the longitude is a negative integer.
-
Many forms of GPS-collected data will contain x,y coordinates. You can use this tool to convert GPS-collected data into customers.
-
If your x,y data is stored in a relational database such as Access, it can be accessed through this tool using the Database Connections wizard in ArcCatalog.
-
This setup tool does not generate a feature class; it generates an x,y event layer.
Syntax
| Parameter | Explanation | Data Type |
Table |
The input table used for setting up your customer layer. | Table View |
LatitudeField |
The field containing your latitude coordinates (Y field). | Field |
LongitudeField |
The field containing your longitude coordinates (X field). | Field |
NameField |
The unique identifier for the customer data (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 features. | Feature Class |
Code Sample
# Name: SetupCustomersByXYData.py
# Description: Creates a customer layer from latitude longitude coordinates.
# Author: Esri
# Import system modules
import arcview
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")
# Define the parameters for the Setup Customers Using XY Data tool
CustPath = "C:/temp/sf_cust.dbf"
NewFC = "C:/temp/sf_customer.shp"
Lat = "Latitude"
Long = "Longitude"
CustName = "NAME"
StoreId = "STORE_ID"
# Sets up a new customer layer based on XY data
arcpy.SetupCustomersByXYData_ba(CustPath, Lat, Long, CustName, StoreId, NewFC)
# Release extension license
arcpy.CheckInExtension("Business")
except:
print arcpy.GetMessages(2)