Location Details

Lord Howe Group

Political Hierarchy

Australia --> New South Wales

Geographical Hierarchy

All Oceans of the World --> Pacific Ocean --> South Pacific Ocean --> Lord Howe Group

Coordinates: -31.5314822 159.0701995

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	ADFDCE20-2175-4DCE-A8D0-45DFF884CCD7	7488838C-22F2-47D0-BAD6-D60AD0D4C490	60	63	19694262	19694262	19691327	ADFDCE20-2175-4DCE-A8D0-45DFF884CCD7	[null]	[null]	19694262	19728822	1	19691433	1976	The endemic shore fishes of the Hawaiian Islands, Lord Howe Island and Easter Island	[null]	[null]	[null]	47	[null]	[null]	49-73	[null]	[null]	[null]	[null]	[null]	[null]	[null]	1976-01-01 00:00:00.000	1976-12-31 00:00:00.000	[null]	Randall 1976	Randall	Randall, John E.	<em>Travaux et Documents de l’Office de la Recherche Scientifique et Technique Outre-Mer, Oceanographie</em> <b>47</b>: 49-73.	The endemic shore fishes of the Hawaiian Islands, Lord Howe Island and Easter Island	2597624	7488838C-22F2-47D0-BAD6-D60AD0D4C490	38	2597624	[null]	7950	2597624	Lord Howe Group	[null]	1	[null]	[null]	[null]	lord howe.JPG	-31.5314822	159.0701995	4	7946	[empty string]	[null]	[null]	[null]	[null]	-31.5984709102	159.037068854	-31.510556657	159.105733405
2	92050464-8950-4E8E-BFCB-38762EA359C8	7488838C-22F2-47D0-BAD6-D60AD0D4C490	[null]	[null]	19719039	19719039	19691327	92050464-8950-4E8E-BFCB-38762EA359C8	[null]	[null]	19719039	19700102	1	0	1993	Checklist of the coastal fishes of Lord Howe, Norfolk, and Kermadec Island, southwest Pacific Ocean	[null]	[null]	[null]	47	[null]	2	136-170	[null]	[null]	[null]	[null]	[null]	[null]	[null]	1993-01-01 00:00:00.000	1993-12-31 00:00:00.000	[null]	Francis 1993	Francis	Francis, Malcom P.	<em>Pacific Science</em> <b>47</b>(2): 136-170.	Checklist of the coastal fishes of Lord Howe, Norfolk, and Kermadec Island, southwest Pacific Ocean	2597624	7488838C-22F2-47D0-BAD6-D60AD0D4C490	38	2597624	[null]	7950	2597624	Lord Howe Group	[null]	1	[null]	[null]	[null]	lord howe.JPG	-31.5314822	159.0701995	4	7946	[empty string]	[null]	[null]	[null]	[null]	-31.5984709102	159.037068854	-31.510556657	159.105733405
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:	Type=CF_SQL_VARCHAR; Data=[7488838C-22F2-47D0-BAD6-D60AD0D4C490]; Direction=IN; Variable=null