Layers:

Layer: Known Sewer Defects (0)

Name: Known Sewer Defects

Display Field: UtilityType

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Point feature class showing sanitary sewer and storm sewer defects in the City of Dubuque utility system. These defects are found by field crews performing maintenance or inspection work.

Service Item Id: d5b0477c61c04c3fb49c8562d91106c8

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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

Supports Datum Transformation: true

Extent:
XMin: 5656293.165057316
YMin: 3637056.310661018
XMax: 5688897.364429504
YMax: 3672882.9757687747
Spatial Reference: 102675  (3417)  VCSWkid(5703)  LatestVCSWkid(5703)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: UtilityType
Field 2: Resolved
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Sanitary,No
  Label: Sanitary,No
  Description: N/A
  Symbol:
  
• Value: Sanitary,Yes
  Label: Sanitary,Yes
  Description: N/A
  Symbol:
  
• Value: Storm,No
  Label: Storm,No
  Description: N/A
  Symbol:
  
• Value: Storm,Yes
  Label: Storm,Yes
  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: true
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: false
Supports Query With LOD Spatial Reference: false
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: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: UtilityType

Fields:
• FacilityID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FacilityID )
• UtilityType ( type: esriFieldTypeString, alias: Utility Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UtilityType , Coded Values: [Sanitary: Sanitary] , [Storm: Storm] , [Fiber: Fiber] , ...1 more... )
• DefectID ( type: esriFieldTypeInteger, alias: Defect ID, editable: true, nullable: true, defaultValue: null, modelName: DefectID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• DateFound ( type: esriFieldTypeDate, alias: Date Found, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateFound )
• Resolved ( type: esriFieldTypeString, alias: Resolved?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Resolved , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• ResolvedDate ( type: esriFieldTypeDate, alias: Resolved Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResolvedDate )
• RepairPriority ( type: esriFieldTypeString, alias: Repair Priority, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RepairPriority , Coded Values: [Low: Low] , [Medium: Medium] , [High: High] )
• DefectType ( type: esriFieldTypeString, alias: Defect Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DefectType )
• Note ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Note )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• TotalCost ( type: esriFieldTypeDouble, alias: Total Cost, editable: true, nullable: true, defaultValue: null, modelName: TotalCost )
Types:
ID: Sanitary
Name: Sanitary,No
Domains:
• UtilityType:
  Inherited
• Resolved:
  Inherited
• RepairPriority:
  Inherited
Templates:
• Name: Sanitary,No
  Description:
  Prototype:
  FacilityID: null
  DateFound: null
  TotalCost: null
  UtilityType: Sanitary
  DefectID: null
  Resolved: No
  ResolvedDate: null
  RepairPriority: null
  DefectType: null
  Note: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Sanitary,Yes
  Description:
  Prototype:
  FacilityID: null
  DateFound: null
  TotalCost: null
  UtilityType: Sanitary
  DefectID: null
  Resolved: Yes
  ResolvedDate: null
  RepairPriority: null
  DefectType: null
  Note: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Storm
Name: Storm,No
Domains:
• UtilityType:
  Inherited
• Resolved:
  Inherited
• RepairPriority:
  Inherited
Templates:
• Name: Storm,No
  Description:
  Prototype:
  FacilityID: null
  DateFound: null
  TotalCost: null
  UtilityType: Storm
  DefectID: null
  Resolved: No
  ResolvedDate: null
  RepairPriority: null
  DefectType: null
  Note: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Storm,Yes
  Description:
  Prototype:
  FacilityID: null
  DateFound: null
  TotalCost: null
  UtilityType: Storm
  DefectID: null
  Resolved: Yes
  ResolvedDate: null
  RepairPriority: null
  DefectType: null
  Note: null
  
  Drawing Tool: esriFeatureEditToolPoint

---