[mapserver-users] GetFeatureInfo over OGR OCI Layer
David Alda Fernandez de Lezea
dalda at ikt.es
Thu Oct 7 02:15:09 EDT 2010
Sebastian,
Thanks for your response.
If I execute that line of code I get a confusing response. It seems that recognizes the table but there are som errors that make me think there is something wrong.
C:\ms4w>ogrinfo OCI:admcarto/admcarto at ORA10GEX GV_SIGPAC_REC_ED50
ERROR 1: ORA-04043: object GV_INVFOR_2005_ED50 does not exist
in OCIDescribeAny
ERROR 1: ORA-04043: object GV_SIGPAC_PAR_ED50 does not exist
in OCIDescribeAny
ERROR 1: ORA-04043: object GV_SIGPAC_POL_ED50 does not exist
in OCIDescribeAny
ERROR 1: ORA-04043: object GV_SIGPAC_REC_ED50 does not exist
in OCIDescribeAny
INFO: Open of `OCI:admcarto/admcarto at ORA10GEX'
using driver `OCI' successful.
Layer name: GV_SIGPAC_REC_ED50
Geometry: Unknown (any)
Feature Count: 946359
ERROR 1: ORA-03113: fin de archivo en el canal de comunicaci¾n
in SELECT MIN(SDO_GEOM.SDO_MIN_MBR_ORDINATE(t.GEOMETRY,m.DIMINFO,1)) AS MINX,MI
N(SDO_GEOM.SDO_MIN_MBR_ORDINATE(t.GEOMETRY,m.DIMINFO,2)) AS MINY,MAX(SDO_GEOM.SD
O_MAX_MBR_ORDINATE(t.GEOMETRY,m.DIMINFO,1)) AS MAXX,MAX(SDO_GEOM.SDO_MAX_MBR_ORD
INATE(t.GEOMETRY,m.DIMINFO,2)) AS MAXY FROM ALL_SDO_GEOM_METADATA m, GV_SIGPAC_
REC_ED50 t WHERE m.TABLE_NAME = 'GV_SIGPAC_REC_ED50' AND m.COLUMN_NAME='GEOMETRY
'
ERROR 1: ORA-03114: no conectado a ORACLE
in SELECT "GEOMETRY","GID","PROVINCIA","MUNICIPIO","POLIGONO","PARCELA","RECINT
O","DN_SURFACE","DN_PERIMET","PENDIENTE","ELEGIBILIDAD","COEF_REGAD","COEF_PASTO
","USO_SIGPAC","USO_2003","PARCELA_AG","DN_OID","FECHA" FROM GV_SIGPAC_REC_ED50
Layer SRS WKT:
PROJCS["UTM Zone 30 (ED 50)",
GEOGCS["European 1950",
DATUM["European 1950",
SPHEROID["International 1924",6378388,297]],
PRIMEM["Greenwich",0.000000],
UNIT["Decimal Degree",0.01745329251994330]],
PROJECTION["Transverse Mercator"],
PARAMETER["Scale_Factor",0.999600],
PARAMETER["Central_Meridian",-3.000000],
PARAMETER["False_Easting",500000.000000],
UNIT["Meter",1.000000000000],
AUTHORITY["Oracle","82337"]]
Geometry Column = GEOMETRY
GID: Integer (10.0)
PROVINCIA: Integer (2.0)
MUNICIPIO: Integer (3.0)
POLIGONO: Integer (3.0)
PARCELA: Integer (5.0)
RECINTO: Integer (3.0)
DN_SURFACE: Real (15.5)
DN_PERIMET: Real (15.5)
PENDIENTE: Real (4.1)
ELEGIBILIDAD: Integer (3.0)
COEF_REGAD: Integer (3.0)
COEF_PASTO: Integer (3.0)
USO_SIGPAC: String (2.0)
USO_2003: String (2.0)
PARCELA_AG: String (30.0)
DN_OID: Integer (10.0)
FECHA: Date (0.0)
ERROR 1: ORA-03114: no conectado a ORACLE
in SELECT "GEOMETRY","GID","PROVINCIA","MUNICIPIO","POLIGONO","PARCELA","RECINT
O","DN_SURFACE","DN_PERIMET","PENDIENTE","ELEGIBILIDAD","COEF_REGAD","COEF_PASTO
","USO_SIGPAC","USO_2003","PARCELA_AG","DN_OID","FECHA" FROM GV_SIGPAC_REC_ED50
C:\ms4w>
Any idea?
Thanks again.
________________________________
De: sebastianovide at gmail.com [mailto:sebastianovide at gmail.com] En nombre de Sebastian E. Ovide
Enviado el: miércoles, 06 de octubre de 2010 17:14
Para: David Alda Fernandez de Lezea
CC: mapserver-users at lists.osgeo.org
Asunto: Re: [mapserver-users] GetFeatureInfo over OGR OCI Layer
does
ogrinfo OCI:admcarto/admcarto at ORA10GEX GV_SIGPAC_REC_ED50
work ?
On Fri, Oct 1, 2010 at 12:25 PM, David Alda Fernandez de Lezea <dalda at ikt.es> wrote:
Hi list,
I'm trying to execute a GetFeatureInfo request over an Oracle layer via OGR. I can view the content of the layer, but when I make the request I don't get any result. I mean, I receive an empty GML. My layer config:
LAYER
STATUS ON
CONNECTION "OCI:admcarto/admcarto at ORA10GEX"
CONNECTIONTYPE OGR
DATA "GV_SIGPAC_REC_ED50" #todo el sigpac
NAME "RecintosSigpacOGR"
PROJECTION
"init=epsg:23030"
END
DUMP TRUE
TYPE POLYGON
METADATA
"wms_title" "Recintos Sigpac 2009"
"wms_srs" "EPSG:23030"
"wms_name" "RecintosSigpacOGR"
"wms_server_version" "1.1.1"
"wms_format" "image/gif"
"wms_transparent" "true"
"wms_extent" "460000 4690000 610000 4820000"
"wms_include_items" "all"
"gml_include_items" "all"
END
MAXSCALE 10000
TEMPLATE "ms_template.html"
PROCESSING "LABEL_NO_CLIP=ON"
PROCESSING "CLOSE_CONNECTION=DEFER"
SYMBOLSCALE 5000
#Simbologia
CLASSGROUP "Simbologia_Recintos"
CLASS
TEXT ([PARCELA]:[RECINTO])
STYLE
OUTLINECOLOR 0 234 0
END
LABEL
COLOR 254 254 255
OUTLINECOLOR 0 0 0
TYPE truetype
FONT "sans"
SIZE 6
POSITION cc
PARTIALS TRUE
END
NAME "RecintosSigPac"
GROUP "Referencia_Sigpac"
END
CLASS
STYLE
OUTLINECOLOR 0 234 0
WIDTH 1
END
NAME "RecintosSigPac"
GROUP "Predeterminado"
END
END
Resultant file
<?xml version="1.0" encoding="ISO-8859-1"?>
<msGMLOutput
xmlns:gml="http://www.opengis.net/gml"
xmlns:xlink="http://www.w3.org/1999/xlink"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
</msGMLOutput>
Any ideas? Something wrong configured?
Thanks.
Un saludo,
··················································································
David Alda Fernández de Lezea
Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y Biodiversidad
IKT
Granja Modelo s/n · 01192 · Arkaute (Araba)
··················································································
Tlfnos.: 945-00-32-95 Fax: 945-00.32.90
··················································································
email: dalda at ikt.es web: www.ikt.es
··················································································
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
--
Sebastian E. Ovide
More information about the mapserver-users
mailing list