View In:   ArcGIS Online Map Viewer

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

---

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata