Linked Questions

1
vote
0answers
38 views

KNN with “Big Data”

I have a point dataset of over 30mill records and I am trying to select the closest 5 lines to each point. Reading this post there seems to be two methodologies Using <-> however as I want to ...
2
votes
1answer
70 views

Calculating distance between every entry in Table A and nearest record in Table B using PostGIS

I am new to PostGIS. How do I calculate the distance and direction between every site (approx 30,000 record) and the nearest entity in a gazetteer (approx 300,000 records)? Ideally a separate table ...
3
votes
1answer
375 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 ...
6
votes
4answers
946 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 ...
6
votes
3answers
390 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 ...
0
votes
1answer
281 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 ...
2
votes
1answer
338 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 ...
2
votes
1answer
536 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 ...
2
votes
1answer
946 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 ...
3
votes
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 ...
5
votes
1answer
2k 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
521 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 ...
1
vote
0answers
50 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 ...