Name: Sewer Gravity Mains

Display Field: projname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 92ee12da09db421c95a232862ed235d1

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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: 2884136.607394997
YMin: 2047768.4867925718
XMax: 3165849.39862708
YMax: 2298172.888869904
Spatial Reference: 2245  (2966)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [230, 152, 0, 255]
Width: 1
Label: N/A
Description: N/A
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ASSETGROUP

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Reviewed ( type: esriFieldTypeString, alias: Reviewed, length: 10 )
• ASSETGROUP ( type: esriFieldTypeInteger, alias: Asset group )
• ASSETTYPE ( type: esriFieldTypeSmallInteger, alias: Asset type )
• diameter ( type: esriFieldTypeDouble, alias: Diameter )
• 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 )
• engineer ( type: esriFieldTypeString, alias: Engineer, length: 255 )
• contractor ( type: esriFieldTypeString, alias: Contractor, length: 255 )
• 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: 255 )
• Condition_Date ( type: esriFieldTypeDate, alias: Condition_Date, length: 8 )
• Status ( type: esriFieldTypeString, alias: Status, length: 255 )
• Decommissioned_Date ( type: esriFieldTypeDate, alias: Decommissioned Date, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• MH_Distance ( type: esriFieldTypeDouble, alias: Distance from Manhole )
• District ( type: esriFieldTypeString, alias: District, length: 512 )
• Interceptor ( type: esriFieldTypeString, alias: Interceptor, length: 5 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• inspection_date ( type: esriFieldTypeDate, alias: inspection_date, length: 8 )
• date_cleaned ( type: esriFieldTypeDate, alias: date_cleaned, length: 8 )
• inspection_status ( type: esriFieldTypeString, alias: inspection_status, length: 255 )
• street ( type: esriFieldTypeString, alias: street, length: 255 )
• location_code ( type: esriFieldTypeString, alias: location_code, length: 255 )
• location_details ( type: esriFieldTypeString, alias: location_details, length: 255 )
• height ( type: esriFieldTypeInteger, alias: height )
• width ( type: esriFieldTypeDouble, alias: width )
• pipe_shape ( type: esriFieldTypeString, alias: pipe_shape, length: 255 )
• Material ( type: esriFieldTypeString, alias: Material, length: 255 )
• lining_method ( type: esriFieldTypeString, alias: lining_method, length: 255 )
• coating_method ( type: esriFieldTypeString, alias: coating_method, length: 255 )
• up_rim_to_invert ( type: esriFieldTypeDouble, alias: up_rim_to_invert )
• up_grade_to_invert ( type: esriFieldTypeDouble, alias: up_grade_to_invert )
• down_rim_to_invert ( type: esriFieldTypeDouble, alias: down_rim_to_invert )
• down_grade_to_invert ( type: esriFieldTypeDouble, alias: down_grade_to_invert )
• additional_info ( type: esriFieldTypeString, alias: additional_info, length: 255 )
• source ( type: esriFieldTypeString, alias: Source, length: 1073741822 )
• pdfs ( type: esriFieldTypeString, alias: PDFs, length: 512 )
• photos ( type: esriFieldTypeString, alias: Photos, length: 512 )
• videos ( type: esriFieldTypeString, alias: Videos, length: 512 )
• length_surveyed ( type: esriFieldTypeDouble, alias: Length Surveyed )
• percent_surveyed ( type: esriFieldTypeDouble, alias: Percent Surveyed )
• percent_surveyed_normalized ( type: esriFieldTypeSmallInteger, alias: Percent Surveyed Normalized )
• inspection_record ( type: esriFieldTypeString, alias: inspection_record, length: 512 )
• LegacyGUID ( type: esriFieldTypeGUID, alias: LegacyGUID, length: 38 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• pre_cleaning ( type: esriFieldTypeString, alias: pre_cleaning, length: 1073741822 )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• OM_Quick ( type: esriFieldTypeString, alias: OM Quick, length: 1073741822 )
• Structural_Quick ( type: esriFieldTypeString, alias: Structural Quick, length: 1073741822 )
• Overall_Quick ( type: esriFieldTypeString, alias: Overall Quick, length: 1073741822 )
• OM_Index ( type: esriFieldTypeDouble, alias: OM Index )
• Structural_Index ( type: esriFieldTypeDouble, alias: Structural Index )
• Overall_Severity_Index ( type: esriFieldTypeDouble, alias: Overall Severity Index )
• Infiltration_Inflow ( type: esriFieldTypeDouble, alias: Infiltration & Inflow )

Types:

ID: 1
Name: Gravity Main
Domains:
• Reviewed:
  Coded Values: [Yes: Yes] , [No: No]
• ASSETTYPE:
  Coded Values: [1: Collector Gravity Main] , [2: Interceptor Gravity Main]
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...28 more...
• Condition:
  Coded Values: [1: Poor] , [2: OK] , [3: Good] , ...1 more...
• Status:
  Coded Values: [Active: Active] , [Not Active: Not Active]
• Interceptor:
  Coded Values: [Yes: Yes] , [No: No]
• inspection_status:
  Coded Values: [BM: Buried and Marked] , [CI: Complete Inspection] , [NA: No Access] , ...5 more...
• location_code:
  Coded Values: [A: Primary major arterial roads, interstates, numbered roads or town/city center roads for heavy vehicles.] , [B: Secondary roads, non-numbered suburban/rural for heavy vehicles.] , [C: Local rural streets with light traffic, town and city back streets, estate streets and curbside parking areas.] , ...15 more...
• pipe_shape:
  Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...8 more...
• Material:
  Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CAS: Cast Iron] , ...25 more...
• lining_method:
  Coded Values: [CIP: Cured-In-Place Pipe] , [FF: Fold and Form or Deform/Reform] , [FP: Formed-In-Place Liner] , ...11 more...
• coating_method:
  Coded Values: [CM: Cement Mortar] , [CT: Coal Tar or Bituminous] , [EP: Epoxy] , ...6 more...
• pdfs:
  Coded Values: [Yes: Yes] , [No: No]
• photos:
  Coded Values: [Yes: Yes] , [No: No]
• videos:
  Coded Values: [Yes: Yes] , [No: No]
• inspection_record:
  Coded Values: [Yes: Yes] , [No: No]

---

ID: 2
Name: Force Main
Domains:
• Reviewed:
  Coded Values: [Yes: Yes] , [No: No]
• ASSETTYPE:
  Coded Values: [41: Collector Force Main] , [42: Interceptor Force Main]
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...28 more...
• Condition:
  Coded Values: [1: Poor] , [2: OK] , [3: Good] , ...1 more...
• Status:
  Coded Values: [Active: Active] , [Not Active: Not Active]
• Interceptor:
  Coded Values: [Yes: Yes] , [No: No]
• inspection_status:
  Coded Values: [BM: Buried and Marked] , [CI: Complete Inspection] , [NA: No Access] , ...5 more...
• location_code:
  Coded Values: [A: Primary major arterial roads, interstates, numbered roads or town/city center roads for heavy vehicles.] , [B: Secondary roads, non-numbered suburban/rural for heavy vehicles.] , [C: Local rural streets with light traffic, town and city back streets, estate streets and curbside parking areas.] , ...15 more...
• pipe_shape:
  Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...8 more...
• Material:
  Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CAS: Cast Iron] , ...25 more...
• lining_method:
  Coded Values: [CIP: Cured-In-Place Pipe] , [FF: Fold and Form or Deform/Reform] , [FP: Formed-In-Place Liner] , ...11 more...
• coating_method:
  Coded Values: [CM: Cement Mortar] , [CT: Coal Tar or Bituminous] , [EP: Epoxy] , ...6 more...
• pdfs:
  Coded Values: [Yes: Yes] , [No: No]
• photos:
  Coded Values: [Yes: Yes] , [No: No]
• videos:
  Coded Values: [Yes: Yes] , [No: No]
• inspection_record:
  Coded Values: [Yes: Yes] , [No: No]

---

ID: 3
Name: Lateral
Domains:
• Reviewed:
  Coded Values: [Yes: Yes] , [No: No]
• ASSETTYPE:
  Coded Values: [121: Commercial] , [122: Industrial] , [123: Residential]
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...28 more...
• Condition:
  Coded Values: [1: Poor] , [2: OK] , [3: Good] , ...1 more...
• Status:
  Coded Values: [Active: Active] , [Not Active: Not Active]
• Interceptor:
  Coded Values: [Yes: Yes] , [No: No]
• inspection_status:
  Coded Values: [BM: Buried and Marked] , [CI: Complete Inspection] , [NA: No Access] , ...5 more...
• location_code:
  Coded Values: [A: Primary major arterial roads, interstates, numbered roads or town/city center roads for heavy vehicles.] , [B: Secondary roads, non-numbered suburban/rural for heavy vehicles.] , [C: Local rural streets with light traffic, town and city back streets, estate streets and curbside parking areas.] , ...15 more...
• pipe_shape:
  Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...8 more...
• Material:
  Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CAS: Cast Iron] , ...25 more...
• lining_method:
  Coded Values: [CIP: Cured-In-Place Pipe] , [FF: Fold and Form or Deform/Reform] , [FP: Formed-In-Place Liner] , ...11 more...
• coating_method:
  Coded Values: [CM: Cement Mortar] , [CT: Coal Tar or Bituminous] , [EP: Epoxy] , ...6 more...
• pdfs:
  Coded Values: [Yes: Yes] , [No: No]
• photos:
  Coded Values: [Yes: Yes] , [No: No]
• videos:
  Coded Values: [Yes: Yes] , [No: No]
• inspection_record:
  Coded Values: [Yes: Yes] , [No: No]

---

ID: 4
Name: Low Pressure Main
Domains:
• Reviewed:
  Coded Values: [Yes: Yes] , [No: No]
• ASSETTYPE:
  Coded Values: [41: Collector Force Main] , [42: Interceptor Force Main]
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...28 more...
• Condition:
  Coded Values: [1: Poor] , [2: OK] , [3: Good] , ...1 more...
• Status:
  Coded Values: [Active: Active] , [Not Active: Not Active]
• Interceptor:
  Coded Values: [Yes: Yes] , [No: No]
• inspection_status:
  Coded Values: [BM: Buried and Marked] , [CI: Complete Inspection] , [NA: No Access] , ...5 more...
• location_code:
  Coded Values: [A: Primary major arterial roads, interstates, numbered roads or town/city center roads for heavy vehicles.] , [B: Secondary roads, non-numbered suburban/rural for heavy vehicles.] , [C: Local rural streets with light traffic, town and city back streets, estate streets and curbside parking areas.] , ...15 more...
• pipe_shape:
  Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...8 more...
• Material:
  Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CAS: Cast Iron] , ...25 more...
• lining_method:
  Coded Values: [CIP: Cured-In-Place Pipe] , [FF: Fold and Form or Deform/Reform] , [FP: Formed-In-Place Liner] , ...11 more...
• coating_method:
  Coded Values: [CM: Cement Mortar] , [CT: Coal Tar or Bituminous] , [EP: Epoxy] , ...6 more...
• pdfs:
  Coded Values: [Yes: Yes] , [No: No]
• photos:
  Coded Values: [Yes: Yes] , [No: No]
• videos:
  Coded Values: [Yes: Yes] , [No: No]
• inspection_record:
  Coded Values: [Yes: Yes] , [No: No]

---

ID: 5
Name: Low Pressure Lateral
Domains:
• Reviewed:
  Coded Values: [Yes: Yes] , [No: No]
• ASSETTYPE:
  Coded Values: [121: Commercial] , [122: Industrial] , [123: Residential]
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...28 more...
• Condition:
  Coded Values: [1: Poor] , [2: OK] , [3: Good] , ...1 more...
• Status:
  Coded Values: [Active: Active] , [Not Active: Not Active]
• Interceptor:
  Coded Values: [Yes: Yes] , [No: No]
• inspection_status:
  Coded Values: [BM: Buried and Marked] , [CI: Complete Inspection] , [NA: No Access] , ...5 more...
• location_code:
  Coded Values: [A: Primary major arterial roads, interstates, numbered roads or town/city center roads for heavy vehicles.] , [B: Secondary roads, non-numbered suburban/rural for heavy vehicles.] , [C: Local rural streets with light traffic, town and city back streets, estate streets and curbside parking areas.] , ...15 more...
• pipe_shape:
  Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...8 more...
• Material:
  Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CAS: Cast Iron] , ...25 more...
• lining_method:
  Coded Values: [CIP: Cured-In-Place Pipe] , [FF: Fold and Form or Deform/Reform] , [FP: Formed-In-Place Liner] , ...11 more...
• coating_method:
  Coded Values: [CM: Cement Mortar] , [CT: Coal Tar or Bituminous] , [EP: Epoxy] , ...6 more...
• pdfs:
  Coded Values: [Yes: Yes] , [No: No]
• photos:
  Coded Values: [Yes: Yes] , [No: No]
• videos:
  Coded Values: [Yes: Yes] , [No: No]
• inspection_record:
  Coded Values: [Yes: Yes] , [No: No]

---

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

  Iteminfo   Thumbnail   Metadata