SeaTiger Wreck

Political Hierarchy

United States of America --> State of Hawaii

Geographical Hierarchy

All Oceans of the World --> Pacific Ocean --> Central Pacific Ocean --> North America --> Hawaiian Archipelago --> Main Hawaiian Islands --> Island of Oahu --> South Shore --> SeaTiger Wreck

Coordinates: 21.2804 -157.858566667 In 1992 known then as the Yun Fong Seong No. 303, it was caught smuggling 93 illegal Chinese immigrants. It seems Harbor master was trying to hail the ship but there was no answer, just the vessel barreling to the pier. The five crew members served various prison terms in what immigration officials say was Hawaii's largest seizure of illegal immigrants. The Justice Department seized the Yun Fong Seong No. 303 and sold it at auction. The Sea Shepherd Conservation Society bought the ship for $40,000 in 1993 and planned to use it to harass and ram fishing vessels that lay drift nets. The Yun Fong Seong No. 303 was to be renamed UN Resolution 42/216, after the United Nation resolution that bans drift nets. The society's plan fell through and the Yun Fong Seong No. 303 ended up selling it in 1994 to a Vietnamese fisherman who renamed it the Sea Tiger. The Sea Tiger kept repeatedly leaking oil and fuel into the Honolulu Harbor which led Hawaii Coast Guard inspectors to severally fine the owner on several occasions. Eventually they siezed the vessel were it was abandoned at Pier 40. The state was planning to tow the Sea Tiger 12 miles out to sea and sink it until Voyager Submarines bought it in 1997 for $1. It took Voyager two years of paperwork and $250,000 in cleanup and preparation costs to get all the approvals from the state Department of Land and Natural Resources, health department, U.S. Coast Guard, and the Army Corp of Engineers. They spent $100,000 just getting rid of 100 gallons of fuel and oil left in it. Voyager is no longer in business and only scuba divers frequent the Sea Tiger ship wreck now. This 189-foot Oahu ship wreck rests in 123 feet of water is the deepest recreational scuba diving ship wreck in Hawaii. This Hawaii ship wreck offers penetration through its cargo holds, inner cabins, engine room, narrow passageways, and stairwells of the ship.


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
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=[94A5E922-6264-4E1D-80BE-926091BE6B41]; Direction=IN; Variable=null