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

learn more… | top users | synonyms

2
votes
0answers
19 views

GeoDjango with PostGis: distance_lte filter is inaccurate

My view code (relevant part): location = self.GOOGLE_MAPS.geocode(lookup) if len(location): page = int(request.POST.get('page')) or 0 start = page * settings.PHOTOS_PER_BATCH end = (page ...
2
votes
0answers
34 views

How can I convert a shapefile from a single line segment to separate side segments using PostGIS?

I have a shapefile (STC) which is a single line segment per street with information for both the odd and even sides of the street. This .shp file has to be converted to separate side segments. To do ...
2
votes
0answers
43 views

How to pull a shapefile into R from PostGIS database (in Windows)?

I'm currently working on pulling data from a PostGIS database for the first time to map in R and need some help. The database contains a shapefile of countries/regions of the world. I am able to pull ...
2
votes
0answers
40 views

display shapefile from postgres using arcmap?

I have uploaded shapefile using postgis extension in postgres but when i tried to display the shapefile in arcmap, it wont display the data in vector. this is the image of my connection. i followed ...
2
votes
0answers
29 views

“Point in polygon” counts that respond to filters?

I have a list of addresses in one layer and a polygon layer of census block groups for the local town, all stored in postgis. I have a nice display right now that labels each polygon with a count of ...
2
votes
0answers
27 views

Overlapping line aggregation+trim in PostGIS, while summing values

I'm sorry for the vague title, I didn't really know how to name this. I am working on a project that visualizes and simulates 17th century trade. For this project we also use so called Minard lines to ...
2
votes
0answers
42 views

Writing GeoJSON data into PostGIS in perl?

I am working with GeoJSON files and need to store them in PostgreSQL using perl. I can do this in 2 steps: open (JSON,">$path/tmp/current.json"); print JSON $fullJSON; close JSON; followed by: ...
2
votes
0answers
33 views

Efficient processing of ST_ValueCount Results in Postgresql

General Problem: I have a table of rasters. The rasters are classified MSI images, so each pixel is an integer indicating the class of the pixel. For a number of regions, I am querying pixel counts in ...
2
votes
0answers
128 views

Compiling Postgis 2.2.0 on Raspian error doesn't install postgis extension

Installed postgresql 9.4 following this tutorial using the method of already compiled pkg. All seems fine with postgres installation. testdb=# SELECT name, setting FROM pg_settings where ...
2
votes
0answers
27 views

Creating lines from lonely nodes in a linestring table to closest point on another linestring table

I want to segmentate a country (denmmark) by using barriers such as larger roads, railroads and the border/ coastline as the delimiting lines of the polygonise function in QGIS. But as most roads and ...
2
votes
0answers
25 views

Performance of 'extract by mask' tool in PostGIS?

Context: A large raster is clipped to create a bunch of smaller rasters based on a bunch of shapefiles. I've used st_clip() which seems to take forever looping through the different shapefiles, so ...
2
votes
0answers
54 views

Cannot open QGIS form from PostGIS Layer with bigInt datatype for my primary keys?

Using QGIS 2.10.1 Pisa / PostgreSQL 9.4 with PostGIS. In PostgreSQL I have column oid with datatype is bigINT as primary key. These are 16-digit numbers. In QGIS I can read the table as a layer and ...
2
votes
0answers
27 views

Merge curved polygons with Postgis

is there any way to merge/union curved polygons in Postgis? "SELECT ST_UNION(the_geom) from public.polygons" can be executed, if the type of the_geom is Polygon, but doesn't work with the type ...
2
votes
0answers
72 views

How to export ESRI Geodatabase format .gdb from PostGIS

I found several posts explaining how to import a .gdb file into PostGIS. Is exporting also possible? For example using ogr2ogr to generate a .gdb file from query result.
2
votes
0answers
52 views

Creating new PostGIS connection in QGIS?

I am trying to create a new PostGIS connection and I am doing as it follows: The password I inserted is postgres, I don't know what should be inserted there. And when testing the connection, I get ...
2
votes
0answers
45 views

Error on qGIS with postgresql views

I have a PostGIS database with various tables and views. With pgAdmin I can make requests on the tables, on the views, all is working. I add tables in QGIS 2.8, it's working, I can read, write, modify ...
2
votes
0answers
71 views

How to create isometric 3D map with postgis

I am looking for a way to create isometric 3D maps based on data stored in a PostGIS database. My idea is to create a PostGIS function that will return a SVG image like the one below. It is easy to ...
2
votes
0answers
66 views

QGIS does not display all Features of Layer and behaves weird instead

I have a weird problem with QGIS trying to load a Layer from a Postgis Database When I open the Layer from Postsgis I have two choices: Method one: Either, I use the Panel "Browser", where I can ...
2
votes
0answers
64 views

Create Indexes Within a View? How could I Speed up Spatial Queries Over a View?

I´m trying to add a view from postgis using QGIS, what´s facile. The problem is that it´s taking too long to load it and to perform any kind of operation, for example, as simple as counting rows. It´s ...
2
votes
0answers
42 views

Are there methods of filtering gps-data with metadata?

In our project we captured GPS-tracks from a few electric vehicles in the timeframe of a year. In total we captured around 13000000 GPS-points this way. The captured data comes from electric powered ...
2
votes
0answers
20 views

Add individual fields to delete-log-trigger when deleting PostGis-Objects via QGis

I am using a PostGres Database with PostGis extension (on Windows). QGis serves as a client to access (visualize and edit) certain database-tables. I need to create a delete-log-table that saves all ...
2
votes
0answers
78 views

Optimize PostGIS query, ST_Intersects - Raster and Geom

I am trying to run a spatial query between two tables. Table one (prism_ppt_monthly - see below for details) is monthly precipitation data. Table two (usgs_basin_boundary - see below for details) are ...
2
votes
0answers
89 views

PostGIS for GPX analysis

I have GPX trails of vehicles/bikes of a particular city. Meaning, lat/lon, timestamp of bike trails from where a particular bike started and ended at different hours of the day. I have sets of these ...
2
votes
0answers
60 views

GeoDjango and bug with bounding box query

Just some context first, I have a postgres database with PostGIS extension, running under a GeoDjango wrapper. I have a weird bug that hopefully someone can shed some light on. I'm running a query ...
2
votes
0answers
47 views

QGIS: Edits in attribute table are not updated in Postgis database. Why?

As the title say. I edit values in the attribute tables of my QGIS project but there is no update to the database. I refreshed in QGIS as well as the database. What else do I need to do?
2
votes
0answers
118 views

How to create line segments between pairs of pixels in a raster?

I want to draw several lines between pixels (please see the image below) according to some criteria : First Criterion: The distance between 2 pixels is less than 2000m and greater than 500m ...
2
votes
0answers
49 views

Import OSM Notes dump into PostgreSQL?

I'm planning to write some software to improve handling of OSM Notes, so I need them in postgis database. Following the documentation I found there is notes dump on osm.org, but I can't find if ...
2
votes
0answers
75 views

Server-side map generation from postGIS database

I have loaded some OSM data into a postGIS database, using imposm. Now using this data base, I computed a value associated to every point of the map (could be anything, real-estate average price or ...
2
votes
0answers
93 views

set Default projection in postgis table

I've set the SRID 4326 for a table having geometry column, but when i insert a geometry without SRID, i get an error because no SRID specified is interpreted as -1 or 0, so how i can set a default ...
2
votes
0answers
75 views

ST_Buffer with segment AND endcap parameters

Making a QGis plugin that buffers a line and I want to declare a high number of segments and a flat endcap. ST_Buffer(geom, 40, 25, 'endcap=flat') This doesn't work with both parameters entered, ...
2
votes
0answers
53 views

How to create raster from table containing cell values in PostGIS?

I am having a table with integer values. These values are in between 0 and 2. I want to create a raster out of that table with integers as cell values. Or else how to create polygons out of that table ...
2
votes
0answers
85 views

Not able to get the PostGIS Layer Viewer running in pgAdmin or command line

I've installed PostGIS Layer Viewer as a plugin for pgAdmin. I've downloaded postgis_viewer.py from the official repository on GitHub! and followed the install instructions described on Web site!. ...
2
votes
0answers
235 views

GeoServer: Get styles from PostgreSQL/PostGIS table

We're running GeoServer with all layers coming from a PostGIS data source. Most people work directly on the PostGIS database, but we have one person sitting 10.000km away, and for him, connecting to ...
2
votes
0answers
111 views

PostGIS: What is the difference between regular R-tree and R-tree on top of GiST?

I have built a spatial index structure that I am trying to compare with other existing spatial index structures. I have to either code (in Java) the same logic that PostGIS uses or find a java library ...
2
votes
0answers
241 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
0answers
84 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
0answers
159 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 ...
2
votes
0answers
207 views

pgrouting librouting.dll library is supposedly missing when it is not

Yesterday, I successfully installed pgrouting from the most recent x64 2.0.0 binaries, at least this is what I thought. I was able to perform first query - select pgr_createTopology() from the ...
2
votes
0answers
112 views

Geoserver : create a rasterized polygon / dynamic fill for polygons with features from database

I decided to post here because I couldn't find any answer to my problems on the internet. So I am using geoserver 2.7-SNAPSHOT, everything is working fine but I need to implement a new function or ...
2
votes
0answers
60 views

filling the attributes according to intersection of two layers (Postgresql)

How to automatically fill attributes of a point layer according to the exact position in the polygon layer? I mean how to write a command in PostgreSQL to automatically fill the attributes by the ...
2
votes
0answers
29 views

What are the problems of loading overlapping (or the same) tifs into postgis?

I am still early on the Postgis learning curve. I have an existing table in Postgres - it looks like this: create table "public"."mytable" ( "rid" serial primary key, "rast" raster, "filename" ...
2
votes
0answers
106 views

Cartographic-complete Maps in PDF On Request using Open Source?

Currently I have some data in PostGIS. I want to implement the following: users will make a request via web, with parameters like location, scale, layers to be displayed, etc. and I need to provide ...
2
votes
0answers
83 views

Reprojecting PostgreSQL/PostGIS data as it streams in?

I have a postgres/postgis database. I would like to reproject those data coming to me in 4326 to 32736. For those tables with lat long info in wgs84 (4326) I have set the geom to 4326. Then I have ...
2
votes
0answers
65 views

Why pgRouting GUI panel may not work in QGIS?

What could be the reason behind the mal-functionality of the pgRouting Layer GUI panel? In order to route shortest path via dijkstra function code I'm able to conduct the task using the following ...
2
votes
0answers
86 views

Are there naming rules for direct connections from ArcGIS to PostgreSQL?

I don't have problem direct connecting arcgis to postgresql if my database name contains only letters, but when the name contains dashes or underscore e.g:"gisdb-dev", I receive an error when setting ...
2
votes
0answers
301 views

How to plot heatmap/locations in Geoserver & Openlayers map from the Lat/Lon data of PostGIS table?

I am using Geoserver, Openlayers, PostGIS for Geospatial web implemenation. I have an Indian map shape files for States, Districts, Talukas. I am able to generate a map with states, districts, ...
2
votes
0answers
139 views

OpenGeo: GeoExplorer cannot upload shapefiles into PostGIS

I have installed OpenGeo 4.1 on Ubuntu Linux 12.04 following the official instructions. I then followed the tutorial Load your data with GeoExplorer. I was able to zip and upload a few shapefiles. ...
2
votes
0answers
103 views

Rebuilding a Polygon from the points within it, in PostGIS

This question is an update on the problem formulated here. I wanted to redefine the border of a set of polygons, in order to "smooth it". My first approach (described in the former question) was to ...
2
votes
0answers
31 views

ArcGIS dissolve analysis output issues in geoserver wfs/ PostGIS

I have an ArcGIS dissolve analysis output (parcel data) that needs to be loaded on PostGIS and published as a wfs from geoserver. The issue is that the ArcGIS dissolve output shapefile, although can ...
2
votes
0answers
125 views

List of vector to one raster in PostGIS

Hi PostGIS developers! I need to rasterize a part of OSM map by coordinates. I found rather good algorithm, but can’t finish it. I have problems in STEP 3. I described all algorithm here – may be ...