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":"d17c3dcd-7354-471a-a747-9976b83a13b0","width":20.25,"height":20.25,"imageData":"iVBORw0KGgoAAAANSUhEUgAAAGwAAABsCAMAAAC4uKf/AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAEsUExURQAAAADY/wDJ/wDR/wDK/wDM/wDO/wDN/wDN/wDO/wDL/wDL/wDN/wDM/wDN/wDM/wDM/wDN/wDN/wDL/wDM/wDM/wDM/wDN/wDM/wDL/wDM/wDM/wDM/wDL/wDM/wDM/wDN/wDM/wDM/wDM/wDM/wDM/wDM/wDM/wDM/wDM/wDM/wjO/xDP/xPQ/xXQ/xbQ/xfR/x7S/yDS/yHT/yTT/ynU/yrU/y3V/zDW/zrY/0DZ/1Dc/1je/13f/17f/2Df/23i/3Di/4Dl/4Tm/4Xn/4fn/4vo/4zo/43o/4/p/5Dp/5jq/5zr/5/s/63v/6/v/7Pw/7/y/8Xz/8/1/9L2/9T2/9X3/9z4/974/9/5/+L5/+b6/+v7/+z7/+/8//D8//f9//j+//n+/////8zBsOkAAAAqdFJOUwANExYYHh8kPT5FU1dqa219hYmOkZaXqKqrtbi6vL3DxdLf6+zw8fT5/XOSwkIAAAAJcEhZcwAAFxEAABcRAcom8z8AAAccSURBVGhDvZppX9NMEMDjgQcIguAFolwK1njhVVIRyqFUKRjAo4pRnn7/7/DMzM4mm+zkbH/9vwjtdGeH3czOzh5OGYaGx6Zm5uYXllZWlhbm52amxoaH+Kf+cmV8drkmsDw7foWL9Ifzo9OiIc3y9Oh5LtorI3e4zkzujnDxHrgwsci1AU/XNnYPjk5+np6dnXZOjg52N9ae8k/A4sQFVqrGpcnHXFPt5fr+j67Aj/31l1yk9njyEiuW5+JNrqT2bvs71y3yfecdF6zdvMjKJbn+SOk/2zziSjM42nymSj+6zupluPpAKb/6zNXl8vmV0nhwlasozA2l+PYL11SIL2+V1g2upBiX75PSk09cS2H2npDi/ctcUQGuPSSV9V9cRQl+fSDVh9e4qlwmqPzrr6xfkq+vSX2CK8vhFhV+/5eVS/P3PVVwi6vL5DYV/cialfhIVdzmCtM5dw/LvfBZrSL+C6zl3jmuNA2y9eYbK4kEfqvtB/wlhW9vyBpXmgL14dpvVhEImi4WqdUabZbI/F7DQpk9Sb7x/B8r2ISmkHqHpSL/nmOZDC8hn1/LsNXAAhGHLBf5R21LHQHX8Nc36X2YtFWrHXeDVtPzGluSQ/2m95Yyui9j3HiR4RtbqBzDbehudYVX+A198qEcuSgeZvh8x3hfAsIr9FF+n6uPQXHeGsuB36y7tdVGs9NtYoEM3GPWiaDRLcwBV1H+nguF+HUUE152wwDXHnwUuez5DefK14l4GGxg2eJ4rBfxF6PyAzYRch0LJ+K87X152G/8K4oTmcJFzDc+cAFN3kuyabCmwTqIH8WzIMyjniTmykPSL4XLqga/cO6+yWaIS1hyj3/WeCgsiTByPqHczCcn4ftb/lFzjIXKIkVnzIIm2RBwAfPeZB5lx4sCtFjZ5AvIH0eZOQbgV/xTSGlXRAQP6XYxn4wCMq4drFx0lbTLIs07n0G+yKacEfjyjH+IqGZMClpdzMz1iuoufN5keUQVZ0QEa5sgvqNsncci9tqh/JBmVrmCiCMUq7XpKHx6x2KDSt5IbHENEbiiGiVj0/Bph6UGASlWwnKSbRBOkzFcm0trvZIh38Bq2ncQLqOtK/DhJQtjdEixCnaIxJUw7mCMw991lhkEWxV9H/GSHYmxfxyMzcLffZaFxBLEKjS5ImYfRLP8ypL7AEGUDVQlPmv/AAm8tCH485RFmuMeejAkbg33S4acYXiusYTp9MNWYrrB9HjYGYPnBkuY6j4fI+aTWOeYMwXPXZYoKLXsB2bTduH7lDMDzwOWKKpGYAtzcjuA7zPOHDxjUbhCnpOC2Y8Yi+eceXiesISoHoAtjAz5BL7OOwvwjI33/rgiYeRaP+HrgrMEz1OWED2GDhOjEafwdclZgecZSwgq1hfMd3YG31fI2H8sQXqYxpKY3qiMYTf+YQnRv240k0jVjZaD9B6DGc9cruHkuGC7fuVEJ0E8y1Ku39ugbrRSR0o8N1CD2gpXxTzEo6CGC9tDsd/dVnzNq8KVHYjTQsiWr3vYbbQDMsYu0Dlstw9jTawnM1UViO0pJpB7pg7/aps+YEXU2aZvt1DgKleuJ5oFqClGmDzFlZlLsQf/Dxqr1DAjHPlkpo2N9IVsnydPKS0QfMRV+1TUNJinkg1rkS17tyBEpQViwmNZY1vKe6DX4w07Vms51XgRTnjkVM5KeXRqhlZc1dG6YTrt0/+QhE7lUpLU5ADiqshVA3oqQaALZtkKk9TU9NtvbXirXqOprVLjqIN98hP0uCAcZZazx9Dpd+rCIkT/76tQH700emMYIcKtreQYThAuLGjJtM3SFHicY7gLJwXf2EXzMpvV7e5AGbVkSlkMxtAOcxgaqwdhxPbSvZCJFoMpy9wEnLm2dGs8/Sq9LMdQGMtcBw9Q7QV8EhrP0JXqj6aAKbWAv6tspWxNWBwn7AA5fqExtybkTReb5ILD3ShkKr7pIm8nCcS3pDNHsUl8O0ncKJMw1xwZkTBOYqNM3AIUMSbWoraSW4Bqc7PIAWc0sWZMJ3H2sHTssFzathWhCRkp+sLsbVu1IS3EfoswHSrai3jgmtiQFrfaRbRDFmyZtNUuHyJI6HAl7QbbyIcIKccjNtpDihlLOR5JOfix0MakrWeLtIOf/CMthX5nRYylH2nlH9YRqI/YO5gWWYd1uceQBJZB8o1lHkPmH7AC4SZkrrGcA9b8o2PDWGKPzyL36LjAoXi4DjAXFQIFDsXzj/vDsG9vzZoUOu7Pu8hgpAZZ/VjwIkPOFQ3jNMg+KwgpekUDyLp8ErRCUvPSMpdPBnutJrww9KHKhSFcr5S5MBRdhUoeg+byqfxVKGCAl7yAQV5fAwZ4MQ8wrhzuZF853O75yiEwwMuUiHRNtIPXRH/2/ZooMYIHsLnc6cMFWGKAV3sVA7u0rOntOrbj/A9ge/u1Vd0WGwAAAABJRU5ErkJggg==","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: Land Use
• Survey_Questions: LU_Poor_Access

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