{ "currentVersion": 10.81, "id": 9, "name": "Backflow Devices", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "BACKFLOW_LOCATION", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "SERVICE_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ID" }, { "name": "Water_Account", "type": "esriFieldTypeString", "alias": "Water Account", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Water_Account" }, { "name": "SERVICE_DISTRICT", "type": "esriFieldTypeString", "alias": "Pressure District", "domain": { "type": "codedValue", "name": "wDomPressureDistrict", "description": "", "codedValues": [ { "name": "Tall Tree", "code": "TT" }, { "name": "Low Service", "code": "LS" }, { "name": "1st High Service", "code": "1HS" }, { "name": "2nd High Service", "code": "2HS" }, { "name": "Worrell Road", "code": "WR" }, { "name": "Pelton Road", "code": "PR" }, { "name": "Orton 1st High", "code": "OT1H" }, { "name": "Arcola Low Service", "code": "ALS" }, { "name": "Pinecrest", "code": "PC" }, { "name": "3rd High Madison Vlg. Service 2022", "code": "3HMV2" }, { "name": "Bacon Road Low Service 2022", "code": "BRLS2" }, { "name": "Painesville Twp Park 2022", "code": "PTP2" }, { "name": "River Road 2nd High 2022", "code": "RR2H2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERVICE_DISTRICT" }, { "name": "SERVICE_NAME", "type": "esriFieldTypeString", "alias": "Service Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERVICE_NAME" }, { "name": "SERVICE_ADDRESS", "type": "esriFieldTypeString", "alias": "Service Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERVICE_ADDRESS" }, { "name": "SERVICE_CITY", "type": "esriFieldTypeString", "alias": "Service City", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERVICE_CITY" }, { "name": "MAILING_OWNER", "type": "esriFieldTypeString", "alias": "Mailing Owner", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MAILING_OWNER" }, { "name": "MAILING_ADDRESS", "type": "esriFieldTypeString", "alias": "Mailing Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MAILING_ADDRESS" }, { "name": "MAILING_ADD_2", "type": "esriFieldTypeString", "alias": "Mailing Address 2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MAILING_ADD_2" }, { "name": "ATTN_", "type": "esriFieldTypeString", "alias": "Attn:", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ATTN_" }, { "name": "MAILING_CITY", "type": "esriFieldTypeString", "alias": "Mail City", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MAILING_CITY" }, { "name": "STATIC_PRESSURE", "type": "esriFieldTypeString", "alias": "Static Pressure", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATIC_PRESSURE" }, { "name": "MONTH_RECEIVED", "type": "esriFieldTypeString", "alias": "Month Received", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MONTH_RECEIVED" }, { "name": "BF_ACCT", "type": "esriFieldTypeString", "alias": "BF Acct #", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "BF_ACCT" }, { "name": "TESTING_MONTH", "type": "esriFieldTypeString", "alias": "Testing Month", "domain": { "type": "codedValue", "name": "UtMonth", "description": "Months", "codedValues": [ { "name": "January", "code": "JAN" }, { "name": "February", "code": "FEB" }, { "name": "March", "code": "MAR" }, { "name": "April", "code": "APR" }, { "name": "May", "code": "MAY" }, { "name": "June", "code": "JUN" }, { "name": "July", "code": "JUL" }, { "name": "August", "code": "AUG" }, { "name": "September", "code": "SEPT" }, { "name": "October", "code": "OCT" }, { "name": "November", "code": "NOV" }, { "name": "December", "code": "DEC" }, { "name": "IDLE", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "TESTING_MONTH" }, { "name": "FIRELINE", "type": "esriFieldTypeString", "alias": "Fireline", "domain": { "type": "codedValue", "name": "UtFireline", "description": "Fireline Indicator", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "FIRELINE" }, { "name": "FIRE_ACCT", "type": "esriFieldTypeString", "alias": "Fireline Account", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "FIRE_ACCT" }, { "name": "SRV_SZ", "type": "esriFieldTypeString", "alias": "Service Size", "domain": null, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "SRV_SZ" }, { "name": "BF_TYPE", "type": "esriFieldTypeString", "alias": "Backflow Type", "domain": { "type": "codedValue", "name": "UtBFType", "description": "Backflow Type", "codedValues": [ { "name": "RP", "code": "RP" }, { "name": "RPZ", "code": "RPZ" }, { "name": "DC", "code": "DC" }, { "name": "DDC", "code": "DDC" }, { "name": "PVB", "code": "PVB" }, { "name": "WATTS QT", "code": "WQT" }, { "name": "DCDC", "code": "DCDC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "BF_TYPE" }, { "name": "BF_SIZE", "type": "esriFieldTypeString", "alias": "BF Size", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "BF_SIZE" }, { "name": "MNFCTR", "type": "esriFieldTypeString", "alias": "Manufacture", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MNFCTR" }, { "name": "FL_SIZE", "type": "esriFieldTypeString", "alias": "FL Size", "domain": null, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "FL_SIZE" }, { "name": "SERIAL", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SERIAL" }, { "name": "YEAR_IN", "type": "esriFieldTypeString", "alias": "Year Installed", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "YEAR_IN" }, { "name": "HAZZARD", "type": "esriFieldTypeString", "alias": "Degree of Hazzard", "domain": { "type": "codedValue", "name": "UtDgrHazzard", "description": "Degree of Hazzard", "codedValues": [ { "name": "High", "code": "H" }, { "name": "Low", "code": "L" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "HAZZARD" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "Test Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "INSPECT", "type": "esriFieldTypeString", "alias": "Inspector", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INSPECT" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "DOMESTIC_1", "type": "esriFieldTypeString", "alias": "Domestic", "domain": { "type": "codedValue", "name": "UtDomestic", "description": "Domestic Service", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DOMESTIC_1" }, { "name": "LOCATION_1", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION_1" }, { "name": "RECEIVED_TEST", "type": "esriFieldTypeString", "alias": "Rec'd Test Rpt", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "RECEIVED_TEST" }, { "name": "CONTAINMENT", "type": "esriFieldTypeString", "alias": "CONTAINMENT", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CONTAINMENT" }, { "name": "NOTES_1", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "NOTES_1" }, { "name": "VIOLATIONS_1", "type": "esriFieldTypeString", "alias": "Violations", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "VIOLATIONS_1" }, { "name": "LCDU_TEST", "type": "esriFieldTypeDate", "alias": "LCDU Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LCDU_TEST" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "CONTAINMENTDEV", "type": "esriFieldTypeString", "alias": "Containment Device", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CONTAINMENTDEV" }, { "name": "CONDITIONSCORE", "type": "esriFieldTypeDouble", "alias": "Condition Score", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CONDITIONSCORE" }, { "name": "IRRRIGATION", "type": "esriFieldTypeString", "alias": "IRRIGATION", "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes No Domain As Text", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "IRRRIGATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R1307_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G16982ID", "fields": "ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1307", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1307", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Backflow Devices", "description": "", "prototype": { "attributes": { "CONDITIONSCORE": null, "IRRRIGATION": null, "ID": null, "Water_Account": null, "SERVICE_DISTRICT": null, "SERVICE_NAME": null, "SERVICE_ADDRESS": null, "SERVICE_CITY": null, "MAILING_OWNER": null, "MAILING_ADDRESS": null, "MAILING_ADD_2": null, "ATTN_": null, "MAILING_CITY": null, "STATIC_PRESSURE": null, "MONTH_RECEIVED": null, "BF_ACCT": null, "TESTING_MONTH": null, "FIRELINE": null, "FIRE_ACCT": null, "SRV_SZ": null, "BF_TYPE": null, "BF_SIZE": null, "MNFCTR": null, "FL_SIZE": null, "SERIAL": null, "YEAR_IN": null, "HAZZARD": null, "INSP_DATE": null, "INSPECT": null, "CONTAINMENTDEV": null, "DOMESTIC_1": null, "LOCATION_1": null, "RECEIVED_TEST": null, "CONTAINMENT": null, "NOTES_1": null, "VIOLATIONS_1": null, "LCDU_TEST": null, "FACILITYID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }