Name: CasesReports

Display Field: RespondentName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: CasesReports

Copyright Text:

Min. Scale: 320512

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 7528248.8894604
YMin: 591423.722568935
XMax: 7743109.8214804
YMax: 731691.986469618
Spatial Reference: 2913 (2913)

Drawing Info:

{"renderer":{"type":"uniqueValue","valueExpression":"if ($feature.CaseType == \"Report\" && $feature.ReportStatus == \"Received\")\nreturn \"Received\"\nelse if (($feature.SiteStatus == \"Dirty\" || $feature.SiteStatus == \"On Hold\")&& $feature.Disposition == \"Open\")\nreturn \"Pending\"\nelse if ($feature.SiteStatus == \"Cleaned Up\")\nreturn \"Cleaned\"\nelse if ($feature.SiteStatus == \"UTL\")\nreturn \"UTL\"\nelse\nreturn \"Referred\"","valueExpressionTitle":"Status","defaultSymbol":null,"uniqueValueInfos":[{"value":"Cleaned","symbol":{"color":[77,175,74,196],"size":9.75,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,115,76,255],"width":0.375,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Cleaned"},{"value":"UTL","symbol":{"color":[152,78,163,255],"size":10.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[76,0,115,64],"width":0.375,"type":"esriSLS","style":"esriSLSSolid"}},"label":"UTL"},{"value":"Pending","symbol":{"color":[255,127,0,206],"size":10.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[230,76,0,255],"width":0.375,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Pending"},{"value":"Referred","symbol":{"color":[207,62,60,203],"size":10.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[168,0,0,255],"width":0.375,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Referred"},{"value":"Received","symbol":{"color":[51,126,184,183],"size":10.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,77,168,64],"width":0.375,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Received"}]},"transparency":0}

HasZ: false

HasM: false

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)
• CaseNumber (type: esriFieldTypeString, alias: Case Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DateReceived (type: esriFieldTypeDate, alias: Date Report Received, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Portland: Portland], [Aloha: Aloha], [Beaverton: Beaverton], ... 23 more ...)
• IncidentDescription (type: esriFieldTypeString, alias: Incident Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SiteStatusDate (type: esriFieldTypeDate, alias: Site Status Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DispositionDate (type: esriFieldTypeDate, alias: Disposition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TagNumber (type: esriFieldTypeString, alias: Tag Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• TagIssuedDate (type: esriFieldTypeDate, alias: Tag Issued Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• SiteStatus (type: esriFieldTypeString, alias: Site Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Dirty: Dirty], [On Hold: On Hold], [UTL: UTL], ... 3 more ...)
• Disposition (type: esriFieldTypeString, alias: Disposition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Open: Open], [Closed: Closed], [Suspended: Suspended], ... 6 more ...)
• CaseType (type: esriFieldTypeString, alias: Case Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Dump: Dump], [Camp: Camp], [Metro Bag: Metro Bag], ... 4 more ...)
• IsActive (type: esriFieldTypeString, alias: Is Record Active, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• ReportedMethod (type: esriFieldTypeString, alias: Reported By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Metro Website: Metro Website], [RIC: RIC], [Phone: Phone], ... 3 more ...)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Clackamas: Clackamas], [Clark: Clark], [Columbia: Columbia], ... 6 more ...)
• LocationDetails (type: esriFieldTypeString, alias: Location Details, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• ReferredToAgency (type: esriFieldTypeString, alias: Referred To Agency, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Clackamas County: Clackamas County], [DEQ: DEQ], [Multnomah County: Multnomah County], ... 7 more ...)
• ReportID (type: esriFieldTypeString, alias: Report ID, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
• ReportStatus (type: esriFieldTypeString, alias: Report Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Approved: Approved], [Received: Received], [Rejected: Rejected])

Templates:

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

Attributes:

Relationships:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/18/2025 9:30:25 AM

Schema Last Edit Date: 4/18/2025 9:30:25 AM

Data Last Edit Date: 4/18/2025 9:30:25 AM

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