I started the SpatiaLite Google Group a little over a year ago and since then, it’s grown a lot! I’m really glad to see such an interest in this awesome technology and one day I hope to see it as a strong and viable alternative for the personal GeoDatabase. I know that there is demand for SpatiaLite because once upon a time I posted something on the GeoPDF blog and more traffic came to the site because of that post than the actual GeoPDF.
We are dead smack in the middle of the smart phone revolution which means that most if not all cell phones that you can purchase these days also do a multitude of other tasks. These tasks can range from a simple calendar that links to your Google account to a full blown video game that you can interact with other smart phones through.
My interest, of course, is in the advantage of being able to use a phone as a light-weight mapping device. iPhone, Android, and Windows Mobile all have pretty nifty mapping applications from both Open Source and COTS sources. I’ve seen on the SpatiaLite Group that users have successfully deployed this database technology on the iPhone and most recently on the Windows Mobile platform. Please see the excerpt below…
Firstly, I love this open source spatial DBMS and thanks Alessandro
for developing this marvelous program. I would like to contribute my
personal effort by sharing a set of workable Spatialite DLLs for
Windows Mobile 5 smart device. The binary files have been installed
and test with a number of VB2005/8 smart device applications.I have produced two sets of binary files (one set is compiled with
Proj 4.6.1 only and the other set is compiled with Proj 4.6.1 and GEOS
3.1.0. The link http://www.gaia-gis.it/spatialite/spatialite-sql-2.3.0.html
illustrated the differences). It took me quite a lot of time to figure
out how to make and compile GEOS for WM5 environment. The DLLs are
compiled with Microsoft VS 2008 Professional and the target device is
WM5 with .NET Compact Framework 3.5.The Mateusz Loskot (http://mateusz.loskot.net/) blog is a good
reference site to consult when compiling Proj4 and GEOS 3.
System.Data.SQLite is a good SQLite ADO.NET data provider to work on
when developing your own .NET database application both for desktops
and smart devices. Thanks Robert.At the moment, I only have time to share the binaries without
explaining the make and build procedures. Once I finish the tidying
and cleanup, I will share the modified/edited sources with Microsoft
VS solution and projects.The link for downloading the pre-complied DLLs is http://myweb.polyu.edu.hk/~lsykshea/public
Let’s face it…our cell phones are now more powerful than our first computers were and they are getting much, much better all the time so why not push to do more than just view your spatial data on them. Why not start to ask questions from your data while on? We *can* do this without dropping a lot of coin on COTS solutions…
More from Adam Estrada
- Open Street Map (take 1)
- WordPress as a CMS
- ESRI FlexViewer and Error 1065
- SpatiaLite 2.4.0
- jQuery and Prototype Overview
Adam Estrada Recommends
- Generic Host Process for Win32 Services and internet stops (MtaraM)
- Jailbreaking and unlocking your iphone for T-mobile (tretre)
- Windows 7 tricks and secrets (MtaraM)
