Bonin Islands (Ogasawara-shoto)

Political Hierarchy

Japan

Geographical Hierarchy

All Oceans of the World --> Pacific Ocean --> North Pacific Ocean --> Bonin Islands (Ogasawara-shoto)

Coordinates: 27.0293628345 142.254557325 The Bonin Islands, known in Japan as the Ogasawara Group (小笠原群島 Ogasawara Guntō?) are an archipelago of over 30 subtropical and tropical islands, some 1,000 kilometres (540 nmi; 620 mi) directly south of Tokyo, Japan. "Bonin Islands" is the common name in English for Ogasawara Guntō, from the Japanese word bunin (an archaic reading of 無人 mujin), meaning "no people" or "uninhabited." The only inhabited islands of the group are Chichi-jima (父島), the seat of the municipal government, and Haha-jima (母島) which includes Ogasawara Village. Ogasawara Municipality (mura) and Ogasawara Subprefecture (Tokyo Prefecture) take their names from the Ogasawara Group. However, Ogasawara Archipelago (小笠原諸島 Ogasawara shotō?), may also be a wider collective term that includes other islands in Ogasawara Municipality, such as the Volcano Islands, along with other small, uninhabited and isolated islands.

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
1149BCC91-8066-4FA5-9362-0B7CF9AA4B8E2A2047D8-EA47-4C00-8685-BE8D04C5775B[null][null]196997141969971419691327149BCC91-8066-4FA5-9362-0B7CF9AA4B8E[null][null]19699714197235131196914331997Annotated checklist of the inshore fishes of the Ogasawara Islands[null]National Science MuseumTokyo[null][null]111-74, pls. 1-19 (color)[null][null][null][null][null][null][null]1997-01-01 00:00:00.0001997-12-31 00:00:00.000[null]Randall et al. 1997Randall, Ida, Kato, Pyle & EarleRandall, John E., Hitoshi Ida, Kenji Kato, Richard L. Pyle & John L. Earle<I>National Science Museum Tokyo, National Science Museum Monographs</I>(11): 1-74, pls. 1-19 (color).Annotated checklist of the inshore fishes of the Ogasawara Islands 25983452A2047D8-EA47-4C00-8685-BE8D04C5775B382598345[null]86712598345Bonin Islands (Ogasawara-shoto)[null]1[null][null][null][null]27.0293628345142.25455732538653The Bonin Islands, known in Japan as the Ogasawara Group (小笠原群島 Ogasawara Guntō?) are an archipelago of over 30 subtropical and tropical islands, some 1,000 kilometres (540 nmi; 620 mi) directly south of Tokyo, Japan. "Bonin Islands" is the common name in English for Ogasawara Guntō, from the Japanese word bunin (an archaic reading of 無人 mujin), meaning "no people" or "uninhabited." The only inhabited islands of the group are Chichi-jima (父島), the seat of the municipal government, and Haha-jima (母島) which includes Ogasawara Village. Ogasawara Municipality (mura) and Ogasawara Subprefecture (Tokyo Prefecture) take their names from the Ogasawara Group. However, Ogasawara Archipelago (小笠原諸島 Ogasawara shotō?), may also be a wider collective term that includes other islands in Ogasawara Municipality, such as the Volcano Islands, along with other small, uninhabited and isolated islands.[null][null][null][null]26.4013003752141.88651533327.7730762257142.529215528
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:2 ms
CFQUERYPARAMS:
  1. Type=CF_SQL_VARCHAR; Data=[2A2047D8-EA47-4C00-8685-BE8D04C5775B]; Direction=IN; Variable=null