[Mapserver-users] OGC-compliant WMS-server deliveringdynamic layers with MS?

[Frieso ter Haseborg]

Hi Debbie,

first of all thanks a lot for posting your code - yes, it's been a great
help bringing some light how to handle these things.

One more question - if you will excuse me.
The solution to handle GetMap and GetCapabilities are understood in
particular the idea to create a new mapfile and to let mapserver do the
xml-generation for GetCapabilities seems clever to me.

But I've still a question regarding the getFeatureInfo-Request. Instead
of returning the direct output you dump an url. What would be the result
on executing this url? I can't test this, since the url I get on trying
your demo-link leads to an unaccessible server. Would the other serve
deliver the desired output? 

Would MS be able to handle this reroute if an url is dumped instead of a
result in the info_format normally specified with a
getFeatureInfo-Request?
Or in other words: This isn't ogc-compliant (no offense!), is it?

TIA,
 
Frieso ter Haseborg
- Software Development - 
 
--

-------------------------------------------------- 
S&F Datentechnik GmbH&Co.KG 
Reimersstr. 41b 
26789 Leer, Germany


>-----Original Message-----
>From: Debbie Pagurek [mailto:pagurekd at agr.gc.ca]
>Sent: Monday, September 29, 2003 8:37 PM
>To: mapserver-users at lists.gis.umn.edu; Frieso ter Haseborg
>Cc: Tom.Kralidis at CCRS.NRCan.gc.ca
>Subject: Re: [Mapserver-users] OGC-compliant WMS-server
>deliveringdynamic layers with MS?
>
>
>
>OK everybody,
>I've attached the PHP code that I wrote for handling the WMS requests
>to our Integrated Taxonomic Information System internet mapping
>application.
>
>I have removed most of the code that shows that transfer of the point
>information via XML to the application, because the points can 
>come from
>anywhere:  XML, a direct database connection, or a shapefile.  
>
>The point of interest here is how the WMS request name/value pairs are
>handled in PHP and how the corresponding results are returned (an image
>for a getmap request,  an xml stream for the getcapabilities request, a
>pop up window with a new URL for a getfeatureinfo request).
>
>I tried to include all possible name/value pairs that can come in via a
>WMS request but I think I missed some e.g. EXCEPTIONS=
>
>I am no programming guru so please forgive any weird programming
>foibles in here.  All I know is that the application does WORK! 
>Hopefully some of you will find this useful in some way.  Please let me
>know if you have found it helpful or if you see any problems.
>
>Keep in mind that the GetCapabilities for this application was a
>problem because we are mapping over 100,000 taxa, and it is ridiculous
>to include that many layers in a getcapabilities document.  In the
>getcapabilities section I included a default (no layer name is 
>specified
>in the request) as well as a dynamic response that writes out a new
>mapfile if a layername is specified (e.g.
>request=getcapabilites&layers=Abudefduf)
>
>An example of the type of requests that are handled by this script:
>Getmap:
>http://wms1.agr.gc.ca/mapdata/itis/testscript.php?VERSION=1.1.0
>&REQUEST=GetMap&Layers=Cyanocitta%20cristata&SRS=EPSG:42304&BBO
>X=-2750560,-936638,3583870,4673120&WIDTH=339&HEIGHT=300
>
>GetFeatureInfo:
>http://wms1.agr.gc.ca/mapdata/itis/testscript.php?VERSION=1.1.0
>&REQUEST=GetFeatureInfo&QUERY_LAYERS=Abudefduf+abdominalis&Laye
>r=Abudefduf+abdominalis&X=250&Y=150
>
>GetCapabilities:
>http://wms1.agr.gc.ca/mapdata/itis/testscript.php?VERSION=1.0.0
>&REQUEST=GetCapabilities
>
>I am no programming guru so please forgive any weird programming
>idiosyncrasies in here.  All I know is that the application does WORK! 
>Hopefully some of you will find this useful in some way.  Please let me
>know if you have found it helpful or if you see any problems.
>
>Debbie Pagurek
> 
>
>Debbie Pagurek, M.Sc.
>GIS and Remote Sensing Analyst / Télédétection, SIG
>Research Branch / D.G. Recherche
>Agriculture and Agri-Food Canada / Agriculture et Agroalimentaire
>Canada
>Telephone / Téléphone: 613-759-1543
>Facsimile / Télécopieur: 613-759-1937
>960 Carling Avenue
>Ottawa, Ontario
>K1A 0C6
>pagurekd at agr.gc.ca
>
>>>> "Frieso ter Haseborg" <ter-haseborg at sf-datentechnik.de> 09/17/03
>11:56AM >>>
>Hi,
>
>I'm searching for possibilities to use MS for building an
>OGC-compliant
>WMS-service which creates and serves dynamic layers from data out of
>RDBMS. These RDBMS do NOT have any spatial-extensions it's just the
>"x,y-coordinate & label-data"-thing. 
>
>So what I want to do: retrieve the coordinates from my databases and
>create one or more dynamic layers. I did some experiments with
>PHP/MapScript, no major problems so far, that seems to be the easier
>part.
>
>The problem comes here: I don't want to create these layers in any
>client-app, I want to have these layers served by the mapserver, since
>I
>have to incorporate other servers e.g. ArcIMS which have to use and
>process this layers through OGC-requests. Any ideas?
>
>Are there any possibilities to create dynamic layers from RDBMS e.g.
>Sybase ASA, MS SQL Server, Oracle without spatial-extensions I
>overlooked, besides doing this in PHP/MapScript?
>
>Are there any hooks or entry-points in the mapserv-cgi to process
>customized-operations like creating the mentioned dynamic layers?
>
>Any comment and hint would be appreciated!
>
>TIA,
> 
>Frieso ter Haseborg
>- Software Development - 
> 
>--
>
>-------------------------------------------------- 
>S&F Datentechnik GmbH&Co.KG 
>Reimersstr
>. 41b 
>26789 Leer, Germany
>
>_______________________________________________
>Mapserver-users mailing list
>Mapserver-users at lists.gis.umn.edu 
>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>