Skip to content

Instantly share code, notes, and snippets.

View smathermather's full-sized avatar

Stephen Mather smathermather

View GitHub Profile

Installing and configuring ODM components within the POSM base system; Determining approximate limitations on the number of source photos that can be handled by standard POSM hardware

Raw image upload (unprocessed images sourced from a sUAS) using a web form and/or fileshare; Copying / uploading post-processed GeoTIFFs to POSM using a web form and/or fileshare

GeoTIFF processing (externally sourced scenes and/or output from ODM):

  • Chunking input images into Web Mercator tiles at the TMS zoom level most closely corresponding to its native resolution
  • Pyramiding (downsampling and merging) of generated tiles to produce tiles for all appropriate zooms

Simple web interface for managing processing pipelines:

  • Display progress in a web view while processing proceeds
DROP TABLE IF EXISTS regions_medial_subset CASCADE;
CREATE TABLE regions_medial_subset AS
SELECT gid,
ST_ApproximateMedialAxis(ST_Buffer(geom, 0)) AS geom,
scalerank, featurecla, "name", namealt, region, subregion
FROM regions_polys_subset
WHERE
"name" != 'AUSTRALIA' AND "name" != 'NORTH AMERICA' AND
"name" != 'SOUTH AMERICA' AND "name" != 'EUROPE' AND
@smathermather
smathermather / strongsville_test.geojson
Last active December 21, 2015 23:29
test GeoJSON for Strongsville, OH
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@smathermather
smathermather / lineToStreet
Created July 30, 2013 18:57
Make Lines from Points to nearest road
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 / odm-big-vision.md
Last active November 9, 2015 02:58
OpenDroneMap -- The bigger vision

Objectives:

Take OpenDroneMap from simple toolchain to an online processing tool + open aerial dataset. This would be distinct from and complementary to OpenAerialMap:

  1. Explicitly engage and provide a platform for drone enthusiasts to contribute imagery in return for processing services.
  2. Address and serve:
  • Aerial imagery
  • Point clouds
  • Surface models
  • Terrain models
@smathermather
smathermather / odm_oam_mapknitter.md
Last active August 29, 2015 14:22
Thoughts on OAM, ODM, and MapKnitter

Integration points for ODM / OAM:

  • First step -- have ODM write OAM/OIM metadata and GeoTiff
  • Second step -- write wrapper to auto push to OAM catalog

Integration points for ODM MapKnitter

  • Adapt SIFT output for generic 2D autostitch
  • Use MapKnitter to approximately place identifiable photos and use that in optimization of ODM
@smathermather
smathermather / regexp_split
Created February 13, 2015 01:53
regexp split to table
CREATE TABLE nr.oram_metrics AS
SELECT oram_id, 'm1_wetland_area'::text AS metric, regexp_split_to_table(m1_wetland_area, ',')::text AS selection
FROM nr.cm_oram_data
UNION ALL
SELECT oram_id, 'm2a_upland_buffer_width'::text AS metric, regexp_split_to_table(m2a_upland_buffer_width, ',')::text AS selection
FROM nr.cm_oram_data;
@smathermather
smathermather / Centennial Webby People.md
Last active August 29, 2015 14:13
Centennial Webby People

Elements:

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

Website types/ Ideas

  • Timelines

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)