[Mapserver-users] RE : MapOracleSpatial - Great News

[Fortin,Nicolas [SteFoy]]

Hi Fernando and list,

Great news et good work!

Do you have any working compiled (4.2) version of this mapserver for windows yet?  Since I can't compile it myself, I will be really thankful if you (or someone else) could point me where I can download it.  It should also include all the INPUT and OUTPUT of the standard w32 binary.

Thank you very much!

Nicolas Fortin
Mathématicien, Programmeur, Analyste de données
SMC-Québec Hydrologie, Environnement Canada
1141, Rte de l'Église, Sainte-Foy(QC) G1V 4H5
(418)648-2516
nicolas.fortin at ec.gc.ca <mailto:nicolas.fortin at ec.gc.ca>



-----Message d'origine-----
De : Fernando S. [mailto:simon at inf.univali.br] 
Envoyé : Friday, April 16, 2004 12:54 PM
À : qoelhex at cttmar.univali.br; simon at inf.univali.br
Objet : MapOracleSpatial - Great News


Dear friends, 
    We made some updates in the maporaclespatial source code. 
    Now the code do query directly to database and return text data to use in templates files (html).
    The next step is make the mapserv show what the database return as visual shape.
    We waiting for your feedback to fix the bugs.
    Thank you.

Exmaple query layer
layer
      connectiontype ORACLESPATIAL
      connection 'user/passwd at server'
      data "shape from (select shape, mkt_id, name from cola_markets)"
        name "map_query"
        type point
        status off
        classitem 'NAME'
        class
            overlaysymbol 'coleta'
            overlaycolor 255 0 0
            overlayoutlinecolor 0 0 0
            overlaysize 4
        end
    header "templates/map_query_header.html"
    footer "templates/map_query_footer.html"
    template "templates/map_query_body.html"
end

Example nquery link
http://200.169.54.40/cgi-bin/mapserv2?map=/usr/local/apache2/web/mapserv/maporaclespatial/maporaclespatial.map&imgsize=400+402&imgext=0+20+20+0&imbox=0+20+20+0&mode=nquery&savequery=true&layer=map_query

Same link generating only image
http://200.169.54.40/cgi-bin/mapserv2?map=/usr/local/apache2/web/mapserv/maporaclespatial/maporaclespatial.map&imgsize=400+402&imgext=0+20+20+0&imbox=0+20+20+0&mode=map&savequery=true&layer=map_query

Example query link
http://200.169.54.40/cgi-bin/mapserv2?map=/usr/local/apache2/web/mapserv/maporaclespatial/maporaclespatial.map&imgsize=400+402&imgext=0+20+20+0&imgxy=5+5&mode=query&savequery=true&layer=map_query

================================================================== 
Fernando Simon
DataBase Manager, Mapserver, OracleSpatial and PostGis Developer 
G10 - Laboratório de Computação Aplicada
MapOracleSpatial developer 
http://g10.cttmar.univali.br 
==================================================================