Layers:

Layer: Storm Drain Structures (0)

Name: Storm Drain Structures

Display Field: str_num

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: New data is entered by DPIE, legacy data has been updated through field verification from DPW&T and DoE.

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: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1291853.671886161
YMin: 321120.1198234856
XMax: 1407237.2760922462
YMax: 664849.3053952307
Spatial Reference: 102685  (2248)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: STR_TYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: CV
  Label: Culvert
  Description: N/A
  Symbol:
  
• Value: ES
  Label: Endsection
  Description: N/A
  Symbol:
  
• Value: EW
  Label: Endwall
  Description: N/A
  Symbol:
  
• Value: HW
  Label: Headwall
  Description: N/A
  Symbol:
  
• Value: IN
  Label: Inlet
  Description: N/A
  Symbol:
  Style: esriSMSSquare
  Color: [230, 0, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: MH
  Label: Manhole
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [85, 255, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: OTH
  Label: Other
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 169, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: PP
  Label: Projecting Pipe
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveLeft
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• str_num ( type: esriFieldTypeString, alias: Structure Number, length: 10 )
• STR_TYPE ( type: esriFieldTypeString, alias: Structure Type, length: 75 , Coded Values: [B: Bend] , [CV: Culvert] , [DI: Ditch Intersection] , ...20 more... )
• status ( type: esriFieldTypeString, alias: STATUS, length: 75 )
• MS4_Report ( type: esriFieldTypeString, alias: MS4 Report, length: 255 , Coded Values: [Y: Yes] , [N: No] )
• MDE_GDB_ID ( type: esriFieldTypeString, alias: MDE_GDB_ID, length: 13 )
• MajOutfall ( type: esriFieldTypeString, alias: MS4 Major Outfall, length: 4 , Coded Values: [12: Industrial Outfall 12" or greater] , [36: Outfall 36" or greater] , [50: Outfall with Drainage Area reater than 50 acres] , ...1 more... )
• top_of_grade ( type: esriFieldTypeDouble, alias: TOP_OF_GRADE )
• measured_depth ( type: esriFieldTypeDouble, alias: MEASURED_DEPTH )
• GenCom ( type: esriFieldTypeString, alias: General Comments, length: 255 )
• StruOwner ( type: esriFieldTypeString, alias: Structure Owner, length: 10 , Coded Values: [C: County] , [S: SHA] , [M: Municipality] , ...1 more... )
• sd_number ( type: esriFieldTypeString, alias: SD Number, length: 75 )
• pipe_in_quantity ( type: esriFieldTypeDouble, alias: PIPE_IN_QUANTITY )
• pipe_out_quantity ( type: esriFieldTypeDouble, alias: PIPE_OUT_QUANTITY )
• out_year ( type: esriFieldTypeString, alias: Year Constructed, length: 4 )
• permit_num ( type: esriFieldTypeString, alias: PERMIT_NUM, length: 13 )
• bottom_elevation ( type: esriFieldTypeDouble, alias: Structure Bottom Elevation )
• asbuiltdate ( type: esriFieldTypeDate, alias: As Built Date, length: 8 )
• approvaldate ( type: esriFieldTypeDate, alias: Approval Date, length: 8 )
• Muni ( type: esriFieldTypeString, alias: Municipality, length: 255 , Coded Values: [73: EAGLE HARBOR] , [74: GREENBELT] , [75: BERWYN HEIGHTS] , ...25 more... )
• WATERSHED8DGT ( type: esriFieldTypeString, alias: 8 Digit Watershed, length: 255 , Coded Values: [02140205: Anacostia River] , [02140111: Mattawoman Creek] , [02140204: Oxon Creek] , ...9 more... )
• POINT_X ( type: esriFieldTypeDouble, alias: Longitude (X) )
• POINT_Y ( type: esriFieldTypeDouble, alias: Latitude (Y) )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• EdCom ( type: esriFieldTypeString, alias: Editor Comments, length: 255 )
• FieldVer ( type: esriFieldTypeString, alias: Field Verified, length: 255 )
• FieldVerDate ( type: esriFieldTypeDate, alias: Field Verification Date, length: 8 )
• Structure_AGE ( type: esriFieldTypeString, alias: Age of Structure, length: 255 )
• ST_RepairAs ( type: esriFieldTypeString, alias: Repair Assessment Indicator, length: 255 , Coded Values: [Significant: Significant Repairs Recommended] , [NA: No Repairs Recommended] , [Moderate: Moderate Repairs Recommended] )
• ST_RepairDate ( type: esriFieldTypeDate, alias: Repair Date, length: 8 )
• ST_Repair_Issue ( type: esriFieldTypeString, alias: Repair Issue, length: 255 , Coded Values: [TR: Total Rebuild] , [BWP: Brick Work - Parging] , [Reset: Reset Top Slab] , ...3 more... )
• ST_RepairNotes ( type: esriFieldTypeString, alias: Repair Notes, length: 255 )
• ST_RepairResp ( type: esriFieldTypeString, alias: Repair Responsibility, length: 255 , Coded Values: [C1: Contractor 1] , [C2: Contractor 2] , [C3: Contractor 3] , ...2 more... )
• InletCleaned ( type: esriFieldTypeString, alias: Inlet Cleaned, length: 255 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• Date_Last_Cleaned ( type: esriFieldTypeDate, alias: Last Date Cleaned, length: 8 )
• ST_Blockage ( type: esriFieldTypeString, alias: Blockage Extent, length: 255 , Coded Values: [Low Blockage: 0% - 25% None to Little Blockage] , [Moderate Blockage: 26% to 75% Blockage] , [High Blockage: Greater than 76% Blockage] )
• Assess_Date ( type: esriFieldTypeDate, alias: Assessment Date, length: 8 )
• SR_NOa ( type: esriFieldTypeString, alias: Service Request Number, length: 11 )
• ST_RepairStatus ( type: esriFieldTypeString, alias: Repair Progress Status, length: 255 , Coded Values: [C: Complete] , [TD: To-Do] , [IP: In-Progress] )
• ST_Assesment_Com ( type: esriFieldTypeString, alias: Assesment Comment, length: 255 )
• Struct_GlobalID_on_add ( type: esriFieldTypeGUID, alias: GlobalID_On_Add, length: 38 )
• STsafety_score ( type: esriFieldTypeString, alias: Safety Score, length: 75 , Coded Values: [No Safety Hazard Observed: No Safety Hazard Observed] , [Low Risk Safety Hazard Observed: Low Risk Safety Hazard Observed] , [Moderate Risk Safety Hazard Observed: Moderate Risk Safety Hazard Observed] , ...3 more... )
• MDE_GDB_ID_OutfallDA ( type: esriFieldTypeString, alias: MDE GDB ID of Outfall DA, length: 255 )
• Inlet_Type ( type: esriFieldTypeString, alias: Inlet Type, length: 255 , Coded Values: [A1: A1- Grate Inlet at Curb] , [A2: A2- Grate Inlet at Curb] , [A3: A3- Grate Inlet at Curb] , ...16 more... )

Relationships:

• Downstream Conveyance (0) -- Related To: Storm Drain Conveyance (1)
• SDS_Cleaning (1) -- Related To: SDS_Cleaning (6)
• Upstream Conveyance (2) -- Related To: Storm Drain Conveyance (1)
• OutfallDrainageArea (3) -- Related To: Outfall Drainage Area (2)
• SDS_Condition (4) -- Related To: SDS_Condition (7)
• ESMGDB.PGCSW.SDS_Repairs (5) -- Related To: SDS_Repairs (8)

Layer: Storm Drain Conveyance (1)

Name: Storm Drain Conveyance

Display Field: dpw_channel_name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: New data is entered by DPIE, legacy data has been updated through field verification from DPW&T and DoE.

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: 1291535.5740971565
YMin: 320428.3137923926
XMax: 1403740.8460772485
YMax: 583427.1283448935
Spatial Reference: 102685  (2248)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: ConveyanceType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: C
  Label: Culvert
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [169, 0, 230, 255]
  Width: 2
• Value: D
  Label: Ditch
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 2
• Value: HC
  Label: Hydraulic Connector
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [169, 0, 230, 255]
  Width: 2
• Value: OC
  Label: Open Channel
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 2
• Value: P
  Label: Pipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 77, 168, 255]
  Width: 2
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ConveyanceType ( type: esriFieldTypeString, alias: Type Of Storm Drain Conveyance, length: 75 , Coded Values: [C: Culvert] , [D: Ditch] , [HC: Hydraulic Connector] , ...3 more... )
• TYPE_MATL ( type: esriFieldTypeString, alias: Conveyance Material, length: 75 , Coded Values: [ACCMP: Asphalt Coated Corrugated Metal Pipe] , [ASRP: Aluminum Spiral Rib Pipe] , [BCCMP: Bituminous Coated Corrugated Metal Pipe] , ...14 more... )
• DIM_OUTFALL ( type: esriFieldTypeDouble, alias: Outfall dimensions (square inches) )
• HT_OUTFALL ( type: esriFieldTypeDouble, alias: Height )
• WT_OUTFALL ( type: esriFieldTypeDouble, alias: Width )
• MDE_GDB_ID ( type: esriFieldTypeString, alias: MDE GDB ID of Outfall, length: 255 )
• ConveyStatus ( type: esriFieldTypeString, alias: Conveyance Status in Field, length: 75 )
• ConveyOwner ( type: esriFieldTypeString, alias: Conveyance Owner, length: 10 , Coded Values: [C: County] , [S: SHA] , [M: Municipality] , ...1 more... )
• invert_in_elevation ( type: esriFieldTypeDouble, alias: Invert In Elevation )
• invert_out_elevation ( type: esriFieldTypeDouble, alias: Invert Out Elevation )
• plan_length ( type: esriFieldTypeDouble, alias: Conveyance Length on Plan in Feet )
• upstrm_globalid ( type: esriFieldTypeGUID, alias: OSDM Upstream Structure Global ID, length: 38 )
• dnstrm_globalid ( type: esriFieldTypeGUID, alias: OSDM Downstream Structure Global ID, length: 38 )
• sd_number ( type: esriFieldTypeString, alias: SD Number, length: 75 )
• GenCom ( type: esriFieldTypeString, alias: General Comments, length: 255 )
• invert_in_measurement ( type: esriFieldTypeDouble, alias: Invert In Measurement )
• invert_out_measurement ( type: esriFieldTypeDouble, alias: Invert Out Measurement )
• top_width ( type: esriFieldTypeDouble, alias: Channel Top Width )
• bottom_width ( type: esriFieldTypeDouble, alias: Channel Bottom Width )
• depth ( type: esriFieldTypeDouble, alias: Channel Depth )
• dpw_channel_id ( type: esriFieldTypeString, alias: DPWT Channel ID, length: 5 )
• dpw_channel_name ( type: esriFieldTypeString, alias: DPWT Channel Name, length: 150 )
• x_area ( type: esriFieldTypeDouble, alias: Area of Channel )
• ConveyShape ( type: esriFieldTypeString, alias: Conveyance Shape, length: 75 , Coded Values: [VD: V-Ditch] , [PD: Parabolic Ditch] , [TD: Trapezoidal Ditch] , ...10 more... )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GeomLengthFt ( type: esriFieldTypeDouble, alias: Geometric Length In Feet )
• EdCom ( type: esriFieldTypeString, alias: Editor Comments, length: 255 )
• FieldVer ( type: esriFieldTypeString, alias: Field Verified, length: 1 )
• FieldVerDate ( type: esriFieldTypeDate, alias: Field Verification Date, length: 8 )
• Slope ( type: esriFieldTypeDouble, alias: Slope )
• Conveyance_AGE ( type: esriFieldTypeString, alias: Age of Conveyance, length: 255 )
• Conv_RepairResp ( type: esriFieldTypeString, alias: Repair Responsibility, length: 255 , Coded Values: [C1: Contractor 1] , [C2: Contractor 2] , [C3: Contractor 3] , ...2 more... )
• Conv_RepairStatus ( type: esriFieldTypeString, alias: Repair Progress Status, length: 255 , Coded Values: [C: Complete] , [TD: To-Do] , [IP: In-Progress] )
• Conv_RepairDate ( type: esriFieldTypeDate, alias: Repair Date, length: 8 )
• Conv_Repair_Issue ( type: esriFieldTypeString, alias: Repair Issue, length: 255 , Coded Values: [Reset: Reset] , [Replace: Replace] , [RU: Replace - Upgrade] )
• Conv_RepairNotes ( type: esriFieldTypeString, alias: Repair Notes, length: 255 )
• PIPE_Cleaned ( type: esriFieldTypeString, alias: Pipe Cleaned, length: 255 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• PipeDateLastCleaned ( type: esriFieldTypeDate, alias: Last Date Cleaned, length: 8 )
• ConvRepairAs ( type: esriFieldTypeString, alias: Repair Assesment Indicator, length: 255 , Coded Values: [Significant: Significant Repairs Recommended] , [NA: No Repairs Recommended] , [Moderate: Moderate Repairs Recommended] )
• Conv_Blockage ( type: esriFieldTypeString, alias: Blockage Extent, length: 255 , Coded Values: [Low Blockage: 0% - 25% None to Little Blockage] , [Moderate Blockage: 26% to 75% Blockage] , [High Blockage: Greater than 76% Blockage] )
• Asses_Date2 ( type: esriFieldTypeDate, alias: Assesment Date, length: 8 )
• SR_NOb ( type: esriFieldTypeString, alias: Service Request Number, length: 11 )
• Material_PipeReplace ( type: esriFieldTypeString, alias: Material of Replaced Pipe, length: 255 , Coded Values: [ACCMP: Asphalt Coated Corrugated Metal Pipe] , [ASRP: Aluminum Spiral Rib Pipe] , [BCCMP: Bituminous Coated Corrugated Metal Pipe] , ...14 more... )
• Length_PipeReplace ( type: esriFieldTypeDouble, alias: Length of Replaced Pipe (FT) )
• VideoPipeInsp ( type: esriFieldTypeString, alias: Video Pipe Inspection, length: 255 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• VideoPipeInspDate ( type: esriFieldTypeDate, alias: Video Pipe Inspection Date, length: 8 )
• Conv_Assess_Com ( type: esriFieldTypeString, alias: Assesment Comments, length: 255 )
• Length_Pipe_Insp ( type: esriFieldTypeDouble, alias: Length of Pipe Inspected (FT) )
• Length_Pipe_Cleaned ( type: esriFieldTypeDouble, alias: Length of Pipe Cleaned (FT) )
• Conv_GlobalID_on_add ( type: esriFieldTypeGUID, alias: GlobalID_On_Add, length: 38 )
• Convsafety_score ( type: esriFieldTypeString, alias: Safety Score, length: 75 , Coded Values: [No Safety Hazard Observed: No Safety Hazard Observed] , [Low Risk Safety Hazard Observed: Low Risk Safety Hazard Observed] , [Moderate Risk Safety Hazard Observed: Moderate Risk Safety Hazard Observed] , ...3 more... )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Relationships:

• SDC_Repairs (6) -- Related To: SDC_Repairs (5)
• SDC_Cleaning (7) -- Related To: SDC_Cleaning (3)
• SDC_Condition (8) -- Related To: SDC_Condition (4)
• Downstream Structure (2) -- Related To: Storm Drain Structures (0)
• Upstream Structure (0) -- Related To: Storm Drain Structures (0)

Layer: Outfall Drainage Area (2)

Name: Outfall Drainage Area

Display Field: MDE_GDB_ID

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Records from storm drains built since 2013 should have drainage areas from as built plans, else earlier records were digitized from contours and existing pipe network.

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: 1296874.3665691614
YMin: 321070.525762558
XMax: 1401796.0235233307
YMax: 530272.9702177346
Spatial Reference: 102685  (2248)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [169, 28, 28, 0]
Outline:
Style: esriSLSSolid
Color: [169, 0, 230, 255]
Width: 1
Label: N/A
Description: N/A
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• MDE_GDB_ID ( type: esriFieldTypeString, alias: MDE_GDB_ID, length: 13 )
• MDE_GDB_ID_Outfall ( type: esriFieldTypeString, alias: MDE GDB ID of Outfall, length: 13 )
• OUTFALL_DRAIN_AREA ( type: esriFieldTypeDouble, alias: Drainage area (acres) to outfall )
• SD_Number ( type: esriFieldTypeString, alias: SD Number, length: 13 )
• GEN_COMMENTS ( type: esriFieldTypeString, alias: General comments, length: 255 )
• created_user ( type: esriFieldTypeString, alias: Created by, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Date created, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last edited by, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last edited date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Relationships:

• StormDrainStructures (3) -- Related To: Storm Drain Structures (0)

Tables:

Table: SDC_Cleaning (3)

Name: SDC_Cleaning

Display Field: conv_pipe_cleaned

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: 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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• rel_globalid ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• conv_pipe_cleaned ( type: esriFieldTypeString, alias: Pipe Cleaned, length: 50 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• conv_date_cleaned ( type: esriFieldTypeDate, alias: Date Cleaned, length: 8 )
• Conv_comments ( type: esriFieldTypeString, alias: Comments, length: 1000 )
• C_meets_criteria_yn ( type: esriFieldTypeString, alias: Meets Criteria, length: 50 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Length_Pipe_Cleaned ( type: esriFieldTypeDouble, alias: Length of Pipe Cleaned (FT) )

Relationships:

• StormDrainConveyance (7) -- Related To: Storm Drain Conveyance (1)

Table: SDC_Condition (4)

Name: SDC_Condition

Display Field: safety_score2

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: 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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• safety_score2 ( type: esriFieldTypeString, alias: Safety Score, length: 75 , Coded Values: [No Safety Hazard Observed: No Safety Hazard Observed] , [Low Risk Safety Hazard Observed: Low Risk Safety Hazard Observed] , [Moderate Risk Safety Hazard Observed: Moderate Risk Safety Hazard Observed] , ...3 more... )
• blockage2 ( type: esriFieldTypeString, alias: Blockage Extent, length: 75 , Coded Values: [Low Blockage: 0% - 25% None to Little Blockage] , [Moderate Blockage: 26% to 75% Blockage] , [High Blockage: Greater than 76% Blockage] )
• ConvRepairEval2 ( type: esriFieldTypeString, alias: Repair Assessment Indicator, length: 75 , Coded Values: [Significant: Significant Repairs Recommended] , [NA: No Repairs Recommended] , [Moderate: Moderate Repairs Recommended] )
• assess_comments2 ( type: esriFieldTypeString, alias: Assesment Comments, length: 255 )
• assess_date2 ( type: esriFieldTypeDate, alias: Assement Date, length: 8 )
• rel_globalid ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• VideoPipeInsp ( type: esriFieldTypeString, alias: Video Pipe Inspection, length: 255 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• VideoPipeInspDate ( type: esriFieldTypeDate, alias: Video Pipe Inspection Date, length: 8 )
• Length_Pipe_Insp ( type: esriFieldTypeDouble, alias: Length of Pipe Inspected (FT) )

Relationships:

• StormDrainConveyance (8) -- Related To: Storm Drain Conveyance (1)

Table: SDC_Repairs (5)

Name: SDC_Repairs

Display Field: created_user

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: 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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• REL_GUID ( type: esriFieldTypeGUID, alias: REL_GUID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Conv_RepairResp3 ( type: esriFieldTypeString, alias: Repair Responsibility, length: 255 , Coded Values: [C1: Contractor 1] , [C2: Contractor 2] , [C3: Contractor 3] , ...2 more... )
• Conv_RepairDate3 ( type: esriFieldTypeDate, alias: Repair Date, length: 8 )
• Conv_Repair_Issue3 ( type: esriFieldTypeString, alias: Repair Issue, length: 255 , Coded Values: [Reset: Reset] , [Replace: Replace] , [RU: Replace - Upgrade] )
• Conv_RepairNotes3 ( type: esriFieldTypeString, alias: Repair Notes, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SR_NOb3 ( type: esriFieldTypeString, alias: Service Request Number, length: 11 )
• Material_PipeReplace ( type: esriFieldTypeString, alias: Material of Replaced Pipe, length: 255 , Coded Values: [ACCMP: Asphalt Coated Corrugated Metal Pipe] , [ASRP: Aluminum Spiral Rib Pipe] , [BCCMP: Bituminous Coated Corrugated Metal Pipe] , ...14 more... )
• Length_PipeReplace ( type: esriFieldTypeDouble, alias: Length of Replaced Pipe (FT) )

Relationships:

• StormDrainConveyance (6) -- Related To: Storm Drain Conveyance (1)

Table: SDS_Cleaning (6)

Name: SDS_Cleaning

Display Field: inlet_cleaned

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: 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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• rel_globalid ( type: esriFieldTypeGUID, alias: KCI Guid, length: 38 )
• inlet_cleaned ( type: esriFieldTypeString, alias: Inlet Cleaned, length: 50 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• st_date_cleaned ( type: esriFieldTypeDate, alias: Date Cleaned, length: 8 )
• st_comments ( type: esriFieldTypeString, alias: Comments, length: 1000 )
• meets_criteria_yn ( type: esriFieldTypeString, alias: Meets Criteria, length: 50 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Relationships:

• StormDrainStructures (1) -- Related To: Storm Drain Structures (0)

Table: SDS_Condition (7)

Name: SDS_Condition

Display Field: safety_score

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: 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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• safety_score ( type: esriFieldTypeString, alias: Safety Score, length: 75 , Coded Values: [No Safety Hazard Observed: No Safety Hazard Observed] , [Low Risk Safety Hazard Observed: Low Risk Safety Hazard Observed] , [Moderate Risk Safety Hazard Observed: Moderate Risk Safety Hazard Observed] , ...3 more... )
• blockage ( type: esriFieldTypeString, alias: Blockage Extent, length: 75 , Coded Values: [Low Blockage: 0% - 25% None to Little Blockage] , [Moderate Blockage: 26% to 75% Blockage] , [High Blockage: Greater than 76% Blockage] )
• RepairEval ( type: esriFieldTypeString, alias: Repair Assessment Indicator, length: 75 , Coded Values: [Significant: Significant Repairs Recommended] , [NA: No Repairs Recommended] , [Moderate: Moderate Repairs Recommended] )
• assess_comments ( type: esriFieldTypeString, alias: Assesment Comments, length: 255 )
• assess_date ( type: esriFieldTypeDate, alias: Assessment Date, length: 8 )
• rel_globalid ( type: esriFieldTypeGUID, alias: KCI Guid, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• top_stable ( type: esriFieldTypeString, alias: Top is Stable, length: 25 )
• LAB_GUID ( type: esriFieldTypeGUID, alias: Lab Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• StormDrainStructures (4) -- Related To: Storm Drain Structures (0)

Table: SDS_Repairs (8)

Name: SDS_Repairs

Display Field: ST_RepairDate3

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: 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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ST_RepairDate3 ( type: esriFieldTypeDate, alias: Repair Date, length: 8 )
• ST_Repair_Issue3 ( type: esriFieldTypeString, alias: Repair Issue, length: 255 , Coded Values: [TR: Total Rebuild] , [BWP: Brick Work - Parging] , [Reset: Reset Top Slab] , ...3 more... )
• ST_RepairNotes3 ( type: esriFieldTypeString, alias: Repair Notes, length: 255 )
• ST_RepairResp3 ( type: esriFieldTypeString, alias: Repair Responsibility, length: 255 , Coded Values: [C1: Contractor 1] , [C2: Contractor 2] , [C3: Contractor 3] , ...2 more... )
• REL_GUID ( type: esriFieldTypeGUID, alias: REL_GUID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SR3 ( type: esriFieldTypeString, alias: Service Request Number, length: 11 )

Relationships:

• ESMGDB.PGCSW.StormDrainStructures (5) -- Related To: Storm Drain Structures (0)