Tag Archives: sql
The SpatiaLite Cookbook
Alessandro‘s new SpatiaLite Cookbook is rather good. Alessandro’s new SpatiaLite Cookbook is rather good.
finding the nearest thing to another thing
Something I used to have to do a lot was to maintain a table of the nearest houses to prospective wind farm layouts. While the list of houses didn’t change very much, the layouts did. I came up with an … Continue reading
but where am i, really?
In my first post I asked where am i? The gps in my phone said I was standing at 43.73066°N, 79.26482°W. In real life, I was standing at the junction of Kenmark Blvd and Chevron Cres. With the Open Toronto … Continue reading
Finding the exact geographic centre of Toronto
Spacing has alluded to it. The Ontario Science Centre makes bold (and incorrect) claims about it. But here’s the real deal. If you consider Toronto to be defined by its city wards, the centre of Toronto lies at 43.725518°N, 79.390531°W. … Continue reading
ward maps: kinda working, sorta
Now I’ve sorted out formatting the labels and scraping the data, I should be almost ready to produce a pretty map. Well, almost. The DBF component of a shapefile seems somewhat resistant to adding a column, and SQLite doesn’t seem … Continue reading
reblog: finding things that are inside other things
My post diary of a geonumpty to my main blog is really what got me started thinking about abstract geographic data. In it, I (with a lot of external help) develop queries to count points in areas with the same … Continue reading
a simple geocoder for toronto
I’m going to use SpatiaLite and the Toronto One Address Repository to try some simple geocoding. That is, given an address, spit out the real-world map coordinates. As it happens, the way the Toronto data is structured it doesn’t really … Continue reading