Name: Regional_Cleanup_Reporter
Display Field: objectid
Type: Feature Layer
Geometry Type: esriGeometryPoint
Has Views: true
Source Schema Changes Allowed: true
Views
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":"Regional Cleanup Reporter","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:
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)
- logo (type: esriFieldTypeString, alias: logo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- welcome_message (type: esriFieldTypeString, alias: Welcome to Metro's reporting survey for the regional cleanup funds., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- reporting_type (type: esriFieldTypeString, alias: Please select which type of information you're providing us with today., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Quarterly summary report: Quarterly summary report], [Success stories or event information: Success stories or event information])
- organization (type: esriFieldTypeString, alias: Select your organization from the list below, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City of Beaverton: City of Beaverton], [City of Gresham: City of Gresham], [City of Hillsboro: City of Hillsboro], ... 10 more ...)
- submitter_name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- phone_number (type: esriFieldTypeString, alias: Phone number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- quarter_reported (type: esriFieldTypeString, alias: Quarter reporting, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q6: Jan 15, 2024 (activities Oct 1- Dec 31)], [Q7: Apr 15, 2024 (activities Jan 1 - Mar 31)], [Q8: July 15, 2024 (activities Apr 1 - Jun 30)], ... 6 more ...)
- total_money_spent (type: esriFieldTypeInteger, alias: Funds spent this quarter, SQL Type: sqlTypeOther, nullable: true, editable: true)
- total_waste_tons (type: esriFieldTypeDouble, alias: Tons of waste or recycling collected (1 ton = 2,000 pounds), SQL Type: sqlTypeOther, nullable: true, editable: true)
- clean_up_numbers (type: esriFieldTypeInteger, alias: Number of cleanups, if any, SQL Type: sqlTypeOther, nullable: true, editable: true)
- graffiti (type: esriFieldTypeInteger, alias: Number of graffiti abatement sites cleaned, SQL Type: sqlTypeOther, nullable: true, editable: true)
- bulky_waste_events (type: esriFieldTypeInteger, alias: Number of bulky waste events held, SQL Type: sqlTypeOther, nullable: true, editable: true)
- bulky_waste_mfr_out (type: esriFieldTypeInteger, alias: Number of multifamily bulky waste vouchers redeemed, SQL Type: sqlTypeOther, nullable: true, editable: true)
- bulky_waste_mfr_in (type: esriFieldTypeInteger, alias: Number of multifamily bulky waste vouchers issued, SQL Type: sqlTypeOther, nullable: true, editable: true)
- bulky_waste_curbside_out (type: esriFieldTypeInteger, alias: Number of single family/curbside bulky waste vouchers redeemed, SQL Type: sqlTypeOther, nullable: true, editable: true)
- bulky_waste_curbside_in (type: esriFieldTypeInteger, alias: Number of single family/curbside bulky waste vouchers issued, SQL Type: sqlTypeOther, nullable: true, editable: true)
- rvs (type: esriFieldTypeInteger, alias: Number of abandoned RVs properly disposed, SQL Type: sqlTypeOther, nullable: true, editable: true)
- surveylang (type: esriFieldTypeString, alias: surveylang, 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)
- instructions (type: esriFieldTypeString, alias: This form is used to track funds and metrics for projects your organization has completed in the previous quarter. This report should be completed only once per quarter and no more than two weeks after the close of the previous quarter. For example, information for the second reporting period would include all reportable data occurring between September 1, 2022 and December 31, 2022. The submission should occur no later than January 15, 2023.
**Data fields are specific to each fund recipient. If there are types of work your organization is completing that is not captured in your customized reporting form, please contact us., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- graffiti_sites (type: esriFieldTypeInteger, alias: Number of graffiti assets cleaned, SQL Type: sqlTypeOther, nullable: true, editable: true)
- open_ended (type: esriFieldTypeString, alias: Is there anything else you would like to share with us?, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- tons_description (type: esriFieldTypeString, alias: Describe the projects related to this tonnage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- org_type (type: esriFieldTypeString, alias: Organization Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/23/2024 11:16:02 PM
Schema Last Edit Date: 7/23/2024 11:16:02 PM
Data Last Edit Date: 7/23/2024 11:16:02 PM
Supported Operations:
Add Features
Apply Edits
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat