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

learn more… | top users | synonyms

1
vote
0answers
23 views

QGIS - Split a line having attributes with UNIQUE constraint

I am using QGIS with a PostgreSQL/PostGIS database, where the lines table (named 'segments'), besides the integer serial primary key, has a UUID column having a UNIQUE constraint. Trying to split a ...
1
vote
0answers
22 views

How to pass time dimension to postgis DB layer WHERE clause in Geoserver?

I have successfully configured a layer with time dimension that is backed by an SQL query to a PostGIS DB. I can query it through WMS, but I just can't find a way to pass the start and end time to the ...
1
vote
0answers
20 views

How to batch create GeoServer stores for each user?

I have unix system with a number of regular users, each with his/her own database in PostGIS. I need to create a PostGIS store for each user. I know how to do this in the web interface. Is it ...
1
vote
0answers
38 views

Is it necessary to use hibernate-spatial for postgis?

I'm beginner in GIS. I have a database in PostgreSQL that contains a table location, that table contains a column with type point. I have to get points and display it on google map. Once I did the ...
1
vote
0answers
15 views

like finding errors overlap on the same layer in postgis?

After meeting the overlay erroneous polygons in the same layer, I used the following query: select gid from limite_localidad where not ST_Overlaps(the_geom,the_geom) I have to leave 108 records ...
1
vote
0answers
27 views

pgRouting “Can't find Table”

I am using pgRouting version 2.1.0. I am using pgAdmin III. I have created a street network using Anita Graser's guide: https://anitagraser.com/2013/07/06/pgrouting-2-0-for-windows-quick-guide/ But ...
1
vote
0answers
19 views

How to add large file (in GB) in Xcode project?

I am working with Mapbox Framework. I have generated MBTiles file which I want to use in my project (for iPhones and iPads) but that file is having size of 3GB (which I can't use in project). When I ...
1
vote
0answers
29 views

Python GDAL open dataset in PostGIS with quotations

Error trying to use gdal to open a dataset in PostGIS with the following code: ds = gdal.Open("PG: dbname=nyc host=localhost user=postgres password=mypassword port=5432 mode=2 schema=public ...
1
vote
0answers
25 views

PostGIS Svg Projection on Google Map

Context I have a database with spatial data such as areas and points. Some of the areas in my db are coming from OpenStreetMaps, representing some regions. (Which are kinda small at earth's scale, ...
1
vote
0answers
29 views

Finding the shortest path between points to LineString PostGIS

I have a MultiPolygon. Something like this: All one colored circles make up one multipolygon. I would like to find the shortest line to connect all one colored polygons. The first idea was to find ...
1
vote
0answers
19 views

Configure new SQL view doesn't appear for different DB's in the same PostGIS Database

I have PostGIS Database with different DB's. Each one of them has different workspace:store in Geoserver. When I'm opening Create new layer page and picking different workspace:store for some of them ...
1
vote
0answers
57 views

Cursor help on large spatial query in PostgreSQL

I have two very large tables on which I want to perform a spatial query. UPDATE table_a SET att_1 = b.att_1, att_2 = b.att_2 FROM table_a AS a JOIN table_b AS b ON ...
1
vote
0answers
35 views

Optimize Postgis contour lines DB

I'd like to try to optimize a world-wide 10m contour lines (isohypses) Postgis database(from SRTM). The complete DB takes 504GB on disk, contour lines are already in epsg:3857, and simplified with ...
1
vote
0answers
27 views

Saving styles to database

In QGIS, the option to save the style to a database (postgres) does not appear in the drop down list if the postgis table has been opened using add vector layer and then entering the postgres database ...
1
vote
0answers
22 views

How can I use ST_Contains/ST_Overlaps with non-simple lines?

Following the SQL of the accepted answer to How to get smallest line segments from intersection + difference of multiple overlapping lines? copied below. I'm having some difficulties assign the ids of ...
1
vote
0answers
41 views

Is PostGIS / PostgreSQL UK Public Sector Network (PSN) compliant?

Is PostGIS / PostgreSQL UK Public Sector Network PSN compliant? ... specifically so it can be used in a UK local government council?
1
vote
0answers
34 views

PostGIS: intersection of a MultipolygonZ and a floating point raster

I am trying to isolate the pixels in a floating point raster (loaded in PostGIS) that intersect my MultipolygonZ table (also loaded in PostGIS) and whose values are less than or equal to the z values ...
1
vote
0answers
67 views

How to IDW interpolation in PostGIS

I'm trying to find PostGIS Raster functions supports the Inverse Distance Weighted interpolation method (IDW) and Kriging interpolation method. I'm especially trying to generate a temperature map ...
1
vote
0answers
47 views

Copy Polygon to Postgis from Shapefile

I have the following situation: Postgres database with PostGIS There is a table with a PostGIS geometry column. All non geometry data is managed (create, update, delete) by a webapplication. QGIS ...
1
vote
0answers
49 views

Problem with ST_Union

I have loaded some rasters into Postgis. I did a lot of ST_XXXX (scale, snap to grid,resample) magic to make them aligned. After executing: select r1.rid,r2.rid ...
1
vote
0answers
20 views

How to use the TopoViewer in the QGIS DB Manager?

I'm just wondering what the TopoViewer in QGIS is doing. DB Manager (PostGIS) says 'Schema "schemaname" is not registered in topology.topology'. Unfortunately there is no help available and I can't ...
1
vote
0answers
28 views

Incorrect results returning from st_distance_spheroid query

Given a routable network table constructed by completing the guide at http://anitagraser.com/2011/02/07/a-beginners-guide-to-pgrouting/, how can I get an accurate list of all roads that are within a ...
1
vote
0answers
44 views

Are GIS tools suitable for physical capacity and placement management?

I'm a complete newbie to GIS systems, I've been watching some introductory videos about GIS but I'm not yet sure if GIS tools are the right tool for solving my problem. I have a database with ...
1
vote
0answers
37 views

update query with st_intersects() is not finding results

So I am trying to identify which items from the requests table fall into some particular district from the district table using postgis. Basically, I am writing an UPDATE query that will take the ...
1
vote
0answers
29 views

PostGIS Street Intersection Autocomplete with full text search

What I'm attempting to do is create a custom autocomplete for addresses, road intersections, POI's, etc. For now we are going to using Mapbox GL (we'll be creating a custom map at a later phase), ...
1
vote
0answers
94 views

Django/PostGIS: How to insert coordinates in PointField in EPSG:27700, and return EPSG:4236?

I am using Django 1.9 with PostGIS. I have input data that consists of British National Grid eastings and northings, and a table that looks like this: class Org(models.Model): name = ...
1
vote
0answers
53 views

Problems using pgr_fromAtoB - postgresql error

I have some trouble with the pgr_fromAtoB function of the workshop. I get: ERROR: column "ways" does not exist But "ways" is the table, not a column. What am I do wrong? My table ways looks like: ...
1
vote
0answers
40 views

PostGIS query: filter rows by area?

I am working with PostGIS (in CartoDB). I want to find all rows in the database with an area of over 100 square metres. I've been trying this: SELECT *, ST_AREA(the_geom::geography) AS area ...
1
vote
0answers
40 views

Import raster using raster2pgsql with out-of-db option not working

I am using raster2pgsql to import DTED data into postgis database. I would like the data to be out-of-db, I am using the command as follows. raster2pgsql -R /home/gis/elevation/DTED/area.dt2 ...
1
vote
0answers
36 views

ST_Intersects in postgis

My version : postgres 8.4.1/postgis 1.4.0 I want to perform a simple spatial join with the following query : SELECT code_insee, nom, id_canton, lib_canton FROM localisants.alca_toponyme_commune ...
1
vote
0answers
29 views

St_intersects returning false results in postgis

I want to intersect point geometry with raster. In postgis I'm executing select st_intersects(geom,rast) from testraster1,pft_pft and the result is false even though the points are sitting on ...
1
vote
0answers
40 views

QGIS crashes when using PostgreSQL/PostGIS triggers

When using PostgreSQL/PostGIS triggers saving layer edits gets slower and slower every time when saving a layer edit. This issue occurs after a few up to a few dozen saved layer edits. Finally QGIS ...
1
vote
0answers
35 views

PostGIS: Find nearest point given coordinates from another table

So I have two tables, one table is called stores which has the name of the store as well as the geom column that contains the coordinates for the stores. The other one is customers which has the ...
1
vote
0answers
27 views

pgrouting pointAtoB function

Has anyone successfully implemented pgr_fromAtoB function? Sometimes I get 0 results from points in the same line string, sometimes I do get results, How can accuracy be improved?, or maybe do I ...
1
vote
0answers
143 views

Visualizing shapefiles on web using SHINY package of R with PostGIS?

I am using PostGIS database to store my shapefiles. Now I want to read those files through shiny package of R. How can I visualize those files on web using shiny package of R and perform statistical ...
1
vote
0answers
88 views

How to calculate multiple distances between set of points and vector grid in PostGIS?

My set contains the following input data: A set of points and a hexagonal (vector) grid. For each cell in the grid, I want to calculate the driving-distance to each point. I thought this would be a ...
1
vote
0answers
53 views

Length not respected in ST_Segmentize

When segmentizing a geography line in Postgis, the max segment length does not seem to be respected when the line is more than 3000km. The error grows when the length of the line increases. Below the ...
1
vote
0answers
52 views

Multi-dimensional points in PostGIS

I have experience in PostgreSQL but I am fresh new in PostGIS and I can see how quickly would I like it. I have extensively worked on time series and now I am discovering the spatial side of my data. ...
1
vote
0answers
34 views

Automatically generating raster maps (from OSM) for areas bounded by polygons?

In order to create walking lists for a volunteer campaign I have used qgis to draw polygons over groups of addresses. These are irregular areas, so I've used postgis's ST_ENVELOPE function to ...
1
vote
0answers
32 views

Nearest neighbor POSTGIS in FME

So I have an attribute and I want to find the nearest neighbor but the issue is that the memory of the server may not be able to handle the use of all the FME transformers. I need to take records out ...
1
vote
0answers
57 views

POST (OL3-->Geoserver 2.8.1-->PostGIS 2.2)

I have a problem with post. Here is code OL3. (multi platform hybrid app - cordova) var point = new ol.geom.Point([18.25, 49.83]); var feature = new ol.Feature({ geometry: point }); ...
1
vote
0answers
21 views

Creating a contiguous raster stack from different sources (vectors and DTM bands)

This is a conceptual question I've been trying to implement for a while, and not being very good at raster/data processing or python I'd like to hear best practices in dealing with an extent such as ...
1
vote
0answers
31 views

How to translate QgsMapCanvas coordinates to wgs-84?

My application uses QgsMapCanvas. I've got point coordinates in wgs-84 crs and i need to add this point to vector layer (represents postgis table) inside of the canvas. Have no idea how to ...
1
vote
0answers
44 views

Updating an Openstreetmap PostgreSQL database after the system restore

My Openstreetmap PostgreSQL database takes a long time – about 25 hours by now – for updating via Osmosis after I had made a system restore at the last weekend. Before making the system restore it ...
1
vote
0answers
36 views

How do I translate gps sports data into a representative plane

I'm hoping to use qgis and postgis for a project but I'm unsure of, how to not only frame the question but accomplish the task. If I have gps data from 1 runner on an oval track but who has run on ...
1
vote
0answers
42 views

Find census block for street intersection with tiger geocoder

I'm geocoding lots of addresses and map them to census block. Some of addresses are street intersections, like this select ST_X((geo).geomout)::numeric(8,6), ST_Y((geo).geomout)::numeric(8,6) ...
1
vote
0answers
63 views

How to draw a raster over the World using Postgis

Im currently working on a system to track user interaction on mapwidgets. Now i need to visualize the bounds that users are looking at on the map. Since were using a whole lot of data i need to find a ...
1
vote
0answers
37 views

Creating look up tables in QGIS that last more than one session?

It seems that when I create a Look up Table or Value Map for a shapefile or a PostgreSQL table in QGIS it saves it for one session, then when I open it again it had disappears. Can someone ...
1
vote
0answers
33 views

pgr_nodeNetwork doesn't place new nodes properly

I wanted to use pgr_nodeNetwork tool to split lines where there's no vertex on intersection. The tool doesn't seem to work as expected, though. It doesn't place new nodes right where the two lines ...
1
vote
0answers
91 views

Unable to load raster from PostGIS into QGIS

I'm trying to load raster from a postGIS connection into QGIS, but I'm getting the following error: PG: dbname=EnvModel host=127.0.0.1 user=postgres port=5432 mode=2 schema=public column=rast ...