Name: Water Mains - Private

Display Field: GEODBID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: OBJECTID: System-generated unique identifier for each record within the feature classShape: System-generated geometry type of the featureGEODBID: Three-digit code that assigns editing responsibility to a community in the GIS ConsortiumFEATUREID: GIS-Consortium-generated unique identifier for each record within the feature class. All FEATUREIDs start with the GEODBID of the community that owns the recordDATECREATED: Date/time stamp from the moment the GIS record was createdDATEMODIFIED: Date/time stamp from the last moment the GIS record was changedSOURCE: Organization that provided the data. The GIS Consortium standard is to preface the source with the three-letter municipal code of the community providing the data, followed by a dash. Example: VGV-Public WorksSOURCETYPE: Accuracy context for the recordEnabled: Boolean field to indicate whether water is allowed to flow through this featureADMINISTRATIVEAREA: Owner of the area in which the feature is locatedINSTALLDATE: Date of installation for the real-world feature represented in the feature classOPERATIONALAREA: Retired field used to store a description for an operational area designated by a communityLIFECYCLESTATUS: Current state of the real-world featureSUBTYPE:Additional designation of the feature.WORKORDERID: Unique work order identifierFLOWMEASUREMENTID: Discharge rate; measured in cubic feet per second unless otherwise indicatedWATERTYPE: Designation of water distribution or collection system to which the feature appliesMATERIAL: Matter composition of the featureEXTERIORCOATING: Material used to coat the outside of the pipeJOINTTYPE1: Type of connection between the structure and the pipeJOINTTYPE2: Type of connection between the structure and the pipeLININGTYPE: The lining type (interior coating) of the featurePIPECLASS: The class rating of the featureROUGHNESS: The roughness coefficient of the featureDIAMETER: Width of the real-world feature represented in the feature class; measured in inchesGROUNDSURFACETYPE: The type of ground surface over the featurePRESSURERATING: The pressure rating of the feature; measured in pounds per square inch (PSI)LEGACYTYPE: Retired GIS tracking code for the featurePIPEID: Retired GIS tracking identification number for the featureCOMMUNITYID: Unique identifying code selected by the communityOWNERSHIP: Organization with jurisdiction over the real-world feature represented in the feature classMAINTAINED: Organization responsible for the care of the real-world feature represented in the feature classDESCRIPTION: Statement illustrating the featureFID_WSEDGEANNO_LINE: Unique identifier that can be joined to the FEATUREID field of the wsEdgeAnno_LINE feature class to provide a link between and edge an its labelCATEGORY: Retired field required for ArcGIS coverage modelsMEASURELENGTH: Length of the pipe; measured in feetDEPTH: The distance from the bottom of the structure and the ground surface above; measured in feetREPLICAFILTER: Code used to filter data for the creation of custom geodatabases PRODUCTIONNOTES: Technical notes from GIS personnelWEBLINK: URL for a website related to the recordDEADEND: Boolean field to indicate the presence of a dead endDATEABANDONED: Date of abandonment for the real-world feature represented in the feature classDATELINED: Date when the feature was lined to extend the life of the assetHASTRACERWIRE: Designation if the feature has a tracer wire used for locating underground features.Shape_Length: System-generated length of the featureGlobalID: System-generated unique identifier for each record that is required in replicated geodatabasesLOCATIONDESCRIPTION: Statement illustrating the whereabouts of a feature

Copyright Text: Created by the GIS Consortium's members with ongoing updates.

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 12000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -17463800
YMin: -46132600
XMax: 1255931.7962500006
YMax: 2102908.134999998
Spatial Reference: 102671  (3435)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LIFECYCLESTATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: ABANDONED
  Label: Abandoned
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [168, 0, 132, 255]
  Width: 2
• Value: ACTIVE
  Label: Active
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [168, 0, 132, 255]
  Width: 2
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GEODBID ( type: esriFieldTypeString, alias: GEODBID, length: 3 )
• FEATUREID ( type: esriFieldTypeString, alias: FEATUREID, length: 15 )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, length: 8 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, length: 8 )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 20 )
• SOURCETYPE ( type: esriFieldTypeString, alias: SOURCETYPE, length: 20 )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled )
• INSTALLDATE ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LifecycleStatus, length: 20 )
• SUBTYPE ( type: esriFieldTypeInteger, alias: Subtype )
• WATERTYPE ( type: esriFieldTypeString, alias: WaterType, length: 255 )
• MATERIAL ( type: esriFieldTypeString, alias: Material, length: 255 )
• EXTERIORCOATING ( type: esriFieldTypeString, alias: ExteriorCoating, length: 20 )
• JOINTTYPE1 ( type: esriFieldTypeString, alias: JointType1, length: 20 )
• JOINTTYPE2 ( type: esriFieldTypeString, alias: JointType2, length: 20 )
• LININGTYPE ( type: esriFieldTypeString, alias: LiningType, length: 20 )
• PIPECLASS ( type: esriFieldTypeString, alias: PipeClass, length: 20 )
• ROUGHNESS ( type: esriFieldTypeDouble, alias: Roughness )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter )
• GROUNDSURFACETYPE ( type: esriFieldTypeString, alias: GroundSurfaceType, length: 20 )
• PRESSURERATING ( type: esriFieldTypeString, alias: PressureRating, length: 20 )
• PIPEID ( type: esriFieldTypeInteger, alias: PipeID )
• COMMUNITYID ( type: esriFieldTypeString, alias: CommunityID, length: 20 )
• OWNERSHIP ( type: esriFieldTypeString, alias: Ownership, length: 9 )
• MAINTAINED ( type: esriFieldTypeString, alias: Maintained, length: 9 )
• DESCRIPTION ( type: esriFieldTypeString, alias: Description, length: 255 )
• MEASURELENGTH ( type: esriFieldTypeDouble, alias: MeasureLength )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• REPLICAFILTER ( type: esriFieldTypeString, alias: REPLICAFILTER, length: 255 )
• PRODUCTIONNOTES ( type: esriFieldTypeString, alias: PRODUCTIONNOTES, length: 100 )
• WEBLINK ( type: esriFieldTypeString, alias: WEBLINK, length: 255 )
• DEADEND ( type: esriFieldTypeSmallInteger, alias: DEADEND )
• CREATEDBY ( type: esriFieldTypeString, alias: CREATEDBY, length: 100 )
• MODIFIEDBY ( type: esriFieldTypeString, alias: MODIFIEDBY, length: 100 )
• DATEABANDONED ( type: esriFieldTypeDate, alias: DATEABANDONED, length: 8 )
• DATELINED ( type: esriFieldTypeDate, alias: DATELINED, length: 8 )
• HASTRACERWIRE ( type: esriFieldTypeSmallInteger, alias: HASTRACERWIRE )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, length: 255 )
• OWNERSHIPDESCRIPTION ( type: esriFieldTypeString, alias: OWNERSHIPDESCRIPTION, length: 50 )
• MAINTAINEDDESCRIPTION ( type: esriFieldTypeString, alias: MAINTAINEDDESCRIPTION, length: 50 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• QANOTES ( type: esriFieldTypeString, alias: QA Notes, length: 255 )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m) )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m) )
• FIELDVERIFICATIONSTATUS ( type: esriFieldTypeString, alias: Field Verification Status, length: 10 )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m) )
• QASTATUS ( type: esriFieldTypeString, alias: QA Status, length: 10 )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m) )
• FIELDVERIFICATIONNOTES ( type: esriFieldTypeString, alias: Field Verification Notes, length: 255 )
• RISKSCORE ( type: esriFieldTypeDouble, alias: RISKSCORE )
• ERP_CW_LastInspected ( type: esriFieldTypeDate, alias: CityWorks - Last Inspected Date, length: 8 )
• ERP_CW_LastRepaired ( type: esriFieldTypeDate, alias: CityWorks - Last Repaired Date, length: 8 )
• ERP_CW_Score ( type: esriFieldTypeDouble, alias: CityWorks - Score )
• ERP_CW_NearestAddress ( type: esriFieldTypeString, alias: CityWorks - Nearest Address, length: 50 )
• ERP_CW_Cycle ( type: esriFieldTypeString, alias: CityWorks - Maintenance Cycle, length: 50 )
• ERP_CW_POF ( type: esriFieldTypeDouble, alias: CityWorks - Probability of Failure )
• ERP_CW_COF ( type: esriFieldTypeDouble, alias: CityWorks - Consequence of Failure )
• ERP_CW_BRE ( type: esriFieldTypeDouble, alias: CityWorks - Business Risk Exposure )
• ERP_CW_MSPU ( type: esriFieldTypeDouble, alias: CityWorks - Under-maintained Proactive Maintenance Score )
• ERP_CW_MSPO ( type: esriFieldTypeDouble, alias: CityWorks - Over-maintained Proactive Maintenance Score )
• ERP_CW_MSR ( type: esriFieldTypeDouble, alias: CityWorks - Reactive Maintenance Score )
• ERP_CW_AVERAGEENDYEAR ( type: esriFieldTypeSmallInteger, alias: CityWorks - Average End Year )
• ERP_CW_FASTENDYEAR ( type: esriFieldTypeSmallInteger, alias: CityWorks - Fast End Year )
• ERP_CW_SLOWENDYEAR ( type: esriFieldTypeSmallInteger, alias: CityWorks - Slow End Year )
• ERP_CW_CALCULATIONNAME ( type: esriFieldTypeString, alias: CityWorks - Calculation Name, length: 50 )
• ERP_CW_DATECALCULATED ( type: esriFieldTypeDate, alias: CityWorks - Date Calculated, length: 8 )
• ERP_CW_MAINTZONE ( type: esriFieldTypeString, alias: CityWorks - Maintenance Zone, length: 50 )

Relationships:

• has wsPressMainBreak_POINT (2) -- Related To: Water Main Break (65)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata