See the map (v.1) I made (with 40 datapoints) at:
I made a (v.2) map (with 60 datapoints) at:
MethodIf you want to repeat this for your area, here's how I did it.
- 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
- Create Google Sheet (or spreadsheet) with four columns A. Address B.Lat C.Long D. NBN Status – in rollout (yes/no)
- 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
- Paste address into NBN map checker: http://www.nbnco.com.au/connect-home-or-business/check-your-address.html
- Paste Address status (yes/no) into Col. D.
- 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.
- 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
- 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).
- 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.
- Add polygon to show the boundary of rollout for the region.
- Post to Whirlpool / Twitter for comments: Maps -> Share -> Change: anyone with the link can View – copy/paste URL
This gives rollout status. In Hughesdale it was either (1) (Available: Apr – Jun) = yes or (2) (Still finalising) = no.
This places all your address points on a map.
Add a title and description to explain what area you are mapping.