search

UrbanCCD-UChicago / plenario

API for geospatial and time aggregation across multiple open datasets.
http://plenar.io
MIT License
154 stars 43 forks source link

Error when downloading CSV data for "Austin Energy: 2013: ECAD Multi-Family Energy Audit and EUI Data" #228

Open geosir opened 8 years ago

geosir commented 8 years ago

The application returns an error page when trying to download CSV Raw Data for the "Austin Energy: 2013: ECAD Commercial Portfolio Manager Reported Data" dataset. Downloads for all other forms of data work fine.

To reproduce:

  1. Go to Austin Energy: 2013: ECAD Commercial Portfolio Manager Reported Data
  2. Click on the Download button.
  3. Select "Raw Data (CSV, first 1,000 records)".
HeyZoos commented 8 years ago

Hey George, it looks like this is resolvable by refining the query to include the dates listed for the dataset. Setting start date to something like 01/01/2010 and end date to 01/01/2016 finds the appropriate records and suddenly you are able to download them. But it highlights something interesting. If the query returns no records, then it causes an error for us.