Spatialite Cgs 2009

  • Uploaded by: Alex Mandel
  • 0
  • 0
  • April 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Spatialite Cgs 2009 as PDF for free.

More details

  • Words: 571
  • Pages: 12
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

Related Documents


More Documents from "topcat"