View In:   ArcGIS Online Map Viewer

Name: US_Businesses

Display Field: coname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Businesses provides a detailed list of businesses from Data Axle. It includes company name, Standard Industrial Classification (SIC) and North American Industry Classification System (NAICS) industry code and location coordinates for every business in the database.

Service Item Id: 7ce48682e7e04552b57dd39337b8168d

Copyright Text: Esri; Data Axle

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -176.65756999999996
YMin: 18.969124000000022
XMax: -66.95060499999994
YMax: 71.32598300000006
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [145, 139, 53, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: Object ID )
• esri_pid ( nullable: true, editable: true, defaultValue: null, length: 32, type: esriFieldTypeString, modelName: esri_pid, alias: Esri PID )
• coname ( nullable: true, editable: true, defaultValue: null, length: 238, type: esriFieldTypeString, modelName: coname, alias: Company/Business Name )
• street ( nullable: true, editable: true, defaultValue: null, length: 41, type: esriFieldTypeString, modelName: street, alias: Street )
• city ( nullable: true, editable: true, defaultValue: null, length: 27, type: esriFieldTypeString, modelName: city, alias: City )
• state ( nullable: true, editable: true, defaultValue: null, length: 2, type: esriFieldTypeString, modelName: state, alias: State Abbreviation )
• state_name ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: state_name, alias: State Name )
• zip ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, modelName: zip, alias: ZIP Code )
• zip4 ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: zip4, alias: ZIP+4 Extension )
• sic_all ( nullable: true, editable: true, defaultValue: null, length: 398, type: esriFieldTypeString, modelName: sic_all, alias: All SIC Codes )
• sic ( nullable: true, editable: true, defaultValue: null, length: 6, type: esriFieldTypeString, modelName: sic, alias: Primary SIC )
• sic_desc ( nullable: true, editable: true, defaultValue: null, length: 71, type: esriFieldTypeString, modelName: sic_desc, alias: SIC Code Description )
• naics_all ( nullable: true, editable: true, defaultValue: null, length: 512, type: esriFieldTypeString, modelName: naics_all, alias: All NAICS Codes )
• naics ( nullable: true, editable: true, defaultValue: null, length: 8, type: esriFieldTypeString, modelName: naics, alias: Primary NAICS )
• naics_desc ( nullable: true, editable: true, defaultValue: null, length: 71, type: esriFieldTypeString, modelName: naics_desc, alias: NAICS Code Description )
• naics_sect ( nullable: true, editable: true, defaultValue: null, length: 40, type: esriFieldTypeString, modelName: naics_sect, alias: NAICS Industry Sector )
• salesvol ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: salesvol, alias: Sales Volume )
• empnum ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: empnum, alias: Employee Count )
• placetype ( nullable: true, editable: true, defaultValue: null, length: 12, type: esriFieldTypeString, modelName: placetype, alias: Business Category )
• hqname ( nullable: true, editable: true, defaultValue: null, length: 107, type: esriFieldTypeString, modelName: hqname, alias: Headquarters Name )
• sqftcode ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: sqftcode, alias: Square Foot Code )
• sqfootage ( nullable: true, editable: true, defaultValue: null, length: 13, type: esriFieldTypeString, modelName: sqfootage, alias: Square Footage )
• min_sqft ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: min_sqft, alias: Square Foot Minimum )
• max_sqft ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: max_sqft, alias: Square Foot Maximum )
• affiliate ( nullable: true, editable: true, defaultValue: null, length: 101, type: esriFieldTypeString, modelName: affiliate, alias: Affiliated Orgs )
• brand ( nullable: true, editable: true, defaultValue: null, length: 195, type: esriFieldTypeString, modelName: brand, alias: Brands )
• loc_conf ( nullable: true, editable: true, defaultValue: null, length: 9, type: esriFieldTypeString, modelName: loc_conf, alias: Location Confidence )
• source ( nullable: true, editable: true, defaultValue: null, length: 9, type: esriFieldTypeString, modelName: source, alias: Source )

Templates:

• Name: US_Businesses
  Description:
  Prototype:
  city: null
  coname: null
  zip4: null
  source: null
  sic: null
  min_sqft: null
  naics_sect: null
  state_name: null
  street: null
  sic_all: null
  state: null
  brand: null
  zip: null
  placetype: null
  naics_desc: null
  loc_conf: null
  sqfootage: null
  sic_desc: null
  naics_all: null
  empnum: null
  esri_pid: null
  salesvol: null
  max_sqft: null
  hqname: null
  affiliate: null
  naics: null
  sqftcode: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata