{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 321, "name": "RISOilSands.GDB.DisturbedFeature", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DISTURBED_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "DISTURBED_ID", "type": "esriFieldTypeString", "alias": "Disturbed Feature ID", "length": 12, "domain": null }, { "name": "LCU_ID", "type": "esriFieldTypeString", "alias": "Land Cover ID", "length": 12, "domain": null }, { "name": "DISTURBED_FEATURE_TYPE", "type": "esriFieldTypeString", "alias": "Disturbed Feature Type", "length": 3, "domain": { "type": "codedValue", "name": "WS2_OilSand_DisturbedFeature", "description": "OilSands Disturbed Feature", "codedValues": [ { "name": "Aerodrome", "code": "01" }, { "name": "Borrow pit", "code": "02" }, { "name": "Camp housing", "code": "03" }, { "name": "Disturbed other industry", "code": "04" }, { "name": "Drainage", "code": "05" }, { "name": "Mine pit", "code": "06" }, { "name": "Operations", "code": "07" }, { "name": "Overburden dump", "code": "08" }, { "name": "Pipeline", "code": "09" }, { "name": "Plant site", "code": "10" }, { "name": "Powerline", "code": "11" }, { "name": "Reclamation material stockpile (RMS)", "code": "13" }, { "name": "River water intake structure", "code": "14" }, { "name": "Road", "code": "15" }, { "name": "Soil placed", "code": "16" }, { "name": "soil salvaged", "code": "17" }, { "name": "Tailings", "code": "18" }, { "name": "Tank farm", "code": "19" }, { "name": "Utilities", "code": "20" }, { "name": "Waste", "code": "21" }, { "name": "well site", "code": "22" }, { "name": "disturbed unclassified", "code": "23" }, { "name": "other", "code": "24" }, { "name": "Undergoing remediation", "code": "25" }, { "name": "Recontoured", "code": "26" }, { "name": "Concrete pit", "code": "27" }, { "name": "Central processing facility", "code": "28" }, { "name": "Windrow", "code": "29" }, { "name": "Ready for reclamation", "code": "12" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DISTURBED_FEATURE_STATUS", "type": "esriFieldTypeString", "alias": "Disturbed Feature Status", "length": 3, "domain": { "type": "codedValue", "name": "WS2_OilSands_DisturbedFeatureStatus", "description": "Disturbed Feature Status", "codedValues": [ { "name": "Active", "code": "01" }, { "name": "Inactive", "code": "02" }, { "name": "Abandoned", "code": "03" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R239_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1619_LCU_ID", "fields": "LCU_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_1619_DISTURB", "fields": "DISTURBED_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_1619_DISTURB_1", "fields": "DISTURBED_FEATURE_TYPE", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 43, "name": "TAILINGS", "relatedTableId": 322, "role": "esriRelRoleOrigin", "keyField": "DISTURBED_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C5FF5FE6-879E-472F-B225-138ADFC8A29D}" }, { "id": 8, "name": "OilSandsLandCover2007", "relatedTableId": 75, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{8F7C46ED-0273-4859-83CD-DFC0CA83917F}" }, { "id": 5, "name": "OilSandsLandCover1998", "relatedTableId": 58, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{C00F961C-3B22-4B14-A02B-7389D7AC4B32}" }, { "id": 21, "name": ".OilSandsLandCover2013", "relatedTableId": 143, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{49CDF185-15E0-40C8-89FE-1D2E0C3603B0}" }, { "id": 0, "name": "OilSandsLandCover1980s", "relatedTableId": 41, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{73AC60E5-CC28-448E-B5DC-068A40A46BB4}" }, { "id": 11, "name": "OilSandsLandCover2010", "relatedTableId": 93, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{87B02036-2547-4EE5-9CB6-403A061CB775}" }, { "id": 14, "name": "OilSandsLandCover2011", "relatedTableId": 110, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{189BCCC1-A3D1-43ED-91FD-73D84827C23D}" }, { "id": 15, "name": "OilSandsLandCover2012", "relatedTableId": 127, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{8D648FB2-E96F-4AE8-B687-3CBF608C4513}" }, { "id": 22, "name": "OilSandsLandCover2014", "relatedTableId": 164, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{9A7C322D-18DB-48FA-9CA2-2D022BCC4BA0}" }, { "id": 26, "name": "OilSandsLandCover2015", "relatedTableId": 185, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{D8BCC6E4-7940-4425-AA27-9689625B09C6}" }, { "id": 33, "name": "OilSandsLandCover2017", "relatedTableId": 231, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{4B3A76B2-04E8-4260-AD1F-BEFD81B97597}" }, { "id": 30, "name": "OilSandsLandCover2016", "relatedTableId": 208, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{6034E1C0-6203-4378-A929-C6AA228467A4}" }, { "id": 39, "name": "OilSandsLandCover2020", "relatedTableId": 277, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{656CCCA3-EF1A-4F0C-8E7F-5FD3B96CF5F6}" }, { "id": 35, "name": "RISOilSands.GDB.OilSandsLandCover2018", "relatedTableId": 254, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{697972E2-5077-4027-90A0-4F7E01AACF35}" }, { "id": 40, "name": "RISOilSands.GDB.OilSandsLandCover2021", "relatedTableId": 300, "role": "esriRelRoleDestination", "keyField": "LCU_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{9D98C85E-7571-488D-8100-1DC844D5A3E5}" } ], "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" }