Database and Technical Information

The full file contains 15,263 rows of data (excluding the column headers). Each row uses the following field structure:

FieldField nameFormatExample
1idINTEGER11143
2nameVARCHAR (39)Quindalup
3local_government_areaVARCHAR (27)Busselton
4stateVARCHAR (3)WA
5postcodeCHAR(4)6281
6latitudeDECIMAL (8,5)-33.62875
7longitudeDECIMAL (8,5)115.12484
8categoryVARCHAR (40)Suburb (of Dunsborough)
9typeVARCHAR (40)Bounded
10populationINTEGER1105
11area_sqkmDECIMAL (8,2)52.85
12time_zoneVARCHAR (21)Australia/Perth