You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I am technically fairly inept when it comes to presenting data. So is there an easy way to present data on a bing or google map?
The data is postcodes of learners who have enrolled on to courses. I'd like to see a map visual of pins, showing where learners come from. I'd like to drill this down to have different coloured pins depending upon if the learner has enrolled in a mental health course, english qual etc.
Is there an easy way to do this?
Thanks in advance!
Blu Tack?
Plotly, and a little bit of python did this for me the other day. Think the chart type was geobox
I think chart studio would do it with less python.
Recent versions of excel have a map function offered in the charts. The wizard / tool was reasonably obvious to me when I used it a year or so ago. Not sure if it can do drill downs or if it shows pins (I was shading regions by density).
Google maps will definitely allow you to plot pins (I’ve done this with lat long, but assume google will handle postcodes too) - you can set the pin colour etc so will do your drill down. It’s a good few years since I did this but presume there will be tutorials/guides that tell you how...
There's a data visualisation tool called Tableau that would let you do that. We have it at work so I don't know about pricing and such, but I suspect there are free trials to be had if you didn't want to use it long term. I know there is a Web based version too.
Doable - see http://www.hilltracker.co.uk/hill-maps/wainwright-fells-map.php for an example.
No idea how it's done though
You should be able to do it in Google Earth, though will take some manual adjustment.
Open source you can use QGIS though that isn’t an ‘easy’ option.
In Microsoft land, Power BI. The desktop software is free, import your data (excel/csv/sql etc) and a Bing map vis is built in.
I've done it in Google maps before. It was years ago though and not sure if the functionality is still available.
Quick check reveals that it's definitely still doable in Google maps.
While it may be possible in a lot of the solutions suggested.
The OP is talking about quite personal information that is almost certainly covered under GDPR and needs some thought on how to secure it...
I did wonder about this but unsure of whether just using a postcode would be an issue.
Cheers for it all so far. It will just be postcodes, nothing that could make individuals identifiable, so not linking to where I got the info etc. It will just be a bunch of random postcodes to anyone that looked.
Google Maps will do most of this, as long as you have a Google account.
Its in Your Places/My Maps. Create map. It will then have a "layer" with an option to upload data. I have simply uploaded Excel spreadsheets into this. If you have columns with your different criteria in, these can appear as a label. However, I think they would have to be in separate tables to be able to have different coloured pins.
The only thing is, the data won't be "live" to your spreadsheet, it is just a snapshot. So if you change it, you will have to re-load it to Google maps.
The only thing is, the data won’t be “live” to your spreadsheet, it is just a snapshot. So if you change it, you will have to re-load it to Google maps
Although this could possibly be automated via a Google script that would reload the data into the map when the spreadsheet changed.
Really easy with Google Earth, instructions here.
https://batchgeo.com/features/google-earth-kml/
Although this could possibly be automated via a Google script that would reload the data into the map when the spreadsheet changed.
I do this in Excel, you can launch Google Earth via the command line with the new file attached. You would need a VBA macro to do that for you though, so you need some programming ability.
I've just done this this week.
My maps.google.com (needs a Google account).
Upload spreadsheet with postcodes in.
Set location by postcode.
Job jobbed.
Mine
https://nnolscotland.blogspot.com/2020/08/map-of-outdoor-learning-and-play.html?m=1
It’s fairly straightforward to do in QGIS and probably just as easy as some of the Google Maps/Earth suggestions. Instructions here. If you need to geocode your postcodes (add coordinates), then you can use the batch geocoder here. The other option would be to use an online GIS, like MangoMaps or Mapbox. Happy to help with QGIS, if go with this option.
As an aside, the Dougal site has some Strava tools for segment exploring and viewing.
Umap is another option. Similar idea to Google My Maps etc, but based on OpenStreetMap. Can import in a variety of formats. Plenty of options to customise the map style, and icons and labels if you want.
http://umap.openstreetmap.fr/en/