Name: Business_Grouping_Join

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• Business_Category (type: esriFieldTypeString, alias: Business_Category, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• Business_Category_Grouping (type: esriFieldTypeString, alias: Business_Category_Grouping, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• safegraph_place_id (type: esriFieldTypeString, alias: safegraph_place_id, SQL Type: sqlTypeNVarchar, length: 35, nullable: true, editable: true)
• location_name (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeNVarchar, length: 250, nullable: true, editable: true)
• brands (type: esriFieldTypeString, alias: Brands, SQL Type: sqlTypeNVarchar, length: 250, nullable: true, editable: true)
• sub_category (type: esriFieldTypeString, alias: sub_category, SQL Type: sqlTypeNVarchar, length: 150, nullable: true, editable: true)
• naics_code (type: esriFieldTypeString, alias: NAICS, SQL Type: sqlTypeNVarchar, length: 6, nullable: true, editable: true)
• street_address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeNVarchar, length: 150, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
• region (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeNVarchar, length: 2, nullable: true, editable: true)
• postal_code (type: esriFieldTypeString, alias: postal_code, SQL Type: sqlTypeNVarchar, length: 7, nullable: true, editable: true)
• iso_country_code (type: esriFieldTypeString, alias: iso_country_code, SQL Type: sqlTypeNVarchar, length: 2, nullable: true, editable: true)
• phone_number (type: esriFieldTypeString, alias: phone_number, SQL Type: sqlTypeNVarchar, length: 15, nullable: true, editable: true)
• category_tags (type: esriFieldTypeString, alias: category_tags, SQL Type: sqlTypeNVarchar, length: 150, nullable: true, editable: true)
• raw_visit_counts (type: esriFieldTypeInteger, alias: Visits, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• raw_visitor_counts (type: esriFieldTypeInteger, alias: Unique Visitors, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• visits_by_day (type: esriFieldTypeString, alias: visits_by_day, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Visits4_5_2020 (type: esriFieldTypeInteger, alias: 4/5, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Visits4_6_2020 (type: esriFieldTypeInteger, alias: 4/6, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Visits4_7_2020 (type: esriFieldTypeInteger, alias: 4/7, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Visits4_8_2020 (type: esriFieldTypeInteger, alias: 4/8, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Visits4_9_2020 (type: esriFieldTypeInteger, alias: 4/9, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Visits4_10_2020 (type: esriFieldTypeInteger, alias: 4/10, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Visits4_11_2020 (type: esriFieldTypeInteger, alias: 4/11, SQL Type: sqlTypeInteger, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/20/2020 3:31:56 PM

Schema Last Edit Date: 4/20/2020 3:31:56 PM

Data Last Edit Date: 4/20/2020 3:31:56 PM

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