Re: [mapserver-users] copyright, logos, etc
On Wed, Feb 11, 2015 at 03:25:15PM +, Eichner, Andreas - SID wrote:
It's a little ugly but it works with:
https://gist.github.com/silenius/f0b0fb856b82a7c70eaa
Being on PostGIS I'd suggest using the native driver with something like that:
CONNECTIONTYPE postgis
DATA geom FROM (select id, name, now() as generated_date,
st_GeomFromText('POINT(-5 70)') AS geom FROM map WHERE id=%MYID%) AS tmp
USING SRID=-1 USING UNIQUE id
CLASS
LABEL
TEXT Species name: [name] (last updated: [generated_date])
FONT vera
TYPE TRUETYPE
SIZE 7
BUFFER 1
COLOR 0 0 0
FORCE TRUE
STYLE
GEOMTRANSFORM 'labelpoly'
COLOR 255 255 255
END
END
END
that works even better .. thanks!
--
Julien Cigar
Belgian Biodiversity Platform (http://www.biodiversity.be)
PGP fingerprint: EEF9 F697 4B68 D275 7B11 6A25 B2BB 3710 A204 23C0
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.
pgpBULtS7KA_P.pgp
Description: PGP signature
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] copyright, logos, etc
On Wed, Feb 11, 2015 at 02:55:37PM +, Eichner, Andreas - SID wrote: Thanks, I'll try it that way. Another idea I had was to create a POINT layer with a FEATURE POINTS x y END END and use that layer in my SLD stylesheet (which is generated dynamically) with a TextSymbolizerLabelsometextblabla/Label ... /TextSymbolizer like on https://gist.github.com/silenius/1f4a020f35a4113cdd4d but it seems that it's unsupported by Mapserver (if I understand well https://github.com/mapserver/mapserver/blob/master/mapogcsld.c#L2706 ) You're right. That's unsupported. But to me it looks as you could cheat by using an empty PropertyName/: TextSymbolizerLabelThis static text will be displayedPropertyName//Label/TextSymbolizer more or less, it seems that there are some serious issues with the XML parser: The following doesn't work: se:Labelogc:PropertyName /foo/se:Label The following returns a strange msFontsetLookupFonts(): TrueType Font error. Requested font (^A) not found.: se:Label ogc:PropertyName /foo /se:Label With: se:Label ogc:PropertyName / foo /se:Label it works more or less, it display (foo ) etc Would it be possible in the future to add support for a CDATA-like section that goes directly within the FEATURE - TEXT part of the layer? I guess a basic implementation wouldn't be too hard to implement. But many elements of symbology encoding map to se:ParameterValueType which is a mixture of text nodes and ogc:expressions and this is generally not very well supported. I'd guess this needs huge reworking on both parser and engine... So, to get at least the simple cases supported you might want to file a ticket. I'll do that ..! Thanks, Julien -- Julien Cigar Belgian Biodiversity Platform (http://www.biodiversity.be) PGP fingerprint: EEF9 F697 4B68 D275 7B11 6A25 B2BB 3710 A204 23C0 No trees were killed in the creation of this message. However, many electrons were terribly inconvenienced. pgpEom52otH47.pgp Description: PGP signature ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] copyright, logos, etc
On Wed, Feb 11, 2015 at 01:32:54PM +, Eichner, Andreas - SID wrote:
what I really need to do is to
make an SQL query (something like select name from map where id=%MYID%)
and use that attribute in the TEXT part of the FEATURE section (something
like FEATURE POINTS x y END TEXT Species name: [name] END)
Any idea is welcome on how to do that in the Mapserver way ..
I have not test it but I would suggest replacing the inlined feature with a
OGR point layer connected to a MYSQL view or a OGR VRT datasource that
associates every line with the position of the annotation.
1) MYSQL view:
CREATE OR REPLACE VIEW species_annotation AS SELECT id,
GeomFromText('POINT(60 -10)') AS Shape, name FROM map;
LAYER
...
# FEATURE
#POINTS
# 60 -10# the offset (from lower left) in pixels
#END # Points
#TEXT © xyz company 2006 # this is your displaying text
# END # Feature
CONNECTIONTYPE ogr
CONNECTION 'MYSQL: ...'
DATA 'species_annotation'
LABELITEM 'name'
FILTER ([id]=%MYID%)
...
END # Layer
2) OGR VRT datasource:
In species_annotation.vrt:
OGRVRTDataSource
OGRVRTLayer name=species_annotation
SrcDataSourceMYSQL: .../SrcDataSource
SrcSQLSELECT id, 60 as x, -10 as y, name FROM map/SrcSQL
FIDid/FID
GeometryTypewkbPoint/GeometryType
LayerSRSNULL/LayerSRS
GeometryField encoding=PointFromColumns x=x y=y
reportSrcColumn=false /
/OGRVRTLayer
/OGRVRTDataSource
Test with: ogrinfo -al species_annotation.vrt -fid existing id
LAYER
...
CONNECTIONTYPE ogr
CONNECTION 'species_annotation.vrt'
DATA 'species_annotation'
LABELITEM 'name'
FILTER ([id] = %MYID%)
...
END # Layer
HTH
Thanks, I'll try it that way. Another idea I had was to create a POINT
layer with a FEATURE POINTS x y END END and use that layer in my SLD
stylesheet (which is generated dynamically) with a
TextSymbolizerLabelsometextblabla/Label ... /TextSymbolizer like
on https://gist.github.com/silenius/1f4a020f35a4113cdd4d but it seems
that it's unsupported by Mapserver (if I understand well
https://github.com/mapserver/mapserver/blob/master/mapogcsld.c#L2706 )
Would it be possible in the future to add support for a CDATA-like
section that goes directly within the FEATURE - TEXT part of the layer?
Thanks!
Julien
--
Julien Cigar
Belgian Biodiversity Platform (http://www.biodiversity.be)
PGP fingerprint: EEF9 F697 4B68 D275 7B11 6A25 B2BB 3710 A204 23C0
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.
pgpt2qhsgcGDB.pgp
Description: PGP signature
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Label in SLD
Basically yes as MapServer's SLD implementation does not support Literals. It only supports a property name optionally enclosed by PropertyName. -Ursprüngliche Nachricht- Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users- boun...@lists.osgeo.org] Im Auftrag von Julien Cigar Gesendet: Mittwoch, 11. Februar 2015 14:11 An: mapserver-users@lists.osgeo.org Betreff: [mapserver-users] Label in SLD Hello, With the following https://gist.github.com/silenius/1f4a020f35a4113cdd4d is it normal that the Label (line 29-31) within my TextSymbolizer is not rendered (the PointSymbolizer is) ? Thanks, Julien -- Julien Cigar Belgian Biodiversity Platform (http://www.biodiversity.be) PGP fingerprint: EEF9 F697 4B68 D275 7B11 6A25 B2BB 3710 A204 23C0 No trees were killed in the creation of this message. However, many electrons were terribly inconvenienced. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] copyright, logos, etc
On Wed, Feb 11, 2015 at 01:32:54PM +, Eichner, Andreas - SID wrote:
what I really need to do is to
make an SQL query (something like select name from map where id=%MYID%)
and use that attribute in the TEXT part of the FEATURE section (something
like FEATURE POINTS x y END TEXT Species name: [name] END)
Any idea is welcome on how to do that in the Mapserver way ..
I have not test it but I would suggest replacing the inlined feature with a
OGR point layer connected to a MYSQL view or a OGR VRT datasource that
associates every line with the position of the annotation.
1) MYSQL view:
CREATE OR REPLACE VIEW species_annotation AS SELECT id,
GeomFromText('POINT(60 -10)') AS Shape, name FROM map;
LAYER
...
# FEATURE
#POINTS
# 60 -10# the offset (from lower left) in pixels
#END # Points
#TEXT © xyz company 2006 # this is your displaying text
# END # Feature
CONNECTIONTYPE ogr
CONNECTION 'MYSQL: ...'
DATA 'species_annotation'
LABELITEM 'name'
FILTER ([id]=%MYID%)
...
END # Layer
2) OGR VRT datasource:
In species_annotation.vrt:
OGRVRTDataSource
OGRVRTLayer name=species_annotation
SrcDataSourceMYSQL: .../SrcDataSource
SrcSQLSELECT id, 60 as x, -10 as y, name FROM map/SrcSQL
FIDid/FID
GeometryTypewkbPoint/GeometryType
LayerSRSNULL/LayerSRS
GeometryField encoding=PointFromColumns x=x y=y
reportSrcColumn=false /
/OGRVRTLayer
/OGRVRTDataSource
Test with: ogrinfo -al species_annotation.vrt -fid existing id
LAYER
...
CONNECTIONTYPE ogr
CONNECTION 'species_annotation.vrt'
DATA 'species_annotation'
LABELITEM 'name'
FILTER ([id] = %MYID%)
...
END # Layer
HTH
It's a little ugly but it works with:
https://gist.github.com/silenius/f0b0fb856b82a7c70eaa
Thank you very much!
--
Julien Cigar
Belgian Biodiversity Platform (http://www.biodiversity.be)
PGP fingerprint: EEF9 F697 4B68 D275 7B11 6A25 B2BB 3710 A204 23C0
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.
pgpfsxJwn9mOX.pgp
Description: PGP signature
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] copyright, logos, etc
Thanks, I'll try it that way. Another idea I had was to create a POINT layer with a FEATURE POINTS x y END END and use that layer in my SLD stylesheet (which is generated dynamically) with a TextSymbolizerLabelsometextblabla/Label ... /TextSymbolizer like on https://gist.github.com/silenius/1f4a020f35a4113cdd4d but it seems that it's unsupported by Mapserver (if I understand well https://github.com/mapserver/mapserver/blob/master/mapogcsld.c#L2706 ) You're right. That's unsupported. But to me it looks as you could cheat by using an empty PropertyName/: TextSymbolizerLabelThis static text will be displayedPropertyName//Label/TextSymbolizer Would it be possible in the future to add support for a CDATA-like section that goes directly within the FEATURE - TEXT part of the layer? I guess a basic implementation wouldn't be too hard to implement. But many elements of symbology encoding map to se:ParameterValueType which is a mixture of text nodes and ogc:expressions and this is generally not very well supported. I'd guess this needs huge reworking on both parser and engine... So, to get at least the simple cases supported you might want to file a ticket. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] copyright, logos, etc
It's a little ugly but it works with:
https://gist.github.com/silenius/f0b0fb856b82a7c70eaa
Being on PostGIS I'd suggest using the native driver with something like that:
CONNECTIONTYPE postgis
DATA geom FROM (select id, name, now() as generated_date,
st_GeomFromText('POINT(-5 70)') AS geom FROM map WHERE id=%MYID%) AS tmp USING
SRID=-1 USING UNIQUE id
CLASS
LABEL
TEXT Species name: [name] (last updated: [generated_date])
FONT vera
TYPE TRUETYPE
SIZE 7
BUFFER 1
COLOR 0 0 0
FORCE TRUE
STYLE
GEOMTRANSFORM 'labelpoly'
COLOR 255 255 255
END
END
END
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] msOGRFileNextShape(): OGR error. TopologyException: side location conflict
I ran into this old problem today, using the OSGeo4W daily 6.5 build. http://lists.osgeo.org/pipermail/mapserver-users/2009-August/thread.html#62527 http://trac.osgeo.org/mapserver/ticket/3100 Google finds quite a lot of non-mapserver-related questions about this error, but perhaps (as was suggested in the ticket), something can be done to avoid it, as it is related to GEOS (EdgeEndStar::propagateSideLabels). Mapserver seems to render the problematic geometry with no problem, but fails when a query (WMS GetFeatureInfo) falls near it. I think it can't be related to input file format, as it does the same with KML, spatialite, and GML. I have made a simple set of data that shows the problem, but I'm not sure what parts I should post, as altogether it's quite long. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] WMS request url gets misinterpreted calling on mapserver from python
Hi, Do you mean that you get nothing else than those lines into ms_errorfile ever, not valid images at all? The log entry looks good to me. The line you copied from access.log has been a success 200 with 14068 bytes sent out which fits well for a small jpeg image. Could it be that your DOP20 source data is little bit sparse and some 256x256 sized tiles just do not contain any data? Then it would be an expected result that you get those lines into your ms_error. -Jukka Rahkonen- Lars Fricke wrote: Hello List, I have a very strange effect I am stuck with. I have a python server (Twisted) from where I make a WMS request to Mapserver. Now the strange thing is, if I issue the request from my python server, I get a msQueryByRect(): Search returned no results. No matching record(s) found. in ms_error.txt If I take the very request string from the apache access log and put it into the browser, I get a nice image as result. So I assume the BBOX may be interpreted differently depending on the client? Or can this be an encoding issue? Here's my line from access.log: 127.0.0.1 - - [11/Feb/2015:09:17:35 +0100] GET /wms?SERVICE=WMSFORMAT=image%2FjpegREQUEST=GetMapHEIGHT=256SRS=EPSG%3A3857VERSION=1.1.1BBOX=1102680.5700419527%2C6719884.904662984%2C1102757.0070702378%2C6719961.341691271LAYERS=DOP20WIDTH=256MAXNATIVEZOOM=20TRANSPARENT=false HTTP/1.1 200 14068 - My Server I do not see anything in the error.log of Apache at that time. Any help is highly appreciated. Thanks for taking the time! Best Lars ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] WMS request url gets misinterpreted calling on mapserver from python
Hello List, I have a very strange effect I am stuck with. I have a python server (Twisted) from where I make a WMS request to Mapserver. Now the strange thing is, if I issue the request from my python server, I get a msQueryByRect(): Search returned no results. No matching record(s) found. in ms_error.txt If I take the very request string from the apache access log and put it into the browser, I get a nice image as result. So I assume the BBOX may be interpreted differently depending on the client? Or can this be an encoding issue? Here's my line from access.log: 127.0.0.1 - - [11/Feb/2015:09:17:35 +0100] GET /wms?SERVICE=WMSFORMAT=image%2FjpegREQUEST=GetMapHEIGHT=256SRS=EPSG%3A3857VERSION=1.1.1BBOX=1102680.5700419527%2C6719884.904662984%2C1102757.0070702378%2C6719961.341691271LAYERS=DOP20WIDTH=256MAXNATIVEZOOM=20TRANSPARENT=false HTTP/1.1 200 14068 - My Server I do not see anything in the error.log of Apache at that time. Any help is highly appreciated. Thanks for taking the time! Best Lars ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] WMS request url gets misinterpreted calling on mapserver from python
Hi Jukka, Thank you for the fast response. If you say there should be an image, maybe I'm doing something wrong in the receiving application. I will check on that first and then come back with the result. Best Lars Am 11.02.2015 um 11:34 schrieb Rahkonen Jukka (MML): Hi, Do you mean that you get nothing else than those lines into ms_errorfile ever, not valid images at all? The log entry looks good to me. The line you copied from access.log has been a success 200 with 14068 bytes sent out which fits well for a small jpeg image. Could it be that your DOP20 source data is little bit sparse and some 256x256 sized tiles just do not contain any data? Then it would be an expected result that you get those lines into your ms_error. -Jukka Rahkonen- Lars Fricke wrote: Hello List, I have a very strange effect I am stuck with. I have a python server (Twisted) from where I make a WMS request to Mapserver. Now the strange thing is, if I issue the request from my python server, I get a msQueryByRect(): Search returned no results. No matching record(s) found. in ms_error.txt If I take the very request string from the apache access log and put it into the browser, I get a nice image as result. So I assume the BBOX may be interpreted differently depending on the client? Or can this be an encoding issue? Here's my line from access.log: 127.0.0.1 - - [11/Feb/2015:09:17:35 +0100] GET /wms?SERVICE=WMSFORMAT=image%2FjpegREQUEST=GetMapHEIGHT=256SRS=EPSG%3A3857VERSION=1.1.1BBOX=1102680.5700419527%2C6719884.904662984%2C1102757.0070702378%2C6719961.341691271LAYERS=DOP20WIDTH=256MAXNATIVEZOOM=20TRANSPARENT=false HTTP/1.1 200 14068 - My Server I do not see anything in the error.log of Apache at that time. Any help is highly appreciated. Thanks for taking the time! Best Lars ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] copyright, logos, etc
On Thu, Feb 05, 2015 at 02:41:40PM +0100, Julien Cigar wrote: Hello, I'm using Mapserver to generate maps for various PostGIS layers and it works pretty well, especially with SLD to filter WMS requests. Now the users want to include: - a logo (PNG file) in the upper right corner - a copyright text at the bottom center of the page - a text generated at ... with the date For now I have the following MAP file: https://gist.github.com/silenius/545d479132981dc5a55a (only relevant parts are shown) For the logo and the copyright text it works more or less (although it seems über complicated for such simple thing, but maybe there is a simpler way of doing it ?), the only problem I have is that if I change the WIDTH and HEIGHT of the map the things disappear, as the POINTS in the FEATURE section don't fit the map size. I wonder if there is a simple way to tell Mapserver to just put that 20px .PNG file in the upper right corner of the generated map or something like that .. ? Any idea how could I do for the generated date ? Thanks ! Julien Hello, After digging hours in the documentation I ended by modifying the generated image file with PIL ... It's not the ideal solution but I don't see an easy way in Mapserver to simply add some text to a generated image. I used http://www.mapserver.org/faq.html#how-do-i-add-a-copyright-notice-on-the-corner-of-my-map for the static ones (which works) but what I really need to do is to make an SQL query (something like select name from map where id=%MYID%) and use that attribute in the TEXT part of the FEATURE section (something like FEATURE POINTS x y END TEXT Species name: [name] END) Any idea is welcome on how to do that in the Mapserver way .. Julien -- Julien Cigar Belgian Biodiversity Platform (http://www.biodiversity.be) PGP fingerprint: EEF9 F697 4B68 D275 7B11 6A25 B2BB 3710 A204 23C0 No trees were killed in the creation of this message. However, many electrons were terribly inconvenienced. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Julien Cigar Belgian Biodiversity Platform (http://www.biodiversity.be) PGP fingerprint: EEF9 F697 4B68 D275 7B11 6A25 B2BB 3710 A204 23C0 No trees were killed in the creation of this message. However, many electrons were terribly inconvenienced. pgp7SXuiBTSL9.pgp Description: PGP signature ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] WMS request url gets misinterpreted calling on mapserver from python
Hi Jukka, hi List, Sorry, false alarm. I had screwed up on a message pipeline so I'd read the images before they were there. That way I also hindered the images to be delivered and screwed up on the next request. So nothing is wrong with Mapserver and I am smarter than before ;-) Best Lars Am 11.02.2015 um 12:03 schrieb Lars Fricke: Hi Jukka, Thank you for the fast response. If you say there should be an image, maybe I'm doing something wrong in the receiving application. I will check on that first and then come back with the result. Best Lars Am 11.02.2015 um 11:34 schrieb Rahkonen Jukka (MML): Hi, Do you mean that you get nothing else than those lines into ms_errorfile ever, not valid images at all? The log entry looks good to me. The line you copied from access.log has been a success 200 with 14068 bytes sent out which fits well for a small jpeg image. Could it be that your DOP20 source data is little bit sparse and some 256x256 sized tiles just do not contain any data? Then it would be an expected result that you get those lines into your ms_error. -Jukka Rahkonen- Lars Fricke wrote: Hello List, I have a very strange effect I am stuck with. I have a python server (Twisted) from where I make a WMS request to Mapserver. Now the strange thing is, if I issue the request from my python server, I get a msQueryByRect(): Search returned no results. No matching record(s) found. in ms_error.txt If I take the very request string from the apache access log and put it into the browser, I get a nice image as result. So I assume the BBOX may be interpreted differently depending on the client? Or can this be an encoding issue? Here's my line from access.log: 127.0.0.1 - - [11/Feb/2015:09:17:35 +0100] GET /wms?SERVICE=WMSFORMAT=image%2FjpegREQUEST=GetMapHEIGHT=256SRS=EPSG%3A3857VERSION=1.1.1BBOX=1102680.5700419527%2C6719884.904662984%2C1102757.0070702378%2C6719961.341691271LAYERS=DOP20WIDTH=256MAXNATIVEZOOM=20TRANSPARENT=false HTTP/1.1 200 14068 - My Server I do not see anything in the error.log of Apache at that time. Any help is highly appreciated. Thanks for taking the time! Best Lars ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Label in SLD
Hello, With the following https://gist.github.com/silenius/1f4a020f35a4113cdd4d is it normal that the Label (line 29-31) within my TextSymbolizer is not rendered (the PointSymbolizer is) ? Thanks, Julien -- Julien Cigar Belgian Biodiversity Platform (http://www.biodiversity.be) PGP fingerprint: EEF9 F697 4B68 D275 7B11 6A25 B2BB 3710 A204 23C0 No trees were killed in the creation of this message. However, many electrons were terribly inconvenienced. pgpyPok02B2gn.pgp Description: PGP signature ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] copyright, logos, etc
what I really need to do is to
make an SQL query (something like select name from map where id=%MYID%)
and use that attribute in the TEXT part of the FEATURE section (something
like FEATURE POINTS x y END TEXT Species name: [name] END)
Any idea is welcome on how to do that in the Mapserver way ..
I have not test it but I would suggest replacing the inlined feature with a OGR
point layer connected to a MYSQL view or a OGR VRT datasource that associates
every line with the position of the annotation.
1) MYSQL view:
CREATE OR REPLACE VIEW species_annotation AS SELECT id, GeomFromText('POINT(60
-10)') AS Shape, name FROM map;
LAYER
...
# FEATURE
#POINTS
# 60 -10# the offset (from lower left) in pixels
#END # Points
#TEXT © xyz company 2006 # this is your displaying text
# END # Feature
CONNECTIONTYPE ogr
CONNECTION 'MYSQL: ...'
DATA 'species_annotation'
LABELITEM 'name'
FILTER ([id]=%MYID%)
...
END # Layer
2) OGR VRT datasource:
In species_annotation.vrt:
OGRVRTDataSource
OGRVRTLayer name=species_annotation
SrcDataSourceMYSQL: .../SrcDataSource
SrcSQLSELECT id, 60 as x, -10 as y, name FROM map/SrcSQL
FIDid/FID
GeometryTypewkbPoint/GeometryType
LayerSRSNULL/LayerSRS
GeometryField encoding=PointFromColumns x=x y=y
reportSrcColumn=false /
/OGRVRTLayer
/OGRVRTDataSource
Test with: ogrinfo -al species_annotation.vrt -fid existing id
LAYER
...
CONNECTIONTYPE ogr
CONNECTION 'species_annotation.vrt'
DATA 'species_annotation'
LABELITEM 'name'
FILTER ([id] = %MYID%)
...
END # Layer
HTH
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
