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

learn more… | top users | synonyms

1
vote
1answer
185 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
54 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
59 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
59 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
1answer
78 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' ...
0
votes
0answers
27 views

time complexity of selected algorithm - SQL

I use PostGIS - SQL 1) I need know time complexity of algorithm which in I use these functions: ST_Equals, ST_Overlaps, ST_Distance_Spheroid and ST_Dwithin Is a time complexity diferent when I use ...
1
vote
1answer
62 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
37 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 ...
0
votes
0answers
104 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
152 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
39 views

in mapserver, how would i style polygons differently based on a seperated 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 ...
0
votes
2answers
91 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
40 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 ...
1
vote
1answer
121 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
79 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
106 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
48 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
votes
1answer
28 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 ...
3
votes
4answers
279 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
0answers
60 views

Multiline String to Linestring conversion

I have road network table which is multilinestring.I was trying to convert this file to Linestring using the following query ALTER TABLE multiline ALTER COLUMN the_geom TYPE geometry(linestring,4030) ...
0
votes
3answers
82 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
102 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 ...
2
votes
1answer
79 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
1answer
64 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
37 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
48 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 ...
6
votes
1answer
98 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
74 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
144 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
22 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
86 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 ...
0
votes
1answer
107 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
56 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
53 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
0answers
74 views

within using Hibernate Spatial

I'm doing this query using postgis and working properly SELECT "public".zona."id", "public".zona.zts FROM "public".zona WHERE ST_Within ( Geometry ( st_GeographyFromText ...
0
votes
2answers
73 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
70 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
60 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
55 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
41 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 ...
2
votes
1answer
32 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
34 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 ...
2
votes
1answer
114 views

Using ST_split to split a line feature using nearby points

I have a line shapefile and a point shapefile, and the line has just one segment and its attribute table, the point shapefile has points near the line above, not on it and the close ...
1
vote
2answers
96 views

Is it best to use multipolygon or polygon features for large intersect operations?

I have two large layers that I want to do intersect operations. One is municipalities and the other is landuse. Right now, the landuse layer is of MultiPolygon type that is, for the entire state, I ...
0
votes
3answers
158 views

ST_transform postgis

SQL within that zone is a point SELECT "public".zona.zts FROM "public".zona WHERE ST_Within ( ST_Transform ( ST_GeomFromText ( 'POINT(-30.033514 ...
0
votes
0answers
367 views

Postgres SSL SYSCALL error: EOF detected with python and psycopg

Using psycopg2 package with python 2.7 I keep getting the titled error: psycopg2.DatabaseError: SSL SYSCALL error: EOF detected It only occurs when I add a WHERE column LIKE ''%X%'' clause to my ...
0
votes
0answers
158 views

libgdal1 and libgdal1h conflict

I am on Ubuntu 14.04. When I am installing PostGIS-2.1, it's asking for libgdal1 library. But when I am installing libgdal1, it's removing grass and gdal. Can someone please guide me how to install ...
4
votes
1answer
107 views

Can I use a QGIS geometry in a Python PostGIS query?

I have a "Python Init function" for the attribute form in QGIS, which is called when I add a new geometry. I can access the geometry of the newly created feature like this geom = feature.geometry() ...
1
vote
0answers
52 views

Is there a Raster2pgsql GUI?

Has anyone ever attempted to create a raster2pgsql gui (like the shp2pgsql gui). As I am sometimes lazy to use command line, this could be a very nice to have.
0
votes
1answer
69 views

postgis finding lines that touch and update

I am not much of a postgis guy so please bear with me. I have a subset of lines representing exits and roads around those exists. Main roads and exists can be distinguished by their class attribute ...