View In:   ArcGIS Online Map Viewer

Name: Pipe

Display Field: identification

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: ae91ffee9b9f44fead3aae0b71317b9f

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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

Extent:

XMin: -1.3358968627999999E7
YMin: 4186835.8225999996
XMax: -1.26950410216E7
YMax: 5160660.363499999
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [140, 140, 140, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• display ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: display, alias: Feature Display , Coded Values: [Storm Drain: Storm Drain] , [Culvert: Culvert] , [Down Drain: Down Drain] , ...4 more... )
• f_subtype ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: f_subtype, alias: Feature Subtype , Coded Values: [1: Storm Drain] , [2: Culvert] , [3: Down Drain] , ...4 more... )
• identification ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: identification, alias: Identification )
• assetid ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: assetid, alias: Asset ID )
• facilitystatus_pip ( nullable: false, editable: true, defaultValue: Active, length: 30, type: esriFieldTypeString, modelName: facilitystatus_pip, alias: Facility Status , Coded Values: [Active: Active] , [Abandoned: Abandoned] , [Relinquished: Relinquished] , ...4 more... )
• inspectioninterval ( nullable: true, editable: true, defaultValue: null, length: 40, type: esriFieldTypeString, modelName: inspectioninterval, alias: Inspection Interval , Coded Values: [3 Months: 3 Months] , [1 Year: 1 Year] , [3 Years: 3 Years] , ...1 more... )
• inspectionstatus_pip ( nullable: false, editable: true, defaultValue: Undetermined, length: 30, type: esriFieldTypeString, modelName: inspectionstatus_pip, alias: Inspection Status , Coded Values: [Inspected: Inspected] , [Undetermined: Undetermined] , [NeedsInspection: Needs Inspection] )
• lastinspectiondate ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: lastinspectiondate, alias: Last Inspection Date )
• maintenancestatus ( nullable: false, editable: true, defaultValue: Undetermined, length: 40, type: esriFieldTypeString, modelName: maintenancestatus, alias: Maintenance Status , Coded Values: [MaintenanceRequired: Maintenance Required] , [MaintenanceCompleted: Maintenance Completed] , [Undetermined: Undetermined] )
• lastmaintenancedate ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: lastmaintenancedate, alias: Last Maintenance Date )
• routeid1 ( nullable: true, editable: true, defaultValue: null, length: 12, type: esriFieldTypeString, modelName: routeid1, alias: Route ID 1 )
• routeid2 ( nullable: true, editable: true, defaultValue: null, length: 12, type: esriFieldTypeString, modelName: routeid2, alias: Route ID 2 )
• milepost1 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: milepost1, alias: Milepost 1 )
• milepost2 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: milepost2, alias: Milepost 2 )
• offset1_ft ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: offset1_ft, alias: Offset 1 (ft) )
• offset2_ft ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: offset2_ft, alias: Offset 2 (ft) )
• latitude ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: latitude, alias: Latitude )
• longitude ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: longitude, alias: Longitude )
• district ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: district, alias: District , Coded Values: [1: District 1] , [2: District 2] , [3: District 3] )
• assetconstructionstatus_pip ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: assetconstructionstatus_pip, alias: Asset Construction Status , Coded Values: [Designed: Designed] , [Constructed: Constructed] )
• constructioncontractnumber ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: constructioncontractnumber, alias: Construction Contract Number )
• rowpermitnumber ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: rowpermitnumber, alias: ROW Permit Number )
• othersystemnumber ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: othersystemnumber, alias: Other System Number )
• assetaccessibility_pip ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: assetaccessibility_pip, alias: Asset Accessibility , Coded Values: [Accessible: Accessible] , [Feature Not Found: Feature Not Found] , [Feature in Roadway: Feature in Roadway] , ...2 more... )
• featuresource_pip ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: featuresource_pip, alias: Feature Source , Coded Values: [Handheld GPS: Handheld GPS] , [Aerial Imagery: Aerial Imagery] , [Planimetric DGN: Planimetric DGN] , ...6 more... )
• featuresourceid ( nullable: true, editable: true, defaultValue: null, length: 150, type: esriFieldTypeString, modelName: featuresourceid, alias: Feature Source ID )
• attributesource_pip ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: attributesource_pip, alias: Attribute Source , Coded Values: [Handheld GPS: Handheld GPS] , [Aerial Imagery: Aerial Imagery] , [Planimetric DGN: Planimetric DGN] , ...6 more... )
• attributesourceid ( nullable: true, editable: true, defaultValue: null, length: 150, type: esriFieldTypeString, modelName: attributesourceid, alias: Attribute Source ID )
• outfallid ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: outfallid, alias: Outfall ID )
• assetinstalldate ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: assetinstalldate, alias: Asset Install Date )
• assetowner_pip ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: assetowner_pip, alias: Asset Owner , Coded Values: [NDOT: NDOT] , [Municipal: Municipal] , [Private: Private] , ...2 more... )
• maintenanceobligation_pip ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: maintenanceobligation_pip, alias: Maintenance Obligation , Coded Values: [NDOT: NDOT] , [Municipal: Municipal] , [Private: Private] , ...2 more... )
• numberofpipes ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: numberofpipes, alias: Number of Pipes , Range: [1, 20] )
• endconfigurationupstream ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: endconfigurationupstream, alias: End Configuration Upstream , Coded Values: [Open End: Open End] , [End Section: End Section] , [Headwall: Headwall] , ...5 more... )
• pipeconfiguration ( nullable: true, editable: true, defaultValue: null, length: 25, type: esriFieldTypeString, modelName: pipeconfiguration, alias: Shape of Pipe , Coded Values: [Circular: Circular] , [Arch: Arch] , [Eliptical: Eliptical] , ...1 more... )
• endconfigurationdownstream ( nullable: true, editable: true, defaultValue: null, length: 25, type: esriFieldTypeString, modelName: endconfigurationdownstream, alias: End Configuration Downstream , Coded Values: [Open End: Open End] , [End Section: End Section] , [Headwall: Headwall] , ...5 more... )
• riprapapron ( nullable: true, editable: true, defaultValue: null, length: 25, type: esriFieldTypeString, modelName: riprapapron, alias: Riprap Apron , Coded Values: [None: None] , [Upstream: Upstream] , [Downstream: Downstream] , ...1 more... )
• trashrack ( nullable: true, editable: true, defaultValue: null, length: 25, type: esriFieldTypeString, modelName: trashrack, alias: Trash Rack , Coded Values: [None: None] , [Upstream: Upstream] , [Downstream: Downstream] , ...1 more... )
• pipematerial ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: pipematerial, alias: Pipe Material , Coded Values: [Concrete: Concrete] , [Corrugated Metal Pipe: Corrugated Metal Pipe (CMP)] , [High Density Polyethylene (HDPE) Thick Walled: High Density Polyethylene (HDPE) Thick Walled] , ...7 more... )
• pipelinermaterial ( nullable: true, editable: true, defaultValue: null, length: 40, type: esriFieldTypeString, modelName: pipelinermaterial, alias: Pipe Liner Material , Coded Values: [None: None] , [High Density Polyethylene (HDPE): High Density Polyethylene (HDPE)] , [Cured in Place Plastic (CIPP): Cured in Place Plastic (CIPP)] , ...3 more... )
• endsectionmaterialupstream ( nullable: true, editable: true, defaultValue: null, length: 40, type: esriFieldTypeString, modelName: endsectionmaterialupstream, alias: End Section Material Upstream , Coded Values: [Concrete End Section: Concrete End Section] , [Metal End Section: Metal End Section] , [Metal End Section (Safety-Type): Metal End Section (Safety-Type)] , ...1 more... )
• endsectionmaterialdownstream ( nullable: true, editable: true, defaultValue: null, length: 40, type: esriFieldTypeString, modelName: endsectionmaterialdownstream, alias: End Section Material Downstream , Coded Values: [Concrete End Section: Concrete End Section] , [Metal End Section: Metal End Section] , [Metal End Section (Safety-Type): Metal End Section (Safety-Type)] , ...1 more... )
• percentslope ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: percentslope, alias: Percent Slope )
• length_ft ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: length_ft, alias: Length (ft) )
• diameter_in ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: diameter_in, alias: Diameter (in) )
• width_in ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: width_in, alias: Width (in) )
• height_in ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: height_in, alias: Height (in) )
• upperinvertelevation_ft ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: upperinvertelevation_ft, alias: Upper Invert Elevation (ft) )
• lowerinvertelevation_ft ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: lowerinvertelevation_ft, alias: Lower Invert Elevation (ft) )
• featureretiredate ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: featureretiredate, alias: Feature Retire Date )
• description ( nullable: true, editable: true, defaultValue: null, length: 1000, type: esriFieldTypeString, modelName: description, alias: Description )
• notes ( nullable: true, editable: true, defaultValue: null, length: 1000, type: esriFieldTypeString, modelName: notes, alias: Notes )
• creator ( nullable: true, editable: false, defaultValue: null, length: 128, type: esriFieldTypeString, modelName: creator, alias: Creator )
• creationdate ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: creationdate, alias: Creation Date )
• editor ( nullable: true, editable: false, defaultValue: null, length: 128, type: esriFieldTypeString, modelName: editor, alias: Editor )
• editdate ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: editdate, alias: Edit Date )
• facilitystatus ( nullable: true, editable: true, defaultValue: null, length: 512, type: esriFieldTypeString, modelName: facilitystatus, alias: FacilityStatus )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Templates:

• Name: Pipe
  Description:
  Prototype:
  notes: null
  featuresourceid: null
  othersystemnumber: null
  endsectionmaterialdownstream: null
  identification: null
  inspectionstatus_pip: Undetermined
  assetconstructionstatus_pip: null
  maintenanceobligation_pip: null
  offset2_ft: null
  longitude: null
  f_subtype: null
  outfallid: null
  upperinvertelevation_ft: null
  inspectioninterval: null
  assetinstalldate: null
  pipematerial: null
  lastinspectiondate: null
  lowerinvertelevation_ft: null
  featuresource_pip: null
  endconfigurationupstream: null
  facilitystatus_pip: Active
  district: null
  featureretiredate: null
  offset1_ft: null
  length_ft: null
  trashrack: null
  endconfigurationdownstream: null
  latitude: null
  description: null
  milepost2: null
  milepost1: null
  riprapapron: null
  attributesource_pip: null
  maintenancestatus: Undetermined
  assetaccessibility_pip: null
  constructioncontractnumber: null
  diameter_in: null
  attributesourceid: null
  numberofpipes: null
  routeid2: null
  assetowner_pip: null
  percentslope: null
  routeid1: null
  pipeconfiguration: null
  pipelinermaterial: null
  display: null
  rowpermitnumber: null
  endsectionmaterialupstream: null
  facilitystatus: null
  lastmaintenancedate: null
  width_in: null
  assetid: null
  height_in: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• Pipe Inspection (3) -- Related To: Pipe Inspection (15)

Capabilities: Query,Sync,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: editdate
• Editor Field: editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata