Problem configuring WFS-SERVER on oraclespatial layers
Fernando Simon
fsimon at UNIVALI.BR
Wed Jun 8 08:48:48 EDT 2005
Hi folks,
Needs to be a number datatype.
I use the UNIQUE column as a internal (Mapserver core) identifier
for shapeindex, Mapserver store this value as long type.
Usually I use the primary key as UNIQUE, but you can specify another
(number) column for the restrict option. If you don't specify any UNIQUE
maporaclespatial.c use the rownum in sql, but using this way, when the
extent changed, the order for the rows will be different and the rownum
is not equal than before.
Any hints?
------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://g10.cttmar.univali.br - UNIVALI/CTTMAR
------------------------------------------------------------------------
François Prunayre wrote:
>Hi Fernando and Ludovic, I was facing the same problem with WFS GetFeature
>and WMS GetFeatureInfo.
>USING UNIQUE <column> solved the problem for all my Oracle Spatial layers.
>Works well with Mapinfo client or Chameleon.
>
>But it seems that <column> has to be a number. Is Varchar2 datatype
>supported ?
>
>Thanks.
>François
>
>
>-----Message d'origine-----
>De : UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] De la
>part de Fernando Simon
>Envoyé : mercredi 8 juin 2005 13:44
>À : MAPSERVER-USERS at LISTS.UMN.EDU
>Objet : Re: [UMN_MAPSERVER-USERS] Problem configuring WFS-SERVER on
>oraclespatial layers
>
>Hi Ludovic and Bart,
> About the problem with WFS (I'm not a specialist in WFS) did you check
>all the metadata parameters? (upper case/lower case)
> You can check all the messages that Mapserver request to Oracle server
>using a debug flag (inf mapfile and configure for mapserver). You need to
>specify a "--enable-debug" for configure and DEBUG parameter for layer and
>MAP in you mapfile. Using this way all of actions and SQL appear in apache
>error log.
> I recommend to pass the UNIQUE parameter in your DATA definition. In
>UNIQUE parameter you define the column that store the unique values (usually
>primary key) for your table. This is necessary for retrieve the correct data
>from database. You can specify like this: (null SRID is default when you
>don't specify)
> DATA "GEOM FROM BATIMENT USING UNIQUE <column>" example
> DATA "GEOM FROM BATIMENT USING UNIQUE BATIMENT_ID"
> Can you change the data and test the result for this case?
> Thanks.
>
>------------------------------------------------------------------------
>Fernando Simon
>Mapserver and Oracle Spatial developer
>G10 - Laboratorio de Computacao Aplicada - Brazil
>http://g10.cttmar.univali.br - UNIVALI/CTTMAR
>------------------------------------------------------------------------
>
>
>
>ludovic gnemmi wrote:
>
>
>
>>Bart,
>>You were right with MWS...I hat to add "wms_extent" on each layer to
>>make WMS works with MS 4.6...I can now view all my layers with wms:)
>>But still can't see oracle layers with WFS.
>>I don't think communication failing with oracle...I see oracle is
>>processing when sending WFS getfeature request. And i still can see
>>oracle layers with Mapserver in normal use.
>>
>>Thanks.
>>
>>Ludovic
>>
>>
>>
>>--- Bart van den Eijnden <BEN at SYNCERA-ITSOLUTIONS.NL> a écrit :
>>
>>
>>
>>
>>
>>>It seems that all aspects which communicate with Oracle fail. I had a
>>>look at your original post and the GML created only contained the
>>>wfs_extent values you put in the MAP file. So probably all
>>>communication with Oracle is failing.
>>>
>>>The WMS capabilities now use a function to calculate the boundingbox.
>>>If you use a wms_extent metadata it will probably be complete.
>>>
>>>Are you able to get normal maps?
>>>
>>>I hope Fernando Simon can help you further.
>>>
>>>Best regards,
>>>Bart
>>>
>>>Bart van den Eijnden
>>>Syncera IT Solutions
>>>Postbus 270
>>>2600 AG DELFT
>>>
>>>tel.nr.: 015-7512436
>>>email: BEN at Syncera-ITSolutions.nl
>>>
>>>
>>>
>>>
>>>
>>>>>>ludovic gnemmi <l_gnemmi at YAHOO.FR> 06/08/05
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>08:58am >>>
>>>Hi,
>>>I'm now testing with mapserver 4.6 beta3. I still receive nothing with
>>>getfeature request on oraclespatial layers (i can see that oracle is
>>>processing the requests).
>>>
>>>And i'm now receiving an uncomplete xml file when testing wms
>>>capabilities (stoped on <Layer queryable=).
>>>
>>>On more thing, i see a new message in my apache error log : "In
>>>msCleanupOnSignal". ???
>>>
>>>Ludovic
>>>
>>>
>>>
>>>--- Bart van den Eijnden
>>><BEN at Syncera-ITSolutions.NL>
>>>a écrit :
>>>
>>>
>>>
>>>
>>>
>>>>Okay, my information was 4.6 specific. I was assuming you were using
>>>>that version.
>>>>
>>>>Could you try the latest 4.6 beta? There have also been a lot of
>>>>improvements made by Fernando in maporaclespatial.c.
>>>>
>>>>Best regards,
>>>>Bart
>>>>
>>>>Bart van den Eijnden
>>>>Syncera IT Solutions
>>>>Postbus 270
>>>>2600 AG DELFT
>>>>
>>>>tel.nr.: 015-7512436
>>>>email: BEN at Syncera-ITSolutions.nl
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>>>ludovic gnemmi <l_gnemmi at YAHOO.FR> 06/07/05
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>09:22am >>>
>>>>Hi,
>>>>Thanks for your answer Bart but it still doesn't work...I'm trying
>>>>with mapserver 4.4.2...Is gml_include_tems include in mapserver
>>>>4.4.2? Or
>>>>
>>>>
>>>>
>>>>
>>>i'll
>>>
>>>
>>>
>>>
>>>>have to upgrade to 4.4.6?
>>>>
>>>>Ludovic
>>>>
>>>>--- Bart van den Eijnden <bartvde at XS4ALL.NL> a
>>>>
>>>>
>>>>
>>>>
>>>écrit
>>>
>>>
>>>
>>>
>>>>:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>Hi,
>>>>>
>>>>>use:
>>>>>
>>>>>gml_include_items "all"
>>>>>
>>>>>in the METADATA section of your LAYER.
>>>>>
>>>>>Best regards,
>>>>>Bart
>>>>>
>>>>>On Mon, 06 Jun 2005 18:32:03 +0200, ludovic
>>>>>
>>>>>
>>>>>
>>>>>
>>>gnemmi
>>>
>>>
>>>
>>>
>>>>><l_gnemmi at YAHOO.FR>
>>>>>wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>Hi all,
>>>>>>I have a problem configuring WFS-SERVER with oraclespatial (Nativ
>>>>>>support)
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>layers...Everything
>>>>
>>>>
>>>>
>>>>
>>>>>is
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>ok when configuring WMS-SERVER on these layers
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>but i
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>still receive an incomplete XML result when i
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>try
>>>>
>>>>
>>>>
>>>>
>>>>>a
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>getfeature request on my WFS oraclespatial
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>layers
>>>>
>>>>
>>>>
>>>>
>>>>>>(without errors). getcapabilitie request is
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>OK.
>>>
>>>
>>>
>>>
>>>>>>getfeature requests are OK on shapefiles.
>>>>>>
>>>>>>Here is my mapfile:
>>>>>>MAP
>>>>>> NAME "my_wfs"
>>>>>> EXTENT 868470 83215 965015 165840
>>>>>> SIZE 400 300
>>>>>>IMAGETYPE PNG
>>>>>> IMAGECOLOR 255 255 255
>>>>>> STATUS ON
>>>>>> UNITS METERS
>>>>>> FONTSET "path to font"
>>>>>> SYMBOLSET "path to symbol"
>>>>>>SHAPEPATH "path to shape"
>>>>>>
>>>>>>
>>>>>>WEB
>>>>>>IMAGEPATH "path to images"
>>>>>>IMAGEURL "/ms_tmp/"
>>>>>>
>>>>>>METADATA
>>>>>> "wfs_title" "my_wfs"
>>>>>> "wfs_onlineresource"
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>"http://localhost/cgi-bin/mapserv?map=my_wfs.map&"
>>>>
>>>>
>>>>
>>>>
>>>>>> "wfs_srs" "EPSG:27582"
>>>>>>END
>>>>>>END
>>>>>>
>>>>>>#oracle spatial layer
>>>>>>
>>>>>>LAYER
>>>>>>NAME "bati"
>>>>>>TYPE POLYGON
>>>>>>CONNECTIONTYPE oraclespatial
>>>>>>CONNECTION "usr/pass at DB"
>>>>>>DATA "GEOM FROM BATIMENT USING SRID NULL"
>>>>>>DUMP TRUE
>>>>>>STATUS DEFAULT
>>>>>>DEBUG ON
>>>>>>PROJECTION
>>>>>>"init=epsg:27582"
>>>>>>END
>>>>>>METADATA
>>>>>>"wfs_title" "bati"
>>>>>>"wfs_extent" "868470 83215 965015 165840"
>>>>>>END
>>>>>>
>>>>>>CLASSITEM "BAT_CODE"
>>>>>>CLASS
>>>>>> EXPRESSION "01"
>>>>>> COLOR 152 152 152
>>>>>> OUTLINECOLOR 0 0 0
>>>>>>END
>>>>>>CLASS
>>>>>> EXPRESSION "02"
>>>>>> COLOR 202 202 202
>>>>>> OUTLINECOLOR 0 0 0
>>>>>>END
>>>>>>
>>>>>>END
>>>>>>END
>>>>>>
>>>>>>
>>>>>>
>>>>>>here the result of a getfeature request on
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>this
>>>
>>>
>>>
>>>
>>>>>layer:
>>>>>
>>>>>
>>>>>
>>>>>
>>-------------------------------------------------------
>>
>>
>>
>>
>>>>>>-
>>>>>> <wfs:FeatureCollection
>>>>>>xsi:schemaLocation="http://www.opengis.net/wfs
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>http://schemas.opengeospatial.net/wfs/1.0.0/WFS-basic.xsd
>>
>>
>>
>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>http://www.ttt.org/myns
>>>
>>>
>>>
>>>
>>http://localhost/cgi-bin/mapserv?map=my_wfs.map&SERVICE=WFS&VERSION=1..
>>.0.0&REQUEST=DescribeFeatureType&TYPENAME=bati">
>>
>>
>>
>>
>>>>>>-
>>>>>> <gml:boundedBy>
>>>>>>-
>>>>>> <gml:Box srsName="EPSG:27582">
>>>>>>-
>>>>>> <gml:coordinates>
>>>>>>874619.370000,112072.490000
>>>>>>875774.930000,113685.950000
>>>>>></gml:coordinates>
>>>>>></gml:Box>
>>>>>></gml:boundedBy>
>>>>>></wfs:FeatureCollection>
>>>>>>
>>>>>>---------------------------------------
>>>>>>
>>>>>>
>>>>>>Has anybody got an idea?
>>>>>>
>>>>>>Thanks a lot.
>>>>>>
>>>>>>Ludovic
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>_______________________________________________________________________
>>______
>>
>>
>>
>>
>>>>>>Découvrez le nouveau Yahoo! Mail : 1 Go
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>d'espace
>>>
>>>
>>>
>>>
>>>>>de stockage pour vos
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>mails, photos et vidéos !
>>>>>>Créez votre Yahoo! Mail sur
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>http://fr.mail.yahoo.com
>>>>>
>>>>>
>>>>>
>>>>>--
>>>>>Using Opera's revolutionary e-mail client:
>>>>>http://www.opera.com/mail/
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>_______________________________________________________________________
>>______
>>
>>
>>
>>
>>>>Découvrez le nouveau Yahoo! Mail : 1 Go d'espace
>>>>
>>>>
>>>>
>>>>
>>>de
>>>
>>>
>>>
>>>
>>>>stockage pour vos mails, photos et vidéos !
>>>>Créez votre Yahoo! Mail sur
>>>>
>>>>
>>>>
>>>>
>>>http://fr.mail.yahoo.com
>>>
>>>
>>>
>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>_______________________________________________________________________
>>______
>>
>>
>>
>>
>>>Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos
>>>mails, photos et vidéos !
>>>Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>>_______________________________________________________________________
>>______ Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage
>>pour vos mails, photos et vidéos !
>>Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com
>>
>>
>>
>>
>>
>
>--
>Ce message a ete verifie par MailScanner pour des virus ou des polluriels et
>rien de suspect n'a ete trouve.
>
>Les donnees et renseignements contenus dans ce message sont personnels,
>confidentiels et prives. Toute publication, utilisation ou diffusion, meme
>partielle, doit etre autorisee.
>
>Any data and information contained in this electronic mail is personal,
>confidential and secret. Any total or partial publication, use or
>distribution must be authorized.
>
>
>
>
More information about the mapserver-users
mailing list