Feel free to accuse me of becoming a little bit too interested in mashing, but I can't help it, there are just too many cool mash-ups out there that once I started looking I couldn't stop 'accidentally' finding them...well, it's a legitimate part of my job, right...? One mashup that's relevant enough to Nestoria's antics to justify it being mentioned here is 'How Safe Is Your Suburb?, a map based mashup of NSW police data, that could help you choose the safest place to live. This is what Andrew Naish, one of the people who built it, had to say about it, and about other aspects of his work in the geospatial sphere, when I interviewed him for the blog:
Hi Andrew, welcome to the digital couch. Let's start by talking about the couple of mashups you built for the MashUp Australia competition.
Space-Time Research, who I'm a GIS Technical Lead Developer for, entered two mashups: one was 'How Safe Is Your Suburb?' and one was the 'KML Cruncher'.
For 'How Safe Is Your Suburb', we had a choice of data sources from data.australia.gov.au and realized that most of the data sets did not contain geography variables. We wanted to be able to visualize data on both a chart and a map, and the NSW Crime data had interesting information both geographically and over time. We ended up mashing the NSW crime data with an ABS Local Government Area (LGA) mapping file to present a thematic map in Google Maps. We were able to categorize crime into different types, and our map shows how many crimes were committed in certain areas by category (e.g violent crime vs. white collar crime) and for either all years of the survey or individual years. Once you've queried the one you want, you can save it as a pdf, image or save the data associated with it for sharing, and you can comment on the data.
Rather than simply displaying the raw NSW Crime data, which is what many other competition entrants did, we wanted to come up with a story to do with the data that would be interesting for potential users of the application - citizens, researchers, policy makers, government and police. So we develop four key views:
* The first enables users to view the data on a map to see a visual representation of offence by type by year by Local Government Area. The user can choose to hone in on different areas, types of crime or time periods depending on where their interest lies.
* The next is a crime breakdown by year pie chart that shows which crimes are most prominent for a given year.
-
- Crime Breakdown Pie Chart
* Crime in My Suburb shows a breakdown of crime over time and you can select the crime type(s) and suburb(s) to include.
* The last view shows the most dangerous suburbs, the top 10 suburbs showing number of offences. The user can select the offence type and the year of interest.

- 10 Worst Suburbs for Crime
The KML Cruncher submission wasn't actually a map per se – it's basically a tool that allows people to easily create web maps from one of the most common geospatial digital formats - the ESRI Shapefile format. Most organizations dealing with geospatial data (especially government) use this file format, but unfortunately it's not very web friendly and can be a little difficult to work with. What the KML Cruncher does is two main things:
* Converts an ESRI (polygon) shapefile format into KML (which is more web friendly format).
* Generalises (simplifies) the polygons according to a specified tolerance so that the resulting KML is small. Smaller KML files mean faster loading and faster draw times.
-
- The KML Cruncher: More impressive looking when it's working
We settled on the idea out of necessity -- at Space-Time Research we are always manipulating geospatial data in to make it work in Google Maps, but we were mainly using high-end GIS products like the ArcGIS suite to do it. You kind of need to know what you're doing in order to convert a Shapefile to KML using the ArcGIS suite, but KML Cruncher simplifies the process so that hopefully anyone dealing with the shapefile format can generate a KML file and use it in Google Maps or other mapping applications.
Cool ideas. How difficult would it be to roll 'How Safe is your Suburb' out across the whole country and what would the challenges be?
It would be easy, if we can get the raw data. We would expand the application to mash in Australian Bureau of Statistics population data, and include socio-economic and demographic variables.
One of the aims of that competition was to promote open access to geospatial data - how much of an issue is access to data for people wanting to play around with maps?
It's a big issue - and one that hopefully the KML Cruncher will alleviate somewhat. As I mentioned earlier, most of the geospatial data people want to use on the web is stored in ESRI shapefile format inside internal networks, if you want to convert it into a web friendly format, and (more importantly) make it load nice and fast, there are no tools out there that can do it like the one we have created (trust me I've looked).
Thanks - I'm sure we'll find that useful too!
I think the other issue is the lack of a centralized datastore for geospatial data in a web friendly format - what I'd really like to see is access to any country's geographic hierarchy (like the Australian ASGC) in a wide variety of web formats (KML, JSON, GeoRSS, etc) – that's when we'll start to see some really interesting mashups. Unfortunately there are some hurdles though - namely data integrity (i.e. people need to know exactly where geospatial data has come from so that it can be verified as being genuine) and also there needs to be a simple (and I can't stress the word 'simple' enough) standard developed for the geospatial attributes (i.e the attributes describing the geographic boundaries) so that GIS engineers can interoperate with it seamlessly.
I often ask this question to the people I meet on my quest for interesting mashups: but what are some of the most interesting uses for geospatial data have you come across?
I'd say one of the weird cases was when I was working for Webraska Australia. We were heavily involved in mobile mapping (handset navigation, maps for your mobile, etc) - one of the projects we went for was what we (internally) dubbed 'The Granny Tracker' - it was basically a mobile device with a button that an elderly person could push to alert a central office to exactly where the person was. Great idea, might have been a little intrusive though.
I've also got some really interesting stories around location intelligence when I used to work for ESRI Australia contracting to the Australian Defence Force, but I'm not going to share those!
What do you think people will be doing with geospatial data in the future?
I think mobile location intelligence is going to be very big in the future - we're going to see a lot of work involving geospatial awareness, and the first commercial use will be around advertising. For example, we'll see applications that track your location and determine target adverts based on your profile and where you are.
In terms of slightly more productive uses I think we'll see a general shift toward more openness of the geospatial data from government organizations, and ease of access, which will in turn allow us to really dig into more spatial analysis - I'm thinking mainly correlation analysis to start with. That is, we'll be able to determine answers to questions like, "Is there a correlation between the number of obese children in an area that also has a high number of fast food outlets?" Such questions can be answered easily with a map that is drawing from multiple data sets.
Also I am 100% sure there are many correlations between datasets that we simply don't know about, there are ways to determine correlation coefficients programmatically so we could, theoretically, find answers to questions we could never dreamed of asking ourselves.
I've got the impression from the people I've spoken to that the geospatial and mapping community in Australia is a pretty interesting space to be in, what are some of the projects the Australian community is engaged with?
Yes, the geospatial community is quite vibrant here, albeit small compared to other countries (everyone knows everyone else in the GIS sector!). There is wide range of projects being undertaken down here, which keeps me interested.
At Space-Time Research, mapping is one of the core outputs for our data dissemination and visualization products. We're finding more and more government agencies want to disseminate their data publicly, especially now that the Government 2.0 movement is in full swing. For example, we've worked with the Department of Transport on their VISTA 07 application, and the Australian Bureau of Statistics CDATA Online and Table Builder products.
I know that one big challenge agencies are having is dealing with privacy and 'confidentialising' data. We've worked out ways to handle that and all of our products incorporate the security methods, so hopefully as our products get used by more and more agencies it won't be too much of a challenge for too long.
Thanks very much for sharing, with me especially – hopefully that's my map fix for today! I think you might have been overly hard on the Granny Tracker...I can see several different potential uses...
Andrew graduated from the RMIT Geomatics department 12 years ago and is now a GIS Technical Lead Developer at Space-Time Research. He also dabbles in making online games and playing music (but says his music isn't quite popular enough to give up his day job just yet.).