booo

SELECT

	nodes.id,
	nodes.version,
	nodes.user_id,
	users.name AS user_name,
	nodes.tstamp,
	nodes.changeset_id,
	hstore_to_array(nodes.tags) AS tags,
	Y(nodes.geom) AS lat,

booo

Hash Join  (cost=5503530.38..29517441.81 rows=2474305 width=153)"
"  Hash Cond: (nodes.user_id = users.id)"
"  ->  Merge Join  (cost=5500446.44..29443221.60 rows=2474305 width=144)"
"        Merge Cond: (nodes.id = public.relation_members.member_id)"
"        ->  Index Scan using pk_nodes on nodes  (cost=0.00..22433054.50 rows=586568128 width=144)"
"        ->  Materialize  (cost=5500446.44..5512817.96 rows=2474305 width=8)"
"              ->  Sort  (cost=5500446.44..5506632.20 rows=2474305 width=8)"
"                    Sort Key: public.relation_members.member_id"
"                    ->  HashAggregate  (cost=5154375.57..5179118.62 rows=2474305 width=8)"
"                          ->  Append  (cost=0.00..5148189.81 rows=2474305 width=8)"

booo

root@spaceship:/usr/local/etc/couchdb/local.d# /usr/local/bin/couchdb 
Apache CouchDB 1.1.2a05914bd-git (LogLevel=info) is starting.
[error] [<0.87.0>] {error_report,<0.32.0>,
                       {<0.87.0>,supervisor_report,
                        [{supervisor,{local,couch_secondary_services}},
                         {errorContext,start_error},
                         {reason,
                             {'EXIT',
                                 {undef,
                                     [{couch_spatial,start_link,[]},

booo

SELECT relation_id, ways.linestring FROM relations, relation_members, ways 

WHERE
	relation_members.member_id = ways.id

AND 
	relation_members.member_type = 'W'

AND
	relations.tags @> hstore('admin_level','8') AND relations.tags @> hstore('boundary','administrative')

booo

SELECT ST_AsText(ST_Polygonize(linestring)) AS GEOM FROM (

SELECT linestring FROM ways, relations, relation_members

WHERE
    relations.id = 162902
AND
    relations.id = relation_members.relation_id
AND
    ways.id = relation_members.member_id

booo

diff -urN libspatialindex-1.6.1-orig/include/tools/rand48.h libspatialindex-1.6.1/include/tools/rand48.h
--- libspatialindex-1.6.1-orig/include/tools/rand48.h   2010-03-09 03:58:29.000000000 +0100
+++ libspatialindex-1.6.1/include/tools/rand48.h        2011-05-16 13:51:15.000000000 +0200
@@ -1,11 +1,33 @@
 #pragma once
 
-extern void srand48(long seed);
-extern unsigned short *seed48(unsigned short xseed[3]);
-extern long nrand48(unsigned short xseed[3]);
-extern long mrand48(void);

booo

sinon = require "sinon"

assert = require "assert"

fn = ->
  console.log "called..."

spy = sinon.spy fn

fn()

booo

orm = require "orm"

orm.connect "postgresql://postgres:testing@localhost/orm", (success, db) ->
  if not success then console.log db.message
  else
    Place = db.define "place", {
      description:
        type: "string"
      geom:
        type: "geom"

booo

orm = require "orm"

orm.connect "postgresql://postgres:testing@localhost/orm", (success, db) ->
  if not success then console.log db.message
  else
    Place = db.define "place", {
      description:
        type: "string"
      geom:
        type: "geom"

booo

git = require "nodegit"

git.repo "../node-mapnik/.git", (error, repo) ->
  if error then console.log error
  else
    repo.branch "master", (error, branch) ->
      if error then console.log error
      else
        branch.tree().walk (i, entry) ->
          console.log entry.name