search

degauss-org / st_census_tract

link geocoded coordinates with date ranges to corresponding census tracts from the appropriate vintage
https://geomarker.io/st_census_tract
GNU General Public License v3.0
2 stars 0 forks source link

two rows with address ranges spanning more than 1 decade results in unexpected output #2

Closed cole-brokamp closed 2 years ago

cole-brokamp commented 2 years ago

If I run a.csv through, I get some unexpected output. It only seems to happen with date ranges in a row that both span more than one decade. Each one works fine individually in a csv file. The problem is only when they are right in a row.

  > cat a.csv
lat, lon, start_date, end_date
39.15, -84.51, "2010/04/12", "2020/12/31"
39.15, -84.51, "2010/04/11", "2020/12/30"

  > cat a_st_census_tract_v0.0.3.csv
lat,lon,start_date,end_date,census_tract_vintage,census_tract_id
39.15,-84.51,2010-04-12,2010-12-31,2010,39061006900
39.15,-84.51,2010-04-11,2010-12-31,2010,39061006900
39.15,-84.51,2020-01-01,2020-12-31,2020,39061006900
39.15,-84.51,2020-01-01,2020-12-30,2020,39061006900
39.15,-84.51,2010-04-12,2010-12-31,2010,39061006900
39.15,-84.51,2010-04-11,2010-12-31,2010,39061006900
39.15,-84.51,2020-01-01,2020-12-31,2020,39061006900
39.15,-84.51,2020-01-01,2020-12-30,2020,39061006900