NBN coming to Vic 3166 - I made a map. Here's how.

See the map (v.1) I made (with 40 datapoints) at:
https://twitter.com/ValueMgmt/status/827009730870521856 
I made a (v.2) map (with 60 datapoints) at:
https://t.co/zd8F86Z9am

Method

If you want to repeat this for your area, here's how I did it.

Getting Started

• Lat/Long: I use a Mac, and its Map program provides an easy way to turn an address into a Lat Long. You can also use maps.google.com.
• Spreadsheet. I used a Google Sheet. You can also load data into excel (csv) and drop into Google Maps.
• Google Maps. You need a Google login for this.

Making the Map

1. Create Google Sheet (or spreadsheet) with four columns
A. Address B.Lat C.Long D. NBN Status – in rollout (yes/no)

2. Get the Lat Long. In Apple Maps, pick an address, Drop a pin = Right Click. Click (i). Copy address into Column A. Copy Lat/ Long in Col B,C. Alternatively, in Google Maps, right click What's here to get the Lat/Long of any point. You can also find a Lat/Long with Google Maps API; by inserting and address into: http://maps.googleapis.com/maps/api/geocode/json?address=ADDR where ADDR = 12carlislecrescent,hughesdale,vic eg Link


3. Paste address into NBN map checker:
http://www.nbnco.com.au/connect-home-or-business/check-your-address.html
This gives rollout status. In Hughesdale it was either (1) (Available: Apr – Jun) = yes or (2) (Still finalising) = no.


4. Paste Address status (yes/no) into Col. D.
5. Gather a list of addresses you want to map... I did about 25 before I made a map. Then the map helped pick where to check next.
6. Go to Google Maps: https://www.google.com.au/maps/
-> Menu -> Your places -> Maps -> Create Map -> Add Layer -> select Google Sheet -> indicate Lat/Long fields -> indicate NBN Status: Yes/No field
This places all your address points on a map.
Add a title and description to explain what area you are mapping.


7. Colour code the points into different colours for NBN Status: Yes/No.
Select Layer -> Uniform Style -> Uniform Style -> Style by Data Column -> Col D. (NBN Status).


8. When you add new data to your spreadsheet, you need to (but maybe there is an easier way) readd the layer: Add layer -> select Google Sheet i.e. repeat Step 6,7. Delete the old layer: Choose layer -> layer options (three vertical dots) -> delete this layer.
9. Add polygon to show the boundary of rollout for the region.
10. Post to Whirlpool / Twitter for comments: Maps -> Share -> Change: anyone with the link can View – copy/paste URL

Enjoy!