View In:   ArcGIS Online Map Viewer

Name: Grocery Stores

Display Field: Common_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Stores selling groceries, identified by City planning staff through Cty records, SNAP provider lists, site visits, internet searches, and phonebook research. Categorized into "full service" (which sell fresh meat, fresh fruits and vegetables, frozen foods, boxed and canned goods, and dairy products), "partial service" (which do not sell all of the food types found in a full service grocery store), "membership full service" (which requires a membership fee in order to shop there), "pharmacy" (drug stores offering a small amount of grocery items), "convenience stores" (offering a small amount of grocery items), and "gas stations" (which have a very limited selection of grocery items). Data valid as of April, 2020.

Copyright Text: City of Gaithersburg

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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: false

Supports Datum Transformation: true

Extent:

XMin: 1229547.9146080613
YMin: 518815.7132765651
XMax: 1271651.2667528838
YMax: 559709.9723671377
Spatial Reference: 2893  (2893)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Grocery_Type
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: full
  Label: Full Service Grocery Store
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [215, 48, 39, 255]
  Size: 6.5
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: limited
  Label: Limited Service Grocery Store
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [252, 141, 89, 255]
  Size: 6.5
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: membership
  Label: Membership Full Service Grocery Store
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [254, 224, 144, 255]
  Size: 6.5
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: convenience
  Label: Convenience Store
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [69, 117, 180, 255]
  Size: 6.5
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: pharmacy
  Label: Pharmacy/Drug Store
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [145, 191, 219, 255]
  Size: 6.5
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: gas
  Label: Gas Station Store
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [224, 243, 248, 255]
  Size: 6.5
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Grocery_Type

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 20, defaultValue: GAITHERSBURG, modelName: City )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 2, defaultValue: MD, modelName: State )
• Zip_Code ( type: esriFieldTypeString, alias: Zip Code, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Zip_Code )
• Full_Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Full_Address )
• Common_Name ( type: esriFieldTypeString, alias: Store Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Common_Name )
• Grocery_Notes ( type: esriFieldTypeString, alias: Store Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Grocery_Notes )
• Grocery_Type ( type: esriFieldTypeString, alias: Store Type, editable: true, nullable: true, length: 50, defaultValue: unknown, modelName: Grocery_Type , Coded Values: [unknown: Unknown / Not Coded] , [full: Full Service Grocery Store] , [limited: Limited Service Grocery Store] , ...4 more... )
• Restricted_Hours ( type: esriFieldTypeString, alias: Restricted Hours, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Restricted_Hours )
• Restricted_Days ( type: esriFieldTypeString, alias: Restricted Days, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Restricted_Days )
• Restriction_Notes ( type: esriFieldTypeString, alias: Restricted to, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Restriction_Notes )
• Phone ( type: esriFieldTypeString, alias: Phone, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Phone )
• Phone_Number ( type: esriFieldTypeDouble, alias: Phone_Number, editable: true, nullable: true, defaultValue: null, modelName: Phone_Number )
• Active ( type: esriFieldTypeString, alias: Active, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Active )

Types:

ID: full
Name: full
Domains:
• Grocery_Type:
  Inherited
• Muni:
  Inherited
Templates:
• Name: Full Service Grocery Store
  Description:
  Prototype:
  Active: null
  City: GAITHERSBURG
  Grocery_Notes: null
  State: MD
  Zip_Code: null
  Full_Address: null
  Common_Name: null
  Grocery_Type: full
  Restricted_Hours: null
  Restricted_Days: null
  Restriction_Notes: null
  Phone: null
  Phone_Number: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: limited
Name: limited
Domains:
• Grocery_Type:
  Inherited
• Muni:
  Inherited
Templates:
• Name: Limited Service Grocery Store
  Description:
  Prototype:
  Active: null
  City: GAITHERSBURG
  Grocery_Notes: null
  State: MD
  Zip_Code: null
  Full_Address: null
  Common_Name: null
  Grocery_Type: limited
  Restricted_Hours: null
  Restricted_Days: null
  Restriction_Notes: null
  Phone: null
  Phone_Number: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: membership
Name: membership
Domains:
• Grocery_Type:
  Inherited
• Muni:
  Inherited
Templates:
• Name: Membership Full Service Grocery Store
  Description:
  Prototype:
  Active: null
  City: GAITHERSBURG
  Grocery_Notes: null
  State: MD
  Zip_Code: null
  Full_Address: null
  Common_Name: null
  Grocery_Type: membership
  Restricted_Hours: null
  Restricted_Days: null
  Restriction_Notes: null
  Phone: null
  Phone_Number: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: convenience
Name: convenience
Domains:
• Grocery_Type:
  Inherited
• Muni:
  Inherited
Templates:
• Name: Convenience Store
  Description:
  Prototype:
  Active: null
  City: GAITHERSBURG
  Grocery_Notes: null
  State: MD
  Zip_Code: null
  Full_Address: null
  Common_Name: null
  Grocery_Type: convenience
  Restricted_Hours: null
  Restricted_Days: null
  Restriction_Notes: null
  Phone: null
  Phone_Number: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: pharmacy
Name: pharmacy
Domains:
• Grocery_Type:
  Inherited
• Muni:
  Inherited
Templates:
• Name: Pharmacy/Drug Store
  Description:
  Prototype:
  Active: null
  City: GAITHERSBURG
  Grocery_Notes: null
  State: MD
  Zip_Code: null
  Full_Address: null
  Common_Name: null
  Grocery_Type: pharmacy
  Restricted_Hours: null
  Restricted_Days: null
  Restriction_Notes: null
  Phone: null
  Phone_Number: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: gas
Name: gas
Domains:
• Grocery_Type:
  Inherited
• Muni:
  Inherited
Templates:
• Name: Gas Station Store
  Description:
  Prototype:
  Active: null
  City: GAITHERSBURG
  Grocery_Notes: null
  State: MD
  Zip_Code: null
  Full_Address: null
  Common_Name: null
  Grocery_Type: gas
  Restricted_Hours: null
  Restricted_Days: null
  Restriction_Notes: null
  Phone: null
  Phone_Number: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata