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

learn more… | top users | synonyms

2
votes
1answer
116 views

Empty geometries in GEOMETRYCOLLECTION

I just noticed some strange behavior in PostGIS, with respect to WKT parsing. A GeometryCollection containing 1 or more empty geometries postgis_test=# SELECT ...
1
vote
1answer
47 views

Force St_split() to return geometries in specific pattern

I'm Using PostGIS st_split() to split a polygon geometry by a linestring. Then I use st_dump() to return each of the splitted geometry and it is working fine. But the issue is I want to force ...
1
vote
1answer
107 views

Geometry has incorrect latitude-longitudes

SELECT ST_SRID(geom) AS s FROM zones GROUP BY s; returns a single record: 4326 SELECT Find_SRID('public', 'zones', 'geom'); returns 4326 SELECT AsText(geom) FROM zones returns geometry like: ...
1
vote
1answer
32 views

Postgis create polygon extent/convex hull from spatial table

Please help, I have a polygon layer representing building footprints. I want to create new view in postgis that will contain rectangle representing bounding box and also another view that will have ...
1
vote
0answers
35 views

Looking for free tools to automatically generate spatial data catalogue

I've recently inherited a whole bunch of spatial data (mostly shapefiles but some .gdbs) which relate to a bunch of different cities. I'm looking for a way to take an inventory of what data I've got ...
2
votes
1answer
167 views

Get Multiple Shortest Path using PgRouting in One Query

I am trying to get multiple shortest path using A* Algorithm available in PgRouting. I referred Solution given by UnderDark ( Link of the Stakoverflow Post ) . But it is not giving me proper Output. ...
0
votes
1answer
65 views

Postgis: Traslate geometry from EPSG:23030 to EPSG:21818, then to lat long

I'm from Colombia, South America. I'm a computer programming student and I have to develop a prototype for a GIS system for my small home town using Postgis >= 2.0 as database back-end. The local ...
2
votes
1answer
126 views

using PostGIS to calculate distance of a route over a large area

I'm new to PostGIS and looking to measure the distance of the Pacific Crest Trail which spans western North America from Canada to Mexico. I have a data set containing the lat lon and dates from GPX ...
5
votes
3answers
3k views

Bounding box for PostGIS table

Is there an easy way to get the bounding box for an entire table in PostGIS? Thanks
1
vote
2answers
41 views

Missing some lines after import of .PBF int PostGIS

I've a little problem with either the initial data (from Geofabrik) or the import (using osm2pgsql): I can't find some lines of a street in my city in the database while they are there on the OSM-Site ...
0
votes
3answers
55 views

Problem with Geometry SRID in PostGIS

i ceated my table (borne) in PostGIS id_borne serial NOT NULL, num_borne character varying, shape_borne geometry and i changed the SRID of my table with succes using select ...
1
vote
3answers
403 views

Load information about a feature

I must mention first of all that I am very new to this area... I am developing a GIS application. I created a simple map using geoserver with openlayers, it is all working through apache tomcat - and ...
2
votes
2answers
45 views

Defining OID causes Query Layer on PostGIS to disappear from ArcMap?

I used query layer to load my layer from PostGIS and show it in ArcMap 10, I had two cases; if I defined the OID in the configuration of connection, there was no problem with the attribute table of ...
0
votes
3answers
79 views

How to Build a graph from a map

I spent days looking in all questions here and trying tutorials. I need to build a graph for a region (It will be my input in simulation) I downloaded Postgresql and Postgis and osm2pgsql. Now i can ...
2
votes
1answer
453 views

generate height data from DTED maps

I have 16 DTED maps of (1 degree x 1 degree). I have to generate combined height matrix of maximum 4 (1 degree x 1 degree) DTED maps in my C++ application. Can someone suggest to me which open source ...
-1
votes
0answers
40 views

how to determine the direction in point-in-polygon

I am very new to GIS and I am wondering if the following problem could be solved or not. Given that there are three pairs of points(A<-B, C->D, E<-F) Each pair of points has a direction and ...
2
votes
3answers
355 views

How does ST_Azimuth work?

I do not understand the function behaviour. I am giving the function a point B that is North of point A so I would expect something around 90 degrees but I get 263 degrees instead. In another example, ...
2
votes
1answer
42 views

How to migrate spatial tables from MSSQL to Postgis

I'd like to migrate my spatial datas from MSSQL to Postgis. Originaly the data stored with SDE under MSSQL. Then I migrated with an ArcGis tool. That create us spatial data column with WKB data I've ...
1
vote
1answer
26 views

Run PostGIS command line functions in pgAdmin?

Is it possible to utilize the PostGIS command line functions, e.g. shp2pgsql, from within pgAdmin III? I am using pgAdmin to connect to a remote server.
1
vote
1answer
32 views

How to extend a straight line in postgis?

I have a postgis table of simple linestrings, each one is a straight line with just two points. I want to select every linestring, but extended from both sides by 1 meter. So i have lines, that are ...
0
votes
3answers
50 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) ...
0
votes
1answer
24 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: ...
5
votes
1answer
1k views

Hibernate Spatial 4 and Postgis 2.0

I'm having some issues integratings this technologies: Hibernate Spatial 4.0-M1 Postgis 2.0.2 (with compiled jdbc 2.0.2) Hibernate 4.1.1 The specific error is: Caused by: ...
0
votes
2answers
92 views

GeoAlchemy pg_function.geojson cannot be decoded with json.loads

I asked this quesiton over on StackOverflow and thought it might make more sense to post it here given it's GIS nature. Given this function: features being a list of SQLAlchemy objects template ...
1
vote
1answer
155 views

How to handle QGIS 2.2 Data Defined Label Position on PostGIS Layer Null Defaulting to 0?

I just upgraded to qgis 2.2 from 2.0. In 2.2 there was a minor change to data defined label positioning at least when used with postgis layers. In Version 2.2 the labeling engine appears to be ...
2
votes
1answer
121 views

Separate a polygon in different polygons depending of the distance to another polygon

I have a reference polygon "R", and others polygons (in grey). I want to separate each grey polygon in multiple polygons, depending on the distance to R with different Buffers : - The red line is R ...
3
votes
1answer
134 views

How to create a buffer on a linestring with varying or increasing/decreasing width

I want to buffer rivers/streams for a topographic map. I'm using a PostgreSQL/PostGIS database. Usually, I create buffer with ST_Buffer with a constant width. For example, the width of a river buffer ...
1
vote
1answer
132 views

How to use Mapserver+Openstreetmap for tracking service effectively?

I have got Asset tracking installations for many clients. The availability of GIS map data for every client location seems to be the tough part. I have got a MapServer WMS installation. Can I use OSM ...
0
votes
1answer
87 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 ...
2
votes
1answer
264 views

Postgis 1.4 - Obtain closest point of point over polylines layer (without st_ClosestPoint)

I´ve got a polylines layer (pipes) and a points layer (valves) and In Postgis 1.4 I would like to obtain the closest points but exactly on the closest polyline. In other words, i need to locate each ...
0
votes
2answers
282 views

PHP PostGIS to geoJSON missing required parametar error

I'm using this PHP PostGIS to geoJSON script: https://gist.github.com/bmcbride/1913855 But I keep getting this error: 'missing required parameter: geotable' This is my code: # Retrive URL ...
0
votes
1answer
28 views

PostGIS geography query returns a string value

I have a strange issue. The lonlat column on my app works well on the development server –– its output is in the form of POINT(X Y). But when I move the data to the production server, the output is ...
0
votes
2answers
35 views

export postgis database

I'm totally new to the awesome PostGIS world, so sorry for the maybe silly question. After a while I was able to install postgres and postgis on my computer (debian testing) and I was also able to ...
0
votes
1answer
183 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 ...
3
votes
1answer
289 views

In PostGIS, how do I merge a multilinestring into a single linestring, keeping the pieces in proper order?

I have a multilinestring made up of several pieces, some of which are facing the wrong direction. (Accessible here: http://pastebin.com/89Zcixv5 ) I think what I'm looking for is some utilization of ...
1
vote
1answer
56 views

DB manager in QGIS 2.0

I followed this post:pgRouting 2.0 for Windows quick guide, and I want to use DB manager to load the test data into my PostgreSQL database. I used url to get the test data: I have set up the ...
4
votes
1answer
158 views

Editing PostGIS topology in a web browser

I am trying to conceptualize the best process for editing topology from PostGIS in a web browser. Ideally what I would like to accomplish is the loading of a topology (imagine the lower 48 states of ...
1
vote
1answer
512 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 ...
2
votes
2answers
784 views

openlayers code PanZoomBar is not a constructor and GetFeatureInfo error

I’m having trouble with my openlayers code displaying postgis data in geoserver Why would this line (also PanZoomBar) map.addControl(new OpenLayers.Control.Scale($('scale'))); Produce this error in ...
0
votes
1answer
37 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
18 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
101 views

Why is ArcMap leaving connections “<IDLE> in transaction”?

The TL;DR version: When you use ArcMap Query Layers to access a PostgreSQL table, ArcMap's database connections are almost always sitting idle in unclosed transactions. Why would this be? I have ...
0
votes
1answer
46 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 ...
6
votes
1answer
448 views

Geometry errors when importing data from ESRI file geodatabase to PostGIS

When I run the following command to import by data from an ESRI fgdb to postgis... ogr2ogr -f "PostgreSQL" -a_srs "EPSG:28355" -t_srs "EPSG:3857" PG:"dbname=tp_test user=postgres port=54321 ...
2
votes
1answer
497 views

How to debug 'Layer is not valid error' from Python plugin?

I'm trying to understand what goes wrong with a QGIS python plugin. Basically I'm trying to render a series of POINT. The query works fine, at least giving it by hand from inside PostGIS DB: "SELECT ...
1
vote
1answer
32 views

Can't get SRS from PostGIS using Proj4 text

I'm having a problem transforming a point from the Australian MGA UTM datum (eg MGA Zone 51 http://spatialreference.org/ref/epsg/28351/) to WGS84 using GeoDjango. I've narrowed that down to a problem ...
1
vote
1answer
40 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
28 views

UpdateGeometrySRID and ST_Transform are the same thing?

UpdateGeometrySRID actually transforms the coordinate system of my data? For in the PostGIS documentation it appears the trim ST_Transform (Returns a new geometry with its coordinates transformed to ...
0
votes
0answers
17 views

shp2pgql: how to omit the git column?

I am importing a series of shapefiles with shp2pqsql that already have a unique identifier attribute. Since shp2pqsql creates a new column called gid I am ending up with two unique identifiers per ...
0
votes
1answer
18 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 ...