Questions tagged [st-makeline]

A function that forms a line from a set of points (or other geometries).

Filter by
Sorted by
Tagged with
0
votes
0answers
10 views

visualising edge_graph from list pgr_dijkstra graph [duplicate]

I am creating a query that finds the shortest path from dangerous crossing nodes to hospitals (many-to-many). I have the proper output from pgr_dijkstra, with output as follows seq | path_seq | ...
0
votes
0answers
19 views

visualising edge_graph from list pgr_dijkstra graph

I am creating a query that finds the shortest path from dangerous crossing nodes to hospitals (many-to-many). I have the proper output from pgr_dijkstra, with output as follows seq | path_seq | ...
2
votes
1answer
91 views

create lines from points table

I have a point table I have sorted by mmsi (it is the identifier) and by datetime columns. mmsi numeric, x1 double precision, y1 double precision, datetime timestamp without time zone, geom ...
0
votes
1answer
56 views

How to Use ST_MakeLine query in leaflet to connect to Carto

I want to run in leaflet a query that works in carto Builder to connect points in a line: SELECT ST_MakeLine(the_geom_webmercator) as the_geom_webmercator, min(cartodb_id) as cartodb_id FROM my_table ...
1
vote
0answers
46 views

How to obtain a live route on a carto map? [duplicate]

My main goal is to build an app that send lat lon from my smartphone to my carto (postgis) database and show the route "live" (in real time) as a line and not as a lot of points. i am able to save ...
1
vote
0answers
243 views

What to add as “measure” to a linestringM in PostGIS?

I am kind of new into the GIS world. I have a couple of GPS data in a CSV file as LonLat coordinates. I used PostGIS to create points from those coordinates using ST_MakePoint(). Then I tried to ...
4
votes
1answer
162 views

QGIS make lines with offsets of y and azimuth from source and target coordinates

I'm very new with QGIS and currently stuck with such problem in my work. Maybe some one knows how to help me? I have made two separate layers. Database layer with sites and antennas, containing ...
2
votes
1answer
498 views

PostgreSQL create line from points

How do i create a linestring from points sort by date in PostgreSQL? I tried: SELECT observations.id, ST_MakeLine(observations.geom ORDER BY observations.date) AS newgeom FROM observations ...
1
vote
0answers
23 views

PostgreSQL points to line error [duplicate]

I have GPS locations with date. These are points. I want to convert the points to lines, sorted by date. Using PostgreSQL Tried: SELECT observations.id, ST_MakeLine(observations.geom ORDER ...
2
votes
2answers
230 views

PostGIS MakeLine issue

I am using GPS coordinates and I am trying to create lines (routes) from lon,lat. I create a geography column from my point and then I create the line as following: ST_MakeLine(point_geom order by ...
3
votes
1answer
216 views

Displaying lines in QGIS from ST_MakeLine() not working with UPDATE, but works with CREATE TABLE

When using UPDATE to create geometries based on the SCHNUM (school number) of students to their attend school, not all the lines show up in QGIS. However, when the basic query result is written to a ...