Dear hipsters
By John C. Zastrow
Just wearing untucked plaid shirts, that you clearly paid too much for, does not make you cool.
-
-
Postgres database from itis.gov
By John C. ZastrowThis might save you some head aches. The postgresql database dump of the taxonomic universe (according to the USGS) from http://www.itis.gov/ is provided in a latin1 character encoding (specifically it tries to create a database as ENCODING = 'LATIN1' LC_COLLATE = 'en_US.ISO8859-1' LC_CTYPE = 'en_US.ISO8859-1'. [Read More] -
PostgreSQL/PostGIS and ArcGIS ArcMap 10.2
By John C. ZastrowOf course good things come to those who wait (at least that’s the wisdom that I pass along to my kids). We expect that after we’re done waiting we will get something awesome and worth the wait, right? But sometimes what we end up getting is a little underwhelming and... [Read More] -
I Love LIDAR
By John C. ZastrowOver the years I’ve tasted good bear, coffee, and hot cocoa. Now I have a hard time drinking the cheap stuff– though I try not to drink expensive wine for fear of losing my wallet. I’m about to get another expensive taste: LIDAR data. I’ve never worked with it before,... [Read More] -
Spatialite wishlist for 2013
By John C. ZastrowThe Spatialite project and its family of products is progressing and gaining a larger following by the day. Growth seems to be coming from its apparent target audience – mobile developers (though I rely on it for desktop use). This is likely to only snowball as Spatialite acceptance increases and... [Read More] -
Find listen ports on your linux
By John C. ZastrowFor example, if you only want to see TCP connections, use netstat –tcp. This shows a list of TCP connections to and from your machine. The following example shows connections to our machine on ports 993 (imaps), 143 (imap), 110 (pop3), 25 (smtp), and 22 (ssh).It also shows a connection... [Read More] -
Bye Bye Google Reader
By John C. ZastrowNow Google Reader, next Gmail. The Internets are abuzz with news that Google is going to kill off the Google personal RSS Aggregator called Reader. I use Reader everyday. Even more than Gmail. So this is another example of the evils of SaaS and cloudy stuff. You don’t own it.... [Read More] -
Paul Ramsey: The Unknowns: A Managers Guide to Open Source
By John C. ZastrowI’m a big fan of this talk. [Read More] -
Wget examples
By John C. ZastrowI keep having to Google wget incantations. So, I’m going to just write some common ones down here. The spell at the moment is below and can be used with my previous post about processing EPA WQX/STORET domain values into useful tables: [Read More] -
Importing EPA WQX Domains into MySQL Tables
By John C. ZastrowI wanted fresh WQX domain values from the STORET web service that are updated daily ( http://www.epa.gov/storet/wqx/wqx_getdomainvalueswebservice.html ) – which are provided in XML format. But, it’s not a friendly format for most software. Excel and Access “see it” but they don’t make useful tables out of them. It turns... [Read More]