usds / justice40-tool

A tool to identify disadvantaged communities due to environmental, socioeconomic and health burdens
https://screeningtool.geoplatform.gov/
Creative Commons Zero v1.0 Universal
133 stars 42 forks source link

When I open the csv or xlsx file, the prefixed 0s in census tract IDs are lost, causing usability issues. #953

Closed switzersc-usds closed 2 years ago

switzersc-usds commented 2 years ago

Describe the bug When I open the data file (either) in Excel, the first 0 of many of the census tract IDs is dropped and therefore the ID is made incorrect / unusable.

To Reproduce Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

Smartphone (please complete the following information):

Additional context Add any other context about the problem here.

lucasmbrown-usds commented 2 years ago

FYI, I'm not sure you'll be able to fix this in a CSV -- maybe writing strings around the cell like "01234567890" works? For excel, you may have to write ='01234567890, if you try "01234567890" and it doesn't work there either.