Jeremy Smith's blog

Entry Is Labelled

Mapping Crimes on Campus

Mapping Crimes on Campus

Now that's cool.

Brian, how are you mining the data off of crime log and converting it to GPS coordinates?


  1. gravatar

    First it tries to grab the wiki page by the location name. This is desirable over grabbing markers.php because the location is often abbreviated (the BRB, for example) and our wiki has lots of redirects for such abbreviations.

    If the wiki page doesn't exist or isn't geocoded, it uses a regular expression to search for a street address (or even just a street name). If found, it queries Google's geocoder and only uses the return value if it's an exact match.

    So there are a lot of locations missing coordinates from these two methods. I'm going to geocode more locations on the wiki, and probably manually do the rest (things that wouldn't be useful as wiki pages). Or let users give coordinates to the missing ones.