View In:   ArcGIS Online Map Viewer

Parent Layer: Storm

Name: Stormwater Structure

Display Field: assetgroup

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 0f739664893f42f8bdb01bbb63cc551c

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

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

Supports Datum Transformation: true

Extent:

XMin: 2485267.6277035773
YMin: 1490793.3343876526
XMax: 2495685.2056216635
YMax: 1499162.0246712416
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:
Default Label: Other
UniqueValueInfos:
• Value: 28
  Label: Inlet
  Description: N/A
  Symbol:
  
• Value: 32
  Label: Manhole
  Description: N/A
  Symbol:
  
• Value: 22
  Label: End Treatment
  Description: N/A
  Symbol:
  
• Value: 23
  Label: Connection
  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: 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: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
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 ( modelName: OBJECTID, nullable: false, editable: false, defaultValue: N/A, alias: Object ID, type: esriFieldTypeOID )
• assetid ( modelName: assetid, nullable: true, editable: true, defaultValue: N/A, length: 64, alias: Structure ID, type: esriFieldTypeString )
• assetgroup ( modelName: assetgroup, nullable: false, editable: true, defaultValue: 0, alias: Asset group, type: esriFieldTypeInteger, required: true )
• assettype ( modelName: assettype, nullable: false, editable: true, defaultValue: 0, alias: Asset type, type: esriFieldTypeSmallInteger, required: true )
• designtype ( modelName: designtype, nullable: true, editable: true, defaultValue: N/A, alias: Type, type: esriFieldTypeSmallInteger )
• add_et ( modelName: add_et, nullable: true, editable: true, defaultValue: N/A, alias: Add Type End Treatment, type: esriFieldTypeSmallInteger )
• inletshape ( modelName: inletshape, nullable: true, editable: true, defaultValue: N/A, alias: F&G/Lid Shape, type: esriFieldTypeSmallInteger )
• material ( modelName: material, nullable: true, editable: true, defaultValue: N/A, alias: F&G/Lid Material, type: esriFieldTypeSmallInteger )
• conetype ( modelName: conetype, nullable: true, editable: true, defaultValue: N/A, alias: Cone type, type: esriFieldTypeSmallInteger )
• material_struct ( modelName: material_struct, nullable: true, editable: true, defaultValue: N/A, alias: Inside Structure Material, type: esriFieldTypeSmallInteger )
• shape_struct ( modelName: shape_struct, nullable: true, editable: true, defaultValue: N/A, alias: Inside Strcture Shape, type: esriFieldTypeSmallInteger )
• diameter ( modelName: diameter, nullable: true, editable: true, defaultValue: N/A, alias: Diameter, type: esriFieldTypeDouble )
• length2 ( modelName: length2, nullable: true, editable: true, defaultValue: N/A, alias: Length, type: esriFieldTypeDouble )
• width ( modelName: width, nullable: true, editable: true, defaultValue: N/A, alias: Width, type: esriFieldTypeDouble )
• depth ( modelName: depth, nullable: true, editable: true, defaultValue: N/A, alias: Depth, type: esriFieldTypeDouble )
• elevation ( modelName: elevation, nullable: true, editable: true, defaultValue: N/A, alias: Rim Elevation, type: esriFieldTypeDouble )
• bottom_elevation ( modelName: bottom_elevation, nullable: true, editable: true, defaultValue: N/A, alias: Bottom Elevation, type: esriFieldTypeDouble )
• pipe_count ( modelName: pipe_count, nullable: true, editable: true, defaultValue: N/A, alias: Number of Pipes, type: esriFieldTypeSmallInteger )
• surfacewater ( modelName: surfacewater, nullable: true, editable: true, defaultValue: N/A, alias: Receives Surface Water, type: esriFieldTypeSmallInteger )
• lifecyclestatus ( modelName: lifecyclestatus, nullable: false, editable: true, defaultValue: 8, alias: Lifecycle Status, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• surveydate ( modelName: surveydate, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Survey Date, type: esriFieldTypeDate )
• installdate ( modelName: installdate, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Install Date, type: esriFieldTypeDate )
• inspectdate ( modelName: inspectdate, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Inspection Date, type: esriFieldTypeDate )
• notes ( modelName: notes, nullable: true, editable: true, defaultValue: N/A, length: 2000, alias: Notes, type: esriFieldTypeString )
• spatialsource ( modelName: spatialsource, nullable: true, editable: true, defaultValue: 0, alias: Spatial Source, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
• location ( modelName: location, nullable: true, editable: true, defaultValue: N/A, alias: Structure Location, type: esriFieldTypeSmallInteger )
• surface ( modelName: surface, nullable: true, editable: true, defaultValue: N/A, alias: Structure Surface Type, type: esriFieldTypeSmallInteger )
• ownedby ( modelName: ownedby, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• maintby ( modelName: maintby, nullable: true, editable: true, defaultValue: 1, alias: Maintained By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• MACP ( modelName: MACP, nullable: true, editable: true, defaultValue: N/A, alias: MACP score, type: esriFieldTypeDouble )
• IDOT_survey_code ( modelName: IDOT_survey_code, nullable: true, editable: true, defaultValue: N/A, alias: IDOT Survey Code, type: esriFieldTypeSmallInteger )
• validationstatus ( modelName: validationstatus, nullable: true, editable: true, defaultValue: 6, alias: Validation status, type: esriFieldTypeSmallInteger , 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... )
• GlobalID_1 ( modelName: GlobalID_1, nullable: false, editable: false, defaultValue: N/A, length: 38, alias: Global ID, type: esriFieldTypeGlobalID )
• globalid ( modelName: globalid, nullable: false, editable: true, defaultValue: {00000000-0000-0000-0000-000000000000}, length: 38, alias: Global ID 2, type: esriFieldTypeGUID )
• isconnected ( modelName: isconnected, nullable: false, editable: true, defaultValue: 2, alias: Is connected, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• creationdate ( modelName: creationdate, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: Creation date, type: esriFieldTypeDate )
• creator ( modelName: creator, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: Creator, type: esriFieldTypeString )
• lastupdate ( modelName: lastupdate, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: Last update, type: esriFieldTypeDate )
• updatedby ( modelName: updatedby, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: Updated by, type: esriFieldTypeString )

Types:

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...
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [5: Cast Iron - CAS] , ...9 more...
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 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...
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• maintby:
  Inherited
• validationstatus:
  Inherited
• isconnected:
  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...
Templates:
• Name: Inlet
  Description:
  Prototype:
  installdate: null
  notes: null
  spatialsource: 0
  globalid: {00000000-0000-0000-0000-000000000000}
  lifecyclestatus: 8
  surveydate: null
  diameter: 0
  inletshape: 0
  isconnected: 2
  validationstatus: null
  ownedby: 1
  assettype: 0
  elevation: null
  MACP: null
  surface: 0
  shape_struct: 0
  assetgroup: 28
  surfacewater: 1
  pipe_count: null
  depth: null
  material: 0
  bottom_elevation: null
  designtype: 0
  length2: null
  IDOT_survey_code: null
  assetid: null
  inspectdate: null
  width: null
  material_struct: 0
  location: 0
  maintby: 1
  add_et: null
  conetype: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

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
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [5: Cast Iron - CAS] , ...9 more...
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more...
• 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...
• material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• maintby:
  Inherited
• validationstatus:
  Inherited
• isconnected:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [2: Diversion Manhole] , [3: Junction Manhole] , ...7 more...
• conetype:
  Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...
Templates:
• Name: Manhole
  Description:
  Prototype:
  installdate: null
  notes: null
  spatialsource: null
  globalid: {00000000-0000-0000-0000-000000000000}
  lifecyclestatus: 8
  surveydate: null
  diameter: 0
  inletshape: 0
  isconnected: 1
  validationstatus: null
  ownedby: 1
  assettype: 9
  elevation: null
  MACP: null
  surface: 0
  shape_struct: 0
  assetgroup: 32
  surfacewater: 0
  pipe_count: null
  depth: null
  material: 0
  bottom_elevation: null
  designtype: 0
  length2: null
  IDOT_survey_code: null
  assetid: null
  inspectdate: null
  width: null
  material_struct: 0
  location: 0
  maintby: 1
  add_et: null
  conetype: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

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...
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• material:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...24 more...
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more...
• designtype:
  Coded Values: [0: Unknown] , [9: Tide Gate Chamber] , [11: Flap Gate] , ...5 more...
• material_struct:
  Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...24 more...
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• maintby:
  Inherited
• validationstatus:
  Inherited
• isconnected:
  Inherited
• add_et:
  Coded Values: [0: N/A] , [1: Flap Gate] , [2: Apron] , ...3 more...
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [1: SW Inlet] , [2: SW Outlet] , ...2 more...
Templates:
• Name: End Treatment
  Description:
  Prototype:
  installdate: null
  notes: null
  spatialsource: 0
  globalid: {00000000-0000-0000-0000-000000000000}
  lifecyclestatus: 8
  surveydate: null
  diameter: 0
  inletshape: null
  isconnected: 2
  validationstatus: null
  ownedby: 1
  assettype: 0
  elevation: null
  MACP: null
  surface: 0
  shape_struct: null
  assetgroup: 22
  surfacewater: 0
  pipe_count: null
  depth: null
  material: 0
  bottom_elevation: null
  designtype: 0
  length2: null
  IDOT_survey_code: null
  assetid: null
  inspectdate: null
  width: null
  material_struct: 0
  location: 0
  maintby: 1
  add_et: 0
  conetype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 23
Name: Connection
Domains:
• spatialsource:
  Inherited
• maintby:
  Inherited
• validationstatus:
  Inherited
• isconnected:
  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...
Templates:
• Name: Connection
  Description:
  Prototype:
  installdate: null
  notes: null
  spatialsource: 0
  globalid: {00000000-0000-0000-0000-000000000000}
  lifecyclestatus: 8
  surveydate: null
  diameter: null
  inletshape: null
  isconnected: 2
  validationstatus: 6
  ownedby: 1
  assettype: 0
  elevation: null
  MACP: null
  surface: null
  shape_struct: null
  assetgroup: 23
  surfacewater: null
  pipe_count: null
  depth: null
  material: null
  bottom_elevation: null
  designtype: null
  length2: null
  IDOT_survey_code: null
  assetid: null
  inspectdate: null
  width: null
  material_struct: null
  location: null
  maintby: 1
  add_et: null
  conetype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• DischargeInspection (0) -- Related To: Discharge Inspection (37)
• StormwaterBMPInspection (1) -- Related To: BMP Inspection (36)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

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: LASTUPDATE
• Editor Field: UPDATEDBY

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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