[GIS] To import bulk data in google fusion table

google mapsgoogle-fusion-tables

I want to import bulk data into fusion table . What is the best data format should I use to import data i.e JSON ,CSV .

If I want to import data in JSON format how can I do it since on google help only way was to upload CSV files .

Best Answer

If you have geospacial data, I've had a lot of success exporting a kml from SHP and GeoJSON with QGIS and uploading that. If your comfortable with the command line the python CSV and JSON libraries are both very good and easy to use to convert JSON -> python dictionary -> CSV. Though that isn't going to work if you have geospatial data.

Related Solutions

[GIS] Zooming Google Maps to fit the extents of a Fusion Table layer

You can get your all your table data and find the bounds from the response:

      var bounds = new google.maps.LatLngBounds();
  for(i = 0; i < numRows; i++) {
      var point = new google.maps.LatLng(
          parseFloat(response.getDataTable().getValue(i, 0)),
          parseFloat(response.getDataTable().getValue(i, 1)));
      bounds.extend(point);
  }
  // zoom to the bounds
  map.fitBounds(bounds);
}

This comes from a good example:

http://www.geocodezip.com/www_vciregionmap_comC.html and view source

[GIS] google map api v3 large/complex polygons

I had a similar problem and used a kml parser (geoxml3) to locally parse a kml. I later ended up storing each kml file as a database table and looping through the records to plot a polygon. Loading the kml from a server was the slowest of all.

Best Answer

Related Solutions

[GIS] Zooming Google Maps to fit the extents of a Fusion Table layer

[GIS] google map api v3 large/complex polygons

Related Question