We've been busy as of late, so has been hard to keep up with blogging.
As many of you may notice, we have another satellite site called Postgres OnLine Journal.
We try to put only PostgreSQL specific things on that site and PostGIS/GIS things on this site, but often times the lines cross and so we end up cross-linking.
This is one of those times.
People who know me tend to think I have a spectacular memory for things. What they don't seem to realize is I have good recollection but bad memory.
People seem to have a hard time differentiating between the two concepts.
My natural survival instinct
to compensate for my terrible memory is to carefully organize my thoughts which often gives the illusion of a spectacular memory in many cases
and embarassing absent-mindedness in others.
This also makes me more sensitive to breaks in patterns than most and produces some other interesting and humorous side effects.
One of the tools I use to organize my memory is to create cheat sheets which I gain some joy in making. Cheat sheets provide a reference as well as forces a certain
level of knowledge organization. Here are some that PostGIS users may find useful.
PostGIS 1.3.3 pgsql2shp shp2pgsql Command Line Cheatsheet
PostgreSQL Pg_dump Pg_Restore Cheatsheet
PostgreSQL 8.3 Cheat Sheet
Old one which I hope to update when the new release comes out
PostGIS ver. 1.3.1 Quick Guide
Yeh for OpenJUMP
I'm still navigating my way thru the OpenJUMP tool, but so far I like it more than even the commercial tools I have used and even more than QuantumGIS. Although doesn't seem to have
a shape importer similar to QuantumGIS's SPIT plug-in or Manifold's link import tools.
So far I have tried to try ESRI ArcGIS, Manifold.net, GvSig, uDig. Manifold seemed to have some interesting features, but required some setting back and reading material
which I have had too short of an attention span for. Granted looks like it would be worth it once I can get myself to sit down for longer than 15 minutes.
ESRI ArcGIS layout and terminology, sorry if I am offending anyone here, just seems altogether confusing to me which makes me think what kind of person came up with this
chaotic structure?. Perhaps its just a side-effect of consolidating a number of pseudo-disparate products over the years under one umbrella. I'm sure there is beauty in there that I am just not able to appreciate coming from GIS from a non-standard angle.
GvSig, admittedly I haven't explored enough. The layout seemed organized enough, but just not my kind of layout.
uDig I haven't tried in a while, but seemed a bit overwhelming and when I did, I found it annoying that it would arbitrarily pick a geometry field if I had more than one in a table and I couldn't seem to selectively select one.
That was a couple of years ago so
things probably changed, and I really should give it another go.
OpenJUMP on the other hand was like it just read my mind. I really haven't had to read anything
to do the things I have wanted to do in it. Well really most of what I was looking for was an ad-hoc spatial query tool so while Manifold and ArcGIS probably have tons of useful stuff that are real gems,
it gets in my way of my short-term objectives. Plus the OpenJUMP mascot was an added benefit since it is similar to the logo of our biggest client and a graphic representation of my old moniker - which was derived from my initials. So OpenJump gets plus 2 for nostalgic effect.
If anyone is interested, I've put together a quick brush through of using it - at our Postgres Online Journal satellite site - in the product showcase section.
OpenJump for PostGIS Spatial Ad-Hoc Queries