Name: Food Rescue Donations

Display Field: OBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -179.999995508415
YMin: -88.9999999216112
XMax: 179.999995508415
YMax: 88.9999999216112
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[66,137,117,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Time Info:

Start Time Field: date_available
End Time Field: null
Track ID Field: null
Time Extent
[12/11/2023 11:07:00 PM UTC, 10/18/2024 4:33:41 PM UTC]

Time Reference: UTC
Time Interval: 0
Time Interval Units:
Has Live Data: false
Export Options:

Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

Has Attachments: true

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: sqlTypeOther, length: 38, nullable: false, editable: false)
• donator_name (type: esriFieldTypeString, alias: Company Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donator_type (type: esriFieldTypeString, alias: Business Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Restaurant: Restaurant], [Grocery: Grocery], [Caterer: Caterer], ... 3 more ...)
• food_purpose (type: esriFieldTypeString, alias: Food Purpose, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Human: Human Consumption], [Animal: Animal Consumption])
• weight (type: esriFieldTypeSmallInteger, alias: Donation Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• date_available (type: esriFieldTypeDate, alias: Available Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• date_expire (type: esriFieldTypeDate, alias: Donation Expiration, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Donation Status, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Available: Available], [Claimed: Claimed], [Part: Partially Claimed])
• food_Proteins (type: esriFieldTypeString, alias: Cooked (Cooled) Meats/Proteins, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• food_Veggies (type: esriFieldTypeString, alias: Cooked (Cooled) Vegetables/Startches, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• food_Soups (type: esriFieldTypeString, alias: Soups (Cooled or Frozen), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• food_Deli (type: esriFieldTypeString, alias: Deli (Protein, Cheese, Pasta, Veggies, Fruit Salads, Sandwiches), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• food_Dairy (type: esriFieldTypeString, alias: Dairy Products (within 7 day "use by" window after sell date), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• food_Produce (type: esriFieldTypeString, alias: Produce (fresh or safe for consumption, minor damage/defects), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• food_Desserts (type: esriFieldTypeString, alias: Desserts or Pastries (Whole, uncut cakes/pies), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• food_Frozen (type: esriFieldTypeString, alias: Frozen Items, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• food_Shelf (type: esriFieldTypeString, alias: Shelf-stable Items (canned goods, dried goods), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• equip_Cold (type: esriFieldTypeString, alias: Cold (Temperature Holding), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• equip_Frozen (type: esriFieldTypeString, alias: Frozen (Temperature Holding), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• equip_Serving (type: esriFieldTypeString, alias: Serving Area (Meal Service), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• equip_Repackaging (type: esriFieldTypeString, alias: Repackaging Area and Supplies, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• equip_ForkLift (type: esriFieldTypeString, alias: Fork Lift, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• equip_Dolly (type: esriFieldTypeString, alias: Dolly(s), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• equip_Cart (type: esriFieldTypeString, alias: Cart(s), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• equip_Coolers (type: esriFieldTypeString, alias: Coolers, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• equip_Lift50 (type: esriFieldTypeString, alias: Volunteers/Staff that can lift 50+ lbs, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• equip_Lift (type: esriFieldTypeString, alias: Volunteers/Staff that can lift <50 lbs, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• date_claimed (type: esriFieldTypeDate, alias: Claimed Date and Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• claimed_by (type: esriFieldTypeString, alias: Food Rescuer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• claimed_volunteer (type: esriFieldTypeString, alias: Volunteer Request, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• donator_transport (type: esriFieldTypeString, alias: Transportation Method, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Pickup: Pickup], [Delivery: Delivery], [Both: Both])
• claimed_transport (type: esriFieldTypeString, alias: Preferred Transportation Method, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Pickup: Pickup], [Delivery: Delivery], [Both: Both])
• volunteer_Driver (type: esriFieldTypeString, alias: Driver, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• volunteer_Vehicle_Cold (type: esriFieldTypeString, alias: Vehicle (Cold Storage), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• volunteer_Vehicle_Hot (type: esriFieldTypeString, alias: Vehicle (Hot Storage), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• volunteer_Vehicle (type: esriFieldTypeString, alias: Vehicle (Other), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• volunteer_Repackaging (type: esriFieldTypeString, alias: Repackaging, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• volunteer_Loading (type: esriFieldTypeString, alias: Load Vehicle, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• volunteer_Unloading (type: esriFieldTypeString, alias: Unload Vehicle, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• volunteer_Lift_50 (type: esriFieldTypeString, alias: Lift 50lbs+, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• volunteer_Lift (type: esriFieldTypeString, alias: Life >50lbs, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• date_complete (type: esriFieldTypeDate, alias: Delivered or Picked Up Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ID_Donator (type: esriFieldTypeGUID, alias: Donator ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ID_Rescuer (type: esriFieldTypeGUID, alias: Rescuer ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• donator_email (type: esriFieldTypeString, alias: Donator Contact Email, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• donator_phone (type: esriFieldTypeString, alias: Donator Contact Phone, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• claimed_by_email (type: esriFieldTypeString, alias: Food Rescuer Contact Email, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• claimed_by_phone (type: esriFieldTypeString, alias: Food Rescuer Contact Phone, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• donator_note (type: esriFieldTypeString, alias: Donator Donation Notes, SQL Type: sqlTypeOther, length: 1500, nullable: true, editable: true)
• claimed_by_notes (type: esriFieldTypeString, alias: Food Rescuer Claim Notes, SQL Type: sqlTypeOther, length: 1500, nullable: true, editable: true)
• donation_address (type: esriFieldTypeString, alias: Donation Address, SQL Type: sqlTypeOther, length: 1500, nullable: true, editable: true)
• claimed_by_address (type: esriFieldTypeString, alias: Rescuer Address, SQL Type: sqlTypeOther, length: 1500, nullable: true, editable: true)
• donation_size (type: esriFieldTypeString, alias: Donation Size, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)

Templates:

Name: Food Rescue Donations
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Relationships:

• Rescuers (0) -- Related To: Food Rescuers (3)
• Donators (1) -- Related To: Food Rescue Donators (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/21/2025 5:54:35 PM

Schema Last Edit Date: 1/27/2025 10:33:57 PM

Data Last Edit Date: 4/21/2025 5:54:35 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat