5
votes
2answers
282 views

How to detect duplicates and keep only one?

I've got a table with lots of points (200.000). Some of them are duplicates (not exactly but e.g. a metro station has eight entrances) and I want to keep only one of these metro entrances. I am able ...
0
votes
1answer
37 views

PostGIS: Querying a record table and explanatory table

Basically I have two tables one containing a collection of records and one table that contains extra info about features in the first. i.e Records Table: GID SITE SPECIES GEOM and the second table ...