getFeatureInfo against unique character primary key
Sebastian Schmitz
sebastian.schmitz at WHEREGROUP.COM
Fri Feb 23 07:51:16 EST 2007
Hi,
anybody out there having the need for MapServer being able to serve
getFeatureInfo against unique character primary key columns?
Cheers
Sebastian Schmitz
Bart van den Eijnden (OSGIS) schrieb:
> It's a restriction from Mapserver side.
>
> You can't change your view SQL so that it has an integer primary key column?
>
> Best regards,
> Bart
>
> --
> Bart van den Eijnden
> OSGIS, Open Source GIS
> http://www.osgis.nl
>
>
> --------- Oorspronkelijk bericht --------
> Van: Sebastian Schmitz <sebastian.schmitz at WHEREGROUP.COM>
> Naar: MAPSERVER-USERS at LISTS.UMN.EDU <MAPSERVER-USERS at LISTS.UMN.EDU>
> Onderwerp: Re: [UMN_MAPSERVER-USERS] OracleSpatial getFeatureInfo problem
> against unique column containing text
> Datum: 23/02/07 09:32
>
>
>> Now what do I do?
>>
>> Is this a restriction from Oracle-side or from MapServer?
>> MapServer I guess?
>>
>> Cheers
>>
>> Sebastian
>>
>> Bart van den Eijnden (OSGIS) schrieb:
>> > No this is not possible.
>> >
>> > You need to use an integer for the unique column. It's a requirement.
>> >
>> > Best regards,
>> > Bart
>> >
>> > --
>> > Bart van den Eijnden
>> > OSGIS, Open Source GIS
>> > http://www.osgis.nl
>> >
>> >
>> > --------- Oorspronkelijk bericht --------
>> > Van: Sebastian Schmitz <sebastian.schmitz at WHEREGROUP.COM>
>> > Naar: MAPSERVER-USERS at LISTS.UMN.EDU
>>
> <MAPSERVER-USERS at LISTS.UMN.EDU>
>
>> > Onderwerp: [UMN_MAPSERVER-USERS] OracleSpatial getFeatureInfo problem
>> > against unique column containing text
>> > Datum: 23/02/07 08:33
>> >
>> >
>> >> Hi,
>> >>
>> >> I have a view in Oracle Spatial 10gR2 with a unique Id, which is
>>
> text.
>
>> >> MapServer draws the map OK using oraclespatial CONNECTIONTYPE.
>> >> However, MapServer is unable to serve a getFeatureInfo request
>>
> against
>
>> >> that view. If I change the DATA statement to substr(ID, 3,7),
>>
> removing
>
>> >> letters from the ID - getFeatureInfo runs fine for the time
>>
> being, but
>
>> >> without the letters my ID will soon lose its uniqueness.
>> >>
>> >> Is MapServer able to server a getFeatureInfo request against DATA
>>
> that
>
>> >> uses a unique text-column containing letters?
>> >>
>> >> Find more detail below:
>> >> mapfile:
>> >> ...
>> >> CONNECTIONTYPE oraclespatial
>> >> CONNECTION &quot;GDI/****@ORCL_HOGGNO&quot;
>> >> #not serving getFeatureInfo
>> >> DATA &quot;GEOM FROM V_*** USING UNIQUE SST_NR SRID 8307
>>
> FILTER VERSION
>
>> >>
>> > 10g&quot;
>> >
>> >> #serving getFeatureInfo
>> >> DATA &quot;GEOM FROM V_*** USING UNIQUE substr(SST_NR,3,7)
>>
> SRID 8307
>
>> >>
>> > FILTER
>> >
>> >> VERSION 10g&quot;
>> >> FILTER &quot;BEREICHKZ = '3'&quot;
>> >> ...
>> >>
>> >> log:
>> >> Fri Feb 23 10:54:40 2007 - msOracleSpatialLayerGetShape():
>>
> OracleSpatial
>
>> >> error. Error: ORA-01722: invalid number
>> >> . Query statement: SELECT ***,***, GEOM FROM V_*** WHERE SST_NR
>>
> = 0 AND
>
>> >> BEREICHKZ = '2' .Check your data statement.
>> >>
>> >> SST_NR in this case should not be null, but sth. like 'SS0023093
>>
> '.
>
>> >>
>> >> Cheers
>> >>
>> >> Sebastian
>> >>
>> >> --
>> >> ---------------------------------------
>> >> WhereGroup GmbH &amp; Co. KG
>> >> Siemensstraße 8
>> >> 53121 Bonn
>> >> -------------------------------
>> >> Fon: +49 (0)228 / 90 90 38 - 24
>> >> Fax: +49 (0)228 / 90 90 38 - 11
>> >> -------------------------------
>> >> mailto:sebastian.schmitz at wheregroup.com
>> >> http://www.wheregroup.com
>> >> -------------------------------
>> >> Komplementärin:
>> >> WhereGroup Verwaltungs GmbH
>> >> vertreten durch:
>> >> Arnulf Christl, Olaf Knopp, Peter Stamm
>> >> Amtsgericht Bonn, HRB 9885
>> >> ---------------------------------------
>> >>
>> >>
>> >>
>>
>> --
>> ---------------------------------------
>> WhereGroup GmbH & Co. KG
>> Siemensstraße 8
>> 53121 Bonn
>> -------------------------------
>> Fon: +49 (0)228 / 90 90 38 - 24
>> Fax: +49 (0)228 / 90 90 38 - 11
>> -------------------------------
>> mailto:sebastian.schmitz at wheregroup.com
>> http://www.wheregroup.com
>> -------------------------------
>> Komplementärin:
>> WhereGroup Verwaltungs GmbH
>> vertreten durch:
>> Arnulf Christl, Olaf Knopp, Peter Stamm
>> Amtsgericht Bonn, HRB 9885
>> ---------------------------------------
>>
>>
>>
--
---------------------------------------
WhereGroup GmbH & Co. KG
Siemensstraße 8
53121 Bonn
-------------------------------
Fon: +49 (0)228 / 90 90 38 - 24
Fax: +49 (0)228 / 90 90 38 - 11
-------------------------------
mailto:sebastian.schmitz at wheregroup.com
http://www.wheregroup.com
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885
---------------------------------------
--
---------------------------------------
WhereGroup GmbH & Co. KG
Siemensstraße 8
53121 Bonn
-------------------------------
Fon: +49 (0)228 / 90 90 38 - 24
Fax: +49 (0)228 / 90 90 38 - 11
-------------------------------
mailto:sebastian.schmitz at wheregroup.com
http://www.wheregroup.com
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885
---------------------------------------
More information about the mapserver-users
mailing list