Layers:

Layer: Citizen Problems (0)

Name: Citizen Problems

Display Field: pocfullname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: e0bbbd3147b74591a6a6e9883d062037

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:
XMin: -9587791.89473722
YMin: 4022358.618458298
XMax: -9559572.403821124
YMax: 4038057.369082866
Spatial Reference: 102100  (0)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: status
Field 2: N/A
Field 3: N/A
Field Delimiter: N/A
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Submitted
  Label: Submitted
  Description: N/A
  Symbol:
  
• Value: Received
  Label: Received
  Description: N/A
  Symbol:
  
• Value: In Progress
  Label: In Progress
  Description: N/A
  Symbol:
  
• Value: Completed
  Label: Completed
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
• probid ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Problem ID, type: esriFieldTypeString )
• category ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Category, type: esriFieldTypeString , Coded Values: [Animal: Animal] , [Blight: Blight] , [Health: Health] , ...6 more... )
• probtype ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, isViewOverride: true, alias: Type of Problem , Coded Values: [Hydrant Not Cleared: Hydrant Not Cleared] , [Road Not Cleared: Road Not Cleared] , [Salt or Sand Required: Salt or Sand Required] , ...2 more... )
• details ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Details about the problem, type: esriFieldTypeString )
• pocfullname ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Full Name, type: esriFieldTypeString )
• pocfirstname ( nullable: true, editable: true, defaultValue: null, length: 150, alias: First Name, type: esriFieldTypeString )
• poclastname ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Last Name, type: esriFieldTypeString )
• pocphone ( nullable: true, editable: true, defaultValue: null, length: 12, alias: Phone Number, type: esriFieldTypeString )
• pocemail ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Email, type: esriFieldTypeString )
• locdesc ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Location, type: esriFieldTypeString )
• publicview ( nullable: true, editable: true, defaultValue: Yes, length: 5, alias: Visible to the public, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• userid ( nullable: true, editable: true, defaultValue: null, length: 150, alias: User Name, type: esriFieldTypeString )
• numvotes ( nullable: true, editable: true, defaultValue: null, alias: Number of Votes, type: esriFieldTypeInteger )
• status ( nullable: true, editable: true, defaultValue: Submitted, length: 25, alias: Status, type: esriFieldTypeString , Coded Values: [Submitted: Submitted] , [Received: Received] , [In Progress: In Progress] , ...1 more... )
• assignedto ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Assigned To, type: esriFieldTypeString , Coded Values: [Animal Control: Animal Control] , [Facilities: Facilities] , [Fire: Fire] , ...8 more... )
• resolution ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Resolution, type: esriFieldTypeString )
• resolutiondt ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Resolved On, type: esriFieldTypeDate )
• emailstatus ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Email Status, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Submitted On, type: esriFieldTypeDate )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 128, alias: Creator, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: EditDate, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 128, alias: Editor, type: esriFieldTypeString )
Templates:
• Name: Problem Report
  Description:
  Prototype:
  probtype: null
  pocfullname: null
  pocphone: null
  probid: null
  poclastname: null
  userid: null
  resolution: null
  numvotes: null
  assignedto: null
  pocemail: null
  pocfirstname: null
  emailstatus: null
  details: null
  resolutiondt: null
  locdesc: null
  category: Snow/Ice
  publicview: Yes
  status: Submitted
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

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

Tables:

Table: Comments (1)

Name: Comments

Display Field: pocfullname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: e0bbbd3147b74591a6a6e9883d062037

Copyright Text: Esri

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:
XMin: -9587791.89473722
YMin: 4022358.618458298
XMax: -9559572.403821124
YMax: 4038057.369082866
Spatial Reference: 102100  (0)  LatestVCSWkid(0)



Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
• probguid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: Problem GUID, type: esriFieldTypeGUID )
• comments ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Comments, type: esriFieldTypeString )
• pocfullname ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Full Name, type: esriFieldTypeString )
• pocfirstname ( nullable: true, editable: true, defaultValue: null, length: 150, alias: First Name, type: esriFieldTypeString )
• poclastname ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Last Name, type: esriFieldTypeString )
• pocphone ( nullable: true, editable: true, defaultValue: null, length: 12, type: esriFieldTypeString, isViewOverride: true, alias: Phone )
• pocemail ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Email, type: esriFieldTypeString )
• publicview ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, isViewOverride: true, alias: Public View , Coded Values: [Yes: Yes] , [No: No] )
• emailstatus ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Email Status, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Submitted On, type: esriFieldTypeDate )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 128, alias: Creator, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: EditDate, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 128, alias: Editor, type: esriFieldTypeString )
Templates:
• Name: Comments
  Description:
  Prototype:
  pocfullname: null
  pocemail: null
  comments: null
  pocfirstname: null
  probguid: null
  pocphone: null
  emailstatus: null
  poclastname: null
  publicview: Yes
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Table: Surveys (2)

Name: Surveys

Display Field: pocfullname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: e0bbbd3147b74591a6a6e9883d062037

Copyright Text: Esri

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:
XMin: -9587791.89473722
YMin: 4022358.618458298
XMax: -9559572.403821124
YMax: 4038057.369082866
Spatial Reference: 102100  (0)  LatestVCSWkid(0)



Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
• probguid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: Problem GUID, type: esriFieldTypeGUID )
• resquality ( nullable: true, editable: true, defaultValue: null, alias: Resolution Quality, type: esriFieldTypeSmallInteger , Coded Values: [1: Very dissatisfied] , [2: Somewhat dissatisfied] , [3: Neutral] , ...2 more... )
• restime ( nullable: true, editable: true, defaultValue: null, alias: Resolution Time, type: esriFieldTypeSmallInteger , Coded Values: [1: Much longer than expected] , [2: Longer than expected] , [3: About what I expected] , ...2 more... )
• service ( nullable: true, editable: true, defaultValue: null, alias: Customer Service, type: esriFieldTypeSmallInteger , Coded Values: [1: Very negative] , [2: Somewhat negative] , [3: Neutral] , ...2 more... )
• nps ( nullable: true, editable: true, defaultValue: null, alias: Net Promoter Score, type: esriFieldTypeSmallInteger , Range: [0, 10] )
• comments ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Comments, type: esriFieldTypeString )
• cancontact ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Can Contact, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• pocfullname ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Full Name, type: esriFieldTypeString )
• pocfirstname ( nullable: true, editable: true, defaultValue: null, length: 150, alias: First Name, type: esriFieldTypeString )
• poclastname ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Last Name, type: esriFieldTypeString )
• pocphone ( nullable: true, editable: true, defaultValue: null, length: 12, type: esriFieldTypeString, isViewOverride: true, alias: Phone )
• pocemail ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Email, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Submitted On, type: esriFieldTypeDate )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 128, alias: Creator, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: EditDate, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 128, alias: Editor, type: esriFieldTypeString )
Templates:
• Name: Surveys
  Description:
  Prototype:
  nps: null
  pocfullname: null
  pocemail: null
  resquality: null
  comments: null
  pocfirstname: null
  service: null
  probguid: null
  restime: null
  pocphone: null
  poclastname: null
  cancontact: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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