PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.

learn more… | top users | synonyms

0
votes
1answer
19 views

Solving “Traveling Purchaser Problem”

Till now, I was using PostGIS-pgrouting pgr_tsp function to solve Travelling Salesman Problems. This function can give us the best possible route depending upon the cost parameter when the starting, ...
0
votes
0answers
16 views

strange result of spatial functions postgis

I have a problem with different result of spatial functions for same geometry. For some reason result I get when I use geometry from database is different then result when I load same geometry from ...
2
votes
1answer
25 views

Layer from PostGIS with array of integers fields?

I have GeoServer 2.6 and I published a vector layer (point) which some of the field attributes are integer's array. GeoServer doesn't recognize those fields in wfs call or even in the Feature Type ...
0
votes
0answers
10 views

How to get linestringe from kml into shp or postgis [duplicate]

Im looking into extracting linestrings from a kml file into a shp file or postgis db. Each linestring would be a feature/row. How would I go about it usinge ogr2ogr or python? I'd like to get ...
0
votes
1answer
14 views

ogr2ogr - gpx to PostGIS has wrong timezone adjustment

A gpx track point: <trkpt lat="52.321775959804654" lon="-72.647269548848271"> <time>2014-10-01T16:07:19Z</time> </trkpt> is imported with ogrogr in my PostGIS ...
0
votes
0answers
22 views

Create polygon with predefined size

I need to create a polygon (square) with a predefined size to place it anywhere in a map. The size is given in centimeter (size in cm * scale = size in real). Is that possible with postgis/qgis?
0
votes
1answer
15 views

OpenGEO templates and postGIS

I am trying to display my shapefiles.shp with ol3edit template. On OpenGEO Suite I have successfully created an ol3edit application.I'm in possession of the ol3editApplication.war but the ...
0
votes
0answers
20 views

Creating trajectory/lines from millions of points [PostGIS] [on hold]

I have millions of points in a PostGIS database containing taxi gps tracks. Now I want to create lines from these points by vehicleid and ordered by timestamp. But, and that's my problem right now, at ...
0
votes
1answer
24 views

Splitting multiline into several same-length multilines

Is there a method to convert a multiline geometry into several multiline geometries having the same length? For example break this: MULTILINESTRING((1 1, 3 1, 3 1.5, 2.5 1.5)) Into [approximately] ...
1
vote
0answers
41 views

Simplifying geometries and calculating non-spatial averages

I'm quite new to using proper spatial tools, and have a simple question that doesn't immediately show up on google. I have a table that contains multiple rows of empiric data (say, speed of a ...
1
vote
1answer
36 views

Visualize large amount of geopoints with Geoserver and PostGIS

I have a postgis database with over 50 million rows. Every row consists of a POINT corresponding to lon,lat and a value (number 1-100) I'm trying to create tiles for zoom levels 5-20 that I want to ...
3
votes
2answers
39 views

How can I export data containing umlauts from PostGIS to shapefile, without losing the umlauts?

I am exporting my Finnish (Finland) data from PostGIS to esri shapefile. I am using the PostGIS Shapefile Import/Export Manager and I don't see any way to specify the encoding of the shapefile's ...
0
votes
0answers
28 views

Overlapping gpx imported to PostGIS with ogr2ogr

I can successfully import track points from gpx file into my PostGIS database the usual way: ogr2ogr -f "PostgreSQL" PG:"dbname=ABC user=usrname password=123" firsttracklog.gpx However, I have a ...
1
vote
1answer
32 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?
0
votes
1answer
66 views

How to import multiple shapefiles without any dbf to a postgis database?

I have a polyline shapefile (.shp and .shx) without .dbf. I would like to import the shp into Postgis. In order to do that, I created the corresponding .dbf using the r code provided by mdsumner in ...
2
votes
1answer
59 views

PostGIS Nearest Neighbour outside buffer

I am trying to find the 6 nearest neighbours to a point which are outside a defined buffer. Basically I am comparing points of the same table and working with Mike Gleason's examples. WITH subq AS ...
1
vote
0answers
29 views

Create a “wide” table recording all overlaps between polygons in PostGIS

I have a set of overlapping polygons and would like to record which polygons are overlapping at each intersection. I have followed the instructions at: ...
0
votes
0answers
11 views

postgis & mapnik “column ”CLASS“ does not exist”

I've piped an osm map of greece into postgis with osm2pgsql and was playing around with C++ mapnik sample code giving "planet_osm_polygon" as the source table: parameters p0; p0["type"] = ...
5
votes
1answer
76 views

SQL “Case” statement when count(*) is 0

I am trying to write the following SQL command using case clause. with x as (select the_geom as geom from table1 where st_dwithin(the_geom, st_setsrid(st_makepoint(28.959495,41.019913), 4326), ...
1
vote
2answers
27 views

Insert values in Postgresql in Java

Hello i try to insert same values in my table but i write this code String sql = "INSERT INTO points (gid, osm_id, name, type, geom)VALUES (?, ?, ?, ?,ST_GeomFromText('POINT(?, ?)', 2100));"; ...
1
vote
1answer
40 views

Modifying “pg_hba.conf” file to listen local TCP/IP conection

I am starting with PostGIS and there is an error when trying to connect through a TCP/IP connection. What I have done is: installed PostGre 9.3 in my PC, then installed PostGIS 2.3 for postGre 9.3, ...
3
votes
0answers
24 views

Prevent PostGIS Topology from splitting edges on line insert

I'm dealing with a large amount of road data represented with PostGIS Topology types. Anytime I add an edge over another edge, the edge is automatically split and a new node is created at the ...
0
votes
0answers
15 views

postgis st_makeline, points with rounded time

I have seen a number of example SQL statements that take gps points, order them by time, them use ST_MakeLine to make a Linestring. I think my trouble comes from that fact that my times are rounded to ...
0
votes
0answers
16 views

cartodb/postgis : how to display a polygon with longitude outside the -180;180 range

I am trying to display the following geojson polygon: { "type": "FeatureCollection", "features": [ { "type": "Feature", "properties": {}, "geometry": { "type": ...
0
votes
1answer
26 views

How to modify imposm data mapping in order to include the user name?

I want to import OSM data into postgresql with imposm. How do I have to modify the import process in order to have the user name as an attribute in my tables? Do I have to change that in the data ...
1
vote
1answer
17 views

Does mixing geometries of different granularity affect POSTGIS index efficiency?

My POSTGIS table contains a lot of small non-overlapping geometries and I do mostly bbox queries. I would like to add larger / coarser grained geometries to the database (counties, provinces, country) ...
1
vote
1answer
45 views

Computing intersections for each geometry in a table

I have a table with many Linestrings and for each of these Linestrings I need to figure out which other Linestrings, from the same table, intersect with it. If I recall correctly this gives me a ...
0
votes
2answers
20 views

Create a point on a line after a specific distance from startpoint

I'm trying to create a point on a line after 10 meters from the beginning of the line. In postgis it is possible to create a point on a certain fraction of total length of linestring ...
0
votes
1answer
59 views

How to create a Network Topology in a shapefile that contains only nodes(geometry points)?

I want to use pgrouting with the shapefile but when I use : alter table network.publictransport add column source integer; alter table network.publictransport add column target integer; select ...
1
vote
1answer
29 views

Hardware requirements for one instance Geoserver/PostGIS

What hardware minimun requirements do you recomend for one instance of geoserver and postgis and 20 concurrent users? Vectorial data stored in PostGIS is around 20 MB only. I need the ammount of RAM, ...
0
votes
1answer
30 views

Export shapefile From PostGIS

I've a website where I'm giving the functionality of creating and editing line features. I'm using Leaflet-Draw plugin for drawing, PostGIS for storing the data and GeoJSON to display it on map. My ...
2
votes
3answers
53 views

ST_MakePoint or ST_PointFromText to generate points

I'm new to postGIS and am having trouble finding an answer to this question. I have loaded UK postcode data (OSGB36, SRID 27700 with eastings and northings fields) into a postGIS database. I now want ...
1
vote
1answer
24 views

Why does my query not run since SRID are the same?

I am running this query: SELECT source,ST_AsText(ST_ClosestPoint(roads.geom,ST_GeomFromText('POINT(22.256 39.569)'))) FROM roads ORDER BY ST_Distance(roads.geom,ST_GeomFromText('POINT(22.256 ...
-1
votes
0answers
24 views

How to use pgRouting in my case?

Suppose I have 6 bus route and a road network. After a user determines to me the starting point and the place he wants to go, I want to determine which of the bus routes is the best. How to use ...
1
vote
2answers
60 views

How to visualize pgrouting result?

So I use this query SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_dijkstra(' SELECT gid AS id, source::integer, ...
1
vote
1answer
46 views

QGIS WFS-T not updating data

I have asked for help on this topic a few times, but i'll go one more time; with a bit more info. I am trying to edit a WFS from geoserver (using PostGIS data) within QGIS. This is the request as ...
1
vote
1answer
30 views

What does st_hausdorffdistance Actually Compare

Does st_hausdorffdistance just look at discreet points used to construct a line segment or does it compare two line segments as a continuous set of points? Also, the points used to construct my line ...
0
votes
0answers
53 views

Converting GPS coordinates points to polylines

I happen to have some GPS coordinates points based on timestamp in a table. My table consists of and id , time_stamp and GPS points as the geometrical data. I want to create a line by joining all ...
2
votes
0answers
17 views

postgres repojection: best practice

I have a postgres/postgis database. I would like to reproject those data coming to me in 4326 to 32736. For those tables with lat long info in wgs84 (4326) I have set the geom to 4326. Then I have ...
0
votes
1answer
16 views

Error while make Build osm2pgrouting on openSUSE 13.2

i am getting the error while make /usr/lib64/gcc/x86_64-suse-linux/4.8/../../../../x86_64-suse-linux/bin/ld: cannot find -lpq collect2: error: ld returned 1 exit status make[2]: *** [osm2pgrouting] ...
1
vote
1answer
13 views

How to join LINESTRINGS in a specific order in PostGIS?

I have a path from point A to point B, which I want to double back on itself to create a path from A to B back to A. It seemed like using ST_LineMerge on the MULTILINESTRING created by ST_Collect ...
1
vote
1answer
27 views

Import KML to PostGIS

I am looking for a way to import my data from KML (example below) to PostGIS database. <?xml version="1.0" encoding="UTF-8"?> <kml xmlns="http://www.opengis.net/kml/2.2" ...
-3
votes
1answer
40 views

How to use st_touches to get all nearby states

I have a table with all US states geometrical data: USstate ------- state | The_geom (here filling in random value) AL | 00012312 NM | 000234234 NJ | 0000234534 NY | 00005465 ...
-3
votes
1answer
44 views

How do you combine multiple spatial functions in one query?

I want to find out the intersection and difference in the same query using postgresql. How can I combine both st_intersect and st_Difference in same query and return the result.I want to compute the ...
1
vote
0answers
15 views

TileStache some vector tiles failing / postgis connection error

I have TileStache running fine with NGINX/uWSGI on my server. Problems start when I try to render data as vector tiles from a postgis datasource. A few tiles will normally work fine, but at some ...
0
votes
0answers
27 views

Capturing points slightly out at sea

I have two tables one containing points (points) and the other polygons (polygons). I want to generate a two-columns table identifying for each point of the first table the polygon containing it. So ...
1
vote
1answer
42 views

Conversion of EPSG:3857 coordinate to UTM

I'm trying to convert coordinates from Google Maps using the PostGIS. I'm using this query: SELECT ST_AsText(ST_Transform(ST_GeomFromText('POINT(-29.16297 -51.1795034)', 900913), 29182)); The ...
0
votes
1answer
19 views

Merge Point Data and Raster using ST_SetValues in PostGIS

I'm trying to merge a point dataset with a raster dataset using Column X / Row Y. I have written a tool which generates a raster and, from that raster, I have created grid points with ...
0
votes
0answers
26 views

Geohash36 for PostGIS

i was wondering if anyone created a ST_GeoHash36 function inside postGIS, i know the ST_GeoHash + ST_GeomFromGeoHash functions exists, But i need the geohash36 function inside postGIS, i need a ...
1
vote
1answer
24 views

How to save selected features from a postgis database into a new mini database

I have a postgis(v2.1.3)/postgresql(v9.3) database with geometry (geom1, geom2, etc.) and attribute (attr1, attr2, attr3, etc.) tables. The attribute tables are linked to the geometry tables using ...