tried... but still no luck...
g...@mapserver:~$ ogrinfo OCI:la002/la...@192.168.60.70/MFUATDB -sql 'Select
T.Entry_Id as id, SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(T.Xcoord, T.Ycoord,
NULL), NULL, NULL) as geom From Lookupindex T;'
INFO: Open of `OCI:la002/la...@192.168.60.70/MFUATDB'
using d
Hi Sebastian
maybe Select T.Entry_Id id, SDO_GEOMETRY(2001,8307,SDO_
POINT_TYPE(T.Xcoord, T.Ycoord, NULL), NULL, NULL)* AS* geom From Lookupindex
T; ?
regards, michael
On 15 November 2010 17:46, Sebastian E. Ovide wrote:
> Hi All,
>
> I have a table which has an X and Y columns. It doesn't hav
Hi All,
I have a table which has an X and Y columns. It doesn't have a geometry
column.
In order to read geometries created on the fly, I'm trying to use ogrinfo
with the -sql parameter.
So the Oracle query is:
Select T.Entry_Id id, SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(T.Xcoord,
T.Ycoord, NUL
