Front Yard in Bloom Awards

All addresses that received Awards as part of the Front Yards in Bloom program.

Front Yards in Bloom is a partnership of the Edmonton Horticultural Society, the Canadian Union of Postal Workers, and the City of Edmonton.

Front Yards in Bloom congratulates private landscapes that make the whole city more beautiful.

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-yard-in-bloom-awards-bnfb-vu2t\".\"front_yard_in_bloom_awards\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.