OCStoyanov
  • Blog
  • Photography
    • Galleries
      • Along the way
      • Caves
      • Landscape
      • Macro
      • Nature
      • Reportedly
    • +
      • Google+
      • Frickr
      • 500px
    • Photo walks
      • Light and cult
      • Trashscape Project
      • Beglika and Chatama
      • Crete
  • Outdoor
    • Adventure
      • EVKM
      • #ExploreCrete
      • Boyana (eco) path Project
    • Good Idea!
      • Sofia City Escape
      • Kids camps and Team Buildings
      • For Relax
      • Welcome to Sofia
    • Activities
      • Caving
      • Climbing
      • Cycling
      • Cycling Touring
      • Kayaking and Rafting
      • Winter activities
    • Hike
      • Ecotrails
      • Marked and excursion trails
      • Multy-day trails
      • Thematic trails
  • Advice
    • Карта TopoBulgaria
    • Tips and tricks
      • Good to know
      • First aid
      • Equipment
      • Survivor and bushcraft
      • About Food
      • Orienting
    • Guide
      • Camping and nice places for tent in Bulgaria
      • Friendly world map
  • Work
    • Work Files
      • GIS
      • Various statistics
      • Interesting maps
      • Internet maps
      • Touristic maps
      • Print maps
    • Useful Maps
      • Tourist map of Bulgaria
      • Карта TopoBulgaria
    • Portfolio
      • Graphic design
      • Web design
      • Maps
    • Projects
      • Scheme of public transport in Sofia
      • Bulgaria of the early 20th century
      • Detailed GIS on Caves zoning in Bulgaria
      • GIS of the basic morphographic units in the Physiological Geographic Regions in Bulgaria
      • Vintage style maps
      • Maps of the world
  • Download
    • Icons and symbols for web and print maps
      • Classic signs and icons for tourist maps
      • Icons for outdoors and tourism
      • Pin icons for outdoors and tourism
    • More
      • PDF and e-books
      • Die drawing
      • For kids
  • Bulgarian
Internet integration of maps

Fusion Tables is retiring. And what to do with all these tables now?

Fusion Tables is retiring. And what to do with all these tables now?
Internet integration of maps

I have been using Fusion Tables for many years and I have just started my project on the platform and got an email saying that in August 2019 the data-related API will stop communicating and on December 3rd the whole platform goes offline. The whole storm stopped, and a brief report showed that besides this project there are also 83 tables using Fusion Tables in different visualizations and projects. Most are related to population visualizations and bike statistics, and I need to find a different format and visualization by the end of 2019. Because the main thing in the e-mail is – “We stop the platform, you can download your data from here.” No, we are huge Google and unfortunately we stop tables, but can continue to use them in Google Doc, Google This or Google That… Fusion Tables for me has always been like carving a boat from pine bark – rude, simple and fun. Without any special skills in coding, API documentation, or server space requirements. The simplicity of the tables is complemented by the fact that Google’s options for saving on hard disk or online of the available information is as CSV and KML files. Table or map. Sounds good, but … there’s a catch.

You can open the CSV file in almost any spreadsheet program – from Google Docs, Excels and even online readers – but you should always be alert to encoding (most of my tables are in Cyrillic) and you will not get a map outside of Gagle Maps if you use for location address or KML shape. The KML file is handy but you can not access a table outside the Google Map, and if you download a new KML file from an active map, no matter how many rows you have in the table, everything will be reduced to a name and description, you lose the autonomy of rows, which makes the information in them meaningless as a source of visualization.

Although there are many similar platforms like CartoDB , Tableau, , EasyMapMaker and a few more similar ones where you can visualize tables in a similar way as Fusion Tables, they are available at a charge of, let’s say, $ 70 per month, if not more. In the “free” DataWrapper , the only free is one map and 10,000 table views. Despite the prices, I suppose there will be consumers who will migrate to these platforms.

What does Google offer to those who will stay in Google’s cloud? As a high-tech company, Google offers a bunch of apps to visualize tables. As BigQuerty or DataStudio … Instruments with which, according to Google ads work the big brands, so we need terabytes of cloud space. For which prices do not differ much from those on external platforms. Where am I with my tables of 200-300 kb. Google offers me to do my boats from pine bark with a 3D printer. Because we are 21 century… How tempting…

For good or bad, the only adequate alternative to visualizations on Fusion Tables is to work with GeoJSON files. This will allow you to use custom info windows, heatmap and many other statistical functions in order and value. And that means, besides converting, and writing at least one HTML document with at least one API or Java Script code in it for each table. And trust me on Google Maps writing is not worth it, since there are platforms such as Mapbox , OpenStreetMaps and Kartograph.js .

Writing the code will be “easy” with a little read. The question remains with reformatting CSV and KML from Fusion Tables to Geo and regular JSON files. If we stay in Google Docs, we will have to convert again with the same settings after each change. Change, download, convert, upload. Even for one letter. Therefore, once GeoJSON passed, it is best that the subsequent edits be JSON’s editor. Like http://geojson.io , for example. In a nutshell, the suspension of Fusion Tables is out of Google products at all the statistical maps.

Previous articleWhat if we split the population of Bulgaria into two equal partsNext article Elata Cave

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

About me and site

I hope here you will find what you are looking for. That is, what I can offer - interesting maps of Bulgaria and the world, even more, interesting ideas for tourism and adventures, as well as useful information about my native city - Sofia. You can learn more about these things as well as my most interesting projects from the links below.
I'm still adding photos and translations, so Error 404 pops up. Use Search or the menu to find what you are looking for

Recent Posts

Elata Cave24/02/2019
Fusion Tables is retiring. And what to do with all these tables now?15/12/2018
What if we split the population of Bulgaria into two equal parts03/11/2018

Popular Posts

Famous unknown Reselets2 comments
Ice and fire mood1 comment
Little, but beautiful Lastovica cave1 comment
Maliovitsa – for climbing and hiking1 comment
Promo video of our new Light and Cult discoveries1 comment

Projects in Progress

Downloads

  • Donation Free Download
  • Cycling Touring in Bulgaria
  • Animation movies and reviews
  • Advertising here
  • Contact me
  • About me
Maps, Photography and Adventure 2019 © Stoyanov
Условия за ползване на файловете