# How do you construct a 2000 migpuma1 and 2010 migpuma1 crosswalk?

**URL:** <https://forum.ipums.org/t/how-do-you-construct-a-2000-migpuma1-and-2010-migpuma1-crosswalk/2619>\
**Category:** USA\
**Created:** [October 18, 2018, 6:51am UTC](https://forum.ipums.org/t/how-do-you-construct-a-2000-migpuma1-and-2010-migpuma1-crosswalk/2619 "2018-10-18T06:51:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gennayliu](https://avatars.discourse-cdn.com/v4/letter/g/e5b9ba/32.png) [@gennayliu](https://forum.ipums.org/u/gennayliu)\
**Post date:** [October 18, 2018, 6:51am UTC](https://forum.ipums.org/t/how-do-you-construct-a-2000-migpuma1-and-2010-migpuma1-crosswalk/2619/1 "2018-10-18T06:51:00Z")

</div>

I am trying to create a 2000 migpuma1 and 2010 migpuma1 crosswalk. I created a crosswalk from 2000 PUMA -\> 2010 PUMA -\> 2010 migpuma1, but since migpuma1 is an aggregate of PUMAs, attempting to create the migpuma1 crosswalk through 2000 migpuma1 -\> 2000 PUMA -\> 2010 PUMA -\> 2010 migpuma1 may add a lot of noise. Does such a crosswalk exist?

---

<div class="post-metadata">

**Author:** ![JonathanSchroeder](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/jonathanschroeder/32/70_2.png) [@JonathanSchroeder](https://forum.ipums.org/u/JonathanSchroeder)\
**Post date:** [October 18, 2018, 5:48pm UTC](https://forum.ipums.org/t/how-do-you-construct-a-2000-migpuma1-and-2010-migpuma1-crosswalk/2619/2 "2018-10-18T17:48:00Z")

</div>

We haven’t yet constructed a 2000-2010 Migration PUMA crosswalk. It’s a good idea, though, and we’ll plan to construct one soon.

In fact, we’ve already been preparing a batch of new migration-related resources to release later this fall, which includes a [spreadsheet of 2000 PUMA–2000 Migration PUMA relationships](https://usa.ipums.org/usa/resources/volii/ipums_usa_puma_migpuma_2000.xlsx) that could help you construct a 2000-2010 Migration PUMA crosswalk. (The file is already available through that link, even though we haven’t yet updated our website to link to it.)

Using that spreadsheet, combined with our [2000-2010 PUMA crosswalk](https://usa.ipums.org/usa/resources/volii/PUMA2000_PUMA2010_crosswalk.xls) and our [2010 PUMA-MIGPUMA-PWPUMA relationships](https://usa.ipums.org/usa/resources/volii/puma_migpuma1_pwpuma00.xls) file, you should be able to determine the land areas and 2000 and 2010 populations of each intersection between a 2000 Migration PUMA and 2010 Migration PUMA. That said, I’ll plan to reply again soon–possibly next week–if/when I’ve been able to construct a “less noisy” 2000-2010 Migration PUMA crosswalk.

---

<div class="post-metadata">

**Author:** ![JonathanSchroeder](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/jonathanschroeder/32/70_2.png) [@JonathanSchroeder](https://forum.ipums.org/u/JonathanSchroeder)\
**Post date:** [October 24, 2018, 8:57pm UTC](https://forum.ipums.org/t/how-do-you-construct-a-2000-migpuma1-and-2010-migpuma1-crosswalk/2619/3 "2018-10-24T20:57:00Z")

</div>

I’ve attached a completed 2000-2010 Migration PUMA crosswalk. Feel free to reply to this message if you have any questions about it.

[MIGPUMA2000\_MIGPUMA2.xls](https://forum.ipums.org/uploads/short-url/hFmlOhsJDSnKfKi0OoORmJbaIX4.xls) (904 KB)