Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
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

  • GeoCouch

  • 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