No subject

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