Re: [postgis-users] Line of sight (LOS) Calculation

2015-03-09 Thread Paolo Cavallini
Il 09/03/2015 04:16, Mark Wynter ha scritto: An example of how you can generate Viewsheds in PostGIS via PL/R and Grass using a single SQL query statement. CREATE OR REPLACE FUNCTION generate_viewshed(coordxy text) RETURNS text as Hi all. Please note that in GRASS7, recently released,

Re: [postgis-users] Line of sight (LOS) Calculation

2015-03-09 Thread Rémi Cura
Very cool solution ! Could you give a better estimate of run time? (example of DEM resolution, time?) Cheers, Rémi-C 2015-03-09 9:45 GMT+01:00 Paolo Cavallini cavall...@faunalia.it: Il 09/03/2015 04:16, Mark Wynter ha scritto: An example of how you can generate Viewsheds in PostGIS via PL/R

[postgis-users] Line of sight (LOS) Calculation

2015-03-08 Thread Mark Wynter
Grass r.viewshed is very good and fast, and plays nicely with postgis et al. We are talking about seconds per viewshed. You keep your DEM in grass. Then set the g.extent of the DEM raster to define your area of interest. This is very important to get fast calculation times. Once you've called

[postgis-users] Line of sight (LOS) Calculation

2015-03-08 Thread Mark Wynter
An example of how you can generate Viewsheds in PostGIS via PL/R and Grass using a single SQL query statement. CREATE OR REPLACE FUNCTION generate_viewshed(coordxy text) RETURNS text as $$ library(spgrass6) initGRASS(gisBase = /usr/lib/grass64/, home = tempdir(), gisDbase = /data/grassdata/,

[postgis-users] Line of sight (LOS) Calculation

2015-03-07 Thread Ofer Zilberstein
Hi, I would like to calculate LOS (visibility) from a point to an area fast as possible. For example looking from one observation point to 1000 targets that represents the area The option is to use terrain existing tools such as ARC Toolbox or using function in POSTGIS I wander if there is an