Discussions

I recently noticed an error in city market queries where certain city places have duplicate entries. For example, querying 'Carson' with state_abbreviation of 'NV' in location_type 'city' returns two entries. Both are identical with the only differences being their parcl_id and geoid values. In this example, the entry with parcl_id of 5377238 has the correct geoid of 3209700, at least according to a Census Bureau API query . The other entry with parcl_id of 5820707 has a 5 digit geoid, which is incorrect for a Census Bureau place geoid.

I have found the following parcl_id values have similar problems:

5821081 5821275 5821225 5823306 5821362 5822755 5822069 5821586 5821180 5823279 5822326
5824412 5823040 5820938 5820707 5820798 5821619 5824570 5822265

Any way to correct this error in the queries? As far as I can tell, every duplicate city has a geoid of 5 digits with the first 2 being the state's fips code. The last 3 digits, however, seem to be random as they are not part of the correct 7 digit geoid.