Name: Stormwater Device

Display Field: creator

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 04a051e4298748f9ae0ffe5744362589

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2477888.3245488293
YMin: 1405359.5754654855
XMax: 2478121.122311577
YMax: 1405765.1379745752
Spatial Reference: 103038  (6457)

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: 0
  Label: Unknown
  Description: N/A
  Symbol:
  
• Value: 5
  Label: Pump
  Description: N/A
  Symbol:
  
• Value: 21
  Label: Cleanout
  Description: N/A
  Symbol:
  
• Value: 22
  Label: End Treatment
  Description: N/A
  Symbol:
  
• Value: 23
  Label: Connection
  Description: N/A
  Symbol:
  
• Value: 26
  Label: Weir
  Description: N/A
  Symbol:
  
• Value: 28
  Label: Inlet
  Description: N/A
  Symbol:
  
• Value: 29
  Label: BMP Point
  Description: N/A
  Symbol:
  
• Value: 30
  Label: BMP Inlet
  Description: N/A
  Symbol:
  
• Value: 32
  Label: Manhole
  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: 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 ( type: esriFieldTypeOID, alias: Object ID )
• assetid ( type: esriFieldTypeString, alias: Structure ID, length: 64 )
• assetgroup ( type: esriFieldTypeInteger, alias: Asset group )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset type )
• designtype ( type: esriFieldTypeSmallInteger, alias: Type )
• inletshape ( type: esriFieldTypeSmallInteger, alias: Inlet Shape )
• add_et ( type: esriFieldTypeSmallInteger, alias: add_et )
• elevation ( type: esriFieldTypeDouble, alias: Elevation )
• bottom_elevation ( type: esriFieldTypeDouble, alias: Bottom Elevation )
• surveydate ( type: esriFieldTypeDate, alias: Survey Date, length: 8 )
• inspectdate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• IDOT_survey_code ( type: esriFieldTypeSmallInteger, alias: IDOT Survey Code )
• material ( type: esriFieldTypeSmallInteger, alias: Material )
• diameter ( type: esriFieldTypeDouble, alias: Diameter )
• length2 ( type: esriFieldTypeDouble, alias: Length )
• width ( type: esriFieldTypeDouble, alias: Width )
• depth ( type: esriFieldTypeDouble, alias: Depth )
• notes ( type: esriFieldTypeString, alias: Notes, length: 2000 )
• pipe_count ( type: esriFieldTypeSmallInteger, alias: Number of Pipes )
• conetype ( type: esriFieldTypeSmallInteger, alias: Cone type )
• location ( type: esriFieldTypeSmallInteger, alias: Structure Location )
• surface ( type: esriFieldTypeSmallInteger, alias: Structure Surface Type )
• shape_struct ( type: esriFieldTypeSmallInteger, alias: Inside Strcture Shape )
• material_struct ( type: esriFieldTypeSmallInteger, alias: Inside Structure Material )
• surfacewater ( type: esriFieldTypeSmallInteger, alias: Receives Surface Water )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
• MACP ( type: esriFieldTypeDouble, alias: MACP score )
• installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• validationstatus ( type: esriFieldTypeSmallInteger, alias: Validation status , Coded Values: [0: No calculation required, no validation required, no error] , [1: No calculation required, no validation required, has error(s)] , [2: No calculation required, validation required, no error] , ...5 more... )
• shape ( type: esriFieldTypeGeometry, alias: Shape )
• isconnected ( type: esriFieldTypeSmallInteger, alias: Is connected , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• creationdate ( type: esriFieldTypeDate, alias: Creation date, length: 8 )
• creator ( type: esriFieldTypeString, alias: Creator, length: 255 )
• lastupdate ( type: esriFieldTypeDate, alias: Last update, length: 8 )
• updatedby ( type: esriFieldTypeString, alias: Updated by, length: 255 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: Global ID, length: 38 )
• globalid ( type: esriFieldTypeGUID, alias: Global ID 2, length: 38 )

Types:

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

---

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

---

ID: 26
Name: Weir
Domains:
• assettype:
  Coded Values: [0: Unknown] , [281: Broad-Crested] , [282: Combination] , ...4 more...
• isconnected:
  Inherited
• ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [5: Cast Iron - CAS] , ...9 more...
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• spatialsource:
  Inherited
• validationstatus:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• shape_struct:
  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...

---

ID: 21
Name: Cleanout
Domains:
• assettype:
  Coded Values: [0: Unknown] , [1: Cleanout]
• isconnected:
  Inherited
• ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• 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...
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• spatialsource:
  Inherited
• validationstatus:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...

---

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

---

ID: 30
Name: BMP Inlet
Domains:
• assettype:
  Coded Values: [0: Unknown] , [6: Apron Inlet] , [7: Pipe Inlet] , ...1 more...
• isconnected:
  Inherited
• ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• 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...
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• spatialsource:
  Inherited
• validationstatus:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...

---

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

---

ID: 32
Name: Manhole
Domains:
• assettype:
  Coded Values: [0: Unknown] , [2: Diversion Manhole] , [3: Junction Manhole] , ...7 more...
• isconnected:
  Inherited
• ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more...
• material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [5: Cast Iron - CAS] , ...9 more...
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• lifecyclestatus:
  Inherited
• spatialsource:
  Inherited
• designtype:
  Coded Values: [0: Unknown] , [3: Solid] , [4: Vented/Slotted] , ...4 more...
• inletshape:
  Coded Values: [0: Unknown] , [3: Arched (with flat bottom) - A] , [4: Barrel - B] , ...9 more...
• validationstatus:
  Inherited
• conetype:
  Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• shape_struct:
  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...

---

ID: 28
Name: Inlet
Domains:
• assettype:
  Coded Values: [0: Unknown] , [204: Infiltration] , [210: Drop Inlet] , ...1 more...
• isconnected:
  Inherited
• ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more...
• material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [5: Cast Iron - CAS] , ...9 more...
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• spatialsource:
  Inherited
• designtype:
  Coded Values: [0: Unknown] , [1: Curb Opening] , [2: Grate] , ...1 more...
• inletshape:
  Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
• validationstatus:
  Inherited
• conetype:
  Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• shape_struct:
  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...

---

ID: 22
Name: End Treatment
Domains:
• assettype:
  Coded Values: [0: Unknown] , [1: SW Inlet] , [2: SW Outlet] , ...2 more...
• isconnected:
  Inherited
• ownedby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• maintby:
  Coded Values: [1: Our Agency] , [2: Private] , [100: Other]
• 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...
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• spatialsource:
  Inherited
• designtype:
  Coded Values: [0: Unknown] , [9: Tide Gate Chamber] , [11: Flap Gate] , ...5 more...
• validationstatus:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...24 more...
• add_et:
  Coded Values: [0: N/A] , [1: Flap Gate] , [2: Apron] , ...3 more...

---

Relationships:

• DischargeInspection (0) -- Related To: End Treatment Inspection (6)
• StormwaterBMPInspection (1) -- Related To: BMP Inspection (5)

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

  Iteminfo   Thumbnail   Metadata