Where does geocoded_facilities_cal.csv come from?

[kbuzard]

My best guess is that it's either cut down from geocoded_facilities.csv, or it's made by hand, in which case we need to determine the source from which the manual work was done.

Is @Kirs10-Riley helping with this?

[JorgeValde]

If this is correct, which I think it is, then GeoCoder.py will come before shapify.py. GeoCoder is creating cal_labs.shp and then shapiy.py is writing on it. Shapify.py was created a month after GeoCoder.py

[kbuzard]

If this is correct, which I think it is, then GeoCoder.py will come before shapify.py.

I think they're parallel. I think GeoCoder.py is like a fancier version. It geocodes all the labs for the whole country, then drops the ones that aren't for California, then creates the output.

• shapify somehow gets just the geocoded CA labs (this is the file we don't know the origin of) and the creates the output shape file
  • Can you check whether the columns from "..T-Burk\PngData\cattLabs97.csv" are included in geocoded_facilities_cal.csv or not? Do the columns match up to geocoded_facilities.csv? This might help to see what the relationship is AND to figure out what Antonio actually used.

[JorgeValde]

geocoded_facilities_cal.csv and geocoded_facilities.csv have the same number of variables. geocoded_facilities.csv has (5 vars, 8,736 obs) geocoded_facilities_cal.csv has (5 vars, 1,729 obs) cattLabs97.csv has (20 vars, 12,778 obs)

The only variable from geocoded_facilities.csv (_cal.csv) that is common to cattLabs97.csv is id. The rest are all different. The five variables are: v1, address, id, lat, lng