I thought that was possible. I'd read the 'Ogr Direct Connection to Mysql' page and I will use it.
I don't want to have shp, shx, dbf and duplicate database data to prevent errors.
2006/6/15, Fawcett, David <[EMAIL PROTECTED]>:
John,
My understanding is that MyGIS support has not been maintained in MapServer for a long time. Recently, direct connection through OGR to MySQL for spatial support.
Take a look at this page.
David.
-----Original Message-----
From: UMN MapServer Users List on behalf of John Prof
Sent: Wed 6/14/2006 10:50 AM
To: [email protected]
Subject: Re: [UMN_MAPSERVER-USERS] MyGis connection question
Hi David,
I would prefer use the spatial extensions but I can't find nothing about.
Your method works fine.
Thanks
2006/6/13, Fawcett, David <[EMAIL PROTECTED] >:
>
> John,
>
> Take a look at this: http://mapserver.gis.umn.edu/docs/howto/ogrmysql
>
> You would need to change your data structure so that you store your x and
> y values in separate columns.
>
> Note that this method doesn't use MyGIS, it uses a direct connection
> driver in OGR, so your MapServer binary would need to be compiled with OGR
> support (as most are).
>
> David.
>
> -----Original Message-----
> *From:* UMN MapServer Users List [mailto:[email protected]] *On
> Behalf Of *John Prof
> *Sent:* Tuesday, June 13, 2006 4:03 AM
> *To:* [email protected]
> *Subject:* [UMN_MAPSERVER-USERS] MyGis connection question
>
> Hello,
>
> I'm trying to connect mapserver's map with a mysql datatable like this:
>
> id int
> name varchar(20)
> description varchar(100)
> location point
>
> I'd like to create a shape with the points and the labels of the name. Is
> it possible? I've tried many ways but I have errors.
> I'd like to do something like this example:
>
>
> LAYER
>
> CONNECTIONTYPE mygis
> NAME "City"
> CONNECTION "host:user:passwd:database:bin"
> DATA "location from city"
> TYPE POINT
> STATUS ON
> .
> .
> .
> END
>
> It fails. I've tried with some mysql functions like AsBinary(point), but
> it doesn't work.
> I must use sh2mysql structure to store data in my database? Is not
> possible make my simply case?
>
> Thanks and sorry for my english :p
>
>
