Home » Data transformation tools key to council mapping services*

Data transformation tools key to council mapping services*

By Martin Gregory, General Manager, 1Spatial Asia Pacific

Australian local governments are in a bind when deploying geospatial systems to provide better services at a lower cost. While tech savvy citizens are happy to jump online to interact with a map-based interface – whether for planning applications or to see when to put out the recycling – councils are often overstretched with maintaining existing services.

1Spatial’s recent Australian Local Government GIS Survey drew a picture of councils consumed with maintaining existing geospatial applications rather than delivering new ones. Over half of councils surveyed spent most of their time performing processes manually when managing geospatial data. Around half also said staff and skills limitations – with a similar proportion citing budget constraints – prevented them from doing more with geographic information systems (GIS) or maps to provide solutions to staff and the public.

1Spatial has worked with a number of councils facing staff, skills and budget challenges. One we recently worked with is typical of many that want to do more with mapping with less budget and staff. It has used GIS technology for over 15 years but, for the first 10 years or so, the activity was fairly siloed. Every project undertaken was approached in different ways, using different standards and storing data in different formats and places.

With smarter geospatial solutions, 1Spatial removed duplication of data, resources and effort to find new ways to do a better job. Even with fewer staff, process improvements and automation enabled the council to deliver new geospatial services. One prepares data on planning applications, with the council’s website now displaying interactive maps with current and recent historical planning information.

Change of Strategy
The key to the success of the project was choosing a data transformation tool to create new workflow processes. These synchronise and update spatial and non-spatial data between existing GIS and other systems such as financial, asset and workforce management applications. This approach – which is becoming common in Australia – involved a significant change of strategy.

When the council formed a GIS team four years ago, its remit was to remove the duplication of data, resources and effort. The team aimed to provide a unifying strategy to break down departmental data silos. It formed a long term plan to consolidate all geospatial data into a single, authoritative SQL Server database.

Planning for the data migration, the council purchased Safe Software’s FME from 1Spatial. When a restructure reduced its headcount, the GIS team further explored FME’s capabilities and decided to replace the council’s older processes as a less labour intensive, short term option. As a result, the team developed more than 100 new, automated processes using FME. The software populates data into mapping systems, audits data quality, transforms and geocodes data, and retrieves new data from the web. Joining up data from different sources – using FME to transform it so that it is synchronised and not duplicated – has effectively dissolved departmental barriers. Users now have the spatial data they require to support decisions, without the organisational effort of finding it and negotiating its use.

Locating Assets
Agile transformation tools that build upon existing systems, rather than consolidating data into a new and more expensive one, have also assisted a Victorian council in deploying new map-based services. Working with 1Spatial, the council developed a single, common mapping platform using foundational data from Vicmap API, including aerial imagery, road layouts, cadastral information, land contours, vegetation density, planning zones and public facilities.

On top of this, it layered local information such as refuse collection zones (when will my bin be emptied next if I live here?) from a combination of spatial and corporate databases, including many that are not “spatially aware”. For example, assets like bridges and footpaths are linked by asset IDs to map locations where users can see information like length, width and composition.

For council users, an animal registration layer can geographically display 17,000 registered pets. If a stray dog is found, rangers can use the system to search the vicinity by breed or colour to try and locate the owner. If a local resident contacts council, staff can use the system to more easily reunite pet and owner without the need for a ranger visit.

Thousands of councils worldwide are using one of the FME Editions available to maximise their existing investments in systems and data with new workflows for reading, integration, transformation, improvement and writing data between more than 335 spatial and non-spatial formats. These FME processes can be easily chained together, automated or scheduled to reduce the manual effort required to manage data and enable citizens and staff to use published information whenever and however they need it.

For more information visit 1spatial.com/au/
*Copy supplied by 1Spatial

Digital Editions


More News

  • Three small changes making big differences in grand programs

    Three small changes making big differences in grand programs

    Local government grant programs are designed to create community impact. Yet for many councils, the effectiveness of those programs is shaped less by intent and more by the processes that…

  • Alice skating program a success

    Alice skating program a success

    Free ice skating, packed programs and smiling faces have marked the end of a hugely successful school holiday program delivered through a partnership between Alice Springs Town Council, the Northern…

  • Supporting Waverley

    Supporting Waverley

    Councils across NSW are being encouraged to continue to provide direct support for the Waverley community in the wake of December’s devastating terrorist attack at Bondi. In the aftermath of…

  • New deputy for Liverpool

    New deputy for Liverpool

    Councillor Peter Harle has been elected Deputy Mayor of Liverpool City Council following the resignation of Cllr Dr Betty Green. Councillor Harle, who has served the office in the past,…

  • Erosion reef wins awards

    Erosion reef wins awards

    A West Australian-first coastal erosion research reef installed off C.Y. O’Connor Beach in 2022, reducing wave height and energy and blossoming into a thriving habitat, took out the 2025 WA…

  • More rehabilitation works for Coffs

    More rehabilitation works for Coffs

    Scores of local flood-damaged roads will be improved after the City of Coffs Harbour determined to expand rehabilitation works. An initial program of stabilisation works had already been approved for…

  • First-class Pump Track opens in Ballina

    First-class Pump Track opens in Ballina

    Ballina Shire Council is thrilled to announce the completion of the new Ballina Pump Track at Kingsford Smith Reserve in the heart of Ballina. Designed to national competition standards, the…

  • Fraser Coast support announced

    Fraser Coast support announced

    Fraser Coast Regional Council has renewed and expanded its support for three key emergency services – the Royal Flying Doctor Service (RFDS), LifeFlight, and local Rural Fire Brigades. At their…

  • Council named among Australia’s most inclusive employers

    Council named among Australia’s most inclusive employers

    Lake Macquarie City Council has become one of only two local government organisations in Australia included in a benchmark list of inclusive employers. The Diversity Council of Australia (DCA) added…

  • New deputy in Griffith

    New deputy in Griffith

    Griffith City Council has elected Councillor Scott Groat as the new Deputy Mayor at the Ordinary Council Meeting held on Tuesday, 28 October 2025. Cr Groat will hold the position…