{ "currentVersion": 10.91, "id": 119, "name": "Backflow History", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "last_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "assetkey", "type": "esriFieldTypeString", "alias": "Asset Key", "length": 20, "domain": null }, { "name": "workorderid", "type": "esriFieldTypeString", "alias": "Workorder Key", "length": 50, "domain": null }, { "name": "workdate", "type": "esriFieldTypeDate", "alias": "Work Date", "length": 8, "domain": null }, { "name": "workby", "type": "esriFieldTypeString", "alias": "Work By", "length": 50, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1000, "domain": null }, { "name": "worktype", "type": "esriFieldTypeString", "alias": "Work Type", "length": 50, "domain": null }, { "name": "attachment01", "type": "esriFieldTypeInteger", "alias": "AttachmentID1", "domain": null }, { "name": "attachment02", "type": "esriFieldTypeInteger", "alias": "AttachmentID2", "domain": null }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "inspector", "length": 254, "domain": { "type": "codedValue", "name": "sedaInspector", "description": "", "codedValues": [ { "name": "Alex Gan", "code": "Alex Gan" }, { "name": "Ty Kuban", "code": "Ty Kuban" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "addr_care_", "type": "esriFieldTypeString", "alias": "addr_care_", "length": 200, "domain": null }, { "name": "last_name", "type": "esriFieldTypeString", "alias": "last_name", "length": 254, "domain": null }, { "name": "first_name", "type": "esriFieldTypeString", "alias": "first_name", "length": 254, "domain": null }, { "name": "bus_phone", "type": "esriFieldTypeString", "alias": "bus_phone", "length": 254, "domain": null }, { "name": "home_phone", "type": "esriFieldTypeString", "alias": "home_phone", "length": 254, "domain": null }, { "name": "email", "type": "esriFieldTypeString", "alias": "email", "length": 254, "domain": null }, { "name": "prop_type", "type": "esriFieldTypeString", "alias": "prop_type", "length": 20, "domain": null }, { "name": "meter_size", "type": "esriFieldTypeString", "alias": "meter_size", "length": 20, "domain": null }, { "name": "meter_sn", "type": "esriFieldTypeString", "alias": "meter_sn", "length": 254, "domain": null }, { "name": "lodesc", "type": "esriFieldTypeString", "alias": "lodesc", "length": 200, "domain": null }, { "name": "fulladdres", "type": "esriFieldTypeString", "alias": "fulladdres", "length": 200, "domain": null }, { "name": "containment_exist", "type": "esriFieldTypeString", "alias": "containment_exist", "length": 20, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "branch_count", "type": "esriFieldTypeInteger", "alias": "branch_count", "domain": null }, { "name": "bf_type", "type": "esriFieldTypeString", "alias": "bf_type", "length": 20, "domain": { "type": "codedValue", "name": "sedaBackflowType", "description": "", "codedValues": [ { "name": "RPZ", "code": "RPZ" }, { "name": "DC", "code": "DC" }, { "name": "PVB", "code": "PVB" }, { "name": "SBV", "code": "SVB" }, { "name": "DCDA", "code": "DCDA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "bf_manufacturer", "type": "esriFieldTypeString", "alias": "bf_manufacturer", "length": 50, "domain": null }, { "name": "bf_model", "type": "esriFieldTypeString", "alias": "bf_model", "length": 50, "domain": null }, { "name": "bf_size", "type": "esriFieldTypeString", "alias": "bf_size", "length": 20, "domain": { "type": "codedValue", "name": "sedaBackflowSize", "description": "", "codedValues": [ { "name": "0.75", "code": "0.75" }, { "name": "1.5", "code": "1.5" }, { "name": "0.25", "code": "0.25" }, { "name": "0.378", "code": "0.378" }, { "name": "0.5", "code": "0.5" }, { "name": "1.0", "code": "1.0" }, { "name": "1.25", "code": "1.25" }, { "name": "2.0", "code": "2.0" }, { "name": "3.0", "code": "3.0" }, { "name": "3.25", "code": "3.25" }, { "name": "4.0", "code": "4.0" }, { "name": "5.0", "code": "5.0" }, { "name": "6.0", "code": "6.0" }, { "name": "8.0", "code": "8.0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "bf_sn", "type": "esriFieldTypeString", "alias": "bf_sn", "length": 50, "domain": null }, { "name": "test_date", "type": "esriFieldTypeDate", "alias": "test_date", "length": 8, "domain": null }, { "name": "outlet_ori", "type": "esriFieldTypeString", "alias": "outlet_ori", "length": 20, "domain": { "type": "codedValue", "name": "sedaOrientation", "description": "", "codedValues": [ { "name": "Horizontal", "code": "Horizontal" }, { "name": "Up", "code": "Up" }, { "name": "Down", "code": "Down" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inlet_ori", "type": "esriFieldTypeString", "alias": "inlet ori", "length": 20, "domain": { "type": "codedValue", "name": "sedaOrientation", "description": "", "codedValues": [ { "name": "Horizontal", "code": "Horizontal" }, { "name": "Up", "code": "Up" }, { "name": "Down", "code": "Down" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "branch_type", "type": "esriFieldTypeString", "alias": "branch_type", "length": 50, "domain": { "type": "codedValue", "name": "sedaBranchType", "description": "", "codedValues": [ { "name": "Assembly", "code": "Assembly" }, { "name": "Air Gap", "code": "Air Gap" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "branch_water_use", "type": "esriFieldTypeString", "alias": "branch_water_use", "length": 50, "domain": null } ], "indexes": [ { "name": "R401_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 3000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }