Skip to content

Instantly share code, notes, and snippets.

@berb
Forked from kashif/geodatabases.md
Created May 27, 2011 11:29
Show Gist options
  • Save berb/995075 to your computer and use it in GitHub Desktop.
Save berb/995075 to your computer and use it in GitHub Desktop.
GeoDatabases - a discussion

GeoDatabases

What is a GeoDatabase? and how is it diff from a regular db

  • Stores geometries
  • multi-dimensional
  • R-Tree indexing (Query planner uses it?)
  • projections
  • Supports Datums ?
  • Vector and raster support
  • Spatial Analayis (topo, buffer, intersection, etc)

Options for storing geodata

Open Source

  • PostGIS

  • CouchDB

    • GeoCouch/CouchBase (GeoJSON support, no high-dimensional indices, only 2d)
    • CouchDB-Lucene (Numeric Ranges, multidimensional, no arbitrary shape support)
  • Spatialite (in production?)

  • MongoDB ...

  • Ingres

  • Neo4j

  • MySQL :-(

  • Solr - basic points?

  • Elastic Search

Propriotry

  • Oracle
  • MS SqlServer
  • Esri Spatial database (only access?)

Cloud based

  • Fusion tables
  • SimpleGeo (Casandra) Quad-Tree
  • MongoDB - Geodata not shardable?

Concerns in Distributed databases

  • aggrigating distributed datasets
  • standard for simple queries?
  • geo indexing and sharding

What are folks using and why

  • Mobile

    • Spatialite
    • Tile Map Service (TMS)
    • TileMill to create Sqlite index
  • Web

  • Desktop

What are the advantages and disadvantages

What do you find

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment