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

learn more… | top users | synonyms

0
votes
0answers
10 views

Drawing lineString in Google Earth API

I am able to draw a Polygon on the Google Earth API which is integrated in my website but i have to draw a lineString. Does anybody can help me? Here is the code i use to draw the polygon: function ...
0
votes
0answers
16 views

google maps api with polyline not displaying lines

I converted shape files into mysql table that has features like LINESTRING and MULTILINESTRING. I am using google maps api ( var shape = new google.maps.Polyline({path: ...
0
votes
1answer
33 views

Multipolygon From Multilinestring PostGis

I have been looking for a answer for days. I dont even know if its possible. Tried: ST_AsGeoJson(ST_MakePolygon(ST_transform(geom,4326))) ERROR: Shell is not a line ...
0
votes
1answer
37 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 # ...
1
vote
0answers
26 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 ...
2
votes
1answer
45 views

How to detect if point is on the left or right side of the 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 ...
0
votes
0answers
21 views

Drawing Lines Between Postal Codes in Fusion Tables

I'm using Google Fusion Tables and have two columns of corresponding postal codes. Fusion Tables automatically converts postal codes to coordinates (the centroids of each postal code) upon import. ...
1
vote
0answers
14 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
28 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: ...
2
votes
1answer
32 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
38 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
69 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 ...
2
votes
4answers
55 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 - ...
0
votes
0answers
33 views

draw coloured LINESTRING over map [.NET (C#) if possible]

I need to render linestring on the map (possibly OSM map) where each pixel (or at least segment) has assigned custom color. In my linestring, each point defining the line has also color definition. ...
1
vote
1answer
43 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 ...
0
votes
2answers
55 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 ...
2
votes
2answers
118 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
31 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 ...
1
vote
0answers
39 views

Progress Bar gets stuck converting Lines to Polygons using QGIS?

I'm trying to convert lines to polygon using QGIS 2.8.1. I use Vector > Geometry Tools > Polygons to Lines. I always get the progress bar stuck on 90%, it can't get to 100%. Could someone ...
2
votes
1answer
62 views

ST_LineMerge doesn't return LineString

I want to create a LINESTRING from a MULTILINESTRING. However in the following case ST_MultiLineString is returned: Select ST_GeometryType(ST_LineMerge(ST_AsText(' MULTILINESTRING( (-70.52570888 ...
1
vote
0answers
40 views

Postgis - st_MakeLine and st_lineLocatePoint

Lets explain, I have 4 points (1,2,3,4), and I need to visit clients (A, B, C, D). So, I need to use st_makeline with (1,2,3,4,3)... Now I have to get % position from A,B,C,D; but in visit order. ...
1
vote
1answer
61 views

What is the best way to get two points along the line in both directions using postgis?

I have a point on a linestring geometry (found by an intersection). What is the best way to get two points along the line in both directions using postgis? It does not really matter if the points ...
0
votes
1answer
118 views

Check if a point cordinate is between linestring cordinates

I know that, linestring is a vector and if i want to check that, if point cordinates are between linestring begginning and ending cordinates then i need to use vector comparison (x2 > x && ...
2
votes
0answers
27 views

Extract from a linestring layer, groups of linestrings to a multilinestring objects layer

I've got a linestring layer with thousands of linestrings. I want to extract groups of linestrings to individual multilinestring objects. In the following picture you can see a part of the layer ...
2
votes
0answers
27 views

SQL Server, Given a linestring with M value, what is the location of this other M value

We are investigating migrating a prototype into SQL Server (azure). We have LineStrings that also have M values. What we would like to do is given another M value find out what its geographical ...
0
votes
1answer
76 views

QSpatiaLite Plugin: LINESTRINGZ(x y z, …) supported?

I get an error when trying to import this query as a spatial table in QGIS: select geomFromText('LINESTRING Z(13.091464 47.061328 2597, 13.092059 47.061287 2580)') as geometry 'The result can't ...
1
vote
0answers
46 views

Using TIGER/Line shape files, how do I get address coordinates?

I've downloaded addressfeature shapefiles from TIGER/Line on the Census Bureau website. I converted one file to CSV using ogr2ogr. I get the following sample output: ...
0
votes
1answer
48 views

Postgis: Conflation of two vector layers into a single layer

If I have table A that I consider to be definitive and table B that may have some elements missing from table B but also has geometries that are "close" to those in A that I want to ignore. How could ...
0
votes
1answer
87 views

How to transform isolines to isopolygons with postgis?

I have a table a postgis table of isolines that's defined like this: CREATE TABLE myisolines ( gid serial NOT NULL, isotime timestamp without timezone, val numeric(10,4), geom ...
1
vote
1answer
42 views

How to use gdal's “forceToLineString()” with Python

I'm working with Python and GDAL and I'm quite new to this ^^ For my script I'm looking for a method to convert a MultiLineString into a simple LineString. Example: MULTILINESTRING ((0 0,0 1),(0 1,0 ...
2
votes
0answers
154 views

Get Distance between two point on linestring using mysql Spatial

I have a linestring and two point on this linestrin according to my picture i want distance between two point as base of linestring please hellp me
1
vote
1answer
197 views

How to find a point on linestring and in a range of 10 meter

i have a linestring which is show in diagram and i have a point which is some time on the linestring or out of linestring but in range which is red line and some time its is out of range so how can i ...
1
vote
1answer
50 views

Index to speed up ST_HausdorffDistance?

When comparing similarity of linestrings with ST_HausdorffDistance (or another type of similarity function), is there a way to use an index to speed up the search for similar linestrings?
2
votes
0answers
178 views

Splitting Line.shp at Point.shp with Python/ogr

I'm trying to modify some ESRI Shapefiles using Python with gdal/ogr module. What I want to do is quite simple, but I didn't find any solution by now. I have two shapefiles: (1) Lines.shp and (2) ...
0
votes
1answer
109 views

Check if point is near a linestring Spatialite

I have a LINESTRING made of two points start point and end point in spatialite. UPDATE points SET road_geometry = GeomFromText('LINESTRING(24.889142 67.196188, 24.889673 67.196579)',4326) where ...
6
votes
2answers
171 views

What controls the direction of TopoGeometry Linestrings?

In PostGIS, what if anything controls the direction that topogeometry LINESTRINGs will have when converted to geometry? It doesn't appear to be the order in which the edges are listed in the call to ...
1
vote
1answer
57 views

Closed Linestring

I've created a linestring using st_makeline(). When I draw this linestring using QGIS it always makes it closed. The start and end points are not the same and I verified by using st_startpoint() and ...
1
vote
0answers
88 views

Postgis - Split linestring between point A and B

I need to find the different trajectories between point A and B. In the image is possible to see 2 differents trajectories. The way i use to calculate them is: Found the min time and the max time (in ...
3
votes
1answer
89 views

How to find intersected line is from left or right on another line?

There is a main LineString and its direction is known. I want to find the side of intersected lines to this main line. Example image: Black line is main LineString and red one is intersected ...
6
votes
2answers
604 views

Split lines at intersection points

I've got some linestrings covering a road network, and need to split them at the crossroads. Does anybody have any idea on how to do it? I'm using QGIS 2.4, with a Postgis 2.1.3.
3
votes
1answer
101 views

Bounding box of a set of MULTILINESTRINGs PostGIS

I have a PostGIS table with a geometry column (geom) and a type column. The geom column contains only MULTILINESTRINGs and the type column contains tags that tell me what each MULTILINESTRING ...
1
vote
1answer
96 views

How to get the LineStrings from a MultiLineString

I was wondering if there is a way I can extract the LineStrings from a MultiLinestring object. What I am really trying to do is look into a MultiLineString and see if I have a certain LineString. I ...
3
votes
1answer
189 views

PostGIS: Get closest point between geometry and Multipoint

I think my question is not that difficult for GIS professionals, but i didn't found an answer to my problem (even not in other questions). Problem: I have given two tables (table1,table2) with Points ...
0
votes
2answers
117 views

Densify a JTS LINESTRING (add points)

I have a LineString I would like to "soften" in a way that if two coordinates (vertices) in the LineString are very far apart, I want to automatically add some coordinates in between. The line ...
3
votes
1answer
351 views

OpenLayers: How to get *real* centroid of a Line Geometry/Feature?

I have declared a line geometry as: var lineString = new OpenLayers.Geometry.LineString([source,target]); then I am trying to get the centroid of this lineString as lineString.getCentroid(). But ...
1
vote
0answers
190 views

OpenLayers - Add points at vertices of line while drawing line

I would like to create points while I draw a line on my map in OpenLayers. That is, at each vertices of a line and at the end points there is a shape like a square, circle, or diamond. I have this ...
3
votes
1answer
325 views

Find the closest line vertex from the linestring using PostGIS

How to find the closest line vertex from a linestring? ST_ClosestPoint will give a point which is not from the linestring.
1
vote
1answer
200 views

PostGIS - Intersects feature to split into linestring

I would like to know if it's possible to intersect feature datasets (multipolygon, polygon, multilinestring and linestring) to get a result as a set of linestrings being split at each intersection ...
1
vote
1answer
66 views

ValueError when instantiating LineString from a mix of tuples and Point objects

I'm new to Shapely, and tried instantiating a LineString object from a mix of tuples and Point objects like this: >>> LineString([Point(1,2),(2,3),Point(3,4),(5,5)]) I get the following ...
3
votes
1answer
199 views

Showing Linestring from SQL statement with CartoDB

I have cartodb sql statement to return what polygons are intersected by a linestring, but I'd like to have the linestring visualized over the polygons on the results. Also not add the linestring to ...