[postgis-users] MySQL->PostGIS

[Erich Schroeder]

I have a mapserver application of paleontological data that uses 
shapefiles to create the taxon-specific maps, and then allows the visitor 
to go to views of the tabular data held in MySQL. I would like to 
recreated it using PostGIS to allow more flexibility, etc. I looked at a 
couple of mysql->pgsql translators and they didn't work for me right away. 
Am I likely better off with one of following methods:

1. going ahead and moving all 32 of the tables into postgresql? If so, do 
any tools work well and easily?

2. just creating one table on PostGIS to hold the point locations for the 
paleontological site locations, and continue the rest of the data in 
MySQL?

3. work with DBI-Link (http://pgfoundry.org/projects/dbi-link/) to create 
a PostGIS-enabled database of the localities, with DBI-link'ed tables to 
the Mysql versions? Anyone used DBI-link?

I have to say that I hate to lose access to the data via phpMyAdmin, as 
I've gotten so used to it. However, I really want to be able to allow 
queries such as "show me localities within 150km that also contain taxon-A 
specimens that date from 8000 to 15000 years ago".

eks

---------------------------------------------------------------------
Erich Schroeder                    Phone: (217)785-0033
Curator, Learning Center           FAX:   (217)785-2857
Illinois State Museum GIS Lab      email:erich(at)illinois.state.museum
http://www.museum.state.il.us/     Linux user #18660
---------------------------------------------------------------------