Mariana Islands

Political Hierarchy

Geographical Hierarchy

All Oceans of the World --> Pacific Ocean --> Western Pacific Ocean --> Micronesia --> Mariana Islands

Coordinates: 18.4152691926 145.441916244 The Mariana Islands (also the Marianas; up to the early 20th century sometimes called Ladrones Islands, from Spanish Islas de los Ladrones meaning "Islands of Thieves") are an arc-shaped archipelago made up by the summits of fifteen volcanic mountains in the north-western Pacific Ocean between the 12th and 21st parallels north and along the 145th meridian east. They are south of Japan and north of New Guinea, and form the eastern limit of the Philippine Sea. The islands were named after Spanish Queen Mariana of Austria in the 17th century, when Spain started the colonization of the archipelago. They form the northern part of the western Pacific subregion of Micronesia, and are composed of two U.S. jurisdictions: the Commonwealth of the Northern Mariana Islands and, at the southern end of the chain of islands, the territory of Guam.

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
1116F8288-1EA4-449F-B2F2-39ECF91E8B995B2FDC2E-BE02-4DB0-BDD6-D0A66C79E8D2598652197414961974149619691327116F8288-1EA4-449F-B2F2-39ECF91E8B99[null][null]1974149619701021102003The fishes of the Mariana Islands[null][null][null]35-36[null][null]598-652[null][null][null][null][null][null][null]2003-01-01 00:00:00.0002003-12-31 00:00:00.000[null]Myers & Donaldson 2003Myers & DonaldsonMyers, Robert F. & Terry J. Donaldson<em>Micronesica</em> <b>35-36</b>: 598-652.The fishes of the Mariana Islands 52895195B2FDC2E-BE02-4DB0-BDD6-D0A66C79E8D2385289519[empty string][null]5289519Mariana Islands[null]1[null][null][null][null]18.4152691926145.4419162445[null]The Mariana Islands (also the Marianas; up to the early 20th century sometimes called Ladrones Islands, from Spanish Islas de los Ladrones meaning "Islands of Thieves") are an arc-shaped archipelago made up by the summits of fifteen volcanic mountains in the north-western Pacific Ocean between the 12th and 21st parallels north and along the 145th meridian east. They are south of Japan and north of New Guinea, and form the eastern limit of the Philippine Sea. The islands were named after Spanish Queen Mariana of Austria in the 17th century, when Spain started the colonization of the archipelago. They form the northern part of the western Pacific subregion of Micronesia, and are composed of two U.S. jurisdictions: the Commonwealth of the Northern Mariana Islands and, at the southern end of the chain of islands, the territory of Guam.[null][null][null][null]12.5098035486143.354513921.525399765147.9248264
26DA13235-E09A-4100-A0A2-7E2C54E0A3F35B2FDC2E-BE02-4DB0-BDD6-D0A66C79E8D22072661973920819739208196913276DA13235-E09A-4100-A0A2-7E2C54E0A3F3[null][null]1973920819701021101996New and recent records of fishes from the Mariana Islands[null][null][null]28[null]2207-266[null][null][null][null][null][null][null]1996-01-01 00:00:00.0001996-12-31 00:00:00.000[null]Myers & Donaldson 1996Myers & DonaldsonMyers, Robert F. & Terry J. Donaldson<em>Micronesica</em> <b>28</b>(2): 207-266.New and recent records of fishes from the Mariana Islands 52895195B2FDC2E-BE02-4DB0-BDD6-D0A66C79E8D2385289519[empty string][null]5289519Mariana Islands[null]1[null][null][null][null]18.4152691926145.4419162445[null]The Mariana Islands (also the Marianas; up to the early 20th century sometimes called Ladrones Islands, from Spanish Islas de los Ladrones meaning "Islands of Thieves") are an arc-shaped archipelago made up by the summits of fifteen volcanic mountains in the north-western Pacific Ocean between the 12th and 21st parallels north and along the 145th meridian east. They are south of Japan and north of New Guinea, and form the eastern limit of the Philippine Sea. The islands were named after Spanish Queen Mariana of Austria in the 17th century, when Spain started the colonization of the archipelago. They form the northern part of the western Pacific subregion of Micronesia, and are composed of two U.S. jurisdictions: the Commonwealth of the Northern Mariana Islands and, at the southern end of the chain of islands, the territory of Guam.[null][null][null][null]12.5098035486143.354513921.525399765147.9248264
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=[5B2FDC2E-BE02-4DB0-BDD6-D0A66C79E8D2]; Direction=IN; Variable=null