View In:   ArcGIS Online Map Viewer

Name: NCAviationBus_2022_CountyJoin

Display Field: company_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Data Axle collects information on over 13 million private and public companies. Individual businesses are located by address geocoding—not all will have an exact location. Records that did not match fall back to the geocode provided by Data Axle. Businesses can be retrieved by their Standard Industrial Classification Code (SIC) as well as by North American Industry Classification System (NAICS) Code and Location. The Data Axle Business File can be used for locating both competitors and marketing opportunities.

Service Item Id: 688e5a487eeb42ba9930bd9120d49819

Copyright Text: Esri; Data Axle

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -9335678.9646
YMin: 4019285.5864999965
XMax: -8422702.5112
YMax: 4361066.932999998
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [190, 255, 232, 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:

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

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: OBJECTID )
• company_name ( modelName: CONAME, nullable: true, editable: true, defaultValue: null, length: 30, alias: Company Name, type: esriFieldTypeString )
• executive_first_name ( modelName: executive_first_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Executive First Name, type: esriFieldTypeString )
• executive_last_name ( modelName: executive_last_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Executive Last Name, type: esriFieldTypeString )
• address ( modelName: address, nullable: true, editable: true, defaultValue: null, length: 255, alias: Address, type: esriFieldTypeString )
• city ( modelName: CITY, nullable: true, editable: true, defaultValue: null, length: 16, alias: City, type: esriFieldTypeString )
• state ( modelName: STATE, nullable: true, editable: true, defaultValue: null, length: 2, alias: State, type: esriFieldTypeString )
• zip_code ( modelName: ZIP, nullable: true, editable: true, defaultValue: null, length: 5, alias: ZIP Code, type: esriFieldTypeString )
• record_type ( modelName: REC_TYPE, nullable: true, editable: true, defaultValue: null, alias: Record Type, type: esriFieldTypeSmallInteger )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• sic_code ( modelName: SIC, nullable: true, editable: true, defaultValue: null, length: 6, alias: Primary SIC Code, type: esriFieldTypeString )
• naics_code ( modelName: NAICS, nullable: true, editable: true, defaultValue: null, length: 8, alias: Primary NAICS Code, type: esriFieldTypeString )
• business_classification ( modelName: business_classification, nullable: true, editable: true, defaultValue: null, length: 255, alias: Business Classification, type: esriFieldTypeString )
• number_of_employees ( modelName: EMPNUM, nullable: true, editable: true, defaultValue: null, alias: Location Employee Size Actual, type: esriFieldTypeInteger )
• estimated_annual_sales_volume ( modelName: SALESVOL, nullable: true, editable: true, defaultValue: null, alias: Location Sales Volume Actual, type: esriFieldTypeInteger )
• county_name ( modelName: county_name, nullable: true, editable: true, defaultValue: null, length: 32, alias: County, type: esriFieldTypeString )
• email ( modelName: email, nullable: true, editable: true, defaultValue: null, length: 255, alias: Email, type: esriFieldTypeString )
• otherbusinessclassification ( modelName: otherbusinessclassification, nullable: true, editable: true, defaultValue: null, length: 255, alias: Other Business Classification, type: esriFieldTypeString )
• reviewstatus ( modelName: reviewstatus, nullable: true, editable: true, defaultValue: null, length: 255, alias: Review Status, type: esriFieldTypeString )
• reviewcomments ( modelName: reviewcomments, nullable: true, editable: true, defaultValue: null, length: 255, alias: Review Comments, type: esriFieldTypeString )
• code ( modelName: code, nullable: true, editable: true, defaultValue: null, alias: Code, type: esriFieldTypeInteger )

Templates:

• Name: NCAviationBus_2022_CountyJoin
  Description:
  Prototype:
  naics_code: null
  otherbusinessclassification: null
  reviewstatus: null
  estimated_annual_sales_volume: null
  address: null
  code: null
  city: null
  latitude: null
  business_classification: null
  reviewcomments: null
  county_name: null
  zip_code: null
  record_type: null
  sic_code: null
  number_of_employees: null
  executive_first_name: null
  executive_last_name: null
  company_name: null
  state: null
  email: null
  longitude: 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

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