Layers:

Layer: SWMFAC (0)

Name: SWMFAC

Display Field: BMP_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: e56c8123e4b84bc382817a49aa247c06

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: 1301872.4733707607
YMin: 351807.0689480901
XMax: 1394454.0388634205
YMax: 527076.0209029168
Spatial Reference: 102685  (2248)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 197, 255, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SWMFAC_ID ( type: esriFieldTypeString, alias: SWMFAC ID, length: 50 )
• BMP_NAME ( type: esriFieldTypeString, alias: BMP Name, length: 100 )
• BMP_TYPE ( type: esriFieldTypeString, alias: BMP Type, length: 5 , Coded Values: [AGRE: Green Roof - Extensive] , [AGRI: Green Roof - Intensive] , [APRP: Permeable Pavements] , ...46 more... )
• MD_NORTH ( type: esriFieldTypeDouble, alias: MD North )
• MD_EAST ( type: esriFieldTypeDouble, alias: MD East )
• WATERSHED8DGT ( type: esriFieldTypeString, alias: Watershed 8DGT, length: 8 , Coded Values: [02140205: Anacostia River] , [02140111: Mattawoman Creek] , [02140204: Oxon Creek] , ...9 more... )
• IMP_ACRES ( type: esriFieldTypeDouble, alias: Impervious Acres )
• APPR_DATE ( type: esriFieldTypeDate, alias: Approval Date, length: 8 )
• BUILT_DATE ( type: esriFieldTypeDate, alias: Built Date, length: 8 )
• BMP_CLASS ( type: esriFieldTypeString, alias: BMP Classification, length: 1 , Coded Values: [A: Alternative BMP] , [E: ESD] , [S: Structural BMP] )
• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 75 )
• CITY ( type: esriFieldTypeString, alias: City, length: 50 )
• ZIP ( type: esriFieldTypeString, alias: ZIP, length: 5 )
• BMP_INSP_STATUS ( type: esriFieldTypeString, alias: BMP Inspection Status, length: 1 , Coded Values: [F: Fail] , [P: Pass] )
• LAST_INSP_DATE ( type: esriFieldTypeDate, alias: Last Inspection Date, length: 8 )
• MAINTENANCE_DIST ( type: esriFieldTypeString, alias: Maintenance District, length: 50 , Coded Values: [1: Maintenance District 1] , [2: Maintenance District 2] , [3: Maintenance District 3] , ...3 more... )
• COUNCIL_DISTRICT ( type: esriFieldTypeString, alias: Council District, length: 50 , Coded Values: [1: District 1] , [2: District 2] , [3: District 3] , ...7 more... )
• MOWED_BY ( type: esriFieldTypeString, alias: Mowed By, length: 50 , Coded Values: [C1: Contractor 1] , [C2: Contractor 2] , [C3 : Contractor 3] , ...2 more... )
• IN_STREAM ( type: esriFieldTypeString, alias: In Stream, length: 1 , Coded Values: [1: True] , [2: False] )
• FENCE_MAT ( type: esriFieldTypeString, alias: Fence Material, length: 8 , Coded Values: [Wood: Primarily Composed of Wood] , [Metal: Primarily Metal with no other Treatment] , [Coated: Metal with Plastic Coating] , ...3 more... )
• DAM_HEIGHT ( type: esriFieldTypeDouble, alias: Dam Height )
• SEEP_CONT ( type: esriFieldTypeString, alias: Seepage Condition, length: 1 , Coded Values: [1: True] , [2: False] )
• SEEP_CONT_COMMENTS ( type: esriFieldTypeString, alias: Seepage Condition Comments, length: 200 )
• FILTER_DIA ( type: esriFieldTypeString, alias: Filter DIA, length: 50 , Coded Values: [1: True] , [2: False] )
• HAZ_CLASS ( type: esriFieldTypeString, alias: High Hazard Pond Classifications, length: 50 , Coded Values: [A: Class A] , [B: Class B] , [C: Class C] , ...5 more... )
• COMMENTS_OVERALL ( type: esriFieldTypeString, alias: Comments - Overall, length: 120 )
• Q_1YR ( type: esriFieldTypeDouble, alias: 1 Year Discharge in cfs )
• Q_2YR ( type: esriFieldTypeDouble, alias: 2 Year Discharge in cfs )
• Q_10YR ( type: esriFieldTypeDouble, alias: 10 Year Discharge in cfs )
• Q_100YR ( type: esriFieldTypeDouble, alias: 100 Year Discharge in cfs )
• WS_ELEV_WQv ( type: esriFieldTypeDouble, alias: Water Quality Volume (Cubic Feet) )
• WSELEV_1_CPv ( type: esriFieldTypeDouble, alias: 24 Hour Extended Detention Elevation for the 1 Year Event )
• WSELEV_2_CPv ( type: esriFieldTypeDouble, alias: 24 Hour Extended Detention Elevation for the 2 Year Event )
• WSELEV_10_CPv ( type: esriFieldTypeDouble, alias: 24 Hour Extended Detention Elevation for the 10 Year Event )
• WSELEV_100_CPv ( type: esriFieldTypeDouble, alias: 24 Hour Extended Detention Elevation for the 100 Year Event )
• FOUR_MI_VICINITY_AIRPORT ( type: esriFieldTypeString, alias: BMP is within 4 Miles of Airport, length: 1 , Coded Values: [1: True] , [2: False] )
• 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 )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 255 )
• LAST_INSP_RATING ( type: esriFieldTypeString, alias: Last Inspection Rating, length: 50 , Coded Values: [0: 0 - NOT part of design ] , [A: A - Functioning as designed - NO problems.] , [B: B - Minor issues - Functioning, may require annual inspection] , ...4 more... )
• ReInspectFY ( type: esriFieldTypeSmallInteger, alias: Reinspecting Fiscal Year )
• InspectingFirm ( type: esriFieldTypeString, alias: Inspecting Firm, length: 75 , Coded Values: [DPW: DPW&T] , [C1: Consultant 1] , [C2: Consultant 2] )
• InspectionStatus ( type: esriFieldTypeString, alias: Inspection Status, length: 10 , Coded Values: [C: Complete] , [T: To-Do] , [N: NA] , ...1 more... )
• Current_Insp_Type ( type: esriFieldTypeString, alias: Inspection Type, length: 25 , Coded Values: [N: New Inspection] , [R: Re-Inspection] , [M: Maintenance Re-Inspection] , ...2 more... )
• responsibility ( type: esriFieldTypeString, alias: Responsibility, length: 25 , Coded Values: [Corvias: Corvias] , [Other: Other] , [DPWT: PG County Public Works and Transportation] , ...4 more... )
• MS4_Report ( type: esriFieldTypeString, alias: MS4 Report, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• LAST_MAINT_DATE ( type: esriFieldTypeDate, alias: Last Maintenance Date, length: 8 )
• FY_Maint_Status ( type: esriFieldTypeString, alias: Present FY Maintenance Status, length: 255 , Coded Values: [C: Complete] , [TD: To-Do] , [IP: In-Progress] )
• STRU_NO ( type: esriFieldTypeString, alias: Structure ID, length: 8 )
• ConsentDecree ( type: esriFieldTypeString, alias: Consent Decree BMP, length: 255 , Coded Values: [a: II6a] , [c: II6c Restoration BMPs] )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 255 )
• SWMFAC_GUID ( type: esriFieldTypeGUID, alias: SWMFAC_GUID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• LAST_MOW_DATE ( type: esriFieldTypeDate, alias: Last Mow Date, length: 8 )
• ProjectedMaintStatus ( type: esriFieldTypeString, alias: Projected Maintenance Status, length: 255 , Coded Values: [C: Complete] , [TD: To-Do] , [IP: In-Progress] )
• MaintInspStatus ( type: esriFieldTypeString, alias: Maintenance Inspection Status, length: 255 , Coded Values: [C: Complete] , [T: To-Do] , [N: NA] , ...1 more... )
• MaintResp ( type: esriFieldTypeString, alias: Maintenance Responsibility, length: 255 , Coded Values: [C1: Contractor 1] , [C2: Contractor 2] , [C3 : Contractor 3] , ...2 more... )
• MowingAcres ( type: esriFieldTypeDouble, alias: Acres to Mow )
• ETL_Run ( type: esriFieldTypeDate, alias: ETL Run Date, length: 8 )

Relationships:

• SWMFAC_FOOTPRINT (0) -- Related To: SWMFAC_Footprint (1)
• SWMFAC_INSPECTIONS (3) -- Related To: Inspections (5)
• SWMFAC_AS_BUILTS (1) -- Related To: SWMFAC_As_Builts (3)
• SWMFAC_MAINTENANCE (2) -- Related To: Maintenance (4)

Layer: SWMFAC_Footprint (1)

Name: SWMFAC_Footprint

Display Field: created_user

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: e56c8123e4b84bc382817a49aa247c06

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: 1301658.798273176
YMin: 351581.0428253412
XMax: 1394498.167384088
YMax: 527108.135668084
Spatial Reference: 102685  (2248)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [115, 223, 255, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 43
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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ACRES ( type: esriFieldTypeDouble, alias: Acres )
• 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 )
• STRU_NOd ( type: esriFieldTypeString, alias: Structure ID, length: 8 )
• SWMFAC_GUID ( type: esriFieldTypeGUID, alias: SWMFAC_GUID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• SHAPE.STArea() ( type: esriFieldTypeDouble, alias: SHAPE.STArea() )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Relationships:

• SWMFAC (0) -- Related To: SWMFAC (0)

Layer: SWMFAC_Districts_Maintenance (2)

Name: SWMFAC_Districts_Maintenance

Display Field: District_n

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: e56c8123e4b84bc382817a49aa247c06

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: 1290286.6251514256
YMin: 317373.1699682623
XMax: 1406405.4956035018
YMax: 533632.9999149293
Spatial Reference: 102685  (2248)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [252, 242, 214, 0]
Outline:
Style: esriSLSSolid
Color: [255, 255, 255, 255]
Width: 2
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 )
• ESMGDB.PGCSW.SWMFAC_DISTRICTS_MAINTENANCE.AREA ( type: esriFieldTypeDouble, alias: ESMGDB.PGCSW.SWMFAC_DISTRICTS_MAINTENANCE.AREA )
• PERIMETER ( type: esriFieldTypeDouble, alias: PERIMETER )
• DISTRICT_ ( type: esriFieldTypeInteger, alias: DISTRICT_ )
• DISTRICT_I ( type: esriFieldTypeInteger, alias: DISTRICT_I )
• District_n ( type: esriFieldTypeString, alias: District_n, length: 16 )
• 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 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Tables:

Table: SWMFAC_As_Builts (3)

Name: SWMFAC_As_Builts

Display Field: AS_BUILT_PLAN_ID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e56c8123e4b84bc382817a49aa247c06

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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• AS_BUILT_PLAN_ID ( type: esriFieldTypeString, alias: Contract ID, length: 50 )
• TITLE ( type: esriFieldTypeString, alias: Title, length: 120 )
• YEAR_BUILT ( type: esriFieldTypeInteger, alias: Year Built )
• PLAN_DATE ( type: esriFieldTypeDate, alias: Plan Date, length: 8 )
• COM_AS_BUILTS ( type: esriFieldTypeString, alias: Completed As Builts, length: 200 )
• V_DATUM ( type: esriFieldTypeString, alias: V Datum, length: 12 , Coded Values: [1929: NGVD 29] , [1988: NAVD 88] , [OTHER: Other] , ...1 more... )
• FILE_LOCATION ( type: esriFieldTypeString, alias: File Location, length: 255 )
• 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 )
• STRU_NOc ( type: esriFieldTypeString, alias: Structure ID, length: 8 )
• SWMFAC_GUID ( type: esriFieldTypeGUID, alias: SWMFAC_GUID, length: 38 )

Relationships:

• SWMFAC (1) -- Related To: SWMFAC (0)

Table: Maintenance (4)

Name: Maintenance

Display Field: Maintenance_Status

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 )
• SWMFAC_GUID ( type: esriFieldTypeGUID, alias: SWMFAC_GUID, length: 38 )
• Maintenance_Date ( type: esriFieldTypeDate, alias: Maintenance Date, length: 8 )
• Maintenance_Status ( type: esriFieldTypeString, alias: Maintenance Status, length: 255 , Coded Values: [C: Complete] , [TD: To-Do] , [IP: In-Progress] )
• Contractor ( type: esriFieldTypeString, alias: Contractor, length: 255 , Coded Values: [C1: Contractor 1] , [C2: Contractor 2] , [C3 : Contractor 3] , ...2 more... )
• Maintenance_Comment ( type: esriFieldTypeString, alias: Comment, length: 255 )
• STRU_NOb ( type: esriFieldTypeString, alias: Structure ID, length: 8 )
• Inspection_Status ( type: esriFieldTypeString, alias: Inspection Status, length: 255 , Coded Values: [I: Inspected] , [NI: Needs Inspection] )
• 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 )
• Cost_Maintenance ( type: esriFieldTypeDouble, alias: Cost of Maintenance )

Relationships:

• SWMFAC (2) -- Related To: SWMFAC (0)

Table: Inspections (5)

Name: Inspections

Display Field: INSPECTR

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e56c8123e4b84bc382817a49aa247c06

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SWMFAC_GUID ( type: esriFieldTypeGUID, alias: SWMFAC_GUID, length: 38 )
• DATE_INSP ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• INSPECTR ( type: esriFieldTypeString, alias: Inspector Name(s), length: 255 )
• DATE_STORM ( type: esriFieldTypeDate, alias: Date of Last Storm Event, length: 8 )
• MOW ( type: esriFieldTypeString, alias: Ability to mow designation areas, length: 255 , Coded Values: [0: 0 - NO Mowing Required] , [1: 1 - Slopes 4:1 or flatter or tractor.] , [2: 2 - Emb./Spillway/Outfall flat. Other components are too steep.] , ...4 more... )
• MOW_COM ( type: esriFieldTypeString, alias: Comment - Mowing, length: 255 )
• ACCESS_FACILITY ( type: esriFieldTypeString, alias: Access to and around the facility, length: 255 , Coded Values: [0: 0 - NOT part of design] , [1: 1 - 5 Criteria Met] , [2: 2 - 4 Criteria Met] , ...4 more... )
• COM_ACCESS ( type: esriFieldTypeString, alias: Comment - Access, length: 255 )
• WILDLIFE_EXISTS ( type: esriFieldTypeString, alias: Signs of Wildlife Activity, length: 255 , Coded Values: [1: True] , [2: False] )
• WILDLIFE_COMMENT ( type: esriFieldTypeString, alias: Comment - Wildlife, length: 255 )
• OUTFALL ( type: esriFieldTypeString, alias: Outfall of the principal spillway, length: 255 , Coded Values: [1: 1 - No stream erosion. Stable channel invert/slopes. No debris.] , [2: 2 - 0 to 25%; Minor erosion. Stable channel invert/ slopes.] , [3: 3 - 26 to 50%; Moderate/Active erosion bottom/slopes. RRP Minor relocation.] , ...4 more... )
• OUTFALL_COM ( type: esriFieldTypeString, alias: Comment - Outfall, length: 255 )
• DS_CONDITION ( type: esriFieldTypeString, alias: Overall condition downstream of outfall, length: 255 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Absent of erosion.] , [2: 2 - Minor - Stable. No headcutting] , ...4 more... )
• DS_CONDITION_COM ( type: esriFieldTypeString, alias: Comment - Downstream Condition, length: 255 )
• RED_FLAG ( type: esriFieldTypeString, alias: Does the site require immediate attention?, length: 50 , Coded Values: [1: True] , [2: False] )
• RED_FLAG_COM ( type: esriFieldTypeString, alias: Comment - Red Flag, length: 255 )
• RATING ( type: esriFieldTypeString, alias: Rating, length: 255 , Coded Values: [0: 0 - NOT part of design ] , [A: A - Functioning as designed - NO problems.] , [B: B - Minor issues - Functioning, may require annual inspection] , ...4 more... )
• GEN_COMMENTS ( type: esriFieldTypeString, alias: Comments - General, length: 255 )
• 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 )
• QC_Complete ( type: esriFieldTypeString, alias: QC Complete, length: 50 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• QC_initials ( type: esriFieldTypeString, alias: QC Initials, length: 32 )
• inspection_type ( type: esriFieldTypeString, alias: Inspection Type, length: 50 , Coded Values: [N: New Inspection] , [R: Re-Inspection] , [M: Maintenance Re-Inspection] , ...2 more... )
• fiscal_year ( type: esriFieldTypeSmallInteger, alias: Fiscal Year )
• STRU_NOa ( type: esriFieldTypeString, alias: Structure ID, length: 8 )
• INSPECTION_GUID ( type: esriFieldTypeGUID, alias: INSPECTION_GUID, length: 38 )
• BMP_TYPE2 ( type: esriFieldTypeString, alias: BMP Type, length: 255 , Coded Values: [AGRE: Green Roof - Extensive] , [AGRI: Green Roof - Intensive] , [APRP: Permeable Pavements] , ...48 more... )

Relationships:

• SWMFAC_INSPECTIONS_ACTIONS (12) -- Related To: Inspection_Actions (12)
• SWMFAC_INSPECTIONS_OBSERVATIONWELLS (8) -- Related To: Inspection_Observation_Wells (11)
• SWMFAC_SUB_INSP_SWALES (11) -- Related To: Swale (7)
• SWMFAC_SUB_INSP_UNDERGROUND (9) -- Related To: Underground (10)
• SWMFAC_SUB_INSP_PONDS (6) -- Related To: Ponds (6)
• SWMFAC_INSPECTIONS_INFLOWS (7) -- Related To: Inspection_Inflows (13)
• SWMFAC_SUB_INSP_FILTERINGSYSTEMS (4) -- Related To: Filtering_Systems (9)
• SWMFAC_SUB_INSP_INFILTRATIONFACILITY (5) -- Related To: Infiltration_Facility (8)
• SWMFAC (3) -- Related To: SWMFAC (0)

Table: Ponds (6)

Name: Ponds

Display Field: DEBRIS

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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• INSPECTION_GUID ( type: esriFieldTypeGUID, alias: INSPECTION_GUID, length: 38 )
• DEBRIS ( type: esriFieldTypeString, alias: Debris in or near facility, length: 255 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Absent or accumulations – see above.] , [2: 2 - 0 to 25% of surface, Minor.] , ...4 more... )
• DEBRIS_COM ( type: esriFieldTypeString, alias: Comment - Debris, length: 255 )
• SEDIMENT ( type: esriFieldTypeString, alias: Quantify sedimentation in pond, length: 255 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Absent.] , [2: 2 - 10%, Minor. Doesn’t block low flow.] , ...4 more... )
• SEDIMENT_COM ( type: esriFieldTypeString, alias: Comment - Sedimentation, length: 255 )
• INFLOW_COND ( type: esriFieldTypeString, alias: Overall Condition of Inflows (see Inflows table for evaluation of each inflow), length: 255 , Coded Values: [0: 0 - Not part of design] , [1: 1 - No problems.] , [2: 2 - Minor sedimentation/structural damage. No Maint. required.] , ...4 more... )
• INFLOW_COND_COM ( type: esriFieldTypeString, alias: Comment - Inflow Condition, length: 255 )
• IN_FLOW_STABILITY ( type: esriFieldTypeString, alias: Stability of discharges into pond (ditches and outfalls), length: 255 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Functioning properly.] , [2: 2 - Minor erosion. Monitored.] , ...4 more... )
• IN_FLOW_STABILITY_COM ( type: esriFieldTypeString, alias: Comment - Inflow Stability, length: 255 )
• PONDING ( type: esriFieldTypeString, alias: Unwanted or extended ponding in pond, length: 255 , Coded Values: [0: 0 - BMP is a WET Facility or “OW” not installed as required.] , [1: 1 - As designed. (%) = [measured OW water depth ÷ OW Full depth] x 100] , [2: 2 - Minor; 0 to 25% volume.] , ...4 more... )
• PONDING_COM ( type: esriFieldTypeString, alias: Comment - Ponding, length: 255 )
• WATER_DEPTH ( type: esriFieldTypeDouble, alias: Depth of standing water )
• WATER_DEPTH_COM ( type: esriFieldTypeString, alias: Comment - Water Depth, length: 255 )
• PERMPOOL ( type: esriFieldTypeString, alias: Condition of pond with permanent standing water, length: 255 , Coded Values: [0: 0 - NOT part of design] , [2: 2 - 100 to 75% design. Note reasons for issues.] , [3: 3 - 75 to <50% design OR Moderate fluctuations.] , ...4 more... )
• PERMPOOL_COM ( type: esriFieldTypeString, alias: Comment - Permanent Pool, length: 255 )
• FOREBAY ( type: esriFieldTypeString, alias: Overall Condition of any pre-treatment device, length: 255 , Coded Values: [0: 0 - Designed with NO Pretreatment.] , [1: 1 - Absent of vegetation, woody/leafy debris, garbage, &/or sediment.] , [2: 2 - 0 to 25%; Minor accumulations.] , ...4 more... )
• FOREBAY_COM ( type: esriFieldTypeString, alias: Comment - Forebay, length: 255 )
• CS_OPEN ( type: esriFieldTypeString, alias: Riser/Control Structure Openings, length: 255 , Coded Values: [0: 0 - NOT part of design] , [1: 1 - Absent of woody/leafy, sedimentation, & garbage debris.] , [2: 2 - 0 to 25%] , ...4 more... )
• CS_OPEN_COM ( type: esriFieldTypeString, alias: Comment - Riser/Control Structure Openings, length: 255 )
• CS_TRSH ( type: esriFieldTypeString, alias: Riser/Control Structure Trashrack, length: 255 , Coded Values: [0: 0 - if N/A] , [1: 1 - Absent of garbage/woody/leafy debris. Functioning properly.] , [2: 2 - 0 t 25% blocked; functioning properly w/ Minor damage.] , ...4 more... )
• CS_TRSH_COM ( type: esriFieldTypeString, alias: Comment - Riser/Control Structure Trashrack, length: 255 )
• CS_SEDI ( type: esriFieldTypeString, alias: Riser/Control Structure Sediment or Debris, length: 255 , Coded Values: [0: 0 - 0 if Weir] , [1: 1 - Absent of woody/leafy, sedimentation, & garbage debris.] , [2: 2 - 0 to 25% of outlet.] , ...4 more... )
• CS_SEDI_COM ( type: esriFieldTypeString, alias: Comment - Riser/Control Structure Sediment or Debris, length: 255 )
• CS_STRC ( type: esriFieldTypeString, alias: Riser/Control Structure Cracks, Spalling, Joints, length: 255 , Coded Values: [0: 0 - NOT part of design] , [1: 1 - Absent of woody/leafy, sedimentation, & garbage debris.] , [2: 2 - 0 to 25%] , ...4 more... )
• CS_STRC_COM ( type: esriFieldTypeString, alias: Comment - Riser/Control Structure Cracks, Spalling, Joints, length: 255 )
• CS_VALV ( type: esriFieldTypeString, alias: Riser/Control Structure Valve, length: 255 , Coded Values: [0: 0 - No valve.] , [1: 1 - Valve is functional & is chained & locked.] , [2: 2 - Same as above but debris may start to compromise functionality.] , ...4 more... )
• CS_VALV_COM ( type: esriFieldTypeString, alias: Comment - Riser/Control Structure Valve, length: 255 )
• ORF_OPEN ( type: esriFieldTypeString, alias: Low-flow orifice opening, length: 255 , Coded Values: [0: 0 - If N/A] , [1: 1 - Absent of blockages.] , [2: 2 - 0 to 25% blocked.] , ...4 more... )
• ORF_OPEN_COM ( type: esriFieldTypeString, alias: Comment - Low-flow orifice opening, length: 255 )
• ORF_TRSH ( type: esriFieldTypeString, alias: Low-flow orifice trashrack, length: 255 , Coded Values: [0: 0 - If N/A] , [1: 1 - Absent of garbage/woody/leafy debris. Functioning properly.] , [2: 2 - 0 t 25% blocked; functioning properly w/ minor damage.] , ...4 more... )
• ORF_TRSH_COM ( type: esriFieldTypeString, alias: Comment - Low-flow orifice trashrack, length: 255 )
• EMGYSPW_PRESENT ( type: esriFieldTypeString, alias: Emergency Spillway Present?, length: 255 , Coded Values: [1: True] , [2: False] )
• EMGYSPW_STAB ( type: esriFieldTypeString, alias: Emergency Spillway Stability, length: 255 , Coded Values: [0: 0 - NA or “Principal/Emergency Spwy Combo”] , [1: 1 - Stable & functioning properly.] , [2: 2 - Minor erosion but Stable.] , ...4 more... )
• EMGYSPW_STAB_COM ( type: esriFieldTypeString, alias: Comment - Emergency Spillway Stability, length: 255 )
• EMGYSPW_OPEN ( type: esriFieldTypeString, alias: Emergency Spillway Opening, length: 255 , Coded Values: [0: 0 - NA or “Principal/Emergency Spwy Combo”] , [1: 1 - Absent of garbage/woody/leafy debris. Functioning properly.] , [2: 2 - Minor blockage.] , ...4 more... )
• EMGYSPW_OPEN_COM ( type: esriFieldTypeString, alias: Comment - Emergency Spillway Opening, length: 255 )
• EMBUP_CVR ( type: esriFieldTypeString, alias: Upstream Embankment - Cover/Vegetation, length: 255 , Coded Values: [0: 0 - NOT part of design] , [1: 1 - Densely vegetated. (100% herbaceous cover – no woody vegetation)] , [2: 2 - 76 to 100% cover w/ minor sapling < 0.5” dia.] , ...4 more... )
• EMBUP_CVR_COM ( type: esriFieldTypeString, alias: Comment - Upstream Embankment - Cover/Vegetation, length: 255 )
• EMBUP_ERO ( type: esriFieldTypeString, alias: Upstream Embankment - Erosion, length: 255 , Coded Values: [0: 0 - NOT part of design] , [1: 1 - Stable & absent of erosion.] , [3: 3 - Stable & Moderate erosion. Schedule Maint.] , ...4 more... )
• EMBUP_ERO_COM ( type: esriFieldTypeString, alias: Comment - Upstream Embankment - Erosion, length: 255 )
• EMBUP_TOE ( type: esriFieldTypeString, alias: Upstream Embankment - Toe Condition, length: 255 , Coded Values: [0: 0 - NOT part of design] , [1: 1 - UPSTREAM Toe is stable.] , [2: 2 - Minor settling but Stable.] , ...4 more... )
• EMBUP_TOE_COM ( type: esriFieldTypeString, alias: Comment - Upstream Embankment - Toe Condition, length: 255 )
• EMBDS_CVR ( type: esriFieldTypeString, alias: Downstream Embankment - Cover/Vegetation, length: 255 , Coded Values: [1: 1 - Densely vegetated. (100% herbaceous cover – no woody vegetation)] , [2: 2 - 76 to 100% cover w/ minor sapling < 0.5” dia.] , [3: 3 - 51 to 75% or woody veg. 0.5” to 1.5”. Schedule Maint.] , ...4 more... )
• EMBDS_CVR_COM ( type: esriFieldTypeString, alias: Comment - Downstream Embankment - Cover/Vegetation, length: 255 )
• EMBDS_ERO ( type: esriFieldTypeString, alias: Downstream Embankment - Erosion, length: 255 , Coded Values: [1: 1 - Stable & absent of erosion.] , [3: 3 - Stable & Moderate erosion. Schedule Maint.] , [4: 4 - Major erosion. Integrity potentially compromised. Maint. Immediately.] , ...4 more... )
• EMBDS_ERO_COM ( type: esriFieldTypeString, alias: Comment - Downstream Embankment - Erosion, length: 255 )
• EMBDS_TOE ( type: esriFieldTypeString, alias: Downstream Embankment - Toe Condition, length: 255 , Coded Values: [1: 1 - DOWNSTREAM Toe is stable.] , [2: 2 - Minor settling but Stable.] , [3: 3 - Moderate settlement or holes. Schedule Maint.] , ...4 more... )
• EMBDS_TOE_COM ( type: esriFieldTypeString, alias: Comment - Downstream Embankment - Toe Condition, length: 255 )
• EMBDS_SEEP ( type: esriFieldTypeString, alias: Downstream Embankment - Seepage condition (include filter), length: 255 , Coded Values: [1: 1 - Stable & NO seepage.] , [2: 2 - Stable w/ Minor Saturation @ toe.] , [3: 3 - Moderate Saturation. Should be inspected/ monitored.] , ...4 more... )
• EMBDS_SEEP_COM ( type: esriFieldTypeString, alias: Comment – Downstream Embankment - Seepage condition, length: 255 )
• PRIN_SPWY ( type: esriFieldTypeString, alias: Principal Spillway, length: 255 , Coded Values: [2: 2 - 0 to 25%, Minor (shape)] , [3: 3 - 26 to 50%, Moderate (corrosion/deflection). Schedule Maint.] , [4: 4 - 51 to 75%, Significant. Compromised. Maint. Immediately] , ...4 more... )
• PRIN_SPWY_COM ( type: esriFieldTypeString, alias: Comment - Principal Spillway, length: 255 )
• CONVEY_STABILITY ( type: esriFieldTypeString, alias: Conveyance Stability, length: 255 , Coded Values: [1: 1 - Stable.] , [2: 2 - Minor erosion & Stable.] , [4: 4 - Major erosion & signs of deterioration. Schedule Maint.] , ...3 more... )
• CONVEY_STABILITY_COM ( type: esriFieldTypeString, alias: Comment - Conveyance Stability, length: 255 )
• SITE_VEGETATION ( type: esriFieldTypeString, alias: Unwanted vegetation impacting site, length: 255 , Coded Values: [0: 0 - NOT part of design] , [1: 1 - Well managed. No fallen trees. Access is clear. NO Maintenance.] , [3: 3 - 26 to 50% overgrown - access is difficult. Maint. Recommended.] , ...4 more... )
• SITE_VEGETATION_COM ( type: esriFieldTypeString, alias: Comment - Unwanted vegetation, length: 255 )
• POND_VEG ( type: esriFieldTypeString, alias: Vegetation Condition specific to water quality, length: 255 , Coded Values: [0: 0 - NOT part of design] , [1: 1 - 80 to 100% cover (ex: Bioretention/Wetlands/Wet Swale)] , [2: 2 - 60 to 80% cover; 10 to 30% invasive.] , ...4 more... )
• POND_VEG_COM ( type: esriFieldTypeString, alias: Comment - Vegetation Condition, length: 255 )
• POND_CONTAMINATION ( type: esriFieldTypeString, alias: Pond Contamination, length: 255 , Coded Values: [0: 0 - NOT part of design] , [1: 1 - Absent of items in #39] , [2: 2 - Minor accumulations – no contamination.] , ...4 more... )
• POND_CONTAMINATION_COM ( type: esriFieldTypeString, alias: Comment - Pond Contamination, length: 255 )
• POND_C_CONC_INV ( type: esriFieldTypeString, alias: Overall Concern Rating (contamination or invasives) - Use Concerns table, length: 255 , Coded Values: [C: Contamination] , [I: Invasive species] , [B: Both] , ...2 more... )
• TYPE_C_CONC_INV ( type: esriFieldTypeString, alias: Comment - Overall Concern Rating, length: 255 )
• FENCES ( type: esriFieldTypeString, alias: Fence Condition, length: 255 , Coded Values: [0: 0 - 0 if N/A] , [1: 1 - Good condition.] , [2: 2 - Wear but NO security breaches.] , ...4 more... )
• FENCES_COM ( type: esriFieldTypeString, alias: Comment - Fence Condition, length: 255 )
• SAFE_WATER_DEPTH ( type: esriFieldTypeString, alias: Safe Water Depth, length: 255 , Coded Values: [0: 0 - 0 if DRY design] , [2: 2 - Depth >2’, NOT Fenced w/ “No Trespassing” Sign, and “Benches”, <4:1.] , [3: 3 - Depth >2’ & fence encircles BMP.] , ...4 more... )
• SAFE_WATER_DEPTH_COM ( type: esriFieldTypeString, alias: Comment - Safe Water Depth, length: 255 )
• GEN_COMMENTSa ( type: esriFieldTypeString, alias: Comments - General, length: 255 )
• 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 )
• Type_Concern ( type: esriFieldTypeString, alias: Type of Concern 1, length: 25 , Coded Values: [AL: Algae] , [CS: Construction Sediment] , [CW: Chemical Waste] , ...7 more... )
• Concern_Comment ( type: esriFieldTypeString, alias: Comment - Concern, length: 255 )
• Type_Concern2 ( type: esriFieldTypeString, alias: Type of Concern 2, length: 25 , Coded Values: [AL: Algae] , [CS: Construction Sediment] , [CW: Chemical Waste] , ...7 more... )
• Type_Concern3 ( type: esriFieldTypeString, alias: Type of Concern 3, length: 25 , Coded Values: [AL: Algae] , [CS: Construction Sediment] , [CW: Chemical Waste] , ...7 more... )

Relationships:

• SWMFAC_INSPECTIONS (6) -- Related To: Inspections (5)

Table: Swale (7)

Name: Swale

Display Field: VEG_MOW

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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• INSPECTION_GUID ( type: esriFieldTypeGUID, alias: INSPECTION_GUID, length: 38 )
• VEG_MOW ( type: esriFieldTypeString, alias: Veg Mow height adequate, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• VEG_SEED ( type: esriFieldTypeString, alias: Veg Seeding necessary, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• VEG_O ( type: esriFieldTypeString, alias: Veg other, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• VEG_COM ( type: esriFieldTypeString, alias: Veg Comments, length: 255 )
• GEN_COMMENTSb ( type: esriFieldTypeString, alias: Comments - General, length: 255 )
• 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:

• SWMFAC_INSPECTIONS (11) -- Related To: Inspections (5)

Table: Infiltration_Facility (8)

Name: Infiltration_Facility

Display Field: Inlet_Opening

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e56c8123e4b84bc382817a49aa247c06

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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• INSPECTION_GUID ( type: esriFieldTypeGUID, alias: INSPECTION_GUID, length: 38 )
• Inlet_Opening ( type: esriFieldTypeString, alias: Inlet Opening, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Inlet_Opening_Com ( type: esriFieldTypeString, alias: Inlet Opening Comments, length: 255 )
• Sediment_Trash ( type: esriFieldTypeString, alias: Sediment and/or Trash in Structure, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Sed_Trash_Com ( type: esriFieldTypeString, alias: Sediment and/or Trash in Structure Comments, length: 255 )
• Struct_Cond ( type: esriFieldTypeString, alias: Structural Condition of Inlet, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Struct_Cond_Com ( type: esriFieldTypeString, alias: Structural Condition of Inlet Comments, length: 255 )
• Outfall_Cond ( type: esriFieldTypeString, alias: Outfall Condition, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Outfall_Dia ( type: esriFieldTypeDouble, alias: Outfall Pipe Diameter (Inches) )
• Outfall_Type ( type: esriFieldTypeString, alias: Outfall Pipe Type, length: 50 , Coded Values: [RCP: RCP] , [PVC: PVC] , [HDPE: HDPE] , ...3 more... )
• Outfall_Coma ( type: esriFieldTypeString, alias: Outfall Comments, length: 255 )
• Underdrain_Cond ( type: esriFieldTypeString, alias: Underdrain Condition, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Underdrain_Com ( type: esriFieldTypeString, alias: Underdrain Comments, length: 255 )
• Site_Stability ( type: esriFieldTypeString, alias: Site Stability, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Site_Stability_Com ( type: esriFieldTypeString, alias: Site Stability Comments, length: 255 )
• Vegetation ( type: esriFieldTypeString, alias: Vegetation, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Vegetation_Com ( type: esriFieldTypeString, alias: Vegetation Comments, length: 255 )
• Access ( type: esriFieldTypeString, alias: Access, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Access_Com ( type: esriFieldTypeString, alias: Access Comments, length: 255 )
• Water_Depth ( type: esriFieldTypeDouble, alias: Water Depth (Inches) )
• Dist_Water_Sur_Pipe ( type: esriFieldTypeDouble, alias: Distance from water surface to pipe inverts )
• Sediment_Accu_Inlet ( type: esriFieldTypeString, alias: Sediment Accumulation in Inlet, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Debris_Accu_Inlet ( type: esriFieldTypeString, alias: Debris Accumulation in Inlet, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Obs_Well_Found ( type: esriFieldTypeString, alias: Observation Well Found, length: 5 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• Width_Inlet ( type: esriFieldTypeDouble, alias: Width of Inlet (Inches) )
• GEN_COMMENTSc ( type: esriFieldTypeString, alias: Comments - General, length: 255 )
• 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:

• SWMFAC_INSPECTIONS (5) -- Related To: Inspections (5)

Table: Filtering_Systems (9)

Name: Filtering_Systems

Display Field: MLCH_EX

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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• INSPECTION_GUID ( type: esriFieldTypeGUID, alias: INSPECTION_GUID, length: 38 )
• MLCH_EX ( type: esriFieldTypeString, alias: Does Mulch Exist?, length: 5 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• SOIL_EX ( type: esriFieldTypeString, alias: Does Soil Exist?, length: 5 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• SAND_EX ( type: esriFieldTypeString, alias: Does Sand Exist?, length: 5 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• GRVL_EX ( type: esriFieldTypeString, alias: Does Gravel Exist?, length: 5 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• BUILT_TO_PLANS ( type: esriFieldTypeString, alias: Depth and material built to plans, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• FILTER_MAT ( type: esriFieldTypeString, alias: Condition of filter material, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• TRASH_DEBRIS ( type: esriFieldTypeString, alias: Filter material free of trash/debris, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• OIL_CHEM ( type: esriFieldTypeString, alias: Filter material free of oil/chemicals, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• FABRIC ( type: esriFieldTypeString, alias: Filter fabric acceptable and intact, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• SEDIMENT ( type: esriFieldTypeString, alias: Accumulation of sediment, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• PONDING ( type: esriFieldTypeString, alias: Flooding/ponding of water, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• PONDING_DEPTH ( type: esriFieldTypeString, alias: Flooding/ponding of water depth, length: 255 )
• VEG_COND ( type: esriFieldTypeString, alias: Vegetation - Condition of vegetation, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• VEG_PLNTRP ( type: esriFieldTypeString, alias: Vegetation - Replacement of plants, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• VEG_AREAS ( type: esriFieldTypeString, alias: Vegetation - Sparsely vegetated areas, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• VEG_INV ( type: esriFieldTypeString, alias: Vegetation - Growth of undesirable or invasive plants, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• VEG_COM ( type: esriFieldTypeString, alias: Vegetation - Comments, length: 255 )
• UD_OP ( type: esriFieldTypeString, alias: Underdrains Operational, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• UD_OB ( type: esriFieldTypeString, alias: Underdrains Obstructed, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• UD_DL ( type: esriFieldTypeString, alias: Underdrains Daylighted, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• UD_COM ( type: esriFieldTypeString, alias: Underdrain Comments, length: 255 )
• MISC_ENCR ( type: esriFieldTypeString, alias: Miscellaneous Encroachment into facility or outfall area, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• MISC_COMP ( type: esriFieldTypeString, alias: Miscellaneous Complaints from local residents, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• MISC_PUMP ( type: esriFieldTypeString, alias: Miscellaneous Pump function, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• MISC_GRAF ( type: esriFieldTypeString, alias: Miscellaneous Graffiti removal required, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• MISC_HAZ ( type: esriFieldTypeString, alias: Miscellaneous Public hazards, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• MISC_COM ( type: esriFieldTypeString, alias: Miscellaneous Comment, length: 255 )
• GEN_COMMENTSd ( type: esriFieldTypeString, alias: Comments - General, length: 255 )
• 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:

• SWMFAC_INSPECTIONS (4) -- Related To: Inspections (5)

Table: Underground (10)

Name: Underground

Display Field: CL_ACC

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e56c8123e4b84bc382817a49aa247c06

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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• INSPECTION_GUID ( type: esriFieldTypeGUID, alias: INSPECTION_GUID, length: 38 )
• CL_ACC ( type: esriFieldTypeString, alias: Cleanout Accessibility, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• CL_CAP ( type: esriFieldTypeString, alias: Cleanout Cap in place, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• CL_O ( type: esriFieldTypeString, alias: Cleanout Other, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• CL_COM ( type: esriFieldTypeString, alias: Cleanout Comment, length: 255 )
• ChamA_Manhole ( type: esriFieldTypeString, alias: Chamber "A" Manhole spacing rings okay, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamA_Manhole_Com ( type: esriFieldTypeString, alias: Chamber "A" Manhole spacing rings okay Comments, length: 255 )
• ChamA_Throat ( type: esriFieldTypeString, alias: Chamber "A" Throat opening support block at least 6 inch, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamA_Throat_Com ( type: esriFieldTypeString, alias: Chamber "A" Throat opening support block at least 6 inch Comments, length: 255 )
• ChamA_Accu_Sed ( type: esriFieldTypeString, alias: Chamber "A" Accumulation of sediment, debris, oil, or trash, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamA_Accu_Sed_Com ( type: esriFieldTypeString, alias: Chamber "A" Accumulation of sediment, debris, oil, or trash Comments, length: 255 )
• ChamA_Cracks_Displace ( type: esriFieldTypeString, alias: Chamber "A" Cracks and/or displacements, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamA_Cracks_Displace_Com ( type: esriFieldTypeString, alias: Chamber "A" Cracks and/or displacements Comments, length: 255 )
• ChamA_Joint ( type: esriFieldTypeString, alias: Chamber "A" Joint Failure, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamA_Joint_Com ( type: esriFieldTypeString, alias: Chamber "A" Joint Failure Comments, length: 255 )
• ChamA_Watertight ( type: esriFieldTypeString, alias: Chamber "A" Watertight, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamA_Watertight_Com ( type: esriFieldTypeString, alias: Chamber "A" Watertight Comments, length: 255 )
• ChamA_Lug ( type: esriFieldTypeString, alias: Chamber "A" Lug lifts to be removed, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamA_Lug_Com ( type: esriFieldTypeString, alias: Chamber "A" Lug lifts to be removed Comments, length: 255 )
• ChamA_Influ_Efflu ( type: esriFieldTypeString, alias: Chamber "A" Influent/Effluent pipe condition, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamA_Influ_Efflu_Com ( type: esriFieldTypeString, alias: Chamber "A" Influent/Effluent pipe condition Comments, length: 255 )
• ChamA_Gutterpan ( type: esriFieldTypeString, alias: Chamber "A" Gutterpan spalling present, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamA_Gutterpan_Com ( type: esriFieldTypeString, alias: Chamber "A" Gutterpan spalling present Comments, length: 255 )
• ChamA_Baffles ( type: esriFieldTypeString, alias: Chamber "A" Baffles functioning, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamA_Baffles_Com ( type: esriFieldTypeString, alias: Chamber "A" Baffles functioning Comments, length: 255 )
• ChamA_Other ( type: esriFieldTypeString, alias: Chamber "A" Other, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamA_Other_Com ( type: esriFieldTypeString, alias: Chamber "A" Other Comments, length: 255 )
• ChamB_Manhole ( type: esriFieldTypeString, alias: Chamber "B" Manhole spacing rings okay, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamB_Manhole_Com ( type: esriFieldTypeString, alias: Chamber "B" Manhole spacing rings okay Comments, length: 255 )
• ChamB_Throat ( type: esriFieldTypeString, alias: Chamber "B" Throat opening support block at least 6 inch, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamB_Throat_Com ( type: esriFieldTypeString, alias: Chamber "B" Throat opening support block at least 6 inch Comments, length: 255 )
• ChamB_Accu_Sed ( type: esriFieldTypeString, alias: Chamber "B" Accumulation of sediment, debris, oil, or trash, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamB_Accu_Sed_Com ( type: esriFieldTypeString, alias: Chamber "B" Accumulation of sediment, debris, oil, or trash Comments, length: 255 )
• ChamB_Cracks_Displace ( type: esriFieldTypeString, alias: Chamber "B" Cracks and/or displacements, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamB_Cracks_Displace_Com ( type: esriFieldTypeString, alias: Chamber "B" Cracks and/or displacements Comments, length: 255 )
• ChamB_Joint ( type: esriFieldTypeString, alias: Chamber "B" Joint Failure, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamB_Joint_Com ( type: esriFieldTypeString, alias: Chamber "B" Joint Failure Comments, length: 255 )
• ChamB_Watertight ( type: esriFieldTypeString, alias: Chamber "B" Watertight, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamB_Watertight_Com ( type: esriFieldTypeString, alias: Chamber "B" Watertight Comments, length: 255 )
• ChamB_Lug ( type: esriFieldTypeString, alias: Chamber "B" Lug lifts to be removed, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamB_Lug_Com ( type: esriFieldTypeString, alias: Chamber "B" Lug lifts to be removed Comments, length: 255 )
• ChamB_Influ_Efflu ( type: esriFieldTypeString, alias: Chamber "B" Influent/Effluent pipe condition, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamB_Influ_Efflu_Com ( type: esriFieldTypeString, alias: Chamber "B" Influent/Effluent pipe condition Comments, length: 255 )
• ChamB_Gutterpan ( type: esriFieldTypeString, alias: Chamber "B" Gutterpan spalling present, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamB_Gutterpan_Com ( type: esriFieldTypeString, alias: Chamber "B" Gutterpan spalling present Comments, length: 255 )
• ChamB_Baffles ( type: esriFieldTypeString, alias: Chamber "B" Baffles functioning, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamB_Baffles_Com ( type: esriFieldTypeString, alias: Chamber "B" Baffles functioning Comments, length: 255 )
• ChamB_Other ( type: esriFieldTypeString, alias: Chamber "B" Other, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• ChamB_Other_Com ( type: esriFieldTypeString, alias: Chamber "B" Other Comments, length: 255 )
• Outfall_Chamber_Concrete ( type: esriFieldTypeString, alias: Outfall Chamber Concrete/Masonry Condition, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Outfall_Chamber_Concrete_Com ( type: esriFieldTypeString, alias: Outfall Chamber Concrete/Masonry Condition Comments, length: 255 )
• Outfall_Chamber_Cracks ( type: esriFieldTypeString, alias: Outfall Chamber Cracks and/or displacements, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Outfall_Chamber_Cracks_Com ( type: esriFieldTypeString, alias: Outfall Chamber Cracks and/or displacements Comments, length: 255 )
• Outfall_Chamber_Min_Spall ( type: esriFieldTypeString, alias: Outfall Chamber Minor spalling (1 in or less), length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Outfall_Chamber_Min_Spall_Com ( type: esriFieldTypeString, alias: Outfall Chamber Minor spalling (1 in or less) Comments, length: 255 )
• Outfall_Chamber_Maj_Spall ( type: esriFieldTypeString, alias: Outfall Chamber Major spalling (exposed re-bar), length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Outfall_Chamber_Maj_Spall_Com ( type: esriFieldTypeString, alias: Outfall Chamber Major spalling (exposed re-bar) Comments, length: 255 )
• Outfall_Chamber_Watertight ( type: esriFieldTypeString, alias: Outfall Chamber Watertight, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Outfall_Chamber_Watertight_Com ( type: esriFieldTypeString, alias: Outfall Chamber Watertight Comments, length: 255 )
• Outfall_Chamber_Lug ( type: esriFieldTypeString, alias: Outfall Chamber Lug lifts to be removed, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Outfall_Chamber_Lug_Com ( type: esriFieldTypeString, alias: Outfall Chamber Lug lifts to be removed Comments, length: 255 )
• Outfall_Chamber_Accum ( type: esriFieldTypeString, alias: Outfall Chamber Accumulation of sediment, trash, or debris, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Outfall_Chamber_Accum_Com ( type: esriFieldTypeString, alias: Outfall Chamber Accumulation of sediment, trash, or debris Comments, length: 255 )
• Outfall_Chamber_Other ( type: esriFieldTypeString, alias: Outfall Chamber Other, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Outfall_Chamber_Other_Com ( type: esriFieldTypeString, alias: Outfall Chamber Other Comments, length: 255 )
• Cleanout_Accessibility ( type: esriFieldTypeString, alias: Cleanout Accessibility, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Cleanout_Accessibility_Com ( type: esriFieldTypeString, alias: Cleanout Accessibility Comments, length: 255 )
• Cleanout_Cap ( type: esriFieldTypeString, alias: Cleanout Cap in place, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Cleanout_Cap_Com ( type: esriFieldTypeString, alias: Cleanout Cap in place Comments, length: 255 )
• Cleanout_Other ( type: esriFieldTypeString, alias: Cleanout Other, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• Cleanout_Other_Com ( type: esriFieldTypeString, alias: Cleanout Other Comments, length: 255 )
• GEN_COMMENTSe ( type: esriFieldTypeString, alias: Comments - General, length: 255 )
• 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:

• SWMFAC_INSPECTIONS (9) -- Related To: Inspections (5)

Table: Inspection_Observation_Wells (11)

Name: Inspection_Observation_Wells

Display Field: OW_WLDPTH

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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• INSPECTION_GUID ( type: esriFieldTypeGUID, alias: INSPECTION_GUID, length: 38 )
• OW_WLDPTH ( type: esriFieldTypeString, alias: Observation Well total depth of well from bottom to top (ft), length: 5 )
• OW_WTRDPTH ( type: esriFieldTypeString, alias: Observation Well total water depth from bottom of well to top of water (ft), length: 5 )
• OW_WLSRFDPTH ( type: esriFieldTypeString, alias: Observation Well total depth from top of well to ground surface (ft), length: 5 )
• OW_CAP ( type: esriFieldTypeString, alias: Observation Well roperly capped, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• OW_CRK ( type: esriFieldTypeString, alias: Observation Well cracked or broken, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• OW_DEB ( type: esriFieldTypeString, alias: Observation Well free of debris, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• OW_SEC ( type: esriFieldTypeString, alias: Observation Well well secured, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• OW_WTR ( type: esriFieldTypeString, alias: Observation Well presence of water in well, length: 5 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• OW_O ( type: esriFieldTypeString, alias: Observation Well other, length: 5 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Not a Problem] , [2: 2 - Monitor (Potential for future problem)] , ...5 more... )
• GEN_COMMENTSf ( type: esriFieldTypeString, alias: Comments - General, length: 255 )
• 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:

• SWMFAC_INSPECTIONS (8) -- Related To: Inspections (5)

Table: Inspection_Actions (12)

Name: Inspection_Actions

Display Field: COM_ACTION

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e56c8123e4b84bc382817a49aa247c06

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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• COM_ACTION ( type: esriFieldTypeString, alias: Action, length: 50 , Coded Values: [BE: Rebuild Embankment to Provide Required Freeboard] , [BN: Install Pond Bench/Shelves] , [CO: Construct Emergency Spillway Opening] , ...88 more... )
• GEN_COMMENTSh ( type: esriFieldTypeString, alias: Comments - General, length: 255 )
• 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 )
• INSPECTION_GUID ( type: esriFieldTypeGUID, alias: Inspection GUID, length: 38 )
• LOC_ACTION ( type: esriFieldTypeString, alias: Action Location, length: 5 , Coded Values: [AB: Aquatic Bench] , [AP: Adjacent Property] , [AR: Access Road] , ...31 more... )

Relationships:

• SWMFAC_INSPECTIONS (12) -- Related To: Inspections (5)

Table: Inspection_Inflows (13)

Name: Inspection_Inflows

Display Field: INFLOW_TYPE

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e56c8123e4b84bc382817a49aa247c06

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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• INSPECTION_GUID ( type: esriFieldTypeGUID, alias: INSPECTION_GUID, length: 38 )
• INFLOW_TYPE ( type: esriFieldTypeString, alias: Inflow Type, length: 10 , Coded Values: [RCP: RCP] , [PVC: PVC] , [HDPE: HDPE] , ...3 more... )
• INFLOW_DIAMETER ( type: esriFieldTypeDouble, alias: Inflow Diameter (Inches) )
• INFLOW_COND ( type: esriFieldTypeString, alias: Inflow Condition Rating, length: 100 , Coded Values: [0: 0 - Not part of design] , [1: 1 - No problems.] , [2: 2 - Minor sedimentation/structural damage. No Maint. required.] , ...4 more... )
• INFLOW_COND_COM ( type: esriFieldTypeString, alias: In Flow Condition Comment, length: 255 )
• IN_FLOW_STABILITY ( type: esriFieldTypeString, alias: In Flow Stability Rating, length: 100 , Coded Values: [0: 0 - Not part of design] , [1: 1 - Functioning properly.] , [2: 2 - Minor erosion. Monitored.] , ...4 more... )
• IN_FLOW_STABILITY_COM ( type: esriFieldTypeString, alias: In Flow Stability Comments, length: 255 )
• GEN_COMMENTSg ( type: esriFieldTypeString, alias: Comments - General, length: 255 )
• 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:

• SWMFAC_INSPECTIONS (7) -- Related To: Inspections (5)

Table: SWMFAC_INSPECTIONS__ATTACH (14)

Name: SWMFAC_INSPECTIONS__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e56c8123e4b84bc382817a49aa247c06

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:
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SWMFAC_GID ( type: esriFieldTypeString, alias: SWMFAC_GID, length: 255 )
• STRU_NO ( type: esriFieldTypeString, alias: STRU_NO, length: 255 )