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

learn more… | top users | synonyms

8
votes
2answers
393 views

How to avoid duplicate GIDs when copying features from one PostGIS layer to another?

When I enter new elements (features) in another Postgres layer, I can do it in two ways: Drawing new element(s) (with 'Add feature') which I do rarely or Copying (or cutting) some elements from ...
1
vote
1answer
741 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 ...
1
vote
1answer
141 views

Error in displaying wfs layer from mapserver/postgis

I have read and tested all the relative posts but I still don't have a solution for my problem. I have a layer suscribers (points) stored in postgis database with srid=32232. I would like to display ...
1
vote
1answer
204 views

How to store data for gis system?

I'm developing a GIS solution using Postgis database and geoserver as web map server. The solution to develop will analyzes the defects (as a polygon) and process parameters values (as a linestring) ...
1
vote
1answer
200 views

How can I map data points to OpenStreetMap (OSM) line data?

my goal is to filter measuring points of vehicles by mapping them to streets. So I could filter out all the false data located in fields and rivers and so on. I imported my data into a PostGIS ...
0
votes
1answer
30 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 ...
0
votes
1answer
17 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
1answer
21 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
1answer
33 views

Can't add a postgis layer in tilemill (symbol shown grayed)

I want to add a postgis layer to a tilemill project but the symbol is shown grayed and I can't select it (shown on the picture below). I followed this instructions.
0
votes
1answer
35 views

How to update raster metadata in postgis

How can I update the raster metadata in postgis? upperleftx | upperlefty | width | height | scalex | scaley | skewx | skewy | srid | numbands ...
0
votes
1answer
42 views

Delete all data from a PostGIS topology

I need to delete everything (faces, nodes, edges, anything I'm not thinking of) from a PostGIS topology, but I want to keep my database schema (schemas, tables, columns, sequences, etc.) intact. Is ...
0
votes
1answer
44 views

WFS with authentication to PostGis (or to shape)

Is there a way to import data from a WFS layer to a Postgis table (or to a shape)? there are blogs explaining how to do it in 3 steps (http://anitagraser.com/2012/09/26/wfs-to-postgis-in-3-steps/) or ...
0
votes
1answer
23 views

Road displays up to node, not up to starting point and ending point

SELECT id FROM table ORDER BY st_distance(the_geom, st_setsrid(st_makepoint($slng,$slat), 4326)) limit 1 ; get source and similar for target ; and then apply in dijkstra algo SELECT pgr_a('SELECT id ...
0
votes
1answer
83 views

How to query a PostGIS database through Geoserver and OpenLayers

I've built a web application using OpenLayers, which is connected to my PostGIS database through Geoserver. Now that I'm able to successfully display all of the layers, I'd like to add ...
0
votes
1answer
105 views

Geoserver+postgis+leaflet

I have been using the getfeatureinfo operation on layers published from shapefile and it works however the data which is being served from within postgis throws an internal server error. I am not sure ...
0
votes
1answer
21 views

How to get pgrouting source and target value using openlayers 2/3?

Is there anyone can teach me how to get the pgrouting's source and target parameters in openlayers 2/3? I plan to get those parameters by click the OSM map layer. Currently, I can only get the lonlat ...
0
votes
1answer
46 views

ST_Intersects returning incorrect result on routing problem

I have a table that contains the shortest path between destinations for survey respondents on an osm2po created network. When calculating the shortest path result, I store the geometry in a column. ...
0
votes
1answer
178 views

ERROR: Operation on two geometries with different SRIDs

I'm new when it comes to GIS and PostgreSQL. I have searched everywhere for the cause of this problem but I can't find the solution. I was following the documentation here First i created a table: ...
0
votes
1answer
49 views

geoserver and overlapping multipolygons from postgis

What does geoserver do when you get a result set from a postgis layer that contains multiple Geoshaps (of type multipolygon) that overlaps the same area? Does geoserver add the two overlapping values ...
0
votes
1answer
31 views

How to export query result on raster table in PostGIS

I did success query on a raster table in postGIS(raster data clipped by a vector polygon), now I want to view the query result in QGIS. But how to export the query result to another table. In vector ...
0
votes
1answer
67 views

Best method to find routes from a set of points

I have lines table (postgis enabled database) representing the streets. I have collected few gps points along a route and I would like to match it with the streets in order. Scenario - I am jogging ...
0
votes
1answer
78 views

pgr_dijkstra function not finding node that appears in ways table

I am having a problem with pgr_dijkstra algorithm not finding some of the node vertices in my table. I have a large dataset of survey travel diaries and am trying to determine their shortest paths ...
0
votes
1answer
67 views

Geometry to Shapefile

From importing the shapefile to postgis, its geometry is added to the database postgresql. The question, how can I load the shapefile in the Visual Basic.Net using the geometry in the database ?
0
votes
1answer
49 views

With osm2pgrouting, how to handle relations?

I'm trying to create a topology of the public transport in Paris. I use a OSM export, osm2pgrouting with the correspondent mapconfig.xml and Postgis. Everything works fine, except one thing. In ...
0
votes
1answer
57 views

Missing hstore column in TileMill!

I made a PostgreSQL with PosGIS Extension DB with the pgsnapshot_schema and loaded an .osm.pbf-file with OSMOSIS into it. Now i connected it to TileMill, but if i look up into the table i just see ...
0
votes
1answer
140 views

Drawing curved lines in CartoDB?

I am experimenting drawing curved line from Origin to Destination in Cartodb. I was able to do so once, however, failed the second and third time. Could anyone offer me some insights into the ...
0
votes
1answer
68 views

Calculating a vector raster intersection in postgis

I am using CartoDB and trying to calculate the total population (in raster format in popcount) within a specified distance to a line (vector data in mytable). The population data is at about 5km ...
0
votes
1answer
64 views

PostGIS Spatial Index not used after copying table

I am copying a PostGIS database from my computer to our webserver. I always had problems to copy the entire database using pg_dump and pg_restore so I am creating a new database on the server and copy ...
0
votes
1answer
151 views

Difference between 2 projections?

I have osm.xml file where projection is defined as follows: Map background-color="grey" srs="&srs900913;" minimum-version="2.0.0"> n settings.xml file projection is also set there as: <!ENTITY ...
0
votes
1answer
42 views

PGrouting encapsulated queries error [quotes problem]

I'm facing a quote problem on a pgrouting query. What I'm thinking is wrong is that my query only works if I use one, then four, then eight quotes on encapsulated queries. Is there a way to simplify ...
0
votes
1answer
65 views

Mapserver openlayer postgis spatial data are in postgis but label I want to display from webservice

My database of spatial data wkb is in postgis and my textual data is in sqlserver now is it possible to show labels through webservice. I have common id in both the database through which I can join ...
0
votes
1answer
81 views

TileStache:TileStache.Core.KnownUnknown: Couldn't get a layer from data source!

I want to use tilestache to get geojson files. I hava run tilestache-server.py -c tilestache.cfg ,and it works well. However,I want to get tiles from data stored in postgis. Maybe it will need to run ...
0
votes
1answer
43 views

Export .dbf maintaining column data type

I require a shapefile's .dbf to contain two types of text columns VARCHAR(n) and CHAR(n) to meet specs (attribute format) of gov receiving body. Have to send them the .shp, .dbf and .prj. Within ...
0
votes
1answer
67 views

How to get a distinct pair of column values based on minimum of another (computed) column?

I have two tables with point geo data, one (sfc_obs) with weather stations (names), one (smos_grid) with satellite pixels (dggs), and I'm trying to find which dgg is closest to each name using ...
0
votes
1answer
59 views

Self organizing maps with Postgis

I am trying to plot hot regions. It's reorganizing mapping We have a table "product" with three attributes : lat log n_items: number of items that we sell I'd like to group point in one polygon ...
0
votes
1answer
48 views

How can I combine two datasets with the same schema in to one table?

So I have two tables (in CartoDB/PostGIS) that are from two tiger shapefiles that have the exact same attributes, just in different counties. I want to combine them in to a single table, just ...
0
votes
1answer
70 views

Installing Cartaro using Acquia Dev Desktop and and link it with GeoServer and PostGIS

How do i configure GeoServer and PostGIS so that I dont get the following error when installing Cartaro using the Acquia Dev Desktop. I am just installing Cartaro locally for testing. Or how can ...
0
votes
1answer
107 views

Admin Sample GXP Viewer

I have Geospatial application which is using GXP, GeoServer, GeoExt and PostgisSQL. We would like to enhance the application by adding a user friendly Admin system, similar to what GeoNode has. This ...
0
votes
1answer
64 views

How to add Routing Table Query-Result on pgrouting?

I've followed the pgrouting latest workshop http://workshop.pgrouting.org. I wanted to know how to add the routing table query-result into my webpage directly after the route showed up? regards
0
votes
1answer
121 views

ST_Dump not working with geometry_dump

I am trying to ST_Dump a geometry_dump column comprised of points and paths in PostGIS 2.0 using SELECT (ST_Dump(geom)).geom FROM pointdump However, I get the error message 'function ...
0
votes
1answer
56 views

Issues with pgrouting workshop code in postgis 2.11/pgrouting 2.0

I'm having issues getting the pgrouting workshop to work on Postgresql 9.2/PostGIS 2.11 and pgrouting 2.0 on windows. How can I rewrite the following php/sql code and make it compatible with my ...
0
votes
1answer
81 views

Simplify table of linestrings

I have a PostGIS table of linestrings representing a road network. I want to simplify the geometries such that only lines that connect road junctions are stored. At the moment the table has a large ...
0
votes
1answer
34 views

How to modify existing geometry type or create new geometry type in PostGIS?

I want to modify PostGIS geometry type TRIANGLE by adding additional information about its neighbours within TIN. WKT representation might look as follows: TRIANGLEN ((0 0 0,1 1 1,1 0 2,0 0 0) ID n1 ...
0
votes
1answer
160 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
1answer
198 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 ...
-1
votes
1answer
90 views

plypython set-up

I am trying to set up plypython on the following system: Windows 8.1 PostgreSQL 9.2 64-bit PostGIS 2.0 Python 2.7.05 I have added plpython2.dll to \PostgreSQL\9.2\lib When I run: CREATE ...
-1
votes
1answer
243 views

Create a View with a new geometry field in PostGIS

I have a table in my data base. This table was created with differents fields as 'x','y' and 'z'. Now I need to make a view to generate a geometry column, but I found problems, because the created ...
-1
votes
1answer
27 views

The command for find the object

I got error message that shows "Object has more than 1 line in polyline". What is the command to find the object that has more than one line (such as error on number 100) Thank you
-1
votes
1answer
135 views

Shp2pgsql - exec() not allowed on external server

Me and my collegue are using the shp2pgsql and psql commands in php code (a Drupal module to be precise). We put these commands in a php variable and use the exec() command to execute them. This ...
-2
votes
1answer
67 views

Render specific vector data from database with openlayer

I want to render some data on a map. They are stored as points in my database (postGiS), each one is associated with a name. I want to render points with the same place name in the same color. ...