How to find the center point of MULTILINESTRING, which lies on the multiline?
I have a postgis table of points, that are sitting on road centerlines (I've linear referenced them). And the second table with road centerlines themselves. The point table also has a field roadid and ...
The current approach that I am using to load a csv file into a PostGIS enabled database on a server is the following: -- create table CREATE TABLE points( id int, lat double precision, lng double ...
I have a PostGIS db, and I want to find the points that lie within some region (a bounding box). I have two sets of coordinates, from which I can get all four rectangle points that form the box (if ...
Estou trabalhando com linhas em estradas representadas por uma grande grande quantidade de pontos em sequencia. Uma vez que colocar o nome de todos os pontos tornaria a identificação impossível, ...