Key | Value |
---|---|
Name | Stormwater_UtilityNetwork.geodatabase |
Workspace Type | Local Database |
Workspace Factory | Sqlite |
Geodatabase Release | 3.0.0 |
Date Exported | 2025-06-09 12:59:39 |
Path |
Owner | Domain Name | Description | Field Type | Domain Type | Split Policy | Merge Policy | # of Codes | # of Assignments |
---|---|---|---|---|---|---|---|---|
Asset_Manager | The manager of an asset. | Short Integer | Coded Value | Duplicate | Default Value | 3 | 20 | |
Asset_Owner | The owner of an asset. | Short Integer | Coded Value | Duplicate | Default Value | 3 | 20 | |
Asset_Type_Stormwater_Device_BMP_Inlet | The asset type for the stormwater devices's asset group BMP Inlet. | Short Integer | Coded Value | Duplicate | Default Value | 4 | 1 | |
Asset_Type_Stormwater_Device_BMP_Point | The asset type for the stormwater device's asset group BMP Point. | Short Integer | Coded Value | Duplicate | Default Value | 18 | 1 | |
Asset_Type_Stormwater_Device_Catch_Basin | The asset type for the stormwater device's asset group catch basin. | Short Integer | Coded Value | Duplicate | Default Value | 4 | 1 | |
Asset_Type_Stormwater_Device_Cleanout | The asset type for the stormwater device's asset group clean out. | Short Integer | Coded Value | Duplicate | Default Value | 2 | 1 | |
Asset_Type_Stormwater_Device_Connection | The asset type for the stormwater device's asset group pipe connection. | Short Integer | Coded Value | Duplicate | Default Value | 4 | 1 | |
Asset_Type_Stormwater_Device_Manhole_Channel | The asset type for the Stormwater device's asset group manhole channel. | Short Integer | Coded Value | Duplicate | Default Value | 3 | 1 | |
Asset_Type_Stormwater_Device_Outlet | The asset type for the stormwater device's asset group discharge. | Short Integer | Coded Value | Duplicate | Default Value | 6 | 1 | |
Asset_Type_Stormwater_Device_Pump | The asset type for the stormwater device's asset group pump. | Short Integer | Coded Value | Duplicate | Default Value | 2 | 1 | |
Asset_Type_Stormwater_Device_Weir | The asset type for the stormwater device's asset group weir. | Short Integer | Coded Value | Duplicate | Default Value | 7 | 1 | |
Asset_Type_Stormwater_Junction_Wall | The asset type for the stormwater junction's asset group wall. | Short Integer | Coded Value | Duplicate | Default Value | 5 | 1 | |
Asset_Type_Stormwater_Line_Culvert | The asset type for the stormwater line's asset group culvert | Short Integer | Coded Value | Duplicate | Default Value | 6 | 1 | |
Asset_Type_Stormwater_Line_Linear_Drain | The asset type for the stormwater line's asset group linear drain | Short Integer | Coded Value | Duplicate | Default Value | 3 | 1 | |
Asset_Type_Stormwater_Line_Open_Channel | The asset type for the stormwater line's asset group open channel. | Short Integer | Coded Value | Duplicate | Default Value | 6 | 1 | |
Asset_Type_Stormwater_Line_Pipe | The asset type for the stormwater line's asset group pipe | Short Integer | Coded Value | Duplicate | Default Value | 4 | 1 | |
Asset_Type_Structure_Boundary_BMP_Boundary | The asset type for the structure boundary's asset group BMP. | Short Integer | Coded Value | Duplicate | Default Value | 18 | 1 | |
Asset_Type_Structure_Boundary_Storm_Lift_Station_Boundary | The asset type for the structure boundary's asset group storm pump station. | Short Integer | Coded Value | Duplicate | Default Value | 2 | 1 | |
Asset_Type_Structure_Junction_Sewer_Storm_Vault | The asset type for the structure junction's asset group sewer storm vault. | Short Integer | Coded Value | Duplicate | Default Value | 2 | 1 | |
Attribute Rule Type | The attribute rule type that created the error record. | Short Integer | Coded Value | Default Value | Default Value | 3 | 4 | |
BMP_Class | The class of a BMP. | Short Integer | Coded Value | Duplicate | Default Value | 3 | 2 | |
Construction_Status | Valid Construction statues for the assets. | Short Integer | Coded Value | Duplicate | Default Value | 8 | 28 | |
Event_Level | The activate value of a stormwater or sewer device. | Short Integer | Coded Value | Duplicate | Default Value | 4 | 3 | |
Lifecycle_Combined | Bitwise combination of lifecycle states for subnetwork management | Short Integer | Coded Value | Duplicate | Default Value | 6 | 11 | |
Lifecycle_Status | Valid lifecycle states for the assets. | Short Integer | Coded Value | Duplicate | Default Value | 4 | 17 | |
Manhole_Types | Types of manholes. | Short Integer | Coded Value | Duplicate | Default Value | 10 | 1 | |
Network_6_AssociationStatus | Indicates how the feature participates in associations. | Short Integer | Coded Value | Duplicate | Default Value | 36 | 39 | |
Network_6_FeatureSourceID | The source feature class name in the utility network. | Short Integer | Coded Value | Default Value | Default Value | 16 | 0 | |
Network_6_FlowDirection | Indicates how the feature flows in network. | Short Integer | Coded Value | Duplicate | Default Value | 3 | 12 | |
Network_6_IsConnected | Indicates if the feature is connected to a subnetwork controller. | Short Integer | Coded Value | Duplicate | Default Value | 3 | 24 | |
Network_6_IsContentVisible | Indicates if the content or attachment association is visible for containment associations. | Short Integer | Coded Value | Default Value | Default Value | 2 | 0 | |
Network_6_IsDeleted | Indicates if a subnetwork has been marked for deletion. | Short Integer | Coded Value | Default Value | Default Value | 2 | 0 | |
Network_6_IsDirty | Indicates if a subnetwork is clean, dirty, or invalid. | Short Integer | Coded Value | Default Value | Default Value | 3 | 3 | |
Network_6_IsSubnetworkController | Indicates if a device feature is a subnetwork controller. | Short Integer | Coded Value | Default Value | Default Value | 2 | 13 | |
Network_6_TerminalNames | The terminal names in the utility network. | Short Integer | Coded Value | Duplicate | Default Value | 14 | 12 | |
Network_6_TierName | The tier names in the utility network. | Short Integer | Coded Value | Default Value | Default Value | 2 | 13 | |
Network_6_TierTopologyType | The type of topology for each tier. | Short Integer | Coded Value | Default Value | Default Value | 2 | 0 | |
Network_6_UnknownAssetType | The AssetType domain for the Unknown AssetGroup. | Short Integer | Coded Value | Default Value | Default Value | 1 | 11 | |
Spatial_Confidence | Confidence values for the data | Short Integer | Coded Value | Duplicate | Default Value | 4 | 24 | |
Spatial_Source | Source of the data | Short Integer | Coded Value | Duplicate | Default Value | 6 | 24 | |
Stormwater_BMP_Material | The material of stormwater BMPs | Short Integer | Coded Value | Duplicate | Default Value | 16 | 1 | |
Stormwater_Catch_Basin_Opening_Type | The type of catch basin | Short Integer | Coded Value | Duplicate | Default Value | 4 | 1 | |
Stormwater_Cleanout_Diameter | The diameter of stormwater cleanouts. | Double | Coded Value | Duplicate | Default Value | 30 | 1 | |
Stormwater_Cleanout_Material | The material of stormwater cleanouts. | Short Integer | Coded Value | Duplicate | Default Value | 27 | 1 | |
Stormwater_Culvert_Shape | The shape of stormwater culverts. | Short Integer | Coded Value | Duplicate | Default Value | 8 | 1 | |
Stormwater_Exiting_System | The way water exits the stormwater system. | Short Integer | Coded Value | Duplicate | Default Value | 4 | 5 | |
Stormwater_Inlet_Shape | The shpae of the stormwater inlet. | Short Integer | Coded Value | Duplicate | Default Value | 4 | 1 | |
Stormwater_Open_Channel_Type | The type of open channel. | Short Integer | Coded Value | Duplicate | Default Value | 3 | 1 | |
Stormwater_Outlet_Diameter | The diameter of a stormwater oulet. | Double | Coded Value | Duplicate | Default Value | 29 | 1 | |
Stormwater_Outlet_Location | The location of the stormwater oulet. | Short Integer | Coded Value | Duplicate | Default Value | 4 | 1 | |
Stormwater_Outlet_Material | The material of stormwater outlets. | Short Integer | Coded Value | Duplicate | Default Value | 27 | 1 | |
Stormwater_Pipe_Diameter | The diameter of stormwater pipes. | Double | Coded Value | Duplicate | Default Value | 30 | 2 | |
Stormwater_Pipe_Liner_Method | The liner method of stormwater pipes. | Short Integer | Coded Value | Duplicate | Default Value | 14 | 1 | |
Stormwater_Pipe_Liner_Year | The liner year of stormwater pipes. | Short Integer | Range | Duplicate | Default Value | 1 | ||
Stormwater_Pipe_Material | The material of stormwater pipes. | Short Integer | Coded Value | Duplicate | Default Value | 27 | 3 | |
Stormwater_Pipe_Shape | The shape of stormwater pipes. | Short Integer | Coded Value | Duplicate | Default Value | 8 | 1 | |
Stormwater_Pump_Type | The type of the stormwater pump. | Short Integer | Coded Value | Duplicate | Default Value | 7 | 1 | |
Stormwater_Wall_Material | The material of stormwater walls. | Short Integer | Coded Value | Duplicate | Default Value | 33 | 1 | |
Structure_Boundary_BMP_Condition | The condition of a BMP. | Short Integer | Coded Value | Duplicate | Default Value | 7 | 1 | |
Structure_Sewer_Storm_Manhole_Step_Material | The step material of structure manholes. | Short Integer | Coded Value | Duplicate | Default Value | 5 | 1 | |
Structure_Sewer_Storm_Materials | The materials of sewer storm structures. | Short Integer | Coded Value | Duplicate | Default Value | 12 | 3 | |
Structure_Sewer_Storm_Vault_Cover_Shape | The cover shape of structure manholes. | Short Integer | Coded Value | Duplicate | Default Value | 12 | 1 | |
Structure_Sewer_Storm_Vault_Cover_Type | The cover type of structure manholes. | Short Integer | Coded Value | Duplicate | Default Value | 7 | 1 | |
Structure_Sewer_Storm_Vault_Manhole_Cone | The cone type of structure manholes. | Short Integer | Coded Value | Duplicate | Default Value | 3 | 1 | |
Structure_Sewer_Storm_Vault_Manhole_Location | The location of structure manholes. | Short Integer | Coded Value | Duplicate | Default Value | 14 | 1 | |
Structure_Sewer_Storm_Vault_Manhole_Surface | The surface type of structure manholes. | Short Integer | Coded Value | Duplicate | Default Value | 7 | 1 | |
Symbol_Rotation | The rotation of an asset's symbol. | Short Integer | Range | Duplicate | Default Value | 15 | ||
Validation Error Exception | Indicates if the error record has been marked as an exception. | Short Integer | Coded Value | Default Value | Default Value | 2 | 4 | |
Validation Error Phase | Indicates error lifecycle phase of an error | Long Integer | Coded Value | Default Value | Default Value | 3 | 4 | |
Validation Error Status | Indicates error lifecycle status of an error | Long Integer | Coded Value | Default Value | Default Value | 6 | 4 | |
Validation Status | The current record's validation status. | Short Integer | Coded Value | Default Value | Default Value | 8 | 20 | |
Validation_Status | The current record's validation status. | Short Integer | Coded Value | Duplicate | Default Value | 8 | 0 | |
Yes_No | A yes/no indicator | Short Integer | Coded Value | Duplicate | Default Value | 3 | 20 |
Key | Value |
---|---|
Name | main.DischargeInspection |
Dataset Type | Table |
Dataset ID | 110 |
Minimum Client Version | 10.1 |
Alias | Discharge 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 | {F301D897-3645-4E50-B290-340150ACEB88} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
objectid | OBJECTID | OID | Index | False | 0 | 0 | 4 | False | True | |||
inspector | Inspector | String | True | 0 | 0 | 50 | True | False | ||||
inspectdt | Inspection Date | Date | True | 0 | 0 | 8 | True | False | ||||
dryweather | Dry Weather Inspection? | Short Integer | True | 0 | 0 | 2 | True | False | ||||
dateprecip | Date of Last Precipitation | Date | True | 0 | 0 | 8 | True | False | ||||
amountprecip | Amount of Last Precipitation | Double | True | 0 | 0 | 8 | True | False | ||||
flow | Flow Present? | Short Integer | True | 0 | 0 | 2 | True | False | ||||
flowrate | Flow Rate | Short Integer | True | 0 | 0 | 2 | True | False | ||||
flowcolor | Flow contains color? | Short Integer | True | 0 | 0 | 2 | True | False | ||||
colordesc | Color Description | Short Integer | True | 0 | 0 | 2 | True | False | ||||
colordesc_other | Specify other | String | True | 0 | 0 | 50 | True | False | ||||
flowodor | Flow contains odor? | Short Integer | True | 0 | 0 | 2 | True | False | ||||
odordesc | Odor Description | Short Integer | True | 0 | 0 | 2 | True | False | ||||
odordesc_other | Specify other | String | True | 0 | 0 | 50 | True | False | ||||
flowfloatable | Flow contains floatables? | Short Integer | True | 0 | 0 | 2 | True | False | ||||
floatabledesc | Floatable Description | Short Integer | True | 0 | 0 | 2 | True | False | ||||
floatabledesc_other | Specify other | String | True | 0 | 0 | 50 | True | False | ||||
recievingwater | Change in recieving water? | Short Integer | False | 0 | 0 | 2 | True | False | ||||
recievingwaterdesc | Description of Change | String | True | 0 | 0 | 150 | True | False | ||||
illicitdischarge | Is Flow Illicit Discharge? | Short Integer | True | 0 | 0 | 2 | True | False | ||||
illicitdischargesource | Efforts to determine source | String | True | 0 | 0 | 150 | True | False | ||||
illicitdischargeaction | Corrective Action Taken | String | True | 0 | 0 | 150 | True | False | ||||
notes | Notes | String | True | 0 | 0 | 2000 | True | False | ||||
assetguid | Asset GUID | GUID | Index | True | 0 | 0 | 38 | True | False | |||
globalid | globalid | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Key | Value |
---|---|
Name | main.DischargeInspection__ATTACH |
Dataset Type | Table |
Dataset ID | 111 |
Minimum Client Version | 10.1 |
Alias | DischargeInspection__ATTACH |
OID Field | attachmentid |
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 | {8A09F4AB-815C-4A86-825C-83ACCBB9A001} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
attachmentid | ATTACHMENTID | OID | Index | False | 0 | 0 | 4 | False | True | |||
rel_globalid | REL_GLOBALID | GUID | Index | False | 0 | 0 | 38 | True | False | |||
content_type | CONTENT_TYPE | String | False | 0 | 0 | 150 | True | False | ||||
att_name | ATT_NAME | String | False | 0 | 0 | 250 | True | False | ||||
data_size | DATA_SIZE | Long Integer | False | 0 | 0 | 4 | True | False | ||||
data | DATA | Blob | True | 0 | 0 | 0 | True | False | ||||
globalid | GLOBALID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | True | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | True | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | True | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | True |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_111_REL_GLOB | False | True | rel_globalid |
UUID_51 | True | True | globalid |
FDO_attachmentid | True | True | attachmentid |
Key | Value |
---|---|
Name | main.DischargeInspection__ATTACHREL |
Dataset Type | RelationshipClass |
Dataset ID | 123 |
Type | Composite |
Cardinality | One To Many |
Notification | None |
Is Attachment | True |
Is Attributed | False |
Origin Name | main.DischargeInspection |
Origin Primary Key | globalid |
Origin Foreign Key | REL_GLOBALID |
Destination Name | main.DischargeInspection__ATTACH |
Forward Path Label | attachment |
Backward Path Label | object |
Minimum Client Version | 10.0 |
Editor Tracking Enabled | False |
Catalog ID | {0973A9A7-E8F3-4F8B-9FE8-5B97BDFE6FCC} |
Key | Value |
---|---|
Name | main.GDB_ValidationLineErrors |
Dataset Type | FeatureClass |
Dataset ID | 140 |
Geometry Type | Polyline |
Feature Type | Simple |
Z-Aware | True |
M-Aware | True |
Split Model | Update Insert |
Minimum Client Version | 10.1 |
Alias | Validation Line Errors |
OID Field | ObjectID |
GlobalID Field | GlobalID |
Editor Tracking Enabled | True |
Editor Tracking UTC | True |
Creator Field | CREATOR |
Create Date Field | CREATIONDATE |
Editor Field | UPDATEDBY |
Edit Date Field | LASTUPDATE |
Shape Field | Shape |
Spatial Reference | GCS_WGS_1984 |
Catalog ID | {8321C66F-B627-4A78-86F0-83BE1472A478} |
Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
ObjectID | Object ID | OID | Index | False | 0 | 0 | 4 | False | True | |||
FeatureClassID | Feature class ID | Long Integer | False | 0 | 0 | 4 | True | True | ||||
FeatureObjectID | Feature object ID | Long Integer | False | 0 | 0 | 4 | True | True | ||||
FeatureGlobalID | Feature global ID | GUID | False | 0 | 0 | 38 | True | True | ||||
ErrorNumber | Error number | Long Integer | False | 0 | 0 | 4 | True | True | ||||
ErrorMessage | Error message | String | False | 0 | 0 | 2000 | True | True | ||||
RuleType | Rule type | Short Integer | False | Attribute Rule Type | 0 | 0 | 2 | True | True | |||
RuleName | Rule name | String | False | 0 | 0 | 64 | True | True | ||||
RuleID | Rule ID | Long Integer | False | 0 | 0 | 4 | True | True | ||||
RuleDescription | Rule description | String | True | 0 | 0 | 256 | True | True | ||||
Severity | Severity | Long Integer | True | 0 | 0 | 4 | True | True | ||||
IsException | Is exception | Short Integer | True | Validation Error Exception | 0 | 0 | 2 | True | True | |||
ErrorStatus | Error status | Long Integer | True | Validation Error Status | 1 | 0 | 0 | 4 | True | True | ||
ErrorPhase | Error phase | Long Integer | True | Validation Error Phase | 2 | 0 | 0 | 4 | True | True | ||
CorrectionNotes | Correction notes | String | True | 0 | 0 | 256 | True | True | ||||
CorrectionTechnician | Correction technician | String | True | 0 | 0 | 256 | True | True | ||||
VerificationNotes | Verification notes | String | True | 0 | 0 | 256 | True | True | ||||
VerificationTechnician | Verification technician | String | True | 0 | 0 | 256 | True | True | ||||
CREATIONDATE | Creation date | Date | Created | False | 0 | 0 | 8 | False | True | |||
CREATOR | Creator | String | Creator | False | 0 | 0 | 255 | False | True | |||
LASTUPDATE | Last update | Date | Edited | False | 0 | 0 | 8 | False | True | |||
UPDATEDBY | Updated by | String | Editor | False | 0 | 0 | 255 | False | True | |||
Shape | Geometry | Index | True | 0 | 0 | 8 | True | True | ||||
GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | ||||
st_length(Shape) | Double | Length | True | 0 | 0 | 0 | False | True |
Key | Value |
---|---|
Name | main.GDB_ValidationObjectErrors |
Dataset Type | Table |
Dataset ID | 138 |
Minimum Client Version | 10.1 |
Alias | Validation Object Errors |
OID Field | ObjectID |
GlobalID Field | GlobalID |
Editor Tracking Enabled | True |
Editor Tracking UTC | True |
Creator Field | CREATOR |
Create Date Field | CREATIONDATE |
Editor Field | UPDATEDBY |
Edit Date Field | LASTUPDATE |
Catalog ID | {BE0B888A-DD83-4D99-AFFC-7779E6A63AF4} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
ObjectID | Object ID | OID | Index | False | 0 | 0 | 4 | False | True | |||
FeatureClassID | Feature class ID | Long Integer | False | 0 | 0 | 4 | True | True | ||||
FeatureObjectID | Feature object ID | Long Integer | False | 0 | 0 | 4 | True | True | ||||
FeatureGlobalID | Feature global ID | GUID | False | 0 | 0 | 38 | True | True | ||||
ErrorNumber | Error number | Long Integer | False | 0 | 0 | 4 | True | True | ||||
ErrorMessage | Error message | String | False | 0 | 0 | 2000 | True | True | ||||
RuleType | Rule type | Short Integer | False | Attribute Rule Type | 0 | 0 | 2 | True | True | |||
RuleName | Rule name | String | False | 0 | 0 | 64 | True | True | ||||
RuleID | Rule ID | Long Integer | False | 0 | 0 | 4 | True | True | ||||
RuleDescription | Rule description | String | True | 0 | 0 | 256 | True | True | ||||
Severity | Severity | Long Integer | True | 0 | 0 | 4 | True | True | ||||
IsException | Is exception | Short Integer | True | Validation Error Exception | 0 | 0 | 2 | True | True | |||
ErrorStatus | Error status | Long Integer | True | Validation Error Status | 1 | 0 | 0 | 4 | True | True | ||
ErrorPhase | Error phase | Long Integer | True | Validation Error Phase | 2 | 0 | 0 | 4 | True | True | ||
CorrectionNotes | Correction notes | String | True | 0 | 0 | 256 | True | True | ||||
CorrectionTechnician | Correction technician | String | True | 0 | 0 | 256 | True | True | ||||
VerificationNotes | Verification notes | String | True | 0 | 0 | 256 | True | True | ||||
VerificationTechnician | Verification technician | String | True | 0 | 0 | 256 | True | True | ||||
CREATIONDATE | Creation date | Date | Created | False | 0 | 0 | 8 | False | True | |||
CREATOR | Creator | String | Creator | False | 0 | 0 | 255 | False | True | |||
LASTUPDATE | Last update | Date | Edited | False | 0 | 0 | 8 | False | True | |||
UPDATEDBY | Updated by | String | Editor | False | 0 | 0 | 255 | False | True | |||
GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True |
Key | Value |
---|---|
Name | main.GDB_ValidationPointErrors |
Dataset Type | FeatureClass |
Dataset ID | 139 |
Geometry Type | Point |
Feature Type | Simple |
Z-Aware | True |
M-Aware | True |
Split Model | Update Insert |
Minimum Client Version | 10.1 |
Alias | Validation Point Errors |
OID Field | ObjectID |
GlobalID Field | GlobalID |
Editor Tracking Enabled | True |
Editor Tracking UTC | True |
Creator Field | CREATOR |
Create Date Field | CREATIONDATE |
Editor Field | UPDATEDBY |
Edit Date Field | LASTUPDATE |
Shape Field | Shape |
Spatial Reference | GCS_WGS_1984 |
Catalog ID | {00AB2FB3-3FF6-4381-874F-F1344114D263} |
Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
ObjectID | Object ID | OID | Index | False | 0 | 0 | 4 | False | True | |||
FeatureClassID | Feature class ID | Long Integer | False | 0 | 0 | 4 | True | True | ||||
FeatureObjectID | Feature object ID | Long Integer | False | 0 | 0 | 4 | True | True | ||||
FeatureGlobalID | Feature global ID | GUID | False | 0 | 0 | 38 | True | True | ||||
ErrorNumber | Error number | Long Integer | False | 0 | 0 | 4 | True | True | ||||
ErrorMessage | Error message | String | False | 0 | 0 | 2000 | True | True | ||||
RuleType | Rule type | Short Integer | False | Attribute Rule Type | 0 | 0 | 2 | True | True | |||
RuleName | Rule name | String | False | 0 | 0 | 64 | True | True | ||||
RuleID | Rule ID | Long Integer | False | 0 | 0 | 4 | True | True | ||||
RuleDescription | Rule description | String | True | 0 | 0 | 256 | True | True | ||||
Severity | Severity | Long Integer | True | 0 | 0 | 4 | True | True | ||||
IsException | Is exception | Short Integer | True | Validation Error Exception | 0 | 0 | 2 | True | True | |||
ErrorStatus | Error status | Long Integer | True | Validation Error Status | 1 | 0 | 0 | 4 | True | True | ||
ErrorPhase | Error phase | Long Integer | True | Validation Error Phase | 2 | 0 | 0 | 4 | True | True | ||
CorrectionNotes | Correction notes | String | True | 0 | 0 | 256 | True | True | ||||
CorrectionTechnician | Correction technician | String | True | 0 | 0 | 256 | True | True | ||||
VerificationNotes | Verification notes | String | True | 0 | 0 | 256 | True | True | ||||
VerificationTechnician | Verification technician | String | True | 0 | 0 | 256 | True | True | ||||
CREATIONDATE | Creation date | Date | Created | False | 0 | 0 | 8 | False | True | |||
CREATOR | Creator | String | Creator | False | 0 | 0 | 255 | False | True | |||
LASTUPDATE | Last update | Date | Edited | False | 0 | 0 | 8 | False | True | |||
UPDATEDBY | Updated by | String | Editor | False | 0 | 0 | 255 | False | True | |||
Shape | Geometry | Index | True | 0 | 0 | 8 | True | True | ||||
GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True |
Key | Value |
---|---|
Name | main.GDB_ValidationPolygonErrors |
Dataset Type | FeatureClass |
Dataset ID | 141 |
Geometry Type | Polygon |
Feature Type | Simple |
Z-Aware | True |
M-Aware | True |
Split Model | Update Insert |
Minimum Client Version | 10.1 |
Alias | Validation Polygon Errors |
OID Field | ObjectID |
GlobalID Field | GlobalID |
Editor Tracking Enabled | True |
Editor Tracking UTC | True |
Creator Field | CREATOR |
Create Date Field | CREATIONDATE |
Editor Field | UPDATEDBY |
Edit Date Field | LASTUPDATE |
Shape Field | Shape |
Spatial Reference | GCS_WGS_1984 |
Catalog ID | {170EA31C-972A-422E-9F99-63F0DA5E044A} |
Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
ObjectID | Object ID | OID | Index | False | 0 | 0 | 4 | False | True | |||
FeatureClassID | Feature class ID | Long Integer | False | 0 | 0 | 4 | True | True | ||||
FeatureObjectID | Feature object ID | Long Integer | False | 0 | 0 | 4 | True | True | ||||
FeatureGlobalID | Feature global ID | GUID | False | 0 | 0 | 38 | True | True | ||||
ErrorNumber | Error number | Long Integer | False | 0 | 0 | 4 | True | True | ||||
ErrorMessage | Error message | String | False | 0 | 0 | 2000 | True | True | ||||
RuleType | Rule type | Short Integer | False | Attribute Rule Type | 0 | 0 | 2 | True | True | |||
RuleName | Rule name | String | False | 0 | 0 | 64 | True | True | ||||
RuleID | Rule ID | Long Integer | False | 0 | 0 | 4 | True | True | ||||
RuleDescription | Rule description | String | True | 0 | 0 | 256 | True | True | ||||
Severity | Severity | Long Integer | True | 0 | 0 | 4 | True | True | ||||
IsException | Is exception | Short Integer | True | Validation Error Exception | 0 | 0 | 2 | True | True | |||
ErrorStatus | Error status | Long Integer | True | Validation Error Status | 1 | 0 | 0 | 4 | True | True | ||
ErrorPhase | Error phase | Long Integer | True | Validation Error Phase | 2 | 0 | 0 | 4 | True | True | ||
CorrectionNotes | Correction notes | String | True | 0 | 0 | 256 | True | True | ||||
CorrectionTechnician | Correction technician | String | True | 0 | 0 | 256 | True | True | ||||
VerificationNotes | Verification notes | String | True | 0 | 0 | 256 | True | True | ||||
VerificationTechnician | Verification technician | String | True | 0 | 0 | 256 | True | True | ||||
CREATIONDATE | Creation date | Date | Created | False | 0 | 0 | 8 | False | True | |||
CREATOR | Creator | String | Creator | False | 0 | 0 | 255 | False | True | |||
LASTUPDATE | Last update | Date | Edited | False | 0 | 0 | 8 | False | True | |||
UPDATEDBY | Updated by | String | Editor | False | 0 | 0 | 255 | False | True | |||
Shape | Geometry | Index | True | 0 | 0 | 8 | True | True | ||||
GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | ||||
st_area(Shape) | Double | Area | True | 0 | 0 | 0 | False | True | ||||
st_perimeter(Shape) | Double | Length | True | 0 | 0 | 0 | False | True |
Key | Value |
---|---|
Name | main.ManholeInspection |
Dataset Type | Table |
Dataset ID | 112 |
Minimum Client Version | 10.1 |
Alias | Manhole 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 | {C3740377-5993-4A9B-9F41-51866AC6D94A} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
objectid | OBJECTID | OID | Index | False | 0 | 0 | 4 | False | True | |||
inspector | Inspector | String | True | 0 | 0 | 50 | True | False | ||||
inspectdt | Inspection Date | Date | True | 0 | 0 | 8 | True | False | ||||
inspectpurp | Purpose of Inspection | Short Integer | True | 0 | 0 | 2 | True | False | ||||
precleaning | Pre-Cleaning | Short Integer | True | 0 | 0 | 2 | True | False | ||||
precleaningdate | Pre-Cleaning Date | Date | True | 0 | 0 | 8 | True | False | ||||
weather | Weather | Short Integer | True | 0 | 0 | 2 | True | False | ||||
runoff | Runoff Potential | Short Integer | True | 0 | 0 | 2 | True | False | ||||
inspectionstatus | Inspection Status | Short Integer | True | 0 | 0 | 2 | True | False | ||||
evidsurcharge | Evidence of Surchage | Short Integer | True | 0 | 0 | 2 | True | False | ||||
coverfit | Cover Fit | Short Integer | True | 0 | 0 | 2 | True | False | ||||
covercondition | Cover Condition | Short Integer | True | 0 | 0 | 2 | True | False | ||||
coverinsertcondition | Cover Insert Condition | Short Integer | True | 0 | 0 | 2 | True | False | ||||
coverringcondition | Cover Ring Condition | Short Integer | True | 0 | 0 | 2 | True | False | ||||
framecondition | Frame Condition | Short Integer | True | 0 | 0 | 2 | True | False | ||||
framesealcondition | Frame Seal Condition | Short Integer | True | 0 | 0 | 2 | True | False | ||||
framesealinflow | Evidence of Frame Seal Inflow | Short Integer | True | 0 | 0 | 2 | True | False | ||||
notes | Notes | String | True | 0 | 0 | 2000 | True | False | ||||
assetguid | Asset GUID | GUID | Index | True | 0 | 0 | 38 | True | False | |||
globalid | globalid | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Key | Value |
---|---|
Name | main.ManholeInspection__ATTACH |
Dataset Type | Table |
Dataset ID | 113 |
Minimum Client Version | 10.1 |
Alias | ManholeInspection__ATTACH |
OID Field | attachmentid |
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 | {0799AE0E-BF07-4E04-A146-8F6137CBCA7E} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
attachmentid | ATTACHMENTID | OID | Index | False | 0 | 0 | 4 | False | True | |||
rel_globalid | REL_GLOBALID | GUID | Index | False | 0 | 0 | 38 | True | False | |||
content_type | CONTENT_TYPE | String | False | 0 | 0 | 150 | True | False | ||||
att_name | ATT_NAME | String | False | 0 | 0 | 250 | True | False | ||||
data_size | DATA_SIZE | Long Integer | False | 0 | 0 | 4 | True | False | ||||
data | DATA | Blob | True | 0 | 0 | 0 | True | False | ||||
globalid | GLOBALID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | True | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | True | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | True | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | True |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_113_REL_GLOB | False | True | rel_globalid |
UUID_53 | True | True | globalid |
FDO_attachmentid | True | True | attachmentid |
Key | Value |
---|---|
Name | main.ManholeInspection__ATTACHREL |
Dataset Type | RelationshipClass |
Dataset ID | 124 |
Type | Composite |
Cardinality | One To Many |
Notification | None |
Is Attachment | True |
Is Attributed | False |
Origin Name | main.ManholeInspection |
Origin Primary Key | globalid |
Origin Foreign Key | REL_GLOBALID |
Destination Name | main.ManholeInspection__ATTACH |
Forward Path Label | attachment |
Backward Path Label | object |
Minimum Client Version | 10.0 |
Editor Tracking Enabled | False |
Catalog ID | {D1D044FA-CB41-4006-9A8E-11FC90E06E48} |
Key | Value |
---|---|
Name | main.Network |
Dataset Type | UtilityNetwork |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 6 |
Schema Generation | 7 |
Pro Version | ArcGIS Pro 3.3.0 |
Creation Time | 2024-04-26 11:12:25 |
Spatial Reference | NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS) |
X-Min | 500372.76851501653 |
X-Max | 1270078.1610237253 |
Y-Min | 1550391.9656166665 |
Y-Max | 2190094.2549103117 |
Z-Min | 0.00010000000474974513 |
Z-Max | 0.00010000000474974513 |
Service Territory | main.ServiceTerritory |
Domain Network Name | Domain Network Alias | Domain Network ID | Tier Definition | Subnetwork Controller Type | Creation Time |
---|---|---|---|---|---|
Structure | Structure | 1 | None | 2024-04-26 11:12:25 | |
Stormwater | Stormwater | 2 | Partitioned | Sink | 2024-04-26 11:13:25 |
Domain Network Name | Tier Group Name | Tier Name | Tier ID | Tier Rank | Tier Topology | Diagram Templates | Supports Disjoint | Subnetwork Field Name | Edit Mode in Default | Edit Mode in Version | Update Structures | Update Containers | Validate Locatability | Manage isDirty | Creation Time |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Stormwater | Stormwater Management Area | 1 | 1 | Radial | True | Without Eventing | Without Eventing | True | True | False | False | 2024-04-26 11:13:34 |
Tier Name | Include Containers | Include Content | Include Structures | Include Barriers | Validate Locatability | Traversability Scope |
---|---|---|---|---|---|---|
Stormwater Management Area | True | True | True | True | False | junctionsAndEdges |
Tier Name | Network Attribute / Category | Operator | Value | Combine Using Or |
---|---|---|---|---|
Stormwater Management Area | Lifecycle Status | Does Not Include Any | 6 | True |
Stormwater Management Area | S:Activate Value | Greater Than | 0 | False |
Domain Network Name | Source Name | Table | Usage Type | Source ID | # of Asset Groups | # of Asset Types |
---|---|---|---|---|---|---|
Structure | StructureJunction | main.StructureJunction | Structure Junction | 4 | 2 | 3 |
Structure | StructureBoundary | main.StructureBoundary | Structure Boundary | 6 | 3 | 21 |
Structure | StructureJunctionObject | main.StructureJunctionObject | Structure Junction Object | 7 | 1 | 1 |
Structure | StructureLine | main.StructureLine | Structure Line | 5 | 1 | 1 |
Structure | StructureEdgeObject | main.StructureEdgeObject | Structure Edge Object | 8 | 1 | 1 |
Stormwater | StormwaterDevice | main.StormwaterDevice | Device | 9 | 10 | 51 |
Stormwater | StormwaterAssembly | main.StormwaterAssembly | Assembly | 11 | 1 | 1 |
Stormwater | StormwaterJunction | main.StormwaterJunction | Junction | 12 | 2 | 6 |
Stormwater | StormwaterJunctionObject | main.StormwaterJunctionObject | Junction Object | 14 | 1 | 1 |
Stormwater | StormwaterLine | main.StormwaterLine | Line | 10 | 5 | 20 |
Stormwater | StormwaterSubnetLine | main.StormwaterSubnetLine | Subnet Line | 13 | 2 | 0 |
Stormwater | StormwaterEdgeObject | main.StormwaterEdgeObject | Edge Object | 15 | 1 | 1 |
Source Name | Asset Group Name | Asset Group Code | # of Asset Types | Creation Time |
---|---|---|---|---|
StructureJunction | Unknown | 0 | 1 | 2024-04-26 11:12:26 |
StructureJunction | Sewer Storm Vault | 208 | 2 | 2024-04-26 11:13:36 |
StructureBoundary | Unknown | 0 | 1 | 2024-04-26 11:12:26 |
StructureBoundary | BMP Boundary | 401 | 18 | 2024-04-26 11:13:38 |
StructureBoundary | Storm Lift Station Boundary | 404 | 2 | 2024-04-26 11:13:38 |
StructureJunctionObject | Unknown | 0 | 1 | 2024-04-26 11:12:26 |
StructureLine | Unknown | 0 | 1 | 2024-04-26 11:12:26 |
StructureEdgeObject | Unknown | 0 | 1 | 2024-04-26 11:12:26 |
StormwaterDevice | Unknown | 0 | 1 | 2024-04-26 11:13:27 |
StormwaterDevice | Pump | 5 | 2 | 2024-04-26 11:13:42 |
StormwaterDevice | Weir | 26 | 7 | 2024-04-26 11:13:42 |
StormwaterDevice | Cleanout | 21 | 2 | 2024-04-26 11:13:42 |
StormwaterDevice | Catch Basin | 28 | 4 | 2024-04-26 11:13:42 |
StormwaterDevice | BMP Point | 29 | 18 | 2024-04-26 11:13:42 |
StormwaterDevice | Outlet | 22 | 6 | 2024-04-26 11:13:42 |
StormwaterDevice | BMP Inlet | 30 | 4 | 2024-04-26 11:13:42 |
StormwaterDevice | Connection | 23 | 4 | 2024-04-26 11:13:42 |
StormwaterDevice | Manhole Channel | 32 | 3 | 2024-04-26 11:13:42 |
StormwaterAssembly | Unknown | 0 | 1 | 2024-04-26 11:13:27 |
StormwaterJunction | Unknown | 0 | 1 | 2024-04-26 11:13:27 |
StormwaterJunction | Wall | 23 | 5 | 2024-04-26 11:13:48 |
StormwaterJunctionObject | Unknown | 0 | 1 | 2024-04-26 11:13:27 |
StormwaterLine | Unknown | 0 | 1 | 2024-04-26 11:13:27 |
StormwaterLine | Pipe | 4 | 4 | 2024-04-26 11:13:51 |
StormwaterLine | Open Channel | 5 | 6 | 2024-04-26 11:13:51 |
StormwaterLine | Culvert | 6 | 6 | 2024-04-26 11:13:51 |
StormwaterLine | Linear Drain | 7 | 3 | 2024-04-26 11:13:51 |
StormwaterSubnetLine | Unknown | 0 | 0 | 2024-04-26 11:13:27 |
StormwaterSubnetLine | Stormwater Management Area | 1 | 0 | 2024-04-26 11:13:36 |
StormwaterEdgeObject | Unknown | 0 | 1 | 2024-04-26 11:13:27 |
Source Name | Asset Group Name | Asset Type Name | Asset Group Code | Asset Type Code | Terminal Configuration | Association Role | Delete Type | Containment Scale | Split Content | Connectivity Policy | Network Categories | Creation Time |
---|---|---|---|---|---|---|---|---|---|---|---|---|
StructureJunction | Unknown | Unknown | 0 | 0 | 2024-04-26 11:12:26 | |||||||
StructureJunction | Sewer Storm Vault | Unknown | 208 | 0 | Container | Restricted | 10 | 2024-04-26 11:13:36 | ||||
StructureJunction | Sewer Storm Vault | Manhole | 208 | 9 | Container | Restricted | 10 | 2024-04-26 11:13:36 | ||||
StructureBoundary | Unknown | Unknown | 0 | 0 | 2024-04-26 11:12:26 | |||||||
StructureBoundary | BMP Boundary | Unknown | 401 | 0 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Detention Basin | 401 | 2 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Dry Basin | 401 | 3 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Treatment Vault | 401 | 6 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Wet Basin | 401 | 7 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Bed Filter | 401 | 8 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Infiltration Basin | 401 | 9 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Media Filter | 401 | 10 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Bio-Filtration | 401 | 21 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Bio-Retention | 401 | 22 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Bioswale | 401 | 23 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Filtration Device | 401 | 24 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Infiltration Feature | 401 | 25 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Pervious Pavement | 401 | 26 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Sediment Trap | 401 | 27 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Settling Basin | 401 | 28 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Green Roof | 401 | 29 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | BMP Boundary | Retention Basin | 401 | 30 | Container | Restricted | 500 | 2024-04-26 11:13:38 | ||||
StructureBoundary | Storm Lift Station Boundary | Unknown | 404 | 0 | Container | Restricted | 50 | 2024-04-26 11:13:39 | ||||
StructureBoundary | Storm Lift Station Boundary | Lift Station | 404 | 42 | Container | Restricted | 50 | 2024-04-26 11:13:39 | ||||
StructureJunctionObject | Unknown | Unknown | 0 | 0 | 2024-04-26 11:12:26 | |||||||
StructureLine | Unknown | Unknown | 0 | 0 | 2024-04-26 11:12:26 | |||||||
StructureEdgeObject | Unknown | Unknown | 0 | 0 | 2024-04-26 11:12:26 | |||||||
StormwaterDevice | Unknown | Unknown | 0 | 0 | 2024-04-26 11:13:27 | |||||||
StormwaterDevice | Pump | Unknown | 5 | 0 | Container | Restricted | 50 | 2024-04-26 11:13:42 | ||||
StormwaterDevice | Pump | Pump | 5 | 61 | Pressure Increasing | Container | Restricted | 50 | 2024-04-26 11:13:42 | |||
StormwaterDevice | Weir | Unknown | 26 | 0 | 2024-04-26 11:13:42 | |||||||
StormwaterDevice | Weir | Broad-Crested | 26 | 281 | 2024-04-26 11:13:42 | |||||||
StormwaterDevice | Weir | Combination | 26 | 282 | 2024-04-26 11:13:42 | |||||||
StormwaterDevice | Weir | Labyrinth | 26 | 283 | 2024-04-26 11:13:42 | |||||||
StormwaterDevice | Weir | Minimum Energy Loss | 26 | 284 | 2024-04-26 11:13:42 | |||||||
StormwaterDevice | Weir | Sharp-Crested | 26 | 285 | 2024-04-26 11:13:42 | |||||||
StormwaterDevice | Weir | V-Notch | 26 | 286 | 2024-04-26 11:13:42 | |||||||
StormwaterDevice | Cleanout | Unknown | 21 | 0 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | Cleanout | Cleanout | 21 | 1 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | Catch Basin | Unknown | 28 | 0 | Container | Restricted | 10 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | Catch Basin | Infiltration | 28 | 204 | Container | Restricted | 10 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | Catch Basin | Sediment Trap | 28 | 205 | Container | Restricted | 10 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | Catch Basin | Drop Inlet | 28 | 210 | Container | Restricted | 10 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Unknown | 29 | 0 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Detention Basin | 29 | 2 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Dry Basin | 29 | 3 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Treatment Vault | 29 | 6 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Wet Basin | 29 | 7 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Bed Filter | 29 | 8 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Infiltration Basin | 29 | 9 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Media Filter | 29 | 10 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Bio-Filtration | 29 | 21 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Bio-Retention | 29 | 22 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Bioswale | 29 | 23 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Filtration Device | 29 | 24 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Infiltration Feature | 29 | 25 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Pervious Pavement | 29 | 26 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Sediment Trap | 29 | 27 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Settling Basin | 29 | 28 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Green Roof | 29 | 29 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | BMP Point | Retention Basin | 29 | 30 | Container | Restricted | 500 | 2024-04-26 11:13:43 | ||||
StormwaterDevice | Outlet | Unknown | 22 | 0 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | Outlet | Pipe Outlet | 22 | 5 | Directional Dual Terminal | Subnetwork Controller | 2024-04-26 11:13:43 | |||||
StormwaterDevice | Outlet | Tide Gate Chamber | 22 | 9 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | Outlet | Apron Outlet | 22 | 10 | Directional Dual Terminal | Subnetwork Controller | 2024-04-26 11:13:43 | |||||
StormwaterDevice | Outlet | Flap Gate | 22 | 11 | Directional Dual Terminal | Subnetwork Controller | 2024-04-26 11:13:43 | |||||
StormwaterDevice | Outlet | Riser | 22 | 12 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | BMP Inlet | Unknown | 30 | 0 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | BMP Inlet | Apron Inlet | 30 | 6 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | BMP Inlet | Pipe Inlet | 30 | 7 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | BMP Inlet | Channel Inlet | 30 | 8 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | Connection | Unknown | 23 | 0 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | Connection | Pipe Connection | 23 | 241 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | Connection | Open Channel Connection | 23 | 242 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | Connection | Linear Drain Connection | 23 | 245 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | Manhole Channel | Unknown | 32 | 0 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | Manhole Channel | Manhole Channel | 32 | 301 | 2024-04-26 11:13:43 | |||||||
StormwaterDevice | Manhole Channel | Directional Manhole Channel | 32 | 302 | Directional Manhole Terminal | Subnetwork Controller | 2024-04-26 11:13:43 | |||||
StormwaterAssembly | Unknown | Unknown | 0 | 0 | 2024-04-26 11:13:27 | |||||||
StormwaterJunction | Unknown | Unknown | 0 | 0 | 2024-04-26 11:13:27 | |||||||
StormwaterJunction | Wall | Unknown | 23 | 0 | 2024-04-26 11:13:48 | |||||||
StormwaterJunction | Wall | Endwall | 23 | 81 | 2024-04-26 11:13:48 | |||||||
StormwaterJunction | Wall | Headwall | 23 | 82 | 2024-04-26 11:13:48 | |||||||
StormwaterJunction | Wall | Wingwall | 23 | 83 | 2024-04-26 11:13:48 | |||||||
StormwaterJunction | Wall | Floodwall | 23 | 84 | 2024-04-26 11:13:48 | |||||||
StormwaterJunctionObject | Unknown | Unknown | 0 | 0 | 2024-04-26 11:13:27 | |||||||
StormwaterLine | Unknown | Unknown | 0 | 0 | 2024-04-26 11:13:27 | |||||||
StormwaterLine | Pipe | Unknown | 4 | 0 | 2024-04-26 11:13:51 | |||||||
StormwaterLine | Pipe | Gravity Pipe | 4 | 3 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Pipe | Force Pipe | 4 | 4 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Pipe | Perforated Pipe | 4 | 5 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Open Channel | Unknown | 5 | 0 | 2024-04-26 11:13:51 | |||||||
StormwaterLine | Open Channel | Aquaduct Channel | 5 | 43 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Open Channel | Spillway Channel | 5 | 44 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Open Channel | Natural Channel | 5 | 45 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Open Channel | Ditch Channel | 5 | 46 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Open Channel | Roadside Gutter | 5 | 47 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Culvert | Unknown | 6 | 0 | 2024-04-26 11:13:51 | |||||||
StormwaterLine | Culvert | Pipe Culvert | 6 | 81 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Culvert | Pipe Arch | 6 | 82 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Culvert | Box Culvert | 6 | 83 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Culvert | Arch Culvert | 6 | 84 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Culvert | Bridge Culvert | 6 | 85 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Linear Drain | Unknown | 7 | 0 | 2024-04-26 11:13:51 | |||||||
StormwaterLine | Linear Drain | Trench Drain | 7 | 121 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterLine | Linear Drain | Slotted Drain | 7 | 122 | Any Vertex | 2024-04-26 11:13:51 | ||||||
StormwaterEdgeObject | Unknown | Unknown | 0 | 0 | 2024-04-26 11:13:27 |
Category Name | Creation Time |
---|---|
Subnetwork Controller | 2024-04-26 11:12:25 |
Subnetwork Tap | 2024-04-26 11:12:25 |
Attribute Substitution | 2024-04-26 11:12:25 |
Configuration Name | Configuration ID | Traversability Model | Default | Creation Time |
---|---|---|---|---|
Single terminal | 0 | Bidirectional | All | 2024-04-26 11:12:25 |
Pressure Reducing | 2 | Directional | All | 2024-04-26 11:14:00 |
Pressure Increasing | 3 | Directional | All | 2024-04-26 11:14:00 |
Directional Dual Terminal | 4 | Directional | All | 2024-04-26 11:14:00 |
Bidirectional Dual Terminal | 5 | Bidirectional | All | 2024-04-26 11:14:00 |
Directional Manhole Terminal | 6 | Directional | All | 2024-04-26 11:14:00 |
Configuration Name | Terminal Name | Terminal ID | Upstream |
---|---|---|---|
Single terminal | Single Terminal | 1 | |
Pressure Reducing | High Pressure In | 2 | True |
Pressure Reducing | Low Pressure Out | 3 | False |
Pressure Increasing | Low Pressure In | 4 | True |
Pressure Increasing | High Pressure Out | 5 | False |
Directional Dual Terminal | Inlet Port | 6 | True |
Directional Dual Terminal | Outlet Port | 7 | False |
Bidirectional Dual Terminal | Port One | 8 | |
Bidirectional Dual Terminal | Port Two | 9 | |
Directional Manhole Terminal | Upstream | 10 | True |
Directional Manhole Terminal | Upstream 2 | 11 | True |
Directional Manhole Terminal | Downstream | 12 | False |
Directional Manhole Terminal | Downstream 2 | 13 | False |
Configuration Name | Path Name | Path ID | Path Description |
---|---|---|---|
Directional Manhole Terminal | All | 1 | All |
Directional Manhole Terminal | D-D2 | 2 | Downstream-Downstream 2 |
Name | ID | Usage Type | Data Type | Field Type | Inline | Domain Name | Nullable | Apportionable | Substitution Attribute | Bit Position | Bit Size | Junction ID | Edge ID | Creation Time |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Source ID | 1 | Source ID | Integer | Short Integer | True | False | False | 0 | 7 | 1 | 2 | 2024-04-26 11:12:25 | ||
Terminal ID | 2 | Terminal ID | Integer | Short Integer | False | False | False | 7 | 0 | 3 | 4 | 2024-04-26 11:12:25 | ||
Asset group | 3 | Asset Group | Integer | Short Integer | True | False | False | 7 | 10 | 5 | 6 | 2024-04-26 11:12:25 | ||
Asset type | 4 | Asset Type | Integer | Short Integer | True | False | False | 17 | 10 | 7 | 8 | 2024-04-26 11:12:25 | ||
Is subnetwork controller | 5 | Is Subnetwork Controller | Integer | Short Integer | True | False | False | 27 | 1 | 9 | 10 | 2024-04-26 11:12:25 | ||
Tier name | 6 | Tier Name | Integer | Short Integer | True | False | False | 28 | 6 | 11 | 12 | 2024-04-26 11:12:25 | ||
Shape length | 7 | Shape Length | Double | Double | False | False | True | 34 | 0 | 13 | 14 | 2024-04-26 11:12:25 | ||
Position from | 8 | Position From | Double | Double | False | False | False | 34 | 0 | 15 | 16 | 2024-04-26 11:12:25 | ||
Position to | 9 | Position To | Double | Double | False | False | False | 34 | 0 | 17 | 18 | 2024-04-26 11:12:25 | ||
Flow direction | 10 | Flow Direction | Integer | Short Integer | True | False | False | 34 | 2 | 19 | 20 | 2024-04-26 11:12:25 | ||
Lifecycle Status | 11 | Unknown | Integer | Short Integer | True | Lifecycle_Combined | False | False | 36 | 3 | 21 | 22 | 2024-04-26 11:14:00 | |
Outfall | 12 | Unknown | Integer | Short Integer | False | True | False | 0 | 0 | 23 | 24 | 2024-04-26 11:14:00 | ||
S:Activate Value | 13 | Unknown | Integer | Short Integer | False | False | False | 0 | 0 | 25 | 26 | 2024-04-26 11:14:00 | ||
Construction Status | 14 | Unknown | Integer | Short Integer | False | True | False | 0 | 0 | 27 | 28 | 2024-04-26 11:14:00 |
Key | Value |
---|---|
Name | main.ServiceTerritory |
Dataset Type | FeatureClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 5 |
Geometry Type | Polygon |
Feature Type | Simple |
Z-Aware | True |
M-Aware | True |
Split Model | Update Insert |
Minimum Client Version | 13.2 |
Alias | Service Territory |
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;NAVD88_height_(ftUS) |
X-Min | 535359.3772654124 |
X-Max | 1235091.5522733293 |
Y-Min | 1579469.3424027413 |
Y-Max | 2161016.878124237 |
Z-Min | 0.00010000000474974513 |
Z-Max | 0.00010000000474974513 |
Catalog ID | {C27572E1-AA26-4AD9-94CA-2AB58F448E02} |
Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
Key | Value |
---|---|
utilityNetworkName | main.Network |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
objectid | objectid | OID | Index | False | 0 | 0 | 8 | False | True | |||
globalid | GLOBALID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False | |||
shape | shape | Geometry | Index | True | 0 | 0 | 8 | True | True | |||
st_area(shape) | Double | Area | True | 0 | 0 | 0 | False | True | ||||
st_perimeter(shape) | Double | Length | True | 0 | 0 | 0 | False | True |
Key | Value |
---|---|
Name | main.Stormwater_Device_BMP_to_Inspection |
Dataset Type | RelationshipClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 130 |
Type | Composite |
Cardinality | One To Many |
Notification | None |
Is Attachment | False |
Is Attributed | False |
Origin Name | main.StormwaterDevice |
Origin Primary Key | globalid |
Origin Foreign Key | assetguid |
Destination Name | main.StormwaterBMPInspection |
Forward Path Label | StormwaterBMPInspection |
Backward Path Label | StormwaterDevice |
Minimum Client Version | 10.0 |
Editor Tracking Enabled | False |
Catalog ID | {6FF4A8BD-B17B-42DB-B81D-81D49E94F6C2} |
Rule ID | Origin Subtype | Origin Min Cardinality | Origin Max Cardinality | Destination Subtype | Destination Min Cardinality | Destination Max Cardinality |
---|---|---|---|---|---|---|
1 | BMP Point | 0 | 10000 | 0 | 10000 | |
2 | Catch Basin | 0 | 10000 | 0 | 10000 | |
3 | Cleanout | 0 | 0 | 0 | 0 | |
4 | Connection | 0 | 0 | 0 | 0 | |
5 | Manhole Channel | 0 | 0 | 0 | 0 | |
6 | Pump | 0 | 0 | 0 | 0 | |
7 | Unknown | 0 | 0 | 0 | 0 | |
8 | Weir | 0 | 0 | 0 | 0 | |
9 | BMP Inlet | 0 | 0 | 0 | 0 | |
10 | Outlet | 0 | 0 | 0 | 0 |
Key | Value |
---|---|
Name | main.Stormwater_Device_Discharge_To_Inspection |
Dataset Type | RelationshipClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 131 |
Type | Composite |
Cardinality | One To Many |
Notification | None |
Is Attachment | False |
Is Attributed | False |
Origin Name | main.StormwaterDevice |
Origin Primary Key | GLOBALID |
Origin Foreign Key | assetguid |
Destination Name | main.DischargeInspection |
Forward Path Label | DischargeInspection |
Backward Path Label | StormwaterDevice |
Minimum Client Version | 10.0 |
Editor Tracking Enabled | False |
Catalog ID | {104256E3-FA15-4B16-8821-8E4132FFD688} |
Rule ID | Origin Subtype | Origin Min Cardinality | Origin Max Cardinality | Destination Subtype | Destination Min Cardinality | Destination Max Cardinality |
---|---|---|---|---|---|---|
1 | BMP Inlet | 0 | 0 | 0 | 0 | |
2 | BMP Point | 0 | 0 | 0 | 0 | |
3 | Catch Basin | 0 | 0 | 0 | 0 | |
4 | Cleanout | 0 | 0 | 0 | 0 | |
5 | Connection | 0 | 0 | 0 | 0 | |
6 | Manhole Channel | 0 | 0 | 0 | 0 | |
7 | Outlet | 0 | 1000 | 0 | 1000 | |
8 | Pump | 0 | 0 | 0 | 0 | |
9 | Unknown | 0 | 0 | 0 | 0 | |
10 | Weir | 0 | 0 | 0 | 0 |
Key | Value |
---|---|
Name | main.StormwaterAssembly |
Dataset Type | FeatureClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 105 |
Geometry Type | Point |
Feature Type | Simple |
Z-Aware | True |
M-Aware | True |
Split Model | Update Insert |
Minimum Client Version | 13.2 |
Alias | Stormwater Assembly |
OID Field | OBJECTID |
GlobalID Field | GLOBALID |
Subtype Field | ASSETGROUP |
Default Subtype | Unknown |
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;NAVD88_height_(ftUS) |
X-Min | 500372.76851501653 |
X-Max | 1270078.1610237253 |
Y-Min | 1550391.9656166665 |
Y-Max | 2190094.2549103117 |
Z-Min | 0.00010000000474974513 |
Z-Max | 0.00010000000474974513 |
Catalog ID | {CBD60400-F390-44A2-ACAF-C35EB63D9799} |
Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
Key | Value |
---|---|
utilityNetworkName | main.Network |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECTID | Object ID | OID | Index | False | 0 | 0 | 8 | False | True | |||
ASSETGROUP | Asset group | Long Integer | Subtype | False | 0 | 0 | 0 | 4 | True | True | ||
ASSETTYPE | Asset type | Short Integer | False | 0 | 0 | 0 | 2 | True | True | |||
ASSOCIATIONSTATUS | Association status | Short Integer | False | Network_6_AssociationStatus | 0 | 0 | 0 | 2 | False | True | ||
SHAPE | Shape | Geometry | Index | False | 0 | 0 | 8 | True | True | |||
GLOBALID | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
SUPPORTEDSUBNETWORKNAME | Supported subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
subnetworkname | Subnetwork name | String | False | Unknown | 0 | 0 | 2000 | True | False | |||
installdate | Install Date | Date | True | 0 | 0 | 8 | True | False | ||||
ownedby | Asset Owner | Short Integer | True | Asset_Owner | 1 | 0 | 0 | 2 | True | False | ||
maintby | Asset Manager | Short Integer | True | Asset_Manager | 1 | 0 | 0 | 2 | True | False | ||
symbolrotation | symbolrotation: Symbol Rotation | Short Integer | True | Symbol_Rotation | 0 | 0 | 2 | True | False | |||
assetid | Asset ID | String | True | 0 | 0 | 64 | True | False | ||||
notes | Notes | String | True | 0 | 0 | 2000 | True | False | ||||
lifecyclestatus | Lifecycle Status | Short Integer | False | Lifecycle_Combined | 2 | 0 | 0 | 2 | True | False | ||
spatialsource | Spatial Source | Short Integer | True | Spatial_Source | 0 | 0 | 0 | 2 | True | False | ||
spatialconfidence | Spatial Confidence | Short Integer | True | Spatial_Confidence | 0 | 0 | 0 | 2 | True | False | ||
constructionstatus | Construction Status | Short Integer | True | Construction_Status | 6 | 0 | 0 | 2 | True | False | ||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_105_SUPPORTE | False | True | SUPPORTEDSUBNETWORKNAME |
UUID_45 | True | True | GLOBALID |
FDO_OBJECTID | True | True | OBJECTID |
st_spindex__StormwaterAssembly_SHAPE | True | True | SHAPE |
Subtype Name | Subtype Code | Field Name | Default Value | Domain Name | Details |
---|---|---|---|---|---|
Unknown | 0 | ASSETTYPE | 0 | Network_6_UnknownAssetType | |
Unknown | 0 | ASSOCIATIONSTATUS | 0 | Network_6_AssociationStatus | |
Unknown | 0 | SUPPORTEDSUBNETWORKNAME | Unknown | ||
Unknown | 0 | subnetworkname | Unknown |
Key | Value |
---|---|
Name | main.StormwaterAssembly__ATTACH |
Dataset Type | Table |
Dataset ID | 114 |
Minimum Client Version | 10.1 |
Alias | Stormwater Assembly Attachment |
OID Field | attachmentid |
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 | {5E4DEC1B-CE80-4E1A-BA02-B1DC6BFA33B7} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
attachmentid | ATTACHMENTID | OID | Index | False | 0 | 0 | 4 | False | True | |||
rel_globalid | rel_globalid | GUID | Index | False | 0 | 0 | 38 | True | False | |||
content_type | content_type | String | False | 0 | 0 | 150 | True | False | ||||
att_name | att_name | String | False | 0 | 0 | 250 | True | False | ||||
data_size | data_size | Long Integer | False | 0 | 0 | 4 | True | False | ||||
data | data | Blob | True | 0 | 0 | 0 | True | False | ||||
globalid | globalid | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_114_REL_GLOB | False | True | rel_globalid |
UUID_54 | True | True | globalid |
FDO_attachmentid | True | True | attachmentid |
Key | Value |
---|---|
Name | main.StormwaterAssembly__ATTACHREL |
Dataset Type | RelationshipClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 125 |
Type | Composite |
Cardinality | One To Many |
Notification | None |
Is Attachment | True |
Is Attributed | False |
Origin Name | main.StormwaterAssembly |
Origin Primary Key | globalid |
Origin Foreign Key | REL_GLOBALID |
Destination Name | main.StormwaterAssembly__ATTACH |
Forward Path Label | attachment |
Backward Path Label | object |
Minimum Client Version | 10.0 |
Editor Tracking Enabled | False |
Catalog ID | {6B55A471-3A95-45CC-8946-9D1F6263237B} |
Key | Value |
---|---|
Name | main.StormwaterBMPInspection |
Dataset Type | Table |
Dataset ID | 115 |
Minimum Client Version | 10.1 |
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 | {084DD591-108A-4756-BE3D-7395F6883AF3} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
objectid | OBJECTID | OID | Index | False | 0 | 0 | 4 | False | True | |||
inspector | Inspector | String | True | 0 | 0 | 50 | True | False | ||||
inspectdt | Inspection Date | Date | True | 0 | 0 | 8 | True | False | ||||
removal | Removal of... | Short Integer | True | 0 | 0 | 2 | True | False | ||||
removalequipment | Equipment Needed | Short Integer | True | 0 | 0 | 2 | True | False | ||||
removalnotes | Removal Notes | String | True | 0 | 0 | 2000 | True | False | ||||
damage | Damage To... | Short Integer | True | 0 | 0 | 2 | True | False | ||||
damage_other | Specify other | String | True | 0 | 0 | 150 | True | False | ||||
damageengineer | Engineer Inspection Needed? | Short Integer | True | 0 | 0 | 2 | True | False | ||||
damagenotes | Damage Notes | String | True | 0 | 0 | 2000 | True | False | ||||
globalid | globalid | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Key | Value |
---|---|
Name | main.StormwaterBMPInspection__ATTACH |
Dataset Type | Table |
Dataset ID | 116 |
Minimum Client Version | 10.1 |
Alias | StormwaterBMPInspection__ATTACH |
OID Field | attachmentid |
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 | {BAD50E6B-EE36-40EF-BAE7-B338D510669D} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
attachmentid | ATTACHMENTID | OID | Index | False | 0 | 0 | 4 | False | True | |||
rel_globalid | REL_GLOBALID | GUID | Index | False | 0 | 0 | 38 | True | False | |||
content_type | CONTENT_TYPE | String | False | 0 | 0 | 150 | True | False | ||||
att_name | ATT_NAME | String | False | 0 | 0 | 250 | True | False | ||||
data_size | DATA_SIZE | Long Integer | False | 0 | 0 | 4 | True | False | ||||
data | DATA | Blob | True | 0 | 0 | 0 | True | False | ||||
globalid | GLOBALID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | True | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | True | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | True | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | True |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_116_REL_GLOB | False | True | rel_globalid |
UUID_56 | True | True | globalid |
FDO_attachmentid | True | True | attachmentid |
Key | Value |
---|---|
Name | main.StormwaterBMPInspection__ATTACHREL |
Dataset Type | RelationshipClass |
Dataset ID | 126 |
Type | Composite |
Cardinality | One To Many |
Notification | None |
Is Attachment | True |
Is Attributed | False |
Origin Name | main.StormwaterBMPInspection |
Origin Primary Key | globalid |
Origin Foreign Key | REL_GLOBALID |
Destination Name | main.StormwaterBMPInspection__ATTACH |
Forward Path Label | attachment |
Backward Path Label | object |
Minimum Client Version | 10.0 |
Editor Tracking Enabled | False |
Catalog ID | {1AA4F0FD-E9F2-4FC4-A45C-1F96E38D9091} |
Key | Value |
---|---|
Name | main.StormwaterDevice |
Dataset Type | FeatureClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 102 |
Geometry Type | Point |
Feature Type | Simple |
Z-Aware | True |
M-Aware | True |
Split Model | Update Insert |
Minimum Client Version | 13.2 |
Alias | Stormwater Device |
OID Field | OBJECTID |
GlobalID Field | GLOBALID |
Subtype Field | ASSETGROUP |
Default Subtype | Unknown |
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;NAVD88_height_(ftUS) |
X-Min | 500372.76851501653 |
X-Max | 1270078.1610237253 |
Y-Min | 1550391.9656166665 |
Y-Max | 2190094.2549103117 |
Z-Min | 0 |
Z-Max | 2298.821200000006 |
Catalog ID | {80491DF0-38B9-4DE3-A09D-00E145829896} |
Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
Key | Value |
---|---|
utilityNetworkName | main.Network |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECTID | Object ID | OID | Index | False | 0 | 0 | 8 | False | True | |||
ASSETGROUP | Asset group | Long Integer | Subtype | False | 0 | 0 | 0 | 4 | True | True | ||
ASSETTYPE | Asset type | Short Integer | False | 0 | 0 | 0 | 2 | True | True | |||
ASSOCIATIONSTATUS | Association status | Short Integer | False | Network_6_AssociationStatus | 0 | 0 | 0 | 2 | False | True | ||
ISSUBNETWORKCONTROLLER | Is subnetwork controller | Short Integer | False | Network_6_IsSubnetworkController | 0 | 0 | 0 | 2 | False | True | ||
ISCONNECTED | Is connected | Short Integer | False | Network_6_IsConnected | 2 | 0 | 0 | 2 | False | True | ||
SUBNETWORKCONTROLLERNAME | Subnetwork controller name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
TIERNAME | Tier name | Short Integer | False | Network_6_TierName | 0 | 0 | 0 | 2 | False | True | ||
TIERRANK | Tier rank | Long Integer | False | 0 | 0 | 0 | 4 | False | True | |||
TERMINALCONFIGURATION | Terminal path | String | False | Default | 0 | 0 | 128 | True | True | |||
SHAPE | Shape | Geometry | Index | False | 0 | 0 | 8 | True | True | |||
GLOBALID | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
SUBNETWORKNAME | Subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
SUPPORTEDSUBNETWORKNAME | Supported subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
SUPPORTINGSUBNETWORKNAME | Supporting subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
installdate | Install Date | Date | True | 0 | 0 | 8 | True | False | ||||
ownedby | Owned By | Short Integer | True | Asset_Owner | 1 | 0 | 0 | 2 | True | False | ||
maintby | Maintained By | Short Integer | True | Asset_Manager | 1 | 0 | 0 | 2 | True | False | ||
assetid | Asset ID | String | True | 0 | 0 | 64 | True | False | ||||
notes | Notes | String | True | 0 | 0 | 2000 | True | False | ||||
diameter | Diameter | Double | True | 0 | 0 | 8 | True | False | ||||
permitid | Permit ID | String | True | 0 | 0 | 50 | True | False | ||||
location | Location | Short Integer | True | 0 | 0 | 2 | True | False | ||||
material | Material | Short Integer | True | 0 | 0 | 2 | True | False | ||||
wingwall | Wingwall | Short Integer | True | 0 | 0 | 2 | True | False | ||||
orifice | Orifice | Short Integer | True | 0 | 0 | 2 | True | False | ||||
permitted | Permitted | Short Integer | True | 0 | 0 | 2 | True | False | ||||
surfacewater | Receives Surface Water | Short Integer | True | 0 | 0 | 2 | True | False | ||||
exitsystem | Water Exiting System | Short Integer | True | 0 | 0 | 2 | True | False | ||||
lifecyclestatus | Lifecycle Status | Short Integer | False | Lifecycle_Combined | 2 | 0 | 0 | 2 | True | False | ||
activevol | Activate Volume | Short Integer | False | 0 | 0 | 2 | True | False | ||||
spatialsource | Spatial Source | Short Integer | True | Spatial_Source | 0 | 0 | 0 | 2 | True | False | ||
spatialconfidence | Spatial Confidence | Short Integer | True | Spatial_Confidence | 0 | 0 | 0 | 2 | True | False | ||
symbolrotation | Symbol Rotation | Short Integer | True | Symbol_Rotation | 0 | 0 | 2 | True | False | |||
signage | Signage | Short Integer | True | 0 | 0 | 2 | True | False | ||||
designtype | Type | Short Integer | True | 0 | 0 | 2 | True | False | ||||
length2 | Length | Double | True | 0 | 0 | 8 | True | False | ||||
width | Width | Double | True | 0 | 0 | 8 | True | False | ||||
depth | Depth | Double | True | 0 | 0 | 8 | True | False | ||||
inletcount | Number of Inlets | Short Integer | True | 0 | 0 | 2 | True | False | ||||
outletcount | Number of Outlets | Short Integer | True | 0 | 0 | 2 | True | False | ||||
volume | Storage Volume | Double | True | 0 | 0 | 8 | True | False | ||||
rate | Treatment Rate | Double | True | 0 | 0 | 8 | True | False | ||||
rate2 | Infiltration Rate | Double | True | 0 | 0 | 8 | True | False | ||||
reuse | Capture and Reuse | Short Integer | True | 0 | 0 | 2 | True | False | ||||
outfallid | Outfall ID | String | True | 0 | 0 | 64 | True | False | ||||
outfall | Outfall | Short Integer | True | 0 | 0 | 2 | True | False | ||||
elevation | Elevation | Short Integer | True | 0 | 0 | 2 | True | False | ||||
bmpclass | BMP Class | Short Integer | True | 0 | 0 | 2 | True | False | ||||
inletshape | Inlet Shape | Short Integer | True | 0 | 0 | 2 | True | False | ||||
sump | Sump | Short Integer | True | 0 | 0 | 2 | True | False | ||||
observationport | Observation Port | Short Integer | True | 0 | 0 | 2 | True | False | ||||
confinedspace | Confined Space | Short Integer | True | 0 | 0 | 2 | True | False | ||||
constructionstatus | Construction Status | Short Integer | True | Construction_Status | 6 | 0 | 0 | 2 | True | False | ||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False | |||
VALIDATIONSTATUS | Validation status | Short Integer | Index | True | Validation Status | 6 | 0 | 0 | 2 | False | True |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_102_VALIDATI | False | True | VALIDATIONSTATUS |
GDB_102_SUBNETWO | False | True | SUBNETWORKCONTROLLERNAME |
GDB_102_SUBNETWO_1 | False | True | SUBNETWORKNAME |
GDB_102_SUPPORTE | False | True | SUPPORTEDSUBNETWORKNAME |
GDB_102_SUPPORTI | False | True | SUPPORTINGSUBNETWORKNAME |
UUID_43 | True | True | GLOBALID |
FDO_OBJECTID | True | True | OBJECTID |
st_spindex__StormwaterDevice_SHAPE | True | True | SHAPE |
Name | Code | Details |
---|---|---|
Unknown | 0 | |
Pump | 5 | |
Weir | 26 | |
Cleanout | 21 | |
Catch Basin | 28 | |
BMP Point | 29 | |
Outlet | 22 | |
BMP Inlet | 30 | |
Connection | 23 | |
Manhole Channel | 32 |
Key | Value |
---|---|
ID | 6 |
Minimum Client Version | 12.6 |
Evaluation Order | 1 |
Name | StormwaterDevice-GenerateIDs |
Description | Generate IDs for StormwaterDevice using database sequences |
Type | Calculation |
Batch | False |
Insert Trigger | True |
Update Trigger | True |
Delete Trigger | False |
Field Name | assetid |
Editable | True |
Enabled | True |
Exclude From Client | True |
Creation Time | 2024-04-26 11:14:36 |
Script |
|
Key | Value |
---|---|
ID | 7 |
Minimum Client Version | 12.7 |
Evaluation Order | 2 |
Name | Device - Set Attributes from Z |
Description | Update Elevation attribute of a Pipe Connection based on the Geometry Z value. |
Type | Calculation |
Batch | False |
Insert Trigger | True |
Update Trigger | True |
Delete Trigger | False |
Subtype | Connection |
Editable | True |
Enabled | True |
Exclude From Client | True |
Creation Time | 2024-04-26 11:14:36 |
Script |
|
Key | Value |
---|---|
ID | 8 |
Minimum Client Version | 12.4 |
Evaluation Order | 3 |
Name | Device Symbol Rotation |
Description | Symbol rotation calculation for device features |
Type | Calculation |
Batch | False |
Insert Trigger | True |
Update Trigger | True |
Delete Trigger | False |
Field Name | symbolrotation |
Editable | True |
Enabled | True |
Exclude From Client | False |
Creation Time | 2024-04-26 11:14:36 |
Script |
|
Key | Value |
---|---|
ID | 9 |
Minimum Client Version | 12.7 |
Evaluation Order | 1 |
Name | Device - Check Pipe Connection |
Description | Run validation on all Pipe Connection features. |
Type | Validation |
Batch | True |
Insert Trigger | False |
Update Trigger | False |
Delete Trigger | False |
Subtype | Connection |
Severity | 5 |
Error Number | 5001 |
Error Message | Error |
Enabled | True |
Exclude From Client | True |
Creation Time | 2024-04-26 11:14:36 |
Script |
|
Key | Value |
---|---|
Name | main.StormwaterDevice__ATTACH |
Dataset Type | Table |
Dataset ID | 117 |
Minimum Client Version | 10.1 |
Alias | Stormwater Device Attachment |
OID Field | attachmentid |
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 | {B4BD74B0-0856-4353-BE8A-965D01AF778A} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
attachmentid | ATTACHMENTID | OID | Index | False | 0 | 0 | 4 | False | True | |||
rel_globalid | rel_globalid | GUID | Index | False | 0 | 0 | 38 | True | False | |||
content_type | content_type | String | False | 0 | 0 | 150 | True | False | ||||
att_name | att_name | String | False | 0 | 0 | 250 | True | False | ||||
data_size | data_size | Long Integer | False | 0 | 0 | 4 | True | False | ||||
data | data | Blob | True | 0 | 0 | 0 | True | False | ||||
globalid | globalid | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_117_REL_GLOB | False | True | rel_globalid |
UUID_57 | True | True | globalid |
FDO_attachmentid | True | True | attachmentid |
Key | Value |
---|---|
Name | main.StormwaterDevice__ATTACHREL |
Dataset Type | RelationshipClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 127 |
Type | Composite |
Cardinality | One To Many |
Notification | None |
Is Attachment | True |
Is Attributed | False |
Origin Name | main.StormwaterDevice |
Origin Primary Key | globalid |
Origin Foreign Key | REL_GLOBALID |
Destination Name | main.StormwaterDevice__ATTACH |
Forward Path Label | attachment |
Backward Path Label | object |
Minimum Client Version | 10.0 |
Editor Tracking Enabled | False |
Catalog ID | {93DC05E1-34B8-4422-A56E-C10E269A8FA9} |
Key | Value |
---|---|
Name | main.StormwaterEdgeObject |
Dataset Type | Table |
Dataset ID | 109 |
Minimum Client Version | 13.2 |
Alias | Stormwater Edge Object |
OID Field | OBJECTID |
GlobalID Field | GLOBALID |
Subtype Field | ASSETGROUP |
Default Subtype | Unknown |
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 | {08F6F9BD-FB0F-4099-8EBA-891CC7D64EA9} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Key | Value |
---|---|
utilityNetworkName | main.Network |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECTID | Object ID | OID | Index | False | 0 | 0 | 8 | False | True | |||
ASSETGROUP | Asset group | Long Integer | Subtype | False | 0 | 0 | 0 | 4 | True | True | ||
ASSETTYPE | Asset type | Short Integer | False | 0 | 0 | 0 | 2 | True | True | |||
ASSOCIATIONSTATUS | Association status | Short Integer | False | Network_6_AssociationStatus | 0 | 0 | 0 | 2 | False | True | ||
ISCONNECTED | Is connected | Short Integer | False | Network_6_IsConnected | 2 | 0 | 0 | 2 | False | True | ||
FLOWDIRECTION | Flow direction | Short Integer | True | Network_6_FlowDirection | 1 | 0 | 0 | 2 | True | True | ||
GLOBALID | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
SUBNETWORKNAME | Subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
SUPPORTEDSUBNETWORKNAME | Supported subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
SUPPORTINGSUBNETWORKNAME | Supporting subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
lifecyclestatus | Lifecycle Status | Short Integer | False | Lifecycle_Combined | 2 | 0 | 0 | 2 | True | False | ||
constructionstatus | Construction Status | Short Integer | True | Construction_Status | 6 | 0 | 0 | 2 | True | False | ||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_109_SUPPORTI | False | True | SUPPORTINGSUBNETWORKNAME |
GDB_109_SUPPORTE | False | True | SUPPORTEDSUBNETWORKNAME |
GDB_109_SUBNETWO | False | True | SUBNETWORKNAME |
UUID_49 | True | True | GLOBALID |
FDO_OBJECTID | True | True | OBJECTID |
Subtype Name | Subtype Code | Field Name | Default Value | Domain Name | Details |
---|---|---|---|---|---|
Unknown | 0 | ASSETTYPE | 0 | Network_6_UnknownAssetType | |
Unknown | 0 | ASSOCIATIONSTATUS | 0 | Network_6_AssociationStatus | |
Unknown | 0 | ISCONNECTED | 2 | Network_6_IsConnected | |
Unknown | 0 | FLOWDIRECTION | 1 | Network_6_FlowDirection | |
Unknown | 0 | SUBNETWORKNAME | Unknown | ||
Unknown | 0 | SUPPORTEDSUBNETWORKNAME | Unknown | ||
Unknown | 0 | SUPPORTINGSUBNETWORKNAME | Unknown |
Key | Value |
---|---|
Name | main.StormwaterJunction |
Dataset Type | FeatureClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 106 |
Geometry Type | Point |
Feature Type | Simple |
Z-Aware | True |
M-Aware | True |
Split Model | Update Insert |
Minimum Client Version | 13.2 |
Alias | Stormwater Junction |
OID Field | OBJECTID |
GlobalID Field | GLOBALID |
Subtype Field | ASSETGROUP |
Default Subtype | Unknown |
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;NAVD88_height_(ftUS) |
X-Min | 500372.76851501653 |
X-Max | 1270078.1610237253 |
Y-Min | 1550391.9656166665 |
Y-Max | 2190094.2549103117 |
Z-Min | 0.00010000000474974513 |
Z-Max | 0.00010000000474974513 |
Catalog ID | {D981FB2D-727B-48E2-907B-DD902A369C30} |
Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
Key | Value |
---|---|
utilityNetworkName | main.Network |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECTID | Object ID | OID | Index | False | 0 | 0 | 8 | False | True | |||
ASSETGROUP | Asset group | Long Integer | Subtype | False | 0 | 0 | 0 | 4 | True | True | ||
ASSETTYPE | Asset type | Short Integer | False | 0 | 0 | 0 | 2 | True | True | |||
ASSOCIATIONSTATUS | Association status | Short Integer | False | Network_6_AssociationStatus | 0 | 0 | 0 | 2 | False | True | ||
ISCONNECTED | Is connected | Short Integer | False | Network_6_IsConnected | 2 | 0 | 0 | 2 | False | True | ||
SHAPE | Shape | Geometry | Index | False | 0 | 0 | 8 | True | True | |||
GLOBALID | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
SUBNETWORKNAME | Subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
SUPPORTEDSUBNETWORKNAME | Supported subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
SUPPORTINGSUBNETWORKNAME | Supporting subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
installdate | Install Date | Date | True | 0 | 0 | 8 | True | False | ||||
ownedby | Owned By | Short Integer | True | Asset_Owner | 1 | 0 | 0 | 2 | True | False | ||
maintby | Maintained By | Short Integer | True | Asset_Manager | 1 | 0 | 0 | 2 | True | False | ||
symbolrotation | Symbol Rotation | Short Integer | True | Symbol_Rotation | 0 | 0 | 2 | True | False | |||
material | Material | Short Integer | True | 0 | 0 | 2 | True | False | ||||
assetid | Asset ID | String | True | 0 | 0 | 64 | True | False | ||||
notes | Notes | String | True | 0 | 0 | 2000 | True | False | ||||
lifecyclestatus | Lifecycle Status | Short Integer | False | Lifecycle_Combined | 2 | 0 | 0 | 2 | True | False | ||
spatialsource | Spatial Source | Short Integer | True | Spatial_Source | 0 | 0 | 0 | 2 | True | False | ||
spatialconfidence | Spatial Confidence | Short Integer | True | Spatial_Confidence | 0 | 0 | 0 | 2 | True | False | ||
constructionstatus | Construction Status | Short Integer | True | Construction_Status | 6 | 0 | 0 | 2 | True | False | ||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_106_SUPPORTI | False | True | SUPPORTINGSUBNETWORKNAME |
GDB_106_SUPPORTE | False | True | SUPPORTEDSUBNETWORKNAME |
GDB_106_SUBNETWO | False | True | SUBNETWORKNAME |
UUID_46 | True | True | GLOBALID |
FDO_OBJECTID | True | True | OBJECTID |
st_spindex__StormwaterJunction_SHAPE | True | True | SHAPE |
Subtype Name | Subtype Code | Field Name | Default Value | Domain Name | Details |
---|---|---|---|---|---|
Unknown | 0 | ASSETTYPE | 0 | Network_6_UnknownAssetType | |
Unknown | 0 | ASSOCIATIONSTATUS | 0 | Network_6_AssociationStatus | |
Unknown | 0 | ISCONNECTED | 2 | Network_6_IsConnected | |
Unknown | 0 | SUBNETWORKNAME | Unknown | ||
Unknown | 0 | SUPPORTEDSUBNETWORKNAME | Unknown | ||
Unknown | 0 | SUPPORTINGSUBNETWORKNAME | Unknown | ||
Wall | 23 | ASSETTYPE | 0 | Asset_Type_Stormwater_Junction_Wall | |
Wall | 23 | ASSOCIATIONSTATUS | 0 | Network_6_AssociationStatus | |
Wall | 23 | ISCONNECTED | 2 | Network_6_IsConnected | |
Wall | 23 | SUBNETWORKNAME | Unknown | ||
Wall | 23 | SUPPORTEDSUBNETWORKNAME | Unknown | ||
Wall | 23 | SUPPORTINGSUBNETWORKNAME | Unknown | ||
Wall | 23 | constructionstatus | 6 | Construction_Status | |
Wall | 23 | lifecyclestatus | 2 | Lifecycle_Status | |
Wall | 23 | maintby | 1 | Asset_Manager | |
Wall | 23 | material | 0 | Stormwater_Wall_Material | |
Wall | 23 | ownedby | 1 | Asset_Owner | |
Wall | 23 | spatialconfidence | 0 | Spatial_Confidence | |
Wall | 23 | spatialsource | 0 | Spatial_Source | |
Wall | 23 | symbolrotation | Symbol_Rotation |
Key | Value |
---|---|
ID | 10 |
Minimum Client Version | 12.6 |
Evaluation Order | 1 |
Name | StormwaterJunction-GenerateIDs |
Description | Generate IDs for StormwaterJunction using database sequences |
Type | Calculation |
Batch | False |
Insert Trigger | True |
Update Trigger | True |
Delete Trigger | False |
Field Name | assetid |
Editable | True |
Enabled | True |
Exclude From Client | True |
Creation Time | 2024-04-26 11:14:39 |
Script |
|
Key | Value |
---|---|
ID | 11 |
Minimum Client Version | 12.4 |
Evaluation Order | 2 |
Name | Junction Symbol Rotation |
Description | Symbol rotation calculation for junction features |
Type | Calculation |
Batch | False |
Insert Trigger | True |
Update Trigger | True |
Delete Trigger | False |
Field Name | symbolrotation |
Editable | True |
Enabled | True |
Exclude From Client | False |
Creation Time | 2024-04-26 11:14:39 |
Script |
|
Key | Value |
---|---|
Name | main.StormwaterJunction__ATTACH |
Dataset Type | Table |
Dataset ID | 118 |
Minimum Client Version | 10.1 |
Alias | Stormwater Junction Attachment |
OID Field | attachmentid |
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 | {A3734608-C618-4E47-9407-9410BBEA3A8A} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
attachmentid | ATTACHMENTID | OID | Index | False | 0 | 0 | 4 | False | True | |||
rel_globalid | rel_globalid | GUID | Index | False | 0 | 0 | 38 | True | False | |||
content_type | content_type | String | False | 0 | 0 | 150 | True | False | ||||
att_name | att_name | String | False | 0 | 0 | 250 | True | False | ||||
data_size | data_size | Long Integer | False | 0 | 0 | 4 | True | False | ||||
data | data | Blob | True | 0 | 0 | 0 | True | False | ||||
globalid | globalid | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_118_REL_GLOB | False | True | rel_globalid |
UUID_58 | True | True | globalid |
FDO_attachmentid | True | True | attachmentid |
Key | Value |
---|---|
Name | main.StormwaterJunction__ATTACHREL |
Dataset Type | RelationshipClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 128 |
Type | Composite |
Cardinality | One To Many |
Notification | None |
Is Attachment | True |
Is Attributed | False |
Origin Name | main.StormwaterJunction |
Origin Primary Key | globalid |
Origin Foreign Key | REL_GLOBALID |
Destination Name | main.StormwaterJunction__ATTACH |
Forward Path Label | attachment |
Backward Path Label | object |
Minimum Client Version | 10.0 |
Editor Tracking Enabled | False |
Catalog ID | {C737A2E1-4062-4595-87F2-3360667BD15D} |
Key | Value |
---|---|
Name | main.StormwaterJunctionObject |
Dataset Type | Table |
Dataset ID | 108 |
Minimum Client Version | 13.2 |
Alias | Stormwater Junction Object |
OID Field | OBJECTID |
GlobalID Field | GLOBALID |
Subtype Field | ASSETGROUP |
Default Subtype | Unknown |
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 | {69E801BE-8EB2-4483-9355-C008F5041CC6} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Key | Value |
---|---|
utilityNetworkName | main.Network |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECTID | Object ID | OID | Index | False | 0 | 0 | 8 | False | True | |||
ASSETGROUP | Asset group | Long Integer | Subtype | False | 0 | 0 | 0 | 4 | True | True | ||
ASSETTYPE | Asset type | Short Integer | False | 0 | 0 | 0 | 2 | True | True | |||
ASSOCIATIONSTATUS | Association status | Short Integer | False | Network_6_AssociationStatus | 0 | 0 | 0 | 2 | False | True | ||
ISSUBNETWORKCONTROLLER | Is subnetwork controller | Short Integer | False | Network_6_IsSubnetworkController | 0 | 0 | 0 | 2 | False | True | ||
ISCONNECTED | Is connected | Short Integer | False | Network_6_IsConnected | 2 | 0 | 0 | 2 | False | True | ||
SUBNETWORKCONTROLLERNAME | Subnetwork controller name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
TIERNAME | Tier name | Short Integer | False | Network_6_TierName | 0 | 0 | 0 | 2 | False | True | ||
TIERRANK | Tier rank | Long Integer | False | 0 | 0 | 0 | 4 | False | True | |||
TERMINALCONFIGURATION | Terminal path | String | False | Default | 0 | 0 | 128 | True | True | |||
GLOBALID | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
SUBNETWORKNAME | Subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
SUPPORTEDSUBNETWORKNAME | Supported subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
SUPPORTINGSUBNETWORKNAME | Supporting subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
lifecyclestatus | Lifecycle Status | Short Integer | False | Lifecycle_Combined | 2 | 0 | 0 | 2 | True | False | ||
constructionstatus | Construction Status | Short Integer | True | Construction_Status | 6 | 0 | 0 | 2 | True | False | ||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_108_SUPPORTI | False | True | SUPPORTINGSUBNETWORKNAME |
GDB_108_SUPPORTE | False | True | SUPPORTEDSUBNETWORKNAME |
GDB_108_SUBNETWO_1 | False | True | SUBNETWORKNAME |
GDB_108_SUBNETWO | False | True | SUBNETWORKCONTROLLERNAME |
UUID_48 | True | True | GLOBALID |
FDO_OBJECTID | True | True | OBJECTID |
Subtype Name | Subtype Code | Field Name | Default Value | Domain Name | Details |
---|---|---|---|---|---|
Unknown | 0 | ASSETTYPE | 0 | Network_6_UnknownAssetType | |
Unknown | 0 | ASSOCIATIONSTATUS | 0 | Network_6_AssociationStatus | |
Unknown | 0 | ISSUBNETWORKCONTROLLER | 0 | Network_6_IsSubnetworkController | |
Unknown | 0 | ISCONNECTED | 2 | Network_6_IsConnected | |
Unknown | 0 | SUBNETWORKCONTROLLERNAME | Unknown | ||
Unknown | 0 | TIERNAME | 0 | Network_6_TierName | |
Unknown | 0 | TIERRANK | 0 | ||
Unknown | 0 | TERMINALCONFIGURATION | Default | ||
Unknown | 0 | SUBNETWORKNAME | Unknown | ||
Unknown | 0 | SUPPORTEDSUBNETWORKNAME | Unknown | ||
Unknown | 0 | SUPPORTINGSUBNETWORKNAME | Unknown |
Key | Value |
---|---|
Name | main.StormwaterLine |
Dataset Type | FeatureClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 104 |
Geometry Type | Polyline |
Feature Type | Simple |
Z-Aware | True |
M-Aware | True |
Split Model | Update Insert |
Minimum Client Version | 13.2 |
Alias | Stormwater Line |
OID Field | OBJECTID |
GlobalID Field | GLOBALID |
Subtype Field | ASSETGROUP |
Default Subtype | Unknown |
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;NAVD88_height_(ftUS) |
X-Min | 500372.76851501653 |
X-Max | 1270078.1610237253 |
Y-Min | 1550391.9656166665 |
Y-Max | 2190094.2549103117 |
Z-Min | 0 |
Z-Max | 774.4931999999972 |
M-Min | 0 |
M-Max | 855.2090999999928 |
Catalog ID | {16A07D31-4676-4014-8851-CD41B08D1C2A} |
Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
Key | Value |
---|---|
utilityNetworkName | main.Network |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECTID | Object ID | OID | Index | False | 0 | 0 | 8 | False | True | |||
ASSETGROUP | Asset group | Long Integer | Subtype | False | 0 | 0 | 0 | 4 | True | True | ||
ASSETTYPE | Asset type | Short Integer | False | 0 | 0 | 0 | 2 | True | True | |||
ASSOCIATIONSTATUS | Association status | Short Integer | False | Network_6_AssociationStatus | 0 | 0 | 0 | 2 | False | True | ||
ISCONNECTED | Is connected | Short Integer | False | Network_6_IsConnected | 2 | 0 | 0 | 2 | False | True | ||
FROMDEVICETERMINAL | From device terminal | Short Integer | False | Network_6_TerminalNames | 0 | 0 | 0 | 2 | True | True | ||
TODEVICETERMINAL | To device terminal | Short Integer | False | Network_6_TerminalNames | 0 | 0 | 0 | 2 | True | True | ||
FLOWDIRECTION | Flow direction | Short Integer | True | Network_6_FlowDirection | 1 | 0 | 0 | 2 | True | True | ||
SHAPE | Shape | Geometry | Index | False | 0 | 0 | 8 | True | True | |||
GLOBALID | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
SUBNETWORKNAME | Subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
SUPPORTEDSUBNETWORKNAME | Supported subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
SUPPORTINGSUBNETWORKNAME | Supporting subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
diameter | Diameter | Double | True | 0 | 0 | 8 | True | False | ||||
upelev | Upstream Elevation | Double | True | 0 | 0 | 8 | True | False | ||||
downelev | Downstream Elevation | Double | True | 0 | 0 | 8 | True | False | ||||
slope | Slope | Double | True | 0 | 0 | 8 | True | False | ||||
installdate | Install Date | Date | True | 0 | 0 | 8 | True | False | ||||
ownedby | Owned By | Short Integer | True | Asset_Owner | 1 | 0 | 0 | 2 | True | False | ||
maintby | Maintained By | Short Integer | True | Asset_Manager | 1 | 0 | 0 | 2 | True | False | ||
pipeshape | Culvert Shape, Pipe Shape | Short Integer | True | 0 | 0 | 2 | True | False | ||||
type | Type | Short Integer | True | 0 | 0 | 2 | True | False | ||||
lined | Lined? | Short Integer | True | 0 | 0 | 2 | True | False | ||||
lineryear | Liner Year | Short Integer | True | 0 | 0 | 2 | True | False | ||||
linermethod | Liner Method | Short Integer | True | 0 | 0 | 2 | True | False | ||||
assetid | Asset ID | String | True | 0 | 0 | 64 | True | False | ||||
notes | Notes | String | True | 0 | 0 | 2000 | True | False | ||||
lifecyclestatus | Lifecycle Status | Short Integer | False | Lifecycle_Combined | 2 | 0 | 0 | 2 | True | False | ||
spatialsource | Spatial Source | Short Integer | True | Spatial_Source | 0 | 0 | 0 | 2 | True | False | ||
spatialconfidence | Spatial Confidence | Short Integer | True | Spatial_Confidence | 0 | 0 | 0 | 2 | True | False | ||
material | Material | Short Integer | True | 0 | 0 | 2 | True | False | ||||
width | Width | Double | True | 0 | 0 | 8 | True | False | ||||
height | Height | Double | True | 0 | 0 | 8 | True | False | ||||
wall | Wall | Short Integer | True | 0 | 0 | 2 | True | False | ||||
measuredlength | Measured Length | Double | True | 0 | 0 | 8 | True | False | ||||
constructionstatus | Construction Status | Short Integer | True | Construction_Status | 6 | 0 | 0 | 2 | True | False | ||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False | |||
VALIDATIONSTATUS | Validation status | Short Integer | Index | True | Validation Status | 6 | 0 | 0 | 2 | False | True | |
st_length(SHAPE) | shape_Length | Double | Length | True | 0 | 0 | 0 | False | True |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_104_VALIDATI | False | True | VALIDATIONSTATUS |
GDB_104_SUBNETWO | False | True | SUBNETWORKNAME |
GDB_104_SUPPORTE | False | True | SUPPORTEDSUBNETWORKNAME |
GDB_104_SUPPORTI | False | True | SUPPORTINGSUBNETWORKNAME |
UUID_44 | True | True | GLOBALID |
FDO_OBJECTID | True | True | OBJECTID |
st_spindex__StormwaterLine_SHAPE | True | True | SHAPE |
Key | Value |
---|---|
ID | 12 |
Minimum Client Version | 12.6 |
Evaluation Order | 1 |
Name | StormwaterLine-GenerateIDs |
Description | Generate IDs for StormwaterLine using database sequences |
Type | Calculation |
Batch | False |
Insert Trigger | True |
Update Trigger | True |
Delete Trigger | False |
Field Name | assetid |
Editable | True |
Enabled | True |
Exclude From Client | True |
Creation Time | 2024-04-26 11:14:42 |
Script |
|
Key | Value |
---|---|
ID | 13 |
Minimum Client Version | 12.7 |
Evaluation Order | 2 |
Name | Line - Snap to Manhole |
Description | Generates pipe connection points when Stormwater Pipe is snapped to a Manhole Channel. |
Type | Calculation |
Batch | False |
Insert Trigger | True |
Update Trigger | False |
Delete Trigger | False |
Editable | True |
Enabled | True |
Exclude From Client | True |
Creation Time | 2024-04-26 11:14:42 |
Script |
|
Key | Value |
---|---|
ID | 14 |
Minimum Client Version | 12.7 |
Evaluation Order | 3 |
Name | Line - Set Attributes from Z |
Description | Update upstream and downstream attributes a Main based on Geometry Z values of begin and endpoints of line. |
Type | Calculation |
Batch | False |
Insert Trigger | True |
Update Trigger | True |
Delete Trigger | False |
Editable | True |
Enabled | True |
Exclude From Client | True |
Creation Time | 2024-04-26 11:14:42 |
Script |
|
Key | Value |
---|---|
ID | 15 |
Minimum Client Version | 12.7 |
Evaluation Order | 4 |
Name | Line - Main Slope |
Description | Adjusts the slope based on the upstream, downstream, and length of the main |
Type | Calculation |
Batch | False |
Insert Trigger | True |
Update Trigger | True |
Delete Trigger | False |
Field Name | slope |
Editable | True |
Enabled | True |
Exclude From Client | False |
Creation Time | 2024-04-26 11:14:42 |
Script |
|
Key | Value |
---|---|
ID | 16 |
Minimum Client Version | 12.7 |
Evaluation Order | 1 |
Name | Line - Snap to Manhole batch |
Description | Generates pipe connection points when Stormwater Pipe is snapped to a Manhole Channel. |
Type | Calculation |
Batch | True |
Insert Trigger | False |
Update Trigger | False |
Delete Trigger | False |
Editable | True |
Enabled | False |
Exclude From Client | True |
Creation Time | 2024-04-26 11:14:42 |
Script |
|
Key | Value |
---|---|
Name | main.StormwaterLine__ATTACH |
Dataset Type | Table |
Dataset ID | 119 |
Minimum Client Version | 10.1 |
Alias | Stormwater Line Attachment |
OID Field | attachmentid |
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 | {9B18EA77-C0D1-47AF-A96A-5B81544BA0B4} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
attachmentid | ATTACHMENTID | OID | Index | False | 0 | 0 | 4 | False | True | |||
rel_globalid | rel_globalid | GUID | Index | False | 0 | 0 | 38 | True | False | |||
content_type | content_type | String | False | 0 | 0 | 150 | True | False | ||||
att_name | att_name | String | False | 0 | 0 | 250 | True | False | ||||
data_size | data_size | Long Integer | False | 0 | 0 | 4 | True | False | ||||
data | data | Blob | True | 0 | 0 | 0 | True | False | ||||
globalid | globalid | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_119_REL_GLOB | False | True | rel_globalid |
UUID_59 | True | True | globalid |
FDO_attachmentid | True | True | attachmentid |
Key | Value |
---|---|
Name | main.StormwaterLine__ATTACHREL |
Dataset Type | RelationshipClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 129 |
Type | Composite |
Cardinality | One To Many |
Notification | None |
Is Attachment | True |
Is Attributed | False |
Origin Name | main.StormwaterLine |
Origin Primary Key | globalid |
Origin Foreign Key | REL_GLOBALID |
Destination Name | main.StormwaterLine__ATTACH |
Forward Path Label | attachment |
Backward Path Label | object |
Minimum Client Version | 10.0 |
Editor Tracking Enabled | False |
Catalog ID | {1FFB9347-5CDD-4283-A833-75C8CE437D7F} |
Key | Value |
---|---|
Name | main.StormwaterSubnetLine |
Dataset Type | FeatureClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 107 |
Geometry Type | Polyline |
Feature Type | Simple |
Z-Aware | True |
M-Aware | True |
Split Model | Update Insert |
Minimum Client Version | 13.2 |
Alias | Stormwater Networks |
OID Field | OBJECTID |
GlobalID Field | GLOBALID |
Subtype Field | TIERNAME |
Default Subtype | Unknown |
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;NAVD88_height_(ftUS) |
X-Min | 500372.76851501653 |
X-Max | 1270078.1610237253 |
Y-Min | 1550391.9656166665 |
Y-Max | 2190094.2549103117 |
Z-Min | 0 |
Z-Max | 774.4931999999972 |
M-Min | 0 |
M-Max | 855.2090999999928 |
Catalog ID | {9BCF196D-E644-42C9-9DCC-9F627E68F5C7} |
Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
Key | Value |
---|---|
utilityNetworkName | main.Network |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECTID | Object ID | OID | Index | False | 0 | 0 | 8 | False | True | |||
SUBNETWORKNAME | Subnetwork name | String | False | Unknown | 0 | 0 | 64 | False | True | |||
ISDIRTY | Is dirty | Short Integer | False | Network_6_IsDirty | 1 | 0 | 0 | 2 | False | True | ||
TIERNAME | Tier name | Short Integer | Subtype | False | 0 | 0 | 0 | 2 | False | True | ||
SUBNETWORKCONTROLLERNAMES | Subnetwork controller names | String | False | Unknown | 0 | 0 | 1073741822 | False | True | |||
LASTUPDATESUBNETWORK | Last update subnetwork | Date | True | 0 | 0 | 8 | False | True | ||||
LASTACKEXPORTSUBNETWORK | Last ack export subnetwork | Date | True | 0 | 0 | 8 | False | True | ||||
SHAPE | Shape | Geometry | Index | False | 0 | 0 | 8 | True | True | |||
GLOBALID | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False | |||
st_length(SHAPE) | shape_Length | Double | Length | True | 0 | 0 | 0 | False | True |
Subtype Name | Subtype Code | Field Name | Default Value | Domain Name | Details |
---|---|---|---|---|---|
Unknown | 0 | SUBNETWORKNAME | Unknown | ||
Unknown | 0 | ISDIRTY | 1 | Network_6_IsDirty | |
Unknown | 0 | SUBNETWORKCONTROLLERNAMES | Unknown | ||
Stormwater Management Area | 1 | SUBNETWORKNAME | Unknown | ||
Stormwater Management Area | 1 | ISDIRTY | 1 | Network_6_IsDirty | |
Stormwater Management Area | 1 | SUBNETWORKCONTROLLERNAMES | Unknown |
Key | Value |
---|---|
Name | main.Structure_Junction_Manhole_To_Inspection |
Dataset Type | RelationshipClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 135 |
Type | Composite |
Cardinality | One To Many |
Notification | None |
Is Attachment | False |
Is Attributed | False |
Origin Name | main.StructureJunction |
Origin Primary Key | GLOBALID |
Origin Foreign Key | assetguid |
Destination Name | main.ManholeInspection |
Forward Path Label | ManholeInspection |
Backward Path Label | StructureJunction |
Minimum Client Version | 10.0 |
Editor Tracking Enabled | False |
Catalog ID | {1C53837A-B208-4AB9-9900-5E16F2272073} |
Key | Value |
---|---|
Name | main.StructureBoundary |
Dataset Type | FeatureClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 38 |
Geometry Type | Polygon |
Feature Type | Simple |
Z-Aware | True |
M-Aware | True |
Split Model | Update Insert |
Minimum Client Version | 13.2 |
Alias | Structure Boundary |
OID Field | OBJECTID |
GlobalID Field | GLOBALID |
Subtype Field | ASSETGROUP |
Default Subtype | Unknown |
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;NAVD88_height_(ftUS) |
X-Min | 500372.76851501653 |
X-Max | 1270078.1610237253 |
Y-Min | 1550391.9656166665 |
Y-Max | 2190094.2549103117 |
Z-Min | 0 |
Z-Max | 764.1472999999969 |
Catalog ID | {2228C45A-6807-4661-AA0B-AA4381AAF091} |
Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
Key | Value |
---|---|
utilityNetworkName | main.Network |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECTID | Object ID | OID | Index | False | 0 | 0 | 8 | False | True | |||
ASSETGROUP | Asset group | Long Integer | Subtype | False | 0 | 0 | 0 | 4 | True | True | ||
ASSETTYPE | Asset type | Short Integer | False | 0 | 0 | 0 | 2 | True | True | |||
ASSOCIATIONSTATUS | Association status | Short Integer | False | Network_6_AssociationStatus | 0 | 0 | 0 | 2 | False | True | ||
SUBNETWORKNAME | Subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
SHAPE | Shape | Geometry | Index | False | 0 | 0 | 8 | True | True | |||
GLOBALID | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
lifecyclestatus | Lifecycle Status | Short Integer | False | Lifecycle_Combined | 2 | 0 | 0 | 2 | True | False | ||
depth | Depth | Double | True | 0 | 0 | 8 | True | False | ||||
spatialsource | Spatial Source | Short Integer | True | Spatial_Source | 0 | 0 | 0 | 2 | True | False | ||
spatialconfidence | Spatial Confidence | Short Integer | True | Spatial_Confidence | 0 | 0 | 0 | 2 | True | False | ||
assetcondition | Condition | Short Integer | True | 0 | 0 | 2 | True | False | ||||
bmpclass | BMP Class | Short Integer | True | 0 | 0 | 2 | True | False | ||||
assetid | Asset ID | String | True | 0 | 0 | 64 | True | False | ||||
constructionstatus | Construction Status | Short Integer | True | Construction_Status | 6 | 0 | 0 | 2 | True | False | ||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False | |||
st_area(SHAPE) | shape_Area | Double | Area | True | 0 | 0 | 0 | False | True | |||
st_perimeter(SHAPE) | shape_Length | Double | Length | True | 0 | 0 | 0 | False | True |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_38_SUBNETWOR | False | True | SUBNETWORKNAME |
UUID_40 | True | True | GLOBALID |
FDO_OBJECTID | True | True | OBJECTID |
st_spindex__StructureBoundary_SHAPE | True | True | SHAPE |
Key | Value |
---|---|
ID | 5 |
Minimum Client Version | 12.6 |
Evaluation Order | 1 |
Name | StructureBoundary-GenerateIDs |
Description | Generate IDs for StructureBoundary using database sequences |
Type | Calculation |
Batch | False |
Insert Trigger | True |
Update Trigger | True |
Delete Trigger | False |
Field Name | assetid |
Editable | True |
Enabled | True |
Exclude From Client | True |
Creation Time | 2024-04-26 11:14:31 |
Script |
|
Key | Value |
---|---|
Name | main.StructureBoundary__ATTACH |
Dataset Type | Table |
Dataset ID | 120 |
Minimum Client Version | 10.1 |
Alias | Structure Boundary Attachment |
OID Field | attachmentid |
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 | {44EC2D78-A0B9-42F8-BA23-5D1B1DDA4F93} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
attachmentid | ATTACHMENTID | OID | Index | False | 0 | 0 | 4 | False | True | |||
rel_globalid | rel_globalid | GUID | Index | False | 0 | 0 | 38 | True | False | |||
content_type | content_type | String | False | 0 | 0 | 150 | True | False | ||||
att_name | att_name | String | False | 0 | 0 | 250 | True | False | ||||
data_size | data_size | Long Integer | False | 0 | 0 | 4 | True | False | ||||
data | data | Blob | True | 0 | 0 | 0 | True | False | ||||
globalid | globalid | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_120_REL_GLOB | False | True | rel_globalid |
UUID_60 | True | True | globalid |
FDO_attachmentid | True | True | attachmentid |
Key | Value |
---|---|
Name | main.StructureBoundary__ATTACHREL |
Dataset Type | RelationshipClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 132 |
Type | Composite |
Cardinality | One To Many |
Notification | None |
Is Attachment | True |
Is Attributed | False |
Origin Name | main.StructureBoundary |
Origin Primary Key | globalid |
Origin Foreign Key | REL_GLOBALID |
Destination Name | main.StructureBoundary__ATTACH |
Forward Path Label | attachment |
Backward Path Label | object |
Minimum Client Version | 10.0 |
Editor Tracking Enabled | False |
Catalog ID | {E208AB10-1475-49C7-BE88-57C2A5986471} |
Key | Value |
---|---|
Name | main.StructureEdgeObject |
Dataset Type | Table |
Dataset ID | 40 |
Minimum Client Version | 13.2 |
Alias | Structure Edge Object |
OID Field | OBJECTID |
GlobalID Field | GLOBALID |
Subtype Field | ASSETGROUP |
Default Subtype | Unknown |
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 | {CA8CB66F-77C4-49E0-B85A-FC36A3CEF836} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Key | Value |
---|---|
utilityNetworkName | main.Network |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECTID | Object ID | OID | Index | False | 0 | 0 | 8 | False | True | |||
ASSETGROUP | Asset group | Long Integer | Subtype | False | 0 | 0 | 0 | 4 | True | True | ||
ASSETTYPE | Asset type | Short Integer | False | 0 | 0 | 0 | 2 | True | True | |||
ASSOCIATIONSTATUS | Association status | Short Integer | False | Network_6_AssociationStatus | 0 | 0 | 0 | 2 | False | True | ||
SUBNETWORKNAME | Supported subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
FLOWDIRECTION | Flow direction | Short Integer | True | Network_6_FlowDirection | 1 | 0 | 0 | 2 | True | True | ||
GLOBALID | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
lifecyclestatus | Lifecycle Status | Short Integer | False | Lifecycle_Combined | 2 | 0 | 0 | 2 | True | False | ||
constructionstatus | Construction Status | Short Integer | True | Construction_Status | 6 | 0 | 0 | 2 | True | False | ||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_40_SUBNETWOR | False | True | SUBNETWORKNAME |
UUID_42 | True | True | GLOBALID |
FDO_OBJECTID | True | True | OBJECTID |
Subtype Name | Subtype Code | Field Name | Default Value | Domain Name | Details |
---|---|---|---|---|---|
Unknown | 0 | ASSETTYPE | 0 | Network_6_UnknownAssetType | |
Unknown | 0 | ASSOCIATIONSTATUS | 0 | Network_6_AssociationStatus | |
Unknown | 0 | SUBNETWORKNAME | Unknown | ||
Unknown | 0 | FLOWDIRECTION | 1 | Network_6_FlowDirection |
Key | Value |
---|---|
Name | main.StructureJunction |
Dataset Type | FeatureClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 34 |
Geometry Type | Point |
Feature Type | Simple |
Z-Aware | True |
M-Aware | True |
Split Model | Update Insert |
Minimum Client Version | 13.2 |
Alias | Structure Junction |
OID Field | OBJECTID |
GlobalID Field | GLOBALID |
Subtype Field | ASSETGROUP |
Default Subtype | Unknown |
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;NAVD88_height_(ftUS) |
X-Min | 500372.76851501653 |
X-Max | 1270078.1610237253 |
Y-Min | 1550391.9656166665 |
Y-Max | 2190094.2549103117 |
Z-Min | 0.00010000000474974513 |
Z-Max | 774.4931999999972 |
Catalog ID | {60EA2241-AA4E-468A-BE28-D34A85B8A2D5} |
Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
Key | Value |
---|---|
utilityNetworkName | main.Network |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECTID | Object ID | OID | Index | False | 0 | 0 | 8 | False | True | |||
ASSETGROUP | Asset group | Long Integer | Subtype | False | 0 | 0 | 0 | 4 | True | True | ||
ASSETTYPE | Asset type | Short Integer | False | 0 | 0 | 0 | 2 | True | True | |||
ASSOCIATIONSTATUS | Association status | Short Integer | False | Network_6_AssociationStatus | 0 | 0 | 0 | 2 | False | True | ||
SUBNETWORKNAME | Subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
SHAPE | Shape | Geometry | Index | False | 0 | 0 | 8 | True | True | |||
GLOBALID | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
conetype | Cone Type | Short Integer | True | 0 | 0 | 2 | True | False | ||||
location | Manhole Location | Short Integer | True | 0 | 0 | 2 | True | False | ||||
surface | Manhole Surface Type | Short Integer | True | 0 | 0 | 2 | True | False | ||||
covershape | Cover Shape | Short Integer | True | 0 | 0 | 2 | True | False | ||||
type | Cover Type | Short Integer | True | 0 | 0 | 2 | True | False | ||||
channel | Channel | Short Integer | True | 0 | 0 | 2 | True | False | ||||
bench | Bench | Short Integer | True | 0 | 0 | 2 | True | False | ||||
material | Frame Material | Short Integer | True | 0 | 0 | 2 | True | False | ||||
wall | Wall | Short Integer | True | 0 | 0 | 2 | True | False | ||||
numsteps | Number of Steps | Short Integer | True | 0 | 0 | 2 | True | False | ||||
stepmaterial | Step Material | Short Integer | True | 0 | 0 | 2 | True | False | ||||
ownedby | Owned By | Short Integer | True | Asset_Owner | 1 | 0 | 0 | 2 | True | False | ||
maintby | Maintained By | Short Integer | True | Asset_Manager | 1 | 0 | 0 | 2 | True | False | ||
symbolrotation | Symbol Rotation | Short Integer | True | Symbol_Rotation | 0 | 0 | 2 | True | False | |||
installdate | Install Date | Date | True | 0 | 0 | 8 | True | False | ||||
assetid | Asset ID | String | True | 0 | 0 | 64 | True | False | ||||
notes | Notes | String | True | 0 | 0 | 2000 | True | False | ||||
surfacewater | Receives Surface Water | Short Integer | True | 0 | 0 | 2 | True | False | ||||
exitsystem | Water Exiting System | Short Integer | True | 0 | 0 | 2 | True | False | ||||
rimelev | Rim Elevation | Double | True | 0 | 0 | 8 | True | False | ||||
invertelev | Invert Elevation | Double | True | 0 | 0 | 8 | True | False | ||||
depth | Depth | Double | True | 0 | 0 | 8 | True | False | ||||
highpipeelev | High Pipe Elevation | Double | True | 0 | 0 | 8 | True | False | ||||
lifecyclestatus | Lifecycle Status | Short Integer | False | Lifecycle_Combined | 2 | 0 | 0 | 2 | True | False | ||
spatialsource | Spatial Source | Short Integer | True | Spatial_Source | 0 | 0 | 0 | 2 | True | False | ||
spatialconfidence | Spatial Confidence | Short Integer | True | Spatial_Confidence | 0 | 0 | 0 | 2 | True | False | ||
wallmaterial | Wall Material | Short Integer | True | 0 | 0 | 2 | True | False | ||||
manholetype | Manhole Type | Short Integer | True | 0 | 0 | 2 | True | False | ||||
constructionstatus | Construction Status | Short Integer | True | Construction_Status | 6 | 0 | 0 | 2 | True | False | ||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False | |||
VALIDATIONSTATUS | Validation status | Short Integer | Index | True | Validation Status | 6 | 0 | 0 | 2 | False | True |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_34_VALIDATIO | False | True | VALIDATIONSTATUS |
GDB_34_SUBNETWOR | False | True | SUBNETWORKNAME |
UUID_38 | True | True | GLOBALID |
FDO_OBJECTID | True | True | OBJECTID |
st_spindex__StructureJunction_SHAPE | True | True | SHAPE |
Key | Value |
---|---|
ID | 1 |
Minimum Client Version | 12.7 |
Evaluation Order | 1 |
Name | StructureJunction - Create Manhole Channel |
Description | When a Sewer Storm Vault - Manhole is created, generate and contain a Manhole Channel. |
Type | Calculation |
Batch | False |
Insert Trigger | True |
Update Trigger | False |
Delete Trigger | False |
Subtype | Sewer Storm Vault |
Editable | True |
Enabled | True |
Exclude From Client | True |
Creation Time | 2024-04-26 11:14:29 |
Script |
|
Key | Value |
---|---|
ID | 2 |
Minimum Client Version | 12.6 |
Evaluation Order | 2 |
Name | StructureJunction-GenerateIDs |
Description | Generate IDs for StructureJunction using database sequences |
Type | Calculation |
Batch | False |
Insert Trigger | True |
Update Trigger | True |
Delete Trigger | False |
Field Name | assetid |
Editable | True |
Enabled | True |
Exclude From Client | True |
Creation Time | 2024-04-26 11:14:29 |
Script |
|
Key | Value |
---|---|
ID | 3 |
Minimum Client Version | 12.7 |
Evaluation Order | 3 |
Name | StructureJunction - Manhole Elevation Attributes |
Description | Set rim elevation, invert elevation, and depth on Sewer Storm Vault - Manhole from the Z value. Update Manhole Channel content feature z value if needed. |
Type | Calculation |
Batch | False |
Insert Trigger | True |
Update Trigger | True |
Delete Trigger | False |
Subtype | Sewer Storm Vault |
Editable | True |
Enabled | True |
Exclude From Client | True |
Creation Time | 2024-04-26 11:14:29 |
Script |
|
Key | Value |
---|---|
ID | 4 |
Minimum Client Version | 12.7 |
Evaluation Order | 1 |
Name | StructureJunction - Create Manhole Channel batch |
Description | When a Sewer Storm Vault - Manhole is created, generate and contain a Manhole Channel. |
Type | Calculation |
Batch | True |
Insert Trigger | False |
Update Trigger | False |
Delete Trigger | False |
Subtype | Sewer Storm Vault |
Editable | True |
Enabled | False |
Exclude From Client | True |
Creation Time | 2024-04-26 11:14:30 |
Script |
|
Key | Value |
---|---|
Name | main.StructureJunction__ATTACH |
Dataset Type | Table |
Dataset ID | 121 |
Minimum Client Version | 10.1 |
Alias | Structure Junction Attachment |
OID Field | attachmentid |
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 | {36264497-D77C-42C2-A6C6-433073EFCAEE} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
attachmentid | ATTACHMENTID | OID | Index | False | 0 | 0 | 4 | False | True | |||
rel_globalid | rel_globalid | GUID | Index | False | 0 | 0 | 38 | True | False | |||
content_type | content_type | String | False | 0 | 0 | 150 | True | False | ||||
att_name | att_name | String | False | 0 | 0 | 250 | True | False | ||||
data_size | data_size | Long Integer | False | 0 | 0 | 4 | True | False | ||||
data | data | Blob | True | 0 | 0 | 0 | True | False | ||||
globalid | globalid | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_121_REL_GLOB | False | True | rel_globalid |
UUID_61 | True | True | globalid |
FDO_attachmentid | True | True | attachmentid |
Key | Value |
---|---|
Name | main.StructureJunction__ATTACHREL |
Dataset Type | RelationshipClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 133 |
Type | Composite |
Cardinality | One To Many |
Notification | None |
Is Attachment | True |
Is Attributed | False |
Origin Name | main.StructureJunction |
Origin Primary Key | globalid |
Origin Foreign Key | REL_GLOBALID |
Destination Name | main.StructureJunction__ATTACH |
Forward Path Label | attachment |
Backward Path Label | object |
Minimum Client Version | 10.0 |
Editor Tracking Enabled | False |
Catalog ID | {ADFCAB23-CBD1-4B4F-897C-89211A4C8239} |
Key | Value |
---|---|
Name | main.StructureJunctionObject |
Dataset Type | Table |
Dataset ID | 39 |
Minimum Client Version | 13.2 |
Alias | Structure Junction Object |
OID Field | OBJECTID |
GlobalID Field | GLOBALID |
Subtype Field | ASSETGROUP |
Default Subtype | Unknown |
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 | {45B0A8DA-FD2B-4477-9133-64893E8CB5E5} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Key | Value |
---|---|
utilityNetworkName | main.Network |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECTID | Object ID | OID | Index | False | 0 | 0 | 8 | False | True | |||
ASSETGROUP | Asset group | Long Integer | Subtype | False | 0 | 0 | 0 | 4 | True | True | ||
ASSETTYPE | Asset type | Short Integer | False | 0 | 0 | 0 | 2 | True | True | |||
ASSOCIATIONSTATUS | Association status | Short Integer | False | Network_6_AssociationStatus | 0 | 0 | 0 | 2 | False | True | ||
SUBNETWORKNAME | Supported subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
GLOBALID | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
lifecyclestatus | Lifecycle Status | Short Integer | False | Lifecycle_Combined | 2 | 0 | 0 | 2 | True | False | ||
constructionstatus | Construction Status | Short Integer | True | Construction_Status | 6 | 0 | 0 | 2 | True | False | ||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_39_SUBNETWOR | False | True | SUBNETWORKNAME |
UUID_41 | True | True | GLOBALID |
FDO_OBJECTID | True | True | OBJECTID |
Subtype Name | Subtype Code | Field Name | Default Value | Domain Name | Details |
---|---|---|---|---|---|
Unknown | 0 | ASSETTYPE | 0 | Network_6_UnknownAssetType | |
Unknown | 0 | ASSOCIATIONSTATUS | 0 | Network_6_AssociationStatus | |
Unknown | 0 | SUBNETWORKNAME | Unknown |
Key | Value |
---|---|
Name | main.StructureLine |
Dataset Type | FeatureClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 37 |
Geometry Type | Polyline |
Feature Type | Simple |
Z-Aware | True |
M-Aware | True |
Split Model | Update Insert |
Minimum Client Version | 13.2 |
Alias | Structure Line |
OID Field | OBJECTID |
GlobalID Field | GLOBALID |
Subtype Field | ASSETGROUP |
Default Subtype | Unknown |
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;NAVD88_height_(ftUS) |
X-Min | 500372.76851501653 |
X-Max | 1270078.1610237253 |
Y-Min | 1550391.9656166665 |
Y-Max | 2190094.2549103117 |
Z-Min | 0.00010000000474974513 |
Z-Max | 0.00010000000474974513 |
Catalog ID | {547A0D20-1130-40DD-84A8-E4864EF0B32A} |
Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
Key | Value |
---|---|
utilityNetworkName | main.Network |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECTID | Object ID | OID | Index | False | 0 | 0 | 8 | False | True | |||
ASSETGROUP | Asset group | Long Integer | Subtype | False | 0 | 0 | 0 | 4 | True | True | ||
ASSETTYPE | Asset type | Short Integer | False | 0 | 0 | 0 | 2 | True | True | |||
ASSOCIATIONSTATUS | Association status | Short Integer | False | Network_6_AssociationStatus | 0 | 0 | 0 | 2 | False | True | ||
SUBNETWORKNAME | Subnetwork name | String | Index | False | Unknown | 0 | 0 | 2000 | False | True | ||
FLOWDIRECTION | Flow direction | Short Integer | True | Network_6_FlowDirection | 1 | 0 | 0 | 2 | True | True | ||
SHAPE | Shape | Geometry | Index | False | 0 | 0 | 8 | True | True | |||
GLOBALID | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
name | Name | String | True | 0 | 0 | 64 | True | False | ||||
notes | Notes | String | True | 0 | 0 | 2000 | True | False | ||||
lifecyclestatus | Lifecycle Status | Short Integer | False | Lifecycle_Combined | 2 | 0 | 0 | 2 | True | False | ||
spatialsource | Spatial Source | Short Integer | True | Spatial_Source | 0 | 0 | 0 | 2 | True | False | ||
spatialconfidence | Spatial Confidence | Short Integer | True | Spatial_Confidence | 0 | 0 | 0 | 2 | True | False | ||
constructionstatus | Construction Status | Short Integer | True | Construction_Status | 6 | 0 | 0 | 2 | True | False | ||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False | |||
st_length(SHAPE) | shape_Length | Double | Length | True | 0 | 0 | 0 | False | True |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_37_SUBNETWOR | False | True | SUBNETWORKNAME |
UUID_39 | True | True | GLOBALID |
FDO_OBJECTID | True | True | OBJECTID |
st_spindex__StructureLine_SHAPE | True | True | SHAPE |
Subtype Name | Subtype Code | Field Name | Default Value | Domain Name | Details |
---|---|---|---|---|---|
Unknown | 0 | ASSETTYPE | 0 | Network_6_UnknownAssetType | |
Unknown | 0 | ASSOCIATIONSTATUS | 0 | Network_6_AssociationStatus | |
Unknown | 0 | SUBNETWORKNAME | Unknown | ||
Unknown | 0 | FLOWDIRECTION | 1 | Network_6_FlowDirection |
Key | Value |
---|---|
Name | main.StructureLine__ATTACH |
Dataset Type | Table |
Dataset ID | 122 |
Minimum Client Version | 10.1 |
Alias | Structure Line Attachment |
OID Field | attachmentid |
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 | {399CDFB9-B7C3-443F-89D9-33ED4431C721} |
Class ID | {7A566981-C114-11D2-8A28-006097AFF44E} |
Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
---|---|---|---|---|---|---|---|---|---|---|---|---|
attachmentid | ATTACHMENTID | OID | Index | False | 0 | 0 | 4 | False | True | |||
rel_globalid | rel_globalid | GUID | Index | False | 0 | 0 | 38 | True | False | |||
content_type | content_type | String | False | 0 | 0 | 150 | True | False | ||||
att_name | att_name | String | False | 0 | 0 | 250 | True | False | ||||
data_size | data_size | Long Integer | False | 0 | 0 | 4 | True | False | ||||
data | data | Blob | True | 0 | 0 | 0 | True | False | ||||
globalid | globalid | Global ID | Index | False | 0 | 0 | 38 | False | True | |||
created_user | created_user | String | Creator | True | 0 | 0 | 255 | False | False | |||
created_date | created_date | Date | Created | True | 0 | 0 | 8 | False | False | |||
last_edited_user | last_edited_user | String | Editor | True | 0 | 0 | 255 | False | False | |||
last_edited_date | last_edited_date | Date | Edited | True | 0 | 0 | 8 | False | False |
Name | Is Unique | Is Ascending | Field Name |
---|---|---|---|
GDB_122_REL_GLOB | False | True | rel_globalid |
UUID_62 | True | True | globalid |
FDO_attachmentid | True | True | attachmentid |
Key | Value |
---|---|
Name | main.StructureLine__ATTACHREL |
Dataset Type | RelationshipClass |
Feature Dataset | main.UtilityNetwork |
Dataset ID | 134 |
Type | Composite |
Cardinality | One To Many |
Notification | None |
Is Attachment | True |
Is Attributed | False |
Origin Name | main.StructureLine |
Origin Primary Key | globalid |
Origin Foreign Key | REL_GLOBALID |
Destination Name | main.StructureLine__ATTACH |
Forward Path Label | attachment |
Backward Path Label | object |
Minimum Client Version | 10.0 |
Editor Tracking Enabled | False |
Catalog ID | {499CF551-8619-4A5F-B549-DB7A98B6CA4F} |
Key | Value |
---|---|
Name | main.UtilityNetwork |
Dataset Type | FeatureDataset |
# of Children | 20 |
Spatial Reference | NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS) |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Manager |
Description | The manager of an asset. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 3 |
# of Assignments | 20 |
Code | Description | Details |
---|---|---|
1 | Our Agency | |
2 | Private | |
100 | Other |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Owner |
Description | The owner of an asset. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 3 |
# of Assignments | 20 |
Code | Description | Details |
---|---|---|
1 | Our Agency | |
2 | Private | |
100 | Other |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Device_BMP_Inlet |
Description | The asset type for the stormwater devices's asset group BMP Inlet. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 4 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
6 | Apron Inlet | |
7 | Pipe Inlet | |
8 | Channel Inlet |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 30 | BMP Inlet | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Device_BMP_Point |
Description | The asset type for the stormwater device's asset group BMP Point. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 18 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
2 | Detention Basin | |
3 | Dry Basin | |
6 | Treatment Vault | |
7 | Wet Basin | |
8 | Bed Filter | |
9 | Infiltration Basin | |
10 | Media Filter | |
21 | Bio-Filtration | |
22 | Bio-Retention | |
23 | Bioswale | |
24 | Filtration Device | |
25 | Infiltration Feature | |
26 | Pervious Pavement | |
27 | Sediment Trap | |
28 | Settling Basin | |
29 | Green Roof | |
30 | Retention Basin |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 29 | BMP Point | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Device_Catch_Basin |
Description | The asset type for the stormwater device's asset group catch basin. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 4 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
204 | Infiltration | |
205 | Sediment Trap | |
210 | Drop Inlet |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 28 | Catch Basin | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Device_Cleanout |
Description | The asset type for the stormwater device's asset group clean out. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 2 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Cleanout |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 21 | Cleanout | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Device_Connection |
Description | The asset type for the stormwater device's asset group pipe connection. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 4 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
241 | Pipe Connection | |
242 | Open Channel Connection | |
245 | Linear Drain Connection |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 23 | Connection | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Device_Manhole_Channel |
Description | The asset type for the Stormwater device's asset group manhole channel. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 3 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
301 | Manhole Channel | |
302 | Directional Manhole Channel |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 32 | Manhole Channel | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Device_Outlet |
Description | The asset type for the stormwater device's asset group discharge. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 6 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
5 | Pipe Outlet | |
9 | Tide Gate Chamber | |
10 | Apron Outlet | |
11 | Flap Gate | |
12 | Riser |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 22 | Outlet | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Device_Pump |
Description | The asset type for the stormwater device's asset group pump. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 2 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | Unknown type of pump. |
61 | Pump | Pump device that convey stormwater from a lower elevation to a higher elevation. |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 5 | Pump | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Device_Weir |
Description | The asset type for the stormwater device's asset group weir. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 7 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | Unknown type of weir. |
281 | Broad-Crested | A weir that typically spans the width of a bioswale, or channel, and operates with higher levels of downstream water. |
282 | Combination | A weir designed for areas of varying flows of water. |
283 | Labyrinth | A weir designed to control flow by an increased length in respect to the bioswale or channel's width. |
284 | Minimum Energy Loss | A weir designed for areas of heavy/torrential storms to minimize flooding upstream. |
285 | Sharp-Crested | A weir designed to take accurate measurements of flow and discharge. |
286 | V-Notch | A weir with a "V" shape to minimize the flow of a bioswale or open channel. |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 26 | Weir | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Junction_Wall |
Description | The asset type for the stormwater junction's asset group wall. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 5 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | Unknown type of wall. |
81 | Endwall | A wall to support a transportation feature and/or protect from erosion at the outlet of a culvert. |
82 | Headwall | A wall to support a transportation feature and/or protect from erosion at the inlet of a culvert. |
83 | Wingwall | An extending wall at a headwall to maintain slope. |
84 | Floodwall | A manmade structure to protect assets from inundation and debris during a storm event. |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterJunction | 23 | Wall | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Line_Culvert |
Description | The asset type for the stormwater line's asset group culvert |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 6 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | Unknown type of culvert. |
81 | Pipe Culvert | A culvert made of pipe and typically surrounded by soil or natural materials. |
82 | Pipe Arch | A culvert made of a pipe that has been shaped into a specific width to form an arch. |
83 | Box Culvert | A culvert in a box or rectangular shape allowing for the flow of stormwater through an open channel under a roadway |
84 | Arch Culvert | A culvert in an arch shape allowing for the flow of stormwater through an open channel under a roadway. |
85 | Bridge Culvert | A culvert allowing for the flow of stormwater through an open channel under a bridge. |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterLine | 6 | Culvert | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Line_Linear_Drain |
Description | The asset type for the stormwater line's asset group linear drain |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 3 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
121 | Trench Drain | |
122 | Slotted Drain |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterLine | 7 | Linear Drain | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Line_Open_Channel |
Description | The asset type for the stormwater line's asset group open channel. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 6 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
43 | Aquaduct Channel | |
44 | Spillway Channel | |
45 | Natural Channel | |
46 | Ditch Channel | |
47 | Roadside Gutter |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterLine | 5 | Open Channel | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Stormwater_Line_Pipe |
Description | The asset type for the stormwater line's asset group pipe |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 4 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | Unknown type of pipe. |
3 | Gravity Pipe | Pipe in which stormwater flow results from a difference in elevation. |
4 | Force Pipe | Pipes that convey stormwater under pressure from a pump to a discharge point. |
5 | Perforated Pipe | Pipe with small slots or holes to allow stormwater to exit or enter easily. |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterLine | 4 | Pipe | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Structure_Boundary_BMP_Boundary |
Description | The asset type for the structure boundary's asset group BMP. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 18 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
2 | Detention Basin | |
3 | Dry Basin | |
6 | Treatment Vault | |
7 | Wet Basin | |
8 | Bed Filter | |
9 | Infiltration Basin | |
10 | Media Filter | |
21 | Bio-Filtration | |
22 | Bio-Retention | |
23 | Bioswale | |
24 | Filtration Device | |
25 | Infiltration Feature | |
26 | Pervious Pavement | |
27 | Sediment Trap | |
28 | Settling Basin | |
29 | Green Roof | |
30 | Retention Basin |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureBoundary | 401 | BMP Boundary | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Structure_Boundary_Storm_Lift_Station_Boundary |
Description | The asset type for the structure boundary's asset group storm pump station. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 2 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
42 | Lift Station |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureBoundary | 404 | Storm Lift Station Boundary | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Asset_Type_Structure_Junction_Sewer_Storm_Vault |
Description | The asset type for the structure junction's asset group sewer storm vault. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 2 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | Unknown type of sewer storm vault. |
9 | Manhole | A manhole is a feature that connects two or more pipes and controls the flow of water through the system through the elevation of the pipes. |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureJunction | 208 | Sewer Storm Vault | ASSETTYPE |
Key | Value |
---|---|
Owner | |
Domain Name | Attribute Rule Type |
Description | The attribute rule type that created the error record. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Default Value |
Merge Policy | Default Value |
# of Codes | 3 |
# of Assignments | 4 |
Code | Description | Details |
---|---|---|
0 | Calculation | |
1 | Constraint | |
2 | Validation |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.GDB_ValidationObjectErrors | RuleType | ||
main.GDB_ValidationPointErrors | RuleType | ||
main.GDB_ValidationLineErrors | RuleType | ||
main.GDB_ValidationPolygonErrors | RuleType |
Key | Value |
---|---|
Owner | |
Domain Name | BMP_Class |
Description | The class of a BMP. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 3 |
# of Assignments | 2 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Centralized | |
2 | Decentralized |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureBoundary | 401 | BMP Boundary | bmpclass |
main.StormwaterDevice | 29 | BMP Point | bmpclass |
Key | Value |
---|---|
Owner | |
Domain Name | Construction_Status |
Description | Valid Construction statues for the assets. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 8 |
# of Assignments | 28 |
Code | Description | Details |
---|---|---|
0 | Warehouse | |
1 | Abandoned | |
2 | Removed | |
3 | Design | |
4 | Approved | |
5 | Under construction | |
6 | Construction complete | |
7 | Maintenance |
Key | Value |
---|---|
Owner | |
Domain Name | Event_Level |
Description | The activate value of a stormwater or sewer device. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 4 |
# of Assignments | 3 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Low Event | |
50 | Medium Event | |
100 | High Event |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 28 | Catch Basin | activevol |
main.StormwaterDevice | 22 | Outlet | activevol |
main.StormwaterDevice | 23 | Connection | activevol |
Key | Value |
---|---|
Owner | |
Domain Name | Lifecycle_Combined |
Description | Bitwise combination of lifecycle states for subnetwork management |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 6 |
# of Assignments | 11 |
Code | Description | Details |
---|---|---|
0 | Out of Service | |
1 | Proposed | |
2 | In Service | |
3 | Proposed and In Service | |
4 | Planned Removal | |
6 | In Service and Planned Removal |
Key | Value |
---|---|
Owner | |
Domain Name | Lifecycle_Status |
Description | Valid lifecycle states for the assets. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 4 |
# of Assignments | 17 |
Code | Description | Details |
---|---|---|
0 | Out of Service | |
1 | Proposed | |
2 | In Service | |
4 | Planned Removal |
Key | Value |
---|---|
Owner | |
Domain Name | Manhole_Types |
Description | Types of manholes. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 10 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
2 | Diversion Manhole | |
3 | Junction Manhole | |
6 | Drop Manhole | |
7 | Drop Trap Manhole | |
8 | Flush Manhole | |
9 | Manhole | |
10 | Offset Manhole | |
11 | Shallow Manhole | |
12 | Siphon Manhole |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureJunction | 208 | Sewer Storm Vault | manholetype |
Key | Value |
---|---|
Owner | |
Domain Name | Network_6_AssociationStatus |
Description | Indicates how the feature participates in associations. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 36 |
# of Assignments | 39 |
Code | Description | Details |
---|---|---|
0 | None | |
1 | Container | |
2 | Structure | |
4 | Content | |
5 | Content and Container | |
6 | Content and Structure | |
8 | Attachment | |
9 | Attachment and Container | |
10 | Attachment and Structure | |
12 | Attachment and Content | |
13 | Attachment and Content and Container | |
14 | Attachment and Content and Structure | |
16 | Visible Content | |
17 | Visible Content and Container | |
18 | Visible Content and Structure | |
24 | Visible Content and Attachment | |
25 | Visible Content and Attachment and Container | |
26 | Visible Content and Attachment and Structure | |
32 | Connectivity | |
33 | Connectivity and Container | |
34 | Connectivity and Structure | |
36 | Connectivity and Content | |
37 | Connectivity and Content and Container | |
38 | Connectivity and Content and Structure | |
40 | Connectivity and Attachment | |
41 | Connectivity and Attachment and Container | |
42 | Connectivity and Attachment and Structure | |
44 | Connectivity and Attachment and Content | |
45 | Connectivity and Attachment and Content and Container | |
46 | Connectivity and Attachment and Content and Structure | |
48 | Connectivity and Visible Content | |
49 | Connectivity and Visible Content and Container | |
50 | Connectivity and Visible Content and Structure | |
56 | Connectivity and Visible Content and Attachment | |
57 | Connectivity and Visible Content and Attachment and Container | |
58 | Connectivity and Visible Content and Attachment and Structure |
Key | Value |
---|---|
Owner | |
Domain Name | Network_6_FeatureSourceID |
Description | The source feature class name in the utility network. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Default Value |
Merge Policy | Default Value |
# of Codes | 16 |
# of Assignments | 0 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Association | |
2 | System Junction | |
3 | System Junction Object | |
4 | Structure Junction | |
5 | Structure Line | |
6 | Structure Boundary | |
7 | Structure Junction Object | |
8 | Structure Edge Object | |
9 | Stormwater Device | |
10 | Stormwater Line | |
11 | Stormwater Assembly | |
12 | Stormwater Junction | |
13 | Stormwater Networks | |
14 | Stormwater Junction Object | |
15 | Stormwater Edge Object |
Key | Value |
---|---|
Owner | |
Domain Name | Network_6_FlowDirection |
Description | Indicates how the feature flows in network. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 3 |
# of Assignments | 12 |
Code | Description | Details |
---|---|---|
1 | With digitized | |
2 | Against digitized | |
3 | Indeterminate |
Key | Value |
---|---|
Owner | |
Domain Name | Network_6_IsConnected |
Description | Indicates if the feature is connected to a subnetwork controller. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 3 |
# of Assignments | 24 |
Code | Description | Details |
---|---|---|
0 | False | |
1 | True | |
2 | Unknown |
Key | Value |
---|---|
Owner | |
Domain Name | Network_6_IsContentVisible |
Description | Indicates if the content or attachment association is visible for containment associations. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Default Value |
Merge Policy | Default Value |
# of Codes | 2 |
# of Assignments | 0 |
Code | Description | Details |
---|---|---|
0 | False | |
1 | True |
Key | Value |
---|---|
Owner | |
Domain Name | Network_6_IsDeleted |
Description | Indicates if a subnetwork has been marked for deletion. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Default Value |
Merge Policy | Default Value |
# of Codes | 2 |
# of Assignments | 0 |
Code | Description | Details |
---|---|---|
0 | False | |
1 | True |
Key | Value |
---|---|
Owner | |
Domain Name | Network_6_IsDirty |
Description | Indicates if a subnetwork is clean, dirty, or invalid. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Default Value |
Merge Policy | Default Value |
# of Codes | 3 |
# of Assignments | 3 |
Code | Description | Details |
---|---|---|
0 | Clean | |
1 | Dirty | |
2 | Invalid |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterSubnetLine | ISDIRTY | ||
main.StormwaterSubnetLine | 0 | Unknown | ISDIRTY |
main.StormwaterSubnetLine | 1 | Stormwater Management Area | ISDIRTY |
Key | Value |
---|---|
Owner | |
Domain Name | Network_6_IsSubnetworkController |
Description | Indicates if a device feature is a subnetwork controller. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Default Value |
Merge Policy | Default Value |
# of Codes | 2 |
# of Assignments | 13 |
Code | Description | Details |
---|---|---|
0 | False | |
1 | True |
Key | Value |
---|---|
Owner | |
Domain Name | Network_6_TerminalNames |
Description | The terminal names in the utility network. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 14 |
# of Assignments | 12 |
Code | Description | Details |
---|---|---|
0 | None | |
1 | Single Terminal | |
2 | High Pressure In | |
3 | Low Pressure Out | |
4 | Low Pressure In | |
5 | High Pressure Out | |
6 | Inlet Port | |
7 | Outlet Port | |
8 | Port One | |
9 | Port Two | |
10 | Upstream | |
11 | Upstream 2 | |
12 | Downstream | |
13 | Downstream 2 |
Key | Value |
---|---|
Owner | |
Domain Name | Network_6_TierName |
Description | The tier names in the utility network. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Default Value |
Merge Policy | Default Value |
# of Codes | 2 |
# of Assignments | 13 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Stormwater Management Area |
Key | Value |
---|---|
Owner | |
Domain Name | Network_6_TierTopologyType |
Description | The type of topology for each tier. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Default Value |
Merge Policy | Default Value |
# of Codes | 2 |
# of Assignments | 0 |
Code | Description | Details |
---|---|---|
1 | Radial | |
2 | Mesh |
Key | Value |
---|---|
Owner | |
Domain Name | Network_6_UnknownAssetType |
Description | The AssetType domain for the Unknown AssetGroup. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Default Value |
Merge Policy | Default Value |
# of Codes | 1 |
# of Assignments | 11 |
Code | Description | Details |
---|---|---|
0 | Unknown |
Key | Value |
---|---|
Owner | |
Domain Name | Spatial_Confidence |
Description | Confidence values for the data |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 4 |
# of Assignments | 24 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | High | |
2 | Medium | |
3 | Low |
Key | Value |
---|---|
Owner | |
Domain Name | Spatial_Source |
Description | Source of the data |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 6 |
# of Assignments | 24 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | As-Built | |
2 | CAD | |
3 | Digitized | |
4 | GPS/GNSS | |
5 | Field Sketch |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_BMP_Material |
Description | The material of stormwater BMPs |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 16 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Amended Soil | |
2 | Biochar | |
3 | Bioretention Soil | |
4 | Brick | |
5 | Concrete | |
6 | Gravel | |
7 | Iron-enhanced Filter | |
8 | Mulch | |
9 | Native Soil | |
10 | Pavers | |
11 | Permeable Pavement | |
12 | Rock | |
13 | Sand Compost Mix | |
14 | Sand Filter | |
15 | Spent Lime |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 29 | BMP Point | material |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Catch_Basin_Opening_Type |
Description | The type of catch basin |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 4 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Curb Opening | |
2 | Grate | |
3 | Combination |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 28 | Catch Basin | designtype |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Cleanout_Diameter |
Description | The diameter of stormwater cleanouts. |
Field Type | Double |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 30 |
# of Assignments | 1 |
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" |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 21 | Cleanout | diameter |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Cleanout_Material |
Description | The material of stormwater cleanouts. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 27 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | ABS Plastic - ABS | |
2 | Asbestos Cement - AC | |
3 | Asphalt - ASP | |
4 | Brick - BR | |
5 | Cast Iron - CAS | |
6 | Clay Tile - CT | |
7 | Concrete (Non-Reinforced) - CP | |
8 | Concrete Segments (Bolted) - CSB | |
9 | Concrete Segments (Unbolted) - CSU | |
10 | Cured In Place - CIP | |
11 | Ductile Iron - DIP | |
12 | Fiberglass Reinforced - FRP | |
13 | Galvanized Pipe - GP | |
14 | Glass Reinforced Cement - GRC | |
15 | High Density Polyethylene - HDPE | |
17 | Plastic/Steel Composite - PSC | |
18 | Polyethylene - PE | |
19 | Polypropylene - PP | |
20 | Polyvinyl Chloride - PVC | |
21 | Pre-Stressed Concrete Cylinder - PCCP | |
22 | Reinforced Concrete - RCP | |
23 | Reinforced Plastic (Truss) - RMP | |
24 | Segmented Block - SB | |
25 | Steel - SP | |
26 | Vitrified Clay - VCP | |
16 | Other - OTH |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 21 | Cleanout | material |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Culvert_Shape |
Description | The shape of stormwater culverts. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 8 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Circular | |
2 | Horseshoe | |
3 | Oblong | |
4 | Rectangular | |
5 | Trapezoidal | |
6 | Triangular | |
100 | Other |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterLine | 6 | Culvert | pipeshape |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Exiting_System |
Description | The way water exits the stormwater system. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 4 |
# of Assignments | 5 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Waterway | |
2 | Other System | |
3 | None |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureJunction | 208 | Sewer Storm Vault | exitsystem |
main.StormwaterDevice | 5 | Pump | exitsystem |
main.StormwaterDevice | 26 | Weir | exitsystem |
main.StormwaterDevice | 28 | Catch Basin | exitsystem |
main.StormwaterDevice | 22 | Outlet | exitsystem |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Inlet_Shape |
Description | The shpae of the stormwater inlet. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 4 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Round | |
2 | Square | |
3 | Rectangle |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 28 | Catch Basin | inletshape |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Open_Channel_Type |
Description | The type of open channel. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 3 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
3 | Wet | |
4 | Dry |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterLine | 5 | Open Channel | type |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Outlet_Diameter |
Description | The diameter of a stormwater oulet. |
Field Type | Double |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 29 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
0.5 | 1/2" | |
0.75 | 3/4" | |
1 | 1" | |
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" |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 22 | Outlet | diameter |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Outlet_Location |
Description | The location of the stormwater oulet. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 4 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Closed Pipe | |
2 | Open Drainage | |
3 | In-Stream |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 22 | Outlet | location |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Outlet_Material |
Description | The material of stormwater outlets. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 27 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | ABS Plastic - ABS | |
2 | Asbestos Cement - AC | |
3 | Asphalt - ASP | |
4 | Brick - BR | |
5 | Cast Iron - CAS | |
6 | Clay Tile - CT | |
7 | Concrete (Non-Reinforced) - CP | |
8 | Concrete Segments (Bolted) - CSB | |
9 | Concrete Segments (Unbolted) - CSU | |
10 | Cured In Place - CIP | |
11 | Ductile Iron - DIP | |
12 | Fiberglass Reinforced - FRP | |
13 | Galvanized Pipe - GP | |
14 | Glass Reinforced Cement - GRC | |
15 | High Density Polyethylene - HDPE | |
16 | Other - OTH | |
17 | Plastic/Steel Composite - PSC | |
18 | Polyethylene - PE | |
19 | Polypropylene - PP | |
20 | Polyvinyl Chloride - PVC | |
21 | Pre-Stressed Concrete Cylinder - PCCP | |
22 | Reinforced Concrete - RCP | |
23 | Reinforced Plastic (Truss) - RMP | |
24 | Segmented Block - SB | |
25 | Steel - SP | |
26 | Vitrified Clay - VCP |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 22 | Outlet | material |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Pipe_Diameter |
Description | The diameter of stormwater pipes. |
Field Type | Double |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 30 |
# of Assignments | 2 |
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" |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterLine | 4 | Pipe | diameter |
main.StormwaterLine | 7 | Linear Drain | diameter |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Pipe_Liner_Method |
Description | The liner method of stormwater pipes. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 14 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Cured In Place - CIP | |
2 | Fold and Form or Deform/Reform - FF | |
3 | Formed-In-Place Liner - FP | |
4 | Grout-In-Place Liner - GP | |
5 | Glass Reinforced Cement - GRC | |
6 | None - N | |
7 | Continuous Slip Liner - SC | |
8 | Sectional Slip Liner - SE | |
9 | Spray Liner - SL | |
10 | Segmented Panel - SN | |
11 | Segmented Pipe - SP | |
12 | Spiral Wound - SW | |
100 | Other - ZZ |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterLine | 4 | Pipe | linermethod |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Pipe_Liner_Year |
Description | The liner year of stormwater pipes. |
Field Type | Short Integer |
Domain Type | Range |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | |
# of Assignments | 1 |
Minimum | Maximum |
---|---|
1800 | 2060 |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterLine | 4 | Pipe | lineryear |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Pipe_Material |
Description | The material of stormwater pipes. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 27 |
# of Assignments | 3 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | ABS Plastic - ABS | |
2 | Asbestos Cement - AC | |
3 | Asphalt - ASP | |
4 | Brick - BR | |
5 | Cast Iron - CAS | |
6 | Clay Tile - CT | |
7 | Concrete (Non-Reinforced) - CP | |
8 | Concrete Segments (Bolted) - CSB | |
9 | Concrete Segments (Unbolted) - CSU | |
10 | Cured In Place - CIP | |
11 | Ductile Iron - DIP | |
12 | Fiberglass Reinforced - FRP | |
13 | Galvanized Pipe - GP | |
14 | Glass Reinforced Cement - GRC | |
15 | High Density Polyethylene - HDPE | |
16 | Other - OTH | |
17 | Plastic/Steel Composite - PSC | |
18 | Polyethylene - PE | |
19 | Polypropylene - PP | |
20 | Polyvinyl Chloride - PVC | |
21 | Pre-Stressed Concrete Cylinder - PCCP | |
22 | Reinforced Concrete - RCP | |
23 | Reinforced Plastic (Truss) - RMP | |
24 | Segmented Block - SB | |
25 | Steel - SP | |
26 | Vitrified Clay - VCP |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterLine | 4 | Pipe | material |
main.StormwaterLine | 6 | Culvert | material |
main.StormwaterLine | 7 | Linear Drain | material |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Pipe_Shape |
Description | The shape of stormwater pipes. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 8 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Circular | |
2 | Horseshoe | |
3 | Oblong | |
4 | Rectangular | |
5 | Trapezoidal | |
6 | Triangular | |
100 | Other |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterLine | 4 | Pipe | pipeshape |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Pump_Type |
Description | The type of the stormwater pump. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 7 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Centerfugal Pump | |
2 | Duplex Pump | |
4 | Simplex Pump | |
5 | Split-case Pump | |
6 | Triplex Pump | |
7 | Turbine Pump |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterDevice | 5 | Pump | designtype |
Key | Value |
---|---|
Owner | |
Domain Name | Stormwater_Wall_Material |
Description | The material of stormwater walls. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 33 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | ABS Plastic - ABS | |
2 | Asbestos Cement - AC | |
3 | Asphalt - ASP | |
4 | Brick - BR | |
5 | Cast Iron - CAS | |
6 | Clay Tile - CT | |
7 | Concrete (Non-Reinforced) - CP | |
8 | Concrete Segments (Bolted) - CSB | |
9 | Concrete Segments (Unbolted) - CSU | |
10 | Cured In Place - CIP | |
11 | Ductile Iron - DIP | |
12 | Fiberglass Reinforced - FRP | |
13 | Galvanized Pipe - GP | |
14 | Glass Reinforced Cement - GRC | |
15 | High Density Polyethylene - HDPE | |
16 | Other - OTH | |
17 | Plastic/Steel Composite - PSC | |
18 | Polyethylene - PE | |
19 | Polypropylene - PP | |
20 | Polyvinyl Chloride - PVC | |
21 | Pre-Stressed Concrete Cylinder - PCCP | |
22 | Reinforced Concrete - RCP | |
23 | Reinforced Plastic (Truss) - RMP | |
24 | Segmented Block - SB | |
25 | Steel - SP | |
26 | Vitrified Clay - VCP | |
27 | Corrugated Metal - CMP | |
28 | Earth & Geotextile - EARGEO | |
29 | Earthen - EAR | |
30 | Geotextile - GEO | |
31 | Transite - TTE | |
32 | Wood - WD |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StormwaterJunction | 23 | Wall | material |
Key | Value |
---|---|
Owner | |
Domain Name | Structure_Boundary_BMP_Condition |
Description | The condition of a BMP. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 7 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | More Data Needed | |
2 | Inspection Due | |
3 | Inspected >4 | |
4 | Inspected 3-4 | |
5 | Inspected 2-3 | |
6 | Inspected <2 |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureBoundary | 401 | BMP Boundary | assetcondition |
Key | Value |
---|---|
Owner | |
Domain Name | Structure_Sewer_Storm_Manhole_Step_Material |
Description | The step material of structure manholes. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 5 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
4 | Brick - BR | |
16 | Other - OTH | |
33 | Metal - M | |
34 | Plastic - P |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureJunction | 208 | Sewer Storm Vault | stepmaterial |
Key | Value |
---|---|
Owner | |
Domain Name | Structure_Sewer_Storm_Materials |
Description | The materials of sewer storm structures. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 12 |
# of Assignments | 3 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | ABS Plastic - ABS | |
5 | Cast Iron - CAS | |
11 | Ductile Iron - DIP | |
15 | High Density Polyethylene - HDPE | |
17 | Plastic/Steel Composite - PSC | |
18 | Polyethylene - PE | |
19 | Polypropylene - PP | |
20 | Polyvinyl Chloride - PVC | |
23 | Reinforced Plastic (Truss) - RMP | |
25 | Steel - SP | |
100 | Other |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureJunction | 208 | Sewer Storm Vault | material |
main.StructureJunction | 208 | Sewer Storm Vault | wallmaterial |
main.StormwaterDevice | 28 | Catch Basin | material |
Key | Value |
---|---|
Owner | |
Domain Name | Structure_Sewer_Storm_Vault_Cover_Shape |
Description | The cover shape of structure manholes. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 12 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
3 | Arched (with flat bottom) - A | |
4 | Barrel - B | |
5 | Circular - C | |
6 | Egg shaped - E | |
7 | Horseshoe - H | |
8 | Oval or Elliptical - O | |
9 | Rectangular - R | |
10 | Square - S | |
11 | Trapezoidal - T | |
12 | U-Shaped with flat top (straight walls) - U | |
100 | Other - Z |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureJunction | 208 | Sewer Storm Vault | covershape |
Key | Value |
---|---|
Owner | |
Domain Name | Structure_Sewer_Storm_Vault_Cover_Type |
Description | The cover type of structure manholes. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 7 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
3 | Solid | |
4 | Vented/Slotted | |
5 | Gasketed | |
6 | Bolted | |
7 | Inner Cover | |
8 | Locking |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureJunction | 208 | Sewer Storm Vault | type |
Key | Value |
---|---|
Owner | |
Domain Name | Structure_Sewer_Storm_Vault_Manhole_Cone |
Description | The cone type of structure manholes. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 3 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Straight | |
2 | Offset |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureJunction | 208 | Sewer Storm Vault | conetype |
Key | Value |
---|---|
Owner | |
Domain Name | Structure_Sewer_Storm_Vault_Manhole_Location |
Description | The location of structure manholes. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 14 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Main Highway | |
2 | Light Highway | |
3 | Easement/Right of Way | |
4 | Woods | |
5 | Sidewalk | |
6 | Parking Lot | |
7 | Alley | |
8 | Ditch | |
9 | Building | |
10 | Creek | |
11 | Railway | |
12 | Airport | |
13 | Yard |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureJunction | 208 | Sewer Storm Vault | location |
Key | Value |
---|---|
Owner | |
Domain Name | Structure_Sewer_Storm_Vault_Manhole_Surface |
Description | The surface type of structure manholes. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 7 |
# of Assignments | 1 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Asphalt | |
2 | Concrete Pavement | |
3 | Concrete Collar | |
4 | Grass/Dirt | |
5 | Gravel | |
100 | Other |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.StructureJunction | 208 | Sewer Storm Vault | surface |
Key | Value |
---|---|
Owner | |
Domain Name | Symbol_Rotation |
Description | The rotation of an asset's symbol. |
Field Type | Short Integer |
Domain Type | Range |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | |
# of Assignments | 15 |
Minimum | Maximum |
---|---|
0 | 359 |
Key | Value |
---|---|
Owner | |
Domain Name | Validation Error Exception |
Description | Indicates if the error record has been marked as an exception. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Default Value |
Merge Policy | Default Value |
# of Codes | 2 |
# of Assignments | 4 |
Code | Description | Details |
---|---|---|
0 | False | |
1 | True |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.GDB_ValidationObjectErrors | IsException | ||
main.GDB_ValidationPointErrors | IsException | ||
main.GDB_ValidationLineErrors | IsException | ||
main.GDB_ValidationPolygonErrors | IsException |
Key | Value |
---|---|
Owner | |
Domain Name | Validation Error Phase |
Description | Indicates error lifecycle phase of an error |
Field Type | Long Integer |
Domain Type | Coded Value |
Split Policy | Default Value |
Merge Policy | Default Value |
# of Codes | 3 |
# of Assignments | 4 |
Code | Description | Details |
---|---|---|
2 | Review | |
4 | Correction | |
6 | Verification |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.GDB_ValidationObjectErrors | ErrorPhase | ||
main.GDB_ValidationPointErrors | ErrorPhase | ||
main.GDB_ValidationLineErrors | ErrorPhase | ||
main.GDB_ValidationPolygonErrors | ErrorPhase |
Key | Value |
---|---|
Owner | |
Domain Name | Validation Error Status |
Description | Indicates error lifecycle status of an error |
Field Type | Long Integer |
Domain Type | Coded Value |
Split Policy | Default Value |
Merge Policy | Default Value |
# of Codes | 6 |
# of Assignments | 4 |
Code | Description | Details |
---|---|---|
1 | Reviewed | |
2 | Resolved | |
3 | Mark As Exception | |
4 | Acceptable | |
6 | Unacceptable | |
9 | Exception |
Dataset | Subtype Code | Subtype Name | Field Name |
---|---|---|---|
main.GDB_ValidationObjectErrors | ErrorStatus | ||
main.GDB_ValidationPointErrors | ErrorStatus | ||
main.GDB_ValidationLineErrors | ErrorStatus | ||
main.GDB_ValidationPolygonErrors | ErrorStatus |
Key | Value |
---|---|
Owner | |
Domain Name | Validation Status |
Description | The current record's validation status. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Default Value |
Merge Policy | Default Value |
# of Codes | 8 |
# of Assignments | 20 |
Code | Description | Details |
---|---|---|
0 | No calculation required, no validation required, no error | |
1 | No calculation required, no validation required, has error(s) | |
2 | No calculation required, validation required, no error | |
3 | No calculation required, validation required, has error(s) | |
4 | Calculation required, no validation required, no error | |
5 | Calculation required, no validation required, has error(s) | |
6 | Calculation required, validation required, no error | |
7 | Calculation required, validation required, has error(s) |
Key | Value |
---|---|
Owner | |
Domain Name | Validation_Status |
Description | The current record's validation status. |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 8 |
# of Assignments | 0 |
Code | Description | Details |
---|---|---|
0 | No calculation required, no validation required, no error | |
1 | No calculation required, no validation required, has error(s) | |
2 | No calculation required, validation required, no error | |
3 | No calculation required, validation required, has error(s) | |
4 | Calculation required, no validation required, no error | |
5 | Calculation required, no validation required, has error(s) | |
6 | Calculation required, validation required, no error | |
7 | Calculation required, validation required, has error(s) |
Key | Value |
---|---|
Owner | |
Domain Name | Yes_No |
Description | A yes/no indicator |
Field Type | Short Integer |
Domain Type | Coded Value |
Split Policy | Duplicate |
Merge Policy | Default Value |
# of Codes | 3 |
# of Assignments | 20 |
Code | Description | Details |
---|---|---|
0 | Unknown | |
1 | Yes | |
2 | No |