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

learn more… | top users | synonyms

0
votes
0answers
15 views

Postgis - get all records (lat, Log) that contain a polygon.

I have a polygon and want to get all the points inside from a georeference table. How is the sql sentence? For example. obtain all the lat/long records that are inside the department ZZ polygon. ...
2
votes
1answer
22 views

GROUP BY on geography in postgres 9.4.0 returns wrong/different results

table definition: CREATE TABLE search ( id bigserial NOT NULL, location geography(Point,4326) NOT NULL, location_aggregated geography(Point,4326) NOT NULL, created timestamp with time zone ...
2
votes
1answer
67 views

Best practice for a group working on the same shapefile, with open source tools

We are a small (~5) group working on a single, shared shapefile. The current workflow is that each one of us does the editing on a designated attribute field, on his local copy, then exports the ...
-1
votes
0answers
22 views

How to get the band number for a specific data value?

I have temperature data values which are stored in a raster image and I want to know which band numbers have that data value stored in them. Can anyone please guide me as to how can i do this using ...
0
votes
0answers
14 views

How to get a time cost related to polyline geometric characteristics in postgis using OSM data?

I'm trying to make an isochrone mapping of the emergency facilities in my region, I'm using a street map loaded in postgis by osm2pgrouting, data is supplied by OSM. The only cost I got for every ...
0
votes
1answer
27 views

Point inside st_dwithin with wrong results

I want to get all points, that are in the same area. Therefore, I have the following query for my table check: SELECT l.location_id, l.location FROM check l INNER JOIN check l2 ON ST_DWithin ...
1
vote
1answer
36 views

PostGIS: Geometry column registering as GeometryCollection, not converting to MULTIPOLYGON

I'm trying to aggregate data from a tabular data source and then join it to a geometry file (sl_adm2) in PostGIS using a primary key. The geometry file was imported using shp2psql. CREATE TABLE ...
-4
votes
0answers
32 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
36 views

How to organize database with objects having GPS coordinates (in radians) [on hold]

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
37 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
19 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
36 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
30 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
27 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
38 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
26 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
24 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
39 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
143 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
15 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
22 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
33 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
63 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
166 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
25 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
37 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
54 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
23 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
22 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
24 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
15 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
35 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
71 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
28 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
68 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); ...