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

learn more… | top users | synonyms

0
votes
0answers
207 views

Function ST_Transform postgis 2.0

I've read many forum posts on the function ST_Transform but unfortunately was unable to resolve my doubts so I posted a new question. I have a spatial table SRID = 101010 and want to transform it to ...
3
votes
2answers
300 views

Does PostGIS have separate implementation of GiST index from PostgreSQL?

I want to know if PostGIS has a separate implementation of GIST index or it reuses the GIST index implementation provided by Postgresql?
0
votes
1answer
487 views

postgis, st_within, and a join

So I'm in the middle of learning postgis/postgres. I've a polygon table. I've a point table. The polygon layer contains a foreign key that points to another table. For the example the Foreign key ...
3
votes
1answer
587 views

How to get the width and height of a rectangular polygon in PostGIS

I have a table with point features saved in the my PostgreSQL database, and I can run the following query to get the extent of the point features and I turned the extent back into a geometry: SELECT ...
1
vote
3answers
224 views

How to complete the roads output of PostGIS?

I converted the file I exported from OSM to PostGIS using osm2pgsql. I have opened the table's outputs to QGIS and I saw data are not complete compare to OSM editor view. Most of the roads are broken ...
1
vote
1answer
173 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?
0
votes
2answers
62 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
81 views

Function get_partition(geometry, unknown) does not exist - Nominatim tiger data import

Ive install Nominatim with postgres9.3 and postgis 2.1, imported osm data ok and now trying to import tiger data (tiger2013 edges) for the house numbers. The import looks to go ok, but there is no ...
0
votes
1answer
78 views

SLD function/transformation based on table values

I'm trying to accomplish an apparently simple task, to display some lines from a postgis table, but I don't know how to do it. The table has, say, 3 fields, one for the geometry and the other two have ...
-1
votes
1answer
105 views

ST_buffer display creates big circle [closed]

$result = pg_query("SELECT ST_Astext(ST_Buffer(ST_GeomFromText('POINT( 80.7605 7.67833 )'),1))"); ST_buffer display creates big circle..
1
vote
0answers
74 views

PostGIS points to multipoint error

I have a table on PostgreSQL 9.2 ("POSTGIS="2.0.1 r9979" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.8.0, 6 March 2012" LIBXML="2.8.0""). This is it: CREATE TABLE nearest_point ( id_nearest_point serial ...
1
vote
1answer
1k views

MapInfo 12 problems with PostGIS database

I am simply trying to connect MapInfo 12 to my existing PostGIS database but after hours of trying various options I have hit a brick wall and need help. So far I have: 1) Downloaded and installed ...
0
votes
0answers
117 views

mapserver postgis

I have a problem with my connection to my db. I get this message: msPostGISLayerOpen(): Query error. Database connection failed (fe_sendauth: no password supplied ) with connect string ...
0
votes
1answer
140 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
2answers
191 views

Building PostGIS with SFCGAL from source fails

I'm trying to build latest PostGIS (2.2dev) with SFCGAL. SFCGAL is installed in /usr/local/lib, and includes are in /usr/local/include/SFCGAL I've run configure as: ./configure ...
1
vote
0answers
447 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
109 views

PostGIS: Update child geometries based on parent

I'm using Leaflet and postgis in a case where using Leaflet draw plugin I draw a polygon first like this Now, I draw a line which cuts the polygon and using line and polygon geometry, based on ...
0
votes
1answer
118 views

Empty geometry resulting from pgrouting function

Let me start by saying I'm assuming I'm missing something very silly but I can't see it. I have a table of points and I'm trying to generate a polygon around each point that estimates a maximum of ...
1
vote
0answers
383 views

Problem inserting feature into GeoServer empty layer via WFS-T

I'm facing a strange issue with GeoServer (2.4) (on PostgreSQL 9.4/PostGIS 2.1). The problem is I am not able to insert a feature via WFS-T if the layer is empty; it returns me the following error: ...
4
votes
2answers
200 views

What does 'to the right' mean, regarding the >> operator in PostGIS?

I am reading the documentation on the >> operator in PostGIS, and I cannot understand the meaning of strictly to the right because on the plane, right or left depends on the direction at which ...
1
vote
2answers
119 views

In mapserver, how would I style polygons differently based on a separated points layer?

I have 2 tables in postgis - one of type polygons and one of type points. I want the color of the polygons to be related to the number of points within each polygon, say white when no points are ...
1
vote
2answers
259 views

Enlisting all OpenStreetMap (OSM) street names for General Transit Feed Specification (GTFS) routes?

I have exported OpenStreetMap (OSM) data of a city to my local postgresql db using osm2pgsql. I would like to add the General Transit Feed Specification (GTFS) routes information (say bus routes) ...
0
votes
0answers
57 views

rasterize table polygon postgis 2.1

I would like to rasterize a postgis 2.1 polygon table, but I don't undersand how to create the SQL function syntax for ST_AsRaster. My vector table has 3 fields: gid, recharge, and geom. The SQL ...
2
votes
4answers
527 views

Create shapefile from data PostGIS or KML using Java

I'm working on a geographic information system project, whose products form shapefiles. I am using the Java programming language and a PostGIS database. Is there a way to generate a shapefile from ...
0
votes
1answer
227 views

Create shapefile from data postgis / kml using java [duplicate]

I'm working on a geographic information system project, whose products form shapefile. I am using java language, and PostGIS database. Is there a way to generate a shp file from PostGIS or kml using ...
3
votes
2answers
202 views

Custom OSM, styling points

I have my own OSM file, which is created by some application which I written. You can see some of nodes in my OSM file bottom of the post. I want to fill +/-0.0001 latitude, +/-0.0001 longitude ...
1
vote
1answer
141 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 ...
0
votes
2answers
88 views

Failed to convert multilinestring to linestring

I tried to convert some multilinestring data into linestring using: SELECT ST_AsText( ST_LineMerge( ST_SnapToGrid( ST_GeomFromText(the_geom), 0.001) ) ); and ...
5
votes
4answers
3k views

Heat map / Density map from dynamic points table in MapServer (GeoServer)?

How can I create a heat map (some would call a density map) from a points layer in MapServer (or GeoServer)? (preferably able to choose Interpolation method, NN, IDW, etc and color map with a ...
0
votes
3answers
834 views

postgis insert query to store geometry and other data

I'm using Postgis functions st_dump and st_split to split a polygon based on line. Now, after splitting; output geometry stores in a database table as well. Here is the query: insert into aoo(geom) ...
1
vote
2answers
445 views

Find out whether geography point lies within geography bounds

I have three points: Point A Point SW Point NE I want to know if Point A resides within the bounds determined by points SW (for south-west coordinates) and NE (for north-east coordinates). I've ...
3
votes
1answer
500 views

Is there any random data generator supporting geometry in PostGIS?

I found few random data generators for PostgreSQL (such as this one), but none supporting PostGIS geometry type, other than point. Making points would be quite easy, but for lines with multiple nodes ...
0
votes
2answers
267 views

PostGIS pgr_dijkstra function does not find 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
111 views

PostGIS Group By Error [closed]

I am performing a pretty simple query in PostGIS 2.1.1 from within QGIS 2.2 for Windows (using the DB Manager plugin). I have a table with many columns and I am trying to perform a Group By function. ...
1
vote
2answers
78 views

PostGIS schemas doesn't show in QGIS

I try to use QGIS to display some data stored in PostGIS, some of schemas don't show except public; And it's a testing DB, so I have only one super user: postgres. I use PostgreSQL9.3. Anyone has some ...
8
votes
1answer
241 views

Suitable algorithms for simplifying isochrone polygons

I'm looking for an algorithm for simplifying isochrones which were generated using OSM data. These are generally characterised as having lots of small "holes" mostly due to missing OSM data but also ...
0
votes
1answer
203 views

Intersecting great circle arcs and polygons

I am trying to find the point of intersection between a great cirle arc and a polygon. I am working in long/lat, where I am given the endpoints of the great circle arc, A and B, and the vertices, C, ...
1
vote
1answer
2k views

PostgreSQL/PostGIS: create spatial view

I have a polygon layer and a point layer. 1) I wrote a spatial query to count how many points fall in each polygon: SELECT polR.codeR, count(pntAZ.geom) as tot_pntAZ FROM boundaryR as polR LEFT ...
1
vote
0answers
33 views

Designing a database for Kinect cloud data [closed]

I'm developing a navegation system with a kinect, by this moment I can obtain a cloud points(X, Y, Z, RGB), the idea is to introduce the point cloud (X,Y,Z) into a database postgreSQL with postGIS ...
3
votes
1answer
161 views

Should I use a projection or not, and if so what SRID would be useful?

First off, I realize that this is perhaps not the most stackexchange-esque question. I am however having trouble finding a good source of information for this. So if there is a better place for me to ...
1
vote
1answer
666 views

Add GPX files to postgreSQL database and add one column with a given value

I already found out how to add a gpx track information into my postgres database: `ogr2ogr -append -f PostgreSQL "PG:dbname=your_db user=xxxx password=yyyy" filename.gpx` Everything works fine but ...
0
votes
1answer
161 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
91 views

rubber sheet a polygon collection into another - postGIS

My question is this: How do I create a 4 x 4 grid over the orange grid like the pink(ish) one? The pink grid are geometries that have already been provided and are wonderful. I'm attempting to ...
0
votes
2answers
272 views

Postgis: ST_Buffer breaks because of no forward edges

I try to buffer a huge road network using ST_Buffer. After 8h of processing I get an error message: ERROR: GEOSBuffer: TopologyException: No forward edges found in buffer subgraph Here is my query ...
0
votes
2answers
128 views

Common Web Server for Web Mapping?

I'm planning to create interactive routing map system( for small town only ) which will be running online. My server side language will be PHP and PostGIS/PostgreSQL with using pgRouting and client ...
1
vote
2answers
109 views

How to bring all “tourism:attraction” from points table and polygon table together?

Im using OSM data as osm2pgsql-import (from extract.bbbike.org). And I want to draw all attractions ("tourism" = 'attraction'). The most of the attractions I found in the planet_osm_point table. But ...
2
votes
1answer
169 views

Spike finder in PostGIS

I tried to modify spikeRemover from Schmidt & Krüger. My goal it's to obtain, for each polygon, the position of the spikes. I don't need to remove it. For some reason, that I can't figure out, my ...
0
votes
1answer
72 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 ...
3
votes
1answer
77 views

OpenGeo/Geoserver: can I have a store that access more than one PostGIS schema?

I have an existing PostGIS database that I use with QGIS. I am now looking at options for getting some of this data up on the web. Hence OpenGeo. I have Geoserver installed and running and have ...
1
vote
1answer
106 views

How can I convert SRTEXT to PROJ4TEXT with QGIS

I have a SRTEXT like this: GEOGCS["My Data",DATUM["Not specified (..... I want to get PROJ4TEXT of this STREXT. Can I get it from QGIS. Because I want to insert it in Postgresql SPATIAL_REF_SYS ...