Sam's notebook

What LGA is it in? August 31st, 2018, 9AM


I’ve been updating Wikidata items that are located in the administrative territorial entity of Fremantle (Q606212) because that isn’t actually an administrative territorial entity. Those items are actually in City of Fremantle (Q1455046), which is an LGA. On which topic, I’ve also been trying to add LGA boundaries to OSM for Fremantle (relation 8617839), but […]

[No comments] [Keywords: , , , , , ] [Permanent link]

Loading spatial data into MySQL with LOAD DATA INFILE July 23rd, 2015, 9AM


Just a note for my future reference: importing an Excel CSV into MySQL. The WKT column has been constructed by hand to be POINT(lng lat) and the CSV contains headers. LOAD DATA INFILE ‘/full_path/to/file-on-server.csv’ REPLACE INTO TABLE the_table COLUMNS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ IGNORE 1 ROWS (name,description,@geographic_location) SET geographic_location = GeomFromText(@geographic_location) ;

[No comments] [Keywords: , , , , , , , , ] [Permanent link]

Backing up thunderbird email April 25th, 2013, 2PM


When backing up Thunderbird, the only files I worry about are the actual mbox files that store the ‘Local Folders’ (archived) email, and the *.mab addresbook files. Everything else is operational cruft. This might seem a bit extreme—after all, why not backup the account configurations and user preferences etc.—but I jump from machine to machine […]

[No comments] [Keywords: , , , , , , , ] [Permanent link]

Jeffersonian Yeoman bloggers March 21st, 2013, 6AM


Great post yesterday from The Blasphemous Bicycler about people not controlling their own data: The reasons for this are fairly easy to deduce. We were all swept away by “social media.” To send a tweet, update your Facebook status, or post a picture of your victuals on Intagram is a trivial task. Composing a blog […]

[3 comments] [Keywords: , , , , , ] [Permanent link]