• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

Spatial database references

 
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 200
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 54
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
reply
    Bookmark Topic Watch Topic
  • New Topic