| Key | Value |
|---|---|
| Name | Sewer_System_9ffe17e518f94c629497ff923c3f7963 |
| Workspace Type | Remote Database |
| Workspace Factory | Feature Service DB |
| Geodatabase Release | |
| Date Exported | 2025-03-26 10:43:15 |
| Path |
| Owner | Domain Name | Description | Field Type | Domain Type | Split Policy | Merge Policy | # of Codes | # of Assignments |
|---|---|---|---|---|---|---|---|---|
| Asset_Type_Sewer_Device_Backflow_Preventer | String | Coded Value | Duplicate | Default Value | 1 | 1 | ||
| Asset_Type_Sewer_Device_Cleanout | String | Coded Value | Duplicate | Default Value | 4 | 1 | ||
| Asset_Type_Sewer_Device_Controllable_Valve | String | Coded Value | Default Value | Default Value | 1 | 1 | ||
| Asset_Type_Sewer_Device_Discharge | String | Coded Value | Duplicate | Default Value | 3 | 1 | ||
| Asset_Type_Sewer_Device_Grease_Trap | String | Coded Value | Duplicate | Default Value | 4 | 1 | ||
| Asset_Type_Sewer_Device_Meter | String | Coded Value | Default Value | Default Value | 3 | 1 | ||
| Asset_Type_Sewer_Device_Pump | String | Coded Value | Duplicate | Default Value | 3 | 1 | ||
| Asset_Type_Sewer_Device_Relief_Valve | String | Coded Value | Default Value | Default Value | 4 | 1 | ||
| Asset_Type_Sewer_Device_Service_Connection | String | Coded Value | Duplicate | Default Value | 4 | 1 | ||
| Asset_Type_Sewer_Device_Treatment | String | Coded Value | Duplicate | Default Value | 1 | 1 | ||
| Asset_Type_Sewer_Junction_Fitting | String | Coded Value | Duplicate | Default Value | 20 | 1 | ||
| Asset_Type_Sewer_Line_Lateral_Service | String | Coded Value | Duplicate | Default Value | 4 | 1 | ||
| Asset_Type_Sewer_Line_Sewer_Force_Main | String | Coded Value | Duplicate | Default Value | 1 | 1 | ||
| Asset_Type_Sewer_Line_Sewer_Gravity_Main | String | Coded Value | Duplicate | Default Value | 3 | 1 | ||
| Asset_Type_Structure_Boundary_Sewer_Lift_Station_Boundary | String | Coded Value | Duplicate | Default Value | 1 | 1 | ||
| Asset_Type_Structure_Boundary_Sewer_Storm_Vault_Boundary | String | Coded Value | Duplicate | Default Value | 5 | 1 | ||
| Asset_Type_Structure_Boundary_Sewer_Treatment_Plant_Boundary | String | Coded Value | Duplicate | Default Value | 1 | 1 | ||
| Asset_Type_Structure_Junction_Sewer_Lift_Station | String | Coded Value | Duplicate | Default Value | 1 | 1 | ||
| Asset_Type_Structure_Junction_Sewer_Storm_Manhole | String | Coded Value | Duplicate | Default Value | 10 | 1 | ||
| Asset_Type_Structure_Junction_Sewer_Storm_Vault | String | Coded Value | Duplicate | Default Value | 5 | 1 | ||
| Asset_Type_Structure_Line_Sewer_Storm_Casing | String | Coded Value | Duplicate | Default Value | 1 | 1 | ||
| ESRI_FIX_TYPE_DOMAIN | Short Integer | Coded Value | Default Value | Default Value | 5 | 14 | ||
| ESRI_NUM_SATS_DOMAIN | Short Integer | Range | Default Value | Default Value | 14 | |||
| ESRI_POSITIONSOURCETYPE_DOMAIN | Position Source Type | Short Integer | Coded Value | Default Value | Default Value | 6 | 14 | |
| ESRI_STATION_ID_DOMAIN | Short Integer | Range | Default Value | Default Value | 14 | |||
| LifecycleStatus | String | Coded Value | Duplicate | Default Value | 10 | 21 | ||
| Location | String | Coded Value | Duplicate | Default Value | 2 | 1 | ||
| Overall_Condition | String | Coded Value | Default Value | Default Value | 5 | 21 | ||
| Pipe_Device_Status_Combined | String | Coded Value | Duplicate | Default Value | 4 | 12 | ||
| Pipeline_Valve_Close_Direction | String | Coded Value | Duplicate | Default Value | 2 | 1 | ||
| Sewer_Asset_Manager | String | Coded Value | Duplicate | Default Value | 3 | 17 | ||
| Sewer_Asset_Owner | String | Coded Value | Duplicate | Default Value | 3 | 17 | ||
| Sewer_Cleanout_Material | String | Coded Value | Duplicate | Default Value | 10 | 1 | ||
| Sewer_Controllable_Valve_Diameter | Double | Coded Value | Duplicate | Default Value | 29 | 1 | ||
| Sewer_Controllable_Valve_Type | String | Coded Value | Duplicate | Default Value | 5 | 1 | ||
| Sewer_Lateral_Diameter | Double | Coded Value | Duplicate | Default Value | 19 | 1 | ||
| Sewer_Lateral_Material | String | Coded Value | Duplicate | Default Value | 10 | 1 | ||
| Sewer_Main_Diameter | Double | Coded Value | Duplicate | Default Value | 29 | 2 | ||
| Sewer_Main_Liner | String | Coded Value | Duplicate | Default Value | 13 | 2 | ||
| Sewer_Main_Material | String | Coded Value | Duplicate | Default Value | 26 | 2 | ||
| Sewer_Main_Shape | String | Coded Value | Duplicate | Default Value | 6 | 2 | ||
| Sewer_Pump_Discharge_Diameter | Double | Coded Value | Duplicate | Default Value | 13 | 1 | ||
| Sewer_Pump_Inlet_Diameter | Double | Coded Value | Duplicate | Default Value | 13 | 1 | ||
| Sewer_Pump_Type | String | Coded Value | Duplicate | Default Value | 7 | 1 | ||
| Sewer_Relief_Valve_Diameter | Double | Coded Value | Duplicate | Default Value | 29 | 1 | ||
| Spatial_Confidence | String | Coded Value | Duplicate | Default Value | 3 | 21 | ||
| Spatial_Source | String | Coded Value | Duplicate | Default Value | 5 | 21 | ||
| Structure_Sewer_Storm_Access_Point_Cover_Shape | String | Coded Value | Duplicate | Default Value | 9 | 2 | ||
| Structure_Sewer_Storm_Casing_Diameter | Double | Coded Value | Duplicate | Default Value | 6 | 1 | ||
| Structure_Sewer_Storm_Manhole_Frame_Material | String | Coded Value | Duplicate | Default Value | 11 | 2 | ||
| Structure_Sewer_Storm_Manhole_Step_Material | String | Coded Value | Duplicate | Default Value | 3 | 2 | ||
| Structure_Sewer_Storm_Manhole_Surface | String | Coded Value | Duplicate | Default Value | 7 | 2 | ||
| Structure_Sewer_Storm_Manhole_Wall_Material | String | Coded Value | Duplicate | Default Value | 6 | 2 | ||
| Structure_Sewer_Storm_Vault_Manhole_Cone | String | Coded Value | Duplicate | Default Value | 2 | 2 | ||
| Structure_Sewer_Storm_Vault_Manhole_Location | String | Coded Value | Duplicate | Default Value | 13 | 2 | ||
| Yes_No | String | Coded Value | Duplicate | Default Value | 2 | 11 |
| Key | Value |
|---|---|
| Name | Backflow_Preventer |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Backflow_Preventer |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -20037507.84278825 |
| X-Max | 20037507.84278825 |
| Y-Min | -30240971.45838615 |
| Y-Max | 30240971.45838615 |
| Catalog ID | {770CB3A5-D9C6-4BBC-91D5-9661FC4E04FB} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Device_Backflow_Preventer | Backflow Preventer | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| manufacturer | Manufacturer | String | True | 0 | 0 | 100 | True | False | Manufacturer of the sewer asset | |||
| presentstatus | Present Status | String | True | Pipe_Device_Status_Combined | Active | 0 | 0 | 50 | True | False | Current operational status of the sewer asset | |
| normalstatus | Normal Status | String | True | Pipe_Device_Status_Combined | Active | 0 | 0 | 50 | True | False | Normal operational status of the asset | |
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E632D9703594 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_BACKFLOW_PREVENTER3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I82assetid | False | True | assetid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_BACKFLOW_PREVENTER3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | BackflowPreventerRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | BackflowPreventerRelate |
| 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 | {B5B6ECAA-4249-45C6-B128-3B69F18071D4} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D850DB5E903 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G84assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Casing |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Polyline |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Casing |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -20037507.84278825 |
| X-Max | 20037507.84278825 |
| Y-Min | -30240971.45838615 |
| Y-Max | 30240971.45838615 |
| Catalog ID | {2A7D9D87-998B-4B51-A175-39C271F14B8A} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Structure_Line_Sewer_Storm_Casing | Casing | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| diameter | Diameter | Double | False | Structure_Sewer_Storm_Casing_Diameter | 0 | 0 | 0 | True | False | Diameter of the asset | ||
| measuredlength | Measured Length | Double | True | 0 | 0 | 0 | True | False | Measured length of the casing | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape__Length | Shape__Length | Double | Index;Length | True | 0 | 0 | 0 | False | True | Length of the asset | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E6320FBAD288 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_CASING3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I148assetid | False | True | assetid |
| Shape__Length_Index | False | True | Shape__Length |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_CASING3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | CasingRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | CasingRelate |
| 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 | {4A0CE62E-C00C-42E6-9FA4-55C0F16A87B1} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D85753CB975 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G149assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Cleanout |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Cleanout |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -9816549.8308 |
| X-Max | -9809446.5661 |
| Y-Min | 5125680.556699999 |
| Y-Max | 5130575.3314 |
| Catalog ID | {DFD9377C-26CC-49AD-84D9-D8727974ECDE} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Device_Cleanout | Unknown | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| material | Cleanout Material | String | True | Sewer_Cleanout_Material | 0 | 0 | 100 | True | False | Material of the asset | ||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E6321F899CD4 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_CLEANOUT3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I64assetid | False | True | assetid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_CLEANOUT3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | CleanoutRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | CleanoutRelate |
| 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 | {A830FA70-4814-46F4-B679-2FF50D238D88} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D853F6A4444 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G66assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Controllable_Valve |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Controllable_Valve |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -9815358.5765 |
| X-Max | -9815348.3004 |
| Y-Min | 5128376.364299998 |
| Y-Max | 5128380.740400001 |
| Catalog ID | {2AC9DC20-3604-4C8F-B9D5-53C885EA23E5} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Device_Controllable_Valve | Controllable Valve | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| diameter | Diameter | Double | True | Sewer_Controllable_Valve_Diameter | 0 | 0 | 0 | True | False | Diameter of the asset | ||
| valvetype | Valve Type | String | True | Sewer_Controllable_Valve_Type | 0 | 0 | 50 | True | False | Type of the controllable valve | ||
| presentstatus | Present Status | String | True | Pipe_Device_Status_Combined | Open | 0 | 0 | 50 | True | False | Current operational status of the sewer asset | |
| normalstatus | Normal Status | String | True | Pipe_Device_Status_Combined | Open | 0 | 0 | 50 | True | False | Normal operational status of the asset | |
| closedirection | Clockwise to Close | String | True | Pipeline_Valve_Close_Direction | Counter Clockwise | 0 | 0 | 50 | True | False | Direction to close the valve | |
| operable | Operable | String | True | Yes_No | 0 | 0 | 15 | True | False | Indicates if the asset is operable | ||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| hasbypass | Has Bypass Valve | String | True | Yes_No | 0 | 0 | 15 | True | False | Indicates if the valve has a bypass | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E63278603919 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_CONTROLLABLE_VALVE3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I98assetid | False | True | assetid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_CONTROLLABLE_VALVE3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | ControllableValveRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | ControllableValveRelate |
| 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 | {1664F03A-5B1E-4528-99BF-9DA0106AF4A6} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D85A451F807 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G99assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Discharge |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Discharge |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -9815831.2608 |
| X-Max | -9815831.2608 |
| Y-Min | 5125752.036700003 |
| Y-Max | 5125752.036700003 |
| Catalog ID | {C7E1B0BD-AAC8-4173-BD3C-93F6EC7C0F86} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Device_Discharge | Unknown | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| presentstatus | Present Status | String | True | Pipe_Device_Status_Combined | Active | 0 | 0 | 50 | True | False | Current operational status of the sewer asset | |
| normalstatus | Normal Status | String | True | Pipe_Device_Status_Combined | Active | 0 | 0 | 50 | True | False | Normal operational status of the asset | |
| name | Name | String | True | 0 | 0 | 64 | True | False | Name of the asset | |||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E632953B5643 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_DISCHARGE3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I22assetid | False | True | assetid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_DISCHARGE3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | DischargeRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | DischargeRelate |
| 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 | {FFA9C409-59F8-47FD-9085-6AB314A01C8E} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D853AC0ED8E | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G23assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Fitting |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Fitting |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -9816611.8271 |
| X-Max | -9809396.5066 |
| Y-Min | 5125600.5009 |
| Y-Max | 5130627.195299998 |
| Catalog ID | {42567F44-761F-46E8-90B9-AF5774934F0F} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Junction_Fitting | Unknown | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E63240DF1FFA | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_FITTING3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I117assetid | False | True | assetid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_FITTING3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | FittingRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | FittingRelate |
| 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 | {43D0627E-CDC6-497D-B412-34F94BEA6BE5} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D85D53C0570 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G118assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Grease_Trap |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Grease_Trap |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -20037507.84278825 |
| X-Max | 20037507.84278825 |
| Y-Min | -30240971.45838615 |
| Y-Max | 30240971.45838615 |
| Catalog ID | {3A347502-D272-4411-9D74-FFA9039A9CA3} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Device_Grease_Trap | Unknown | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| presentstatus | Present Status | String | True | Pipe_Device_Status_Combined | Active | 0 | 0 | 50 | True | False | Current operational status of the sewer asset | |
| normalstatus | Normal Status | String | True | Pipe_Device_Status_Combined | Active | 0 | 0 | 50 | True | False | Normal operational status of the asset | |
| inspectiondate | Inspection Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| location | Location | String | True | Location | 0 | 0 | 50 | True | False | If the location of the grease trap is inside or outside | ||
| name | Name | String | Index;Index | True | 0 | 0 | 64 | True | False | Name of the asset | ||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E6321C69E971 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_GREASE_TRAP3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I89assetid | False | True | assetid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| IX_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_GREASE_TRAP3_name_ASC | False | True | name |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_GREASE_TRAP3_name | False | True | name |
| Key | Value |
|---|---|
| Name | GreaseTrapRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | GreaseTrapRelate |
| 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 | {F0B45CDE-49C2-4285-ABEE-41810D356670} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D8510DB469B | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G90assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Lateral |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Polyline |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Lateral |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -9816560.3192 |
| X-Max | -9809415.9421 |
| Y-Min | 5125680.368799999 |
| Y-Max | 5130586.214599997 |
| Catalog ID | {ED0C8A40-FED2-4FCA-80A5-761944233ED4} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Line_Lateral_Service | Unknown | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| diameter | Diameter | Double | True | Sewer_Lateral_Diameter | 0 | 0 | 0 | True | False | Diameter of the asset | ||
| material | Material | String | True | Sewer_Lateral_Material | 0 | 0 | 100 | True | False | Material of the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| measuredlength | Measured Length | Double | True | 0 | 0 | 0 | True | False | Measured length of the pipe | |||
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape__Length | Shape__Length | Double | Index;Length | True | 0 | 0 | 0 | False | True | Length of the asset | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E632194E7B84 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_LATERAL3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I135assetid | False | True | assetid |
| Shape__Length_Index | False | True | Shape__Length |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_LATERAL3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | LateralRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | LateralRelate |
| 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 | {32565E4A-BA30-48D6-A18C-0DD61380F185} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D85338A5B4F | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G136assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Manhole |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Manhole |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -9816680.589 |
| X-Max | -9809387.2073 |
| Y-Min | 5125601.420999996 |
| Y-Max | 5130656.508900002 |
| Catalog ID | {D9B8290D-D90D-4031-B6AD-73D3C90930E5} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OBJECTID | OBJECTID | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Structure_Junction_Sewer_Storm_Manhole | Manhole | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| rimelev | Rim Elevation | Double | True | 0 | 0 | 0 | True | False | Elevation of the rim of the manhole | |||
| invertelev | Invert Elevation | Double | True | 0 | 0 | 0 | True | False | Elevation of the invert of the manhole | |||
| depth | Depth | Double | True | 0 | 0 | 0 | True | False | Depth of the asset | |||
| highpipeelev | High Pipe Elevation | Double | True | 0 | 0 | 0 | True | False | Elevation of the highest pipe in the manhole | |||
| conetype | Cone Type | String | True | Structure_Sewer_Storm_Vault_Manhole_Cone | Straight | 0 | 0 | 50 | True | False | Type of cone used in the manhole | |
| location | Manhole Location | String | True | Structure_Sewer_Storm_Vault_Manhole_Location | 0 | 0 | 100 | True | False | Location of the manhole | ||
| surface | Manhole Surface Type | String | True | Structure_Sewer_Storm_Manhole_Surface | 0 | 0 | 100 | True | False | Type of surface where the manhole is located | ||
| covershape | Cover Shape | String | True | Structure_Sewer_Storm_Access_Point_Cover_Shape | Circular | 0 | 0 | 100 | True | False | Shape of the manhole cover | |
| channel | Channel | String | True | Yes_No | 0 | 0 | 15 | True | False | Indicates if the manhole has a channel | ||
| bench | Bench | String | True | Yes_No | 0 | 0 | 15 | True | False | Indicates if the manhole has a bench | ||
| framematerial | Frame Material | String | True | Structure_Sewer_Storm_Manhole_Frame_Material | 0 | 0 | 100 | True | False | Material of the manhole frame | ||
| wallmaterial | Wall Material | String | True | Structure_Sewer_Storm_Manhole_Wall_Material | 0 | 0 | 100 | True | False | Material of the manhole wall | ||
| numsteps | Number of Steps | Short Integer | True | 0 | 0 | 0 | True | False | Number of steps in the manhole | |||
| stepmaterial | Step Material | String | True | Structure_Sewer_Storm_Manhole_Step_Material | 0 | 0 | 100 | True | False | Material of the steps in the manhole | ||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D85FD081DBB | True | True | OBJECTID |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_MANHOLE3_Shape_sidx | False | True | Shape |
| FDO_GlobalID | True | True | GlobalID |
| I48assetid | False | True | assetid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_MANHOLE3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | ManholeRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | ManholeRelate |
| 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 | {F1BB1D80-C654-45DA-A0F6-F979BA9301BC} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D856975CC3C | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G50assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Meter |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Meter |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -20037507.84278825 |
| X-Max | 20037507.84278825 |
| Y-Min | -30240971.45838615 |
| Y-Max | 30240971.45838615 |
| Catalog ID | {908DE2B2-0762-4241-BCAA-6701CF14177E} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Device_Meter | Unknown | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| presentstatus | Present Status | String | True | Pipe_Device_Status_Combined | Active | 0 | 0 | 50 | True | False | Current operational status of the sewer asset | |
| normalstatus | Normal Status | String | True | Pipe_Device_Status_Combined | Active | 0 | 0 | 50 | True | False | Normal operational status of the asset | |
| operable | Operable | String | True | Yes_No | 0 | 0 | 15 | True | False | Indicates if the asset is operable | ||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E63243450F9A | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_METER3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I111assetid | False | True | assetid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_METER3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | MeterRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | MeterRelate |
| 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 | {A06425F6-008D-469A-8161-4607AAE888BE} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D853D22D266 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G112assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Pump |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Pump |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -9815363.5674 |
| X-Max | -9815352.897 |
| Y-Min | 5128388.854800001 |
| Y-Max | 5128392.8037 |
| Catalog ID | {4D178F1B-614C-4A80-AB5F-7612DFC36BCA} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Device_Pump | Unknown | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| pumptype | Pump Type | String | True | Sewer_Pump_Type | 0 | 0 | 100 | True | False | Type of pump | ||
| inletdiameter | Inlet Diameter | Double | True | Sewer_Pump_Inlet_Diameter | 0 | 0 | 0 | True | False | Diameter of the inlet pipe of the pump | ||
| dischargediameter | Discharge Diameter | Double | True | Sewer_Pump_Discharge_Diameter | 0 | 0 | 0 | True | False | Diameter of the pipe discharging from the pump | ||
| presentstatus | Present Status | String | True | Pipe_Device_Status_Combined | Open | 0 | 0 | 50 | True | False | Current operational status of the asset | |
| normalstatus | Normal Status | String | True | Pipe_Device_Status_Combined | Open | 0 | 0 | 50 | True | False | Normal operational status of the asset | |
| ratedflow | Rated Flow | Double | True | 0 | 0 | 0 | True | False | Rated flow capacity of the pump | |||
| pressure | Rated Pressure | Double | True | 0 | 0 | 0 | True | False | Rated pressure of the pump | |||
| operable | Operable | String | True | Yes_No | 0 | 0 | 15 | True | False | Indicates if the asset is operable | ||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E63256583D25 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_PUMP3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I57assetid | False | True | assetid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_PUMP3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | PumpRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | PumpRelate |
| 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 | {0AB22B0F-5C30-41CD-8931-1DE5E0690F06} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D85B3A21066 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G58assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Relief_Valve |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Relief_Valve |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -20037507.84278825 |
| X-Max | 20037507.84278825 |
| Y-Min | -30240971.45838615 |
| Y-Max | 30240971.45838615 |
| Catalog ID | {DDA8422F-41DA-46C6-9D8C-1738736DCEF4} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Device_Relief_Valve | Unknown | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| diameter | Diameter | Double | True | Sewer_Relief_Valve_Diameter | 0 | 0 | 0 | True | False | Diameter of the asset | ||
| operable | Operable | String | True | Yes_No | 0 | 0 | 15 | True | False | Indicates if the asset is operable | ||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E63291745C53 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_RELIEF_VALVE3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I105assetid | False | True | assetid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_RELIEF_VALVE3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | ReliefValveRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | ReliefValveRelate |
| 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 | {66CB0C58-621A-4C24-9D92-61ADF02CBDFA} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D85F4C55CD8 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G106assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Service_Connection |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Service_Connection |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -9816560.3192 |
| X-Max | -9809415.9421 |
| Y-Min | 5125680.769100003 |
| Y-Max | 5130586.214599997 |
| Catalog ID | {4983B3BA-7838-41C4-A50E-B37B96655CFD} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Device_Service_Connection | Unknown | 0 | 0 | 100 | True | False | Type of asset | |
| accountid | Account ID | String | Index;Index | True | 0 | 0 | 50 | True | False | Unique identifier for the account associated with the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| assetid | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | |||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E632A2264DAE | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SERVICE_CONNECTION3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I34accountid | False | True | accountid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SERVICE_CONNECTION3_accountid | False | True | accountid |
| Key | Value |
|---|---|
| Name | Service_Territory |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Polygon |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -20037507.84278825 |
| X-Max | 20037507.84278825 |
| Y-Min | -30240971.45838615 |
| Y-Max | 30240971.45838615 |
| Catalog ID | {876CAC97-8F04-47D8-AAA0-062ADF86D8D2} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| name | Name | String | Index;Index | True | 0 | 0 | 255 | True | False | Name of the service territory | ||
| globalid | GLOBALID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape__Area | Shape__Area | Double | Area;Index | True | 0 | 0 | 0 | False | True | Area of the asset | ||
| Shape__Length | Shape__Length | Double | Index;Length | True | 0 | 0 | 0 | False | True | Length of the asset | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E63236BF1B5B | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SERVICE_TERRITORY3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| Shape__Area_Index | False | True | Shape__Area |
| Shape__Length_Index | False | True | Shape__Length |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| IX_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SERVICE_TERRITORY3_name_ASC | False | True | name |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SERVICE_TERRITORY3_name | False | True | name |
| Key | Value |
|---|---|
| Name | ServiceConnectionRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | ServiceConnectionRelate |
| 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 | {4C15E7F6-3D39-4B5C-843A-3B07B4C2241C} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D85FF780279 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G35assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Sewer_Force_Main |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Polyline |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Sewer_Force_Main |
| OID Field | objectid |
| GlobalID Field | globalid |
| Editor Tracking Enabled | True |
| Editor Tracking UTC | True |
| Creator Field | created_user |
| Create Date Field | created_date |
| Editor Field | last_edited_user |
| Edit Date Field | last_edited_date |
| Shape Field | Shape |
| Spatial Reference | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -9815541.877 |
| X-Max | -9814752.4437 |
| Y-Min | 5126107.965999998 |
| Y-Max | 5128422.674800001 |
| Catalog ID | {7186A64A-BC33-4523-8ABC-9438AD8801A0} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Line_Sewer_Force_Main | Force Main | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| diameter | Diameter | Double | True | Sewer_Main_Diameter | 0 | 0 | 0 | True | False | Diameter of the asset | ||
| material | Material | String | True | Sewer_Main_Material | 0 | 0 | 100 | True | False | Material of the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| downelev | Downstream Elevation | Double | True | 0 | 0 | 0 | True | False | Elevation at the downstream end of the sewer main | |||
| upelev | Upstream Elevation | Double | True | 0 | 0 | 0 | True | False | Elevation at the upstream end of the sewer force main | |||
| slope | Slope | Double | True | 0 | 0 | 0 | True | False | Slope of the sewer force main | |||
| designtype | Main Shape | String | True | Sewer_Main_Shape | 0 | 0 | 100 | True | False | Shape of the sewer main | ||
| linertype | Liner Type | String | True | Sewer_Main_Liner | 0 | 0 | 100 | True | False | Type of liner used in the sewer main | ||
| tracerwire | Tracer Wire | String | True | Yes_No | 0 | 0 | 15 | True | False | Indicates if a tracer wire is present with the main | ||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| measuredlength | Measured Length | Double | True | 0 | 0 | 0 | True | False | Measured length of the pipe | |||
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape__Length | Shape__Length | Double | Index;Length | True | 0 | 0 | 0 | False | True | Length of the asset | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E632B6E34415 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SEWER_FORCE_MAIN3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I141assetid | False | True | assetid |
| Shape__Length_Index | False | True | Shape__Length |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SEWER_FORCE_MAIN3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | Sewer_Gravity_Main |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Polyline |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Sewer_Gravity_Main |
| OID Field | objectid |
| GlobalID Field | globalid |
| Editor Tracking Enabled | True |
| Editor Tracking UTC | True |
| Creator Field | created_user |
| Create Date Field | created_date |
| Editor Field | last_edited_user |
| Edit Date Field | last_edited_date |
| Shape Field | Shape |
| Spatial Reference | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -9816680.589 |
| X-Max | -9809387.2073 |
| Y-Min | 5125600.5009 |
| Y-Max | 5130656.508900002 |
| Catalog ID | {C341CC0B-6A32-4593-AB9E-C7386AD9BB8C} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Line_Sewer_Gravity_Main | Unknown | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| diameter | Diameter | Double | True | Sewer_Main_Diameter | 0 | 0 | 0 | True | False | Diameter of the asset | ||
| material | Material | String | True | Sewer_Main_Material | 0 | 0 | 100 | True | False | Material of the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| downelev | Downstream Elevation | Double | True | 0 | 0 | 0 | True | False | Elevation at the downstream end of the sewer main | |||
| upelev | Upstream Elevation | Double | True | 0 | 0 | 0 | True | False | Elevation at the upstream end of the sewer main | |||
| slope | Slope | Double | True | 0 | 0 | 0 | True | False | Slope of the sewer main | |||
| mainshape | Main Shape | String | True | Sewer_Main_Shape | 0 | 0 | 50 | True | False | Shape of the sewer main | ||
| linertype | Liner Type | String | True | Sewer_Main_Liner | 0 | 0 | 50 | True | False | Type of liner used in the sewer main | ||
| tracerwire | Tracer Wire | String | True | Yes_No | 0 | 0 | 15 | True | False | Indicates if a tracer wire is present with the main | ||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| measuredlength | Measured Length | Double | True | 0 | 0 | 0 | True | False | Measured length of the pipe | |||
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape__Length | Shape__Length | Double | Index;Length | True | 0 | 0 | 0 | False | True | Length of the asset | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E6325A115D2D | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SEWER_GRAVITY_MAIN3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I127assetid | False | True | assetid |
| Shape__Length_Index | False | True | Shape__Length |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SEWER_GRAVITY_MAIN3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | Sewer_Lift_Station |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Sewer_Lift_Station |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -20037507.84278825 |
| X-Max | 20037507.84278825 |
| Y-Min | -30240971.45838615 |
| Y-Max | 30240971.45838615 |
| Catalog ID | {DD7696F2-124A-4514-A4CB-2F0798D18B59} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Structure_Junction_Sewer_Lift_Station | Lift Station | 0 | 0 | 50 | True | False | Type of asset | |
| assetid | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | |||
| name | Name | String | Index;Index | True | 0 | 0 | 255 | True | False | Name of the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E6323CCFF265 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SEWER_LIFT_STATION3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| IX_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SEWER_LIFT_STATION3_name_ASC | False | True | name |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SEWER_LIFT_STATION3_name | False | True | name |
| Key | Value |
|---|---|
| Name | Sewer_Lift_Station_Boundary |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Polygon |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Sewer_Lift_Station_Boundary |
| OID Field | objectid |
| GlobalID Field | globalid |
| Editor Tracking Enabled | True |
| Editor Tracking UTC | True |
| Creator Field | created_user |
| Create Date Field | created_date |
| Editor Field | last_edited_user |
| Edit Date Field | last_edited_date |
| Shape Field | Shape |
| Spatial Reference | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -9815373.6259 |
| X-Max | -9815340.4614 |
| Y-Min | 5128366.665200002 |
| Y-Max | 5128410.762100004 |
| Catalog ID | {4C4B50AC-1FE4-4977-8F5E-7A1AD75218F9} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Structure_Boundary_Sewer_Lift_Station_Boundary | Lift Station | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| name | Name | String | Index;Index | True | 0 | 0 | 64 | True | False | Name of the asset | ||
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape__Area | Shape__Area | Double | Area;Index | True | 0 | 0 | 0 | False | True | Area of the asset | ||
| Shape__Length | Shape__Length | Double | Index;Length | True | 0 | 0 | 0 | False | True | Length of the asset | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E632A2A4A3DE | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SEWER_LIFT_STATION_BOUNDARY3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I160assetid | False | True | assetid |
| Shape__Area_Index | False | True | Shape__Area |
| Shape__Length_Index | False | True | Shape__Length |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| IX_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SEWER_LIFT_STATION_BOUNDARY3_name_ASC | False | True | name |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_SEWER_LIFT_STATION_BOUNDARY3_name | False | True | name |
| Key | Value |
|---|---|
| Name | SewerForceMainRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | SewerForceMainRelate |
| 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 | {DC85F45E-7244-46AB-B626-8470B9C53E33} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D854A8A1E16 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G142assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | SewerGravityMainRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | SewerGravityMainRelate |
| 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 | {83E33DAE-F1C6-473E-8865-D86CC8BC3629} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D85186BBDD8 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G129assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | SewerLiftStationBoundaryRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | SewerLiftStationBoundaryRelate |
| 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 | {EA9D54F0-53F8-4A47-84AD-755BC8AA1399} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D85610C8BF4 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G162assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | SewerLiftStationRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | SewerLiftStationRelate |
| 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 | {2FEC965C-9836-46AA-893D-C2800A1D7231} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D8574A22692 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G72assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Treatment_Plant |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Treatment_Plant |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -9815686.0441 |
| X-Max | -9815686.0441 |
| Y-Min | 5125845.0295 |
| Y-Max | 5125845.0295 |
| Catalog ID | {A85BD240-E688-4B25-9507-E82C71F5B152} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Sewer_Device_Treatment | Treatment Plant | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| name | Name | String | Index;Index | True | 0 | 0 | 64 | True | False | Name of the asset | ||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E6322B8710D3 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_TREATMENT_PLANT3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I15assetid | False | True | assetid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| IX_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_TREATMENT_PLANT3_name_ASC | False | True | name |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_TREATMENT_PLANT3_name | False | True | name |
| Key | Value |
|---|---|
| Name | Treatment_Plant_Boundary |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Polygon |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Treatment_Plant_Boundary |
| OID Field | objectid |
| GlobalID Field | globalid |
| Editor Tracking Enabled | True |
| Editor Tracking UTC | True |
| Creator Field | created_user |
| Create Date Field | created_date |
| Editor Field | last_edited_user |
| Edit Date Field | last_edited_date |
| Shape Field | Shape |
| Spatial Reference | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -20037507.84278825 |
| X-Max | 20037507.84278825 |
| Y-Min | -30240971.45838615 |
| Y-Max | 30240971.45838615 |
| Catalog ID | {86F25A98-A1DC-40E8-8F1D-D98EDB7F69C3} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Structure_Boundary_Sewer_Treatment_Plant_Boundary | Treatment Plant | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| name | Name | String | Index;Index | True | 0 | 0 | 64 | True | False | Name of the asset | ||
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape__Area | Shape__Area | Double | Area;Index | True | 0 | 0 | 0 | False | True | Area of the asset | ||
| Shape__Length | Shape__Length | Double | Index;Length | True | 0 | 0 | 0 | False | True | Length of the asset | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E632D2E64409 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_TREATMENT_PLANT_BOUNDARY2_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I28assetid | False | True | assetid |
| Shape__Area_Index | False | True | Shape__Area |
| Shape__Length_Index | False | True | Shape__Length |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| IX_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_TREATMENT_PLANT_BOUNDARY2_name_ASC | False | True | name |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_TREATMENT_PLANT_BOUNDARY2_name | False | True | name |
| Key | Value |
|---|---|
| Name | TreatmentPlantRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | TreatmentPlantRelate |
| 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 | {E6A1F783-270D-4FDD-A483-1BF593ED6B5F} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D8569B2D91D | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G30assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | TreatmentRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | TreatmentRelate |
| 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 | {366F17C8-47FA-41E6-8240-DCC8C8131228} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D85225E9452 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G17assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | Vault |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Point |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Vault |
| 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 | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -20037507.84278825 |
| X-Max | 20037507.84278825 |
| Y-Min | -30240971.45838615 |
| Y-Max | 30240971.45838615 |
| Catalog ID | {263B5DA6-42BB-417D-B61B-F849C2F50721} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Structure_Junction_Sewer_Storm_Vault | Unknown | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index;Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| rimelev | Rim Elevation | Double | True | 0 | 0 | 0 | True | False | Elevation of the rim of the vault | |||
| invertelev | Invert Elevation | Double | True | 0 | 0 | 0 | True | False | Elevation of the invert of the vault | |||
| depth | Depth | Double | True | 0 | 0 | 0 | True | False | Depth of the asset | |||
| highpipeelev | High Pipe Elevation | Double | True | 0 | 0 | 0 | True | False | Elevation of the highest pipe in the vault | |||
| conetype | Cone Type | String | True | Structure_Sewer_Storm_Vault_Manhole_Cone | Straight | 0 | 0 | 50 | True | False | Type of cone used in the vault | |
| location | Manhole Location | String | True | Structure_Sewer_Storm_Vault_Manhole_Location | 0 | 0 | 100 | True | False | Location of the vault | ||
| surface | Manhole Surface Type | String | True | Structure_Sewer_Storm_Manhole_Surface | 0 | 0 | 100 | True | False | Type of surface where the vault is located | ||
| covershape | Cover Shape | String | True | Structure_Sewer_Storm_Access_Point_Cover_Shape | Circular | 0 | 0 | 100 | True | False | Shape of the vault cover | |
| channel | Channel | String | True | Yes_No | 0 | 0 | 15 | True | False | Indicates if thevault has a channel | ||
| bench | Bench | String | True | Yes_No | 0 | 0 | 15 | True | False | Indicates if the vault has a bench | ||
| framematerial | Frame Material | String | True | Structure_Sewer_Storm_Manhole_Frame_Material | 0 | 0 | 100 | True | False | Material of the vault frame | ||
| wallmaterial | Wall Material | String | True | Structure_Sewer_Storm_Manhole_Wall_Material | 0 | 0 | 100 | True | False | Material of the vault wall | ||
| numsteps | Number of Steps | Short Integer | True | 0 | 0 | 0 | True | False | Number of steps in the vault | |||
| stepmaterial | Step Material | String | True | Structure_Sewer_Storm_Manhole_Step_Material | 0 | 0 | 100 | True | False | Material of the steps in the vault | ||
| ownedby | Owned By | String | True | Sewer_Asset_Owner | Our Agency | 0 | 0 | 50 | True | False | Entity that owns the asset | |
| maintby | Maintained By | String | True | Sewer_Asset_Manager | Our Agency | 0 | 0 | 50 | True | False | Entity that maintains the asset | |
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| ESRIGNSS_POSITIONSOURCETYPE | Position source type | Short Integer | True | ESRI_POSITIONSOURCETYPE_DOMAIN | 0 | 0 | 0 | True | False | Source used to collect the point or vertex | ||
| ESRIGNSS_RECEIVER | Receiver Name | String | True | 0 | 0 | 50 | True | False | Name of the receiver used to capture the location | |||
| ESRIGNSS_LATITUDE | Latitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's north-south position on Earth | |||
| ESRIGNSS_LONGITUDE | Longitude | Double | True | 0 | 0 | 0 | True | False | A geographic coordinate that specifies a location's east-west position on Earth | |||
| ESRIGNSS_ALTITUDE | Altitude | Double | True | 0 | 0 | 0 | True | False | Ellipsoidal height received from the GPS receiver | |||
| ESRIGNSS_H_RMS | Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_V_RMS | Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_FIXDATETIME | Fix Time | Date | True | 1 | 0 | 8 | True | False | Date and time the GPS receiver became fixed | |||
| ESRIGNSS_FIXTYPE | Fix Type | Short Integer | True | ESRI_FIX_TYPE_DOMAIN | 0 | 0 | 0 | True | False | Type of fix being used to determine its location | ||
| ESRIGNSS_CORRECTIONAGE | Correction Age | Double | True | 0 | 0 | 0 | True | False | Time elapsed between when a correction message is generated and when it's received by the GPS receiver | |||
| ESRIGNSS_STATIONID | Station ID | Short Integer | True | ESRI_STATION_ID_DOMAIN | 0 | 0 | 0 | True | False | A unique identifier, often a 4-character code, used to identify a specific GPS or GNSS ground station | ||
| ESRIGNSS_NUMSATS | Number of Satellites | Short Integer | True | ESRI_NUM_SATS_DOMAIN | 0 | 0 | 0 | True | False | Number of satellites being used to receive a signal | ||
| ESRIGNSS_PDOP | PDOP | Double | True | 0 | 0 | 0 | True | False | A measure of how the geometry of the visible satellites impacts the accuracy of your position fix | |||
| ESRIGNSS_HDOP | HDOP | Double | True | 0 | 0 | 0 | True | False | A metric that reflects the impact of satellite geometry on the horizontal positional accuracy of a GPS receiver, with lower values indicating better accuracy. | |||
| ESRIGNSS_VDOP | VDOP | Double | True | 0 | 0 | 0 | True | False | Measures how the geometric distribution of satellites impacts the accuracy of vertical positioning (altitude or elevation), with a lower VDOP value indicating better vertical precision | |||
| ESRIGNSS_DIRECTION | Direction of travel (°) | Double | True | 0 | 0 | 0 | True | False | Compass direction GPS is pointed expressed in degrees | |||
| ESRIGNSS_SPEED | Speed (km/h) | Double | True | 0 | 0 | 0 | True | False | Speed at which the GPS device is moving | |||
| ESRISNSR_AZIMUTH | Compass reading (°) | Double | True | 0 | 0 | 0 | True | False | The direction measured as a clockwise angle in degrees from true north (0°) to a specific point or object, with east being 90°, south 180°, and west 270° | |||
| ESRIGNSS_AVG_H_RMS | Average Horizontal Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within a circle of a given radius | |||
| ESRIGNSS_AVG_V_RMS | Average Vertical Accuracy (m) | Double | True | 0 | 0 | 0 | True | False | Probability that the location signal is within an elevation range | |||
| ESRIGNSS_AVG_POSITIONS | Averaged Positions | Short Integer | True | 0 | 0 | 0 | True | False | Average location of multiple positions to improve accuracy | |||
| ESRIGNSS_H_STDDEV | Standard Deviation (m) | Double | True | 0 | 0 | 0 | True | False | An indication of the variation in distance between your final, averaged location and each individual location recorded during averaging. A high value indicates that your position was influenced by outliers. | |||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E6321285722E | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_VAULT3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I76assetid | False | True | assetid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_VAULT3_assetid | False | True | assetid |
| Key | Value |
|---|---|
| Name | Vault_Boundary |
| Dataset Type | FeatureClass |
| Dataset ID | -1 |
| Geometry Type | Polygon |
| Feature Type | Simple |
| Z-Aware | True |
| M-Aware | True |
| Split Model | Update Insert |
| Minimum Client Version | 10.0 |
| Alias | Vault_Boundary |
| OID Field | objectid |
| GlobalID Field | globalid |
| Editor Tracking Enabled | True |
| Editor Tracking UTC | True |
| Creator Field | created_user |
| Create Date Field | created_date |
| Editor Field | last_edited_user |
| Edit Date Field | last_edited_date |
| Shape Field | Shape |
| Spatial Reference | WGS_1984_Web_Mercator_Auxiliary_Sphere |
| X-Min | -20037507.84278825 |
| X-Max | 20037507.84278825 |
| Y-Min | -30240971.45838615 |
| Y-Max | 30240971.45838615 |
| Catalog ID | {19BAB864-C9A5-416D-BB95-4BE0F5C5ADE1} |
| Class ID | {52353152-891A-11D0-BEC6-00805F7C4268} |
| Name | Alias | Type | Usage | Nullable | Domain | Default Value | Precision | Scale | Length | Editable | Required | Details |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectid | objectid | OID | Index | False | 0 | 0 | 0 | False | True | Unique identifier for each record | ||
| assettype | Asset type | String | False | Asset_Type_Structure_Boundary_Sewer_Storm_Vault_Boundary | Unknown | 0 | 0 | 100 | True | False | Type of asset | |
| assetid | Asset ID | String | Index | True | 0 | 0 | 64 | True | False | A unique identifier for the asset | ||
| lifecyclestatus | Lifecycle Status | String | False | LifecycleStatus | In Service | 0 | 0 | 100 | True | False | The current phase or state of an asset within its lifecycle | |
| installdate | Install Date | Date | True | 1 | 0 | 8 | True | False | Date when the asset was installed | |||
| name | Name | String | Index;Index | True | 0 | 0 | 64 | True | False | Name of the asset | ||
| spatialsource | Spatial Source | String | True | Spatial_Source | 0 | 0 | 100 | True | False | Source of the spatial data for the asset | ||
| spatialconfidence | Spatial Confidence | String | True | Spatial_Confidence | 0 | 0 | 100 | True | False | Confidence level in the location accuracy of the asset | ||
| notes | Notes | String | True | 0 | 0 | 2000 | True | False | Notes pertaining to the asset | |||
| globalid | Global ID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited | ||
| Shape__Area | Shape__Area | Double | Area;Index | True | 0 | 0 | 0 | False | True | Area of the asset | ||
| Shape__Length | Shape__Length | Double | Index;Length | True | 0 | 0 | 0 | False | True | Length of the asset | ||
| Shape | Geometry | Index | True | 0 | 0 | 0 | True | True | Geometric representation of the asset. Either point, line, or polygon |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__5242E63267151DD0 | True | True | objectid |
| user_7607.SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_VAULT_BOUNDARY3_Shape_sidx | False | True | Shape |
| FDO_globalid | True | True | globalid |
| I154assetid | False | True | assetid |
| Shape__Area_Index | False | True | Shape__Area |
| Shape__Length_Index | False | True | Shape__Length |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| IX_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_VAULT_BOUNDARY3_name_ASC | False | True | name |
| FT_SEWER_SYSTEM_9FFE17E518F94C629497FF923C3F7963_VAULT_BOUNDARY3_name | False | True | name |
| Key | Value |
|---|---|
| Name | VaultBoundaryRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | VaultBoundaryRelate |
| 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 | {037A51BE-489A-4CDF-92E7-E4DD599D5E5E} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D851CABB28D | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G156assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Name | VaultRelate |
| Dataset Type | Table |
| Dataset ID | -1 |
| Minimum Client Version | 10.0 |
| Alias | VaultRelate |
| 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 | {919CDCCF-08D9-4699-9CEE-EFF3E1A1558E} |
| 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 | 0 | False | True | Unique identifier for each record | ||
| asset_id | Asset ID | String | True | 0 | 0 | 64 | True | False | A unique identifier for for the asset | |||
| inspect_date | Inspected On | Date | True | 1 | 0 | 8 | True | False | Date when the asset was last inspected | |||
| overall_condition | Overall Condition | String | True | Overall_Condition | 0 | 0 | 50 | True | False | The overall condition of an asset | ||
| relate_notes | Notes | String | True | 0 | 0 | 255 | True | False | Notes pertaining to the related record | |||
| assetguid | Asset Guid | GUID | Index | True | 0 | 0 | 38 | True | False | A unique identifier used to relate a table to a feature | ||
| GlobalID | GlobalID | Global ID | Index | False | 0 | 0 | 38 | False | True | Globally unique identifier for the asset | ||
| created_user | Creator | String | Creator;Index | True | 0 | 0 | 255 | False | True | User who created the record | ||
| created_date | Creation Date | Date | Created;Index | True | 1 | 0 | 8 | False | True | Date the record was created | ||
| last_edited_user | Editor | String | Editor;Index | True | 0 | 0 | 255 | False | True | User who last edited the record | ||
| last_edited_date | Edit Date | Date | Edited;Index | True | 1 | 0 | 8 | False | True | Date when the record was last edited |
| Name | Is Unique | Is Ascending | Field Name |
|---|---|---|---|
| PK__SEWER_SY__F4B70D85F5BAA703 | True | True | OBJECTID |
| FDO_GlobalID | True | True | GlobalID |
| G77assetguid | False | True | assetguid |
| created_dateIndex | False | True | created_date |
| created_userIndex | False | False | created_user |
| last_edited_dateIndex | False | True | last_edited_date |
| last_edited_userIndex | False | False | last_edited_user |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Device_Backflow_Preventer |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 1 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Backflow Preventer | Backflow Preventer |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Backflow_Preventer | assettype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Device_Cleanout |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 4 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Cleanout | Cleanout | |
| Lamp Hole | Lamp Hole | |
| Terminal | Terminal |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Device_Controllable_Valve |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Default Value |
| Merge Policy | Default Value |
| # of Codes | 1 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Controllable Valve | Controllable Valve |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Controllable_Valve | assettype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Device_Discharge |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 3 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Effluent | Effluent | |
| Overflow | Overflow |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Device_Grease_Trap |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 4 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Grease Interceptor | Grease Interceptor | |
| Grease Recovery | Grease Recovery | |
| Grease Trap | Grease Trap |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Grease_Trap | assettype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Device_Meter |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Default Value |
| Merge Policy | Default Value |
| # of Codes | 3 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Bulk Meter | Bulk Meter | |
| Station Meter | Station Meter |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Device_Pump |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 3 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Pump | Pump | |
| Pump with Grinder | Pump with Grinder |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Device_Relief_Valve |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Default Value |
| Merge Policy | Default Value |
| # of Codes | 4 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Air & Vacuum Valve | Air & Vacuum Valve | |
| Air Release Valve | Air Release Valve | |
| Combination Air Valve | Combination Air Valve |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Relief_Valve | assettype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Device_Service_Connection |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 4 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Commercial | Commercial | |
| Industrial | Industrial | |
| Residential | Residential |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Service_Connection | assettype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Device_Treatment |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 1 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Treatment Plant | Treatment Plant |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Treatment_Plant | assettype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Junction_Fitting |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 20 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Coupling | Coupling | |
| Cross | Cross | |
| Elbow | Elbow | |
| End Cap | End Cap | |
| Expansion Joint | Expansion Joint | |
| Flange | Flange | |
| Plug | Plug | |
| Reducer | Reducer | |
| Reducing Cross | Reducing Cross | |
| Reducing Tee | Reducing Tee | |
| Saddle | Saddle | |
| Screw | Screw | |
| Sleeve | Sleeve | |
| Tap | Tap | |
| Tapping Saddle | Tapping Saddle | |
| Tee | Tee | |
| Transition | Transition | |
| Weld | Weld | |
| Wye | Wye |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Line_Lateral_Service |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 4 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Commercial | Commercial | |
| Industrial | Industrial | |
| Residential | Residential |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Line_Sewer_Force_Main |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 1 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Force Main | Force Main |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Sewer_Force_Main | assettype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Sewer_Line_Sewer_Gravity_Main |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 3 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Collector Gravity Main | Collector Gravity Main | |
| Interceptor Gravity Main | Interceptor Gravity Main |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Sewer_Gravity_Main | assettype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Structure_Boundary_Sewer_Lift_Station_Boundary |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 1 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Lift Station | Lift Station |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Sewer_Lift_Station_Boundary | assettype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Structure_Boundary_Sewer_Storm_Vault_Boundary |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 5 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Baffle Chamber | Baffle Chamber | |
| Regulator Chamber | Regulator Chamber | |
| Tide Gate Chamber | Tide Gate Chamber | |
| Wet Well | Wet Well |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Vault_Boundary | assettype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Structure_Boundary_Sewer_Treatment_Plant_Boundary |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 1 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Treatment Plant | Treatment Plant |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Treatment_Plant_Boundary | assettype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Structure_Junction_Sewer_Lift_Station |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 1 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Lift Station | Lift Station |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Sewer_Lift_Station | assettype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Structure_Junction_Sewer_Storm_Manhole |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 10 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Diversion Manhole | Diversion Manhole | |
| Drop Manhole | Drop Manhole | |
| Drop Trap Manhole | Drop Trap Manhole | |
| Flush Manhole | Flush Manhole | |
| Junction Manhole | Junction Manhole | |
| Manhole | Manhole | |
| Offset Manhole | Offset Manhole | |
| Shallow Manhole | Shallow Manhole | |
| Siphon Manhole | Siphon Manhole |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Structure_Junction_Sewer_Storm_Vault |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 5 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Baffle Chamber | Baffle Chamber | |
| Regulator Chamber | Regulator Chamber | |
| Tide Gate Chamber | Tide Gate Chamber | |
| Wet Well | Wet Well |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Asset_Type_Structure_Line_Sewer_Storm_Casing |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 1 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Casing | Casing |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | ESRI_FIX_TYPE_DOMAIN |
| Description | |
| Field Type | Short Integer |
| Domain Type | Coded Value |
| Split Policy | Default Value |
| Merge Policy | Default Value |
| # of Codes | 5 |
| # of Assignments | 14 |
| Code | Description | Details |
|---|---|---|
| 0 | Fix not valid | |
| 1 | GPS | |
| 2 | Differential GPS | |
| 4 | RTK Fixed | |
| 5 | RTK Float |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | ESRI_NUM_SATS_DOMAIN |
| Description | |
| Field Type | Short Integer |
| Domain Type | Range |
| Split Policy | Default Value |
| Merge Policy | Default Value |
| # of Codes | |
| # of Assignments | 14 |
| Minimum | Maximum |
|---|---|
| 0 | 99 |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | ESRI_POSITIONSOURCETYPE_DOMAIN |
| Description | Position Source Type |
| Field Type | Short Integer |
| Domain Type | Coded Value |
| Split Policy | Default Value |
| Merge Policy | Default Value |
| # of Codes | 6 |
| # of Assignments | 14 |
| Code | Description | Details |
|---|---|---|
| 0 | Unknown | |
| 1 | User defined | |
| 2 | Integrated (System) Location Provider | |
| 3 | External GNSS Receiver | |
| 4 | Network Location Provider | |
| 5 | Snapped |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | ESRI_STATION_ID_DOMAIN |
| Description | |
| Field Type | Short Integer |
| Domain Type | Range |
| Split Policy | Default Value |
| Merge Policy | Default Value |
| # of Codes | |
| # of Assignments | 14 |
| Minimum | Maximum |
|---|---|
| 0 | 1023 |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | LifecycleStatus |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 10 |
| # of Assignments | 21 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Proposed | Proposed | |
| Approved | Approved | |
| Under Construction | Under Construction | |
| In Service | In Service | |
| To Be Retired | To Be Retired | |
| Abandoned | Abandoned | |
| Retired | Retired | |
| Removed | Removed | |
| Out of Service | Out of Service |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Location |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 2 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Inside | Inside | |
| Outside | Outside |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Grease_Trap | location |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Overall_Condition |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Default Value |
| Merge Policy | Default Value |
| # of Codes | 5 |
| # of Assignments | 21 |
| Code | Description | Details |
|---|---|---|
| 1- Excellent | 1- Excellent | |
| 2 - Good | 2 - Good | |
| 3 - Average | 3 - Average | |
| 4 - Fair | 4 - Fair | |
| 5 - Poor | 5 - Poor |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Pipe_Device_Status_Combined |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 4 |
| # of Assignments | 12 |
| Code | Description | Details |
|---|---|---|
| Closed | Closed | |
| Open | Open | |
| Inactive | Inactive | |
| Active | Active |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Pipeline_Valve_Close_Direction |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 2 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Counter Clockwise | Counter Clockwise | |
| Clockwise | Clockwise |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Controllable_Valve | closedirection |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Asset_Manager |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 3 |
| # of Assignments | 17 |
| Code | Description | Details |
|---|---|---|
| Our Agency | Our Agency | |
| Private | Private | |
| Other | Other |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Asset_Owner |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 3 |
| # of Assignments | 17 |
| Code | Description | Details |
|---|---|---|
| Our Agency | Our Agency | |
| Private | Private | |
| Other | Other |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Cleanout_Material |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 10 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Acrylonitrile Butadiene Styrene - ABS | Acrylonitrile Butadiene Styrene - ABS | |
| Cast Iron - CAS | Cast Iron - CAS | |
| Concrete Pipe (non-reinforced) - CP | Concrete Pipe (non-reinforced) - CP | |
| Ductile Iron Pipe - DIP | Ductile Iron Pipe - DIP | |
| Galvanized - GP | Galvanized - GP | |
| Polyethylene - PE | Polyethylene - PE | |
| Polypropylene - PP | Polypropylene - PP | |
| Polyvinyle Chloride - PVC | Polyvinyle Chloride - PVC | |
| Steel - SP | Steel - SP | |
| Copper - CIP | Copper - CIP |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Controllable_Valve_Diameter |
| Description | |
| Field Type | Double |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 29 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| 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 |
|---|---|---|---|
| Controllable_Valve | diameter |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Controllable_Valve_Type |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 5 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Ball | Ball | |
| Butterfly | Butterfly | |
| Cone | Cone | |
| Gate | Gate | |
| Plug | Plug |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Controllable_Valve | valvetype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Lateral_Diameter |
| Description | |
| Field Type | Double |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 19 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| 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" |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Lateral_Material |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 10 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Acrylonitrile Butadiene Styrene - ABS | Acrylonitrile Butadiene Styrene - ABS | |
| Cast Iron - CAS | Cast Iron - CAS | |
| Concrete Pipe (Non-Reinforced) - CP | Concrete Pipe (Non-Reinforced) - CP | |
| Ductile Iron Pipe - DIP | Ductile Iron Pipe - DIP | |
| Galvanized Pipe - GP | Galvanized Pipe - GP | |
| Polyethylene - PE | Polyethylene - PE | |
| Polypropylene - PP | Polypropylene - PP | |
| Polyvinyle Chloride - PVC | Polyvinyle Chloride - PVC | |
| Steel Pipe - SP | Steel Pipe - SP | |
| Copper - CIP | Copper - CIP |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Main_Diameter |
| Description | |
| Field Type | Double |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 29 |
| # of Assignments | 2 |
| Code | Description | Details |
|---|---|---|
| 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 |
|---|---|---|---|
| Sewer_Gravity_Main | diameter | ||
| Sewer_Force_Main | diameter |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Main_Liner |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 13 |
| # of Assignments | 2 |
| Code | Description | Details |
|---|---|---|
| Cured-In-Place Pipe | Cured-In-Place Pipe - CIP | |
| Fold and Form or Deform/Reform | Fold and Form or Deform/Reform - FF | |
| Formed-In-Place Liner | Formed-In-Place Liner - FP | |
| Grout-In-Place Liner | Grout-In-Place Liner - GP | |
| Glass Reinforced Cement | Glass Reinforced Cement - GRC | |
| None | None - N | |
| Continuous Slip Liner | Continuous Slip Liner - SC | |
| Sectional Slip Liner | Sectional Slip Liner - SE | |
| Spray Liner | Spray Liner - SL | |
| Segmented Panel | Segmented Panel - SN | |
| Segmented Pipe | Segmented Pipe - SP | |
| Spiral Wound | Spiral Wound - SW | |
| Other | Other - ZZ |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Sewer_Gravity_Main | linertype | ||
| Sewer_Force_Main | linertype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Main_Material |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 26 |
| # of Assignments | 2 |
| Code | Description | Details |
|---|---|---|
| Acrylonitrile Butadiene Styrene - ABS | Acrylonitrile Butadiene Styrene - ABS | |
| Asbestos Cement - AC | Asbestos Cement - AC | |
| Asphalt - ASP | Asphalt - ASP | |
| Brick - BR | Brick - BR | |
| Cast Iron - CAS | Cast Iron - CAS | |
| Clay Tile - CT | Clay Tile - CT | |
| Concrete Pipe (Non-Reinforced) - CP | Concrete Pipe (Non-Reinforced) - CP | |
| Concrete Segments (Bolted) - CSB | Concrete Segments (Bolted) - CSB | |
| Concrete Segments (Unbolted) - CSU | Concrete Segments (Unbolted) - CSU | |
| Cured in Place Pipe - CIPP | Cured in Place Pipe - CIPP | |
| Ductile Iron Pipe - DIP | Ductile Iron Pipe - DIP | |
| Fiberglass Reinforced Pipe - FRP | Fiberglass Reinforced Pipe - FRP | |
| Galvanized Pipe - GP | Galvanized Pipe - GP | |
| Glass Reinforced Cement - GRC | Glass Reinforced Cement - GRC | |
| High Density Polyethylene - HDPE | High Density Polyethylene - HDPE | |
| Other - OTH | Other - OTH | |
| Plastic/Steel Composite - PSC | Plastic/Steel Composite - PSC | |
| Polyethylene - PE | Polyethylene - PE | |
| Polypropylene - PP | Polypropylene - PP | |
| Polyvinyle Chloride - PVC | Polyvinyle Chloride - PVC | |
| Pre-Stressed Concrete Cylinder Pipe - PCCP | Pre-Stressed Concrete Cylinder Pipe - PCCP | |
| Reinforced Concrete Pipe - RCP | Reinforced Concrete Pipe - RCP | |
| Reinforced Plastic Pipe (Truss Pipe) - RPM | Reinforced Plastic Pipe (Truss Pipe) - RPM | |
| Segmented Block - SB | Segmented Block - SB | |
| Steel Pipe - SP | Steel Pipe - SP | |
| Vitrified Clay Pipe - VCP | Vitrified Clay Pipe - VCP |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Sewer_Gravity_Main | material | ||
| Sewer_Force_Main | material |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Main_Shape |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 6 |
| # of Assignments | 2 |
| Code | Description | Details |
|---|---|---|
| Circular | Circular | |
| Horseshoe | Horseshoe | |
| Oblong | Oblong | |
| Rectangular | Rectangular | |
| Trapezoidal | Trapezoidal | |
| Triangular | Triangular |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Sewer_Gravity_Main | mainshape | ||
| Sewer_Force_Main | designtype |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Pump_Discharge_Diameter |
| Description | |
| Field Type | Double |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 13 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| 4 | 4" | |
| 6 | 6" | |
| 8 | 8" | |
| 10 | 10" | |
| 12 | 12" | |
| 14 | 14" | |
| 15 | 15" | |
| 16 | 16" | |
| 18 | 18" | |
| 20 | 20" | |
| 24 | 24" | |
| 36 | 36" | |
| 48 | 48" |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Pump | dischargediameter |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Pump_Inlet_Diameter |
| Description | |
| Field Type | Double |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 13 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| 4 | 4" | |
| 6 | 6" | |
| 8 | 8" | |
| 10 | 10" | |
| 12 | 12" | |
| 14 | 14" | |
| 15 | 15" | |
| 16 | 16" | |
| 18 | 18" | |
| 20 | 20" | |
| 24 | 24" | |
| 36 | 36" | |
| 48 | 48" |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Pump | inletdiameter |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Pump_Type |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 7 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| Axial Flow | Axial Flow | |
| Centrifugal | Centrifugal | |
| Jet | Jet | |
| Reciprocating | Reciprocating | |
| Rotary | Rotary | |
| Turbine | Turbine | |
| Other | Other |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Sewer_Relief_Valve_Diameter |
| Description | |
| Field Type | Double |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 29 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| 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 |
|---|---|---|---|
| Relief_Valve | diameter |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Spatial_Confidence |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 3 |
| # of Assignments | 21 |
| Code | Description | Details |
|---|---|---|
| High | High | |
| Medium | Medium | |
| Low | Low |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Spatial_Source |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 5 |
| # of Assignments | 21 |
| Code | Description | Details |
|---|---|---|
| As-Built | As-Built | |
| CAD | CAD | |
| Digitized | Digitized | |
| GPS/GNSS | GPS/GNSS | |
| Field Sketch | Field Sketch |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Structure_Sewer_Storm_Access_Point_Cover_Shape |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 9 |
| # of Assignments | 2 |
| Code | Description | Details |
|---|---|---|
| Circular | Circular | |
| Horseshoe | Horseshoe | |
| Oblong | Oblong | |
| Rectangular | Rectangular | |
| Trapezoidal | Trapezoidal | |
| Triangular | Triangular | |
| Arched (with flat bottom) | Arched (with flat bottom) | |
| Square | Square | |
| U-Shaped with Flat Top | U-Shaped with Flat Top |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Manhole | covershape | ||
| Vault | covershape |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Structure_Sewer_Storm_Casing_Diameter |
| Description | |
| Field Type | Double |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 6 |
| # of Assignments | 1 |
| Code | Description | Details |
|---|---|---|
| 10 | 10" | |
| 14 | 14" | |
| 16 | 16" | |
| 18 | 18" | |
| 20 | 20" | |
| 30 | 30" |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Structure_Sewer_Storm_Manhole_Frame_Material |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 11 |
| # of Assignments | 2 |
| Code | Description | Details |
|---|---|---|
| Acrylonitrile Butadiene Styrene - ABS | Acrylonitrile Butadiene Styrene - ABS | |
| Cast Iron - CAS | Cast Iron - CAS | |
| Ductile Iron Pipe - DIP | Ductile Iron Pipe - DIP | |
| High Density Polyethylene - HDPE | High Density Polyethylene - HDPE | |
| Plastic/Steel Composite - PSC | Plastic/Steel Composite - PSC | |
| Polyethylene - PE | Polyethylene - PE | |
| Polypropylene - PP | Polypropylene - PP | |
| Polyvinyle Chloride - PVC | Polyvinyle Chloride - PVC | |
| Reinforced Plastic Pipe (Truss Pipe) - RPM | Reinforced Plastic Pipe (Truss Pipe) - RPM | |
| Steel Pipe - SP | Steel Pipe - SP | |
| Other | Other |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Manhole | framematerial | ||
| Vault | framematerial |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Structure_Sewer_Storm_Manhole_Step_Material |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 3 |
| # of Assignments | 2 |
| Code | Description | Details |
|---|---|---|
| Metal | Metal | |
| Plastic | Plastic | |
| Brick | Brick |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Manhole | stepmaterial | ||
| Vault | stepmaterial |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Structure_Sewer_Storm_Manhole_Surface |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 7 |
| # of Assignments | 2 |
| Code | Description | Details |
|---|---|---|
| Unknown | Unknown | |
| Asphalt | Asphalt | |
| Concrete Pavement | Concrete Pavement | |
| Concrete Collar | Concrete Collar | |
| Grass/Dirt | Grass/Dirt | |
| Gravel | Gravel | |
| Other | Other |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Structure_Sewer_Storm_Manhole_Wall_Material |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 6 |
| # of Assignments | 2 |
| Code | Description | Details |
|---|---|---|
| Brick - BR | Brick - BR | |
| Concrete Pipe (Non-Reinforced) - CP | Concrete Pipe (Non-Reinforced) - CP | |
| Concrete Segments (Bolted) - CSB | Concrete Segments (Bolted) - CSB | |
| Concrete Segments (Unbolted) - CSU | Concrete Segments (Unbolted) - CSU | |
| Pre-Stressed Concrete Cylinder Pipe - PCCP | Pre-Stressed Concrete Cylinder Pipe - PCCP | |
| Reinforced Concrete Pipe - RCP | Reinforced Concrete Pipe - RCP |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Manhole | wallmaterial | ||
| Vault | wallmaterial |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Structure_Sewer_Storm_Vault_Manhole_Cone |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 2 |
| # of Assignments | 2 |
| Code | Description | Details |
|---|---|---|
| Straight | Straight | |
| Offset | Offset |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Structure_Sewer_Storm_Vault_Manhole_Location |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 13 |
| # of Assignments | 2 |
| Code | Description | Details |
|---|---|---|
| Main Highway | Main Highway | |
| Light Highway | Light Highway | |
| Easement/Right of Way | Easement/Right of Way | |
| Woods | Woods | |
| Sidewalk | Sidewalk | |
| Parking Lot | Parking Lot | |
| Alley | Alley | |
| Ditch | Ditch | |
| Building | Building | |
| Creek | Creek | |
| Railway | Railway | |
| Airport | Airport | |
| Yard | Yard |
| Key | Value |
|---|---|
| Owner | |
| Domain Name | Yes_No |
| Description | |
| Field Type | String |
| Domain Type | Coded Value |
| Split Policy | Duplicate |
| Merge Policy | Default Value |
| # of Codes | 2 |
| # of Assignments | 11 |
| Code | Description | Details |
|---|---|---|
| Yes | Yes | |
| No | No |
| Dataset | Subtype Code | Subtype Name | Field Name |
|---|---|---|---|
| Manhole | channel | ||
| Manhole | bench | ||
| Pump | operable | ||
| Vault | channel | ||
| Vault | bench | ||
| Controllable_Valve | operable | ||
| Controllable_Valve | hasbypass | ||
| Relief_Valve | operable | ||
| Meter | operable | ||
| Sewer_Gravity_Main | tracerwire | ||
| Sewer_Force_Main | tracerwire |