ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Setup Customers Using XY Data

  • Summary
  • Usage
  • Syntax
  • Code Sample
  • Environments
  • Licensing Information

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)
ParameterExplanationData 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

Related Topics

  • An overview of the Customer Setup toolset
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal