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
SetupCustomersByXYData_ba (Table, LatitudeField, LongitudeField, NameField, LinkField, OutputFeatureClass)
| 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
SetupCustomersByXYData Example (Stand-alone Script)
# 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.3\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)
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