Skip to content

Instantly share code, notes, and snippets.

View springmeyer's full-sized avatar

Dane Springmeyer springmeyer

1.2k followers · 1.2k following
View GitHub Profile
@springmeyer
springmeyer / add_primary_key.sql
Created December 26, 2011 17:25
add unique primary key column and sequence to osm2pgsql tables
ALTER TABLE "planet_osm_line" ADD COLUMN "gid" INTEGER;
CREATE SEQUENCE "planet_osm_line_gid_seq";
UPDATE planet_osm_line SET gid = nextval('"planet_osm_line_gid_seq"');
ALTER TABLE "planet_osm_line"
ALTER COLUMN "gid" SET DEFAULT nextval('"planet_osm_line_gid_seq"');
ALTER TABLE "planet_osm_line"
ALTER COLUMN "gid" SET NOT NULL;
ALTER TABLE "planet_osm_line" ADD UNIQUE ("gid");
ALTER TABLE "planet_osm_line" ADD PRIMARY KEY ("gid");
@springmeyer
springmeyer / transformer_glitch.cpp
Created December 21, 2011 17:29 — forked from tmcw/transformer_glitch.cpp
produces (but try changing bbox):
```
before: box2d(-180,-60,180,60)
after back: box2d(-20037508.34278924,-8399737.889818359,20037508.34278924,8399737.889818355)
after forward: box2d(-180,-60.00000000000001,180,59.99999999999999)
```
@springmeyer
springmeyer / gist:1504260
Created December 21, 2011 02:17
var path = require('path');
console.log(path.resolve(__dirname + '/../fixtures'));
console.log(path.resolve(path.join(__dirname,'../fixtures')));
@springmeyer
springmeyer / gist:1503714
Created December 20, 2011 23:03
# BEGIN WPSuperCache
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
AddDefaultCharset UTF-8
RewriteCond %{REQUEST_URI} !^.*[^/]$
RewriteCond %{REQUEST_URI} !^.*//.*$
RewriteCond %{REQUEST_METHOD} !POST
@springmeyer
springmeyer / sqlite-speedtest.sql
Created December 20, 2011 00:43
testing sqlite query speed with complex joins and rtree spatial filtering
cd ~/github/atlas-project/
sqlite3 /usr/share/mapbox/project/compare-s-2008-cty-g-2008-cty/layers/elections.sqlite
attach database "tabular-data/comp_res.sqlite" as comp_res;
-- speed-test1
select count(*)
from attributes
join (
select geoid as results_geoid, (cast(dem as real) / cast(total as real) * 100) as pct1,
(
@springmeyer
springmeyer / gist:1486799
Created December 16, 2011 16:42
g++ -o bindings/python/mapnik_geometry.os -c -DHAVE_JPEG -ansi -Wall -pthread -ftemplate-depth-300 -DLINUX -DBOOST_SPIRIT_THREADSAFE -DMAPNIK_THREADSAFE -O3 -finline-functions -Wno-inline -Wno-parentheses -Wno-char-subscripts -DNDEBUG -DHAVE_CAIRO -DHAVE_PYCAIRO -pthread -fPIC -Ideps/agg/include -I. -Iinclude -I/usr/local/include -I/usr/include -I/usr/include/freetype2 -I/usr/include/libxml2 -I/usr/include/gdal -I/usr/include/postgresql -I/usr/include/python2.7 -I/usr/include/cairo -I/usr/include/glib-2.0 -I/usr/lib/x86_64-linux-gnu/glib-2.0/include -I/usr/include/pixman-1 -I/usr/include/libpng12 -I/usr/include/cairomm-1.0 -I/usr/lib/cairomm-1.0/include -I/usr/include/sigc++-2.0 -I/usr/lib/sigc++-2.0/include -I/usr/include/pycairo bindings/python/mapnik_geometry.cpp
In file included from include/mapnik/util/geometry_to_wkt.hpp:32:0,
from bindings/python/mapnik_geometry.cpp:39:
include/mapnik/util/geometry_wkt_generator.hpp: In instantiation of ‘mapnik::util::wkt_generator<std::back_insert_ite
@springmeyer
springmeyer / fails.sh
Created December 13, 2011 21:36
test icu's Collator::createInstance
# *** this fails ***
BUILD="/opt/icu4_8"
export DYLD_LIBRARY_PATH=/opt/icu4_8/lib
export ARCH_FLAGS="-arch x86_64 -arch i386"
export CFLAGS=$ARCH_FLAGS
export CXXFLAGS=$CFLAGS
export LDFLAGS=$ARCH_FLAGS
./runConfigureICU MacOSX --prefix=${BUILD} && make -j6 && make install
clang++ -o icutest icutest.cpp -I${BUILD}/include/ -L${BUILD}/lib -licuuc -licui18n
./icutest
@springmeyer
springmeyer / query plan
Created December 9, 2011 19:40
attach database "../tabular-data/comp_res.sqlite" as comp_res;
explain query plan select OGC_FID, GEOMETRY, (
(
cast(dem as real) /
cast(total as real) * 100
) -
(
cast(replace(group_concat(dem, " "), dem, "") as real) /
cast(replace(group_concat(total, " "), total, "") as real) * 100
@springmeyer
springmeyer / gist:1449821
Created December 9, 2011 02:20
diff --git a/debian-nightlies/nightly-build.sh b/debian-nightlies/nightly-build.sh
index 50966b7..4dac566 100755
--- a/debian-nightlies/nightly-build.sh
+++ b/debian-nightlies/nightly-build.sh
@@ -11,30 +11,34 @@ DEST="mapnik" # the launchpad account name
GPGKEY=80B52FF1
DEBFULLNAME="Robert Coup (Mapnik Nightly Builds)"
DEBEMAIL="robert+mapniknightly@coup.net.nz"
+#GPGKEY=89DBC525
+#DEBFULLNAME="Dane Springmeyer (Mapnik Nightly Builds)"
@springmeyer
springmeyer / gist:1444810
Created December 7, 2011 21:42
mapnik@mapnik-VirtualBox:~/src/tilemill-v0.7.1/platforms/ubuntu$ git diff debian/
diff --git a/platforms/ubuntu/debian/changelog b/platforms/ubuntu/debian/changelog
index 818408a..02d0e4a 100644
--- a/platforms/ubuntu/debian/changelog
+++ b/platforms/ubuntu/debian/changelog
@@ -1,3 +1,15 @@
+tilemill (0.7.1~maverick1) maverick; urgency=medium
+ * tilemill
+ -- Dane Springmeyer <dane.springmeyer@gmail.com> Wed, 7 Dec 2011 23:39:00 -0400
+