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)

About these ads

One Response to “Spatial databases once more”

  1. jaykayone Says:

    Hi Hans,
    welcome to the wonderful ArcWorld.

    ArcGIS wont connect to it without having ArcSDE (ArcGIS Server Basic) or FME ESRI Edition.

    ArcSDE will allow you RW access to postgis, whereas FME will only give you R access from within ArcGIS.

    With ArcGIS 10, you’ll be able to read directly from PostGIS though.

    As for the ODBC thing, it’s attributes only ..

    As for Manifold, I don’t know a lot, but this might help: http://www.manifold.net/doc/spatial_dbms_facilities.htm

    Cheerio
    Jeff

    PS: Postgres / PostGIS is really powerful, especially in combination with UMN Mapserver!

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: