Geodatabase Documentation
Date: Wednesday, January 30, 2019
Time: 3:22:14 PM
Summary Information and Links
0 Feature Datasets and 12 Feature Classes
No Topology Datasets
No Geometric Networks
No Rasters
No Tables (Object Classes)
No Relationship Classes
26 Domains
Feature Datasets and Child Classes
Rasters
Workspace-Level Tables and Feature Classes
AirandVacuumService - Feature Class
BlowOffService - Feature Class
CommercialService - Feature Class
FireService - Feature Class
IndustrialService - Feature Class
IrrigationService - Feature Class
MeterStation - Feature Class
ResidentialService - Feature Class
SamplingService - Feature Class
ServiceConnection - Feature Class
ServiceMeter - Feature Class
ServiceValve - Feature Class
Relationship Classes
Domains
Asset_Manager
Asset_Owner
Asset_Type_Water_Assembly_Meter_Station
Asset_Type_Water_Device_Meter
Asset_Type_Water_Device_Service_Connection
Asset_Type_Water_Device_Service_Valve
Asset_Type_Water_Line_Air_&_Vacuum_Service
Asset_Type_Water_Line_Blow_Off_Service
Asset_Type_Water_Line_Commercial_Service
Asset_Type_Water_Line_Fire_Service
Asset_Type_Water_Line_Industrial_Service
Asset_Type_Water_Line_Irrigation_Service
Asset_Type_Water_Line_Residential_Service
Asset_Type_Water_Line_Sampling_Service
Boolean
ESRI_FIX_TYPE_DOMAIN
ESRI_NUM_SATS_DOMAIN
ESRI_STATION_ID_DOMAIN
Lifecycle_Combined
Pipe_Device_Status_Combined
Pipeline_Valve_Close_Direction
Symbol_Rotation
Water_Diameter
Water_Service_Diameter
Water_Valve_Type
Yes_No
AirandVacuumService - FeatureClass
Name | AirandVacuumService |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | AirandVacuumService |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | AirandVacuumService |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
assettype | SmallInteger | 2 | Asset type | assettype | Asset_Type_Water_Line_Air_&_Vacuum_Service | | false | | |
creationdate | Date | 8 | Creation date | creationdate | | | true | | |
creator | String | 255 | Creator | creator | | | true | | |
lastupdate | Date | 8 | Last update | lastupdate | | | true | | |
updatedby | String | 255 | Updated by | updatedby | | | true | | |
globalid | GlobalID | 38 | Global ID | globalid | | | false | | |
installdate | Date | 8 | Install Date | installdate | | | true | | |
assetid | String | 64 | Asset ID | assetid | | | true | | |
ownedby | SmallInteger | 2 | Owned By | ownedby | Asset_Owner | | true | | |
maintby | SmallInteger | 2 | Maintained By | maintby | Asset_Manager | | true | | |
notes | String | 2000 | Notes | notes | | | true | | |
diameter | Double | 8 | Diameter | diameter | Water_Service_Diameter | | true | | |
measuredlength | Double | 8 | Measured Length | measuredlength | | | true | | |
adddetails | SmallInteger | 2 | Tracer Wire | adddetails | Yes_No | | true | | |
lifecyclestatus | SmallInteger | 2 | Lifecycle Status | lifecyclestatus | Lifecycle_Combined | | false | | |
BlowOffService - FeatureClass
Name | BlowOffService |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | BlowOffService |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | BlowOffService |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
assettype | SmallInteger | 2 | Asset type | assettype | Asset_Type_Water_Line_Blow_Off_Service | | false | | |
creationdate | Date | 8 | Creation date | creationdate | | | true | | |
creator | String | 255 | Creator | creator | | | true | | |
lastupdate | Date | 8 | Last update | lastupdate | | | true | | |
updatedby | String | 255 | Updated by | updatedby | | | true | | |
globalid | GlobalID | 38 | Global ID | globalid | | | false | | |
installdate | Date | 8 | Install Date | installdate | | | true | | |
assetid | String | 64 | Asset ID | assetid | | | true | | |
ownedby | SmallInteger | 2 | Owned By | ownedby | Asset_Owner | | true | | |
maintby | SmallInteger | 2 | Maintained By | maintby | Asset_Manager | | true | | |
notes | String | 2000 | Notes | notes | | | true | | |
diameter | Double | 8 | Diameter | diameter | Water_Service_Diameter | | true | | |
measuredlength | Double | 8 | Measured Length | measuredlength | | | true | | |
adddetails | SmallInteger | 2 | Tracer Wire | adddetails | Yes_No | | true | | |
lifecyclestatus | SmallInteger | 2 | Lifecycle Status | lifecyclestatus | Lifecycle_Combined | | false | | |
CommercialService - FeatureClass
Name | CommercialService |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | CommercialService |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | CommercialService |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
assettype | SmallInteger | 2 | Asset type | assettype | Asset_Type_Water_Line_Commercial_Service | | false | | |
creationdate | Date | 8 | Creation date | creationdate | | | true | | |
creator | String | 255 | Creator | creator | | | true | | |
lastupdate | Date | 8 | Last update | lastupdate | | | true | | |
updatedby | String | 255 | Updated by | updatedby | | | true | | |
globalid | GlobalID | 38 | Global ID | globalid | | | false | | |
installdate | Date | 8 | Install Date | installdate | | | true | | |
assetid | String | 64 | Asset ID | assetid | | | true | | |
ownedby | SmallInteger | 2 | Owned By | ownedby | Asset_Owner | | true | | |
maintby | SmallInteger | 2 | Maintained By | maintby | Asset_Manager | | true | | |
notes | String | 2000 | Notes | notes | | | true | | |
diameter | Double | 8 | Diameter | diameter | Water_Service_Diameter | | true | | |
measuredlength | Double | 8 | Measured Length | measuredlength | | | true | | |
adddetails | SmallInteger | 2 | Tracer Wire | adddetails | Yes_No | | true | | |
lifecyclestatus | SmallInteger | 2 | Lifecycle Status | lifecyclestatus | Lifecycle_Combined | | false | | |
FireService - FeatureClass
Name | FireService |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | FireService |
HasM | false |
HasZ | false |
HasAttachments | false |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
assettype | SmallInteger | 2 | Asset type | assettype | Asset_Type_Water_Line_Fire_Service | | false | | |
creationdate | Date | 8 | Creation date | creationdate | | | true | | |
creator | String | 255 | Creator | creator | | | true | | |
lastupdate | Date | 8 | Last update | lastupdate | | | true | | |
updatedby | String | 255 | Updated by | updatedby | | | true | | |
globalid | GlobalID | 38 | Global ID | globalid | | | false | | |
installdate | Date | 8 | Install Date | installdate | | | true | | |
assetid | String | 64 | Asset ID | assetid | | | true | | |
ownedby | SmallInteger | 2 | Owned By | ownedby | Asset_Owner | | true | | |
maintby | SmallInteger | 2 | Maintained By | maintby | Asset_Manager | | true | | |
notes | String | 2000 | Notes | notes | | | true | | |
diameter | Double | 8 | Diameter | diameter | Water_Service_Diameter | | true | | |
measuredlength | Double | 8 | Measured Length | measuredlength | | | true | | |
adddetails | SmallInteger | 2 | Tracer Wire | adddetails | Yes_No | | true | | |
lifecyclestatus | SmallInteger | 2 | Lifecycle Status | lifecyclestatus | Lifecycle_Combined | | false | | |
IndustrialService - FeatureClass
Name | IndustrialService |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | IndustrialService |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | IndustrialService |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
assettype | SmallInteger | 2 | Asset type | assettype | Asset_Type_Water_Line_Industrial_Service | | false | | |
creationdate | Date | 8 | Creation date | creationdate | | | true | | |
creator | String | 255 | Creator | creator | | | true | | |
lastupdate | Date | 8 | Last update | lastupdate | | | true | | |
updatedby | String | 255 | Updated by | updatedby | | | true | | |
globalid | GlobalID | 38 | Global ID | globalid | | | false | | |
installdate | Date | 8 | Install Date | installdate | | | true | | |
assetid | String | 64 | Asset ID | assetid | | | true | | |
ownedby | SmallInteger | 2 | Owned By | ownedby | Asset_Owner | | true | | |
maintby | SmallInteger | 2 | Maintained By | maintby | Asset_Manager | | true | | |
notes | String | 2000 | Notes | notes | | | true | | |
diameter | Double | 8 | Diameter | diameter | Water_Service_Diameter | | true | | |
measuredlength | Double | 8 | Measured Length | measuredlength | | | true | | |
adddetails | SmallInteger | 2 | Tracer Wire | adddetails | Yes_No | | true | | |
lifecyclestatus | SmallInteger | 2 | Lifecycle Status | lifecyclestatus | Lifecycle_Combined | | false | | |
IrrigationService - FeatureClass
Name | IrrigationService |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | IrrigationService |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | IrrigationService |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
assettype | SmallInteger | 2 | Asset type | assettype | Asset_Type_Water_Line_Irrigation_Service | | false | | |
creationdate | Date | 8 | Creation date | creationdate | | | true | | |
creator | String | 255 | Creator | creator | | | true | | |
lastupdate | Date | 8 | Last update | lastupdate | | | true | | |
updatedby | String | 255 | Updated by | updatedby | | | true | | |
globalid | GlobalID | 38 | Global ID | globalid | | | false | | |
installdate | Date | 8 | Install Date | installdate | | | true | | |
assetid | String | 64 | Asset ID | assetid | | | true | | |
ownedby | SmallInteger | 2 | Owned By | ownedby | Asset_Owner | | true | | |
maintby | SmallInteger | 2 | Maintained By | maintby | Asset_Manager | | true | | |
notes | String | 2000 | Notes | notes | | | true | | |
diameter | Double | 8 | Diameter | diameter | Water_Service_Diameter | | true | | |
measuredlength | Double | 8 | Measured Length | measuredlength | | | true | | |
adddetails | SmallInteger | 2 | Tracer Wire | adddetails | Yes_No | | true | | |
lifecyclestatus | SmallInteger | 2 | Lifecycle Status | lifecyclestatus | Lifecycle_Combined | | false | | |
MeterStation - FeatureClass
Name | MeterStation |
ShapeType | Point |
FeatureType | Simple |
AliasName | MeterStation |
HasM | false |
HasZ | false |
HasAttachments | false |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
assettype | SmallInteger | 2 | Asset type | assettype | Asset_Type_Water_Assembly_Meter_Station | | false | | |
creationdate | Date | 8 | Creation date | creationdate | | | true | | |
creator | String | 255 | Creator | creator | | | true | | |
lastupdate | Date | 8 | Last update | lastupdate | | | true | | |
updatedby | String | 255 | Updated by | updatedby | | | true | | |
globalid | GlobalID | 38 | Global ID | globalid | | | false | | |
installdate | Date | 8 | Install Date | installdate | | | true | | |
assetid | String | 64 | Asset ID | assetid | | | true | | |
notes | String | 2000 | Notes | notes | | | false | | |
symbolrotation | SmallInteger | 2 | Symbol Rotation | symbolrotation | Symbol_Rotation | | true | | |
lifecyclestatus | SmallInteger | 2 | Lifecycle Status | lifecyclestatus | Lifecycle_Combined | | false | | |
ESRIGNSS_RECEIVER | String | 50 | Receiver Name | ESRIGNSS_RECEIVER | | | true | | |
ESRIGNSS_H_RMS | Double | 8 | Horizontal Accuracy (m) | ESRIGNSS_H_RMS | | | true | | |
ESRIGNSS_V_RMS | Double | 8 | Vertical Accuracy (m) | ESRIGNSS_V_RMS | | | true | | |
ESRIGNSS_LATITUDE | Double | 8 | Latitude | ESRIGNSS_LATITUDE | | | true | | |
ESRIGNSS_LONGITUDE | Double | 8 | Longitude | ESRIGNSS_LONGITUDE | | | true | | |
ESRIGNSS_ALTITUDE | Double | 8 | Altitude | ESRIGNSS_ALTITUDE | | | true | | |
ESRIGNSS_PDOP | Double | 8 | PDOP | ESRIGNSS_PDOP | | | true | | |
ESRIGNSS_HDOP | Double | 8 | HDOP | ESRIGNSS_HDOP | | | true | | |
ESRIGNSS_VDOP | Double | 8 | VDOP | ESRIGNSS_VDOP | | | true | | |
ESRIGNSS_FIXTYPE | SmallInteger | 2 | Fix Type | ESRIGNSS_FIXTYPE | ESRI_FIX_TYPE_DOMAIN | | true | | |
ESRIGNSS_CORRECTIONAGE | Double | 8 | Correction Age | ESRIGNSS_CORRECTIONAGE | | | true | | |
ESRIGNSS_STATIONID | SmallInteger | 2 | Station ID | ESRIGNSS_STATIONID | ESRI_STATION_ID_DOMAIN | | true | | |
ESRIGNSS_NUMSATS | SmallInteger | 2 | Number of Satellites | ESRIGNSS_NUMSATS | ESRI_NUM_SATS_DOMAIN | | true | | |
ESRIGNSS_FIXDATETIME | Date | 8 | Fix Time | ESRIGNSS_FIXDATETIME | | | true | | |
ESRIGNSS_AVG_H_RMS | Double | 8 | Average Horizontal Accuracy (m) | ESRIGNSS_AVG_H_RMS | | | true | | |
ESRIGNSS_AVG_V_RMS | Double | 8 | Average Vertical Accuracy (m) | ESRIGNSS_AVG_V_RMS | | | true | | |
ESRIGNSS_AVG_POSITIONS | SmallInteger | 2 | Averaged Positions | ESRIGNSS_AVG_POSITIONS | | | true | | |
ESRIGNSS_H_STDDEV | Double | 8 | Standard Deviation (m) | ESRIGNSS_H_STDDEV | | | true | | |
ResidentialService - FeatureClass
Name | ResidentialService |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | ResidentialService |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | ResidentialService |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
assettype | SmallInteger | 2 | Asset type | assettype | Asset_Type_Water_Line_Residential_Service | | false | | |
creationdate | Date | 8 | Creation date | creationdate | | | true | | |
creator | String | 255 | Creator | creator | | | true | | |
lastupdate | Date | 8 | Last update | lastupdate | | | true | | |
updatedby | String | 255 | Updated by | updatedby | | | true | | |
globalid | GlobalID | 38 | Global ID | globalid | | | false | | |
installdate | Date | 8 | Install Date | installdate | | | true | | |
assetid | String | 64 | Asset ID | assetid | | | true | | |
ownedby | SmallInteger | 2 | Owned By | ownedby | Asset_Owner | | true | | |
maintby | SmallInteger | 2 | Maintained By | maintby | Asset_Manager | | true | | |
notes | String | 2000 | Notes | notes | | | true | | |
diameter | Double | 8 | Diameter | diameter | Water_Service_Diameter | | true | | |
measuredlength | Double | 8 | Measured Length | measuredlength | | | true | | |
adddetails | SmallInteger | 2 | Tracer Wire | adddetails | Yes_No | | true | | |
lifecyclestatus | SmallInteger | 2 | Lifecycle Status | lifecyclestatus | Lifecycle_Combined | | false | | |
SamplingService - FeatureClass
Name | SamplingService |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | SamplingService |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | SamplingService |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
assettype | SmallInteger | 2 | Asset type | assettype | Asset_Type_Water_Line_Sampling_Service | | false | | |
creationdate | Date | 8 | Creation date | creationdate | | | true | | |
creator | String | 255 | Creator | creator | | | true | | |
lastupdate | Date | 8 | Last update | lastupdate | | | true | | |
updatedby | String | 255 | Updated by | updatedby | | | true | | |
globalid | GlobalID | 38 | Global ID | globalid | | | false | | |
installdate | Date | 8 | Install Date | installdate | | | true | | |
assetid | String | 64 | Asset ID | assetid | | | true | | |
ownedby | SmallInteger | 2 | Owned By | ownedby | Asset_Owner | | true | | |
maintby | SmallInteger | 2 | Maintained By | maintby | Asset_Manager | | true | | |
notes | String | 2000 | Notes | notes | | | true | | |
diameter | Double | 8 | Diameter | diameter | Water_Service_Diameter | | true | | |
measuredlength | Double | 8 | Measured Length | measuredlength | | | true | | |
adddetails | SmallInteger | 2 | Tracer Wire | adddetails | Yes_No | | true | | |
lifecyclestatus | SmallInteger | 2 | Lifecycle Status | lifecyclestatus | Lifecycle_Combined | | false | | |
ServiceConnection - FeatureClass
Name | ServiceConnection |
ShapeType | Point |
FeatureType | Simple |
AliasName | ServiceConnection |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | ServiceConnection |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
assettype | SmallInteger | 2 | Asset type | assettype | Asset_Type_Water_Device_Service_Connection | | false | | |
creationdate | Date | 8 | Creation date | creationdate | | | true | | |
creator | String | 255 | Creator | creator | | | true | | |
lastupdate | Date | 8 | Last update | lastupdate | | | true | | |
updatedby | String | 255 | Updated by | updatedby | | | true | | |
globalid | GlobalID | 38 | Global ID | globalid | | | false | | |
diameter | Double | 8 | Diameter | diameter | | | true | | |
additionaldetails | SmallInteger | 2 | Critical | additionaldetails | Yes_No | | true | | |
installdate | Date | 8 | Install Date | installdate | | | true | | |
assetid | String | 64 | Asset ID | assetid | | | true | | |
accountid | String | 50 | Account ID | accountid | | | true | | |
ownedby | SmallInteger | 2 | Owned By | ownedby | Asset_Owner | | true | | |
maintby | SmallInteger | 2 | Maintained By | maintby | Asset_Manager | | true | | |
additionaldevice | SmallInteger | 2 | Metered | additionaldevice | Yes_No | | true | | |
notes | String | 2000 | Notes | notes | | | true | | |
symbolrotation | SmallInteger | 2 | Symbol Rotation | symbolrotation | Symbol_Rotation | | true | | |
lastmaint | Date | 8 | Last Maintenance | lastmaint | | | true | | |
lifecyclestatus | SmallInteger | 2 | Lifecycle Status | lifecyclestatus | Lifecycle_Combined | | false | | |
ESRIGNSS_RECEIVER | String | 50 | Receiver Name | ESRIGNSS_RECEIVER | | | true | | |
ESRIGNSS_H_RMS | Double | 8 | Horizontal Accuracy (m) | ESRIGNSS_H_RMS | | | true | | |
ESRIGNSS_V_RMS | Double | 8 | Vertical Accuracy (m) | ESRIGNSS_V_RMS | | | true | | |
ESRIGNSS_LATITUDE | Double | 8 | Latitude | ESRIGNSS_LATITUDE | | | true | | |
ESRIGNSS_LONGITUDE | Double | 8 | Longitude | ESRIGNSS_LONGITUDE | | | true | | |
ESRIGNSS_ALTITUDE | Double | 8 | Altitude | ESRIGNSS_ALTITUDE | | | true | | |
ESRIGNSS_PDOP | Double | 8 | PDOP | ESRIGNSS_PDOP | | | true | | |
ESRIGNSS_HDOP | Double | 8 | HDOP | ESRIGNSS_HDOP | | | true | | |
ESRIGNSS_VDOP | Double | 8 | VDOP | ESRIGNSS_VDOP | | | true | | |
ESRIGNSS_FIXTYPE | SmallInteger | 2 | Fix Type | ESRIGNSS_FIXTYPE | ESRI_FIX_TYPE_DOMAIN | | true | | |
ESRIGNSS_CORRECTIONAGE | Double | 8 | Correction Age | ESRIGNSS_CORRECTIONAGE | | | true | | |
ESRIGNSS_STATIONID | SmallInteger | 2 | Station ID | ESRIGNSS_STATIONID | ESRI_STATION_ID_DOMAIN | | true | | |
ESRIGNSS_NUMSATS | SmallInteger | 2 | Number of Satellites | ESRIGNSS_NUMSATS | ESRI_NUM_SATS_DOMAIN | | true | | |
ESRIGNSS_FIXDATETIME | Date | 8 | Fix Time | ESRIGNSS_FIXDATETIME | | | true | | |
ESRIGNSS_AVG_H_RMS | Double | 8 | Average Horizontal Accuracy (m) | ESRIGNSS_AVG_H_RMS | | | true | | |
ESRIGNSS_AVG_V_RMS | Double | 8 | Average Vertical Accuracy (m) | ESRIGNSS_AVG_V_RMS | | | true | | |
ESRIGNSS_AVG_POSITIONS | SmallInteger | 2 | Averaged Positions | ESRIGNSS_AVG_POSITIONS | | | true | | |
ESRIGNSS_H_STDDEV | Double | 8 | Standard Deviation (m) | ESRIGNSS_H_STDDEV | | | true | | |
ServiceMeter - FeatureClass
Name | ServiceMeter |
ShapeType | Point |
FeatureType | Simple |
AliasName | ServiceMeter |
HasM | false |
HasZ | false |
HasAttachments | false |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
assettype | SmallInteger | 2 | Asset type | assettype | Asset_Type_Water_Device_Meter | | false | | |
creationdate | Date | 8 | Creation date | creationdate | | | true | | |
creator | String | 255 | Creator | creator | | | true | | |
lastupdate | Date | 8 | Last update | lastupdate | | | true | | |
updatedby | String | 255 | Updated by | updatedby | | | true | | |
globalid | GlobalID | 38 | Global ID | globalid | | | false | | |
diameter | Double | 8 | Diameter | diameter | Water_Diameter | | true | | |
installdate | Date | 8 | Install Date | installdate | | | true | | |
assetid | String | 64 | Asset ID | assetid | | | true | | |
accountid | String | 50 | Account ID | accountid | | | true | | |
ownedby | SmallInteger | 2 | Owned By | ownedby | Asset_Owner | | true | | |
maintby | SmallInteger | 2 | Maintained By | maintby | Asset_Manager | | true | | |
notes | String | 2000 | Notes | notes | | | true | | |
symbolrotation | SmallInteger | 2 | Symbol Rotation | symbolrotation | Symbol_Rotation | | true | | |
lastmaint | Date | 8 | Last Maintenance | lastmaint | | | true | | |
lifecyclestatus | SmallInteger | 2 | Lifecycle Status | lifecyclestatus | Lifecycle_Combined | | false | | |
ESRIGNSS_RECEIVER | String | 50 | Receiver Name | ESRIGNSS_RECEIVER | | | true | | |
ESRIGNSS_H_RMS | Double | 8 | Horizontal Accuracy (m) | ESRIGNSS_H_RMS | | | true | | |
ESRIGNSS_V_RMS | Double | 8 | Vertical Accuracy (m) | ESRIGNSS_V_RMS | | | true | | |
ESRIGNSS_LATITUDE | Double | 8 | Latitude | ESRIGNSS_LATITUDE | | | true | | |
ESRIGNSS_LONGITUDE | Double | 8 | Longitude | ESRIGNSS_LONGITUDE | | | true | | |
ESRIGNSS_ALTITUDE | Double | 8 | Altitude | ESRIGNSS_ALTITUDE | | | true | | |
ESRIGNSS_PDOP | Double | 8 | PDOP | ESRIGNSS_PDOP | | | true | | |
ESRIGNSS_HDOP | Double | 8 | HDOP | ESRIGNSS_HDOP | | | true | | |
ESRIGNSS_VDOP | Double | 8 | VDOP | ESRIGNSS_VDOP | | | true | | |
ESRIGNSS_FIXTYPE | SmallInteger | 2 | Fix Type | ESRIGNSS_FIXTYPE | ESRI_FIX_TYPE_DOMAIN | | true | | |
ESRIGNSS_CORRECTIONAGE | Double | 8 | Correction Age | ESRIGNSS_CORRECTIONAGE | | | true | | |
ESRIGNSS_STATIONID | SmallInteger | 2 | Station ID | ESRIGNSS_STATIONID | ESRI_STATION_ID_DOMAIN | | true | | |
ESRIGNSS_NUMSATS | SmallInteger | 2 | Number of Satellites | ESRIGNSS_NUMSATS | ESRI_NUM_SATS_DOMAIN | | true | | |
ESRIGNSS_FIXDATETIME | Date | 8 | Fix Time | ESRIGNSS_FIXDATETIME | | | true | | |
ESRIGNSS_AVG_H_RMS | Double | 8 | Average Horizontal Accuracy (m) | ESRIGNSS_AVG_H_RMS | | | true | | |
ESRIGNSS_AVG_V_RMS | Double | 8 | Average Vertical Accuracy (m) | ESRIGNSS_AVG_V_RMS | | | true | | |
ESRIGNSS_AVG_POSITIONS | SmallInteger | 2 | Averaged Positions | ESRIGNSS_AVG_POSITIONS | | | true | | |
ESRIGNSS_H_STDDEV | Double | 8 | Standard Deviation (m) | ESRIGNSS_H_STDDEV | | | true | | |
ServiceValve - FeatureClass
Name | ServiceValve |
ShapeType | Point |
FeatureType | Simple |
AliasName | ServiceValve |
HasM | false |
HasZ | false |
HasAttachments | false |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
assettype | SmallInteger | 2 | Asset type | assettype | Asset_Type_Water_Device_Service_Valve | | false | | |
creationdate | Date | 8 | Creation date | creationdate | | | true | | |
creator | String | 255 | Creator | creator | | | true | | |
lastupdate | Date | 8 | Last update | lastupdate | | | true | | |
updatedby | String | 255 | Updated by | updatedby | | | true | | |
globalid | GlobalID | 38 | Global ID | globalid | | | false | | |
diameter | Double | 8 | Diameter | diameter | Water_Diameter | | true | | |
designtype | SmallInteger | 2 | Valve Type | designtype | Water_Valve_Type | | true | | |
normalstatus | SmallInteger | 2 | Normal Status | normalstatus | Pipe_Device_Status_Combined | | false | | |
presentstatus | SmallInteger | 2 | Present Status | presentstatus | Pipe_Device_Status_Combined | | false | | |
additionaldetails | SmallInteger | 2 | Clockwise to Close | additionaldetails | Pipeline_Valve_Close_Direction | | true | | |
designinfo | Double | 8 | Turns to Close | designinfo | | | true | | |
operable | SmallInteger | 2 | Operable | operable | Boolean | | false | | |
name | String | 64 | Name | name | | | true | | |
installdate | Date | 8 | Install Date | installdate | | | true | | |
assetid | String | 64 | Asset ID | assetid | | | true | | |
ownedby | SmallInteger | 2 | Owned By | ownedby | Asset_Owner | | true | | |
maintby | SmallInteger | 2 | Maintained By | maintby | Asset_Manager | | true | | |
additionaldevice | SmallInteger | 2 | Has Bypass | additionaldevice | Yes_No | | true | | |
notes | String | 2000 | Notes | notes | | | true | | |
symbolrotation | SmallInteger | 2 | Symbol Rotation | symbolrotation | Symbol_Rotation | | true | | |
lastmaint | Date | 8 | Last Maintenance | lastmaint | | | true | | |
lifecyclestatus | SmallInteger | 2 | Lifecycle Status | lifecyclestatus | Lifecycle_Combined | | false | | |
ESRIGNSS_RECEIVER | String | 50 | Receiver Name | ESRIGNSS_RECEIVER | | | true | | |
ESRIGNSS_H_RMS | Double | 8 | Horizontal Accuracy (m) | ESRIGNSS_H_RMS | | | true | | |
ESRIGNSS_V_RMS | Double | 8 | Vertical Accuracy (m) | ESRIGNSS_V_RMS | | | true | | |
ESRIGNSS_LATITUDE | Double | 8 | Latitude | ESRIGNSS_LATITUDE | | | true | | |
ESRIGNSS_LONGITUDE | Double | 8 | Longitude | ESRIGNSS_LONGITUDE | | | true | | |
ESRIGNSS_ALTITUDE | Double | 8 | Altitude | ESRIGNSS_ALTITUDE | | | true | | |
ESRIGNSS_PDOP | Double | 8 | PDOP | ESRIGNSS_PDOP | | | true | | |
ESRIGNSS_HDOP | Double | 8 | HDOP | ESRIGNSS_HDOP | | | true | | |
ESRIGNSS_VDOP | Double | 8 | VDOP | ESRIGNSS_VDOP | | | true | | |
ESRIGNSS_FIXTYPE | SmallInteger | 2 | Fix Type | ESRIGNSS_FIXTYPE | ESRI_FIX_TYPE_DOMAIN | | true | | |
ESRIGNSS_CORRECTIONAGE | Double | 8 | Correction Age | ESRIGNSS_CORRECTIONAGE | | | true | | |
ESRIGNSS_STATIONID | SmallInteger | 2 | Station ID | ESRIGNSS_STATIONID | ESRI_STATION_ID_DOMAIN | | true | | |
ESRIGNSS_NUMSATS | SmallInteger | 2 | Number of Satellites | ESRIGNSS_NUMSATS | ESRI_NUM_SATS_DOMAIN | | true | | |
ESRIGNSS_FIXDATETIME | Date | 8 | Fix Time | ESRIGNSS_FIXDATETIME | | | true | | |
ESRIGNSS_AVG_H_RMS | Double | 8 | Average Horizontal Accuracy (m) | ESRIGNSS_AVG_H_RMS | | | true | | |
ESRIGNSS_AVG_V_RMS | Double | 8 | Average Vertical Accuracy (m) | ESRIGNSS_AVG_V_RMS | | | true | | |
ESRIGNSS_AVG_POSITIONS | SmallInteger | 2 | Averaged Positions | ESRIGNSS_AVG_POSITIONS | | | true | | |
ESRIGNSS_H_STDDEV | Double | 8 | Standard Deviation (m) | ESRIGNSS_H_STDDEV | | | true | | |
Asset_Manager - Domain
DomainName | Asset_Manager |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
1 | Our Agency |
2 | Private |
100 | Other |
Asset_Owner - Domain
DomainName | Asset_Owner |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
1 | Our Agency |
2 | Private |
100 | Other |
Asset_Type_Water_Assembly_Meter_Station - Domain
DomainName | Asset_Type_Water_Assembly_Meter_Station |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
81 | Meter Station |
Asset_Type_Water_Device_Meter - Domain
DomainName | Asset_Type_Water_Device_Meter |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
41 | Bulk |
42 | Commercial |
43 | DMA |
44 | Emergency Connection |
45 | Industrial |
46 | Master |
47 | Pump Station |
48 | Residential |
Asset_Type_Water_Device_Service_Connection - Domain
DomainName | Asset_Type_Water_Device_Service_Connection |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
61 | Commercial |
62 | Fire |
63 | Industrial |
64 | Irrigation |
65 | Residential |
Asset_Type_Water_Device_Service_Valve - Domain
DomainName | Asset_Type_Water_Device_Service_Valve |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
176 | Service |
Asset_Type_Water_Line_Air_&_Vacuum_Service - Domain
DomainName | Asset_Type_Water_Line_Air_&_Vacuum_Service |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
83 | Cast Iron - CAS |
84 | Copper - COP |
88 | Ductile Iron - DIP |
94 | Polyvinyl Chloride - PVC |
Asset_Type_Water_Line_Blow_Off_Service - Domain
DomainName | Asset_Type_Water_Line_Blow_Off_Service |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
83 | Cast Iron - CAS |
84 | Copper - COP |
88 | Ductile Iron - DIP |
94 | Polyvinyl Chloride - PVC |
Asset_Type_Water_Line_Commercial_Service - Domain
DomainName | Asset_Type_Water_Line_Commercial_Service |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
83 | Cast Iron - CAS |
84 | Copper - COP |
88 | Ductile Iron - DIP |
94 | Polyvinyl Chloride - PVC |
Asset_Type_Water_Line_Fire_Service - Domain
DomainName | Asset_Type_Water_Line_Fire_Service |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
83 | Cast Iron - CAS |
84 | Copper - COP |
88 | Ductile Iron - DIP |
94 | Polyvinyl Chloride - PVC |
Asset_Type_Water_Line_Industrial_Service - Domain
DomainName | Asset_Type_Water_Line_Industrial_Service |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
83 | Cast Iron - CAS |
84 | Copper - COP |
88 | Ductile Iron - DIP |
94 | Polyvinyl Chloride - PVC |
Asset_Type_Water_Line_Irrigation_Service - Domain
DomainName | Asset_Type_Water_Line_Irrigation_Service |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
83 | Cast Iron - CAS |
84 | Copper - COP |
88 | Ductile Iron - DIP |
94 | Polyvinyl Chloride - PVC |
Asset_Type_Water_Line_Residential_Service - Domain
DomainName | Asset_Type_Water_Line_Residential_Service |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
83 | Cast Iron - CAS |
84 | Copper - COP |
88 | Ductile Iron - DIP |
94 | Polyvinyl Chloride - PVC |
Asset_Type_Water_Line_Sampling_Service - Domain
DomainName | Asset_Type_Water_Line_Sampling_Service |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
83 | Cast Iron - CAS |
84 | Copper - COP |
88 | Ductile Iron - DIP |
94 | Polyvinyl Chloride - PVC |
Boolean - Domain
DomainName | Boolean |
FieldType | SmallInteger |
Domain Type | CodedValue |
ESRI_FIX_TYPE_DOMAIN - Domain
DomainName | ESRI_FIX_TYPE_DOMAIN |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Fix not valid |
1 | GPS |
2 | Differential GPS |
4 | RTK Fixed |
5 | RTK Float |
ESRI_NUM_SATS_DOMAIN - Domain
DomainName | ESRI_NUM_SATS_DOMAIN |
FieldType | SmallInteger |
Domain Type | Range |
Minimum Value | Maximum Value |
0 | 99 |
ESRI_STATION_ID_DOMAIN - Domain
DomainName | ESRI_STATION_ID_DOMAIN |
FieldType | SmallInteger |
Domain Type | Range |
Minimum Value | Maximum Value |
0 | 1023 |
Lifecycle_Combined - Domain
DomainName | Lifecycle_Combined |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
1 | Proposed |
2 | Approved |
3 | Proposed and Approved |
4 | Under Construction |
6 | Approved and Under Construction |
7 | Proposed, Approved and Under Construction |
8 | In Service |
12 | In Service and Under Construction |
14 | In Service, Under Construction, and Approved |
15 | In Service, Under Construction, Approved and Proposed |
16 | To Be Retired |
24 | In Service and To Be Retired |
32 | Abandoned |
Pipe_Device_Status_Combined - Domain
DomainName | Pipe_Device_Status_Combined |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Closed |
1 | Open |
2 | Inactive |
3 | Active |
Pipeline_Valve_Close_Direction - Domain
DomainName | Pipeline_Valve_Close_Direction |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Counter Clockwise |
1 | Clockwise |
Symbol_Rotation - Domain
DomainName | Symbol_Rotation |
FieldType | SmallInteger |
Domain Type | Range |
Minimum Value | Maximum Value |
0 | 359 |
Water_Diameter - Domain
DomainName | Water_Diameter |
FieldType | Double |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
0.5 | 1/2" |
0.75 | 3/4" |
1 | 1" |
1.25 | 1 1/4" |
1.5 | 1 1/2" |
2 | 2" |
2.5 | 2 1/2" |
3 | 3" |
4 | 4" |
6 | 6" |
8 | 8" |
10 | 10" |
12 | 12" |
14 | 14" |
15 | 15" |
16 | 16" |
18 | 18" |
20 | 20" |
24 | 24" |
30 | 30" |
36 | 36" |
40 | 40" |
42 | 42" |
48 | 48" |
54 | 54" |
60 | 60" |
66 | 66" |
72 | 72" |
75 | 75" |
Water_Service_Diameter - Domain
DomainName | Water_Service_Diameter |
FieldType | Double |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
0.75 | 3/4" |
1 | 1" |
1.25 | 1 1/4" |
1.5 | 1 1/2" |
2 | 2" |
2.25 | 2 1/4" |
2.5 | 2 1/2" |
3 | 3" |
4 | 4" |
4.5 | 4 1/2" |
5.25 | 5 1/4" |
6 | 6" |
8 | 8" |
10 | 10" |
0.5 | 1/2" |
Water_Valve_Type - Domain
DomainName | Water_Valve_Type |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
|
0 | Unknown |
20 | Ball |
21 | Butterfly |
22 | Cone |
23 | Gate |
24 | Plug |
Yes_No - Domain
DomainName | Yes_No |
FieldType | SmallInteger |
Domain Type | CodedValue |