Your 'Port' has been chosen Clear this filter or visit another page to change

Dunedin (Port Chalmers), New Zealand

Port Chalmers is the main port of the city of Dunedin, New Zealand. Although it has been a suburb since local body reorganisation in the 1980s, it is still regarded by most people throughout Dunedin as a separate town. Port Chalmers lies ten kilometres inside Otago Harbour, some 15 kilometres northeast from Dunedin's city centre.

Dunedin is the second-largest city on the south island of New Zealand. It is built in a natural harbour on a relatively small area of flat land, and is surrounded by steep hillsides. Some of its streets are very steep; Baldwin Street is claimed to be the steepest in the world.

Dunedin is known for its Victorian and Edwardian architecture; notable buildings include First Church and Larnach Castle. Other attractions include the famous Captain Cook Tavern, the local Speight's brewery and the Cadbury factory.

Things to See and Do

* Kiwi Shuttles tours
* Speights Brewery Tours
* Dunedin Casino
* The Octagon – city centre
* Cadbury factory tour

General information

Cruise Season – Jan - Dec
Currency - New Zealand dollar (NZD)
Language – English, Maori
Land Area – 3,314.8 km²
Population – 132,000 approx
Electricity – 2 Angled pins and 1 flat pin centred below Australian style
Time - GMT plus 12 hours
International Country Telephone Code – + 64

Port Location – Cruise ships dock at Port Chalmers which is located in Otago Harbor.

Transport Links – Dunedin airport is located southwest of the city and is largely a domestic terminal, however it does offer some international flights to some Australian capital cities. There are several daily bus services from Christchurch, Invercargill, Wanaka and Queenstown. The railway station is close to the centre of town. Unfortunately there is no longer a regular long distance passenger train service, but some people arrive in the city by the local scenic trains.

#	Query	Time
(1)	connect	0.00075483322143555
(2)	DESCRIBE `ports`	0.0018520355224609
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'dunedin-port-chalmers-new-zealand') AND (orchid_available = 1) LIMIT 1	0.0040020942687988
(4)	DESCRIBE `destinations`	0.0028131008148193
(5)	SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43)))	0.00040197372436523
(6)	DESCRIBE `avid_specials`	0.0011780261993408
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '43' AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))	0.0012190341949463
(8)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491')	0.0002901554107666
(9)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '491')	0.0015149116516113
(10)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '491')	0.0014679431915283
(11)	DESCRIBE `cruises`	0.0030810832977295
(12)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (77112, 76277, 76246, 58745, 78340, 78341, 76256, 76863, 76266, 76085)) ORDER BY FIND_IN_SET(id, '77112,76277,76246,58745,78340,78341,76256,76863,76266,76085')	0.0017769336700439
(13)	DESCRIBE `cruiselines`	0.0023880004882812
(14)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '15', '18', '26', '8', '262', '264', '29', '20', '14', '28', '91', '24', '114', '151', '4', '36', '37', '105', '159')) ORDER BY FIND_IN_SET(id, '23,15,18,26,8,262,264,29,20,14,28,91,24,114,151,4,36,37,105,159')	0.00189208984375
(15)	DESCRIBE `ships`	0.0029129981994629
(16)	SELECT `ships`.* FROM `ships` WHERE (id IN ('780', '1767', '683', '485', '1492', '1330', '1409', '547', '678', '1398', '253', '340', '389', '1135', '75', '394', '406', '1325', '287', '776', '1539', '105', '341', '451', '717', '1749', '332', '616', '1168', '1474', '1672', '4', '108', '479', '506', '66', '111', '338', '573', '692', '695', '1758')) ORDER BY FIND_IN_SET(id, '780,1767,683,485,1492,1330,1409,547,678,1398,253,340,389,1135,75,394,406,1325,287,776,1539,105,341,451,717,1749,332,616,1168,1474,1672,4,108,479,506,66,111,338,573,692,695,1758')	0.00341796875
(17)	DESCRIBE `cruisetypes`	0.0016422271728516
(18)	DESCRIBE `destinations`	0.0018439292907715
(19)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '40', '8', '7')) ORDER BY FIND_IN_SET(id, '43,40,8,7')	0.0006859302520752
(20)	DESCRIBE `ports`	0.0013108253479004
(21)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491)))	0.00067305564880371

Query

Time

(1)

connect

0.00075483322143555

(2)

DESCRIBE `ports`

0.0018520355224609

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'dunedin-port-chalmers-new-zealand') AND (orchid_available = 1) LIMIT 1

0.0040020942687988

(4)

DESCRIBE `destinations`

0.0028131008148193

(5)

SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43)))

0.00040197372436523

(6)

DESCRIBE `avid_specials`

0.0011780261993408

(7)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '43' AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))

0.0012190341949463

(8)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491')

0.0002901554107666

(9)

SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '491')

0.0015149116516113

(10)

SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '491')

0.0014679431915283

(11)

DESCRIBE `cruises`

0.0030810832977295

(12)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (77112, 76277, 76246, 58745, 78340, 78341, 76256, 76863, 76266, 76085)) ORDER BY FIND_IN_SET(id, '77112,76277,76246,58745,78340,78341,76256,76863,76266,76085')

0.0017769336700439

(13)

DESCRIBE `cruiselines`

0.0023880004882812

(14)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '15', '18', '26', '8', '262', '264', '29', '20', '14', '28', '91', '24', '114', '151', '4', '36', '37', '105', '159')) ORDER BY FIND_IN_SET(id, '23,15,18,26,8,262,264,29,20,14,28,91,24,114,151,4,36,37,105,159')

0.00189208984375

(15)

DESCRIBE `ships`

0.0029129981994629

(16)

SELECT `ships`.* FROM `ships` WHERE (id IN ('780', '1767', '683', '485', '1492', '1330', '1409', '547', '678', '1398', '253', '340', '389', '1135', '75', '394', '406', '1325', '287', '776', '1539', '105', '341', '451', '717', '1749', '332', '616', '1168', '1474', '1672', '4', '108', '479', '506', '66', '111', '338', '573', '692', '695', '1758')) ORDER BY FIND_IN_SET(id, '780,1767,683,485,1492,1330,1409,547,678,1398,253,340,389,1135,75,394,406,1325,287,776,1539,105,341,451,717,1749,332,616,1168,1474,1672,4,108,479,506,66,111,338,573,692,695,1758')

0.00341796875

(17)

DESCRIBE `cruisetypes`

0.0016422271728516

(18)

DESCRIBE `destinations`

0.0018439292907715

(19)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '40', '8', '7')) ORDER BY FIND_IN_SET(id, '43,40,8,7')

0.0006859302520752

(20)

DESCRIBE `ports`

0.0013108253479004

(21)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491)))

0.00067305564880371

Find Your Cruise

Dunedin (Port Chalmers), New Zealand

Database Profiling Report