Correction Lesson 5 Lab 1: Mapping Toronto Condo Boom Part2: Data Enrichment and Mapping
-
Calculate the time spent using the GREL: diff(cells['COMPLETED_DATE'].value, cells['ISSUE_DATE'].value, "weeks")
-
Join (cell.cross) based on the postal code using the result from the lab 4 using: cell.cross("postalcode","postalcode").cells["area"].value[0]
-
Query OpenStreetMap API: 'http://www.mapquestapi.com/geocoding/v1/address?key=[YOUR CONSUMER KEY]&callback=renderGeocode&location='+escape(value, 'url')
- The new Mapquest results wrap the result into renderGeocode() . This extra wrap prevent OpenRefine to recongize the result as a JSON and so to use the parseJson() function. You need first to remove this element using either the replace() or split fuction:
- value.replace('renderGeocode(','')
- value.split('(')[1]
-
Parse the long: value.parseJson().results[0].locations[0].latLng.lng
-
Parse the lat: value.parseJson().results[0].locations[0].latLng.lat
-
Export in csv format
- Load in mapbox to map the points.
Last modified: Saturday, 6 April 2019, 12:38 PM