3
votes
1answer
88 views

polygon from exterior points

How to convert points data to polygon, so as to form polygon from exterior point as shown above
1
vote
1answer
436 views

From a trajectory of GPS points to a multiline segment

Given a trajectory as a sequence of GPS points I would like to create a smooth linestring representing a path where a car drove. The data is stored in postgresql: the input trajectory in a table, ...
5
votes
1answer
277 views

How to draw a line between two places with via-points?

I have prepared a GPS-tracking dataset, currently consisting of one table with stopping points and one table with the raw GPS-points. The first table contains a column for any stopping point showing ...
3
votes
3answers
1k views

How to extract POINT from a [LINE|MULTILINE]STRING

I'd like to create a vectorLayer in QGIS to display all the points that form a LINESTRING or a MULTILINESTRING stored in a PostGIS DB. I think that I need to transform all points of LINESTRING (or ...
3
votes
2answers
789 views

Generate non-overlapping shapes from a buffer

I have a collection of points, and I need to generate shapes around these points. Let's assume that these points are locations of offices and that the shapes are the 'area of responsibility' around ...
2
votes
0answers
229 views

How can I create a parallel lines in a MULTILINESTRING table using Postgis? [duplicate]

Possible Duplicate: How to create one-sided buffers or parallel lines in PostGIS? I need to make parallel lines on a MULTILINESTRING table, similar to st_buffer, but that the result come be ...
5
votes
3answers
1k views

How to create spider diagrams (hub lines) in PostGIS?

I'm rather new to PostGIS but I have done a lot of reading. One thing that I have been searching for is a function that allows users to create a "spider diagram" (also called "desire lines" or "hub ...
12
votes
4answers
3k views

How to create one-sided buffers or parallel lines in PostGIS?

I'm looking for a way to create so-called one-sided buffers or parallel lines in PostGIS. Example: 1. buffer, 2. one-side, 3. both-sides I've found some discussion on the mailing list from 2009 and ...