{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 324, "name": "RISOilSands.GDB.Cleared", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CLEARED_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CLEARED_ID", "type": "esriFieldTypeString", "alias": "Cleared ID", "length": 12, "domain": null }, { "name": "LCU_ID", "type": "esriFieldTypeString", "alias": "Land Cover ID", "length": 12, "domain": null }, { "name": "CLEARED_FEATURE_TYPE", "type": "esriFieldTypeString", "alias": "Cleared Feature Type", "length": 3, "domain": { "type": "codedValue", "name": "WS2_OilSands_ClearedArea", "description": "Description of Cleared Area", "codedValues": [ { "name": "Cutblock", "code": "01" }, { "name": "Oil sands cleared", "code": "02" }, { "name": "Cleared other industry", "code": "03" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R238_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1618_LCU_ID", "fields": "LCU_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "OilSandsLandCover2007", "relatedTableId": 75, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{3CB03847-3724-4A92-811F-01CF4ED6CFAE}" }, { "id": 4, "name": "OilSandsLandCover1998", "relatedTableId": 58, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{5946BFDC-28EC-43AF-A623-236217557F80}" }, { "id": 20, "name": "OilSandsLandCover2013", "relatedTableId": 143, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{BE3614A8-81C6-47D0-8781-91B89AFBE319}" }, { "id": 18, "name": "OilSandsLandCover2013", "relatedTableId": 143, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{C82A27E0-0246-4453-B062-DABB0751696E}" }, { "id": 2, "name": "OilSandsLandCover1980s", "relatedTableId": 41, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{7FF5F4E6-B21F-4159-B801-1606FD4B0ACF}" }, { "id": 10, "name": "OilSandsLandCover2010", "relatedTableId": 93, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{8C31469F-4317-48C7-BD7E-2F6765D999DC}" }, { "id": 12, "name": "OilSandsLandCover2011", "relatedTableId": 110, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{20FE6C81-C4E3-42B4-8FF0-04DBFA13EA49}" }, { "id": 16, "name": "OilSandsLandCover2012", "relatedTableId": 127, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{BA889821-D81D-4EF7-B7D9-EB2DD438C1AC}" }, { "id": 24, "name": "OilSandsLandCover2014", "relatedTableId": 164, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{7F24B432-CF1B-49DF-9206-E10BDEBE0B07}" }, { "id": 25, "name": "OilSandsLandCover2015", "relatedTableId": 185, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{07B3EB82-A763-4E5F-A0FD-9E8D5FA41B26}" }, { "id": 32, "name": "OilSandsLandCover2017", "relatedTableId": 231, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{28D7D929-B097-40F7-A933-45C65F3FE524}" }, { "id": 28, "name": "OilSandsLandCover2016", "relatedTableId": 208, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{97159838-06EC-4459-A6DD-6F75F01B4EA7}" }, { "id": 38, "name": "OilSandsLandCover2020", "relatedTableId": 277, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{A728DBF9-2FE4-491A-9564-C5D1A29F2AC3}" }, { "id": 34, "name": "RISOilSands.GDB.OilSandsLandCover2018", "relatedTableId": 254, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{B920CFE8-3D17-41F0-8D12-314A680808BF}" }, { "id": 42, "name": "RISOilSands.GDB.OilSandsLandCover2021", "relatedTableId": 300, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{A1706473-876B-46E3-9FC3-5525B27E82B2}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "ad9742fa81ce4f71be816ef2e2d9b14b" }