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

learn more… | top users | synonyms

0
votes
1answer
202 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 ...
0
votes
0answers
17 views

How to organize database with objects having GPS coordinates (in radians)

I have a huge database of different objects organized in tables. For instance photos in one table and metadata of each photo in other. Most of them have their GPS coordinates in radians stored as a ...
-4
votes
0answers
19 views

error while trying to compile quantum gis: unresolved external symbol class QwtIntervalData [on hold]

While trying to build qgis-2.6.1 from source on windows 7 32 bit with mvc++ 2008 I got the overall result ========== Rebuild All: 281 succeeded, 3 failed, 0 skipped ========== from this I am able to ...
11
votes
2answers
300 views

How to compute the smallest network that connects all points using PostGIS?

I have a set of postgis scripts which generates two tables - one of a set of points and the second a set of roads which surround them. All data is in the same projection and both outputs are stored in ...
2
votes
1answer
31 views

ST_GeomFromGeoJSON strips coordinates, is it a bug?

I'm storing some geo paths in PostGIS using GeoJSON and the ST_GeomFromGeoJSON()-function but I just found an issue with it: SELECT ...
3
votes
2answers
30 views

QGIS Plugin for PostGIS versioning

Does anyone of you know a QGIS-Plugin for Versioning PostGIS-Data? I know there was pgVersion of Horst Düster but as far as I know this was not updated for QGIS 2.x (at least not for the "normal" QGIS ...
0
votes
0answers
27 views

Fetching postgis data through php json and passing to leaflet map

I am new to this and trying to explore leaflet and geojson a bit. Please help me with this. This is my php page which I am using to fetch data from PostGIS. (the data opened successfully in the ...
2
votes
1answer
295 views

Using ST_MakeEnvelope over the dateline

I'm using ST_MakeEnvelope in PostGIS to try and make geometries that cross the international dateline, but they are making a shape that wraps the other way around the globe. The geometry I want is ...
3
votes
1answer
213 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. ...
4
votes
1answer
129 views

Routing problem finding shortest route to line

inspiration on how to solve this problem. (Ascii art, I don't have points to insert picture) I need to find Z Z = Shortest route from X Using Road (no point exists here) O = The points that makes ...
1
vote
1answer
16 views

Renderd “planet_osm_polygon” not exists. What to do now?

I'm trying to create my map server. Importing a planet with osm2psql was perfect, I installed nominatim and is working too. I installed the libapache2-mod-tile packet, caring about to not create the ...
2
votes
0answers
33 views

Postgres OSM planet reverse geocoding

i'm building function for reverse geocoding in Postgres using PostGIS function's. For now i was able to clean up all the data that was useless to me(rivers, buildings,etc.). I got 3 ...
2
votes
2answers
20 views

Can you rename the Django GeoManager object instance?

Is it possible to change the name of the GeoManager object from "objects" to something like "geo_objects"? The way I've done it in the code below is supposed to be the default way to configure your ...
0
votes
1answer
33 views

Isochrone driving/public transport map : Grass or postgis?

I have to do Isochrone driving / public transport map. It would seem that the two better open-source solutions are grass and postgis. Could you tell me which one is the better? the easier to ...
1
vote
2answers
549 views

QGIS create layer with the points of the beginnings and ends of a polylines layer (without duplicate points)

In QGIS, i would like to create a new layer containing the beginning and end points of a polylines layer, but without the duplicate points that would result of adjacent polylines.
0
votes
1answer
25 views

How to transform isolines to isopolygons with postgis?

I have a table a postgis table of isolines that's defined like this: CREATE TABLE myisolines ( gid serial NOT NULL, isotime timestamp without timezone, val numeric(10,4), geom ...
1
vote
2answers
151 views

Error in displaying wfs layer from mapserver/postgis

I have read and tested all the relative posts but I still don't have a solution for my problem. I have a layer suscribers (points) stored in postgis database with srid=32232. I would like to display ...
2
votes
3answers
46 views

Calculate Color of Object So No Adjacent Objects Repeat

I am attempting to assign one of 16 colors to map objects (e.g. counties, states, ZIP Codes, etc.) so that no two adjacent objects share the same color. I'm seeing tons of articles online about ...
1
vote
1answer
29 views

Editing POSTGIS tables via QGIS

Is it possible to edit POSTGIS tables directly in QGIS 2.6.1. I've been using The DB MANAGER but can only really do DDL type edits....Or create/import a brand new layer. I did see a SQL Window but ...
2
votes
1answer
26 views

Odd performance of PostGIS Select Query with ST_AsText

I have this query: select ST_AsText(geo) as wkt, city, street_number, street_name, street_type, street_direction, street_unit from parcels_union order by id ...
4
votes
1answer
50 views

Using more than one ST_function in one query

I have got stuck with a dynamic analysis that I would like to include in a project I am working with. I want to save the query in the project file or make it to a view in my database. I have tried a ...
1
vote
0answers
22 views

pgsql2shp: create shapefile from empty table, but with known attributes (dbf)

I was trying to generate shapefile from postgis tables using pgsql2shp. Everything is fine except for table with no rows. When trying to create shapefile from an empty table, an error occurs: Could ...
1
vote
0answers
25 views

Batch load multiple shapefiles to Postgis

According to the shp2pgsql help, the options drop, append, create and prepare are mutually exclusive. So, if I want to create a table from a shape and then append multiple other shapefiles, I do ...
1
vote
3answers
491 views

Importing MaxSea 3D Database to PostGIS

I am currently working on a project, where I combine several MaxSea 3D databases, which contain depth measurements made by the echosounder onboard on a ship. The idea is to combine these databases to ...
2
votes
1answer
24 views

How to add a band with conditional value to a raster with PostGIS

I'm trying to convert a vector polygon into a raster, with pixel values that indicate the area of the intersection. I have a query that gets the area of intersection between an empty raster and the ...
0
votes
1answer
35 views

What's the PostGIS equivalent to Extract Nodes in fTools / QGIS? [duplicate]

I'm looking to convert Park polygons from OSM into points. The QGIS fTools Extract Nodes tool will convert a polygon to points at the vertices. What is the equivalent function or work-flow in ...
1
vote
1answer
203 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 ...
0
votes
2answers
221 views

Coordinate System Google Maps API

I am making an application in java using GMaps4JSF where the person will enter the address on the map I'll take this coordinate and consult on my postgis base regions in which region this point is ...
5
votes
2answers
132 views

PostGIS nearest point with ST_Distance

I need to obtain on each element on one table the closest point of another table. The first table contains traffic signs and the second one the Entrance Halls of the town. The thing is that I can't ...
1
vote
1answer
198 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 ...
3
votes
2answers
61 views

How to reproduce FME Change Detector results in PostGIS?

we would like to use the function change detector from FME in PostGIS. We had a try with the following SQL-Statements but the function doesn´t work. There are no results in the end. The single ...
0
votes
0answers
35 views

Query path shape independent of orientation

Here is an interesting problem I haven't been able to solve or find any solution anywhere. Lets say I have a path defined by 5 points like this one: How can I make a query (postgis) to find all ...
0
votes
0answers
12 views

Geoserver SLD repeat = PropertyName

i've got Geoserver up and running, rendering spatial data in Openlayers, based on a view from a Postgresql/Postgis database. I'm trying to get most of the values for the SLD file by the object ...
15
votes
2answers
7k views

How to change the geometry type from Point to Multipoint within an existing table in PostGIS?

Is there a PostGIS function that can change geometry type for an existing table? We need to change from POINT to MULTIPOINT. The table will be empty when we change the geometry type and we cannot ...
3
votes
2answers
2k views

PostGIS Geometry Query returns “Error: Operation on mixed SRID geometries” only for certain values

I have PostGIS table with two geometry columns, both defined with SRID 4326. I can insert into the table without problem, using the following INSERT statement (where lng and lat are values passed in ...
3
votes
2answers
708 views

What is this PostGIS query doing to show great circle connections?

I'm trying to draw a flight map in CartoDB. My starting point is a single lat long point. We'll pretend it is this: ST_GeomFromText('POINT(-71.060316 48.432044)', 4326) And I want draw lines ...
0
votes
0answers
131 views

Using Terraformer to convert to WKT

I'm using Terraformer to parse some ArcGIS JSON into a Terraformer primitive. I'd like to store the geometry in PostGIS for other purposes. So I'm trying to use the WKT.convert tool to convert this ...
0
votes
1answer
137 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
113 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 ...
2
votes
1answer
512 views

Create isochrone from multiple start points

I want to create an isochrone. For this I could use the pgr_drivingDistance function with pgRouting (http://docs.pgrouting.org/dev/src/driving_distance/doc/index.html) but it only takes one start ...
0
votes
2answers
122 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) ...
1
vote
1answer
31 views

Incorrect lat / lon conversion from utm

I used this website to determine that the SRID for my shapefile is 3857. Following that information, I used the shp2pgsql utility to convert my shapefile into the sql I need to insert into PostreSQL ...
-4
votes
0answers
47 views

How to find a point inside a multipolygon?

I have a table postGIS with a column (type: geometry(Multipolygon)). One of the entries looks like below. How do I convert them into polygons ? or If I have a geo-coordinate , is there a way to find ...
17
votes
5answers
3k views

PostGIS: Select features that do NOT intersect

This seems to me like such a simple question (and it probably is) yet I cannot seem to find an example that gives me the answer. Using PostGIS, I just want to select points that fall outside of ...
0
votes
2answers
164 views

Extracting data from four intersecting polygon layers in PostGIS

I've been using the following code in Postgres/PostGIS for the last year, as needed, which is about once a quarter. It works ok, it's just that it takes days to run. With over 25,000 parcels making up ...
2
votes
0answers
14 views

Generate contour lines for big DEMs and import into PostGis

I've downloaded the SRTM DEM files for most of Europe, from both 3arc_v4.1 and 1arc_v3 versions. The first comes in 5x5 degrees tiles, the latter in 1x1. I can stitch them together with gdalbuildvrt ...
1
vote
0answers
21 views

How to highlight joined features?

I have a task in QGIS (2.6), where I need to join two tables through an action (I think). I have some projects (points) that I need to connect to a list of partners (also points). I have data in both ...
0
votes
0answers
26 views

Auto-reprojecting (st_transform) SRIDs in Postgis

I have a postgis table that is edited from different sources. The points added from Source 1 are in SRID 23030. The points added from Soruce 2 are in SRID 4230. I want all the points in the table ...
1
vote
1answer
34 views

How to get all the LineStrings of a street using PostGIS with OSM

I want to get all parts of a given street. I use a query like: Select * from planet_osm_lines where name = 'mystreet' As a result I get all the LineStrings that are part of a street with the ...
1
vote
2answers
131 views

How to style ways with CartoCSS depending on a relation property (OSM)

I'm using CartoCSS together with an OSM Postgres DB (hstore on). I want to set the line color depending on the operator tag of relations (routes). How can I do that? Update Thanks to Paul Norman for ...