{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 12, "name": "Water Work Done", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "globalid", "displayField": "FACILITY_ID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid" }, { "name": "FACILITY_ID", "type": "esriFieldTypeString", "alias": "Facility ID:", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITY_ID" }, { "name": "type", "type": "esriFieldTypeString", "alias": "Data Type:", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "type" }, { "name": "issue", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "issue" }, { "name": "latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "latitude" }, { "name": "longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "longitude" }, { "name": "Date_Created", "type": "esriFieldTypeDate", "alias": "Date Created", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date_Created" }, { "name": "common_issue", "type": "esriFieldTypeString", "alias": "Common issue", "domain": { "type": "codedValue", "name": "cvd_common_issue", "description": "", "codedValues": [ { "name": "Flag", "code": "Flag" }, { "name": "Test", "code": "Test" }, { "name": "Sewer Back Up", "code": "Sewer_Back_Up" }, { "name": "Sewer Repair", "code": "Sewer_Repair" }, { "name": "Sewer Tap", "code": "Sewer_Tap" }, { "name": "Sewer Stop", "code": "Sewer_Stop" }, { "name": "Water Main Break", "code": "Water_Main_Break" }, { "name": "Water Line Repair", "code": "Water_Line_Repair" }, { "name": "Raise Valve Box", "code": "Raise_Valve_Box" }, { "name": "Lower Valve Box", "code": "Lower_Valve_Box" }, { "name": "Repair Valve Box", "code": "Repair_Valve_Box" }, { "name": "Raise Curb Box", "code": "Raise_Curb_Box" }, { "name": "Lower Curb Box", "code": "Lower_Curb_Box" }, { "name": "Repair Curb Box", "code": "Repair_Curb_Box" }, { "name": "Raise Manhole", "code": "Raise_Manhole" }, { "name": "Lower Manhole", "code": "Lower_Manhole" }, { "name": "Repair Manhole", "code": "Repair_Manhole" }, { "name": "Replace Seal", "code": "Replace_Seal" }, { "name": "Repair Paving Ring", "code": "Repair_Paving_Ring" }, { "name": "Replace Lid", "code": "Replace_Lid" }, { "name": "Hydrant Dig", "code": "Hydrant_dig" }, { "name": "Hydrant Leaks", "code": "Hydrant_leaks" }, { "name": "Raise Locator Box", "code": "Raise_Locator_Box" }, { "name": "Lower Locator Box", "code": "Lower_Locator_Box" }, { "name": "Repair Locator Box", "code": "Repair_Locator_Box" }, { "name": "Needs Grout", "code": "Needs_Grout" }, { "name": "Debris in Manhole", "code": "Debris_in_Manhole" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "common_issue" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "cvd_Status", "description": "", "codedValues": [ { "name": "Incomplete", "code": "Incomplete" }, { "name": "Complete", "code": "Complete" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Status" }, { "name": "Completion_Notes", "type": "esriFieldTypeString", "alias": "Completion Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Completion_Notes" }, { "name": "heavy_construction_equipment", "type": "esriFieldTypeString", "alias": "Construction Equipment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "heavy_construction_equipment" }, { "name": "Completion_Date", "type": "esriFieldTypeDate", "alias": "Completion Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Completion_Date" }, { "name": "Construction_TEST", "type": "esriFieldTypeString", "alias": "Heavy Construction Test", "domain": { "type": "codedValue", "name": "cvd_Construction_TEST", "description": "", "codedValues": [ { "name": "Excavator", "code": "Excavator" }, { "name": "Vactor", "code": "Vactor" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Construction_TEST" } ], "indexes": [ { "name": "R186_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_186", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_186", "fields": "globalid,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Water Work Done", "description": "", "prototype": { "attributes": { "Completion_Date": null, "heavy_construction_equipment": null, "Construction_TEST": null, "FACILITY_ID": null, "type": null, "issue": null, "latitude": null, "longitude": null, "Date_Created": null, "common_issue": null, "Status": null, "Completion_Notes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 30000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Update,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 30000, "maxRecordCountFactor": 1 }