hinds89
commented
8 years ago Here's the list of projects with multiple locations (with some as blank), these are the ones to look at:
| project_number | project_name | locs-for-proj |
|---|---|---|
| C980909 | Australia Business Academy Stage 2 | 4 |
| B950204 | Project Bushranger | 3 |
| Shane Thompson McDuff House | McDuff House | 4 |
| Shane Thompson McDuff House | McDuff House | 4 |
| Shane Thompson McDuff House | McDuff House | 4 |
| Shane Thompson McDuff House | McDuff House | 4 |
| M0709003 | Puckapunyal Redevelopment Stage 2 | 4 |
| M0709003 | Puckapunyal Redevelopment Stage 2 | 4 |
| M0709003 | Puckapunyal Redevelopment Stage 2 | 4 |
| B701207 | University of Queensland, Gatton Campus, Meat Technology | 4 |
| Shane Thompson Andersons Real Estate Office Building | Andersons Office Building | 4 |
| Shane Thompson Andersons Real Estate Office Building | Andersons Office Building | 4 |
| Shane Thompson Andersons Real Estate Office Building | Andersons Office Building | 4 |
| Shane Thompson Andersons Real Estate Office Building | Andersons Office Building | 4 |
| Shane Thompson Hse Chandler | Thompson House, Chandler | 4 |
| Shane Thompson Hse Chandler | Thompson House, Chandler | 4 |
| Shane Thompson Hse Chandler | Thompson House, Chandler | 4 |
| Shane Thompson Hse Chandler | Thompson House, Chandler | 4 |
| B1205003 | Mater Children's Refurbishment | 4 |
| B920503 | University of Queensland, Gatton Campus, Administration Annexe | 4 |
| M980352 | Berwick Hospital | 4 |
| Shane Thompson Droney Hse | Droney House | 4 |
| Shane Thompson Droney Hse | Droney House | 4 |
| Shane Thompson Droney Hse | Droney House | 4 |
| Shane Thompson Droney Hse | Droney House | 4 |
| B1334 | University of Queensland, Gatton Campus, Food Technology | 4 |
| B1334 | University of Queensland, Gatton Campus, Food Technology | 4 |
| B940404 | Brunswick Street Mall | 4 |
| B940404 | Brunswick Street Mall | 4 |
| C960701 | 111 Alinga Street Fitout, Level 5E - Fitout for a Division of the Department of Administrative Services (DAS) | 4 |
| C960701 | 111 Alinga Street Fitout, Level 5E - Fitout for a Division of the Department of Administrative Services (DAS) | 4 |
| C960701 | 111 Alinga Street Fitout, Level 5E - Fitout for a Division of the Department of Administrative Services (DAS) | 4 |
| P--9510 | RMIT Bundoora Campus Building 220 | 4 |
| B960201 | Elizabeth Street Retail Refurbishment | 4 |
| B030207 | Mater Potter & VIP Suite | 4 |
| B030207 | Mater Potter & VIP Suite | 4 |
| Shane Thompson Bidwell Harper House | Bidwell/Harper House | 4 |
| Shane Thompson Bidwell Harper House | Bidwell/Harper House | 4 |
| Shane Thompson Bidwell Harper House | Bidwell/Harper House | 4 |
| Shane Thompson Bidwell Harper House | Bidwell/Harper House | 4 |
| Shane Thompson Skippen Hse | Skippen House | 4 |
| Shane Thompson Skippen Hse | Skippen House | 4 |
| Shane Thompson Skippen Hse | Skippen House | 4 |
| Shane Thompson Skippen Hse | Skippen House | 4 |
| S940511 | Knox Grammar School Paterson Business Studies Centre | 4 |
| Shane Thompson McCann Hse | McCann House | 4 |
| Shane Thompson McCann Hse | McCann House | 4 |
| Shane Thompson McCann Hse | McCann House | 4 |
| Shane Thompson McCann Hse | McCann House | 4 |
| B1311008 | Newcastle Airport Masterplan | 4 |
| B1311008 | Newcastle Airport Masterplan | 4 |
| B1311008 | Newcastle Airport Masterplan | 4 |
| B1311008 | Newcastle Airport Masterplan | 4 |
| S050965 | The University of New South Wales, ASIA Singapore Campus Masterplan and Library | 4 |
| S010123 | Campus MLC, Level 2 | 4 |
| S010123 | Campus MLC, Level 2 | 4 |
| B961002 | Hyatt Regency Resort Coolum - Advanced Management Centre | 4 |
| B1308001 | Blue Tower Refurbishment Strategy | 4 |
| B1308001 | Blue Tower Refurbishment Strategy | 4 |
| B1308001 | Blue Tower Refurbishment Strategy | 4 |
| B1308001 | Blue Tower Refurbishment Strategy | 4 |
| B861203 | Queensland Police Museum | 4 |
| B861203 | Queensland Police Museum | 4 |
| B861203 | Queensland Police Museum | 4 |
| B861203 | Queensland Police Museum | 4 |
| P Acoustic Barriers | Acoustic Barriers, Eastern Freeway, Melbourne | 4 |
| P Acoustic Barriers | Acoustic Barriers, Eastern Freeway, Melbourne | 4 |
| P Acoustic Barriers | Acoustic Barriers, Eastern Freeway, Melbourne | 4 |
| P Acoustic Barriers | Acoustic Barriers, Eastern Freeway, Melbourne | 4 |
| B861203 | Queensland Police Headquarters, Forensic Laboratories | 4 |
| B861203 | Queensland Police Headquarters, Forensic Laboratories | 4 |
| B861203 | Queensland Police Headquarters, Forensic Laboratories | 4 |
| B861203 | Queensland Police Headquarters, Forensic Laboratories | 4 |
| BL9830B | Ballymore Redevelopment Stage 5 | 4 |
| B1004006 | Santos Field Offices | 4 |
| B1004006 | Santos Field Offices | 4 |
| B1210082 | The Chambers (National Australia Bank Redevelopment) (NAB) (Donovan Hill) | 4 |
| B1210082 | The Chambers (National Australia Bank Redevelopment) (NAB) (Donovan Hill) | 4 |
| B1210082 | The Chambers (National Australia Bank Redevelopment) (NAB) (Donovan Hill) | 4 |
| B1210082 | The Chambers (National Australia Bank Redevelopment) (NAB) (Donovan Hill) | 4 |
| B060373 | Bundaberg Airport | 4 |
| B060373 | Bundaberg Airport | 4 |
| B060373 | Bundaberg Airport | 4 |
| B060373 | Bundaberg Airport | 4 |
| B961002 | Hyatt Regency Coolum Resort - Mt Coolum Room | 4 |
| B1211507 | Aldoga Mining Village | 4 |
| B1211507 | Aldoga Mining Village | 4 |
| B1211507 | Aldoga Mining Village | 4 |
| B1211507 | Aldoga Mining Village | 4 |
| B1210089 | North Gheran Masterplan | 4 |
| B1210089 | North Gheran Masterplan | 4 |
| B1210089 | North Gheran Masterplan | 4 |
| B1210089 | North Gheran Masterplan | 4 |
| S011005 | Volos Stadium | 4 |
| S011005 | Volos Stadium | 4 |
| S011005 | Volos Stadium | 4 |
| B1210002 | Virgin DTB Masterplan | 4 |
| B1210002 | Virgin DTB Masterplan | 4 |
| B1210002 | Virgin DTB Masterplan | 4 |
| B1210002 | Virgin DTB Masterplan | 4 |
| M930901 | Australian Centre for the Moving Image (Project) | 4 |
| LN Noarlunga Health Village | Noarlunga Health Village | 4 |
| LN Noarlunga Health Village | Noarlunga Health Village | 4 |
| LN Noarlunga Health Village | Noarlunga Health Village | 4 |
| LN Noarlunga Health Village | Noarlunga Health Village | 4 |
| B840608 | World Expo '88 Monorail Stations | 4 |
| B840608 | World Expo '88 Monorail Stations | 4 |
| B840608 | World Expo '88 Monorail Stations | 4 |
| B840608 | World Expo '88 Monorail Stations | 4 |
| S020708 | Sydney Opera House Forecourt Performance Space | 4 |
| B900307 | Peter Ahern & Associates Office Building | 4 |
| B900307 | Peter Ahern & Associates Office Building | 4 |
| S0809004 GarranPrimary | Garran Primary School, Women's and Children's Hospital Project | 4 |
| S0809004 GarranPrimary | Garran Primary School, Women's and Children's Hospital Project | 4 |
| S0809004 GarranPrimary | Garran Primary School, Women's and Children's Hospital Project | 4 |
| S0809004 GarranPrimary | Garran Primary School, Women's and Children's Hospital Project | 4 |
| M9208 | Melton Aquatic Centre | 4 |
| B840608 | World Expo '88 Pavilions | 4 |
| B840608 | World Expo '88 Pavilions | 4 |
| B840608 | World Expo '88 Pavilions | 4 |
| B840608 | World Expo '88 Pavilions | 4 |
| B960408 | Telstra Toilets and Tea Room Refurbishment | 4 |
| B960408 | Telstra Toilets and Tea Room Refurbishment | 4 |
| B960408 | Telstra Toilets and Tea Room Refurbishment | 4 |
| B960408 | Telstra Toilets and Tea Room Refurbishment | 4 |
| C960407 | Australian Business Academy Stage 1 | 4 |
| B0705009 | Noosa Springs House | 4 |
| B0705009 | Noosa Springs House | 4 |
| B1003005 | DVA Townsville Fitout | 4 |
| B1401001 | Kurilpa Riverfront Renewal Master Plan | 4 |
| B1401001 | Kurilpa Riverfront Renewal Master Plan | 4 |
| B1401001 | Kurilpa Riverfront Renewal Master Plan | 4 |
| B1202007 | Satellite Infill and Regional Lounge for Virgin Australia - Domestic Terminal Brisbane (BAC Virgin Satellite Infill) | 4 |
| B1202007 | Satellite Infill and Regional Lounge for Virgin Australia - Domestic Terminal Brisbane (BAC Virgin Satellite Infill) | 4 |
| B1202007 | Satellite Infill and Regional Lounge for Virgin Australia - Domestic Terminal Brisbane (BAC Virgin Satellite Infill) | 4 |
| B1202007 | Satellite Infill and Regional Lounge for Virgin Australia - Domestic Terminal Brisbane (BAC Virgin Satellite Infill) | 4 |
| C970717 | Department of Environment, Sport and Territories | 4 |
| S980415 | Campus MLC Interior Fitout | 4 |
| B910801 | Brisbane Convention & Exhibition Centre | 4 |
| B850603 | Bald Hills Hospital | 4 |
| B850603 | Bald Hills Hospital | 4 |
| C990511 | CRS Australia | 4 |
| B1010503 | University of Queensland (UQ) Business School Competition | 4 |
| M1101502 | Ballarat Civic Centre | 4 |
| B1211004 | QIC Building Study | 4 |
| B1211004 | QIC Building Study | 4 |
| B1211004 | QIC Building Study | 4 |
| B1211004 | QIC Building Study | 4 |
| B900804 | University of Queensland, Gatton Campus, Pesticide and Hazardous Chemicals Store | 4 |
| B050752 | Coolum Beach Design Competition | 4 |
| B050752 | Coolum Beach Design Competition | 4 |
| B050752 | Coolum Beach Design Competition | 4 |
| C990703 | Canberra Institute of Technology, Faculty of Design | 4 |
| B050107 | BCC Typology & Modelling Consultancy | 4 |
| B050107 | BCC Typology & Modelling Consultancy | 4 |
| B041018 | Simpsons Rd Housing | 4 |
| B041018 | Simpsons Rd Housing | 4 |
| B041018 | Simpsons Rd Housing | 4 |
| S000553 | Fairfield Hospital | 4 |
| B930102 | Thursday Island Hospital Masterplan | 4 |
| B000401 | KingsHeath Seaside Village | 3 |
| B000401 | KingsHeath Seaside Village | 3 |
| B020202 | Mater Mother's Soft Refurbishment | 4 |
| S031004 | Shankar Chapman Portsea House | 4 |
| S031004 | Shankar Chapman Portsea House | 4 |
| S031004 | Shankar Chapman Portsea House | 4 |
| S031004 | Shankar Chapman Portsea House | 4 |
| B0907007 | BGS Office Relocation | 2 |
| B1302012 | New Lift installation to Gate 75 - International Terminal Brisbane (Gate 87) | 4 |
| B1302012 | New Lift installation to Gate 75 - International Terminal Brisbane (Gate 87) | 4 |
| B1302012 | New Lift installation to Gate 75 - International Terminal Brisbane (Gate 87) | 4 |
| B1302012 | New Lift installation to Gate 75 - International Terminal Brisbane (Gate 87) | 4 |
| B1308002 | Mater Pathology Redevelopment | 2 |
| B050913 | The Rec Club at Ridges | 5 |
| B051007 | Lavarack Barracks 3CER & 4REGT Precincts (Lavarack Barracks Redevelopment Stage 4) | 5 |
| Shane Thompson Carbines Hse | Carbines House | 4 |
| Shane Thompson Carbines Hse | Carbines House | 4 |
| Shane Thompson Carbines Hse | Carbines House | 4 |
| Shane Thompson Carbines Hse | Carbines House | 4 |
| B1275 | University of Queensland, Gatton Campus, Biological Sciences | 4 |
| B980912 | Darwin Domestic and International Airport Upgrade | 4 |
| Shane Thompson Hse Teneriffe | Thompson House, Teneriffe | 4 |
| Shane Thompson Hse Teneriffe | Thompson House, Teneriffe | 4 |
| Shane Thompson Hse Teneriffe | Thompson House, Teneriffe | 4 |
| Shane Thompson Hse Teneriffe | Thompson House, Teneriffe | 4 |
| B1203001 | Mater Day Oncology | 4 |
| B1210049 | Nielson Property Fitout (Donovan Hill) | 4 |
| G_Architecture Studios | Architecture Studios, University of Newcastle | 4 |
| G_Architecture Studios | Architecture Studios, University of Newcastle | 4 |
| G_Architecture Studios | Architecture Studios, University of Newcastle | 4 |
There are 287 projects, with a total of 395 addresses/lat-lon completely blank (more than one per project for some projects). I have listed these below.
Each project needs to have at least one location, even if blank. So, only delete blank addresses if there are multiple of them for the same project.