Name: DataAxelBusinessSummary

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• COMPANY_NAME (type: esriFieldTypeString, alias: COMPANY_NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ZIP_CODE (type: esriFieldTypeString, alias: ZIP_CODE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• LOCATION_ADDRESS_DELIVERY_POINT (type: esriFieldTypeInteger, alias: LOCATION_ADDRESS_DELIVERY_POINT_BAR_CODE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ACTUAL_EMPLOYEE_SIZE (type: esriFieldTypeInteger, alias: ACTUAL_EMPLOYEE_SIZE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• EMPLOYEE_SIZE_RANGE (type: esriFieldTypeString, alias: EMPLOYEE_SIZE_RANGE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ACTUAL_SALES_VOLUME (type: esriFieldTypeString, alias: ACTUAL_SALES_VOLUME, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• SALES_VOLUME_RANGE (type: esriFieldTypeString, alias: SALES_VOLUME_RANGE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PRIMARY_SIC (type: esriFieldTypeInteger, alias: PRIMARY_SIC, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PRIMARY_SIC_DESCRIPTION (type: esriFieldTypeString, alias: PRIMARY_SIC_DESCRIPTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SECONDARY_SIC__1 (type: esriFieldTypeInteger, alias: SECONDARY_SIC__1, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SECONDARY_SIC_DESCRIPTION__1 (type: esriFieldTypeString, alias: SECONDARY_SIC_DESCRIPTION__1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SECONDARY_SIC__2 (type: esriFieldTypeInteger, alias: SECONDARY_SIC__2, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SECONDARY_SIC_DESCRIPTION__2 (type: esriFieldTypeString, alias: SECONDARY_SIC_DESCRIPTION__2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• HEADQUARTERS_BRANCH (type: esriFieldTypeString, alias: HEADQUARTERS_BRANCH, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• YEAR_1ST_APPEARED (type: esriFieldTypeInteger, alias: YEAR_1ST_APPEARED, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• OFFICE_SIZE (type: esriFieldTypeString, alias: OFFICE_SIZE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SQUARE_FOOTAGE (type: esriFieldTypeString, alias: SQUARE_FOOTAGE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FIRM_INDIVIDUAL (type: esriFieldTypeString, alias: FIRM_INDIVIDUAL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PUBLIC_PRIVATE_FLAG (type: esriFieldTypeString, alias: PUBLIC_PRIVATE_FLAG, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Fleet_size (type: esriFieldTypeString, alias: Fleet_size, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FRANCHISE_SPECIALTY__1 (type: esriFieldTypeString, alias: FRANCHISE_SPECIALTY__1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FRANCHISE_SPECIALTY__2 (type: esriFieldTypeString, alias: FRANCHISE_SPECIALTY__2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• INDUSTRY_SPECIFIC_CODES (type: esriFieldTypeString, alias: INDUSTRY_SPECIFIC_CODES, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ADSIZE_IN_YELLOW_PAGES (type: esriFieldTypeString, alias: ADSIZE_IN_YELLOW_PAGES, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• METRO_AREA (type: esriFieldTypeString, alias: METRO_AREA, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DATA_AXLE_USA_ID (type: esriFieldTypeInteger, alias: DATA_AXLE_USA_ID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Match_Code (type: esriFieldTypeString, alias: Match_Code, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PRIMARY_NAICS_CODE (type: esriFieldTypeInteger, alias: PRIMARY_NAICS_CODE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PRIMARY_NAICS_DESCRIPTION (type: esriFieldTypeString, alias: PRIMARY_NAICS_DESCRIPTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Rent___Lease_Expense (type: esriFieldTypeString, alias: Rent___Lease_Expense, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Package_Container_Expense (type: esriFieldTypeString, alias: Package_Container_Expense, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Within_0_5_Miles (type: esriFieldTypeInteger, alias: Within_0_5_Miles, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Within_1_Mile (type: esriFieldTypeInteger, alias: Within_1_Mile, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SIC2 (type: esriFieldTypeInteger, alias: SIC2, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SIC2_Definition (type: esriFieldTypeString, alias: SIC2_Definition, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Industry_Filter (type: esriFieldTypeInteger, alias: Industry_Filter, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• OBJECTID_12 (type: esriFieldTypeInteger, alias: OBJECTID_12, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• STCOFIPS (type: esriFieldTypeInteger, alias: STCOFIPS, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• GNIS (type: esriFieldTypeInteger, alias: GNIS, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• NAMELSAD (type: esriFieldTypeString, alias: NAMELSAD, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• JURISTYPE (type: esriFieldTypeString, alias: JURISTYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• TotalSales (type: esriFieldTypeDouble, alias: TotalSales, SQL Type: sqlTypeOther, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/21/2021 3:14:44 PM

Schema Last Edit Date: 7/21/2021 3:14:44 PM

Data Last Edit Date: 7/21/2021 3:14:44 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat