caged

Spina Pro Message Inbox Setup

As of 01/07/2025, the Spina Pro Messages guide is unpublished, making it a little difficult getting up and running with message inboxes. Below is information I've peiced together while trying to get it running. Hopefully it can help the next person.

Prerequisites

• Spina pro installed using this guide.
• You have config.plugins = [ "Pro" ] set in your config/spina.rb config.

Generate your Message object

caged

// Start `node d3-server.js`
// Then visit http://localhost:1337/
//
var d3   = require('d3'),
    http = require('http')

http.createServer(function (req, res) {
  // Chrome automatically sends a requests for favicons
  // Looks like https://code.google.com/p/chromium/issues/detail?id=39402 isn't
  // fixed or this is a regression.

caged

How to use d3-tip with d3's simple bar chart example.

caged

#!/bin/sh
# usage ./create-psql-database DATABASE
#
DB_NAME=$1
FOLDER_NAME="nhgis0004"


# Drop and recreate database
dropdb --interactive "${DB_NAME}"
createdb --encoding UTF8 $DB_NAME

caged

# Returns a lambda used to determine what number is at t in the range of a and b
#
#   interpolate_number(0, 500).call(0.5) # 250
#   interpolate_number(0, 500).call(1) # 500
#
def interpolate_number(a, b)
  a = a.to_f
  b = b.to_f
  b -= a
  lambda { |t| a + b * t }

caged

.DS_Store
node_modules
us-judicial-districts.zip
build

caged

var svg  = document.getElementById('graph'),
    xml  = new XMLSerializer().serializeToString(svg),
    data = "data:image/svg+xml;base64," + btoa(xml),
    img  = new Image()

img.setAttribute('src', data)
document.body.appendChild(img)

caged

drop table if exists inspection_point_buffers;

-- Group identical overlapping points and count how many occupy
-- the space.
create temporary table inspection_overlappoing_points as
  select a.geom as geom,
        count(*)
  from latest_inspections a,
       latest_inspections b
  where st_equals(a.geom, b.geom)

caged

This is a general overview (from memory) of the steps I used to install graphite (http://graphite.wikidot.com) on OS X Lion. I think the steps are in order but YMMV. Please fork and fix if you find an error.

Install Python 2.7.2

brew install python

Check your env

$ python --version

caged

WITH
bad_geometries AS (SELECT
  (a.p_geom).path[1] AS path,
  (a.p_geom).geom
FROM
  (
    SELECT
      st_dump(shape) AS p_geom
    FROM
      us_district_court_jurisdictions