2b:null 2c:["$","title",null,{"children":"Your CO2 emissions from Location History | Steren | Observable"}] 31:T890,md` # Your CO₂ emissions from Location History This notebook computes an estimate of your past transportation-related CO₂ emissions using your [Google Location History](https://support.google.com/accounts/answer/3118687?hl=en) (an opt-in feature also called "[Timeline](https://support.google.com/maps/answer/6258979?co=GENIE.Platform%3DAndroid&hl=en)" in Google Maps). After selecting your data, you get something like this: ${await FileAttachment("example@2.png").image()} This notebook **does not store or upload your data**. All computation is done client-side using JavaScript in your web browser. Greenhouse gases are responisble for climate change, read more in [*A pragmatic guide climate change*](https://www.tmrow.com/climatechange). Greenhouse gas emission is mearued in "CO₂ equivalent". Transporation emit greenhouse gas, being able to understand how much might help you reduce your impact on climate change. Only Flights and car rides will be taken into account, other means of transportation like trains will be skipped or can be miscategorized. You might have offset some of these emissions, this is not be reflected in these charts, that only show *emissions*. **See also:** To automatically track your CO₂ emissions and understand your monthly budget, I recommend using the [North mobile app](https://north-app.com/). ## How to use *You can stop reading if you have not enabled Google Location History before*. 1. Request an archive of your Google Location History * Visit https://takeout.google.com * Under "*Create a new export*": * Click "*Deselect all*" * Scroll and check "*Location History*". * Scroll and click "*Next Step*" * Under "*Choose file type, frequency & destination*", keep the default values: Export once a ".zip" file. * Click "*Create Export*". 1. Download the archive * You will receive an email after some time (it usually takes minutes or up to a few hours) * Click the link from the email * Download and Save the .zip on your local disk 1. 👇 Select the .zip in the file selector below (Data and charts will appear after a few seconds). `32:T412,vl.layer([vl.markBar() .data(activities) .encode( vl.x().fieldT('datetime').timeUnit('yearmonth').title('Month'), vl.y().fieldQ('kCO2e'), vl.color().fieldN('transportationMode'), vl.tooltip([{field: 'datetime', 'type': 'temporal'}, 'distanceKilometers', 'durationHours']), )], [ vl.markRule() .data({ values: [{kCO2e: 400, label: "Monthly kCO2eq budget"}]}) .encode( vl.y().fieldQ('kCO2e'), vl.color({value: 'red'}), //vl.text().fieldN('label'), vl.tooltip([{field: 'label', 'type': 'nominal'}, {field: 'kCO2e', 'type': 'quantitative'}]), ) ],/* [ vl.markRule() .data(activities) .transform( // How to average the monthly value? vl.aggregate(vl.average('kCO2e').as('Average kCO2eq')) ) .encode( vl.y().fieldQ('Average kCO2eq'), vl.color({value: 'blue'}), //vl.text().fieldN('label'), vl.tooltip([{field: 'Average kCO2e', 'type': 'quantitative'}]), ) ]*/) .width(700) .render()33:Tfa8,/** * Parse a location history * @param {String} historyStr: a semantic activity location history .json file * @return the parsed activities */ function parseActivities(historyStr) { const weCareAboutActivityType = function(type) { return ['FLYING', 'IN_VEHICLE', 'IN_PASSENGER_VEHICLE', 'IN_TAXI'].includes(type); } const weCareAboutActivity = function(activitySegment) { return activitySegment && activitySegment.distance && weCareAboutActivityType(activitySegment.activityType); } const activityTypeToTransportationMode = function(type) { switch(type) { case 'FLYING': return 'Air'; case 'IN_TAXI': case 'IN_PASSENGER_VEHICLE': case 'IN_VEHICLE': return 'Road'; default: return type; } } /* * This function uses heuristics to potentially inject an activityType if not present. * E.g. long distance and high average speed should be a flight */ const preProcessActivity = function (activitySegment) { const FLIGHT_MIN_DISTANCE_KM = 500; const FLIGHT_MIN_AVERAGE_SPEED_KMH = 300; const FLIGHT_MAX_AVERAGE_SPEED_KMH = 1000; const CAR_MAX_DISTANCE_KM = 1000; const CAR_MIN_DISTANCE_KM = 50; const CAR_MAX_AVERAGE_SPEED_KMH = 130; const CAR_MIN_AVERAGE_SPEED_KMH = 50; // we need duration to compute speed. if( !activitySegment || !activitySegment.duration || !activitySegment.duration.endTimestampMs || !activitySegment.duration.startTimestampMs) { return; } const speedKmH = function(activitySegment) { const km = activitySegment.distance / 1000; const h = (activitySegment.duration.endTimestampMs - activitySegment.duration.startTimestampMs) / (1000 * 60 * 60); return km / h; } if(activitySegment.distance > FLIGHT_MIN_DISTANCE_KM * 1000 && speedKmH(activitySegment) > FLIGHT_MIN_AVERAGE_SPEED_KMH && speedKmH(activitySegment) < FLIGHT_MAX_AVERAGE_SPEED_KMH) { activitySegment.activityType = 'FLYING'; return; } if(activitySegment.distance > CAR_MIN_DISTANCE_KM * 1000 && activitySegment.distance < CAR_MAX_DISTANCE_KM * 1000 && speedKmH(activitySegment) > CAR_MIN_AVERAGE_SPEED_KMH && speedKmH(activitySegment) < CAR_MAX_AVERAGE_SPEED_KMH) { activitySegment.activityType = 'IN_PASSENGER_VEHICLE'; return; } } const history = JSON.parse(historyStr) if(!history.timelineObjects) { return; } let activities = []; history.timelineObjects.forEach(timelineObject => { const activitySegment = timelineObject.activitySegment; preProcessActivity(activitySegment); if(weCareAboutActivity(activitySegment)) { const activity = { id: activitySegment.duration.startTimestampMs, datetime: new Date(parseInt(activitySegment.duration.startTimestampMs, 10)), durationHours: (activitySegment.duration.endTimestampMs - activitySegment.duration.startTimestampMs) / (1000 * 60 * 60), distanceKilometers: activitySegment.distance / 1000, activityType: 'ACTIVITY_TYPE_TRANSPORTATION', transportationMode: activityTypeToTransportationMode(activitySegment.activityType), }; activities.push(activity); } // For Debug only else if(activitySegment && !['WALKING', 'IN_SUBWAY', 'CYCLING', 'SAILING', 'BOATING', 'IN_BUS', 'HIKING', 'IN_TRAIN'].includes(activitySegment.activityType) && activitySegment.distance > 100 * 1000 && (activitySegment.duration.endTimestampMs - activitySegment.duration.startTimestampMs) > 1000 * 60 * 60 ) { console.log(activitySegment); } }) return activities; }34:[{"id":"0c8083998b86a4a7fa1fd9ac848f164114fa5fc65095c4f7f0c3ea326da3a76acf2fedaec6ec19873df774e55d905dbf906671b015944cb81fa13110b55f515d","href":"https://static.observableusercontent.com/files/0c8083998b86a4a7fa1fd9ac848f164114fa5fc65095c4f7f0c3ea326da3a76acf2fedaec6ec19873df774e55d905dbf906671b015944cb81fa13110b55f515d","name":"example@2.png","type":"image/png","lastModified":1583286976272.933,"size":115990}] 2f:{"id":"c14409de8771d837","slug":"your-co2-emissions-from-location-history","title":"Your CO2 emissions from Location History","thumbnail":"0c2f529b0cb291c838d8b32768ea8bf811094e9f7ddc03b2c2311a5bbabec775","access_level":"public","create_time":"$D2020-03-01T17:34:57.774Z","update_time":"$D2020-03-04T18:53:05.535Z","view_time":null,"first_public_time":"$D2020-03-03T06:52:21.648Z","fork":false,"stars":10,"starred":false,"owner":{"type":"team","id":"61677a18a5adad08","login":"steren","name":"Steren","avatar_url":"https://avatars-next.observableusercontent.com/d5c11bf7f66294d4fe467870c63102da2f03488e6d8b1ab782e36f5fad52c826","tier":"starter_2024"},"version":579,"publish_version":579,"role":null,"authored":false,"authors":[{"type":"individual","id":"264dadb4cc8ce20b","login":"steren","name":"Steren","avatar_url":"https://avatars-next.observableusercontent.com/d5c11bf7f66294d4fe467870c63102da2f03488e6d8b1ab782e36f5fad52c826","tier":null}],"members":[{"type":"individual","id":"264dadb4cc8ce20b","login":"steren","name":"Steren","avatar_url":"https://avatars-next.observableusercontent.com/d5c11bf7f66294d4fe467870c63102da2f03488e6d8b1ab782e36f5fad52c826","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":5,"collection":null,"type":"notebook","body":{"title":"Your CO2 emissions from Location History","cells":[{"id":0,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"viewof zipFile = html``\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":88,"value":"md`\nExtracted **${activities.filter(a => a.transportationMode == 'Air').length} flights** and **${activities.filter(a => a.transportationMode == 'Road').length} car rides** (or equivalent) from your Location History.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":175,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":514,"value":"md`\nOther interesting charts:\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":528,"value":"vl.markBar()\n .data(activities)\n .encode(\n vl.x().fieldQ('kCO2e'),\n vl.color().fieldN('transportationMode'),\n )\n .title('Total')\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":518,"value":"vl.markBar()\n .data(activities)\n .transform(\n vl.filter('datum.transportationMode == \"Air\"')\n )\n .encode(\n vl.x().fieldT('datetime').timeUnit('yearmonth').title('Month'),\n vl.y().count().title('Number of flights'),\n )\n .width(700)\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":200,"value":"vl.markBar()\n .data(activities)\n .transform(\n vl.filter('datum.transportationMode == \"Air\"')\n )\n .encode(\n vl.y().count().title('Number of flights'),\n vl.x().fieldQ('kCO2e').bin({maxbins: 5}),\n )\n .render()\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"md`\nHere are the 10 most impactful flights:\n${\n//TODO: use https://observablehq.com/@tmcw/tables/2 instead?\nprintTable(\n activities\n .sort((first, second) => {return first.distanceKilometers > second.distanceKilometers ? -1 : 1 })\n .slice(0,10),\n [\n {field: 'datetime', title: 'Date', align: 'l'},\n {field: 'distanceKilometers', title: 'Distance (km)', align: 'l'},\n {field: 'kCO2e', title: 'kCO2e', align: 'l'},\n ]\n)\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"md`\n## Code\n* **License**: This code is under the [Apache 2.0 License](https://www.apache.org/licenses/LICENSE-2.0) \n* **Author**: Steren Giannini (steren.giannin@gmail.com)\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"JSZip = require(\"jszip@3/dist/jszip.min.js\")\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":182,"value":"import {printTable} from '@uwdata/data-utilities' \n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"import {vl} from '@vega/vega-lite-api'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"zip = await JSZip.loadAsync(zipFile);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"files = zip.file(/^Takeout\\/Location History\\/Semantic Location History\\/.*\\.json$/)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"fileContents = await Promise.all( files.map(f => f.async(\"string\"))) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"// For each file content, extract activities, then flaten all activities in a single array\nactivities = fileContents.map(parseActivities).flat()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":156,"value":"activities.forEach(co2e)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"/** For a given activity, populate its kCO2e attribute **/\nfunction co2e(activity) {\n // Poor man's CO2 model. \n // This is copy pasting values from the \"Transportation\" chart at https://www.tmrow.com/climatechange\n // TODO: use better model, import https://github.com/tmrowco/northapp-contrib/tree/master/co2eq\n switch(activity.transportationMode) {\n case 'Air':\n return activity.kCO2e = activity.distanceKilometers * 300 / 1000;\n case 'Road':\n return activity.kCO2e = activity.distanceKilometers * 183 / 1000;\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 30:"$2f:body"