Spatial databases once more
For a while I’ve been meaning to try out more stuff with spatial databases. I’ve been using them for a few years actually, but so far that’s always been MySQL Spatial thanks to a simple install package produced by the good people at Apachefriends.org. It’s easy to set up that way but… MySQL Spatial isn’t very widely supported, in fact the only application I have that actually reads/writes it is FME…
So, wanting to try something different I went ahead and installed PostgreSQL with PostGIS. This should be wider supported, of the software that I use on a regular basis FME, Manifold and ArcGIS should be able to read/write it. Well, FME certainly does, no problem there. Having a bit more trouble getting Manifold and Arc to talk to the database though. Apparently they require an ODBC connection and that seems to be tricky to set up. Hopefully I can get that sorted out soon.
– Update January 21st –
Well, as Jeff has pointed out, I should not worry about Arc…
I’ve continued hacking away at this and managed to get both FME and Manifold talking to a PostGIS database. Funny enough Manifold only does that in the 32 bit version, though it appears there’s some extra dll’s for the 64 bit version that can be used to get that one working too. Also, veteran Manifold user (rock star I should say) Art Lembo of Gisadvisor.com has a training video on setting up an enterprise spatial database with Manifold and PostGIS that looks rather interesting.
Anyway, I have opted to install the databases on a brand new (and rather cute) Compaq ultraportable. For playing around with databases in a network environment it appears to be just fine (which is good, because I’m short on space)