Combined Sewer System

Workspace

Key	Value
Name	CombinedSewerSystem_7342e9936edc4398986c0a9f97cae71a
Workspace Type	Remote Database
Workspace Factory	Feature Service DB
Geodatabase Release
Date Exported	2025-03-31 11:45:50
Path

Domain Name	Description	Field Type	Domain Type	Split Policy	Merge Policy	# of Codes	# of Assignments
Asset_Type_Combined_Device_Storage		String	Coded Value	Duplicate	Default Value	1	1
Asset_Type_Combined_Junction_Dropshaft		String	Coded Value	Duplicate	Default Value	1	1
Asset_Type_Combined_Line_Force_Main		String	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Combined_Line_Gravity_Main		String	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Combined_Line_Storage_Tunnel		String	Coded Value	Duplicate	Default Value	1	1
Asset_Type_Sewer_Device_Discharge		String	Coded Value	Default Value	Default Value	1	1
Asset_Type_Stormwater_Device_Catch_Basin		String	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Stormwater_Line_Pipe		String	Coded Value	Duplicate	Default Value	1	1
Asset_Type_Structure_Boundary_Storage		String	Coded Value	Duplicate	Default Value	1	1
ESRI_FIX_TYPE_DOMAIN		Short Integer	Coded Value	Default Value	Default Value	5	4
ESRI_NUM_SATS_DOMAIN		Short Integer	Range	Default Value	Default Value		4
ESRI_POSITIONSOURCETYPE_DOMAIN	Position Source Type	Short Integer	Coded Value	Default Value	Default Value	6	4
ESRI_STATION_ID_DOMAIN		Short Integer	Range	Default Value	Default Value		4
LifecycleStatus		String	Coded Value	Duplicate	Default Value	10	9
Overall_Condition		Short Integer	Coded Value	Default Value	Default Value	5	9
Sewer_Asset_Manager		String	Coded Value	Duplicate	Default Value	3	9
Sewer_Asset_Owner		String	Coded Value	Duplicate	Default Value	3	9
Sewer_Main_Diameter		Double	Coded Value	Duplicate	Default Value	30	4
Sewer_Main_Liner		String	Coded Value	Duplicate	Default Value	13	3
Sewer_Main_Material		String	Coded Value	Duplicate	Default Value	26	4
Sewer_Main_Shape		String	Coded Value	Duplicate	Default Value	6	4
Spatial_Confidence		String	Coded Value	Duplicate	Default Value	3	9
Spatial_Source		String	Coded Value	Duplicate	Default Value	5	9
Stormwater_Catch_Basin_Opening_Type		String	Coded Value	Duplicate	Default Value	3	1
Stormwater_Exiting_System		String	Coded Value	Duplicate	Default Value	3	1
Stormwater_Inlet_Shape		String	Coded Value	Duplicate	Default Value	3	1
Structure_Sewer_Storm_Materials		String	Coded Value	Duplicate	Default Value	11	2
Yes_No		String	Coded Value	Duplicate	Default Value	2	6

Datasets

Catch_Basin

Properties

Key	Value
Name	Catch_Basin
Dataset Type	FeatureClass
Dataset ID	-1
Geometry Type	Point
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	10.0
Alias	Catch_Basin
OID Field	objectid
GlobalID Field	globalid
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	Shape
Spatial Reference	NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet
X-Min	1191742.900125679
X-Max	1221336.785163511
Y-Min	468439.0913706124
Y-Max	487711.8074182793
Catalog ID	{FAB1AF61-941E-4B61-8BD4-B2826C5E7552}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
objectid	objectid	OID	Index	False			0	0	False	True	Unique identifier for each record
assettype	Asset type	String		False	Asset_Type_Stormwater_Device_Catch_Basin	Unknown	0	100	True	False	Type of asset
assetid	Asset ID	String	Index;Index	True			0	64	True	False	Unique identifier for the asset
surfacewater	Receives Surface Water	String		True	Yes_No		0	15	True	False	Indicates if the asset receives surface water
exitsystem	Water Exiting System	String		True	Stormwater_Exiting_System		0	50	True	False	Describes where the water exits the system
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	String		False	LifecycleStatus	In Service	0	100	True	False	Current phase or state of an asset within its lifecycle
rimelevation	Rim Elevation	Double		True			0	0	True	False	Elevation of the rim of the manhole
invertelev	Invert Elevation	Double		True			0	0	True	False	Invert elevation of the asset
assetlength	Length	Double		True			0	0	True	False	Length of the asset
width	Width	Double		True			0	0	True	False	Width of the asset
depth	Depth	Double		True			0	0	True	False	Depth of the asset
wallmaterial	Wall Material	String		True	Structure_Sewer_Storm_Materials		0	100	True	False	Material of the wall of the asset
framematerial	Frame Material	String		True	Structure_Sewer_Storm_Materials		0	100	True	False	Material of the frame of the asset
sump	Sump	String		True	Yes_No		0	15	True	False	Indicates if the asset has a sump
openingtype	Opening Type	String		True	Stormwater_Catch_Basin_Opening_Type		0	50	True	False	Type of opening for the catch basin
inletshape	Inlet Shape	String		True	Stormwater_Inlet_Shape		0	50	True	False	Shape of the inlet of the asset
signage	Signage	String		True	Yes_No		0	15	True	False	Indicates if the asset has signage
ownedby	Owned By	String		True	Sewer_Asset_Owner	Our Agency	0	50	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Sewer_Asset_Manager	Our Agency	0	50	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Notes pertaining to the asset
spatialsource	Spatial Source	String		True	Spatial_Source		0	50	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence		0	50	True	False	Confidence level in the location accuracy of the asset
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date the record was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Source used to collect the point or vertex
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the receiver used to capture the location
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Geographic coordinate that specifies a location's north-south position on Earth
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Geographic coordinate that specifies a location's east-west position on Earth
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Ellipsoidal height received from the GPS receiver
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Probability that the location signal is within a circle of a given radius
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Probability that the location signal is within an elevation range
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Date and time the GPS receiver became fixed
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of fix being used to determine its location
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Time elapsed between when a correction message is generated and when it's received by the GPS receiver
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites being used to receive a signal
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Measure of how the geometry of the visible satellites impacts the accuracy of your position fix
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy.
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Compass direction GPS is pointed expressed in degrees
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed at which the GPS device is moving
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	ction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270°
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average probability that the location signal is within a circle of a given radius
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average probability that the location signal is within an elevation range
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Average location of multiple positions to improve accuracy
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers.
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the asset. Either point, line, or polygon

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__5242E632D929F5CD	True	True	objectid
user_7607.COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_CATCH_BASIN_Shape_sidx	False	True	Shape
FDO_globalid	True	True	globalid
I25assetid	False	True	assetid
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user
FT_COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_CATCH_BASIN_assetid	False	True	assetid

CatchBasinRelate

Properties

Key	Value
Name	CatchBasinRelate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	CatchBasinRelate
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{E6836F53-2226-4A7C-9C49-B34B264BFD80}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__F4B70D855CF0FF6E	True	True	OBJECTID
FDO_GlobalID	True	True	GlobalID
G27assetguid	False	True	assetguid
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user

Combined_Sewer_Force_Main

Properties

Key	Value
Name	Combined_Sewer_Force_Main
Dataset Type	FeatureClass
Dataset ID	-1
Geometry Type	Polyline
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	10.0
Alias	Combined_Sewer_Force_Main
OID Field	objectid
GlobalID Field	globalid
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	Shape
Spatial Reference	NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet
X-Min	1191450.856090344
X-Max	1224174.445826761
Y-Min	466127.8312293664
Y-Max	490944.1526596174
Catalog ID	{1BA145C9-CD3A-482E-8FA0-2BFDCAD06F49}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
objectid	objectid	OID	Index	False			0	0	False	True	Unique identifier for each record
assettype	Asset type	String		False	Asset_Type_Combined_Line_Force_Main	Unknown	0	100	True	False	Type of asset
assetid	Asset ID	String	Index;Index	True			0	64	True	False	Unique identifier for the asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
diameter	Diameter	Double		True	Sewer_Main_Diameter	0	0	0	True	False	Diameter of the asset
material	Material	String		True	Sewer_Main_Material		0	100	True	False	Material of the asset
lifecyclestatus	Lifecycle Status	String		False	LifecycleStatus	In Service	0	100	True	False	Current phase or state of an asset within its lifecycle
downelev	Downstream Elevation	Double		True			0	0	True	False	Elevation at the downstream end of the sewer force main
upelev	Upstream Elevation	Double		True			0	0	True	False	Elevation at the upstream end of the sewer force main
slope	Slope	Double		True			0	0	True	False	Slope of the sewer force main
mainshape	Main Shape	String		True	Sewer_Main_Shape		0	50	True	False	Shape of the sewer force main
linertype	Liner Type	String		True	Sewer_Main_Liner		0	100	True	False	Type of liner used in the sewer force main
tracerwire	Tracer Wire	String		True	Yes_No		0	15	True	False	Indicates if a tracer wire is present
ownedby	Owned By	String		True	Sewer_Asset_Owner	Our Agency	0	50	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Sewer_Asset_Manager	Our Agency	0	50	True	False	Entity that maintains the asset
measuredlength	Measured Length	Double		True			0	0	True	False	Measured length of the sewer force main
notes	Notes	String		True			0	2000	True	False	Notes pertaining to the asset
spatialsource	Spatial Source	String		True	Spatial_Source		0	50	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence		0	50	True	False	Confidence level in the location accuracy of the asset
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date the record was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
Shape__Length	Shape__Length	Double	Index;Length	True			0	0	False	True	Length of the asset
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the asset. Either point, line, or polygon

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__5242E632235AAD52	True	True	objectid
user_7607.COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_COMBINED_SEWER_FORCE_MAIN_Shape_sidx	False	True	Shape
FDO_globalid	True	True	globalid
I71assetid	False	True	assetid
Shape__Length_Index	False	True	Shape__Length
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user
FT_COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_COMBINED_SEWER_FORCE_MAIN_assetid	False	True	assetid

Combined_Sewer_Gravity_Main

Properties

Key	Value
Name	Combined_Sewer_Gravity_Main
Dataset Type	FeatureClass
Dataset ID	-1
Geometry Type	Polyline
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	10.0
Alias	Combined_Sewer_Gravity_Main
OID Field	objectid
GlobalID Field	globalid
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	Shape
Spatial Reference	NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet
X-Min	1189225.298533596
X-Max	1236205.927341178
Y-Min	465670.1205306128
Y-Max	511327.7877452821
Catalog ID	{C25675A6-631E-469F-A523-6DE4CEC8E7E3}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
objectid	objectid	OID	Index	False			0	0	False	True	Unique identifier for each record
assettype	Asset type	String		False	Asset_Type_Combined_Line_Gravity_Main	Unknown	0	100	True	False	Type of asset
assetid	Asset ID	String	Index;Index	True			0	64	True	False	Unique identifier for the asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
diameter	Diameter	Double		True	Sewer_Main_Diameter	0	0	0	True	False	Diameter of the asset
material	Material	String		True	Sewer_Main_Material		0	100	True	False	Material of the asset
lifecyclestatus	Lifecycle Status	String		False	LifecycleStatus	In Service	0	100	True	False	Current phase or state of an asset within its lifecycle
downelev	Downstream Elevation	Double		True			0	0	True	False	Elevation at the downstream end of the sewer main
upelev	Upstream Elevation	Double		True			0	0	True	False	Elevation at the upstream end of the sewer main
slope	Slope	Double		True			0	0	True	False	Slope of the sewer main
mainshape	Main Shape	String		True	Sewer_Main_Shape		0	50	True	False	Shape of the sewer main
linertype	Liner Type	String		True	Sewer_Main_Liner		0	100	True	False	Type of liner used in the sewer main
tracerwire	Tracer Wire	String		True	Yes_No		0	15	True	False	Indicates if a tracer wire is present
ownedby	Owned By	String		True	Sewer_Asset_Owner	Our Agency	0	50	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Sewer_Asset_Manager	Our Agency	0	50	True	False	Entity that maintains the asset
measuredlength	Measured Length	Double		True			0	0	True	False	Measured length of the sewer main
notes	Notes	String		True			0	2000	True	False	Notes pertaining to the asset
spatialsource	Spatial Source	String		True	Spatial_Source		0	50	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence		0	50	True	False	Confidence level in the location accuracy of the asset
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date the record was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
Shape__Length	Shape__Length	Double	Index;Length	True			0	0	False	True	Length of the asset
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the asset. Either point, line, or polygon

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__5242E632A20D5119	True	True	objectid
user_7607.COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_COMBINED_SEWER_GRAVITY_MAIN_Shape_sidx	False	True	Shape
FDO_globalid	True	True	globalid
I65assetid	False	True	assetid
Shape__Length_Index	False	True	Shape__Length
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user
FT_COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_COMBINED_SEWER_GRAVITY_MAIN_assetid	False	True	assetid

Combined_Sewer_Overflow

Properties

Key	Value
Name	Combined_Sewer_Overflow
Dataset Type	FeatureClass
Dataset ID	-1
Geometry Type	Point
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	10.0
Alias	Combined_Sewer_Overflow
OID Field	objectid
GlobalID Field	globalid
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	Shape
Spatial Reference	NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet
X-Min	1190014.493805595
X-Max	1235062.988682181
Y-Min	463308.5711198673
Y-Max	500156.794011198
Catalog ID	{7E2D81A5-7142-43DD-8B23-B8EDFAE3A523}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
objectid	objectid	OID	Index	False			0	0	False	True	Unique identifier for each record
assettype	Asset type	String		False	Asset_Type_Sewer_Device_Discharge	Combined Sewer Overflow	0	100	True	False	Type of asset
assetid	Asset ID	String	Index	True			0	64	True	False	Unique identifier for the asset
lifecyclestatus	Lifecycle Status	String		False	LifecycleStatus	In Service	0	100	True	False	Current phase or state of an asset within its lifecycle
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
name	Name	String	Index;Index	True			0	64	True	False	Name of the asset
ownedby	Owned By	String		True	Sewer_Asset_Owner	Our Agency	0	50	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Sewer_Asset_Manager	Our Agency	0	50	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Notes pertaining to the asset
spatialsource	Spatial Source	String		True	Spatial_Source		0	50	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence		0	50	True	False	Confidence level in the location accuracy of the asset
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date the record was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Source used to collect the point or vertex
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the receiver used to capture the location
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Geographic coordinate that specifies a location's north-south position on Earth
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Geographic coordinate that specifies a location's east-west position on Earth
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Ellipsoidal height received from the GPS receiver
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Probability that the location signal is within a circle of a given radius
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Probability that the location signal is within an elevation range
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Date and time the GPS receiver became fixed
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of fix being used to determine its location
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Time elapsed between when a correction message is generated and when it's received by the GPS receiver
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites being used to receive a signal
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Measure of how the geometry of the visible satellites impacts the accuracy of your position fix
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy.
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Compass direction GPS is pointed expressed in degrees
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed at which the GPS device is moving
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	ction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270°
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average probability that the location signal is within a circle of a given radius
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average probability that the location signal is within an elevation range
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Average location of multiple positions to improve accuracy
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers.
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the asset. Either point, line, or polygon

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__5242E632C185139C	True	True	objectid
user_7607.COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_COMBINED_SEWER_OVERFLOW_Shape_sidx	False	True	Shape
FDO_globalid	True	True	globalid
I14assetid	False	True	assetid
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user
IX_COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_COMBINED_SEWER_OVERFLOW_name_ASC	False	True	name
FT_COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_COMBINED_SEWER_OVERFLOW_name	False	True	name

CombinedSewerForceMainRelate

Properties

Key	Value
Name	CombinedSewerForceMainRelate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	CombinedSewerForceMainRelate
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{8A1366E5-9666-4B1C-8D3D-80128A7F791D}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__F4B70D85C9CDA428	True	True	OBJECTID
FDO_GlobalID	True	True	GlobalID
G73assetguid	False	True	assetguid
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user

CombinedSewerGravityMainRelate

Properties

Key	Value
Name	CombinedSewerGravityMainRelate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	CombinedSewerGravityMainRelate
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{F6002C16-906C-4048-B462-D890CF12044E}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__F4B70D85CF8AB799	True	True	OBJECTID
FDO_GlobalID	True	True	GlobalID
G66assetguid	False	True	assetguid
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user

CombinedSewerOverflowRelate

Properties

Key	Value
Name	CombinedSewerOverflowRelate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	CombinedSewerOverflowRelate
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{AB554B7F-26BB-4F2F-9F4E-3A6E27D4721E}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__F4B70D85B1C8DB0E	True	True	OBJECTID
FDO_GlobalID	True	True	GlobalID
G15assetguid	False	True	assetguid
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user

Dropshaft

Properties

Key	Value
Name	Dropshaft
Dataset Type	FeatureClass
Dataset ID	-1
Geometry Type	Point
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	10.0
Alias	Dropshaft
OID Field	objectid
GlobalID Field	globalid
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	Shape
Spatial Reference	NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet
X-Min	-17463455.5506689
X-Max	19431955.5506689
Y-Min	-46132232.73347634
Y-Max	19495685.09234675
Catalog ID	{127ED051-FF51-47AF-B9EC-B881FB57042D}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
objectid	objectid	OID	Index	False			0	0	False	True	Unique identifier for each record
assettype	Asset type	String		False	Asset_Type_Combined_Junction_Dropshaft	Dropshaft	0	100	True	False	Type of asset
assetid	Asset ID	String	Index;Index	True			0	64	True	False	Unique identifier for the asset
lifecyclestatus	Lifecycle Status	String		False	LifecycleStatus	In Service	0	100	True	False	Current phase or state of an asset within its lifecycle
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
depth	Depth	Double		True			0	0	True	False	Depth of the asset
ownedby	Owned By	String		True	Sewer_Asset_Owner	Our Agency	0	50	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Sewer_Asset_Manager	Our Agency	0	50	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Notes pertaining to the asset
spatialsource	Spatial Source	String		True	Spatial_Source		0	50	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence		0	50	True	False	Confidence level in the location accuracy of the asset
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date the record was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Source used to collect the point or vertex
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the receiver used to capture the location
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Geographic coordinate that specifies a location's north-south position on Earth
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Geographic coordinate that specifies a location's east-west position on Earth
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Ellipsoidal height received from the GPS receiver
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Probability that the location signal is within a circle of a given radius
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Probability that the location signal is within an elevation range
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Date and time the GPS receiver became fixed
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of fix being used to determine its location
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Time elapsed between when a correction message is generated and when it's received by the GPS receiver
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites being used to receive a signal
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Measure of how the geometry of the visible satellites impacts the accuracy of your position fix
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy.
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Compass direction GPS is pointed expressed in degrees
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed at which the GPS device is moving
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	ction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270°
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average probability that the location signal is within a circle of a given radius
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average probability that the location signal is within an elevation range
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Average location of multiple positions to improve accuracy
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers.
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the asset. Either point, line, or polygon

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__5242E6321FD6CA0F	True	True	objectid
user_7607.COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_DROPSHAFT2_Shape_sidx	False	True	Shape
FDO_globalid	True	True	globalid
I52assetid	False	True	assetid
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user
FT_COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_DROPSHAFT2_assetid	False	True	assetid

DropshaftRelate

Properties

Key	Value
Name	DropshaftRelate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	DropshaftRelate
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{37628BCD-00F8-4E7B-9132-CA425401F44E}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__F4B70D85B9B0F075	True	True	OBJECTID
FDO_GlobalID	True	True	GlobalID
G53assetguid	False	True	assetguid
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user

Storage

Properties

Key	Value
Name	Storage
Dataset Type	FeatureClass
Dataset ID	-1
Geometry Type	Point
Feature Type	Simple
Z-Aware	True
M-Aware	False
Split Model	Update Insert
Minimum Client Version	10.0
Alias	Storage
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	Shape
Spatial Reference	NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet
X-Min	-17463455.5506689
X-Max	19431955.5506689
Y-Min	-46132232.73347634
Y-Max	19495685.09234675
Catalog ID	{26A023EE-393C-4F81-9494-22B6D5089890}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			0	0	False	True	Unique identifier for each record
assettype	Asset type	String		False	Asset_Type_Combined_Device_Storage	Storage	0	100	True	False	Type of asset
assetid	Asset ID	String	Index	True			0	64	True	False	Unique identifier for the asset
lifecyclestatus	Lifecycle Status	String		False	LifecycleStatus	In Service	0	100	True	False	Current phase or state of an asset within its lifecycle
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
name	Name	String	Index;Index	True			0	64	True	False	Name of the asset
ownedby	Owned By	String		True	Sewer_Asset_Owner	Our Agency	0	50	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Sewer_Asset_Manager	Our Agency	0	50	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Notes pertaining to the asset
spatialsource	Spatial Source	String		True	Spatial_Source		0	50	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence		0	50	True	False	Confidence level in the location accuracy of the asset
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date the record was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
GlobalID	GlobalID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Source used to collect the point or vertex
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the receiver used to capture the location
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Geographic coordinate that specifies a location's north-south position on Earth
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Geographic coordinate that specifies a location's east-west position on Earth
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Ellipsoidal height received from the GPS receiver
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Probability that the location signal is within a circle of a given radius
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Probability that the location signal is within an elevation range
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Date and time the GPS receiver became fixed
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of fix being used to determine its location
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Time elapsed between when a correction message is generated and when it's received by the GPS receiver
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites being used to receive a signal
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Measure of how the geometry of the visible satellites impacts the accuracy of your position fix
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy.
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Compass direction GPS is pointed expressed in degrees
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed at which the GPS device is moving
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	ction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270°
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average probability that the location signal is within a circle of a given radius
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average probability that the location signal is within an elevation range
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Average location of multiple positions to improve accuracy
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers.
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the asset. Either point, line, or polygon

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__F4B70D8558C9313F	True	True	OBJECTID
user_7607.COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_STORAGE2_Shape_sidx	False	True	Shape
FDO_GlobalID	True	True	GlobalID
I46assetid	False	True	assetid
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user
IX_COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_STORAGE2_name_ASC	False	True	name
FT_COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_STORAGE2_name	False	True	name

Storage_Boundary

Properties

Key	Value
Name	Storage_Boundary
Dataset Type	FeatureClass
Dataset ID	-1
Geometry Type	Polygon
Feature Type	Simple
Z-Aware	True
M-Aware	False
Split Model	Update Insert
Minimum Client Version	10.0
Alias	Storage_Boundary
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	Shape
Spatial Reference	NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet
X-Min	-17463455.5506689
X-Max	19431955.5506689
Y-Min	-46132232.73347634
Y-Max	19495685.09234675
Catalog ID	{94771FA4-57C8-41D4-803E-E31CF367E961}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			0	0	False	True	Unique identifier for each record
assettype	Asset type	String		False	Asset_Type_Structure_Boundary_Storage	Storage	0	100	True	False	Type of asset
assetid	Asset ID	String	Index	True			0	64	True	False	Unique identifier for the asset
lifecyclestatus	Lifecycle Status	String		False	LifecycleStatus	In Service	0	100	True	False	Current phase or state of an asset within its lifecycle
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
name	Name	String	Index;Index	True			0	64	True	False	Name of the asset
ownedby	Owned By	String		True	Sewer_Asset_Owner	Our Agency	0	50	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Sewer_Asset_Manager	Our Agency	0	50	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Notes pertaining to the asset
spatialsource	Spatial Source	String		True	Spatial_Source		0	50	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence		0	50	True	False	Confidence level in the location accuracy of the asset
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date the record was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
GlobalID	GlobalID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
Shape__Area	Shape__Area	Double	Area;Index	True			0	0	False	True	Area of the asset
Shape__Length	Shape__Length	Double	Index;Length	True			0	0	False	True	Length of the asset
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the asset. Either point, line, or polygon

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__F4B70D85D6AC7371	True	True	OBJECTID
user_7607.COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_STORAGE_BOUNDARY_Shape_sidx	False	True	Shape
FDO_GlobalID	True	True	GlobalID
I40assetid	False	True	assetid
Shape__Area_Index	False	True	Shape__Area
Shape__Length_Index	False	True	Shape__Length
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user
IX_COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_STORAGE_BOUNDARY_name_ASC	False	True	name
FT_COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_STORAGE_BOUNDARY_name	False	True	name

Storage_Tunnel

Properties

Key	Value
Name	Storage_Tunnel
Dataset Type	FeatureClass
Dataset ID	-1
Geometry Type	Polyline
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	10.0
Alias	Storage_Tunnel
OID Field	objectid
GlobalID Field	globalid
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	Shape
Spatial Reference	NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet
X-Min	-17463455.5506689
X-Max	19431955.5506689
Y-Min	-46132232.73347634
Y-Max	19495685.09234675
Catalog ID	{47B18C4C-163A-42EC-90A3-588AE3108D4B}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
objectid	objectid	OID	Index	False			0	0	False	True	Unique identifier for each record
assettype	Asset type	String		False	Asset_Type_Combined_Line_Storage_Tunnel	Storage Tunnel	0	100	True	False	Type of asset
assetid	Asset ID	String	Index;Index	True			0	64	True	False	Unique identifier for the asset
lifecyclestatus	Lifecycle Status	String		False	LifecycleStatus	In Service	0	100	True	False	Current phase or state of an asset within its lifecycle
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
diameter	Diameter	Double		True	Sewer_Main_Diameter	0	0	0	True	False	Diameter of the asset
material	Material	String		True	Sewer_Main_Material		0	100	True	False	Material of the asset
downelev	Downstream Elevation	Double		True			0	0	True	False	Elevation at the downstream end of the tunnel
upelev	Upstream Elevation	Double		True			0	0	True	False	Elevation at the upstream end of the tunnel
slope	Slope	Double		True			0	0	True	False	Slope of the tunnel
volume	Volume	Double		True			0	0	True	False	Volume of the asset
mainshape	Main Shape	String		True	Sewer_Main_Shape		0	50	True	False	Shape of the tunnel
ownedby	Owned By	String		True	Sewer_Asset_Owner	Our Agency	0	50	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Sewer_Asset_Manager	Our Agency	0	50	True	False	Entity that maintains the asset
measuredlength	Measured Length	Double		True			0	0	True	False	Measured length of the tunnel
notes	Notes	String		True			0	2000	True	False	Notes pertaining to the asset
spatialsource	Spatial Source	String		True	Spatial_Source		0	50	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence		0	50	True	False	Confidence level in the location accuracy of the asset
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date the record was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
Shape__Length	Shape__Length	Double	Index;Length	True			0	0	False	True	Length of the asset
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the asset. Either point, line, or polygon

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__5242E6324C939253	True	True	objectid
user_7607.COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_STORAGE_TUNNEL_Shape_sidx	False	True	Shape
FDO_globalid	True	True	globalid
I34assetid	False	True	assetid
Shape__Length_Index	False	True	Shape__Length
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user
FT_COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_STORAGE_TUNNEL_assetid	False	True	assetid

StorageBoundaryRelate

Properties

Key	Value
Name	StorageBoundaryRelate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	StorageBoundaryRelate
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{6DA22C1B-626F-47EF-9B0C-1F5D517CBAAC}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__F4B70D8562283597	True	True	OBJECTID
FDO_GlobalID	True	True	GlobalID
G41assetguid	False	True	assetguid
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user

StorageRelate

Properties

Key	Value
Name	StorageRelate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	StorageRelate
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{F3510FE0-49A2-4D73-A5FB-5E7B83E6CFB2}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__F4B70D85E7AF6F6E	True	True	OBJECTID
FDO_GlobalID	True	True	GlobalID
G47assetguid	False	True	assetguid
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user

StorageTunnelRelate

Properties

Key	Value
Name	StorageTunnelRelate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	StorageTunnelRelate
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{18832B44-FF84-4CF1-98FD-5422871F7690}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__F4B70D8580B44DB0	True	True	OBJECTID
FDO_GlobalID	True	True	GlobalID
G36assetguid	False	True	assetguid
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user

Stormwater_Pipe

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
objectid	objectid	OID	Index	False			0	0	False	True	Unique identifier for each record
assettype	Asset type	String		False	Asset_Type_Stormwater_Line_Pipe	Storm Pipe	0	100	True	False	Type of asset
assetid	Asset ID	String	Index;Index	True			0	64	True	False	Unique identifier for the asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
diameter	Diameter	Double		True	Sewer_Main_Diameter	0	0	0	True	False	Diameter of the asset
material	Material	String		True	Sewer_Main_Material		0	100	True	False	Material of the asset
lifecyclestatus	Lifecycle Status	String		False	LifecycleStatus	In Service	0	100	True	False	Current phase or state of an asset within its lifecycle
downelev	Downstream Elevation	Double		True			0	0	True	False	Elevation at the downstream end of the stormwater pipe
upelev	Upstream Elevation	Double		True			0	0	True	False	Elevation at the upstream end of the stormwater pipe
slope	Slope	Double		True			0	0	True	False	Slope of the stormwater pipe
mainshape	Main Shape	String		True	Sewer_Main_Shape		0	50	True	False	Shape of the stormwater pipe
linertype	Liner Type	String		True	Sewer_Main_Liner		0	100	True	False	Type of liner used in the stormwater pipe
tracerwire	Tracer Wire	String		True	Yes_No		0	15	True	False	Indicates if a tracer wire is present
ownedby	Owned By	String		True	Sewer_Asset_Owner	Our Agency	0	50	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Sewer_Asset_Manager	Our Agency	0	50	True	False	Entity that maintains the asset
measuredlength	Measured Length	Double		True			0	0	True	False	Measured length of the stormwater pipe
notes	Notes	String		True			0	2000	True	False	Notes pertaining to the asset
spatialsource	Spatial Source	String		True	Spatial_Source		0	50	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence		0	50	True	False	Confidence level in the location accuracy of the asset
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date the record was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
Shape__Length	Shape__Length	Double	Index;Length	True			0	0	False	True	Length of the asset
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the asset. Either point, line, or polygon

Indexes

StormwaterPipeRelate

Properties

Fields

Indexes

Domains

Asset_Type_Combined_Device_Storage

Asset_Type_Combined_Junction_Dropshaft

Asset_Type_Combined_Line_Force_Main

Asset_Type_Combined_Line_Gravity_Main

Asset_Type_Combined_Line_Storage_Tunnel

Asset_Type_Sewer_Device_Discharge

Asset_Type_Stormwater_Device_Catch_Basin

Asset_Type_Stormwater_Line_Pipe

Asset_Type_Structure_Boundary_Storage

ESRI_FIX_TYPE_DOMAIN

ESRI_NUM_SATS_DOMAIN

ESRI_POSITIONSOURCETYPE_DOMAIN

ESRI_STATION_ID_DOMAIN

LifecycleStatus

Overall_Condition

Sewer_Asset_Manager

Sewer_Asset_Owner

Sewer_Main_Diameter

Sewer_Main_Liner

Sewer_Main_Material

Properties

Coded Values

Domain Usage

Sewer_Main_Shape

Spatial_Confidence

Spatial_Source

Stormwater_Catch_Basin_Opening_Type

Stormwater_Exiting_System

Stormwater_Inlet_Shape

Structure_Sewer_Storm_Materials

Yes_No

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__5242E6328C5D3203	True	True	objectid
user_7607.COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_STORMWATER_PIPE_Shape_sidx	False	True	Shape
FDO_globalid	True	True	globalid
I59assetid	False	True	assetid
Shape__Length_Index	False	True	Shape__Length
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user
FT_COMBINEDSEWERSYSTEM_7342E9936EDC4398986C0A9F97CAE71A_STORMWATER_PIPE_assetid	False	True	assetid

Name	Is Unique	Is Ascending	Field Name
PK__COMBINED__F4B70D859D38EA10	True	True	OBJECTID
FDO_GlobalID	True	True	GlobalID
G61assetguid	False	True	assetguid
created_dateIndex	False	True	created_date
created_userIndex	False	False	created_user
last_edited_dateIndex	False	True	last_edited_date
last_edited_userIndex	False	False	last_edited_user

Code	Description	Details
Unknown	Unknown
Combined Collector	Combined Collector
Combined Interceptor	Combined Interceptor

Code	Description	Details
Unknown	Unknown
Drop Inlet	Drop Inlet
Infiltration	Infiltration
Sediment Trap	Sediment Trap

Code	Description	Details
0	Unknown
1	User defined
2	Integrated (System) Location Provider
3	External GNSS Receiver
4	Network Location Provider
5	Snapped

Code	Description	Details
Unknown	Unknown
Proposed	Proposed
Approved	Approved
Under Construction	Under Construction
In Service	In Service
To Be Retired	To Be Retired
Abandoned	Abandoned
Retired	Retired
Removed	Removed
Out of Service	Out of Service

Code	Description	Details
0	Unknown
0.5	1/2"
0.75	3/4"
1	1"
1.25	1 1/4"
1.5	1 1/2"
2	2"
2.5	2 1/2"
3	3"
4	4"
6	6"
8	8"
10	10"
12	12"
14	14"
15	15"
16	16"
18	18"
20	20"
24	24"
30	30"
36	36"
40	40"
42	42"
48	48"
54	54"
60	60"
66	66"
72	72"
75	75"

Code	Description	Details
Cured-In-Place Pipe - CIP	Cured-In-Place Pipe - CIP
Fold and Form or Deform/Reform - FF	Fold and Form or Deform/Reform - FF
Formed-In-Place Liner - FP	Formed-In-Place Liner - FP
Grout-In-Place Liner - GP	Grout-In-Place Liner - GP
Glass Reinforced Cement - GRC	Glass Reinforced Cement - GRC
None - N	None - N
Continuous Slip Liner - SC	Continuous Slip Liner - SC
Sectional Slip Liner - SE	Sectional Slip Liner - SE
Spray Liner - SL	Spray Liner - SL
Segmented Panel - SN	Segmented Panel - SN
Segmented Pipe - SP	Segmented Pipe - SP
Spiral Wound - SW	Spiral Wound - SW
Other - ZZ	Other - ZZ

Code	Description	Details
Acrylonitrile Butadiene Styrene - ABS	Acrylonitrile Butadiene Styrene - ABS
Asbestos Cement - AC	Asbestos Cement - AC
Asphalt - ASP	Asphalt - ASP
Brick - BR	Brick - BR
Cast Iron - CAS	Cast Iron - CAS
Clay Tile - CT	Clay Tile - CT
Concrete Pipe (Non-Reinforced) - CP	Concrete Pipe (Non-Reinforced) - CP
Concrete Segments (Bolted) - CSB	Concrete Segments (Bolted) - CSB
Concrete Segments (Unbolted) - CSU	Concrete Segments (Unbolted) - CSU
Cured in Place Pipe - CIPP	Cured in Place Pipe - CIPP
Ductile Iron Pipe - DIP	Ductile Iron Pipe - DIP
Fiberglass Reinforced Pipe - FRP	Fiberglass Reinforced Pipe - FRP
Galvanized Pipe - GP	Galvanized Pipe - GP
Glass Reinforced Cement - GRC	Glass Reinforced Cement - GRC
High Density Polyethylene - HDPE	High Density Polyethylene - HDPE
Other - OTH	Other - OTH
Plastic/Steel Composite - PSC	Plastic/Steel Composite - PSC
Polyethylene - PE	Polyethylene - PE
Polypropylene - PP	Polypropylene - PP
Polyvinyle Chloride - PVC	Polyvinyle Chloride - PVC
Pre-Stressed Concrete Cylinder Pipe - PCCP	Pre-Stressed Concrete Cylinder Pipe - PCCP
Reinforced Concrete Pipe - RCP	Reinforced Concrete Pipe - RCP
Reinforced Plastic Pipe (Truss Pipe) - RPM	Reinforced Plastic Pipe (Truss Pipe) - RPM
Segmented Block - SB	Segmented Block - SB
Steel Pipe - SP	Steel Pipe - SP
Vitrified Clay Pipe - VCP	Vitrified Clay Pipe - VCP

Code	Description	Details
Circular	Circular
Horseshoe	Horseshoe
Oblong	Oblong
Rectangular	Rectangular
Trapezoidal	Trapezoidal
Triangular	Triangular

Code	Description	Details
As-Built	As-Built
CAD	CAD
Digitized	Digitized
GPS/GNSS	GPS/GNSS
Field Sketch	Field Sketch

Code	Description	Details
ABS Plastic - ABS	ABS Plastic - ABS
Cast Iron - CAS	Cast Iron - CAS
Ductile Iron - DIP	Ductile Iron - DIP
High Density Polyethylene - HDPE	High Density Polyethylene - HDPE
Other - OTH	Other - OTH
Plastic/Steel Composite - PSC	Plastic/Steel Composite - PSC
Polyethylene - PE	Polyethylene - PE
Polypropylene - PP	Polypropylene - PP
Polyvinyl Chloride - PVC	Polyvinyl Chloride - PVC
Reinforced Plastic (Truss) - RMP	Reinforced Plastic (Truss) - RMP
Steel - SP	Steel - SP