Skip to content

Instantly share code, notes, and snippets.

Embed
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
You can’t perform that action at this time.