ArcMap

Setup Store Using XY Data

Available with Business Analyst license.

Summary

Tool allows you to turn x,y (latitude-longitude) coordinate data into store points.

Usage

  • This tool allows you to create a store layer based on x and y columns from an input table.

  • Many forms of GPS-collected data will contain latitude/longitude coordinates. You can use this tool to convert GPS-collected data into stores.

  • If your x,y data is stored in a relational database, such as Access, it can be accessed through this tool utilizing the Database Connections wizard in ArcCatalog.

Syntax

SetupStoreByXYData_ba (Table, LatitudeField, LongitudeField, NameField, StoreIDField, OutputFeatureClass, WayToSpecifyStoreIDField, {UsePictureSymbol}, {ImagePath}, {PictureSymbolSize})
ParameterExplanationData Type
Table

The table of x,y data that will be used to create stores.

Table View
LatitudeField

The field containing your latitude coordinates (y field).

Field
LongitudeField

The field containing your longitude coordinates (x field).

Field
NameField

The field containing the store name.

Field
StoreIDField

The name used to identify the unique store ID. This ID is a link to the associated customer layer.

Field
OutputFeatureClass

The feature class that will contain the store points.

Feature Class
WayToSpecifyStoreIDField

Selects an existing Store ID Field or creates a new field.

  • USE_EXISTING —Uses the existing Store ID Field. This is the default.
  • CREATE_NEW —Creates a new store ID field.
Boolean
UsePictureSymbol
(Optional)

Inserts custom store symbology into point feature class.

  • True —Inserts custom symbology.
  • False —Will not insert custom symbology. This is the default.
Boolean
ImagePath
(Optional)

The file location containing the custom store symbology.

File
PictureSymbolSize
(Optional)

The size, in pixels, of the picture symbol.

Long

Code sample

SetupStoreByXYData example (stand-alone script)

# Name: SetupStoreByXYData.py
# Description: Creates a store layer from latitude longitude coordinates. 
# Author: Esri

# Import system modules
import arcview
import arcpy

arcpy.ImportToolbox(r"C:\Program Files (x86)\ArcGIS\Desktop10.7\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx")

try:
# Acquire extension license 
  arcpy.CheckOutExtension("Business") 
 
# Defines the parameters for the Setup Store Using XY Data tool
  Table = "C:/temp/sf_store.shp"
  LatitudeField = "Latitude"
  LongitudeField = "Longitude"
  NameField = "NAME"
  StoreIDField = "STORE_ID"
  OutputFeatureClass = "C:/temp/sf_storenew.shp"
 
# Sets up a new customer layer based on XY data
  arcpy.SetupStoreByXYData_ba(Table, LatitudeField, LongitudeField, NameField, StoreIDField, OutputFeatureClass)
 
# Release extension license 
  arcpy.CheckInExtension("Business")
     
except:
  print arcpy.GetMessages(2)

Environments

This tool does not use any geoprocessing environments.

Licensing information

  • ArcGIS Desktop Basic: Requires Business Analyst
  • ArcGIS Desktop Standard: Requires Business Analyst
  • ArcGIS Desktop Advanced: Requires Business Analyst

Related topics