1
vote
2answers
166 views

How to find the center point of MULTILINESTRING?

How to find the center point of MULTILINESTRING, which lies on the multiline?
1
vote
2answers
387 views

How to offset point perpendicular to line direction in PostGIS

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 ...
2
votes
1answer
197 views

How to create a point table from a remote csv file?

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 ...
6
votes
2answers
2k views

PostGIS: Find points that lie within a set of coordinates

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 ...
5
votes
3answers
2k views

Is there a way to label points in a regular interval in ArcGIS 10? [SOLVED]

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, ...