[mapserver-users] GetFeatureInfo over OGR OCI Layer

David Alda Fernandez de Lezea dalda at ikt.es
Wed Oct 6 23:15:09 PDT 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