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

learn more… | top users | synonyms

1
vote
1answer
71 views

Is there a PostGIS function to get a tangent and normal line?

I'm looking for a function that will return a tangent (and normal) for a LINESTRING in PostGIS. I think this is the 3rd time I've come across the need for this function and everytime, I end porting ...
1
vote
1answer
57 views

Merge polygon based on other line shape file PostGIS

I have a polygon shape file and a line shape file. I would like to merge two polygons which shares the same border along with line shape. Finally the line should be removed in polygon shape file. In ...
1
vote
1answer
51 views

I'm not able to save edited layer connected via PostGIS in QGIS

I have project and i was doing editing layers in QGIS. These layers are connected in QGIS via PostGIS. 1 layer of the 4 layers was saved correctly but other layers gave me error message. Error ...
1
vote
1answer
60 views

Implementing Wrapper of PostgreSQL?

How can I implement the Wrapper of PostgreSQL? I found this useful looking wrapper from a FOSS4G routing with pgRouting Workshop but I do not know how to implement it!
1
vote
1answer
157 views

Union of several linestring to multilinestring using MS SQL Server

Followed Postgreql query is the existing one used to combine serveral linestring to a single multilinestring. is there any equivalent of this in SQLServer . SELECT ST_AsText(ST_Collect( ARRAY[ ...
1
vote
1answer
81 views

How to write a (memory) layer from QGIS to PostGIS?

I am looking for an "elegant" solution to write, from a python script, a layer from qgis and into a new table of a PostGIS database. I thougth that this might be solved by QgsWriteVectorLayer, but I ...
1
vote
1answer
76 views

POSTGIS Raster - Merge polygon onto raster

I have two tables, SCHEDULE contains polygon geometries and RASTER contains raster tiles I want to take a polygon from the SCHEDULE table and overlay it on top of a set of RASTER tiles that intersect ...
1
vote
1answer
158 views

Counting self intersections of linestring using PostGIS?

Is there a way of using PostgreSQL + PostGIS for finding the number of self intersections in a linestring? I have a linestring that goes forward but in circles, and I need to find the number of times ...
1
vote
1answer
73 views

shape file into DataSet in postGIS using openJUMP, but getting error

I am new to this field and I want to save my shape file into DataSet in postGIS using openJUMP, but I'm getting an error...can anybody tell me solution for this?
1
vote
1answer
153 views

SQL-query should return GeoJSON FeatureCollection

I'm trying to return a GeoJSON FeatureCollection object from a SQL-query with PostgreSQL 9.3 and PostGIS 2.1. This is my query so far: SELECT row_to_json(fc) AS p FROM (SELECT 'FeatureCollection' ...
1
vote
1answer
61 views

Will ogr2ogr correctly merge features from several OSM files to resulting set

In GDAL >= 1.10, ogr2ogr contains osm driver I want to try this feature and migrate OSM to PostGIS (I'm aware of osm2pqsql existence) I have several relatively small OSM files and wonder if ...
1
vote
1answer
190 views

Geoserver OSM data Imported via osm2pgsql - most efficient tables to use to style roads

The Osm2pgsql importer for OSM data to Postgres results in two tables for ways, one called planet_osm_roads and a second one called planet_osm_lines The Osm2pgsql documentation states that the ...
1
vote
1answer
49 views

Why is “Add feature” of the GPS Information tool inactive for some of my PostGIS layers?

Sorry If I rise it again on this forum but I couldn't find any info on limitations/requirements of "GPS Information" tool for QGIS (2.2.0) against data layers. For some layers I'm able to collect ...
1
vote
1answer
195 views

How to calculate the track length of GPX files with PostGIS?

I am trying to calculate the length of a GPX track. The original GPS data looks like this: <?xml version='1.0' encoding='UTF-8' standalone='yes' ?> <gpx ...
1
vote
1answer
94 views

How to split/divide linestrings of larger lengths in postgis

I want to split/divide linestrings in my data. I have roads data and I want to have every road segment having length not more than 250 meter. Check the shape length of this particular line feature. ...
1
vote
1answer
76 views

convert XML to PostgreSQL using MATLAB

In a weeks time I should be able to transfer the GIS data provided in the XML format to PostgreSQL database. I have prepared the PostgreSQL database (empty) and looking at Matlab scripts. (I am on ...
1
vote
1answer
70 views

PostGIS transform geometry with long crs

How do i transform a geometry to a new geometry with a crs like urn:ogc:def:crs:EPSG::25832 st_transform(geom,integer srid) obviously doesn't work since my srid is a string found a solution ...
1
vote
1answer
120 views

Connecting to PostGIS (LATIN1) from Microsoft Access 2010 - Encoding problem?

I want to connect to a PostGIS table Using MS Access. The table has been created using the PostGIS Shapefile loader in pgAdmin. It has been encoded at LATIN1 (it wouldn't load with UTF-8 default). I ...
1
vote
1answer
94 views

Openlayers wfs no fid being passed from tinyows

I have a webapp - OpenLayers<->tinyows<->postgis. With 1 layer I have a problem. On localhost all works well - here is a snip of the xml I get back: <gml:featureMember> <tows:trad ...
1
vote
1answer
105 views

using postgis function in pyqgis

I'd use Postgis function in Pyqgis script. This code: qsql="(select gid, id, St_Buffer(the_geom,200) as geom from archi)" uri = QgsDataSourceURI() uri.setConnection("ip", "port", "x", "x", "x") ...
1
vote
1answer
68 views

Rewrite query to match two points with a linestring in a different database table

OK, not sure if I've worded the title brilliantly, but here goes: Suppose I have: a table "gps_nodes" containing columns: "EASTING" (containing longitude data) "NORTHING" (containing latitude ...
1
vote
1answer
121 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
1answer
68 views

Google Map API and OS Opendata in QGIS

I'm new to gis and having problems with matching reference systems for my two data sources. I have downloaded some OS Vectormap data which I believe is in 27700.. And I have some longitude and ...
1
vote
1answer
780 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
168 views

Error printing pdf in OpenGeo Suite client SDK app

I am using OpenGeo Suite 3.0.2. I created an app using Client SDK and stored the raster and vector data on postgreSQL/PostGIS. The print tool is not working, giving error the following error: ...
1
vote
1answer
217 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
39 views

How do I create a new vertex in the middle of an edge in postGIS?

I have a postGIS database populated with OSM data with the osm2po import tool. I have a number of fixed points that I want to route between using pgrouting. In order to do this accurately, I want to ...
0
votes
1answer
59 views

pgRouting cannot find extension control file

I am trying to use pgrouting on OS X. I installed the following: brew install postgres brew install postgis brew install pgrouting When I try to create the extension pgrouting I get the following ...
0
votes
1answer
46 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
18 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
24 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
38 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
48 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
23 views

What do pixeltypes in PostGIS raster mean?

I'm trying to build a raster in PostGIS from a vector layer and I was curious as to the meaning of pixeltypes in the raster geometry? How does it effect my raster?
0
votes
1answer
48 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
24 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
105 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
134 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
23 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
219 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
50 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
33 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
68 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
81 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
50 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
59 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
159 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
70 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 ...