Hello.
As always trying to coerce these two to work together nicely...
The situation: exporting ArcSDE feature class to <anything>, shapefile, gpx...
server: Oracle xe (10), ArcSDE 9.3 sp1, Win2003 Std x32
client: Vista x32, GDAL/OGR 1.6 build 1500 from Tamas site, sde dll's from 9.3
sp1
As you can see below, Oracle describes several fields as being number and
nvarchar2, and ogrinfo only identifies numeric fields. All text fields come out
as unknown.
Now, what could this be due to? Anyone facing the same issue? I tried to use
SQL to cast a nvarchar to character without success...
Thanks,
Duarte
Feature class description in Oracle:
Column Name Data Type Nullable Default Primary Key
OBJECTID NUMBER No - -
IDPERC NVARCHAR2(6) Yes - -
NOME NVARCHAR2(150) Yes - -
DESCRICAO NVARCHAR2(255) Yes - -
IDPONTO NVARCHAR2(10) Yes - -
IDSIG NUMBER Yes - -
XCOORD NUMBER(38,8) Yes - -
YCOORD NUMBER(38,8) Yes - -
MORADA_COMPLETA NVARCHAR2(255) Yes - -
CONCELHO NVARCHAR2(50) Yes - -
FREGUESIA NVARCHAR2(50) Yes - -
CODPOSTAL NVARCHAR2(10) Yes - -
TELEFONE NVARCHAR2(10) Yes - -
DESCRICAOPT NVARCHAR2(255) Yes - -
NOMEPT NVARCHAR2(150) Yes - -
SHAPE ST_GEOMETRY Yes - -
1 - 16
ogrinfo output:
Layer name: <user>.<table>
Geometry: Unknown (any)
ERROR 1: SE_layer_get_statistics: -51/Underlying DBMS error
Feature Count: -1
Extent: (6177.862000, -123296.045000) - (63997.354000, -91245.397000)
Layer SRS WKT:
PROJCS["Datum_73_Hayford_Gauss_IPCC",
GEOGCS["GCS_Datum_73",
DATUM["Datum_73",
SPHEROID["International_1924",6378388.0,297.0]],
PRIMEM["Greenwich",0.0],
UNIT["Degree",0.0174532925199433]],
PROJECTION["Transverse_Mercator"],
PARAMETER["False_Easting",180.598],
PARAMETER["False_Northing",-86.99],
PARAMETER["Central_Meridian",-8.131906111111112],
PARAMETER["Scale_Factor",1.0],
PARAMETER["Latitude_Of_Origin",39.66666666666666],
UNIT["Meter",1.0]]
OBJECTID: Integer (10.0)
IDPERC: (unknown) (6.0)
NOME: (unknown) (50.0)
DESCRICAO: (unknown) (50.0)
IDLINHA: (unknown) (5.0)
SHAPE_LENG: Real (38.8)
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
