20231205 08015600 1.0 FALSE SDE_JDK_add_structures_reviewing_12_4_23 002 Projected GCS_NAD_1983_2011 Linear Unit: Foot_US (0.304801) NAD_1983_2011_StatePlane_Illinois_West_FIPS_1202_Ft_US <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WKT>PROJCS[&quot;NAD_1983_2011_StatePlane_Illinois_West_FIPS_1202_Ft_US&quot;,GEOGCS[&quot;GCS_NAD_1983_2011&quot;,DATUM[&quot;D_NAD_1983_2011&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Transverse_Mercator&quot;],PARAMETER[&quot;False_Easting&quot;,2296583.333333333],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-90.16666666666667],PARAMETER[&quot;Scale_Factor&quot;,0.9999411764705882],PARAMETER[&quot;Latitude_Of_Origin&quot;,36.66666666666666],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,6457]],VERTCS[&quot;NAVD88_height_(ftUS)&quot;,VDATUM[&quot;North_American_Vertical_Datum_1988&quot;],PARAMETER[&quot;Vertical_Shift&quot;,0.0],PARAMETER[&quot;Direction&quot;,1.0],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,6360]]</WKT><XOrigin>-17463800</XOrigin><YOrigin>-46132600</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.0032808333333333331</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>103038</WKID><LatestWKID>6457</LatestWKID><VCSWKID>105703</VCSWKID><LatestVCSWKID>6360</LatestVCSWKID></ProjectedCoordinateSystem> 20240213 10222800 20240213 10222800 Esri ArcGIS 13.2.0.49743 SDE_JDK_add_structures_reviewing_12_4_23 Enterprise Geodatabase Table dataset EPSG 8.2.10(10.3.1) 0 Simple FALSE 0 TRUE TRUE SDE_JDK_add_structures_reviewing_12_4_23 Table 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. assetid Structure ID String 64 0 0 IDOT_survey_code IDOT Survey Code SmallInteger 2 5 0 assetgroup Asset group Integer 4 10 0 assettype Asset type SmallInteger 2 5 0 designtype Type SmallInteger 2 5 0 material F&G/Cover/Other Material SmallInteger 2 5 0 inletshape F&G/Cover/Other Shape SmallInteger 2 5 0 material_struct Structure Material SmallInteger 2 5 0 shape_struct Strcture Shape SmallInteger 2 5 0 diameter Diameter Double 8 38 8 length2 Length Double 8 38 8 width Width Double 8 38 8 depth Depth Double 8 38 8 elevation Rim Elevation Double 8 38 8 bottom_elevation Bottom Elevation Double 8 38 8 pipe_count Number of Pipes SmallInteger 2 5 0 surfacewater Receives Surface Water SmallInteger 2 5 0 conetype Cone type SmallInteger 2 5 0 MACP MACP score Double 8 38 8 location Structure Location SmallInteger 2 5 0 surface Structure Surface Type SmallInteger 2 5 0 spatialsource Spatial Source SmallInteger 2 5 0 isconnected Is connected SmallInteger 2 5 0 lifecyclestatus Lifecycle Status SmallInteger 2 5 0 installdate Install Date Date 8 0 0 surveydate Survey Date Date 8 0 0 inspectdate Inspection Date Date 8 0 0 notes Notes String 2000 0 0 validationstatus Validation status SmallInteger 2 5 0 ownedby Owned By SmallInteger 2 5 0 maintby Maintained By SmallInteger 2 5 0 creationdate Creation date Date 8 0 0 creator Creator String 255 0 0 lastupdate Last update Date 8 0 0 updatedby Updated by String 255 0 0 globalid Global ID 2 String 38 0 0 CMT_CAD_GIS CMT CAD-GIS (Y/N) SmallInteger 2 5 0 Unknown 0 assettype 0 Stormwater_5_UnknownAssetType The AssetType domain for the Unknown AssetGroup. Coded Value Default value Default value SmallInteger isconnected 2 Stormwater_5_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate SmallInteger validationstatus 6 Validation Status The current record's validation status. Coded Value Default value Default value SmallInteger CMT_CAD_GIS Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger Pump 5 assettype 0 Asset_Type_Stormwater_Device_Pump The asset type for the stormwater device's asset group pump. Coded Value Default value Duplicate SmallInteger designtype 0 Stormwater_Pump_Type The type of the stormwater pump. Coded Value Default value Duplicate SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate SmallInteger isconnected 2 Stormwater_5_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate SmallInteger validationstatus 6 Validation Status The current record's validation status. Coded Value Default value Default value SmallInteger ownedby 1 Asset_Owner The owner of an asset. Coded Value Default value Duplicate SmallInteger maintby 1 Asset_Manager The manager of an asset. Coded Value Default value Duplicate SmallInteger CMT_CAD_GIS Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger Weir 26 assettype 0 Asset_Type_Stormwater_Device_Weir The asset type for the stormwater device's asset group weir. Coded Value Default value Duplicate SmallInteger material 0 Structure_Sewer_Storm_Materials The materials of sewer storm structures. Coded Value Default value Duplicate SmallInteger material_struct 0 Stormwater_Wall_Material The material of stormwater walls. Coded Value Default value Duplicate SmallInteger shape_struct 0 Stormwater_Inlet_Shape The shpae of the stormwater inlet. Coded Value Default value Duplicate SmallInteger surfacewater 0 Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger location 0 Structure_Sewer_Storm_Vault_Manhole_Location The location of structure manholes. Coded Value Default value Duplicate SmallInteger surface 0 Structure_Sewer_Storm_Vault_Manhole_Surface The surface type of structure manholes. Coded Value Default value Duplicate SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate SmallInteger isconnected 2 Stormwater_5_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate SmallInteger validationstatus 6 Validation Status The current record's validation status. Coded Value Default value Default value SmallInteger ownedby 1 Asset_Owner The owner of an asset. Coded Value Default value Duplicate SmallInteger maintby 1 Asset_Manager The manager of an asset. Coded Value Default value Duplicate SmallInteger CMT_CAD_GIS Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger Cleanout 21 assettype 0 Asset_Type_Stormwater_Device_Cleanout The asset type for the stormwater device's asset group clean out. Coded Value Default value Duplicate SmallInteger material 0 Stormwater_Cleanout_Material The material of stormwater cleanouts. Coded Value Default value Duplicate SmallInteger diameter 0 Stormwater_Cleanout_Diameter The diameter of stormwater cleanouts. Coded Value Default value Duplicate Double location 0 Structure_Sewer_Storm_Vault_Manhole_Location The location of structure manholes. Coded Value Default value Duplicate SmallInteger surface 0 Structure_Sewer_Storm_Vault_Manhole_Surface The surface type of structure manholes. Coded Value Default value Duplicate SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate SmallInteger isconnected 2 Stormwater_5_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate SmallInteger validationstatus 6 Validation Status The current record's validation status. Coded Value Default value Default value SmallInteger ownedby 1 Asset_Owner The owner of an asset. Coded Value Default value Duplicate SmallInteger maintby 1 Asset_Manager The manager of an asset. Coded Value Default value Duplicate SmallInteger CMT_CAD_GIS Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger Catch Basin 28 assettype 0 Asset_Type_Stormwater_Device_Catch_Basin The asset type for the stormwater device's asset group catch basin. Coded Value Default value Duplicate SmallInteger designtype 0 Stormwater_Catch_Basin_Opening_Type The type of catch basin Coded Value Default value Duplicate SmallInteger material 0 Structure_Sewer_Storm_Materials The materials of sewer storm structures. Coded Value Default value Duplicate SmallInteger inletshape 0 Stormwater_Inlet_Shape The shpae of the stormwater inlet. Coded Value Default value Duplicate SmallInteger material_struct 0 Stormwater_Wall_Material The material of stormwater walls. Coded Value Default value Duplicate SmallInteger shape_struct 0 Stormwater_Inlet_Shape The shpae of the stormwater inlet. Coded Value Default value Duplicate SmallInteger diameter 0 Stormwater_Outlet_Diameter_1 The diameter of a stormwater oulet. Coded Value Default value Duplicate Double surfacewater 0 Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger conetype 0 Structure_Sewer_Storm_Vault_Manhole_Cone_1 The cone type of structure manholes. Coded Value Default value Duplicate SmallInteger location 0 Structure_Sewer_Storm_Vault_Manhole_Location The location of structure manholes. Coded Value Default value Duplicate SmallInteger surface 0 Structure_Sewer_Storm_Vault_Manhole_Surface The surface type of structure manholes. Coded Value Default value Duplicate SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate SmallInteger isconnected 2 Stormwater_5_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate SmallInteger validationstatus 6 Validation Status The current record's validation status. Coded Value Default value Default value SmallInteger ownedby 1 Asset_Owner The owner of an asset. Coded Value Default value Duplicate SmallInteger maintby 1 Asset_Manager The manager of an asset. Coded Value Default value Duplicate SmallInteger CMT_CAD_GIS Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger BMP Point 29 assettype 0 Asset_Type_Stormwater_Device_BMP_Point The asset type for the stormwater device's asset group BMP Point. Coded Value Default value Duplicate SmallInteger material 0 Stormwater_BMP_Material The material of stormwater BMPs Coded Value Default value Duplicate SmallInteger material_struct 0 Stormwater_BMP_Material The material of stormwater BMPs Coded Value Default value Duplicate SmallInteger surfacewater 0 Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger location 0 Structure_Sewer_Storm_Vault_Manhole_Location The location of structure manholes. Coded Value Default value Duplicate SmallInteger surface 0 Structure_Sewer_Storm_Vault_Manhole_Surface The surface type of structure manholes. Coded Value Default value Duplicate SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate SmallInteger isconnected 2 Stormwater_5_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate SmallInteger validationstatus 6 Validation Status The current record's validation status. Coded Value Default value Default value SmallInteger ownedby 1 Asset_Owner The owner of an asset. Coded Value Default value Duplicate SmallInteger maintby 1 Asset_Manager The manager of an asset. Coded Value Default value Duplicate SmallInteger CMT_CAD_GIS Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger Outlet 22 assettype 0 Asset_Type_Stormwater_Device_Outlet_1 The asset type for the stormwater device's asset group discharge. Coded Value Default value Duplicate SmallInteger material 0 Stormwater_Outlet_Material The material of stormwater outlets. Coded Value Default value Duplicate SmallInteger diameter 0 Stormwater_Outlet_Diameter_1 The diameter of a stormwater oulet. Coded Value Default value Duplicate Double surfacewater 0 Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger location 0 Structure_Sewer_Storm_Vault_Manhole_Location The location of structure manholes. Coded Value Default value Duplicate SmallInteger surface 0 Structure_Sewer_Storm_Vault_Manhole_Surface The surface type of structure manholes. Coded Value Default value Duplicate SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate SmallInteger isconnected 2 Stormwater_5_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate SmallInteger validationstatus 6 Validation Status The current record's validation status. Coded Value Default value Default value SmallInteger ownedby 1 Asset_Owner The owner of an asset. Coded Value Default value Duplicate SmallInteger maintby 1 Asset_Manager The manager of an asset. Coded Value Default value Duplicate SmallInteger CMT_CAD_GIS Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger BMP Inlet 30 assettype 0 Asset_Type_Stormwater_Device_BMP_Inlet The asset type for the stormwater devices's asset group BMP Inlet. Coded Value Default value Duplicate SmallInteger material 0 Stormwater_Outlet_Material The material of stormwater outlets. Coded Value Default value Duplicate SmallInteger diameter 0 Stormwater_Outlet_Diameter_1 The diameter of a stormwater oulet. Coded Value Default value Duplicate Double surfacewater 0 Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger location 0 Structure_Sewer_Storm_Vault_Manhole_Location The location of structure manholes. Coded Value Default value Duplicate SmallInteger surface 0 Structure_Sewer_Storm_Vault_Manhole_Surface The surface type of structure manholes. Coded Value Default value Duplicate SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate SmallInteger isconnected 2 Stormwater_5_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate SmallInteger validationstatus 6 Validation Status The current record's validation status. Coded Value Default value Default value SmallInteger ownedby 1 Asset_Owner The owner of an asset. Coded Value Default value Duplicate SmallInteger maintby 1 Asset_Manager The manager of an asset. Coded Value Default value Duplicate SmallInteger CMT_CAD_GIS Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger Connection 23 assettype 0 Asset_Type_Stormwater_Device_Connection The asset type for the stormwater device's asset group pipe connection. Coded Value Default value Duplicate SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate SmallInteger isconnected 2 Stormwater_5_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate SmallInteger validationstatus 6 Validation Status The current record's validation status. Coded Value Default value Default value SmallInteger ownedby 1 Asset_Owner The owner of an asset. Coded Value Default value Duplicate SmallInteger maintby 1 Asset_Manager The manager of an asset. Coded Value Default value Duplicate SmallInteger CMT_CAD_GIS Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger exist_note exist_note String 1 0 0 no_inverts no_inverts String 1 0 0 survey_req survey_req String 1 0 0 verification_req verification_req String 1 0 0 unburied_req unburied_req String 1 0 0 prev_maint prev_maint String 1 0 0 verif_missing_attribs verif_missing_attribs String 1 0 0 verif_geom_connec verif_geom_connec String 255 0 0 illicit_discharge illicit_discharge String 1 0 0 clean_req clean_req String 1 0 0 repair_req repair_req String 1 0 0 verify_inlet_protect verify_inlet_protect String 1 0 0 DuplicateReview DuplicateReview Integer 4 10 0 Manhole 32 assettype 9 Manhole_Types Types of manholes. Coded Value Default value Duplicate SmallInteger designtype 0 Structure_Sewer_Storm_Vault_Cover_Type The cover type of structure manholes. Coded Value Default value Duplicate SmallInteger material 0 Structure_Sewer_Storm_Materials The materials of sewer storm structures. Coded Value Default value Duplicate SmallInteger inletshape 0 Structure_Sewer_Storm_Vault_Cover_Shape The cover shape of structure manholes. Coded Value Default value Duplicate SmallInteger material_struct 0 Stormwater_Wall_Material The material of stormwater walls. Coded Value Default value Duplicate SmallInteger shape_struct 0 Stormwater_Inlet_Shape The shpae of the stormwater inlet. Coded Value Default value Duplicate SmallInteger diameter 0 Stormwater_Outlet_Diameter_1 The diameter of a stormwater oulet. Coded Value Default value Duplicate Double surfacewater 0 Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger conetype 0 Structure_Sewer_Storm_Vault_Manhole_Cone_1 The cone type of structure manholes. Coded Value Default value Duplicate SmallInteger location 0 Structure_Sewer_Storm_Vault_Manhole_Location The location of structure manholes. Coded Value Default value Duplicate SmallInteger surface 0 Structure_Sewer_Storm_Vault_Manhole_Surface The surface type of structure manholes. Coded Value Default value Duplicate SmallInteger spatialsource Spatial_Source Source of the data Coded Value Default value Duplicate SmallInteger isconnected 1 Stormwater_5_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate SmallInteger lifecyclestatus 8 Lifecycle_Combined Bitwise combination of lifecycle states for subnetwork management Coded Value Default value Duplicate SmallInteger validationstatus Validation Status The current record's validation status. Coded Value Default value Default value SmallInteger ownedby 1 Asset_Owner The owner of an asset. Coded Value Default value Duplicate SmallInteger maintby 1 Asset_Manager The manager of an asset. Coded Value Default value Duplicate SmallInteger CMT_CAD_GIS Yes_No A yes/no indicator Coded Value Default value Duplicate SmallInteger UnburiedComp Unbury Completed String 255 0 0 UnburiedComp_Notes Unbury Completion Notes String 255 0 0 CleanComp Cleaning Completed String 255 0 0 CleanComp_Notes Cleaning Completion Notes String 255 0 0 RepairComp Repair Completed String 255 0 0 RepairComp_Notes Repair Completion Notes String 255 0 0 IllicitDischargeInsp Illicit Discharge Inspected String 255 0 0 IllicitDischargeInsp_Notes Illicit Discharge Inspection Notes String 255 0 0 InletProtectVerified Inlet Protection Verified String 255 0 0 InletProtectVerified_Notes Inlet Protection Verification Notes String 255 0 0 unstuck_req unstuck_req String 1 0 0 UnstuckComp Unstuck Completed String 255 0 0 UnstuckComp_Notes Unstuck Completion Notes String 255 0 0 AssetGUID Asset GUID String 38 0 0 20240213