{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 320, "name": "RISOilSands.GDB.Reclaimed", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RECLAIMED_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "RECLAIMED_ID", "type": "esriFieldTypeString", "alias": "Reclaimed ID", "length": 12, "domain": null }, { "name": "LCU_ID", "type": "esriFieldTypeString", "alias": "Land Cover ID", "length": 12, "domain": null }, { "name": "RECLAIMED_YEAR", "type": "esriFieldTypeSmallInteger", "alias": "Reclaimed Year", "domain": null }, { "name": "SITETYPE", "type": "esriFieldTypeString", "alias": "Site Type", "length": 3, "domain": { "type": "codedValue", "name": "WS2_OilSands_SiteType", "description": "Site Type", "codedValues": [ { "name": "Dry (ecosites a and b)", "code": "01" }, { "name": "Moist Poor (ecosite c)", "code": "02" }, { "name": "Moist Rich (ecosites d and e)", "code": "03" }, { "name": "Wet Rich (ecosites f and h)", "code": "04" }, { "name": "Wet Poor (ecosite g)", "code": "05" }, { "name": "Bog (ecosite i)", "code": "06" }, { "name": "Fen (ecosites j and k)", "code": "07" }, { "name": "Marsh (ecosite l)", "code": "08" }, { "name": "Open water (rivers and streams)", "code": "09" }, { "name": "Open water (lakes and ponds)", "code": "10" }, { "name": "Open water (lakes and ponds)", "code": "11" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ECOSITE", "type": "esriFieldTypeString", "alias": "EcoSite", "length": 3, "domain": { "type": "codedValue", "name": "WS2_OilSands_Ecosite", "description": "EcoSite", "codedValues": [ { "name": "a = lichen (subxeric / poor)", "code": "01" }, { "name": "b = blueberry (submesic / medium)", "code": "02" }, { "name": "c = labrador tea - mesic (mesic / poor)", "code": "03" }, { "name": "d = low-bush cranberry (mesic / medium)", "code": "04" }, { "name": "e = dogwood (subhygric / rich)", "code": "05" }, { "name": "f = horsetail (hygric / rich)", "code": "06" }, { "name": "g = labrador tea - subhygric (subhygric / poor)", "code": "07" }, { "name": "h = labrador tea - horsetail (hygric / medium)", "code": "08" }, { "name": "j = poor fen (subhydric / medium)", "code": "10" }, { "name": "k = rich fen (subhydric / rich)", "code": "11" }, { "name": "l = marsh - swamp (hydric / rich)", "code": "12" }, { "name": "Open water (rivers and streams)", "code": "13" }, { "name": "Open water (lakes and ponds)", "code": "14" }, { "name": "Other", "code": "15" }, { "name": "i = bog (subhydric / very poor)", "code": "09" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ECOSITE_PHASE", "type": "esriFieldTypeString", "alias": "EcoSite Phase", "length": 3, "domain": { "type": "codedValue", "name": "WS2_OilSands_EcositePhase", "description": "Ecosite Phase", "codedValues": [ { "name": "b1 - blueberry/jack pine - aspen", "code": "02" }, { "name": "b2 - blueberry/aspen (white birch)", "code": "03" }, { "name": "b4 - blueberry/white spruce - jack pine", "code": "05" }, { "name": "b3 - blueberry/aspen - white spruce", "code": "04" }, { "name": "c1 - labrador tea - mesic/jack pine - black spruce", "code": "06" }, { "name": "d1 - low-bush cranberry/aspen", "code": "07" }, { "name": "d2 - low-bush cranberry/aspen - white spruce", "code": "08" }, { "name": "d3 - low-bush cranberry/white spruce", "code": "09" }, { "name": "e1 - dogwood/balsam poplar - aspen", "code": "10" }, { "name": "e2 - dogwood/balsam poplar - white spruce", "code": "11" }, { "name": "e3 - dogwood/white spruce", "code": "12" }, { "name": "f1 - horsetail/balsam poplar - aspen", "code": "13" }, { "name": "f2 - horsetail/balsam poplar - white spruce", "code": "14" }, { "name": "f3 - horsetail/white spruce", "code": "15" }, { "name": "g1 - Labrador tea - subhygric/black spruce - jack pine", "code": "16" }, { "name": "h1 - Labrador tea / horsetail white spruce - black spruce", "code": "17" }, { "name": "Forested bog (BFNN)", "code": "18" }, { "name": "Open bog (BONN)", "code": "19" }, { "name": "Wooded bog (BTNN)", "code": "20" }, { "name": "Graminoid fen (FONG)", "code": "21" }, { "name": "shrubby fen (FONS)", "code": "22" }, { "name": "Wooded fen with internal lawns (FTNI)", "code": "23" }, { "name": "Wooded fen (FTNN)", "code": "24" }, { "name": "Marsh (MONG)", "code": "25" }, { "name": "Shrubby swamp (SONS)", "code": "26" }, { "name": "Wooded swamp (STNN)", "code": "27" }, { "name": "Open water (rivers and streams)", "code": "28" }, { "name": "Open water (lakes and ponds)", "code": "29" }, { "name": "End pit lake", "code": "30" }, { "name": "Burned/harvested", "code": "31" }, { "name": "Other - reclaimed saline wetland", "code": "32" }, { "name": "Other - reclaimed terrestrial", "code": "33" }, { "name": "i1 - treed bog", "code": "34" }, { "name": "i2 - shrubby bog", "code": "35" }, { "name": "j1 - treed poor fen", "code": "36" }, { "name": "j2 - shrubby poor fen", "code": "37" }, { "name": "k1 - treed rich fen", "code": "38" }, { "name": "k2 - shrubby rich fen", "code": "39" }, { "name": "k3 - graminoid rich fen", "code": "40" }, { "name": "l1 - marsh", "code": "41" }, { "name": "Meadow", "code": "42" }, { "name": "a1 - lichen/jack pine", "code": "01" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CROWN_CLOSURE", "type": "esriFieldTypeString", "alias": "Crown Closure", "length": 3, "domain": { "type": "codedValue", "name": "WS2_OilSands_CrownClosure", "description": "CrownClosure", "codedValues": [ { "name": "A/B crown closure", "code": "01" }, { "name": "C/D crown closure", "code": "02" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RECLAIMED_STATUS", "type": "esriFieldTypeString", "alias": "RECLAIMED_STATUS", "length": 3, "domain": { "type": "codedValue", "name": "WS2_OilSands_ReclaimedStatus", "description": "Reclaimed Status", "codedValues": [ { "name": "Permanent", "code": "01" }, { "name": "Temporary", "code": "02" }, { "name": "Temporary (dam safety)", "code": "03" }, { "name": "Certified", "code": "04" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CERTIFIED_YEAR", "type": "esriFieldTypeSmallInteger", "alias": "Certified Year", "domain": null }, { "name": "ARIS_CODE", "type": "esriFieldTypeInteger", "alias": "ARIS Code", "domain": null } ], "indexes": [ { "name": "R241_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1621_LCU_ID", "fields": "LCU_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "OilSandsLandCover2007", "relatedTableId": 75, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{8C408635-7604-40FA-B4D4-B11EF1A265D9}" }, { "id": 3, "name": "OilSandsLandCover1998", "relatedTableId": 58, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{D1739BAF-469D-45DA-A830-BCE183628215}" }, { "id": 9, "name": "OilSandsLandCover2010", "relatedTableId": 93, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{D34B0D30-77AD-4064-93EF-EB228190AAC7}" }, { "id": 13, "name": "OilSandsLandCover2011", "relatedTableId": 110, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{4034BA72-6B36-42E6-B454-D634A6A54D1D}" }, { "id": 17, "name": "OilSandsLandCover2012", "relatedTableId": 127, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{5E5B2953-269E-476E-9E4A-2A323C669821}" }, { "id": 1, "name": "OilSandsLandCover1980s", "relatedTableId": 41, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{8E6FB9AF-7FC0-40AB-A9F6-1D607CC89D5C}" }, { "id": 23, "name": "OilSandsLandCover2014", "relatedTableId": 164, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{69AF86FE-EF97-470A-A2F8-8D6B36CECDA1}" }, { "id": 19, "name": "OilSandsLandCover2013", "relatedTableId": 143, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{AFF109D3-7333-467A-8A7D-110D46D44F46}" }, { "id": 27, "name": "OilSandsLandCover2015", "relatedTableId": 185, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{101E43E9-937A-4445-BADE-231033A32A8B}" }, { "id": 31, "name": "OilSandsLandCover2017", "relatedTableId": 231, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{88928BC3-35D9-48BE-8F76-BC1E45909254}" }, { "id": 29, "name": "OilSandsLandCover2016", "relatedTableId": 208, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{580DB826-AE0C-48A1-B79E-1AA876F6EC80}" }, { "id": 37, "name": "OilSandsLandCover2020", "relatedTableId": 277, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{035FB6FE-D366-4693-B985-B7DA40109C71}" }, { "id": 41, "name": "RISOilSands.GDB.OilSandsLandCover2021", "relatedTableId": 300, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{167D22C5-3C61-49B3-8BDC-60DF39F523F7}" }, { "id": 36, "name": "RISOilSands.GDB.OilSandsLandCover2018", "relatedTableId": 254, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{F1B2040B-FC55-4744-9692-676F43EE4F8B}" } ], "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" }