Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Updating zip.csv file #124

Open
pkarman opened this issue Aug 10, 2022 · 0 comments
Open

Updating zip.csv file #124

pkarman opened this issue Aug 10, 2022 · 0 comments

Comments

@pkarman
Copy link
Contributor

pkarman commented Aug 10, 2022

The README in prep/ refers to

The zip-subregion utility lookup data comes from the "Zip-subregion" tab of the Power Profiler Emissions Tool Excel file.

but has no other details about how the Zip-subregion tab (sheet) of that Excel file is transformed into containing these additional fields:

  • UtilName
  • trim_util_code
  • Predominant Utility

Is the app/data/zip.csv file manually maintained? That seems unlikely given the inconsistent column spelling conventions. (1 each of CamelCase, snake_case, Title Case and ALLCAPS -- that's quite impressive!) If there's some programmatic way of generating the zip.csv file from the Excel and shapefile data, plus the Zip-subregion sheet, that would be lovely to at least document.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant