Re: [UMN_MAPSERVER-USERS] Select data from table to generate layer

[Umberto Nicoletti]

It is probably slower, that's it.

Umberto

On 9/28/07, Henric Ernstson <[EMAIL PROTECTED]> wrote:
>
> Tanks for a quick answer.
>
> I have used *.ovf files to select data from mySQL for the layers I have today 
> to get data from the database and so far I have not got any problem yet, is 
> it not recomended or so to use that method?
>
>
>
> -----Ursprungligt meddelande-----
> Från: "Umberto Nicoletti" <[EMAIL PROTECTED]>
> Till: "Henric Ernstson" <[EMAIL PROTECTED]>
> Kopia: MAPSERVER-USERS@lists.umn.edu
> Skickat: 07-09-28 09:14
> Ämne: Re: [UMN_MAPSERVER-USERS] Select data from table to generate layer
>
> The same has been cleaned up and added to the documentation here:
>
> http://mapserver.gis.umn.edu/docs/reference/vector_data/mygis
>
> Umberto
>
> On 9/28/07, Umberto Nicoletti <[EMAIL PROTECTED]> wrote:
> > Henric,
> > first of all you need to make the mysql accessibile to mapserver by
> > converting coordintes into a valid mygis geometry.
> > Unfortunately there is not much documentation on mysql around, but I
> > could gather the following by looking at the source of mapmygis.c:
> >
> >
> > Standard ways of specifiying are :
> > (1) 'geometry_column from geometry_table'
> > (2) 'geometry_column from (&lt;sub query&gt;) as foo using unique
> > &lt;column name&gt; using SRID=&lt;srid#&gt;'",
> >
> > NOTE: for (2) 'using unique' and 'SRID=' are optional, but its highly
> > recommended that you use them!!!
> >
> > The most common problem with (1) is incorrectly uploading your data.
> > There must be an entry in the geometry_columns table.  This will be
> > automatically done if you used the shp2mysql program or created your
> > geometry column with the AddGeometryColumn() MYGIS function.
>
>