automation of fraser coast regional council's mapping systems using exponare
DESCRIPTION
David Broadstock, GIS Technician at Fraser Coast Regional Council presents 'Automation of Council Mapping Systems using Exponare' at MapInfo Forum 2014 in Brisbane. http://www.mapinfo.com/TRANSCRIPT
MapInfo Forums 2014Automation of Council Mapping
Systems using ExponareDavid Broadstock – Senior GIS Technician
Fraser Coast Regional Council
2 MapInfo Forums 2014
Fraser Coast Regional Council Located between Gympie Regional Council & Bundaberg
Regional Council
Total area of 8,010 sq km, or 0.4% of the total area of Queensland
Population of 100,784 (2014), estimated at 144,833 by 2036
Famous for easy access to Fraser Island, Whale Watching in
Hervey Bay, creator of Mary Poppins birthplace (Maryborough)
3 MapInfo Forums 2014
Site Overview
Exponare Enquiry 5.6
MapInfo Professional 12.0
4 MapInfo Forums 2014
Resolves customer complaints quickly &
allows admin & truck staff to focus on
other tasks
Example:
Waste Report Automation with Exponare
Main reasons why bins weren’t being picked up:
1 The customer forgot to put it out
2 No access dues to trees
3 Rubbish contaminated
Customers reporting rubbish
collection trucks not picking up bins
5 MapInfo Forums 2014
Solution
Truck Drivers drop marks with a GPS at
households that have not put their bin out
or had a waste issue e.g. contaminated rubbish in
green waste etc.
The GPS marks are downloaded at the
base and emailed to our Exponare
System
Customer Service then review the marks
when customers call to complain
They are also provided with a visual
display of the issue including a report
from the driver
6 MapInfo Forums 2014
Consequences of GIS Solution
HOW COUNCIL BENEFITS
SAVES:
Numerous phone calls per week to Cleanaway to see
why a bin was missed
SAVES:
Council staff visiting residents to resolve
waste collection complaints
SAVES:
Rubbish truck making extra trips to
resident’s homes to re-collect bins
ENSURES:
Customer service can quickly deal with any
waste collection complaints
ENSURES:
Efficient waste management
knowing what issues were encountered
each week
$$ SAVED:
Large amounts of staff time and money
saved every week
7 MapInfo Forums 2014
Waste Reporting – Fast tracked direct from trucks
Mapped
point
for location
Extra Info on
reporting
8 MapInfo Forums 2014
Tracking, CSV
(Automated Responses)
9 MapInfo Forums 2014
Windows Server
Picks up from MapXtreme
Full use of spatial commands that can be
recorded in MapInfo to
produce quick and
easy scripts
Used to refresh
Assetic
10 MapInfo Forums 2014
Windows Server
FTP
UDP-TCP
SCRIPTING
CONVERSION OF FORMATS
11 MapInfo Forums 2014
Windows Server
Allows modification and
complex queries of TAB files
Allows real time modification
of TAB files while Exponare
is accessing the same TAB
files
Automation of Dial Before
You Dig requests
12 MapInfo Forums 2014
Questions?