R: [UMN_MAPSERVER-USERS] MIGRATING SHAPE IN MYSQL

[Bart van den Eijnden]

Hi Alberto,

MySQL has spatial datatypes in 4.1 (alpha) if I am not mistaken, but
Mapserver does not have a data connector for that. See also this link for
a review:

http://postgis.refractions.net/pipermail/postgis-users/2003-June/002651.html

So I assume you are talking about the MyGIS option, there is a Perl
utility which can write your shapefile to the MyGIS format, but all that I
know is from the Wiki page.

PostGIS is a spatial extension for PostgreSQL, and is a lot more mature.
There are several tools to get your shapefile data into postgis, shp2pgsql
or ogr2ogr from Frank Warmerdam. There are also very good tutorials (see
the proceeding from the Ottawa meeting) to get you started with PostGIS. I
found it easy to get started.

http://www.omsug.ca/osgis2004/proceedings.html

Hope this helps.

Best regards,
Bart

>
> THANKS FOR YOUR REPLY BART, I'D LIKE TO WORK WITH MYSQL ONLY BECAUSE THIS
> IS
> THE WAY THAT I'VE FOUND AND ALSO BECAUSE I KNOW MYSQL BUT I DON'T KNOW
> POSTGIS. CA YOU TELL ME MORE ABOUT POSTGIS AND THE MIGRATION OF SHAPE?
> THANKS IN ADVANCE
> ALBERTO
>
>
>
> -----Messaggio originale-----
> Da: bartvde at xs4all.nl
> A: Alberto Cavalli
> Cc: mapserver-users at lists.umn.edu
> Inviato: 11/08/04 10.55
> Oggetto: Re: [UMN_MAPSERVER-USERS] MIGRATING SHAPE IN MYSQL
>
> Hi Alberto,
>
> did you consider migrating to PostGIS (postgis.refractions.net) instead?
> IMHO that would be a far better option.
>
> Best regards,
> Bart
>
>> I found this interesting way to work and I'd like to do this to menage
> a
>> big
>> amount of data. I've read the instruction on mapserver.wiki but I
> don't
>> understand correctly how I can make it. Did someone make it?
>> can someone help for the migration from shape to mysql? What i've to
> do?
>> thanks a lot
>> Alberto
>>
>