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

learn more… | top users | synonyms

0
votes
0answers
20 views

How to split linestrings where start/end points don't touch nearby lines

I am trying to figure out some basic routing with PostgreSQL/pgRouting and I'm struggling a bit. Our network of linestrings are not topologically correct, tracks that should be connected don't touch, ...
0
votes
0answers
7 views

osm2pgsql cannot connect to postgis database, running on a Bitnami project installer

Based on this guide I am trying to import an .osm.pbf file into my PostGIS database, which is running on my Postgres Bitnami installation here: [bitnami@ip-xxx]/usr/share/proj$ which postgres ...
1
vote
1answer
81 views

What should be my learning progress regarding GIS open source

I was wondering for a while now, what should be the hierarchy of my GIS knowledge or better to say, learning curve in domain of open source GIS. Should I start with Geoserver and PostGIS then ...
0
votes
0answers
9 views

Difference postgis TopologyException

I'm trying to make a quite simple analysis in Postgis, but I'm finding some problems. I want to in the first place create buffers for then, intersects themselves but one, this will be differenced. ...
1
vote
1answer
18 views

Is product purchaser in distribution area?

I am going to be using PostGIS 2 to create a lookup service. Given a point (lat/lon), I need to either find if a product can be distributed there, or b) a list of products or distributors. I am ...
7
votes
1answer
1k views

Why do simplify polygon results differ between ArcGIS for Desktop and PostGIS?

I am mainly interested in why and how the Simplify Polygons tool in ArcGIS for Desktop handles the simplification process, including preventing and resolving topological errors better than the ...
6
votes
1answer
448 views

What is difference between ST_DWithin and ST_Distance for proximity search in PostGIS?

I have records stored in a table with latitude/longitude coordinates stored in a geometry field. I want to find all records nearby a user supplied reference point. Note "nearby" probably means less ...
0
votes
0answers
22 views

PostGis: find distance if closer than X. For huge sets [duplicate]

I have two tables (that can have different geometry: point, line, polygons, ecc...) and I have to find distances: for all features in table A, for all features in table B, if feature is closer ...
0
votes
0answers
6 views

postgis resampling two rasters to a common intersection grid?

I am testing the PostGIS map algebra (ST_MapAlgebra) on two different raster tables. Each table contains a single image/row. They have the same SRID but different, overlapping extents and different ...
1
vote
1answer
44 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 ...
0
votes
1answer
55 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
1answer
158 views

error printinf pdf in opengeo suite client sdk app

I am using OpenGeo Suite 3.0.2 I created an app using Client SDK. Stored the raster and vector data on postgreSQL/PostGIS print tool is not working, giving error i.e. "Java.io.IOException: the ...
0
votes
0answers
36 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 ...
1
vote
1answer
35 views

How to process GeoJSON data and create hive table for spatial analysis

I am using the ESRI-GIS tool for hadoop for analyzing json data generated through ESRI products like ArcGIS. But I wanted to analyze spatial data from a PostGIS table for which I made geojson ...
2
votes
1answer
33 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 ...
2
votes
1answer
232 views

Using ST_MakeEnvelope over the dateline

I'm using ST_MakeEnvelope in PostGIS to try and make geometries that cross the international dateline, but they are making a shape that wraps the other way around the globe. The geometry I want is ...
0
votes
0answers
11 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 ...
1
vote
1answer
693 views

Having trouble connecting QGIS with postgres database with postgis extension

I am working on Ubuntu Precise with postgresql version 9.3 and postgis 2.0. After initially starting my postgres database and eventually getting permission errors that would prevent postgres from ...
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
23 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
0answers
21 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
17 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 ...
1
vote
0answers
44 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 ...
0
votes
1answer
25 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
1answer
111 views

Creating a postgis database a GML application schema

Is there any open Source tool(automated or semi-automated) that converts GML application schema to a POSTGIS database/table .Specifically I have a huge application schema containing many ...
1
vote
3answers
139 views

PostGIS importing shapefile error w/ official manager

I'm having some trouble when trying to import an shapefile of the Sao Paulo Brazil's state (I downloaded it from the web and I'm using the own PostGis manager to import it). Here's an image! The ...
1
vote
1answer
33 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
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 ...
3
votes
2answers
40 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
2answers
210 views

can't geocode with PostGIS 2.1.1

I don't know where's the mistake... I am using the process from the PostGIS documentation (http://postgis.net/docs/manual-2.1/postgis_installation.html#loading_extras_tiger_geocoder) . I created a ...
3
votes
1answer
189 views

Get Multiple Shortest Path using PgRouting in One Query

I am trying to get multiple shortest path using A* Algorithm available in PgRouting. I referred Solution given by UnderDark ( Link of the Stakoverflow Post ) . But it is not giving me proper Output. ...
1
vote
2answers
220 views

Why does Driving distance of pgRouting return disconnected results?

I am trying the driving distance function of pgRouting 2.0 beta, with an extract of OSM data. The problem i have is illustrated on the following image : On this picture i try to get all the ways ...
0
votes
1answer
67 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
60 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
2answers
28 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));"; ...
0
votes
1answer
195 views

ST-Links convert Feature Class to DB Table error

I'm using ArcMap with the ST-Links SpatialKit Conversion tool to convert a Feature Class to a DB Table. But I'm getting an error: ERROR: 42601: type modifier is not allowed for type "geometry". I ...
9
votes
1answer
177 views

How to compute the smallest network that connects all points using PostGIS?

I have a set of postgis scripts which generates two tables - one of a set of points and the second a set of roads which surround them. All data is in the same projection and both outputs are stored in ...
1
vote
0answers
30 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: ...
5
votes
1answer
79 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), ...
0
votes
2answers
340 views

PHP PostGIS to geoJSON missing required parametar error

I'm using this PHP PostGIS to geoJSON script: https://gist.github.com/bmcbride/1913855 But I keep getting this error: 'missing required parameter: geotable' This is my code: # Retrive URL ...
0
votes
0answers
12 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"] = ...
1
vote
1answer
152 views

Help defining custom CRS in QGIS 2.2

I'm trying to use EPSG:4479 in QGIS. 1) If I search for EPSG:4479, it returns a "Imported from GDAL" EPSG:4479, but it does not work. At the console, the following message is displayed: ERROR 6: ...
0
votes
1answer
27 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
41 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
26 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
17 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": ...
1
vote
1answer
57 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 ...
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) ...
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 ...