{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "Inspection Form", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayFieldExpressionInfo": { "expression": "TEXT($feature.InspDate, 'M/D/Y') + \": \" + DomainName($feature, \"InspType\")", "title": "" }, "displayField": "InspectorName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "OwnerContact", "type": "esriFieldTypeString", "alias": "Owner / Contact", "length": 255, "domain": null }, { "name": "PhoneNo", "type": "esriFieldTypeString", "alias": "Phone No", "length": 255, "domain": null }, { "name": "AddressLocation", "type": "esriFieldTypeString", "alias": "Address", "length": 255, "domain": null }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "InspectorName", "type": "esriFieldTypeString", "alias": "Inspector's Name", "length": 255, "domain": null }, { "name": "InspType", "type": "esriFieldTypeSmallInteger", "alias": "Inspection Type", "domain": { "type": "codedValue", "name": "InspectionType", "description": "Inspection Type", "codedValues": [ { "name": "Initial Inspection", "code": 1 }, { "name": "Renewal Inspection", "code": 2 }, { "name": "Re-Inspection", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CCCPClass", "type": "esriFieldTypeSmallInteger", "alias": "Class", "domain": { "type": "codedValue", "name": "AcctClass", "description": "Cross Conn. Account Classification", "codedValues": [ { "name": "Residential", "code": 1 }, { "name": "Commercial", "code": 2 }, { "name": "Non-CCCP Lot", "code": 3 }, { "name": "Other", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HazardType", "type": "esriFieldTypeSmallInteger", "alias": "Hazard Type", "domain": { "type": "codedValue", "name": "Hazard", "description": "Cross Conn. Hazard Status", "codedValues": [ { "name": "Low", "code": 1 }, { "name": "High", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HeatSource", "type": "esriFieldTypeSmallInteger", "alias": "Heat Source", "domain": { "type": "codedValue", "name": "HeatSource", "description": "Heat Source on Inspection Form", "codedValues": [ { "name": "Forced Air", "code": 1 }, { "name": "Boiler (protected)", "code": 2 }, { "name": "Boiler (unprotected)", "code": 3 }, { "name": "Other - See Comments", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Question1", "type": "esriFieldTypeSmallInteger", "alias": "Question 1: Is there any type of secondary water supply within the property?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q1SurfaceWater", "type": "esriFieldTypeSmallInteger", "alias": "Surface Water", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q1WellSupply", "type": "esriFieldTypeSmallInteger", "alias": "Well supply", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q1StorageTank", "type": "esriFieldTypeSmallInteger", "alias": "Storage tank", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q1Recirculated", "type": "esriFieldTypeSmallInteger", "alias": "Recirculated", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q1Other", "type": "esriFieldTypeSmallInteger", "alias": "Other, see comments", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Question2", "type": "esriFieldTypeSmallInteger", "alias": "Question 2: Are there any cross connections by submerged inlet?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q2Boiler", "type": "esriFieldTypeSmallInteger", "alias": "Boilers", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q2Lab", "type": "esriFieldTypeSmallInteger", "alias": "Laboratories", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q2Sprinkler", "type": "esriFieldTypeSmallInteger", "alias": "Lawn sprinkling system", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q2Autopsy", "type": "esriFieldTypeSmallInteger", "alias": "Autopsy / mortuary table", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q2Other", "type": "esriFieldTypeSmallInteger", "alias": "Other, see comments", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "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?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q3FireProtection", "type": "esriFieldTypeSmallInteger", "alias": "Piping for fire protection", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q3Softner", "type": "esriFieldTypeSmallInteger", "alias": "Equipment drained to sewer-water softner", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q3Refrigeration", "type": "esriFieldTypeSmallInteger", "alias": "Refrigeration system", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q3Other", "type": "esriFieldTypeSmallInteger", "alias": "Other, see comments", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Question4", "type": "esriFieldTypeSmallInteger", "alias": "Question 4: Are there any cross connections with piping immersed in a tank or vessel?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q4ComLaundry", "type": "esriFieldTypeSmallInteger", "alias": "Commerical laundry", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q4SteamLines", "type": "esriFieldTypeSmallInteger", "alias": "Steam lines to keep storage tank from freezing", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q4Coils", "type": "esriFieldTypeSmallInteger", "alias": "Coils within plating or rinse tanks", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Q4Other", "type": "esriFieldTypeSmallInteger", "alias": "Other, see comments", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Question5", "type": "esriFieldTypeSmallInteger", "alias": "Question 5: Are any hoses connected to possible contaminates?", "domain": { "type": "codedValue", "name": "YesNoForHose", "description": "No Yes option for hoses with contaminates", "codedValues": [ { "name": "No", "code": 1 }, { "name": "Yes - Protected by an approved vacuum breaker", "code": 2 }, { "name": "Yes - NOT protected", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Question6", "type": "esriFieldTypeSmallInteger", "alias": "Question 6: Is the potable water supply within the propert satisfactory?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "AirGap", "type": "esriFieldTypeSmallInteger", "alias": "Air Gaps", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "VacuumBr", "type": "esriFieldTypeSmallInteger", "alias": "Vacuum Breakers", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PressureVaccuumBr", "type": "esriFieldTypeSmallInteger", "alias": "Pressure Vaccuum Breaker", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DoubleCkValveAssy", "type": "esriFieldTypeSmallInteger", "alias": "Double Check Valve Assy", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "VentedDouble_Ck", "type": "esriFieldTypeSmallInteger", "alias": "Vented Double Check", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "RPZ", "type": "esriFieldTypeSmallInteger", "alias": "RPZ", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "RPDA", "type": "esriFieldTypeSmallInteger", "alias": "RPDA", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Question8", "type": "esriFieldTypeSmallInteger", "alias": "Question 8: Any required protection?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ReqProtection", "type": "esriFieldTypeString", "alias": "Required Protection:", "length": 400, "domain": null }, { "name": "InspFreq", "type": "esriFieldTypeSmallInteger", "alias": "Inspection Frequency?", "domain": { "type": "codedValue", "name": "Freq", "description": "Cross Conn. Inspection Frequency", "codedValues": [ { "name": "1", "code": 1 }, { "name": "3", "code": 3 }, { "name": "10", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MainLinContain", "type": "esriFieldTypeSmallInteger", "alias": "Main Line Containment?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "InspOutcome", "type": "esriFieldTypeSmallInteger", "alias": "Inspection Outcome", "domain": { "type": "codedValue", "name": "InspOutcome", "description": "Inspection Outcome", "codedValues": [ { "name": "Approved", "code": 1 }, { "name": "Failed", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HBVBTotal", "type": "esriFieldTypeSmallInteger", "alias": "# HBVB Given", "domain": { "type": "codedValue", "name": "HBVB", "description": "Total Number of HBVB", "codedValues": [ { "name": "0", "code": 0 }, { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 }, { "name": "5", "code": 5 }, { "name": "6", "code": 6 }, { "name": "7", "code": 7 }, { "name": "8", "code": 8 }, { "name": "9", "code": 9 }, { "name": "10", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 400, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Related_GlobalID", "type": "esriFieldTypeGUID", "alias": "Related_GlobalID", "length": 38, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R36_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_36", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_48_Related_G", "fields": "Related_GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_36", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "DBO.CCCPAccounts", "relatedTableId": 8, "role": "esriRelRoleDestination", "keyField": "Related_GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{897C1E3B-E738-4FEF-86C1-958163818E70}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }