Re: [UMN_MAPSERVER-USERS] mapping xy tables directly

Fri, 20 Jan 2006 12:54:22 -0800

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:[EMAIL PROTECTED] On Behalf Of Kevin Flanders
Sent: Friday, January 20, 2006 2:33 PM
To: [email protected]
Subject: [UMN_MAPSERVER-USERS] mapping xy tables directly

 

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

 

 

Kevin

Reply via email to