http://simonwillison.net/2019-06-14T00:45:01+00:00Simon Willison2019-06-14T00:45:01+00:002019-06-14T00:45:01+00:00https://simonwillison.net/2019/Jun/14/locations-kml/#atom-tag

<p><strong><a href="https://gist.github.com/simonw/2f09eb4b9fa41a3721f3e87f18813221">Convert Locations.kml (pulled from an iPhone backup) to SQLite</a></strong></p> I’ve been playing around with data from my iPhone using the iPhone Backup Extractor app and one of the things it exports for you is a Locations.kml file full of location history data. I wrote a tiny script using Python’s ElementTree XMLPullParser to efficiently iterate through the Placemarks and yield them as dictionaries, which I then batch-inserted into sqlite-utils to create a SQLite database. <p>Tags: <a href="https://simonwillison.net/tags/kml">kml</a>, <a href="https://simonwillison.net/tags/projects">projects</a>, <a href="https://simonwillison.net/tags/sqlite">sqlite</a>, <a href="https://simonwillison.net/tags/xml">xml</a>, <a href="https://simonwillison.net/tags/sqlite-utils">sqlite-utils</a></p>

2019-01-18T23:50:00+00:002019-01-18T23:50:00+00:00https://simonwillison.net/2019/Jan/18/togeojson/#atom-tag

<p><strong><a href="https://github.com/tmcw/togeojson">togeojson</a></strong></p> Handy JavaScript library and command-mine tool for converting KML and GPX to GeoJSON, by Tom MacWright <p><small></small>Via <a href="https://twitter.com/tmcw/status/1086407002773803008">@tmcw</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/geospatial">geospatial</a>, <a href="https://simonwillison.net/tags/kml">kml</a>, <a href="https://simonwillison.net/tags/geojson">geojson</a>, <a href="https://simonwillison.net/tags/tom-macwright">tom-macwright</a></p>

2009-05-20T21:07:10+00:002009-05-20T21:07:10+00:00https://simonwillison.net/2009/May/20/mapdata/#atom-tag

<p><strong><a href="http://code.google.com/apis/maps/documentation/mapsdata/">Google Maps Data API</a></strong></p> I’m disappointed by this one—it’s really just a CRUD store for the KML files used in Google MyMaps. It would be a lot more useful if it let you perform geospatial calculations against your stored map data using some kind of query API—a cloud service alternative to tools like PostGIS. <p><small></small>Via <a href="http://googlegeodevelopers.blogspot.com/2009/05/introducing-google-maps-data-api-in.html">Google Geo Developers Blog</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/apis">apis</a>, <a href="https://simonwillison.net/tags/gdata">gdata</a>, <a href="https://simonwillison.net/tags/geospatial">geospatial</a>, <a href="https://simonwillison.net/tags/google-maps">google-maps</a>, <a href="https://simonwillison.net/tags/google-maps-api">google-maps-api</a>, <a href="https://simonwillison.net/tags/googlemapsdataapi">googlemapsdataapi</a>, <a href="https://simonwillison.net/tags/kml">kml</a>, <a href="https://simonwillison.net/tags/postgis">postgis</a></p>

2008-10-16T14:37:33+00:002008-10-16T14:37:33+00:00https://simonwillison.net/2008/Oct/16/data/#atom-tag

<p><strong><a href="http://ouseful.wordpress.com/2008/10/14/data-scraping-wikipedia-with-google-spreadsheets/">Data Scraping Wikipedia with Google Spreadsheets</a></strong></p> I hadn’t played with =importHTML in Google spreadsheets, which lets you suck in data from an HTML table or list somewhere on the web. This tutorial takes it further, bringing Wikipedia, Yahoo! Pipes and KML in to the mix. <p>Tags: <a href="https://simonwillison.net/tags/google-docs">google-docs</a>, <a href="https://simonwillison.net/tags/googlespreadsheet">googlespreadsheet</a>, <a href="https://simonwillison.net/tags/importhtml">importhtml</a>, <a href="https://simonwillison.net/tags/kml">kml</a>, <a href="https://simonwillison.net/tags/mashups">mashups</a>, <a href="https://simonwillison.net/tags/scraping">scraping</a>, <a href="https://simonwillison.net/tags/wikipedia">wikipedia</a>, <a href="https://simonwillison.net/tags/yahoo-pipes">yahoo-pipes</a></p>

2008-08-25T22:20:10+00:002008-08-25T22:20:10+00:00https://simonwillison.net/2008/Aug/25/flickr/#atom-tag

<p><strong><a href="http://code.flickr.com/blog/2008/08/25/api-responses-as-feeds/">Flickr Developer Blog: API Responses as Feeds</a></strong></p> Flickr API calls that return a “standard photos response” (e.g. flickr.photos.search and flickr.favorites.getList) can now output eight different feed formats as well, including Atom, RSS flavours, geoatom, geordf and KML. Error codes are returned as X-FlickrErrCode HTTP headers. <p><small></small>Via <a href="http://laughingmeme.org/2008/08/25/codeflickrcom-api-responses-as-feeds/">Kellan</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/apis">apis</a>, <a href="https://simonwillison.net/tags/atom">atom</a>, <a href="https://simonwillison.net/tags/feeds">feeds</a>, <a href="https://simonwillison.net/tags/flickr">flickr</a>, <a href="https://simonwillison.net/tags/geoatom">geoatom</a>, <a href="https://simonwillison.net/tags/geordf">geordf</a>, <a href="https://simonwillison.net/tags/http">http</a>, <a href="https://simonwillison.net/tags/kml">kml</a>, <a href="https://simonwillison.net/tags/rss">rss</a></p>

2008-04-14T18:36:39+00:002008-04-14T18:36:39+00:00https://simonwillison.net/2008/Apr/14/kml/#atom-tag

<p><strong><a href="http://google-latlong.blogspot.com/2008/04/kml-new-standard-for-sharing-maps.html">KML: A new standard for sharing maps</a></strong></p> Google’s KML format, which is already supported by both Microsoft and Yahoo!’s map software, has been accepted under the wing of the Open Geospatial Consortium and is now an international standard. <p>Tags: <a href="https://simonwillison.net/tags/google">google</a>, <a href="https://simonwillison.net/tags/google-maps">google-maps</a>, <a href="https://simonwillison.net/tags/kml">kml</a>, <a href="https://simonwillison.net/tags/mapping">mapping</a>, <a href="https://simonwillison.net/tags/maps">maps</a>, <a href="https://simonwillison.net/tags/ogc">ogc</a></p>

2007-08-16T01:38:29+00:002007-08-16T01:38:29+00:00https://simonwillison.net/2007/Aug/16/brighton/#atom-tag

<p><strong><a href="http://brighton.geekvenues.com/">Brighton geek venues</a></strong></p> Nat’s latest project: a neat Google Maps mashup listing venues for geek events in Brighton, managed using Google MyMaps to edit a KML file. <p>Tags: <a href="https://simonwillison.net/tags/brighton">brighton</a>, <a href="https://simonwillison.net/tags/geek">geek</a>, <a href="https://simonwillison.net/tags/google">google</a>, <a href="https://simonwillison.net/tags/google-maps">google-maps</a>, <a href="https://simonwillison.net/tags/googlemymaps">googlemymaps</a>, <a href="https://simonwillison.net/tags/kml">kml</a>, <a href="https://simonwillison.net/tags/mashup">mashup</a>, <a href="https://simonwillison.net/tags/mymaps">mymaps</a>, <a href="https://simonwillison.net/tags/natalie-downe">natalie-downe</a></p>

2007-03-23T01:03:33+00:002007-03-23T01:03:33+00:00https://simonwillison.net/2007/Mar/23/google/#atom-tag

<p><strong><a href="http://googlemapsapi.blogspot.com/2007/03/kml-and-georss-support-added-to-google.html">KML and GeoRSS support added to the Google Maps API</a></strong></p> Since Flickr can output GeoRSS, this means you can now plot your Flickr photos on a Google Map (if you’re so inclined). <p>Tags: <a href="https://simonwillison.net/tags/flickr">flickr</a>, <a href="https://simonwillison.net/tags/georss">georss</a>, <a href="https://simonwillison.net/tags/google">google</a>, <a href="https://simonwillison.net/tags/google-maps">google-maps</a>, <a href="https://simonwillison.net/tags/kml">kml</a></p>