Name: Water Structure

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: A junction in the network that represents a significant facility such as a treatment plant, Production Well, resivoir or pump station. Usually contains many other pieces of equipment

Copyright Text: City of Prince George

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 507568.278
YMin: 5963592.5072
XMax: 527278.039
YMax: 5982688.0585
Spatial Reference: 26910 (26910)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[190,232,255,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2}}},"scaleSymbols":true,"transparency":50,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GLOBALID

Type ID Field:

Fields:

• acquisitioncost (type: esriFieldTypeDouble, alias: AcquisitionCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• assetid (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• cofdate (type: esriFieldTypeDate, alias: CoFDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• cofscore (type: esriFieldTypeDouble, alias: CoFScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• condition (type: esriFieldTypeDouble, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• conditiondate (type: esriFieldTypeDate, alias: ConditionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• elevation (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• expectedlife (type: esriFieldTypeDouble, alias: ExpectedLife, SQL Type: sqlTypeOther, nullable: true, editable: true)
• installcontractor (type: esriFieldTypeSmallInteger, alias: InstallContractor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: InstallDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: LifecycleStatus, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 14 more ...)
• link (type: esriFieldTypeString, alias: Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• residualvalue (type: esriFieldTypeDouble, alias: ResidualValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• riskscore (type: esriFieldTypeDouble, alias: RiskScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSETGROUP (type: esriFieldTypeInteger, alias: Asset group, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSETTYPE (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSOCIATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Container], [2: Structure], ... 33 more ...)
• SUBNETWORKNAME (type: esriFieldTypeString, alias: Subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inservicedate (type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• retireddate (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• spatialsource (type: esriFieldTypeSmallInteger, alias: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built], [2: CAD], ... 3 more ...)
• spatialconfidence (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true)
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pressurezone (type: esriFieldTypeString, alias: Pressure Zone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• VALIDATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Validation status, SQL Type: sqlTypeOther, nullable: true, editable: true)
• subtypetext (type: esriFieldTypeString, alias: Subtype Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Water Structure
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• subtype: 4
• VALIDATIONSTATUS: 6
• lifecyclestatus: ACT
• ASSETGROUP: 0
• ASSETTYPE: 0
• ASSOCIATIONSTATUS: 0
• SUBNETWORKNAME: Unknown

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/26/2025 3:24:23 AM

Schema Last Edit Date: 7/26/2025 3:24:23 AM

Data Last Edit Date: 7/26/2025 3:24:23 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat