Hi All,hello,
I do that in my application using shapelib and sqlite.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.
I also do that, geometry is stored in ascii, I would like to move to uuencode or something like that to avoid the decoding overhead.
You cannot avoid the spatial indexing problem, I build a quad-tree index to filter shapes.
Performance are good on win32 but not on windowsCE.
I firmly believe so.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 regardsregards
Noël Frankinet
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
