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

smathermather

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

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

-- 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

smathermather

each huc has interactive points for sampling locations identify gaps problem areas (not in attainment) another layer with the different projects

Timeline: End of June...

http://www.maptime.io/

smathermather

OpenDroneMap Texture Mapping

Background

Current status of OpenDroneMap

A fork of https://github.com/qwesda/BundlerTools, currently OpenDroneMap project uses Bundler SfM, Patch-based Multi-view Stereo Software (PMVS), Clustering Views for Multi-view Stereo (CMVS), and related tools to ingest a set of unreferenced images, perform multistereo matching, reconstruct original camera positions, sparse point cloud, and dense point cloud from image inputs. ODM is intended to act as a workflow for processing ground level and civilian UAS (drone) imagery to do 3D reconstruction, with target outputs of point clouds, surfaces, textured surfaces, and orthophotos. Currently ODM can provide outputs similar to figures 1 and 2.

Figure 1:

smathermather

Project scope:

• Assessment of existing hardware, software, and oganizational capacity
• Review of 5 existin and costs structures
• Develop ROI
• Develop guidlines to allow for shared costs
• Create short, medium, and long term implementation roadmap with recommendations
• Facilitate and build consensus with initial and possible future partners

Four tier model (generic model of how GIS services organizes)

smathermather

Elements:

• Web & Social Media
• Video
• Book
• Events
• Gala
• Money

Website types/ Ideas

• Timelines