mapping xy tables directly

[Fischer, Brian]

Hi Kevin, we are using an access database with the OGR OVF support to
display points out of a database table.  Simply create an OBDC System
DSN connection to the dateabase, create your layer in the mapfile and
.ovf file.  Then you use the layer just like you normally would with
MapServer.  I provided an example of the layer in the mapfile and ovf
file.  How this helps.  Brian

 

Here is the layer file:

LAYER

      NAME permits_062405

      STATUS OFF

      TYPE POINT

      CONNECTIONTYPE OGR

      CONNECTION "permits.ovf"

      DATA "permits_062405"

      HEADER permitheader.html

      TEMPLATE permitresults.html

      FOOTER permitfooter.html

      MAXSCALE 1250000

      SYMBOLSCALE 50000

      LABELMAXSCALE 100000

      LABELITEM 'PERMIT_NUM'

      CLASSITEM 'YEAR'

      CLASS

        NAME "2005 Permits"

        EXPRESSION '2005'

        SYMBOL 'star'

        COLOR 255 0 0

        SIZE 9

        MINSIZE 9

        MAXSIZE 12

      END

  END

 

Here is the ovf file: 

<OGRVRTDataSource>

            <OGRVRTLayer name="permits_062405">

 
<SrcDataSource>ODBC:RLWDPERMITS,RLWD_Permits</SrcDataSource>

                        <SrcLayer>RLWD_Permits</SrcLayer>

                        <GeometryType>wkbPoint</GeometryType>

                        <GeometryField encoding="PointFromColumns"
x="X_Coordinates" y="Y_Coordinates"/>

            </OGRVRTLayer>

</OGRVRTDataSource>

 

Brian Fischer

Houston Engineering, Inc.

Maple Grove, MN

(763) 493-4522

________________________________

From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of Kevin Flanders
Sent: Friday, January 20, 2006 2:33 PM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] mapping xy tables directly

 

Can anyone provide a quick description of how I can map xy tables
directly?

 

 

Kevin 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060120/ad0391a1/attachment.htm>