Sam's notebook

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]