Does PostgreSQL implement Geospatial relationship queries?

postgresql gis geospatial
pearcewg picture pearcewg · Mar 24, 2009 · Viewed 9.8k times · Source

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?

Answer

vartec picture vartec · Mar 24, 2009

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

Related questions

Distance between 2 POINTs in Postgis in srid 4326 in metres

This is probably a simple question, but I'm not very good at PostGIS and don't fully grok all of this. Basically I have a table (nodes) with a POINT column (point). I have created an index on this column create …

Read More
GIS: PostGIS/PostgreSQL vs. MySql vs. SQL Server?

EDIT: I have been using Postgres with PostGIS for a few months now, and I am satisfied. I need to analyze a few million geocoded records, each of which will have latitude and longitude. These records include data of at …

Read More
SQL query for point-in-polygon using PostgreSQL

I have the following simple table: CREATE TABLE tbl_test ( id serial NOT NULL, poly polygon NOT NULL ) WITH (OIDS=FALSE); I then try to insert a row with a polygon: insert into tbl_test values(1, PolyFromText('POLYGON((0 0, 10 10, 10 0, 0 0))')) And …

Read More