Data Story
Data Processing
Rec Area Data
LGA Data
We’ve used data from the Queensland Government to source potential locations of the microfarms. We used a vectorised spatial dataset about local government area boundaries and converted it into coordinates using QGIS. We’ve then used a second vectorised spatial dataset about every recreational area in the state. From this recreational area data set, we've kept only the parks and botanical gardens. We’ve then combined the information in both datasets to classify every park in Queensland into its local government area. We've then removed parks and local government areas that are rural or reigonal. Then, we've used a notebook to collate the parks available in each LGA that can be a potential community microfarm.
This is just the beginning of this data-based solution. If we had more time, we would've used more data to find out exactly which parks were more suitable for community garden than others. e.g. a large park with dwindling visitor numbers would be a good candidate for a potential microfarm. Likewise, census time series profiles could be used to track which lgas have the largest increases in high density apartments etc. This would identify a populace without backyards that required community gardens more than other LGAs with plenty of single-unit housing.
Raw Data Analysis
- Rec Area Raw Data
Raw Spatial Data from Queensland Government about all recreational areas in Queensland
- LGA Raw Data
Raw Spatial Data from Queensland Government about local government areas in Queensland
- Consumer Price Index (CPI) and wages
- In this file, exploratory data analysis was conducted to find a correlation between wage growth and the CPI for Fruit and Vegetables. Using the * ABS data, no immediate correlation was found between the two variables. However, the CPI experiences significantly greater swings in price than t
- WPI. Finally, it can be seen that the WPI growth is slowing down, highlighting the need for sustainable and cheap access to fresh produce.
- Parks and LGAs
- Processed Spatial Data
vals.csv
is processed spatial data of the recreational areas into (x,y) coordinates.
vertex4.csv
is processed spatial data of LGA boundaries into (x,y) coordinates. The processing was completed by extracting vertices in QGIS.