Location Details

Baker Island

Political Hierarchy

United States of America --> Territories of the United States --> Unincorporated unorganized territories

Geographical Hierarchy

North America --> All Oceans of the World --> Pacific Ocean --> Central Pacific Ocean --> Baker Island

Coordinates: 0.1936266 -176.476908

query [long version]
	ReferenceUUID	LocationUUID	Start_Page	End_Page	PKID	CorrectID	TableID	UUID	LegacyID	LegacyID2	ReferenceID	ParentReferenceID	ReferenceTypeID	LanguageID	Year	Title	SecondaryTitle	Publisher	PlacePublished	Volume	NumberVolumes	Number	Pages	InPages	Section	Edition	DatePublished	TypeWork	ShortTitle	Figures	StartDate	EndDate	URL	CheatCitation	CheatAuthors	CheatFullAuthors	CheatCitationDetails	CheatSearchReference	Expr1	Expr2	FK_TableTypeID	Expr3	CheatSearchString	Expr4	PK_LocationID	Location_name	FK_CountryID	Active	Abbreviation	x_location	y_location	map_name	LocationDecimalLatitude	LocationDecimalLongitude	Echelon	FK_SubordID	location_description	height	width	y_rect_coords	x_rect_coords	SW_Bound_Lat	SW_Bound_Long	NE_Bound_Lat	NE_Bound_Long
1	4974A281-EA76-4BE4-BA08-52F1E4C4F018	7E87BC33-58C3-40C3-88BF-B6B79B4B0248	[null]	[null]	22206826	22206826	19691327	4974A281-EA76-4BE4-BA08-52F1E4C4F018	[null]	[null]	22206826	19724229	1	0	2010	Inshore Fishes of Howland Island, Baker Island, Jarvis Island, Palmyra Atoll, and Kingman Reef	[null]	National Museum of Natural History	Washington, D.C.	[null]	[null]	585	1-131	[null]	[null]	[null]	[null]	[null]	[null]	[null]	2010-01-01 00:00:00.000	2010-12-31 00:00:00.000	[null]	Mundy et al. 2010	Mundy, Wass, DeMartini, Greene, Zgliczynski, Schroeder & Musberger	Mundy, Bruce C., Richard C. Wass, E. E. DeMartini, Jr., Brian D. Greene, Brian Zgliczynski, Robert E. Schroeder & Craig Musberger	<em>Atoll Research Bulletin</em>(585): 1-131.	Inshore Fishes of Howland Island, Baker Island, Jarvis Island, Palmyra Atoll, and Kingman Reef	5288361	7E87BC33-58C3-40C3-88BF-B6B79B4B0248	38	5288361	[empty string]	[null]	5288361	Baker Island	[null]	1	[null]	[null]	[null]	[null]	0.1936266	-176.476908	4	[null]	[empty string]	[null]	[null]	[null]	[null]	0.189884	-176.4868501	0.2009611	-176.470108
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:	Type=CF_SQL_VARCHAR; Data=[7E87BC33-58C3-40C3-88BF-B6B79B4B0248]; Direction=IN; Variable=null