Name: SDE.DBO.wTank_ComprehensiveInspections

Display Field: SystemName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SystemName ( type: esriFieldTypeString, alias: System Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SystemName )
• PWSID ( type: esriFieldTypeString, alias: PWSID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PWSID )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• InspectorsName ( type: esriFieldTypeString, alias: Inspectors Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectorsName )
• InspectorsPhone ( type: esriFieldTypeString, alias: Inspectors Phone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectorsPhone )
• InspectorsEmail ( type: esriFieldTypeString, alias: Inspectors Email, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectorsEmail )
• SDWISTankName ( type: esriFieldTypeString, alias: SDWIS Tank Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SDWISTankName )
• SDWISFacilityStateID ( type: esriFieldTypeString, alias: SDWIS Facility State ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SDWISFacilityStateID )
• InspectionStartTime ( type: esriFieldTypeDate, alias: Inspection Start Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionStartTime )
• InspectionFinishTime ( type: esriFieldTypeDate, alias: Inspection Finish Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionFinishTime )
• TankLevel ( type: esriFieldTypeString, alias: Tank Level, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TankLevel )
• WeatherConditions ( type: esriFieldTypeString, alias: Weather Conditions, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WeatherConditions )
• SanitaryDefects ( type: esriFieldTypeString, alias: Sanitary Defects, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SanitaryDefects )
• PhotographsTaken ( type: esriFieldTypeString, alias: Photographs Taken, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PhotographsTaken , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TankContamination ( type: esriFieldTypeString, alias: Tank Contamination, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TankContamination , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Water_Turbid_Discolored_Foul ( type: esriFieldTypeString, alias: Water_Turbid_Discolored_Foul, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Water_Turbid_Discolored_Foul , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• StoredWater_RoutinelyTurnedOv ( type: esriFieldTypeString, alias: StoredWater_RoutinelyTurnedOver, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StoredWater_RoutinelyTurnedOv , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CathodicProtectionFunctioning ( type: esriFieldTypeString, alias: Cathodic Protection Functioning, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CathodicProtectionFunctioning , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• InteriorCoatingFailure ( type: esriFieldTypeString, alias: Interior Coating Failure, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InteriorCoatingFailure , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• InteriorSidewallsFailure ( type: esriFieldTypeString, alias: Interior Sidewalls Failure, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InteriorSidewallsFailure , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• RoofInteriorFailure ( type: esriFieldTypeString, alias: Roof Interior Failure, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RoofInteriorFailure , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• InteriorHatchFailure ( type: esriFieldTypeString, alias: Interior Hatch Failure, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InteriorHatchFailure , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ANSI_NSF_Standards_Stamp ( type: esriFieldTypeString, alias: ANSI_NSF_Standards_Stamp, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ANSI_NSF_Standards_Stamp , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TankFloorFailure ( type: esriFieldTypeString, alias: Tank Floor Failure, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TankFloorFailure , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TankPenetrationsSealed ( type: esriFieldTypeString, alias: Tank Penetrations Sealed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TankPenetrationsSealed , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• DaylightVisibleInsideTank ( type: esriFieldTypeString, alias: Daylight Visible Inside Tank, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DaylightVisibleInsideTank , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• InternalLadderDamage ( type: esriFieldTypeString, alias: Internal Ladder Damage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InternalLadderDamage , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• OtherConcerns ( type: esriFieldTypeString, alias: Other Concerns, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OtherConcerns )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• CleaningCompleted ( type: esriFieldTypeString, alias: Cleaning Completed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CleaningCompleted , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )

Templates:

• Name: SDE.DBO.wTank_ComprehensiveInspections
  Description:
  Prototype:
  CleaningCompleted: null
  GUID: null
  SystemName: null
  PWSID: null
  InspectionDate: null
  InspectorsName: null
  InspectorsPhone: null
  InspectorsEmail: null
  SDWISTankName: null
  SDWISFacilityStateID: null
  InspectionStartTime: null
  InspectionFinishTime: null
  TankLevel: null
  WeatherConditions: null
  SanitaryDefects: null
  PhotographsTaken: null
  TankContamination: null
  Water_Turbid_Discolored_Foul: null
  StoredWater_RoutinelyTurnedOv: null
  CathodicProtectionFunctioning: null
  InteriorCoatingFailure: null
  InteriorSidewallsFailure: null
  RoofInteriorFailure: null
  InteriorHatchFailure: null
  ANSI_NSF_Standards_Stamp: null
  TankFloorFailure: null
  TankPenetrationsSealed: null
  DaylightVisibleInsideTank: null
  InternalLadderDamage: null
  OtherConcerns: null
  Comments: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata