Layers:

Layer: Structures Requiring Inspection (39)

Name: Structures Requiring Inspection

Display Field: CNVYNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 27ace7498cc543b4bf3387270e068612

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 2411192.972047411
YMin: 1451856.1127215698
XMax: 2475069.4289399125
YMax: 1519927.9378637373
Spatial Reference: 103038  (6457)  VCSWkid(105703)  LatestVCSWkid(6360)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: assetgroup
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0
  Label: Unknown
  Description: N/A
  Symbol:
  
• Value: 22
  Label: End Treatment
  Description: N/A
  Symbol:
  
• Value: 28
  Label: Inlet
  Description: N/A
  Symbol:
  
• Value: 32
  Label: Manhole
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Feature Draw Order:
N/A
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: 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: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: assetgroup

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• assetid ( type: esriFieldTypeString, alias: Structure ID, editable: true, nullable: true, length: 64, defaultValue: null, modelName: assetid )
• IDOT_survey_code ( type: esriFieldTypeSmallInteger, alias: IDOT Survey Code, editable: true, nullable: true, defaultValue: null, modelName: IDOT_survey_code )
• assetgroup ( type: esriFieldTypeInteger, alias: Asset group, editable: true, nullable: false, defaultValue: 0, modelName: assetgroup, required: true )
• surfacewater ( type: esriFieldTypeSmallInteger, alias: Receives Surface Water, editable: true, nullable: true, defaultValue: null, modelName: surfacewater )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset type, editable: true, nullable: false, defaultValue: 0, modelName: assettype, required: true , Coded Values: [0: Unknown] , [2: Diversion Manhole] , [3: Junction Manhole] , ...7 more... )
• designtype ( type: esriFieldTypeSmallInteger, alias: Type, editable: true, nullable: true, defaultValue: null, modelName: designtype )
• add_et ( type: esriFieldTypeSmallInteger, alias: End Treatment Add. Type, editable: true, nullable: true, defaultValue: null, modelName: add_et )
• isconnected ( type: esriFieldTypeSmallInteger, alias: Is connected, editable: true, nullable: false, defaultValue: 2, modelName: isconnected , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• creationdate ( type: esriFieldTypeDate, alias: Creation date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: creationdate )
• creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 255, defaultValue: null, modelName: creator )
• lastupdate ( type: esriFieldTypeDate, alias: Last update, editable: false, nullable: true, length: 8, defaultValue: null, modelName: lastupdate )
• updatedby ( type: esriFieldTypeString, alias: Updated by, editable: false, nullable: true, length: 255, defaultValue: null, modelName: updatedby )
• globalid ( type: esriFieldTypeGUID, alias: Global ID 2, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: globalid )
• material ( type: esriFieldTypeSmallInteger, alias: Material, editable: true, nullable: true, defaultValue: null, modelName: material )
• material_struct ( type: esriFieldTypeSmallInteger, alias: Inside Structure Material, editable: true, nullable: true, defaultValue: null, modelName: material_struct )
• diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter )
• length2 ( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: length2 )
• width ( type: esriFieldTypeDouble, alias: Width, editable: true, nullable: true, defaultValue: null, modelName: width )
• depth ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: depth )
• elevation ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: elevation )
• bottom_elevation ( type: esriFieldTypeDouble, alias: Bottom Elevation, editable: true, nullable: true, defaultValue: null, modelName: bottom_elevation )
• pipe_count ( type: esriFieldTypeSmallInteger, alias: Number of Pipes, editable: true, nullable: true, defaultValue: null, modelName: pipe_count )
• shape_struct ( type: esriFieldTypeSmallInteger, alias: Inside Strcture Shape, editable: true, nullable: true, defaultValue: null, modelName: shape_struct )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: notes )
• inletshape ( type: esriFieldTypeSmallInteger, alias: Inlet Shape, editable: true, nullable: true, defaultValue: null, modelName: inletshape )
• validationstatus ( type: esriFieldTypeSmallInteger, alias: Validation status, editable: true, nullable: true, defaultValue: 6, modelName: validationstatus , Coded Values: [0: No calculation required, no validation required, no error] , [1: No calculation required, no validation required, has error(s)] , [2: No calculation required, validation required, no error] , ...5 more... )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: Global ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• conetype ( type: esriFieldTypeSmallInteger, alias: Cone type, editable: true, nullable: true, defaultValue: null, modelName: conetype )
• MACP ( type: esriFieldTypeDouble, alias: MACP score, editable: true, nullable: true, defaultValue: null, modelName: MACP )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status, editable: true, nullable: false, defaultValue: 8, modelName: lifecyclestatus , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• surveydate ( type: esriFieldTypeDate, alias: Survey Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: surveydate )
• inspectdate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspectdate )
• CMT_CAD_GIS ( type: esriFieldTypeSmallInteger, alias: CMT_CAD_GIS, editable: true, nullable: true, defaultValue: null, modelName: CMT_CAD_GIS , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• frame_type ( type: esriFieldTypeString, alias: frame_type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: frame_type )
• distance_to_sub_w_year ( type: esriFieldTypeDouble, alias: distance_to_sub_w_year, editable: true, nullable: true, defaultValue: null, modelName: distance_to_sub_w_year )
• CNVYNAME ( type: esriFieldTypeString, alias: 7!Subdivision Name, editable: true, nullable: true, length: 250, defaultValue: null, modelName: CNVYNAME )
• FREQUENCY ( type: esriFieldTypeInteger, alias: FREQUENCY, editable: true, nullable: true, defaultValue: null, modelName: FREQUENCY )
• MIN_year_built ( type: esriFieldTypeDouble, alias: MIN_year_built, editable: true, nullable: true, defaultValue: null, modelName: MIN_year_built )
• Platt_year ( type: esriFieldTypeInteger, alias: Platt_year, editable: true, nullable: true, defaultValue: null, modelName: Platt_year )
• year_final ( type: esriFieldTypeString, alias: year_final, editable: true, nullable: true, length: 255, defaultValue: null, modelName: year_final )
• LoFMACP ( type: esriFieldTypeSingle, alias: LoFMACP, editable: true, nullable: true, defaultValue: null, modelName: LoFMACP )
• InspectionID ( type: esriFieldTypeInteger, alias: InspectionID, editable: true, nullable: true, defaultValue: null, modelName: InspectionID )
• cmt_proxy_year ( type: esriFieldTypeDate, alias: CMT Proxy Year, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cmt_proxy_year )
• near_address ( type: esriFieldTypeString, alias: Nearest Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: near_address )
• location ( type: esriFieldTypeSmallInteger, alias: Structure Location, editable: true, nullable: true, defaultValue: null, modelName: location )
• surface ( type: esriFieldTypeSmallInteger, alias: Structure Surface Type, editable: true, nullable: true, defaultValue: null, modelName: surface )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source, editable: true, nullable: true, defaultValue: 0, modelName: spatialsource , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: ownedby , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: 1, modelName: maintby , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• sw_system ( type: esriFieldTypeSmallInteger, alias: sw_system, editable: true, nullable: true, defaultValue: null, modelName: sw_system , Coded Values: [0: MS4] , [1: CSO] , [2: MS4-GI] , ...1 more... )
• fg_length ( type: esriFieldTypeDouble, alias: Frame & Grate - Length, editable: true, nullable: true, defaultValue: null, modelName: fg_length )
• fg_width ( type: esriFieldTypeDouble, alias: Frame & Grate - Width, editable: true, nullable: true, defaultValue: null, modelName: fg_width )
• fg_diameter ( type: esriFieldTypeDouble, alias: Frame & Grate - Diameter, editable: true, nullable: true, defaultValue: null, modelName: fg_diameter )
• StreetID ( type: esriFieldTypeString, alias: Street ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StreetID )
• cmt_proxy_bottomelev ( type: esriFieldTypeDouble, alias: CMT Proxy Bottom Elevation, editable: true, nullable: true, defaultValue: null, modelName: cmt_proxy_bottomelev )
• FOTH_DRAC_GIS ( type: esriFieldTypeSmallInteger, alias: FOTH_DRAC_GIS, editable: true, nullable: true, defaultValue: null, modelName: FOTH_DRAC_GIS , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• ESRIGNSS_POSITIONSOURCETYPE ( type: esriFieldTypeSmallInteger, alias: Position source type, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_POSITIONSOURCETYPE , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...3 more... )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ESRIGNSS_RECEIVER )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LATITUDE )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LONGITUDE )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_ALTITUDE )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_H_RMS )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_V_RMS )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ESRIGNSS_FIXDATETIME )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_FIXTYPE , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_CORRECTIONAGE )
• ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_STATIONID , Range: [0, 1023] )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_NUMSATS , Range: [0, 99] )
• ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_PDOP )
• ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_HDOP )
• ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_VDOP )
• ESRIGNSS_DIRECTION ( type: esriFieldTypeDouble, alias: Direction of travel (°), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_DIRECTION )
• ESRIGNSS_SPEED ( type: esriFieldTypeDouble, alias: Speed (km/h), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_SPEED )
• ESRISNSR_AZIMUTH ( type: esriFieldTypeDouble, alias: Compass reading (°), editable: true, nullable: true, defaultValue: null, modelName: ESRISNSR_AZIMUTH )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_H_RMS )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_V_RMS )
• ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeSmallInteger, alias: Averaged Positions, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_POSITIONS )
• ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_H_STDDEV )
Types:
ID: 0
Name: Unknown
Domains:
• assettype:
  Coded Values: [0: Unknown]
• isconnected:
  Inherited
• validationstatus:
  Inherited
• CMT_CAD_GIS:
  Inherited
• sw_system:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  IDOT_survey_code: null
  ESRIGNSS_AVG_POSITIONS: null
  assetid: null
  assetgroup: 0
  surfacewater: null
  assettype: 0
  designtype: null
  add_et: null
  isconnected: 2
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRISNSR_AZIMUTH: null
  ESRIGNSS_SPEED: null
  globalid: {00000000-0000-0000-0000-000000000000}
  material: null
  material_struct: null
  diameter: null
  length2: null
  width: null
  depth: null
  elevation: null
  bottom_elevation: null
  pipe_count: null
  shape_struct: null
  notes: null
  inletshape: null
  validationstatus: 6
  ESRIGNSS_H_STDDEV: null
  conetype: null
  MACP: null
  lifecyclestatus: 0
  installdate: null
  surveydate: null
  inspectdate: null
  CMT_CAD_GIS: null
  frame_type: null
  distance_to_sub_w_year: null
  CNVYNAME: null
  FREQUENCY: null
  MIN_year_built: null
  Platt_year: null
  year_final: null
  LoFMACP: null
  InspectionID: null
  cmt_proxy_year: null
  near_address: null
  location: null
  surface: null
  spatialsource: null
  ownedby: null
  maintby: null
  sw_system: null
  fg_length: null
  fg_width: null
  fg_diameter: null
  StreetID: null
  cmt_proxy_bottomelev: null
  FOTH_DRAC_GIS: null
  ESRIGNSS_POSITIONSOURCETYPE: null
  ESRIGNSS_RECEIVER: null
  ESRIGNSS_LATITUDE: null
  ESRIGNSS_LONGITUDE: null
  ESRIGNSS_ALTITUDE: null
  ESRIGNSS_H_RMS: null
  ESRIGNSS_V_RMS: null
  ESRIGNSS_FIXDATETIME: null
  ESRIGNSS_FIXTYPE: null
  ESRIGNSS_CORRECTIONAGE: null
  ESRIGNSS_STATIONID: null
  ESRIGNSS_NUMSATS: null
  ESRIGNSS_PDOP: null
  ESRIGNSS_HDOP: null
  ESRIGNSS_VDOP: null
  ESRIGNSS_DIRECTION: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 22
Name: End Treatment
Domains:
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• assettype:
  Coded Values: [0: Unknown] , [3: Culvert Inlet] , [4: Culvert Outlet] , ...2 more...
• designtype:
  Coded Values: [0: Unknown] , [9: Tide Gate Chamber] , [11: Flap Gate] , ...5 more...
• add_et:
  Coded Values: [0: N/A] , [1: Flap Gate] , [2: Apron] , ...4 more...
• isconnected:
  Inherited
• material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...25 more...
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• validationstatus:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• CMT_CAD_GIS:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• spatialsource:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• sw_system:
  Inherited
Templates:
• Name: End Treatment
  Description:
  Prototype:
  IDOT_survey_code: null
  ESRIGNSS_AVG_POSITIONS: null
  assetid: null
  assetgroup: 22
  surfacewater: 0
  assettype: 0
  designtype: 0
  add_et: null
  isconnected: 2
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRISNSR_AZIMUTH: null
  ESRIGNSS_SPEED: null
  globalid: {00000000-0000-0000-0000-000000000000}
  material: 0
  material_struct: null
  diameter: 0
  length2: null
  width: null
  depth: null
  elevation: null
  bottom_elevation: null
  pipe_count: null
  shape_struct: null
  notes: null
  inletshape: null
  validationstatus: null
  ESRIGNSS_H_STDDEV: null
  conetype: null
  MACP: null
  lifecyclestatus: 8
  installdate: null
  surveydate: null
  inspectdate: null
  CMT_CAD_GIS: 0
  frame_type: null
  distance_to_sub_w_year: null
  CNVYNAME: null
  FREQUENCY: null
  MIN_year_built: null
  Platt_year: null
  year_final: null
  LoFMACP: null
  InspectionID: null
  cmt_proxy_year: null
  near_address: null
  location: 0
  surface: 0
  spatialsource: 0
  ownedby: 1
  maintby: 1
  sw_system: null
  fg_length: null
  fg_width: null
  fg_diameter: null
  StreetID: null
  cmt_proxy_bottomelev: null
  FOTH_DRAC_GIS: null
  ESRIGNSS_POSITIONSOURCETYPE: null
  ESRIGNSS_RECEIVER: null
  ESRIGNSS_LATITUDE: null
  ESRIGNSS_LONGITUDE: null
  ESRIGNSS_ALTITUDE: null
  ESRIGNSS_H_RMS: null
  ESRIGNSS_V_RMS: null
  ESRIGNSS_FIXDATETIME: null
  ESRIGNSS_FIXTYPE: null
  ESRIGNSS_CORRECTIONAGE: null
  ESRIGNSS_STATIONID: null
  ESRIGNSS_NUMSATS: null
  ESRIGNSS_PDOP: null
  ESRIGNSS_HDOP: null
  ESRIGNSS_VDOP: null
  ESRIGNSS_DIRECTION: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 28
Name: Inlet
Domains:
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• assettype:
  Coded Values: [0: Unknown] , [204: Infiltration] , [210: Drop Inlet] , ...1 more...
• designtype:
  Coded Values: [0: Unknown] , [1: Curb Opening] , [2: Grate] , ...1 more...
• isconnected:
  Inherited
• material:
  Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
• material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• shape_struct:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• inletshape:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• validationstatus:
  Inherited
• conetype:
  Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• CMT_CAD_GIS:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• spatialsource:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• sw_system:
  Inherited
Templates:
• Name: Inlet
  Description:
  Prototype:
  IDOT_survey_code: null
  ESRIGNSS_AVG_POSITIONS: null
  assetid: null
  assetgroup: 28
  surfacewater: 1
  assettype: 0
  designtype: 0
  add_et: null
  isconnected: 2
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRISNSR_AZIMUTH: null
  ESRIGNSS_SPEED: null
  globalid: {00000000-0000-0000-0000-000000000000}
  material: 0
  material_struct: 0
  diameter: 0
  length2: null
  width: null
  depth: null
  elevation: null
  bottom_elevation: null
  pipe_count: null
  shape_struct: 0
  notes: null
  inletshape: 0
  validationstatus: null
  ESRIGNSS_H_STDDEV: null
  conetype: 0
  MACP: null
  lifecyclestatus: 8
  installdate: null
  surveydate: null
  inspectdate: null
  CMT_CAD_GIS: null
  frame_type: null
  distance_to_sub_w_year: null
  CNVYNAME: null
  FREQUENCY: null
  MIN_year_built: null
  Platt_year: null
  year_final: null
  LoFMACP: null
  InspectionID: null
  cmt_proxy_year: null
  near_address: null
  location: 0
  surface: 0
  spatialsource: 0
  ownedby: 1
  maintby: 1
  sw_system: null
  fg_length: null
  fg_width: null
  fg_diameter: null
  StreetID: null
  cmt_proxy_bottomelev: null
  FOTH_DRAC_GIS: null
  ESRIGNSS_POSITIONSOURCETYPE: null
  ESRIGNSS_RECEIVER: null
  ESRIGNSS_LATITUDE: null
  ESRIGNSS_LONGITUDE: null
  ESRIGNSS_ALTITUDE: null
  ESRIGNSS_H_RMS: null
  ESRIGNSS_V_RMS: null
  ESRIGNSS_FIXDATETIME: null
  ESRIGNSS_FIXTYPE: null
  ESRIGNSS_CORRECTIONAGE: null
  ESRIGNSS_STATIONID: null
  ESRIGNSS_NUMSATS: null
  ESRIGNSS_PDOP: null
  ESRIGNSS_HDOP: null
  ESRIGNSS_VDOP: null
  ESRIGNSS_DIRECTION: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 32
Name: Manhole
Domains:
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• assettype:
  Inherited
• designtype:
  Coded Values: [0: Unknown] , [3: Solid] , [4: Vented/Slotted] , ...4 more...
• isconnected:
  Inherited
• material:
  Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
• material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• shape_struct:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• inletshape:
  Coded Values: [0: Unknown] , [3: Arched (with flat bottom)] , [4: Barrel] , ...9 more...
• validationstatus:
  Inherited
• conetype:
  Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...
• lifecyclestatus:
  Inherited
• CMT_CAD_GIS:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• spatialsource:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• sw_system:
  Inherited
Templates:
• Name: Manhole
  Description:
  Prototype:
  IDOT_survey_code: null
  ESRIGNSS_AVG_POSITIONS: null
  assetid: null
  assetgroup: 32
  surfacewater: 0
  assettype: 9
  designtype: 0
  add_et: null
  isconnected: 1
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRISNSR_AZIMUTH: null
  ESRIGNSS_SPEED: null
  globalid: {00000000-0000-0000-0000-000000000000}
  material: 0
  material_struct: 0
  diameter: 0
  length2: null
  width: null
  depth: null
  elevation: null
  bottom_elevation: null
  pipe_count: null
  shape_struct: 0
  notes: null
  inletshape: 0
  validationstatus: null
  ESRIGNSS_H_STDDEV: null
  conetype: 0
  MACP: null
  lifecyclestatus: 8
  installdate: null
  surveydate: null
  inspectdate: null
  CMT_CAD_GIS: null
  frame_type: null
  distance_to_sub_w_year: null
  CNVYNAME: null
  FREQUENCY: null
  MIN_year_built: null
  Platt_year: null
  year_final: null
  LoFMACP: null
  InspectionID: null
  cmt_proxy_year: null
  near_address: null
  location: 0
  surface: 0
  spatialsource: null
  ownedby: 1
  maintby: 1
  sw_system: null
  fg_length: null
  fg_width: null
  fg_diameter: null
  StreetID: null
  cmt_proxy_bottomelev: null
  FOTH_DRAC_GIS: null
  ESRIGNSS_POSITIONSOURCETYPE: null
  ESRIGNSS_RECEIVER: null
  ESRIGNSS_LATITUDE: null
  ESRIGNSS_LONGITUDE: null
  ESRIGNSS_ALTITUDE: null
  ESRIGNSS_H_RMS: null
  ESRIGNSS_V_RMS: null
  ESRIGNSS_FIXDATETIME: null
  ESRIGNSS_FIXTYPE: null
  ESRIGNSS_CORRECTIONAGE: null
  ESRIGNSS_STATIONID: null
  ESRIGNSS_NUMSATS: null
  ESRIGNSS_PDOP: null
  ESRIGNSS_HDOP: null
  ESRIGNSS_VDOP: null
  ESRIGNSS_DIRECTION: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• StructuresToBeInspected_20240213 (0) -- Related To: Structures To Be Inspected (49)

Tables:

Table: Structures To Be Inspected (49)

Name: Structures To Be Inspected

Display Field: notes

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 27ace7498cc543b4bf3387270e068612

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
N/A
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: 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: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: notes )
• assetid ( type: esriFieldTypeString, alias: Structure ID, editable: true, nullable: true, length: 64, defaultValue: null, modelName: assetid )
• assetgroup ( type: esriFieldTypeInteger, alias: Asset group, editable: true, nullable: true, defaultValue: 0, modelName: assetgroup )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset type, editable: true, nullable: true, defaultValue: 0, modelName: assettype )
• designtype ( type: esriFieldTypeSmallInteger, alias: Type, editable: true, nullable: true, defaultValue: null, modelName: designtype )
• globalid ( type: esriFieldTypeString, alias: Global ID 2, editable: true, nullable: true, length: 38, defaultValue: null, modelName: globalid )
• unburied_req ( type: esriFieldTypeString, alias: unburied_req, editable: true, nullable: true, length: 1, defaultValue: null, modelName: unburied_req )
• clean_req ( type: esriFieldTypeString, alias: clean_req, editable: true, nullable: true, length: 1, defaultValue: null, modelName: clean_req )
• repair_req ( type: esriFieldTypeString, alias: repair_req, editable: true, nullable: true, length: 1, defaultValue: null, modelName: repair_req )
• UnburiedComp ( type: esriFieldTypeString, alias: Unbury Completed, editable: true, nullable: true, length: 255, defaultValue: Buried, modelName: UnburiedComp , Coded Values: [Buried: Buried] , [UnableToLocate: Unable to Locate] , [Unburied: Unburied] , ...3 more... )
• UnburiedComp_Notes ( type: esriFieldTypeString, alias: Unbury Completion Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UnburiedComp_Notes )
• CleanComp ( type: esriFieldTypeString, alias: Cleaning Completed, editable: true, nullable: true, length: 255, defaultValue: N, modelName: CleanComp , Coded Values: [Y: Yes] , [N: No] )
• CleanComp_Notes ( type: esriFieldTypeString, alias: Cleaning Completion Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CleanComp_Notes )
• RepairComp ( type: esriFieldTypeString, alias: Repair Completed, editable: true, nullable: true, length: 255, defaultValue: N, modelName: RepairComp , Coded Values: [Y: Yes] , [N: No] )
• RepairComp_Notes ( type: esriFieldTypeString, alias: Repair Completion Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RepairComp_Notes )
• IllicitDischargeInsp ( type: esriFieldTypeString, alias: Illicit Discharge Inspected, editable: true, nullable: true, length: 255, defaultValue: N, modelName: IllicitDischargeInsp , Coded Values: [Y: Yes] , [N: No] )
• IllicitDischargeInsp_Notes ( type: esriFieldTypeString, alias: Illicit Discharge Inspection Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IllicitDischargeInsp_Notes )
• InletProtectVerified ( type: esriFieldTypeString, alias: Inlet Protection Verified, editable: true, nullable: true, length: 255, defaultValue: N, modelName: InletProtectVerified , Coded Values: [Y: Yes] , [N: No] )
• InletProtectVerified_Notes ( type: esriFieldTypeString, alias: Inlet Protection Verification Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InletProtectVerified_Notes )
• unstuck_req ( type: esriFieldTypeString, alias: unstuck_req, editable: true, nullable: true, length: 1, defaultValue: null, modelName: unstuck_req )
• UnstuckComp ( type: esriFieldTypeString, alias: Unstuck Completed, editable: true, nullable: true, length: 255, defaultValue: N, modelName: UnstuckComp , Coded Values: [Y: Yes] , [N: No] )
• UnstuckComp_Notes ( type: esriFieldTypeString, alias: Unstuck Completion Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UnstuckComp_Notes )
• AssetGUID ( type: esriFieldTypeString, alias: Asset GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: AssetGUID )
Templates:
• Name: Structures To Be Inspected
  Description:
  Prototype:
  UnstuckComp_Notes: null
  notes: null
  assetid: null
  assetgroup: 0
  assettype: 0
  designtype: null
  globalid: null
  unburied_req: null
  clean_req: null
  repair_req: null
  UnburiedComp: Buried
  UnburiedComp_Notes: null
  CleanComp: N
  CleanComp_Notes: null
  RepairComp: N
  RepairComp_Notes: null
  IllicitDischargeInsp: N
  IllicitDischargeInsp_Notes: null
  InletProtectVerified: N
  InletProtectVerified_Notes: null
  unstuck_req: null
  UnstuckComp: N
  AssetGUID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• StormwaterDevice (0) -- Related To: Structures Requiring Inspection (39)