smathermather

smathermather

-- Modifies all 
-- 
-- 

CREATE OR REPLACE FUNCTION drape_sampled(line geometry) RETURNS geometry AS $$
DECLARE line3d geometry;
BEGIN
    RAISE NOTICE 'draping';
    WITH linemeasure AS
      -- Add a measure dimension to extract steps

smathermather

Structure from Motion (SfM)
* http://flightriot.com/post-processing-software/
* http://wedidstuff.heavyimage.com/index.php/2013/07/12/open-source-photogrammetry-workflow/
* http://www.lancaster.ac.uk/staff/jamesm/software/sfm_georef.htm
* http://www.agisoft.ru/products/photoscan/professional/
* http://www.agisoft.ru/products/photoscan/standard/
* http://ccwu.me/vsfm/

Deep Learning
* http://vimeo.com/91460768

smathermather

#UAS flight specifications & business needs

Interactive Map: http://cdb.io/1nvcgRT

###Acacia Reservation #####Acreage 196 #####Location: -81.492562, 41.505428 ######BBOX: -81.497625, 41.501209, -81.486774, 41.51008 ####Business need:

1. Mapping of existing drainage tiles

smathermather

smathermather

CREATE OR REPLACE FUNCTION line_to_street (geometry) RETURNS geometry AS $$
 
WITH index_query as
                (SELECT ST_Distance($1,road.the_geom_webmercator) as dist,
                                ST_MakeLine(ST_ClosestPoint(road.the_geom_webmercator, $1), $1) as the_geom_webmercator
                FROM cuy_streets As road
                ORDER BY $1 <#> road.the_geom_webmercator limit 10)

SELECT the_geom_webmercator
                FROM index_query