View In:   ArcGIS Online Map Viewer

Name: COLEGEODEV.DBO.Open_Channel

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: 6210795.629138306
YMin: 2170996.5369271487
XMax: 6266805.872104466
YMax: 2203413.087579474
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: CHANNELTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: DoubleBoxCulvert
  Label: Double Box Culvert
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [85, 255, 0, 255]
  Width: 1
• Value: EarthenChannel
  Label: Earthen Channel
  Description: N/A
  Symbol:
  Style: esriSLSDashDotDot
  Color: [255, 170, 0, 255]
  Width: 2
• Value: TransitionStructure
  Label: Transition Structure
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [0, 92, 230, 255]
  Width: 1
• Value: Rectangular
  Label: Rectangular
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [112, 68, 137, 255]
  Width: 1
• Value: Swale
  Label: Swale
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 1
• Value: VDitch
  Label: VDitch
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 1
• Value: Trapezoidal
  Label: Trapezoidal
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [76, 115, 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

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: CHANNELTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset type, editable: true, nullable: false, defaultValue: null, modelName: assettype , Coded Values: [0: Unknown] , [41: Vegetated] , [42: Hardened] , ...7 more... )
• diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...35 more... )
• upelev ( type: esriFieldTypeDouble, alias: Upstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: upelev )
• downelev ( type: esriFieldTypeDouble, alias: Downstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: downelev )
• slope ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: slope )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: ownedby , Coded Values: [1: Our Agency] , [100: Other] , [2: Private] )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: null, modelName: maintby , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• pipeshape ( type: esriFieldTypeSmallInteger, alias: Shape, editable: true, nullable: true, defaultValue: null, modelName: pipeshape , Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...5 more... )
• type ( type: esriFieldTypeSmallInteger, alias: Type, editable: true, nullable: true, defaultValue: null, modelName: type , Coded Values: [0: Unknown] , [3: Wet] , [4: Dry] )
• lined ( type: esriFieldTypeSmallInteger, alias: Lined?, editable: true, nullable: true, defaultValue: null, modelName: lined )
• lineryear ( type: esriFieldTypeSmallInteger, alias: Liner Year, editable: true, nullable: true, defaultValue: null, modelName: lineryear )
• linermethod ( type: esriFieldTypeSmallInteger, alias: Liner Method, editable: true, nullable: true, defaultValue: null, modelName: linermethod )
• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: assetid )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status, editable: true, nullable: false, defaultValue: null, modelName: lifecyclestatus , Coded Values: [0: Unknown] , [1: Proposed] , [2: Proposed - Approved] , ...4 more... )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• CHANNELTYPE ( type: esriFieldTypeString, alias: Channel Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CHANNELTYPE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCDESC )
• HEIGHT ( type: esriFieldTypeDouble, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: HEIGHT )
• WIDTH ( type: esriFieldTypeDouble, alias: Width, editable: true, nullable: true, defaultValue: null, modelName: WIDTH )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONDITION )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: null, modelName: Enabled )
• FeatureType ( type: esriFieldTypeString, alias: FeatureType, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FeatureType )
• FeatureID ( type: esriFieldTypeString, alias: FeatureID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FeatureID )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Material )
• CrossSectionShape ( type: esriFieldTypeString, alias: CrossSectionShape, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CrossSectionShape )
• Diameter_Height ( type: esriFieldTypeInteger, alias: Diameter_Height, editable: true, nullable: true, defaultValue: null, modelName: Diameter_Height )
• LeftSS ( type: esriFieldTypeString, alias: LeftSS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LeftSS )
• RightSS ( type: esriFieldTypeString, alias: RightSS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RightSS )
• BaseWidth ( type: esriFieldTypeInteger, alias: BaseWidth, editable: true, nullable: true, defaultValue: null, modelName: BaseWidth )
• Pier ( type: esriFieldTypeDouble, alias: Pier, editable: true, nullable: true, defaultValue: null, modelName: Pier )
• DwgNo ( type: esriFieldTypeString, alias: DwgNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DwgNo )
• UpStreamInvert ( type: esriFieldTypeDouble, alias: UpStreamInvert, editable: true, nullable: true, defaultValue: null, modelName: UpStreamInvert )
• DownStreamInvert ( type: esriFieldTypeDouble, alias: DownStreamInvert, editable: true, nullable: true, defaultValue: null, modelName: DownStreamInvert )
• PipeLength ( type: esriFieldTypeDouble, alias: PipeLength, editable: true, nullable: true, defaultValue: null, modelName: PipeLength )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Owner )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Status )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Source )
• GridNo ( type: esriFieldTypeString, alias: GridNo, editable: true, nullable: true, length: 15, defaultValue: null, modelName: GridNo )
• LaserFiche_Scan_No ( type: esriFieldTypeString, alias: LaserFiche_Scan_No, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LaserFiche_Scan_No )
• Asbuilt ( type: esriFieldTypeSmallInteger, alias: Asbuilt, editable: true, nullable: true, defaultValue: null, modelName: Asbuilt )
• Barcode ( type: esriFieldTypeString, alias: Barcode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Barcode )
• SheetNo ( type: esriFieldTypeString, alias: SheetNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SheetNo )
• Offset ( type: esriFieldTypeString, alias: Offset, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Offset )
• DigitizedMethod ( type: esriFieldTypeSmallInteger, alias: DigitizedMethod, editable: true, nullable: true, defaultValue: null, modelName: DigitizedMethod )
• DesignFlowRate ( type: esriFieldTypeDouble, alias: DesignFlowRate, editable: true, nullable: true, defaultValue: null, modelName: DesignFlowRate )
• PipeAge ( type: esriFieldTypeString, alias: PipeAge, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PipeAge )
• GeoTiff ( type: esriFieldTypeString, alias: GeoTiff, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeoTiff )
• Remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Remarks )
• Q10 ( type: esriFieldTypeDouble, alias: Q10, editable: true, nullable: true, defaultValue: null, modelName: Q10 )
• Q50 ( type: esriFieldTypeDouble, alias: Q50, editable: true, nullable: true, defaultValue: null, modelName: Q50 )
• Q100 ( type: esriFieldTypeDouble, alias: Q100, editable: true, nullable: true, defaultValue: null, modelName: Q100 )
• Shape__Length ( type: esriFieldTypeDouble, alias: shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: shape.STLength() )

Types:

ID: DoubleBoxCulvert
Name: Double Box Culvert
Domains:
• assettype:
  Inherited
• diameter:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• pipeshape:
  Inherited
• type:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: Double Box Culvert
  Description:
  Prototype:
  FACILITYID: null
  assetid: null
  Q100: null
  assettype: 0
  diameter: null
  upelev: null
  downelev: null
  slope: null
  installdate: null
  ownedby: null
  maintby: null
  pipeshape: null
  type: null
  lined: null
  lineryear: null
  linermethod: null
  lifecyclestatus: 0
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  CHANNELTYPE: DoubleBoxCulvert
  LOCDESC: null
  HEIGHT: null
  WIDTH: null
  CONDITION: null
  COMMENTS: null
  Enabled: null
  FeatureType: null
  FeatureID: null
  Material: null
  CrossSectionShape: null
  Diameter_Height: null
  LeftSS: null
  RightSS: null
  BaseWidth: null
  Pier: null
  DwgNo: null
  UpStreamInvert: null
  DownStreamInvert: null
  PipeLength: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Offset: null
  DigitizedMethod: null
  DesignFlowRate: null
  PipeAge: null
  GeoTiff: null
  Remarks: null
  Q10: null
  Q50: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: EarthenChannel
Name: Earthen Channel
Domains:
• assettype:
  Inherited
• diameter:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• pipeshape:
  Inherited
• type:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: Earthen Channel
  Description:
  Prototype:
  FACILITYID: null
  assetid: null
  Q100: null
  assettype: 0
  diameter: null
  upelev: null
  downelev: null
  slope: null
  installdate: null
  ownedby: null
  maintby: null
  pipeshape: null
  type: null
  lined: null
  lineryear: null
  linermethod: null
  lifecyclestatus: 0
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  CHANNELTYPE: EarthenChannel
  LOCDESC: null
  HEIGHT: null
  WIDTH: null
  CONDITION: null
  COMMENTS: null
  Enabled: null
  FeatureType: null
  FeatureID: null
  Material: null
  CrossSectionShape: null
  Diameter_Height: null
  LeftSS: null
  RightSS: null
  BaseWidth: null
  Pier: null
  DwgNo: null
  UpStreamInvert: null
  DownStreamInvert: null
  PipeLength: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Offset: null
  DigitizedMethod: null
  DesignFlowRate: null
  PipeAge: null
  GeoTiff: null
  Remarks: null
  Q10: null
  Q50: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: TransitionStructure
Name: Transition Structure
Domains:
• assettype:
  Inherited
• diameter:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• pipeshape:
  Inherited
• type:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: Transition Structure
  Description:
  Prototype:
  FACILITYID: null
  assetid: null
  Q100: null
  assettype: 0
  diameter: null
  upelev: null
  downelev: null
  slope: null
  installdate: null
  ownedby: null
  maintby: null
  pipeshape: null
  type: null
  lined: null
  lineryear: null
  linermethod: null
  lifecyclestatus: 0
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  CHANNELTYPE: TransitionStructure
  LOCDESC: null
  HEIGHT: null
  WIDTH: null
  CONDITION: null
  COMMENTS: null
  Enabled: null
  FeatureType: null
  FeatureID: null
  Material: null
  CrossSectionShape: null
  Diameter_Height: null
  LeftSS: null
  RightSS: null
  BaseWidth: null
  Pier: null
  DwgNo: null
  UpStreamInvert: null
  DownStreamInvert: null
  PipeLength: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Offset: null
  DigitizedMethod: null
  DesignFlowRate: null
  PipeAge: null
  GeoTiff: null
  Remarks: null
  Q10: null
  Q50: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Rectangular
Name: Rectangular
Domains:
• assettype:
  Inherited
• diameter:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• pipeshape:
  Inherited
• type:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: Rectangular
  Description:
  Prototype:
  FACILITYID: null
  assetid: null
  Q100: null
  assettype: 0
  diameter: null
  upelev: null
  downelev: null
  slope: null
  installdate: null
  ownedby: null
  maintby: null
  pipeshape: null
  type: null
  lined: null
  lineryear: null
  linermethod: null
  lifecyclestatus: 0
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  CHANNELTYPE: Rectangular
  LOCDESC: null
  HEIGHT: null
  WIDTH: null
  CONDITION: null
  COMMENTS: null
  Enabled: null
  FeatureType: null
  FeatureID: null
  Material: null
  CrossSectionShape: null
  Diameter_Height: null
  LeftSS: null
  RightSS: null
  BaseWidth: null
  Pier: null
  DwgNo: null
  UpStreamInvert: null
  DownStreamInvert: null
  PipeLength: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Offset: null
  DigitizedMethod: null
  DesignFlowRate: null
  PipeAge: null
  GeoTiff: null
  Remarks: null
  Q10: null
  Q50: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Swale
Name: Swale
Domains:
• assettype:
  Inherited
• diameter:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• pipeshape:
  Inherited
• type:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: Swale
  Description:
  Prototype:
  FACILITYID: null
  assetid: null
  Q100: null
  assettype: 0
  diameter: null
  upelev: null
  downelev: null
  slope: null
  installdate: null
  ownedby: null
  maintby: null
  pipeshape: null
  type: null
  lined: null
  lineryear: null
  linermethod: null
  lifecyclestatus: 0
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  CHANNELTYPE: Swale
  LOCDESC: null
  HEIGHT: null
  WIDTH: null
  CONDITION: null
  COMMENTS: null
  Enabled: null
  FeatureType: null
  FeatureID: null
  Material: null
  CrossSectionShape: null
  Diameter_Height: null
  LeftSS: null
  RightSS: null
  BaseWidth: null
  Pier: null
  DwgNo: null
  UpStreamInvert: null
  DownStreamInvert: null
  PipeLength: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Offset: null
  DigitizedMethod: null
  DesignFlowRate: null
  PipeAge: null
  GeoTiff: null
  Remarks: null
  Q10: null
  Q50: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: VDitch
Name: VDitch
Domains:
• assettype:
  Inherited
• diameter:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• pipeshape:
  Inherited
• type:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: VDitch
  Description:
  Prototype:
  FACILITYID: null
  assetid: null
  Q100: null
  assettype: 0
  diameter: null
  upelev: null
  downelev: null
  slope: null
  installdate: null
  ownedby: null
  maintby: null
  pipeshape: null
  type: null
  lined: null
  lineryear: null
  linermethod: null
  lifecyclestatus: 0
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  CHANNELTYPE: VDitch
  LOCDESC: null
  HEIGHT: null
  WIDTH: null
  CONDITION: null
  COMMENTS: null
  Enabled: null
  FeatureType: null
  FeatureID: null
  Material: null
  CrossSectionShape: null
  Diameter_Height: null
  LeftSS: null
  RightSS: null
  BaseWidth: null
  Pier: null
  DwgNo: null
  UpStreamInvert: null
  DownStreamInvert: null
  PipeLength: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Offset: null
  DigitizedMethod: null
  DesignFlowRate: null
  PipeAge: null
  GeoTiff: null
  Remarks: null
  Q10: null
  Q50: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Trapezoidal
Name: Trapezoidal
Domains:
• assettype:
  Inherited
• diameter:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• pipeshape:
  Inherited
• type:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: Trapezoidal
  Description:
  Prototype:
  FACILITYID: null
  assetid: null
  Q100: null
  assettype: 0
  diameter: null
  upelev: null
  downelev: null
  slope: null
  installdate: null
  ownedby: null
  maintby: null
  pipeshape: null
  type: null
  lined: null
  lineryear: null
  linermethod: null
  lifecyclestatus: 0
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  CHANNELTYPE: Trapezoidal
  LOCDESC: null
  HEIGHT: null
  WIDTH: null
  CONDITION: null
  COMMENTS: null
  Enabled: null
  FeatureType: null
  FeatureID: null
  Material: null
  CrossSectionShape: null
  Diameter_Height: null
  LeftSS: null
  RightSS: null
  BaseWidth: null
  Pier: null
  DwgNo: null
  UpStreamInvert: null
  DownStreamInvert: null
  PipeLength: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Offset: null
  DigitizedMethod: null
  DesignFlowRate: null
  PipeAge: null
  GeoTiff: null
  Remarks: null
  Q10: null
  Q50: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata