Layers:

Layer: S123InPractice (0)


Name: S123InPractice

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)


Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"S123 In Practice - Connect","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• Store_Brand (type: esriFieldTypeString, alias: Which store brand are you evaluating today?, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Wawa: Wawa], [Royal Farms: Royal Farms])
• Store_Name (type: esriFieldTypeString, alias: Select the store location from the list., SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Store_URL (type: esriFieldTypeString, alias: Store URL in ArcGIS Online, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Store_Where (type: esriFieldTypeString, alias: Dynamic WHERE clause for pulldata function, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Store_Address (type: esriFieldTypeString, alias: Street Address:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Store_County (type: esriFieldTypeString, alias: County:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Store_State (type: esriFieldTypeString, alias: State:, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Store_X (type: esriFieldTypeString, alias: X (Longitude), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Store_Y (type: esriFieldTypeString, alias: Y (Latitude), SQL Type: sqlTypeOther, length: 255, 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)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:


Relationships:
• S123_In_Practice___Connect_store_visit_observation (1) -- Related To: store_visit_observation (1)
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

Tables:

store_visit_observation (1)


Name: store_visit_observation

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

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