Re: [postgis-users] Postgis raster tutorial

Thank you Pierre, this will be of great help not just to me but to countless others as well, I hope it receives the widest possible circulation. -- View this message in context: http://postgis.17.x6.nabble.com/Postgis-raster-tutorial-tp5006124p5006287.html Sent from the PostGIS - User mailing

Re: [postgis-users] ST_MakeLine() woes

Remi, you replied before the edits I made to my last posting were accepted by the forum. It actually did work!, with very minor adjustments to your code. But I accept that my approach may not the best way to go about this problem, so I'll try your latest suggestion and let you know the results.

Re: [postgis-users] ST_MakeLine() woes

thanks Remi, attached is the result after running your code, no change unfortunately. I had to make some slight changes to the code to make it work. The image has the code. However you also say that my approach is not as robust as it could be. Any suggestions on how to make it more robust?

Re: [postgis-users] ST_MakeLine() woes

Thanks Francois, the ORDER BY statement was in the original blog I quoted, but even if I remove it, the points are still displayed in the same wrong sequence. -- View this message in context: http://postgis.17.x6.nabble.com/ST-MakeLine-woes-tp5006266p5006268.html Sent from the PostGIS - User

Re: [postgis-users] ST_MakeLine() woes

Thank you Remi, I assume that means that my original code was correct (although it produces unwanted results). I am slowly reaching the conclusion that the problem is with st_intersection(), which traverses the raster in an order which is not compatible with my line shape and any attempt to create

Re: [postgis-users] Postgis raster tutorial

Thank you Pierre, your add-ons are a life saver. I'll make sure to make the most of them. And I look forward to your blog in 2000 minutes, the countdown has started already! -- View this message in context: http://postgis.17.x6.nabble.com/Postgis-raster-tutorial-tp5006124p5006169.html Sent

[postgis-users] Postgis raster tutorial

As a new raster user I have found it extremely difficult to come to grips with the task of creating a raster table with postgis, in particular from an existing vector table, a task which is really trivial when done with some existing s/w packages ( i.e. SAGA, GRASS etc..). Most of the examples I

[postgis-users] more memory issues with raster2pgsql

Hi, I am trying to convert a raster from SAGA GIS to Postgis using raster2pgsql.The command line and its output is: C:\\Progra~1\\PostgreSQL\\9.3\\bin\\raster2pgsql.exe -F -d - I -C -M -s 2193 I:\cb09\cb09_3dem.sdat cb09_3 | psql -d NZTPU Processing 1/1: I:\cb09\cb09_3dem.sdat BEGIN NOTICE:

Re: [postgis-users] more memory issues with raster2pgsql

Thanks bborie, however from the error message I received the problem seems due to the need to convert the original raster to utf-8. But the original raster is in utf-8 already. If I follow your suggestion (and after this mystery conversion is done) will I be able to recombine the tiles to create

Re: [postgis-users] more memory issues with raster2pgsql

thanks again bborie, my original raster is only 135MB in size, the generated sql is 270MB in size. As for the FAQ, I had looked at it, but could not work out how to find out how my client encoding is set and where. Also where is the postgresql load script for windows? -- View this message in

Re: [postgis-users] more memory issues with raster2pgsql

Thanks bborie, this is what I did, but no improvement: Microsoft Windows [Version 6.3.9600] (c) 2013 Microsoft Corporation. All rights reserved. C:\WINDOWS\system32set PGCLIENTENCODING=UTF8 C:\WINDOWS\system32psql -U postgres -d NZTPU -f c:\cb09.sql BEGIN psql:c:/cb09.sql:2: NOTICE: table

[postgis-users] ST_AsRaster vs raster2pgsql

Hi, I am new to raster and am having some problems creating a raster table from a contour vector table, PostGIS 2.1.1, Win 8.1 64bit To create the table I am using: CREATE TABLE BK30_dem2 AS SELECT 1 AS rid, ST_AsRaster(( SELECT ST_Collect(geom) FROM