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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

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

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: STR_TYPE

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• str_num ( type: esriFieldTypeString, alias: Structure Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: str_num )
• STR_TYPE ( type: esriFieldTypeString, alias: Structure Type, editable: true, nullable: true, length: 75, defaultValue: null, modelName: STR_TYPE , Coded Values: [B: Bend] , [CV: Culvert] , [DI: Ditch Intersection] , ...20 more... )
• status ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 75, defaultValue: null, modelName: status )
• MS4_Report ( type: esriFieldTypeString, alias: MS4 Report, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MS4_Report , Coded Values: [Y: Yes] , [N: No] )
• MDE_GDB_ID ( type: esriFieldTypeString, alias: MDE_GDB_ID, editable: true, nullable: true, length: 13, defaultValue: null, modelName: MDE_GDB_ID )
• MajOutfall ( type: esriFieldTypeString, alias: MS4 Major Outfall, editable: true, nullable: true, length: 4, defaultValue: null, modelName: MajOutfall , 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, editable: true, nullable: true, defaultValue: null, modelName: top_of_grade )
• measured_depth ( type: esriFieldTypeDouble, alias: MEASURED_DEPTH, editable: true, nullable: true, defaultValue: null, modelName: measured_depth )
• GenCom ( type: esriFieldTypeString, alias: General Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GenCom )
• StruOwner ( type: esriFieldTypeString, alias: Structure Owner, editable: true, nullable: true, length: 10, defaultValue: null, modelName: StruOwner , Coded Values: [C: County] , [S: SHA] , [M: Municipality] , ...1 more... )
• sd_number ( type: esriFieldTypeString, alias: SD Number, editable: true, nullable: true, length: 75, defaultValue: null, modelName: sd_number )
• pipe_in_quantity ( type: esriFieldTypeDouble, alias: PIPE_IN_QUANTITY, editable: true, nullable: true, defaultValue: null, modelName: pipe_in_quantity )
• pipe_out_quantity ( type: esriFieldTypeDouble, alias: PIPE_OUT_QUANTITY, editable: true, nullable: true, defaultValue: null, modelName: pipe_out_quantity )
• out_year ( type: esriFieldTypeString, alias: Year Constructed, editable: true, nullable: true, length: 4, defaultValue: null, modelName: out_year )
• permit_num ( type: esriFieldTypeString, alias: PERMIT_NUM, editable: true, nullable: true, length: 13, defaultValue: null, modelName: permit_num )
• bottom_elevation ( type: esriFieldTypeDouble, alias: Structure Bottom Elevation, editable: true, nullable: true, defaultValue: null, modelName: bottom_elevation )
• asbuiltdate ( type: esriFieldTypeDate, alias: As Built Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: asbuiltdate )
• approvaldate ( type: esriFieldTypeDate, alias: Approval Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: approvaldate )
• Muni ( type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Muni , Coded Values: [73: EAGLE HARBOR] , [74: GREENBELT] , [75: BERWYN HEIGHTS] , ...25 more... )
• WATERSHED8DGT ( type: esriFieldTypeString, alias: 8 Digit Watershed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WATERSHED8DGT , Coded Values: [02140205: Anacostia River] , [02140111: Mattawoman Creek] , [02140204: Oxon Creek] , ...9 more... )
• POINT_X ( type: esriFieldTypeDouble, alias: Longitude (X), editable: true, nullable: true, defaultValue: null, modelName: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: Latitude (Y), editable: true, nullable: true, defaultValue: null, modelName: POINT_Y )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• EdCom ( type: esriFieldTypeString, alias: Editor Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EdCom )
• FieldVer ( type: esriFieldTypeString, alias: Field Verified, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FieldVer )
• FieldVerDate ( type: esriFieldTypeDate, alias: Field Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FieldVerDate )
• Structure_AGE ( type: esriFieldTypeString, alias: Age of Structure, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structure_AGE )
• ST_RepairAs ( type: esriFieldTypeString, alias: Repair Assessment Indicator, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ST_RepairAs , Coded Values: [Significant: Significant Repairs Recommended] , [NA: No Repairs Recommended] , [Moderate: Moderate Repairs Recommended] )
• ST_RepairDate ( type: esriFieldTypeDate, alias: Repair Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ST_RepairDate )
• ST_Repair_Issue ( type: esriFieldTypeString, alias: Repair Issue, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ST_Repair_Issue , Coded Values: [TR: Total Rebuild] , [BWP: Brick Work - Parging] , [Reset: Reset Top Slab] , ...3 more... )
• ST_RepairNotes ( type: esriFieldTypeString, alias: Repair Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ST_RepairNotes )
• ST_RepairResp ( type: esriFieldTypeString, alias: Repair Responsibility, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ST_RepairResp , Coded Values: [C1: Contractor 1] , [C2: Contractor 2] , [C3: Contractor 3] , ...2 more... )
• InletCleaned ( type: esriFieldTypeString, alias: Inlet Cleaned, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InletCleaned , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• Date_Last_Cleaned ( type: esriFieldTypeDate, alias: Last Date Cleaned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_Last_Cleaned )
• ST_Blockage ( type: esriFieldTypeString, alias: Blockage Extent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ST_Blockage , 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, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Assess_Date )
• SR_NOa ( type: esriFieldTypeString, alias: Service Request Number, editable: true, nullable: true, length: 11, defaultValue: null, modelName: SR_NOa )
• ST_RepairStatus ( type: esriFieldTypeString, alias: Repair Progress Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ST_RepairStatus , Coded Values: [C: Complete] , [TD: To-Do] , [IP: In-Progress] )
• ST_Assesment_Com ( type: esriFieldTypeString, alias: Assesment Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ST_Assesment_Com )
• Struct_GlobalID_on_add ( type: esriFieldTypeGUID, alias: GlobalID_On_Add, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Struct_GlobalID_on_add )
• STsafety_score ( type: esriFieldTypeString, alias: Safety Score, editable: true, nullable: true, length: 75, defaultValue: null, modelName: STsafety_score , 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, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MDE_GDB_ID_OutfallDA )
• Inlet_Type ( type: esriFieldTypeString, alias: Inlet Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Inlet_Type , Coded Values: [A1: A1- Grate Inlet at Curb] , [A2: A2- Grate Inlet at Curb] , [A3: A3- Grate Inlet at Curb] , ...16 more... )
Types:
ID: CV
Name: Culvert
Domains:
• STR_TYPE:
  Inherited
• MS4_Report:
  Inherited
• MajOutfall:
  Inherited
• StruOwner:
  Inherited
• Muni:
  Inherited
• WATERSHED8DGT:
  Inherited
• ST_RepairAs:
  Inherited
• ST_Repair_Issue:
  Inherited
• ST_RepairResp:
  Inherited
• InletCleaned:
  Inherited
• ST_Blockage:
  Inherited
• ST_RepairStatus:
  Inherited
• STsafety_score:
  Inherited
• Inlet_Type:
  Inherited
Templates:
• Name: CV
  Description:
  Prototype:
  MDE_GDB_ID_OutfallDA: null
  STsafety_score: null
  str_num: null
  STR_TYPE: CV
  status: null
  MS4_Report: null
  MDE_GDB_ID: null
  MajOutfall: null
  top_of_grade: null
  measured_depth: null
  GenCom: null
  StruOwner: null
  sd_number: null
  pipe_in_quantity: null
  pipe_out_quantity: null
  out_year: null
  permit_num: null
  bottom_elevation: null
  asbuiltdate: null
  approvaldate: null
  Muni: null
  WATERSHED8DGT: null
  POINT_X: null
  POINT_Y: null
  Struct_GlobalID_on_add: null
  ST_Assesment_Com: null
  ST_RepairStatus: null
  SR_NOa: null
  Inlet_Type: null
  EdCom: null
  FieldVer: null
  FieldVerDate: null
  Structure_AGE: null
  ST_RepairAs: null
  ST_RepairDate: null
  ST_Repair_Issue: null
  ST_RepairNotes: null
  ST_RepairResp: null
  InletCleaned: null
  Date_Last_Cleaned: null
  ST_Blockage: null
  Assess_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: ES
Name: Endsection
Domains:
• STR_TYPE:
  Inherited
• MS4_Report:
  Inherited
• MajOutfall:
  Inherited
• StruOwner:
  Inherited
• Muni:
  Inherited
• WATERSHED8DGT:
  Inherited
• ST_RepairAs:
  Inherited
• ST_Repair_Issue:
  Inherited
• ST_RepairResp:
  Inherited
• InletCleaned:
  Inherited
• ST_Blockage:
  Inherited
• ST_RepairStatus:
  Inherited
• STsafety_score:
  Inherited
• Inlet_Type:
  Inherited
Templates:
• Name: ES
  Description:
  Prototype:
  MDE_GDB_ID_OutfallDA: null
  STsafety_score: null
  str_num: null
  STR_TYPE: ES
  status: null
  MS4_Report: null
  MDE_GDB_ID: null
  MajOutfall: null
  top_of_grade: null
  measured_depth: null
  GenCom: null
  StruOwner: null
  sd_number: null
  pipe_in_quantity: null
  pipe_out_quantity: null
  out_year: null
  permit_num: null
  bottom_elevation: null
  asbuiltdate: null
  approvaldate: null
  Muni: null
  WATERSHED8DGT: null
  POINT_X: null
  POINT_Y: null
  Struct_GlobalID_on_add: null
  ST_Assesment_Com: null
  ST_RepairStatus: null
  SR_NOa: null
  Inlet_Type: null
  EdCom: null
  FieldVer: null
  FieldVerDate: null
  Structure_AGE: null
  ST_RepairAs: null
  ST_RepairDate: null
  ST_Repair_Issue: null
  ST_RepairNotes: null
  ST_RepairResp: null
  InletCleaned: null
  Date_Last_Cleaned: null
  ST_Blockage: null
  Assess_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: EW
Name: Endwall
Domains:
• STR_TYPE:
  Inherited
• MS4_Report:
  Inherited
• MajOutfall:
  Inherited
• StruOwner:
  Inherited
• Muni:
  Inherited
• WATERSHED8DGT:
  Inherited
• ST_RepairAs:
  Inherited
• ST_Repair_Issue:
  Inherited
• ST_RepairResp:
  Inherited
• InletCleaned:
  Inherited
• ST_Blockage:
  Inherited
• ST_RepairStatus:
  Inherited
• STsafety_score:
  Inherited
• Inlet_Type:
  Inherited
Templates:
• Name: EW
  Description:
  Prototype:
  MDE_GDB_ID_OutfallDA: null
  STsafety_score: null
  str_num: null
  STR_TYPE: EW
  status: null
  MS4_Report: null
  MDE_GDB_ID: null
  MajOutfall: null
  top_of_grade: null
  measured_depth: null
  GenCom: null
  StruOwner: null
  sd_number: null
  pipe_in_quantity: null
  pipe_out_quantity: null
  out_year: null
  permit_num: null
  bottom_elevation: null
  asbuiltdate: null
  approvaldate: null
  Muni: null
  WATERSHED8DGT: null
  POINT_X: null
  POINT_Y: null
  Struct_GlobalID_on_add: null
  ST_Assesment_Com: null
  ST_RepairStatus: null
  SR_NOa: null
  Inlet_Type: null
  EdCom: null
  FieldVer: null
  FieldVerDate: null
  Structure_AGE: null
  ST_RepairAs: null
  ST_RepairDate: null
  ST_Repair_Issue: null
  ST_RepairNotes: null
  ST_RepairResp: null
  InletCleaned: null
  Date_Last_Cleaned: null
  ST_Blockage: null
  Assess_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: HW
Name: Headwall
Domains:
• STR_TYPE:
  Inherited
• MS4_Report:
  Inherited
• MajOutfall:
  Inherited
• StruOwner:
  Inherited
• Muni:
  Inherited
• WATERSHED8DGT:
  Inherited
• ST_RepairAs:
  Inherited
• ST_Repair_Issue:
  Inherited
• ST_RepairResp:
  Inherited
• InletCleaned:
  Inherited
• ST_Blockage:
  Inherited
• ST_RepairStatus:
  Inherited
• STsafety_score:
  Inherited
• Inlet_Type:
  Inherited
Templates:
• Name: HW
  Description:
  Prototype:
  MDE_GDB_ID_OutfallDA: null
  STsafety_score: null
  str_num: null
  STR_TYPE: HW
  status: null
  MS4_Report: null
  MDE_GDB_ID: null
  MajOutfall: null
  top_of_grade: null
  measured_depth: null
  GenCom: null
  StruOwner: null
  sd_number: null
  pipe_in_quantity: null
  pipe_out_quantity: null
  out_year: null
  permit_num: null
  bottom_elevation: null
  asbuiltdate: null
  approvaldate: null
  Muni: null
  WATERSHED8DGT: null
  POINT_X: null
  POINT_Y: null
  Struct_GlobalID_on_add: null
  ST_Assesment_Com: null
  ST_RepairStatus: null
  SR_NOa: null
  Inlet_Type: null
  EdCom: null
  FieldVer: null
  FieldVerDate: null
  Structure_AGE: null
  ST_RepairAs: null
  ST_RepairDate: null
  ST_Repair_Issue: null
  ST_RepairNotes: null
  ST_RepairResp: null
  InletCleaned: null
  Date_Last_Cleaned: null
  ST_Blockage: null
  Assess_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: IN
Name: Inlet
Domains:
• STR_TYPE:
  Inherited
• MS4_Report:
  Inherited
• MajOutfall:
  Inherited
• StruOwner:
  Inherited
• Muni:
  Inherited
• WATERSHED8DGT:
  Inherited
• ST_RepairAs:
  Inherited
• ST_Repair_Issue:
  Inherited
• ST_RepairResp:
  Inherited
• InletCleaned:
  Inherited
• ST_Blockage:
  Inherited
• ST_RepairStatus:
  Inherited
• STsafety_score:
  Inherited
• Inlet_Type:
  Inherited
Templates:
• Name: IN
  Description:
  Prototype:
  MDE_GDB_ID_OutfallDA: null
  STsafety_score: null
  str_num: null
  STR_TYPE: IN
  status: null
  MS4_Report: null
  MDE_GDB_ID: null
  MajOutfall: null
  top_of_grade: null
  measured_depth: null
  GenCom: null
  StruOwner: null
  sd_number: null
  pipe_in_quantity: null
  pipe_out_quantity: null
  out_year: null
  permit_num: null
  bottom_elevation: null
  asbuiltdate: null
  approvaldate: null
  Muni: null
  WATERSHED8DGT: null
  POINT_X: null
  POINT_Y: null
  Struct_GlobalID_on_add: null
  ST_Assesment_Com: null
  ST_RepairStatus: null
  SR_NOa: null
  Inlet_Type: null
  EdCom: null
  FieldVer: null
  FieldVerDate: null
  Structure_AGE: null
  ST_RepairAs: null
  ST_RepairDate: null
  ST_Repair_Issue: null
  ST_RepairNotes: null
  ST_RepairResp: null
  InletCleaned: null
  Date_Last_Cleaned: null
  ST_Blockage: null
  Assess_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: MH
Name: Manhole
Domains:
• STR_TYPE:
  Inherited
• MS4_Report:
  Inherited
• MajOutfall:
  Inherited
• StruOwner:
  Inherited
• Muni:
  Inherited
• WATERSHED8DGT:
  Inherited
• ST_RepairAs:
  Inherited
• ST_Repair_Issue:
  Inherited
• ST_RepairResp:
  Inherited
• InletCleaned:
  Inherited
• ST_Blockage:
  Inherited
• ST_RepairStatus:
  Inherited
• STsafety_score:
  Inherited
• Inlet_Type:
  Inherited
Templates:
• Name: MH
  Description:
  Prototype:
  MDE_GDB_ID_OutfallDA: null
  STsafety_score: null
  str_num: null
  STR_TYPE: MH
  status: null
  MS4_Report: null
  MDE_GDB_ID: null
  MajOutfall: null
  top_of_grade: null
  measured_depth: null
  GenCom: null
  StruOwner: null
  sd_number: null
  pipe_in_quantity: null
  pipe_out_quantity: null
  out_year: null
  permit_num: null
  bottom_elevation: null
  asbuiltdate: null
  approvaldate: null
  Muni: null
  WATERSHED8DGT: null
  POINT_X: null
  POINT_Y: null
  Struct_GlobalID_on_add: null
  ST_Assesment_Com: null
  ST_RepairStatus: null
  SR_NOa: null
  Inlet_Type: null
  EdCom: null
  FieldVer: null
  FieldVerDate: null
  Structure_AGE: null
  ST_RepairAs: null
  ST_RepairDate: null
  ST_Repair_Issue: null
  ST_RepairNotes: null
  ST_RepairResp: null
  InletCleaned: null
  Date_Last_Cleaned: null
  ST_Blockage: null
  Assess_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: OTH
Name: Other
Domains:
• STR_TYPE:
  Inherited
• MS4_Report:
  Inherited
• MajOutfall:
  Inherited
• StruOwner:
  Inherited
• Muni:
  Inherited
• WATERSHED8DGT:
  Inherited
• ST_RepairAs:
  Inherited
• ST_Repair_Issue:
  Inherited
• ST_RepairResp:
  Inherited
• InletCleaned:
  Inherited
• ST_Blockage:
  Inherited
• ST_RepairStatus:
  Inherited
• STsafety_score:
  Inherited
• Inlet_Type:
  Inherited
Templates:
• Name: OTH
  Description:
  Prototype:
  MDE_GDB_ID_OutfallDA: null
  STsafety_score: null
  str_num: null
  STR_TYPE: OTH
  status: null
  MS4_Report: null
  MDE_GDB_ID: null
  MajOutfall: null
  top_of_grade: null
  measured_depth: null
  GenCom: null
  StruOwner: null
  sd_number: null
  pipe_in_quantity: null
  pipe_out_quantity: null
  out_year: null
  permit_num: null
  bottom_elevation: null
  asbuiltdate: null
  approvaldate: null
  Muni: null
  WATERSHED8DGT: null
  POINT_X: null
  POINT_Y: null
  Struct_GlobalID_on_add: null
  ST_Assesment_Com: null
  ST_RepairStatus: null
  SR_NOa: null
  Inlet_Type: null
  EdCom: null
  FieldVer: null
  FieldVerDate: null
  Structure_AGE: null
  ST_RepairAs: null
  ST_RepairDate: null
  ST_Repair_Issue: null
  ST_RepairNotes: null
  ST_RepairResp: null
  InletCleaned: null
  Date_Last_Cleaned: null
  ST_Blockage: null
  Assess_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: PP
Name: Projecting Pipe
Domains:
• STR_TYPE:
  Inherited
• MS4_Report:
  Inherited
• MajOutfall:
  Inherited
• StruOwner:
  Inherited
• Muni:
  Inherited
• WATERSHED8DGT:
  Inherited
• ST_RepairAs:
  Inherited
• ST_Repair_Issue:
  Inherited
• ST_RepairResp:
  Inherited
• InletCleaned:
  Inherited
• ST_Blockage:
  Inherited
• ST_RepairStatus:
  Inherited
• STsafety_score:
  Inherited
• Inlet_Type:
  Inherited
Templates:
• Name: PP
  Description:
  Prototype:
  MDE_GDB_ID_OutfallDA: null
  STsafety_score: null
  str_num: null
  STR_TYPE: PP
  status: null
  MS4_Report: null
  MDE_GDB_ID: null
  MajOutfall: null
  top_of_grade: null
  measured_depth: null
  GenCom: null
  StruOwner: null
  sd_number: null
  pipe_in_quantity: null
  pipe_out_quantity: null
  out_year: null
  permit_num: null
  bottom_elevation: null
  asbuiltdate: null
  approvaldate: null
  Muni: null
  WATERSHED8DGT: null
  POINT_X: null
  POINT_Y: null
  Struct_GlobalID_on_add: null
  ST_Assesment_Com: null
  ST_RepairStatus: null
  SR_NOa: null
  Inlet_Type: null
  EdCom: null
  FieldVer: null
  FieldVerDate: null
  Structure_AGE: null
  ST_RepairAs: null
  ST_RepairDate: null
  ST_Repair_Issue: null
  ST_RepairNotes: null
  ST_RepairResp: null
  InletCleaned: null
  Date_Last_Cleaned: null
  ST_Blockage: null
  Assess_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

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

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ConveyanceType

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ConveyanceType ( type: esriFieldTypeString, alias: Type Of Storm Drain Conveyance, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ConveyanceType , Coded Values: [C: Culvert] , [D: Ditch] , [HC: Hydraulic Connector] , ...3 more... )
• TYPE_MATL ( type: esriFieldTypeString, alias: Conveyance Material, editable: true, nullable: true, length: 75, defaultValue: null, modelName: TYPE_MATL , 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), editable: true, nullable: true, defaultValue: null, modelName: DIM_OUTFALL )
• HT_OUTFALL ( type: esriFieldTypeDouble, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: HT_OUTFALL )
• WT_OUTFALL ( type: esriFieldTypeDouble, alias: Width, editable: true, nullable: true, defaultValue: null, modelName: WT_OUTFALL )
• MDE_GDB_ID ( type: esriFieldTypeString, alias: MDE GDB ID of Outfall, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MDE_GDB_ID )
• ConveyStatus ( type: esriFieldTypeString, alias: Conveyance Status in Field, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ConveyStatus )
• ConveyOwner ( type: esriFieldTypeString, alias: Conveyance Owner, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ConveyOwner , Coded Values: [C: County] , [S: SHA] , [M: Municipality] , ...1 more... )
• invert_in_elevation ( type: esriFieldTypeDouble, alias: Invert In Elevation, editable: true, nullable: true, defaultValue: null, modelName: invert_in_elevation )
• invert_out_elevation ( type: esriFieldTypeDouble, alias: Invert Out Elevation, editable: true, nullable: true, defaultValue: null, modelName: invert_out_elevation )
• plan_length ( type: esriFieldTypeDouble, alias: Conveyance Length on Plan in Feet, editable: true, nullable: true, defaultValue: null, modelName: plan_length )
• upstrm_globalid ( type: esriFieldTypeGUID, alias: OSDM Upstream Structure Global ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: upstrm_globalid )
• dnstrm_globalid ( type: esriFieldTypeGUID, alias: OSDM Downstream Structure Global ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: dnstrm_globalid )
• sd_number ( type: esriFieldTypeString, alias: SD Number, editable: true, nullable: true, length: 75, defaultValue: null, modelName: sd_number )
• GenCom ( type: esriFieldTypeString, alias: General Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GenCom )
• invert_in_measurement ( type: esriFieldTypeDouble, alias: Invert In Measurement, editable: true, nullable: true, defaultValue: null, modelName: invert_in_measurement )
• invert_out_measurement ( type: esriFieldTypeDouble, alias: Invert Out Measurement, editable: true, nullable: true, defaultValue: null, modelName: invert_out_measurement )
• top_width ( type: esriFieldTypeDouble, alias: Channel Top Width, editable: true, nullable: true, defaultValue: null, modelName: top_width )
• bottom_width ( type: esriFieldTypeDouble, alias: Channel Bottom Width, editable: true, nullable: true, defaultValue: null, modelName: bottom_width )
• depth ( type: esriFieldTypeDouble, alias: Channel Depth, editable: true, nullable: true, defaultValue: null, modelName: depth )
• dpw_channel_id ( type: esriFieldTypeString, alias: DPWT Channel ID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: dpw_channel_id )
• dpw_channel_name ( type: esriFieldTypeString, alias: DPWT Channel Name, editable: true, nullable: true, length: 150, defaultValue: null, modelName: dpw_channel_name )
• x_area ( type: esriFieldTypeDouble, alias: Area of Channel, editable: true, nullable: true, defaultValue: null, modelName: x_area )
• ConveyShape ( type: esriFieldTypeString, alias: Conveyance Shape, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ConveyShape , Coded Values: [VD: V-Ditch] , [PD: Parabolic Ditch] , [TD: Trapezoidal Ditch] , ...10 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GeomLengthFt ( type: esriFieldTypeDouble, alias: Geometric Length In Feet, editable: true, nullable: true, defaultValue: null, modelName: GeomLengthFt )
• EdCom ( type: esriFieldTypeString, alias: Editor Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EdCom )
• FieldVer ( type: esriFieldTypeString, alias: Field Verified, editable: true, nullable: true, length: 1, defaultValue: null, modelName: FieldVer )
• FieldVerDate ( type: esriFieldTypeDate, alias: Field Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FieldVerDate )
• Slope ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: Slope )
• Conveyance_AGE ( type: esriFieldTypeString, alias: Age of Conveyance, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Conveyance_AGE )
• Conv_RepairResp ( type: esriFieldTypeString, alias: Repair Responsibility, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Conv_RepairResp , Coded Values: [C1: Contractor 1] , [C2: Contractor 2] , [C3: Contractor 3] , ...2 more... )
• Conv_RepairStatus ( type: esriFieldTypeString, alias: Repair Progress Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Conv_RepairStatus , Coded Values: [C: Complete] , [TD: To-Do] , [IP: In-Progress] )
• Conv_RepairDate ( type: esriFieldTypeDate, alias: Repair Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Conv_RepairDate )
• Conv_Repair_Issue ( type: esriFieldTypeString, alias: Repair Issue, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Conv_Repair_Issue , Coded Values: [Reset: Reset] , [Replace: Replace] , [RU: Replace - Upgrade] )
• Conv_RepairNotes ( type: esriFieldTypeString, alias: Repair Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Conv_RepairNotes )
• PIPE_Cleaned ( type: esriFieldTypeString, alias: Pipe Cleaned, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PIPE_Cleaned , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• PipeDateLastCleaned ( type: esriFieldTypeDate, alias: Last Date Cleaned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PipeDateLastCleaned )
• ConvRepairAs ( type: esriFieldTypeString, alias: Repair Assesment Indicator, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ConvRepairAs , Coded Values: [Significant: Significant Repairs Recommended] , [NA: No Repairs Recommended] , [Moderate: Moderate Repairs Recommended] )
• Conv_Blockage ( type: esriFieldTypeString, alias: Blockage Extent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Conv_Blockage , 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, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Asses_Date2 )
• SR_NOb ( type: esriFieldTypeString, alias: Service Request Number, editable: true, nullable: true, length: 11, defaultValue: null, modelName: SR_NOb )
• Material_PipeReplace ( type: esriFieldTypeString, alias: Material of Replaced Pipe, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Material_PipeReplace , 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), editable: true, nullable: true, defaultValue: null, modelName: Length_PipeReplace )
• VideoPipeInsp ( type: esriFieldTypeString, alias: Video Pipe Inspection, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VideoPipeInsp , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• VideoPipeInspDate ( type: esriFieldTypeDate, alias: Video Pipe Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: VideoPipeInspDate )
• Conv_Assess_Com ( type: esriFieldTypeString, alias: Assesment Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Conv_Assess_Com )
• Length_Pipe_Insp ( type: esriFieldTypeDouble, alias: Length of Pipe Inspected (FT), editable: true, nullable: true, defaultValue: null, modelName: Length_Pipe_Insp )
• Length_Pipe_Cleaned ( type: esriFieldTypeDouble, alias: Length of Pipe Cleaned (FT), editable: true, nullable: true, defaultValue: null, modelName: Length_Pipe_Cleaned )
• Conv_GlobalID_on_add ( type: esriFieldTypeGUID, alias: GlobalID_On_Add, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Conv_GlobalID_on_add )
• Convsafety_score ( type: esriFieldTypeString, alias: Safety Score, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Convsafety_score , 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__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
Types:
ID: C
Name: Culvert
Domains:
• ConveyanceType:
  Inherited
• TYPE_MATL:
  Inherited
• ConveyOwner:
  Inherited
• ConveyShape:
  Inherited
• Conv_RepairResp:
  Inherited
• Conv_RepairStatus:
  Inherited
• Conv_Repair_Issue:
  Inherited
• PIPE_Cleaned:
  Inherited
• ConvRepairAs:
  Inherited
• Conv_Blockage:
  Inherited
• Material_PipeReplace:
  Inherited
• VideoPipeInsp:
  Inherited
• Convsafety_score:
  Inherited
Templates:
• Name: C
  Description:
  Prototype:
  Convsafety_score: null
  Conv_GlobalID_on_add: null
  ConveyanceType: C
  TYPE_MATL: null
  DIM_OUTFALL: null
  HT_OUTFALL: null
  WT_OUTFALL: null
  MDE_GDB_ID: null
  ConveyStatus: null
  ConveyOwner: null
  invert_in_elevation: null
  invert_out_elevation: null
  plan_length: null
  upstrm_globalid: null
  dnstrm_globalid: null
  sd_number: null
  GenCom: null
  invert_in_measurement: null
  invert_out_measurement: null
  top_width: null
  bottom_width: null
  depth: null
  dpw_channel_id: null
  dpw_channel_name: null
  x_area: null
  ConveyShape: null
  Length_Pipe_Cleaned: null
  Length_Pipe_Insp: null
  Conv_Assess_Com: null
  VideoPipeInspDate: null
  VideoPipeInsp: null
  GeomLengthFt: null
  EdCom: null
  FieldVer: null
  FieldVerDate: null
  Slope: null
  Conveyance_AGE: null
  Conv_RepairResp: null
  Conv_RepairStatus: null
  Conv_RepairDate: null
  Conv_Repair_Issue: null
  Conv_RepairNotes: null
  PIPE_Cleaned: null
  PipeDateLastCleaned: null
  ConvRepairAs: null
  Conv_Blockage: null
  Asses_Date2: null
  SR_NOb: null
  Material_PipeReplace: null
  Length_PipeReplace: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: D
Name: Ditch
Domains:
• ConveyanceType:
  Inherited
• TYPE_MATL:
  Inherited
• ConveyOwner:
  Inherited
• ConveyShape:
  Inherited
• Conv_RepairResp:
  Inherited
• Conv_RepairStatus:
  Inherited
• Conv_Repair_Issue:
  Inherited
• PIPE_Cleaned:
  Inherited
• ConvRepairAs:
  Inherited
• Conv_Blockage:
  Inherited
• Material_PipeReplace:
  Inherited
• VideoPipeInsp:
  Inherited
• Convsafety_score:
  Inherited
Templates:
• Name: D
  Description:
  Prototype:
  Convsafety_score: null
  Conv_GlobalID_on_add: null
  ConveyanceType: D
  TYPE_MATL: null
  DIM_OUTFALL: null
  HT_OUTFALL: null
  WT_OUTFALL: null
  MDE_GDB_ID: null
  ConveyStatus: null
  ConveyOwner: null
  invert_in_elevation: null
  invert_out_elevation: null
  plan_length: null
  upstrm_globalid: null
  dnstrm_globalid: null
  sd_number: null
  GenCom: null
  invert_in_measurement: null
  invert_out_measurement: null
  top_width: null
  bottom_width: null
  depth: null
  dpw_channel_id: null
  dpw_channel_name: null
  x_area: null
  ConveyShape: null
  Length_Pipe_Cleaned: null
  Length_Pipe_Insp: null
  Conv_Assess_Com: null
  VideoPipeInspDate: null
  VideoPipeInsp: null
  GeomLengthFt: null
  EdCom: null
  FieldVer: null
  FieldVerDate: null
  Slope: null
  Conveyance_AGE: null
  Conv_RepairResp: null
  Conv_RepairStatus: null
  Conv_RepairDate: null
  Conv_Repair_Issue: null
  Conv_RepairNotes: null
  PIPE_Cleaned: null
  PipeDateLastCleaned: null
  ConvRepairAs: null
  Conv_Blockage: null
  Asses_Date2: null
  SR_NOb: null
  Material_PipeReplace: null
  Length_PipeReplace: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: HC
Name: Hydraulic Connector
Domains:
• ConveyanceType:
  Inherited
• TYPE_MATL:
  Inherited
• ConveyOwner:
  Inherited
• ConveyShape:
  Inherited
• Conv_RepairResp:
  Inherited
• Conv_RepairStatus:
  Inherited
• Conv_Repair_Issue:
  Inherited
• PIPE_Cleaned:
  Inherited
• ConvRepairAs:
  Inherited
• Conv_Blockage:
  Inherited
• Material_PipeReplace:
  Inherited
• VideoPipeInsp:
  Inherited
• Convsafety_score:
  Inherited
Templates:
• Name: HC
  Description:
  Prototype:
  Convsafety_score: null
  Conv_GlobalID_on_add: null
  ConveyanceType: HC
  TYPE_MATL: null
  DIM_OUTFALL: null
  HT_OUTFALL: null
  WT_OUTFALL: null
  MDE_GDB_ID: null
  ConveyStatus: null
  ConveyOwner: null
  invert_in_elevation: null
  invert_out_elevation: null
  plan_length: null
  upstrm_globalid: null
  dnstrm_globalid: null
  sd_number: null
  GenCom: null
  invert_in_measurement: null
  invert_out_measurement: null
  top_width: null
  bottom_width: null
  depth: null
  dpw_channel_id: null
  dpw_channel_name: null
  x_area: null
  ConveyShape: null
  Length_Pipe_Cleaned: null
  Length_Pipe_Insp: null
  Conv_Assess_Com: null
  VideoPipeInspDate: null
  VideoPipeInsp: null
  GeomLengthFt: null
  EdCom: null
  FieldVer: null
  FieldVerDate: null
  Slope: null
  Conveyance_AGE: null
  Conv_RepairResp: null
  Conv_RepairStatus: null
  Conv_RepairDate: null
  Conv_Repair_Issue: null
  Conv_RepairNotes: null
  PIPE_Cleaned: null
  PipeDateLastCleaned: null
  ConvRepairAs: null
  Conv_Blockage: null
  Asses_Date2: null
  SR_NOb: null
  Material_PipeReplace: null
  Length_PipeReplace: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: OC
Name: Open Channel
Domains:
• ConveyanceType:
  Inherited
• TYPE_MATL:
  Inherited
• ConveyOwner:
  Inherited
• ConveyShape:
  Inherited
• Conv_RepairResp:
  Inherited
• Conv_RepairStatus:
  Inherited
• Conv_Repair_Issue:
  Inherited
• PIPE_Cleaned:
  Inherited
• ConvRepairAs:
  Inherited
• Conv_Blockage:
  Inherited
• Material_PipeReplace:
  Inherited
• VideoPipeInsp:
  Inherited
• Convsafety_score:
  Inherited
Templates:
• Name: OC
  Description:
  Prototype:
  Convsafety_score: null
  Conv_GlobalID_on_add: null
  ConveyanceType: OC
  TYPE_MATL: null
  DIM_OUTFALL: null
  HT_OUTFALL: null
  WT_OUTFALL: null
  MDE_GDB_ID: null
  ConveyStatus: null
  ConveyOwner: null
  invert_in_elevation: null
  invert_out_elevation: null
  plan_length: null
  upstrm_globalid: null
  dnstrm_globalid: null
  sd_number: null
  GenCom: null
  invert_in_measurement: null
  invert_out_measurement: null
  top_width: null
  bottom_width: null
  depth: null
  dpw_channel_id: null
  dpw_channel_name: null
  x_area: null
  ConveyShape: null
  Length_Pipe_Cleaned: null
  Length_Pipe_Insp: null
  Conv_Assess_Com: null
  VideoPipeInspDate: null
  VideoPipeInsp: null
  GeomLengthFt: null
  EdCom: null
  FieldVer: null
  FieldVerDate: null
  Slope: null
  Conveyance_AGE: null
  Conv_RepairResp: null
  Conv_RepairStatus: null
  Conv_RepairDate: null
  Conv_Repair_Issue: null
  Conv_RepairNotes: null
  PIPE_Cleaned: null
  PipeDateLastCleaned: null
  ConvRepairAs: null
  Conv_Blockage: null
  Asses_Date2: null
  SR_NOb: null
  Material_PipeReplace: null
  Length_PipeReplace: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: P
Name: Pipe
Domains:
• ConveyanceType:
  Inherited
• TYPE_MATL:
  Inherited
• ConveyOwner:
  Inherited
• ConveyShape:
  Inherited
• Conv_RepairResp:
  Inherited
• Conv_RepairStatus:
  Inherited
• Conv_Repair_Issue:
  Inherited
• PIPE_Cleaned:
  Inherited
• ConvRepairAs:
  Inherited
• Conv_Blockage:
  Inherited
• Material_PipeReplace:
  Inherited
• VideoPipeInsp:
  Inherited
• Convsafety_score:
  Inherited
Templates:
• Name: P
  Description:
  Prototype:
  Convsafety_score: null
  Conv_GlobalID_on_add: null
  ConveyanceType: P
  TYPE_MATL: null
  DIM_OUTFALL: null
  HT_OUTFALL: null
  WT_OUTFALL: null
  MDE_GDB_ID: null
  ConveyStatus: null
  ConveyOwner: null
  invert_in_elevation: null
  invert_out_elevation: null
  plan_length: null
  upstrm_globalid: null
  dnstrm_globalid: null
  sd_number: null
  GenCom: null
  invert_in_measurement: null
  invert_out_measurement: null
  top_width: null
  bottom_width: null
  depth: null
  dpw_channel_id: null
  dpw_channel_name: null
  x_area: null
  ConveyShape: null
  Length_Pipe_Cleaned: null
  Length_Pipe_Insp: null
  Conv_Assess_Com: null
  VideoPipeInspDate: null
  VideoPipeInsp: null
  GeomLengthFt: null
  EdCom: null
  FieldVer: null
  FieldVerDate: null
  Slope: null
  Conveyance_AGE: null
  Conv_RepairResp: null
  Conv_RepairStatus: null
  Conv_RepairDate: null
  Conv_Repair_Issue: null
  Conv_RepairNotes: null
  PIPE_Cleaned: null
  PipeDateLastCleaned: null
  ConvRepairAs: null
  Conv_Blockage: null
  Asses_Date2: null
  SR_NOb: null
  Material_PipeReplace: null
  Length_PipeReplace: null
  
  Drawing Tool: esriFeatureEditToolLine

---

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
Supports Returning Geometry Centroid: true
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• MDE_GDB_ID ( type: esriFieldTypeString, alias: MDE_GDB_ID, editable: true, nullable: true, length: 13, defaultValue: null, modelName: MDE_GDB_ID )
• MDE_GDB_ID_Outfall ( type: esriFieldTypeString, alias: MDE GDB ID of Outfall, editable: true, nullable: true, length: 13, defaultValue: null, modelName: MDE_GDB_ID_Outfall )
• OUTFALL_DRAIN_AREA ( type: esriFieldTypeDouble, alias: Drainage area (acres) to outfall, editable: true, nullable: true, defaultValue: null, modelName: OUTFALL_DRAIN_AREA )
• SD_Number ( type: esriFieldTypeString, alias: SD Number, editable: true, nullable: true, length: 13, defaultValue: null, modelName: SD_Number )
• GEN_COMMENTS ( type: esriFieldTypeString, alias: General comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GEN_COMMENTS )
• created_user ( type: esriFieldTypeString, alias: Created by, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Date created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last edited by, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last edited date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Shape__Area ( type: esriFieldTypeDouble, alias: Shape.STArea(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STArea(), required: true )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
Templates:
• Name: Outfall Drainage Area
  Description:
  Prototype:
  SD_Number: null
  GEN_COMMENTS: null
  MDE_GDB_ID: null
  MDE_GDB_ID_Outfall: null
  OUTFALL_DRAIN_AREA: null
  
  Drawing Tool: esriFeatureEditToolPolygon

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:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

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

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• rel_globalid ( type: esriFieldTypeGUID, alias: REL_GLOBALID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: rel_globalid )
• conv_pipe_cleaned ( type: esriFieldTypeString, alias: Pipe Cleaned, editable: true, nullable: true, length: 50, defaultValue: null, modelName: inlet_cleaned , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• conv_date_cleaned ( type: esriFieldTypeDate, alias: Date Cleaned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date_last_cleaned )
• Conv_comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: comments )
• C_meets_criteria_yn ( type: esriFieldTypeString, alias: Meets Criteria, editable: true, nullable: true, length: 50, defaultValue: null, modelName: meets_criteria_yn , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Length_Pipe_Cleaned ( type: esriFieldTypeDouble, alias: Length of Pipe Cleaned (FT), editable: true, nullable: true, defaultValue: null, modelName: Length_Pipe_Cleaned )
Templates:
• Name: SDC_Cleaning
  Description:
  Prototype:
  C_meets_criteria_yn: null
  Length_Pipe_Cleaned: null
  rel_globalid: null
  conv_pipe_cleaned: null
  conv_date_cleaned: null
  Conv_comments: null
  
  Drawing Tool: esriFeatureEditToolNone

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:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

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

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• safety_score2 ( type: esriFieldTypeString, alias: Safety Score, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SAFETY_SCORE , 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, editable: true, nullable: true, length: 75, defaultValue: null, modelName: BLOCKAGE , 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, editable: true, nullable: true, length: 75, defaultValue: null, modelName: CONDITION , Coded Values: [Significant: Significant Repairs Recommended] , [NA: No Repairs Recommended] , [Moderate: Moderate Repairs Recommended] )
• assess_comments2 ( type: esriFieldTypeString, alias: Assesment Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ASSESS_COMMENTS )
• assess_date2 ( type: esriFieldTypeDate, alias: Assement Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSESS_DATE )
• rel_globalid ( type: esriFieldTypeGUID, alias: REL_GLOBALID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GLOBALID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• VideoPipeInsp ( type: esriFieldTypeString, alias: Video Pipe Inspection, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VideoPipeInsp , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• VideoPipeInspDate ( type: esriFieldTypeDate, alias: Video Pipe Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: VideoPipeInspDate )
• Length_Pipe_Insp ( type: esriFieldTypeDouble, alias: Length of Pipe Inspected (FT), editable: true, nullable: true, defaultValue: null, modelName: Length_Pipe_Insp )
Templates:
• Name: SDC_Condition
  Description:
  Prototype:
  VideoPipeInspDate: null
  VideoPipeInsp: null
  safety_score2: null
  blockage2: null
  ConvRepairEval2: null
  assess_comments2: null
  assess_date2: null
  rel_globalid: null
  Length_Pipe_Insp: null
  
  Drawing Tool: esriFeatureEditToolNone

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:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

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

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• REL_GUID ( type: esriFieldTypeGUID, alias: REL_GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GUID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Conv_RepairResp3 ( type: esriFieldTypeString, alias: Repair Responsibility, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Conv_RepairResp3 , Coded Values: [C1: Contractor 1] , [C2: Contractor 2] , [C3: Contractor 3] , ...2 more... )
• Conv_RepairDate3 ( type: esriFieldTypeDate, alias: Repair Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Conv_RepairDate3 )
• Conv_Repair_Issue3 ( type: esriFieldTypeString, alias: Repair Issue, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Conv_Repair_Issue3 , Coded Values: [Reset: Reset] , [Replace: Replace] , [RU: Replace - Upgrade] )
• Conv_RepairNotes3 ( type: esriFieldTypeString, alias: Repair Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Conv_RepairNotes3 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• SR_NOb3 ( type: esriFieldTypeString, alias: Service Request Number, editable: true, nullable: true, length: 11, defaultValue: null, modelName: SR_NOb3 )
• Material_PipeReplace ( type: esriFieldTypeString, alias: Material of Replaced Pipe, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Material_PipeReplace , 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), editable: true, nullable: true, defaultValue: null, modelName: Length_PipeReplace )
Templates:
• Name: SDC_Repairs
  Description:
  Prototype:
  Material_PipeReplace: null
  SR_NOb3: null
  REL_GUID: null
  Length_PipeReplace: null
  Conv_RepairNotes3: null
  Conv_Repair_Issue3: null
  Conv_RepairDate3: null
  Conv_RepairResp3: null
  
  Drawing Tool: esriFeatureEditToolNone

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:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

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

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• rel_globalid ( type: esriFieldTypeGUID, alias: KCI Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: rel_globalid )
• inlet_cleaned ( type: esriFieldTypeString, alias: Inlet Cleaned, editable: true, nullable: true, length: 50, defaultValue: null, modelName: inlet_cleaned , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• st_date_cleaned ( type: esriFieldTypeDate, alias: Date Cleaned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date_last_cleaned )
• st_comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: comments )
• meets_criteria_yn ( type: esriFieldTypeString, alias: Meets Criteria, editable: true, nullable: true, length: 50, defaultValue: null, modelName: meets_criteria_yn , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: SDS_Cleaning
  Description:
  Prototype:
  meets_criteria_yn: null
  st_comments: null
  rel_globalid: null
  inlet_cleaned: null
  st_date_cleaned: null
  
  Drawing Tool: esriFeatureEditToolNone

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:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

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

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• safety_score ( type: esriFieldTypeString, alias: Safety Score, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SAFETY_SCORE , 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, editable: true, nullable: true, length: 75, defaultValue: null, modelName: BLOCKAGE , 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, editable: true, nullable: true, length: 75, defaultValue: null, modelName: CONDITION , Coded Values: [Significant: Significant Repairs Recommended] , [NA: No Repairs Recommended] , [Moderate: Moderate Repairs Recommended] )
• assess_comments ( type: esriFieldTypeString, alias: Assesment Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ASSESS_COMMENTS )
• assess_date ( type: esriFieldTypeDate, alias: Assessment Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSESS_DATE )
• rel_globalid ( type: esriFieldTypeGUID, alias: KCI Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GLOBALID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• top_stable ( type: esriFieldTypeString, alias: Top is Stable, editable: true, nullable: true, length: 25, defaultValue: null, modelName: top_stable_ )
• LAB_GUID ( type: esriFieldTypeGUID, alias: Lab Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: LAB_GUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: SDS_Condition
  Description:
  Prototype:
  LAB_GUID: null
  top_stable: null
  safety_score: null
  blockage: null
  RepairEval: null
  assess_comments: null
  assess_date: null
  rel_globalid: null
  
  Drawing Tool: esriFeatureEditToolNone

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:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

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

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

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

Relationships:

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