Exploration of Potential Solution

Exploration of Potential Solution

1. Bike Rack Locations & Tracks and Trails

   • Positives
     • Compatible topics
       • Both tables are design more the potential use of bike
     • Data allows both to be placed on a map
       • Each table data locations, this will allow t to b displayed on a map. This will make it an easy to follow display
         • g. Latitude & Longitude
         • Instead of a table format
     • encourages physicial activity
       • It helps people to find a new location to ride their bike
         • If more people ride their bikes, less people will drive
           • good for the enviroment
   • Negatives
     • Bike only solution
       • By adding the bike rack aspect to the trail and tracks dataset. It removes the potential for the user to search for walking path
     • Don't use the same location data
       • Bike racks uses Latitude & Longitude
       • Trails and track uses SAP_FUNCTIONAL_LOCATION
         • Makes it more difficult to place both on a map

2. Community Gardens Locations & Weed Identification

   • Positives
     • Topics are compatible
       • Weeds and gardens are within the same theme/Topic
         • App combination makes sense
           • This means that there is a definitely an audience for this product
     • No requirement for foreign keys between tables
       • Although compatible ideas, there is no need to link the tables as they are seperate parts of the app
         • Therefore each table will respond to a different part of the app
     • Increase community garden usage
       • If the BCC introduced this app (with advertising) more people would become aware of communiy gardens
         • App helps them find different location
     • Help limit the spread of unwanted weeds
       • Column 'Notifiable' will tell users if the plant they have found requires BCC notification
         • Through the app the BCC will be notified of the weeds and the locations
   • Negatives
     • Weeds based
       • Means focus of plants that look like weeds and real weeds
         • Instead of all plants, which would also be extremely helpful for a community gardens app
     • Only 56 community gardens recorded within the whole BCC
       • Small target audience
         • Application could help to increases the audience

3. Bus Stop & Libraries Locations

   • Negatives
     • Could be done with something like google maps
       • Google maps would also give direction
       • Google maps would give an eta
     • Not all libraries have bus stops
       • Means that not all bus stops can be apart of the app
     • Not a large audience
       • Not everyone wants to go the the library
       • Most people have a car
     • Does not give a bus number to get there
       • User would have to direct themselves
       • Does not give the frequency of bus that arrive there
   • Positives
     • Libraries often have a bus stop
       • Often on a main line
         • eg State Library
         • eg. Garden City library
     • Encourages the use of busses
       • Less individual travel
         • Better for the enviroment
       • More income for the BCC
     • Could help slow the dying use of libraries
       • Less and less people are using libraries due to:
         • eBooks
         • audioBooks
         • Less reading in genral

4. Events locations & Bus Stop Locations

   • Positives
     • Large target audience
       • Most people are happy to catch public transport to big events
         • Especially if the transport is free
           • Currently sporting events have free transport provided by the BCC
       • Events would want to be apart of the app
         • Helps the events to reach to a ranch of people
     • Most big events have Bus stops
       • Larges events are help a big events will practiced bus stops and servives
         • Eg. The Gabba
         • Eg. Suncorp Stadium
         • Eg. QPAC
     • Help prorent drink driving
       • Big events often have alchol
         • This application would help them so that they don't end up driving home
         • Safer roads
         • Could be apart of the no drink driving campaign
           • Funding for app could come from there
     • Encourages the use of busses
       • More income for the BCC
       • Less individual travel
         • Better for the enviroment
   • Negatives
     • No direction, just bus stop location
       • Google maps could do the same thing, but with directions

5. Free Native Plant & Community Garden Locations

   • Positives
     • Overlapping topics/themes
       • Both garden theme
         • Therefore help to grow the environmental community of Brisbane
     • appropriate for map use
       • Both tables have longitude and latitude
         • easily applied to a map
       • Both tables have addresses
         • Easily be applied to a map
         • Helpful if user is trying to locate garden/nursery
     • Fixed data sets
       • Nature of the data sets does not require updating due to changes
         • Allows for little to none admin interaction
     • Solves a current problem within the BCC
       • Helps to grow awareness for the Free Native Plant Program
         • Currently little awareness
     • Clear market and target audience
       • Target Audience
         • Can focus towards currently users of community gardens
         • Could be used to introduce more of the elderly to gardening
       • Market
         • Currently very difficult to find information about the Free Native Plant Program
         • Due to the clear target audience and lack of solution there is clearly a market
   • Negatives
     • Poor Table constraints and design
       • No Foreign Keys between tables
         • Difficult to make direct links between tables using data
       • No Primary Key in either table
         • No unique identifier
       • Empty cells and columns
         • Difficult to use information if it is not there for every record
           • Can be fixed during data cleaning

6. Bike Rack Locations & Bus Stop Locations

   • Positives
     • Helps to lessen the amount of cars on the road
       • Promotes riding a bike to a bus stop and then catching the bus
     • Easily placed on a map
   • Negatives
     • Most major bus stop already have easy to access bike racks
       • Therefore this app is only help for finding bike racks at small bus stops
         • Often not many bike racks on the streets
     • Only a very small audience of people
       • Although the app would help to eliminate some traffic on the roads, most people will still drive