View In:   ArcGIS Online Map Viewer

Name: Water: Pipe

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2400

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: 1311701.7810398042
YMin: 231426.52710163593
XMax: 1358283.233480394
YMax: 271494.55293655396
Spatial Reference: 2926  (2926)  VCSWkid(5702)  LatestVCSWkid(5702)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: d_Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: ACT
  Label: Active
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 169, 230, 255]
  Width: 1
• Value: ABN
  Label: Abandon
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [115, 223, 255, 255]
  Width: 0
• Value: CONST
  Label: Construction
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: d_Status

Fields:

• AssetID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: AssetID )
• d_AssetType ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: d_AssetType , Coded Values: [Aquatic: Aquatic] , [Art: Art] , [AssetRepair: AssetRepair] , ...70 more... )
• d_Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: false, length: 6, defaultValue: ACT, modelName: d_Status , Coded Values: [ACT: Active] , [CONST: Construction] , [ABN: Abandon] , ...3 more... )
• d_Ownership ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: false, length: 6, defaultValue: UNK, modelName: d_Ownership , Coded Values: [RED: City of Redmond] , [PVT: Private] , [KCO: King County] , ...15 more... )
• d_MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 6, defaultValue: UNK, modelName: d_MaintainedBy , Coded Values: [CORPK: City of Redmond Parks Department] , [CORSM: City of Redmond Stormwater Department] , [CORST: City of Redmond Street Department] , ...19 more... )
• d_PipeType ( type: esriFieldTypeString, alias: Type, editable: true, nullable: false, length: 6, defaultValue: UNK, modelName: d_PipeType , Coded Values: [DIST: Distribution Main] , [FH: Fire Hydrant] , [AP: Appurtenance] , ...3 more... )
• d_PipeSize ( type: esriFieldTypeDouble, alias: Size (in), editable: true, nullable: false, defaultValue: 0, modelName: d_PipeSize , Coded Values: [0: 0 inch/Unknown] , [1: 1 inch] , [1.5: 1.5 inch] , ...57 more... )
• d_PipeMaterial ( type: esriFieldTypeString, alias: Material, editable: true, nullable: false, length: 6, defaultValue: UNK, modelName: d_PipeMaterial , Coded Values: [UNK: Unknown] , [AC: Asbestos Cement] , [CI: Cast Iron] , ...12 more... )
• CalcLength ( type: esriFieldTypeDouble, alias: Length (ft), editable: true, nullable: true, defaultValue: null, modelName: CalcLength )
• d_PressureZone ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: false, length: 6, defaultValue: 0, modelName: d_PressureZone , Coded Values: [238: 238] , [300: 300] , [315: 315] , ...24 more... )
• InstallYear ( type: esriFieldTypeString, alias: Install Year, editable: true, nullable: true, length: 4, defaultValue: null, modelName: InstallYear )
• d_EstimatedInstallYear ( type: esriFieldTypeString, alias: Estimated Install Year, editable: true, nullable: true, length: 3, defaultValue: UNK, modelName: d_EstimatedInstallYear , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectName )
• RecordDrawing ( type: esriFieldTypeString, alias: Record Drawing, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RecordDrawing )
• RecordDrawing1 ( type: esriFieldTypeString, alias: Record Drawing 1, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RecordDrawing1 )
• RecordDrawing2 ( type: esriFieldTypeString, alias: Record Drawing 2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RecordDrawing2 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: ACT
Name: Active
Domains:
• d_AssetType:
  Inherited
• d_Status:
  Inherited
• d_Ownership:
  Inherited
• d_MaintainedBy:
  Inherited
• d_PipeType:
  Inherited
• d_PipeSize:
  Inherited
• d_PipeMaterial:
  Inherited
• d_PressureZone:
  Inherited
• d_EstimatedInstallYear:
  Inherited
• RecordLength:
  Inherited
• d_DataSource:
  Inherited
• d_AnalysisType:
  Inherited
• Analysis:
  Inherited
• Enabled:
  Inherited
• d_FranchisePipe:
  Inherited
Templates:
• Name: Active
  Description:
  Prototype:
  d_AssetType: null
  RecordDrawing2: null
  AssetID: null
  d_Status: ACT
  d_Ownership: UNK
  d_MaintainedBy: UNK
  d_PipeType: UNK
  d_PipeSize: 0
  d_PipeMaterial: UNK
  CalcLength: null
  d_PressureZone: 0
  InstallYear: null
  d_EstimatedInstallYear: UNK
  ProjectName: null
  RecordDrawing: null
  RecordDrawing1: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: ABN
Name: Abandon
Domains:
• d_AssetType:
  Inherited
• d_Status:
  Inherited
• d_Ownership:
  Inherited
• d_MaintainedBy:
  Inherited
• d_PipeType:
  Inherited
• d_PipeSize:
  Inherited
• d_PipeMaterial:
  Inherited
• d_PressureZone:
  Inherited
• d_EstimatedInstallYear:
  Inherited
• RecordLength:
  Inherited
• d_DataSource:
  Inherited
• d_AnalysisType:
  Inherited
• Analysis:
  Inherited
• Enabled:
  Inherited
• d_FranchisePipe:
  Inherited
Templates:
• Name: Abandon
  Description:
  Prototype:
  d_AssetType: null
  RecordDrawing2: null
  AssetID: null
  d_Status: ABN
  d_Ownership: UNK
  d_MaintainedBy: UNK
  d_PipeType: UNK
  d_PipeSize: 0
  d_PipeMaterial: UNK
  CalcLength: null
  d_PressureZone: 0
  InstallYear: null
  d_EstimatedInstallYear: UNK
  ProjectName: null
  RecordDrawing: null
  RecordDrawing1: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: CONST
Name: Construction
Domains:
• d_AssetType:
  Inherited
• d_Status:
  Inherited
• d_Ownership:
  Inherited
• d_MaintainedBy:
  Inherited
• d_PipeType:
  Inherited
• d_PipeSize:
  Inherited
• d_PipeMaterial:
  Inherited
• d_PressureZone:
  Inherited
• d_EstimatedInstallYear:
  Inherited
• RecordLength:
  Inherited
• d_DataSource:
  Inherited
• d_AnalysisType:
  Inherited
• Analysis:
  Inherited
• Enabled:
  Inherited
• d_FranchisePipe:
  Inherited
Templates:
• Name: Construction
  Description:
  Prototype:
  d_AssetType: null
  RecordDrawing2: null
  AssetID: null
  d_Status: CONST
  d_Ownership: UNK
  d_MaintainedBy: UNK
  d_PipeType: UNK
  d_PipeSize: 0
  d_PipeMaterial: UNK
  CalcLength: null
  d_PressureZone: 0
  InstallYear: null
  d_EstimatedInstallYear: UNK
  ProjectName: null
  RecordDrawing: null
  RecordDrawing1: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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