National Park Service Units.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This notebook introduces National Park Service units to the GeoKB. The originating use case for these came from work to represent Geo-Heritage sites, but NPS units will be needed for many other purposes. Like with our other reference sources, we don't need a fully comprehensive representation of \"Parks\" in the GeoKB, but we need to have established identities we can link to and whatever characteristics of those entities we need for our uses (e.g., attributes we need to query on or include in query outputs/reports). In the initial representation, we are including the following concepts:\n",
    "\n",
    "* Park name and any alternates we know about\n",
    "* Point location for basic spatial reference\n",
    "* US States the park is located within\n",
    "* URL to an official web site (because it's there and could be useful in some circumstances as a linking factor)\n",
    "\n",
    "NPS also uses a unique 4-character alpha code for all park units that is used as a route to many other details and related information through their API and other interface points. This necessitated the introduction of a new property. The formatter URL we used for the parkCode essentially gives us the same functionality as the official URL, but we include both for different kinds of utility.\n",
    "\n",
    "We also needed to introduce the National Park Service itself as a DOI Bureau so we can indicate the higher level managing entity for the units.\n",
    "\n",
    "I initially tried to build out a same as linkage to Wikidata using a higher level classification for protected areas that gets us many of the units for NPS but also other managing entities, but I need to do some more work on understanding how those entities have been introduced and what I can align with effectively. For now, I've punted on this issue as well in the interest of getting our GeoKB entities established."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from wbmaker import WikibaseConnection\n",
    "import pandas as pd\n",
    "import requests\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "geokb = WikibaseConnection('GEOKB_CLOUD')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Original Source\n",
    "\n",
    "Wherever possible in the GeoKB, I am attempting to work with some best available original source. I want something that is an official outlet of whoever the managing authority is that is also technically easy to work with in code. In this case, I'm experimenting with the official NPS REST API, which seems to provide usable enough information on park units along with some other useful assets that we might incorporate for other purposes.\n",
    "\n",
    "I'm continuing to hash through all of the best ways to document sources in the GeoKB and haven't settled on the ultimate solution (if there is one). I'd like to be able to have the GeoKB fully explain how it gets everything with most if not all configuration details stored within entity claims, but I have to put more time on establishing the model. I at least want to have anything built out from a source point to a source entity as reference that we can continue building out. In this case, I established a [knowledgebase source item](https://geokb.wikibase.cloud/wiki/Item:Q158224) for the specific route used in the REST API. Logically, this could include the base HTTP route. We could be fully detailed and provide the version number of the API, request parameters, and even things like a standard variable used to provide an API key (something required in this case). For now, I'm punting on those details for later work. I drop the source item QID in so we can build a reference on claims."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "source_item = \"Q158224\"\n",
    "nps_entity = \"Q158217\"\n",
    "\n",
    "nps_parks_api = f\"https://developer.nps.gov/api/v1/parks?limit=1000&api_key={os.environ['NPS_API_KEY']}\"\n",
    "\n",
    "r_nps_parks = requests.get(nps_parks_api)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'id': '77E0D7F0-1942-494A-ACE2-9004D2BDC59E',\n",
       " 'url': 'https://www.nps.gov/abli/index.htm',\n",
       " 'fullName': 'Abraham Lincoln Birthplace National Historical Park',\n",
       " 'parkCode': 'abli',\n",
       " 'description': \"For over a century people from around the world have come to rural Central Kentucky to honor the humble beginnings of our 16th president, Abraham Lincoln. His early life on Kentucky's frontier shaped his character and prepared him to lead the nation through Civil War. Visit our country's first memorial to Lincoln, built with donations from young and old, and the site of his childhood home.\",\n",
       " 'latitude': '37.5858662',\n",
       " 'longitude': '-85.67330523',\n",
       " 'latLong': 'lat:37.5858662, long:-85.67330523',\n",
       " 'activities': [{'id': '13A57703-BB1A-41A2-94B8-53B692EB7238',\n",
       "   'name': 'Astronomy'},\n",
       "  {'id': 'D37A0003-8317-4F04-8FB0-4CF0A272E195', 'name': 'Stargazing'},\n",
       "  {'id': '1DFACD97-1B9C-4F5A-80F2-05593604799E', 'name': 'Food'},\n",
       "  {'id': 'C6D3230A-2CEA-4AFE-BFF3-DC1E2C2C4BB4', 'name': 'Picnicking'},\n",
       "  {'id': 'B33DC9B6-0B7D-4322-BAD7-A13A34C584A3', 'name': 'Guided Tours'},\n",
       "  {'id': 'A0631906-9672-4583-91DE-113B93DB6B6E',\n",
       "   'name': 'Self-Guided Tours - Walking'},\n",
       "  {'id': '42FD78B9-2B90-4AA9-BC43-F10E9FEA8B5A', 'name': 'Hands-On'},\n",
       "  {'id': 'DF4A35E0-7983-4A3E-BC47-F37B872B0F25',\n",
       "   'name': 'Junior Ranger Program'},\n",
       "  {'id': '0B685688-3405-4E2A-ABBA-E3069492EC50', 'name': 'Wildlife Watching'},\n",
       "  {'id': '5A2C91D1-50EC-4B24-8BED-A2E11A1892DF', 'name': 'Birdwatching'},\n",
       "  {'id': '0C0D142F-06B5-4BE1-8B44-491B90F93DEB', 'name': 'Park Film'},\n",
       "  {'id': 'C8F98B28-3C10-41AE-AA99-092B3B398C43', 'name': 'Museum Exhibits'},\n",
       "  {'id': '24380E3F-AD9D-4E38-BF13-C8EEB21893E7', 'name': 'Shopping'},\n",
       "  {'id': '467DC8B8-0B7D-436D-A026-80A22358F615',\n",
       "   'name': 'Bookstore and Park Store'},\n",
       "  {'id': '43800AD1-D439-40F3-AAB3-9FB651FE45BB',\n",
       "   'name': 'Gift Shop and Souvenirs'}],\n",
       " 'topics': [{'id': 'D10852A3-443C-4743-A5FA-6DD6D2A054B3',\n",
       "   'name': 'Birthplace'},\n",
       "  {'id': 'F669BC40-BDC4-41C0-9ACE-B2CD25373045', 'name': 'Presidents'},\n",
       "  {'id': '0D00073E-18C3-46E5-8727-2F87B112DDC6', 'name': 'Animals'},\n",
       "  {'id': '957EF2BD-AC6C-4B7B-BD9A-87593ADC6691', 'name': 'Birds'},\n",
       "  {'id': 'E25F3456-43ED-45DD-93BC-057F9B944F7A',\n",
       "   'name': 'Caves, Caverns and Karst'},\n",
       "  {'id': 'F0F97E32-2F29-41B4-AF98-9FBE8DAB36B1', 'name': 'Geology'},\n",
       "  {'id': '4BE01DC5-52E6-4F18-8C9A-B22D65965F6D', 'name': 'Groundwater'},\n",
       "  {'id': '0E1A04CC-EB51-4F18-93D4-EC0B0B4EC1E3', 'name': 'Freshwater Springs'},\n",
       "  {'id': 'A7359FC4-DAD8-45F5-AF15-7FF62F816ED3', 'name': 'Night Sky'}],\n",
       " 'states': 'KY',\n",
       " 'contacts': {'phoneNumbers': [{'phoneNumber': '2703583137',\n",
       "    'description': '',\n",
       "    'extension': '',\n",
       "    'type': 'Voice'},\n",
       "   {'phoneNumber': '2703583874',\n",
       "    'description': '',\n",
       "    'extension': '',\n",
       "    'type': 'Fax'}],\n",
       "  'emailAddresses': [{'description': '',\n",
       "    'emailAddress': 'ABLI_Administration@nps.gov'}]},\n",
       " 'entranceFees': [],\n",
       " 'entrancePasses': [],\n",
       " 'fees': [],\n",
       " 'directionsInfo': 'The Birthplace Unit of the park is located approximately 2 miles south of the town of Hodgenville on U.S. Highway 31E South. The Boyhood Home Unit at Knob Creek is located approximately 10 miles northeast of the Birthplace Unit of the park.',\n",
       " 'directionsUrl': 'http://www.nps.gov/abli/planyourvisit/directions.htm',\n",
       " 'operatingHours': [{'exceptions': [{'exceptionHours': {},\n",
       "     'startDate': '2023-11-23',\n",
       "     'name': 'Park is Closed',\n",
       "     'endDate': '2023-11-23'},\n",
       "    {'exceptionHours': {},\n",
       "     'startDate': '2023-12-25',\n",
       "     'name': 'Park is Closed',\n",
       "     'endDate': '2023-12-25'},\n",
       "    {'exceptionHours': {},\n",
       "     'startDate': '2024-01-01',\n",
       "     'name': 'Park is Closed',\n",
       "     'endDate': '2024-01-01'}],\n",
       "   'description': 'Memorial Building:\\nopen 9:00 am - 4:30 pm eastern time.\\n\\nBirthplace Unit Visitor Center and Grounds: \\nopen 9:00 am - 5:00 pm eastern time.',\n",
       "   'standardHours': {'wednesday': '9:00AM - 5:00PM',\n",
       "    'monday': '9:00AM - 5:00PM',\n",
       "    'thursday': '9:00AM - 5:00PM',\n",
       "    'sunday': '9:00AM - 5:00PM',\n",
       "    'tuesday': '9:00AM - 5:00PM',\n",
       "    'friday': '9:00AM - 5:00PM',\n",
       "    'saturday': '9:00AM - 5:00PM'},\n",
       "   'name': 'Birthplace Unit'},\n",
       "  {'exceptions': [{'exceptionHours': {'wednesday': 'Closed',\n",
       "      'monday': 'Closed',\n",
       "      'thursday': 'Closed',\n",
       "      'sunday': '10:00AM - 4:00PM',\n",
       "      'tuesday': 'Closed',\n",
       "      'friday': 'Closed',\n",
       "      'saturday': '10:00AM - 4:00PM'},\n",
       "     'startDate': '2024-04-01',\n",
       "     'name': 'Spring Hours - Visitor Center at Knob Creek',\n",
       "     'endDate': '2024-05-31'},\n",
       "    {'exceptionHours': {'wednesday': 'Closed',\n",
       "      'monday': 'Closed',\n",
       "      'thursday': 'Closed',\n",
       "      'sunday': '10:00AM - 4:00PM',\n",
       "      'tuesday': 'Closed',\n",
       "      'friday': 'Closed',\n",
       "      'saturday': '10:00AM - 4:00PM'},\n",
       "     'startDate': '2023-09-01',\n",
       "     'name': 'Fall Hours - Knob Creek Visitor Center',\n",
       "     'endDate': '2023-10-31'}],\n",
       "   'description': 'The Boyhood Home Unit at Knob Creek Grounds:\\nopen daily dawn to dusk.\\n\\nKnob Creek Tavern Visitor Center:\\nopen on weekends in April, May, September and October and 5 days a week from Memorial Day to Labor day from 10 am to 4pm (Thursday - Monday) closed for the winter.',\n",
       "   'standardHours': {'wednesday': 'Closed',\n",
       "    'monday': '10:00AM - 4:00PM',\n",
       "    'thursday': '10:00AM - 4:00PM',\n",
       "    'sunday': '10:00AM - 4:00PM',\n",
       "    'tuesday': 'Closed',\n",
       "    'friday': '10:00AM - 4:00PM',\n",
       "    'saturday': '10:00AM - 4:00PM'},\n",
       "   'name': 'Boyhood Unit'}],\n",
       " 'addresses': [{'postalCode': '42748',\n",
       "   'city': 'Hodgenville',\n",
       "   'stateCode': 'KY',\n",
       "   'countryCode': 'US',\n",
       "   'provinceTerritoryCode': '',\n",
       "   'line1': '2995 Lincoln Farm Road',\n",
       "   'type': 'Physical',\n",
       "   'line3': '',\n",
       "   'line2': ''},\n",
       "  {'postalCode': '42748',\n",
       "   'city': 'Hodgenville',\n",
       "   'stateCode': 'KY',\n",
       "   'countryCode': 'US',\n",
       "   'provinceTerritoryCode': '',\n",
       "   'line1': '2995 Lincoln Farm Road',\n",
       "   'type': 'Mailing',\n",
       "   'line3': '',\n",
       "   'line2': ''}],\n",
       " 'images': [{'credit': 'NPS Photo',\n",
       "   'title': 'The Memorial Building with fall colors',\n",
       "   'altText': 'The Memorial Building surrounded by fall colors',\n",
       "   'caption': 'Over 200,000 people a year come to walk up the steps of the Memorial Building to visit the site where Abraham Lincoln was born',\n",
       "   'url': 'https://www.nps.gov/common/uploads/structured_data/3C861078-1DD8-B71B-0B774A242EF6A706.jpg'},\n",
       "  {'credit': 'NPS Photo',\n",
       "   'title': 'The Memorial Building',\n",
       "   'altText': 'The first memorial erected to honor Abraham Lincoln',\n",
       "   'caption': 'The Memorial Building constructed on the traditional site of the birth of Abraham Lincoln.',\n",
       "   'url': 'https://www.nps.gov/common/uploads/structured_data/3C861263-1DD8-B71B-0B71EF9B95F9644F.jpg'},\n",
       "  {'credit': 'NPS Photo',\n",
       "   'title': 'The Symbolic Birth Cabin of Abraham Lincoln',\n",
       "   'altText': 'The symbolic birth cabin on the traditional site of the birth of Abraham Lincoln.',\n",
       "   'caption': 'The symbolic birth cabin of Abraham Lincoln.',\n",
       "   'url': 'https://www.nps.gov/common/uploads/structured_data/3C86137D-1DD8-B71B-0B978BACD7EBAEF1.jpg'},\n",
       "  {'credit': 'NPS Photo',\n",
       "   'title': 'Statue of the Lincoln Family in the Visitor Center',\n",
       "   'altText': \"Statue of the Lincoln family in the park's Visitor Center\",\n",
       "   'caption': 'Visitors to the park can view the statue of the Lincoln family.',\n",
       "   'url': 'https://www.nps.gov/common/uploads/structured_data/3C8614D1-1DD8-B71B-0B1AF72CA452B051.jpg'}],\n",
       " 'weatherInfo': 'There are four distinct seasons in Central Kentucky. However, temperature and weather conditions can vary widely within those seasons. Spring and Fall are generally pleasant with frequent rain showers. Summer is usually hot and humid. Winter is moderately cold with mixed precipitation.',\n",
       " 'name': 'Abraham Lincoln Birthplace',\n",
       " 'designation': 'National Historical Park'}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r_nps_parks.json()['data'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_parks = pd.DataFrame(r_nps_parks.json()['data'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Classification\n",
    "\n",
    "Further work will be needed to synthesize a higher level concept for classification of NPS \"parks.\" The listing of unique designation values below shows that there are units via the API that do not have any designation. The listing presented on [this NPS web site](https://www.nps.gov/aboutus/national-park-system.htm) is likely more reasonable, but that's not what comes through in the API. We'll look at things like how the USGS PADUS source handles this as well to make a determination on what our best route will be. In the meantime, I'm punting on the issue and simply using a high-level temporary classification of a \"National Park Service Unit.\" I did go ahead and pull the designation to use in the description string for now as a way to at least introduce the values (when they exist)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['National Historical Park', 'National Park', '',\n",
       "       'National Monument', 'National Historic Trail', 'Wild River',\n",
       "       'National Historic Area', 'National Historic Site', 'Park',\n",
       "       'National Recreation Area', 'National Monument & Preserve',\n",
       "       'National Battlefield', 'National Lakeshore',\n",
       "       'National Scenic Trail', 'National Memorial', 'National Seashore',\n",
       "       'Parkway', 'National Preserve', 'National River & Recreation Area',\n",
       "       'National Scenic River', 'National Battlefield Site',\n",
       "       'National River', 'Part of Colonial National Historical Park',\n",
       "       'National Military Park', 'National Reserve',\n",
       "       'National Park & Preserve', 'Memorial',\n",
       "       'National Historical Reserve',\n",
       "       'Part of Statue of Liberty National Monument',\n",
       "       'National Monument and Historic Shrine', 'Memorial Parkway',\n",
       "       'National Geologic Trail', 'National Historical Park and Preserve',\n",
       "       'National Battlefield Park', 'National Wild and Scenic River',\n",
       "       'National Recreational River', 'Wild & Scenic River',\n",
       "       'National Scenic Riverways', 'National and State Parks',\n",
       "       'International Park', 'International Historic Site',\n",
       "       'National Scenic Riverway',\n",
       "       'National Historical Park and Ecological Preserve',\n",
       "       'National Parks', 'Ecological & Historic Preserve',\n",
       "       'Scenic & Recreational River', 'Affiliated Area'], dtype=object)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "classification_item = \"Q158222\"\n",
    "\n",
    "df_parks['designation'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data Prep\n",
    "\n",
    "We need to do a couple of things to prep our park unit data for representation in the GeoKB.\n",
    "* In order to link to state/territory items, we pull those as a reference using the FIPS alpha codes that are what NPS has in their \"states\" fields. We pull a reference set from the GeoKB via SPARQL and set it up as a simple key/value store.\n",
    "* I generate a description using the designation where it exists or a default string just so the item is recognizable for what it is."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "query_fips_codes = \"\"\"\n",
    "PREFIX wdt: <https://geokb.wikibase.cloud/prop/direct/>\n",
    "\n",
    "SELECT ?item ?fips\n",
    "WHERE {\n",
    "  ?item wdt:P13 ?fips .\n",
    "}\n",
    "\"\"\"\n",
    "\n",
    "fips_codes = geokb.sparql_query(\n",
    "    query=query_fips_codes,\n",
    "    endpoint=geokb.sparql_endpoint,\n",
    "    output=\"dataframe\"\n",
    ")\n",
    "\n",
    "fips_codes['qid'] = fips_codes['item'].apply(lambda x: x.split('/')[-1])\n",
    "fips_lookup = fips_codes.set_index('fips')['qid'].to_dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "park_units = df_parks[['parkCode','fullName','name','url','states','latitude','longitude','designation']].reset_index(drop=True)\n",
    "\n",
    "park_units['description'] = park_units['designation'].apply(lambda x: f'a {x} managed by the National Park Service' if len(x) > 0 else 'a National Park Service Unit')\n",
    "park_units.drop(columns='designation', inplace=True)\n",
    "park_units['states'] = park_units['states'].apply(lambda x: x.split(','))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Commit to GeoKB"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>parkCode</th>\n",
       "      <th>fullName</th>\n",
       "      <th>name</th>\n",
       "      <th>url</th>\n",
       "      <th>states</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>abli</td>\n",
       "      <td>Abraham Lincoln Birthplace National Historical...</td>\n",
       "      <td>Abraham Lincoln Birthplace</td>\n",
       "      <td>https://www.nps.gov/abli/index.htm</td>\n",
       "      <td>[KY]</td>\n",
       "      <td>37.5858662</td>\n",
       "      <td>-85.67330523</td>\n",
       "      <td>a National Historical Park managed by the Nati...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>acad</td>\n",
       "      <td>Acadia National Park</td>\n",
       "      <td>Acadia</td>\n",
       "      <td>https://www.nps.gov/acad/index.htm</td>\n",
       "      <td>[ME]</td>\n",
       "      <td>44.409286</td>\n",
       "      <td>-68.247501</td>\n",
       "      <td>a National Park managed by the National Park S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>adam</td>\n",
       "      <td>Adams National Historical Park</td>\n",
       "      <td>Adams</td>\n",
       "      <td>https://www.nps.gov/adam/index.htm</td>\n",
       "      <td>[MA]</td>\n",
       "      <td>42.2553961</td>\n",
       "      <td>-71.01160356</td>\n",
       "      <td>a National Historical Park managed by the Nati...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>afam</td>\n",
       "      <td>African American Civil War Memorial</td>\n",
       "      <td>African American Civil War Memorial</td>\n",
       "      <td>https://www.nps.gov/afam/index.htm</td>\n",
       "      <td>[DC]</td>\n",
       "      <td>38.9166</td>\n",
       "      <td>-77.026</td>\n",
       "      <td>a National Park Service Unit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>afbg</td>\n",
       "      <td>African Burial Ground National Monument</td>\n",
       "      <td>African Burial Ground</td>\n",
       "      <td>https://www.nps.gov/afbg/index.htm</td>\n",
       "      <td>[NY]</td>\n",
       "      <td>40.71452681</td>\n",
       "      <td>-74.00447358</td>\n",
       "      <td>a National Monument managed by the National Pa...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  parkCode                                           fullName  \\\n",
       "0     abli  Abraham Lincoln Birthplace National Historical...   \n",
       "1     acad                               Acadia National Park   \n",
       "2     adam                     Adams National Historical Park   \n",
       "3     afam                African American Civil War Memorial   \n",
       "4     afbg            African Burial Ground National Monument   \n",
       "\n",
       "                                  name                                 url  \\\n",
       "0           Abraham Lincoln Birthplace  https://www.nps.gov/abli/index.htm   \n",
       "1                               Acadia  https://www.nps.gov/acad/index.htm   \n",
       "2                                Adams  https://www.nps.gov/adam/index.htm   \n",
       "3  African American Civil War Memorial  https://www.nps.gov/afam/index.htm   \n",
       "4                African Burial Ground  https://www.nps.gov/afbg/index.htm   \n",
       "\n",
       "  states     latitude     longitude  \\\n",
       "0   [KY]   37.5858662  -85.67330523   \n",
       "1   [ME]    44.409286    -68.247501   \n",
       "2   [MA]   42.2553961  -71.01160356   \n",
       "3   [DC]      38.9166       -77.026   \n",
       "4   [NY]  40.71452681  -74.00447358   \n",
       "\n",
       "                                         description  \n",
       "0  a National Historical Park managed by the Nati...  \n",
       "1  a National Park managed by the National Park S...  \n",
       "2  a National Historical Park managed by the Nati...  \n",
       "3                       a National Park Service Unit  \n",
       "4  a National Monument managed by the National Pa...  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "park_units.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Abraham Lincoln Birthplace National Historical Park Q158226\n",
      "Acadia National Park Q158227\n",
      "Adams National Historical Park Q158228\n",
      "African American Civil War Memorial Q158229\n",
      "African Burial Ground National Monument Q158230\n",
      "Agate Fossil Beds National Monument Q158231\n",
      "Ala Kahakai National Historic Trail Q158232\n",
      "Alagnak Wild River Q158233\n",
      "Alaska Public Lands Q158234\n",
      "Alcatraz Island Q158235\n",
      "Aleutian Islands World War II National Historic Area Q158236\n",
      "Alibates Flint Quarries National Monument Q158237\n",
      "Allegheny Portage Railroad National Historic Site Q158238\n",
      "Amache National Historic Site Q158239\n",
      "American Memorial Park Q158240\n",
      "Amistad National Recreation Area Q158241\n",
      "Anacostia Park Q158242\n",
      "Andersonville National Historic Site Q158243\n",
      "Andrew Johnson National Historic Site Q158244\n",
      "Aniakchak National Monument & Preserve Q158245\n",
      "Antietam National Battlefield Q158246\n",
      "Apostle Islands National Lakeshore Q158247\n",
      "Appalachian National Scenic Trail Q158248\n",
      "Appomattox Court House National Historical Park Q158249\n",
      "Arches National Park Q158250\n",
      "Arkansas Post National Memorial Q158251\n",
      "Arlington House, The Robert E. Lee Memorial Q158252\n",
      "Assateague Island National Seashore Q158253\n",
      "Aztec Ruins National Monument Q158254\n",
      "Badlands National Park Q158255\n",
      "Baltimore-Washington Parkway Q158256\n",
      "Bandelier National Monument Q158257\n",
      "Belmont-Paul Women's Equality National Monument Q158258\n",
      "Bent's Old Fort National Historic Site Q158259\n",
      "Bering Land Bridge National Preserve Q158260\n",
      "Big Bend National Park Q158261\n",
      "Big Cypress National Preserve Q158262\n",
      "Big Hole National Battlefield Q158263\n",
      "Big South Fork National River & Recreation Area Q158264\n",
      "Big Thicket National Preserve Q158265\n",
      "Bighorn Canyon National Recreation Area Q158266\n",
      "Birmingham Civil Rights National Monument Q158267\n",
      "Biscayne National Park Q158268\n",
      "Black Canyon Of The Gunnison National Park Q158269\n",
      "Blackstone River Valley National Historical Park Q158270\n",
      "Blackwell School National Historic Site Q158271\n",
      "Blue Ridge Parkway Q158272\n",
      "Bluestone National Scenic River Q158273\n",
      "Booker T Washington National Monument Q158274\n",
      "Boston African American National Historic Site Q158275\n",
      "Boston Harbor Islands National Recreation Area Q158276\n",
      "Boston National Historical Park Q158277\n",
      "Brices Cross Roads National Battlefield Site Q158278\n",
      "Brown v. Board of Education National Historical Park Q158279\n",
      "Bryce Canyon National Park Q158280\n",
      "Buck Island Reef National Monument Q158281\n",
      "Buffalo National River Q158282\n",
      "Butterfield Overland National Historic Trail Q158283\n",
      "Cabrillo National Monument Q158284\n",
      "California National Historic Trail Q158285\n",
      "Camp Nelson National Monument Q158286\n",
      "Canaveral National Seashore Q158287\n",
      "Cane River Creole National Historical Park Q158288\n",
      "Canyon de Chelly National Monument Q158289\n",
      "Canyonlands National Park Q158290\n",
      "Cape Cod National Seashore Q158291\n",
      "Cape Hatteras National Seashore Q158292\n",
      "Cape Henry Memorial Part of Colonial National Historical Park Q158293\n",
      "Cape Krusenstern National Monument Q158294\n",
      "Cape Lookout National Seashore Q158295\n",
      "Capitol Hill Parks Q158296\n",
      "Capitol Reef National Park Q158297\n",
      "Captain John Smith Chesapeake National Historic Trail Q158298\n",
      "Capulin Volcano National Monument Q158299\n",
      "Carl Sandburg Home National Historic Site Q158300\n",
      "Carlsbad Caverns National Park Q158301\n",
      "Carter G. Woodson Home National Historic Site Q158302\n",
      "Casa Grande Ruins National Monument Q158303\n",
      "Castillo de San Marcos National Monument Q158304\n",
      "Castle Clinton National Monument Q158305\n",
      "Castle Mountains National Monument Q158306\n",
      "Catoctin Mountain Park Q158307\n",
      "Cedar Breaks National Monument Q158308\n",
      "Cedar Creek & Belle Grove National Historical Park Q158309\n",
      "Chaco Culture National Historical Park Q158310\n",
      "Chamizal National Memorial Q158311\n",
      "Channel Islands National Park Q158312\n",
      "Charles Pinckney National Historic Site Q158313\n",
      "Charles Young Buffalo Soldiers National Monument Q158314\n",
      "Chattahoochee River National Recreation Area Q158315\n",
      "Chesapeake & Ohio Canal National Historical Park Q158316\n",
      "Chesapeake Bay Q158317\n",
      "Chickamauga & Chattanooga National Military Park Q158318\n",
      "Chickasaw National Recreation Area Q158319\n",
      "Chiricahua National Monument Q158320\n",
      "Christiansted National Historic Site Q158321\n",
      "City Of Rocks National Reserve Q158322\n",
      "Civil War Defenses of Washington Q158323\n",
      "Clara Barton National Historic Site Q158324\n",
      "Colonial National Historical Park Q158325\n",
      "Colorado National Monument Q158326\n",
      "Coltsville National Historical Park Q158327\n",
      "Congaree National Park Q158328\n",
      "Constitution Gardens Q158329\n",
      "Coronado National Memorial Q158330\n",
      "Cowpens National Battlefield Q158331\n",
      "Crater Lake National Park Q158332\n",
      "Craters Of The Moon National Monument & Preserve Q158333\n",
      "Cumberland Gap National Historical Park Q158334\n",
      "Cumberland Island National Seashore Q158335\n",
      "Curecanti National Recreation Area Q158336\n",
      "Cuyahoga Valley National Park Q158337\n",
      "César E. Chávez National Monument Q158338\n",
      "Dayton Aviation Heritage National Historical Park Q158339\n",
      "De Soto National Memorial Q158340\n",
      "Death Valley National Park Q158341\n",
      "Delaware Water Gap National Recreation Area Q158342\n",
      "Denali National Park & Preserve Q158343\n",
      "Devils Postpile National Monument Q158344\n",
      "Devils Tower National Monument Q158345\n",
      "Dinosaur National Monument Q158346\n",
      "Dry Tortugas National Park Q158347\n",
      "Dwight D. Eisenhower Memorial Q158348\n",
      "Ebey's Landing National Historical Reserve Q158349\n",
      "Edgar Allan Poe National Historic Site Q158350\n",
      "Effigy Mounds National Monument Q158351\n",
      "Eisenhower National Historic Site Q158352\n",
      "El Camino Real de Tierra Adentro National Historic Trail Q158353\n",
      "El Camino Real de los Tejas National Historic Trail Q158354\n",
      "El Malpais National Monument Q158355\n",
      "El Morro National Monument Q158356\n",
      "Eleanor Roosevelt National Historic Site Q158357\n",
      "Ellis Island Part of Statue of Liberty National Monument Q158358\n",
      "Emmett Till and Mamie Till-Mobley National Monument Q158359\n",
      "Eugene O'Neill National Historic Site Q158360\n",
      "Everglades National Park Q158361\n",
      "Federal Hall National Memorial Q158362\n",
      "Fire Island National Seashore Q158363\n",
      "First Ladies National Historic Site Q158364\n",
      "First State National Historical Park Q158365\n",
      "Flight 93 National Memorial Q158366\n",
      "Florissant Fossil Beds National Monument Q158367\n",
      "Ford's Theatre Q158368\n",
      "Fort Bowie National Historic Site Q158369\n",
      "Fort Davis National Historic Site Q158370\n",
      "Fort Donelson National Battlefield Q158371\n",
      "Fort Dupont Park Q158372\n",
      "Fort Foote Park Q158373\n",
      "Fort Frederica National Monument Q158374\n",
      "Fort Laramie National Historic Site Q158375\n",
      "Fort Larned National Historic Site Q158376\n",
      "Fort Matanzas National Monument Q158377\n",
      "Fort McHenry National Monument and Historic Shrine Q158378\n",
      "Fort Monroe National Monument Q158379\n",
      "Fort Necessity National Battlefield Q158380\n",
      "Fort Point National Historic Site Q158381\n",
      "Fort Pulaski National Monument Q158382\n",
      "Fort Raleigh National Historic Site Q158383\n",
      "Fort Scott National Historic Site Q158384\n",
      "Fort Smith National Historic Site Q158385\n",
      "Fort Stanwix National Monument Q158386\n",
      "Fort Sumter and Fort Moultrie National Historical Park Q158387\n",
      "Fort Union National Monument Q158388\n",
      "Fort Union Trading Post National Historic Site Q158389\n",
      "Fort Vancouver National Historic Site Q158390\n",
      "Fort Washington Park Q158391\n",
      "Fossil Butte National Monument Q158392\n",
      "Franklin Delano Roosevelt Memorial Q158393\n",
      "Frederick Douglass National Historic Site Q158394\n",
      "Frederick Law Olmsted National Historic Site Q158395\n",
      "Fredericksburg & Spotsylvania National Military Park Q158396\n",
      "Freedom Riders National Monument Q158397\n",
      "Friendship Hill National Historic Site Q158398\n",
      "Gates Of The Arctic National Park & Preserve Q158399\n",
      "Gateway Arch National Park Q158400\n",
      "Gateway National Recreation Area Q158401\n",
      "Gauley River National Recreation Area Q158402\n",
      "General Grant National Memorial Q158403\n",
      "George Rogers Clark National Historical Park Q158404\n",
      "George Washington Birthplace National Monument Q158405\n",
      "George Washington Carver National Monument Q158406\n",
      "George Washington Memorial Parkway Q158407\n",
      "Gettysburg National Military Park Q158408\n",
      "Gila Cliff Dwellings National Monument Q158409\n",
      "Glacier Bay National Park & Preserve Q158410\n",
      "Glacier National Park Q158411\n",
      "Glen Canyon National Recreation Area Q158412\n",
      "Glen Echo Park Q158413\n",
      "Gloria Dei Church National Historic Site Q158414\n",
      "Golden Gate National Recreation Area Q158415\n",
      "Golden Spike National Historical Park Q158416\n",
      "Governors Island National Monument Q158417\n",
      "Grand Canyon National Park Q158418\n",
      "Grand Canyon-Parashant National Monument Q158419\n",
      "Grand Portage National Monument Q158420\n",
      "Grand Teton National Park Q158421\n",
      "Grant-Kohrs Ranch National Historic Site Q158422\n",
      "Great Basin National Park Q158423\n",
      "Great Egg Harbor River Q158424\n",
      "Great Falls Park Q158425\n",
      "Great Sand Dunes National Park & Preserve Q158426\n",
      "Great Smoky Mountains National Park Q158427\n",
      "Green Springs Q158428\n",
      "Greenbelt Park Q158429\n",
      "Guadalupe Mountains National Park Q158430\n",
      "Guilford Courthouse National Military Park Q158431\n",
      "Gulf Islands National Seashore Q158432\n",
      "Hagerman Fossil Beds National Monument Q158433\n",
      "Haleakalā National Park Q158434\n",
      "Hamilton Grange National Memorial Q158435\n",
      "Hampton National Historic Site Q158436\n",
      "Harmony Hall Q158437\n",
      "Harpers Ferry National Historical Park Q158438\n",
      "Harriet Tubman National Historical Park Q158439\n",
      "Harriet Tubman Underground Railroad National Historical Park Q158440\n",
      "Harry S Truman National Historic Site Q158441\n",
      "Hawaiʻi Volcanoes National Park Q158442\n",
      "Herbert Hoover National Historic Site Q158443\n",
      "Historic Jamestowne Part of Colonial National Historical Park Q158444\n",
      "Home Of Franklin D Roosevelt National Historic Site Q158445\n",
      "Homestead National Historical Park Q158446\n",
      "Honouliuli National Historic Site Q158447\n",
      "Hopewell Culture National Historical Park Q158448\n",
      "Hopewell Furnace National Historic Site Q158449\n",
      "Horseshoe Bend National Military Park Q158450\n",
      "Hot Springs National Park Q158451\n",
      "Hovenweep National Monument Q158452\n",
      "Hubbell Trading Post National Historic Site Q158453\n",
      "Ice Age Floods National Geologic Trail Q158454\n",
      "Ice Age National Scenic Trail Q158455\n",
      "Independence National Historical Park Q158456\n",
      "Indiana Dunes National Park Q158457\n",
      "Isle Royale National Park Q158458\n",
      "Iñupiat Heritage Center Q158459\n",
      "James A Garfield National Historic Site Q158460\n",
      "Jean Lafitte National Historical Park and Preserve Q158461\n",
      "Jewel Cave National Monument Q158462\n",
      "Jimmy Carter National Historical Park Q158463\n",
      "John Day Fossil Beds National Monument Q158464\n",
      "John Fitzgerald Kennedy National Historic Site Q158465\n",
      "John Muir National Historic Site Q158466\n",
      "Johnstown Flood National Memorial Q158467\n",
      "Joshua Tree National Park Q158468\n",
      "Juan Bautista de Anza National Historic Trail Q158469\n",
      "Kalaupapa National Historical Park Q158470\n",
      "Kaloko-Honokōhau National Historical Park Q158471\n",
      "Katahdin Woods and Waters National Monument Q158472\n",
      "Katmai National Park & Preserve Q158473\n",
      "Kenai Fjords National Park Q158474\n",
      "Kenilworth Park & Aquatic Gardens Q158475\n",
      "Kennesaw Mountain National Battlefield Park Q158476\n",
      "Keweenaw National Historical Park Q158477\n",
      "Kings Mountain National Military Park Q158478\n",
      "Klondike Gold Rush - Seattle Unit National Historical Park Q158479\n",
      "Klondike Gold Rush National Historical Park Q158480\n",
      "Knife River Indian Villages National Historic Site Q158481\n",
      "Kobuk Valley National Park Q158482\n",
      "Korean War Veterans Memorial Q158483\n",
      "LBJ Memorial Grove on the Potomac Q158484\n",
      "Lake Clark National Park & Preserve Q158485\n",
      "Lake Mead National Recreation Area Q158486\n",
      "Lake Meredith National Recreation Area Q158487\n",
      "Lake Roosevelt National Recreation Area Q158488\n",
      "Lassen Volcanic National Park Q158489\n",
      "Lava Beds National Monument Q158490\n",
      "Lewis & Clark National Historic Trail Q158491\n",
      "Lewis and Clark National Historical Park Q158492\n",
      "Lincoln Boyhood National Memorial Q158493\n",
      "Lincoln Home National Historic Site Q158494\n",
      "Lincoln Memorial Q158495\n",
      "Little Bighorn Battlefield National Monument Q158496\n",
      "Little River Canyon National Preserve Q158497\n",
      "Little Rock Central High School National Historic Site Q158498\n",
      "Longfellow House Washington's Headquarters National Historic Site Q158499\n",
      "Lowell National Historical Park Q158500\n",
      "Lower Delaware National Wild and Scenic River Q158501\n",
      "Lower East Side Tenement Museum National Historic Site Q158502\n",
      "Lyndon B Johnson National Historical Park Q158503\n",
      "Maggie L Walker National Historic Site Q158504\n",
      "Maine Acadian Culture Q158505\n",
      "Mammoth Cave National Park Q158506\n",
      "Manassas National Battlefield Park Q158507\n",
      "Manhattan Project National Historical Park Q158508\n",
      "Manzanar National Historic Site Q158509\n",
      "Marsh - Billings - Rockefeller National Historical Park Q158510\n",
      "Martin Luther King, Jr. Memorial Q158511\n",
      "Martin Luther King, Jr. National Historical Park Q158512\n",
      "Martin Van Buren National Historic Site Q158513\n",
      "Mary McLeod Bethune Council House National Historic Site Q158514\n",
      "Medgar and Myrlie Evers Home National Monument Q158515\n",
      "Mesa Verde National Park Q158516\n",
      "Mill Springs Battlefield National Monument Q158517\n",
      "Minidoka National Historic Site Q158518\n",
      "Minute Man National Historical Park Q158519\n",
      "Minuteman Missile National Historic Site Q158520\n",
      "Mississippi National River & Recreation Area Q158521\n",
      "Missouri National Recreational River Q158522\n",
      "Mojave National Preserve Q158523\n",
      "Monocacy National Battlefield Q158524\n",
      "Montezuma Castle National Monument Q158525\n",
      "Moores Creek National Battlefield Q158526\n",
      "Mormon Pioneer National Historic Trail Q158527\n",
      "Morristown National Historical Park Q158528\n",
      "Mount Rainier National Park Q158529\n",
      "Mount Rushmore National Memorial Q158530\n",
      "Muir Woods National Monument Q158531\n",
      "Natchez National Historical Park Q158532\n",
      "Natchez Trace National Scenic Trail Q158533\n",
      "Natchez Trace Parkway Q158534\n",
      "National Capital Parks-East Q158535\n",
      "National Mall and Memorial Parks Q158536\n",
      "National Park of American Samoa Q158537\n",
      "National Parks of New York Harbor Q158538\n",
      "Natural Bridges National Monument Q158539\n",
      "Navajo National Monument Q158540\n",
      "New Bedford Whaling National Historical Park Q158541\n",
      "New England National Scenic Trail Q158542\n",
      "New Jersey Pinelands National Reserve Q158543\n",
      "New Orleans Jazz National Historical Park Q158544\n",
      "New Philadelphia National Historic Site Q158545\n",
      "New River Gorge National Park & Preserve Q158546\n",
      "Nez Perce National Historical Park Q158547\n",
      "Nicodemus National Historic Site Q158548\n",
      "Ninety Six National Historic Site Q158549\n",
      "Niobrara National Scenic River Q158550\n",
      "Noatak National Preserve Q158551\n",
      "North Cascades National Park Q158552\n",
      "North Country National Scenic Trail Q158553\n",
      "Obed Wild & Scenic River Q158554\n",
      "Ocmulgee Mounds National Historical Park Q158555\n",
      "Oklahoma City National Memorial Q158556\n",
      "Old Spanish National Historic Trail Q158557\n",
      "Olympic National Park Q158558\n",
      "Oregon Caves National Monument & Preserve Q158559\n",
      "Oregon National Historic Trail Q158560\n",
      "Organ Pipe Cactus National Monument Q158561\n",
      "Overmountain Victory National Historic Trail Q158562\n",
      "Oxon Cove Park & Oxon Hill Farm Q158563\n",
      "Ozark National Scenic Riverways Q158564\n",
      "Padre Island National Seashore Q158565\n",
      "Palo Alto Battlefield National Historical Park Q158566\n",
      "Paterson Great Falls National Historical Park Q158567\n",
      "Pea Ridge National Military Park Q158568\n",
      "Pearl Harbor National Memorial Q158569\n",
      "Pecos National Historical Park Q158570\n",
      "Pennsylvania Avenue Q158571\n",
      "Perry's Victory & International Peace Memorial Q158572\n",
      "Petersburg National Battlefield Q158573\n",
      "Petrified Forest National Park Q158574\n",
      "Petroglyph National Monument Q158575\n",
      "Pictured Rocks National Lakeshore Q158576\n",
      "Pinnacles National Park Q158577\n",
      "Pipe Spring National Monument Q158578\n",
      "Pipestone National Monument Q158579\n",
      "Piscataway Park Q158580\n",
      "Point Reyes National Seashore Q158581\n",
      "Pony Express National Historic Trail Q158582\n",
      "Port Chicago Naval Magazine National Memorial Q158583\n",
      "Potomac Heritage National Scenic Trail Q158584\n",
      "Poverty Point National Monument Q158585\n",
      "President William Jefferson Clinton Birthplace Home National Historic Site Q158586\n",
      "Presidio of San Francisco Q158587\n",
      "Prince William Forest Park Q158588\n",
      "Pullman National Historical Park Q158589\n",
      "Puʻuhonua o Hōnaunau National Historical Park Q158590\n",
      "Puʻukoholā Heiau National Historic Site Q158591\n",
      "Rainbow Bridge National Monument Q158592\n",
      "Reconstruction Era National Historical Park Q158593\n",
      "Redwood National and State Parks Q158594\n",
      "Richmond National Battlefield Park Q158595\n",
      "Rio Grande Wild & Scenic River Q158596\n",
      "River Raisin National Battlefield Park Q158597\n",
      "Rock Creek Park Q158598\n",
      "Rocky Mountain National Park Q158599\n",
      "Roger Williams National Memorial Q158600\n",
      "Roosevelt Campobello International Park Q158601\n",
      "Rosie the Riveter WWII Home Front National Historical Park Q158602\n",
      "Russell Cave National Monument Q158603\n",
      "Sagamore Hill National Historic Site Q158604\n",
      "Saguaro National Park Q158605\n",
      "Saint Croix Island International Historic Site Q158606\n",
      "Saint Croix National Scenic Riverway Q158607\n",
      "Saint Paul's Church National Historic Site Q158608\n",
      "Saint-Gaudens National Historical Park Q158609\n",
      "Salem Maritime National Historic Site Q158610\n",
      "Salinas Pueblo Missions National Monument Q158611\n",
      "Salt River Bay National Historical Park and Ecological Preserve Q158612\n",
      "San Antonio Missions National Historical Park Q158613\n",
      "San Francisco Maritime National Historical Park Q158614\n",
      "San Juan Island National Historical Park Q158615\n",
      "San Juan National Historic Site Q158616\n",
      "Sand Creek Massacre National Historic Site Q158617\n",
      "Santa Fe National Historic Trail Q158618\n",
      "Santa Monica Mountains National Recreation Area Q158619\n",
      "Saratoga National Historical Park Q158620\n",
      "Saugus Iron Works National Historic Site Q158621\n",
      "Scotts Bluff National Monument Q158622\n",
      "Selma To Montgomery National Historic Trail Q158623\n",
      "Sequoia & Kings Canyon National Parks Q158624\n",
      "Shenandoah National Park Q158625\n",
      "Shiloh National Military Park Q158626\n",
      "Sitka National Historical Park Q158627\n",
      "Sleeping Bear Dunes National Lakeshore Q158628\n",
      "Springfield Armory National Historic Site Q158629\n",
      "Star-Spangled Banner National Historic Trail Q158630\n",
      "Statue Of Liberty National Monument Q158631\n",
      "Ste. Geneviève National Historical Park Q158632\n",
      "Steamtown National Historic Site Q158633\n",
      "Stones River National Battlefield Q158634\n",
      "Stonewall National Monument Q158635\n",
      "Sunset Crater Volcano National Monument Q158636\n",
      "Tallgrass Prairie National Preserve Q158637\n",
      "Thaddeus Kosciuszko National Memorial Q158638\n",
      "The White House and President's Park Q158639\n",
      "Theodore Roosevelt Birthplace National Historic Site Q158640\n",
      "Theodore Roosevelt Inaugural National Historic Site Q158641\n",
      "Theodore Roosevelt Island Q158642\n",
      "Theodore Roosevelt National Park Q158643\n",
      "Thomas Cole National Historic Site Q158644\n",
      "Thomas Edison National Historical Park Q158645\n",
      "Thomas Jefferson Memorial Q158646\n",
      "Thomas Stone National Historic Site Q158647\n",
      "Timpanogos Cave National Monument Q158648\n",
      "Timucuan Ecological & Historic Preserve Q158649\n",
      "Tonto National Monument Q158650\n",
      "Touro Synagogue National Historic Site Q158651\n",
      "Trail Of Tears National Historic Trail Q158652\n",
      "Tule Lake National Monument Q158653\n",
      "Tule Springs Fossil Beds National Monument Q158654\n",
      "Tumacácori National Historical Park Q158655\n",
      "Tupelo National Battlefield Q158656\n",
      "Tuskegee Airmen National Historic Site Q158657\n",
      "Tuskegee Institute National Historic Site Q158658\n",
      "Tuzigoot National Monument Q158659\n",
      "Ulysses S Grant National Historic Site Q158660\n",
      "Upper Delaware Scenic & Recreational River Q158661\n",
      "Valles Caldera National Preserve Q158662\n",
      "Valley Forge National Historical Park Q158663\n",
      "Vanderbilt Mansion National Historic Site Q158664\n",
      "Vicksburg National Military Park Q158665\n",
      "Vietnam Veterans Memorial Q158666\n",
      "Virgin Islands Coral Reef National Monument Q158667\n",
      "Virgin Islands National Park Q158668\n",
      "Voyageurs National Park Q158669\n",
      "Waco Mammoth National Monument Q158670\n",
      "Walnut Canyon National Monument Q158671\n",
      "War In The Pacific National Historical Park Q158672\n",
      "Washington Monument Q158673\n",
      "Washington-Rochambeau Revolutionary Route National Historic Trail Q158674\n",
      "Washita Battlefield National Historic Site Q158675\n",
      "Weir Farm National Historical Park Q158676\n",
      "Whiskeytown National Recreation Area Q158677\n",
      "White Sands National Park Q158678\n",
      "Whitman Mission National Historic Site Q158679\n",
      "William Howard Taft National Historic Site Q158680\n",
      "Wilson's Creek National Battlefield Q158681\n",
      "Wind Cave National Park Q158682\n",
      "Wing Luke Museum Affiliated Area Q158683\n",
      "Wolf Trap National Park for the Performing Arts Q158684\n",
      "Women's Rights National Historical Park Q158685\n",
      "World War I Memorial Q158686\n",
      "World War II Memorial Q158687\n",
      "Wrangell - St Elias National Park & Preserve Q158688\n",
      "Wright Brothers National Memorial Q158689\n",
      "Wupatki National Monument Q158690\n",
      "Yellowstone National Park Q158691\n",
      "Yorktown Battlefield Part of Colonial National Historical Park Q158692\n",
      "Yosemite National Park Q158693\n",
      "Yucca House National Monument Q158694\n",
      "Yukon - Charley Rivers National Preserve Q158695\n",
      "Zion National Park Q158696\n"
     ]
    }
   ],
   "source": [
    "refs = geokb.models.References()\n",
    "refs.add(\n",
    "    geokb.datatypes.Item(\n",
    "        prop_nr=geokb.prop_lookup['data source'],\n",
    "        value=source_item\n",
    "    )\n",
    ")\n",
    "\n",
    "for index, row in park_units.iterrows():\n",
    "    item = geokb.wbi.item.new()\n",
    "\n",
    "    item.labels.set('en', row['fullName'])\n",
    "    item.descriptions.set('en', row['description'])\n",
    "\n",
    "    if row['name'] != row['fullName']:\n",
    "        item.aliases.set('en', row['name'])\n",
    "\n",
    "    item.claims.add(\n",
    "        geokb.datatypes.Item(\n",
    "            prop_nr=geokb.prop_lookup['instance of'],\n",
    "            value=classification_item,\n",
    "            references=refs\n",
    "        )\n",
    "    )\n",
    "\n",
    "    item.claims.add(\n",
    "        geokb.datatypes.ExternalID(\n",
    "            prop_nr=geokb.prop_lookup['NPS Park Code'],\n",
    "            value=row['parkCode'],\n",
    "            references=refs\n",
    "        )\n",
    "    )\n",
    "\n",
    "    item.claims.add(\n",
    "        geokb.datatypes.Item(\n",
    "            prop_nr=geokb.prop_lookup['operator'],\n",
    "            value=nps_entity,\n",
    "            references=refs\n",
    "        )\n",
    "    )\n",
    "\n",
    "    item.claims.add(\n",
    "        geokb.datatypes.URL(\n",
    "            prop_nr=geokb.prop_lookup['official website'],\n",
    "            value=row['url'],\n",
    "            references=refs\n",
    "        )\n",
    "    )\n",
    "\n",
    "    if len(row['latitude']) > 0:\n",
    "        item.claims.add(\n",
    "            geokb.datatypes.GlobeCoordinate(\n",
    "                prop_nr=geokb.prop_lookup['coordinate location'],\n",
    "                latitude=float(row['latitude']),\n",
    "                longitude=float(row['longitude']),\n",
    "                references=refs\n",
    "            )\n",
    "        )\n",
    "\n",
    "    state_location_claims = []\n",
    "    for st_fips in row['states']:\n",
    "        state_location_claims.append(\n",
    "            geokb.datatypes.Item(\n",
    "                prop_nr=geokb.prop_lookup['located in the administrative territorial entity'],\n",
    "                value=fips_lookup[st_fips],\n",
    "                references=refs\n",
    "            )\n",
    "        )\n",
    "    item.claims.add(state_location_claims)\n",
    "\n",
    "    response = item.write(\n",
    "        summary=\"Added initial entity representing a National Park Service Unit\"\n",
    "    )\n",
    "    print(row['fullName'], response.id)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "geokb",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.0"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}