Questions tagged [linestring]

A sequence of point coordinates referring to the line segments connecting them, as used to represent a one-dimensional feature or object.

Filter by
Sorted by
Tagged with
2
votes
1answer
2k views

PostGIS subquery make linestring from points

I have thousands of points and I am trying to intersect them with US states, sort them by date and then create a linestring from those points grouped by date, and state name. I have accomplished this ...
3
votes
2answers
230 views

Lengthening 1st and last point of GeoJSON LineString containing lat/lon coordinates maintaining angle and direction

I am fairly new to the gis topic and may not be using correct terms. I have a GeoJSON LineString containing lat/lon coordinates. I would like to lengthen the 1st coordinate and the last coordinate by ...
1
vote
1answer
70 views

Linestring moving to the other end of the map near the edges

I have a geojson for a line string that I am calculating using arc.js (great circle points between coordinates). For small distances its working fine but for long distances between one end of the map ...
3
votes
2answers
1k views

Find a linestring closest to a given linestring

There must be already a solution to this problem - let's say we have five different linestrings. They might intersect or not. Given a sixth linestring, how do we find which one of the original five ...
1
vote
1answer
185 views

ST_IsValidDetail and LINESTRING

Why ST_AsText(location(ST_IsValidDetail(the_geom))) from LINESTRING return blank? From POLYGON, all ok... "POINT(...)" For example: SELECT ST_Astext(location(ST_IsValidDetail(ST_GeomFromText('...
1
vote
1answer
247 views

Buffering multiple features with Geoserver WPS

I'm trying to create a buffer around more than one LineString feature at a time with geoserver 2.8.x. and openlayers 3. Currently, i can create a buffer around a single line feature with the following ...
8
votes
1answer
10k views

Turning GeoDataFrame of x,y coordinates into Linestrings using GROUPBY?

I have a dataframe of X,Y coordinates that represent points along the paths taken by several different entities. Pseudo-data here, but it is roughly of the form: entity_id lat lon time 1001 ...
6
votes
2answers
964 views

How to compare polygon boundaries in PostGIS?

I've to compare two polygon layers, 'land_use' and 'land_parcels', in PostGIS. My aim is to create linestrings, where boundaries of 'land_use' polygons do not match boundaries of 'land_parcel' ...
3
votes
1answer
4k views

How to combine LineStrings using JTS

I want to combine LineStrings with common points. The scenario looks like this: I tried it using the GeometryCollection.union() method like suggested here: http://docs.geotools.org/latest/userguide/...
6
votes
1answer
955 views

How to split overlapping linestrings?

I'm new to PostGIS and a bit lost... I work with linestrings that sometimes overlap, for example: I'd like to distinguish these linestrings by splitting them like Google Maps do: I was thinking ...
1
vote
1answer
641 views

QGIS show labels in beggining or ending points of Linestrings

I've got a Linestrings layer. Each Linestring has among other fields, these ones: id ENTRY EXIT 1 S1 E2 2 S1 E3 3 S1 E3 4 S1 E3 5 S1 E3 6 S1 E1 7 ...
0
votes
1answer
484 views

Linestrings into one multilinestring

I have 2 tables "dijkstra_results_geo" and "dijkstra_results_geo_aggregate". I have a set of Linestrings in the column dijkstra_results_geo.geom_path_intermediaire (defined as geometry(Linestring, ...
1
vote
0answers
390 views

Swapping start and end points of line (i.e. direction) of LineString in PostGIS?

I know that postgis has the function to find the start and end point of a line. Is there a function that can swap the start point and end point? (Note: I do not mean literally changing the co-...
10
votes
2answers
3k views

PostGIS - Get a point inside a line or polygon

I need to get the center point of a line or polygon to make marker for my app. So that when you click a marker the geometry appears (line or polygon). I used ST_Centroid to make it work. The result ...
2
votes
1answer
166 views

What does the GEOS LineString “normalize()” routine really do?

What does the GEOS LineString "normalize()" routine really do? GEOS has virtual void geos::geom::LineString::normalize() with the documentation: A normalized linestring has the first point which ...
1
vote
0answers
39 views

Linestring segment completition?

I just extracted some river paths from some old maps I acquired a few weeks ago, they seem accurate enough and will be very interesting to put against my theoretical mapping calculated by using the ...
3
votes
0answers
185 views

Can I reorder the points in a GEOS LineString?

Using libgeos, when I buffer() a polygon and then getExteriorRing() [to make a slightly smaller outline copy of the polygon just inside the original], it seems that which point on the new geometry is ...
2
votes
1answer
1k views

Convert KML polygons to lines

I've been given a KML file which should consist of linear features (train lines), but for some reason they're all represented as <Polygon> types. Each appears to have the right data, from end of ...
5
votes
3answers
3k views

Getting distance between two points over linestring using PostGIS?

I have a linestring: LINESTRING(-1.3326397 50.9174932,-1.3319842 50.9166939) and I select two points that lay on that linestring. How do I get the distance between these two points (in meters)?
2
votes
1answer
179 views

Bring a list of unsorted linestrings in order so that they form a path from origin to destination

I have a table of linestrings together with some attributes that, when displayed all at the same time, represent a connected path from an origin to a destination (each linestring has one predecessor, ...
3
votes
1answer
3k views

Get LineString length in meters (Python, GEODjango)

In a Django model, I have a LineString field which holds GPS coordinates of a street route. I know that I the .length holds the length of the LineString, but I don't know what unit the returned value ...
15
votes
3answers
879 views

How to create lines to visualize differences between polygon features in PostGIS?

I've a PostGIS table polygon_b with some polygon features. There is also a table polygon_a which contains the same polygons as polygon_b but with minor changes. Now I want to create lines to visualize ...
6
votes
1answer
809 views

Find all intersections of a LineString and a Polygon and the order in which it intersects it

I would like to find out all intersections of a LineString (River) through Polygons (Municipalities). I would like to list the order of municipalities which the river crosses, using linear referencing....
3
votes
0answers
43 views

Postgis - Construct linestring of length N

Give a table of linestrings (roads) ogc_fid, wkb_geometry And a road with ogc_fid = X In postgis how could I construct a linestring that is of length Y metres made up of roads starting from road X?...
0
votes
1answer
507 views

Linestring in OpenLayers doesn't draw

I don't understand why my code doesn't work. If the map is displayed, the line is never drawn: <script> var long_deb = -1.28627; var lat_deb = 43.49829; var long_fin = -1.29394; var lat_fin = ...
5
votes
1answer
552 views

Creating line-strings from points in MySQL

I am extracting the lat/long information from Geo-tagged images and storing them in MySQL. I want to get a line-string from the points, I looked into the GROUP_CONCAT() function but I am not able to ...
1
vote
1answer
1k views

Finding and merging lines that touch in PostGIS?

I would like to select and merge segments that touch like in the image below. My table contains single segments with their own id (shown in the figure), I just want to isolate single "group" of ...
5
votes
2answers
439 views

How to use ST_Difference to create linestrings from non-intersecting polygon boundaries?

There are two tables with polygon features in my PostgreSQL database. I want to create linestring features where the boundries of the polygons are not intersecting. CREATE TABLE schema.poly_a ( gid ...
7
votes
1answer
3k views

In PostGIS: how to split linestrings into their individual segments?

I have one table with many linestrings and I want to make a new table containing the individual segments of all the linestrings, no matter if they are grouped line per line or not. This is my table, ...
6
votes
2answers
572 views

Get the 2 points immediately before and after a given point in PostGIS

In the picture below: The given point is C, I would like to select A and B, but not Z (which is closer to C than B but it's not immediately after in the LineString). Note that C is always ON the line ...
1
vote
1answer
47 views

Finding zero-length LINESTRINGs the wrong way gives funny answer

I tried select st_astext(geom) from table where st_pointn(geom, 1) = st_pointn(geom, 2) But I get some results which don't match the criteria. For example: LINESTRING(-117.1642086 34.2779308,-117....
1
vote
1answer
783 views

Determine points where a LineString meets the boundaries of a Polygon using Turf.js

Using Turf, I'm trying to determine the points at which a line (LineString) meets the boundaries of a polygon. Turf has the ability to do point-in-polygon/point-on-line and polygon intersections etc, ...
-1
votes
1answer
649 views

JSON to line string

I'm getting a JSON return like so: [{"lat":38.660274,"lng":-90.136198},{"lat":38.6613,"lng":-90.13860199999999},{"lat":38.664634,"lng":-90.141853},{"lat":38.664634,"lng":-90.141853},{"lat":38....
3
votes
2answers
1k views

PostGIS - Merging linestrings into multilinestrings in a particular order

I have a set of linestrings, which I want to group into a single multilinestring, and in a specific order. However, when I use ST_Collect, it merges them out of order, like this: Geometries as ...
2
votes
3answers
597 views

How to remove identical lines from layer in QGIS?

I converted polygon layer to line layer using "Polygons to Lines" tool. Then I used "Split" function of the Networks plugin. What I need to do next is to remove identical lines that were shared ...
2
votes
1answer
515 views

How to export a CSV with lat lon WKT from a layer which is not in WGS84?

I want to extract a csv with lat and lon coordinates so I select -- Geometry AS_WKT but when the csv is created I see this LINESTRING (277054.55782319931 198725.03588318737,277052.43701817648 198727....
1
vote
1answer
1k views

Multipolygon From Multilinestring PostGIS

I have been looking for a answer for days. I don't even know if its possible. Tried: ST_AsGeoJson(ST_MakePolygon(ST_transform(geom,4326))) ERROR: Shell is not a line ST_Polygonize(ST_LineMerge(...
2
votes
1answer
1k views

MapServer: Symbol (v-line) style that automatically follows line direction

I created this image: with: MAP SIZE 1000 1000 IMAGETYPE png24 EXTENT -30 -10 60 30 UNITS DD SYMBOL NAME "v-line-shift" TYPE vector POINTS 0 0 5 10 10 0 END # POINTS ...
1
vote
0answers
302 views

need to split some linestrings by points

please help me, i'm new in gis 1) i have а table with geom railways, which are multilinestrings (for example there are 2 ways one of which is interrupted, so this way will be multilinestrings ...
14
votes
1answer
3k views

Detecting if point is on left or right side of line in PostGIS?

I have a linestring table and a point table in postgis. I know the closest line to any given point. What I need to know is on which "side" of that line is the point. I guess I have to do that by ...
1
vote
0answers
178 views

Postgis ST_AsSVG renders a tiny SVG

I am storing information about a person's journey as a linestring. Having recently discovered ST_AsSVG I tried the following query: SELECT ST_AsSVG(path) FROM activities WHERE id = 209 ...
2
votes
0answers
131 views

match noisy GPS data to closest linestring in road network [duplicate]

I have some noisy GPS data(Points) that they are not exactly on the road because of the noise. But I want to match them to the closest road linestrings. How to do this in PostgreSQL? Data: ...
4
votes
1answer
1k views

MySQL select linestrings into a multilinestring

I have a mysql column of linestring type with 2000 linestrings (high water mark values to be more specific). I want to merge them into one multilinestring so i can see what the shape of these values ...
0
votes
1answer
994 views

Spatial query ST_CONTAINS returns empty result

I want to create a database view in Postgres/PostGIS which returns a subset of the points stored in another table called locations. The subset is defined by an area stored in yet another table called ...
3
votes
2answers
837 views

Remove specific points from linestring postgis

I am working with a data set that has been using the (0 0) point to pad any points that were missing when the linestring was created. So now the query SELECT id, route as line FROM trips ...
3
votes
4answers
638 views

How to determine if two points are on the same side of a LineString?

I have two points, A and B, and a line string L. A line string is formed by a sequence of points such that consecutive points are joined by a straight line. This is the same as a LineString in Geos - ...
2
votes
1answer
2k views

How to individually label points in Openlayers linestring?

I want to display some text below each point on a linestring with Openlayers. The text would include, for example, the coordinates of the point, plus some other information. I have managed to add a ...
1
vote
2answers
756 views

Create point on a line with given distance from end in PostGIS

Does anyone know how to create points along a line (MultiLineString geometry) with a given distance in PostGIS? I'd like to create points at a regular distance over a line, which represents a ...
4
votes
2answers
1k views

Merging linestrings in QGIS using PostgreSQL and PostGIS

I've to merge all linestrings from a PostgreSQL table "river" where not more than two start-/endpoints are overlapping. In the illustration below I use a "M" to mark all linestrings that needs to be ...
2
votes
1answer
353 views

Algorithm to remove Loops from a Line-String

I am using a third-party API to acquire a linestring representing a route. Occasionally, this API (which I will not name, here) returns a linestring that contains loops. Logically, this makes no sense....