[mapserver-dev] Oracle SQL (MS trunk)

[bartvde at osgis.nl]

Ofcourse, I can also add "GML_EXCLUDE_ITEMS" "null" to exclude it, but it
would be nicer if this would be automagically :-)

Best regards,
Bart

> Hi Mike,
>
> thanks, right, it is an SE_ANNO_CAD_DATA column, but nulling it out also
> means it is also output in the WFS GML, which is unwanted (shows up in
> attribute tables etc.):
>
> ..
> <rws:PERIMETER>13507.68</rws:PERIMETER>
> <rws:null/>
> </rws:AAA35>
> ..
>
> Do you see a solution?
>
> Or do I need to change my DATA statement to exclude it (but then again, I
> need to always change the SQL when the datamodel changes).
>
> TIA.
>
> Best regards,
> Bart
>
>> Bart,
>>
>> I'm not sure about the 2 objectid's, but it is probably due to
>> requesting
>> unique OBJECTID. This gets added to the column list with has all the
>> columns
>> already present. The NULL is probably a blob column, perhaps an
>> SE_ANNO_CAD_DATA column. NULLing it out was a patch I submitted to allow
>> WFS
>> to work when you have a blob column.
>>
>> Mike
>>
>>
>> --
>> Michael Smith
>> RSGIS Center
>> US Army Corps of Engineers
>>
>>
>>
>>
>> On 12/10/09 6:30 AM, "bartvde at osgis.nl" <bartvde at osgis.nl> wrote:
>>
>>> Hi list,
>>>
>>> using Mapserver trunk I see the following SQL being generated for
>>> Oracle
>>> Spatial layers:
>>>
>>> SELECT OBJECTID, OBJECTID, VOOR, LETTER, CYFER, KALK, ACHTER, SCHOP,
>>> HEL,
>>> GWT, CODE, OMSCHR, EERSTE_BOD, EERSTE_GWT, KLEUR_BOD, KLEUR_GWT, AREA,
>>> PERIMETER, null, SHAPE FROM BODEM.BODEMKAART50 WHERE  ROWNUM<=5  AND
>>> SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, :srid,
>>> NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates
>>> ),'querytype=window')
>>> = 'TRUE'
>>>
>>> Questions:
>>>
>>> 1) why is OBJECTID requested twice? DATA statement is "SHAPE FROM
>>> BODEM.BODEMKAART50 USING UNIQUE OBJECTID".
>>> 2) where is the null after PERIMETER coming from?
>>>
>>> Best regards,
>>> Bart
>>>
>>> _______________________________________________
>>> mapserver-dev mailing list
>>> mapserver-dev at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>>
>>
>
>
>