SQLite, in its 'default' code configuration, contains enough functionality to be a replacement for a shapefile. However, there is one very significant feature that is wasteful to ignore: spatial indexes. In order for the SQLite RTree to be used, it needs accompanying code that understands the geometry data inside the database.
And that, quite simply, is what I have here: http://www.baboonz.org/shapefile2.php Only 1269 lines of code, liberally licensed. -------------------------------------------------------------------------------------------------------------------------- The content of this e-mail message and all attachments thereto (`this message`) does not necessarily reflect the views of IMQS Software (Pty) Ltd (`IMQS`). Before acting on the contents thereof, the recipient should verify that the originator has the appropriate delegated authority. In the event that this message has not been appropriately authorised in terms of IMQS`s delegation of authority, or in the event of the personal usage of IMQS`s e-mail facility, IMQS will not be liable for the contents of this message. 1. This message may contain information which is confidential, private or privileged in nature and subject to legal privilege. If you are not the intended recipient you may not peruse, use, disseminate, distribute or copy this message or its attachments. Please notify the sender immediately by e-mail, facsimile or telephone and thereafter return and or destroy this original message. 2. Please note that the recipient must scan this message and any attachments for viruses and the like. IMQS accepts no liability, damage or expense resulting directly or indirectly from the access of any message or it`s attachments or the use thereof. 3. IMQS reserves the right to monitor, read, filter, block, delete, use and act upon any incoming or outgoing message or it`s attachments sent or received by the employee, including hyperlinks in such message attachments and files copied or saved, automatically or by the employee on IMQS`s equipment. -------------------------------------------------------------------------------------------------------------------------- Please report email abuse / misuse to itsupp...@imqs.co.za _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users