elecnix/evalmtl.js

evalmtl node.js application

evalmtl.js

Web frontend for Évaluations foncières de Montréal.

1. Scrape and export to PostgreSQL

Follow instructions at https://github.com/elecnix/evalmtl

2. Create streets table

$ psql -d evalmtl
evalmtl=# CREATE TABLE streets AS SELECT row_number() OVER (ORDER BY street_name, arrondissement, municipalite) AS id, street_name, arrondissement AS borough, municipalite AS city FROM evaluations_2014 GROUP BY street_name, arrondissement, municipalite;
evalmtl=# ALTER TABLE streets ADD PRIMARY KEY (id);
evalmtl=# CREATE INDEX ON streets (street_name);
evalmtl=# ALTER TABLE evaluations_2014 ADD street_id integer;
evalmtl=# UPDATE evaluations_2014 SET street_id = (SELECT id FROM streets WHERE streets.street_name = evaluations_2014.street_name AND (streets.borough = evaluations_2014.arrondissement OR (streets.borough IS NULL AND evaluations_2014.arrondissement IS NULL)) AND streets.city = evaluations_2014.municipalite);
evalmtl=# CREATE INDEX ON evaluations_2014 (street_id);

3. Install node modules, assuming NPM is already installed:

npm install

4. Run!

DATABASE_URL=postgres://user:pass@localhost/evalmtl node app

Or push to Heroku:

heroku create
heroku addons:add heroku-postgresql:dev
git push heroku master
heroku open

evalmtl.js's Issues

Show streets on map

When searching for a street, display matching streets on a map. Draw line from lowest numeric address to highest numeric address.

Nom d'arrondissement tronqué

"Arrondissement de Villeray - Saint-Michel - Parc-Extens"

Navigate to property list when clicking on street

On mobile, the list displays at the bottom, and may not be visible.

Show properties on map

When selecting a street, display a map with the street shown as a line. As adresses are geocoded, refine the line in a polyline. Start with endpoints, then center, and keep dividing in halves at each iteration until 10% properties are geocoded to get a better fit.

Display hourglass while loading property list

Loading list of properties can take a few seconds, especially on mobile phones. Users need feedback.

Show borough of street matches

Perhaps grouped by borough?

Sort properties by numeric address

Wrong order:

1200 Boulevard Crémazie Est
140 Boulevard Crémazie Est
1460 Boulevard Crémazie Est

Add chart

Using D3.js http://d3js.org/