Re: [postgis-users] Cost weighted distance raster

2017-03-16 Thread Pierre Racine
ST_Raster2WorldCoordX and ST_Raster2WorldCoordY were replaced with ST_RasterToWorldCoordX and RasterToWorldCoordY in newer version of PostGIS. Just replace those names in the function and reexecute the CREATE FUNCTION… Pierre From: Spencer Gardner [mailto:spencergard...@gmail.com] Sent: 16

Re: [postgis-users] Cost weighted distance raster

2017-03-16 Thread Michael Treglia
Thanks for following-up on this, Spencer - good to hear, as this would be of interest to me as well, from an ecological perspective. I'll note, depending on what you're doing, might be worth looking into a recently-developed tool called gflow (see paper here:

Re: [postgis-users] Cost weighted distance raster

2017-03-16 Thread Spencer Gardner
Just to follow up: I was able to execute the CREATE FUNCTION scripts with some minor tweaking. When I run ST_CostDistance it chokes on making a call to ST_World2RasterCoordx. That's as far as I've gotten. I'll have to turn my attention to another solution for now. It's a shame--having a good

Re: [postgis-users] Cost weighted distance raster

2017-03-07 Thread Spencer Gardner
Ah thanks. Didn't see the code page. I'll let you know whether these work as is or if they need tweaking. On Tue, Mar 7, 2017 at 11:51 AM, Pierre Racine wrote: > In the code page : > > > > https://trac.osgeo.org/postgis/wiki/PostGIS_Raster_SoC_Idea_2012/Distance_ >

Re: [postgis-users] Cost weighted distance raster

2017-03-07 Thread Pierre Racine
In the code page : https://trac.osgeo.org/postgis/wiki/PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/code There is a ST_CostDistance() function. Pierre From: Spencer Gardner [mailto:spencergard...@gmail.com] Sent: 7 mars 2017 12:35 To: Pierre Racine Cc:

Re: [postgis-users] Cost weighted distance raster

2017-03-07 Thread Spencer Gardner
I didn't see any code for the Cost Distance function, only the Euclidean Distance. Did I miss something? Or is it located on a different website that I haven't found? Thanks, Spencer On Tue, Mar 7, 2017 at 10:23 AM, Pierre Racine wrote: > There is no .sql. just

Re: [postgis-users] Cost weighted distance raster

2017-03-07 Thread Pierre Racine
There is no .sql. just copy the functions into a .sql text file and execute. From: Spencer Gardner [mailto:spencergard...@gmail.com] Sent: 7 mars 2017 11:16 To: Pierre Racine Cc: postgis-users@lists.osgeo.org Subject: Re: Cost weighted distance raster On Tue, Mar 7,

Re: [postgis-users] Cost weighted distance raster

2017-03-07 Thread Spencer Gardner
On Tue, Mar 7, 2017 at 7:07 AM, Pierre Racine wrote: > Hi Spencer, > > > > Integrating something in the main PostGIS core is hard work. That’s why I > started the PostGIS Addons: to quickly gather PLpgSQL-only functions into > an easy to install .SQL file. Why I did

Re: [postgis-users] Cost weighted distance raster

2017-03-07 Thread Pierre Racine
Hi Spencer, Integrating something in the main PostGIS core is hard work. That’s why I started the PostGIS Addons: to quickly gather PLpgSQL-only functions into an easy to install .SQL file. Why I did not integrate those functions in the Addons yet? Lack of time, not much work involving PostGIS

Re: [postgis-users] Cost weighted distance raster

2017-03-06 Thread Spencer Gardner
> Hi Spencer, > I don’t know if they are still compatible with the newest PostGIS version. > They used to work fine but don’t expect very good performance. > Pierre Thanks, Pierre. Did all that work stagnate? Have there been efforts to incorporate into the main PostGIS code? Just curious to know

Re: [postgis-users] Cost weighted distance raster

2017-03-06 Thread Pierre Racine
-users@lists.osgeo.org Subject: [postgis-users] Cost weighted distance raster I'm looking to work with PostGIS raster to complete some network analysis using a cost raster surface. I came across this GSOC project from 2012 which was supposed to create functions to accomplish this: https

[postgis-users] Cost weighted distance raster

2017-03-03 Thread Spencer Gardner
I'm looking to work with PostGIS raster to complete some network analysis using a cost raster surface. I came across this GSOC project from 2012 which was supposed to create functions to accomplish this: https://trac.osgeo.org/postgis/wiki/PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools Does