Layers:

Layer: Citizen Problems (0)


Name: Citizen Problems

Display Field: pocfullname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text: Esri

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: -9164726.62275833
YMin: -4669284.50972604
XMax: 19510596.4574337
YMax: 7489128.70957667
Spatial Reference: 102100 (3857)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"f949d045-b1aa-4918-82eb-05d142d59ba6","width":20.25,"height":20.25,"imageData":"iVBORw0KGgoAAAANSUhEUgAAAGwAAABsCAMAAAC4uKf/AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAE1UExURQAAAMTYO7zXNrncLrXVK7vVM7XWMbjVMrjVLrnWMbnTMLjUMbzWL7zWMLrUMLvVMbrUL7rVMLrXMLrWMLnUMLrVL7vVMLrVL7vVMbvWMbrVMLnUMLrVMLrUMbnVMLrVL7rVMbrVMLrWMLrVMbnVMLrVMLrVMLrWMLrWMLrVMLnVMLnVMLrVMLzWN77YPb/YQMDYQcDZQsDZQ8LaSMPaSsPaS8TbTcXcUcXcUsbcVMbcVcfdV8reX8rfX8vfZNDicdLjd9PkfNTlftfniNjnidjni9zql97rnN7rneDsoeDsouHtpOHtpePuq+PurOTvr+Xvsenyvenyvuvzwu70y+/10PL32PP42vP42/P43PT43fX54vb65ff66Pj76vr87/r88Pv88vv98/3++P3++f3++v///6mBQ+4AAAAsdFJOUwANExYYHh8kPT5FU1dqa219hYWJjpGWl6ioqqu1uLq8vcPF0t/r7PDx9Pn9NPM0CwAAAAlwSFlzAAAXEQAAFxEByibzPwAABy1JREFUaEO9mvlfEzsQwNcDDxAEBU8Q5VKw1quelSJHC1qRUkt5QpW3yuP//xPezGSym01mr7affn9ou7NJprkmk0m8PAwNj03NzM0vLK2sLC3Mz81MjQ0P8av+cmV8drkgsDw7foWT9Ifzo9OiIs3y9Oh5TtorI/e4zETuj3DyHrgwscilAc9XN3b2Dw47J6enJ53Dg/2djdXn/ApYnLjAmbrj0uRTLqnwen3v+EzgeG/9NScpPJ28xBnzc/EWF1L4sH3EZYscbX/khIVbFzlzTq4/UflfbB5woQkcbL1QqZ9c5+x5uPpIZX7zjYtL5dsblePRVS4iMzdVxvffuaRM7L5XuW5yIdm4/JAyPfvKpWTm6zPK+PAyF5SBa48py/ovLiIHv9Yp6+NrXFQqE5T+7Q/On5Mfbyn7DS4shduU+PMfzpybP5+pgNtcXCJ3KOkXztkVX6iIu1xgPOceYLpXLc7WJa1XWMqDc1xoHKTr3U/OJOG36rVG2p/5+Y60caEx3MU0n35zFhe/UcIUQLXNIpnfnzDRHS5WhMbGy7+cwaVZxgRMlYUyf19imoRRcgPff4rXVcf3IWWf5SJ/qW4TXLTDNXz7Lr4NLV2gDTqwWimX1qpSH/6mfouZ3ZfRbryKHxtNzBulVOQfhVKDUxn8xDH5WLZcZA+Fv+i3VXNV8H08QqO2UP6Qi49Adt6ey36jQn++UpMqFqXY4UwhNLuFNeAqyj9zIk1TD3TA+BlDmXMZkOVy1zdcK99G7aFfxaQ52OCMIX/QKj9iFQHXMXHUzvtrKMuF25A/UGx5ChfR31jnBEzeegHCPMf17UnUC0I/6ll0raShlJMi5zX4hWv3LVZDXMKUlg+QMtJlBJvyFeWmPzkJz+/5JdPGNLmRrDN6QZOsCLiAfu8uv2Mc25QJyWx9B/nT0DNHp+MNv9JsUOa8rHHuCOhPhgYZ9w62L5p/3BNFoW7fQL7IqrwReHjBLwK6Gh+IoA09c72jug+/t1ge0MUsUxTdQbIJ4ntK13lM4uwdUu1uLO5kO0Cx2puOwq+PLA7pYILucO3IB5COkrJp+LXNUgPT3ciJYyK3QThNynBvLuz1upvVRJ2LCDgC4TLqugI/XrPQpBUs+blxew13whjBGIdvy97D8tLqoRVBm+2RoO0fB2Wz8L3HMk27J1VIOdpveyCa5S6z4gA9tGBAKbIAHIMEOm0Ivp6ziGn0QZetDeMlQ94wfK6yRNHsi65CocblEasgGPbG4DPqqHRtFS0irh0uImPeFHzusIRoUMp+YFqSHXie8mbgc58liJ/uH2bFXNz24XnGm4NP0wp3b4AdzLmNtnjOm4fPQ5Yg3a3QMsZ4PITHeW8BPs2e7F8rRsrFRWTBW4LPE5Yg/VTGRSIn8LjkrcDnKUsQStUfzI3GKTyvkLL/WIL0aUYj5qxWyrAZ/2UJ0rMJDiia9ko1oz1A+jcaI8uMGiA49P9hCZLPgCS0Q9QGqqFvT2qfUqaiuhYsez1m+FpbbDWpbXMV247FalhssaaWvCZmaNaqlVI5ar6L9aguNleOIY6rGowtZcrWam1f+bCmpa3RO6bsOKrKELtLjNxr1CxUa+z4DlbMHG5tqmm9sVFZgz/DQgO1xLiLp9iQJRqx5LniX6OKGfNItWqFnwTU4im4BcIORvsvOPrAmFsV86ukS/DyA5RbIDk80Q5AdEPTi5b6Ciqm3T7HNw1hh0d05c7adlNyl9PoqZG11hVr8Th0fEUT7cqJTiqoq6n/Sw2EqKGHj2s0KlVltapCkaZBHNpJjXO/gU4bBnlHV5L6DcsuUp/ipq8V9G7FNHku2v2O21iE6DbFAUDDEKsH60eoqpxYLWNjEbdlMtEucjMcOjUegkDJNhcO4ZYJN4MfWBqHjmPVg4hFEJl2LJMAHq+pzaC8zbVhLbYHm0WVuc318AB1k+XxtAXznknV2dkWJL2vdMmhCRffXryKG5lURUMTYtBFwNImxVdEIkEXMZwkQSZRY233EoiGkyhQluXA0YhBRrdfSexCaiNQJoUAZcL1IMHqWlghQDG4KRKEYrJXzAluSmFbGT3+hbC6jBu2FQPSIjp+llmZEJCWQu0i2kEp8XMaUqhdPESQ0LZRiHNLyIcI8vGIS05lMccj8sGPg15isimLO/iJP9KKEARY+TmR+COt1MM6InCEMsyzpMO61GNIJDAh6coSjyH5UkHCASuQXZk6YE24YpB2dGzEmhK8XyL16JgvFiQdigeLTJJLCqhD8ZTrBcnH/X7oKAsnnAaZjvtTLjKYZ2pJVct4kYGvF8TN7npNk+TqqCsaiRcLNIO8fMJXDHq9VhN7qcBmkBeGBnsVCtCXvKzDyWS+d3XJCxjk9TUguJi3leVi3mYvF/OA8Mrhx7Qrh3hARnR75RAY4GVKZIDXRIkRPIBN5V4fLsASA7zaqxjYpWVNb9exPe9/YDNWrID06y0AAAAASUVORK5CYII=","contentType":"image/png"}},"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)
• probid (type: esriFieldTypeString, alias: Problem ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• category (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Animal: Animal], [Blight: Blight], [Health: Health], ... 6 more ...)
• probtype (type: esriFieldTypeString, alias: Type of Problem, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• details (type: esriFieldTypeString, alias: Comments (Please explain), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• pocfullname (type: esriFieldTypeString, alias: Full Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• pocfirstname (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• poclastname (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• pocphone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• pocemail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• locdesc (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• publicview (type: esriFieldTypeString, alias: Visible to the public, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• userid (type: esriFieldTypeString, alias: User Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• numvotes (type: esriFieldTypeInteger, alias: Number of Votes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Submitted: Submitted], [Received: Received], [In Progress: In Progress], ... 1 more ...)
• assignedto (type: esriFieldTypeString, alias: Assigned To, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Animal Control: Animal Control], [Facilities: Facilities], [Fire: Fire], ... 8 more ...)
• resolution (type: esriFieldTypeString, alias: Resolution, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• resolutiondt (type: esriFieldTypeDate, alias: Resolved On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• emailstatus (type: esriFieldTypeString, alias: Email Status, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: Submitted On, 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)
• Survey_Theme (type: esriFieldTypeString, alias: Survey Theme, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Land Use: Land Use], [Open Space: Open Space], [Visioning: Visioning])
• Survey_Questions (type: esriFieldTypeString, alias: Survey Questions, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Vision_Heart: Vision_Heart], [Vision_Problem: Vision_Problem], [LU_Character_Changing: LU_Character_Changing], ... 8 more ...)

Templates:

Name: Problem Report
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• publicview: Yes
• status: Submitted
• Survey_Theme: Open Space
• Survey_Questions: OS_Visit_Regularly

Relationships:
• Comments (0) -- Related To: Comments (1)
• Surveys (1) -- Related To: Surveys (2)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/9/2023 3:56:16 PM

Schema Last Edit Date: 2/9/2023 3:56:16 PM

Data Last Edit Date: 2/9/2023 3:56:16 PM

Tables:

Comments (1)


Name: Comments

Display Field: pocfullname

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text: Esri

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)
• probguid (type: esriFieldTypeGUID, alias: Problem GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• pocfullname (type: esriFieldTypeString, alias: Full Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• pocfirstname (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• poclastname (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• pocphone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• pocemail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• publicview (type: esriFieldTypeString, alias: Public View, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• emailstatus (type: esriFieldTypeString, alias: Email Status, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: Submitted On, 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)

Templates:

Name: Comments
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• publicview: Yes

Relationships:
• CitizenProblems (0) -- Related To: Citizen Problems (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/9/2023 3:56:16 PM

Schema Last Edit Date: 2/9/2023 3:56:16 PM

Data Last Edit Date: 2/9/2023 3:56:16 PM

Surveys (2)


Name: Surveys

Display Field: pocfullname

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text: Esri

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

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)
• probguid (type: esriFieldTypeGUID, alias: Problem GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• resquality (type: esriFieldTypeSmallInteger, alias: Resolution Quality, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Very dissatisfied], [2: Somewhat dissatisfied], [3: Neutral], ... 2 more ...)
• restime (type: esriFieldTypeSmallInteger, alias: Resolution Time, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Much longer than expected], [2: Longer than expected], [3: About what I expected], ... 2 more ...)
• service (type: esriFieldTypeSmallInteger, alias: Customer Service, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Very negative], [2: Somewhat negative], [3: Neutral], ... 2 more ...)
• nps (type: esriFieldTypeSmallInteger, alias: Net Promoter Score, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 10])
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• cancontact (type: esriFieldTypeString, alias: Can Contact, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• pocfullname (type: esriFieldTypeString, alias: Full Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• pocfirstname (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• poclastname (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• pocphone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• pocemail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: Submitted On, 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)

Templates:

Name: Surveys
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:


Relationships:
• CitizenProblems (1) -- Related To: Citizen Problems (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/9/2023 3:56:16 PM

Schema Last Edit Date: 2/9/2023 3:56:16 PM

Data Last Edit Date: 2/9/2023 3:56:16 PM