Name: Farms_Product_Survey

Display Field: Food_Item

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: 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)
• Food_Item (type: esriFieldTypeString, alias: Food_Item, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Apples: Apples], [Arugula: Arugula], [Beets: Beets], ... 24 more ...)
• Brand_Variety (type: esriFieldTypeString, alias: Brand_Variety, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Signature: Signature Select], [Food Lion: Food Lion], [Kellog: Kellog], ... 6 more ...)
• Desired_Amount (type: esriFieldTypeString, alias: Desired_Amount, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [(4) 8 oz: (4) 8 oz], [(7) 12 oz cans: (7) 12 oz cans], [.02 oz: .02 oz], ... 58 more ...)
• Item_Weight (type: esriFieldTypeString, alias: Item_Weight, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Price (type: esriFieldTypeString, alias: Price, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Price_Per_Unit (type: esriFieldTypeString, alias: Price_Per_Unit, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Unit_Actual (type: esriFieldTypeString, alias: Unit_Actual, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [per pint: per pint], [per quart: per quart], [per oz: per oz], ... 5 more ...)
• Unit_Expected (type: esriFieldTypeString, alias: Unit_Expected, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [per doz: per doz], [per fl oz: per fl oz], [per head: per head], ... 6 more ...)
• Weight_Ratio (type: esriFieldTypeString, alias: Weight_Ratio, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [0.02: 0.02], [0.03: 0.03], [0.05: 0.05], ... 51 more ...)
• Price_Per_WR (type: esriFieldTypeString, alias: Price_Per_WR, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Confidence (type: esriFieldTypeString, alias: Confidence, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• Present (type: esriFieldTypeString, alias: Present?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• Brand_text (type: esriFieldTypeString, alias: Specify Other, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Unit_Match (type: esriFieldTypeString, alias: Do the Units Match?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Unit_Ratio (type: esriFieldTypeString, alias: Unit Ratio, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• FarmID (type: esriFieldTypeGUID, alias: FarmID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• Product_Other (type: esriFieldTypeString, alias: Specify Other, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• Quantity (type: esriFieldTypeString, alias: Quantity (if necessary), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Quantity_ (type: esriFieldTypeString, alias: Quantity (if applicable), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• test_field (type: esriFieldTypeDouble, alias: test_field, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Weight_2 (type: esriFieldTypeString, alias: Weight 2, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Weight_3 (type: esriFieldTypeString, alias: Weight 3, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: Farms_Product_Survey
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• Present: Yes

Relationships:

• Farms_Food_Access_Points (0) -- Related To: Farms_Food_Access_Points (0)
• Product_Types (1) -- Related To: Market_Basket (3)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/5/2026 5:07:17 PM

Schema Last Edit Date: 10/5/2026 5:00:05 PM

Data Last Edit Date: 10/5/2026 5:07:17 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat