The values match one those "(rXXXXX)" parts are removed. I called Census this morning and they informed me that those are footnotes for values that have been revised due to a CQR. I thought that all CQR data was kept separate and I'm not quite sure why it has to be in the same field as the count value and not a separate field. So the important thing to know is that the text file that's included with the downloaded data shows those footnotes and their corrected counts. All those footnotes must be removed from the cell before that data can be used. Thank you, Geoff Olson Transportation Planner Bi-State Regional Commission 1504 3rd Ave. P.O. Box 3368 Rock Island, IL 61204 (309) 793-6302 ext. 151 -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Liang.Long.CTR(a)dot.gov Sent: Wednesday, January 29, 2014 8:37 AM To: ctpp-news(a)chrispy.net Subject: Re: [CTPP] UPDATE 2010 Census Block-Level Data is Changed SF1-P1 Hi, Geoff Thanks for sharing your experience with us. When you mentioned that two data sources are off by 696 people, is this caused by rvalues included data? Or even after cleaning up rvalue cells, two datasets are still off by 696? Thanks, Liang ________________________________________ From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] on behalf of Geoff Olson [golson(a)bistateonline.org] Sent: Tuesday, January 28, 2014 5:25 PM To: 'ctpp-news(a)chrispy.net' Subject: Re: [CTPP] UPDATE 2010 Census Block-Level Data is Changed SF1-P1 I compared our data downloaded in 2011 to the recent data and there are fields in the data from FactFinder2 that have non-numeric characters in the data values. So for the 3 county are that our MPO is in, the count difference was off by 696 people (SF-1 P1). Here is what the data looks like, so please be aware that other data may have the same issue. This is just a small sample, sorted to have the "#VALUE!" cells at the top. The "2011" Blocks are the data we downloaded in 2011 and the "2014" Blocks are the data I downloaded just now. The values are there, but those r values are also included in the data. "2011" Block POP_TOT "2014" Blocks D001 ID Match 2011_2014_diff 171610241012049 167 171610241012049 167(r49517) Yay #VALUE! 171610241012050 78 171610241012050 78(r49518) Yay #VALUE! 171610241012051 86 171610241012051 86(r39321) Yay #VALUE! 171610241012056 135 171610241012056 135(r49515) Yay #VALUE! 171610241012057 3 171610241012057 3(r39322) Yay #VALUE! 171610241012079 51 171610241012079 51(r39318) Yay #VALUE! 171610241023013 17 171610241023013 17(r49516) Yay #VALUE! 191630130001018 90 191630130001018 90(r39585) Yay #VALUE! 191630130001020 48 191630130001020 48(r39586) Yay #VALUE! 191630130001024 19 191630130001024 19(r39587) Yay #VALUE! 191630135001037 2 191630135001037 2(r39591) Yay #VALUE! 170730301001000 0 170730301001000 0 Yay 0 170730301001001 0 170730301001001 0 Yay 0 170730301001002 0 170730301001002 0 Yay 0 170730301001003 0 170730301001003 0 Yay 0 170730301001004 0 170730301001004 0 Yay 0 170730301001005 0 170730301001005 0 Yay 0 170730301001006 0 170730301001006 0 Yay 0 170730301001007 0 170730301001007 0 Yay 0 170730301001008 0 170730301001008 0 Yay 0 170730301001009 0 170730301001009 0 Yay 0 170730301001010 219 170730301001010 219 Yay 0 170730301001011 43 170730301001011 43 Yay 0 170730301001012 64 170730301001012 64 Yay 0 170730301001013 70 170730301001013 70 Yay 0 170730301001014 0 170730301001014 0 Yay 0 170730301001015 0 170730301001015 0 Yay 0 I hope this helps someone else. Thank you, Geoff Olson Transportation Planner Bi-State Regional Commission 1504 3rd Ave. P.O. Box 3368 Rock Island, IL 61204 (309) 793-6302 ext. 151 -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Geoff Olson Sent: Tuesday, January 28, 2014 9:52 AM To: 'ctpp-news(a)chrispy.net' Subject: [CTPP] 2010 Census Block-Level Data is Changed SF1-P1 Our MPO has been working on getting Census block data aggregated to TAZ levels and we noticed that Census data that was downloaded when 2010 Census data was released does not match 2010 Census Data that was downloaded today. We've done various checks between the two tables (SF1-P1), and the sums are different. Our MPA population count with the older data is 297,986 and the sum the new data is showing us is 297,290. We did check this with ESRI's Community Analyst and it agrees with the older data that our MPA should have a Census 2010 population of 297,986. Is there a reason when Census data might change? If the P1 data has changed, then I'm wondering if other Census data might be different too. Thank you, Geoff Olson Transportation Planner Bi-State Regional Commission 1504 3rd Ave. P.O. Box 3368 Rock Island, IL 61204 (309) 793-6302 ext. 151 This email and all attachments are intended only for the listed recipient(s). This message may contain confidential or privileged information only for use by the listed recipient(s). Do not forward, post or otherwise disclose the contents of this email without the permission of the sender. If you received this message in error, please delete it and notify the sender immediately. Bi-State Regional Commission accepts no responsibility for any damages caused by this message, including those related to viruses or malware. _______________________________________________ ctpp-news mailing list ctpp-news(a)chrispy.net https://www.chrispy.net/mailman/listinfo/ctpp-news This email and all attachments are intended only for the listed recipient(s). This message may contain confidential or privileged information only for use by the listed recipient(s). Do not forward, post or otherwise disclose the contents of this email without the permission of the sender. If you received this message in error, please delete it and notify the sender immediately. Bi-State Regional Commission accepts no responsibility for any damages caused by this message, including those related to viruses or malware. This email and all attachments are intended only for the listed recipient(s). This message may contain confidential or privileged information only for use by the listed recipient(s). Do not forward, post or otherwise disclose the contents of this email without the permission of the sender. If you received this message in error, please delete it and notify the sender immediately. Bi-State Regional Commission accepts no responsibility for any damages caused by this message, including those related to viruses or malware. _______________________________________________ ctpp-news mailing list ctpp-news(a)chrispy.net https://www.chrispy.net/mailman/listinfo/ctpp-news _______________________________________________ ctpp-news mailing list ctpp-news(a)chrispy.net https://www.chrispy.net/mailman/listinfo/ctpp-news This email and all attachments are intended only for the listed recipient(s). This message may contain confidential or privileged information only for use by the listed recipient(s). Do not forward, post or otherwise disclose the contents of this email without the permission of the sender. If you received this message in error, please delete it and notify the sender immediately. Bi-State Regional Commission accepts no responsibility for any damages caused by this message, including those related to viruses or malware.