Add/update fields in places_boundaries `parks` table

[chadlawlis]

Add/update these fields to the PostGIS Parks table for maintenance/output back into CartoDB Parks table.

Add:

• [x] unit_region
• [x] unit_state
• [x] unit_url
• [x] created_by
• [x] updated_by

Update/populate:

• [x] unit_region (populate from http://inside.nps.gov/index.cfm?handler=parkunitlist)
• [x] unit_state (populate from http://inside.nps.gov/index.cfm?handler=parkunitlist)
• [x] unit_url (populate from http://inside.nps.gov/index.cfm?handler=parkunitlist; double check against units with alternate unit_code)
• area -> area_km using: (holding off until specific need arises)
  • SELECT ((st_area(geography(the_geom, true))) / 1000) as area_km FROM parks
  • this will ensure that all unit area calculations output in square kilometers
• [x] created_by (figure out way to automate this)
• [x] updated_by (figure out way to automate this)
• created_at (figure out way to automate this)
  • Not possible given current server setup - no "user" accounts
• updated_at (figure out way to automate this)
  • Not possible given current server setup - no "user" accounts

[chadlawlis]

So, @jimmyrocks - places_lock does not need to be maintained here either, correct? Just the separate CartoDB table nps.parks_places_status? Or would you want that available here as well?

[jimmyrocks]

does not need to be maintained here either

On Wed, Dec 9, 2015 at 2:47 PM, Chad Lawlis notifications@github.com wrote:

So, @jimmyrocks https://github.com/jimmyrocks - places_lock does not need to be maintained here either, correct? Just the separate CartoDB table nps.parks_places_status? Or would you want that available here as well?

— Reply to this email directly or view it on GitHub https://github.com/nationalparkservice/places-data/issues/317#issuecomment-163370488 .

[chadlawlis]

Thanks, removing now.

[chadlawlis]

For unit_url, I compared our unit codes against those on http://inside.nps.gov/index.cfm?handler=parkunitlist.

This list has 486 unit codes, while we have 427 records (each with a unique unit code) in PostGIS parks. 417 of these match the NPS.gov list, while the following 10 do not:

1. obri (we use obed)
2. jofk (not on nps.gov)
3. losa (considered part of sacn on nps.gov)
4. cong (this is on nps.gov, list ahs it was cosw - added to alternate_unit_codes table)
5. kica (now part of seki)
6. sequ (now part of seki)
7. wamo (this is on nps.gov; list has it as wash - added to alternate_unit_codes table)
8. befr (considered part of inde on nps.gov)
9. naca (considered nace on nps.gov)
10. inpe (not technically an NPS unit - added in by request by glac)

So, I used the following queries to populate the unit_url accordingly. First, using the ones we know are on NPS.gov:

update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'abli';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'acad';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'adam';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'afbg';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'agfo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'alag';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'alca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'aleu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'alfl';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'alpo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'amis';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'amme';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'ande';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'ania';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'anjo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'anti';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'apco';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'apis';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'appa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'arch';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'arho';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'arpo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'asis';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'azru';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'badl';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'band';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'bawa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'bela';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'beol';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'bibe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'bica';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'bicy';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'biho';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'bisc';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'biso';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'bith';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'blac';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'blca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'blri';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'blue';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'boaf';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'boha';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'bost';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'bowa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'brca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'brcr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'brvb';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'buff';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'buis';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cabr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cach';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cacl';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'caco';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cagr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'caha';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cahe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cakr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cali';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'calo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cana';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cany';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'care';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cari';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'carl';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'casa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cato';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cave';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cavo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cawo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cebe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cebr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cech';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cham';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'chat';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'chch';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'chcu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'chic';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'chir';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'chis';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'choh';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'chpi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'chri';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'chro';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'chsc';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'chyo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'ciro';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'clba';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'coga';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'colm';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'colo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cong';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'coro';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cowp';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'crla';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'crmo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cuga';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cuis';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cure';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'cuva';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'daav';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'dena';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'depo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'deso';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'deto';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'deva';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'dewa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'dino';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'drto';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'ebla';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'edal';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'edis';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'efmo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'eise';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'elis';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'elma';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'elmo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'elro';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'euon';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'ever';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'feha';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fiis';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fila';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'flfo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'flni';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fobo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fobu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'foca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'foda';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fodo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fofr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fola';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fols';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'foma';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fomc';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fomr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fone';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fopo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fopu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fora';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fosc';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fosm';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fost';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fosu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'foth';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'foun';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fous';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fova';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'fowa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'frde';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'frdo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'frhi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'frla';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'frsp';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'frst';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gaar';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gari';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gate';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gegr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gero';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gett';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gewa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gicl';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'glac';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'glba';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'glca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'glde';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'glec';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'goga';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gois';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gosp';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'grba';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'grca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gree';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'greg';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'grfa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'grko';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'grpo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'grsa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'grsm';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'grsp';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'grte';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'guco';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'guis';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gumo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gwca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'gwmp';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hafe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hafo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hagr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hale';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hamp';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'havo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'heho';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hobe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hocu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hofr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hofu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'home';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hono';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hosp';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hove';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hstr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'hutr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'iatr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'inde';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'indu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'isro';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'jaga';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'jame';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'jazz';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'jeca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'jeff';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'jela';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'jica';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'joda';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'jodr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'jofi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'jofl';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'jomu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'jotr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'kaho';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'kala';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'katm';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'kefj';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'kemo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'kewe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'kimo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'klgo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'klse';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'knri';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'kova';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'kowa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'labe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'lach';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'lacl';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'lake';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'lamr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'laro';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'lavo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'lecl';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'lewi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'libi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'libo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'liho';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'linc';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'liri';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'long';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'lowe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'lyba';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'lyjo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mabi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'maca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'malu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mamc';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mana';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'manz';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mava';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mawa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mcho';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'meve';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'miin';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mima';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mimi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'miss';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mlkm';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mnrr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'moca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mocr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'moja';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mono';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mopi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'mora';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'morr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'moru';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'muwo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'nabr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'natc';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'natr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'natt';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'nava';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'nebe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'nepe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'neri';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'nico';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'niob';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'nisi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'noat';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'noca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'noco';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'npsa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'ocmu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'olym';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'orca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'oreg';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'orpi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'ovvi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'ozar';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'paal';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'paav';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pagr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pais';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'para';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'peco';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pefo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'peri';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pete';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'petr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pevi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pima';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pine';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pinn';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pipe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'piro';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pisc';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pisp';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'poch';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pohe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'popo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pore';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'prsf';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'prwi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'puhe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'puho';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'pull';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'rabr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'redw';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'rich';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'rigr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'rira';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'rocr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'rola';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'romo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'rori';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'rowi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'ruca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'saan';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sacn';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sacr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'safe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'safr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'saga';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sagu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sahi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sair';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sajh';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'saju';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sama';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'samo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sand';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sapa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sapu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sara';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sari';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'scbl';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sebe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'seki';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'semo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'shen';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'shil';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sitk';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'slbe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'spar';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'stea';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'stli';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'stri';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'sucr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'tapr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'this';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'thje';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'thko';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'thrb';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'thri';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'thro';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'thst';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'tica';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'timu';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'tont';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'trte';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'tuai';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'tuin';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'tuma';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'tupe';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'tusk';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'tuzi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'ulsg';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'upde';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'vafo';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'valr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'vama';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'vick';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'vicr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'viis';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'vive';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'voya';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'waba';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'waca';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'waco';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'wapa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'wefa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'whho';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'whis';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'whmi';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'whsa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'wica';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'wicl';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'wicr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'wiho';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'wori';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'wotr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'wrbr';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'wrst';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'wupa';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'yell';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'york';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'yose';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'yuch';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'yuho';
update parks set unit_url = 'http://www.nps.gov/' || "unit_code" || '/index.htm' where unit_code = 'zion';

Then filling in the remainders, based on the notes I lay out in the list of 10 from above:

update parks set unit_url = 'http://www.nps.gov/obed/index.htm' where unit_code = 'obri';
update parks set unit_url = 'http://www.nps.gov/sacn/index.htm' where unit_code = 'losa';
update parks set unit_url = 'http://www.nps.gov/wamo/index.htm' where unit_code = 'wamo';
update parks set unit_url = 'http://www.nps.gov/inde/index.htm' where unit_code = 'befr';
update parks set unit_url = 'http://www.nps.gov/nace/index.htm' where unit_code = 'naca';
update parks set unit_url = 'http://www.nps.gov/glac/index.htm' where unit_code = 'inpe';

So, this leaves only jofk "John F. Kennedy Center for the Performing Arts" without a unit_url.

[chadlawlis]

I took the same approach to unit_region.

The update query, based on the NPS.gov list:

update parks set unit_region = 'ser' where unit_code = 'abli';
update parks set unit_region = 'ner' where unit_code = 'acad';
update parks set unit_region = 'ner' where unit_code = 'adam';
update parks set unit_region = 'ner' where unit_code = 'afbg';
update parks set unit_region = 'mwr' where unit_code = 'agfo';
update parks set unit_region = 'akr' where unit_code = 'alag';
update parks set unit_region = 'imr' where unit_code = 'alfl';
update parks set unit_region = 'ner' where unit_code = 'alpo';
update parks set unit_region = 'imr' where unit_code = 'amis';
update parks set unit_region = 'ser' where unit_code = 'ande';
update parks set unit_region = 'ser' where unit_code = 'anjo';
update parks set unit_region = 'akr' where unit_code = 'ania';
update parks set unit_region = 'ncr' where unit_code = 'anti';
update parks set unit_region = 'mwr' where unit_code = 'apis';
update parks set unit_region = 'ner' where unit_code = 'appa';
update parks set unit_region = 'ner' where unit_code = 'apco';
update parks set unit_region = 'imr' where unit_code = 'arch';
update parks set unit_region = 'mwr' where unit_code = 'arpo';
update parks set unit_region = 'ncr' where unit_code = 'arho';
update parks set unit_region = 'ner' where unit_code = 'asis';
update parks set unit_region = 'imr' where unit_code = 'azru';
update parks set unit_region = 'mwr' where unit_code = 'badl';
update parks set unit_region = 'imr' where unit_code = 'band';
update parks set unit_region = 'imr' where unit_code = 'beol';
update parks set unit_region = 'akr' where unit_code = 'bela';
update parks set unit_region = 'imr' where unit_code = 'bibe';
update parks set unit_region = 'ser' where unit_code = 'bicy';
update parks set unit_region = 'pwr' where unit_code = 'biho';
update parks set unit_region = 'ser' where unit_code = 'biso';
update parks set unit_region = 'imr' where unit_code = 'bith';
update parks set unit_region = 'imr' where unit_code = 'bica';
update parks set unit_region = 'ser' where unit_code = 'bisc';
update parks set unit_region = 'imr' where unit_code = 'blca';
update parks set unit_region = 'ser' where unit_code = 'blri';
update parks set unit_region = 'ner' where unit_code = 'blue';
update parks set unit_region = 'ner' where unit_code = 'bowa';
update parks set unit_region = 'ner' where unit_code = 'bost';
update parks set unit_region = 'ner' where unit_code = 'boaf';
update parks set unit_region = 'ner' where unit_code = 'boha';
update parks set unit_region = 'ser' where unit_code = 'brcr';
update parks set unit_region = 'mwr' where unit_code = 'brvb';
update parks set unit_region = 'imr' where unit_code = 'brca';
update parks set unit_region = 'ser' where unit_code = 'buis';
update parks set unit_region = 'mwr' where unit_code = 'buff';
update parks set unit_region = 'pwr' where unit_code = 'cabr';
update parks set unit_region = 'ser' where unit_code = 'cana';
update parks set unit_region = 'ser' where unit_code = 'cari';
update parks set unit_region = 'imr' where unit_code = 'cach';
update parks set unit_region = 'imr' where unit_code = 'cany';
update parks set unit_region = 'ner' where unit_code = 'caco';
update parks set unit_region = 'ser' where unit_code = 'caha';
update parks set unit_region = 'akr' where unit_code = 'cakr';
update parks set unit_region = 'ser' where unit_code = 'calo';
update parks set unit_region = 'imr' where unit_code = 'care';
update parks set unit_region = 'imr' where unit_code = 'cavo';
update parks set unit_region = 'ser' where unit_code = 'carl';
update parks set unit_region = 'imr' where unit_code = 'cave';
update parks set unit_region = 'ncr' where unit_code = 'cawo';
update parks set unit_region = 'imr' where unit_code = 'cagr';
update parks set unit_region = 'ser' where unit_code = 'casa';
update parks set unit_region = 'ner' where unit_code = 'cacl';
update parks set unit_region = 'ncr' where unit_code = 'cato';
update parks set unit_region = 'imr' where unit_code = 'cebr';
update parks set unit_region = 'ner' where unit_code = 'cebe';
update parks set unit_region = 'pwr' where unit_code = 'cech';
update parks set unit_region = 'imr' where unit_code = 'chcu';
update parks set unit_region = 'imr' where unit_code = 'cham';
update parks set unit_region = 'pwr' where unit_code = 'chis';
update parks set unit_region = 'ser' where unit_code = 'chpi';
update parks set unit_region = 'mwr' where unit_code = 'chyo';
update parks set unit_region = 'ser' where unit_code = 'chat';
update parks set unit_region = 'ncr' where unit_code = 'choh';
update parks set unit_region = 'ser' where unit_code = 'chch';
update parks set unit_region = 'imr' where unit_code = 'chic';
update parks set unit_region = 'imr' where unit_code = 'chir';
update parks set unit_region = 'ser' where unit_code = 'chri';
update parks set unit_region = 'pwr' where unit_code = 'ciro';
update parks set unit_region = 'ncr' where unit_code = 'clba';
update parks set unit_region = 'ner' where unit_code = 'colo';
update parks set unit_region = 'imr' where unit_code = 'colm';
update parks set unit_region = 'ser' where unit_code = 'cosw';
update parks set unit_region = 'ncr' where unit_code = 'coga';
update parks set unit_region = 'imr' where unit_code = 'coro';
update parks set unit_region = 'ser' where unit_code = 'cowp';
update parks set unit_region = 'pwr' where unit_code = 'crla';
update parks set unit_region = 'pwr' where unit_code = 'crmo';
update parks set unit_region = 'ser' where unit_code = 'cuga';
update parks set unit_region = 'ser' where unit_code = 'cuis';
update parks set unit_region = 'imr' where unit_code = 'cure';
update parks set unit_region = 'mwr' where unit_code = 'cuva';
update parks set unit_region = 'mwr' where unit_code = 'daav';
update parks set unit_region = 'ser' where unit_code = 'deso';
update parks set unit_region = 'pwr' where unit_code = 'deva';
update parks set unit_region = 'ner' where unit_code = 'dela';
update parks set unit_region = 'ner' where unit_code = 'dewa';
update parks set unit_region = 'akr' where unit_code = 'dena';
update parks set unit_region = 'pwr' where unit_code = 'depo';
update parks set unit_region = 'imr' where unit_code = 'deto';
update parks set unit_region = 'imr' where unit_code = 'dino';
update parks set unit_region = 'ser' where unit_code = 'drto';
update parks set unit_region = 'pwr' where unit_code = 'ebla';
update parks set unit_region = 'ner' where unit_code = 'edal';
update parks set unit_region = 'mwr' where unit_code = 'efmo';
update parks set unit_region = 'ner' where unit_code = 'eise';
update parks set unit_region = 'imr' where unit_code = 'elma';
update parks set unit_region = 'imr' where unit_code = 'elmo';
update parks set unit_region = 'ner' where unit_code = 'elro';
update parks set unit_region = 'pwr' where unit_code = 'euon';
update parks set unit_region = 'ser' where unit_code = 'ever';
update parks set unit_region = 'ner' where unit_code = 'feha';
update parks set unit_region = 'ner' where unit_code = 'fiis';
update parks set unit_region = 'mwr' where unit_code = 'fila';
update parks set unit_region = 'ner' where unit_code = 'frst';
update parks set unit_region = 'ner' where unit_code = 'flni';
update parks set unit_region = 'imr' where unit_code = 'flfo';
update parks set unit_region = 'ncr' where unit_code = 'foth';
update parks set unit_region = 'imr' where unit_code = 'fobo';
update parks set unit_region = 'ser' where unit_code = 'foca';
update parks set unit_region = 'imr' where unit_code = 'foda';
update parks set unit_region = 'ser' where unit_code = 'fodo';
update parks set unit_region = 'ser' where unit_code = 'fofr';
update parks set unit_region = 'imr' where unit_code = 'fola';
update parks set unit_region = 'mwr' where unit_code = 'fols';
update parks set unit_region = 'ser' where unit_code = 'foma';
update parks set unit_region = 'ner' where unit_code = 'fomc';
update parks set unit_region = 'ner' where unit_code = 'fomr';
update parks set unit_region = 'ner' where unit_code = 'fone';
update parks set unit_region = 'pwr' where unit_code = 'fopo';
update parks set unit_region = 'ser' where unit_code = 'fopu';
update parks set unit_region = 'ser' where unit_code = 'fora';
update parks set unit_region = 'mwr' where unit_code = 'fosc';
update parks set unit_region = 'mwr' where unit_code = 'fosm';
update parks set unit_region = 'ner' where unit_code = 'fost';
update parks set unit_region = 'ser' where unit_code = 'fosu';
update parks set unit_region = 'imr' where unit_code = 'foun';
update parks set unit_region = 'mwr' where unit_code = 'fous';
update parks set unit_region = 'pwr' where unit_code = 'fova';
update parks set unit_region = 'ncr' where unit_code = 'fowa';
update parks set unit_region = 'imr' where unit_code = 'fobu';
update parks set unit_region = 'ncr' where unit_code = 'frde';
update parks set unit_region = 'ncr' where unit_code = 'frdo';
update parks set unit_region = 'ner' where unit_code = 'frla';
update parks set unit_region = 'ner' where unit_code = 'frsp';
update parks set unit_region = 'ner' where unit_code = 'frhi';
update parks set unit_region = 'akr' where unit_code = 'gaar';
update parks set unit_region = 'ner' where unit_code = 'gate';
update parks set unit_region = 'ner' where unit_code = 'gari';
update parks set unit_region = 'ner' where unit_code = 'gegr';
update parks set unit_region = 'mwr' where unit_code = 'gero';
update parks set unit_region = 'ncr' where unit_code = 'gwmp';
update parks set unit_region = 'ner' where unit_code = 'gewa';
update parks set unit_region = 'mwr' where unit_code = 'gwca';
update parks set unit_region = 'ner' where unit_code = 'gett';
update parks set unit_region = 'imr' where unit_code = 'gicl';
update parks set unit_region = 'imr' where unit_code = 'glac';
update parks set unit_region = 'akr' where unit_code = 'glba';
update parks set unit_region = 'imr' where unit_code = 'glca';
update parks set unit_region = 'pwr' where unit_code = 'goga';
update parks set unit_region = 'imr' where unit_code = 'gosp';
update parks set unit_region = 'ner' where unit_code = 'gois';
update parks set unit_region = 'imr' where unit_code = 'grca';
update parks set unit_region = 'mwr' where unit_code = 'grpo';
update parks set unit_region = 'imr' where unit_code = 'grte';
update parks set unit_region = 'imr' where unit_code = 'grko';
update parks set unit_region = 'pwr' where unit_code = 'grba';
update parks set unit_region = 'ner' where unit_code = 'greg';
update parks set unit_region = 'imr' where unit_code = 'grsa';
update parks set unit_region = 'ser' where unit_code = 'grsm';
update parks set unit_region = 'ncr' where unit_code = 'gree';
update parks set unit_region = 'imr' where unit_code = 'gumo';
update parks set unit_region = 'ser' where unit_code = 'guco';
update parks set unit_region = 'ser' where unit_code = 'guis';
update parks set unit_region = 'pwr' where unit_code = 'hafo';
update parks set unit_region = 'pwr' where unit_code = 'hale';
update parks set unit_region = 'ner' where unit_code = 'hagr';
update parks set unit_region = 'ner' where unit_code = 'hamp';
update parks set unit_region = 'ncr' where unit_code = 'hafe';
update parks set unit_region = 'ner' where unit_code = 'hatu';
update parks set unit_region = 'mwr' where unit_code = 'hstr';
update parks set unit_region = 'pwr' where unit_code = 'havo';
update parks set unit_region = 'mwr' where unit_code = 'heho';
update parks set unit_region = 'imr' where unit_code = 'pima';
update parks set unit_region = 'ner' where unit_code = 'hofr';
update parks set unit_region = 'mwr' where unit_code = 'home';
update parks set unit_region = 'mwr' where unit_code = 'hocu';
update parks set unit_region = 'ner' where unit_code = 'hofu';
update parks set unit_region = 'ser' where unit_code = 'hobe';
update parks set unit_region = 'mwr' where unit_code = 'hosp';
update parks set unit_region = 'imr' where unit_code = 'hove';
update parks set unit_region = 'imr' where unit_code = 'hutr';
update parks set unit_region = 'ner' where unit_code = 'inde';
update parks set unit_region = 'mwr' where unit_code = 'indu';
update parks set unit_region = 'mwr' where unit_code = 'isro';
update parks set unit_region = 'mwr' where unit_code = 'jaga';
update parks set unit_region = 'ser' where unit_code = 'jela';
update parks set unit_region = 'mwr' where unit_code = 'jeff';
update parks set unit_region = 'mwr' where unit_code = 'jeca';
update parks set unit_region = 'ser' where unit_code = 'jica';
update parks set unit_region = 'imr' where unit_code = 'jodr';
update parks set unit_region = 'pwr' where unit_code = 'joda';
update parks set unit_region = 'ner' where unit_code = 'jofi';
update parks set unit_region = 'pwr' where unit_code = 'jomu';
update parks set unit_region = 'ner' where unit_code = 'jofl';
update parks set unit_region = 'pwr' where unit_code = 'jotr';
update parks set unit_region = 'pwr' where unit_code = 'kala';
update parks set unit_region = 'pwr' where unit_code = 'kaho';
update parks set unit_region = 'akr' where unit_code = 'katm';
update parks set unit_region = 'akr' where unit_code = 'kefj';
update parks set unit_region = 'ser' where unit_code = 'kemo';
update parks set unit_region = 'mwr' where unit_code = 'kewe';
update parks set unit_region = 'ser' where unit_code = 'kimo';
update parks set unit_region = 'akr' where unit_code = 'klgo';
update parks set unit_region = 'mwr' where unit_code = 'knri';
update parks set unit_region = 'akr' where unit_code = 'kova';
update parks set unit_region = 'ncr' where unit_code = 'kowa';
update parks set unit_region = 'pwr' where unit_code = 'lach';
update parks set unit_region = 'akr' where unit_code = 'lacl';
update parks set unit_region = 'pwr' where unit_code = 'lake';
update parks set unit_region = 'imr' where unit_code = 'lamr';
update parks set unit_region = 'pwr' where unit_code = 'laro';
update parks set unit_region = 'pwr' where unit_code = 'lavo';
update parks set unit_region = 'pwr' where unit_code = 'labe';
update parks set unit_region = 'pwr' where unit_code = 'lewi';
update parks set unit_region = 'ncr' where unit_code = 'linc';
update parks set unit_region = 'mwr' where unit_code = 'libo';
update parks set unit_region = 'mwr' where unit_code = 'liho';
update parks set unit_region = 'imr' where unit_code = 'libi';
update parks set unit_region = 'ser' where unit_code = 'liri';
update parks set unit_region = 'mwr' where unit_code = 'chsc';
update parks set unit_region = 'ner' where unit_code = 'long';
update parks set unit_region = 'ner' where unit_code = 'lowe';
update parks set unit_region = 'imr' where unit_code = 'lyjo';
update parks set unit_region = 'ncr' where unit_code = 'lyba';
update parks set unit_region = 'ner' where unit_code = 'mawa';
update parks set unit_region = 'ser' where unit_code = 'maca';
update parks set unit_region = 'ncr' where unit_code = 'mana';
update parks set unit_region = 'pwr' where unit_code = 'manz';
update parks set unit_region = 'ner' where unit_code = 'mabi';
update parks set unit_region = 'ser' where unit_code = 'malu';
update parks set unit_region = 'ncr' where unit_code = 'mlkm';
update parks set unit_region = 'ner' where unit_code = 'mava';
update parks set unit_region = 'ncr' where unit_code = 'mamc';
update parks set unit_region = 'imr' where unit_code = 'meve';
update parks set unit_region = 'pwr' where unit_code = 'miin';
update parks set unit_region = 'ner' where unit_code = 'mima';
update parks set unit_region = 'mwr' where unit_code = 'mimi';
update parks set unit_region = 'mwr' where unit_code = 'miss';
update parks set unit_region = 'mwr' where unit_code = 'mnrr';
update parks set unit_region = 'pwr' where unit_code = 'moja';
update parks set unit_region = 'ncr' where unit_code = 'mono';
update parks set unit_region = 'imr' where unit_code = 'moca';
update parks set unit_region = 'ser' where unit_code = 'mocr';
update parks set unit_region = 'ner' where unit_code = 'morr';
update parks set unit_region = 'pwr' where unit_code = 'mora';
update parks set unit_region = 'mwr' where unit_code = 'moru';
update parks set unit_region = 'pwr' where unit_code = 'muwo';
update parks set unit_region = 'ser' where unit_code = 'natc';
update parks set unit_region = 'ser' where unit_code = 'natr';
update parks set unit_region = 'ncr' where unit_code = 'nama';
update parks set unit_region = 'ncr' where unit_code = 'nacc';
update parks set unit_region = 'pwr' where unit_code = 'npsa';
update parks set unit_region = 'ncr' where unit_code = 'nwwm';
update parks set unit_region = 'imr' where unit_code = 'nabr';
update parks set unit_region = 'imr' where unit_code = 'nava';
update parks set unit_region = 'ner' where unit_code = 'nebe';
update parks set unit_region = 'ser' where unit_code = 'jazz';
update parks set unit_region = 'ner' where unit_code = 'neri';
update parks set unit_region = 'pwr' where unit_code = 'nepe';
update parks set unit_region = 'mwr' where unit_code = 'nico';
update parks set unit_region = 'ser' where unit_code = 'nisi';
update parks set unit_region = 'mwr' where unit_code = 'niob';
update parks set unit_region = 'akr' where unit_code = 'noat';
update parks set unit_region = 'pwr' where unit_code = 'noca';
update parks set unit_region = 'ser' where unit_code = 'obed';
update parks set unit_region = 'ser' where unit_code = 'ocmu';
update parks set unit_region = 'pwr' where unit_code = 'olym';
update parks set unit_region = 'pwr' where unit_code = 'orca';
update parks set unit_region = 'imr' where unit_code = 'orpi';
update parks set unit_region = 'mwr' where unit_code = 'ozar';
update parks set unit_region = 'imr' where unit_code = 'pais';
update parks set unit_region = 'imr' where unit_code = 'paal';
update parks set unit_region = 'ner' where unit_code = 'pagr';
update parks set unit_region = 'mwr' where unit_code = 'peri';
update parks set unit_region = 'imr' where unit_code = 'peco';
update parks set unit_region = 'ncr' where unit_code = 'paav';
update parks set unit_region = 'mwr' where unit_code = 'pevi';
update parks set unit_region = 'ner' where unit_code = 'pete';
update parks set unit_region = 'imr' where unit_code = 'pefo';
update parks set unit_region = 'imr' where unit_code = 'petr';
update parks set unit_region = 'mwr' where unit_code = 'piro';
update parks set unit_region = 'pwr' where unit_code = 'pinn';
update parks set unit_region = 'imr' where unit_code = 'pisp';
update parks set unit_region = 'mwr' where unit_code = 'pipe';
update parks set unit_region = 'ncr' where unit_code = 'pisc';
update parks set unit_region = 'pwr' where unit_code = 'pore';
update parks set unit_region = 'pwr' where unit_code = 'poch';
update parks set unit_region = 'ncr' where unit_code = 'pohe';
update parks set unit_region = 'ser' where unit_code = 'popo';
update parks set unit_region = 'mwr' where unit_code = 'wicl';
update parks set unit_region = 'ncr' where unit_code = 'whho';
update parks set unit_region = 'ncr' where unit_code = 'prwi';
update parks set unit_region = 'pwr' where unit_code = 'puho';
update parks set unit_region = 'mwr' where unit_code = 'pull';
update parks set unit_region = 'pwr' where unit_code = 'puhe';
update parks set unit_region = 'imr' where unit_code = 'rabr';
update parks set unit_region = 'pwr' where unit_code = 'redw';
update parks set unit_region = 'ner' where unit_code = 'rich';
update parks set unit_region = 'imr' where unit_code = 'rigr';
update parks set unit_region = 'mwr' where unit_code = 'rira';
update parks set unit_region = 'ncr' where unit_code = 'rocr';
update parks set unit_region = 'imr' where unit_code = 'romo';
update parks set unit_region = 'ner' where unit_code = 'rowi';
update parks set unit_region = 'pwr' where unit_code = 'rori';
update parks set unit_region = 'pwr' where unit_code = 'rola';
update parks set unit_region = 'ser' where unit_code = 'ruca';
update parks set unit_region = 'ner' where unit_code = 'sahi';
update parks set unit_region = 'imr' where unit_code = 'sagu';
update parks set unit_region = 'mwr' where unit_code = 'sacn';
update parks set unit_region = 'ner' where unit_code = 'sacr';
update parks set unit_region = 'ner' where unit_code = 'sapa';
update parks set unit_region = 'ner' where unit_code = 'saga';
update parks set unit_region = 'ner' where unit_code = 'sama';
update parks set unit_region = 'imr' where unit_code = 'sapu';
update parks set unit_region = 'ser' where unit_code = 'sari';
update parks set unit_region = 'imr' where unit_code = 'saan';
update parks set unit_region = 'pwr' where unit_code = 'safr';
update parks set unit_region = 'ser' where unit_code = 'saju';
update parks set unit_region = 'pwr' where unit_code = 'sajh';
update parks set unit_region = 'imr' where unit_code = 'sand';
update parks set unit_region = 'pwr' where unit_code = 'samo';
update parks set unit_region = 'ner' where unit_code = 'sara';
update parks set unit_region = 'ner' where unit_code = 'sair';
update parks set unit_region = 'mwr' where unit_code = 'scbl';
update parks set unit_region = 'pwr' where unit_code = 'seki';
update parks set unit_region = 'ner' where unit_code = 'shen';
update parks set unit_region = 'ser' where unit_code = 'shil';
update parks set unit_region = 'akr' where unit_code = 'sitk';
update parks set unit_region = 'mwr' where unit_code = 'slbe';
update parks set unit_region = 'ner' where unit_code = 'spar';
update parks set unit_region = 'ner' where unit_code = 'stli';
update parks set unit_region = 'ner' where unit_code = 'stea';
update parks set unit_region = 'ser' where unit_code = 'stri';
update parks set unit_region = 'imr' where unit_code = 'sucr';
update parks set unit_region = 'mwr' where unit_code = 'tapr';
update parks set unit_region = 'ner' where unit_code = 'thko';
update parks set unit_region = 'mwr' where unit_code = 'thro';
update parks set unit_region = 'ner' where unit_code = 'thrb';
update parks set unit_region = 'ner' where unit_code = 'thri';
update parks set unit_region = 'ncr' where unit_code = 'this';
update parks set unit_region = 'ner' where unit_code = 'edis';
update parks set unit_region = 'ncr' where unit_code = 'thje';
update parks set unit_region = 'ner' where unit_code = 'thst';
update parks set unit_region = 'imr' where unit_code = 'tica';
update parks set unit_region = 'ser' where unit_code = 'timu';
update parks set unit_region = 'imr' where unit_code = 'tont';
update parks set unit_region = 'imr' where unit_code = 'tuma';
update parks set unit_region = 'ser' where unit_code = 'tupe';
update parks set unit_region = 'ser' where unit_code = 'tuai';
update parks set unit_region = 'ser' where unit_code = 'tuin';
update parks set unit_region = 'imr' where unit_code = 'tuzi';
update parks set unit_region = 'mwr' where unit_code = 'ulsg';
update parks set unit_region = 'ner' where unit_code = 'upde';
update parks set unit_region = 'ner' where unit_code = 'vafo';
update parks set unit_region = 'ner' where unit_code = 'vama';
update parks set unit_region = 'ser' where unit_code = 'vick';
update parks set unit_region = 'ncr' where unit_code = 'vive';
update parks set unit_region = 'ser' where unit_code = 'viis';
update parks set unit_region = 'ser' where unit_code = 'vicr';
update parks set unit_region = 'mwr' where unit_code = 'voya';
update parks set unit_region = 'imr' where unit_code = 'waca';
update parks set unit_region = 'pwr' where unit_code = 'wapa';
update parks set unit_region = 'ncr' where unit_code = 'wash';
update parks set unit_region = 'imr' where unit_code = 'waba';
update parks set unit_region = 'ner' where unit_code = 'wefa';
update parks set unit_region = 'pwr' where unit_code = 'whis';
update parks set unit_region = 'imr' where unit_code = 'whsa';
update parks set unit_region = 'pwr' where unit_code = 'whmi';
update parks set unit_region = 'mwr' where unit_code = 'wiho';
update parks set unit_region = 'mwr' where unit_code = 'wicr';
update parks set unit_region = 'mwr' where unit_code = 'wica';
update parks set unit_region = 'ncr' where unit_code = 'wotr';
update parks set unit_region = 'ner' where unit_code = 'wori';
update parks set unit_region = 'pwr' where unit_code = 'valr';
update parks set unit_region = 'akr' where unit_code = 'wrst';
update parks set unit_region = 'ser' where unit_code = 'wrbr';
update parks set unit_region = 'imr' where unit_code = 'wupa';
update parks set unit_region = 'imr' where unit_code = 'yell';
update parks set unit_region = 'pwr' where unit_code = 'yose';
update parks set unit_region = 'imr' where unit_code = 'yuho';
update parks set unit_region = 'akr' where unit_code = 'yuch';
update parks set unit_region = 'imr' where unit_code = 'zion';
update parks set unit_region = 'ncr' where unit_code = 'afam';
update parks set unit_region = 'pwr' where unit_code = 'alka';
update parks set unit_region = 'pwr' where unit_code = 'alca';
update parks set unit_region = 'akr' where unit_code = 'aleu';
update parks set unit_region = 'pwr' where unit_code = 'amme';
update parks set unit_region = 'ncr' where unit_code = 'anac';
update parks set unit_region = 'ncr' where unit_code = 'ancm';
update parks set unit_region = 'ncr' where unit_code = 'bawa';
update parks set unit_region = 'ncr' where unit_code = 'batt';
update parks set unit_region = 'ner' where unit_code = 'blac';
update parks set unit_region = 'imr' where unit_code = 'cali';
update parks set unit_region = 'ser' where unit_code = 'crha';
update parks set unit_region = 'ner' where unit_code = 'came';
update parks set unit_region = 'ncr' where unit_code = 'cahe';
update parks set unit_region = 'ner' where unit_code = 'cajo';
update parks set unit_region = 'ner' where unit_code = 'cbpo';
update parks set unit_region = 'mwr' where unit_code = 'chro';
update parks set unit_region = 'ncr' where unit_code = 'clmo';
update parks set unit_region = 'mwr' where unit_code = 'dabe';
update parks set unit_region = 'ner' where unit_code = 'dele';
update parks set unit_region = 'ner' where unit_code = 'demo';
update parks set unit_region = 'imr' where unit_code = 'elte';
update parks set unit_region = 'imr' where unit_code = 'elca';
update parks set unit_region = 'ner' where unit_code = 'elis';
update parks set unit_region = 'ner' where unit_code = 'erie';
update parks set unit_region = 'ner' where unit_code = 'esse';
update parks set unit_region = 'mwr' where unit_code = 'fama';
update parks set unit_region = 'ser' where unit_code = 'fdnc';
update parks set unit_region = 'ncr' where unit_code = 'fodu';
update parks set unit_region = 'ncr' where unit_code = 'fofo';
update parks set unit_region = 'ner' where unit_code = 'fred';
update parks set unit_region = 'ncr' where unit_code = 'gemm';
update parks set unit_region = 'ner' where unit_code = 'getc';
update parks set unit_region = 'ncr' where unit_code = 'glec';
update parks set unit_region = 'ner' where unit_code = 'glde';
update parks set unit_region = 'ncr' where unit_code = 'grfa';
update parks set unit_region = 'ner' where unit_code = 'grsp';
update parks set unit_region = 'ncr' where unit_code = 'haha';
update parks set unit_region = 'mwr' where unit_code = 'iatr';
update parks set unit_region = 'mwr' where unit_code = 'ilmi';
update parks set unit_region = 'akr' where unit_code = 'inup';
update parks set unit_region = 'ner' where unit_code = 'jame';
update parks set unit_region = 'ncr' where unit_code = 'joer';
update parks set unit_region = 'pwr' where unit_code = 'juba';
update parks set unit_region = 'ncr' where unit_code = 'kepa';
update parks set unit_region = 'pwr' where unit_code = 'klse';
update parks set unit_region = 'mwr' where unit_code = 'lecl';
update parks set unit_region = 'ner' where unit_code = 'loea';
update parks set unit_region = 'ner' where unit_code = 'maac';
update parks set unit_region = 'ner' where unit_code = 'masi';
update parks set unit_region = 'pwr' where unit_code = 'mcho';
update parks set unit_region = 'imr' where unit_code = 'mopi';
update parks set unit_region = 'ser' where unit_code = 'natt';
update parks set unit_region = 'ncr' where unit_code = 'nace';
update parks set unit_region = 'ner' where unit_code = 'npnh';
update parks set unit_region = 'ner' where unit_code = 'neen';
update parks set unit_region = 'ner' where unit_code = 'neje';
update parks set unit_region = 'ner' where unit_code = 'pine';
update parks set unit_region = 'ner' where unit_code = 'nifa';
update parks set unit_region = 'mwr' where unit_code = 'noco';
update parks set unit_region = 'imr' where unit_code = 'okci';
update parks set unit_region = 'ncr' where unit_code = 'opot';
update parks set unit_region = 'pwr' where unit_code = 'olsp';
update parks set unit_region = 'imr' where unit_code = 'oreg';
update parks set unit_region = 'ser' where unit_code = 'ovvi';
update parks set unit_region = 'ncr' where unit_code = 'oxhi';
update parks set unit_region = 'pwr' where unit_code = 'para';
update parks set unit_region = 'ncr' where unit_code = 'pimi';
update parks set unit_region = 'imr' where unit_code = 'poex';
update parks set unit_region = 'ner' where unit_code = 'pogr';
update parks set unit_region = 'pwr' where unit_code = 'prsf';
update parks set unit_region = 'ner' where unit_code = 'qush';
update parks set unit_region = 'ner' where unit_code = 'roca';
update parks set unit_region = 'imr' where unit_code = 'safe';
update parks set unit_region = 'ser' where unit_code = 'semo';
update parks set unit_region = 'ncr' where unit_code = 'sebe';
update parks set unit_region = 'ser' where unit_code = 'shnc';
update parks set unit_region = 'ner' where unit_code = 'stsp';
update parks set unit_region = 'ser' where unit_code = 'srnc';
update parks set unit_region = 'ncr' where unit_code = 'suit';
update parks set unit_region = 'ncr' where unit_code = 'olst';
update parks set unit_region = 'ner' where unit_code = 'tosy';
update parks set unit_region = 'imr' where unit_code = 'trte';
update parks set unit_region = 'pwr' where unit_code = 'usar';
update parks set unit_region = 'ser' where unit_code = 'vinc';
update parks set unit_region = 'akr' where unit_code = 'nwak';
update parks set unit_region = 'ner' where unit_code = 'york';
update parks set unit_region = 'ner' where unit_code = 'yonb';

And the remainder:

update parks set unit_region = 'imr' where unit_code = 'waco';
update parks set unit_region = 'pwr' where unit_code = 'hono';
update parks set unit_region = 'pwr' where unit_code = 'tusk';
update parks set unit_region = 'ncr' where unit_code = 'jofk';
update parks set unit_region = 'ser' where unit_code = 'obri';
update parks set unit_region = (select unit_region from parks where unit_code = 'sacn') where unit_code = 'losa';
update parks set unit_region = 'ser' where unit_code = 'cong';
update parks set unit_region = (select unit_region from parks where unit_code = 'seki') where unit_code = 'kica';
update parks set unit_region = (select unit_region from parks where unit_code = 'seki') where unit_code = 'sequ';
update parks set unit_region = 'ncr' where unit_code = 'wamo';
update parks set unit_region = (select unit_region from parks where unit_code = 'inde') where unit_code = 'befr';
update parks set unit_region = 'ncr' where unit_code = 'naca';

This leaves only inpe "International Peace Garden Memorial" without a unit_region.

[chadlawlis]

And the same approach to unit_state.

The update query, based on NPS.gov:

update parks set unit_state = 'ky' where unit_code = 'abli';
update parks set unit_state = 'me' where unit_code = 'acad';
update parks set unit_state = 'ma' where unit_code = 'adam';
update parks set unit_state = 'ny' where unit_code = 'afbg';
update parks set unit_state = 'ne' where unit_code = 'agfo';
update parks set unit_state = 'ak' where unit_code = 'alag';
update parks set unit_state = 'tx' where unit_code = 'alfl';
update parks set unit_state = 'pa' where unit_code = 'alpo';
update parks set unit_state = 'tx' where unit_code = 'amis';
update parks set unit_state = 'ga' where unit_code = 'ande';
update parks set unit_state = 'tn' where unit_code = 'anjo';
update parks set unit_state = 'ak' where unit_code = 'ania';
update parks set unit_state = 'md' where unit_code = 'anti';
update parks set unit_state = 'wi' where unit_code = 'apis';
update parks set unit_state = 'ct,ga,ma,md,me,nc,nh,nj,ny,pa,tn,va,vt,wv' where unit_code = 'appa';
update parks set unit_state = 'va' where unit_code = 'apco';
update parks set unit_state = 'ut' where unit_code = 'arch';
update parks set unit_state = 'ar' where unit_code = 'arpo';
update parks set unit_state = 'va' where unit_code = 'arho';
update parks set unit_state = 'md,va' where unit_code = 'asis';
update parks set unit_state = 'nm' where unit_code = 'azru';
update parks set unit_state = 'sd' where unit_code = 'badl';
update parks set unit_state = 'nm' where unit_code = 'band';
update parks set unit_state = 'co' where unit_code = 'beol';
update parks set unit_state = 'ak' where unit_code = 'bela';
update parks set unit_state = 'tx' where unit_code = 'bibe';
update parks set unit_state = 'fl' where unit_code = 'bicy';
update parks set unit_state = 'mt' where unit_code = 'biho';
update parks set unit_state = 'ky,tn' where unit_code = 'biso';
update parks set unit_state = 'tx' where unit_code = 'bith';
update parks set unit_state = 'mt,wy' where unit_code = 'bica';
update parks set unit_state = 'fl' where unit_code = 'bisc';
update parks set unit_state = 'co' where unit_code = 'blca';
update parks set unit_state = 'ma,ri' where unit_code = 'blrv';
update parks set unit_state = 'nc,va' where unit_code = 'blri';
update parks set unit_state = 'wv' where unit_code = 'blue';
update parks set unit_state = 'va' where unit_code = 'bowa';
update parks set unit_state = 'ma' where unit_code = 'bost';
update parks set unit_state = 'ma' where unit_code = 'boaf';
update parks set unit_state = 'ma' where unit_code = 'boha';
update parks set unit_state = 'ms' where unit_code = 'brcr';
update parks set unit_state = 'ks' where unit_code = 'brvb';
update parks set unit_state = 'ut' where unit_code = 'brca';
update parks set unit_state = 'vi' where unit_code = 'buis';
update parks set unit_state = 'ar' where unit_code = 'buff';
update parks set unit_state = 'ca' where unit_code = 'cabr';
update parks set unit_state = 'fl' where unit_code = 'cana';
update parks set unit_state = 'la' where unit_code = 'cari';
update parks set unit_state = 'az' where unit_code = 'cach';
update parks set unit_state = 'ut' where unit_code = 'cany';
update parks set unit_state = 'ma' where unit_code = 'caco';
update parks set unit_state = 'nc' where unit_code = 'caha';
update parks set unit_state = 'ak' where unit_code = 'cakr';
update parks set unit_state = 'nc' where unit_code = 'calo';
update parks set unit_state = 'ut' where unit_code = 'care';
update parks set unit_state = 'nm' where unit_code = 'cavo';
update parks set unit_state = 'nc' where unit_code = 'carl';
update parks set unit_state = 'nm' where unit_code = 'cave';
update parks set unit_state = 'dc' where unit_code = 'cawo';
update parks set unit_state = 'az' where unit_code = 'cagr';
update parks set unit_state = 'fl' where unit_code = 'casa';
update parks set unit_state = 'ny' where unit_code = 'cacl';
update parks set unit_state = 'md' where unit_code = 'cato';
update parks set unit_state = 'ut' where unit_code = 'cebr';
update parks set unit_state = 'va' where unit_code = 'cebe';
update parks set unit_state = 'ca' where unit_code = 'cech';
update parks set unit_state = 'nm' where unit_code = 'chcu';
update parks set unit_state = 'tx' where unit_code = 'cham';
update parks set unit_state = 'ca' where unit_code = 'chis';
update parks set unit_state = 'sc' where unit_code = 'chpi';
update parks set unit_state = 'oh' where unit_code = 'chyo';
update parks set unit_state = 'ga' where unit_code = 'chat';
update parks set unit_state = 'dc,md,wv' where unit_code = 'choh';
update parks set unit_state = 'ga' where unit_code = 'chch';
update parks set unit_state = 'ok' where unit_code = 'chic';
update parks set unit_state = 'az' where unit_code = 'chir';
update parks set unit_state = 'vi' where unit_code = 'chri';
update parks set unit_state = 'id' where unit_code = 'ciro';
update parks set unit_state = 'md' where unit_code = 'clba';
update parks set unit_state = 'va' where unit_code = 'colo';
update parks set unit_state = 'co' where unit_code = 'colm';
update parks set unit_state = 'dc' where unit_code = 'coga';
update parks set unit_state = 'az' where unit_code = 'coro';
update parks set unit_state = 'sc' where unit_code = 'cowp';
update parks set unit_state = 'or' where unit_code = 'crla';
update parks set unit_state = 'id' where unit_code = 'crmo';
update parks set unit_state = 'ky,tn,va' where unit_code = 'cuga';
update parks set unit_state = 'ga' where unit_code = 'cuis';
update parks set unit_state = 'co' where unit_code = 'cure';
update parks set unit_state = 'oh' where unit_code = 'cuva';
update parks set unit_state = 'oh' where unit_code = 'daav';
update parks set unit_state = 'fl' where unit_code = 'deso';
update parks set unit_state = 'ca' where unit_code = 'deva';
update parks set unit_state = 'pa' where unit_code = 'dela';
update parks set unit_state = 'pa' where unit_code = 'dewa';
update parks set unit_state = 'ak' where unit_code = 'dena';
update parks set unit_state = 'ca' where unit_code = 'depo';
update parks set unit_state = 'wy' where unit_code = 'deto';
update parks set unit_state = 'co,ut' where unit_code = 'dino';
update parks set unit_state = 'fl' where unit_code = 'drto';
update parks set unit_state = 'wa' where unit_code = 'ebla';
update parks set unit_state = 'pa' where unit_code = 'edal';
update parks set unit_state = 'ia' where unit_code = 'efmo';
update parks set unit_state = 'pa' where unit_code = 'eise';
update parks set unit_state = 'nm' where unit_code = 'elma';
update parks set unit_state = 'nm' where unit_code = 'elmo';
update parks set unit_state = 'ny' where unit_code = 'elro';
update parks set unit_state = 'ca' where unit_code = 'euon';
update parks set unit_state = 'fl' where unit_code = 'ever';
update parks set unit_state = 'ny' where unit_code = 'feha';
update parks set unit_state = 'ny' where unit_code = 'fiis';
update parks set unit_state = 'oh' where unit_code = 'fila';
update parks set unit_state = 'de,pa' where unit_code = 'frst';
update parks set unit_state = 'pa' where unit_code = 'flni';
update parks set unit_state = 'co' where unit_code = 'flfo';
update parks set unit_state = 'dc' where unit_code = 'foth';
update parks set unit_state = 'az' where unit_code = 'fobo';
update parks set unit_state = 'fl' where unit_code = 'foca';
update parks set unit_state = 'tx' where unit_code = 'foda';
update parks set unit_state = 'tn' where unit_code = 'fodo';
update parks set unit_state = 'ga' where unit_code = 'fofr';
update parks set unit_state = 'wy' where unit_code = 'fola';
update parks set unit_state = 'ks' where unit_code = 'fols';
update parks set unit_state = 'fl' where unit_code = 'foma';
update parks set unit_state = 'md' where unit_code = 'fomc';
update parks set unit_state = 'va' where unit_code = 'fomr';
update parks set unit_state = 'pa' where unit_code = 'fone';
update parks set unit_state = 'ca' where unit_code = 'fopo';
update parks set unit_state = 'ga' where unit_code = 'fopu';
update parks set unit_state = 'nc' where unit_code = 'fora';
update parks set unit_state = 'ks' where unit_code = 'fosc';
update parks set unit_state = 'ar,ok' where unit_code = 'fosm';
update parks set unit_state = 'ny' where unit_code = 'fost';
update parks set unit_state = 'sc' where unit_code = 'fosu';
update parks set unit_state = 'nm' where unit_code = 'foun';
update parks set unit_state = 'nd' where unit_code = 'fous';
update parks set unit_state = 'wa' where unit_code = 'fova';
update parks set unit_state = 'md' where unit_code = 'fowa';
update parks set unit_state = 'wy' where unit_code = 'fobu';
update parks set unit_state = 'dc' where unit_code = 'frde';
update parks set unit_state = 'dc' where unit_code = 'frdo';
update parks set unit_state = 'ma' where unit_code = 'frla';
update parks set unit_state = 'va' where unit_code = 'frsp';
update parks set unit_state = 'pa' where unit_code = 'frhi';
update parks set unit_state = 'ak' where unit_code = 'gaar';
update parks set unit_state = 'ny,nj' where unit_code = 'gate';
update parks set unit_state = 'wv' where unit_code = 'gari';
update parks set unit_state = 'ny' where unit_code = 'gegr';
update parks set unit_state = 'in' where unit_code = 'gero';
update parks set unit_state = 'dc' where unit_code = 'gwmp';
update parks set unit_state = 'va' where unit_code = 'gewa';
update parks set unit_state = 'mo' where unit_code = 'gwca';
update parks set unit_state = 'pa' where unit_code = 'gett';
update parks set unit_state = 'nm' where unit_code = 'gicl';
update parks set unit_state = 'mt' where unit_code = 'glac';
update parks set unit_state = 'ak' where unit_code = 'glba';
update parks set unit_state = 'az,ut' where unit_code = 'glca';
update parks set unit_state = 'ca' where unit_code = 'goga';
update parks set unit_state = 'ut' where unit_code = 'gosp';
update parks set unit_state = 'ny' where unit_code = 'gois';
update parks set unit_state = 'az' where unit_code = 'grca';
update parks set unit_state = 'mn' where unit_code = 'grpo';
update parks set unit_state = 'wy' where unit_code = 'grte';
update parks set unit_state = 'mt' where unit_code = 'grko';
update parks set unit_state = 'nv' where unit_code = 'grba';
update parks set unit_state = 'nj' where unit_code = 'greg';
update parks set unit_state = 'co' where unit_code = 'grsa';
update parks set unit_state = 'tn,nc' where unit_code = 'grsm';
update parks set unit_state = 'md' where unit_code = 'gree';
update parks set unit_state = 'tx' where unit_code = 'gumo';
update parks set unit_state = 'nc' where unit_code = 'guco';
update parks set unit_state = 'fl,ms' where unit_code = 'guis';
update parks set unit_state = 'id' where unit_code = 'hafo';
update parks set unit_state = 'hi' where unit_code = 'hale';
update parks set unit_state = 'ny' where unit_code = 'hagr';
update parks set unit_state = 'md' where unit_code = 'hamp';
update parks set unit_state = 'wv' where unit_code = 'hafe';
update parks set unit_state = 'md' where unit_code = 'hatu';
update parks set unit_state = 'mo' where unit_code = 'hstr';
update parks set unit_state = 'hi' where unit_code = 'havo';
update parks set unit_state = 'ia' where unit_code = 'heho';
update parks set unit_state = 'az' where unit_code = 'pima';
update parks set unit_state = 'ny' where unit_code = 'hofr';
update parks set unit_state = 'ne' where unit_code = 'home';
update parks set unit_state = 'hi' where unit_code = 'hono';
update parks set unit_state = 'oh' where unit_code = 'hocu';
update parks set unit_state = 'pa' where unit_code = 'hofu';
update parks set unit_state = 'al' where unit_code = 'hobe';
update parks set unit_state = 'ar' where unit_code = 'hosp';
update parks set unit_state = 'ut' where unit_code = 'hove';
update parks set unit_state = 'az' where unit_code = 'hutr';
update parks set unit_state = 'pa' where unit_code = 'inde';
update parks set unit_state = 'in' where unit_code = 'indu';
update parks set unit_state = 'mi' where unit_code = 'isro';
update parks set unit_state = 'oh' where unit_code = 'jaga';
update parks set unit_state = 'la' where unit_code = 'jela';
update parks set unit_state = 'mo' where unit_code = 'jeff';
update parks set unit_state = 'sd' where unit_code = 'jeca';
update parks set unit_state = 'ga' where unit_code = 'jica';
update parks set unit_state = 'wy' where unit_code = 'jodr';
update parks set unit_state = 'or' where unit_code = 'joda';
update parks set unit_state = 'ma' where unit_code = 'jofi';
update parks set unit_state = 'ca' where unit_code = 'jomu';
update parks set unit_state = 'pa' where unit_code = 'jofl';
update parks set unit_state = 'ca' where unit_code = 'jotr';
update parks set unit_state = 'hi' where unit_code = 'kala';
update parks set unit_state = 'hi' where unit_code = 'kaho';
update parks set unit_state = 'ak' where unit_code = 'katm';
update parks set unit_state = 'ak' where unit_code = 'kefj';
update parks set unit_state = 'ga' where unit_code = 'kemo';
update parks set unit_state = 'mi' where unit_code = 'kewe';
update parks set unit_state = 'sc' where unit_code = 'kimo';
update parks set unit_state = 'ak' where unit_code = 'klgo';
update parks set unit_state = 'nd' where unit_code = 'knri';
update parks set unit_state = 'ak' where unit_code = 'kova';
update parks set unit_state = 'dc' where unit_code = 'kowa';
update parks set unit_state = 'wa' where unit_code = 'lach';
update parks set unit_state = 'ak' where unit_code = 'lacl';
update parks set unit_state = 'az,nv' where unit_code = 'lake';
update parks set unit_state = 'tx' where unit_code = 'lamr';
update parks set unit_state = 'wa' where unit_code = 'laro';
update parks set unit_state = 'ca' where unit_code = 'lavo';
update parks set unit_state = 'ca' where unit_code = 'labe';
update parks set unit_state = 'or' where unit_code = 'lewi';
update parks set unit_state = 'dc' where unit_code = 'linc';
update parks set unit_state = 'in' where unit_code = 'libo';
update parks set unit_state = 'il' where unit_code = 'liho';
update parks set unit_state = 'mt' where unit_code = 'libi';
update parks set unit_state = 'al' where unit_code = 'liri';
update parks set unit_state = 'ar' where unit_code = 'chsc';
update parks set unit_state = 'ma' where unit_code = 'long';
update parks set unit_state = 'ma' where unit_code = 'lowe';
update parks set unit_state = 'tx' where unit_code = 'lyjo';
update parks set unit_state = 'va' where unit_code = 'lyba';
update parks set unit_state = 'va' where unit_code = 'mawa';
update parks set unit_state = 'ky' where unit_code = 'maca';
update parks set unit_state = 'va' where unit_code = 'mana';
update parks set unit_state = 'ca' where unit_code = 'manz';
update parks set unit_state = 'vt' where unit_code = 'mabi';
update parks set unit_state = 'ga' where unit_code = 'malu';
update parks set unit_state = 'dc' where unit_code = 'mlkm';
update parks set unit_state = 'ny' where unit_code = 'mava';
update parks set unit_state = 'dc' where unit_code = 'mamc';
update parks set unit_state = 'co' where unit_code = 'meve';
update parks set unit_state = 'id' where unit_code = 'miin';
update parks set unit_state = 'ma' where unit_code = 'mima';
update parks set unit_state = 'sd' where unit_code = 'mimi';
update parks set unit_state = 'mn' where unit_code = 'miss';
update parks set unit_state = 'sd' where unit_code = 'mnrr';
update parks set unit_state = 'ca' where unit_code = 'moja';
update parks set unit_state = 'md' where unit_code = 'mono';
update parks set unit_state = 'az' where unit_code = 'moca';
update parks set unit_state = 'nc' where unit_code = 'mocr';
update parks set unit_state = 'nj' where unit_code = 'morr';
update parks set unit_state = 'wa' where unit_code = 'mora';
update parks set unit_state = 'sd' where unit_code = 'moru';
update parks set unit_state = 'ca' where unit_code = 'muwo';
update parks set unit_state = 'ms' where unit_code = 'natc';
update parks set unit_state = 'al,ms,tn' where unit_code = 'natr';
update parks set unit_state = 'dc' where unit_code = 'nama';
update parks set unit_state = 'dc' where unit_code = 'nacc';
update parks set unit_state = 'as' where unit_code = 'npsa';
update parks set unit_state = 'dc' where unit_code = 'nwwm';
update parks set unit_state = 'ut' where unit_code = 'nabr';
update parks set unit_state = 'az' where unit_code = 'nava';
update parks set unit_state = 'ma' where unit_code = 'nebe';
update parks set unit_state = 'la' where unit_code = 'jazz';
update parks set unit_state = 'wv' where unit_code = 'neri';
update parks set unit_state = 'id,mt,or,wa' where unit_code = 'nepe';
update parks set unit_state = 'ks' where unit_code = 'nico';
update parks set unit_state = 'sc' where unit_code = 'nisi';
update parks set unit_state = 'ne' where unit_code = 'niob';
update parks set unit_state = 'ak' where unit_code = 'noat';
update parks set unit_state = 'wa' where unit_code = 'noca';
update parks set unit_state = 'ga' where unit_code = 'ocmu';
update parks set unit_state = 'wa' where unit_code = 'olym';
update parks set unit_state = 'or' where unit_code = 'orca';
update parks set unit_state = 'az' where unit_code = 'orpi';
update parks set unit_state = 'mo' where unit_code = 'ozar';
update parks set unit_state = 'tx' where unit_code = 'pais';
update parks set unit_state = 'tx' where unit_code = 'paal';
update parks set unit_state = 'nj' where unit_code = 'pagr';
update parks set unit_state = 'ar' where unit_code = 'peri';
update parks set unit_state = 'nm' where unit_code = 'peco';
update parks set unit_state = 'dc' where unit_code = 'paav';
update parks set unit_state = 'oh' where unit_code = 'pevi';
update parks set unit_state = 'va' where unit_code = 'pete';
update parks set unit_state = 'az' where unit_code = 'pefo';
update parks set unit_state = 'nm' where unit_code = 'petr';
update parks set unit_state = 'mi' where unit_code = 'piro';
update parks set unit_state = 'ca' where unit_code = 'pinn';
update parks set unit_state = 'az' where unit_code = 'pisp';
update parks set unit_state = 'mn' where unit_code = 'pipe';
update parks set unit_state = 'md' where unit_code = 'pisc';
update parks set unit_state = 'ca' where unit_code = 'pore';
update parks set unit_state = 'ca' where unit_code = 'poch';
update parks set unit_state = 'dc,md,pa,va' where unit_code = 'pohe';
update parks set unit_state = 'la' where unit_code = 'popo';
update parks set unit_state = 'ar' where unit_code = 'wicl';
update parks set unit_state = 'dc' where unit_code = 'whho';
update parks set unit_state = 'va' where unit_code = 'prwi';
update parks set unit_state = 'hi' where unit_code = 'puho';
update parks set unit_state = 'il' where unit_code = 'pull';
update parks set unit_state = 'hi' where unit_code = 'puhe';
update parks set unit_state = 'ut' where unit_code = 'rabr';
update parks set unit_state = 'ca' where unit_code = 'redw';
update parks set unit_state = 'va' where unit_code = 'rich';
update parks set unit_state = 'tx' where unit_code = 'rigr';
update parks set unit_state = 'mi' where unit_code = 'rira';
update parks set unit_state = 'dc' where unit_code = 'rocr';
update parks set unit_state = 'co' where unit_code = 'romo';
update parks set unit_state = 'ri' where unit_code = 'rowi';
update parks set unit_state = 'ca' where unit_code = 'rori';
update parks set unit_state = 'wa' where unit_code = 'rola';
update parks set unit_state = 'al' where unit_code = 'ruca';
update parks set unit_state = 'ny' where unit_code = 'sahi';
update parks set unit_state = 'az' where unit_code = 'sagu';
update parks set unit_state = 'wi' where unit_code = 'sacn';
update parks set unit_state = 'me' where unit_code = 'sacr';
update parks set unit_state = 'ny' where unit_code = 'sapa';
update parks set unit_state = 'nh' where unit_code = 'saga';
update parks set unit_state = 'ma' where unit_code = 'sama';
update parks set unit_state = 'nm' where unit_code = 'sapu';
update parks set unit_state = 'vi' where unit_code = 'sari';
update parks set unit_state = 'tx' where unit_code = 'saan';
update parks set unit_state = 'ca' where unit_code = 'safr';
update parks set unit_state = 'pr' where unit_code = 'saju';
update parks set unit_state = 'wa' where unit_code = 'sajh';
update parks set unit_state = 'co' where unit_code = 'sand';
update parks set unit_state = 'ca' where unit_code = 'samo';
update parks set unit_state = 'ny' where unit_code = 'sara';
update parks set unit_state = 'ma' where unit_code = 'sair';
update parks set unit_state = 'ne' where unit_code = 'scbl';
update parks set unit_state = 'ca' where unit_code = 'seki';
update parks set unit_state = 'va' where unit_code = 'shen';
update parks set unit_state = 'tn' where unit_code = 'shil';
update parks set unit_state = 'ak' where unit_code = 'sitk';
update parks set unit_state = 'mi' where unit_code = 'slbe';
update parks set unit_state = 'ma' where unit_code = 'spar';
update parks set unit_state = 'ny' where unit_code = 'stli';
update parks set unit_state = 'pa' where unit_code = 'stea';
update parks set unit_state = 'tn' where unit_code = 'stri';
update parks set unit_state = 'az' where unit_code = 'sucr';
update parks set unit_state = 'ks' where unit_code = 'tapr';
update parks set unit_state = 'pa' where unit_code = 'thko';
update parks set unit_state = 'nd' where unit_code = 'thro';
update parks set unit_state = 'ny' where unit_code = 'thrb';
update parks set unit_state = 'ny' where unit_code = 'thri';
update parks set unit_state = 'va' where unit_code = 'this';
update parks set unit_state = 'nj' where unit_code = 'edis';
update parks set unit_state = 'dc' where unit_code = 'thje';
update parks set unit_state = 'md' where unit_code = 'thst';
update parks set unit_state = 'ut' where unit_code = 'tica';
update parks set unit_state = 'fl' where unit_code = 'timu';
update parks set unit_state = 'az' where unit_code = 'tont';
update parks set unit_state = 'nv' where unit_code = 'tusk';
update parks set unit_state = 'az' where unit_code = 'tuma';
update parks set unit_state = 'ms' where unit_code = 'tupe';
update parks set unit_state = 'al' where unit_code = 'tuai';
update parks set unit_state = 'al' where unit_code = 'tuin';
update parks set unit_state = 'az' where unit_code = 'tuzi';
update parks set unit_state = 'mo' where unit_code = 'ulsg';
update parks set unit_state = 'ny,pa' where unit_code = 'upde';
update parks set unit_state = 'nm' where unit_code = 'vall';
update parks set unit_state = 'pa' where unit_code = 'vafo';
update parks set unit_state = 'ny' where unit_code = 'vama';
update parks set unit_state = 'ms' where unit_code = 'vick';
update parks set unit_state = 'dc' where unit_code = 'vive';
update parks set unit_state = 'vi' where unit_code = 'viis';
update parks set unit_state = 'vi' where unit_code = 'vicr';
update parks set unit_state = 'mn' where unit_code = 'voya';
update parks set unit_state = 'tx' where unit_code = 'waco';
update parks set unit_state = 'az' where unit_code = 'waca';
update parks set unit_state = 'gu' where unit_code = 'wapa';
update parks set unit_state = 'ok' where unit_code = 'waba';
update parks set unit_state = 'ct' where unit_code = 'wefa';
update parks set unit_state = 'ca' where unit_code = 'whis';
update parks set unit_state = 'nm' where unit_code = 'whsa';
update parks set unit_state = 'wa' where unit_code = 'whmi';
update parks set unit_state = 'oh' where unit_code = 'wiho';
update parks set unit_state = 'mo' where unit_code = 'wicr';
update parks set unit_state = 'sd' where unit_code = 'wica';
update parks set unit_state = 'va' where unit_code = 'wotr';
update parks set unit_state = 'ny' where unit_code = 'wori';
update parks set unit_state = 'hi' where unit_code = 'valr';
update parks set unit_state = 'ak' where unit_code = 'wrst';
update parks set unit_state = 'nc' where unit_code = 'wrbr';
update parks set unit_state = 'az' where unit_code = 'wupa';
update parks set unit_state = 'id,mt,wy' where unit_code = 'yell';
update parks set unit_state = 'ca' where unit_code = 'yose';
update parks set unit_state = 'co' where unit_code = 'yuho';
update parks set unit_state = 'ak' where unit_code = 'yuch';
update parks set unit_state = 'ut' where unit_code = 'zion';
update parks set unit_state = 'hi' where unit_code = 'alka';
update parks set unit_state = 'ca' where unit_code = 'alca';
update parks set unit_state = 'ak' where unit_code = 'aleu';
update parks set unit_state = 'mp' where unit_code = 'amme';
update parks set unit_state = 'dc' where unit_code = 'anac';
update parks set unit_state = 'md' where unit_code = 'ancm';
update parks set unit_state = 'md' where unit_code = 'bawa';
update parks set unit_state = 'dc' where unit_code = 'batt';
update parks set unit_state = 'ma,ri' where unit_code = 'blac';
update parks set unit_state = 'ca,co,id,ks,mo,nv,or,ut,wy' where unit_code = 'cali';
update parks set unit_state = 'la' where unit_code = 'crha';
update parks set unit_state = 'va' where unit_code = 'came';
update parks set unit_state = 'dc' where unit_code = 'cahe';
update parks set unit_state = 'va,md,de,dc' where unit_code = 'cajo';
update parks set unit_state = 'dc,md,pa,va,wv' where unit_code = 'cbpo';
update parks set unit_state = 'ne' where unit_code = 'chro';
update parks set unit_state = 'va' where unit_code = 'clmo';
update parks set unit_state = 'oh' where unit_code = 'dabe';
update parks set unit_state = 'pa' where unit_code = 'dele';
update parks set unit_state = 'pa' where unit_code = 'demo';
update parks set unit_state = 'nm,tx' where unit_code = 'elca';
update parks set unit_state = 'nj,ny' where unit_code = 'elis';
update parks set unit_state = 'ny' where unit_code = 'erie';
update parks set unit_state = 'ma' where unit_code = 'esse';
update parks set unit_state = 'mi' where unit_code = 'fama';
update parks set unit_state = 'tn' where unit_code = 'fdnc';
update parks set unit_state = 'dc' where unit_code = 'fodu';
update parks set unit_state = 'md' where unit_code = 'fofo';
update parks set unit_state = 'va' where unit_code = 'fred';
update parks set unit_state = 'dc' where unit_code = 'gemm';
update parks set unit_state = 'pa' where unit_code = 'getc';
update parks set unit_state = 'md' where unit_code = 'glec';
update parks set unit_state = 'pa' where unit_code = 'glde';
update parks set unit_state = 'va' where unit_code = 'grfa';
update parks set unit_state = 'va' where unit_code = 'grsp';
update parks set unit_state = 'md' where unit_code = 'haha';
update parks set unit_state = 'wi' where unit_code = 'iatr';
update parks set unit_state = 'il' where unit_code = 'ilmi';
update parks set unit_state = 'ak' where unit_code = 'inup';
update parks set unit_state = 'va' where unit_code = 'jame';
update parks set unit_state = 'dc' where unit_code = 'joer';
update parks set unit_state = 'ca' where unit_code = 'juba';
update parks set unit_state = 'dc' where unit_code = 'kepa';
update parks set unit_state = 'wa' where unit_code = 'klse';
update parks set unit_state = 'ia,id,il,ks,mo,mt,nd,ne,or,sd,wa' where unit_code = 'lecl';
update parks set unit_state = 'ny' where unit_code = 'loea';
update parks set unit_state = 'me' where unit_code = 'maac';
update parks set unit_state = 'ny' where unit_code = 'masi';
update parks set unit_state = 'or' where unit_code = 'mcho';
update parks set unit_state = 'ia,il,ne,ut,wy' where unit_code = 'mopi';
update parks set unit_state = 'ms,tn' where unit_code = 'natt';
update parks set unit_state = 'dc' where unit_code = 'nace';
update parks set unit_state = 'ny' where unit_code = 'npnh';
update parks set unit_state = 'nj' where unit_code = 'neje';
update parks set unit_state = 'nj' where unit_code = 'pine';
update parks set unit_state = 'mi,mn,nd,ny,oh,pa,wi' where unit_code = 'noco';
update parks set unit_state = 'ok' where unit_code = 'okci';
update parks set unit_state = 'dc' where unit_code = 'opot';
update parks set unit_state = 'id,ks,mo,ne,or,wy' where unit_code = 'oreg';
update parks set unit_state = 'nc,sc,tn,va' where unit_code = 'ovvi';
update parks set unit_state = 'md' where unit_code = 'oxhi';
update parks set unit_state = 'az' where unit_code = 'para';
update parks set unit_state = 'dc' where unit_code = 'pimi';
update parks set unit_state = 'ca,co,ks,mo,nv,ut,wy' where unit_code = 'poex';
update parks set unit_state = 'va' where unit_code = 'pogr';
update parks set unit_state = 'ca' where unit_code = 'prsf';
update parks set unit_state = 'ct' where unit_code = 'qush';
update parks set unit_state = 'me' where unit_code = 'roca';
update parks set unit_state = 'co,ks,mo,nm,ok' where unit_code = 'safe';
update parks set unit_state = 'al' where unit_code = 'semo';
update parks set unit_state = 'dc' where unit_code = 'sebe';
update parks set unit_state = 'tn' where unit_code = 'shnc';
update parks set unit_state = 'tn' where unit_code = 'srnc';
update parks set unit_state = 'md' where unit_code = 'suit';
update parks set unit_state = 'dc' where unit_code = 'olst';
update parks set unit_state = 'ri' where unit_code = 'tosy';
update parks set unit_state = 'al,ar,ga,il,ky,mo,nc,ok,tn' where unit_code = 'trte';
update parks set unit_state = 'hi' where unit_code = 'usar';
update parks set unit_state = 'ms' where unit_code = 'vinc';
update parks set unit_state = 'ak' where unit_code = 'nwak';
update parks set unit_state = 'va' where unit_code = 'york';
update parks set unit_state = 'va' where unit_code = 'yonb';

And the remainder:

update parks set unit_state = 'sc' where unit_code = 'cong';
update parks set unit_state = 'dc' where unit_code = 'jofk';
update parks set unit_state = 'ca' where unit_code = 'kica';
update parks set unit_state = 'ca' where unit_code = 'sequ';
update parks set unit_state = 'tn' where unit_code = 'obri';
update parks set unit_state = 'wi' where unit_code = 'losa';
update parks set unit_state = 'dc' where unit_code = 'wamo';
update parks set unit_state = 'pa' where unit_code = 'befr';
update parks set unit_state = 'dc' where unit_code = 'naca';

This leaves only inpe "International Peace Garden Memorial" without a unit_state.

[chadlawlis]

All set here.