Linked Questions

2
votes
1answer
489 views

Find nearest point given coordinates from another table [duplicate]

So I have two tables, one table is called stores which has the name of the store as well as the geom column that contains the coordinates for the stores. The other table is customers which has the ...
6
votes
3answers
192 views

Drawing lines to nearest point

I have two point layers, one with telecom towers and another with secondary schools. I have used the NN-join plugin to find the nearest tower from each school, and calculated the distance between. The ...
5
votes
4answers
211 views

Finding distance between buildings and nearest road using QGIS?

I am very new to working with GIS data. I am currently using the QGIS tool to work with the data. I have two datasets: Buildings - polygon shapefile with information about different buildings in a ...
4
votes
1answer
1k views

PostGIS nearest point with LATERAL JOIN in PostgreSQL 9.3+

I need to obtain on each element on one table the closest point of another table. The first table contains traffic signs and the second one the Entrance Halls of the town. The thing is that I can't ...
1
vote
1answer
2k views

Using st_distance to calculate shortest distance between a table with point geometry to a table with multipolygon geometry

I'm trying and failing to do a calculation of the shortest distance for each point in a point geometry table (15000 records) to the nearest polygon edge in another table (170000 records). The end ...
1
vote
1answer
871 views

Nearest Neighbour function

I'm trying to create a function which calculates the nearest neighbors under a certain length in a table s_1 an stores them in an output table. This is what I've got so far: CREATE OR REPLACE ...
1
vote
1answer
505 views

Where to store lat/lon data with additional informations?

I have huge database of lat/lon GPS coordinate points. For every point, I have several other variables (height, surface type, temperature, pressure...). Also, data will be changed every day and old ...
2
votes
1answer
280 views

Fastest matching on nearest point

I am a total GIS noob and am trying to read weather data from a PostGIS database. The tables contain data points consisting of a geometry, a timestamp and the actual observed variable. The tables are ...
3
votes
1answer
107 views

Calculating nearest neighbor within each polygon using QGIS?

I have 3 layers: world map divided into countries; layer of points representing cities; layer of points representing conflict events (e.g. firefight). My goal: For each city, calculate the nearest ...
0
votes
1answer
173 views

Pois_close POINT with postgis and rails

I try to use postgis in rails and write my first request. I would like have : - the nearest points of another point (but without this point) - the name and the distance between the both In my model I ...
1
vote
0answers
49 views

find nearest point to a point in another table

This similar, but not quite the same as this question. I need to pick, regardless of distance, the closest 'n' points to a given point in another table, using postGIS. Imagine a table with city ...