Front Yards In Bloom Nominations (1999 - 2013)

Shows all addresses that received nominations for the Front Yards in Bloom (FYinB) program. FYinB began in 1999 by the City of Edmonton, Edmonton Horticultural Society, and letter carriers. This shows all nominated addresses, starting in 2006, as well as top addresses from the beginning.

Any address can be nominated many times in one year.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"edmonton-ca/front-yards-in-bloom-nominations-1999-2013-scjj-9qzz\".\"front_yards_in_bloom_nominations_1999_2013\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.