Comments on: Spatial data in SQLite

By: Tyler

Tyler — Tue, 09 Jun 2009 17:10:32 +0000

ADRIAN: I don’t know about virtualshape, but you can convert shape files to SQLite using GDAL/OGR command line utility:

ogr2ogr -f sqlite output.db input.shp

By: adrian

adrian — Sun, 08 Mar 2009 08:32:45 +0000

hello
i want to ask, how to convert shp to *.db with virtualshape ???

thank’s for the answer…

best regards
adrian

By: Alexey Pechnikov

Alexey Pechnikov — Thu, 03 Jul 2008 19:16:21 +0000

Now SQLite support spatial index R-tree.

See
http://www.sqlite.org/draft/doc/rtree.html

By: pb

pb — Thu, 29 May 2008 07:42:04 +0000

If applications like qgis supported sqlite use just easy like esri works with geodatabase. Then SQLite can grow as opensource geodatabase alternative.

By: Vidar Hokstad

Vidar Hokstad — Fri, 18 Apr 2008 10:02:02 +0000

It looks great to me too. Of course there’s the caveat that SQLiteGeo doesn’t support spatial indexes, so many types of operations will be _slow_ for large datasets. To manipulate shapefiles it seems perfect, though.

By: Chris Condit

Chris Condit — Fri, 18 Apr 2008 02:31:15 +0000

Just wanted to mention that GDAL / OGR supports basic SQL Queries, as well:
http://www.gdal.org/ogr/ogr_sql.html

By: Jeremy Cothran

Jeremy Cothran — Thu, 17 Apr 2008 17:44:06 +0000

I also recently learned of SQLiteGeo which this link references and was glad to discover it since I’ve got an geospatial observations oriented schema at http://code.google.com/p/xenia/wiki/XeniaPackageSqlite which this solution fits into similar to PostGIS for PostgreSQL earlier.

Now if I just had a SQLite driver for Geoserver - I thought about using JDBC to work between Sqlite and Geoserver, but I’ve heard the JDBC connection is very slow.

Thanks
Jeremy Cothran

By: Martin Davis

Martin Davis — Thu, 17 Apr 2008 04:26:45 +0000

For a different application offering the same functionality - and more, check out my project JEQL: http://tsusiatsoftware.net/jeql/main.html

In JEQL this same example case would look like:

t = null;
ShapefileReader t file: “counties.shp:;
t2 = select sum(voters) as total_voters, state_name
from t
group by state_name
order by total_voters desc;
Print t2;

JEQL has the advantage of a wide set of spatial functions (as well as lots of others), and the ability to export to many different formats (such as shape, KML, etc).