Tagged Questions

1
vote
0answers
19 views

windows function with points in a mixed (multipoint/point) table

I have a table comprising multipoints (tracks) and points (stops between tracks). there can be several consecutive multipoints. now, i want to merge any points lying very closely to each other ...
2
votes
1answer
38 views

Is it possible to update only latitude or longitude in postgis ?

I have a postgis database that contains Points created based on a couple (longitude, latitude), and I need to update only one of those two for a given point. I found that it's possible to do so but ...
1
vote
1answer
79 views

PostGIS, create line from points

I have a PostGIS table with position data of numerous vehicles and want to create lines from these points. Data can be selected by vehicle id and ordered by timestamp but how to create lines from the ...
-1
votes
1answer
83 views

QGIS and Python - create line with multiple points in postgis

How can I create a line, with Python functions, with many points that are records in Postgis? Thank you
0
votes
1answer
93 views

Aggregate points with same values to polygons

I have a shapefile with 2M measurement points (each measurement point has a resolution of a 1/10). How can I aggregate points around each other if and create polygons out of it? They do not have to ...
0
votes
2answers
67 views

Manually add a new point to PostGIS table [duplicate]

I did accidently delete a table row - or well, in fact a whole subway station. My attempt to solve the problem was this PostGIS function: ST_GeomFromText('POINT(coordinates)') But then PostgreSQL ...
0
votes
1answer
335 views

Make POINT from longitude/latitude coordinates from existing table in PostGIS

I would like to make a POINT using the longitude and latitude columns of an existing table. Here's a link to the documentation of ST_MakePoint. Here's my table: CREATE TABLE sysinst.bio ( oid ...
6
votes
4answers
236 views

How to calculate the “depth” of a linestring using postgis

I have linestring features, which look like bent linestrings, hemicycles or convex or concave linestrings. In the moment I can select the distance between the startpoint and endpoint of each feature. ...
2
votes
2answers
238 views

Calculate min distance between points in PostGIS

I have point layer in PostGIS database. Help please with query which add for each points in layer distance in attribute table between this point and another nearest point. Thanks! Update Calculate ...
2
votes
1answer
125 views

Postgis 1.4 - Obtain closest point of point over polylines layer (without st_ClosestPoint)

I´ve got a polylines layer (pipes) and a points layer (valves) and In Postgis 1.4 I would like to obtain the closest points but exactly on the closest polyline. In other words, i need to locate each ...
6
votes
2answers
283 views

QGIS or Postgis - How to split polylines with a point layer?

In QGIS, I would like to split the polylines in a layer loaded in the workspace with the points in another loaded layer. If a point intersects a polyline, this polyline should be transformed into two ...
1
vote
1answer
127 views

QGIS create layer with the points of the beginnings and ends of a polylines layer (without duplicate points)

In QGIS, i would like to create a new layer containing the beginning and end points of a polylines layer, but without the duplicate points that would result of adjacent polylines.
3
votes
3answers
309 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
1answer
127 views

How to connect particular sets of points with (poly)lines?

I think my problem is quite easy to be solved by the most postgis-users, but i am a bloody beginner: i have a timestamped point-table representing GPS-tracked places of different cars. To distinguish ...
4
votes
1answer
214 views

adding multiple points to a linestring in PostGIS

Though a newbie to PostGIS, I'm having trouble solving something that I think should be farily straightforward. I have two linestring tables, both consisting of simple, 2-node line objects: one has ...
6
votes
2answers
185 views

How to add vertices to existing linestrings?

If I have Linestring(1 2, 1 5, 1 9) and a Point(1 3) Is there any function that can merge linestring and point preserving the order so output would be: Linestring(1 2, 1 3, 1 5, 1 9)
10
votes
2answers
219 views

How to identify and simplify point clusters with regard to time in PostGIS?

I just started to work with spatial databases and I want to write a SQL(PostGIS) query for automatic generalizing of raw GPS-tracks (with fixed tracking frequency). The first thing I am wokring on is ...
1
vote
2answers
184 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
475 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 ...
0
votes
2answers
749 views

PostGIS convert geography(Point,4326) to GPS

I got a database with a column of type geography(Point,4326), the data contained looks like 0101000020E610000092E057F66EF73140930035B56CBD4840. How can I convert it to GPS coordinates?
5
votes
1answer
138 views

Given 2 LINESTRINGs with common point, how to extract common point?

I have 2 LINESTRING geometries. I know both share a common point. Using PostGIS for Postgres, what is the cleanest way to extract the common point? Example with illustration: How do I extract the ...
2
votes
1answer
207 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 ...
3
votes
1answer
802 views

convert list of points to line or polygon

I have a list of Points in a PostGIS table. The rows can be grouped by a date something like: myTable id INT date DATE lat NUMBER lng NUMBER geom GEOMETRY(POINT) now I need a table where all ...
1
vote
1answer
233 views

PostGIS - table with 3d points with fast ordering by distance

I am pretty new to PostGIS and I am trying to solve the following problem. I need a table with 3D points (x,y,z) that will contain around 1-10million points. I want to be able to efficiently ask the ...
6
votes
4answers
677 views

Output PostGIS geometry data as centroid or polygon depending on zoom level (GeoServer)

This is what I want: when I zoom out, cities of the country should appear as points and at a certain level when I zoom in, I want them to appear as polygons (showing the area of the city and ...
5
votes
1answer
2k views

Simple PostGIS ST_Distance query for two points from the same geometry table?

Note: This question was published at Stackoverflow at first. I have a geometry table points_table with SRID 4326 and a few points in it. I need to find a distance between a pair of points (features) ...
2
votes
1answer
349 views

How to create a efficent linestring out of geography points using postgis

I'm trying to create a linestring out of geography points. At the moment I'm doing it like this: select ST_GeographyFromText(ST_Makeline(a.record_point)) from ( select (record_point::geometry) from ...
3
votes
2answers
408 views

Total great circle distance along a path of points (PostGIS)

I am looking for an SQL query that sums the distances between a series of points using PostGIS. The situation is as follows: I have 2 tables: tracks and points. Points belong to a track and thus ...
8
votes
2answers
774 views

PostGIS raster value of a lat/lon point

I have a tiff raster in my PostGIS 2.0 database. I want to get the value of the raster at a specified lat/lon point. I have: postgresql-9.1 postgis-2.0-svn with raster support a raster imported ...
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 ...
2
votes
1answer
96 views

Access points with PostGIS

I have a PostGIS table with linestring geometries and point (A) on it and I need to detrimine points (M) which located M meters from A. Distance is measured along linestrings. Any thoughts?
3
votes
3answers
638 views

Spatial Database Design (PostGIS) - Point data that doesn't always have spatial data

I am creating a spatial database using PostGIS. I am storing the attributes and location of some species records that can be represented as points. The records are recorded from either: a) static ...
14
votes
2answers
3k views

How can I find a point inside a polygon in PostGIS?

How can I find a point that is guaranteed to be within a given polygon in PostGIS? I am aware of the ST_Centroid function. However, the centroid is not always within a polygon, see below: ...