Stormwater System

Workspace

Key	Value
Name	StormwaterSystem_3795a353143b4d59af21d1646ac8fbee
Workspace Type	Remote Database
Workspace Factory	Feature Service DB
Geodatabase Release
Date Exported	2025-04-09 15:36:48
Path

Domain Name	Field Type	Domain Type	Split Policy	Merge Policy	# of Codes	# of Assignments
Asset_Manager	String	Coded Value	Duplicate	Default Value	3	10
Asset_Owner	String	Coded Value	Duplicate	Default Value	3	10
Asset_Type_BMP_Boundary	String	Coded Value	Duplicate	Default Value	18	1
Asset_Type_Catchment_Boundary	String	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Storm_Manhole	String	Coded Value	Duplicate	Default Value	10	1
Asset_Type_Stormwater_BMP_Inlet	String	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Stormwater_BMP_Point	String	Coded Value	Duplicate	Default Value	18	2
Asset_Type_Stormwater_Catch_Basin	String	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Stormwater_Culvert	String	Coded Value	Duplicate	Default Value	6	1
Asset_Type_Stormwater_Linear_Drain	String	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Stormwater_Open Channel	String	Coded Value	Duplicate	Default Value	6	1
Asset_Type_Stormwater_Outlet	String	Coded Value	Duplicate	Default Value	12	1
Asset_Type_Stormwater_Pipe	String	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Stormwater_Pump_Station	String	Coded Value	Duplicate	Default Value	2	1
BMP_Class	String	Coded Value	Duplicate	Default Value	3	2
Catch Basin_adoptionstatus	String	Coded Value	Default Value	Default Value	2	1
Catch Basin_publicview	String	Coded Value	Default Value	Default Value	2	1
Condition	Short Integer	Coded Value	Default Value	Default Value	5	12
ESRI_FIX_TYPE_DOMAIN	Short Integer	Coded Value	Default Value	Default Value	5	6
ESRI_NUM_SATS_DOMAIN	Short Integer	Range	Default Value	Default Value		6
ESRI_STATION_ID_DOMAIN	Short Integer	Range	Default Value	Default Value		6
Is private	String	Coded Value	Duplicate	Default Value	2	1
Lifecycle_Status	String	Coded Value	Duplicate	Default Value	10	12
Monitoring_lifecyclestatus_cb95ce01-9d73-49fb-8dcb-c5768bd1bff6	String	Coded Value	Default Value	Default Value	10	1
Spatial_Confidence	String	Coded Value	Duplicate	Default Value	4	12
Spatial_Source	String	Coded Value	Duplicate	Default Value	6	12
Storm_Manhole_Cone	String	Coded Value	Duplicate	Default Value	3	1
Storm_Manhole_Cover_Shape	String	Coded Value	Duplicate	Default Value	4	1
Storm_Manhole_Cover_Type	String	Coded Value	Duplicate	Default Value	7	1
Storm_Manhole_Location	String	Coded Value	Duplicate	Default Value	14	1
Storm_Manhole_Step_Material	String	Coded Value	Duplicate	Default Value	5	1
Storm_Manhole_Surface	String	Coded Value	Duplicate	Default Value	7	1
Storm_Materials	String	Coded Value	Duplicate	Default Value	12	4
Stormwater_BMP_Material	String	Coded Value	Duplicate	Default Value	16	1
Stormwater_Catch_Basin_Opening_Type	String	Coded Value	Duplicate	Default Value	4	1
Stormwater_Catch_Basin_Shape	String	Coded Value	Duplicate	Default Value	4	1
Stormwater_Culvert_Diameter	Double	Coded Value	Duplicate	Default Value	30	1
Stormwater_Culvert_Shape	String	Coded Value	Duplicate	Default Value	8	1
Stormwater_Exiting_System	String	Coded Value	Duplicate	Default Value	4	4
Stormwater_Monitoring_Type	String	Coded Value	Duplicate	Default Value	5	1
Stormwater_Open_Channel_Type	String	Coded Value	Duplicate	Default Value	3	1
Stormwater_Outlet_Diameter	Double	Coded Value	Duplicate	Default Value	29	1
Stormwater_Outlet_Location	String	Coded Value	Duplicate	Default Value	4	1
Stormwater_Outlet_Material	String	Coded Value	Duplicate	Default Value	15	1
Stormwater_Pipe_Diameter	Double	Coded Value	Duplicate	Default Value	30	2
Stormwater_Pipe_Liner_Method	String	Coded Value	Duplicate	Default Value	14	1
Stormwater_Pipe_Liner_Year	Short Integer	Range	Duplicate	Default Value		1
Stormwater_Pipe_Material	String	Coded Value	Duplicate	Default Value	27	3
Stormwater_Pipe_Shape	String	Coded Value	Duplicate	Default Value	8	1
Stormwater_Pump_Type	String	Coded Value	Duplicate	Default Value	7	1
Symbol_Rotation	Short Integer	Range	Duplicate	Default Value		6
VerificationStatus	String	Coded Value	Duplicate	Default Value	5	1
Yes_No	String	Coded Value	Duplicate	Default Value	3	18
Yes_No_NA	String	Coded Value	Duplicate	Default Value	3	5

Datasets

BMP_Boundary

Properties

Key	Value
Name	BMP_Boundary
Dataset Type	FeatureClass
Dataset ID	-1
Geometry Type	Polygon
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	10.0
Alias	BMP_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	1013018.428613156
X-Max	1053821.577747499
Y-Min	1831828.910787279
Y-Max	1886573.114242457
Catalog ID	{6191E980-553B-4C5F-86FA-55368C40578B}
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_BMP_Boundary	Unknown	0	50	True	False	Type of asset
assetid	Asset ID	String	Index	True			0	255	True	False	Unique identifier for the asset
lifecyclestatus	Lifecycle Status	String		False	Lifecycle_Status	In Service	0	25	True	False	Current phase or state of an asset within its lifecycle
additionaldetails	BMP Class	String		True	BMP_Class	Unknown	0	30	True	False	Provides additional classification details about the BMP
spatialsource	Spatial Source	String		True	Spatial_Source	Unknown	0	25	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence	Unknown	0	25	True	False	Confidence level in the location accuracy of the asset
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
created_date	Creation date	Date	Created;Index	True			1	8	False	True	Date when the record was created
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
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

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__5242E6329BFACF5A	True	True	objectid
FDO_globalid	True	True	globalid
IX_STORMWATERSYSTEM_72023BC0A0D040E0BD0B75D6C4144DD0_BMP_BOUNDARY_assetid_ASC	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
Shape__Area_Index	False	True	Shape__Area
Shape__Length_Index	False	True	Shape__Length
StormwaterSystem_3795a353143b4d59af21d1646ac8fbee_BMP_BOUNDARY_Shape_sidx	False	True	Shape

BMP_Inlet

Properties

Key	Value
Name	BMP_Inlet
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	BMP_Inlet
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	1013018.428613156
X-Max	1053821.577747499
Y-Min	1831828.910787279
Y-Max	1886573.114242457
Catalog ID	{4CBD6A2E-12FD-4354-89B8-7526A963903F}
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_BMP_Inlet	Unknown	0	30	True	False	Type of asset
assetid	Asset ID	String	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
lifecyclestatus	Lifecycle Status	String		False	Lifecycle_Status	In Service	0	25	True	False	Current phase or state of an asset within its lifecycle
permitted	Permitted	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the asset is permitted
permitid	Permit ID	String		True			0	50	True	False	Unique identifier for the permit associated with the asset
surfacewater	Receives Surface Water	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the asset receives surface water
exitsystem	Water Exiting System	String		True	Stormwater_Exiting_System	Unknown	0	25	True	False	Describes where the water exits the system
invertelev	Invert Elevation	Double		True			0	0	True	False	Invert elevation of the asset
wall	Wall	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the asset has a wall
ownedby	Owned By	String		True	Asset_Owner	Our Agency	0	25	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Asset_Manager	Our Agency	0	25	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Additional notes about the asset
spatialsource	Spatial Source	String		True	Spatial_Source	Unknown	0	25	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence	Unknown	0	25	True	False	Confidence level in the location accuracy of the asset
symbolrotation	Symbol Rotation	Short Integer		True	Symbol_Rotation		0	0	True	False	Rotation of the symbol representing the asset
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
created_date	Creation date	Date	Created;Index	True			1	8	False	True	Date when the record was created
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the receiver used to capture the location
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_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_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_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_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Date and time the GPS receiver became fixed
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

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__5242E63285F27338	True	True	objectid
FDO_globalid	True	True	globalid
I105assetid	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
StormwaterSystem_3795a353143b4d59af21d1646ac8fbee_BMP_INLET_Shape_sidx	False	True	Shape

BMP_Inspection

Properties

Key	Value
Name	BMP_Inspection
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	BMP_Inspection
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	{47F8EBE9-3981-4AFF-AF47-05F56B02E81F}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D85DBCD558A	True	True	OBJECTID
FDO_globalid	True	True	globalid
G56assetguid	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

BMP_Point

Properties

Key	Value
Name	BMP_Point
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	BMP_Point
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	1013018.428613156
X-Max	1053821.577747499
Y-Min	1831828.910787279
Y-Max	1886573.114242457
Catalog ID	{F4F1304F-92D2-443B-8FF8-B7BEFED331B2}
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_BMP_Point	Unknown	0	50	True	False	Type of asset
assetid	Asset ID	String	Index	True			0	64	True	False	Unique identifier for the asset
material	BMP Material	String		True	Stormwater_BMP_Material	Unknown	0	50	True	False	Material used in the BMP
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	String		False	Lifecycle_Status	In Service	0	25	True	False	Current phase or state of an asset within its lifecycle
rimelev	Rim Elevation	Double		True			0	0	True	False	Elevation of the rim
invertelev	Invert Elevation	Double		True			0	0	True	False	Elevation of the invert
depth	Depth	Double		True			0	0	True	False	Depth of the asset
additionaldetails	BMP Class	String		True	BMP_Class	Unknown	0	30	True	False	Additional details about the BMP class
designtype	Confined Space	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the asset is a confined space
additionaldevice	Observation Port	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the asset has an observation port
inletcount	Number of Inlets	Short Integer		True			0	0	True	False	Number of inlets in the asset
outletcount	Number of Outlets	Short Integer		True			0	0	True	False	Number of outlets in the asset
volume	Storage Volume	Double		True			0	0	True	False	Storage volume of the asset
rate	Treatment Rate	Double		True			0	0	True	False	Treatment rate of the asset
rate2	Infilitration Rate	Double		True			0	0	True	False	Infiltration rate of the asset
resuse	Capture and Reuse	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the asset is capable of capture and reuse
ownedby	Owned By	String		True	Asset_Owner	Our Agency	0	25	True	False	Entity that owns the asset
assignto	Assigned To	String		True			0	255	True	False	Private property owner Username if using the Stormwater BMP Inspections solution
maintby	Maintained By	String		True	Asset_Manager	Our Agency	0	25	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Additional notes about the asset
spatialsource	Spatial Source	String		True	Spatial_Source	Unknown	0	25	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence	Unknown	0	25	True	False	Confidence level in the location accuracy of the asset
symbolrotation	Symbol Rotation	Short Integer		True	Symbol_Rotation		0	0	True	False	Rotation of the symbol representing the asset
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
created_date	Creation date	Date	Created;Index	True			1	8	False	True	Date when the record was created
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the receiver used to capture the location
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_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_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_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_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Date and time the GPS receiver became fixed
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

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__5242E632CFEAC841	True	True	objectid
FDO_globalid	True	True	globalid
I54assetid	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
StormwaterSystem_3795a353143b4d59af21d1646ac8fbee_BMP_POINT_Shape_sidx	False	True	Shape

BMPBoundaryRelate

Properties

Key	Value
Name	BMPBoundaryRelate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	BMPBoundaryRelate
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	{580C7F1C-1D6E-42A3-B835-9546D92704D4}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D85598EAD0C	True	True	OBJECTID
FDO_globalid	True	True	globalid
G150assetguid	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

BMPInletRelate

Properties

Key	Value
Name	BMPInletRelate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	BMPInletRelate
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	{1F287534-0757-496A-B547-29FAB35853FC}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D850FB395E9	True	True	OBJECTID
FDO_globalid	True	True	globalid
G107assetguid	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

BMPPoint_Verification

Properties

Key	Value
Name	BMPPoint_Verification
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	BMPPoint_Verification
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	{849734E9-9EF2-4016-AD74-B276592AE5D5}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False		0	0	False	True	Unique identifier for each record
assetguid	assetguid	GUID	Index	True		0	38	True	False	A unique identifier for the asset being inspected
operate	operate	String		True	Yes_No_NA	0	25	True	False	Indicates if the asset is operational
assetid	assetid	String		True		0	64	True	False	Unique identifier for the asset
verifydate	verifydate	Date		True		1	8	True	False	Date when the asset was last verified
replace	replace	String		True	Yes_No_NA	0	25	True	False	Indicates if the asset needs to be replaced
datereplace	datereplace	Date		True		1	8	True	False	Date when the asset was replaced
schedule	schedule	String		True	Yes_No_NA	0	25	True	False	Indicates if the asset is scheduled for maintenance
cleaned	cleaned	String		True	Yes_No_NA	0	25	True	False	Indicates if the asset has been cleaned
verifycomments	verifycomments	String		True		0	255	True	False	Comments related to the verification of the asset
year	year	Short Integer		True		0	0	True	False	Year when the asset was installed or last updated
assettype	assettype	String		True	Asset_Type_Stormwater_BMP_Point	0	50	True	False	Type of asset
isprivate	isprivate	String		True	Is private	0	10	True	False	Indicates if the asset is privately owned
status	status	String		True	VerificationStatus	0	255	True	False	Current status of the asset verification
username	Username	String		True		0	255	True	False	Username of the person who last edited the asset information
fname	fname	String		True		0	100	True	False	First name of the person who last edited the asset information
lname	lname	String		True		0	100	True	False	Last name of the person who last edited the asset information
email	email	String		True		0	100	True	False	Email of the person who last edited the asset information
globalid	GlobalID	Global ID	Index	False		0	38	False	True	Globally unique identifier for the asset
created_date	Creation Date	Date	Created;Index	True		1	8	False	True	Date when the record was created
created_user	Creator	String	Creator;Index	True		0	128	False	True	User who created the record
last_edited_date	Edit Date	Date	Edited;Index	True		1	8	False	True	Date when the record was last edited
last_edited_user	Editor	String	Editor;Index	True		0	128	False	True	User who last edited the record

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D8506A48468	True	True	OBJECTID
FDO_globalid	True	True	globalid
G57assetguid	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

BMPPoint_VerificationComments

Properties

Key	Value
Name	BMPPoint_VerificationComments
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	BMPPoint_VerificationComments
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	{076038E4-90F7-4D19-80A2-B1EF1CC36FAC}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D85970ADEE2	True	True	OBJECTID
FDO_globalid	True	True	globalid
G60giverifyguid	False	True	giverifyguid
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

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	1013018.428613156
X-Max	1053821.577747499
Y-Min	1831828.910787279
Y-Max	1886573.114242457
Catalog ID	{E002E87A-DCEE-4223-8ED1-046AFFA03807}
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_Catch_Basin	Unknown	0	30	True	False	Type of asset
assetid	Asset ID	String	Index	True			0	64	True	False	Unique identifier for the asset
surfacewater	Receives Surface Water	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the asset receives surface water
exitsystem	Water Exiting System	String		True	Stormwater_Exiting_System	Unknown	0	25	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	Lifecycle_Status	In Service	0	25	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 asset
invertelev	Invert Elevation	Double		True			0	0	True	False	Elevation of the invert 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	Storm_Materials	Unknown	0	50	True	False	Material of the asset's wall
framematerial	Frame Material	String		True	Storm_Materials	Unknown	0	50	True	False	Material of the asset's frame
additionaldevice	Sump	String		True	Yes_No	Unknown	0	10	True	False	Indicates if there is an additional device like a sump
designtype	Opening Type	String		True	Stormwater_Catch_Basin_Opening_Type	Unknown	0	30	True	False	Type of opening in the asset
additionaldetails	Inlet Shape	String		True	Stormwater_Catch_Basin_Shape		0	30	True	False	Shape of the catch basin
signage	Signage	String		True	Yes_No	Unknown	0	10	True	False	Indicates if there is signage
ownedby	Owned By	String		True	Asset_Owner	Our Agency	0	25	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Asset_Manager	Our Agency	0	25	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Additional notes about the asset
spatialsource	Spatial Source	String		True	Spatial_Source	Unknown	0	25	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence	Unknown	0	25	True	False	Confidence level in the location accuracy of the asset
symbolrotation	Symbol Rotation	Short Integer		True	Symbol_Rotation		0	0	True	False	Rotation of the symbol representing the asset
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
created_date	Creation date	Date	Created;Index	True			1	8	False	True	Date when the record was created
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
adoptionstatus	Adoption Status	String		True	Catch Basin_adoptionstatus		0	50	True	False	Status of the asset's adoption
adoptedby	Adopted By	String		True			0	255	True	False	Entity that adopted the asset
adoptedon	Adopted On	Date		True			1	8	True	False	Date when the asset was adopted
nickname	Nickname	String		True			0	255	True	False	Nickname of the asset
fulladdr	Nearest Address	String		True			0	255	True	False	Nearest address to the asset
publicview	Publicly Visible	String		True	Catch Basin_publicview		0	5	True	False	Indicates if the asset is publicly visible
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the receiver used to capture the location
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_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_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_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_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Date and time the GPS receiver became fixed
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

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__5242E6324159367E	True	True	objectid
FDO_globalid	True	True	globalid
IX_STORMWATERSYSTEM_72023BC0A0D040E0BD0B75D6C4144DD0_CATCH_BASIN_assetid_ASC	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
StormwaterSystem_3795a353143b4d59af21d1646ac8fbee_CATCH_BASIN_Shape_sidx	False	True	Shape

Catch_Basin_Inspection

Properties

Key	Value
Name	Catch_Basin_Inspection
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	Catch_Basin_Inspection
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	{B6803A63-CAC4-4C94-AE8C-F4768AF47BD1}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D85E97A31A6	True	True	OBJECTID
FDO_globalid	True	True	globalid
G32assetguid	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

Catchment_Boundary

Properties

Key	Value
Name	Catchment_Boundary
Dataset Type	FeatureClass
Dataset ID	-1
Geometry Type	Polygon
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	10.0
Alias	Catchment_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	1013018.428613156
X-Max	1053821.577747499
Y-Min	1831828.910787279
Y-Max	1886573.114242457
Catalog ID	{70C7C706-031F-43CF-A37F-324C0DA7A8BB}
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_Catchment_Boundary	Unknown	0	50	True	False	Type of asset
name	Name	String	Index	True			0	255	True	False	Name of the stormwater asset
lifecyclestatus	Lifecycle Status	String		False	Lifecycle_Status	In Service	0	25	True	False	Current phase or state of an asset within its lifecycle
spatialsource	Spatial Source	String		True	Spatial_Source	Unknown	0	25	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence	Unknown	0	25	True	False	Confidence level in the location accuracy of the asset
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date when the record was created
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
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

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__5242E6323A552F7F	True	True	objectid
FDO_globalid	True	True	globalid
IX_STORMWATERSYSTEM_72023BC0A0D040E0BD0B75D6C4144DD0_CATCHMENT_BOUNDARY_name_ASC	False	True	name
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
Shape__Area_Index	False	True	Shape__Area
Shape__Length_Index	False	True	Shape__Length
StormwaterSystem_3795a353143b4d59af21d1646ac8fbee_CATCHMENT_BOUNDARY_Shape_sidx	False	True	Shape

CatchmentBoundaryRelate

Properties

Key	Value
Name	CatchmentBoundaryRelate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	CatchmentBoundaryRelate
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	{F7CDF546-E012-4A8B-BE54-9D794A85408C}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D85F0C960F5	True	True	OBJECTID
FDO_globalid	True	True	globalid
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

Culvert

Properties

Key	Value
Name	Culvert
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	Culvert
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	1013018.428613156
X-Max	1053821.577747499
Y-Min	1831828.910787279
Y-Max	1886573.114242457
Catalog ID	{0103A7C7-EFD6-4968-9BFC-0CAD60090180}
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_Culvert	Unknown	0	25	True	False	Type of asset
assetid	Asset ID	String	Index	True			0	64	True	False	Unique identifier for the asset
material	Material	String		True	Stormwater_Pipe_Material	Unknown	0	50	True	False	Material of the stormwater culvert
pipeshape	Culvert Shape	String		True	Stormwater_Culvert_Shape	Unknown	0	30	True	False	Shape of the culvert
diameter	Diameter	Double		True	Stormwater_Culvert_Diameter	0	0	0	True	False	Diameter of the asset
width	Width	Double		True			0	0	True	False	Width of the culvert
height	Height	Double		True			0	0	True	False	Height of the culvert
wall	Wall	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the culvert has a wall
upelev	Upstream Elevation	Double		True			0	0	True	False	Elevation at the upstream end of the culvert
downelev	Downstream Elevation	Double		True			0	0	True	False	Elevation at the downstream end of the culvert
slope	Slope	Double		True			0	0	True	False	Slope of the culvert
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	String		False	Lifecycle_Status	In Service	0	25	True	False	Current phase or state of an asset within its lifecycle
ownedby	Owned By	String		True	Asset_Owner	Our Agency	0	25	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Asset_Manager	Our Agency	0	25	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Additional notes about the culvert
spatialsource	Spatial Source	String		True	Spatial_Source	Unknown	0	25	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence	Unknown	0	25	True	False	Confidence level in the location accuracy of the asset
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
created_date	Creation date	Date	Created;Index	True			1	8	False	True	Date when the record was created
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
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

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__5242E632715A35C3	True	True	objectid
FDO_globalid	True	True	globalid
I115assetid	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
Shape__Length_Index	False	True	Shape__Length
StormwaterSystem_3795a353143b4d59af21d1646ac8fbee_CULVERT_Shape_sidx	False	True	Shape

CulvertRelate

Properties

Key	Value
Name	CulvertRelate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	CulvertRelate
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	{6264B897-05A4-4FA3-8CE4-C1B7AFB2B569}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D854E0668C1	True	True	OBJECTID
FDO_globalid	True	True	globalid
G116assetguid	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

Linear_Drain

Properties

Key	Value
Name	Linear_Drain
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	Linear_Drain
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	1013018.428613156
X-Max	1053821.577747499
Y-Min	1831828.910787279
Y-Max	1886573.114242457
Catalog ID	{B75F9099-1DFA-4112-B076-869E1CF0490E}
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_Linear_Drain	Unknown	0	30	True	False	Type of asset
assetid	Asset ID	String	Index	True			0	64	True	False	Unique identifier for the asset
material	Material	String		True	Stormwater_Pipe_Material	Unknown	0	50	True	False	Material of the stormwater asset
diameter	Diameter	Double		True	Stormwater_Pipe_Diameter	0	0	0	True	False	Diameter of the asset
upelev	Upstream Elevation	Double		True			0	0	True	False	Elevation at the upstream end of the asset
downelev	Downstream Elevation	Double		True			0	0	True	False	Elevation at the downstream end of the asset
slope	Slope	Double		True			0	0	True	False	Slope of the stormwater asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	String		False	Lifecycle_Status	In Service	0	25	True	False	Current phase or state of an asset within its lifecycle
ownedby	Owned By	String		True	Asset_Owner	Our Agency	0	25	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Asset_Manager	Our Agency	0	25	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Additional notes about the stormwater asset
spatialsource	Spatial Source	String		True	Spatial_Source	Unknown	0	25	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence	Unknown	0	25	True	False	Confidence level in the location accuracy of the asset
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
created_date	Creation date	Date	Created;Index	True			1	8	False	True	Date when the record was created
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
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

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__5242E63270953509	True	True	objectid
FDO_globalid	True	True	globalid
I132assetid	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
Shape__Length_Index	False	True	Shape__Length
StormwaterSystem_3795a353143b4d59af21d1646ac8fbee_LINEAR_DRAIN_Shape_sidx	False	True	Shape

LinearDrainRelate

Properties

Key	Value
Name	LinearDrainRelate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	LinearDrainRelate
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	{8F36BCD8-4664-42CF-A99F-669F882CE80D}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D855604D5A6	True	True	OBJECTID
FDO_globalid	True	True	globalid
G134assetguid	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

Manhole

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_Storm_Manhole	Unknown	0	30	True	False	Type of asset
assetid	Asset ID	String	Index	True			0	64	True	False	Unique identifier for the asset
conetype	Cone Type	String		True	Storm_Manhole_Cone	Unknown	0	30	True	False	Type of cone used in the manhole
location	Manhole Location	String		True	Storm_Manhole_Location	Unknown	0	30	True	False	Location of the manhole
surface	Manhole Surface Type	String		True	Storm_Manhole_Surface	Unknown	0	30	True	False	Type of surface where the manhole is located
covershape	Cover Shape	String		True	Storm_Manhole_Cover_Shape	Unknown	0	30	True	False	Shape of the manhole cover
type	Cover Type	String		True	Storm_Manhole_Cover_Type	Unknown	0	30	True	False	Type of the manhole cover
rimelev	Rim Elevation	Double		True			0	0	True	False	Elevation of the manhole rim
invertelev	Invert Elevation	Double		True			0	0	True	False	Elevation of the manhole invert
depth	Depth	Double		True			0	0	True	False	Depth of the asset
highpipeelev	High Pipe Elevation	Double		True			0	0	True	False	Elevation of the highest pipe in the manhole
channel	Channel	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the manhole has a channel
bench	Bench	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the manhole has a bench
framematerial	Frame Material	String		True	Storm_Materials	Unknown	0	50	True	False	Material of the manhole frame
wallmaterial	Wall Material	String		True	Storm_Materials	Unknown	0	50	True	False	Material of the manhole wall
numsteps	Number of Steps	Short Integer		True			0	0	True	False	Number of steps in the manhole
stepmaterial	Step Material	String		True	Storm_Manhole_Step_Material	Unknown	0	30	True	False	Material of the manhole steps
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	String		False	Lifecycle_Status	In Service	0	25	True	False	Current phase or state of an asset within its lifecycle
surfacewater	Receives Surface Water	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the manhole receives surface water
exitsystem	Water Exiting System	String		True	Stormwater_Exiting_System	Unknown	0	25	True	False	Where the water exits the system
ownedby	Owned By	String		True	Asset_Owner	Our Agency	0	25	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Asset_Manager	Our Agency	0	25	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Additional notes about the manhole
spatialsource	Spatial Source	String		True	Spatial_Source	Unknown	0	25	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence	Unknown	0	25	True	False	Confidence level in the location accuracy of the asset
symbolrotation	Symbol Rotation	Short Integer		True	Symbol_Rotation		0	0	True	False	Rotation of the symbol representing the manhole
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
created_date	Creation date	Date	Created;Index	True			1	8	False	True	Date when the record was created
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the receiver used to capture the location
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_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_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_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_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Date and time the GPS receiver became fixed
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

Indexes

Manhole_Inspection

Properties

Fields

Indexes

Monitoring

Properties

Fields

Indexes

MonitorRelate

Properties

Fields

Indexes

Open_Channel

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_Open Channel	Unknown	0	50	True	False	Type of asset
assetid	Asset ID	String	Index	True			0	64	True	False	Unique identifier for the asset
upelev	Upstream Elevation	Double		True			0	0	True	False	Elevation at the upstream end of the asset
downelev	Downstream Elevation	Double		True			0	0	True	False	Elevation at the downstream end of the asset
slope	Slope	Double		True			0	0	True	False	Gradient or steepness of the asset
width	Width	Double		True			0	0	True	False	Width of the asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	String		False	Lifecycle_Status	In Service	0	25	True	False	Current phase or state of an asset within its lifecycle
type	Type	String		True	Stormwater_Open_Channel_Type	Unknown	0	10	True	False	Specific type of the stormwater asset
ownedby	Owned By	String		True	Asset_Owner	Our Agency	0	25	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Asset_Manager	Our Agency	0	25	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Additional information about the asset
spatialsource	Spatial Source	String		True	Spatial_Source	Unknown	0	25	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence	Unknown	0	25	True	False	Confidence level in the location accuracy of the asset
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
created_date	Creation date	Date	Created;Index	True			1	8	False	True	Date when the record was created
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
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

Indexes

OpenChannelRelate

Properties

Fields

Indexes

Outlet

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_Outlet	Unknown	0	50	True	False	Type of asset
assetid	Asset ID	String	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
lifecyclestatus	Lifecycle Status	String		False	Lifecycle_Status	In Service	0	25	True	False	Current phase or state of an asset within its lifecycle
material	Outlet Material	String		True	Stormwater_Outlet_Material	Unknown	0	50	True	False	Material of the outlet
diameter	Diameter	Double		True	Stormwater_Outlet_Diameter	0	0	0	True	False	Diameter of the asset
permitted	Permitted	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the asset is permitted
permitid	Permit ID	String		True			0	50	True	False	Unique identifier for the permit
location	Location	String		True	Stormwater_Outlet_Location	Unknown	0	25	True	False	Location of the outlet
surfacewater	Receives Surface Water	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the outlet receives surface water
exitsystem	Water Exiting System	String		True	Stormwater_Exiting_System	Unknown	0	25	True	False	Describes where the water exits the system
invertelev	Invert Elevation	Double		True			0	0	True	False	Invert elevation of the outlet
wall	Wall	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the outlet has a wall
additionaldetails	Outfall	String		True	Yes_No_NA	No	0	5	True	False	Additional details about the outfall
outfallid	Outfall ID	String	Index	True			0	64	True	False	Unique identifier for the outfall
ownedby	Owned By	String		True	Asset_Owner	Our Agency	0	25	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Asset_Manager	Our Agency	0	25	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Additional notes about the asset
spatialsource	Spatial Source	String		True	Spatial_Source	Unknown	0	25	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence	Unknown	0	25	True	False	Confidence level in the location accuracy of the asset
symbolrotation	Symbol Rotation	Short Integer		True	Symbol_Rotation		0	0	True	False	Rotation of the symbol representing the asset
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
created_date	Creation date	Date	Created;Index	True			1	8	False	True	Date when the record was created
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the receiver used to capture the location
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_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_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_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_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Date and time the GPS receiver became fixed
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

Indexes

Outlet_Inspection

Properties

Fields

Indexes

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_Pipe	Unknown	0	25	True	False	Type of asset
assetid	Asset ID	String	Index	True			0	64	True	False	Unique identifier for the asset
material	Material	String		True	Stormwater_Pipe_Material	Unknown	0	50	True	False	Material composition of the stormwater pipe
diameter	Diameter	Double		True	Stormwater_Pipe_Diameter	0	0	0	True	False	Diameter of the asset
upelev	Upstream Elevation	Double		True			0	0	True	False	Elevation at the upstream end of the pipe
downelev	Downstream Elevation	Double		True			0	0	True	False	Elevation at the downstream end of the pipe
slope	Slope	Double		True			0	0	True	False	Slope of the stormwater pipe
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	String		False	Lifecycle_Status	In Service	0	25	True	False	Current phase or state of an asset within its lifecycle
pipeshape	Pipe Shape	String		True	Stormwater_Pipe_Shape	Unknown	0	50	True	False	Shape of the stormwater pipe
lined	Lined?	String		True	Yes_No	Unknown	0	10	True	False	Indicates if the stormwater pipe is lined
lineryear	Liner Year	Short Integer		True	Stormwater_Pipe_Liner_Year		0	0	True	False	Year when the liner was installed in the stormwater pipe
linermethod	Liner Method	String		True	Stormwater_Pipe_Liner_Method	Unknown	0	50	True	False	Method used to install the liner in the stormwater pipe
ownedby	Owned By	String		True	Asset_Owner	Our Agency	0	25	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Asset_Manager	Our Agency	0	25	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Additional notes or comments about the stormwater pipe
spatialsource	Spatial Source	String		True	Spatial_Source	Unknown	0	25	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence	Unknown	0	25	True	False	Confidence level in the location accuracy of the asset
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
created_date	Creation date	Date	Created;Index	True			1	8	False	True	Date when the record was created
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
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

Indexes

PipeRelate

Properties

Fields

Indexes

Pump_Station

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_Pump_Station		0	30	True	False	Type of asset
assetid	Asset ID	String	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
lifecyclestatus	Lifecycle Status	String		False	Lifecycle_Status	In Service	0	25	True	False	Current phase or state of an asset within its lifecycle
rimelev	Rim Elevation	Double		True			0	0	True	False	Elevation of the rim of the asset
invertelev	Invert Elevation	Double		True			0	0	True	False	Elevation of the invert 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
volume	Storage Volume	Double		True			0	0	True	False	Storage volume of the asset
designtype	Pump Type	String		True	Stormwater_Pump_Type	Unknown	0	30	True	False	Type of pump used in the asset
additionaldevice	Sump	String		True	Yes_No	Unknown	0	10	True	False	Indicates if there is a sump present
ownedby	Owned By	String		True	Asset_Owner	Our Agency	0	25	True	False	Entity that owns the asset
maintby	Maintained By	String		True	Asset_Manager	Our Agency	0	25	True	False	Entity that maintains the asset
notes	Notes	String		True			0	2000	True	False	Additional notes about the asset
spatialsource	Spatial Source	String		True	Spatial_Source	Unknown	0	25	True	False	Source of the spatial data for the asset
spatialconfidence	Spatial Confidence	String		True	Spatial_Confidence	Unknown	0	25	True	False	Confidence level in the location accuracy of the asset
symbolrotation	Symbol Rotation	Short Integer		True	Symbol_Rotation		0	0	True	False	Rotation of the symbol representing the asset
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the asset
created_date	Creation date	Date	Created;Index	True			1	8	False	True	Date when the record was created
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date when the record was last edited
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	User who last edited the record
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the receiver used to capture the location
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_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_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_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_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Date and time the GPS receiver became fixed
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

Indexes

PumpStationRelate

Properties

Fields

Indexes

Domains

Asset_Manager

Asset_Owner

Asset_Type_BMP_Boundary

Asset_Type_Catchment_Boundary

Asset_Type_Storm_Manhole

Asset_Type_Stormwater_BMP_Inlet

Asset_Type_Stormwater_BMP_Point

Asset_Type_Stormwater_Catch_Basin

Asset_Type_Stormwater_Culvert

Asset_Type_Stormwater_Linear_Drain

Asset_Type_Stormwater_Open Channel

Asset_Type_Stormwater_Outlet

Asset_Type_Stormwater_Pipe

Asset_Type_Stormwater_Pump_Station

BMP_Class

Catch Basin_adoptionstatus

Catch Basin_publicview

Condition

ESRI_FIX_TYPE_DOMAIN

ESRI_NUM_SATS_DOMAIN

ESRI_STATION_ID_DOMAIN

Is private

Lifecycle_Status

Monitoring_lifecyclestatus_cb95ce01-9d73-49fb-8dcb-c5768bd1bff6

Spatial_Confidence

Spatial_Source

Storm_Manhole_Cone

Storm_Manhole_Cover_Shape

Storm_Manhole_Cover_Type

Storm_Manhole_Location

Storm_Manhole_Step_Material

Storm_Manhole_Surface

Storm_Materials

Stormwater_BMP_Material

Stormwater_Catch_Basin_Opening_Type

Stormwater_Catch_Basin_Shape

Stormwater_Culvert_Diameter

Stormwater_Culvert_Shape

Stormwater_Exiting_System

Stormwater_Monitoring_Type

Stormwater_Open_Channel_Type

Stormwater_Outlet_Diameter

Stormwater_Outlet_Location

Stormwater_Outlet_Material

Stormwater_Pipe_Diameter

Stormwater_Pipe_Liner_Method

Stormwater_Pipe_Liner_Year

Stormwater_Pipe_Material

Stormwater_Pipe_Shape

Stormwater_Pump_Type

Symbol_Rotation

VerificationStatus

Yes_No

Yes_No_NA

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__5242E6327E8BBF5A	True	True	objectid
FDO_globalid	True	True	globalid
I97assetid	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
StormwaterSystem_3795a353143b4d59af21d1646ac8fbee_MANHOLE_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D85B79387F4	True	True	OBJECTID
FDO_globalid	True	True	globalid
G98assetguid	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

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D85EF3B6483	True	True	OBJECTID
FDO_GlobalID	True	True	GlobalID
IX_STORMWATERSYSTEM_72023BC0A0D040E0BD0B75D6C4144DD0_MONITORING5_assetid_ASC	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
StormwaterSystem_3795a353143b4d59af21d1646ac8fbee_MONITORING_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D85F50956E7	True	True	OBJECTID
FDO_GlobalID	True	True	GlobalID
G85assetguid	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

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__5242E63249FDA2D7	True	True	objectid
FDO_globalid	True	True	globalid
I124assetid	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
Shape__Length_Index	False	True	Shape__Length
StormwaterSystem_3795a353143b4d59af21d1646ac8fbee_OPEN_CHANNEL_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D8552C7207C	True	True	OBJECTID
FDO_globalid	True	True	globalid
G125assetguid	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

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__5242E6325F8B396F	True	True	objectid
FDO_globalid	True	True	globalid
I42outfallid	False	True	outfallid
IX_STORMWATERSYSTEM_72023BC0A0D040E0BD0B75D6C4144DD0_OUTLET_assetid_ASC	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
StormwaterSystem_3795a353143b4d59af21d1646ac8fbee_OUTLET_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D8586E2B0C7	True	True	OBJECTID
FDO_globalid	True	True	globalid
G43assetguid	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

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__5242E632A0F95A4A	True	True	objectid
FDO_globalid	True	True	globalid
I75assetid	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
Shape__Length_Index	False	True	Shape__Length
StormwaterSystem_3795a353143b4d59af21d1646ac8fbee_PIPE_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D8583045EDB	True	True	OBJECTID
FDO_globalid	True	True	globalid
G76assetguid	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

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__5242E6325D53E397	True	True	objectid
FDO_globalid	True	True	globalid
I16assetid	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
StormwaterSystem_3795a353143b4d59af21d1646ac8fbee_PUMP_STATION_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__Stormwat__F4B70D85DA626B08	True	True	OBJECTID
FDO_globalid	True	True	globalid
G17assetguid	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
Bed Filter	Bed Filter
Bio-Filtration	Bio-Filtration
Bio-Retention	Bio-Retention
Bioswale	Bioswale
Detention Basin	Detention Basin
Dry Basin	Dry Basin
Filtration Device	Filtration Device
Green Roof	Green Roof
Infiltration Basin	Infiltration Basin
Infiltration Feature	Infiltration Feature
Media Filter	Media Filter
Pervious Pavement	Pervious Pavement
Retention Basin	Retention Basin
Sediment Trap	Sediment Trap
Settling Basin	Settling Basin
Treatment Vault	Treatment Vault
Wet Basin	Wet Basin

Code	Description	Details
Unknown	Unknown
Diversion Manhole	Diversion Manhole
Drop Manhole	Drop Manhole
Drop Trap Manhole	Drop Trap Manhole
Flush Manhole	Flush Manhole
Junction Manhole	Junction Manhole
Manhole	Manhole
Offset Manhole	Offset Manhole
Shallow Manhole	Shallow Manhole
Siphon Manhole	Siphon Manhole

Code	Description	Details
Unknown	Unknown
Apron Inlet	Apron Inlet
Channel Inlet	Channel Inlet
Pipe Inlet	Pipe Inlet

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

Code	Description	Details
Unknown	Unknown
Arch Culvert	Arch Culvert
Box Culvert	Box Culvert
Bridge Culvert	Bridge Culvert
Pipe Arch Culvert	Pipe Arch Culvert
Pipe Culvert	Pipe Culvert

Code	Description	Details
Unknown	Unknown
Slotted Drain	Slotted Drain
Trench Drain	Trench Drain

Code	Description	Details
Unknown	Unknown
Aquaduct Channel	Aquaduct Channel
Ditch Channel	Ditch Channel
Natural Channel	Natural Channel
Roadside Gutter	Roadside Gutter
Spillway Channel	Spillway Channel

Code	Description	Details
Unknown	Unknown
Apron Outlet	Apron Outlet
Broad-Crested Weir	Broad-Crested Weir
Combination Weir	Combination Weir
Flap Gate	Flap Gate
Labyrinth Weir	Labyrinth Weir
Minimum Energy Loss Weir	Minimum Energy Loss Weir
Pipe Outlet	Pipe Outlet
Riser	Riser
Sharp-Crested Weir	Sharp-Crested Weir
Tide Gate Chamber	Tide Gate Chamber
V-Notch Weir	V-Notch Weir

Code	Description	Details
Unknown	Unknown
Force Main	Force Main
Gravity	Gravity
Perforated	Perforated

Code	Description	Details
Unknown	Unknown
Centralized	Centralized
Decentralized	Decentralized

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

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

Code	Description	Details
Unknown	Unknown
Solid	Solid
Vented/Slotted	Vented/Slotted
Gasketed	Gasketed
Bolted	Bolted
Inner Cover	Inner Cover
Locking	Locking

Code	Description	Details
Unknown	Unknown
Main Highway	Main Highway
Light Highway	Light Highway
Easement/Right of Way	Easement/Right of Way
Woods	Woods
Sidewalk	Sidewalk
Parking Lot	Parking Lot
Alley	Alley
Ditch	Ditch
Building	Building
Creek	Creek
Railway	Railway
Airport	Airport
Yard	Yard

Code	Description	Details
Unknown	Unknown
Asphalt	Asphalt
Concrete Pavement	Concrete Pavement
Concrete Collar	Concrete Collar
Grass/Dirt	Grass/Dirt
Gravel	Gravel
Other	Other

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

Code	Description	Details
Unknown	Unknown
Amended Soil	Amended Soil
Biochar	Biochar
Bioretention Soil	Bioretention Soil
Brick	Brick
Concrete	Concrete
Gravel	Gravel
Iron-enhanced Filter	Iron-enhanced Filter
Mulch	Mulch
Native Soil	Native Soil
Pavers	Pavers
Permeable Pavement	Permeable Pavement
Rock	Rock
Sand Compost Mix	Sand Compost Mix
Sand Filter	Sand Filter
Spent Lime	Spent Lime

Code	Description	Details
Unknown	Unknown
Curb Opening	Curb Opening
Grate	Grate
Combination	Combination