Name: SDE.DBO.wTank_PeriodicInspections

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] )
• SecurityFenceNeeded ( type: esriFieldTypeString, alias: Security Fence Needed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SecurityFenceNeeded , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• FencedTanks_Locked_DamageFree ( type: esriFieldTypeString, alias: FencedTanks_Locked_DamageFree, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FencedTanks_Locked_DamageFree , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• FencedTanks_Opening_FrcdEntry ( type: esriFieldTypeString, alias: FencedTanks_Opening_FrcdEntry, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FencedTanks_Opening_FrcdEntry , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Vandalism_Litter_Graffiti ( type: esriFieldTypeString, alias: Vandalism_Litter_Graffiti, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Vandalism_Litter_Graffiti , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ExtLadder_Locked_Secured ( type: esriFieldTypeString, alias: ExtLadder_Locked_Secured, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ExtLadder_Locked_Secured , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• IntrusionAlarm_Operational ( type: esriFieldTypeString, alias: IntrusionAlarm_Operational, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IntrusionAlarm_Operational , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• WarningLight_Operational ( type: esriFieldTypeString, alias: WarningLight_Operational, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WarningLight_Operational , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• VisibleLeakage ( type: esriFieldTypeString, alias: Visible Leakage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VisibleLeakage , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• DrainageIssue_EmbankmentErosi ( type: esriFieldTypeString, alias: DrainageIssue_EmbankmentErosi, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DrainageIssue_EmbankmentErosi , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• EncroachmentofVegetation ( type: esriFieldTypeString, alias: EncroachmentofVegetation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EncroachmentofVegetation , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Animal_Intrusion_Contaminatio ( type: esriFieldTypeString, alias: Animal_Intrusion_Contaminatio, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Animal_Intrusion_Contaminatio , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• VisibleFoundationProblems ( type: esriFieldTypeString, alias: Visible Foundation Problems, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VisibleFoundationProblems , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CanExteriorCoatingBeInspected ( type: esriFieldTypeString, alias: CanExteriorCoatingBeInspected, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CanExteriorCoatingBeInspected , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ExteriorCoatingFailure ( type: esriFieldTypeString, alias: Exterior Coating Failure, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ExteriorCoatingFailure , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TankPenetration_SealedProtect ( type: esriFieldTypeString, alias: TankPenetrations_SealedProtected, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TankPenetration_SealedProtect , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ExtLadder_Cage_Damaged ( type: esriFieldTypeString, alias: ExtLadder_Cage_Damaged, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ExtLadder_Cage_Damaged , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• RoofAccess_ClosedLocked ( type: esriFieldTypeString, alias: RoofAccess_ClosedLocked, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RoofAccess_ClosedLocked , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• AccessOpeningSanSeal_GoodCond ( type: esriFieldTypeString, alias: AccessOpeningSanSeal_GoodCondition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AccessOpeningSanSeal_GoodCond , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• VentScreen_ApprovedSizeMesh ( type: esriFieldTypeString, alias: VentScreen_ApprovedSizeMesh, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VentScreen_ApprovedSizeMesh , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• VentScreen_Damaged_Debri ( type: esriFieldTypeString, alias: VentScreen_Damaged_Debri, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VentScreen_Damaged_Debri , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ValvePitTank_Accessible_Locka ( type: esriFieldTypeString, alias: ValvePitTank_Accessible_Lockable_NoStillWater, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ValvePitTank_Accessible_Locka , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SamplingStationTanks_GoodCond ( type: esriFieldTypeString, alias: SamplingStationTanks_GoodCondition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SamplingStationTanks_GoodCond , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ExtRoofDamage_WindorSnowAccum ( type: esriFieldTypeString, alias: ExtRoofDamage_WindorSnowAccum, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ExtRoofDamage_WindorSnowAccum , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TankOverflowedorPooling ( type: esriFieldTypeString, alias: Tank Overflowed or Pooling, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TankOverflowedorPooling , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• OverflowPipeBlocked ( type: esriFieldTypeString, alias: Overflow Pipe Blocked, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OverflowPipeBlocked , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• GrndLevelOvrflowScrn_Damaged ( type: esriFieldTypeString, alias: GrndLevelOverflowScreen_Damaged, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GrndLevelOvrflowScrn_Damaged , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SanSealHatch_Contaminated ( type: esriFieldTypeString, alias: San Seal Hatch_ContaminatedInside, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SanSealHatch_Contaminated , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SanSealHatch_VegetationGrowth ( type: esriFieldTypeString, alias: SanSealHatch_VegetationGrowthInside, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SanSealHatch_VegetationGrowth , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• LevelIndicator_Functioning ( type: esriFieldTypeString, alias: LevelIndicator_Functioning, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LevelIndicator_Functioning , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• AccessRdNeedRepair ( type: esriFieldTypeString, alias: Access Road Needs Repair, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AccessRdNeedRepair , 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 )
• Recommendations ( type: esriFieldTypeString, alias: Recommendations, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Recommendations )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• GrndLevelOverflowScreen_Intact ( type: esriFieldTypeString, alias: GrndLevelOverflowScreen_Intact, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GrndLevelOverflowScreen_Intact , Coded Values: [YES: YES] , [NO: NO] )

Templates:

• Name: SDE.DBO.wTank_PeriodicInspections
  Description:
  Prototype:
  GUID: null
  GrndLevelOverflowScreen_Intact: 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
  SecurityFenceNeeded: null
  FencedTanks_Locked_DamageFree: null
  FencedTanks_Opening_FrcdEntry: null
  Vandalism_Litter_Graffiti: null
  ExtLadder_Locked_Secured: null
  IntrusionAlarm_Operational: null
  WarningLight_Operational: null
  VisibleLeakage: null
  DrainageIssue_EmbankmentErosi: null
  EncroachmentofVegetation: null
  Animal_Intrusion_Contaminatio: null
  VisibleFoundationProblems: null
  CanExteriorCoatingBeInspected: null
  ExteriorCoatingFailure: null
  TankPenetration_SealedProtect: null
  ExtLadder_Cage_Damaged: null
  RoofAccess_ClosedLocked: null
  AccessOpeningSanSeal_GoodCond: null
  VentScreen_ApprovedSizeMesh: null
  VentScreen_Damaged_Debri: null
  ValvePitTank_Accessible_Locka: null
  SamplingStationTanks_GoodCond: null
  ExtRoofDamage_WindorSnowAccum: null
  TankOverflowedorPooling: null
  OverflowPipeBlocked: null
  GrndLevelOvrflowScrn_Damaged: null
  SanSealHatch_Contaminated: null
  SanSealHatch_VegetationGrowth: null
  LevelIndicator_Functioning: null
  AccessRdNeedRepair: null
  OtherConcerns: null
  Recommendations: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SDE.DBO.wStorageTank (3) -- 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