Skip to content

Instantly share code, notes, and snippets.

View oeon's full-sized avatar

Joe Larson oeon

71 followers · 147 following
View GitHub Profile
@oeon
oeon / joes_hello_postgis.sql
Created September 20, 2012 23:23
Hello PostGIS!
select st_asgeojson(st_multi(st_buildarea(st_collect(la_panza_sel.geom)))) from la_panza_sel;
@oeon
oeon / gist:3854756
Created October 8, 2012 20:25
handbrake batch encode (merge) params
-e x264 -q 20.0 -a 1,1 -E faac,copy:ac3 -B 160,160 -6 dpl2,auto -R Auto,Auto -D 0.0,0.0 -f mp4 -X 720 --loose-anamorphic -m -x cabac=0:ref=2:me=umh:bframes=0:weightp=0:8x8dct=0:trellis=0:subme=6
@oeon
oeon / gist:3913754
Created October 18, 2012 17:54
http://overpass-api.de/api/xapi?*[building=*][bbox=-120.8437,35.3203,-120.84309,35.32116][@meta]
@oeon
oeon / Ubuntu s3fs install
Created November 1, 2012 20:53 — forked from matthewhudson/Ubuntu s3fs install
Ubuntu s3fs install & dependencies.
# Install prerequisites before compiling:
apt-get install build-essential
apt-get install libfuse-dev
apt-get install fuse-utils
apt-get install libcurl4-openssl-dev
apt-get install libxml2-dev
apt-get install mime-support
# Download and Install
wget http://s3fs.googlecode.com/files/s3fs-1.61.tar.gz
@oeon
oeon / gist:4003463
Created November 2, 2012 18:42
ec2 s3fs, struggles/notes
#trying to use s3fs mount for GeoServer data
#
#LINKS: http://stackoverflow.com/questions/9764401/change-user-ownership-of-s3fs-mounted-buckets
#http://librelist.com/browser//geonode/2011/10/19/changing-the-geoserver-tomcat-data-directory/
sudo -u tomcat6 s3fs slugisdata -o passwd_file=/home/tomcat6/passwd-s3fs /mnt/slugisdata
@oeon
oeon / gist:4030115
Created November 7, 2012 08:01
Esri free intern training

Trainings selected via http://training.esri.com/gateway/index.cfm?fa=search.results&cannedsearch=2 assume ArcMap version 10.x, noted * 9.3 if applicable. If you see another free training you would like to do instead, please identify it - otherwise, start here.

Authoring Web Maps Using ArcGIS Online http://training.esri.com/gateway/index.cfm?fa=catalog.webCourseDetail&courseid=2519

Creating a Common Operational Picture with ArcGIS (9.3) http://training.esri.com/gateway/index.cfm?fa=catalog.webCourseDetail&courseid=1743

Creating Map Books Using Data Driven Pages http://training.esri.com/gateway/index.cfm?fa=catalog.webCourseDetail&courseid=2152

@oeon
oeon / gist:4167521
Created November 29, 2012 08:13
source filename in shapefile
#1
for f in *.shp;
do
name=${f%.shp}
ogrinfo $f -sql "ALTER TABLE $name ADD COLUMN filename character(10)"
ogrinfo $f -sql "UPDATE TABLE $name filename = '$f'"
@oeon
oeon / addfilenamecol.sh
Last active October 13, 2015 08:58
Add column with source filename from folder of shapefiles. Requires GDAL 1.10dev, my attempt to drop .shp extension isn't working - but overall, works.
for f in *.shp;
do
name=${f%.shp}
/Users/you/gdal_trunk/bin/ogrinfo $f -sql "ALTER TABLE $name ADD COLUMN filename character(21)"
/Users/you/gdal_trunk/bin/ogrinfo $f -dialect SQLite -sql "UPDATE $name SET filename = '$f'"
done;
@oeon
oeon / gist:4732520
Last active December 12, 2015 06:49
QGIS field calculator
CASE WHEN "UNIT2" IS NULL AND "TYPE2" IS NOT NULL THEN concat("ADDRESS",' ',"NAME2",' ',"TYPE2") WHEN "UNIT2" IS NOT NULL AND "TYPE2" IS NOT NULL THEN concat("ADDRESS",' ',"NAME2", "TYPE2",' Unit ',"UNIT2") WHEN "UNIT2" IS NOT NULL AND "TYPE2" IS NULL THEN concat("ADDRESS",' ',"NAME2", ' Unit ', "UNIT2") ELSE concat("ADDRESS",' ',"PREFIX2",' ',"NAME2",' ',"TYPE2",' Unit ',"UNIT2") END
@oeon
oeon / qgis_libs.sh
Created February 12, 2013 05:25 — forked from bmount/qgis_libs.sh
sudo mkdir -p /Library/Frameworks/GDAL.framework/Versions/1.9/
sudo ln -s /usr/local/lib/libgdal.dylib /Library/Frameworks/GDAL.framework/Versions/1.9/GDAL
sudo mkdir -p /Library/Frameworks/PROJ.framework/Versions/4/
sudo ln -s /usr/local/Cellar/proj/4.8.0/lib/libproj.dylib /Library/Frameworks/PROJ.framework/Versions/4/PROJ
# did not work: sudo ln -s `pwd`/libgeos.dylib /Library/Frameworks/GEOS.framework/Versions/3/GEOS
# did work:
# $PWD is /usr/local/Cellar/geos/3.3.6/lib
sudo ln -s `pwd`/libgeos_c.1.dylib /Library/Frameworks/GEOS.framework/Versions/3/GEOS
sudo mkdir -p /Library/Frameworks/SQLite3.framework/Versions/3/
sudo ln -s /usr/local/Cellar/sqlite/3.7.15/lib/libsqlite3.0.8.6.dylib /Library/Frameworks/SQLite3.framework/Versions/3/SQLite3