I'm interested in GIS and Open Source solutions for that field. Mainly I'm looking for simple solutions, not exactly for enterprise.
I know PostgreSQL/PostGIS tandem and it works very nice but sometimes it is to big and complex for use.
I wonder if it is reasonable to implement some GIS functionality in SQLite. What I mean GIS functionality ?
So, simply SQLite could act as a GIS data storage format just as ESRI Shape (consists of 3 necessary files: DBF table, SHP with vectors/list of vertices and SHX which is an spatial index).
It could be great one cold store geometries encoded in OpenGIS Well-Known-Binary format directly in the SQLite tables. There could be descriptive data and geometries stored in the same table from the user's view. Then only one SELECT..FROM..statement could retrieve all necessary GIS data. There could be also some geometry computational functions implemented i.e. functions for length or area calculations. The GIS topic is very complex obviously but now I only would like to ask you as SQLite implementors and experienced users if it could be a good way to develop such solutions for SQLite. Is SQLite a good choice ?
Kind regards
-- Mateusz Łoskot, mateusz at loskot dot net GNU/Linux (Slackware 9.1) http://counter.li.org #220771
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
