Clean Energy Fund Agriculture Audits: Beginning 2016

The Clean Energy Fund (CEF) Agriculture Audit program identifies energy efficiency measures for eligible farms and on-farm producers, including but not limited to: dairies, orchards, greenhouses, vegetables, vineyards, grain dryers, and poultry/egg. NYSERDA assigns Flexible Technical Assistance (FlexTech) Program Consultants to perform energy audits for eligible farms. Participating farms receive a customized plan with recommended energy efficiency upgrades. The Clean Energy Fund (CEF) Agriculture Audits dataset contains information collected from the audits such as location, electric and natural gas utility provider, and amount of CEF funding awarded to each audit.

The New York State Energy Research and Development Authority (NYSERDA) offers objective information and analysis, innovative programs, technical expertise, and support to help New Yorkers increase energy efficiency, save money, use renewable energy, accelerate economic growth, and reduce reliance on fossil fuels. To learn more about NYSERDA’s programs, visit nyserda.ny.gov or follow us on Twitter, Facebook, YouTube, or Instagram.

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 \"ny-gov/clean-energy-fund-agriculture-audits-beginning-4zrh-mycb\".\"clean_energy_fund_agriculture_audits_beginning\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.