View In:   ArcGIS Online Map Viewer

Name: COLEGEODEV.DBO.Inlet

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 20000

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: 6208828.942126811
YMin: 2170612.990450144
XMax: 6267276.81735681
YMax: 2205353.1939354837
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: assettype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 4
  Label: Catch Basin Inlet
  Description: N/A
  Symbol:
  
• Value: 5
  Label: Drop Inlet
  Description: N/A
  Symbol:
  
• Value: 6
  Label: Flow Control Structure
  Description: N/A
  Symbol:
  
• Value: 1
  Label: Inlet
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Parkway Drain
  Description: N/A
  Symbol:
  
• Value: 2
  Label: StandPipeInlet
  Description: N/A
  Symbol:
  
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: assettype

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] , [1: Standard] , [2: StandPipeInlet] , ...4 more... )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Asset Owner, editable: true, nullable: true, defaultValue: null, modelName: ownedby , Coded Values: [1: Our Agency] , [100: Other] , [2: Private] )
• maintby ( type: esriFieldTypeSmallInteger, alias: Asset Manager, editable: true, nullable: true, defaultValue: null, modelName: maintby , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• symbolrotation ( type: esriFieldTypeSmallInteger, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: symbolrotation , Range: [0, 359] )
• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: assetid )
• diameter ( type: esriFieldTypeDouble, alias: Access Diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more... )
• depth ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: depth )
• invertelev ( type: esriFieldTypeDouble, alias: Invert Elevation, editable: true, nullable: true, defaultValue: null, modelName: invertelev )
• rimelev ( type: esriFieldTypeDouble, alias: Rim Elevation, editable: true, nullable: true, defaultValue: null, modelName: rimelev )
• designtype ( type: esriFieldTypeSmallInteger, alias: Inlet Type, editable: true, nullable: true, defaultValue: null, modelName: designtype , Coded Values: [0: Unknown] , [1: Grate] , [2: Double Grate] , ...6 more... )
• material ( type: esriFieldTypeSmallInteger, alias: Access Material, editable: true, nullable: true, defaultValue: null, modelName: material , Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...32 more... )
• surfacewater ( type: esriFieldTypeSmallInteger, alias: Recieves Surface Water, editable: true, nullable: true, defaultValue: null, modelName: surfacewater , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• exitsystem ( type: esriFieldTypeSmallInteger, alias: Water Existing System, editable: true, nullable: true, defaultValue: null, modelName: exitsystem , Coded Values: [0: Unknown] , [1: Waterway] , [2: Other System] , ...1 more... )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Life Cycle 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 )
• INLETTYPE ( type: esriFieldTypeString, alias: Inlet Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INLETTYPE )
• ACCESSDIAM ( type: esriFieldTypeDouble, alias: Access Diameter, editable: true, nullable: true, defaultValue: null, modelName: ACCESSDIAM )
• ACCESSMAT ( type: esriFieldTypeString, alias: Access Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACCESSMAT )
• ACCESSTYPE ( type: esriFieldTypeString, alias: Access Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACCESSTYPE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: null, modelName: ENABLED )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: null, modelName: ACTIVEFLAG )
• AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: null, modelName: AncillaryRole )
• 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 )
• 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 )
• 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: 30, defaultValue: null, modelName: LaserFiche_Scan_No )
• DigitizedMethod ( type: esriFieldTypeSmallInteger, alias: DigitizedMethod, editable: true, nullable: true, defaultValue: null, modelName: DigitizedMethod )
• Outflow_Invert ( type: esriFieldTypeDouble, alias: Outflow_Invert, editable: true, nullable: true, defaultValue: null, modelName: Outflow_Invert )
• Rotation ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: Rotation )
• DwgNo ( type: esriFieldTypeString, alias: DwgNo, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DwgNo )
• DesignFlowRate ( type: esriFieldTypeDouble, alias: DesignFlowRate, editable: true, nullable: true, defaultValue: null, modelName: DesignFlowRate )
• Remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Remarks )
• Opening ( type: esriFieldTypeDouble, alias: Opening, editable: true, nullable: true, defaultValue: null, modelName: Opening )
• Height1 ( type: esriFieldTypeDouble, alias: Height1, editable: true, nullable: true, defaultValue: null, modelName: Height1 )
• Height2 ( type: esriFieldTypeDouble, alias: Height2, editable: true, nullable: true, defaultValue: null, modelName: Height2 )
• GradeElevation ( type: esriFieldTypeDouble, alias: GradeElevation, editable: true, nullable: true, defaultValue: null, modelName: GradeElevation )
• inlet_basket ( type: esriFieldTypeInteger, alias: Inlet Basket, editable: true, nullable: true, defaultValue: -1, modelName: inlet_basket , Coded Values: [-1: NOT OBSERVED] , [0: MISSING] , [1: PRESENT] , ...1 more... )

Types:

ID: 4
Name: Catch Basin Inlet
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• diameter:
  Inherited
• designtype:
  Inherited
• material:
  Inherited
• surfacewater:
  Inherited
• exitsystem:
  Inherited
• lifecyclestatus:
  Inherited
• inlet_basket:
  Inherited
Templates:
• Name: Catch Basin Inlet
  Description:
  Prototype:
  exitsystem: null
  inlet_basket: -1
  GradeElevation: null
  assettype: 4
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  diameter: null
  depth: null
  invertelev: null
  rimelev: null
  designtype: null
  material: null
  surfacewater: null
  lifecyclestatus: 0
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  INLETTYPE: null
  ACCESSDIAM: null
  ACCESSMAT: null
  ACCESSTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  Rotation: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  Opening: null
  Height1: null
  Height2: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: Drop Inlet
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• diameter:
  Inherited
• designtype:
  Inherited
• material:
  Inherited
• surfacewater:
  Inherited
• exitsystem:
  Inherited
• lifecyclestatus:
  Inherited
• inlet_basket:
  Inherited
Templates:
• Name: Drop Inlet
  Description:
  Prototype:
  exitsystem: null
  inlet_basket: -1
  GradeElevation: null
  assettype: 5
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  diameter: null
  depth: null
  invertelev: null
  rimelev: null
  designtype: null
  material: null
  surfacewater: null
  lifecyclestatus: 0
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  INLETTYPE: null
  ACCESSDIAM: null
  ACCESSMAT: null
  ACCESSTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  Rotation: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  Opening: null
  Height1: null
  Height2: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: Flow Control Structure
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• diameter:
  Inherited
• designtype:
  Inherited
• material:
  Inherited
• surfacewater:
  Inherited
• exitsystem:
  Inherited
• lifecyclestatus:
  Inherited
• inlet_basket:
  Inherited
Templates:
• Name: Flow Control Structure
  Description:
  Prototype:
  exitsystem: null
  inlet_basket: -1
  GradeElevation: null
  assettype: 6
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  diameter: null
  depth: null
  invertelev: null
  rimelev: null
  designtype: null
  material: null
  surfacewater: null
  lifecyclestatus: 0
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  INLETTYPE: null
  ACCESSDIAM: null
  ACCESSMAT: null
  ACCESSTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  Rotation: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  Opening: null
  Height1: null
  Height2: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: Inlet
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• diameter:
  Inherited
• designtype:
  Inherited
• material:
  Inherited
• surfacewater:
  Inherited
• exitsystem:
  Inherited
• lifecyclestatus:
  Inherited
• inlet_basket:
  Inherited
Templates:
• Name: Inlet
  Description:
  Prototype:
  exitsystem: null
  inlet_basket: -1
  GradeElevation: null
  assettype: 1
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  diameter: null
  depth: null
  invertelev: null
  rimelev: null
  designtype: null
  material: null
  surfacewater: null
  lifecyclestatus: 0
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  INLETTYPE: null
  ACCESSDIAM: null
  ACCESSMAT: null
  ACCESSTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  Rotation: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  Opening: null
  Height1: null
  Height2: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Parkway Drain
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• diameter:
  Inherited
• designtype:
  Inherited
• material:
  Inherited
• surfacewater:
  Inherited
• exitsystem:
  Inherited
• lifecyclestatus:
  Inherited
• inlet_basket:
  Inherited
Templates:
• Name: Parkway Drain
  Description:
  Prototype:
  exitsystem: null
  inlet_basket: -1
  GradeElevation: null
  assettype: 3
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  diameter: null
  depth: null
  invertelev: null
  rimelev: null
  designtype: null
  material: null
  surfacewater: null
  lifecyclestatus: 0
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  INLETTYPE: null
  ACCESSDIAM: null
  ACCESSMAT: null
  ACCESSTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  Rotation: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  Opening: null
  Height1: null
  Height2: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: StandPipeInlet
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• diameter:
  Inherited
• designtype:
  Inherited
• material:
  Inherited
• surfacewater:
  Inherited
• exitsystem:
  Inherited
• lifecyclestatus:
  Inherited
• inlet_basket:
  Inherited
Templates:
• Name: StandPipeInlet
  Description:
  Prototype:
  exitsystem: null
  inlet_basket: -1
  GradeElevation: null
  assettype: 2
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  diameter: null
  depth: null
  invertelev: null
  rimelev: null
  designtype: null
  material: null
  surfacewater: null
  lifecyclestatus: 0
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  INLETTYPE: null
  ACCESSDIAM: null
  ACCESSMAT: null
  ACCESSTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  Rotation: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  Opening: null
  Height1: null
  Height2: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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