About HomeStatusSQL

Code for America's BlightStatus project for City of Macon, Georgia. Backend technology ported to a Node.js server and a MySQL database

Homepage

Street-by-Street Results

Click for 2009-2012 Code Enforcement History

Individual House History and Survey Data

Browse Open Cases Map

Download as Google Earth KML

Experimental

Integration with SeeClickFix

Open311 Server

Integration with Google Prediction API

About the Database

MySQL

MySQL is a free and open-source database which uses the standard SQL language to retrieve data. MySQL was used to make HomeStatusSQL compatible with current and future city IT standards.

About Poang Framework

Poang - A sample node.js/MongoDB app for Heroku/MongoLab

Poang (github) is a Node.js/MongoDB app built using the Express framework. Poang uses Everyauth for local authentication, Mongoose-Auth to connect Everyauth to MongoDB (and Mongoose as the ODM) for account persistence, and Connect-Mongo as a session store. Most of the code in app.js was generated by Express and all of the code in auth.js after the Comment schema is straight from the Mongoose-Auth docs.

For testing, Poang uses the Mocha test framework, should for assertions, Sinon.JS for mocks & stubs, and Zombie.js for lightweight integration testing.

For more details, please see Steve's blog post that walks through the various tests in Poang.

Local Installation

1. Do a git clone:

   git clone git@github.com:mapmeld/HomeStatusSQL.git

2. cd into the project directory and then install the necessary node modules:

   npm install -d

3. start up your MySQL database, and set up a table with data

   Instructions draft: https://gist.github.com/3835623

4. start the node process:

   node app.js