View In:   ArcGIS Online Map Viewer

Name: Stormwater Structure

Display Field: assetgroup

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: df55517e9a5e4d21b4919d766fd03e8c

Copyright Text:

Default Visibility: false

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: 1446316.5890683813
YMin: 640952.1115255388
XMax: 1476196.484352284
YMax: 672850.4000819062
Spatial Reference: 102723  (3735)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: assetgroup
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [255, 255, 255, 255]
Size: 14.000000000000002
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: 32
  Label: Manhole
  Description: N/A
  Symbol:
  
• Value: 28
  Label: Inlet
  Description: N/A
  Symbol:
  
• Value: 22
  Label: Outfall
  Description: N/A
  Symbol:
  
• Value: 34
  Label: Culvert Point
  Description: N/A
  Symbol:
  
• Value: 0
  Label: Unknown
  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 )
• 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 )
• installdate ( modelName: installdate, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Install Date, type: esriFieldTypeDate )
• 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] )
• assetid ( modelName: assetid, nullable: true, editable: true, defaultValue: N/A, length: 64, alias: Structure ID, type: esriFieldTypeString )
• notes ( modelName: notes, nullable: true, editable: true, defaultValue: N/A, length: 2000, alias: Notes, type: esriFieldTypeString )
• diameter ( modelName: diameter, nullable: true, editable: true, defaultValue: N/A, alias: Diameter, type: esriFieldTypeDouble )
• material ( modelName: material, nullable: true, editable: true, defaultValue: N/A, alias: Material, 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... )
• 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... )
• designtype ( modelName: designtype, nullable: true, editable: true, defaultValue: N/A, alias: Type, type: esriFieldTypeSmallInteger )
• 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: Elevation, type: esriFieldTypeDouble )
• inletshape ( modelName: inletshape, nullable: true, editable: true, defaultValue: N/A, alias: Inlet Shape, type: esriFieldTypeSmallInteger )
• IDOT_survey_code ( modelName: IDOT_survey_code, nullable: true, editable: true, defaultValue: N/A, alias: IDOT Survey Code, type: esriFieldTypeSmallInteger )
• 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 )
• conetype ( modelName: conetype, nullable: true, editable: true, defaultValue: N/A, alias: Cone type, type: esriFieldTypeSmallInteger )
• 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 )
• shape_struct ( modelName: shape_struct, nullable: true, editable: true, defaultValue: N/A, alias: Inside Strcture Shape, type: esriFieldTypeSmallInteger )
• material_struct ( modelName: material_struct, nullable: true, editable: true, defaultValue: N/A, alias: Inside Structure Material, type: esriFieldTypeSmallInteger )
• MACP ( modelName: MACP, nullable: true, editable: true, defaultValue: N/A, alias: MACP score, type: esriFieldTypeDouble )
• surveydate ( modelName: surveydate, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Survey Date, type: esriFieldTypeDate )
• inspectdate ( modelName: inspectdate, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Inspection Date, type: esriFieldTypeDate )
• sw_system ( modelName: sw_system, nullable: true, editable: true, defaultValue: N/A, alias: sw_system, type: esriFieldTypeSmallInteger , Coded Values: [0: MS4] , [1: CSO] )
• GlobalID_1 ( modelName: GlobalID_1, nullable: false, editable: false, defaultValue: N/A, length: 38, alias: Global ID, type: esriFieldTypeGlobalID )

Types:

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]
• 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] , ...10 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...
• maintby:
  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: Diversion Manhole] , [3: Junction Manhole] , ...9 more...
• conetype:
  Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...
Templates:
• Name: Manhole
  Description:
  Prototype:
  installdate: null
  notes: null
  spatialsource: null
  lifecyclestatus: 8
  surveydate: null
  diameter: 0
  inletshape: 0
  sw_system: 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
  inspectdate: null
  assetid: null
  width: null
  material_struct: 0
  maintby: 1
  location: 0
  conetype: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

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]
• 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] , ...10 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...
• maintby:
  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...
Templates:
• Name: Inlet
  Description:
  Prototype:
  installdate: null
  notes: null
  spatialsource: 0
  lifecyclestatus: 8
  surveydate: null
  diameter: 0
  inletshape: 0
  sw_system: 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
  inspectdate: null
  assetid: null
  width: null
  material_struct: 0
  maintby: 1
  location: 0
  conetype: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 22
Name: Outfall
Domains:
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• 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] , ...25 more...
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• spatialsource:
  Inherited
• maintby:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• sw_system:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [5: Pipe Outlet] , [9: Tide Gate Chamber] , ...4 more...
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
Templates:
• Name: Outfall
  Description:
  Prototype:
  installdate: null
  notes: null
  spatialsource: 0
  lifecyclestatus: 8
  surveydate: null
  diameter: 0
  inletshape: null
  sw_system: 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: null
  length2: null
  IDOT_survey_code: null
  inspectdate: null
  assetid: null
  width: null
  material_struct: null
  maintby: 1
  location: 0
  conetype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 34
Name: Culvert Point
Domains:
• surfacewater:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• 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] , ...25 more...
• surface:
  Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
• spatialsource:
  Inherited
• maintby:
  Inherited
• location:
  Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
• sw_system:
  Inherited
• ownedby:
  Inherited
• assettype:
  Coded Values: [0: Unknown] , [5: Pipe Outlet] , [9: Tide Gate Chamber] , ...4 more...
• lifecyclestatus:
  Inherited
Templates:
• Name: Culvert Point
  Description:
  Prototype:
  installdate: null
  notes: null
  spatialsource: 0
  lifecyclestatus: 8
  surveydate: null
  diameter: 0
  inletshape: null
  sw_system: null
  ownedby: 1
  assettype: 0
  elevation: null
  MACP: null
  surface: 0
  shape_struct: null
  assetgroup: 34
  surfacewater: 0
  pipe_count: null
  depth: null
  material: 0
  bottom_elevation: null
  designtype: null
  length2: null
  IDOT_survey_code: null
  inspectdate: null
  assetid: null
  width: null
  material_struct: null
  maintby: 1
  location: 0
  conetype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 0
Name: Unknown
Domains:
• sw_system:
  Inherited
• assettype:
  Coded Values: [0: Unknown]
Templates:
• Name: Unknown
  Description:
  Prototype:
  installdate: null
  notes: null
  spatialsource: null
  lifecyclestatus: 0
  surveydate: null
  diameter: null
  inletshape: null
  sw_system: null
  ownedby: null
  assettype: 0
  elevation: null
  MACP: null
  surface: null
  shape_struct: null
  assetgroup: 0
  surfacewater: null
  pipe_count: null
  depth: null
  material: null
  bottom_elevation: null
  designtype: null
  length2: null
  IDOT_survey_code: null
  inspectdate: null
  assetid: null
  width: null
  material_struct: null
  maintby: null
  location: null
  conetype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• Existing_SW_MH_Inspections (0) -- Related To: Existing_SW_MH_Inspections (21)
• Existing_SW_Pipe_Outlet_Inspections (1) -- Related To: Existing_SW_Pipe_Outlet_Inspections (23)
• Existing_SW_Culvert_Inspections (2) -- Related To: Existing_SW_Culvert_Inspections (20)
• Existing_SW_Pipe_Inlet_Inspections (3) -- Related To: Existing_SW_Pipe_Inlet_Inspections (22)
• Existing_SW_CB_Inspections (4) -- Related To: Existing_SW_CB_Inspections (19)

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