Example with PHP and Spatialite, part 1
By John C. Zastrow
This post is part of a series [1], [2], [3], [4]
[Read More]
-
-
Notes from Where Camp Boston 2011
By John C. ZastrowI 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] -
Remove all foreign keys from MySQL database
By John C. ZastrowI 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] -
Reseting OpenSSH server keys on a server
By John C. Zastrow# Ubuntu / Debian Linux Regenerate OpenSSH Host Keys [Read More] -
Creating an ST_ table and view in Oracle for ArcSDE
By John C. ZastrowI created a table with ST_GEOMETRY as a column with SQL, inserted records, created a view with some filtering and registered both with ArcSDE. [Read More] -
Check for non-numeric data in mysql
By John C. ZastrowThis will list the non-numeric data values in a mysql column. [Read More] -
Check for non-numeric data in mysql
This will list the non-numeric data values in a mysql column. [Read More] -
Read the Descriptions from all columns in MS Access database
By John C. ZastrowFrom one of my developers. This VBA (couldn’t find an approach in .Net) will loop through all the tables and write out the description from all the fields. [Read More] -
Handy database documenter/profiler for mysql, cont.
By John C. ZastrowSome time ago I wrote down a little script to make a table from the MySQL information schema to describe your database. My eventual goal is to come close to reproducing a poor man’s database profiling script similar to this crude one ( http://www.ipcdesigns.com/data_profiling/), but perhaps less powerful and yet... [Read More] -
Wish I didn’t invest in the iPad2
By John C. ZastrowAfter much deliberation we plunked down the plastic for an iPad2. It was supposed to be a gift for me.. though I likely use it the least of all people over the age of 2 in this house. It shipped much faster than expected and just in time for the... [Read More]