geography.sql

USE linkServicesGroup;

INSERT INTO StateTerritory (stateName, stateAbbrev) VALUES
('New South Wales', 'NSW'),
('Queensland', 'QLD'),
('South Australia', 'SA'),
('Tasmania', 'TAS'),
('Victoria', 'VIC'),
('Western Australia', 'WA'),
('Northern Territory', 'NT'),
('Australian Capital Territory', 'ACT');


INSERT INTO Location (locationID, locationName, stateID, postcodeNumber, latitude, longitude) VALUES
(1,"Acacia Ridge",2,4110,-27.5857312,153.025206),
(2,"Albion",2,4010,-27.4303642,153.0421201),
(3,"Alderley",2,4051,-27.4258161,153.002316),
(4,"Algester",2,4115,-27.6109526,153.0315999),
(5,"Annerley",2,4103,-27.5093469,153.0321211),
(6,"Anstead",2,4070,-27.5404815,152.8638552),
(7,"Archerfield",2,4108,-27.5711117,153.007782),
(8,"Arundel",2,4214,-27.9360655,153.3653514),
(9,"Ascot",2,4007,-27.4318955,153.0630132),
(10,"Ashgrove",2,4060,-27.445399,152.9918185),
(11,"Ashmore",2,4214,-27.9909266,153.3770522),
(12,"Ashwell",2,4340,-27.6259765,152.5564029),
(13,"Aspley",2,4034,-27.3628522,153.0164177),
(14,"Auchenflower",2,4066,-27.4737823,152.995744),
(15,"Augustine Heights",2,4300,-27.6597333,152.8802803),
(16,"Bald Hills",2,4036,-27.3107173,153.0124269),
(17,"Balmoral",2,4171,-27.4559074,153.0664859),
(18,"Bannockburn",2,4207,-27.7614106,153.190012),
(19,"Banyo",2,4014,-27.3760218,153.0771634),
(20,"Bardon",2,4065,-27.4589389,152.9798416),
(21,"Barellan Point",2,4306,-27.5719333,152.843127),
(22,"Basin Pocket",2,4305,-27.6004003,152.7713677),
(23,"Beenleigh",2,4207,-27.7159492,153.2022293),
(24,"Belivah",2,4207,-27.7586117,153.1750031),
(25,"Bellbird Park",2,4300,-27.6367635,152.8886859),
(26,"Bellbowrie",2,4070,-27.5619254,152.8855689),
(27,"Belmont",2,4153,-27.5147784,153.1268563),
(28,"Benowa",2,4217,-28.0041744,153.3834595),
(29,"Berrinba",2,4117,-27.652767,153.0826433),
(30,"Bethania",2,4205,-27.6918376,153.1561448),
(31,"Biggera Waters",2,4216,-27.9271595,153.3983923),
(32,"Bilinga",2,4225,-28.1585408,153.505324),
(33,"Blacksoil",2,4306,-27.5763887,152.7057231),
(34,"Blackstone",2,4304,-27.6306942,152.8050166),
(35,"Bonogin",2,4213,-28.1277689,153.3604583),
(36,"Boondall",2,4034,-27.3534749,153.0618597),
(37,"Booval",2,4304,-27.6131241,152.7925942),
(38,"Boronia Heights",2,4124,-27.6879723,153.0216096),
(39,"Bowen Hills",2,4006,-27.4466752,153.0402224),
(40,"Bracken Ridge",2,4017,-27.3189512,153.0390386),
(41,"Brassall",2,4305,-27.5899637,152.7370408),
(42,"Bridgeman Downs",2,4035,-27.3562082,152.9944728),
(43,"Brighton",2,4017,-27.2979603,153.0581895),
(44,"Brisbane Airport",2,4008,-27.39333,153.11333),
(45,"Brisbane City",2,4000,-27.4677792,153.0261078),
(46,"Broadbeach",2,4218,-28.0235886,153.4293335),
(47,"Broadbeach Waters",2,4218,-28.0316652,153.4122307),
(48,"Brookfield",2,4069,-27.4947589,152.9114675),
(49,"Brookwater",2,4300,-27.6609335,152.8948824),
(50,"Browns Plains",2,4118,-27.6621496,153.0430484),
(51,"Bulimba",2,4171,-27.4498447,153.0600915),
(52,"Bundall",2,4217,-28.0112822,153.4080912),
(53,"Bundamba",2,4304,-27.6048845,152.8100289),
(54,"Burbank",2,4156,-27.5583324,153.1588898),
(55,"Burleigh Heads",2,4220,-28.1021343,153.4395799),
(56,"Burleigh Waters",2,4220,-28.0931614,153.4358054),
(57,"Calamvale",2,4116,-27.6169467,153.0495303),
(58,"Calvert",2,4340,-27.6674894,152.5078227),
(59,"Camira",2,4300,-27.634499,152.9199269),
(60,"Camp Hill",2,4152,-27.4942385,153.0771926),
(61,"Cannon Hill",2,4170,-27.4683191,153.0907736),
(62,"Carbrook",2,4130,-27.6759155,153.236016),
(63,"Carina",2,4152,-27.4942526,153.0900278),
(64,"Carina Heights",2,4152,-27.5014508,153.0966984),
(65,"Carindale",2,4152,-27.5032764,153.1040678),
(66,"Carole Park",2,4300,-27.6188711,152.9302722),
(67,"Carrara",2,4211,-28.02077,153.3683962),
(68,"Carseldine",2,4034,-27.3481021,153.0226204),
(69,"Chandler",2,4155,-27.5095617,153.1579124),
(70,"Chapel Hill",2,4069,-27.5051363,152.952349),
(71,"Chelmer",2,4068,-27.5122288,152.9744075),
(72,"Chermside",2,4032,-27.3863441,153.0313687),
(73,"Chermside West",2,4032,-27.3793434,153.0186899),
(74,"Churchill",2,4305,-27.6350442,152.7511026),
(75,"Chuwar",2,4306,-27.5646734,152.779679),
(76,"Clayfield",2,4011,-27.4223848,153.050976),
(77,"Clear Island Waters",2,4226,-28.0437627,153.3985228),
(78,"Coalfalls",2,4305,-27.606166,152.7414181),
(79,"Collingwood Park",2,4301,-27.6245511,152.8563239),
(80,"Coolangatta",2,4225,-28.1682934,153.538753),
(81,"Coombabah",2,4216,-27.9058415,153.3722586),
(82,"Coomera",2,4209,-27.8564881,153.3203988),
(83,"Coopers Plains",2,4108,-27.5691456,153.0337453),
(84,"Coorparoo",2,4151,-27.4962028,153.0595973),
(85,"Corinda",2,4075,-27.5430769,152.9813705),
(86,"Cornubia",2,4130,-27.6687965,153.2014437),
(87,"Crestmead",2,4132,-27.689416,153.0914486),
(88,"Currumbin",2,4223,-28.1369655,153.4799277),
(89,"Currumbin Valley",2,4223,-28.179401,153.422605),
(90,"Currumbin Waters",2,4223,-28.1553122,153.4612699),
(91,"Daisy Hill",2,4127,-27.643611,153.1538113),
(92,"Darra",2,4076,-27.5667751,152.952776),
(93,"Deagon",2,4017,-27.3299349,153.0604953),
(94,"Deebing Heights",2,4306,-27.6867653,152.7650463),
(95,"Dinmore",2,4303,-27.5950887,152.8355143),
(96,"Doolandella",2,4077,-27.6170218,152.982537),
(97,"Drewvale",2,4116,-27.6499149,153.0551353),
(98,"Durack",2,4077,-27.591662,152.985997),
(99,"Dutton Park",2,4102,-27.4962402,153.0269023),
(100,"Eagle Farm",2,4009,-27.4298168,153.0880672),
(101,"Eagleby",2,4207,-27.700935,153.2126343),
(102,"East Brisbane",2,4169,-27.4832497,153.0455745),
(103,"East Ipswich",2,4305,-27.6074796,152.7765633),
(104,"Eastern Heights",2,4305,-27.6263852,152.7735825),
(105,"Ebbw Vale",2,4304,-27.6070787,152.8252297),
(106,"Ebenezer",2,4340,-27.676307,152.6127937),
(107,"Edens Landing",2,4207,-27.7043578,153.1683889),
(108,"Eight Mile Plains",2,4113,-27.5779184,153.092299),
(109,"Elanora",2,4221,-28.126998,153.4591428),
(110,"Ellen Grove",2,4078,-27.6184661,152.9488045),
(111,"Enoggera",2,4051,-27.4222573,152.9917628),
(112,"Enoggera Reservoir",2,4520,-27.433332,152.870834),
(113,"Everton Park",2,4053,-27.4064443,152.9869559),
(114,"Fairfield",2,4103,-27.5076932,153.02402),
(115,"Ferny Grove",2,4055,-27.4034029,152.933129),
(116,"Fig Tree Pocket",2,4069,-27.5281261,152.9627018),
(117,"Fitzgibbon",2,4018,-27.3382423,153.0333049),
(118,"Flinders View",2,4305,-27.6497462,152.7828757),
(119,"Forest Lake",2,4078,-27.6228769,152.9702476),
(120,"Forestdale",2,4118,-27.6638427,153.0058597),
(121,"Fortitude Valley",2,4006,-27.4562467,153.0358184),
(122,"Gailes",2,4300,-27.61141,152.9128309),
(123,"Gaythorne",2,4051,-27.4187691,152.980154),
(124,"Geebung",2,4034,-27.3703832,153.0471643),
(125,"Goodna",2,4300,-27.6113146,152.8949144),
(126,"Goolman",2,4306,-27.7394545,152.7704676),
(127,"Gordon Park",2,4031,-27.4162777,153.026166),
(128,"Graceville",2,4075,-27.520899,152.977918),
(129,"Grange",2,4051,-27.4246675,153.0154574),
(130,"Greenslopes",2,4120,-27.5088321,153.0529626),
(131,"Gumdale",2,4154,-27.4951986,153.1583601),
(132,"Haigslea",2,4306,-27.5671015,152.632878),
(133,"Hamilton",2,4007,-27.4384043,153.0611639),
(134,"Hawthorne",2,4171,-27.4623063,153.0598051),
(135,"Heathwood",2,4110,-27.6389382,152.9874053),
(136,"Helensvale",2,4212,-27.9053051,153.3324585),
(137,"Hemmant",2,4174,-27.4505703,153.1305205),
(138,"Hendra",2,4011,-27.4182182,153.0720678),
(139,"Heritage Park",2,4118,-27.6830685,153.0598889),
(140,"Herston",2,4006,-27.4467898,153.0227913),
(141,"Highgate Hill",2,4101,-27.4876646,153.0175752),
(142,"Highland Park",2,4211,-28.011487,153.3249552),
(143,"Hillcrest",2,4118,-27.6632327,153.0272315),
(144,"Holland Park",2,4121,-27.520083,153.0729783),
(145,"Holland Park West",2,4121,-27.528196,153.0643664),
(146,"Hollywell",2,4216,-27.895707,153.3991084),
(147,"Holmview",2,4207,-27.7046254,153.1786453),
(148,"Hope Island",2,4212,-27.8651137,153.357731),
(149,"Inala",2,4077,-27.59854,152.9720075),
(150,"Indooroopilly",2,4068,-27.5014579,152.9745281),
(151,"Ipswich",2,4305,-27.6234673,152.7594638),
(152,"Ironbark",2,4306,-27.5527967,152.6707792),
(153,"Jacobs Well",2,4208,-27.781009,153.3638622),
(154,"Jamboree Heights",2,4074,-27.5574149,152.9345227),
(155,"Jeebropilly",2,4340,-27.6500042,152.6521041),
(156,"Jindalee",2,4074,-27.5336271,152.9385099),
(157,"Kairabah",2,4207,-27.8366667,153.1383333),
(158,"Kalinga",2,4030,-27.4105904,153.0459874),
(159,"Kangaroo Point",2,4169,-27.4736234,153.0364287),
(160,"Karalee",2,4306,-27.5598123,152.8235219),
(161,"Karana Downs",2,4306,-27.5377667,152.8151069),
(162,"Karawatha",2,4117,-27.632223,153.083054),
(163,"Karrabin",2,4306,-27.5988291,152.7027597),
(164,"Kedron",2,4031,-27.4051171,153.0332677),
(165,"Kelvin Grove",2,4059,-27.4494263,153.011342),
(166,"Kenmore",2,4069,-27.5160106,152.9413421),
(167,"Kenmore Hills",2,4069,-27.495594,152.9272817),
(168,"Keperra",2,4054,-27.4093318,152.9588404),
(169,"Kholo",2,4306,-27.525627,152.7636695),
(170,"Kingston",2,4114,-27.6557421,153.1196351),
(171,"Kirra",2,4872,-28.1676805,153.5295271),
(172,"Kuraby",2,4112,-27.6047543,153.0982186),
(173,"Labrador",2,4215,-27.9427642,153.3987125),
(174,"Lanefield",2,4340,-27.6558621,152.5476568),
(175,"Larapinta",2,4110,-27.640833,153.006393),
(176,"Leichhardt",2,4305,-27.6195825,152.7341268),
(177,"Logan Central",2,4114,-27.6412988,153.1072741),
(178,"Logan Reserve",2,4133,-27.7170594,153.1084184),
(179,"Loganholme",2,4129,-27.683054,153.1894379),
(180,"Loganlea",2,4131,-27.6731622,153.137161),
(181,"Lota",2,4179,-27.4679039,153.1883924),
(182,"Lower Mount Walker",2,4340,-27.7217518,152.5080802),
(183,"Luscombe",2,4207,-27.7851271,153.205604),
(184,"Lutwyche",2,4030,-27.4242082,153.030543),
(185,"Lytton",2,4178,-27.4238491,153.150806),
(186,"Macgregor",2,4109,-27.5627054,153.072007),
(187,"Mackenzie",2,4156,-27.543318,153.1248543),
(188,"Main Beach",2,4217,-27.9787768,153.4271228),
(189,"Manly",2,4179,-27.4547329,153.1849108),
(190,"Manly West",2,4179,-27.4619537,153.1692817),
(191,"Mansfield",2,4122,-27.5314948,153.1015318),
(192,"Marsden",2,4132,-27.6755473,153.103837),
(193,"McDowall",2,4053,-27.3886299,152.9967591),
(194,"Meadowbrook",2,4131,-27.6624666,153.1415558),
(195,"Mermaid Beach",2,4218,-28.0447106,153.4373204),
(196,"Mermaid Waters",2,4218,-28.0513,153.4191232),
(197,"Merrimac",2,4226,-28.0524361,153.3743615),
(198,"Miami",2,4220,-28.0680039,153.4377915),
(199,"Middle Park",2,4074,-27.5534017,152.9211696),
(200,"Milton",2,4064,-27.4700194,153.0037657),
(201,"Mitchelton",2,4053,-27.4120363,152.975009),
(202,"Moggill",2,4070,-27.5694609,152.8771525),
(203,"Molendinar",2,4214,-27.9745778,153.3754344),
(204,"Moores Pocket",2,4305,-27.5996399,152.785415),
(205,"Moorooka",2,4105,-27.5357999,153.0201543),
(206,"Morningside",2,4170,-27.4684656,153.0731165),
(207,"Mount Coot-tha",2,4066,-27.4748982,152.9533042),
(208,"Mount Crosby",2,4306,-27.5397402,152.8025353),
(209,"Mount Forbes",2,4340,-27.7106586,152.6071787),
(210,"Mount Gravatt",2,4122,-27.5419255,153.072535),
(211,"Mount Gravatt East",2,4122,-27.5326267,153.0830705),
(212,"Mount Marrow",2,4306,-27.5938045,152.6285865),
(213,"Mount Mort",2,4340,-27.7857147,152.4363172),
(214,"Mount Ommaney",2,4074,-27.5459356,152.935593),
(215,"Mount Walker West",2,4340,-27.7659624,152.4859359),
(216,"Mount Warren Park",2,4207,-27.7279847,153.2090319),
(217,"Mudgeeraba",2,4213,-28.0804969,153.3576679),
(218,"Muirlea",2,4306,-27.569042,152.7327919),
(219,"Munruben",2,4125,-27.7462512,153.0271901),
(220,"Murarrie",2,4172,-27.4609442,153.105018),
(221,"Mutdapilly",2,4307,-27.7392432,152.6612144),
(222,"Nathan",2,4111,-27.548375,153.0474942),
(223,"Nerang",2,4211,-27.9896566,153.3365942),
(224,"New Chum",2,4303,-27.6162061,152.8331737),
(225,"New Farm",2,4005,-27.4654745,153.0461335),
(226,"Newmarket",2,4051,-27.436618,153.0069688),
(227,"Newstead",2,4006,-27.4453279,153.0444763),
(228,"Newtown",2,4305,-27.6164024,152.7766828),
(229,"Norman Park",2,4170,-27.480455,153.0641069),
(230,"North Booval",2,4304,-27.5971279,152.7928802),
(231,"North Ipswich",2,4305,-27.5939016,152.7624266),
(232,"North Maclean",2,4280,-27.7768283,153.0099871),
(233,"North Tivoli",2,4305,-27.5798596,152.7889319),
(234,"Northgate",2,4013,-27.3908162,153.0693526),
(235,"Nudgee",2,4014,-27.3652168,153.0900564),
(236,"Nudgee Beach",2,4014,-27.3451285,153.1030225),
(237,"Nundah",2,4012,-27.4012298,153.0603789),
(238,"One Mile",2,4305,-27.6335168,152.7423878),
(239,"Ormeau",2,4208,-27.7740328,153.2486457),
(240,"Ormeau Hills",2,4208,-27.8009957,153.225405),
(241,"Oxenford",2,4210,-27.9015337,153.2997577),
(242,"Oxley",2,4075,-27.5564622,152.9743667),
(243,"Pacific Pines",2,4211,-27.9382489,153.3092643),
(244,"Paddington",2,4064,-27.4604626,153.0019682),
(245,"Pallara",2,4110,-27.620834,153.005005),
(246,"Palm Beach",2,4221,-28.1194259,153.4702686),
(247,"Paradise Point",2,4216,-27.8862745,153.3957227),
(248,"Park Ridge",2,4125,-27.6987848,153.0481122),
(249,"Park Ridge South",2,4125,-27.727592,153.0356009),
(250,"Parkinson",2,4115,-27.6357372,153.0300028),
(251,"Parkwood",2,4214,-27.9511525,153.3610577),
(252,"Petrie Terrace",2,4000,-27.4633447,153.0129803),
(253,"Pine Mountain",2,4306,-27.5338436,152.7222811),
(254,"Pinjarra Hills",2,4069,-27.5394651,152.899971),
(255,"Pinkenba",2,4008,-27.4221287,153.1197445),
(256,"Port of Brisbane",2,4178,-27.3823606,153.1693616),
(257,"Priestdale",2,4127,-27.6077786,153.1663818),
(258,"Pullenvale",2,4069,-27.5257099,152.8851317),
(259,"Raceview",2,4305,-27.6360785,152.7773823),
(260,"Ransome",2,4154,-27.4856896,153.1813671),
(261,"Red Hill",2,4059,-27.4545228,153.0071405),
(262,"Redbank",2,4301,-27.6037975,152.8719548),
(263,"Redbank Plains",2,4301,-27.6513182,152.8479458),
(264,"Reedy Creek",2,4227,-28.1205111,153.4032864),
(265,"Regents Park",2,4118,-27.674787,153.0428551),
(266,"Richlands",2,4077,-27.5949839,152.9538031),
(267,"Riverhills",2,4074,-27.5595729,152.9088501),
(268,"Riverview",2,4303,-27.5954905,152.8458501),
(269,"Robertson",2,4109,-27.5647285,153.0576815),
(270,"Robina",2,4226,-28.0751722,153.3913156),
(271,"Rochedale South",2,4123,-27.6009655,153.1283725),
(272,"Rocklea",2,4106,-27.5482033,153.0115871),
(273,"Runaway Bay",2,4216,-27.9122419,153.4029513),
(274,"Runcorn",2,4113,-27.5902743,153.0705615),
(275,"Sadliers Crossing",2,4305,-27.6133596,152.7464197),
(276,"Salisbury",2,4107,-27.5543181,153.0265175),
(277,"Sandgate",2,4017,-27.3206626,153.0697564),
(278,"Seven Hills",2,4170,-27.4816478,153.0755733),
(279,"Seventeen Mile Rocks",2,4073,-27.5495466,152.9579475),
(280,"Shailer Park",2,4128,-27.6524382,153.1727858),
(281,"Sherwood",2,4075,-27.530861,152.9826097),
(282,"Shorncliffe",2,4017,-27.3260995,153.08185),
(283,"Silkstone",2,4304,-27.6237049,152.7913071),
(284,"Sinnamon Park",2,4073,-27.5446662,152.947254),
(285,"Slacks Creek",2,4127,-27.6421532,153.141545),
(286,"South Brisbane",2,4101,-27.482134,153.0223507),
(287,"South Maclean",2,4280,-27.7890909,153.0106015),
(288,"South Ripley",2,4306,-27.7170573,152.8251117),
(289,"Southport",2,4215,-27.9687807,153.4066696),
(290,"Spring Hill",2,4000,-27.4614416,153.0257338),
(291,"Springfield",2,4300,-27.6540497,152.908847),
(292,"Springfield Central",2,4300,-27.6861177,152.9037832),
(293,"Springwood",2,4127,-27.6188844,153.1308699),
(294,"St Lucia",2,4067,-27.4987362,153.0081642),
(295,"Stafford",2,4053,-27.4096212,153.0138783),
(296,"Stafford Heights",2,4053,-27.3961056,153.0110337),
(297,"Stockleigh",2,4280,-27.7732857,153.0573137),
(298,"Stones Corner",2,4120,-27.499255,153.0443195),
(299,"Stretton",2,4116,-27.6126833,153.068394),
(300,"Sumner",2,4074,-27.5658793,152.9338149),
(301,"Sunnybank",2,4109,-27.5752834,153.0557235),
(302,"Sunnybank Hills",2,4109,-27.5991376,153.0486182),
(303,"Surfers Paradise",2,4217,-27.9989899,153.42398),
(304,"Swanbank",2,4306,-27.6612741,152.8241225),
(305,"Taigum",2,4018,-27.3416971,153.0483199),
(306,"Tallai",2,4213,-28.0730154,153.3330328),
(307,"Tallebudgera",2,4228,-28.1401272,153.428695),
(308,"Tallegalla",2,4340,-27.5873386,152.5549438),
(309,"Tanah Merah",2,4128,-27.6742992,153.1689858),
(310,"Taringa",2,4068,-27.4923992,152.9786001),
(311,"Tarragindi",2,4121,-27.5266462,153.0434187),
(312,"Teneriffe",2,4005,-27.4559241,153.0464425),
(313,"Tennyson",2,4105,-27.5257026,153.0017299),
(314,"Thagoona",2,4306,-27.6270411,152.6342599),
(315,"The Bluff",2,4340,-27.6147972,152.5319497),
(316,"The Gap",2,4061,-27.4454012,152.9538303),
(317,"Tingalpa",2,4173,-27.4759575,153.1283016),
(318,"Tivoli",2,4305,-27.5881374,152.7742466),
(319,"Toowong",2,4066,-27.4857407,152.9915943),
(320,"Tugun",2,4224,-28.1412253,153.4929279),
(321,"Underwood",2,4119,-27.6070295,153.1123282),
(322,"Upper Brookfield",2,4069,-27.4778049,152.868813),
(323,"Upper Coomera",2,4209,-27.8529809,153.2982761),
(324,"Upper Kedron",2,4055,-27.41768,152.9214443),
(325,"Upper Mount Gravatt",2,4122,-27.5589562,153.0815491),
(326,"Varsity Lakes",2,4227,-28.0792975,153.4143928),
(327,"Virginia",2,4014,-27.3808493,153.0645392),
(328,"Wacol",2,4076,-27.5936209,152.9283056),
(329,"Wakerley",2,4154,-27.4819726,153.1617698),
(330,"Waterford",2,4133,-27.7035157,153.1528045),
(331,"Waterford West",2,4133,-27.6910154,153.125553),
(332,"Wavell Heights",2,4012,-27.3958794,153.048943),
(333,"West Burleigh",2,4219,-28.1107626,153.4392919),
(334,"West End",2,4101,-27.4804327,153.0128302),
(335,"West Ipswich",2,4305,-27.6196145,152.7482435),
(336,"Westlake",2,4074,-27.5458126,152.9172395),
(337,"White Rock",2,4306,-27.6943743,152.8481144),
(338,"Willawong",2,4110,-27.5980978,153.005894),
(339,"Willow Vale",2,4209,-27.8417192,153.2686268),
(340,"Wilston",2,4051,-27.4335826,153.020154),
(341,"Windaroo",2,4207,-27.7444916,153.1921635),
(342,"Windsor",2,4030,-27.4378754,153.0315133),
(343,"Wishart",2,4122,-27.5514355,153.1031592),
(344,"Wolffdene",2,4207,-27.7826428,153.1726303),
(345,"Woodend",2,4305,-27.6071641,152.7524694),
(346,"Woodridge",2,4114,-27.6325507,153.104227),
(347,"Woolloongabba",2,4102,-27.4853896,153.0364488),
(348,"Wooloowin",2,4030,-27.4194368,153.0412308),
(349,"Woolshed",2,4340,-27.6053663,152.5063636),
(350,"Worongary",2,4213,-28.0360735,153.339128),
(351,"Wulkuraka",2,4305,-27.6144977,152.7273342),
(352,"Wynnum",2,4178,-27.4451042,153.1756078),
(353,"Wynnum West",2,4178,-27.4539766,153.1562022),
(354,"Yamanto",2,4305,-27.6518749,152.7446602),
(355,"Yarrabilba",2,4207,-27.8030098,153.1081584),
(356,"Yatala",2,4207,-27.7352654,153.2252177),
(357,"Yeerongpilly",2,4105,-27.5239023,153.0137075),
(358,"Yeronga",2,4104,-27.5168901,153.0143034),
(359,"Zillmere",2,4034,-27.3587634,153.0376968);