17

My company is looking at different database providers, and how they implement Geospatial queries to get distances from a Lat/Long for a number of records.

We are going to investigate PostgreSQL as a potential database platform.

  • I've heard that PostGRE implements Geospatial queries. Is this correct?
  • Is there a good reference somewhere that gives info on the implementation?
vartec
  • 131,205
  • 36
  • 218
  • 244
pearcewg
  • 9,545
  • 21
  • 79
  • 125

2 Answers2

35

It's PostGIS. For reference you have manual, wiki and more...

Jim
  • 568
  • 1
  • 7
  • 14
vartec
  • 131,205
  • 36
  • 218
  • 244
12

If you want to spatially enable a PostgreSQL database you can do so with PostGIS, it's compliant with the Open Geospatial Consortium's Simple Features Interface Standard for SQL too.

ninesided
  • 23,085
  • 14
  • 83
  • 107