Name: SDE.DBO.wTank_ComprehensiveInspections

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] )
• TankContamination ( type: esriFieldTypeString, alias: Tank Contamination, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Water_Turbid_Discolored_Foul ( type: esriFieldTypeString, alias: Water_Turbid_Discolored_Foul, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• StoredWater_RoutinelyTurnedOv ( type: esriFieldTypeString, alias: StoredWater_RoutinelyTurnedOver, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CathodicProtectionFunctioning ( type: esriFieldTypeString, alias: Cathodic Protection Functioning, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• InteriorCoatingFailure ( type: esriFieldTypeString, alias: Interior Coating Failure, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• InteriorSidewallsFailure ( type: esriFieldTypeString, alias: Interior Sidewalls Failure, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• RoofInteriorFailure ( type: esriFieldTypeString, alias: Roof Interior Failure, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• InteriorHatchFailure ( type: esriFieldTypeString, alias: Interior Hatch Failure, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ANSI_NSF_Standards_Stamp ( type: esriFieldTypeString, alias: ANSI_NSF_Standards_Stamp, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TankFloorFailure ( type: esriFieldTypeString, alias: Tank Floor Failure, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TankPenetrationsSealed ( type: esriFieldTypeString, alias: Tank Penetrations Sealed, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• DaylightVisibleInsideTank ( type: esriFieldTypeString, alias: Daylight Visible Inside Tank, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• InternalLadderDamage ( type: esriFieldTypeString, alias: Internal Ladder Damage, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• OtherConcerns ( type: esriFieldTypeString, alias: Other Concerns, length: 255 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• CleaningCompleted ( type: esriFieldTypeString, alias: Cleaning Completed, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )

Relationships:

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

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata