Location Details

Marshall Islands

Political Hierarchy

Republic of the Marshall Islands

Geographical Hierarchy

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

Coordinates: 7.131474 171.184478

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	B568366D-2D3E-493A-AF7E-3280CF49EFAB	43D21EB5-738E-4ED5-9284-769F4B1C0993	115	132	19736696	19736696	19691327	B568366D-2D3E-493A-AF7E-3280CF49EFAB	[null]	[null]	19736696	19705419	1	19691433	2005	Ninety-one new records of fishes from the Marshall Islands	[null]	[null]	[null]	9	[null]	3	115-132	[null]	[null]	[null]	March 2005	[null]	[null]	[null]	2005-03-01 00:00:00.000	2005-03-31 00:00:00.000	[null]	Randall et al. 2005	Randall, Myers, Trevor, Johnson, Johnson, Yoshii & Greene	Randall, John E., Robert F. Myers, Michael N. Trevor, Jeanette L. Johnson, Scott R. Johnson, Satoshi Yoshii & Brian D. Greene	<em>Aqua, Journal of Ichthyology and Aquatic Biology</em> <b>9</b>(3): 115-132.	Ninety-one new records of fishes from the Marshall Islands	2598777	43D21EB5-738E-4ED5-9284-769F4B1C0993	38	2598777	[null]	9103	2598777	Marshall Islands	[null]	1	[null]	[null]	[null]	[null]	7.131474	171.184478	3	9051	[empty string]	[null]	[null]	[null]	[null]	[null]	[null]	[null]	[null]
2	2A9A5E06-1DB3-4386-B636-B2C36A97DE34	43D21EB5-738E-4ED5-9284-769F4B1C0993	[null]	[null]	19729487	19729487	19691327	2A9A5E06-1DB3-4386-B636-B2C36A97DE34	[null]	[null]	19729487	19724699	1	19691433	1987	Annotated checklist of the fishes of Enewetak Atoll and other Marshall Islands. Chapter 27	[null]	[null]	[null]	[null]	[null]	[null]	289-324, 3 pls.	[null]	[null]	[null]	1987	[null]	[null]	[null]	1987-01-01 00:00:00.000	1987-12-31 00:00:00.000	[null]	Randall & Randall 1987	Randall & Randall	Randall, John E. & Helen A. Randall	<em>The natural history of Enewetak Atoll, Vol. II, Biogeography and systematics</em>: 289-324, 3 pls.	Annotated checklist of the fishes of Enewetak Atoll and other Marshall Islands. Chapter 27	2598777	43D21EB5-738E-4ED5-9284-769F4B1C0993	38	2598777	[null]	9103	2598777	Marshall Islands	[null]	1	[null]	[null]	[null]	[null]	7.131474	171.184478	3	9051	[empty string]	[null]	[null]	[null]	[null]	[null]	[null]	[null]	[null]
3	6AC312BB-1452-4BB9-8A09-3850AE392C1D	43D21EB5-738E-4ED5-9284-769F4B1C0993	[null]	[null]	19695042	19695042	19691327	6AC312BB-1452-4BB9-8A09-3850AE392C1D	[null]	[null]	19695042	0	2	19691433	1999	Micronesian reef fishes: a comprehensive guide to the coral reef fishes of Micronesia	[null]	Coral Graphics	Barrigada, Guam	[null]	[null]	[null]	i-vi, 1-330, pls. 1-192	[null]	[null]	Third edition, revised and expanded	[null]	[null]	[null]	[null]	1999-01-01 00:00:00.000	1999-12-31 00:00:00.000	[null]	[null]	Myers	Myers, Robert F.	Coral Graphics,Barrigada, Guam. Third edition, revised and expanded Edition: i-vi, 1-330, pls. 1-192.	Micronesian reef fishes: a comprehensive guide to the coral reef fishes of Micronesia Third edition, revised and expanded	2598777	43D21EB5-738E-4ED5-9284-769F4B1C0993	38	2598777	[null]	9103	2598777	Marshall Islands	[null]	1	[null]	[null]	[null]	[null]	7.131474	171.184478	3	9051	[empty string]	[null]	[null]	[null]	[null]	[null]	[null]	[null]	[null]
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:	3 ms
CFQUERYPARAMS:	Type=CF_SQL_VARCHAR; Data=[43D21EB5-738E-4ED5-9284-769F4B1C0993]; Direction=IN; Variable=null