Wednesday, February 1, 2017

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
  2. A. Address B.Lat C.Long D. NBN Status – in rollout (yes/no)
  3. 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

  4. Paste address into NBN map checker:
  5. 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.

  6. Paste Address status (yes/no) into Col. D.
  7. 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.
  8. Go to Google Maps: https://www.google.com.au/maps/
  9. -> 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.

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

  12. 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.
  13. Add polygon to show the boundary of rollout for the region.
  14. Post to Whirlpool / Twitter for comments: Maps -> Share -> Change: anyone with the link can View – copy/paste URL

  15. Enjoy!

No comments: