Google Fusion Tables is a way to store, manage, share, and even visualize data from the web. It’s entirely free; all you need is a Google account to get started. With Fulcrum as your means for data creation, getting that data into Fusion Tables is simple and can be incredibly useful for any project.
Exporting your Fulcrum Data
The first step to getting your data into Fusion Tables is to export your Fulcrum data to a CSV file. You could also use the KML format. Go to your app library, and from the app settings box, click “Export Data”:
Follow the steps of the export wizard and be sure that CSV (or KML) is selected as your export file format.
Once the export process has finished, download the file from the exports list.
Once you have downloaded the CSV file you may have to unzip it if it contains photos.
Uploading your Fulcrum Data to Google Fusion Tables
Go to Google Fusion Tables and select “Create a New Table”. If you want to, you can also download the Fusion Tables Google Chrome web app. Browse and select your CSV file and ensure that the Comma box is checked. If you are using a KML file, the separator character selection won’t appear.
After clicking next, it will prompt you to edit information such as the title, description, etc, which you can do as needed. Once you have your data imported, it will bring you to the table view. Now you can filter your data, modify it, and even map it.
If you would like to add photos, simply insert a URL for each photo in the column. You will also need to adjust the line format though the column settings. You can use the images exported with your Fulcrum records. Be sure to upload them to the web somewhere (for this example, I used Photobucket).
Creating Maps and Charts with Fusion Tables
Fusion Tables can really come in handy if you are not very knowledgeable or experienced with mapping, since you can use this tool to create a map. Simply click the “map of latitude” tab. This will automatically generate a map of your data. You can choose to filter by specific features, change the marker icons, and more. When you are finished you can share the map by emailing it to others, downloading it, posting a link on social media, or even embedding it in a website.
Creating a map isn’t the only Fusion Tables feature that can enhance your Fulcrum experience; you can also create charts and graphs. Simply select the ‘+’ tab and then ‘add chart’.
Once in the charts section, all you have to do is select which type of chart or graph you want. In this example, I chose to create a pie chart showing which school districts have the most houses for sale. It is very easy to setup and modify; you can even change the colors.