{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Assy Device", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2898, "latestWkid": 2898, "xyTolerance": 0.0032808464567060367, "zTolerance": 2, "mTolerance": 0.001, "falseX": -107138600, "falseY": -97193800, "xyUnits": 3047.993904, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "PassFail", "uniqueValueGroups": [ { "heading": "Pass / Fail", "classes": [ { "label": "Pass", "description": "Pass", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 76, 230, 0, 255 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "1" ] ] }, { "label": "Fail", "description": "Fail", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 230, 0, 0, 255 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "2" ] ] }, { "label": "Testing Due", "description": "Testing Due", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 0, 0, 255 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 255, 255, 0, 255 ], "width": 1.5 } }, "values": [ [ "3" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 76, 230, 0, 255 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "1", "label": "Pass" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 230, 0, 0, 255 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "2", "label": "Fail" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 0, 0, 255 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 255, 255, 0, 255 ], "width": 1.5 } }, "value": "3", "label": "Testing Due" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 204, 252, 197, 255 ], "toColor": [ 204, 252, 197, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 184, 252, 255 ], "toColor": [ 250, 184, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 195, 179, 255 ], "toColor": [ 252, 195, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 225, 252, 255 ], "toColor": [ 184, 225, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 236, 215, 252, 255 ], "toColor": [ 236, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 240, 210, 255 ], "toColor": [ 252, 240, 210, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 207, 252, 240, 255 ], "toColor": [ 207, 252, 240, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 205, 255 ], "toColor": [ 252, 179, 205, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 252, 179, 255 ], "toColor": [ 250, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 199, 182, 252, 255 ], "toColor": [ 199, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 210, 212, 255 ], "toColor": [ 252, 210, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 202, 252, 255 ], "toColor": [ 194, 202, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 192, 234, 255 ], "toColor": [ 252, 192, 234, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1.3201209627125815E7, "ymin": 685909.0947200358, "xmax": 1.3245397031445503E7, "ymax": 753411.9767730385, "spatialReference": { "wkid": 2898, "latestWkid": 2898, "xyTolerance": 0.0032808398950131233, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -107138600, "falseY": -97193800, "xyUnits": 3048, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayFieldExpressionInfo": { "expression": "DomainName($feature, \"AssyType\") + \": \" + $feature.SerialNo", "title": "Custom" }, "displayField": "Size", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 255, "domain": null }, { "name": "AssyType", "type": "esriFieldTypeSmallInteger", "alias": "Type", "domain": { "type": "codedValue", "name": "CCCPAssyType", "description": "Assembly Types", "codedValues": [ { "name": "RPZ", "code": 1 }, { "name": "RPDA", "code": 2 }, { "name": "PVB", "code": 3 }, { "name": "DCVA", "code": 4 }, { "name": "DCDA", "code": 5 }, { "name": "Other - See Comments", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SerialNo", "type": "esriFieldTypeString", "alias": "Serial No", "length": 255, "domain": null }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "length": 255, "domain": { "type": "codedValue", "name": "CCCPSizeRevised", "description": "Revised Cross Conn. Assy Size", "codedValues": [ { "name": "0.5 in", "code": "0.5" }, { "name": "0.75 in", "code": "0.75" }, { "name": "1.00 in", "code": "1.00" }, { "name": "1.25 in", "code": "1.25" }, { "name": "1.50 in", "code": "1.50" }, { "name": "2.00 in", "code": "2.00" }, { "name": "2.50 in", "code": "2.50" }, { "name": "3.00 in", "code": "3.00" }, { "name": "4.00 in", "code": "4.00" }, { "name": "5.00 in", "code": "5.00" }, { "name": "6.00 in", "code": "6.00" }, { "name": "8.00 in", "code": "8.00" }, { "name": "10.00 in", "code": "10.00" }, { "name": "12.00 in", "code": "12.00" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Make", "type": "esriFieldTypeString", "alias": "Make", "length": 255, "domain": { "type": "codedValue", "name": "CCCPMake", "description": "Cross Conn. Assy Make", "codedValues": [ { "name": "Air Gap", "code": "Air Gap" }, { "name": "Ames", "code": "Ames" }, { "name": "Apollo", "code": "Apollo" }, { "name": "Backflow Direct", "code": "Backflow Direct" }, { "name": "Caleffi", "code": "Caleffi" }, { "name": "Cla-Val", "code": "Cla-Val" }, { "name": "Conbraco", "code": "Conbraco" }, { "name": "Derringer", "code": "Derringer" }, { "name": "Febco", "code": "Febco" }, { "name": "Globe", "code": "Globe" }, { "name": "Hersey", "code": "Hersey" }, { "name": "Kennedy", "code": "Kennedy" }, { "name": "Lawler", "code": "Lawler" }, { "name": "Lunkenheim", "code": "Lunkenheim" }, { "name": "Mueller", "code": "Mueller" }, { "name": "Rainbird", "code": "Rainbird" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Viking", "code": "Viking" }, { "name": "Watts", "code": "Watts" }, { "name": "Rockwood", "code": "Rockwood" }, { "name": "Wilkins", "code": "Wilkins" }, { "name": "Other - See Comments", "code": "Other" }, { "name": "Zurn", "code": "Zurn" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "AssyPurpose", "type": "esriFieldTypeSmallInteger", "alias": "Purpose", "domain": { "type": "codedValue", "name": "CCCPPurpose", "description": "Assembly Purpose", "codedValues": [ { "name": "Mainline", "code": 1 }, { "name": "Isolation", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BldgLocation", "type": "esriFieldTypeString", "alias": "BldgLocation", "length": 255, "domain": { "type": "codedValue", "name": "CCCPAssyLocation", "description": "Cross Conn. Assy Location", "codedValues": [ { "name": "Basement", "code": "Basement" }, { "name": "Boiler", "code": "Boiler" }, { "name": "Boiler Room", "code": "Boiler Room" }, { "name": "Fire Bypass", "code": "Fire Bypass" }, { "name": "Fire Line", "code": "Fire Line" }, { "name": "Isolation", "code": "Isolation" }, { "name": "Lawn", "code": "Lawn" }, { "name": "Mainline", "code": "Mainline" }, { "name": "Mechanical Room", "code": "Mechanical Room" }, { "name": "Sump Pump", "code": "Sump Pump" }, { "name": "Other - See Comments", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PassFail", "type": "esriFieldTypeSmallInteger", "alias": "Pass / Fail", "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": 1 }, { "name": "Fail", "code": 2 }, { "name": "Testing Due", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Tester", "type": "esriFieldTypeString", "alias": "Tester", "length": 255, "domain": null }, { "name": "CertificationNo", "type": "esriFieldTypeString", "alias": "CertificationNo", "length": 255, "domain": null }, { "name": "TestDate", "type": "esriFieldTypeDate", "alias": "Test Date", "length": 8, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 400, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "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 } ], "geometryField": {}, "indexes": [ { "name": "UUID_30", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_442_REL_GLOB", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "DBO.CCCPAccounts", "relatedTableId": 8, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{517FB85E-3505-48FF-9138-9369F86930AD}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": 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 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "CCCP Accounts", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 2898, "latestWkid": 2898, "xyTolerance": 0.0032808464567060367, "zTolerance": 2, "mTolerance": 0.001, "falseX": -107138600, "falseY": -97193800, "xyUnits": 3047.993904, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "Status", "uniqueValueGroups": [ { "heading": "Status", "classes": [ { "label": "Due", "description": "Due", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 104, 104, 104, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "values": [ [ "1" ] ] }, { "label": "Pass", "description": "Pass", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 85, 255, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "values": [ [ "2" ] ] }, { "label": "Pass - Missing Requirement", "description": "Pass - Missing Requirement", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 0, 197, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 1 } }, "values": [ [ "3" ] ] }, { "label": "Yellow Tag", "description": "Yellow Tag", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "values": [ [ "4" ] ] }, { "label": "Appointment Scheduled", "description": "Appointment Scheduled", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 170, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 1 } }, "values": [ [ "5" ] ] }, { "label": "Fail", "description": "Fail", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 0, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "values": [ [ "6" ] ] }, { "label": "Fail -FTC", "description": "Fail -FTC", "symbol": { "type": "esriSFS", "style": "esriSFSBackwardDiagonal", "color": [ 255, 0, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "values": [ [ "7" ] ] }, { "label": "Fail - Off at Road", "description": "Fail - Off at Road", "symbol": { "type": "esriSFS", "style": "esriSFSBackwardDiagonal", "color": [ 255, 0, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "values": [ [ "8" ] ] }, { "label": "Pass- Off at Road", "description": "Pass- Off at Road", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 85, 255, 0, 153 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "values": [ [ "9" ] ] }, { "label": "Not Due", "description": "Not Due", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 207, 189, 252, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "values": [ [ "99" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 104, 104, 104, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "value": "1", "label": "Due" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 85, 255, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "value": "2", "label": "Pass" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 0, 197, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 1 } }, "value": "3", "label": "Pass - Missing Requirement" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "value": "4", "label": "Yellow Tag" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 170, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 1 } }, "value": "5", "label": "Appointment Scheduled" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 0, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "value": "6", "label": "Fail" }, { "symbol": { "type": "esriSFS", "style": "esriSFSBackwardDiagonal", "color": [ 255, 0, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "value": "7", "label": "Fail -FTC" }, { "symbol": { "type": "esriSFS", "style": "esriSFSBackwardDiagonal", "color": [ 255, 0, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "value": "8", "label": "Fail - Off at Road" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 85, 255, 0, 153 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "value": "9", "label": "Pass- Off at Road" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 207, 189, 252, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 104, 104, 104, 255 ], "width": 1 } }, "value": "99", "label": "Not Due" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 204, 252, 197, 255 ], "toColor": [ 204, 252, 197, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 184, 252, 255 ], "toColor": [ 250, 184, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 195, 179, 255 ], "toColor": [ 252, 195, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 225, 252, 255 ], "toColor": [ 184, 225, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 236, 215, 252, 255 ], "toColor": [ 236, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 240, 210, 255 ], "toColor": [ 252, 240, 210, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 207, 252, 240, 255 ], "toColor": [ 207, 252, 240, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 205, 255 ], "toColor": [ 252, 179, 205, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 252, 179, 255 ], "toColor": [ 250, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 199, 182, 252, 255 ], "toColor": [ 199, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 210, 212, 255 ], "toColor": [ 252, 210, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 202, 252, 255 ], "toColor": [ 194, 202, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 192, 234, 255 ], "toColor": [ 252, 192, 234, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpressionInfo": { "expression": "$feature.CCCPAddress", "title": "Custom" }, "labelPlacement": "esriServerPolygonPlacementAlwaysHorizontal", "multiPart": "labelLargest", "allowOverrun": true, "deconflictionStrategy": "dynamic", "repeatLabel": false, "useClippedGeometry": true, "stackLabel": true, "stackAlignment": "dynamic", "removeDuplicates": "none", "stackRowLength": 24, "useCodedValues": true, "maxScale": 0, "minScale": 1500, "name": "Class 1", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 255, 255, 255 ], "haloSize": 1.5, "font": { "family": "Tahoma", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "defaultVisibility": true, "extent": { "xmin": 1.3193937910482645E7, "ymin": 658642.6090846956, "xmax": 1.3271493765725598E7, "ymax": 754673.9163047969, "spatialReference": { "wkid": 2898, "latestWkid": 2898, "xyTolerance": 0.0032808398950131233, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -107138600, "falseY": -97193800, "xyUnits": 3048, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CCCPAddress", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Status", "type": "esriFieldTypeSmallInteger", "alias": "Status", "domain": { "type": "codedValue", "name": "CCCPStatus", "description": "Cross Conn. Account Status", "codedValues": [ { "name": "Due", "code": 1 }, { "name": "Pass", "code": 2 }, { "name": "Pass - Missing Requirement", "code": 3 }, { "name": "Yellow Tag", "code": 4 }, { "name": "Appointment Scheduled", "code": 5 }, { "name": "Fail", "code": 6 }, { "name": "Fail -FTC", "code": 7 }, { "name": "Fail - Off at Road", "code": 8 }, { "name": "Pass- Off at Road", "code": 9 }, { "name": "Not Due", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "StatusDate", "type": "esriFieldTypeDate", "alias": "Status Updated On", "length": 8, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments/Notes", "length": 300, "domain": null }, { "name": "OwnerBiz", "type": "esriFieldTypeString", "alias": "Owner/Biz", "length": 255, "domain": null }, { "name": "CCCPAddress", "type": "esriFieldTypeString", "alias": "CCCP Address", "length": 255, "domain": null }, { "name": "IR", "type": "esriFieldTypeSmallInteger", "alias": "Irrigation Line", "domain": { "type": "codedValue", "name": "YesNo", "description": "Cross Conn. Yes No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Freq", "type": "esriFieldTypeSmallInteger", "alias": "Freq (yrs)", "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": "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": "Class", "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": "RouteBook", "type": "esriFieldTypeString", "alias": "Route Book", "length": 255, "domain": { "type": "codedValue", "name": "CycleRoute", "description": "Cross Conn. Cycle+Route", "codedValues": [ { "name": "0101", "code": "0101" }, { "name": "0102", "code": "0102" }, { "name": "0103", "code": "0103" }, { "name": "0104", "code": "0104" }, { "name": "0105", "code": "0105" }, { "name": "0106", "code": "0106" }, { "name": "0107", "code": "0107" }, { "name": "0108", "code": "0108" }, { "name": "0109", "code": "0109" }, { "name": "0110", "code": "0110" }, { "name": "0201", "code": "0201" }, { "name": "0202", "code": "0202" }, { "name": "0203", "code": "0203" }, { "name": "0204", "code": "0204" }, { "name": "0205", "code": "0205" }, { "name": "0206", "code": "0206" }, { "name": "0207", "code": "0207" }, { "name": "0208", "code": "0208" }, { "name": "0209", "code": "0209" }, { "name": "0210", "code": "0210" }, { "name": "0301", "code": "0301" }, { "name": "0302", "code": "0302" }, { "name": "0303", "code": "0303" }, { "name": "0304", "code": "0304" }, { "name": "0305", "code": "0305" }, { "name": "0306", "code": "0306" }, { "name": "0307", "code": "0307" }, { "name": "0308", "code": "0308" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LetterDate", "type": "esriFieldTypeDate", "alias": "LetterDate", "length": 8, "domain": null }, { "name": "MailingComments", "type": "esriFieldTypeString", "alias": "Mailing Comments", "length": 300, "domain": null }, { "name": "MailingRecipient", "type": "esriFieldTypeString", "alias": "Letter Recipient", "length": 300, "domain": null }, { "name": "MailingAddress", "type": "esriFieldTypeString", "alias": "Letter Address", "length": 255, "domain": null }, { "name": "MailingCityStateZip", "type": "esriFieldTypeString", "alias": "Letter State Zip", "length": 255, "domain": null }, { "name": "AccessAddress", "type": "esriFieldTypeString", "alias": "Access Address", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "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 }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "PCOMBINED", "type": "esriFieldTypeString", "alias": "PCOMBINED", "length": 255, "domain": null }, { "name": "PSNUMBER", "type": "esriFieldTypeDouble", "alias": "PSNUMBER", "domain": null }, { "name": "PDRESSDIR", "type": "esriFieldTypeString", "alias": "PDRESSDIR", "length": 255, "domain": null }, { "name": "PSSSTREET", "type": "esriFieldTypeString", "alias": "PSSSTREET", "length": 255, "domain": null }, { "name": "PDRESSZIP", "type": "esriFieldTypeString", "alias": "PDRESSZIP", "length": 255, "domain": null }, { "name": "Tax_ID", "type": "esriFieldTypeString", "alias": "Tax_ID", "length": 255, "domain": null }, { "name": "PRTYCLASS", "type": "esriFieldTypeString", "alias": "PRTYCLASS", "length": 255, "domain": null }, { "name": "SIMPROVED", "type": "esriFieldTypeDouble", "alias": "SIMPROVED", "domain": null }, { "name": "TCLEUNITS", "type": "esriFieldTypeDouble", "alias": "TCLEUNITS", "domain": null }, { "name": "PTYSTATUS", "type": "esriFieldTypeString", "alias": "PTYSTATUS", "length": 255, "domain": null }, { "name": "ParcelUpdated", "type": "esriFieldTypeDate", "alias": "ParcelUpdated", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R33_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_33", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_33", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S14_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "DBO.CCCPInspection", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{897C1E3B-E738-4FEF-86C1-958163818E70}" }, { "id": 2, "name": "DBO.XCFound", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8BD1C6B6-6653-43BA-A470-0E4F6FEB2640}" }, { "id": 0, "name": "DBO.AssyDevice", "relatedTableId": 0, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{517FB85E-3505-48FF-9138-9369F86930AD}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9002} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "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 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "XC Found Form", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayFieldExpressionInfo": { "expression": "IIf($feature.XCStatus == 1, \"Existing\", \"Resolved\") + \": \" + Text($feature.XCFoundDate, 'M/D/YYYY')", "title": "" }, "displayField": "AddressLocation", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AddressLocation", "type": "esriFieldTypeString", "alias": "Address", "length": 255, "domain": null }, { "name": "XCFoundDate", "type": "esriFieldTypeDate", "alias": "XC Found Date", "length": 8, "domain": null }, { "name": "XCDescription", "type": "esriFieldTypeString", "alias": "XC Description", "length": 400, "domain": null }, { "name": "XCStatus", "type": "esriFieldTypeSmallInteger", "alias": "XC Status", "domain": { "type": "codedValue", "name": "XCStatus", "description": "Cross Conn. XCStatus", "codedValues": [ { "name": "Existing", "code": 1 }, { "name": "Resolved", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "XCResolvedDate", "type": "esriFieldTypeDate", "alias": "XC Resolved Date", "length": 8, "domain": null }, { "name": "XCComments", "type": "esriFieldTypeString", "alias": "XC Comments", "length": 400, "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_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": "R34_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_45_REL_GLOBA", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "DBO.CCCPAccounts", "relatedTableId": 8, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8BD1C6B6-6653-43BA-A470-0E4F6FEB2640}" } ], "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 } } ] }