Hawaiian Archipelago

Political Hierarchy

Geographical Hierarchy

All Oceans of the World --> Pacific Ocean --> Central Pacific Ocean --> Hawaiian Archipelago

Coordinates: 23.5991365 -166.7458436

query [long version]
 ReferenceUUIDLocationUUIDStart_PageEnd_PagePKIDCorrectIDTableIDUUIDLegacyIDLegacyID2ReferenceIDParentReferenceIDReferenceTypeIDLanguageIDYearTitleSecondaryTitlePublisherPlacePublishedVolumeNumberVolumesNumberPagesInPagesSectionEditionDatePublishedTypeWorkShortTitleFiguresStartDateEndDateURLCheatCitationCheatAuthorsCheatFullAuthorsCheatCitationDetailsCheatSearchReferenceExpr1Expr2FK_TableTypeIDExpr3CheatSearchStringExpr4PK_LocationIDLocation_nameFK_CountryIDActiveAbbreviationx_locationy_locationmap_nameLocationDecimalLatitudeLocationDecimalLongitudeEchelonFK_SubordIDlocation_descriptionheightwidthy_rect_coordsx_rect_coordsSW_Bound_LatSW_Bound_LongNE_Bound_LatNE_Bound_Long
1ADFDCE20-2175-4DCE-A8D0-45DFF884CCD7CEEE4C26-F67E-49B9-AB16-405C6EAAD5285057196942621969426219691327ADFDCE20-2175-4DCE-A8D0-45DFF884CCD7[null][null]19694262197288221196914331976The endemic shore fishes of the Hawaiian Islands, Lord Howe Island and Easter Island[null][null][null]47[null][null]49-73[null][null][null][null][null][null][null]1976-01-01 00:00:00.0001976-12-31 00:00:00.000[null]Randall 1976RandallRandall, John E.<em>Travaux et Documents de l’Office de la Recherche Scientifique et Technique Outre-Mer, Oceanographie</em> <b>47</b>: 49-73.The endemic shore fishes of the Hawaiian Islands, Lord Howe Island and Easter Island 2601297CEEE4C26-F67E-49B9-AB16-405C6EAAD528382601297[null]116232601297Hawaiian Archipelago[null]1[null][null][null]hawaii.JPG23.5991365-166.7458436311471[empty string][null][null][null][null]17.9838566-179.610836829.2144164-153.8808504
28A04BA7F-73D2-496A-BF40-BBE15A78A62DCEEE4C26-F67E-49B9-AB16-405C6EAAD528[null][null]1970890019708900196913278A04BA7F-73D2-496A-BF40-BBE15A78A62D[null][null]1970890002196914332007Reef and shore fishes of the Hawaiian Islands[null]University of Hawai‘i Sea Grant College ProrgamHonolulu[null][null][null]i-xiv,1-546[null][null][null]2007[null][null][null]2007-01-01 00:00:00.0002007-12-31 00:00:00.000[null]Randall 2007RandallRandall, John E.University of Hawai‘i Sea Grant College Prorgam, Honolulu.: i-xiv,1-546.Reef and shore fishes of the Hawaiian Islands 2601297CEEE4C26-F67E-49B9-AB16-405C6EAAD528382601297[null]116232601297Hawaiian Archipelago[null]1[null][null][null]hawaii.JPG23.5991365-166.7458436311471[empty string][null][null][null][null]17.9838566-179.610836829.2144164-153.8808504
311653AFF-2A78-4AEF-89F5-67093582F236CEEE4C26-F67E-49B9-AB16-405C6EAAD528[null][null]19708247197082471969132711653AFF-2A78-4AEF-89F5-67093582F236[null][null]1970824702196914332010Hawaii’s Sea Creatures[null]Mutual PublishingHonolulu[null][null][null]1-366[null][null]FifthApril 2010[null][null][null]2010-04-01 00:00:00.0002010-04-30 00:00:00.000[null][null]HooverHoover, John P.Mutual Publishing, Honolulu. Fifth Edition: 1-366.Hawaiis Sea Creatures Fifth 2601297CEEE4C26-F67E-49B9-AB16-405C6EAAD528382601297[null]116232601297Hawaiian Archipelago[null]1[null][null][null]hawaii.JPG23.5991365-166.7458436311471[empty string][null][null][null][null]17.9838566-179.610836829.2144164-153.8808504
44E1ACB99-627B-454F-967D-A03D2D4C549CCEEE4C26-F67E-49B9-AB16-405C6EAAD528[null][null]2238244022382440196913274E1ACB99-627B-454F-967D-A03D2D4C549C[null][null]2238244002196914331991Shells of Hawai‘i[null]University of Hawaii PressHonolulu[null][null][null]1-91[null][null][null][null][null][null][null]1991-01-01 00:00:00.0001991-12-31 00:00:00.000[null]Kay & Schoenberg-Dole 1991Kay & Schoenberg-DoleKay, E. A. & Olive Schoenberg-DoleUniversity of Hawaii Press, Honolulu.: 1-91.Shells of Hawaii 2601297CEEE4C26-F67E-49B9-AB16-405C6EAAD528382601297[null]116232601297Hawaiian Archipelago[null]1[null][null][null]hawaii.JPG23.5991365-166.7458436311471[empty string][null][null][null][null]17.9838566-179.610836829.2144164-153.8808504
5CDB792B7-040A-428F-AD6C-8BCE835AC2B9CEEE4C26-F67E-49B9-AB16-405C6EAAD528[null][null]197331831973318319691327CDB792B7-040A-428F-AD6C-8BCE835AC2B9[null]11811973318319734895101954Hawaiian Portunuidae[null][null][null]21[null]12217-274[null][null][null][null][null][null][null]1954-01-01 00:00:00.0001954-12-31 00:00:00.000[null]Edmondson 1954EdmondsonEdmondson, Charles H.<em>Occasional Papers of the Bernice P. Bishop Museum</em> <b>21</b>(12): 217-274.Hawaiian Portunuidae 2601297CEEE4C26-F67E-49B9-AB16-405C6EAAD528382601297[null]116232601297Hawaiian Archipelago[null]1[null][null][null]hawaii.JPG23.5991365-166.7458436311471[empty string][null][null][null][null]17.9838566-179.610836829.2144164-153.8808504
69BFBB145-BEEB-46A5-A53B-EACB48297C2ECEEE4C26-F67E-49B9-AB16-405C6EAAD5281921973221319732213196913279BFBB145-BEEB-46A5-A53B-EACB48297C2E[null]1069601973221319694820101922A list of the fishes of Hawaii, with notes and descriptions of new species[null][null][null]10[null]11-92, pls. 1-4[null][null][null]1 Dec.[null][null][null]1922-12-01 00:00:00.0001922-12-01 00:00:00.000[null]Jordan & Jordan 1922Jordan & JordanJordan, David S. & Eric K. Jordan<I>Memoirs of the Carnegie Museum</I> <B>10</B>(1): 1-92, pls. 1-4.A list of the fishes of Hawaii, with notes and descriptions of new species 2601297CEEE4C26-F67E-49B9-AB16-405C6EAAD528382601297[null]116232601297Hawaiian Archipelago[null]1[null][null][null]hawaii.JPG23.5991365-166.7458436311471[empty string][null][null][null][null]17.9838566-179.610836829.2144164-153.8808504
72213A5DD-E687-4532-88D2-232809C682B8CEEE4C26-F67E-49B9-AB16-405C6EAAD528[null][null]1971996519719965196913272213A5DD-E687-4532-88D2-232809C682B8[null]1179411971996519701089101831Descriptions of three new species of fish from the Sandwich Islands, in the British Museum[null][null][null]20[null][null]33[null][null][null][null][null][null][null]1831-01-01 00:00:00.0001831-12-31 00:00:00.000[null]Gray 1831GrayGray, John E.<I>Zoological Miscellany</I> <B>20</B>: 33.Descriptions of three new species of fish from the Sandwich Islands, in the British Museum 2601297CEEE4C26-F67E-49B9-AB16-405C6EAAD528382601297[null]116232601297Hawaiian Archipelago[null]1[null][null][null]hawaii.JPG23.5991365-166.7458436311471[empty string][null][null][null][null]17.9838566-179.610836829.2144164-153.8808504
8F2012DCA-A20F-44BB-85E0-D39EC9BB3046CEEE4C26-F67E-49B9-AB16-405C6EAAD528[null][null]197088221970882219691327F2012DCA-A20F-44BB-85E0-D39EC9BB3046[null]1214131970882219700102101994Deep-sea benthic fish of the Hawaiian Archipelago, Cross Seamount, and Johnston Atoll[null][null][null]48[null]4367-409[null][null][null][null][null][null][null]1994-01-01 00:00:00.0001994-12-31 00:00:00.000[null]Chave & Mundy 1994Chave & MundyChave, Edith H. & Bruce C. Mundy<em>Pacific Science</em> <b>48</b>(4): 367-409.Deep-sea benthic fish of the Hawaiian Archipelago, Cross Seamount, and Johnston Atoll 2601297CEEE4C26-F67E-49B9-AB16-405C6EAAD528382601297[null]116232601297Hawaiian Archipelago[null]1[null][null][null]hawaii.JPG23.5991365-166.7458436311471[empty string][null][null][null][null]17.9838566-179.610836829.2144164-153.8808504
94DFE052F-E9A5-4C0A-94A6-C4CF718258ADCEEE4C26-F67E-49B9-AB16-405C6EAAD528[null][null]1971098719710987196913274DFE052F-E9A5-4C0A-94A6-C4CF718258AD[null]1167721971098719695349101828Observations on the fishes contained in the collection of the Zoological Society. On some fishes from the Sandwich Islands[null][null][null]4[null]1331-42[null][null][null][null][null][null][null]1828-01-01 00:00:00.0001828-12-31 00:00:00.000[null]Bennett 1828BennettBennett, Edward T.<I>Zoological Journal</I> <B>4</B>(13): 31-42.Observations on the fishes contained in the collection of the Zoological Society. On some fishes from the Sandwich Islands 2601297CEEE4C26-F67E-49B9-AB16-405C6EAAD528382601297[null]116232601297Hawaiian Archipelago[null]1[null][null][null]hawaii.JPG23.5991365-166.7458436311471[empty string][null][null][null][null]17.9838566-179.610836829.2144164-153.8808504
10EA0F0B54-0EA3-40A0-BA84-34EE352F9959CEEE4C26-F67E-49B9-AB16-405C6EAAD528[null][null]197044581970445819691327EA0F0B54-0EA3-40A0-BA84-34EE352F9959[null]1180491970445819707770101864Descriptions of new species of fishes — No. II[null][null][null]3[null][null]103-107[null][null][null]Jan.[null][null][null]1864-01-01 00:00:00.0001864-01-31 00:00:00.000[null][null]GarrettGarrett, A.<em>Proceedings of the California Academy of Sciences, 1</em> <b>3</b>: 103-107.Descriptions of new species of fishes - No. II 2601297CEEE4C26-F67E-49B9-AB16-405C6EAAD528382601297[null]116232601297Hawaiian Archipelago[null]1[null][null][null]hawaii.JPG23.5991365-166.7458436311471[empty string][null][null][null][null]17.9838566-179.610836829.2144164-153.8808504
118A095659-80F5-466E-A765-B7FAD980216DCEEE4C26-F67E-49B9-AB16-405C6EAAD5284945191971984919719849196913278A095659-80F5-466E-A765-B7FAD980216D[null]1151781971984919722182101900Contributions to the ichthyology of the tropical Pacific[null][null][null]52[null]3493-528, pls. 18-20[null][null][null]31 Oct.-6 Nov.[null][null][null]1900-10-31 00:00:00.0001900-11-06 00:00:00.000[null]Fowler 1900FowlerFowler, Henry W.<em>Proceedings of the Academy of Natural Sciences of Philadelphia</em> <b>52</b>(3): 493-528, pls. 18-20.Contributions to the ichthyology of the tropical Pacific 2601297CEEE4C26-F67E-49B9-AB16-405C6EAAD528382601297[null]116232601297Hawaiian Archipelago[null]1[null][null][null]hawaii.JPG23.5991365-166.7458436311471[empty string][null][null][null][null]17.9838566-179.610836829.2144164-153.8808504
12F696083F-1620-4DFD-A509-D1C2BD582B13CEEE4C26-F67E-49B9-AB16-405C6EAAD528[null][null]197356281973562819691327F696083F-1620-4DFD-A509-D1C2BD582B13[null]1176661973562819740573101875Note sur quelques espèces nouvelles de poissons des îles Sandwich[null][null][null]3[null][null]278-287[null][null][null][null][null][null][null]1875-01-01 00:00:00.0001875-12-31 00:00:00.000[null]Vaillant & Sauvage 1875Vaillant & SauvageVaillant, Léon L. & H. E. Sauvage<em>Revue et Magasin de Zoologie, 3</em> <b>3</b>: 278-287.Note sur quelques especes nouvelles de poissons des iles Sandwich 2601297CEEE4C26-F67E-49B9-AB16-405C6EAAD528382601297[null]116232601297Hawaiian Archipelago[null]1[null][null][null]hawaii.JPG23.5991365-166.7458436311471[empty string][null][null][null][null]17.9838566-179.610836829.2144164-153.8808504
Query Source:SQL Query
Datasource:LOG
Query:SELECT lr.ReferenceUUID, lr.LocationUUID, lr.Start_Page, lr.End_Page, ref_pk.PKID, ref_pk.CorrectID, ref_pk.TableID, ref_pk.UUID, ref_pk.LegacyID, ref_pk.LegacyID2, r.ReferenceID, r.ParentReferenceID, r.ReferenceTypeID, r.LanguageID, r.Year, r.Title, r.SecondaryTitle, r.Publisher, r.PlacePublished, r.Volume, r.NumberVolumes, r.Number, r.Pages, r.InPages, r.Section, r.Edition, r.DatePublished, r.TypeWork, r.ShortTitle, r.Figures, r.StartDate, r.EndDate, r.URL, r.CheatCitation, r.CheatAuthors, r.CheatFullAuthors, r.CheatCitationDetails, r.CheatSearchReference, loc_pk.PKID AS Expr1, loc_pk.UUID AS Expr2, loc_pk.FK_TableTypeID, loc_pk.CorrectID AS Expr3, loc_pk.CheatSearchString, loc_pk.LegacyID AS Expr4, l.PK_LocationID, l.Location_name, l.FK_CountryID, l.Active, l.Abbreviation, l.x_location, l.y_location, l.map_name, l.GeoCoords.Lat as LocationDecimalLatitude, l.GeoCoords.Long as LocationDecimalLongitude, l.Echelon, l.FK_SubordID, l.location_description, l.height, l.width, l.y_rect_coords, l.x_rect_coords, l.SW_Bound_Lat, l.SW_Bound_Long, l.NE_Bound_Lat, l.NE_Bound_Long FROM Location_join_Reference AS lr INNER JOIN Taxonomer.dbo.PK AS ref_pk ON lr.ReferenceUUID = ref_pk.UUID INNER JOIN Taxonomer.dbo.Reference AS r ON ref_pk.PKID = r.ReferenceID INNER JOIN PK AS loc_pk ON lr.LocationUUID = loc_pk.UUID INNER JOIN Locations AS l ON l.PK_LocationID = loc_pk.PKID WHERE lr.ReferenceUUID IS NOT NULL AND lr.LocationUUID = ? ORDER BY lr.SortOrder
Time:0 ms
CFQUERYPARAMS:
  1. Type=CF_SQL_VARCHAR; Data=[CEEE4C26-F67E-49B9-AB16-405C6EAAD528]; Direction=IN; Variable=null