View In:   ArcGIS Online Map Viewer

Name: AL_Contractors_BAExtract

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: a7c3dc3487ca4de6acdd3e66a604b256

Copyright Text: Esri; Data Axle

Default Visibility: true

MaxRecordCount: 2000

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: -9844515.1233
YMin: 3533296.5007999986
XMax: -9459465.3461
YMax: 4162784.6301999986
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [230, 0, 0, 255]
Size: 6.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:

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 )
• coname ( modelName: coname, nullable: true, editable: true, defaultValue: null, length: 167, alias: Company/Business Name, type: esriFieldTypeString )
• street ( modelName: street, nullable: true, editable: true, defaultValue: null, length: 56, alias: Street, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 27, alias: City, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: null, length: 2, alias: State Abbreviation, type: esriFieldTypeString )
• zip ( modelName: zip, nullable: true, editable: true, defaultValue: null, length: 5, alias: ZIP Code, type: esriFieldTypeString )
• sic ( modelName: sic, nullable: true, editable: true, defaultValue: null, length: 6, alias: Primary SIC, type: esriFieldTypeString )
• naics ( modelName: naics, nullable: true, editable: true, defaultValue: null, length: 8, alias: Primary NAICS, type: esriFieldTypeString )
• salesvol ( modelName: salesvol, nullable: true, editable: true, defaultValue: null, alias: Sales Volume, type: esriFieldTypeInteger )
• empnum ( modelName: empnum, nullable: true, editable: true, defaultValue: null, alias: Employee Count, type: esriFieldTypeInteger )
• placetype ( modelName: placetype, nullable: true, editable: true, defaultValue: null, length: 12, alias: Business Category, type: esriFieldTypeString )
• hqname ( modelName: hqname, nullable: true, editable: true, defaultValue: null, length: 107, alias: Headquarters Name, type: esriFieldTypeString )
• source ( modelName: source, nullable: true, editable: true, defaultValue: null, length: 9, alias: Source, type: esriFieldTypeString )
• esri_pid ( modelName: esri_pid, nullable: true, editable: true, defaultValue: null, length: 32, alias: Esri PID, type: esriFieldTypeString )
• countyname ( modelName: countyname, nullable: true, editable: true, defaultValue: null, length: 50, alias: CountyName, type: esriFieldTypeString )
• countyname_short ( modelName: countyname_short, nullable: true, editable: true, defaultValue: null, length: 50, alias: CountyName_short, type: esriFieldTypeString )
• contractorflag ( modelName: contractorflag, nullable: true, editable: true, defaultValue: null, alias: ContractorFlag, type: esriFieldTypeInteger )
• nationalretailerflag ( modelName: nationalretailerflag, nullable: true, editable: true, defaultValue: null, alias: NationalRetailerFlag, type: esriFieldTypeInteger )
• nationalretailer ( modelName: nationalretailer, nullable: true, editable: true, defaultValue: null, length: 50, alias: NationalRetailer, type: esriFieldTypeString )

Templates:

• Name: AL_Contractors_BAExtract
  Description:
  Prototype:
  nationalretailerflag: null
  zip: null
  placetype: null
  nationalretailer: null
  city: null
  coname: null
  source: null
  sic: null
  countyname: null
  empnum: null
  esri_pid: null
  salesvol: null
  countyname_short: null
  contractorflag: null
  street: null
  hqname: null
  state: null
  naics: 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