Skip to content

Instantly share code, notes, and snippets.

@kashif

kashif/geodatabases.md

Created May 27, 2011 10:09
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 3 You must be signed in to fork a gist
  • Save kashif/994992 to your computer and use it in GitHub Desktop.
Save kashif/994992 to your computer and use it in GitHub Desktop.
Download ZIP
GeoDatabases - a discussion
Raw
geodatabases.md

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