Name: Inspection Form

Display Field: InspectorName

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
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• OwnerContact ( type: esriFieldTypeString, alias: Owner / Contact, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OwnerContact )
• PhoneNo ( type: esriFieldTypeString, alias: Phone No, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PhoneNo )
• AddressLocation ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AddressLocation )
• InspDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspDate )
• InspectorName ( type: esriFieldTypeString, alias: Inspector's Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectorName )
• InspType ( type: esriFieldTypeSmallInteger, alias: Inspection Type, editable: true, nullable: true, defaultValue: null, modelName: InspType , Coded Values: [1: Initial Inspection] , [2: Renewal Inspection] , [3: Re-Inspection] )
• CCCPClass ( type: esriFieldTypeSmallInteger, alias: Class, editable: true, nullable: true, defaultValue: null, modelName: CCCPClass , Coded Values: [1: Residential] , [2: Commercial] , [3: Non-CCCP Lot] , ...1 more... )
• HazardType ( type: esriFieldTypeSmallInteger, alias: Hazard Type, editable: true, nullable: true, defaultValue: null, modelName: HazardType , Coded Values: [1: Low] , [2: High] )
• HeatSource ( type: esriFieldTypeSmallInteger, alias: Heat Source, editable: true, nullable: true, defaultValue: null, modelName: HeatSource , Coded Values: [1: Forced Air] , [2: Boiler (protected)] , [3: Boiler (unprotected)] , ...1 more... )
• Question1 ( type: esriFieldTypeSmallInteger, alias: Question 1: Is there any type of secondary water supply within the property?, editable: true, nullable: true, defaultValue: null, modelName: Question1 , Coded Values: [0: No] , [1: Yes] )
• Q1SurfaceWater ( type: esriFieldTypeSmallInteger, alias: Surface Water, editable: true, nullable: true, defaultValue: null, modelName: Q1SurfaceWater , Coded Values: [0: No] , [1: Yes] )
• Q1WellSupply ( type: esriFieldTypeSmallInteger, alias: Well supply, editable: true, nullable: true, defaultValue: null, modelName: Q1WellSupply , Coded Values: [0: No] , [1: Yes] )
• Q1StorageTank ( type: esriFieldTypeSmallInteger, alias: Storage tank, editable: true, nullable: true, defaultValue: null, modelName: Q1StorageTank , Coded Values: [0: No] , [1: Yes] )
• Q1Recirculated ( type: esriFieldTypeSmallInteger, alias: Recirculated, editable: true, nullable: true, defaultValue: null, modelName: Q1Recirculated , Coded Values: [0: No] , [1: Yes] )
• Q1Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments, editable: true, nullable: true, defaultValue: null, modelName: Q1Other , Coded Values: [0: No] , [1: Yes] )
• Question2 ( type: esriFieldTypeSmallInteger, alias: Question 2: Are there any cross connections by submerged inlet?, editable: true, nullable: true, defaultValue: null, modelName: Question2 , Coded Values: [0: No] , [1: Yes] )
• Q2Boiler ( type: esriFieldTypeSmallInteger, alias: Boilers, editable: true, nullable: true, defaultValue: null, modelName: Q2Boiler , Coded Values: [0: No] , [1: Yes] )
• Q2Lab ( type: esriFieldTypeSmallInteger, alias: Laboratories, editable: true, nullable: true, defaultValue: null, modelName: Q2Lab , Coded Values: [0: No] , [1: Yes] )
• Q2Sprinkler ( type: esriFieldTypeSmallInteger, alias: Lawn sprinkling system, editable: true, nullable: true, defaultValue: null, modelName: Q2Sprinkler , Coded Values: [0: No] , [1: Yes] )
• Q2Autopsy ( type: esriFieldTypeSmallInteger, alias: Autopsy / mortuary table, editable: true, nullable: true, defaultValue: null, modelName: Q2Autopsy , Coded Values: [0: No] , [1: Yes] )
• Q2Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments, editable: true, nullable: true, defaultValue: null, modelName: Q2Other , Coded Values: [0: No] , [1: Yes] )
• Question3 ( type: esriFieldTypeSmallInteger, alias: Question 3: Are there any cross connections with piping which may contain sanitary water or a waste or a chemical contaminate?, editable: true, nullable: true, defaultValue: null, modelName: Question3 , Coded Values: [0: No] , [1: Yes] )
• Q3FireProtection ( type: esriFieldTypeSmallInteger, alias: Piping for fire protection, editable: true, nullable: true, defaultValue: null, modelName: Q3FireProtection , Coded Values: [0: No] , [1: Yes] )
• Q3Softner ( type: esriFieldTypeSmallInteger, alias: Equipment drained to sewer-water softner, editable: true, nullable: true, defaultValue: null, modelName: Q3Softner , Coded Values: [0: No] , [1: Yes] )
• Q3Refrigeration ( type: esriFieldTypeSmallInteger, alias: Refrigeration system, editable: true, nullable: true, defaultValue: null, modelName: Q3Refrigeration , Coded Values: [0: No] , [1: Yes] )
• Q3Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments, editable: true, nullable: true, defaultValue: null, modelName: Q3Other , Coded Values: [0: No] , [1: Yes] )
• Question4 ( type: esriFieldTypeSmallInteger, alias: Question 4: Are there any cross connections with piping immersed in a tank or vessel?, editable: true, nullable: true, defaultValue: null, modelName: Question4 , Coded Values: [0: No] , [1: Yes] )
• Q4ComLaundry ( type: esriFieldTypeSmallInteger, alias: Commerical laundry, editable: true, nullable: true, defaultValue: null, modelName: Q4ComLaundry , Coded Values: [0: No] , [1: Yes] )
• Q4SteamLines ( type: esriFieldTypeSmallInteger, alias: Steam lines to keep storage tank from freezing, editable: true, nullable: true, defaultValue: null, modelName: Q4SteamLines , Coded Values: [0: No] , [1: Yes] )
• Q4Coils ( type: esriFieldTypeSmallInteger, alias: Coils within plating or rinse tanks, editable: true, nullable: true, defaultValue: null, modelName: Q4Coils , Coded Values: [0: No] , [1: Yes] )
• Q4Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments, editable: true, nullable: true, defaultValue: null, modelName: Q4Other , Coded Values: [0: No] , [1: Yes] )
• Question5 ( type: esriFieldTypeSmallInteger, alias: Question 5: Are any hoses connected to possible contaminates?, editable: true, nullable: true, defaultValue: null, modelName: Question5 , Coded Values: [1: No] , [2: Yes - Protected by an approved vacuum breaker] , [3: Yes - NOT protected] )
• Question6 ( type: esriFieldTypeSmallInteger, alias: Question 6: Is the potable water supply within the propert satisfactory?, editable: true, nullable: true, defaultValue: null, modelName: Question6 , Coded Values: [0: No] , [1: Yes] )
• AirGap ( type: esriFieldTypeSmallInteger, alias: Air Gaps, editable: true, nullable: true, defaultValue: null, modelName: AirGap , Coded Values: [0: No] , [1: Yes] )
• VacuumBr ( type: esriFieldTypeSmallInteger, alias: Vacuum Breakers, editable: true, nullable: true, defaultValue: null, modelName: VacuumBr , Coded Values: [0: No] , [1: Yes] )
• PressureVaccuumBr ( type: esriFieldTypeSmallInteger, alias: Pressure Vaccuum Breaker, editable: true, nullable: true, defaultValue: null, modelName: PressureVaccuumBr , Coded Values: [0: No] , [1: Yes] )
• DoubleCkValveAssy ( type: esriFieldTypeSmallInteger, alias: Double Check Valve Assy, editable: true, nullable: true, defaultValue: null, modelName: DoubleCkValveAssy , Coded Values: [0: No] , [1: Yes] )
• VentedDouble_Ck ( type: esriFieldTypeSmallInteger, alias: Vented Double Check, editable: true, nullable: true, defaultValue: null, modelName: VentedDouble_Ck , Coded Values: [0: No] , [1: Yes] )
• RPZ ( type: esriFieldTypeSmallInteger, alias: RPZ, editable: true, nullable: true, defaultValue: null, modelName: RPZ , Coded Values: [0: No] , [1: Yes] )
• RPDA ( type: esriFieldTypeSmallInteger, alias: RPDA, editable: true, nullable: true, defaultValue: null, modelName: RPDA , Coded Values: [0: No] , [1: Yes] )
• Question8 ( type: esriFieldTypeSmallInteger, alias: Question 8: Any required protection?, editable: true, nullable: true, defaultValue: null, modelName: Question8 , Coded Values: [0: No] , [1: Yes] )
• ReqProtection ( type: esriFieldTypeString, alias: Required Protection:, editable: true, nullable: true, length: 400, defaultValue: null, modelName: ReqProtection )
• InspFreq ( type: esriFieldTypeSmallInteger, alias: Inspection Frequency?, editable: true, nullable: true, defaultValue: null, modelName: InspFreq , Coded Values: [1: 1] , [3: 3] , [10: 10] )
• MainLinContain ( type: esriFieldTypeSmallInteger, alias: Main Line Containment?, editable: true, nullable: true, defaultValue: null, modelName: MainLinContain , Coded Values: [0: No] , [1: Yes] )
• InspOutcome ( type: esriFieldTypeSmallInteger, alias: Inspection Outcome, editable: true, nullable: true, defaultValue: null, modelName: InspOutcome , Coded Values: [1: Approved] , [2: Failed] )
• HBVBTotal ( type: esriFieldTypeSmallInteger, alias: # HBVB Given, editable: true, nullable: true, defaultValue: null, modelName: HBVBTotal , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...8 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 400, defaultValue: null, modelName: Comments )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Related_GlobalID ( type: esriFieldTypeGUID, alias: Related_GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Related_GlobalID )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: CCCPInspection
  Description:
  Prototype:
  Related_GlobalID: null
  OwnerContact: null
  PhoneNo: null
  AddressLocation: null
  InspDate: null
  InspectorName: null
  InspType: null
  CCCPClass: null
  HazardType: null
  HeatSource: null
  Question1: null
  Q1SurfaceWater: null
  Q1WellSupply: null
  Q1StorageTank: null
  Q1Recirculated: null
  Q1Other: null
  Question2: null
  Q2Boiler: null
  Q2Lab: null
  Q2Sprinkler: null
  Q2Autopsy: null
  Q2Other: null
  Question3: null
  Q3FireProtection: null
  Q3Softner: null
  Q3Refrigeration: null
  Q3Other: null
  Question4: null
  Q4ComLaundry: null
  Q4SteamLines: null
  Q4Coils: null
  Q4Other: null
  Question5: null
  Question6: null
  AirGap: null
  VacuumBr: null
  PressureVaccuumBr: null
  DoubleCkValveAssy: null
  VentedDouble_Ck: null
  RPZ: null
  RPDA: null
  Question8: null
  ReqProtection: null
  InspFreq: null
  MainLinContain: null
  InspOutcome: null
  HBVBTotal: null
  Comments: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.CCCPAccounts (1) -- Related To: CCCP Accounts (8)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

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