Visualizing your location based data with Fusion Tables

Google Fusion Tables is a modern data management and publishing web application that makes it easy to host, manage, collaborate on, visualize, and publish data tables online. Fusion Tables allows for import of geospatial data to quickly and easily display that data on a Google Map.


The Fusion Tables team has been working hard to enrich what Fusion Tables offers for customization and control of the Google Map visualizations. Two very exciting announcements were made at Google I/O during the Fusion Tables session on Managing and visualizing your geospatial data with Fusion Tables. These announcements include the release of the Info Window and Styling in the Fusion Tables API and Fusion Table Styling in the Google Maps API. 


Info Window and Styling API

Previously, map styles and info window templates could only be customized via the Fusion Tables UI. The Info Window and Styling API opens up this functionality to the Fusion Tables API as well. There are many benefits of having API access to map styles and info window templates. For example:

  • This saves time when customizing hundreds of tables.
  • Since the styles and templates are JSON objects, it’s easy to serialize the objects and reuse them later.
  • The styles of public tables can be discovered and used for your own tables.

The Info Window and Styling API is still accepting Trusted Testers! If you’re interested in becoming a Trusted Tester, please join the Fusion Tables API Trusted Tester Google Group.

Fusion Tables Styles in the Google Maps API

Fusion Tables Styles further increases the possibilities of map customization. Rather than applying a style to a table via the API or UI, styling can now be introduced on the client side using the Google Maps API. There are many benefits to Fusion Tables Styles:

  • It allows for dynamic styling of map features.
  • It’s opens up the possibility for styling tables with multiple attributes.
  • You can give your users the opportunity to decide what range of styles works best for your data.
  • Third party developers can now generate visualizations of your data that differ from your own, which makes sharing your data more powerful and useful.

Fusion Tables styles are available now! Read more about how to use Fusion Tables Styles in the Fusion Tables Layer section of the Google Maps API documentation.

We’re already seeing some really nice uses of Fusion Tables for map customization. Simon Rogers, who joined us for the Fusion Tables I/O session to talk about how the UK Guardian Datablog uses Fusion Tables, has been making great use of Fusion Tables Styles. Here’s one of the Guardian’s latest examples. If you’re interested in creating a map similar to the Guardian’s, we have developed a template for plug-and-play.

What’s new since I/O?

Ever since I/O, we’ve been working to bring you new and interesting additions to the API. For example, this past month, we added IN to the list of supported column filters.

 

SketchUp: The doors look right in different ortho views

The doors are represented differently in plan, elevation and sectional orthographic views of a building. By which I mean:

  • In plan, doors are generally shown in the open position.
  • In elevation, doors appear closed.
  • When cut through in section, doors disappear altogether.
In plan, doors appear open to show their swing. In the above image, the swing arcs, section cut graphics and arrows were added in LayOut. 

 

In elevation, doors appear closed. Otherwise, you’d be able to see through them, which would be visually confusing. The scale figure and the dashed lines to indicate the hinge position were added in LayOut.

 

In sectional views, doors which are cut through don’t appear at all. All that is visible of the doorway in the above section is the edges of the wall beyond the cut. Doors which appear in elevation (like the one on the left) are shown closed.

 

If I’m modeling a building and I leave the doors open, they’ll look correct in plan but not in other views. If I close them, the plans will look wrong. Clearly, I need two sets of doors—one open, one closed—and I need to manage which set is visible in each view. Layers, Scenes and nested components to the rescue!

The idea here is to create a door component that includes two sub-components: one that’s an open door, and one that’s a closed door. Mine looks something like this:

A door component which includes both open and closed door sub-components, each on its own layer. In the image above, “Color By Layer” is turned on to better illustrate the setup. The Outliner dialog box shows the nesting relationship of the three door components.

 

Creating a combination door component

Start by modeling both doors and turning them into a set of nested components:

Step 1
Create the hole into which you want to insert a door.

Make the hole exactly the same size as the door you’re planning to model.

 

Step 2
Model a door in the closed position. Keep it simple; a rectangle is fine for now.

Fill the doorway opening with a simple face. Make it flush with the side of the wall into which the door will open.

 

Step 3
Select only the door geometry and turn it into a component. Give it a meaningful name that describes its size, orientation and position like “Door-36-L-Closed”.

Turn your simple door into a component by selecting its geometry and right-clicking to open a context menu.

 

Give your door component a meaningful name; “36” indicates the width and “L” indicates the left-hand hinge position. Make sure the “Replace selection with component” checkbox is selected before you click Create.

 

Step 4
If you like, add detail (like a thickness) to the door you just modeled.

Extruding the single face into a 3D object will make it read better in plan. Resist the temptation to add doorknobs, detailed woodwork or anything else that isn’t in keeping with your model’s current level of detail.

 

Step 5
Model the same door in the open position. Be sure not to duplicate the component instance you made in the previous step — the whole point of this exercise is to have two, separate components.

Model the same door again, this time in the open position. For accuracy, line up the edges where the hinges would be on a real door.

 

Step 6
Turn the open door into a new component. Call it something like “Door-36-L-Open”.

Make the open door into another component and name it accordingly.

 

Step 7
Select the open and closed door components and make a new component that includes both. A good name for this component might be “Door-36-L-Main”.

Select both door components (open and closed) and make them into a new component.

 

Using Layers to control component visibility

The next step is to put each sub-component on a separate layer:

Step 1
Choose Window>Layers to open the Layers Manager.

Step 2
Create a new layer called “Doors-Open”.

Step 3
Create another layer called “Doors-Closed”.

Use the Layers Manager to create two new layers.

 

Step 4
Choose Window>Entity Info to open the Entity Info dialog box.

Step 5
Start editing your Main door component (the one that includes both sub-components) by double-clicking it with the Select tool.

Step 6
Select the closed door sub-component and move it to the “Doors-Closed” layer using the Layer drop-down menu in the Entity Info dialog box.

Move the Closed Door sub-component to the “Doors-Closed” layer using the Entity Info dialog box.

 

Step 7
Select the open door component and move it to the “Doors-Open” layer.

Put the Open Door sub-component on its own layer, too.

 

Step 8
Click elsewhere on your screen to stop editing the Main door component.

Make sure the Main Door component (which includes both sub-components) is on LayerO. If you’re really advanced, I suppose you could even have a layer dedicated to these “combo” door components. Tread lightly, though—layers can be tricky to work with.

 

Setting up Scenes to control layer visibility

After you’ve placed doors wherever you need them in your model, you can control which set is visible by creating (or updating) scenes that show only one “Doors” layer at a time. It’s pretty straightforward, really:

Step 1
Activate the scene that corresponds to a plan view of your model. If you don’t have one yet, just create a new scene called “Plan” and worry about getting the camera position in order later.

Right now, both the Doors Closed and Doors Open layers are visible. We only want the open doors to appear in the above plan.

 

Step 2
In the Layers Manager, hide the “Doors Closed” layer.

Uncheck the Doors Closed layer to make its contents invisible.

 

Step 3
Right-click the “Plan” scene tab and choose Update.

When the doors look the way you want them to, right-click the relevant scene tab and choose Update.

 

Step 4
Repeat the above three steps for any other planimetric scenes in your model.

Step 5
Go through the above process again for any scenes where doors should appear closed.

In the above elevation view, I want only the Doors Closed layer to be visible.

 

Dealing with doorways in section

What about doors that are cut through by section cuts? They shouldn’t appear at all. The solution here is simple: Just hide the offending door components and update your scene.

Doors which are cut through in sectional views shouldn’t appear at all. Those which appear in elevation (like the one on the left) should appear closed.

 

Simply hiding door components you don’t want to see (then updating the corresponding scene) is the easiest way to deal with this conundrum.

 

One more thing: I’ve added the above example model to the 3D Warehouse so you can download it and do some of your own experimenting.

King on Perfect Timing

 

Now is the time…”

–Martin Luther King, Jr. (1929–1968)
American civil rights leader
Nobel Peace Prize winner

Take action.

Make the call (contact).
Ask the (real) questions.
Seek out the objections (the truth).
Close.

You’re in sales. Everyone depends on you.
_______________________________________