Will Skora skorasaurus
skorasaurus
/ gist:3941345
Created
October 23, 2012 20:31
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ( SELECT 'building' AS type, name, way_area AS area, | |
| ST_PointOnSurface(way) AS way | |
| FROM planet_osm_polygon | |
| WHERE name IS NOT NULL | |
| AND building NOT IN (' ', 'no', '0', 'false') | |
| AND building IS NOT NULL | |
| AND ST_SetSRID(way,900913) && !bbox! | |
| AND ST_IsValid(way) | |
| ORDER BY area DESC | |
| ) AS data |
skorasaurus
/ gist:4059615
Created
November 12, 2012 14:13
( SELECT basket, way from planet_osm_point WHERE basket IS NOT NULL) as dayta
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| kdgolf2 2012-11-12 09:01:32 ESTLOG: duration: 5.218 ms statement: SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_point' | |
| kdgolf2 2012-11-12 09:01:32 ESTLOG: duration: 0.578 ms statement: SELECT * FROM ( SELECT basket, way from planet_osm_point WHERE basket IS NOT NULL) as dayta LIMIT 0 | |
| kdgolf2 2012-11-12 09:01:32 ESTLOG: duration: 3.451 ms parse <unnamed>: SELECT ST_AsBinary("way") AS geom,"basket" FROM ( SELECT basket, way from planet_osm_point WHERE basket IS NOT NULL) as dayta WHERE "way" && ST_SetSRID('BOX3D(-9529337.93 5204354.11,-9528816.359999999 5204640.8)'::box3d, 900913) LIMIT 500 | |
| kdgolf2 2012-11-12 09:01:32 ESTLOG: duration: 0.056 ms bind <unnamed>: SELECT ST_AsBinary("way") AS geom,"basket" FROM ( SELECT basket, way from planet_osm_point WHERE basket IS NOT NULL) as dayta WHERE "way" && ST_SetSRID('BOX3D(-9529337.93 5204354.11,-9528816.359999999 5204640.8)'::box3d, 900913) LIMIT 500 | |
| kdgolf2 2012-11-12 09:01:32 ESTLOG: duration: 0.179 ms execute <unn |
skorasaurus
/ gist:4060045
Created
November 12, 2012 15:40
postgresql log for kdgolf2 - 2012.11.12 10:29
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| kdgolf2 2012-11-12 10:29:11 ESTLOG: duration: 4.968 ms statement: SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_point' | |
| kdgolf2 2012-11-12 10:29:11 ESTLOG: duration: 0.524 ms statement: SELECT * FROM ( SELECT basket, way from planet_osm_point WHERE basket IS NOT NULL) AS dayta LIMIT 0 | |
| kdgolf2 2012-11-12 10:29:11 ESTLOG: duration: 4.990 ms statement: SELECT lower(type) as type FROM geometry_columns WHERE f_table_name='planet_osm_point' | |
| kdgolf2 2012-11-12 10:29:56 ESTLOG: duration: 4.919 ms statement: SELECT f_geometry_column, srid FROM geometry_columns WHERE f_table_name='planet_osm_point' | |
| kdgolf2 2012-11-12 10:29:56 ESTLOG: duration: 0.621 ms statement: SELECT * FROM ( SELECT basket, way from planet_osm_point WHERE basket IS NOT NULL) AS dayta LIMIT 0 | |
| kdgolf2 2012-11-12 10:29:56 ESTLOG: duration: 3.391 ms parse <unnamed>: SELECT ST_AsBinary("way") AS geom,"basket" FROM ( SELECT basket, way from planet_osm_point WHERE basket IS NOT NULL) AS dayta WHERE "way" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| treasure = Points( | |
| name = 'treasure', | |
| mapping = { | |
| ('tre', Integer() | |
| ), | |
| } | |
| ), |
skorasaurus
/ gist:4081959
Created
November 15, 2012 22:39
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Map { | |
| background-color: #aaa; | |
| font-directory: url(./fonts); } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| map { | |
| background-color: #999; | |
| } | |
| #border { | |
| opacity: 0.5; | |
| polygon-comp-op: dst-in; | |
| line-width: 4; | |
| line-opacity: .65; | |
| } |
skorasaurus
/ gist:4183005
Created
December 1, 2012 16:01
unoccured exception in todo plugin, josm 5608.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Repository Root: http://josm.openstreetmap.de/svn | |
| Build-Date: 2012-11-29 02:31:07 | |
| Last Changed Author: stoecker | |
| Revision: 5608 | |
| Repository UUID: 0c6e7542-c601-0410-84e7-c038aed88b3b | |
| URL: http://josm.openstreetmap.de/svn/trunk | |
| Last Changed Date: 2012-11-28 23:47:46 +0100 (Wed, 28 Nov 2012) | |
| Last Changed Rev: 5608 | |
| Identification: JOSM/1.5 (5608 en) |
skorasaurus
/ gist:4183055
Created
December 1, 2012 16:12
unoccured exception in todo plugin, josm 5608.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Repository Root: http://josm.openstreetmap.de/svn | |
| Build-Date: 2012-11-29 02:31:07 | |
| Last Changed Author: stoecker | |
| Revision: 5608 | |
| Repository UUID: 0c6e7542-c601-0410-84e7-c038aed88b3b | |
| URL: http://josm.openstreetmap.de/svn/trunk | |
| Last Changed Date: 2012-11-28 23:47:46 +0100 (Wed, 28 Nov 2012) | |
| Last Changed Rev: 5608 | |
| Identification: JOSM/1.5 (5608 en) |
skorasaurus
/ gist:4224538
Created
December 6, 2012 13:45
— forked from cageyjames/gist:4220223
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #ne50mpopulatedplaces { | |
| [zoom = 3][SCALERANK = 0]{ | |
| ::labels{ | |
| text-name:[NAME]; | |
| text-face-name:"DejaVu Sans Book"; | |
| text-fill:#3d3d3d; | |
| text-size:11; | |
| text-min-distance:8; | |
| text-line-spacing:1; | |
| text-halo-radius:1;} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <script src='wax/ext/modestmaps.min.js' type='text/javascript'></script> | |
| <script src='wax/dist/wax.mm.js' type='text/javascript'></script> | |
| <link href='wax/theme/controls.css' rel='stylesheet' type='text/css' /> | |
| <script src='http://api.tiles.mapbox.com/mapbox.js/v0.6.7/mapbox.js'></script> | |
| <link href='http://api.tiles.mapbox.com/mapbox.js/v0.6.7/mapbox.css' rel='stylesheet' /> | |
| <style> |