All Layers and Tables (CitizenProblems_21

Layers:

Layer: Citizen Problems (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"color":[77,77,77,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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: [Abandoned Vehicle: Abandoned Vehicle], [Abandoned Shopping Cart: Abandoned Shopping Cart], [Homelessness: Homelessness], ... 11 more ...)
probtype (type: esriFieldTypeString, alias: Type of Problem, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Public Property (City maintained): Public Property (City maintained)])
details (type: esriFieldTypeString, alias: Details about the problem, 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], [None: None])
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: [Facilities: Facilities], [Fire: Fire], [Recreation & Parks: Recreation & Parks], ... 9 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)

Templates:

category: Graffiti
publicview: Yes
userid: None
status: Submitted

Relationships:

Comments (0) -- Related To: Comments (1)
Surveys (1) -- Related To: Surveys (2)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

Comments (1)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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:

publicview: Yes

Relationships:

CitizenProblems (0) -- Related To: Citizen Problems (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Surveys (2)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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:

Relationships:

CitizenProblems (1) -- Related To: Citizen Problems (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: