[mapserver-users] Re: Reg: QueryMap(Zoom To Shape) with Mapserver, PostgreSql/PostGIS (Venkat Rao Tammineni)

"SAEZ Laurent - CETE Méditerr./DI/ETER" Laurent.Saez at developpement-durable.gouv.fr
Thu Aug 7 05:01:51 PDT 2008


Hi,

You should try something like :
DATA "the_geom FROM (select * FROM rgp_gis_continent) as foo USING 
UNIQUE gid USING SRID=-1"

Regards

Laurent

Le 07/08/2008 13:37, > mapserver-users-request at lists.osgeo.org (par 
Internet, dépôt mapserver-users-bounces at lists.osgeo.org) a écrit  :
> Send mapserver-users mailing list submissions to
> 	mapserver-users at lists.osgeo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://lists.osgeo.org/mailman/listinfo/mapserver-users
> or, via email, send a message with subject or body 'help' to
> 	mapserver-users-request at lists.osgeo.org
>
> You can reach the person managing the list at
> 	mapserver-users-owner at lists.osgeo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of mapserver-users digest..."
>
>
> Today's Topics:
>
>    1. AW: [mapserver-users] How do i define my SLD inside the
>       mapfile? (Albrecht.Weiser at hzd.hessen.de)
>    2. Re: AW: [mapserver-users] How do i define my SLD inside the
>       mapfile? (bartvde at osgis.nl)
>    3. Re: GPS to GIS (Peter Falk)
>    4. drawing a north arrow on a map (John Beck)
>    5. Re: drawing a north arrow on a map (Ritesh Ambastha)
>    6. Reg: QueryMap(Zoom To Shape) with Mapserver
>       PostgreSql/PostGIS (Venkat Rao Tammineni)
>    7. RE : [mapserver-users] drawing a north arrow on a map (L?veill?)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 7 Aug 2008 11:25:02 +0200
> From: <Albrecht.Weiser at hzd.hessen.de>
> Subject: AW: [mapserver-users] How do i define my SLD inside the
> 	mapfile?
> To: <bartvde at osgis.nl>
> Cc: mapserver-users at lists.osgeo.org
> Message-ID:
> 	<CE18753D388B804D89BEF318AA1554DC0C8CC7 at SRVSHPCL03EX2.itshessen.hessen.de>
> 	
> Content-Type: text/plain;	charset="iso-8859-1"
>
> Hi Bart,
> what a luck that there's a workaround. Unluckily i'm not a php crack :o/ Could you please tell in a few catchwords how to apply the script?
> Thanks
> Albrecht
>
>   
>> -----Ursprüngliche Nachricht-----
>> Von: bartvde at osgis.nl [mailto:bartvde at osgis.nl] 
>> Gesendet: Donnerstag, 7. August 2008 09:52
>> An: Weiser, Albrecht (HZD)
>> Cc: mapserver-users at lists.osgeo.org
>> Betreff: Re: [mapserver-users] How do i define my SLD inside 
>> the mapfile?
>>
>> No you can't use an SLD directly in a WMS server MAP file.
>>
>> What I normally do is apply the SLD to the MAP file using a simple PHP
>> script:
>>
>> #!/bin/sh
>> sudo -u apache php -f $0 $*; exit $?
>>
>> <?php
>>
>> if ($argc != 4) {
>>   echo "Usage: applysldurl.php <input MAP file> <SLD url> <output MAP
>> file>\n";
>>   echo "\n";
>>   echo "Applies the SLD url to the layers in the MAP file\n";
>>   echo "\n";
>>   exit(1);
>> }
>>
>> $oMap = ms_newMapObj($argv[1]);
>> $oMap->applySLDURL($argv[2]);
>> $oMap->save($argv[3]);
>>
>> echo "Output saved to $argv[3]\n";
>>
>> ?>
>>
>> Best regards,
>> Bart
>>     
>
>
> ------------------------------
>
> Message: 2
> Date: Thu, 7 Aug 2008 11:34:31 +0200 (CEST)
> From: bartvde at osgis.nl
> Subject: Re: AW: [mapserver-users] How do i define my SLD inside the
> 	mapfile?
> To: Albrecht.Weiser at hzd.hessen.de
> Cc: mapserver-users at lists.osgeo.org
> Message-ID:
> 	<14438.145.50.39.11.1218101671.squirrel at webmail.hostingdiscounter.nl>
> Content-Type: text/plain;charset=iso-8859-1
>
> Hi Albrecht,
>
> you can run the script like:
>
> php -d safe_mode=off /data/geoservices/scripts/applysldurl.php
> /data/OGC_UMN_services/kerngisnat_utre.map http://145.50.148.45/nu.sld
> ~bart/kgnat_svn2/services/kerngisnat_utre.map.new
>
> Make sure the paths to your input and output MAP file are absolute, and
> read the SLD from a webserver.
>
> Btw, Mapserver matches the NamedLayers from the SLD to the NAME of the
> LAYER in the MAP file, so they have to be the same for it to work
> properly.
>
> This will generate CLASSes for your layers in the MAP file.
>
> Best regards,
> Bart
>
>   
>> Hi Bart,
>> what a luck that there's a workaround. Unluckily i'm not a php crack :o/
>> Could you please tell in a few catchwords how to apply the script?
>> Thanks
>> Albrecht
>>
>>     
>>> -----Ursprüngliche Nachricht-----
>>> Von: bartvde at osgis.nl [mailto:bartvde at osgis.nl]
>>> Gesendet: Donnerstag, 7. August 2008 09:52
>>> An: Weiser, Albrecht (HZD)
>>> Cc: mapserver-users at lists.osgeo.org
>>> Betreff: Re: [mapserver-users] How do i define my SLD inside
>>> the mapfile?
>>>
>>> No you can't use an SLD directly in a WMS server MAP file.
>>>
>>> What I normally do is apply the SLD to the MAP file using a simple PHP
>>> script:
>>>
>>> #!/bin/sh
>>> sudo -u apache php -f $0 $*; exit $?
>>>
>>> <?php
>>>
>>> if ($argc != 4) {
>>>   echo "Usage: applysldurl.php <input MAP file> <SLD url> <output MAP
>>> file>\n";
>>>   echo "\n";
>>>   echo "Applies the SLD url to the layers in the MAP file\n";
>>>   echo "\n";
>>>   exit(1);
>>> }
>>>
>>> $oMap = ms_newMapObj($argv[1]);
>>> $oMap->applySLDURL($argv[2]);
>>> $oMap->save($argv[3]);
>>>
>>> echo "Output saved to $argv[3]\n";
>>>
>>> ?>
>>>
>>> Best regards,
>>> Bart
>>>       
>
>
>
>
> ------------------------------
>
> Message: 3
> Date: Thu, 07 Aug 2008 11:35:15 +0200
> From: Peter Falk <peter at nexus.dk>
> Subject: Re: [mapserver-users] GPS to GIS
> To: mapserver-users at lists.osgeo.org
> Message-ID: <489AC1D3.3030800 at nexus.dk>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi Guys,
>
> Thanks for your input. It's been a great help. The fact that I'm now 
> aware of the translation - from WGS84 to UTM Zone 32 - has narrowed the 
> problem down.
>
> Peter
>
>
> Benoît Andrieu skrev:
>   
>> Hi Peter,
>>
>> What do you mean with 'GIS' coordinates ?
>>
>> For me, GIS means Geographic Information System and is a very common 
>> term.
>> Looking at your 'GIS' coordinates I would say that your GIS coordinate 
>> system is a UTM 32 coordinate system.
>>
>> And in your case, you could use cs2cs 
>> (http://proj.maptools.org/man_cs2cs.html) in order to make the 
>> translation.
>>
>> cs2cs.exe +proj=latlong +datum=WGS84 +to +proj=utm +zone=32 
>> +datum=WGS84 -r
>> input : 54.9808N 8.86707E
>> output : 491492.61       6092662.95 0.00
>>
>> The results are not exactly accurate with yours but they are close 
>> enough to me (by what ? 600 meters ? ^^).
>>
>> I hope it will help.
>>
>> Regards,
>> Benoît Andrieu
>>
>> ----- Original Message ----- From: "Peter Falk" <peter at nexus.dk>
>> To: <mapserver-users at lists.osgeo.org>
>> Sent: Thursday, August 07, 2008 9:20 AM
>> Subject: [mapserver-users] GPS to GIS
>>
>>
>>     
>>> Hi David,
>>>
>>> Yes I know i was a bit vague. What I need is a simple function, that 
>>> can turn a point in GPS - a lattitude and a logitude value - into a 
>>> point in GIS.
>>>
>>> I.e. I got these coordinate:
>>> GPS: N: 54.9809  E: 8.86707
>>>
>>> that applies to
>>>
>>> GIS: X: 491055.41 Y: 6092507.928
>>>
>>> What I need is the correlation between the two.
>>>
>>> Regards
>>> Peter
>>>
>>> _______________________________________________
>>> mapserver-users mailing list
>>> mapserver-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users 
>>>       
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080807/e01850ca/attachment.htm>


More information about the MapServer-users mailing list