08 April 2009

Super Lightweight Spatial Database [SpatiaLite]

Superlight Spatial Database [SpatiaLite]

After a quick review of 'Free' Open Source GIS software. Had a look at Spatial Databases
There is a SpatiaLite - and it's easy to use 1,2,3 Go! (five minute guide)

What can you do quickly?
MBR [Minimum Bounding Rectangle] Example

What is an MBR? Above graphically shows the Bottom Left and Top Right of a rectangle using this as an extent to find spatial features within.This is one of the most basic ways to find something spatially.
More on MBR [Minimum Bounding Rectangle] Function [Wiki]

Spatialite MBR SQL Function
SQL request to find all features within the MBR

*Data used was OpenStreetMap in shapefile format
Not saying this is best spatial database out there but is certain to be the quickest to download,install and load data within it.

* Enhanced GUI tool v1.2
* SQL mathematical functions
* EXIF-GPS geometry-handling functions
* Virtual Table module VirtualNetwork
* Supporting routing [Dijkstra's Shortest Path algorithm]
* Supports importing and exporting to shapefiles [big plus]
* Supports standard WKT and WKB formats

Tutorials and Documentation to get you started.

Why Super Lightweight? [8.3mb windows application] that's why.

Related links:
http://www.gaia-gis.it/spatialite/ [Main Homepage]
http://groups.google.com/group/spatialite-users?pli=1 [Google Group - Spatialite]

http://www.geofabrik.de/data/download.html [Open Street Map data in shapefiles]

http://www.gaia-gis.it/spatialite/binaries.html [Applications for Mac,Windows,Linux]
http://www.gaia-gis.it/spatialite/resources.html [Sample Databases, Routing, Test Scripts]


Labels: , , , , , ,


Post a Comment

Links to this post:

Create a Link

<< Home