OGR Virtual
Simbiosis Amorpha
simbiotico at HOTMAIL.COM
Thu Feb 9 18:47:12 EST 2006
Hi Mark,
I actually got my ovf running. Try enabling debugging in mapserver and in
the database server. I got my problem solved after debugging the messages
from mapserver in my logs.
Frank
>From: Mark Adams <markadams at CUESTASYS.COM>
>Reply-To: Mark Adams <markadams at CUESTASYS.COM>
>To: MAPSERVER-USERS at LISTS.UMN.EDU
>Subject: Re: [UMN_MAPSERVER-USERS] OGR Virtual
>Date: Thu, 9 Feb 2006 16:35:23 -0500
>
>Clint,
>
>Thanks for the response, but you may be getting my posting and the one I
>was
>responding to mixed up. My extent is defined in my MAP file as follows:
> EXTENT 500599 4799427 502325 4801598
>I derived the coordinates for my sample polygon by actually looking at the
>map of the other layers... so I can't see this being an extents issue.
>
>Thanks.
>
>------------------------------
>Mark Adams
>Senior Analyst & Project Manager
>Cuesta Systems (DPRA Canada)
>5230 South Service Road
>Burlington, ON L7L 5K2
>Phone: 905-333-4544 x14
>Fax: 905-333-0455
>Email: mark.adams at dpra.com
>
>
>-----Original Message-----
>From: Clint Johnson [mailto:cjohnson at refractions.net]
>Sent: February 9, 2006 4:24 PM
>To: Mark Adams
>Subject: Re: [UMN_MAPSERVER-USERS] OGR Virtual
>
>Mark,
>
>You are correct about not needing any projection elements when all data
>is of the same projection; however, this is because MapServer will
>assume all layers use the same projection
>(http://mapserver.gis.umn.edu/docs/reference/mapfile/projection
>at bottom under Important Notes).
>
>But for that to happen Mapserver will need to read that projection from
>the ciudad layer as ogrinfo clearly stated the following about the
>parcel_test layer...
>
>Layer name: PROPERTY_VIRTUAL
>Geometry: Unknown (any)
>Feature Count: 1
>Layer SRS WKT:
>(unknown)
>
>Thus it wouldn't hurt to explicitly state the projection.
>However, since no errors were produced when creating the map image, I
>have a "feeling" that this may be an extent issue.
>
>
>Look at the map file and your polygon. Are you *sure* that your
>polygon's geometry fits inside of your specified extent?
>
>EXTENT -90.760314 14.252771 -90.210352 14.937117
>
>vs
>
>POLYGON('501453.34 4800585.97,501576.14 4800590.44,501569.85
>4800522,501471.61 4800521.63,501453.34 4800585.97')
>
>
>Cheers,
>Clint
>
>--
>Clint Johnson
>Refractions Research Inc.
>Cjohnson at refractions.net
>
>
>
>Mark Adams wrote:
> > I will try that. However, my understanding of PROJECTION is that it is
>not
> > required unless you have data in more than one projection, or want to
> > display the data in a projection different from the one the data is in.
>Is
> > that not correct?
> >
> > Thanks.
> >
> > ------------------------------
> > Mark Adams
> > Senior Analyst & Project Manager
> > Cuesta Systems (DPRA Canada)
> > 5230 South Service Road
> > Burlington, ON L7L 5K2
> > Phone: 905-333-4544 x14
> > Fax: 905-333-0455
> > Email: mark.adams at dpra.com
> >
> >
> > -----Original Message-----
> > From: Emil Zegers [mailto:taatuut at planet.nl]
> > Sent: February 9, 2006 3:41 PM
> > To: Mark Adams; MAPSERVER-USERS at LISTS.UMN.EDU
> > Subject: RE: [UMN_MAPSERVER-USERS] OGR Virtual
> >
> > Hello Mark,
> >
> > Have you tried adding a PROJECTION to the LAYER containing the ovf file
> > and/or the ovf file?
> >
> > Something like:
> >
> > LAYER
> > NAME "Virtual Parcel"
> > DEBUG ON
> > STATUS DEFAULT
> > CONNECTIONTYPE OGR
> > CONNECTION "parcel_test.ovf"
> > DATA "parcel_test"
> > TYPE POLYGON
> > # fill projection parameter, e.g. 28992 for Dutch system
> > PROJECTION
> > "init=epsg:12345"
> > END
> > TEMPLATE "null"
> > CLASS
> > NAME "Virtual Parcel"
> > STYLE
> > COLOR 255 1 5
> > OUTLINECOLOR 168 112 0
> > END
> > END
> > END
> >
> >
> > In the past I had situations where I needed to put the PROJECTION in the
> > LAYER and not in the OVF file.
> >
> > Also, use STATUS DEFAULT for testing purposes so the layer is always on.
> >
> > Regards,
> >
> > Emil
> >
> >
> > -----Original Message-----
> > From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU]On
> > Behalf Of Mark Adams
> > Sent: donderdag 9 februari 2006 21:12
> > To: MAPSERVER-USERS at LISTS.UMN.EDU
> > Subject: Re: [UMN_MAPSERVER-USERS] OGR Virtual
> >
> >
> > Hello,
> >
> > I would like to know if there was ever a successful resolution to
>Frank's
> > question below. I am in the same situation: I cannot get the OGR virtual
> > layer to render on my map.
> >
> > I have had no problem with points. However when I try to render a
>virtual
> > polygon I get no error, just no feature on the map. The other layers all
> > render without problem. I get no error from OGRINFO either.
> >
> > I've tried a number of different ways of configuring the OVF file, the
> > data in the database, and the MAP file. Numerous combinations result
> > in "success" in the sense of no errors, but still no features.
> >
> > Here is my most recent attempt:
> > Connection: I'm using an ODBC connection to an MS Access database. The
> > ODBC connection is called "parcel_test".
> >
> > OVF:
> > <OGRVRTDataSource>
> > <OGRVRTLayer name="parcel_test">
> > <SrcDataSource>ODBC:parcel_test,PROPERTY_VIRTUAL</SrcDataSource>
> > <SrcSQL>SELECT GEOMETRY FROM PROPERTY_VIRTUAL</SrcSQL>
> > <GeometryType>wkbPolygon</GeometryType>
> > <GeometryField encoding="WKT" field="GEOMETRY"/>
> > </OGRVRTLayer>
> > </OGRVRTDataSource>
> >
> > MAP:
> > LAYER
> > NAME "Virtual Parcel"
> > DEBUG ON
> > STATUS ON
> > CONNECTIONTYPE OGR
> > CONNECTION "parcel_test.ovf"
> > DATA "parcel_test"
> > TYPE POLYGON
> > TEMPLATE "null"
> > CLASS
> > NAME "Virtual Parcel"
> > STYLE
> > COLOR 255 1 5
> > OUTLINECOLOR 168 112 0
> > END
> > END
> > END
> >
> > I've got one record in the PROPERTY_VIRTUAL table, with the GEOMETRY
>value
> > set as follows:
> > POLYGON('501453.34 4800585.97,501576.14 4800590.44,501569.85
> > 4800522,501471.61 4800521.63,501453.34 4800585.97')
> >
> > I've also tried storing the geometry without the quotes, brackets, and
> > keyword POLYGON but it doesn't change the result.
> >
> > I've captured this output when I refresh the map:
> > msOGRFileOpen(parcel_test.ovf)...
> > OGROPen
> >
>(\\Snow\c_drive\Inetpub\wwwroot\NTGO_GeoPortal\config\..\Data\Shapefiles/pa
> > rcel_test.ovf)
> > msOGRLayerClose(parcel_test.ovf).
> > msOGRFileClose
> >
>(\\Snow\c_drive\Inetpub\wwwroot\NTGO_GeoPortal\config\..\Data\Shapefiles/pa
> > rcel_test.ovf,0).
> > msDrawMap(): Layer 3 (Virtual Parcel), 0.130s
> > msDrawMap(): Layer 4 (Property Parcels), 0.101s
> > msDrawMap(): Layer 6 (Streets), 0.030s
> > msDrawMap(): Drawing Label Cache, 0.000s
> > msDrawMap() total time: 0.281s
> > msOGRFileOpen(parcel_test.ovf)...
> > OGROPen
> >
>(\\Snow\c_drive\Inetpub\wwwroot\NTGO_GeoPortal\config\..\Data\Shapefiles/pa
> > rcel_test.ovf)
> > msOGRLayerClose(parcel_test.ovf).
> > msOGRFileClose
> >
>(\\Snow\c_drive\Inetpub\wwwroot\NTGO_GeoPortal\config\..\Data\Shapefiles/pa
> > rcel_test.ovf,0).
> > msDrawMap(): Layer 3 (Virtual Parcel), 0.110s
> > msDrawMap(): Layer 4 (Property Parcels), 0.070s
> > msDrawMap(): Layer 6 (Streets), 0.030s
> > msDrawMap(): Drawing Label Cache, 0.000s
> > msDrawMap() total time: 0.220s
> >
> > >From the FWTools command line I get this:
> > C:\Program Files\FWTools1.0.0a7>ogrinfo ODBC:parcel_test
> > INFO: Open of `ODBC:parcel_test'
> > using driver `ODBC' successful.
> > 1: PROPERTY_VIRTUAL
> >
> >
> > C:\Program Files\FWTools1.0.0a7>ogrinfo ODBC:parcel_test
>PROPERTY_VIRTUAL
> > INFO: Open of `ODBC:parcel_test'
> > using driver `ODBC' successful.
> >
> > Layer name: PROPERTY_VIRTUAL
> > Geometry: Unknown (any)
> > Feature Count: 1
> > Layer SRS WKT:
> > (unknown)
> > OBJECTID: Integer (10.0)
> > STATUS: String (20.0)
> > UTM_X: Real (0.0)
> > UTM_Y: Real (0.0)
> > AREA: Real (0.0)
> > SHAPE_Length: Real (0.0)
> > SHAPE_Area: Real (0.0)
> > HERITAGE: String (20.0)
> > PAR_UPDATE: String (10.0)
> > UPDATE_DATE: String (20.0)
> > CREATE_DATE: String (20.0)
> > UPDATE_SOURCE: String (50.0)
> > AREA_ACRE: Real (0.0)
> > PID: Integer (10.0)
> > AREA_HECTARE: Real (0.0)
> > OGRFeature(PROPERTY_VIRTUAL):0
> > OBJECTID (Integer) = 2
> > STATUS (String) = Active
> > UTM_X (Real) = 501405.687500125
> > UTM_Y (Real) = 4801949.24999883
> > AREA (Real) = 229.843703627485
> > SHAPE_Length (Real) = 77.3317483960398
> > SHAPE_Area (Real) = 229.843703627485
> > HERITAGE (String) = PART V
> > PAR_UPDATE (String) = (null)
> > UPDATE_DATE (String) = (null)
> > CREATE_DATE (String) = (null)
> > UPDATE_SOURCE (String) = (null)
> > AREA_ACRE (Real) = 0.0567943791663515
> > PID (Integer) = 42385
> > AREA_HECTARE (Real) = 0.0229843703627485
> >
> > Any help would be greatly appreciated. I have several polygon layers to
> > publish this way, ultimately from an Oracle database.
> >
> > Thanks in advance,
> >
> > ------------------------------
> > Mark Adams
> > Senior Analyst & Project Manager
> > Cuesta Systems (DPRA Canada)
> > 5230 South Service Road
> > Burlington, ON L7L 5K2
> > Phone: 905-333-4544 x14
> > Fax: 905-333-0455
> > Email: mark.adams at dpra.com
> >
> >
> > On Wed, 21 Dec 2005 00:10:06 -0600, Frank Fica <simbiotico at HOTMAIL.COM>
> > wrote:
> >
> >
> >> Hello,
> >>
> >> I've been trying to map a non-spatial postgre table with ogr via ODBC
>but
> >>
> > no success. There must
> >
> >> be a simple solution to what I'm missing and I haven't been able to
> >>
> > figure it out. My other layers
> >
> >> do render but my Virtual layer doesn't. When I test in ogrinfo I can
> >>
> > connect but when I try to map
> >
> >> in mapserver the image is blank, only my mapinfo layer renders.
> >>
> >> Does someone has any suggestions on what I'm missing?
> >>
> >> Here are is my ovf file:
> >>
> >> <OGRVRTDataSource>
> >> <OGRVRTLayer name="sorento">
> >> <SrcDataSource>ODBC:@PostgreSQL,sorento</SrcDataSource>
> >> <SrcLayer>sorento</SrcLayer>
> >> <GeometryType>wkbPoint</GeometryType>
> >> <GeometryField encoding="PointFromColumns" x="Lon" y="Lat"/>
> >> </OGRVRTLayer>
> >> </OGRVRTDataSource>
> >>
> >> and map file:
> >>
> >> MAP
> >> IMAGETYPE PNG
> >> EXTENT -90.760314 14.252771 -90.210352 14.937117
> >> SIZE 640 480
> >> UNITS METERS
> >>
> >> SYMBOL
> >> NAME "circle"
> >> TYPE ELLIPSE
> >> POINTS
> >> 1 1
> >> END
> >> FILLED TRUE
> >> END
> >>
> >> LAYER
> >> NAME "ciudad"
> >> TYPE POLYGON
> >> STATUS ON
> >> CONNECTIONTYPE OGR
> >> CONNECTION "/var/www/html/guatemala/data/ciudad.tab"
> >> STYLEITEM "AUTO"
> >> CLASS
> >> NAME "Ciudad"
> >> END
> >> END
> >>
> >> LAYER
> >> NAME "sorento"
> >> TYPE POINT
> >> CONNECTIONTYPE OGR
> >> CONNECTION "virtual.ovf"
> >> DATA "sorento"
> >> STATUS DEFAULT
> >> CLASS
> >> STYLE
> >> SYMBOL 'circle'
> >> SIZE 30
> >> COLOR 255 0 0
> >> END
> >> END
> >> END
> >> END
> >>
More information about the mapserver-users
mailing list