tag:blogger.com,1999:blog-6221900824469142147.post2782394414745900560..comments2023-06-22T20:39:13.097+10:00Comments on #All-things-spatial: Shp data and Fusion TablesAll Things Spatialhttp://www.blogger.com/profile/10413714814303264541noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6221900824469142147.post-72654228965062754652011-08-08T17:47:16.502+10:002011-08-08T17:47:16.502+10:00Hi Josh and thanks for your comment.
Having spen...Hi Josh and thanks for your comment. <br /><br />Having spent more time playing with Fusion Tables I now better understand the limitations. Indeed, it’s not shpEscape that is the issue but rather Google Fusion Tables itself. It generalises some polygons while plainly “refusing” to process others - 1 million characters limit is really an issue that may hold back some potential users since it requires additional processing of input files. And when the row fails, the rest of the rows is not loaded either. <br /><br />I believe shpEscape has a great potential, especially if you allow for some “user input” (eg. selection of attributes to transfer) and strictly implement checks for 1 million character limit per cell so all polygons are loaded. But the challenge will be to maintain topological consistency (ie. if one polygon is generalised and the adjoining is not - it may result in mismatch in boundaries) <br /><br />I amended my post based on your comment and my further investigations. Keep me posted when you have the next version ready!<br /><br />CheersAll Things Spatialhttps://www.blogger.com/profile/10413714814303264541noreply@blogger.comtag:blogger.com,1999:blog-6221900824469142147.post-3112733399598049472011-08-06T06:38:29.554+10:002011-08-06T06:38:29.554+10:00Hey - thanks for the post and good feedback on shp...Hey - thanks for the post and good feedback on shpEscape. <br /><br />A few comments:<br /> - The site isn't officially supported by Google; just something I built one weekend<br /><br /> - In terms of performance, I do some row by row analysis which is definitely not optimal, but also helps ensure compatibility with Fusion Tables (for example the requirement all geometries are less than 1M characters in length after conversion to KML, which means I have to simplify some of them).<br /> <br /> - If the geometry is valid and doesn't require simplification it just uses GDAL/OGR to do the shp-> KML conversion, so there shouldn't be any additional corruption of geometries from the shpEscape code<br /><br /> - Good point about slowness: As of v1.9 GDAL supports a Fusion Tables driver which I'll use instead of manually going through each row. One advantage (in my mind) of shpEscape is it adds some attributes for each feature that let you more easily style things in Fusion Tables, but most people may not care about this so speed should be the default<br /><br />Thanks again for the comments.Joshhttps://www.blogger.com/profile/06857249299181024013noreply@blogger.comtag:blogger.com,1999:blog-6221900824469142147.post-23011541791720343712011-07-25T23:13:34.343+10:002011-07-25T23:13:34.343+10:00Indeed Eric, it’s a very easy process with QGIS – ...Indeed Eric, it’s a very easy process with QGIS – I tried it myself earlier today! I have to flag this option in the related post. Thanks for bringing it up. <br /><br />If I could only figure out how to add text to be converted to KML at the same time (for info windows). I know I can add a column to attribute table but not sure how to populate it with relevant HTML tags and text. There seem to be a limit of 255 characters. Any suggestions?All Things Spatialhttps://www.blogger.com/profile/10413714814303264541noreply@blogger.comtag:blogger.com,1999:blog-6221900824469142147.post-67353771659220529092011-07-25T19:35:46.702+10:002011-07-25T19:35:46.702+10:00Try using Quantum GIS for this conversion, it'...Try using Quantum GIS for this conversion, it's a very convenient open source GIS-programm.<br /><br />At least on my pc, the shp->kml conversion was very simple and quick.Anonymoushttps://www.blogger.com/profile/01498640103850785133noreply@blogger.com