Tag Archives: spatialite

The SpatiaLite Cookbook

Posted on 2011/01/28 by scruss

Alessandro‘s new SpatiaLite Cookbook is rather good.

Posted in GIS | Tagged , | Leave a comment

current tools of my trade

Posted on 2010/03/23 by scruss

Mark asked: What kind of GIS software are you using? Well, since you asked:- SpatiaLite: spatial awesome built on SQLite. I love it because I don’t need to play DBA. QGIS: for maps ogr: for file format futzing proj: for … Continue reading →

Posted in Uncategorized | Tagged , , , , , | Leave a comment

ward maps: kinda working, sorta

Posted on 2010/03/02 by scruss

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 →

Posted in GIS | Tagged , , , | Leave a comment

reblog: finding things that are inside other things

Posted on 2010/02/28 by scruss

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 →

Posted in GIS | Tagged , | Leave a comment

tale of two cities: coordinate reference systems, and what on earth is the maywood tot lot?

Posted on 2010/02/26 by scruss

For reasons that are not particularly clear, the Toronto.ca|Open data is in two different coordinate reference systems (CRS), MTM 3 Degree Zone 10, NAD27 (EPSG 2019) and UTM 6 Degree Zone 17N NAD27 (EPSG 26717). This confuses QGIS even if … Continue reading →

Posted in GIS | Tagged , , , , , , | Leave a comment

my first real spatial query: finding nearby libraries

Posted on 2010/02/21 by scruss

Me and Catherine are quite partial to libraries. I’m going to use the address points database we made yesterday to find the libraries within 2km of a given address. It’s not a very useful query, but it shows the very … Continue reading →

Posted in GIS | Tagged , , | Leave a comment

a simple geocoder for toronto

Posted on 2010/02/20 by scruss

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 →

Posted in GIS | Tagged , , , , , , | 2 Comments