Name: Sewer Pipes Missing Inspections

Display Field: projname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: ac62f11034bc45b7b68bbde86bef4aa1

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2888664.542564828
YMin: 2275994.4043555707
XMax: 2915036.0396904945
YMax: 2298172.888869904
Spatial Reference: 2245  (2966)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: RedzoneReinspectionStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Cleaned
  Label: Cleaned
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 169, 230, 255]
  Width: 2
• Value: Complete
  Label: Complete
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 2
• Value: No change
  Label: No change
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: Partially Televised
  Label: Partially Televised
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [169, 0, 230, 255]
  Width: 2
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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ASSETGROUP

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• assetgroup ( type: esriFieldTypeInteger, alias: Asset group )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset type , Coded Values: [0: Unknown] )
• creationdate ( type: esriFieldTypeDate, alias: Creation date, length: 8 )
• creator ( type: esriFieldTypeString, alias: Creator, length: 255 )
• lastupdate ( type: esriFieldTypeDate, alias: Last update, length: 8 )
• updatedby ( type: esriFieldTypeString, alias: Updated by, length: 255 )
• diameter ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...28 more... )
• material ( type: esriFieldTypeSmallInteger, alias: Material , Coded Values: [0: Unknown] , [1: Acrylonitrile Butadiene Styrene - ABS] , [2: Asbestos Cement - AC] , ...26 more... )
• historic_assetid ( type: esriFieldTypeString, alias: Historic Asset ID, length: 255 )
• installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• streetaddress ( type: esriFieldTypeString, alias: Street Address, length: 255 )
• projname ( type: esriFieldTypeString, alias: Project Name, length: 255 , Coded Values: [61st Avenue - Road Plans: 61st Avenue - Road Plans] , [Ash Street Sanitary Sewer Improvements, Hobart, IN. ACOE Contract: W92P6-12-C-0013: Ash Street Sanitary Sewer Improvements, Hobart, IN. ACOE Contract: W92P6-12-C-0013] , [Becknell-Teleperformance Parking Lot: Becknell-Teleperformance Parking Lot] , ...4 more... )
• engineer ( type: esriFieldTypeString, alias: Engineer, length: 255 , Coded Values: [Butler, Fairman & Seufert: Butler, Fairman & Seufert] , [Lawson-Fisher, Assoc: Lawson-Fisher, Assoc] , [Torrenga Engineering: Torrenga Engineering] )
• contractor ( type: esriFieldTypeString, alias: Contractor, length: 255 , Coded Values: [Gariup Construction: Gariup Construction] , [Gatlin Plumbing: Gatlin Plumbing] , [Grimmer Construction: Grimmer Construction] , ...3 more... )
• RZ_US ( type: esriFieldTypeString, alias: RZ Upstream, length: 255 )
• RZ_DS ( type: esriFieldTypeString, alias: RZ Downstream, length: 255 )
• RZ_USDS ( type: esriFieldTypeString, alias: RZ Upstream to Downstream, length: 255 )
• Condition ( type: esriFieldTypeSmallInteger, alias: Condition )
• Location ( type: esriFieldTypeString, alias: Location, length: 255 )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, length: 50 )
• Condition_Date ( type: esriFieldTypeDate, alias: Condition_Date, length: 8 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 )
• Decommissioned_Date ( type: esriFieldTypeDate, alias: Decommissioned Date, length: 8 )
• Date_Cleaned ( type: esriFieldTypeDate, alias: Date Cleaned, length: 8 )
• Light_Heavy_Cleaning ( type: esriFieldTypeString, alias: Light/Heavy Cleaning?, length: 1073741822 )
• Date_Televised ( type: esriFieldTypeDate, alias: Date Televised, length: 8 )
• TelevisedDirection ( type: esriFieldTypeString, alias: Televised Direction, length: 1073741822 )
• Field_Comment ( type: esriFieldTypeString, alias: Field Comment, length: 1073741822 )
• OrigMissingInspection ( type: esriFieldTypeSmallInteger, alias: OrigMissingInspection )
• RedzoneReinspectionStatus ( type: esriFieldTypeString, alias: Re-Inspection Status, length: 50 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Length_Surveyed ( type: esriFieldTypeDouble, alias: Length Surveyed )
• Reversal ( type: esriFieldTypeString, alias: Reversal (Y/N), length: 255 )
• Reversal_Date_Televised ( type: esriFieldTypeDate, alias: Reversal Date Televised, length: 8 )
• Reversal_Length_Surveyed ( type: esriFieldTypeDouble, alias: Reversal Length Surveyed )
• Root_Removal ( type: esriFieldTypeString, alias: Root Removal (Y/N), length: 255 )
• Tap_Removal ( type: esriFieldTypeString, alias: Tap Removal (Y/N), length: 255 )
• Total_Length_Surveyed ( type: esriFieldTypeDouble, alias: Total Length Surveyed )
• PercentSurveyed ( type: esriFieldTypeDouble, alias: PercentSurveyed )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Types:

ID: 0
Name: Unknown
Domains:
• assettype:
  Inherited
• diameter:
  Inherited
• material:
  Inherited
• projname:
  Inherited
• engineer:
  Inherited
• contractor:
  Inherited

---

ID: 1
Name: Sewer Gravity Main
Domains:
• assettype:
  Coded Values: [1: Collector Gravity Main] , [2: Interceptor Gravity Main]
• diameter:
  Inherited
• material:
  Inherited
• projname:
  Inherited
• engineer:
  Inherited
• contractor:
  Inherited

---

ID: 2
Name: Sewer Force Main
Domains:
• assettype:
  Coded Values: [41: Collector Force Main] , [42: Interceptor Force Main]
• diameter:
  Inherited
• material:
  Inherited
• projname:
  Inherited
• engineer:
  Inherited
• contractor:
  Inherited

---

ID: 3
Name: Lateral
Domains:
• assettype:
  Coded Values: [121: Commercial] , [122: Industrial] , [123: Residential]
• diameter:
  Inherited
• material:
  Inherited
• projname:
  Inherited
• engineer:
  Inherited
• contractor:
  Inherited

---

ID: 4
Name: Sewer Low Pressure Main
Domains:
• assettype:
  Coded Values: [41: Collector Force Main] , [42: Interceptor Force Main]
• diameter:
  Inherited
• material:
  Inherited
• projname:
  Inherited
• engineer:
  Inherited
• contractor:
  Inherited

---

ID: 5
Name: Low Pressure Lateral
Domains:
• assettype:
  Coded Values: [121: Commercial] , [122: Industrial] , [123: Residential]
• diameter:
  Inherited
• material:
  Inherited
• projname:
  Inherited
• engineer:
  Inherited
• contractor:
  Inherited

---

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata