Alternate Generated Power Source at Retail Gasoline Outlets - DAM FuelNY

In response to Super-storm Sandy, the “FuelNY” law (AML 16.192-H), gas stations subject to the FuelNY program are required to: (1) install an electrical transfer switch; (2) develop an emergency generator deployment plan; and (3) implement their plan within 24 hours of an energy emergency declaration. Gas station chains (defined as those stations owned by someone who owns more than one gas station) must also have a FuelNY compliant transfer switch installed at an additional 30% of their stations located outside of the FuelNY region (AML Article 16 §192-H(2)(iv)). These chain establishments located downstate but farther than ½ mile of an exit road on controlled access highway or evacuation route must implement their emergency plan within 48 hours of an emergency declaration. This program was implemented in 2014 to maintain the flow of motor fuel during an emergency.

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/alternate-generated-power-source-at-retail-wn3j-2ia4\".\"alternate_generated_power_source_at_retail\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.