Geographic data types

Geographic vector data can define a point, line, or polygon. All three of these can be displayed on the map in Fusion Tables.

By default, only map features in the first 100,000 rows in a table are shown on a map. To request an exception, please email googletables-feedback@google.com with more information.

Location descriptions

A location can also be specified with descriptive text (eg: "France" or "Mountain View, CA") or an address (where all the elements of the address are in one column separated with spaces, eg: "1600 Amphitheater Parkway Mountain View CA 94043"). Fusion Tables attempts to geocode the locations and place the results on your map. If your location data is in several columns, see Combine multi-column locations.

Points

A point is defined by a latitude longitude pair. There are three ways to specify a point with lat-long in Fusion Tables:

  • in one column, separated by a space: latitude longitude
  • in two columns, specified in the column type
  • as a Placemark with a Point in KML

Fusion Tables requires latitude and longitude numbers to be in decimal degrees (e.g., 40.446, -79.948). Lat-long data that is in degree-minutes-seconds must be converted to decimal before import.

Lines or Paths

A line or path is a list of points. To specify a line or path, use the KML LineString element, and store the KML in a Location type column in your table.

Polygons or shapes

A polygon or shape is a list of points where the last point is the same as the first, so that the connecting the points encloses a geographic area. To specify a polygon, use the KML Polygon element, and store the KML in a Location type column in your table.

Holes within polygons are supported. Multi-geometry placemarks are supported, but limited to ten polygons during display on a map.

A cell of data in Fusion Tables supports a maximum of 1 million characters; if you have more than this, you need to simplify the polygon or line or reduce the precision of coordinates in order to fit the description data into the 1 million character limit.