Name: SDE.DBO.wTank_PeriodicInspections

Display Field: SystemName

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SystemName ( type: esriFieldTypeString, alias: System Name, length: 255 )
• PWSID ( type: esriFieldTypeString, alias: PWSID, length: 255 )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• InspectorsName ( type: esriFieldTypeString, alias: Inspectors Name, length: 255 )
• InspectorsPhone ( type: esriFieldTypeString, alias: Inspectors Phone, length: 255 )
• InspectorsEmail ( type: esriFieldTypeString, alias: Inspectors Email, length: 255 )
• SDWISTankName ( type: esriFieldTypeString, alias: SDWIS Tank Name, length: 255 )
• SDWISFacilityStateID ( type: esriFieldTypeString, alias: SDWIS Facility State ID, length: 255 )
• InspectionStartTime ( type: esriFieldTypeDate, alias: Inspection Start Time, length: 8 )
• InspectionFinishTime ( type: esriFieldTypeDate, alias: Inspection Finish Time, length: 8 )
• TankLevel ( type: esriFieldTypeString, alias: Tank Level, length: 255 )
• WeatherConditions ( type: esriFieldTypeString, alias: Weather Conditions, length: 255 )
• SanitaryDefects ( type: esriFieldTypeString, alias: Sanitary Defects, length: 255 )
• PhotographsTaken ( type: esriFieldTypeString, alias: Photographs Taken, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SecurityFenceNeeded ( type: esriFieldTypeString, alias: Security Fence Needed, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• FencedTanks_Locked_DamageFree ( type: esriFieldTypeString, alias: FencedTanks_Locked_DamageFree, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• FencedTanks_Opening_FrcdEntry ( type: esriFieldTypeString, alias: FencedTanks_Opening_FrcdEntry, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Vandalism_Litter_Graffiti ( type: esriFieldTypeString, alias: Vandalism_Litter_Graffiti, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ExtLadder_Locked_Secured ( type: esriFieldTypeString, alias: ExtLadder_Locked_Secured, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• IntrusionAlarm_Operational ( type: esriFieldTypeString, alias: IntrusionAlarm_Operational, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• WarningLight_Operational ( type: esriFieldTypeString, alias: WarningLight_Operational, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• VisibleLeakage ( type: esriFieldTypeString, alias: Visible Leakage, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• DrainageIssue_EmbankmentErosi ( type: esriFieldTypeString, alias: DrainageIssue_EmbankmentErosi, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• EncroachmentofVegetation ( type: esriFieldTypeString, alias: EncroachmentofVegetation, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Animal_Intrusion_Contaminatio ( type: esriFieldTypeString, alias: Animal_Intrusion_Contaminatio, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• VisibleFoundationProblems ( type: esriFieldTypeString, alias: Visible Foundation Problems, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CanExteriorCoatingBeInspected ( type: esriFieldTypeString, alias: CanExteriorCoatingBeInspected, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ExteriorCoatingFailure ( type: esriFieldTypeString, alias: Exterior Coating Failure, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TankPenetration_SealedProtect ( type: esriFieldTypeString, alias: TankPenetrations_SealedProtected, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ExtLadder_Cage_Damaged ( type: esriFieldTypeString, alias: ExtLadder_Cage_Damaged, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• RoofAccess_ClosedLocked ( type: esriFieldTypeString, alias: RoofAccess_ClosedLocked, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• AccessOpeningSanSeal_GoodCond ( type: esriFieldTypeString, alias: AccessOpeningSanSeal_GoodCondition, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• VentScreen_ApprovedSizeMesh ( type: esriFieldTypeString, alias: VentScreen_ApprovedSizeMesh, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• VentScreen_Damaged_Debri ( type: esriFieldTypeString, alias: VentScreen_Damaged_Debri, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ValvePitTank_Accessible_Locka ( type: esriFieldTypeString, alias: ValvePitTank_Accessible_Lockable_NoStillWater, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SamplingStationTanks_GoodCond ( type: esriFieldTypeString, alias: SamplingStationTanks_GoodCondition, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ExtRoofDamage_WindorSnowAccum ( type: esriFieldTypeString, alias: ExtRoofDamage_WindorSnowAccum, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TankOverflowedorPooling ( type: esriFieldTypeString, alias: Tank Overflowed or Pooling, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• OverflowPipeBlocked ( type: esriFieldTypeString, alias: Overflow Pipe Blocked, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• GrndLevelOvrflowScrn_Damaged ( type: esriFieldTypeString, alias: GrndLevelOverflowScreen_Damaged, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SanSealHatch_Contaminated ( type: esriFieldTypeString, alias: San Seal Hatch_ContaminatedInside, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SanSealHatch_VegetationGrowth ( type: esriFieldTypeString, alias: SanSealHatch_VegetationGrowthInside, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• LevelIndicator_Functioning ( type: esriFieldTypeString, alias: LevelIndicator_Functioning, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• AccessRdNeedRepair ( type: esriFieldTypeString, alias: Access Road Needs Repair, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• OtherConcerns ( type: esriFieldTypeString, alias: Other Concerns, length: 255 )
• Recommendations ( type: esriFieldTypeString, alias: Recommendations, length: 255 )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )
• GrndLevelOverflowScreen_Intact ( type: esriFieldTypeString, alias: GrndLevelOverflowScreen_Intact, length: 255 , Coded Values: [YES: YES] , [NO: NO] )

Relationships:

• SDE.DBO.wStorageTank (3) -- Related To: wStorageTank (13)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata