View In:   ArcGIS Online Map Viewer

Name: Citizen_Problems

Display Field: pocfullname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3b96f0b2299343a3992ab0bd062105da

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 4254918.083989501
YMin: 883200.9114173204
XMax: 4262322.474409446
YMax: 885278.0807086676
Spatial Reference: 2914  (2914)

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: Completed
  Label: Completed
  Description: N/A
  Symbol:
  
• Value: In Progress
  Label: In Progress
  Description: N/A
  Symbol:
  
• Value: Received
  Label: Received
  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: status

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• probid ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: probid, alias: Problem ID )
• category ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: category, alias: Category , Coded Values: [ERT: EMERGENCY RESPONSE TEAM] , [FIRST: FIRST RESPONSE TEAM] , [900: FLEET MAINT CREW] , ...8 more... )
• probtype ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: probtype, alias: Type of Problem , Coded Values: [AJST: ADJUSTMENT NEEDED] , [ALYP: ALLEY POTHOLE] , [ALYV: ALLEY VEGETATION] , ...88 more... )
• details ( nullable: true, editable: true, defaultValue: null, length: 1000, type: esriFieldTypeString, modelName: details, alias: Details about the problem )
• pocfullname ( nullable: true, editable: true, defaultValue: null, length: 150, type: esriFieldTypeString, modelName: pocfullname, alias: Full Name )
• pocfirstname ( nullable: true, editable: true, defaultValue: null, length: 150, type: esriFieldTypeString, modelName: pocfirstname, alias: First Name )
• poclastname ( nullable: true, editable: true, defaultValue: null, length: 150, type: esriFieldTypeString, modelName: poclastname, alias: Last Name )
• pocphone ( nullable: true, editable: true, defaultValue: null, length: 12, type: esriFieldTypeString, modelName: pocphone, alias: Phone Number )
• pocemail ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: pocemail, alias: Email )
• locdesc ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: locdesc, alias: Location )
• publicview ( nullable: true, editable: true, defaultValue: Y, length: 5, type: esriFieldTypeString, modelName: publicview, alias: Visible to the public , Coded Values: [N/A: N/A] , [Y: YES] , [N: NO] )
• userid ( nullable: true, editable: true, defaultValue: null, length: 150, type: esriFieldTypeString, modelName: userid, alias: User Name )
• numvotes ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: numvotes, alias: Number of Votes )
• status ( nullable: true, editable: true, defaultValue: Submitted, length: 25, type: esriFieldTypeString, modelName: status, alias: Status , Coded Values: [Submitted: Submitted] , [Received: Received] , [In Progress: In Progress] , ...1 more... )
• assignedto ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: assignedto, alias: Assigned To , Coded Values: [ERT: EMERGENCY RESPONSE TEAM] , [FIRST: FIRST RESPONSE TEAM] , [900: FLEET MAINT CREW] , ...8 more... )
• resolution ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: resolution, alias: Resolution )
• resolutiondt ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: resolutiondt, alias: Resolved On )
• emailstatus ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: emailstatus, alias: Email Status )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: Submitted On )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 128, type: esriFieldTypeString, modelName: created_user, alias: Creator )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: EditDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 128, type: esriFieldTypeString, modelName: last_edited_user, alias: Editor )

Types:

ID: Submitted
Name: Submitted
Domains:
Templates:
• Name: Submitted
  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
  category: null
  locdesc: null
  publicview: Y
  status: Submitted
  
  Drawing Tool: N/A

---

ID: Completed
Name: Completed
Domains:
Templates:
• Name: Completed
  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
  category: null
  locdesc: null
  publicview: Y
  status: Completed
  
  Drawing Tool: N/A

---

ID: In Progress
Name: In Progress
Domains:
Templates:
• Name: In Progress
  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
  category: null
  locdesc: null
  publicview: Y
  status: In Progress
  
  Drawing Tool: N/A

---

ID: Received
Name: Received
Domains:
Templates:
• Name: Received
  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
  category: null
  locdesc: null
  publicview: Y
  status: Received
  
  Drawing Tool: esriFeatureEditToolPoint

---

Templates:

• Name: Citizen_Problems
  Description:
  Prototype:
  probtype: null
  pocfullname: null
  created_user: null
  pocphone: null
  probid: null
  poclastname: null
  userid: null
  resolution: null
  numvotes: null
  assignedto: null
  pocemail: null
  last_edited_user: null
  pocfirstname: null
  emailstatus: null
  last_edited_date: null
  details: null
  resolutiondt: null
  created_date: null
  category: null
  locdesc: null
  publicview: Y
  status: Submitted
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• Springfield.DATA.L1Comments (0) -- Related To: Comments (1)

Capabilities: Query,Create,Update,Delete,Editing,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata