Thaks again David,<br>I thought that was possible. I'd read the 'Ogr Direct Connection to Mysql' page and I will use it.<br>I don't want to have shp, shx, dbf and duplicate database data to prevent errors.<br><br><br><div>
<span class="gmail_quote">2006/6/15, Fawcett, David <<a href="mailto:David.Fawcett@state.mn.us">David.Fawcett@state.mn.us</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
John,<br><br>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.<br><br>Take a look at this page.<br><br>David.
<br><br><br>-----Original Message-----<br>From: UMN MapServer Users List on behalf of John Prof<br>Sent: Wed 6/14/2006 10:50 AM<br>To: <a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</a><br>Subject: Re: [UMN_MAPSERVER-USERS] MyGis connection question
<br><br>Hi David,<br>I would prefer use the spatial extensions but I can't find nothing about.<br>Your method works fine.<br>Thanks<br><br>2006/6/13, Fawcett, David <<a href="mailto:David.Fawcett@state.mn.us">David.Fawcett@state.mn.us
</a> >:<br>><br>> John,<br>><br>> Take a look at this: <a href="http://mapserver.gis.umn.edu/docs/howto/ogrmysql">http://mapserver.gis.umn.edu/docs/howto/ogrmysql</a><br>><br>> You would need to change your data structure so that you store your x and
<br>> y values in separate columns.<br>><br>> Note that this method doesn't use MyGIS, it uses a direct connection<br>> driver in OGR, so your MapServer binary would need to be compiled with OGR<br>> support (as most are).
<br>><br>> David.<br>><br>> -----Original Message-----<br>> *From:* UMN MapServer Users List [mailto:<a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</a>] *On<br>> Behalf Of *John Prof
<br>> *Sent:* Tuesday, June 13, 2006 4:03 AM<br>> *To:* <a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</a><br>> *Subject:* [UMN_MAPSERVER-USERS] MyGis connection question<br>><br>
> Hello,<br>><br>> I'm trying to connect mapserver's map with a mysql datatable like this:<br>><br>> id int<br>> name varchar(20)<br>> description varchar(100)
<br>> location point<br>><br>> I'd like to create a shape with the points and the labels of the name. Is<br>> it possible? I've tried many ways but I have errors.<br>> I'd like to do something like this example:
<br>><br>><br>> LAYER<br>><br>> CONNECTIONTYPE mygis<br>> NAME "City"<br>> CONNECTION "host:user:passwd:database:bin"<br>> DATA "location from city"<br>> TYPE POINT
<br>> STATUS ON<br>> .<br>> .<br>> .<br>> END<br>><br>> It fails. I've tried with some mysql functions like AsBinary(point), but<br>> it doesn't work.<br>> I must use sh2mysql structure to store data in my database? Is not
<br>> possible make my simply case?<br>><br>> Thanks and sorry for my english :p<br>><br>><br><br><br></blockquote></div><br>