Name: sw_Conn_Ctrl_inspection_maintenance

Display Field: date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: dcbd867db0214958be9cfa5bf7ef57ab

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: 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: false
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 )
• inspection_AssetID ( type: esriFieldTypeString, alias: AssetID, length: 10 )
• StructureType ( type: esriFieldTypeString, alias: StructureType, length: 255 )
• GrateLidType ( type: esriFieldTypeString, alias: GrateLidType, length: 255 , Coded Values: [Beehive: Beehive] , [Birdcage: Birdcage] , [Grate: Grate] , ...4 more... )
• AccessOpen ( type: esriFieldTypeString, alias: AccessOpen, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• AccessLidLock ( type: esriFieldTypeString, alias: AccessLidLock, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• AccessLadder ( type: esriFieldTypeString, alias: AccessLadder, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• StructureGap ( type: esriFieldTypeString, alias: StructureGap, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• StructureDefectsTopside ( type: esriFieldTypeString, alias: StructureDefectsTopside, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• StructureDefectsInside ( type: esriFieldTypeString, alias: StructureDefectsInside, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• StructureSediment ( type: esriFieldTypeString, alias: StructureSediment, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• StructureDebris ( type: esriFieldTypeString, alias: StructureDebris, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• InletOutletDebris ( type: esriFieldTypeString, alias: InletOutletDebris, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• InletOutletImpairment ( type: esriFieldTypeString, alias: InletOutletImpairment, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• IllicitDischarge ( type: esriFieldTypeString, alias: IllicitDischarge, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• inspection_Notes ( type: esriFieldTypeString, alias: Notes, length: 1000 )
• guid ( type: esriFieldTypeGUID, alias: guid, length: 38 )
• 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 )
• insp_flag_location ( type: esriFieldTypeString, alias: Flagged issue with feature location during inspection, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• insp_flag_deferred ( type: esriFieldTypeString, alias: Flagged asset for deferred maintenance, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• insp_flag_ownership ( type: esriFieldTypeString, alias: Flagged feature because asset ownership is in question, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• insp_flag_lock ( type: esriFieldTypeString, alias: Flagged asset as having a locking mechanism, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• insp_flag_cleaning ( type: esriFieldTypeString, alias: Flagged asset for cleaning during inspection, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• insp_flag_repair ( type: esriFieldTypeString, alias: Flagged asset for repair during inspection, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• FROP_T_secured ( type: esriFieldTypeString, alias: Generic field for FROP-T questions about upright/secure/watertight, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• FROP_T_orifice ( type: esriFieldTypeString, alias: Generic field for FROP-T questions about orifice plate, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• FROP_T_overflow ( type: esriFieldTypeString, alias: Generic field for FROP-T questions about overflow pope, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• FROP_T_rodchain ( type: esriFieldTypeString, alias: Generic field for FROP-T questions about cleanout gate rod/chain pull, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• FROP_T_gate ( type: esriFieldTypeString, alias: Generic field for FROP-T questions about cleanout gate, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• SignEducationOutreach ( type: esriFieldTypeString, alias: Generic field for 'Site' section signage question, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• Fence ( type: esriFieldTypeString, alias: Generic field for 'Site' section fence question, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• bior_flowpath ( type: esriFieldTypeString, alias: Bioretention-specific field for vegetation blocking flowpath, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• bior_bare ( type: esriFieldTypeString, alias: Bioretention-specific field for poor/bare groundcover, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• bior_shade ( type: esriFieldTypeString, alias: Bioretention-specific field for growth hindered by shade, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• StandingWater ( type: esriFieldTypeString, alias: Generic field for questions related to standing/slow-draining water, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• bior_flowspread ( type: esriFieldTypeString, alias: Bioretention-specific field for flow spread question, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• Erosion ( type: esriFieldTypeString, alias: Generic field for erosion-related questions, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• VegetationOvergrown ( type: esriFieldTypeString, alias: Generic field for questions related to overgrown vegetation, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• StructureBaffle ( type: esriFieldTypeString, alias: Generic field for 'Structure' section baffle questions, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• media_scum ( type: esriFieldTypeString, alias: Media filter vault-specific field for question regarding scum on media filters, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• media_bypassed ( type: esriFieldTypeString, alias: Media filter vault-specific field for question regarding bypass condition, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• owsp_oil ( type: esriFieldTypeString, alias: Baffle/Coalescing Plate OWSP-specific 'Structure' section question on oil accumuilation, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• Vent ( type: esriFieldTypeString, alias: Generic field for 'Structure' section ventilation question, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• owsp_coalescing_plate ( type: esriFieldTypeString, alias: Baffle/Coalescing Plate OWSP-specific 'Structure' section question on coaslescing plates, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• owsp_shutoff ( type: esriFieldTypeString, alias: Baffle/Coalescing Plate OWSP-specific 'Structure' section question on shutoff valve, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• owsp_discharge ( type: esriFieldTypeString, alias: Baffle/Coalescing Plate OWSP-specific 'Discharge' section question on discharged water quality, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• pond_critters ( type: esriFieldTypeString, alias: Pond-specific question to capture presence of hazardous insects, rodents, and beavers, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• VegNoxious ( type: esriFieldTypeString, alias: Generic question for presence of noxious vegetation, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• pond_wall ( type: esriFieldTypeString, alias: Pond-specific field for retaining wall damage, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• pond_berm_settling ( type: esriFieldTypeString, alias: Pond-specific field for settling of berms, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• inspection_date ( type: esriFieldTypeDate, alias: date, length: 8 )
• StructureSpillway ( type: esriFieldTypeString, alias: Spillway, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• media_sediment ( type: esriFieldTypeString, alias: media_sediment, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )
• pond_spillway ( type: esriFieldTypeString, alias: pond_spillway, length: 255 , Coded Values: [Deferred: Deferred] , [Complete: Complete] , [Satisfactory: Satisfactory] , ...1 more... )

Relationships:

• GIS.DBO.sw_Ctrl_Facilities (0) -- Related To: sw_Ctrl_Facilities (0)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata