OOTP Developments Forums - View Single Post

Raidergoo · 06-30-2006, 07:16 AM

I have a theory. I may have zipped and emailed the wrong file. I think this old data may have been from a different source at the Census dept.

Those cities you are pointing out ( I think ) are in multiple counties. The data that I was using listed their populations in each county, so I had to merge them and then delete them. I gave that up as too cumbersome and inaccurate when a different data file was shown to me.

For the life of me, I cant find the file I created from the places.txt Census data. It was a rather simple thing; I saved the file to C, imported it into Excel, used a custom space delimiting function to sort data into columns, deleted useless data like FIPS code, land and water area, then sorted by population, then chopped off the file at 1000 population size.

I think I will have to do it all over again.

06-30-2006, 07:16 AM	#15
Raidergoo Hall Of Famer Join Date: Mar 2003 Posts: 9,005	I have a theory. I may have zipped and emailed the wrong file. I think this old data may have been from a different source at the Census dept. Those cities you are pointing out ( I think ) are in multiple counties. The data that I was using listed their populations in each county, so I had to merge them and then delete them. I gave that up as too cumbersome and inaccurate when a different data file was shown to me. For the life of me, I cant find the file I created from the places.txt Census data. It was a rather simple thing; I saved the file to C, imported it into Excel, used a custom space delimiting function to sort data into columns, deleted useless data like FIPS code, land and water area, then sorted by population, then chopped off the file at 1000 population size. I think I will have to do it all over again.