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

learn more… | top users | synonyms

3
votes
3answers
525 views

How to rename PostgreSQL/PostGIS columns while importing Shapefiles?

I discovered shp2psql to successfully import geospatial data from ESRI Shapefiles into PostgreSQL/PostGIS. Now I would like to automatically rename the target column names. Is there any mechanism ...
3
votes
1answer
560 views

Debugging ogr2ogr “AddGeometryColumn failed” and “Terminating translation prematurely after failed translation of layer”

As noted in the title, I'm getting the following error: ERROR 1: AddGeometryColumn failed for layer pretty_polys, layer creation has failed. ERROR 1: Terminating translation prematurely after failed ...
2
votes
0answers
398 views

Editing PostGIS data in ArcGIS Desktop?

Quick question regarding editing PostGIS data in ArcMap 10.0. Far as I can tell, this can only be accomplished through third-party plugins like GISSquirrel or ST-Links. Does anyone know of an ...
5
votes
2answers
348 views

Optimize Tilemill export of project with contour-lines (and fix out of memory problems)

I have a project in Tilemill (based on OSM-Bright) that covers Europe and also displays Contour-Lines. My problem is that the performance of Tilemill is pretty bad when displaying the contour lines ...
0
votes
1answer
66 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. ...
2
votes
1answer
116 views

Get points along a line at defined distance

I was reading a lot of similar questions here but no one ask about postgis (or I didn't find it). I have a line in postgis and I want to get the point along the line at defined distance. It is ...
4
votes
1answer
228 views

Calculate distance between point and linestring and how to represent that on QGIS?

I have loaded my data with osm2pgrouting and I have my network with ways (Linestring) and nodes (Point). The problem is : I have a database of doctors addresses (point) and I should calculate the ...
0
votes
1answer
303 views

Converting a JOSM indoor map to QGIS

I have created an OpenStreeMap layer of the indoor of a bulding by following this tutorial: https://wiki.openstreetmap.org/wiki/IndoorOSM, since that is only a proposed tagging schema for indoor ...
2
votes
0answers
35 views

PostGIS query with input from point layer

I have a table of rivers in PostGIS, each river linking to its outflow. I also have a QGIS layer of some selected sources, and would like to select the entire river downwards from each source (i.e. ...
1
vote
1answer
449 views

Converting file geodatabase with coded domains to PostgreSQL / PostGIS?

We have several file gdb's and would like to convert these to Postgres / PostGIS. We've used ogr2ogr to transfer these files; however, some of the fields are stored as coded domains and the fields are ...
1
vote
0answers
140 views

Merge overlapping GeoJSON GeometryCollections

I need to merge three overlapping GeoJSON GeometryCollections of Polygon. Ultimately, the end result needs to be a geom type for PostGIS (e.g. MULTIPOLYGON) so I can easily check if particular points ...
2
votes
0answers
24 views

Convert ArcGIS gdb with coded domains to Postgres / PostGIS [duplicate]

We have several file gdb's and would like to convert these to Postgres / PostGIS. We've used ogr2ogr to transfer these files; however, some of the fields are stored as coded domains and the fields are ...
-1
votes
1answer
304 views

How do I calculate driving distance to Amarillo, TX from all Texas cities using zipcode data? [closed]

I have a dataset that contains the zipcode of all cities in Texas. I want to find the distance of all these cities in Texas to ...Amarillo,TX Example: Borger, TX------Amarillo,TX ...
2
votes
1answer
376 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 ...
0
votes
1answer
185 views

Is this correct behavior for ST_ConcaveHull (PostGIS)?

I'm getting this error on the ST_ConcaveHull function call and after reading the docs, I'm unclear as to whether this Error is correct behavior or not. Here is the business end of the query (vx are ...
1
vote
1answer
208 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 ...
0
votes
1answer
174 views

How to union polygons and add attribute values of combined output features

I have a layer containing 10 polygons all overlapping at various locations. Each polygon has a value of '1' in a column called "value" How do I Union the polygons (rows) together such that the ...
1
vote
0answers
115 views

How do I automatically generate a spatial data catalogue from shape files and .gdbs?

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 ...
3
votes
3answers
564 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 I successfully changed the SRID of my table using select ...
0
votes
1answer
92 views

QGIS to solve projection mystery in Postgresql

I downloaded some data from local agency. Per QGIS 2.2, I defined the projection to 'EPSG:3587 - NAD83(NSRS2007) / Michigan Central' in postgresql (maybe ArcMap). Data is in Postgresql 9.3. I am ...
0
votes
1answer
178 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 ...
1
vote
1answer
81 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
223 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 ...
2
votes
3answers
1k 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
336 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
1answer
470 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: ...
1
vote
2answers
144 views

Remove TileStache cache for a single feature

In a large parcel map, features are edited and need to be re-styled. I want to keep as much of the cache as possible, but invalidate the cache for features that are edited when the features are saved. ...
2
votes
2answers
242 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 ...
3
votes
2answers
412 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
1answer
39 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 ...
1
vote
2answers
79 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 ...
3
votes
1answer
129 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 ...
0
votes
1answer
80 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 ...
1
vote
2answers
122 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 ...
0
votes
2answers
221 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
21 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
0answers
168 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 ...
2
votes
2answers
183 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
223 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 ...
2
votes
1answer
267 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
190 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
125 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
50 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
69 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
61 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
75 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
65 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
812 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
91 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
101 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 ...