{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "DSCJumpRel", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "DSConnectJumps", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "JUMP_GISID", "composite": false } ], "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "SERVICETYPE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SERVICETYPE", "type": "esriFieldTypeString", "alias": "SERVICETYPE", "domain": { "type": "codedValue", "name": "DSCJumkpsServiceType", "description": "", "codedValues": [ { "name": "Roto Root", "code": "Roto Root" }, { "name": "Flat Rod", "code": "Flat Rod" }, { "name": "Check Connection", "code": "Check Connection" }, { "name": "Sewer Odour", "code": "Sewer Odour" }, { "name": "Open Trench", "code": "Open Trench" }, { "name": "Camera", "code": "Camera" }, { "name": "Unserviceable", "code": "Unserviceable" }, { "name": "Roto Root and Camera", "code": "Roto Root and Camera" }, { "name": "Check CB", "code": "Check CB" }, { "name": "Check MH", "code": "Check MH" }, { "name": "Other", "code": "Other" }, { "name": "Tie \u2013 In", "code": "Tie \u2013 In" }, { "name": "No Access", "code": "No Access" }, { "name": "LIP", "code": "LIP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERVICETYPE" }, { "name": "SERVICEDATE", "type": "esriFieldTypeDate", "alias": "SERVICEDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SERVICEDATE" }, { "name": "CLEANOUT", "type": "esriFieldTypeString", "alias": "CLEANOUT", "domain": { "type": "codedValue", "name": "DSCJumkpsCleanOut", "description": "DSCJumkpsCleanOut", "codedValues": [ { "name": "Front", "code": "Front" }, { "name": "Stack", "code": "Stack" }, { "name": "OSCO", "code": "OSCO" }, { "name": "No CO", "code": "No CO" }, { "name": "Backflow Prevention Valve", "code": "Backflow Prevention Valve" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CLEANOUT" }, { "name": "OBSTRUCTIONTYPE", "type": "esriFieldTypeString", "alias": "OBSTRUCTIONTYPE", "domain": { "type": "codedValue", "name": "DSCJumkpsObstruction", "description": "DSCJumkpsObstruction", "codedValues": [ { "name": "Tree Roots", "code": "Tree Roots" }, { "name": "Grease", "code": "Grease" }, { "name": "Sag", "code": "Sag" }, { "name": "Broken Pipe", "code": "Broken Pipe" }, { "name": "Rough Spot", "code": "Rough Spot" }, { "name": "Soft Obstruction", "code": "Soft Obstruction" }, { "name": "Cross Connection", "code": "Cross Connection" }, { "name": "Hygiene Products", "code": "Hygiene Products" }, { "name": "Blocked Main", "code": "Blocked Main" }, { "name": "Heavy Roots", "code": "Heavy Roots" }, { "name": "Frozen", "code": "Frozen" }, { "name": "All the Above", "code": "All the Above" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OBSTRUCTIONTYPE" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "SERVICEDBY", "type": "esriFieldTypeString", "alias": "SERVICEDBY", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERVICEDBY" }, { "name": "JUMP_GISID", "type": "esriFieldTypeInteger", "alias": "JUMP_GISID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JUMP_GISID" }, { "name": "DATEARRIVED", "type": "esriFieldTypeDate", "alias": "DATEARRIVED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateArrived" }, { "name": "DATECOMPLETED", "type": "esriFieldTypeDate", "alias": "DATECOMPLETED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateCompleted" }, { "name": "SERVICEREQUEST", "type": "esriFieldTypeInteger", "alias": "SERVICEREQUEST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceRequest" }, { "name": "WORKORDER", "type": "esriFieldTypeInteger", "alias": "WORKORDER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WorkOrder" }, { "name": "WORKORDERTASK", "type": "esriFieldTypeSmallInteger", "alias": "WORKORDERTASK", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WorkOrderTask" }, { "name": "KNIFESIZE", "type": "esriFieldTypeString", "alias": "KNIFESIZE", "domain": { "type": "codedValue", "name": "DSCJumkpsKnifeSize", "description": "DSCJumkpsKnifeSize", "codedValues": [ { "name": "2\"", "code": "2\"" }, { "name": "3\"", "code": "3\"" }, { "name": "4\"", "code": "4\"" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "KnifeSize" }, { "name": "PIPEMATERIALCITY", "type": "esriFieldTypeString", "alias": "PIPEMATERIALCITY", "domain": { "type": "codedValue", "name": "PipeMaterial_3", "description": "", "codedValues": [ { "name": "AC", "code": "AC" }, { "name": "BRICK", "code": "BRICK" }, { "name": "CAM", "code": "CAM" }, { "name": "CI", "code": "CI" }, { "name": "CONC", "code": "CONC" }, { "name": "CSP", "code": "CSP" }, { "name": "Cu", "code": "Cu" }, { "name": "HDPE", "code": "HDPE" }, { "name": "HYPRESCON", "code": "HYPRESCON" }, { "name": "KITEC", "code": "KITEC" }, { "name": "NON-CORRODE", "code": "NON-CORRODE" }, { "name": "Pb", "code": "Pb" }, { "name": "PLASTIC", "code": "PLASTIC" }, { "name": "POLY", "code": "POLY" }, { "name": "POLY B", "code": "POLY B" }, { "name": "POLY E", "code": "POLY E" }, { "name": "POLYETHYLENE", "code": "POLYETHYLENE" }, { "name": "PRELOAD", "code": "PRELOAD" }, { "name": "PVC", "code": "PVC" }, { "name": "PVC C900", "code": "PVC C900" }, { "name": "PVC FLEXLOC", "code": "PVC FLEXLOC" }, { "name": "PVC PERMALOC", "code": "PVC PERMALOC" }, { "name": "PVC RIBBED", "code": "PVC RIBBED" }, { "name": "RCP", "code": "RCP" }, { "name": "STEEL", "code": "STEEL" }, { "name": "TILE", "code": "TILE" }, { "name": "TR", "code": "TR" }, { "name": "UNKNOWN", "code": "UNKNOWN" }, { "name": "VCT", "code": "VCT" }, { "name": "VP", "code": "VP" }, { "name": "WOOD", "code": "WOOD" }, { "name": "ABS", "code": "ABS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PipeMaterialCity" }, { "name": "PIPEMATERIALPRIVATE", "type": "esriFieldTypeString", "alias": "PIPEMATERIALPRIVATE", "domain": { "type": "codedValue", "name": "PipeMaterial_3", "description": "", "codedValues": [ { "name": "AC", "code": "AC" }, { "name": "BRICK", "code": "BRICK" }, { "name": "CAM", "code": "CAM" }, { "name": "CI", "code": "CI" }, { "name": "CONC", "code": "CONC" }, { "name": "CSP", "code": "CSP" }, { "name": "Cu", "code": "Cu" }, { "name": "HDPE", "code": "HDPE" }, { "name": "HYPRESCON", "code": "HYPRESCON" }, { "name": "KITEC", "code": "KITEC" }, { "name": "NON-CORRODE", "code": "NON-CORRODE" }, { "name": "Pb", "code": "Pb" }, { "name": "PLASTIC", "code": "PLASTIC" }, { "name": "POLY", "code": "POLY" }, { "name": "POLY B", "code": "POLY B" }, { "name": "POLY E", "code": "POLY E" }, { "name": "POLYETHYLENE", "code": "POLYETHYLENE" }, { "name": "PRELOAD", "code": "PRELOAD" }, { "name": "PVC", "code": "PVC" }, { "name": "PVC C900", "code": "PVC C900" }, { "name": "PVC FLEXLOC", "code": "PVC FLEXLOC" }, { "name": "PVC PERMALOC", "code": "PVC PERMALOC" }, { "name": "PVC RIBBED", "code": "PVC RIBBED" }, { "name": "RCP", "code": "RCP" }, { "name": "STEEL", "code": "STEEL" }, { "name": "TILE", "code": "TILE" }, { "name": "TR", "code": "TR" }, { "name": "UNKNOWN", "code": "UNKNOWN" }, { "name": "VCT", "code": "VCT" }, { "name": "VP", "code": "VP" }, { "name": "WOOD", "code": "WOOD" }, { "name": "ABS", "code": "ABS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PipeMaterialPrivate" }, { "name": "ACTION", "type": "esriFieldTypeString", "alias": "ACTION", "domain": { "type": "codedValue", "name": "DSCJumkpsAction", "description": "DSCJumkpsAction", "codedValues": [ { "name": "Jet called", "code": "Jet called" }, { "name": "MH or CB Checked", "code": "MH or CB Checked" }, { "name": "Open OK", "code": "Open OK" }, { "name": "Washout", "code": "Washout" }, { "name": "Cross Connection", "code": "Cross Connection" }, { "name": "Recommended Private Service", "code": "Recommended Private Service" }, { "name": "Sent to Construction", "code": "Sent to Construction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Action" }, { "name": "VEHICLEUNIT", "type": "esriFieldTypeInteger", "alias": "VEHICLEUNIT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VehicleUnit" }, { "name": "ATTACHEMENT", "type": "esriFieldTypeBlob", "alias": "ATTACHEMENT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ATTACHEMENT" }, { "name": "RESPONSIBILITY", "type": "esriFieldTypeString", "alias": "RESPONSIBILITY", "domain": { "type": "codedValue", "name": "DSCResponsibility", "description": "", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Private", "code": "Private" }, { "name": "Shared", "code": "Shared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "RESPONSIBILITY" }, { "name": "DATEREFFERRED", "type": "esriFieldTypeDate", "alias": "DATEREFFERRED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEREFFERRED" }, { "name": "FLOWRATE", "type": "esriFieldTypeString", "alias": "FLOWRATE", "domain": { "type": "codedValue", "name": "RP_FLOWRATE ", "description": "FLOWRATE ", "codedValues": [ { "name": "Blocked", "code": "Blocked" }, { "name": "Slow draining", "code": "Slow draining" }, { "name": "Damaged", "code": "Damaged" }, { "name": "Cleaned", "code": "Cleaned" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FLOWRATE" } ], "indexes": [ { "name": "GDB_120767_JUMP_", "fields": "JUMP_GISID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R1004414_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Canada Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "DSCJumpRel", "description": "", "prototype": { "attributes": { "DATEREFFERRED": null, "FLOWRATE": null, "SERVICETYPE": null, "SERVICEDATE": null, "CLEANOUT": null, "OBSTRUCTIONTYPE": null, "COMMENTS": null, "SERVICEDBY": null, "JUMP_GISID": null, "DATEARRIVED": null, "DATECOMPLETED": null, "SERVICEREQUEST": null, "WORKORDER": null, "WORKORDERTASK": null, "KNIFESIZE": null, "PIPEMATERIALCITY": null, "PIPEMATERIALPRIVATE": null, "ACTION": null, "VEHICLEUNIT": null, "ATTACHEMENT": null, "RESPONSIBILITY": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }