Life after Google Fusion Tables
In 2009 Google launched Fusion Tables, a web service for visualising and sharing large amounts of tabular data, particularly with spatial content. Many saw it as Google’s attempt to enter the “serious” GIS market occupied by companies like ESRI with ArcGIS. Google announced that they would “retire” the service on 3rd December 2019. Fusion Tables had always been labelled as “experimental” or beta. Following their "retirement" in 2019, March 2020 was set as the date when data held within Fusion Tables would be - in Google's own words - be "permanently and irrevocably deleted".
Now Fusion Tables are a thing of the past, but what if you have exported data that was previously held in them, or are looking for a comparable solution?
These are the alternatives that Google suggested:
- CloudSQL - managed cloud SQL databases (mySQL, PostGres)
- Sheets - familiar spreadsheets, like Excel, supports charting and can be a source of data for Data Studio
- Data Studio - BI tool for mashing up data from several sources and producing dashboards and visualisations
- BigQuery (GIS) - also beta, for data analytics and machine learning
Google have also hinted at new map visualisation tools on the horizon.
If you are feeling a little overwhelmed at this point then you have every right to be. Google have a history of withdrawing experimental products and those with little take up. Their philosophy of “throw things at the wall and see what sticks” is successful (for now) but is of no help for companies wondering where to place investment in development. Apart from Sheets and light usage of the other tools, the solutions above also require significant investment - learning how they fit together, administration tools, training, as well as financial. Google are aiming to provide a suite of tools for the larger organisation but small to medium companies often require something more “immediate”, low-investment, and low-risk.
If you have already committed resources to Fusion tables and are wondering “what next?”, contact us - we will be happy to help. One direct alternative to Fusion tables is MapVision, our online mapping platform. It offers a lot of shared functionality including the ability to:
- Import your location data and geocode postcodes
- Use map layers to build a map stack
- Share your results with colleagues
We appreciate that many organisations can’t afford a dedicated GIS or mapping specialist, so MapVision is designed to be intuitive. Anyone can access this tool set and use it without the need for formal training, a powerful PC or a local software installation. MapVision users don’t have to be a GIS expert to enjoy the benefits of geographical intelligence and enhanced business insight.
We have 25 years of mapping and data experience. We are also agile enough to do bespoke work affordably for our clients. We can undertake data mapping and presentation on your behalf. Find out more...
Our other blogs
How far is it to the beach
We use Beacon Dodsworth's scripting technology to answer that most important of questions when the sun finally does threaten an appearance.
Cycle to work day
Each year for #cycletoworkday we take a look at cycling statistics across the country and try to map that data and find interesting trends. This is mainly because we at Beacon Dodsworth are either a little bit obsessed about cycling, or we tend to worry about the environment.
Postcode to postcode drive time and distance
What happens if we want a postcode to postcode drive time lookup table?
The new normal for the GIS world
Toby, our Account Manager, looks at the changes to working style and client needs in the geodata industry following the COVID-19 outbreak.
Geodemographics and the University of East London
The University of East London explain how they have been using our P² People & Places geodemographic classification.
How to back up your Prospex data
Keep your GIS projects safe by using the in-built Prospex back up process. Here is how.
What is geodemographic profiling?
More than 64 million people live in the UK, each with their own outlook, priorities, needs and way of life. Geodemographic profiling offers a way to group these individuals to try and identify the right audience for your product or service.
Data visualisation and colour blindness
John, our director talks about living and working with colour blindness in the mapping industry where colours are pivotal in adding dimensions to people's understanding.
What has the census ever done for us?
How Census 2011 can be used to help organisations with demographic analysis.
All you need to know about postcodes but were afraid to ask
The humble postcode has been around for years. We look at how postcodes are used and what led to their introduction.
Who spends most on Fruit and Veg
National Vegetarian Week (#NationalVegetarianWeek) this year runs from 11th to 17th May. What better opportunity to highlight how GIS mapping can be used to create marketing campaigns and raise awareness of the benefits of eating more fruit and veg.
Google Fusion Tables
After almost 10 years of service, Google retired their Fusion Tables product at the end of 2019. This tool was very useful at visualising and sharing large amounts of tabular data - particularly amongst small and mid-sized businesses. So what can we do to fill the gap left by this tool?
As a Yorkshire-based company, we wanted to help celebrate Yorkshire Day, which takes place on 1st August. Naturally, we wanted to put a geographic spin on the celebration, so we took a look at drinking preferences within God’s own county.
Mapping GP prescription data
An article by Allan Brimicombe (Head of Centre for Geo-Information Studies at the University of East London) & Pat Mungroo on using GP prescription data to understand health needs.
Administrative geography is a way of dividing the country into smaller sub-divisions or areas that correspond with the area of responsibility of local authorities and government bodies. It provides an alternative to postcode geography but because it tends not to be used by consumers, it is often overlooked. We take a look at administrative geography, what it is and how to use it.
Mapping for local projects
Recently, we were contacted by a company responsible for organising charity door knockers. They needed more than 9,000 postcode sectors mapped at A4 size to pass to ground staff showing street level detail. This would enable them to use maps at a local level to plan fundraising routes and clearly define territories for each agent.
The foundations of geographical analysis
Displaying data on maps makes it easier to understand as well as giving a new perspective on a problem. Using a GIS to prepare and present data has become increasingly popular over the last 20 years, but graphical displays of data on maps were around long before computers came along.
Social change over 10 years
The next census isn’t due to take place until 2021 so we thought it was a good time to take stock of some of the changes and trends we noticed between the 2001 and the 2011 census. What difference does 10 years make to our society and the people that live within it?
Using geographic intelligence to grow the UK’s broadband network
Using geographic intelligence to sustainably grow the UK’s broadband network.
The power of postcode sectors
Postcode sectors are aggregations of individual postcodes and they provide meaningful geographical reporting areas in any GIS. However, they aren't as easy to map as you might think. Here is how we do it.
Living Costs and Food Survey
The Living Costs and Food survey (LCF) is compiled every year and is used by the UK and European governments, Department for Transport (DfT), and Her Majesty’s Revenue and the Customs (HMRC). But what is it, and why should we care?
Where is the North
We've used the territory manager tool in Prospex GIS to split the UK into north, south and east and west with equal population counts.
What is GIS software?
A Geographical Information System (GIS), is a tool for analysing, visualising, managing and presenting data that is related to a physical, geographical location. That link to geography is the key difference between GIS and other data visualisation techniques.
Your continued use of this site is taken as implied consent to receive cookies from us and our analytics partners.