View In:   ArcGIS Online Map Viewer

Name: Water Main Labels

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

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

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [240, 240, 240, 0]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [DIAMETER] CONCAT "''"
Use Coded Values: true
Symbol:
Color: [0, 77, 168, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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: true
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GEODBID ( type: esriFieldTypeString, alias: GEODBID, editable: true, nullable: true, length: 3, defaultValue: 999, modelName: GEODBID , Coded Values: [001: CHP] , [002: VGC] , [003: CPR] , ...82 more... )
• FEATUREID ( type: esriFieldTypeString, alias: FEATUREID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FEATUREID )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATEMODIFIED )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SOURCE )
• SOURCETYPE ( type: esriFieldTypeString, alias: SOURCETYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SOURCETYPE , Coded Values: [ASBUILT: As-built] , [DATABASE: Database] , [ESTIMATED: Estimated] , ...12 more... )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• INSTALLDATE ( type: esriFieldTypeDate, alias: InstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 20, defaultValue: UNKNOWN, modelName: LifecycleStatus , Coded Values: [ABANDONED: Abandoned] , [ACTIVE: Active] , [PROPOSED: Proposed] , ...2 more... )
• SUBTYPE ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 0, modelName: Subtype )
• WATERTYPE ( type: esriFieldTypeString, alias: WaterType, editable: true, nullable: true, length: 255, defaultValue: POTABLE, modelName: WaterType , Coded Values: [COMBINED: Combined Waste Water] , [EFFLUENT: Waste Water Effluent] , [POTABLE: Potable Water] , ...6 more... )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 255, defaultValue: UNK, modelName: Material , Coded Values: [ABS: Acrylonitrile Butadiene Styrene] , [AC: Asbestos Concrete] , [BRK: Brick] , ...20 more... )
• EXTERIORCOATING ( type: esriFieldTypeString, alias: ExteriorCoating, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ExteriorCoating )
• LININGTYPE ( type: esriFieldTypeString, alias: LiningType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LiningType )
• PIPECLASS ( type: esriFieldTypeString, alias: PipeClass, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PipeClass )
• ROUGHNESS ( type: esriFieldTypeDouble, alias: Roughness, editable: true, nullable: true, defaultValue: null, modelName: Roughness )
• PIPEID ( type: esriFieldTypeInteger, alias: PipeID, editable: true, nullable: true, defaultValue: null, modelName: PIPEID )
• COMMUNITYID ( type: esriFieldTypeString, alias: CommunityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: COMMUNITYID )
• OWNERSHIP ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 9, defaultValue: null, modelName: OWNERSHIP , Coded Values: [ADT: Addison Township] , [ATP: Antioch Township] , [AIL: Aqua Illinois] , ...212 more... )
• MAINTAINED ( type: esriFieldTypeString, alias: Maintained, editable: true, nullable: true, length: 9, defaultValue: null, modelName: MAINTAINED , Coded Values: [ADT: Addison Township] , [ATP: Antioch Township] , [AIL: Aqua Illinois] , ...212 more... )
• DESCRIPTION ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DESCRIPTION )
• MEASURELENGTH ( type: esriFieldTypeDouble, alias: MeasureLength, editable: true, nullable: true, defaultValue: null, modelName: MEASURELENGTH )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• REPLICAFILTER ( type: esriFieldTypeString, alias: REPLICAFILTER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REPLICAFILTER )
• PRODUCTIONNOTES ( type: esriFieldTypeString, alias: PRODUCTIONNOTES, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PRODUCTIONNOTES )
• WEBLINK ( type: esriFieldTypeString, alias: WEBLINK, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WEBLINK )
• CREATEDBY ( type: esriFieldTypeString, alias: CREATEDBY, editable: false, nullable: true, length: 100, defaultValue: null, modelName: CREATEDBY )
• MODIFIEDBY ( type: esriFieldTypeString, alias: MODIFIEDBY, editable: false, nullable: true, length: 100, defaultValue: null, modelName: MODIFIEDBY )
• DATEABANDONED ( type: esriFieldTypeDate, alias: DATEABANDONED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEABANDONED )
• DATELINED ( type: esriFieldTypeDate, alias: DATELINED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATELINED )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATIONDESCRIPTION )
• OWNERSHIPDESCRIPTION ( type: esriFieldTypeString, alias: OWNERSHIPDESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNERSHIPDESCRIPTION )
• MAINTAINEDDESCRIPTION ( type: esriFieldTypeString, alias: MAINTAINEDDESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINTAINEDDESCRIPTION )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )
• JOINTTYPE1 ( type: esriFieldTypeString, alias: JointType1, editable: true, nullable: true, length: 20, defaultValue: UNK, modelName: JointType1 , Coded Values: [BOND: BOND] , [FLANGE: FLANGE] , [OTH: OTHER] , ...2 more... )
• JOINTTYPE2 ( type: esriFieldTypeString, alias: JointType2, editable: true, nullable: true, length: 20, defaultValue: UNK, modelName: JointType2 , Coded Values: [BOND: BOND] , [FLANGE: FLANGE] , [OTH: OTHER] , ...2 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Diameter )
• GROUNDSURFACETYPE ( type: esriFieldTypeString, alias: GroundSurfaceType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GroundSurfaceType )
• PRESSURERATING ( type: esriFieldTypeString, alias: PressureRating, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PressureRating )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH, editable: true, nullable: true, defaultValue: null, modelName: DEPTH )
• DEADEND ( type: esriFieldTypeSmallInteger, alias: DEADEND, editable: true, nullable: true, defaultValue: 0, modelName: DEADEND , Coded Values: [0: False] , [1: True] )
• HASTRACERWIRE ( type: esriFieldTypeSmallInteger, alias: HASTRACERWIRE, editable: true, nullable: true, defaultValue: 0, modelName: HASTRACERWIRE , Coded Values: [0: No] , [1: Yes] )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_ALTITUDE )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LONGITUDE )
• QANOTES ( type: esriFieldTypeString, alias: QA Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: QANOTES )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_V_RMS )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_V_RMS )
• FIELDVERIFICATIONSTATUS ( type: esriFieldTypeString, alias: Field Verification Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FIELDVERIFICATIONSTATUS , Coded Values: [CNL: Cannot Locate] , [CAN: Cannot Access] , [TODO: To Do] , ...2 more... )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LATITUDE )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_FIXTYPE , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential] , ...2 more... )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_H_RMS )
• QASTATUS ( type: esriFieldTypeString, alias: QA Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: QASTATUS , Coded Values: [RAW: Raw] , [CCN: Community Check Needed] , [COMPLETE: Complete] , ...1 more... )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_H_RMS )
• FIELDVERIFICATIONNOTES ( type: esriFieldTypeString, alias: Field Verification Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FIELDVERIFICATIONNOTES )
• RISKSCORE ( type: esriFieldTypeDouble, alias: RISKSCORE, editable: true, nullable: true, defaultValue: null, modelName: RISKSCORE )
• ERP_CW_LastInspected ( type: esriFieldTypeDate, alias: CityWorks - Last Inspected Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ERP_CW_LastInspected )
• ERP_CW_LastRepaired ( type: esriFieldTypeDate, alias: CityWorks - Last Repaired Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ERP_CW_LastRepaired )
• ERP_CW_Score ( type: esriFieldTypeDouble, alias: CityWorks - Score, editable: true, nullable: true, defaultValue: null, modelName: ERP_CW_Score )
• ERP_CW_NearestAddress ( type: esriFieldTypeString, alias: CityWorks - Nearest Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ERP_CW_NearestAddress )
• ERP_CW_Cycle ( type: esriFieldTypeString, alias: CityWorks - Maintenance Cycle, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ERP_CW_Cycle )
• ERP_CW_POF ( type: esriFieldTypeDouble, alias: CityWorks - Probability of Failure, editable: true, nullable: true, defaultValue: null, modelName: ERP_CW_POF )
• ERP_CW_COF ( type: esriFieldTypeDouble, alias: CityWorks - Consequence of Failure, editable: true, nullable: true, defaultValue: null, modelName: ERP_CW_COF )
• ERP_CW_BRE ( type: esriFieldTypeDouble, alias: CityWorks - Business Risk Exposure, editable: true, nullable: true, defaultValue: null, modelName: ERP_CW_BRE )
• ERP_CW_MSPU ( type: esriFieldTypeDouble, alias: CityWorks - Under-maintained Proactive Maintenance Score, editable: true, nullable: true, defaultValue: null, modelName: ERP_CW_MSPU )
• ERP_CW_MSPO ( type: esriFieldTypeDouble, alias: CityWorks - Over-maintained Proactive Maintenance Score, editable: true, nullable: true, defaultValue: null, modelName: ERP_CW_MSPO )
• ERP_CW_MSR ( type: esriFieldTypeDouble, alias: CityWorks - Reactive Maintenance Score, editable: true, nullable: true, defaultValue: null, modelName: ERP_CW_MSR )
• ERP_CW_AVERAGEENDYEAR ( type: esriFieldTypeSmallInteger, alias: CityWorks - Average End Year, editable: true, nullable: true, defaultValue: null, modelName: ERP_CW_AVERAGEENDYEAR )
• ERP_CW_FASTENDYEAR ( type: esriFieldTypeSmallInteger, alias: CityWorks - Fast End Year, editable: true, nullable: true, defaultValue: null, modelName: ERP_CW_FASTENDYEAR )
• ERP_CW_SLOWENDYEAR ( type: esriFieldTypeSmallInteger, alias: CityWorks - Slow End Year, editable: true, nullable: true, defaultValue: null, modelName: ERP_CW_SLOWENDYEAR )
• ERP_CW_CALCULATIONNAME ( type: esriFieldTypeString, alias: CityWorks - Calculation Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ERP_CW_CALCULATIONNAME )
• ERP_CW_DATECALCULATED ( type: esriFieldTypeDate, alias: CityWorks - Date Calculated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ERP_CW_DATECALCULATED )
• ERP_CW_MAINTZONE ( type: esriFieldTypeString, alias: CityWorks - Maintenance Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ERP_CW_MAINTZONE )

Templates:

• Name: Water Main Labels
  Description:
  Prototype:
  LIFECYCLESTATUS: UNKNOWN
  ERP_CW_DATECALCULATED: null
  GEODBID: 999
  FEATUREID: null
  ERP_CW_SLOWENDYEAR: null
  ERP_CW_FASTENDYEAR: null
  SOURCE: null
  SOURCETYPE: null
  Enabled: 1
  INSTALLDATE: null
  SUBTYPE: 0
  WATERTYPE: POTABLE
  MATERIAL: UNK
  EXTERIORCOATING: null
  LININGTYPE: null
  PIPECLASS: null
  ROUGHNESS: null
  PIPEID: null
  COMMUNITYID: null
  OWNERSHIP: null
  MAINTAINED: null
  DESCRIPTION: null
  MEASURELENGTH: null
  ERP_CW_MAINTZONE: null
  REPLICAFILTER: UNSET
  PRODUCTIONNOTES: null
  WEBLINK: null
  ERP_CW_AVERAGEENDYEAR: null
  ERP_CW_MSR: null
  DATEABANDONED: null
  DATELINED: null
  LOCATIONDESCRIPTION: null
  OWNERSHIPDESCRIPTION: null
  MAINTAINEDDESCRIPTION: null
  ERP_CW_CALCULATIONNAME: null
  JOINTTYPE1: UNK
  JOINTTYPE2: UNK
  DIAMETER: null
  GROUNDSURFACETYPE: null
  PRESSURERATING: null
  DEPTH: null
  DEADEND: null
  HASTRACERWIRE: null
  ESRIGNSS_ALTITUDE: null
  ESRIGNSS_LONGITUDE: null
  QANOTES: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_V_RMS: null
  FIELDVERIFICATIONSTATUS: null
  ESRIGNSS_LATITUDE: null
  ESRIGNSS_FIXTYPE: null
  ESRIGNSS_AVG_H_RMS: null
  QASTATUS: null
  ESRIGNSS_H_RMS: null
  FIELDVERIFICATIONNOTES: null
  RISKSCORE: null
  ERP_CW_LastInspected: null
  ERP_CW_LastRepaired: null
  ERP_CW_Score: null
  ERP_CW_NearestAddress: null
  ERP_CW_Cycle: null
  ERP_CW_POF: null
  ERP_CW_COF: null
  ERP_CW_BRE: null
  ERP_CW_MSPU: null
  ERP_CW_MSPO: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: DATECREATED
• Creator Field: CREATEDBY
• Edit Date Field: DATEMODIFIED
• Editor Field: MODIFIEDBY

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata