Icon for Socrata external plugin
Updated over 1 year ago
Indexed 4 hours ago

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" \
{"sql": "
    SELECT *
    FROM \"edmonton-ca/front-yards-in-bloom-nominations-1999-2013-scjj-9qzz\".\"front_yards_in_bloom_nominations_1999_2013\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • front_yards_in_bloom_nominations_1999_2013
Upstream Metadata