View In:   ArcGIS Online Map Viewer

Name: Pipes

Display Field: DIAMETER

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: e4758d8529b141c8a141a2576dcf48aa

Copyright Text:

Default Visibility: true

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 8000

Tile Max Record Count: 4000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.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: 2053884.56849964
YMin: 686559.359685048
XMax: 2156372.36221132
YMax: 808681.876266301
Spatial Reference: 102719  (2264)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PIPE_TYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Pipe
  Label: Pipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 7
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [DIAMETER]
Use Coded Values: true
Symbol:
Color: [255, 0, 0, 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: 10
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 2400.0
Max. Scale: 0.0

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
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 Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: PIPE_TYPE

Fields:

• CITY ( modelName: City, nullable: true, editable: true, defaultValue: Raleigh, length: 25, alias: CITY, type: esriFieldTypeString )
• UPSTREAM_MH ( modelName: Upstream_MH, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: UPSTREAM_MH, type: esriFieldTypeString )
• DOWNSTREAM_MH ( modelName: Downstream_MH, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: DOWNSTREAM_MH, type: esriFieldTypeString )
• MATERIAL_WINCAN ( modelName: Material_WinCan, nullable: true, editable: true, defaultValue: RCP, length: 50, alias: MATERIAL_WINCAN, type: esriFieldTypeString , Coded Values: [BR: Brick] , [CAS: Cast Iron] , [CMP: Corrugated Metal Pipe] , ...18 more... )
• SEWER_USE ( modelName: Sewer_Use, nullable: true, editable: true, defaultValue: Stormwater, length: 25, alias: SEWER_USE, type: esriFieldTypeString )
• PIPE_SHAPE_WINCAN ( modelName: Pipe_Shape_WinCan, nullable: true, editable: true, defaultValue: C, length: 50, alias: PIPE_SHAPE_WINCAN, type: esriFieldTypeString , Coded Values: [A: Arched] , [C: Circular] , [H: Horseshoe] , ...7 more... )
• INSPECTION_CLASS ( modelName: Inspection_Class, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: INSPECTION_CLASS, type: esriFieldTypeString , Coded Values: [Qualifying: Qualifying] , [Non-Qualifying: Non-Qualifying] , [RDOT Identified: RDOT Identified] )
• AGE ( modelName: AGE, nullable: true, editable: true, defaultValue: N/A, alias: Age, type: esriFieldTypeSmallInteger )
• YEAR_BUILT ( modelName: YEAR_BUILT, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Year Built, type: esriFieldTypeString , Coded Values: [1910: 1910-1920] , [1920: 1920-1930] , [1930: 1930-1940] , ...7 more... )
• OWNERSHIP ( modelName: OWNERSHIP, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Ownership, type: esriFieldTypeString , Coded Values: [City: City] , [State: State] , [County: County] , ...5 more... )
• LIFECYCLESTATUS ( modelName: LIFECYCLESTATUS, nullable: true, editable: true, defaultValue: Active, length: 255, alias: Life Cycle Status, type: esriFieldTypeString , Coded Values: [Active: Active] , [Inactive: Inactive] , [Abandoned: Abandoned] , ...2 more... )
• INSTALLDATE ( modelName: INSTALLDATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Install Date, type: esriFieldTypeDate )
• LEGACYID ( modelName: LEGACYID, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Legacy ID, type: esriFieldTypeString )
• UPSTRTYPE ( modelName: UPSTRTYPE, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Upstream Structure Type, type: esriFieldTypeString , Coded Values: [Inlets: Inlets] , [Junctions: Junctions] , [PipeIO: PipeIO] , ...3 more... )
• DOWNSTRTYPE ( modelName: DOWNSTRTYPE, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Downstream Structure Type, type: esriFieldTypeString , Coded Values: [Inlets: Inlets] , [Junctions: Junctions] , [PipeIO: PipeIO] , ...3 more... )
• IBRE ( modelName: IBRE, nullable: true, editable: true, defaultValue: N/A, alias: Business Risk Exposure, type: esriFieldTypeDouble )
• ICOF ( modelName: ICOF, nullable: true, editable: true, defaultValue: N/A, alias: Consequence of Failure, type: esriFieldTypeDouble )
• IPOF ( modelName: IPOF, nullable: true, editable: true, defaultValue: N/A, alias: Probability of Failure, type: esriFieldTypeDouble )
• IMSPO ( modelName: IMSPO, nullable: true, editable: true, defaultValue: N/A, alias: MSP Over-maintained, type: esriFieldTypeDouble )
• IMSPU ( modelName: IMSPU, nullable: true, editable: true, defaultValue: N/A, alias: MSPUnder-maintained, type: esriFieldTypeDouble )
• ICALDATE ( modelName: ICALDATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Date Risk Calculated, type: esriFieldTypeDate )
• UPSTR ( modelName: UPSTR, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Upstream Structure, type: esriFieldTypeString )
• DOWNSTR ( modelName: DOWNSTR, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Downstream Structure, type: esriFieldTypeString )
• SLOPE ( modelName: SLOPE, nullable: true, editable: true, defaultValue: N/A, alias: Slope, type: esriFieldTypeDouble )
• IMSR ( modelName: IMSR, nullable: true, editable: true, defaultValue: N/A, alias: Reactive Maintenance Score, type: esriFieldTypeInteger )
• IYEARENDAVG ( modelName: IYEARENDAVG, nullable: true, editable: true, defaultValue: N/A, alias: Average End of Life, type: esriFieldTypeInteger )
• IYEARENDFST ( modelName: IYEARENDFST, nullable: true, editable: true, defaultValue: N/A, alias: Fast End of Life, type: esriFieldTypeInteger )
• IYEARENDSLW ( modelName: IYEARENDSLW, nullable: true, editable: true, defaultValue: N/A, alias: Slow End of Life, type: esriFieldTypeInteger )
• ICALNAME ( modelName: ICALNAME, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Calculation Name, type: esriFieldTypeString )
• ICOND ( modelName: ICOND, nullable: true, editable: true, defaultValue: N/A, alias: Condition, type: esriFieldTypeDouble )
• IPERF ( modelName: IPERF, nullable: true, editable: true, defaultValue: N/A, alias: Performance, type: esriFieldTypeDouble )
• ISIGNIF ( modelName: ISIGNIF, nullable: true, editable: true, defaultValue: N/A, alias: Significance, type: esriFieldTypeDouble )
• IIMPACT ( modelName: IIMPACT, nullable: true, editable: true, defaultValue: N/A, alias: Impact, type: esriFieldTypeDouble )
• GLOBALID ( modelName: GLOBALID, nullable: false, editable: false, defaultValue: N/A, length: 38, alias: GLOBALID, type: esriFieldTypeGlobalID )
• CREATED_USER ( modelName: CREATED_USER, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: CREATED_USER, type: esriFieldTypeString )
• CREATED_DATE ( modelName: CREATED_DATE, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: CREATED_DATE, type: esriFieldTypeDate )
• LAST_EDITED_USER ( modelName: LAST_EDITED_USER, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: LAST_EDITED_USER, type: esriFieldTypeString )
• LAST_EDITED_DATE ( modelName: LAST_EDITED_DATE, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: LAST_EDITED_DATE, type: esriFieldTypeDate )
• P_CAM_S ( modelName: P_CAM_S, nullable: true, editable: true, defaultValue: N/A, alias: Pole Camera Score, type: esriFieldTypeDouble )
• P_CAM_S_D ( modelName: P_CAM_S_D, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Pole Camera Score Date, type: esriFieldTypeDate )
• CCTV_S ( modelName: CCTV_S, nullable: true, editable: true, defaultValue: N/A, alias: CCTV Score, type: esriFieldTypeDouble )
• CCTV_S_D ( modelName: CCTV_S_D, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: CCTV Score Date, type: esriFieldTypeDate )
• OBJECTID ( modelName: OBJECTID, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• FEATURE ( modelName: FEATURE, nullable: true, editable: true, defaultValue: Pipes, length: 254, alias: FEATURE, type: esriFieldTypeString )
• PIPESHAPE ( modelName: PIPESHAPE, nullable: true, editable: true, defaultValue: Round, length: 254, alias: PIPESHAPE, type: esriFieldTypeString , Coded Values: [Round: Round] , [Rectangular: Rectangular] , [Elliptical: Elliptical] , ...2 more... )
• DIAMETER ( modelName: DIAMETER, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: DIAMETER, type: esriFieldTypeString , Coded Values: [Indeterminate: Indeterminate] , [4: 4] , [6: 6] , ...24 more... )
• MATERIAL ( modelName: MATERIAL, nullable: true, editable: true, defaultValue: Concrete, length: 254, alias: MATERIAL, type: esriFieldTypeString , Coded Values: [Concrete: Concrete] , [CMP: CMP] , [CPP: CPP] , ...7 more... )
• DNINVDIST ( modelName: DNINVDIST, nullable: true, editable: true, defaultValue: N/A, alias: DNINVDIST, type: esriFieldTypeDouble )
• UPINVDIST ( modelName: UPINVDIST, nullable: true, editable: true, defaultValue: N/A, alias: UPINVDIST, type: esriFieldTypeDouble )
• WIDTH ( modelName: WIDTH, nullable: true, editable: true, defaultValue: N/A, alias: WIDTH, type: esriFieldTypeDouble )
• HEIGHT ( modelName: HEIGHT, nullable: true, editable: true, defaultValue: N/A, alias: HEIGHT, type: esriFieldTypeDouble )
• CONDITION ( modelName: CONDITION, nullable: true, editable: true, defaultValue: Functional, length: 254, alias: CONDITION, type: esriFieldTypeString , Coded Values: [Functional: Functional] , [Needs Service: Needs Service] , [Abandoned: Abandoned] )
• OBSTRUCTION ( modelName: Obstruction, nullable: true, editable: true, defaultValue: No (<25%), length: 100, alias: Obstruction, type: esriFieldTypeString , Coded Values: [No (<25%): No (<25%)] , [Yes (>25%): Yes (>25%)] )
• LENGTH ( modelName: LENGTH, nullable: true, editable: true, defaultValue: N/A, alias: LENGTH, type: esriFieldTypeDouble )
• UTILOTHER ( modelName: UTILOTHER, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: UTILOTHER, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• UTILSEWER ( modelName: UTILSEWER, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: UTILSEWER, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• UTILWATER ( modelName: UTILWATER, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: UTILWATER, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• UTILGAS ( modelName: UTILGAS, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: UTILGAS, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• UTILELECTR ( modelName: UTILELECTR, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: UTILELECTR, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• CCTVUSED ( modelName: CCTVUsed, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: CCTVUsed, type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• COMMENTS ( modelName: COMMENTS, nullable: true, editable: true, defaultValue: N/A, length: 254, alias: COMMENTS, type: esriFieldTypeString )
• INV_DATE ( modelName: INV_DATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: INV_DATE, type: esriFieldTypeDate )
• BASIN_NAME ( modelName: BASIN_NAME, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: BASIN_NAME, type: esriFieldTypeString )
• LAST_UPDATED ( modelName: LAST_UPDATED, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: LAST_UPDATED, type: esriFieldTypeDate )
• EDITOR_COMMENTS ( modelName: EDITOR_COMMENTS, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: EDITOR_COMMENTS, type: esriFieldTypeString )
• ENABLED ( modelName: Enabled, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• UNIQUEID ( modelName: UNIQUEID, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: UNIQUEID, type: esriFieldTypeString )
• FACILITYID ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: N/A, length: 12, alias: FACILITYID, type: esriFieldTypeString )
• APPROX_US_INV_ELEV ( modelName: Approx_US_INV_Elev, nullable: true, editable: true, defaultValue: N/A, alias: Approx_US_INV_Elev, type: esriFieldTypeDouble )
• APPROX_DS_INV_ELEV ( modelName: Approx_DS_INV_Elev, nullable: true, editable: true, defaultValue: N/A, alias: Approx_DS_INV_Elev, type: esriFieldTypeDouble )
• APPROX_SLOPE ( modelName: Approx_Slope, nullable: true, editable: true, defaultValue: N/A, alias: Approx_Slope, type: esriFieldTypeDouble )
• PIPE_TYPE ( modelName: Pipe_Type, nullable: true, editable: true, defaultValue: Pipe, length: 50, alias: Pipe_Type, type: esriFieldTypeString , Coded Values: [Pipe: Pipe] , [Abandoned: Abandoned] , [French Drain: French Drain] , ...1 more... )
• Shape__Length ( modelName: SHAPE.LEN, nullable: true, editable: false, defaultValue: N/A, alias: SHAPE.LEN, type: esriFieldTypeDouble, required: true )

Types:

ID: Pipe
Name: Pipe
Domains:
• PIPE_TYPE:
  Inherited
• MATERIAL_WINCAN:
  Inherited
• UTILGAS:
  Inherited
• DOWNSTRTYPE:
  Inherited
• UPSTRTYPE:
  Inherited
• UTILWATER:
  Inherited
• PIPESHAPE:
  Inherited
• UTILELECTR:
  Inherited
• DIAMETER:
  Inherited
• INSPECTION_CLASS:
  Inherited
• CCTVUSED:
  Inherited
• UTILSEWER:
  Inherited
• YEAR_BUILT:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• OBSTRUCTION:
  Inherited
• CONDITION:
  Inherited
• ENABLED:
  Inherited
• PIPE_SHAPE_WINCAN:
  Inherited
• OWNERSHIP:
  Inherited
• UTILOTHER:
  Inherited
• MATERIAL:
  Inherited
Templates:
• Name: Pipes
  Description:
  Prototype:
  PIPE_TYPE: Pipe
  APPROX_DS_INV_ELEV: null
  BASIN_NAME: null
  UTILGAS: null
  LAST_UPDATED: null
  DOWNSTRTYPE: null
  CCTV_S_D: null
  YEAR_BUILT: null
  LIFECYCLESTATUS: Active
  IPERF: null
  FACILITYID: null
  CCTV_S: null
  IPOF: null
  IMSR: null
  APPROX_US_INV_ELEV: null
  MATERIAL_WINCAN: RCP
  INV_DATE: null
  IBRE: null
  UTILELECTR: null
  DIAMETER: null
  UNIQUEID: null
  INSTALLDATE: null
  OBSTRUCTION: No (<25%)
  FEATURE: Pipes
  CONDITION: Functional
  PIPE_SHAPE_WINCAN: C
  SLOPE: null
  APPROX_SLOPE: null
  ICALDATE: null
  UPSTR: null
  IMSPO: null
  LENGTH: null
  DNINVDIST: null
  P_CAM_S: null
  COMMENTS: null
  DOWNSTR: null
  WIDTH: null
  ISIGNIF: null
  IYEARENDSLW: null
  ICOND: null
  UPINVDIST: null
  P_CAM_S_D: null
  ICOF: null
  UPSTREAM_MH: null
  IYEARENDFST: null
  IIMPACT: null
  UTILSEWER: null
  SEWER_USE: Stormwater
  DOWNSTREAM_MH: null
  IYEARENDAVG: null
  IMSPU: null
  UTILOTHER: null
  MATERIAL: Concrete
  AGE: null
  ICALNAME: null
  LEGACYID: null
  HEIGHT: null
  UPSTRTYPE: null
  UTILWATER: null
  PIPESHAPE: Round
  CITY: Raleigh
  INSPECTION_CLASS: null
  CCTVUSED: null
  EDITOR_COMMENTS: null
  ENABLED: 1
  OWNERSHIP: 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

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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