
INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES 
("Christchurch", "Christchurch", "Christchurch", NULL, 197, 0, 1, NULL, "-43.530955", "172.6366455"),
("Invercargill", "Invercargill", "Invercargill", NULL, 197, 0, 1, NULL, "-46.4118465", "168.3470632"),
("Dunedin", "Dunedin", "Dunedin", NULL, 197, 0, 1, NULL, "-45.8740984", "170.5035755"),
("Nelson", "Nelson", "Nelson", NULL, 197, 0, 1, NULL, "-41.2710849", "173.2836756"),
("Wellington", "Wellington", "Wellington", NULL, 197, 0, 1, NULL, "-41.2887953", "174.7772114"),
("Porirua", "Porirua", "Porirua", NULL, 197, 0, 1, NULL, "-41.1354696", "174.8398067"),
("Lower Hutt", "Lower Hutt", "Lower Hutt", NULL, 197, 0, 1, NULL, "-41.2125751", "174.9057626"),
("Upper Hutt", "Upper Hutt", "Upper Hutt", NULL, 197, 0, 1, NULL, "-41.1240674", "175.0699589"),
("Palmerston North", "Palmerston North", "Palmerston North", NULL, 197, 0, 1, NULL, "-40.356317", "175.6112388"),
("Whanganui", "Whanganui", "Whanganui", NULL, 197, 0, 1, NULL, "-39.9324904", "175.0519306"),
("Hastings", "Hastings", "Hastings", NULL, 197, 0, 1, NULL, "-39.6417678", "176.8430781"),
("Napier", "Napier", "Napier", NULL, 197, 0, 1, NULL, "-39.4902099", "176.917839"),
("New Plymouth", "New Plymouth", "New Plymouth", NULL, 197, 0, 1, NULL, "-39.0579941", "174.0806474"),
("Whangārei", "Whangārei", "Whangarei", NULL, 197, 0, 1, NULL, "-35.7275268", "174.3194202"),
("Rotorua", "Rotorua", "Rotorua", NULL, 197, 0, 1, NULL, "-38.1381493", "176.252922"),
("Hamilton", "Hamilton", "Hamilton", NULL, 197, 0, 1, NULL, "-37.7878809", "175.281788"),
("Auckland", "Auckland", "Auckland", NULL, 197, 0, 1, NULL, "-36.852095", "174.7631803"),
("Hibiscus Coast", "Hibiscus Coast", "Hibiscus Coast", NULL, 197, 0, 1, NULL, "-36.6095336", "174.7086237"),
("Tauranga", "Tauranga", "Tauranga", NULL, 197, 0, 1, NULL, "-37.6859006", "176.167505"),
("Gisborne", "Gisborne", "Gisborne", NULL, 197, 0, 1, NULL, "-38.661326", "178.0206487"),
("Abbotsford", "Abbotsford", "Abbotsford", NULL, 197, 0, 1, NULL, "-45.8976781", "170.4219058"),
("Abbotts", "Abbotts", "Abbotts", NULL, 197, 0, 1, NULL, "-36.8871847", "174.8202952"),
("Abercorn", "Abercorn", "Abercorn", NULL, 197, 0, 1, NULL, "-38.2228079", "175.869829"),
("Abercrombie", "Abercrombie", "Abercrombie", NULL, 197, 0, 1, NULL, "-46.120775", "169.9637146"),
("Aberdeen", "Aberdeen", "Aberdeen", NULL, 197, 0, 1, NULL, "-38.6521076", "178.0105561"),
("Aberfeldy", "Aberfeldy", "Aberfeldy", NULL, 197, 0, 1, NULL, "-36.9028526", "174.9079069"),
("Aberfoyle", "Aberfoyle", "Aberfoyle", NULL, 197, 0, 1, NULL, "-37.7867275", "175.2471889"),
("Aberglasslyn", "Aberglasslyn", "Aberglasslyn", NULL, 197, 0, 1, NULL, "-32.694656", "151.534608"),
("Abermain", "Abermain", "Abermain", NULL, 197, 0, 1, NULL, "-32.816667", "151.433333"),
("Acacia Creek", "Acacia Creek", "Acacia Creek", NULL, 197, 0, 1, NULL, "-43.3092425", "172.5766483"),
("Acheron", "Acheron", "Acheron", NULL, 197, 0, 1, NULL, "-41.0923809", "174.8704804"),
("Ackland", "Ackland", "Ackland", NULL, 197, 0, 1, NULL, "-36.8484597", "174.7633315"),
("Adaminaby", "Adaminaby", "Adaminaby", NULL, 197, 0, 1, NULL, "-35.996111", "148.773889"),
("Adelaide", "Adelaide", "Adelaide", NULL, 197, 0, 1, NULL, "-41.3144806", "174.7756993"),
("Adelaide Lead", "Adelaide Lead", "Adelaide Lead", NULL, 197, 0, 1, NULL, "-37.0838207", "143.679125"),
("Adelaide River", "Adelaide River", "Adelaide River", NULL, 197, 0, 1, NULL, "-34.9284989", "138.6007456"),
("Advancetown", "Advancetown", "Advancetown", NULL, 197, 0, 1, NULL, "-28.0315826", "153.2767456"),
("Agnew", "Agnew", "Agnew", NULL, 197, 0, 1, NULL, "-45.0135507", "169.864703"),
("Ahipara", "Ahipara", "Ahipara", NULL, 197, 0, 1, NULL, "-35.1713389", "173.1532718"),
("Aireys Inlet", "Aireys Inlet", "Aireys Inlet", NULL, 197, 0, 1, NULL, "-38.4507109", "144.1089345"),
("Airly", "Airly", "Airly", NULL, 197, 0, 1, NULL, "33.931898", "-118.382006"),
("Alagala", "Alagala", "Alagala", NULL, 197, 0, 1, NULL, "7.3017888", "80.463245"),
("Albany Creek", "Albany Creek", "Albany Creek", NULL, 197, 0, 1, NULL, "-36.7326159", "174.7061932"),
("Alberton", "Alberton", "Alberton", NULL, 197, 0, 1, NULL, "-36.8847235", "174.724292"),
("Alberton West", "Alberton West", "Alberton West", NULL, 197, 0, 1, NULL, "-36.8847235", "174.724292"),
("Albion", "Albion", "Albion", NULL, 197, 0, 1, NULL, "51.496813", "-1.985503"),
("Albion Park", "Albion Park", "Albion Park", NULL, 197, 0, 1, NULL, "-46.1963534", "168.8592824"),
("Alexandra", "Alexandra", "Alexandra", NULL, 197, 0, 1, NULL, "-45.232815", "169.372381"),
("Alexandra-Mooloolaba", "Alexandra-Mooloolaba", "Alexandra-Mooloolaba", NULL, 197, 0, 1, NULL, "-26.6759629", "153.1147981"),
("Alfredton", "Alfredton", "Alfredton", NULL, 197, 0, 1, NULL, "-40.6795871", "175.8573061");
