05/07/2009 13:29
Licensed under Creative Commons Non-Commercial Attribution Share-Alike
05/07/2009 13:29
Limitations of the shapefile There are many well documented limitations of the Shapefile ESRI has a whole page on why you should not use shapefiles to store geoprocessing results
05/07/2009 13:29
Other spatial possible formats (Common Recent formats in Bold) Databases XML & Other web oriented data exchange You want a database But maybe you don't want to run a server, or need to be disconnected You want something compact and easy to give to someone A single file with everything
05/07/2009 13:29
Intro to what Spatialite is: What's sqlite A small and fast single file SQL database How common is SQlite? It's all over the place, in use by companies big and small It's embedded in all sorts of devices like the iPhone Logos of know companies and projects using sqlite
05/07/2009 13:29
What is Spatialite Builds on sqlite Adds the ability for spatialite to read and understand spatial data Adds a tool set to do spatial analysis
05/07/2009 13:29
What can you do with spatialite Importing data to spatialite Loading data (Shapefile, csv) Exporting data (Shapefile, csv) Normal GIS operations Reproject Geoprocessing Area and Distance Calculations Standard SQL Summation, Grouping, Sub-select, Joins Image contains a the list of all functions currently added by Spatialite
05/07/2009 13:29
How do you get spatialite Executable self contained apps ready for download, command line, gui and libraries for programming How do you use spatialite Command Line Spatial Lite Gui Write your own Program
05/07/2009 13:29
Things special about spatialite Full query ability Arc limits you to using their interfaces in order to manipulate the database, you can't run true spatial queries directly on the database using SQL Why is this a problem? The classic example of many to one where the many is attribute data and the one is spatial data. Full control over indexing You can store multiple projections in the same table Making it fast (7 hours in GIS to 5 minutes.) Memory caching of indexes Loading tables into RAM Loading databases in RAM Want 5 different attribute table for the same layer Many to Many, Many to one
05/07/2009 13:29
Interoperability OGC compliance OpenGIS Defined http://www.opengeospatial.org/standards Scripting from Python Java .Net Ruby php etc.
05/07/2009 13:29
In the computer business a stack refers to a collection of several software packages (programs) that you use together in order to solve a problem. Neat things you can do: Connect from R Run a query and do some stats Open in QGIS Cutting edge, use it just like a shapefile
05/07/2009 13:29
Where is sqlite going Adding support for Raster Storing rasters in sqlite Cataloging rasters in sqlite Potential Stumbling Blocks No Compression, XML is really designed for exchange, but people don't seem to like downloading in one format and being forced to convert for usage Complexity of Use Will Proprietary Applications officially support usage Is it a Data Storage, a Data Management or a Data Analysis tool? Or all of the above?
05/07/2009 13:29
Acknowledgements