All Layers and Tables (JCGCP_Survey_2

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":{"visualVariables":[{"type":"sizeInfo","valueExpression":"$view.scale","stops":[{"size":11.25,"value":1128.497176},{"size":9,"value":9027.977411},{"size":4.5,"value":72223.819286},{"size":2.25,"value":577790.554289}]}],"type":"simple","symbol":{"color":[0,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":1,"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: [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: 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])
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: [GCP: GCP])
Survey_Questions (type: esriFieldTypeString, alias: Survey Questions, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Q1: Q1], [Q2: Q2], [Q3: Q3], ... 3 more ...)

Templates:

publicview: Yes
status: Submitted
Survey_Questions: Q6

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: