{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 24, "name": "Water Backflow Prevention Device", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 30, "domain": null }, { "name": "BACKFLOWID", "type": "esriFieldTypeString", "alias": "BACKFLOWID", "length": 30, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 20, "domain": { "type": "codedValue", "name": "wBackflowManu", "description": "", "codedValues": [ { "name": "Ames", "code": "Ames" }, { "name": "Buckner", "code": "Buckner" }, { "name": "Cla-Val", "code": "Cla-Val" }, { "name": "Conbraco", "code": "Conbraco" }, { "name": "Febco", "code": "Febco" }, { "name": "Flomatic", "code": "Flomatic" }, { "name": "Hersey", "code": "Hersey" }, { "name": "Kennedy", "code": "Kennedy" }, { "name": "Mueller", "code": "Mueller" }, { "name": "Orion", "code": "Orion" }, { "name": "PVB", "code": "PVB" }, { "name": "Rainbird", "code": "Rainbird" }, { "name": "Toro", "code": "Toro" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Viking", "code": "Viking" }, { "name": "Watts", "code": "Watts" }, { "name": "Wilkins", "code": "Wilkins" }, { "name": "Maxim", "code": "Maxim" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "length": 8, "domain": null }, { "name": "MODEL_NO", "type": "esriFieldTypeString", "alias": "MODEL_NO", "length": 30, "domain": null }, { "name": "SERIAL_NO", "type": "esriFieldTypeString", "alias": "SERIAL_NO", "length": 30, "domain": null }, { "name": "DEVICE_TYPE", "type": "esriFieldTypeString", "alias": "DEVICE_TYPE", "length": 25, "domain": { "type": "codedValue", "name": "wBackflowDeviceType", "description": "", "codedValues": [ { "name": "DCDA", "code": "DCDA" }, { "name": "DCV", "code": "DCV" }, { "name": "PVB", "code": "PVB" }, { "name": "RPA", "code": "RPA" }, { "name": "RPDA", "code": "RPDA" }, { "name": "SVB", "code": "SVB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SIZE_INCHES", "type": "esriFieldTypeString", "alias": "SIZE_INCHES", "length": 10, "domain": null }, { "name": "NEXT_TEST", "type": "esriFieldTypeDate", "alias": "NEXT_TEST", "length": 8, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 25, "domain": { "type": "codedValue", "name": "wBackflowStatus", "description": "", "codedValues": [ { "name": "New Device", "code": "New Device" }, { "name": "Device Tested", "code": "Device Tested" }, { "name": "Device Rebuilt", "code": "Device Rebuilt" }, { "name": "First Notification Sent", "code": "First Notification" }, { "name": "Second Notification Sent", "code": "Second Notification" }, { "name": "Third Notification Sent", "code": "Third Notification" }, { "name": "Disconnect", "code": "Disconnect" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSTALLATION_TYPE", "type": "esriFieldTypeString", "alias": "INSTALLATION_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "wBackflowInstType", "description": "", "codedValues": [ { "name": "Construction Water", "code": "Construction Water" }, { "name": "Domestic", "code": "Domestic" }, { "name": "Fire Service", "code": "Fire Service" }, { "name": "Irrigation", "code": "Irrigation" }, { "name": "Private Loop", "code": "Private Loop" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADDRESSFACID", "type": "esriFieldTypeString", "alias": "ADDRESSFACID", "length": 50, "domain": null }, { "name": "LEVELOFHAZARD", "type": "esriFieldTypeString", "alias": "LEVELOFHAZARD", "length": 50, "domain": { "type": "codedValue", "name": "wHazardLevel", "description": "Level of Hazard/Risk for Backflow", "codedValues": [ { "name": "High Hazard", "code": "High" }, { "name": "Medium Hazard", "code": "Medium" }, { "name": "Low Hazard", "code": "Low" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "OWNER", "length": 50, "domain": null }, { "name": "MAILING_ADDRESS", "type": "esriFieldTypeString", "alias": "MAILING_ADDRESS", "length": 75, "domain": null }, { "name": "TESTING_FREQUENCY", "type": "esriFieldTypeString", "alias": "TESTING_FREQUENCY", "length": 50, "domain": { "type": "codedValue", "name": "wTestingFrequency", "description": "", "codedValues": [ { "name": "Annually", "code": "Annual" }, { "name": "Quarterly", "code": "Quarter" }, { "name": "Monthly", "code": "Month" }, { "name": "Weekly", "code": "Week" }, { "name": "Biannually", "code": "BiAnnual" }, { "name": "Every Two Years", "code": "Two Year" }, { "name": "Every Three Years", "code": "Three Year" }, { "name": "Every Four Years", "code": "Four Year" }, { "name": "Every Five Years", "code": "Five Year" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspCondition", "type": "esriFieldTypeSmallInteger", "alias": "InspCondition", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R41_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_41", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G344ADDRESSFACID", "fields": "ADDRESSFACID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_41", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Addresses", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "ADDRESSFACID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7F278522-43D4-4C80-981C-A5C3C45FBED2}" } ], "capabilities": "Query,Map,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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "0d75fe8f9cbb498586360b05f9e943a7" }