

select key_theme_id, theme_keyword from keyword_theme;
KEY_THEME_ID THEME_KEYWORD
------------ -------------------------------------------------------
           1 Public Land Survey System
           2 Geographic Coordinate Database
           3 Legal Land update
           4 Aliquots
           5 Land Grid
           6 Digital Elevation Model
           7 Mule deer
           8 Wildlife
           9 Winter range
          10 Summer range
          11 Hydrography

11 rows selected.

select ii_id, key_theme_id from keyword_theme_map;
   II_ID KEY_THEME_ID
---------- ------------
         1            2
         1            3
         1            4
         1            5
         1            1
         2            6
         3            7
         3            8
         3            9
         3           10
         4           11

11 rows selected.

select key_place_id, place_keyword from keyword_place;
KEY_PLACE_ID PLACE_KEYWORD
------------ -------------------------------------------------------
           1 Colorado
           2 Mt. St. Helens NW
           3 Washington
           4 Spirit Lake

4 rows selected.

select ii_id, key_place_id from keyword_place_map;
     II_ID KEY_PLACE_ID
---------- ------------
         2            2
         1            1
         2            3
         2            4
         3            1
         4            1

6 rows selected.