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

learn more… | top users | synonyms

11
votes
0answers
255 views

How to query OSM for all beaches facing west? - QGIS preferred

I want to identify all beaches on this planet (or a given subset of it) that are facing westwards (+/- 20-30 degrees). My idea is to use OSM as the data source. Extracting all polygons that have the ...
5
votes
0answers
694 views

How to create a routable road network from Ordnance Survey data?

I've been following the "Beginners Guide to pgRouting" in an attempt to create an in-house application that provides drive-time isochrones. I have a server, postgreSQL and PostGIS and pgRouting - no ...
4
votes
0answers
51 views

Compute visibility graph on sphere

I have a PostGIS table with some polygons (stored using the geography data type). They represent regions on a spherical earth. For each pair of vertices chosen from among all the polygons, I want to ...
4
votes
0answers
199 views

How to create a topologically correct dataset in PostGIS (with GRASS)?

I have shapefiles which I have loaded in postgis and now i am trying to use geometric function in postgis like ST_intersect and they fail because the data is not topological correct. I have tried to ...
3
votes
0answers
290 views

Hibernate Spatial - 'Invalid endian flag value encountered' Exception

I'm trying to run a simple query in Hibernate Spatial 4.0 on PostgreSQL 9.3. I have a number of objects in a table with latitude/longitude values, and I'm trying to query objects that fall within a ...
3
votes
0answers
62 views

Why are date vaules displaying a trailing 'Z' when layers are published with Geoserver and a PostGIS data store?

I have published various layers using Geoserver 2.2.x with a PostGIS 2.0.1 (PostgreSQL 9.1.x) data store. Fields that only have date values and not time/timestamp related values are stored as date. ...
3
votes
0answers
196 views

Finding poi using st_dwithin in postgis

I am not familiar with gis or writing sql, so my understanding in this field is lacking. I have a hundreds of lat/lng geographic coordinates stored in a single table called Places like this: ID | ...
3
votes
0answers
194 views

Find points that fall within a radius using Hibernate Spatial

I am using hibernate spatial and postgis and i want to find the points that fall within a certain radius. Using this SQL: SELECT name FROM institution WHERE ...
3
votes
0answers
108 views

Joining layers with respective elements with PostGIS Topology

Recently I have started using PostGIS topology extension, but I have some difficulties in understanding how the structure works: One of the key points is the use of "layer"s: as of what I understand, ...
3
votes
0answers
302 views

Extracting x,y,z values from a postgis linestring to python using ogr

I am trying to load a postgis linestring into python (using ST_DumpPoints) and extracting x,y,z coordinates, which is working but extremely slow..and if i mean slow, i really mean it (yes, it takes ...
3
votes
0answers
166 views

Where can I find PostGIS error codes?

Using ST_Contains in where clause sometimes gives me error messages like ERROR: GEOSContains: TopologyException: side location conflict at 37.3706 55.7882 For now I can't guarantee validity for ...
3
votes
0answers
177 views

building larger polygons from smaller ones *without* a common id in PostGIS

I am looking for a means, using PostGIS, of reconstituting a set of polygons from tens of thousands of smaller polygon 'pieces'. This is a simplified example, with the pieces shaded: Unfortunately ...
3
votes
0answers
185 views

Creating Ellipse in WGS84, but with metric parameters

I have the function --Ellipse(x,y,rx,ry,rotation,#of segments in 1/4 of ellipse) SELECT ST_Translate( ST_Rotate( ST_Scale( ST_Buffer(ST_Point(0,0), 0.5, $6), $3, $4), $5), $1, $2) I have points in ...
3
votes
0answers
219 views

Is there a way to start the route on pgrouting from a coordinate that is not a node?

After execute all steps from this pgRouting tutorial, now I have a map that creates and displays routes, but as the routing methods rely on parameters representing vertex Ids that was created using ...
3
votes
0answers
291 views

Geoserver WMS-T backend problems

I've been trying to set up a few timed WMS layers in GeoServer. They're simple enough, of the form ID(PRIMARY KEY) REGION DATE VALUE so for every region and date you have some value, e.g. the ...
3
votes
0answers
121 views

Create a consistent topology using pgrouting

I'm developing an application that needs routing information for certain cities. First, I downloaded a openstreetmap datafile (*.osm) and then I imported it into a postgreSQL database using ...
3
votes
0answers
258 views

Shortest distance from pgrouting with cost not being length: optimal solution

I'm using pgrouting shortest_path_astar with a complicated cost function. It gives back the edges, vertices and costs. I would like to get the total distance of this shortest path (i.e., the sum of ...
3
votes
0answers
359 views

How to save table from PostgreSQL to MapInfo File?

I have two tables: 1 with geometry in WGS 2 with geometry in Local System I tried this: ogr2ogr -f "MapInfo File" output2.tab PG:"host=localhost user=postgres password=123456 dbname=postgis" -sql ...
3
votes
0answers
454 views

How can I properly add PostGIS data into MapGuide Maestro?

I am having trouble connecting a PostGIS database to MapGuide Maestro. Actually, I have added the PostGIS data into Maestro, but when I click to validate the layer it shows an error message: ...
2
votes
0answers
20 views

PostGIS query with input from point layer

I have a table of rivers in PostGIS, each river linking to its outflow. I also have a QGIS layer of some selected sources, and would like to select the entire river downwards from each source (i.e. ...
2
votes
0answers
79 views

TileMill Exports Failing

I'm having trouble exporting my map in TileMill (v0.10.1). I'm using OSM Bright with a PostGIS database connection to import OpenStreetMap data. When exporting an SVG or PDF through the user interface ...
2
votes
0answers
54 views

QGIS is not working with Postgres Plus Advanced Server

We have a problem to integrate GIS software with our GIS database which is populated on Postgres Plus Advanced Server 9.2 from EnterpriseDB. We are using QGIS to maintain and analyze our GIS ...
2
votes
0answers
57 views

how do I create a RESTful PostGIS web Service Framework?

I have PostGIS tables that store vectors that want to show on Google Maps. Read the post http://gis.stackexchange.com/questions/22354/how-to-display-a-postgis-table-on-google-maps But one thing that ...
2
votes
0answers
29 views

Feature service requires registered database error?

I am working on ArcGIS Server 10.2 and SQL Server 2008. when I want to publish the service, I get this error "Feature service requires a registered database" that's error happen when I read (List By ...
2
votes
0answers
140 views

Raster slightly displaced after exporting from PostGIS database

With the following queries I've exported a raster (GTiff) from my postgis database: 1.Creating a large object: WITH buffer AS ( SELECT id, ST_Buffer(geom,50) AS geom FROM ...
2
votes
0answers
51 views

PostGIS does not export shortest path to Shapefile

I am trying to draw a bunch of lines overlaying the globe map in a WGS84 projection. To this effect I have created a PostGIS DB with a table that has one column containing linestring data. My problem ...
2
votes
0answers
31 views

PostgreSQL : Question about dropping tables inside funtions

I am writing a PostgreSQL code where I have a function wich is used multiple times in a single query with different input values. Inside the function I create some tables and use them. What is the ...
2
votes
0answers
53 views

How to set posgis default sequential value in a QGIS “editable” view?

Introduction In a QGIS project I have a VIEW, that I want to became editable (I'm trying to replicate the versioning system used DB Manager with some tweeks). Therefore I created a few rules to ...
2
votes
0answers
61 views

How do I simplify the straight sections of (multi)Linestring in PostGres/PostGis leaving the curved sections untouched

I have (multi)linestrings containing upwards of 5000 points and I want to perform two simplifications possibly using Ramer Douglas Peucker or alternative methods in PostGis The (multi)linestrings ...
2
votes
0answers
72 views

Interpretation of PostGIS geocode function ratings

Edit: I am using Postgres 9.2 and recently installed PostGIS along with the Tiger Geocoder from the extras folder and downloaded all the latest Tiger data. I have been testing the Tiger Geocoder ...
2
votes
0answers
229 views

How to use the linear referencing plugin?

I need a guide how to use this plugin properly, I'm a newbie on PostGIS and I'm trying to use the linear referencing plugin of QGIS. I've created a database on postgreSQL with the postGIS extension ...
2
votes
0answers
137 views

Publish existing table from postgis to geoserver

I would like to know if there is any way for publishing existing table from postgis to geoserver using Geoserver REST API or geoserver-manager java implementation. The thing is that i'm actually ...
2
votes
0answers
151 views

Postgis - extrude a polygon

I want to extrude a polygon shape in postgis to create a pseudo 3D effect. To this end I have written a crude function to achieve it. This is very much test code and it creates a new Y vertice for ...
2
votes
0answers
237 views

import esri Personal Geodatabase (.mdb) to PostGIS

I would like to import an esri Personal Geodatabase (.mdb) to PostGIS. I have tried to follow the blog post: How to import esri Personal Geodatabase (.mdb) to PostGIS on Linux I installed the GDAL ...
2
votes
0answers
321 views

Feature Service from plain Postgres/PostGIS in ArcGIS Server 10.2

Using 10.2 Arcmap/ArcGIS Server on Windows I've successfully published some map services from my Postgres/PostGIS data and now I want to enable editing the features through a JavaScript web app. This ...
2
votes
0answers
60 views

Is there an ArcGIS to PostGIS function cross-reference table?

I was looking back at the presentation called "PostGIS Tips for Power Users" by Paul Ramsey and got to thinking... Has anyone ever seen an ArcGIS Geoprocessing Tool to PostGIS function cross-reference ...
2
votes
0answers
57 views

Using ST_Affine() and trans_param() functions on vector layer

After reading this post How to georeference a vector layer with control points? I decided to give it a try to move/rotation/scale a polygon using Postgis. I have two polygons, polygon_from and ...
2
votes
0answers
160 views

Styling river charts with TileMill - issue with filling a polygon made of disjoint line segments

I am trying to style inland river charts produced by the Army Corps of Engineers. I imported the vectors into Postgres, and I’m using TileMill to style the data. I am having trouble correctly filling ...
2
votes
0answers
65 views

Add attribute table to a raster in postGIS

I would like to add attributes to a raster stored in a postgis database. I use the following command to insert the raster in the database: raster2pgsql -s 4236 -I -C -M ...
2
votes
0answers
43 views

Update PG table setting an area_id

I have a table with lots of points which I'd like to update and set a consecutive area_id to every point "group". I define a point "group" as points that are within a 500 meters radius. The raw table ...
2
votes
0answers
29 views

Geoserver Feature Versioning Support

I am creating a map feature editor that supports versioning & rollback using Geoserver as the WFS. From what I've read online, it seems Geoserver supports feature versioning. My question is how ...
2
votes
0answers
202 views

Migrating from PostGIS to Oracle Spatial

We are now using a solution based on PostGIS extension of Postgresql database for various spatial queries. But we are now thinking about data security. This is why we have a plan to migrate existing ...
2
votes
0answers
245 views

Smooth, not simplify, lines features in PostGIS

I'm trying to automatically generate paths to place labels on that follow the shape of rivers, 4wd tracks and other very windy lines. At first I thought the st_simplify() function was the answer, but ...
2
votes
0answers
103 views

Find and destroy duplicate OSM multipolygon/polygons in TileMill/PostGIS

In OpenStreetMap there are sometimes multipolygons where attributes are present on both the polygon and the multipolygon relation, such as the Grampians National Park: ...
2
votes
0answers
46 views

Can't connect to WMS service? An Amazon-EC2 problem?

I'm running GeoServer 2.3.5 on a Windows instance in AWS for the first time. The data is on the server in PostGIS. The map layers have been published and I can see them locally without any problems. ...
2
votes
0answers
127 views

Spatial Precision for Editing in Multiple GIS Clients

I have something I'd like to discuss, I'll try to explain it first, why it's important, and I'll explain how ArcGIS handles the issue, which I think is a good way to handle it. Finally I'd like to ...
2
votes
0answers
88 views

Large buffers in PostGIS (5000 km radius)

I have a number of points stored as geographies in PostGIS (version 2.0.1), and I'd like to create rather large buffers around them (with a radius of 5000+ km). However, ST_Buffer doesn't handle this ...
2
votes
0answers
204 views

3D features (Polyline, Polygon) intersection library

For my research I am looking for a (python) library to get the intersection of some 3D features. The features can be Polygons or Polylines. Mostly I need to intersect a plane with my features and get ...
2
votes
0answers
129 views

get all the possible parameters of sql view

I have a Geoserver layer coming from a postGIS database. Among other attributes, I have one that is related to the date data we've collected, called departuretime. We use this attribute to display a ...
2
votes
0answers
52 views

Optimize ST_CoveredBy performance

I have a PostGIS 2.0.3 table with 113,862 records with multipolygons represented both as geometry and geography. There is a gist index on each of them. I'm running the following queries: SELECT *, ...