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

---

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

---

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

---

ID: 32
Name: Manhole
Domains:
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• shape_struct:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• spatialsource:
  Inherited
• lifecyclestatus:
  Inherited
• CMT_CAD_GIS:
  Inherited
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• material:
  Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• designtype:
  Coded Values: [0: Unknown] , [3: Solid] , [4: Vented/Slotted] , ...4 more...
• material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
• inletshape:
  Coded Values: [0: Unknown] , [3: Arched (with flat bottom)] , [4: Barrel] , ...9 more...
• isconnected:
  Inherited
• validationstatus:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• maintby:
  Inherited
• sw_system:
  Inherited
• ownedby:
  Inherited
• assettype:
  Inherited
• conetype:
  Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...
Templates:
• Name: Manhole
  Description:
  Prototype:
  cmt_proxy_year: null
  notes: null
  installdate: null
  ESRIGNSS_SPEED: null
  ESRIGNSS_HDOP: null
  InspectionID: null
  spatialsource: null
  year_final: null
  CMT_CAD_GIS: null
  ESRIGNSS_H_RMS: null
  ESRIGNSS_PDOP: null
  diameter: 0
  ESRIGNSS_NUMSATS: null
  ESRIGNSS_AVG_POSITIONS: null
  CNVYNAME: null
  ESRIGNSS_LONGITUDE: null
  ESRIGNSS_DIRECTION: null
  sw_system: null
  ESRIGNSS_AVG_H_RMS: null
  ownedby: 1
  MACP: null
  surface: 0
  shape_struct: 0
  ESRIGNSS_FIXDATETIME: null
  frame_type: null
  ESRIGNSS_AVG_V_RMS: null
  surfacewater: 0
  IDOT_survey_code: null
  designtype: 0
  length2: null
  inspectdate: null
  FOTH_DRAC_GIS: null
  ESRIGNSS_V_RMS: null
  ESRIGNSS_STATIONID: null
  add_et: null
  ESRIGNSS_RECEIVER: null
  conetype: 0
  ESRIGNSS_FIXTYPE: null
  distance_to_sub_w_year: null
  LoFMACP: null
  globalid: {00000000-0000-0000-0000-000000000000}
  ESRIGNSS_CORRECTIONAGE: null
  ESRIGNSS_H_STDDEV: null
  ESRIGNSS_POSITIONSOURCETYPE: null
  lifecyclestatus: 8
  surveydate: null
  FREQUENCY: null
  inletshape: 0
  near_address: null
  isconnected: 1
  validationstatus: null
  assettype: 9
  ESRIGNSS_VDOP: null
  elevation: null
  ESRIGNSS_ALTITUDE: null
  fg_diameter: null
  ESRIGNSS_LATITUDE: null
  StreetID: null
  Platt_year: null
  assetgroup: 32
  pipe_count: null
  MIN_year_built: null
  ESRISNSR_AZIMUTH: null
  depth: null
  material: 0
  bottom_elevation: null
  assetid: null
  width: null
  material_struct: 0
  location: 0
  maintby: 1
  fg_width: null
  cmt_proxy_bottomelev: null
  fg_length: 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 ( modelName: OBJECTID, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• notes ( modelName: notes, nullable: true, editable: true, defaultValue: N/A, length: 2000, alias: Notes, type: esriFieldTypeString )
• assetid ( modelName: assetid, nullable: true, editable: true, defaultValue: N/A, length: 64, alias: Structure ID, type: esriFieldTypeString )
• assetgroup ( modelName: assetgroup, nullable: true, editable: true, defaultValue: 0, alias: Asset group, type: esriFieldTypeInteger )
• assettype ( modelName: assettype, nullable: true, editable: true, defaultValue: 0, alias: Asset type, type: esriFieldTypeSmallInteger )
• designtype ( modelName: designtype, nullable: true, editable: true, defaultValue: N/A, alias: Type, type: esriFieldTypeSmallInteger )
• globalid ( modelName: globalid, nullable: true, editable: true, defaultValue: N/A, length: 38, alias: Global ID 2, type: esriFieldTypeString )
• unburied_req ( modelName: unburied_req, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: unburied_req, type: esriFieldTypeString )
• clean_req ( modelName: clean_req, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: clean_req, type: esriFieldTypeString )
• repair_req ( modelName: repair_req, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: repair_req, type: esriFieldTypeString )
• UnburiedComp ( modelName: UnburiedComp, nullable: true, editable: true, defaultValue: Buried, length: 255, alias: Unbury Completed, type: esriFieldTypeString , Coded Values: [Buried: Buried] , [UnableToLocate: Unable to Locate] , [Unburied: Unburied] , ...3 more... )
• UnburiedComp_Notes ( modelName: UnburiedComp_Notes, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Unbury Completion Notes, type: esriFieldTypeString )
• CleanComp ( modelName: CleanComp, nullable: true, editable: true, defaultValue: N, length: 255, alias: Cleaning Completed, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• CleanComp_Notes ( modelName: CleanComp_Notes, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Cleaning Completion Notes, type: esriFieldTypeString )
• RepairComp ( modelName: RepairComp, nullable: true, editable: true, defaultValue: N, length: 255, alias: Repair Completed, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• RepairComp_Notes ( modelName: RepairComp_Notes, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Repair Completion Notes, type: esriFieldTypeString )
• IllicitDischargeInsp ( modelName: IllicitDischargeInsp, nullable: true, editable: true, defaultValue: N, length: 255, alias: Illicit Discharge Inspected, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• IllicitDischargeInsp_Notes ( modelName: IllicitDischargeInsp_Notes, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Illicit Discharge Inspection Notes, type: esriFieldTypeString )
• InletProtectVerified ( modelName: InletProtectVerified, nullable: true, editable: true, defaultValue: N, length: 255, alias: Inlet Protection Verified, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• InletProtectVerified_Notes ( modelName: InletProtectVerified_Notes, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Inlet Protection Verification Notes, type: esriFieldTypeString )
• unstuck_req ( modelName: unstuck_req, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: unstuck_req, type: esriFieldTypeString )
• UnstuckComp ( modelName: UnstuckComp, nullable: true, editable: true, defaultValue: N, length: 255, alias: Unstuck Completed, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• UnstuckComp_Notes ( modelName: UnstuckComp_Notes, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Unstuck Completion Notes, type: esriFieldTypeString )
• AssetGUID ( modelName: AssetGUID, nullable: true, editable: true, defaultValue: N/A, length: 38, alias: Asset GUID, type: esriFieldTypeString )
Templates:
• Name: Structures To Be Inspected
  Description:
  Prototype:
  UnburiedComp: Buried
  UnstuckComp: N
  notes: null
  clean_req: null
  CleanComp_Notes: null
  RepairComp: N
  UnburiedComp_Notes: null
  InletProtectVerified: N
  globalid: null
  AssetGUID: null
  CleanComp: N
  assetgroup: 0
  InletProtectVerified_Notes: null
  unburied_req: null
  designtype: null
  assetid: null
  unstuck_req: null
  repair_req: null
  RepairComp_Notes: null
  IllicitDischargeInsp_Notes: null
  IllicitDischargeInsp: N
  UnstuckComp_Notes: null
  assettype: 0
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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