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

learn more… | top users | synonyms

-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 ...
0
votes
0answers
16 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 ...
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 ...
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
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 ...
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 ...
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 ...
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
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
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 ...
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 ...
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 ...
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 ...
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
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 ...
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 ...
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 ...
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
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 ...
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 ...
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
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 ...
2
votes
0answers
39 views

Hosting DigitalGlobe stereo imagery on GeoServer

I have a pretty fresh install of the latest Boundless OpenGeo stack (v4.5). I have a requirement to host some stereo satellite imagery. I'm using the sample imagery over China provided by ...
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 ...
3
votes
1answer
61 views

From hundreds of shapefiles to PostGIS with some kind of directory/file structure

We have more than 700 shapefiles which we will import in a PostgreSQL/PostGIS database. We want to use a single database to make joins on our tables without using foreign database wrapper. Our data ...
3
votes
0answers
35 views

PostGIS Recursive Query Based on Line Connectivity

I'm having difficulty with a query. I have a network of linestrings, each with a value in the n_type column. This can be one of a handful of options. I'd like to generate a new table that groups any ...
2
votes
2answers
52 views

osm2pgsql: database “gis” does not exist

I am currently attempting to use OSM Bright to quickly style some OSM data, so I can export tiles without spending hours writing Carto in TileMill. This is my first time using osm2pgsql to import OSM ...
1
vote
1answer
22 views

osm2pgsql - can't find “maxspeed” tag after import

I have import a compressed osm file ".pbf" in a postgis database with osm2pgsql using the following command: osm2pgsql -c -d osm_france -U postgres -H localhost -S default.style -C 10000 ...
0
votes
0answers
21 views

get wms info with Leaflet

I am trying to export(excel,xml or pdf formats) wms feature information using the next tools: 1.- Geoserver.-Provides a Sql statement wich generates a wms polygon layer. 2.- Postgis.-Provides the ...
0
votes
1answer
16 views

Points shapefile resulting in MultiPoints table in PostGIS

I have a Points shapefile. When opened with QGIS, the type is 'Point' (right-click on the layer and check properties). When imported in PostGIS using pgAdmin III plugin 'PostGIS shapefile and DBF ...
0
votes
0answers
39 views

Is there any way to create user login for single project in QGIS?

Is there any way to create user login for single project in QGIS? I want to track changes on database when users update features. I know that I can do this on database level but is there way to do ...
0
votes
0answers
23 views

Invoke PostGIS geocode function using Python

I have a PostGIS Geocoder built with using Tiger data. Using SQL, I am able to execute all database functions and queries. I want to use it with my Python program. One of the option would be to write ...
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 ...
0
votes
1answer
32 views

Openlayers Load Blank Tiles - How To Combine OpenLayers 3 to MapServer version 6.0.3 (MS4W 3.0.6)

I Have Some Experiences With Openlayers 2 Now I Want To Combine OpenLayers 3 And Mapserver And I Tried The Below Configs And Code On OpenLayers And MapServer But The Openlayers Load White And Blank ...
0
votes
0answers
24 views

Query road shape

We have downloaded data from Openstreetmap and want to make special queries but have no idea how to start. What we want to do is find all road intersections with a certain angle in Australia. For ...
1
vote
1answer
67 views

postgis: cluster/group points based on distance

We have a set of thousands of points and want to group all of those which are within 100m distance from each other (to get the centroid from each group). A first idea was to build 100m buffers around ...
1
vote
0answers
26 views

Dividing a geographical area (bbox) into smaller equal sized square miles

I'm working on an automated system for processing geographical information by bbox using PostGIS with an Openlayers 3 UI. The user will use dragbox to 'draw' the bbox they want processed. The catch ...
2
votes
2answers
67 views

How to render an SVG from PostGIS using ST_AsSVG

Speaking with a cartographer from National Geographic last night, my interest was again peaked in an open-source map publishing toolset built on PostGIS and Inkscape (as per his workflow and how ...
0
votes
0answers
23 views

Attributes and Zoom

I have loaded shapefiles on OpenGeo Suite template (ol3view), I'd like to create a popup on click for each point to show attributes. I'd also want to highlight a certain part of the map perhaps by ...
1
vote
1answer
24 views

How do I catch PostgreSQL/ PostGIS RAISE messages in OpenLayers?

Is it possible to catch Raise Warning, Raise Notice and Raise Exception in OpenLayers while using a WFS-T-Layer (stored in a PostGIS-Database) to save edits? Example: A trigger is used to check values ...
0
votes
0answers
22 views

Spatially joining 2 point layers i.e. pole and customer points using spatial join of PostGIS/PostgreSQL Without intersection and buffer technic

Intersecting customer points with pole feature with 20m buffer SELECT distinct h.gid, d.polecode as gid FROM customer as h LEFT JOIN pole_20 as d on ST_Intersects(d.the_geom, h.the_geom); ...
2
votes
1answer
26 views

Show “Raise Notice” and “Raise Warning” in QGIS

Is there a way to catch "Raise Warning" and "Raise Notice" (while editing PostGIS-Layers) from a PostgreSQL/PostGIS-Trigger-Function within QGIS? One example: I have a trigger that reacts to insert or ...
0
votes
1answer
47 views

Use ST_Buffer with a conditional distance based on an attribute

I am quite new to postgres/postgis and are still learning basic skills. I have imported a pointlayer shapefile into my postgres database. I need to make a buffer of varying radius around the points ...
1
vote
1answer
30 views

Postgis query to convert UTM to Lat long

I want Postgres/PostGIS queries to convert UTM coordinates from UTM 43N projection to Decimal Degrees 32643 projection. select ST_X(the_geom), ST_X(the_geom) from table
1
vote
1answer
41 views

Import of OSM data into PostgreSQL with osm2pgsql polygon problem

I've mananged to import my great-britain osm file successfully into postgres and I can query everything fine. osm2pgsql -s -j -G -l --number-processes 8 -K -U james -C 10000 -d osm myfile.osm I'm ...
1
vote
1answer
62 views

Display a layer from geoserver using OpenLayers 3

I'm wondering how to display a Layer in OpenLayers 3 which I host in Geoserver. I imported the Layer from a PostGIS-DB and it is possible to display it using the geoserver preview option. The Layer ...
0
votes
1answer
21 views

I converted a KML file into a PostGIS db using ogr2ogr. How do I publish all the tables as seperate layers?

As the title says I converted/imported a KML file into my PostGIS database using the ogr2ogr command. Now I am trying to publish each table as a seperate layer onto a GeoServer. I know about cURL, but ...
3
votes
1answer
37 views

How to Specify FID column name in shp2pgsql

In ogr2ogr I can specify the name of FID column using the option -lco FID={columnname} when importing a spatial data in PostGIS database. I am using shp2pgsql in case of shapefile and cannot find a ...