Name: store_visit_observation

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• Visit_Date_Time (type: esriFieldTypeDate, alias: Date and time of visit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Name (type: esriFieldTypeString, alias: Please provide your name or initials., SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Local (type: esriFieldTypeString, alias: Are you a Delmarva local?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [yes: Yes], ... 1 more ...)
• DMV (type: esriFieldTypeString, alias: Are you from Delaware, Maryland or Virginia?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Delaware: Delaware], [Maryland: Maryland], [Virginia: Virginia])
• Allegiance (type: esriFieldTypeInteger, alias: Allegiance – Where do you fall in the great debate? (be honest):, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age (type: esriFieldTypeString, alias: What is your age group?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Under 18: Under 18], [18–24: 18–24], [25–34: 25–34], ... 4 more ...)
• How (type: esriFieldTypeString, alias: How are you completing this survey?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Survey123 App on mobile device: Survey123 App on mobile device], [Survey123 App on laptop/desktop: Survey123 App on laptop/desktop], [Web browser on mobile device: Web browser on mobile device], ... 1 more ...)
• Username (type: esriFieldTypeString, alias: Username, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Purchase (type: esriFieldTypeString, alias: Did you make a purchase, other than fuel, at this location?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [yes: Yes], ... 1 more ...)
• Items_Puchased (type: esriFieldTypeString, alias: Select all of the items purchased:, SQL Type: sqlTypeOther, length: 10000, nullable: true, editable: true)
• Barcode (type: esriFieldTypeString, alias: Scan the barcode of your favorite item from your purchase., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Product_Name (type: esriFieldTypeString, alias: Product name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Product_Brand (type: esriFieldTypeString, alias: Brand:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Product_Category (type: esriFieldTypeString, alias: Category:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Product_Price (type: esriFieldTypeDouble, alias: Price:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Facilities (type: esriFieldTypeString, alias: Did you use the facilities (restroom) at this location?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [yes: Yes], ... 1 more ...)
• hot_prepared_food_selection (type: esriFieldTypeInteger, alias: Hot prepared food selection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• fried_chicken_quality (type: esriFieldTypeInteger, alias: Fried chicken quality, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• cold_prepared_food_selection (type: esriFieldTypeInteger, alias: Cold Prepared Food selection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• hoagie_quality (type: esriFieldTypeInteger, alias: Hoagie quality, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• snack_selection (type: esriFieldTypeInteger, alias: Snack selection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• pre_packaged_drink_selection (type: esriFieldTypeInteger, alias: Pre-packaged drink selection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• coffee_quality (type: esriFieldTypeInteger, alias: Coffee quality, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• specialty_prepared_beverage_sel (type: esriFieldTypeInteger, alias: Specialty Prepared Beverage selection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• specialty_prepared_beverage_qua (type: esriFieldTypeInteger, alias: Specialty Prepared Beverage quality, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• bathroom_cleanliness (type: esriFieldTypeInteger, alias: Bathroom cleanliness, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• speed_of_service (type: esriFieldTypeInteger, alias: Speed of service, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• staff_friendliness (type: esriFieldTypeInteger, alias: Staff friendliness, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• checkout_experience (type: esriFieldTypeInteger, alias: Checkout experience, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• touchscreen_ordering_experience (type: esriFieldTypeInteger, alias: Touchscreen ordering experience, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• overall_store_cleanliness (type: esriFieldTypeInteger, alias: Overall store cleanliness, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• parking_experience (type: esriFieldTypeInteger, alias: Parking experience, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• average (type: esriFieldTypeSingle, alias: Average, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Rank_Preference (type: esriFieldTypeString, alias: Rank what matters most when choosing a store:, SQL Type: sqlTypeOther, length: 10000, nullable: true, editable: true)
• survey_completion_time_in_minut (type: esriFieldTypeDouble, alias: survey_completion_time_in_minut, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Relationships:

• S123_In_Practice___Connect_store_visit_observation (1) -- Related To: S123InPractice (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/14/2026 6:35:04 PM

Schema Last Edit Date: 5/13/2026 2:26:31 AM

Data Last Edit Date: 5/14/2026 6:35:04 PM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat