Name: End Treatment

Display Field: CNVYNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: ab967a02f912468db093fa62cd483ffa

Copyright Text:

Default Visibility: false

MaxRecordCount: 5000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2411192.972047411
YMin: 1451856.1127215698
XMax: 2475069.4289399125
YMax: 1526218.8071717396
Spatial Reference: 103038  (6457)  VCSWkid(105703)  LatestVCSWkid(6360)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: assetgroup
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 22
  Label: N/A
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ASSETGROUP

Fields:

• OBJECTID ( nullable: false, alias: Object ID, type: esriFieldTypeOID )
• assetid ( nullable: true, length: 64, alias: Structure ID, type: esriFieldTypeString )
• IDOT_survey_code ( nullable: true, alias: IDOT Survey Code, type: esriFieldTypeSmallInteger )
• assetgroup ( nullable: false, alias: Asset group, type: esriFieldTypeInteger )
• surfacewater ( nullable: true, alias: Receives Surface Water, type: esriFieldTypeSmallInteger )
• assettype ( nullable: false, alias: Asset type, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [2: Diversion Manhole] , [3: Junction Manhole] , ...7 more... )
• designtype ( nullable: true, alias: Type, type: esriFieldTypeSmallInteger )
• add_et ( nullable: true, alias: End Treatment Add. Type, type: esriFieldTypeSmallInteger )
• creationdate ( nullable: true, length: 8, alias: Creation date, type: esriFieldTypeDate )
• creator ( nullable: true, length: 255, alias: Creator, type: esriFieldTypeString )
• lastupdate ( nullable: true, length: 8, alias: Last update, type: esriFieldTypeDate )
• updatedby ( nullable: true, length: 255, alias: Updated by, type: esriFieldTypeString )
• globalid ( nullable: false, length: 38, alias: Global ID 2, type: esriFieldTypeGUID )
• material ( nullable: true, alias: Material, type: esriFieldTypeSmallInteger )
• diameter ( nullable: true, alias: Diameter, type: esriFieldTypeDouble )
• length2 ( nullable: true, alias: Length, type: esriFieldTypeDouble )
• width ( nullable: true, alias: Width, type: esriFieldTypeDouble )
• depth ( nullable: true, alias: Depth, type: esriFieldTypeDouble )
• elevation ( nullable: true, alias: Elevation, type: esriFieldTypeDouble )
• pipe_count ( nullable: true, alias: Number of Pipes, type: esriFieldTypeSmallInteger )
• notes ( nullable: true, length: 2000, alias: Notes, type: esriFieldTypeString )
• GlobalID_1 ( nullable: false, length: 38, alias: Global ID, type: esriFieldTypeGlobalID )
• lifecyclestatus ( nullable: false, alias: Lifecycle Status, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• installdate ( nullable: true, length: 8, alias: Install Date, type: esriFieldTypeDate )
• surveydate ( nullable: true, length: 8, alias: Survey Date, type: esriFieldTypeDate )
• inspectdate ( nullable: true, length: 8, alias: Inspection Date, type: esriFieldTypeDate )
• near_address ( nullable: true, length: 255, alias: Nearest Address, type: esriFieldTypeString )
• location ( nullable: true, alias: Structure Location, type: esriFieldTypeSmallInteger )
• surface ( nullable: true, alias: Structure Surface Type, type: esriFieldTypeSmallInteger )
• spatialsource ( nullable: true, alias: Spatial Source, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
• ownedby ( nullable: true, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• maintby ( nullable: true, alias: Maintained By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• sw_system ( nullable: true, alias: sw_system, type: esriFieldTypeSmallInteger , Coded Values: [0: MS4] , [1: CSO] , [2: MS4-GI] , ...1 more... )
• shape ( nullable: false, alias: Shape, type: esriFieldTypeGeometry )
• cmt_proxy_bottomelev ( nullable: true, alias: CMT Proxy Bottom Elevation, type: esriFieldTypeDouble )
• FOTH_DRAC_GIS ( nullable: true, alias: FOTH_DRAC_GIS, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• ESRIGNSS_POSITIONSOURCETYPE ( nullable: true, alias: Position source type, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...3 more... )
• ESRIGNSS_RECEIVER ( nullable: true, length: 50, alias: Receiver Name, type: esriFieldTypeString )
• ESRIGNSS_LATITUDE ( nullable: true, alias: Latitude, type: esriFieldTypeDouble )
• ESRIGNSS_LONGITUDE ( nullable: true, alias: Longitude, type: esriFieldTypeDouble )
• ESRIGNSS_ALTITUDE ( nullable: true, alias: Altitude, type: esriFieldTypeDouble )
• ESRIGNSS_H_RMS ( nullable: true, alias: Horizontal Accuracy (m), type: esriFieldTypeDouble )
• ESRIGNSS_V_RMS ( nullable: true, alias: Vertical Accuracy (m), type: esriFieldTypeDouble )
• ESRIGNSS_FIXDATETIME ( nullable: true, length: 8, alias: Fix Time, type: esriFieldTypeDate )
• ESRIGNSS_FIXTYPE ( nullable: true, alias: Fix Type, type: esriFieldTypeSmallInteger , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• ESRIGNSS_CORRECTIONAGE ( nullable: true, alias: Correction Age, type: esriFieldTypeDouble )
• ESRIGNSS_STATIONID ( nullable: true, alias: Station ID, type: esriFieldTypeSmallInteger , Range: [0, 1023] )
• ESRIGNSS_NUMSATS ( nullable: true, alias: Number of Satellites, type: esriFieldTypeSmallInteger , Range: [0, 99] )
• ESRIGNSS_PDOP ( nullable: true, alias: PDOP, type: esriFieldTypeDouble )
• ESRIGNSS_HDOP ( nullable: true, alias: HDOP, type: esriFieldTypeDouble )
• ESRIGNSS_VDOP ( nullable: true, alias: VDOP, type: esriFieldTypeDouble )
• ESRIGNSS_DIRECTION ( nullable: true, alias: Direction of travel (°), type: esriFieldTypeDouble )
• ESRIGNSS_SPEED ( nullable: true, alias: Speed (km/h), type: esriFieldTypeDouble )
• ESRISNSR_AZIMUTH ( nullable: true, alias: Compass reading (°), type: esriFieldTypeDouble )
• ESRIGNSS_AVG_H_RMS ( nullable: true, alias: Average Horizontal Accuracy (m), type: esriFieldTypeDouble )
• ESRIGNSS_AVG_V_RMS ( nullable: true, alias: Average Vertical Accuracy (m), type: esriFieldTypeDouble )
• ESRIGNSS_AVG_POSITIONS ( nullable: true, alias: Averaged Positions, type: esriFieldTypeSmallInteger )
• ESRIGNSS_H_STDDEV ( nullable: true, alias: Standard Deviation (m), type: esriFieldTypeDouble )

Types:

ID: 0
Name: Unknown
Domains:
• isconnected:
  Inherited
• validationstatus:
  Inherited
• sw_system:
  Inherited
• assettype:
  Coded Values: [0: Unknown]
• CMT_CAD_GIS:
  Inherited

---

ID: 5
Name: Pump
Domains:
• designtype:
  Coded Values: [0: Unknown] , [1: Centerfugal Pump] , [2: Duplex Pump] , ...4 more...
• spatialsource:
  Inherited
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• sw_system:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [61: Pump]
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• CMT_CAD_GIS:
  Inherited

---

ID: 26
Name: Weir
Domains:
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• shape_struct:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• spatialsource:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• CMT_CAD_GIS:
  Inherited
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• material:
  Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
• material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• sw_system:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [281: Broad-Crested] , [282: Combination] , ...4 more...

---

ID: 21
Name: Cleanout
Domains:
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• spatialsource:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• CMT_CAD_GIS:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more...
• material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...24 more...
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• sw_system:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [1: Cleanout]

---

ID: 29
Name: BMP Point
Domains:
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• spatialsource:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• CMT_CAD_GIS:
  Inherited
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• material:
  Coded Values: [0: Unknown] , [1: Amended Soil] , [2: Biochar] , ...13 more...
• material_struct:
  Coded Values: [0: Unknown] , [1: Amended Soil] , [2: Biochar] , ...13 more...
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• sw_system:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [2: Detention Basin] , [3: Dry Basin] , ...15 more...

---

ID: 30
Name: BMP Inlet
Domains:
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• spatialsource:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• CMT_CAD_GIS:
  Inherited
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...25 more...
• designtype:
  Coded Values: [0: Unknown] , [9: Tide Gate Chamber] , [11: Flap Gate] , ...5 more...
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• sw_system:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [6: Apron Inlet] , [7: Pipe Inlet] , ...1 more...

---

ID: 23
Name: Connection
Domains:
• spatialsource:
  Inherited
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• sw_system:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [241: Pipe Connection] , [242: Open Channel Connection] , ...1 more...
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• CMT_CAD_GIS:
  Inherited

---

ID: 32
Name: Manhole
Domains:
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• shape_struct:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• spatialsource:
  Inherited
• lifecyclestatus:
  Inherited
• CMT_CAD_GIS:
  Inherited
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• material:
  Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
• designtype:
  Coded Values: [0: Unknown] , [3: Solid] , [4: Vented/Slotted] , ...4 more...
• inletshape:
  Coded Values: [0: Unknown] , [3: Arched (with flat bottom)] , [4: Barrel] , ...9 more...
• material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• sw_system:
  Inherited
• ownedby:
  Inherited
• assettype:
  Inherited
• conetype:
  Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...

---

ID: 28
Name: Inlet
Domains:
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• shape_struct:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• spatialsource:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• CMT_CAD_GIS:
  Inherited
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• material:
  Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
• designtype:
  Coded Values: [0: Unknown] , [1: Curb Opening] , [2: Grate] , ...1 more...
• inletshape:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• sw_system:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [204: Infiltration] , [210: Drop Inlet] , ...1 more...
• conetype:
  Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...

---

ID: 33
Name: Turn-down 90
Domains:
• spatialsource:
  Inherited
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• sw_system:
  Inherited
• ownedby:
  Inherited
• lifecyclestatus:
  Inherited
• CMT_CAD_GIS:
  Inherited

---

ID: 22
Name: End Treatment
Domains:
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• spatialsource:
  Inherited
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• CMT_CAD_GIS:
  Inherited
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
• material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...25 more...
• designtype:
  Coded Values: [0: Unknown] , [9: Tide Gate Chamber] , [11: Flap Gate] , ...5 more...
• isconnected:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• add_et:
  Coded Values: [0: N/A] , [1: Flap Gate] , [2: Apron] , ...4 more...
• sw_system:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [3: Culvert Inlet] , [4: Culvert Outlet] , ...2 more...

---

Relationships:

• SDE.DischargeInspection_1 (0) -- Related To: End Treatment Inspection (48)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata