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

[Henric Ernstson]

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.