GeoNotes Blog | GeoNotes

Untar and gunzip all files in a directory

By John C. Zastrow

Posted on April 10, 2012

I needed a little script to expand a bunch of tarred and gzipped files in a directory and I needed a log of what happened.. and didn’t happen (errors). So, here it is. [Read More]

FOSS4g North America not for me

By John C. Zastrow

Posted on February 16, 2012

After missing the International FOSS4G in Denver (one of my former homes and a great excuse to visit land and friend alike) I’m now likely going to miss FOSS4G North America in the territory of my home office in the greater DC area. Argg, this totally bums me out. Somebody... [Read More]

Dropping columns in sqlite/spatialite

By John C. Zastrow

Posted on January 28, 2012

SQLite doesn’t have a nice ALTER TABLE DROP COLUMN command and neither does spatialite. Instead, you get to run a long sequence of commands like this. Here I wanted to drop all the extra columns from my huc12 layer for the country. [Read More]

Of file sizes and nearest neighbors

By John C. Zastrow

Posted on January 27, 2012

This post is part of a series [1], [2], [3], [4], [5] [Read More]

Spatialite Speed Test

By John C. Zastrow

Posted on January 20, 2012

This post is part of a series [1], [2], [3], [4], [5] [Read More]

Spatialite and Spatial Indexes

By John C. Zastrow

Posted on January 18, 2012

This post is part of a series [1], [2], [3], [4] [Read More]

Example with PHP and Spatialite, part 2

By John C. Zastrow

Posted on January 17, 2012

This post is part of a series [1], [2], [3], [4] [Read More]

Example with PHP and Spatialite, part 1

By John C. Zastrow

Posted on January 16, 2012

This post is part of a series [1], [2], [3], [4] [Read More]

Notes from Where Camp Boston 2011

By John C. Zastrow

Posted on November 1, 2011

I had a great time at this little event and it was good prep for the Maine GIS User group’s Ignite meeting tonight. Hopefully I’ll be able to attend more stuff like this in the future. But, before then, I’d better get some materials together about Spatialite in return for... [Read More]

Tags:

Remove all foreign keys from MySQL database

By John C. Zastrow

Posted on October 27, 2011

I needed to load some lookup data into a MySQL database littered with foreign keys. So I copied the empty DB and ran the output of the following: SELECT CONCAT('alter table ',table_schema,'.',table_name,' DROP FOREIGN KEY ',constraint_name,';') FROM information_schema.table_constraints WHERE constraint_type='FOREIGN KEY' AND table_schema = 'MY_DATABASE_NAME_HERE'; \ [Read More]