View In:   ArcGIS Online Map Viewer

Name: Water Pressurized Main

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 2d85a562a7754180ac60e9550eefb375

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 311813.61763499986
YMin: 5770735.9559349995
XMax: 720045.2868650004
YMax: 6178967.625165001
Spatial Reference: 26910  (26910)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ASSETGROUP
Field 2: ASSETTYPE
Field 3: adddetails
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1,2,11
  Label: Bypass
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 3, 173, 255]
  Width: 1
• Value: 1,2,<Null>
  Label: Distribution Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 255, 255]
  Width: 1
• Value: 1,2,12
  Label: Interconnect
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [54, 0, 161, 255]
  Width: 1
• Value: 1,1,<Null>
  Label: Transmission Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [169, 0, 230, 255]
  Width: 1
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: [Diameter]
Use Coded Values: true
Symbol:
Color: [0, 38, 115, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 2500.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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ASSETGROUP

Fields:

• ASSETGROUP ( type: esriFieldTypeInteger, alias: Asset group, editable: true, nullable: false, defaultValue: 0, modelName: ASSETGROUP, required: true )
• ASSETTYPE ( type: esriFieldTypeSmallInteger, alias: Asset type, editable: true, nullable: false, defaultValue: 0, modelName: ASSETTYPE, required: true )
• ASSOCIATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Association status, editable: false, nullable: false, defaultValue: 0, modelName: ASSOCIATIONSTATUS, required: true , Coded Values: [0: None] , [1: Container] , [2: Structure] , ...33 more... )
• ISCONNECTED ( type: esriFieldTypeSmallInteger, alias: Is connected, editable: false, nullable: false, defaultValue: 2, modelName: ISCONNECTED, required: true , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• FROMDEVICETERMINAL ( type: esriFieldTypeSmallInteger, alias: From device terminal, editable: true, nullable: false, defaultValue: 0, modelName: FROMDEVICETERMINAL, required: true , Coded Values: [0: None] , [1: Single Terminal] , [2: High Pressure In] , ...15 more... )
• TODEVICETERMINAL ( type: esriFieldTypeSmallInteger, alias: To device terminal, editable: true, nullable: false, defaultValue: 0, modelName: TODEVICETERMINAL, required: true , Coded Values: [0: None] , [1: Single Terminal] , [2: High Pressure In] , ...15 more... )
• FLOWDIRECTION ( type: esriFieldTypeSmallInteger, alias: Flow direction, editable: true, nullable: true, defaultValue: 1, modelName: FLOWDIRECTION, required: true , Coded Values: [1: With digitized] , [2: Against digitized] , [3: Indeterminate] )
• cpsubnetworkname ( type: esriFieldTypeString, alias: CP Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: cpsubnetworkname, required: true )
• SUPPORTEDSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supported subnetwork name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: SUPPORTEDSUBNETWORKNAME, required: true )
• SUPPORTINGSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supporting subnetwork name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: SUPPORTINGSUBNETWORKNAME, required: true )
• SystemSubnetworkName ( type: esriFieldTypeString, alias: System Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: SystemSubnetworkName, required: true )
• PressureSubnetworkName ( type: esriFieldTypeString, alias: Pressure Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: PressureSubnetworkName, required: true )
• creationdate ( type: esriFieldTypeDate, alias: Creation date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: creationdate, required: true )
• creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 255, defaultValue: null, modelName: creator, required: true )
• lastupdate ( type: esriFieldTypeDate, alias: Last update, editable: false, nullable: true, length: 8, defaultValue: null, modelName: lastupdate, required: true )
• updatedby ( type: esriFieldTypeString, alias: Updated by, editable: false, nullable: true, length: 255, defaultValue: null, modelName: updatedby, required: true )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: ownedby , Coded Values: [1: CPG] , [-1: RDFFG] , [-2: Private] , ...3 more... )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: 1, modelName: maintby , Coded Values: [1: Asset] , [2: Bylaw] , [3: Civic Facility] , ...21 more... )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: notes )
• measuredlength ( type: esriFieldTypeDouble, alias: Measured Length, editable: true, nullable: true, defaultValue: null, modelName: measuredlength )
• adddetails ( type: esriFieldTypeSmallInteger, alias: adddetails: Color Code, Tracer Wire, editable: true, nullable: true, defaultValue: null, modelName: adddetails )
• bondedinsulated ( type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, editable: true, nullable: true, defaultValue: null, modelName: bondedinsulated , Coded Values: [1: Bonded] , [2: Insulated] )
• cptraceability ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, editable: true, nullable: true, defaultValue: 0, modelName: cptraceability , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• inservicedate ( type: esriFieldTypeDate, alias: In-Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inservicedate )
• retireddate ( type: esriFieldTypeDate, alias: Retired Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: retireddate )
• cpoverride ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, editable: true, nullable: true, defaultValue: null, modelName: cpoverride , Coded Values: [1: Traceable] , [2: Not Traceable] )
• designtype ( type: esriFieldTypeSmallInteger, alias: Water Type, editable: true, nullable: true, defaultValue: null, modelName: designtype )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source, editable: true, nullable: true, defaultValue: null, modelName: spatialsource , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
• spatialconfidence ( type: esriFieldTypeSmallInteger, alias: Spatial Confidence, editable: true, nullable: true, defaultValue: null, modelName: spatialconfidence , Coded Values: [0: Unknown] , [1: High] , [2: Medium] , ...1 more... )
• parcelid ( type: esriFieldTypeString, alias: Parcel ID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: parcelid )
• pressurezone ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 20, defaultValue: null, modelName: pressurezone , Coded Values: [PZ 01: PZ 01] , [PZ 02: PZ 02] , [PZ 03: PZ 03] , ...18 more... )
• criticalcustomer ( type: esriFieldTypeSmallInteger, alias: Critical Customer, editable: true, nullable: true, defaultValue: null, modelName: criticalcustomer )
• VALIDATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Validation status, editable: false, nullable: true, defaultValue: 6, modelName: VALIDATIONSTATUS )
• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, length: 8, defaultValue: null, modelName: OBJECTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: Global ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• IsolationSubnetworkName ( type: esriFieldTypeString, alias: Isolation Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: IsolationSubnetworkName, required: true )
• DMASubnetworkName ( type: esriFieldTypeString, alias: DMA Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: DMASubnetworkName, required: true )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: assetid )
• diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter , Coded Values: [0: 0 mm] , [10: 10 mm] , [13: 13 mm] , ...71 more... )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status, editable: true, nullable: false, defaultValue: 0, modelName: lifecyclestatus , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• material ( type: esriFieldTypeSmallInteger, alias: Material, editable: true, nullable: true, defaultValue: null, modelName: material )
• location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: location )
• installcontractor ( type: esriFieldTypeSmallInteger, alias: Install Contractor, editable: true, nullable: true, defaultValue: null, modelName: installcontractor )
• groundtype ( type: esriFieldTypeSmallInteger, alias: Ground Type, editable: true, nullable: true, defaultValue: null, modelName: groundtype )
• depth ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: depth )
• exteriorcoating ( type: esriFieldTypeString, alias: Exterior Coating, editable: true, nullable: true, length: 20, defaultValue: null, modelName: exteriorcoating )
• liningtype ( type: esriFieldTypeString, alias: Lining Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: liningtype )
• liningdate ( type: esriFieldTypeDate, alias: Lining Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: liningdate )
• roughness ( type: esriFieldTypeDouble, alias: Roughness, editable: true, nullable: true, defaultValue: null, modelName: roughness )
• conditiondate ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: conditiondate )
• acquisitioncost ( type: esriFieldTypeDouble, alias: Acquisition Cost, editable: true, nullable: true, defaultValue: null, modelName: acquisitioncost )
• expectedlife ( type: esriFieldTypeDouble, alias: Expected Life, editable: true, nullable: true, defaultValue: null, modelName: expectedlife )
• residualvalue ( type: esriFieldTypeDouble, alias: Residual Value, editable: true, nullable: true, defaultValue: null, modelName: residualvalue )
• condition ( type: esriFieldTypeDouble, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: condition )
• cofscore ( type: esriFieldTypeDouble, alias: CoF Score, editable: true, nullable: true, defaultValue: null, modelName: cofscore )
• cofdate ( type: esriFieldTypeDate, alias: CoF Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cofdate )
• riskscore ( type: esriFieldTypeDouble, alias: Risk Score, editable: true, nullable: true, defaultValue: null, modelName: riskscore )
• link ( type: esriFieldTypeString, alias: Link, editable: true, nullable: true, length: 255, defaultValue: null, modelName: link )
• subtypetext ( type: esriFieldTypeString, alias: Subtype Text, editable: true, nullable: true, length: 255, defaultValue: null, modelName: subtypetext )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE_Length, editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )

Types:

ID: 1
Name: Water Main
Domains:
Templates:
• Name: 1, 2, 11
  Description:
  Prototype:
  subtypetext: null
  ASSETGROUP: 1
  ASSETTYPE: 2
  cofdate: null
  cofscore: null
  FROMDEVICETERMINAL: 0
  TODEVICETERMINAL: 0
  FLOWDIRECTION: 1
  condition: null
  residualvalue: null
  expectedlife: null
  acquisitioncost: null
  conditiondate: null
  roughness: null
  liningdate: null
  liningtype: null
  exteriorcoating: null
  ownedby: 1
  maintby: 21
  notes: null
  measuredlength: null
  adddetails: 11
  bondedinsulated: null
  cptraceability: 0
  inservicedate: null
  retireddate: null
  cpoverride: null
  designtype: null
  spatialsource: 0
  spatialconfidence: 0
  parcelid: null
  pressurezone: null
  criticalcustomer: null
  depth: null
  link: null
  riskscore: null
  groundtype: null
  installcontractor: null
  installdate: null
  assetid: null
  diameter: null
  lifecyclestatus: 8
  material: 0
  location: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 1, 2, <Null>
  Description:
  Prototype:
  subtypetext: null
  ASSETGROUP: 1
  ASSETTYPE: 2
  cofdate: null
  cofscore: null
  FROMDEVICETERMINAL: 0
  TODEVICETERMINAL: 0
  FLOWDIRECTION: 1
  condition: null
  residualvalue: null
  expectedlife: null
  acquisitioncost: null
  conditiondate: null
  roughness: null
  liningdate: null
  liningtype: null
  exteriorcoating: null
  ownedby: 1
  maintby: 21
  notes: null
  measuredlength: null
  adddetails: null
  bondedinsulated: null
  cptraceability: 0
  inservicedate: null
  retireddate: null
  cpoverride: null
  designtype: null
  spatialsource: 0
  spatialconfidence: 0
  parcelid: null
  pressurezone: null
  criticalcustomer: null
  depth: null
  link: null
  riskscore: null
  groundtype: null
  installcontractor: null
  installdate: null
  assetid: null
  diameter: null
  lifecyclestatus: 8
  material: 0
  location: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 1, 2, 12
  Description:
  Prototype:
  subtypetext: null
  ASSETGROUP: 1
  ASSETTYPE: 2
  cofdate: null
  cofscore: null
  FROMDEVICETERMINAL: 0
  TODEVICETERMINAL: 0
  FLOWDIRECTION: 1
  condition: null
  residualvalue: null
  expectedlife: null
  acquisitioncost: null
  conditiondate: null
  roughness: null
  liningdate: null
  liningtype: null
  exteriorcoating: null
  ownedby: 1
  maintby: 21
  notes: null
  measuredlength: null
  adddetails: 12
  bondedinsulated: null
  cptraceability: 0
  inservicedate: null
  retireddate: null
  cpoverride: null
  designtype: null
  spatialsource: 0
  spatialconfidence: 0
  parcelid: null
  pressurezone: null
  criticalcustomer: null
  depth: null
  link: null
  riskscore: null
  groundtype: null
  installcontractor: null
  installdate: null
  assetid: null
  diameter: null
  lifecyclestatus: 8
  material: 0
  location: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 1, 1, <Null>
  Description:
  Prototype:
  subtypetext: null
  ASSETGROUP: 1
  ASSETTYPE: 1
  cofdate: null
  cofscore: null
  FROMDEVICETERMINAL: 0
  TODEVICETERMINAL: 0
  FLOWDIRECTION: 1
  condition: null
  residualvalue: null
  expectedlife: null
  acquisitioncost: null
  conditiondate: null
  roughness: null
  liningdate: null
  liningtype: null
  exteriorcoating: null
  ownedby: 1
  maintby: 21
  notes: null
  measuredlength: null
  adddetails: null
  bondedinsulated: null
  cptraceability: 0
  inservicedate: null
  retireddate: null
  cpoverride: null
  designtype: null
  spatialsource: 0
  spatialconfidence: 0
  parcelid: null
  pressurezone: null
  criticalcustomer: null
  depth: null
  link: null
  riskscore: null
  groundtype: null
  installcontractor: null
  installdate: null
  assetid: null
  diameter: null
  lifecyclestatus: 8
  material: 0
  location: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: lastupdate
• Editor Field: updatedby

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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