Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Spatial database references

 
Harish Shivaraj
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all.

Im very new to realm of databases. And im trying to put together a database to store parking location in a city. And I need spatial database, so that i could query something like give me all the parking location in 1km range and that sort of thing.

So far ive failed to find a decent book which explain how to achieve the things i want or a good reference

books and links which may have helps you in the past would be much appreciated.

Thanks very much
 
Christian Dillinger
Ranch Hand
Posts: 200
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have a look at http://www.postgis.net/ (if you plan to use Postgres/Postgis) or google for "oracle spatial" (if using Oracle). Or if you use Hibernate have a look at www.hibernatespatial.org to see how spatial queries work within hibernate. Hibernatespatial supports differenz spatial dialects.
 
Harish Shivaraj
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks very much. Im using mysql and looking at mysql spatial. Is that a good choice?
From you reply I noticed you never mentioned mysql. Was wondering if there's a reason behind it.

Thanks
 
Christian Dillinger
Ranch Hand
Posts: 200
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We only use Oracle and PostGIS in production. For hobby projects I use H2 (or plain shapefile datastores or gml), so no need for MySQL.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic