Layers:

Layer: Structures to be Unburied (39)

Name: Structures to be Unburied

Display Field: SDE.StormwaterDevice.CNVYNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 65ddec45826245fc8226c96c21c5a637

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 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: SDE.StructuresToBeInspected_20240213.UnburiedComp
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Buried
  Label: Buried
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: UnableToLocate
  Label: Unable To Locate
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [197, 0, 255, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Unburied
  Label: Unburied
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 170, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: UnburiedNeedRaised
  Label: Unburied, Needs Raised
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: UnburiedRaised
  Label: Unburied & Raised
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [85, 255, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
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: 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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SDE.StormwaterDevice.ASSETGROUP

Fields:
• SDE.StormwaterDevice.OBJECTID ( type: esriFieldTypeOID, alias: Object ID )
• SDE.StormwaterDevice.assetid ( type: esriFieldTypeString, alias: Structure ID, length: 64 )
• SDE.StormwaterDevice.IDOT_survey_code ( type: esriFieldTypeSmallInteger, alias: IDOT Survey Code )
• SDE.StormwaterDevice.assetgroup ( type: esriFieldTypeInteger, alias: Asset group )
• SDE.StormwaterDevice.surfacewater ( type: esriFieldTypeSmallInteger, alias: Receives Surface Water )
• SDE.StormwaterDevice.assettype ( type: esriFieldTypeSmallInteger, alias: Asset type , Coded Values: [0: Unknown] , [2: Diversion Manhole] , [3: Junction Manhole] , ...7 more... )
• SDE.StormwaterDevice.designtype ( type: esriFieldTypeSmallInteger, alias: Type )
• SDE.StormwaterDevice.add_et ( type: esriFieldTypeSmallInteger, alias: End Treatment Add. Type )
• SDE.StormwaterDevice.isconnected ( type: esriFieldTypeSmallInteger, alias: Is connected , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• SDE.StormwaterDevice.creationdate ( type: esriFieldTypeDate, alias: Creation date, length: 8 )
• SDE.StormwaterDevice.creator ( type: esriFieldTypeString, alias: Creator, length: 255 )
• SDE.StormwaterDevice.lastupdate ( type: esriFieldTypeDate, alias: Last update, length: 8 )
• SDE.StormwaterDevice.updatedby ( type: esriFieldTypeString, alias: Updated by, length: 255 )
• SDE.StormwaterDevice.globalid ( type: esriFieldTypeGUID, alias: Global ID 2, length: 38 )
• SDE.StormwaterDevice.material ( type: esriFieldTypeSmallInteger, alias: Material )
• SDE.StormwaterDevice.material_struct ( type: esriFieldTypeSmallInteger, alias: Inside Structure Material )
• SDE.StormwaterDevice.diameter ( type: esriFieldTypeDouble, alias: Diameter )
• SDE.StormwaterDevice.length2 ( type: esriFieldTypeDouble, alias: Length )
• SDE.StormwaterDevice.width ( type: esriFieldTypeDouble, alias: Width )
• SDE.StormwaterDevice.depth ( type: esriFieldTypeDouble, alias: Depth )
• SDE.StormwaterDevice.elevation ( type: esriFieldTypeDouble, alias: Elevation )
• SDE.StormwaterDevice.bottom_elevation ( type: esriFieldTypeDouble, alias: Bottom Elevation )
• SDE.StormwaterDevice.pipe_count ( type: esriFieldTypeSmallInteger, alias: Number of Pipes )
• SDE.StormwaterDevice.shape_struct ( type: esriFieldTypeSmallInteger, alias: Inside Strcture Shape )
• SDE.StormwaterDevice.notes ( type: esriFieldTypeString, alias: Notes, length: 2000 )
• SDE.StormwaterDevice.inletshape ( type: esriFieldTypeSmallInteger, alias: Inlet Shape )
• SDE.StormwaterDevice.validationstatus ( type: esriFieldTypeSmallInteger, alias: Validation status , 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... )
• SDE.StormwaterDevice.GlobalID_1 ( type: esriFieldTypeGlobalID, alias: Global ID, length: 38 )
• SDE.StormwaterDevice.conetype ( type: esriFieldTypeSmallInteger, alias: Cone type )
• SDE.StormwaterDevice.MACP ( type: esriFieldTypeDouble, alias: MACP score )
• SDE.StormwaterDevice.lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• SDE.StormwaterDevice.installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• SDE.StormwaterDevice.surveydate ( type: esriFieldTypeDate, alias: Survey Date, length: 8 )
• SDE.StormwaterDevice.inspectdate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• SDE.StormwaterDevice.CMT_CAD_GIS ( type: esriFieldTypeSmallInteger, alias: CMT_CAD_GIS , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• SDE.StormwaterDevice.frame_type ( type: esriFieldTypeString, alias: frame_type, length: 255 )
• SDE.StormwaterDevice.distance_to_sub_w_year ( type: esriFieldTypeDouble, alias: distance_to_sub_w_year )
• SDE.StormwaterDevice.CNVYNAME ( type: esriFieldTypeString, alias: 7!Subdivision Name, length: 250 )
• SDE.StormwaterDevice.FREQUENCY ( type: esriFieldTypeInteger, alias: FREQUENCY )
• SDE.StormwaterDevice.MIN_year_built ( type: esriFieldTypeDouble, alias: MIN_year_built )
• SDE.StormwaterDevice.Platt_year ( type: esriFieldTypeInteger, alias: Platt_year )
• SDE.StormwaterDevice.year_final ( type: esriFieldTypeString, alias: year_final, length: 255 )
• SDE.StormwaterDevice.LoFMACP ( type: esriFieldTypeSingle, alias: LoFMACP )
• SDE.StormwaterDevice.InspectionID ( type: esriFieldTypeInteger, alias: InspectionID )
• SDE.StormwaterDevice.cmt_proxy_year ( type: esriFieldTypeDate, alias: CMT Proxy Year, length: 8 )
• SDE.StormwaterDevice.near_address ( type: esriFieldTypeString, alias: Nearest Address, length: 255 )
• SDE.StormwaterDevice.location ( type: esriFieldTypeSmallInteger, alias: Structure Location )
• SDE.StormwaterDevice.surface ( type: esriFieldTypeSmallInteger, alias: Structure Surface Type )
• SDE.StormwaterDevice.spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
• SDE.StormwaterDevice.ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• SDE.StormwaterDevice.maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• SDE.StormwaterDevice.sw_system ( type: esriFieldTypeSmallInteger, alias: sw_system , Coded Values: [0: MS4] , [1: CSO] , [2: MS4-GI] , ...1 more... )
• SDE.StormwaterDevice.fg_length ( type: esriFieldTypeDouble, alias: Frame & Grate - Length )
• SDE.StormwaterDevice.fg_width ( type: esriFieldTypeDouble, alias: Frame & Grate - Width )
• SDE.StormwaterDevice.fg_diameter ( type: esriFieldTypeDouble, alias: Frame & Grate - Diameter )
• SDE.StormwaterDevice.StreetID ( type: esriFieldTypeString, alias: Street ID, length: 255 )
• SDE.StormwaterDevice.shape ( type: esriFieldTypeGeometry, alias: Shape )
• SDE.StormwaterDevice.cmt_proxy_bottomelev ( type: esriFieldTypeDouble, alias: CMT Proxy Bottom Elevation )
• SDE.StormwaterDevice.FOTH_DRAC_GIS ( type: esriFieldTypeSmallInteger, alias: FOTH_DRAC_GIS , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• SDE.StormwaterDevice.ESRIGNSS_POSITIONSOURCETYPE ( type: esriFieldTypeSmallInteger, alias: Position source type , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...3 more... )
• SDE.StormwaterDevice.ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, length: 50 )
• SDE.StormwaterDevice.ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• SDE.StormwaterDevice.ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• SDE.StormwaterDevice.ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude )
• SDE.StormwaterDevice.ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m) )
• SDE.StormwaterDevice.ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m) )
• SDE.StormwaterDevice.ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, length: 8 )
• SDE.StormwaterDevice.ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• SDE.StormwaterDevice.ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age )
• SDE.StormwaterDevice.ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID , Range: [0, 1023] )
• SDE.StormwaterDevice.ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites , Range: [0, 99] )
• SDE.StormwaterDevice.ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP )
• SDE.StormwaterDevice.ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP )
• SDE.StormwaterDevice.ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP )
• SDE.StormwaterDevice.ESRIGNSS_DIRECTION ( type: esriFieldTypeDouble, alias: Direction of travel (°) )
• SDE.StormwaterDevice.ESRIGNSS_SPEED ( type: esriFieldTypeDouble, alias: Speed (km/h) )
• SDE.StormwaterDevice.ESRISNSR_AZIMUTH ( type: esriFieldTypeDouble, alias: Compass reading (°) )
• SDE.StormwaterDevice.ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m) )
• SDE.StormwaterDevice.ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m) )
• SDE.StormwaterDevice.ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeSmallInteger, alias: Averaged Positions )
• SDE.StormwaterDevice.ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m) )
• SDE.StructuresToBeInspected_20240213.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• SDE.StructuresToBeInspected_20240213.notes ( type: esriFieldTypeString, alias: Notes, length: 2000 )
• SDE.StructuresToBeInspected_20240213.assetid ( type: esriFieldTypeString, alias: Structure ID, length: 64 )
• SDE.StructuresToBeInspected_20240213.IDOT_survey_code ( type: esriFieldTypeSmallInteger, alias: IDOT Survey Code )
• SDE.StructuresToBeInspected_20240213.assetgroup ( type: esriFieldTypeInteger, alias: Asset group )
• SDE.StructuresToBeInspected_20240213.assettype ( type: esriFieldTypeSmallInteger, alias: Asset type )
• SDE.StructuresToBeInspected_20240213.designtype ( type: esriFieldTypeSmallInteger, alias: Type )
• SDE.StructuresToBeInspected_20240213.material ( type: esriFieldTypeSmallInteger, alias: F&G/Cover/Other Material )
• SDE.StructuresToBeInspected_20240213.inletshape ( type: esriFieldTypeSmallInteger, alias: F&G/Cover/Other Shape )
• SDE.StructuresToBeInspected_20240213.material_struct ( type: esriFieldTypeSmallInteger, alias: Structure Material )
• SDE.StructuresToBeInspected_20240213.shape_struct ( type: esriFieldTypeSmallInteger, alias: Strcture Shape )
• SDE.StructuresToBeInspected_20240213.diameter ( type: esriFieldTypeDouble, alias: Diameter )
• SDE.StructuresToBeInspected_20240213.length2 ( type: esriFieldTypeDouble, alias: Length )
• SDE.StructuresToBeInspected_20240213.width ( type: esriFieldTypeDouble, alias: Width )
• SDE.StructuresToBeInspected_20240213.depth ( type: esriFieldTypeDouble, alias: Depth )
• SDE.StructuresToBeInspected_20240213.elevation ( type: esriFieldTypeDouble, alias: Rim Elevation )
• SDE.StructuresToBeInspected_20240213.bottom_elevation ( type: esriFieldTypeDouble, alias: Bottom Elevation )
• SDE.StructuresToBeInspected_20240213.pipe_count ( type: esriFieldTypeSmallInteger, alias: Number of Pipes )
• SDE.StructuresToBeInspected_20240213.surfacewater ( type: esriFieldTypeSmallInteger, alias: Receives Surface Water )
• SDE.StructuresToBeInspected_20240213.conetype ( type: esriFieldTypeSmallInteger, alias: Cone type )
• SDE.StructuresToBeInspected_20240213.MACP ( type: esriFieldTypeDouble, alias: MACP score )
• SDE.StructuresToBeInspected_20240213.location ( type: esriFieldTypeSmallInteger, alias: Structure Location )
• SDE.StructuresToBeInspected_20240213.surface ( type: esriFieldTypeSmallInteger, alias: Structure Surface Type )
• SDE.StructuresToBeInspected_20240213.spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source )
• SDE.StructuresToBeInspected_20240213.isconnected ( type: esriFieldTypeSmallInteger, alias: Is connected )
• SDE.StructuresToBeInspected_20240213.lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status )
• SDE.StructuresToBeInspected_20240213.installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• SDE.StructuresToBeInspected_20240213.surveydate ( type: esriFieldTypeDate, alias: Survey Date, length: 8 )
• SDE.StructuresToBeInspected_20240213.inspectdate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• SDE.StructuresToBeInspected_20240213.validationstatus ( type: esriFieldTypeSmallInteger, alias: Validation status )
• SDE.StructuresToBeInspected_20240213.ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By )
• SDE.StructuresToBeInspected_20240213.maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By )
• SDE.StructuresToBeInspected_20240213.creationdate ( type: esriFieldTypeDate, alias: Creation date, length: 8 )
• SDE.StructuresToBeInspected_20240213.creator ( type: esriFieldTypeString, alias: Creator, length: 255 )
• SDE.StructuresToBeInspected_20240213.lastupdate ( type: esriFieldTypeDate, alias: Last update, length: 8 )
• SDE.StructuresToBeInspected_20240213.updatedby ( type: esriFieldTypeString, alias: Updated by, length: 255 )
• SDE.StructuresToBeInspected_20240213.globalid ( type: esriFieldTypeString, alias: Global ID 2, length: 38 )
• SDE.StructuresToBeInspected_20240213.CMT_CAD_GIS ( type: esriFieldTypeSmallInteger, alias: CMT CAD-GIS (Y/N) )
• SDE.StructuresToBeInspected_20240213.exist_note ( type: esriFieldTypeString, alias: exist_note, length: 1 )
• SDE.StructuresToBeInspected_20240213.no_inverts ( type: esriFieldTypeString, alias: no_inverts, length: 1 )
• SDE.StructuresToBeInspected_20240213.survey_req ( type: esriFieldTypeString, alias: survey_req, length: 1 )
• SDE.StructuresToBeInspected_20240213.verification_req ( type: esriFieldTypeString, alias: verification_req, length: 1 )
• SDE.StructuresToBeInspected_20240213.unburied_req ( type: esriFieldTypeString, alias: unburied_req, length: 1 )
• SDE.StructuresToBeInspected_20240213.prev_maint ( type: esriFieldTypeString, alias: prev_maint, length: 1 )
• SDE.StructuresToBeInspected_20240213.verif_missing_attribs ( type: esriFieldTypeString, alias: verif_missing_attribs, length: 1 )
• SDE.StructuresToBeInspected_20240213.verif_geom_connec ( type: esriFieldTypeString, alias: verif_geom_connec, length: 255 )
• SDE.StructuresToBeInspected_20240213.illicit_discharge ( type: esriFieldTypeString, alias: illicit_discharge, length: 1 )
• SDE.StructuresToBeInspected_20240213.clean_req ( type: esriFieldTypeString, alias: clean_req, length: 1 )
• SDE.StructuresToBeInspected_20240213.repair_req ( type: esriFieldTypeString, alias: repair_req, length: 1 )
• SDE.StructuresToBeInspected_20240213.verify_inlet_protect ( type: esriFieldTypeString, alias: verify_inlet_protect, length: 1 )
• SDE.StructuresToBeInspected_20240213.DuplicateReview ( type: esriFieldTypeInteger, alias: DuplicateReview )
• SDE.StructuresToBeInspected_20240213.UnburiedComp ( type: esriFieldTypeString, alias: Unbury Completed, length: 255 , Coded Values: [Buried: Buried] , [UnableToLocate: Unable to Locate] , [Unburied: Unburied] , ...3 more... )
• SDE.StructuresToBeInspected_20240213.UnburiedComp_Notes ( type: esriFieldTypeString, alias: Unbury Completion Notes, length: 255 )
• SDE.StructuresToBeInspected_20240213.CleanComp ( type: esriFieldTypeString, alias: Cleaning Completed, length: 255 , Coded Values: [Y: Yes] , [N: No] )
• SDE.StructuresToBeInspected_20240213.CleanComp_Notes ( type: esriFieldTypeString, alias: Cleaning Completion Notes, length: 255 )
• SDE.StructuresToBeInspected_20240213.RepairComp ( type: esriFieldTypeString, alias: Repair Completed, length: 255 , Coded Values: [Y: Yes] , [N: No] )
• SDE.StructuresToBeInspected_20240213.RepairComp_Notes ( type: esriFieldTypeString, alias: Repair Completion Notes, length: 255 )
• SDE.StructuresToBeInspected_20240213.IllicitDischargeInsp ( type: esriFieldTypeString, alias: Illicit Discharge Inspected, length: 255 , Coded Values: [Y: Yes] , [N: No] )
• SDE.StructuresToBeInspected_20240213.IllicitDischargeInsp_Notes ( type: esriFieldTypeString, alias: Illicit Discharge Inspection Notes, length: 255 )
• SDE.StructuresToBeInspected_20240213.InletProtectVerified ( type: esriFieldTypeString, alias: Inlet Protection Verified, length: 255 , Coded Values: [Y: Yes] , [N: No] )
• SDE.StructuresToBeInspected_20240213.InletProtectVerified_Notes ( type: esriFieldTypeString, alias: Inlet Protection Verification Notes, length: 255 )
• SDE.StructuresToBeInspected_20240213.unstuck_req ( type: esriFieldTypeString, alias: unstuck_req, length: 1 )
• SDE.StructuresToBeInspected_20240213.UnstuckComp ( type: esriFieldTypeString, alias: Unstuck Completed, length: 255 , Coded Values: [Y: Yes] , [N: No] )
• SDE.StructuresToBeInspected_20240213.UnstuckComp_Notes ( type: esriFieldTypeString, alias: Unstuck Completion Notes, length: 255 )
• SDE.StructuresToBeInspected_20240213.AssetGUID ( type: esriFieldTypeString, alias: Asset GUID, length: 38 )
Types:
ID: 0
Name: Unknown
Domains:
• SDE.StormwaterDevice.assettype:
  Coded Values: [0: Unknown]
• SDE.StormwaterDevice.isconnected:
  Inherited
• SDE.StormwaterDevice.validationstatus:
  Inherited
• SDE.StormwaterDevice.CMT_CAD_GIS:
  Inherited
• SDE.StormwaterDevice.sw_system:
  Inherited
• SDE.StructuresToBeInspected_20240213.assettype:
  Coded Values: [0: Unknown]
• SDE.StructuresToBeInspected_20240213.isconnected:
  Coded Values: [0: False] , [1: True] , [2: Unknown]
• SDE.StructuresToBeInspected_20240213.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...
• SDE.StructuresToBeInspected_20240213.CMT_CAD_GIS:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

ID: 5
Name: Pump
Domains:
• SDE.StormwaterDevice.assettype:
  Coded Values: [0: Unknown] , [61: Pump]
• SDE.StormwaterDevice.isconnected:
  Inherited
• SDE.StormwaterDevice.ownedby:
  Inherited
• SDE.StormwaterDevice.maintby:
  Inherited
• SDE.StormwaterDevice.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StormwaterDevice.spatialsource:
  Inherited
• SDE.StormwaterDevice.designtype:
  Coded Values: [0: Unknown] , [1: Centerfugal Pump] , [2: Duplex Pump] , ...4 more...
• SDE.StormwaterDevice.validationstatus:
  Inherited
• SDE.StormwaterDevice.CMT_CAD_GIS:
  Inherited
• SDE.StormwaterDevice.sw_system:
  Inherited
• SDE.StructuresToBeInspected_20240213.assettype:
  Coded Values: [0: Unknown] , [61: Pump]
• SDE.StructuresToBeInspected_20240213.designtype:
  Coded Values: [0: Unknown] , [1: Centerfugal Pump] , [2: Duplex Pump] , ...4 more...
• SDE.StructuresToBeInspected_20240213.spatialsource:
  Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more...
• SDE.StructuresToBeInspected_20240213.isconnected:
  Coded Values: [0: False] , [1: True] , [2: Unknown]
• SDE.StructuresToBeInspected_20240213.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StructuresToBeInspected_20240213.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...
• SDE.StructuresToBeInspected_20240213.ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.CMT_CAD_GIS:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

ID: 26
Name: Weir
Domains:
• SDE.StormwaterDevice.assettype:
  Coded Values: [0: Unknown] , [281: Broad-Crested] , [282: Combination] , ...4 more...
• SDE.StormwaterDevice.isconnected:
  Inherited
• SDE.StormwaterDevice.ownedby:
  Inherited
• SDE.StormwaterDevice.maintby:
  Inherited
• SDE.StormwaterDevice.material:
  Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
• SDE.StormwaterDevice.surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• SDE.StormwaterDevice.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StormwaterDevice.spatialsource:
  Inherited
• SDE.StormwaterDevice.validationstatus:
  Inherited
• SDE.StormwaterDevice.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StormwaterDevice.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StormwaterDevice.shape_struct:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• SDE.StormwaterDevice.material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
• SDE.StormwaterDevice.CMT_CAD_GIS:
  Inherited
• SDE.StormwaterDevice.sw_system:
  Inherited
• SDE.StructuresToBeInspected_20240213.assettype:
  Coded Values: [0: Unknown] , [281: Broad-Crested] , [282: Combination] , ...4 more...
• SDE.StructuresToBeInspected_20240213.material:
  Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
• SDE.StructuresToBeInspected_20240213.material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
• SDE.StructuresToBeInspected_20240213.shape_struct:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• SDE.StructuresToBeInspected_20240213.surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• SDE.StructuresToBeInspected_20240213.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StructuresToBeInspected_20240213.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StructuresToBeInspected_20240213.spatialsource:
  Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more...
• SDE.StructuresToBeInspected_20240213.isconnected:
  Coded Values: [0: False] , [1: True] , [2: Unknown]
• SDE.StructuresToBeInspected_20240213.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StructuresToBeInspected_20240213.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...
• SDE.StructuresToBeInspected_20240213.ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.CMT_CAD_GIS:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

ID: 21
Name: Cleanout
Domains:
• SDE.StormwaterDevice.assettype:
  Coded Values: [0: Unknown] , [1: Cleanout]
• SDE.StormwaterDevice.isconnected:
  Inherited
• SDE.StormwaterDevice.ownedby:
  Inherited
• SDE.StormwaterDevice.maintby:
  Inherited
• SDE.StormwaterDevice.diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more...
• SDE.StormwaterDevice.material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...24 more...
• SDE.StormwaterDevice.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StormwaterDevice.spatialsource:
  Inherited
• SDE.StormwaterDevice.validationstatus:
  Inherited
• SDE.StormwaterDevice.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StormwaterDevice.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StormwaterDevice.CMT_CAD_GIS:
  Inherited
• SDE.StormwaterDevice.sw_system:
  Inherited
• SDE.StructuresToBeInspected_20240213.assettype:
  Coded Values: [0: Unknown] , [1: Cleanout]
• SDE.StructuresToBeInspected_20240213.material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...24 more...
• SDE.StructuresToBeInspected_20240213.diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more...
• SDE.StructuresToBeInspected_20240213.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StructuresToBeInspected_20240213.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StructuresToBeInspected_20240213.spatialsource:
  Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more...
• SDE.StructuresToBeInspected_20240213.isconnected:
  Coded Values: [0: False] , [1: True] , [2: Unknown]
• SDE.StructuresToBeInspected_20240213.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StructuresToBeInspected_20240213.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...
• SDE.StructuresToBeInspected_20240213.ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.CMT_CAD_GIS:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

ID: 29
Name: BMP Point
Domains:
• SDE.StormwaterDevice.assettype:
  Coded Values: [0: Unknown] , [2: Detention Basin] , [3: Dry Basin] , ...15 more...
• SDE.StormwaterDevice.isconnected:
  Inherited
• SDE.StormwaterDevice.ownedby:
  Inherited
• SDE.StormwaterDevice.maintby:
  Inherited
• SDE.StormwaterDevice.material:
  Coded Values: [0: Unknown] , [1: Amended Soil] , [2: Biochar] , ...13 more...
• SDE.StormwaterDevice.surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• SDE.StormwaterDevice.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StormwaterDevice.spatialsource:
  Inherited
• SDE.StormwaterDevice.validationstatus:
  Inherited
• SDE.StormwaterDevice.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StormwaterDevice.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StormwaterDevice.material_struct:
  Coded Values: [0: Unknown] , [1: Amended Soil] , [2: Biochar] , ...13 more...
• SDE.StormwaterDevice.CMT_CAD_GIS:
  Inherited
• SDE.StormwaterDevice.sw_system:
  Inherited
• SDE.StructuresToBeInspected_20240213.assettype:
  Coded Values: [0: Unknown] , [2: Detention Basin] , [3: Dry Basin] , ...15 more...
• SDE.StructuresToBeInspected_20240213.material:
  Coded Values: [0: Unknown] , [1: Amended Soil] , [2: Biochar] , ...13 more...
• SDE.StructuresToBeInspected_20240213.material_struct:
  Coded Values: [0: Unknown] , [1: Amended Soil] , [2: Biochar] , ...13 more...
• SDE.StructuresToBeInspected_20240213.surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• SDE.StructuresToBeInspected_20240213.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StructuresToBeInspected_20240213.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StructuresToBeInspected_20240213.spatialsource:
  Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more...
• SDE.StructuresToBeInspected_20240213.isconnected:
  Coded Values: [0: False] , [1: True] , [2: Unknown]
• SDE.StructuresToBeInspected_20240213.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StructuresToBeInspected_20240213.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...
• SDE.StructuresToBeInspected_20240213.ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.CMT_CAD_GIS:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

ID: 30
Name: BMP Inlet
Domains:
• SDE.StormwaterDevice.assettype:
  Coded Values: [0: Unknown] , [6: Apron Inlet] , [7: Pipe Inlet] , ...1 more...
• SDE.StormwaterDevice.isconnected:
  Inherited
• SDE.StormwaterDevice.ownedby:
  Inherited
• SDE.StormwaterDevice.maintby:
  Inherited
• SDE.StormwaterDevice.diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• SDE.StormwaterDevice.material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...25 more...
• SDE.StormwaterDevice.surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• SDE.StormwaterDevice.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StormwaterDevice.spatialsource:
  Inherited
• SDE.StormwaterDevice.designtype:
  Coded Values: [0: Unknown] , [9: Tide Gate Chamber] , [11: Flap Gate] , ...5 more...
• SDE.StormwaterDevice.validationstatus:
  Inherited
• SDE.StormwaterDevice.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StormwaterDevice.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StormwaterDevice.CMT_CAD_GIS:
  Inherited
• SDE.StormwaterDevice.sw_system:
  Inherited
• SDE.StructuresToBeInspected_20240213.assettype:
  Coded Values: [0: Unknown] , [6: Apron Inlet] , [7: Pipe Inlet] , ...1 more...
• SDE.StructuresToBeInspected_20240213.designtype:
  Coded Values: [0: Unknown] , [9: Tide Gate Chamber] , [11: Flap Gate] , ...5 more...
• SDE.StructuresToBeInspected_20240213.material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...25 more...
• SDE.StructuresToBeInspected_20240213.diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• SDE.StructuresToBeInspected_20240213.surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• SDE.StructuresToBeInspected_20240213.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StructuresToBeInspected_20240213.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StructuresToBeInspected_20240213.spatialsource:
  Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more...
• SDE.StructuresToBeInspected_20240213.isconnected:
  Coded Values: [0: False] , [1: True] , [2: Unknown]
• SDE.StructuresToBeInspected_20240213.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StructuresToBeInspected_20240213.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...
• SDE.StructuresToBeInspected_20240213.ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.CMT_CAD_GIS:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

ID: 23
Name: Connection
Domains:
• SDE.StormwaterDevice.assettype:
  Coded Values: [0: Unknown] , [241: Pipe Connection] , [242: Open Channel Connection] , ...1 more...
• SDE.StormwaterDevice.isconnected:
  Inherited
• SDE.StormwaterDevice.ownedby:
  Inherited
• SDE.StormwaterDevice.maintby:
  Inherited
• SDE.StormwaterDevice.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StormwaterDevice.spatialsource:
  Inherited
• SDE.StormwaterDevice.validationstatus:
  Inherited
• SDE.StormwaterDevice.CMT_CAD_GIS:
  Inherited
• SDE.StormwaterDevice.sw_system:
  Inherited
• SDE.StructuresToBeInspected_20240213.assettype:
  Coded Values: [0: Unknown] , [241: Pipe Connection] , [242: Open Channel Connection] , ...1 more...
• SDE.StructuresToBeInspected_20240213.spatialsource:
  Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more...
• SDE.StructuresToBeInspected_20240213.isconnected:
  Coded Values: [0: False] , [1: True] , [2: Unknown]
• SDE.StructuresToBeInspected_20240213.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StructuresToBeInspected_20240213.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...
• SDE.StructuresToBeInspected_20240213.ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.CMT_CAD_GIS:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

ID: 32
Name: Manhole
Domains:
• SDE.StormwaterDevice.assettype:
  Inherited
• SDE.StormwaterDevice.isconnected:
  Inherited
• SDE.StormwaterDevice.ownedby:
  Inherited
• SDE.StormwaterDevice.maintby:
  Inherited
• SDE.StormwaterDevice.diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• SDE.StormwaterDevice.material:
  Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
• SDE.StormwaterDevice.surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• SDE.StormwaterDevice.lifecyclestatus:
  Inherited
• SDE.StormwaterDevice.spatialsource:
  Inherited
• SDE.StormwaterDevice.designtype:
  Coded Values: [0: Unknown] , [3: Solid] , [4: Vented/Slotted] , ...4 more...
• SDE.StormwaterDevice.inletshape:
  Coded Values: [0: Unknown] , [3: Arched (with flat bottom)] , [4: Barrel] , ...9 more...
• SDE.StormwaterDevice.validationstatus:
  Inherited
• SDE.StormwaterDevice.conetype:
  Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...
• SDE.StormwaterDevice.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StormwaterDevice.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StormwaterDevice.shape_struct:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• SDE.StormwaterDevice.material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
• SDE.StormwaterDevice.CMT_CAD_GIS:
  Inherited
• SDE.StormwaterDevice.sw_system:
  Inherited
• SDE.StructuresToBeInspected_20240213.assettype:
  Coded Values: [0: Unknown] , [2: Diversion Manhole] , [3: Junction Manhole] , ...7 more...
• SDE.StructuresToBeInspected_20240213.designtype:
  Coded Values: [0: Unknown] , [3: Solid] , [4: Vented/Slotted] , ...4 more...
• SDE.StructuresToBeInspected_20240213.material:
  Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
• SDE.StructuresToBeInspected_20240213.inletshape:
  Coded Values: [0: Unknown] , [3: Arched (with flat bottom)] , [4: Barrel] , ...9 more...
• SDE.StructuresToBeInspected_20240213.material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
• SDE.StructuresToBeInspected_20240213.shape_struct:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• SDE.StructuresToBeInspected_20240213.diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• SDE.StructuresToBeInspected_20240213.surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• SDE.StructuresToBeInspected_20240213.conetype:
  Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...
• SDE.StructuresToBeInspected_20240213.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StructuresToBeInspected_20240213.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StructuresToBeInspected_20240213.spatialsource:
  Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more...
• SDE.StructuresToBeInspected_20240213.isconnected:
  Coded Values: [0: False] , [1: True] , [2: Unknown]
• SDE.StructuresToBeInspected_20240213.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more...
• SDE.StructuresToBeInspected_20240213.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...
• SDE.StructuresToBeInspected_20240213.ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.CMT_CAD_GIS:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

ID: 28
Name: Inlet
Domains:
• SDE.StormwaterDevice.assettype:
  Coded Values: [0: Unknown] , [204: Infiltration] , [210: Drop Inlet] , ...1 more...
• SDE.StormwaterDevice.isconnected:
  Inherited
• SDE.StormwaterDevice.ownedby:
  Inherited
• SDE.StormwaterDevice.maintby:
  Inherited
• SDE.StormwaterDevice.diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• SDE.StormwaterDevice.material:
  Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
• SDE.StormwaterDevice.surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• SDE.StormwaterDevice.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StormwaterDevice.spatialsource:
  Inherited
• SDE.StormwaterDevice.designtype:
  Coded Values: [0: Unknown] , [1: Curb Opening] , [2: Grate] , ...1 more...
• SDE.StormwaterDevice.inletshape:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• SDE.StormwaterDevice.validationstatus:
  Inherited
• SDE.StormwaterDevice.conetype:
  Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...
• SDE.StormwaterDevice.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StormwaterDevice.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StormwaterDevice.shape_struct:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• SDE.StormwaterDevice.material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
• SDE.StormwaterDevice.CMT_CAD_GIS:
  Inherited
• SDE.StormwaterDevice.sw_system:
  Inherited
• SDE.StructuresToBeInspected_20240213.assettype:
  Coded Values: [0: Unknown] , [204: Infiltration] , [210: Drop Inlet] , ...1 more...
• SDE.StructuresToBeInspected_20240213.designtype:
  Coded Values: [0: Unknown] , [1: Curb Opening] , [2: Grate] , ...1 more...
• SDE.StructuresToBeInspected_20240213.material:
  Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
• SDE.StructuresToBeInspected_20240213.inletshape:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• SDE.StructuresToBeInspected_20240213.material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
• SDE.StructuresToBeInspected_20240213.shape_struct:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• SDE.StructuresToBeInspected_20240213.diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• SDE.StructuresToBeInspected_20240213.surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• SDE.StructuresToBeInspected_20240213.conetype:
  Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...
• SDE.StructuresToBeInspected_20240213.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StructuresToBeInspected_20240213.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StructuresToBeInspected_20240213.spatialsource:
  Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more...
• SDE.StructuresToBeInspected_20240213.isconnected:
  Coded Values: [0: False] , [1: True] , [2: Unknown]
• SDE.StructuresToBeInspected_20240213.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StructuresToBeInspected_20240213.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...
• SDE.StructuresToBeInspected_20240213.ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.CMT_CAD_GIS:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

ID: 33
Name: Turn-down 90
Domains:
• SDE.StormwaterDevice.isconnected:
  Inherited
• SDE.StormwaterDevice.ownedby:
  Inherited
• SDE.StormwaterDevice.maintby:
  Inherited
• SDE.StormwaterDevice.lifecyclestatus:
  Inherited
• SDE.StormwaterDevice.spatialsource:
  Inherited
• SDE.StormwaterDevice.validationstatus:
  Inherited
• SDE.StormwaterDevice.CMT_CAD_GIS:
  Inherited
• SDE.StormwaterDevice.sw_system:
  Inherited
• SDE.StructuresToBeInspected_20240213.spatialsource:
  Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more...
• SDE.StructuresToBeInspected_20240213.isconnected:
  Coded Values: [0: False] , [1: True] , [2: Unknown]
• SDE.StructuresToBeInspected_20240213.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more...
• SDE.StructuresToBeInspected_20240213.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...
• SDE.StructuresToBeInspected_20240213.ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.CMT_CAD_GIS:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

ID: 22
Name: End Treatment
Domains:
• SDE.StormwaterDevice.assettype:
  Coded Values: [0: Unknown] , [3: Culvert Inlet] , [4: Culvert Outlet] , ...2 more...
• SDE.StormwaterDevice.isconnected:
  Inherited
• SDE.StormwaterDevice.ownedby:
  Inherited
• SDE.StormwaterDevice.maintby:
  Inherited
• SDE.StormwaterDevice.diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• SDE.StormwaterDevice.material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...25 more...
• SDE.StormwaterDevice.surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• SDE.StormwaterDevice.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StormwaterDevice.spatialsource:
  Inherited
• SDE.StormwaterDevice.designtype:
  Coded Values: [0: Unknown] , [9: Tide Gate Chamber] , [11: Flap Gate] , ...5 more...
• SDE.StormwaterDevice.validationstatus:
  Inherited
• SDE.StormwaterDevice.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StormwaterDevice.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StormwaterDevice.CMT_CAD_GIS:
  Inherited
• SDE.StormwaterDevice.sw_system:
  Inherited
• SDE.StormwaterDevice.add_et:
  Coded Values: [0: N/A] , [1: Flap Gate] , [2: Apron] , ...4 more...
• SDE.StructuresToBeInspected_20240213.assettype:
  Coded Values: [0: Unknown] , [3: Culvert Inlet] , [4: Culvert Outlet] , ...2 more...
• SDE.StructuresToBeInspected_20240213.designtype:
  Coded Values: [0: Unknown] , [9: Tide Gate Chamber] , [11: Flap Gate] , ...5 more...
• SDE.StructuresToBeInspected_20240213.material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...25 more...
• SDE.StructuresToBeInspected_20240213.diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• SDE.StructuresToBeInspected_20240213.surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• SDE.StructuresToBeInspected_20240213.location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• SDE.StructuresToBeInspected_20240213.surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• SDE.StructuresToBeInspected_20240213.spatialsource:
  Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more...
• SDE.StructuresToBeInspected_20240213.isconnected:
  Coded Values: [0: False] , [1: True] , [2: Unknown]
• SDE.StructuresToBeInspected_20240213.lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• SDE.StructuresToBeInspected_20240213.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...
• SDE.StructuresToBeInspected_20240213.ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• SDE.StructuresToBeInspected_20240213.CMT_CAD_GIS:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]

---

Relationships:

• StructuresToBeInspected_20240213 (0) -- Related To: SDE.StructuresToBeInspected_20240213 (40)

Tables:

Table: SDE.StructuresToBeInspected_20240213 (40)

Name: SDE.StructuresToBeInspected_20240213

Display Field: notes

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 65ddec45826245fc8226c96c21c5a637

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: 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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• notes ( type: esriFieldTypeString, alias: Notes, length: 2000 )
• assetid ( type: esriFieldTypeString, alias: Structure ID, length: 64 )
• IDOT_survey_code ( type: esriFieldTypeSmallInteger, alias: IDOT Survey Code )
• assetgroup ( type: esriFieldTypeInteger, alias: Asset group )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset type )
• designtype ( type: esriFieldTypeSmallInteger, alias: Type )
• material ( type: esriFieldTypeSmallInteger, alias: F&G/Cover/Other Material )
• inletshape ( type: esriFieldTypeSmallInteger, alias: F&G/Cover/Other Shape )
• material_struct ( type: esriFieldTypeSmallInteger, alias: Structure Material )
• shape_struct ( type: esriFieldTypeSmallInteger, alias: Strcture Shape )
• diameter ( type: esriFieldTypeDouble, alias: Diameter )
• length2 ( type: esriFieldTypeDouble, alias: Length )
• width ( type: esriFieldTypeDouble, alias: Width )
• depth ( type: esriFieldTypeDouble, alias: Depth )
• elevation ( type: esriFieldTypeDouble, alias: Rim Elevation )
• bottom_elevation ( type: esriFieldTypeDouble, alias: Bottom Elevation )
• pipe_count ( type: esriFieldTypeSmallInteger, alias: Number of Pipes )
• surfacewater ( type: esriFieldTypeSmallInteger, alias: Receives Surface Water )
• conetype ( type: esriFieldTypeSmallInteger, alias: Cone type )
• MACP ( type: esriFieldTypeDouble, alias: MACP score )
• location ( type: esriFieldTypeSmallInteger, alias: Structure Location )
• surface ( type: esriFieldTypeSmallInteger, alias: Structure Surface Type )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source )
• isconnected ( type: esriFieldTypeSmallInteger, alias: Is connected )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status )
• installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• surveydate ( type: esriFieldTypeDate, alias: Survey Date, length: 8 )
• inspectdate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• validationstatus ( type: esriFieldTypeSmallInteger, alias: Validation status )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By )
• 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 )
• globalid ( type: esriFieldTypeString, alias: Global ID 2, length: 38 )
• CMT_CAD_GIS ( type: esriFieldTypeSmallInteger, alias: CMT CAD-GIS (Y/N) )
• exist_note ( type: esriFieldTypeString, alias: exist_note, length: 1 )
• no_inverts ( type: esriFieldTypeString, alias: no_inverts, length: 1 )
• survey_req ( type: esriFieldTypeString, alias: survey_req, length: 1 )
• verification_req ( type: esriFieldTypeString, alias: verification_req, length: 1 )
• unburied_req ( type: esriFieldTypeString, alias: unburied_req, length: 1 )
• prev_maint ( type: esriFieldTypeString, alias: prev_maint, length: 1 )
• verif_missing_attribs ( type: esriFieldTypeString, alias: verif_missing_attribs, length: 1 )
• verif_geom_connec ( type: esriFieldTypeString, alias: verif_geom_connec, length: 255 )
• illicit_discharge ( type: esriFieldTypeString, alias: illicit_discharge, length: 1 )
• clean_req ( type: esriFieldTypeString, alias: clean_req, length: 1 )
• repair_req ( type: esriFieldTypeString, alias: repair_req, length: 1 )
• verify_inlet_protect ( type: esriFieldTypeString, alias: verify_inlet_protect, length: 1 )
• DuplicateReview ( type: esriFieldTypeInteger, alias: DuplicateReview )
• UnburiedComp ( type: esriFieldTypeString, alias: Unbury Completed, length: 255 , Coded Values: [Buried: Buried] , [UnableToLocate: Unable to Locate] , [Unburied: Unburied] , ...3 more... )
• UnburiedComp_Notes ( type: esriFieldTypeString, alias: Unbury Completion Notes, length: 255 )
• CleanComp ( type: esriFieldTypeString, alias: Cleaning Completed, length: 255 , Coded Values: [Y: Yes] , [N: No] )
• CleanComp_Notes ( type: esriFieldTypeString, alias: Cleaning Completion Notes, length: 255 )
• RepairComp ( type: esriFieldTypeString, alias: Repair Completed, length: 255 , Coded Values: [Y: Yes] , [N: No] )
• RepairComp_Notes ( type: esriFieldTypeString, alias: Repair Completion Notes, length: 255 )
• IllicitDischargeInsp ( type: esriFieldTypeString, alias: Illicit Discharge Inspected, length: 255 , Coded Values: [Y: Yes] , [N: No] )
• IllicitDischargeInsp_Notes ( type: esriFieldTypeString, alias: Illicit Discharge Inspection Notes, length: 255 )
• InletProtectVerified ( type: esriFieldTypeString, alias: Inlet Protection Verified, length: 255 , Coded Values: [Y: Yes] , [N: No] )
• InletProtectVerified_Notes ( type: esriFieldTypeString, alias: Inlet Protection Verification Notes, length: 255 )
• unstuck_req ( type: esriFieldTypeString, alias: unstuck_req, length: 1 )
• UnstuckComp ( type: esriFieldTypeString, alias: Unstuck Completed, length: 255 , Coded Values: [Y: Yes] , [N: No] )
• UnstuckComp_Notes ( type: esriFieldTypeString, alias: Unstuck Completion Notes, length: 255 )
• AssetGUID ( type: esriFieldTypeString, alias: Asset GUID, length: 38 )

Relationships:

• StormwaterDevice (0) -- Related To: Structures to be Unburied (39)