Clipperton Island (Île de Clipperton)

Political Hierarchy

France

Geographical Hierarchy

All Oceans of the World --> Europe --> Pacific Ocean --> Eastern Pacific Ocean --> French Overseas Territories --> Tropical Eastern Pacific --> Clipperton Island (Île de Clipperton)

Coordinates: 10.284842 -109.2162498 Clipperton Island (French: Île de Clipperton or Île de la Passion) is an uninhabited 9-square-kilometre (3.5 sq mi) coral atoll in the eastern Pacific Ocean, southwest of Mexico and west of Costa Rica, at 10°18′N 109°13′WCoordinates: 10°18′N 109°13′W. It is an overseas possession of France under direct authority of the Minister of Overseas France.[1]

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
118BAD69C-D187-4857-9101-32C0212542C2054FA9E1-A5A4-4355-99F3-CF0CEADCDF8C[null][null]22447476224474761969132718BAD69C-D187-4857-9101-32C0212542C2[null][null]22447476197198021196914331997An annotated checklist of the fishes of Clipperton Atoll, tropical eastern Pacific.[null][null][null]45[null]2813-843[null][null][null]1997[null][null][null]1997-01-01 00:00:00.0001997-12-31 00:00:00.000[null]Allen & Robertson 1997Allen & RobertsonAllen, Gerald R. & D. Ross Robertson<em>Revista de Biologia Tropical</em> <b>45</b>(2): 813-843.An annotated checklist of the fishes of Clipperton Atoll, tropical eastern Pacific. 5288410054FA9E1-A5A4-4355-99F3-CF0CEADCDF8C385288410[empty string][null]5288410Clipperton Island (Île de Clipperton)[null]1[null][null][null][null]10.284842-109.21624983[null]Clipperton Island (French: Île de Clipperton or Île de la Passion) is an uninhabited 9-square-kilometre (3.5 sq mi) coral atoll in the eastern Pacific Ocean, southwest of Mexico and west of Costa Rica, at 10°18′N 109°13′WCoordinates: 10°18′N 109°13′W. It is an overseas possession of France under direct authority of the Minister of Overseas France.[1][null][null][null][null]10.2820702-109.23801218810.3221475041-109.1993179
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:1 ms
CFQUERYPARAMS:
  1. Type=CF_SQL_VARCHAR; Data=[054FA9E1-A5A4-4355-99F3-CF0CEADCDF8C]; Direction=IN; Variable=null