samgostomski

This is the map of Nielen Designated Marketing Areas using D3.js. Hover over for data related to each area.

See map here

See code here

###Credits

Map adapted from Mike Bostock's map example
Topojson made by converting shapefile from here to topojson via Mike Bostock's instructions

	#!/usr/bin/env python3
	# See: https://medium.com/@lakshmanok/how-to-load-geojson-files-into-bigquery-gis-9dc009802fb4

	import json
	with open('NUTS_BN_01M_2016_4326_LEVL_3.geojson', 'r') as ifp:
	with open('to_load.json', 'w') as ofp:
	features = json.load(ifp)['features']
	# new-line-separated JSON
	schema = None
	for obj in features:

	/**
	* This Google Sheets script keeps data in the specified column sorted any time
	* the data changes.
	*
	* After much research, there wasn't an easy way to automatically keep a column
	* sorted in Google Sheets, and creating a second sheet to act as a "view" to
	* my primary one in order to achieve that was not an option. Instead, I
	* created a script that watches for when a cell is edited and triggers
	* an auto sort.
	*