GeoNotes Blog | GeoNotes

Creating an ST_ table and view in Oracle for ArcSDE

By John C. Zastrow

Posted on September 1, 2011

I 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. Zastrow

Posted on August 22, 2011

This will list the non-numeric data values in a mysql column. [Read More]

Check for non-numeric data in mysql

Posted on August 22, 2011

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. Zastrow

Posted on July 25, 2011

From 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. Zastrow

Posted on July 18, 2011

Some 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. Zastrow

Posted on July 17, 2011

After 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. Zastrow

Posted on July 8, 2011

Use 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. Zastrow

Posted on May 26, 2011

If 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. Zastrow

Posted on May 11, 2011

sudo apt-get remove –purge\ [Read More]

find to copy files into single directory

By John C. Zastrow

Posted on April 29, 2011

Useful little one liners. This one makes copy of subset of dir/ and below based on finding files that match the criteria. In this case, I wanted all .doc files copied into a single place. [Read More]