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] -
Use Excel’s MID and FIND to extract characters from varying positions
By John C. ZastrowUse this to grab the values after a certain value, of the whole string the value doesn’t exist. The concatenation ensure that the value is always found. The final Len(A1) forces the entire length of the string after the value to be shown regardless of what it it. the final... [Read More] -
USGS GNIS column names and shapefiles
By John C. ZastrowIf you try to convert the USGS geographic names (GNIS) text files from the website straight into shapefiles, you will have field name collisions because the field names willbe truncated to 10 characters which result in duplicate field names. [Read More] -
PostGIS Install and Cloning Ubuntu Systems Notes
By John C. Zastrowsudo apt-get remove –purge\ [Read More]