[Mapserver-users] Generating dynamic point layer

[David Fawcett]

Has anyone successfully created point layers from Access .mdb files?  

David J. Fawcett
MN Office of Environmental Assistance

>>> François-Xavier Prunayre <fx.prunayre at oieau.fr> 5/12/2004 4:47:23 AM >>>
>    I have an access table with the georeferencing positions (X, Y).
> Could anybody please help me by sending some code to generate a point
> layer dynamically from these information. Thanks for previous helps I
> got from the group.

You could do that using OGR virtual layer; Wiki page is
http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?VirtualSpatialData.

Set DSN in odbc connection; for exemple French,
then Ovf file look like this :
<OGRVRTDataSource>
    <OGRVRTLayer name="STATIONS">
        <SrcDataSource>ODBC:French,STATIONS</SrcDataSource>
     	<SrcLayer>STATIONS</SrcLayer>
    	<GeometryType>wkbPoint</GeometryType>
    	<LayerSRS></LayerSRS>
                 <GeometryField encoding="PointFromColumns"
x="X_LAMBERT_II_ET" y="Y_LAMBERT_II_ET"/>
 </OGRVRTLayer>
</OGRVRTDataSource>
where X_LAMBERT_II_ET is X coordinates and Y_LAMBERT_II_ET is Y.

Map file layer tag is :
LAYER
    NAME OVF
    TYPE POINT
    CONNECTIONTYPE OGR
    CONNECTION "french.ovf"
    DATA "STATIONS" # the name of the OGRVrtLayer
    STATUS DEFAULT
    PROJECTION
      "init=epsg:27582"
    END
  DUMP TRUE
	CLASS
    		TEMPLATE "ttt_query.html"
    		SYMBOL "circle"
    		SIZE 6
    		NAME "STATION_FR"
    		OUTLINECOLOR 239 16 16
	END
END

You could also use Mapscript.

HTH
Francois

----- Original Message ----- 
From: "Sam Choudry" <samuzzal at linux.net>
To: <mapserver-users at lists.gis.umn.edu>
Sent: Wednesday, May 12, 2004 9:27 AM
Subject: [Mapserver-users] Generating dynamic point layer


> Hello group,
>
>
>                                               Samuzzal
>
>
>
> _____________________________________________________________
> Linux.Net -->Open Source to everyone
> Powered by Linare Corporation
> http://www.linare.com/ 
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu 
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users 
>
> -- 
> Ce message a ete verifie par MailScanner pour des virus ou des polluriels
et rien de suspect n'a ete trouve.
>
> Les donnees et renseignements contenus dans ce message sont personnels,
confidentiels et prives. Toute publication, utilisation ou diffusion, meme
partielle, doit etre autorisee.
>
> Any data and information contained in this electronic mail is personal,
confidential and secret. Any total or partial publication, use or
distribution must be authorized.


-- 
Ce message a ete verifie par MailScanner pour des virus ou des polluriels et rien de suspect n'a ete trouve.

Les donnees et renseignements contenus dans ce message sont personnels, confidentiels et prives. Toute publication, utilisation ou diffusion, meme partielle, doit etre autorisee.

Any data and information contained in this electronic mail is personal, confidential and secret. Any total or partial publication, use or distribution must be authorized.

_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu 
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users