The Chorus website makes available a great deal of technical information regarding their RBI rollout (eg. Cabinet Migration Schedule - http://www.chorus.co.nz/file/8569/webmigration-November-2012.xls, and so on...). This is great. The spreadsheets they make available certainly contain useful information. Several of these spreadsheets contain (X,Y) coordinates of various pieces of equipment.
Is there a way of mapping these coordinates -- manually if needed, I'm only particularly interested in a handful of locations -- to an actual location?
Looks like the coordinates are provided in NZ Map Grid format, so if you convert them into WGS84, you end up with a lat/long coordinate that can go straight into the Google maps search bar
The X figure (from the Chorus spreadsheet) is your Easting, and Y figure your Northing
-- Thats how I would do it for one-off conversion, if you want something more systematic then you really need to use a GIS, i would recommend Quantam GIS as a free starting point
Actually a better way to do the whole spreadsheet is to click on "free format entry advanced option" from the LINZ page above, and paste the whole two columns from your spreadsheet (NB transpose X & Y to match input format) in there to generate two new columns for your spreadsheet with WGS84 coordinates, ready for Google Maps
Funnily enough, spatial data is the only area of geekdom that I'm formally qualified* in, so more than happy to help out with any other spatial queries/problems that you have
*and currently looking for a graduate-level job in, but thats getting even further off-topic
Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly
to your computer or smartphone by using a feed reader.
Trusted
