View In:   ArcGIS Online Map Viewer

Name: GIS.DBO.wMain

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: 2826789.336709723
YMin: 1652628.8677669764
XMax: 2842228.683455631
YMax: 1675528.017834723
Spatial Reference: 102654  (2232)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: DIAMETER
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 4
  Label: 4"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [214, 214, 255, 255]
  Width: 1
• Value: 6
  Label: 6"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [158, 164, 232, 255]
  Width: 1
• Value: 8
  Label: 8"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [108, 125, 212, 255]
  Width: 1
• Value: 10
  Label: 10"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [64, 93, 189, 255]
  Width: 1
• Value: 12
  Label: 12"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [29, 73, 168, 255]
  Width: 1
• Value: 36
  Label: 36"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 57, 148, 255]
  Width: 1
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: DIAMETER

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MATERIAL , Coded Values: [PVC: Polyvinyl Chloride] , [RPM: Reinforced Plastic (Truss)] , [SDR35: SDR 35] , ...6 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0: Others] , [0.75: .75"] , [1: 1"] , ...7 more... )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WATERTYPE , Coded Values: [Potable: Potable Water] , [Raw: Raw Water] , [Reclaimed: Reclaimed Water] , ...3 more... )
• TRANSMISS ( type: esriFieldTypeString, alias: Transmission System, editable: true, nullable: true, length: 5, defaultValue: null, modelName: TRANSMISS , Coded Values: [Yes: Yes] , [No: No] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: null, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: null, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: OWNEDBY , Coded Values: [-1: Private] , [-2: Other] , [1: TOS] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: null, modelName: MAINTBY , Coded Values: [-1: Private] , [-2: Other] , [1: TOS] )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• DATASOURCE ( type: esriFieldTypeString, alias: Data Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DATASOURCE , Coded Values: [Aerial Imagery: Aerial Imagery] , [As-Builts/Construction Drawings: As-Builts/Construction Drawings] , [CAD: CAD] , ...4 more... )
• GPSACCURACY ( type: esriFieldTypeString, alias: GPS Accuracy, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GPSACCURACY )
• FIELDNOTES ( type: esriFieldTypeString, alias: Field Notes, editable: true, nullable: true, length: 150, defaultValue: null, modelName: FIELDNOTES )
• CREATEDATE ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATEDATE )
• CREATEUSER ( type: esriFieldTypeString, alias: Created By, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CREATEUSER )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• PressureZone ( type: esriFieldTypeString, alias: PressureZone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PressureZone , Coded Values: [Low(S): Low(S)] , [Low(N): Low(N)] , [L MCR: L MCR] , ...5 more... )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
• Length ( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )

Types:

ID: 4
Name: 4"
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WATERTYPE:
  Inherited
• TRANSMISS:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• DATASOURCE:
  Inherited
• PressureZone:
  Inherited
Templates:
• Name: 4"
  Description:
  Prototype:
  MATERIAL: null
  PressureZone: null
  FACILITYID: null
  INSTALLDATE: null
  DIAMETER: 4
  WATERTYPE: null
  TRANSMISS: null
  ENABLED: null
  ACTIVEFLAG: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  DATASOURCE: null
  GPSACCURACY: null
  FIELDNOTES: null
  CREATEDATE: null
  CREATEUSER: null
  Length: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 6
Name: 6"
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WATERTYPE:
  Inherited
• TRANSMISS:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• DATASOURCE:
  Inherited
• PressureZone:
  Inherited
Templates:
• Name: 6"
  Description:
  Prototype:
  MATERIAL: null
  PressureZone: null
  FACILITYID: null
  INSTALLDATE: null
  DIAMETER: 6
  WATERTYPE: null
  TRANSMISS: null
  ENABLED: null
  ACTIVEFLAG: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  DATASOURCE: null
  GPSACCURACY: null
  FIELDNOTES: null
  CREATEDATE: null
  CREATEUSER: null
  Length: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 8
Name: 8"
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WATERTYPE:
  Inherited
• TRANSMISS:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• DATASOURCE:
  Inherited
• PressureZone:
  Inherited
Templates:
• Name: 8"
  Description:
  Prototype:
  MATERIAL: null
  PressureZone: null
  FACILITYID: null
  INSTALLDATE: null
  DIAMETER: 8
  WATERTYPE: null
  TRANSMISS: null
  ENABLED: null
  ACTIVEFLAG: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  DATASOURCE: null
  GPSACCURACY: null
  FIELDNOTES: null
  CREATEDATE: null
  CREATEUSER: null
  Length: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 10
Name: 10"
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WATERTYPE:
  Inherited
• TRANSMISS:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• DATASOURCE:
  Inherited
• PressureZone:
  Inherited
Templates:
• Name: 10"
  Description:
  Prototype:
  MATERIAL: null
  PressureZone: null
  FACILITYID: null
  INSTALLDATE: null
  DIAMETER: 10
  WATERTYPE: null
  TRANSMISS: null
  ENABLED: null
  ACTIVEFLAG: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  DATASOURCE: null
  GPSACCURACY: null
  FIELDNOTES: null
  CREATEDATE: null
  CREATEUSER: null
  Length: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 12
Name: 12"
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WATERTYPE:
  Inherited
• TRANSMISS:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• DATASOURCE:
  Inherited
• PressureZone:
  Inherited
Templates:
• Name: 12"
  Description:
  Prototype:
  MATERIAL: null
  PressureZone: null
  FACILITYID: null
  INSTALLDATE: null
  DIAMETER: 12
  WATERTYPE: null
  TRANSMISS: null
  ENABLED: null
  ACTIVEFLAG: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  DATASOURCE: null
  GPSACCURACY: null
  FIELDNOTES: null
  CREATEDATE: null
  CREATEUSER: null
  Length: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 36
Name: 36"
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• WATERTYPE:
  Inherited
• TRANSMISS:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• DATASOURCE:
  Inherited
• PressureZone:
  Inherited
Templates:
• Name: 36"
  Description:
  Prototype:
  MATERIAL: null
  PressureZone: null
  FACILITYID: null
  INSTALLDATE: null
  DIAMETER: 36
  WATERTYPE: null
  TRANSMISS: null
  ENABLED: null
  ACTIVEFLAG: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  DATASOURCE: null
  GPSACCURACY: null
  FIELDNOTES: null
  CREATEDATE: null
  CREATEUSER: null
  Length: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata