2
votes
1answer
95 views

plpgsql | before update trigger: insert the new pseudo-record in another record and leave the old one as it was

I've got the following table: CREATE TABLE alumbrado_puntos_luz ( id numeric(8,0), "GEOMETRY" geometry, revision_actual numeric(10,0), revision_expirada numeric(10,0), CONSTRAINT ...
2
votes
1answer
376 views

Missing libraries when upgrading to PostGIS 2.1 and PostgreSQL 9.3.1 using homebrew

In the process of upgrading my PostgreSQL from version 9.2.4 to 9.3.1 (via homebrew on OS X) I came across an odd problem. These are the steps I took so far PostgreSQL, PostGIS and required ...
1
vote
1answer
52 views

Auto column update in postgis

I have a fruit orchard dataset. One of the columns contain the year the orchard was planted. In another column I would like to have the orchard age. However this pose a problem, since the age changes ...
0
votes
1answer
212 views

How to upgrade PostGIS 2.0 to 2.1 on Windows 7?

PostGIS 2.1 was recently released and I would really like to upgrade from 2.0, but can't quite figure it out. I had previously installed PostgreSQL 9.2 and PostGIS 2.0 using StackBuilder. Running ...
2
votes
1answer
91 views

Is it possible to update only latitude or longitude in postgis ?

I have a postgis database that contains Points created based on a couple (longitude, latitude), and I need to update only one of those two for a given point. I found that it's possible to do so but ...
0
votes
0answers
130 views

Can I do full SQL expressions through the “WHERE” clause in UpdateCursor?

Run as a standalone python script for a shapefile in a toolbox on ArcMap. For example: psql_url_pop = '''SELECT shapefile.NAME_# + shapefile.WIKI_URL FROM public.shapefile''' rows = ...
4
votes
1answer
185 views

Update PostGIS after updating GDAL?

I am using PostGIS 2.0 and I want to use the raster functionality through mapserver. It seems as if the latest official GDAL release 1.9.1 has an unstable PostGIS raster driver, as pointed out in a ...
2
votes
1answer
70 views

Update table using contains function

I have a table that containing placename regions and another table of roads. I have another table that containing centroid of both placename region and roads.The table structure of third table is ...
2
votes
1answer
452 views

How to upgrade PostGIS in OSGEO-Live Xubuntu virtual machine?

I have downlaoded the OSGEO-Live 6.0 virtual machine running Linux Xubuntu. I have it running through VirtualBox on a Windows machine. It currently comes preinstalled with a lot of GIS software, ...
6
votes
1answer
2k views

PostGIS - 1.5 to 2.0 easy update

I have a PostGIS 1.5 database and want to update to 2.0. I read that because this is major release I have to follow the 'Hard update' procedure. However the spatial data I have is only test data so I ...
4
votes
1answer
175 views

Is it be possible to re-render parts of a tile pyramid when postgis table updates?

I have this idea of using postgis together with a tile renderer for serving my organization with tiled maps. As I believe my data will be partially altered almost on a daily basis it does feel like a ...
7
votes
2answers
1k views

How to run two PostGIS versions in parallel on Windows?

I'm trying to understand how to install PostGIS2.0 on Windows7. The PostGIS site has the following suggestions: PostGIS Experimental Binaries PostGIS 2.0.0SVN Binaries with Raster, Topology ...