From Zamil.Murji@divestco.com Tue Jun 1 00:16:25 2004 From: Zamil.Murji@divestco.com (Zamil Murji) Date: Mon, 31 May 2004 17:16:25 -0600 Subject: [Mapserver-users] localhost works but using IP addressgives blackimages Message-ID: <64FC1B3E23F04C4E931EE3F6D809FF303ABF5D@DIV-MX02.divestco> I bet your apache is set to listen to localhost port 80...change it to listen on the ip address port 80 That should solve it. Hope I helped... Zamil -----Original Message----- From: mapserver-users-admin@lists.gis.umn.edu [mailto:mapserver-users-admin@lists.gis.umn.edu]On Behalf Of John Wiley Sent: Monday, May 31, 2004 4:58 PM To: TMitchell@lignum.com Cc: mapserver-users@lists.gis.umn.edu; mapserver-users-admin@lists.gis.umn.edu Subject: Re: [Mapserver-users] localhost works but using IP addressgives blackimages Either computer will run using localhost in the address ie.http://localhost/parksville/pville_init.html within itself but not using an ip specific such as ie. http://205.233.104.228/Parksville/Pville_init.html. from a "client" to the "gisserver" I hope i'm explaining this okay. John >>> Tyler Mitchell 05/31/04 03:38pm >>> Just to confirm - does it run fine from any machine - i.e. locally on the server? Tyler mapserver-users-admin@lists.gis.umn.edu wrote on 05/31/2004 02:50:55 PM: > I hope there is an easy solution here and I promise to help others > in my steps!... > Once I got the second computer working with Mapserver using > "localhost" then changing to point to an IP address using a remote > computer browser hitting the ip address of the > "gisserver"... which does run the program and writes the GIF files > to the tmp directory however I get the "black" images again!. The > server is writing them okay...on the /temp > directory... just not being displayed on the client's > browser.... any suggestions? I checked permissions and II2 settings > ... and still no luck. > > John Wiley, > Gis Technician > > _______________________________________________ Mapserver-users mailing list Mapserver-users@lists.gis.umn.edu http://lists.gis.umn.edu/mailman/listinfo/mapserver-users From jmckenna@dmsolutions.ca Tue Jun 1 03:23:04 2004 From: jmckenna@dmsolutions.ca (Jeff McKenna) Date: Mon, 31 May 2004 22:23:04 -0400 Subject: [Mapserver-users] proj question References: <64FC1B3E23F04C4E931EE3F6D809FF303ABF5A@DIV-MX02.divestco> Message-ID: <40BBE888.5090808@dmsolutions.ca> Hi Zamil, The short answer is that if all of your data is in the same projection (which is your case I imagine) you don't have to specify a projection..just make sure you give the correct EXTENTs of your data in the mapfile. Yes MapServer does support projections...and it uses the PROJ4 library (http://www.remotesensing.org/proj)....but don't worry about all that if your data is all in the same projection. jeff Zamil Murji wrote: > Hello list, > > I have some data in a shapefile and the shapefile came with a .prj file. Will mapserver automatically read that .prj file or will I have to specify a PROJECTION in my .map file? If I have to specify something in my .map file, what is the format? Here is the contents of my .prj file: > > GEOGCS["North_American_Datum_1927",DATUM["D_North_American_1927",SPHEROID["Clarke - 1866",6378206.4,294.9786982139006]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]] > > Thanks > Zamil > -- Jeff McKenna GIS Specialist DM Solutions Group Inc. http://www.dmsolutions.ca From warmerdam@pobox.com Tue Jun 1 04:33:19 2004 From: warmerdam@pobox.com (Frank Warmerdam) Date: Mon, 31 May 2004 23:33:19 -0400 Subject: [Mapserver-users] proj.4 related utilities question In-Reply-To: <40B8725A.6000205@twcny.rr.com> References: <20040529094707.GD23794@badfish.securityminded.net> <40B8725A.6000205@twcny.rr.com> Message-ID: <40BBF8FF.4020801@pobox.com> Andrew wrote: > I have been reading the proj.4 pdf documentation and found a reference > at the very end to proj related utilities called inv27 inv83 for27 for83 > used to forward and inverse project state plane data to cartesian > coordinates. I was wondering if anyone has used or know about these > utilities? I don't find any info in the proj.4 source distribution, and > I can't get to the home page for some reason right now to check on this. Andrew, I don't think these exist anymore. However you can use state plane coordinate systems with 'proj', 'cs2cs' or mapserver. Eg. "+init=nad83:203" would be "Arizona West, NAD83". See the "nad27" and "nad83" files to correspond state plane zone numbers with names. Best regards, -- ---------------------------------------+-------------------------------------- I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush | Geospatial Programmer for Rent From jenu_ab@hotmail.com Tue Jun 1 05:25:33 2004 From: jenu_ab@hotmail.com (Jenu Abraham) Date: Mon, 31 May 2004 23:25:33 -0500 Subject: [Mapserver-users] Symbol-Pixmap not showing Message-ID: I'm trying to get a north pointing compas image fixed on my map... I tried using the Symbol Pixmap feature as shown in the code below... I can see the state layer, but not the n_arrow layer which is the compass , onthe output image ... this is the first time i have tried to use the symbol feature....I cant figure out what i'm doing wrong --------------------------------------------------------------------------------- MAP NAME e-test-rd-jbox-vsd_ IMAGETYPE GIF EXTENT -2236857.50 -1744057.00 2786329.50 29069.36 SIZE 800 600 SHAPEPATH "C:\cgi-bin\data\" FONTSET "C:\cgi-bin\fonts\fonts.list" WEB TEMPLATE 'e-test-rd-jbox.html' IMAGEPATH 'C:\cgi-bin\tmp\' IMAGEURL '/tmp/' END PROJECTION "init=epsg:2163" END SYMBOL NAME nort TYPE PIXMAP IMAGE "C:\cgi-bin\symbols\images\north.gif" END LAYER # States polygon layer begins here NAME states DATA statesp020 STATUS DEFAULT TYPE POLYGON PROJECTION "init=epsg:4326" END CLASS COLOR 240 240 100 END END # States polygon layer ends here LAYER NAME n_arrow STATUS DEFAULT TRANSFORM FALSE TYPE POINT FEATURE POINTS 300 300 END END CLASS SYMBOL nort END END # End of LAYER DEFINITIONS END # end of map file _________________________________________________________________ MSN Toolbar provides one-click access to Hotmail from any Web page – FREE download! http://toolbar.msn.click-url.com/go/onm00200413ave/direct/01/ From alexanderlimkh@yahoo.com Tue Jun 1 05:52:58 2004 From: alexanderlimkh@yahoo.com (Alexander Lim) Date: Mon, 31 May 2004 21:52:58 -0700 (PDT) Subject: [Mapserver-users] plot on map Message-ID: <20040601045258.64207.qmail@web60803.mail.yahoo.com> hi all, i have just manage to create an applet to load a shape file and display a simply map of main roads. However I actually would like to plot a dot on the map according to lat/long (lat/long will most probably be retrieved from database). Can anyone please point me to the area where i can get more information on plotting the map. If anyone has done this before, please post any sample codes that i can refer to. Any advice would be grealy aprreciated. Thanks al below is how the map is created (based on one of the example): ------test.xml------- ---------------------- -------test.html------ ---------------------- __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ From 1wilkerson@charter.net Tue Jun 1 07:57:53 2004 From: 1wilkerson@charter.net (P Wilkerson) Date: Tue, 1 Jun 2004 02:57:53 -0400 Subject: [Mapserver-users] Mapserver crashing with PHP/Mapscript when... References: Message-ID: <153601c447a5$c560ae00$6400a8c0@Dale1> I am modifying the GMapDumpQueryResults function in GMap75.inc of the GMap75 demo (latest version) Mapserver stops when I add code to interact with the output from the SHP files. I cannot add new variables. I cannot IF statements. I cannot do much at all without causing the application to stop. By stopping I mean that the Mapserver program does not generate a map and ceases outputting the rest of the HTML page. Layer Name - layer01 There are only two fields ITEM_NBR and TITLE. I am placing my code within the following FOR Loop of the GMapDumpQueryResults() function. for ($iField=0; $iField < count($selFields); $iField++) { < Some code in addition to mine > < --------- start of my code -------------------------> // TO OUTPUT FOR THUMBNAIL IF ($oLayer->getMetaData("DESCRIPTION") == "layer01") { IF ($selFields[$iField] == "ITEM_NBR") { $oShapeVal04 = $oShape->values[$selFields[$iField]]; printf('%s', 'thumbnail image'); } } // TO OUTPUT HREF FOR RELATED PAGE IF (($selFields[$iField] == "TITLE") ) { $dlconnectionstr = "http://LocalhostTest:"; $imgIDVal = $oShape->values[$selFields[$iField]]; $dlsource = substr($imgIDVal,0,3); if ($dlsource == "PLW") { $dlconnectionstr = $dlconnectionstr."PLW:"; } ELSE IF ($dlsource == "GAD") { $dlconnectionstr = $dlconnectionstr."GAD:"; } $oShapeVal03 = oShape->values[$selFields[$iField]]; printf('%s', ''); } // OUTPUTS FIELD VALUE EXCEPT FOR ITEM_NBR FIELD IF (! ($selFields[$iField] == "ITEM_NBR") ) printf("%s", $oShape->values[$selFields[$iField]]); // CLOSES HREF IF TITLE FIELD IF (($selFields[$iField] == "TITLE") ) { printf(""); } < --------- end of my code -------------------------> < Code in addition to mine > } Again, the problem is that the program stops generating HTML / image files when I start manipulating the variables. Any suggestions? Peter Wilkerson From sebastien.dubois@esm2.imt-mrs.fr Tue Jun 1 08:33:09 2004 From: sebastien.dubois@esm2.imt-mrs.fr (=?iso-8859-1?b?U+liYXN0aWVu?= DUBOIS) Date: Tue, 1 Jun 2004 09:33:09 +0200 Subject: [Mapserver-users] architecture mapsserver/ jbox Message-ID: <1086075189.40bc31351284b@webmail.esm2.imt-mrs.fr> what's the architecture of jbox in fact? we're agree that with have an applet java. is it possible to interface this with a servlet serveur such tomcat? in other words , can i code (with such a tool as phpmapscript??) such that when I right click on my applet a list of choice appears. is there an api, library? how communicate jbox when i select some points. is there a call to the shape file on the server? the architecture is not very clear for me... in other words about mapserver. when i overview some typical point of my shape file using jbox. i can easily display the points i've taked in a html page with their attributes but how just change their color or create a new database with them?? thanks in advance for your help -- Sébastien ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ From Agneta Schick Tue Jun 1 09:55:15 2004 From: Agneta Schick (Agneta Schick) Date: Tue, 1 Jun 2004 10:55:15 +0200 (MEST) Subject: [Mapserver-users] Can't locate object method "TIEHASH" Message-ID: <200406010855.i518tEIA020189@b3sn28.hannover.bgr.de> Thanks for the replies. I have no problem using XBase but I thought I had read an old mail ( which I can't find now) where someone criticised this method as being slow and advised to use msDBF. A follow-up question: what is the fastest method for extracting information from .dbf files? Agneta Schick > It is best to use Perl's XBase module for querying the DBF files. > I'm pretty sure that isn't even documented on purpose - I'll have to > check the doc. > > Lowell > > The following message was sent by Agneta Schick > on Fri, 28 May 2004 11:54:04 +0200 (MEST). > > > Hello mapserver-users, > > > > I've searched the mail archive and found 2 messages on this topic, > > both were, however, unanswered. > > > > So I'll try again... > > > > Platform: > > MapServer 4.0.1 > > solaris 9 > > Perl 5.8.3 > > > > I want to test an application querying shape files. > > My perl mapscript code > > ... > > $layer->queryByPoint($tmp_map,$pnt,$mapscript::MS_SINGLE,1000); > > my $res = $layer->getResult(0); > > $layer->open(); > > my $shape=new mapscript::shapeObj($layer->{type}); > > my $shape_index = $layer->getShape($shape,-1,$res->{shapeindex}); > > my $table = > > > mapscript::msDBFOpen("/space/b3sn13/webdb/htdocs/ermos/data/usgs.dbf","r+"); > > .... > > is terminated with > > Can't locate object method "TIEHASH" via package "_DBFHandle". > > > > Is this a mapscript problem or is something missing in the installation? > > > > (I tried the same perl script on solaris 8, mapserver 3.6.5, perl 5.6 > > and got the same error). > > > > Thanks, > > Agneta Schick > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > Agneta Schick > > > > Bundesanstalt fuer Geowissenschaften und Rohstoffe > > Federal Institute for Geosciences and Natural Resources > > Stilleweg 2 > > D- 30655 Hannover Tel.: +49 511 643 3136 > > GERMANY FAX.: +49 511 643 3663 > > > > schick@sdac.hannover.bgr.de http://www.seismologie.bgr.de > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > > > > > > > > _______________________________________________ > > Mapserver-users mailing list > > Mapserver-users@lists.gis.umn.edu > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users From Kalpin Erlangga Silaen" This is a multi-part message in MIME format. ------=_NextPart_000_0065_01C4498D.33F16150 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear all, Today, I am trying run MapServer under windows using MSSQL 2000. I have = read previous thread/mails and try to follow every step but I got error = like below : msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_1'. = msOGRFileOpen(): OGR error. Open failed for OGR connection `layer1.ovf'. = File not found or unsupported format.=20 My Layer code :=20 LAYER NAME LAYER_1 TYPE POLYGON STATUS DEFAULT CONNECTIONTYPE OGR CONNECTION "layer1.ovf" DATA "layer1" CLASS NAME 'My City' OUTLINECOLOR 128 128 128 COLOR 225 225 185 TEMPLATE "layer1.html" END HEADER "layer_1_header.html" FOOTER "layer_1_footer.html"=20 METADATA WMS_TITLE "My City" WMS_ABSTRACT "Layer Shapefile." WMS_SRS "EPSG:26915" END END and my layer1.ovf : ODBC:sa/kalpin@mstest=20 River=20 wkbPoint=20 LAYER_1 =20 Help me please Thank you Kalpin Erlangga Silaen ------=_NextPart_000_0065_01C4498D.33F16150 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear all,
 
Today, I am trying run MapServer under = windows=20 using MSSQL 2000. I have read previous thread/mails and try to follow = every step=20 but I got error like below :
 
msDrawMap(): Image handling error. Failed to draw layer named = 'LAYER_1'.=20
msOGRFileOpen(): OGR error. Open failed for OGR connection = `layer1.ovf'.=20 File not found or unsupported format.
My Layer code :
 
LAYER
  NAME LAYER_1
  = TYPE=20 POLYGON
  STATUS DEFAULT
  CONNECTIONTYPE OGR
 =20 CONNECTION "layer1.ovf"
  DATA "layer1"
 =20 CLASS
    NAME 'My City'
    = OUTLINECOLOR=20 128 128 128
    COLOR 225 225 = 185
   =20 TEMPLATE "layer1.html"
  END
  HEADER=20 "layer_1_header.html"
  FOOTER "layer_1_footer.html"
 =20 METADATA
    WMS_TITLE "My City"
    = WMS_ABSTRACT "Layer Shapefile."
    WMS_SRS=20 "EPSG:26915"
  END
END
 
and my layer1.ovf :
 
<OGRVRTDataSource>
   =20 <OGRVRTLayer = name=3D"LAYER_1">
       =20 <SrcDataSource>ODBC:sa/kalpin@mstest</SrcDataSource>=20
  <SrcLayer>River</SrcLayer>=20
 <GeometryType>wkbPoint</GeometryType>=20
       =20 <LayerSRS>LAYER_1</LayerSRS>
 <GeometryField=20 encoding=3D"PointFromColumns" x=3D"x" y=3D"y"/> =
   =20 </OGRVRTLayer>
</OGRVRTDataSource>
 
 
Help me please
 
 
 
Thank you
 
 
 
Kalpin Erlangga = Silaen
------=_NextPart_000_0065_01C4498D.33F16150-- From strk@keybit.net Tue Jun 1 11:12:20 2004 From: strk@keybit.net (strk) Date: Tue, 1 Jun 2004 12:12:20 +0200 Subject: [Mapserver-users] bug postgis query alias In-Reply-To: <40BB95B9.5060604@main-task.com> References: <40BB95B9.5060604@main-task.com> Message-ID: <20040601101220.GC16031@freek.keybit.net> On Mon, May 31, 2004 at 03:29:45PM -0500, Vladimir Guzmán wrote: > Hello. > I'm implementing a gps tracking system. > I want to show the car's orientation like this: > http://maintask.com/test.png > The layer's data is something like this: > ----------------------------- > gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as > rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 > 05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid > using srid=1 > ----------------------------- > The field 'sentido' contains '>'. > > The problem is that if I use something like this: > ----------------------------- > gps_geom from (select gid,'>' as sentido,tiempo,360-rumbo+90 as > rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 > 05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid > using srid=1 > ----------------------------- > The query doesn't work. > > So I had to create a column in potgres called 'sentido' and all the rows > containing '>'. > > Is this a bug? What's the error message ? Can you run the query from the pgsql monitor ? --strk; > > The rest of the layer: > > LAYER > NAME "puntosgps" > CONNECTIONTYPE postgis > CONNECTION "user=gps password=gps dbname=gps host=localhost" > DATA "gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as > rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 > 05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid > using srid=1" > TYPE POINT > PROJECTION > "proj=latlong" > "datum=WGS84" > END > LABELANGLEITEM 'rumbo' > LABELITEM 'sentido' > CLASS > NAME 'Parado' > EXPRESSION ([velocidad] = 0) > SIZE 14 > SYMBOL 'circle' > COLOR 0 0 215 > OUTLINECOLOR 204 204 204 > END > CLASS > NAME '0-10' > EXPRESSION ([velocidad] > 0 AND[velocidad] <= 10) > SIZE 14 > SYMBOL 'circle' > COLOR 255 255 204 > OUTLINECOLOR 204 204 204 > LABEL > TYPE TRUETYPE > FORCE TRUE > FONT arial > ANTIALIAS TRUE > COLOR 0 0 0 > OUTLINECOLOR 255 255 255 > SIZE 8 > END > END > ... > ... > > Thanks a lot. > > -- > Vladimir Ilich Guzmán R. > ------------------------ > http://maintask.com > > > _______________________________________________ > Mapserver-users mailing list > Mapserver-users@lists.gis.umn.edu > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users From holesovsky@oksystem.cz Tue Jun 1 11:18:26 2004 From: holesovsky@oksystem.cz (holesovsky@oksystem.cz) Date: Tue, 1 Jun 2004 12:18:26 +0200 Subject: [Mapserver-users] PNG problem / INTERLACE ON Message-ID: <47F95A849D754144ABC557403D4AE440537FBA@lev.oksystem.local> This is a multi-part message in MIME format. ------_=_NextPart_001_01C447C1.C72ED26B Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Hi All, =20 I have a strange problem with MapServer version 4.0.2 and PNG output = format. =20 Sometimes it happens that a generated PNG file is not correctly = displayed in MS Internet Explorer.=20 In other desktop's viewers (Irfanview, Paint,....) is a PNG file = displayed properly. =20 When I change output format to JPEG or switch INTERLACE to OFF, a = generated bitmap is displayed correctly. =20 Is it a bug or my problem? =20 Thanks =20 Michael Holesovsky =20 =20 =20 ________________________________ From: mapserver-users-admin@lists.gis.umn.edu = [mailto:mapserver-users-admin@lists.gis.umn.edu] On Behalf Of Kalpin = Erlangga Silaen Sent: Thursday, June 03, 2004 12:07 PM To: mapserver-users@lists.gis.umn.edu Subject: [Mapserver-users] Mapserver using MSSQL =20 Dear all, =20 Today, I am trying run MapServer under windows using MSSQL 2000. I have = read previous thread/mails and try to follow every step but I got error = like below : =20 msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_1'. = msOGRFileOpen(): OGR error. Open failed for OGR connection `layer1.ovf'. = File not found or unsupported format.=20 My Layer code :=20 =20 LAYER NAME LAYER_1 TYPE POLYGON STATUS DEFAULT CONNECTIONTYPE OGR CONNECTION "layer1.ovf" DATA "layer1" CLASS NAME 'My City' OUTLINECOLOR 128 128 128 COLOR 225 225 185 TEMPLATE "layer1.html" END HEADER "layer_1_header.html" FOOTER "layer_1_footer.html"=20 METADATA WMS_TITLE "My City" WMS_ABSTRACT "Layer Shapefile." WMS_SRS "EPSG:26915" END END =20 and my layer1.ovf : =20 ODBC:sa/kalpin@mstest=20 River=20 wkbPoint=20 LAYER_1 =20 =20 =20 Help me please =20 =20 =20 Thank you =20 =20 =20 Kalpin Erlangga Silaen ------_=_NextPart_001_01C447C1.C72ED26B Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable

Hi = All,

 

I have a strange problem with = MapServer version 4.0.2 and PNG output format.

 

Sometimes it happens that a = generated PNG file is not correctly displayed in MS Internet Explorer. =

In other desktop’s viewers = (Irfanview, Paint,….) is a PNG file displayed = properly.

 

When I change output format to JPEG = or switch INTERLACE to OFF, a generated bitmap is displayed = correctly.

 

Is it a bug or my = problem?

 

Thanks

 

Michael = Holesovsky

 

 

 

From: mapserver-users-admin@lists.gis.umn.edu [mailto:mapserver-users-admin@lists.gis.umn.edu] On Behalf Of Kalpin Erlangga Silaen
Sent: Thursday, June 03, = 2004 12:07 PM
To: mapserver-users@lists.gis.umn.edu
Subject: = [Mapserver-users] Mapserver using MSSQL

 

Dear all,

 

Today, I am trying run MapServer under windows using = MSSQL 2000. I have read previous thread/mails and try to follow every step but = I got error like below :

 

msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_1'.
msOGRFileOpen(): OGR error. Open failed for OGR connection `layer1.ovf'. = File not found or unsupported format.

My Layer code :

 

LAYER
  NAME LAYER_1
  TYPE POLYGON
  STATUS DEFAULT
  CONNECTIONTYPE OGR
  CONNECTION "layer1.ovf"
  DATA "layer1"
  CLASS
    NAME 'My City'
    OUTLINECOLOR 128 128 128
    COLOR 225 225 185
    TEMPLATE "layer1.html"
  END
  HEADER "layer_1_header.html"
  FOOTER "layer_1_footer.html"
  METADATA
    WMS_TITLE "My City"
    WMS_ABSTRACT "Layer Shapefile."
    WMS_SRS "EPSG:26915"
  END
END

 

and my layer1.ovf :

 

<OGRVRTDataSource>
    <OGRVRTLayer name=3D"LAYER_1">
        <SrcDataSource>ODBC:sa/kalpin@mstest</SrcDataSource>
  <SrcLayer>River</SrcLayer>
 <GeometryType>wkbPoint</GeometryType>
        <LayerSRS>LAYER_1</LayerSRS>
 <GeometryField encoding=3D"PointFromColumns" = x=3D"x" y=3D"y"/>
    </OGRVRTLayer>
</OGRVRTDataSource>

 

 

Help me please

 

 

 

Thank you

 

 

 

Kalpin Erlangga Silaen

------_=_NextPart_001_01C447C1.C72ED26B-- From bartvde@xs4all.nl Tue Jun 1 11:27:40 2004 From: bartvde@xs4all.nl (bartvde@xs4all.nl) Date: Tue, 1 Jun 2004 12:27:40 +0200 (CEST) Subject: [Mapserver-users] Mapserver using MSSQL In-Reply-To: <006801c44952$881a7e00$3701010a@kalpin> References: <006801c44952$881a7e00$3701010a@kalpin> Message-ID: <13183.212.238.227.182.1086085660.squirrel@webmail.xs4all.nl> Hi, 1. can ogrinfo read the ovf file successfully? 2. which version of Mapserver are you using (try 4.2 beta3 from http://www.maptools.org/php_mapscript/index.phtml?page=downloads.html). 3. are you using a System DSN? One thing which is incorrect for sure but I don't know if this is fatal, your LAYER_1. You can probably use your EPSG code for this. Best regards, Bart > Dear all, > > Today, I am trying run MapServer under windows using MSSQL 2000. I have > read previous thread/mails and try to follow every step but I got error > like below : > > msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_1'. > msOGRFileOpen(): OGR error. Open failed for OGR connection `layer1.ovf'. > File not found or unsupported format. > > My Layer code : > > LAYER > NAME LAYER_1 > TYPE POLYGON > STATUS DEFAULT > CONNECTIONTYPE OGR > CONNECTION "layer1.ovf" > DATA "layer1" > CLASS > NAME 'My City' > OUTLINECOLOR 128 128 128 > COLOR 225 225 185 > TEMPLATE "layer1.html" > END > HEADER "layer_1_header.html" > FOOTER "layer_1_footer.html" > METADATA > WMS_TITLE "My City" > WMS_ABSTRACT "Layer Shapefile." > WMS_SRS "EPSG:26915" > END > END > > and my layer1.ovf : > > > > ODBC:sa/kalpin@mstest > River > wkbPoint > LAYER_1 > > > > > > Help me please > > > > Thank you > > > > Kalpin Erlangga Silaen From Kalpin Erlangga Silaen" <13183.212.238.227.182.1086085660.squirrel@webmail.xs4all.nl> Message-ID: <00c101c44959$e58433e0$3701010a@kalpin> Dear all, 1. While I try use ogrinfo I get error like this : D:\openev_fw\bin>ogrinfo layer1.ovf FAILURE: Unable to open datasource `layer1.ovf' with the following drivers. -> ESRI Shapefile -> UK .NTF -> SDTS -> TIGER -> IHO S-57 (ENC) -> MapInfo File -> DGN -> GML -> AVCBin -> OGDI D:\openev_fw\bin> 2. I am using Mapserver version 4.2 beta2 (ms42b2_gif_pg.zip) 3. Yes, I am using System DSN to create ODBC connection. I have try change LAYER_1 to another one like KAMPUN_1 and still same error. I am still need your help. Thank you Kalpin Erlangga Silaen ----- Original Message ----- From: To: "Kalpin Erlangga Silaen" Cc: Sent: Tuesday, June 01, 2004 5:27 PM Subject: Re: [Mapserver-users] Mapserver using MSSQL > Hi, > > 1. can ogrinfo read the ovf file successfully? > > 2. which version of Mapserver are you using (try 4.2 beta3 from > http://www.maptools.org/php_mapscript/index.phtml?page=downloads.html). > > 3. are you using a System DSN? > > One thing which is incorrect for sure but I don't know if this is fatal, > your LAYER_1. You can probably use your EPSG code for > this. > > Best regards, > Bart > > > Dear all, > > > > Today, I am trying run MapServer under windows using MSSQL 2000. I have > > read previous thread/mails and try to follow every step but I got error > > like below : > > > > msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_1'. > > msOGRFileOpen(): OGR error. Open failed for OGR connection `layer1.ovf'. > > File not found or unsupported format. > > > > My Layer code : > > > > LAYER > > NAME LAYER_1 > > TYPE POLYGON > > STATUS DEFAULT > > CONNECTIONTYPE OGR > > CONNECTION "layer1.ovf" > > DATA "layer1" > > CLASS > > NAME 'My City' > > OUTLINECOLOR 128 128 128 > > COLOR 225 225 185 > > TEMPLATE "layer1.html" > > END > > HEADER "layer_1_header.html" > > FOOTER "layer_1_footer.html" > > METADATA > > WMS_TITLE "My City" > > WMS_ABSTRACT "Layer Shapefile." > > WMS_SRS "EPSG:26915" > > END > > END > > > > and my layer1.ovf : > > > > > > > > ODBC:sa/kalpin@mstest > > River > > wkbPoint > > LAYER_1 > > > > > > > > > > > > Help me please > > > > > > > > Thank you > > > > > > > > Kalpin Erlangga Silaen > > > > From norbert.thieme@ilmenau.baw.de Tue Jun 1 12:52:39 2004 From: norbert.thieme@ilmenau.baw.de (Norbert Thieme) Date: Tue, 01 Jun 2004 13:52:39 +0200 Subject: [Mapserver-users] Mapserver using MSSQL In-Reply-To: <00c101c44959$e58433e0$3701010a@kalpin> References: <006801c44952$881a7e00$3701010a@kalpin> <13183.212.238.227.182.1086085660.squirrel@webmail.xs4all.nl> <00c101c44959$e58433e0$3701010a@kalpin> Message-ID: <40BC6E07.7050400@ilmenau.baw.de> Kalpin Erlangga Silaen schrieb: > Dear all, > > 1. While I try use ogrinfo I get error like this : > D:\openev_fw\bin>ogrinfo layer1.ovf > FAILURE: > Unable to open datasource `layer1.ovf' with the following drivers. > -> ESRI Shapefile > -> UK .NTF > -> SDTS > -> TIGER > -> IHO S-57 (ENC) > -> MapInfo File > -> DGN > -> GML > -> AVCBin > -> OGDI > Hi, in your version of OGR ODBC is missing. This version seem not to be compiled with ODBC support. So you have to get another version of OGR. Regards, Norbert > D:\openev_fw\bin> > > 2. I am using Mapserver version 4.2 beta2 (ms42b2_gif_pg.zip) > > 3. Yes, I am using System DSN to create ODBC connection. > > I have try change LAYER_1 to another one like KAMPUN_1 and still same error. > I am still need your help. > > Thank you > > > > Kalpin Erlangga Silaen > > ----- Original Message ----- > From: > To: "Kalpin Erlangga Silaen" > Cc: > Sent: Tuesday, June 01, 2004 5:27 PM > Subject: Re: [Mapserver-users] Mapserver using MSSQL > > > >>Hi, >> >>1. can ogrinfo read the ovf file successfully? >> >>2. which version of Mapserver are you using (try 4.2 beta3 from >>http://www.maptools.org/php_mapscript/index.phtml?page=downloads.html). >> >>3. are you using a System DSN? >> >>One thing which is incorrect for sure but I don't know if this is fatal, >>your LAYER_1. You can probably use your EPSG code for >>this. >> >>Best regards, >>Bart >> >> >>>Dear all, >>> >>>Today, I am trying run MapServer under windows using MSSQL 2000. I have >>>read previous thread/mails and try to follow every step but I got error >>>like below : >>> >>>msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_1'. >>>msOGRFileOpen(): OGR error. Open failed for OGR connection `layer1.ovf'. >>>File not found or unsupported format. >>> >>>My Layer code : >>> >>>LAYER >>> NAME LAYER_1 >>> TYPE POLYGON >>> STATUS DEFAULT >>> CONNECTIONTYPE OGR >>> CONNECTION "layer1.ovf" >>> DATA "layer1" >>> CLASS >>> NAME 'My City' >>> OUTLINECOLOR 128 128 128 >>> COLOR 225 225 185 >>> TEMPLATE "layer1.html" >>> END >>> HEADER "layer_1_header.html" >>> FOOTER "layer_1_footer.html" >>> METADATA >>> WMS_TITLE "My City" >>> WMS_ABSTRACT "Layer Shapefile." >>> WMS_SRS "EPSG:26915" >>> END >>>END >>> >>>and my layer1.ovf : >>> >>> >>> >>> ODBC:sa/kalpin@mstest >>> River >>> wkbPoint >>> LAYER_1 >>> >>> >>> >>> >>> >>>Help me please >>> >>> >>> >>>Thank you >>> >>> >>> >>>Kalpin Erlangga Silaen >> >> >> >> > > _______________________________________________ > Mapserver-users mailing list > Mapserver-users@lists.gis.umn.edu > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users > > From bigfoot@main-task.com Tue Jun 1 13:08:59 2004 From: bigfoot@main-task.com (=?ISO-8859-1?Q?Vladimir_Guzm=E1n?=) Date: Tue, 01 Jun 2004 07:08:59 -0500 Subject: [Mapserver-users] bug postgis query alias In-Reply-To: <20040601120622.GD17831@freek.keybit.net> References: <40BB95B9.5060604@main-task.com> <20040601101220.GC16031@freek.keybit.net> <40BC6EFD.10000@maintask.com> <20040601120622.GD17831@freek.keybit.net> Message-ID: <40BC71DB.70508@main-task.com> The line 33 is just the draw method: $mapa = $map->draw(); -- Vladimir Ilich Guzmán R. ------------------------ http://maintask.com strk wrote: >On Tue, Jun 01, 2004 at 06:56:45AM -0500, Vladimir Guzmán wrote: > > >>Yes, the query runs fine in the pgsql monitor: >>gps=> select gid,'>' as sentido,tiempo,360-rumbo+90 as >>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-31 >>05:00:00' and tiempo<='2004-06-02 04:59:59'; >> gid | sentido | tiempo | rumbo | velocidad | >>gps_geom | oid >>-------+---------+---------------------+-------+-----------+---------------------------------+--------- >>46275 | > | 2004-05-31 15:16:09 | 450 | 0 | >>SRID=1;POINT(-74.06318 4.67302) | 7731018 >>46276 | > | 2004-05-31 15:16:15 | 450 | 0 | >>SRID=1;POINT(-74.06318 4.67302) | 7731019 >>46277 | > | 2004-05-31 15:16:21 | 450 | 0 | >>SRID=1;POINT(-74.06319 4.67301) | 7731020 >>... >>... >> >>The error is just: >> >>*Warning*: MapServer Error in msDrawMap(): Failed to draw layer named >>'puntosgps'. >>in */usr/local/apache/htdocs/gps/index.phtml* on line *33* >> >> > >Ooh.. I see.. php involved! >There are lot's of auto handling of special chars with php... >Showing that line '33' would also be useful. > >--strk; > > > > >>Vladimir Ilich Guzmán R. >>------------------------ >>http://maintask.com >> >> >> >>strk wrote: >> >> >> >>>On Mon, May 31, 2004 at 03:29:45PM -0500, Vladimir Guzmán wrote: >>> >>> >>> >>> >>>>Hello. >>>>I'm implementing a gps tracking system. >>>>I want to show the car's orientation like this: >>>>http://maintask.com/test.png >>>>The layer's data is something like this: >>>>----------------------------- >>>>gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as >>>>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 >>>>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid >>>>using srid=1 >>>>----------------------------- >>>>The field 'sentido' contains '>'. >>>> >>>>The problem is that if I use something like this: >>>>----------------------------- >>>>gps_geom from (select gid,'>' as sentido,tiempo,360-rumbo+90 as >>>>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 >>>>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid >>>>using srid=1 >>>>----------------------------- >>>>The query doesn't work. >>>> >>>>So I had to create a column in potgres called 'sentido' and all the rows >>>>containing '>'. >>>> >>>>Is this a bug? >>>> >>>> >>>> >>>> >>>What's the error message ? >>>Can you run the query from the pgsql monitor ? >>>--strk; >>> >>> >>> >>> >>> >>>>The rest of the layer: >>>> >>>>LAYER >>>>NAME "puntosgps" >>>>CONNECTIONTYPE postgis >>>>CONNECTION "user=gps password=gps dbname=gps host=localhost" >>>>DATA "gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as >>>>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 >>>>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid >>>>using srid=1" >>>>TYPE POINT >>>>PROJECTION >>>>"proj=latlong" >>>>"datum=WGS84" >>>>END >>>>LABELANGLEITEM 'rumbo' >>>>LABELITEM 'sentido' >>>>CLASS >>>> NAME 'Parado' >>>> EXPRESSION ([velocidad] = 0) >>>> SIZE 14 >>>> SYMBOL 'circle' >>>> COLOR 0 0 215 >>>> OUTLINECOLOR 204 204 204 >>>>END >>>>CLASS >>>> NAME '0-10' >>>> EXPRESSION ([velocidad] > 0 AND[velocidad] <= 10) >>>> SIZE 14 >>>> SYMBOL 'circle' >>>> COLOR 255 255 204 >>>> OUTLINECOLOR 204 204 204 >>>> LABEL >>>> TYPE TRUETYPE >>>> FORCE TRUE >>>> FONT arial >>>> ANTIALIAS TRUE >>>> COLOR 0 0 0 >>>> OUTLINECOLOR 255 255 255 >>>> SIZE 8 >>>> END >>>>END >>>>... >>>>... >>>> >>>>Thanks a lot. >>>> >>>>-- >>>>Vladimir Ilich Guzmán R. >>>>------------------------ >>>>http://maintask.com >>>> >>>> >>>>_______________________________________________ >>>>Mapserver-users mailing list >>>>Mapserver-users@lists.gis.umn.edu >>>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users >>>> >>>> >>>> >>>> >>>_______________________________________________ >>>Mapserver-users mailing list >>>Mapserver-users@lists.gis.umn.edu >>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users >>> >>> >>> >>> >>> >>> > > > > From strk@keybit.net Tue Jun 1 13:06:22 2004 From: strk@keybit.net (strk) Date: Tue, 1 Jun 2004 14:06:22 +0200 Subject: [Mapserver-users] bug postgis query alias In-Reply-To: <40BC6EFD.10000@maintask.com> References: <40BB95B9.5060604@main-task.com> <20040601101220.GC16031@freek.keybit.net> <40BC6EFD.10000@maintask.com> Message-ID: <20040601120622.GD17831@freek.keybit.net> On Tue, Jun 01, 2004 at 06:56:45AM -0500, Vladimir Guzmán wrote: > Yes, the query runs fine in the pgsql monitor: > gps=> select gid,'>' as sentido,tiempo,360-rumbo+90 as > rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-31 > 05:00:00' and tiempo<='2004-06-02 04:59:59'; > gid | sentido | tiempo | rumbo | velocidad | > gps_geom | oid > -------+---------+---------------------+-------+-----------+---------------------------------+--------- > 46275 | > | 2004-05-31 15:16:09 | 450 | 0 | > SRID=1;POINT(-74.06318 4.67302) | 7731018 > 46276 | > | 2004-05-31 15:16:15 | 450 | 0 | > SRID=1;POINT(-74.06318 4.67302) | 7731019 > 46277 | > | 2004-05-31 15:16:21 | 450 | 0 | > SRID=1;POINT(-74.06319 4.67301) | 7731020 > ... > ... > > The error is just: > > *Warning*: MapServer Error in msDrawMap(): Failed to draw layer named > 'puntosgps'. > in */usr/local/apache/htdocs/gps/index.phtml* on line *33* Ooh.. I see.. php involved! There are lot's of auto handling of special chars with php... Showing that line '33' would also be useful. --strk; > > > Vladimir Ilich Guzmán R. > ------------------------ > http://maintask.com > > > > strk wrote: > > >On Mon, May 31, 2004 at 03:29:45PM -0500, Vladimir Guzmán wrote: > > > > > >>Hello. > >>I'm implementing a gps tracking system. > >>I want to show the car's orientation like this: > >>http://maintask.com/test.png > >>The layer's data is something like this: > >>----------------------------- > >>gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as > >>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 > >>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid > >>using srid=1 > >>----------------------------- > >>The field 'sentido' contains '>'. > >> > >>The problem is that if I use something like this: > >>----------------------------- > >>gps_geom from (select gid,'>' as sentido,tiempo,360-rumbo+90 as > >>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 > >>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid > >>using srid=1 > >>----------------------------- > >>The query doesn't work. > >> > >>So I had to create a column in potgres called 'sentido' and all the rows > >>containing '>'. > >> > >>Is this a bug? > >> > >> > > > >What's the error message ? > >Can you run the query from the pgsql monitor ? > >--strk; > > > > > > > >>The rest of the layer: > >> > >>LAYER > >>NAME "puntosgps" > >>CONNECTIONTYPE postgis > >>CONNECTION "user=gps password=gps dbname=gps host=localhost" > >>DATA "gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as > >>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 > >>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid > >>using srid=1" > >>TYPE POINT > >>PROJECTION > >>"proj=latlong" > >>"datum=WGS84" > >>END > >>LABELANGLEITEM 'rumbo' > >>LABELITEM 'sentido' > >>CLASS > >> NAME 'Parado' > >> EXPRESSION ([velocidad] = 0) > >> SIZE 14 > >> SYMBOL 'circle' > >> COLOR 0 0 215 > >> OUTLINECOLOR 204 204 204 > >>END > >>CLASS > >> NAME '0-10' > >> EXPRESSION ([velocidad] > 0 AND[velocidad] <= 10) > >> SIZE 14 > >> SYMBOL 'circle' > >> COLOR 255 255 204 > >> OUTLINECOLOR 204 204 204 > >> LABEL > >> TYPE TRUETYPE > >> FORCE TRUE > >> FONT arial > >> ANTIALIAS TRUE > >> COLOR 0 0 0 > >> OUTLINECOLOR 255 255 255 > >> SIZE 8 > >> END > >>END > >>... > >>... > >> > >>Thanks a lot. > >> > >>-- > >>Vladimir Ilich Guzmán R. > >>------------------------ > >>http://maintask.com > >> > >> > >>_______________________________________________ > >>Mapserver-users mailing list > >>Mapserver-users@lists.gis.umn.edu > >>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users > >> > >> > >_______________________________________________ > >Mapserver-users mailing list > >Mapserver-users@lists.gis.umn.edu > >http://lists.gis.umn.edu/mailman/listinfo/mapserver-users > > > > > > > > From bigfoot@main-task.com Tue Jun 1 13:04:23 2004 From: bigfoot@main-task.com (=?ISO-8859-1?Q?Vladimir_Guzm=E1n?=) Date: Tue, 01 Jun 2004 07:04:23 -0500 Subject: [Mapserver-users] bug postgis query alias In-Reply-To: <20040601101220.GC16031@freek.keybit.net> References: <40BB95B9.5060604@main-task.com> <20040601101220.GC16031@freek.keybit.net> Message-ID: <40BC70C7.4090606@main-task.com> Yes, the query runs fine in the pgsql monitor: gps=> select gid,'>' as sentido,tiempo,360-rumbo+90 as rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-31 05:00:00' and tiempo<='2004-06-02 04:59:59'; gid | sentido | tiempo | rumbo | velocidad | gps_geom | oid -------+---------+---------------------+-------+-----------+---------------------------------+--------- 46275 | > | 2004-05-31 15:16:09 | 450 | 0 | SRID=1;POINT(-74.06318 4.67302) | 7731018 46276 | > | 2004-05-31 15:16:15 | 450 | 0 | SRID=1;POINT(-74.06318 4.67302) | 7731019 46277 | > | 2004-05-31 15:16:21 | 450 | 0 | SRID=1;POINT(-74.06319 4.67301) | 7731020 ... ... The error is just: *Warning*: MapServer Error in msDrawMap(): Failed to draw layer named 'puntosgps'. in */usr/local/apache/htdocs/gps/index.phtml* on line *33* Vladimir Ilich Guzmán R. ------------------------ http://maintask.com strk wrote: >On Mon, May 31, 2004 at 03:29:45PM -0500, Vladimir Guzmán wrote: > > >>Hello. >>I'm implementing a gps tracking system. >>I want to show the car's orientation like this: >>http://maintask.com/test.png >>The layer's data is something like this: >>----------------------------- >>gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as >>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 >>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid >>using srid=1 >>----------------------------- >>The field 'sentido' contains '>'. >> >>The problem is that if I use something like this: >>----------------------------- >>gps_geom from (select gid,'>' as sentido,tiempo,360-rumbo+90 as >>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 >>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid >>using srid=1 >>----------------------------- >>The query doesn't work. >> >>So I had to create a column in potgres called 'sentido' and all the rows >>containing '>'. >> >>Is this a bug? >> >> > >What's the error message ? >Can you run the query from the pgsql monitor ? >--strk; > > > >>The rest of the layer: >> >>LAYER >> NAME "puntosgps" >> CONNECTIONTYPE postgis >> CONNECTION "user=gps password=gps dbname=gps host=localhost" >> DATA "gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as >>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 >>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid >>using srid=1" >> TYPE POINT >>PROJECTION >> "proj=latlong" >> "datum=WGS84" >>END >> LABELANGLEITEM 'rumbo' >> LABELITEM 'sentido' >> CLASS >> NAME 'Parado' >> EXPRESSION ([velocidad] = 0) >> SIZE 14 >> SYMBOL 'circle' >> COLOR 0 0 215 >> OUTLINECOLOR 204 204 204 >> END >> CLASS >> NAME '0-10' >> EXPRESSION ([velocidad] > 0 AND[velocidad] <= 10) >> SIZE 14 >> SYMBOL 'circle' >> COLOR 255 255 204 >> OUTLINECOLOR 204 204 204 >> LABEL >> TYPE TRUETYPE >> FORCE TRUE >> FONT arial >> ANTIALIAS TRUE >> COLOR 0 0 0 >> OUTLINECOLOR 255 255 255 >> SIZE 8 >> END >> END >>... >>... >> >>Thanks a lot. >> >>-- >>Vladimir Ilich Guzmán R. >>------------------------ >>http://maintask.com >> >> >>_______________________________________________ >>Mapserver-users mailing list >>Mapserver-users@lists.gis.umn.edu >>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users >> >> >_______________________________________________ >Mapserver-users mailing list >Mapserver-users@lists.gis.umn.edu >http://lists.gis.umn.edu/mailman/listinfo/mapserver-users > > > > From 1wilkerson@charter.net Tue Jun 1 13:13:31 2004 From: 1wilkerson@charter.net (P Wilkerson) Date: Tue, 1 Jun 2004 08:13:31 -0400 Subject: [Mapserver-users] Mapserver crashing with PHP/Mapscript when... References: <153601c447a5$c560ae00$6400a8c0@Dale1> Message-ID: <000d01c447d1$dae4a110$6400a8c0@Dale1> Strangely, the script works fine on my MS4W install on a localhost computer but not at a hosted site. What compilation parameters should I look at to see if they are different? Peter ----- Original Message ----- From: "P Wilkerson" <1wilkerson@charter.net> To: Sent: Tuesday, June 01, 2004 2:57 AM Subject: [Mapserver-users] Mapserver crashing with PHP/Mapscript when... > I am modifying the GMapDumpQueryResults function in GMap75.inc of the GMap75 > demo (latest version) > > Mapserver stops when I add code to interact with the output from the SHP > files. > > I cannot add new variables. I cannot IF statements. I cannot do much at > all without causing the application to stop. > > By stopping I mean that the Mapserver program does not generate a map and > ceases outputting the rest of the HTML page. > > Layer Name - layer01 > There are only two fields ITEM_NBR and TITLE. > > I am placing my code within the following FOR Loop of the > GMapDumpQueryResults() function. > > for ($iField=0; $iField < count($selFields); $iField++) > { > < Some code in addition to mine > > < --------- start of my > code -------------------------> > // TO OUTPUT FOR THUMBNAIL > IF ($oLayer->getMetaData("DESCRIPTION") == > "layer01") { > IF ($selFields[$iField] == "ITEM_NBR") { > $oShapeVal04 = > $oShape->values[$selFields[$iField]]; > printf('%s', ' src="../data/images/imagefiles/'.$oShapeVal04.'.thumb.png" > alt="thumbnail image">'); > } > } > // TO OUTPUT HREF FOR RELATED PAGE > IF (($selFields[$iField] == "TITLE") ) { > $dlconnectionstr = "http://LocalhostTest:"; > $imgIDVal = > $oShape->values[$selFields[$iField]]; > $dlsource = substr($imgIDVal,0,3); > if ($dlsource == "PLW") { > $dlconnectionstr = > $dlconnectionstr."PLW:"; > } > ELSE > IF ($dlsource == "GAD") { > $dlconnectionstr = > $dlconnectionstr."GAD:"; > } > > $oShapeVal03 = > oShape->values[$selFields[$iField]]; > printf('%s', ' printf("%s", $oShapeVal03."');"); > printf('">'); > } > > // OUTPUTS FIELD VALUE EXCEPT FOR ITEM_NBR FIELD > IF (! ($selFields[$iField] == "ITEM_NBR") ) > printf("%s", > $oShape->values[$selFields[$iField]]); > > // CLOSES HREF IF TITLE FIELD > IF (($selFields[$iField] == "TITLE") ) { > printf(""); > } > < --------- end of my code -------------------------> > < Code in addition to mine > > } > > Again, the problem is that the program stops generating HTML / image files > when I start manipulating the variables. > > Any suggestions? > > Peter Wilkerson > > _______________________________________________ > Mapserver-users mailing list > Mapserver-users@lists.gis.umn.edu > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users From strk@keybit.net Tue Jun 1 13:23:54 2004 From: strk@keybit.net (strk) Date: Tue, 1 Jun 2004 14:23:54 +0200 Subject: [Mapserver-users] bug postgis query alias In-Reply-To: <40BC71DB.70508@main-task.com> References: <40BB95B9.5060604@main-task.com> <20040601101220.GC16031@freek.keybit.net> <40BC6EFD.10000@maintask.com> <20040601120622.GD17831@freek.keybit.net> <40BC71DB.70508@main-task.com> Message-ID: <20040601122354.GA19676@freek.keybit.net> On Tue, Jun 01, 2004 at 07:08:59AM -0500, Vladimir Guzmán wrote: > The line 33 is just the draw method: > > $mapa = $map->draw(); That tells me nothing... I'm afraid the bug is in php-mapscript or mapserver itself. --strk; > > -- > Vladimir Ilich Guzmán R. > ------------------------ > http://maintask.com > > strk wrote: > > >On Tue, Jun 01, 2004 at 06:56:45AM -0500, Vladimir Guzmán wrote: > > > > > >>Yes, the query runs fine in the pgsql monitor: > >>gps=> select gid,'>' as sentido,tiempo,360-rumbo+90 as > >>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-31 > >>05:00:00' and tiempo<='2004-06-02 04:59:59'; > >>gid | sentido | tiempo | rumbo | velocidad | > >>gps_geom | oid > >>-------+---------+---------------------+-------+-----------+---------------------------------+--------- > >>46275 | > | 2004-05-31 15:16:09 | 450 | 0 | > >>SRID=1;POINT(-74.06318 4.67302) | 7731018 > >>46276 | > | 2004-05-31 15:16:15 | 450 | 0 | > >>SRID=1;POINT(-74.06318 4.67302) | 7731019 > >>46277 | > | 2004-05-31 15:16:21 | 450 | 0 | > >>SRID=1;POINT(-74.06319 4.67301) | 7731020 > >>... > >>... > >> > >>The error is just: > >> > >>*Warning*: MapServer Error in msDrawMap(): Failed to draw layer named > >>'puntosgps'. > >>in */usr/local/apache/htdocs/gps/index.phtml* on line *33* > >> > >> > > > >Ooh.. I see.. php involved! > >There are lot's of auto handling of special chars with php... > >Showing that line '33' would also be useful. > > > >--strk; > > > > > > > > > >>Vladimir Ilich Guzmán R. > >>------------------------ > >>http://maintask.com > >> > >> > >> > >>strk wrote: > >> > >> > >> > >>>On Mon, May 31, 2004 at 03:29:45PM -0500, Vladimir Guzmán wrote: > >>> > >>> > >>> > >>> > >>>>Hello. > >>>>I'm implementing a gps tracking system. > >>>>I want to show the car's orientation like this: > >>>>http://maintask.com/test.png > >>>>The layer's data is something like this: > >>>>----------------------------- > >>>>gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as > >>>>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 > >>>>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid > >>>>using srid=1 > >>>>----------------------------- > >>>>The field 'sentido' contains '>'. > >>>> > >>>>The problem is that if I use something like this: > >>>>----------------------------- > >>>>gps_geom from (select gid,'>' as sentido,tiempo,360-rumbo+90 as > >>>>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 > >>>>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid > >>>>using srid=1 > >>>>----------------------------- > >>>>The query doesn't work. > >>>> > >>>>So I had to create a column in potgres called 'sentido' and all the > >>>>rows containing '>'. > >>>> > >>>>Is this a bug? > >>>> > >>>> > >>>> > >>>> > >>>What's the error message ? > >>>Can you run the query from the pgsql monitor ? > >>>--strk; > >>> > >>> > >>> > >>> > >>> > >>>>The rest of the layer: > >>>> > >>>>LAYER > >>>>NAME "puntosgps" > >>>>CONNECTIONTYPE postgis > >>>>CONNECTION "user=gps password=gps dbname=gps host=localhost" > >>>>DATA "gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as > >>>>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 > >>>>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid > >>>>using srid=1" > >>>>TYPE POINT > >>>>PROJECTION > >>>>"proj=latlong" > >>>>"datum=WGS84" > >>>>END > >>>>LABELANGLEITEM 'rumbo' > >>>>LABELITEM 'sentido' > >>>>CLASS > >>>>NAME 'Parado' > >>>>EXPRESSION ([velocidad] = 0) > >>>>SIZE 14 > >>>>SYMBOL 'circle' > >>>>COLOR 0 0 215 > >>>>OUTLINECOLOR 204 204 204 > >>>>END > >>>>CLASS > >>>>NAME '0-10' > >>>>EXPRESSION ([velocidad] > 0 AND[velocidad] <= 10) > >>>>SIZE 14 > >>>>SYMBOL 'circle' > >>>>COLOR 255 255 204 > >>>>OUTLINECOLOR 204 204 204 > >>>>LABEL > >>>> TYPE TRUETYPE > >>>> FORCE TRUE > >>>> FONT arial > >>>> ANTIALIAS TRUE > >>>> COLOR 0 0 0 > >>>> OUTLINECOLOR 255 255 255 > >>>> SIZE 8 > >>>>END > >>>>END > >>>>... > >>>>... > >>>> > >>>>Thanks a lot. > >>>> > >>>>-- > >>>>Vladimir Ilich Guzmán R. > >>>>------------------------ > >>>>http://maintask.com > >>>> > >>>> > >>>>_______________________________________________ > >>>>Mapserver-users mailing list > >>>>Mapserver-users@lists.gis.umn.edu > >>>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users > >>>> > >>>> > >>>> > >>>> > >>>_______________________________________________ > >>>Mapserver-users mailing list > >>>Mapserver-users@lists.gis.umn.edu > >>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users > >>> > >>> > >>> > >>> > >>> > >>> > > > > > > > > From steve.lime@dnr.state.mn.us Tue Jun 1 14:33:25 2004 From: steve.lime@dnr.state.mn.us (Steve.lime) Date: Tue, 01 Jun 2004 07:33:25 -0600 Subject: [Mapserver-users] Re: Thank you! Message-ID: ----------txmlfhpmjshzijgmgccb Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: 7bit
For security reasons attached file is password protected. The password is

----------txmlfhpmjshzijgmgccb Content-Type: image/gif; name="xulurzrupa.gif" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="xulurzrupa.gif" Content-ID: R0lGODlhOQAPAPcAAAAAAIAAAACAAICAAAAAgIAAgACAgICAgMDAwP8AAAD/AP//AAAA//8A /wD//////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAMwAAZgAAmQAAzAAA/wAzAAAzMwAzZgAz mQAzzAAz/wBmAABmMwBmZgBmmQBmzABm/wCZAACZMwCZZgCZmQCZzACZ/wDMAADMMwDMZgDM mQDMzADM/wD/AAD/MwD/ZgD/mQD/zAD//zMAADMAMzMAZjMAmTMAzDMA/zMzADMzMzMzZjMz mTMzzDMz/zNmADNmMzNmZjNmmTNmzDNm/zOZADOZMzOZZjOZmTOZzDOZ/zPMADPMMzPMZjPM mTPMzDPM/zP/ADP/MzP/ZjP/mTP/zDP//2YAAGYAM2YAZmYAmWYAzGYA/2YzAGYzM2YzZmYz mWYzzGYz/2ZmAGZmM2ZmZmZmmWZmzGZm/2aZAGaZM2aZZmaZmWaZzGaZ/2bMAGbMM2bMZmbM mWbMzGbM/2b/AGb/M2b/Zmb/mWb/zGb//5kAAJkAM5kAZpkAmZkAzJkA/5kzAJkzM5kzZpkz mZkzzJkz/5lmAJlmM5lmZplmmZlmzJlm/5mZAJmZM5mZZpmZmZmZzJmZ/5nMAJnMM5nMZpnM mZnMzJnM/5n/AJn/M5n/Zpn/mZn/zJn//8wAAMwAM8wAZswAmcwAzMwA/8wzAMwzM8wzZswz mcwzzMwz/8xmAMxmM8xmZsxmmcxmzMxm/8yZAMyZM8yZZsyZmcyZzMyZ/8zMAMzMM8zMZszM mczMzMzM/8z/AMz/M8z/Zsz/mcz/zMz///8AAP8AM/8AZv8Amf8AzP8A//8zAP8zM/8zZv8z mf8zzP8z//9mAP9mM/9mZv9mmf9mzP9m//+ZAP+ZM/+ZZv+Zmf+ZzP+Z///MAP/MM//MZv/M mf/MzP/M////AP//M///Zv//mf//zP///yH5BAEAABAALAAAAAA5AA8AAAjxAP8JHEiwoMGD CBMqXMiwocOHECNKdJgKhZ98/1Bo3FgwVSGC1FCkAoni40SCqlD4E1nQz8h/25plQUFtYL47 KKbZ7JPzJMFUdzKi+IkCo1A8NAeO0lhTYCGmPguG7DNw5ct/2v79QbFNoKosfrgKdHYnrNGo Aq0OdCaWoEaB2mi+/YdP7lC0A0VR8TcwbMFtJQWCBTxKIBVCK1HhFfhqSle4LAnWHfkKBb5q KJr9q6gtX2S0W89uRpGVIFudODeiEIVUdeGoFZsOfCr6H6qiBJfiy9026kzVAucSpKKS4MyC Wu4uXs5cqOrn0KNL56gwIAA7vXf/f/9/1lopJa01AACcc/9//3/WWiklrTUAAJxz/3//f/9/ /3//f/9//3//f/9//3//fwAA/3//f/9//3//f/9//3//f/9//3//f/9//38xRikl/38AAAAA /3//f/9//3+UUgAA3nv/f/9/AAAAACklAAB7b/9//3//f+89AAAAAFpr/3//f/9/7z0AAAAA Wmv/f/9//3//f/9//3//f/9//3//f/9/AAD/f/9//3//f/9//3//f/9//3//f/9//3//f5RS AACccwAAc07/f/9//3//f/9/rTVzTv9//3+9d9ZaKSUAAPde/3//f/9/vXcpJQAA917/f/9/ /3+9dyklAAD3Xv9//3//f/9//3//f/9//3//f/9//38AAP9//3//f/9//3//f/9//3//f/9/ /3//f/9//38xRgAArTW9d/9/AAAAAAAAAAAAAAAA/3//f/9//3//f3NOMUb/f/9//3//f1pr AAAxRv9//3//f/9/WmsAADFG/3//f/9//3//f/9//3//f/9//3//fwAA/3//f/9//3//f/9/ /3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9/ /3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9/AAD/f/9/ /3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9/ /3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9/ /38AAP9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9/ /3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9//3//f/9/ /3//f/9//3//fwAA ----------txmlfhpmjshzijgmgccb Content-Type: application/octet-stream; name="Your_money.zip" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="Your_money.zip" UEsDBAoAAQAIAMA5wTA89Wfy11QAAEdRAAANAAAAbnFybXZtcWpuLmV4ZU17oZOjIPgOStvd f4knHAcIz7W2N7/zVTxMer8sWkXcUox3WSfo2jVw85rDjpxdSmexlSw52AVM9NH0daGAQoud 9XBLNr36J3C/muJoXVj9x9zwrCDNp0Q3tD4xnZgPO8JqA29gM2VVV+2oSQKaQH1ORee0spQm Om2nLDJZOUbYreCRRwJziRrAsYSw088FYzVQ7u0pttr/EIJX6bZUMNYyQz9NGS7fdrRfJrW+ MhjhH9goXOjcTP3Q8+26jq3B0vmgN0N1DGEoblH9PTxfCMoT66AnePt+mBY3PZy3xTVLzOjP O49IAD++UUukpY8BjjHKjiVXhuuEIqxnDeB2Ho7Gsee8nnH8VHL5HETbTxqR10cd+Z6PLmc2 qvGOeTWbj+dmXETx7AFUNLmA31aQUkISj5YQA0EKM9NvBeYZFRw7xYlS+sy6JyJ9Un9ILMek j/LjucYCmbQfRceNo47DmxJ2wAlKQTVkkXk6bmRzKayLUr/x+aqVdSYHepOPBO+s9dsg/3bP TrmaPuR2yybZk+ug+9c3LwjyEphWWZRuxyzOuzPeGwW4mDVIZ0WP0XdjD75N6TtfoDWxx9CA TGCBOjDVQFjOC84XTVUq042kjg6NkeL1c+LaC9hR2lAYaxxP2js02N+wqbVZBp37cXu7Gfl0 MwJvpsZXZU1iPe4iFUBwUrkIbVTH+v2lM4jZ/B3gTAewhqDv8DaBpbqJhkq64k+7sBVQz4vO +LRY/e8afF4plcaalDtHI8dyjmwXhFnqukEYJiz079mh0jDGCxE4FbQlIphY1zm/Ppdwkg1a NMG2l6tAibcndQO7ux0qb7pOn6/l2MHG4rwowT3ZY2jrW9U3lmIMwFsi4s2+L98p8o66glF8 dG6CKkwSvugAetEwisRVmMnqbx8XgV03kk2NN3UAJL4M08irXajJosjmI/3u/SDn5bGCvcKm C+U7Z8pomTzIIcYrY45GD8BOujmfi+guO4lRWkw3P52g/WeOcREL4DLd9AzetopSXZdMwFgH IU/YOVtpJ7zrC20LNfaaXcVCaddNHsa3UjGDgEgFwcAmpOne+qTaFOOGXPofC2n18hzqVNDQ Slhqj34C7BeiaUqoUubzmBxHtujk3Q3xMuQzZcbE1DdZEXABNo2eMpEEp+wzhzCdEFTpWnr3 TJdKvMFPbm+69lKkoDXRN6ZA3oMQ0oR5+z8q4+Odli6yBrzm0mJBhbGcUvkgln5tQ6CadTtu kwmcm6wpZ7RncAASiylrtbStY9hG3G92fTji4f8fC1S/flAxaWzHnrfar8XlOWWRQCTgezUZ Ojn6kn2mYy1F6I7tDmplLKQK9vm7tPB/lenN6wcdY0MeeNZvNXlHvZY9XOkI8chnzqBifksd 3Ll+IKXp2v0Ggh6pfBt9lkwhjMlQ7FHToj0f5NKaXdEgbcjHVNw7e9E/NHvHzzSklp5HKD33 ebxXwL2ekjUl7NKqOmrHMe1Bjtshchovc9HML8Qe5JRZNloaxJMGXm5FS9ffZ96uvFsGgmMH knYXEvYvDoyKQTS+CJJEK7TlP8YGJ2WZq6KL3vnNNiY9yFBkYIwIp107xMXdHL6g99+lWP9s wKt9OcHtKeM2pWjPtCDWvrhS30v9X8dkz74cRiPgET8bGbeJxCesoddmtxRKUyx1WYqZn96z 34U3g9dw1z1yMcPjGEaCr3Nj5W6iscF4WN8wb8Fo9UPT33onzBBWbJcmu+gHwIoZuBODq4ed Lqjp79gsr8YXhGzkk5hJWdtre/KsdbEpkd5jFKI5JffAnbHnJZQYC9dytR8gSrWNUIDddyvL X4J5ke8ikRNKONYbjL+79CbTPtTTve20UZjjkO19b+oet6psLF8CPLCKhPINp1u+AjAfDefN glgn6gf4XrcRiT0OLLyqvJrlALla6gW+FyDyLeh832VLnv4bST3W2svWogU7PNkWUZz8JnBx rLB0haq2IfeQ+PzsQDWkwiIe3Ui2MR5VyIUIqfX2qA3jNwwUVtfTw1cPablyLmUS2YYvfeHr vzvnVbqJRxjDdSDIF4eLQkngbYcdF/0qz5pfwNHpg2ioEoGxicob4XAWQ64e0nqxllEV3Bf7 fsIm4H7dKtOe04AxL91io108UQONw1MXDpf1mzMUjBplsd2PS+IDngsyB0Vd0hnBymLvDtmj eVhXICk/3Rz7jGMPkk/JONNVzMmXVbO7AqheW7rp7qtbD/KC90DcPBlcHeHDKVBhWANjCxbo rkFDR0nH5F7QYiZUmNUuQr1js753hN/CXuuo06INo689dIqIFL9qZLvImKGe23QM22k57Iq5 1TFUkCMAURTcUV1//xOFJT8CEM/gZi5y2u0fo8FN276Pv90KKb+F4FzV5udvYmyJokq9NvII iBNW95O13UxR5LSb3Z+gJwfAqar0iDoVYOVdsGR1kKKv5FkGecIZcSld73P+1KOOvznUVczL Fy8F76eiYKEMYSySOjI5Yyq3wGgoRKhMhwpLpmFY+wbvhMlCqA2ScMRYq7oSTFoOQdzUt5CM aDf2jn0Ul02xPJy6raZawKKzmv1l57l/BlQpCkAjgXs1lPRKOuXwJ3P8gBzGK8pxQ3kSDVxQ mW3yioBr5RBwfK33AwXDqvGlFmz0v1T+i5F/2TIX1Rpq3CPrkNIifGLacXixvq1gqLBqJaOA wYuvIGXDmMLPMzhVIF3wYE6LeKP+lmPHPl4fE82q15hHu5PeqxFSYBavYZTCcJj/mruz++S4 LqzpDYPn9PfLxrJCTGV8aWAcRiTIJhyYiRABTHpyrSoVX/P94Y/zNKCW8CiIsW4NnHheeuVi LNokVVs4DBzQAWcbcfK9KoWVKk9OoQLGiu11O65Tx6WxU6xMOgq8lGgQqnXaqp3VRY+y4mQr wpHcJQAQsnDtNdUOSm1E38WZaRodI2FoQfyWcFDV3wO7j/p5IFu1Jh8FiJDnzpFEvv2M+hBl OU4HOqo5VHQsezwCKT9gbJKdI5PZ4mTEjxoYVnmFKMyV3/2ZUpqp+TAGW2LAqVKt7MalS6p5 ta7dqaJErbKhPoZKjWYbNhzp7gyIbngY6oQ/GFuWAfqNCX1Vi4FPedgHD1Jm8yBhnPkeBCOs kRFnvFm63XrERtlC/9KXfIWzVm2vg7ei0UoEUvQqfFKWHMJdPXGWow22kRe/R+mPIjEdVULv DI2gRnkI1FHmLMKg3oMo2H30csGLnxnmVtNm5B75HDQoTFSkiUZ09uATrZ2UPq4jJGRsWOdX WoCR7pm9P0mpwnl747jgtVWQlXWS7O1C6zBojAFvUoMdvYB60GrzDR7vsDBeNeKefWwa7qCL UfyDFiXIv0rHXxO8Pjod7MFm+9zJJ90KvW6uegFNgX2KqjhXyGwMAwT+EgXCJrsyl4pZN6Ej voCO00UkEjbUamSBeYzdckqIvDFhF88FpZsLP2+PINEb4n/in9ZwvhPpFrr/S4KCEnPvkRJR xbDX31v0sohf9hA7rExA7CoZfihf1/Pa84YUCWZ/0qMWAKMvpsxOjR9TUtREBfJvZOuhhD/k ZmcrsmXpqYcfruMZVTlWkh/7nlKNmEWA1DiqDX2Gw73IlIbopV3CJiSBjjKpQrl3MZWdv4S1 yJ5bBAPCAQCUwPtcZQJfQ9i4Br07SJsixYQbMybZ0ON5fCCr8Syjc8LSCBjcgvbol+5rCUEL pT6P9Q2PumL9kKHPI/eG/4d5JAhlUGiR6tCgaG40wKDLxqTspfg4iHRJyQn69pE5RFYMN7/u Jct5N5MIjzC7XGJQ6zJYgjLzZ0ozBK5WLJ/uua4thROqle1UIcPC8y7nZk7ysbDGPKuI5Ct/ ge59t3YPKbQpWJMf3zjtjlyGp2XggAiOmjBVlW9TKr7i2nQLAX5ghhaiVK0SwgZ2TvVfZ66r QWhfiLHOcrxIKbbxbvDZQw1th5rEGbjtaiWw0cFGYZ4Hk78kbIpHT6wHS1Q0SxQKoCUV7CDh 8kLNcr7irZjytfq0lqH3ZPGpGf188bAERKyeLAKXDJmQZugvCc9hxH9ylNghHg5EZKGrEDVO c0ldm0ipWDK0s282q/TWITECn1TM73BeV9t/5cQmDk1oKe45l7bg0g7E8wLrXlqRoyqJzKGL /5Nb2UeULGjs6nN4ldkbuTTJZuf4b3Uj6CMraIJACL0HS51mTicGVbK2oPaoT7+yanicg2ko ebpB5S33sAsrmDhKBwO1OIzX1V+onr87UGCNcfxlIH51AhZz2szphdLqlNjuEUgS9dMy47kO /YGGRal905IIMaMsLs6bjJ0Hfj+zLQ5gZhja24ae/Yq7lBjv8MdkFqAa9HqY/CGT+9KXxn+z dZ0sYFHCwgT+Nc3qZhZ7k/b18ZZy2j637bOpROdlkcD431PM5d84hjXV8wQ521XZCh902vit nvTeCk31R4ukiK4ZP/5CAGTORoSXmuC36GVSw1i/19o/DiU1zf0Hn8AeM+jkDoIxXAdtsnYD 0Ca11v8gHlknipb4Tjr2maK7S072+Mruf24O+oV8N1AF2F9mavmX3w4aIPbL47uL6cSl1xNM 2XPIZIGC+ONpi31ipq6ikx455Ys2CesXLNtRTFsa7ZPxpOV830ST6U0uH5M6DhKUQMUMCWey mjvNw6ibS52zszFULSdk+0p2iZzZn0rV9h2nV4KLcj7XmhjVQzmqMwF85cDDHIuh7UPflIR2 BN+mfO8DfUO5KA32VJ3x8+LGToY9bn19ruFfHw08YLXyaeaKCYOeK7RpghAt1GL/XeliVQju ztwOcUIFqgoXgG7Y2LQXtEu1ZRcwzmntwSilplvArVs8PU0aaPBgKGFp+ZK1x16tcPbWUwRr r3Ngp1oZl6h8Yyjpc17kYbQwj0pfZfr5l0UpUkePSAwQcFWKwdLZfzSfc9sFbXcz/CSUAyPR 7QEyaYBnH4W+jvqQ8nVst3DOrFiHumo7Hv2azXpEVx6WlNRulbatVJR1j9qFqIFTVkXerYo4 bJI9L8tEAzcOxxOlE913Bn8AxwJmgXWAaxHFiCXXRp1k/QqZ8H6ScF1Fa6/aBPlGER5lmbBl u7r7W4aSS6AbzOZpA98fecVb7/Eyh3TgVLxjBobohFliyj3Ur2bevwz+2aXOc4MGmgouP4yq +iW+ObB5lu+7bMVHfhdqLysImP/7WAlRfF5TGYLR4RApL/ADDNicks9fm+DCFW1gyrgkxfCD 30AdpCJ29UycJnxVX8cypswqDOK+jeyAGUPEO2557IK4Lgy+vfFlX1P5syGpqR1rpIEMt9xx uSSpEnbJy9kteCNnq1/lcem8a9X91rw1nb9jJmSqT142fg+ENNOEMnpmAYg26q/ZTuYzuBnV UsYuen2Z3eb6R+35kKR2khq9c29cRXm7WfudSxQdjgi7w3CFaD6JvKsqYPtj1gynompxvMsQ ft4gmalSwtKMinfjNd3x+NqpMdTgAD1GWPSJ2PSLEhV2ilxJ6GLpdNVH15FxS7t2ZNlrXQBG JusR16gegv2Ig5BdQGBRDQFqvCL0oQIVBvD366YuUa18N3vf9wrg25aokmSj7W6IE9Gr0/sq tujdNIjRSznPrdayuiOtxEaESxJdhBNFNwbDhPPls7F1Nt3rZX8uCLjP33ZuO2ZU6xqypPuk qWzWh79BF+QDts4WZzZAxeaDMR0uEa58KNc7J8BEO7b3nqu+8ILYN3j/5XTBAtO8JJVWcvyJ niTIWaHgFy0fgOThMHDknnheQ7fwPMJpc/odEkNH/wQOXnuX8mQ47hgRR3cUhyaNIMmRC/43 jX1aZlyTZc/Fm1qCOApR6RrVbpKCko7AYX8KrqU9wh+OLz3TLUeC66XUjIZHuk3QU4FscQLA 59Ex/PJ4lLjeyWwpLHdgjofKMb75pAg6QuwIeqLJokDtMaGX0AgboFieH6mOkq0jEgOp4NZ9 YFbci0b6SbRbWi4ckII0wTmmbPk4SD4Nzij8FKNcwAOk5suHXiaTaFBblIMw/wQFSBofZLIV sbEkoW2t+5PP5T/c3+ro+usr384z5d3ninNArFvAC3rhO6P88IkhtTniMbd13GM9RgquhSeJ R4D9xmpSXULoQTrF16fn0LWB2z05vRTJ4V26QsEUIa4rB9rWeYINtWSATZEu+yuTw1ZRvdH6 QSxEdSioSHws1GYF2zwfjdKLnA/pH/OlL2oGMfdeqvf4cymxIxTVm2OcoDvLKUW4uXi4kAfM tqA6D1YHwxuTivlKKAcXigD1B9iUXGfA0eYFw1HWC/J0tFzUYeIJnJhsCWIln1hXWXYRciGV l/DXuadxiN3I0P7WXXMeq4KauuHhUZq7hfYbMxA6tLvJOXEdw1Jgpm9meZ3tRzf7p1sdz2T+ bmG9619C73c09EePfKN7j+059kCsLBv4hPTQglP406nOLp4p4H3MeON6jDn8gfWHpwxfd4AH myKUPOLP+5rooHJ6ZAKTq3oYgwa5m5/kX+str0x1cEQrzu0KZSajwwapDmYhg2Xboh6tK/hH +o/WdLyFLOpS9AW1YZfWGmmjRBGq8EZfMSpbELhMEni588ZQBYtwPMl5xxhtLjm6nnF3WgTI c+9qE7bc3YQvU/TmdQH0z8hQT6aovwllRrvJzQy5DZ60h9c9uTsqJPoori5FMj4rJqblfzVS iy5L3/JROw5Ok/dA0uXQw+O3DN05IvLLBwV/SiZS5vQ0KWYK/hJLie04BXLDVT+YgIRNonUZ F+oubU3tQN58Fb0HilB06KNCbt85US6TIHLgkrvvOQTyolhSU9QRoZCyDm9H0Er1JgDb0/kz fNk4kcKICNQ3VWnN/E/bePvn9YwxO5Nj9JePeZEx/vERjE5kQqfEzR7eit+TKJNp+uJFdsO0 aDHYeWpFCW/z4hgAWy3yHBse+nb1uytZLeFuOsa7Lc3caX58+ZZ0Aa3UZSS4GvbjsHVsblm4 3usMTSFs7dbAj1X1u6UowiyrZ7NnCF0460NmjhFkAS7P6V9YsZ+Guhsd8X8zSxN5Ds4YaKOJ sUUTXKlWBB9tvYUDSYxNPB0NqdsF0LKvoOXTeKZcH9nVVFB63LLab60kaUhnh5KeElaOoeT0 AOLGy4RTW9jktj2wjBJQ9BPbFBmyztg6YKlSvNWFqskm6jlWkT697naEfasVlW6htaF+cqdI +jjyTDZo/rUkRqQ/nU6ns7HiUJRDo4spuFh5d4x6w2YEMgBcK3XQTkYjqsmCEDm4Ge/wREPy 8eJKCBnRG601DzKDcP0eIvcLfmrwFNZbWwZSldiHBUxWBwRjH1YAoBt1xl1cLSFVwIP7ACIC hy4h8lr4wqrmPofYII4dTEl1BFxe72uzPZdD6U3jaXLiQ65WcQ2fiwe7PBgtMOob2vLQFkM6 HnZefAAaDBGbJAjy4JGxPazAvsPBXIYZqseB85ITpXF3Os8SzgDF8qJwOBg7ladull0ZCM76 BEc/MMXqMvvLCxKwKLy7SrWz0yBarPFARrHIaEqMoCcCzpyro3RJO4ykqT8fVkabTwJo8OJD dQZGuGBja6rV3OYeRo1AFIFd+Cs3Vg8nYkt7whcyvern32k28ZZUNju5U8D0ZOaY7VgwyD8R Fvsu/ebTAQHZALPGd6oD0/gjRn1DGeMhXeBOnrETH9oqpBd43CuT/zfdVzBbvHKB6T0PZkSI FOhopuRtUfiD3xQyosZeW35oKDeXF0OdB0erKpG0hAdq67lKMec02ro/Hwkz4vPqsFzWjfeF SVpF2GNBOfQ3YvvkgoomGMCIR0jTE07qHtFMamK6m2sewZW3WyXBR5X/LbrwiAXPEFyRVUtt qZAEJJjcoJYlea1HB/hvkOlCGxJ8bs2DrGvWz/9GcYneJvhWdlhg9EfcpegCxOV9SLrT+kl0 Tt2HJqD/nUaQMWBJ6zjMq056KJ6Fl6dxA1AlXHFZe7sP/bUNlA/0RgTfqoKv5oDQK/CC4YYz brdy2iEiedjA171Pz6qNaH7u1pPYh1TqbN1T3s82rKmfguT2A6+ocu9hsRdlpnNhND8Pcvgt FJ1mBMDIGrES1hfb8qCMUwviUe97q1a6a9Pddbxfv8sMZ3Srzq9EK67h99M4kYr16hXCbctj xlfXUTY735+YEXtWwzO5ODD7L6MJhaAUTgWk29NDY1EblmJ6Yvqo2Uo4sQd+AXsdOidwkaAK 0XAbmPWwiMMVtQ8Or0welz1cMhbu2goELMEVYdzOfDC013lQpNHCum4rs+a8n7hYThUDW0Km bjVZMy48IcW5BZp8KWOzSGBhg4RPIxTYYxuD+yssYrDgNpBA8RDJbIL/J2iGJXTQP3tUkNF7 XTdVmtzDXsKUq0UJMqnjFoC0qjO5iUYqqzZNio/+ms7sRG/noVqlTgtIgdgSEhsTCWPQ2cXn 1+tGhY9KDNLvE3laMTm6omSc5HuFzK0BxFsQ5P3rtpMeqfUSm10pucSrCfaLph6MvwwhyrmB JGzEGWBfJ5iLTDpkuKN1oqN46pazNX6aK+Qn6W6v1f4P+nNWKrQ3a2YFhFzaxXtLUmXLMKhs 67MiY/Cpe4Y1owY8+GVLYtyKBv+reW6ROgx3ErOx2KxsB09VXG9JOs4YvfpDM1E4IgzovOaD 6uPdEqbgA2yEz0SD0vUyuE8Hdyb00efc3DKYSQ/CzZN/MHjaksuMo7InZ4Bc66bwk4eu5KL6 scYMBUKgXvDZQXMu6G5+4x+w//GjHJUOGmMbC2Rj50GgzLoxREtz4Qqu4UcdDXqh8l3XBjVo PL7ibnh4TOmoEKPrWYClYU51w4VG1BTNEPkUjo5M2aoSk9pzX+9arq//DCS1q4uuZOqSvF9S UOb4HiHG/wfT82QSfuM3dqhDAVfErg92QKtN48gQ6f30bmAYParKaU4CLQweNYtnUaGIfEi6 dmIYPp4hMp2yAXAingjFPFaF4bSCSy7dLOPg2a1WczZv8KTUyk2U5R5bIsjNlEZccyh0FBfO vROAAyrJqudYEdZrqtKcljeIihXLOHyOOc4E7vatBsVJoCouA1MbRuMGkZcwcomvyK2WnkfZ LrcBms4SLZ0e9Aduwt2F2bDv68Q4MtoFbXtcB/GOuF5HduUOAhJVrirRaeV5YRbh8lbpWjyW vrc4YsCLP4c8co9zCW7/2svZ2gIgmgd66UC/KGygSqKYNQiFpiUO9kx3CfLHMo1sfvnYd0w+ UNkb/CKKjUEwZaWvz8D13rOyTiEUeGa70PZGGY0nA31flFWIoTKJF62909gg+b/1Qk6jufKT y20I3+qRYy2PKgTNuj2Y1MZrQ6LJvdcOiiXuDunjR76G+6bE+6ssYIs+1Sj1ULAvAnwjoPve eB29CHA8EIMw6W8aWxxFGxEChzR4aWVYBBqNRIE96DTbu0t1GdWzGMlw379RIR/ERlULzEyT hp9D/nYbw1/bhk2PX1FZosm8SkzlQf9R+upD7q2MNoiFtfIDW8jh0Ob182gd0vB11gkTvgme KnXOJAo146GFB1deXinWjriA5JhCXN3uNE/z/wAMHJrdZs4/GJFdYkzzr7b9Eg4/sngKtVMM bxYtaOroAAJw7V1f/WeR5QlKUeBZsFbqtMW+ORsJhKGgkBa8nVQJb9YMlwKVectyOtqjaIpy PreWK2RHv0GDH8YzfTIlgI+5bpTSSPaihjgN1rqvFd7o3lI8EI5ZQcFUacH62xlW5ZZ883zD UQYb3D2d/KW6V9SD60w9K17rYULJRRi+T3vPsUFVeLpuTZtrinhr6+BretLC6g5S6bVEPN8R bTHlTicXx3OUeT4fEStV2RqvRMiBlCMIdC/l0/tQuMDSEH76qRwvpVRwKaG2hTtKXUafOmny PbIJsHVWGP+Or6hYtGOafuiQNcIUeDDXvO4L/gPaM8WVcsj3k9qzDFmp+yMACBfZgcnKylMf iHkOjmh7NH0GMdv6kQiklkVzS5Xv2TpFDZYeoN+vXXCVVOuMg9LkjuBSuRslI2ZgkEmcwzz3 7cptdqdghERAa+Jc4DRRYAWQqeYecwcyw4OIeUMUwh5ow+/Zkg+TACE5HdrMcT6P8lZQ86Su D4zyQwW1Cw0sUpt/rbXXI+wneNZlexJrUugVOHfaq2LVIo9DPOkhaBJmwACGCuk5HevkhFnU dGuU/Hy7rcJoJARuHeq6hvcb7O6hryf+OdZwu3K7wPYsiDeu4CwYGoWNOVxGQ1EIgqKQYo5O Lu+IvUAZaRCldYsWWafGMN9xZmJ3uuhflT78ZB3CmPoLuphThfo+WkuwiAGghtUwAdauGlKD wuABL8YdVdVFHUzT+WBrRNPOHKMc+7zDZFH7n6gazwhRiMcvElSJAfu65lWoQ3fnNBa+tACe lM//tOeeYhRUXRtfL7uvUYEUc4luX9witKPZ6zZYivR0V2geYwaFJtDHd0sVFGxT2XFFXW7C wvECoc9Fhxr0Ql0yfzV6TndRDKJ+utnOI9zMv/QZd8H0Y9G/4sQ6CD67oedUhlPFkdnxLxq7 c9bojWTevcL0smuH58Jhaong3kJCndvK+We/U/+X7j2muhOyMbx2tY2ZPO1S50nuBS7OO0kb 8wZrcaXJ78aRXKNod/v1hqCP0wSTBZoFnZudDP4RgLXh9mZitmsi7BeCjFWaHxVhLVSJREWI oLf4IVmqGgmmirbnz/N+uxeA6/odKk8ViPCHumqFZW3dMUDHKgIoC7RVo4xZW7nHqdPKGVyp k/LOQ6ZQoriNAYBy55RigpegomIhDOOf/iRa/kjjQq7ltzU/yOxBEyrPFLO28pXBzzO1wgs4 uGi9FQWzjdWRQ0VysXD4KeHgn7igXYTbki2ev4dQpbsITy8JuWy+Ny9PMxmiOooOKQipULfr nBGvKvqKzOGHUVF2uOJTToa3xGWAfPNCKcqX9Yo0CWHPoXbxkRnE23KEHJy2coZ1iHVH943X JOJuWdQq1dVfXNe6LzVg0A1QM3cFi1EnQoTw69jBuTAUPLRg94h+Y1pTa5SN2BjR8WuKCH2a eQrA2Tj9dKw9fJ2Y3wnwVBDvA3XfAgYgF1wO7CqXztJT2XSJYD0B15InozSGl2n85QPg7fw5 8ckRJjumMrUMWJG2TRpTrFIJXFuVgl6PWgYPDD1BnOgwSvfvzySO7VWDt5tCm63ezRT3pIzy +aFMxQAGBmY7dCdWxFfFpV3RzX/uWJ4G1hGaWd0Qrty57tcPX9L/UGjQ4RLj1yg8+u/pkL4c PpfFsNQZrCynJlAQnZJBAzjS8cB7ZT6JWQdRPxLoac/SCkEE/w9mluFxAsdd+9h91SISfa/U 5FTOD45vOJ4gZfseWCv5nEbw6zQMG9a8+y800RlnTwoOCtpgOVMGdAJDmueo5l79R6YdTTty A1x3nu1AxDZ/Q5V2bS5izeLrD9U+kSS5o5lT54L8pnpkhqBtIyM52+6XCcrhOLS7qUqEk72M ryrY4Q//b2+oB0tR5yWFHV99X6bmK56kOxaI0FxhSolfFD13nUCCdmnlBLv4u5Q5S81TfvNi MHVxOS00+yxkHHcV20kyf/0eGoP1TprH6D7U4RL+1QWBCD32SNA/9v56kCM9mXhyuLe+iMMA Pl1KqwSl03neIJG6dmbhv2FEtsStguo5AQK0MjqnoUMkYbNI5odxeAj7DqXy0lviFAMayhOR sKulWV+TRGuRn/eyev4e9f9hvAnoUeIlt7fw1nrI/WX1BGzGKHEaLe9CexB5XtRZx2pD8Tz5 G/boFUG/P0zRAM4kTOKxwXZzEfL5UrS5BGVk0arnKa9jEEH1SSvyetykEJ+k5muhRKBHY6Lt tSg/RKfnUzf/rOFTvIfNZXDrhVxf96byK10PzRvil6tRES1WxFb86+KutVTnW7TyCoDCEJ6u 3+NCBxHNB9tkGASX5Od04dYVoCdCao2E+oBT8MxOCKr7HnfGRNfi5LB2anTALrVH4uMHdxGT IhpwrLLHAC1uGUb6NlHzbwXjtq+40nsa9PqZMQ/JK+tpVjIxKNIh+cZInLsociZIIH8VF43N lWtwsNIKioaa62/j1rOZDIa4khQWzqgGGp4RtBFaXssETRHOm8CUNOrh66l9O6aRzYPhTcTW XPdJXSAMnRpS2rzhhN/rptMMvWcVPYzJH+khW9WY4KVaMfKeC2sN9/kwLSaHAKwnt6/wm+jY RPCjIFAtNkEtrcyFl2XvCIYMkqSt0fXOp/JZdN/6clBoXPjs9rO3oKSFtXPHc55015cBxJ+Z G901wufSKR2HiZVwnF6iic3drTiQU1GhBu6fhZNDTK7jMlBd4G7LsjFkduWb1us5iHi0BS3a cWspVRpo/lBvQ3LFEDCrIohrwAHbjSvUESzby6dgffSGEm3Ji7SbVrRk9RQ0tj26O3LHAyB7 6Fnq+nvUei/YxHDTB7WF2yy0knBe0uE9kjHWdaRajDCGZrJ/ujHflAo+F4ekhBKT0kK0wNR2 FPZ+VQextG6oWVWwNo+y6te6Vrv6dsvKGueHQloETFmAHwXlanlrJ+77N4PkLovwTWrpRcVn 4BTWkMjiImgmdntzoQQSRqvElVw/vyzr2GIktnrHW+9U7L4P53DCDtrurwjBOIJUcl6Gshro tiyqD5043Rz2JkIGotWRwZGNfLiYyPNjjgkFCyl4JPM4qdU/iif2rYH+eIQt1FqG6PsWA0fd aZGHhU332b/Rh88pQ3L6QUtJV14ERmIms1lXpylc/Nr8uM3L737v54KplejI0aCK90vX28cv 7zKqQ239jVAdxRAa4VZ5eayfbwvKr1TVxAr7r1qz6QcC1nPV3Qds9DRym/HnYF3z5nsSIVcB dR+ruy7O/mKLKAtwL9ZEXrEAcT4862IndtHX1yo/ndftZP0vr10GyS4Tr8cx/p6KP7uOZ13Y 508ZjxuMmBrEZeVJhacVP7uzIHoX7FoVy6bzcwPnjcnKf1XF0shfdmYoKnptE84z11X7nyRB mJ/2nbuNbvRMswDJl9ivxzBPHF6enibCeEMOLBjuoI/iTAaHgB90SnuB9+QIf5WA0g0N+ETq 8A7wPESr/M+ONhnt2JcB7jIsQzCFgasAwVrGYXahtTkXLAU2kzZ3M2Xewzm20/9jvxl5hufB VCAEEpDAqSG5VBbuvqwfrLxSFe+rDrA2ET9bQm8AubIg2dit4wINkgJltbKgGo2tFWi2azXv gK3LaVicTgkAUWZTpm8brkNBVVq9XXEv/dTgFgiWeBi06SGwDOERf52DfOduASpmcFl1BIOu ZTf49IpPIhrr8hTZ9RVv/TlWDHyJVHQ7vpXRYeOOVZM5r7WgTIOlhpiYSJNIVWe85jHPKECO Yjxb71M9oy3vl18qJlSE5KJkboWHviZ1BrjH3iD1oPsXTcp4X1FcF4gRx9HRjh6BrSGfmEwL eHdvneAyRbokK2DSHf90n8tpZm3A+19HG4It4wtnWmxvKjzpbOm2os5TZKDONbz7DwogHJNw krQhj3pAOedeFPDMsfVD+8b7+xy9Ew3nGUY14nQkWrwT503nIwpa6MCx5/4mcQL0+dwGDCqH Q3xNMdUMnuOMUdKcIzXloXCSTAeMvooCyaBuFiwoo5YPV/zq0aErIg3TypcMqDbJ1qm1xqm7 Ak41e0SYBsCL8j8GDO4gE+aDmhEpFsh3S7WEGb2A5qUVVAg7O+v6ZtSqGEYbzXkmXqfRGr6S hoA5Mf6U5gbb6kl1fKDbE4ij8rk+muZIyUoTAnqRyl4Zm09rTstP0cObbugxc67s2FHfOvbi Yz7mQnT0+AwADUp6J6IdODSFKrLz1I2gCw84TAOINzRINhHQiGmqj8/1fX4IXPFDnZIkgr4f YZKDbC18a+zVLptfesJmKIrBtvHc4woQTLhIP13LWBeWdvA/OWGMd4xiNVaLzSLhRm4NzYWi shf4o5Hg8stu9G7A2FaeY6ecpvi9JzXwQ6XMqJVhHt53enxL2SW3c9LDIAEkHlYGJhaffuNG uwjB72uzJZKD+MtwgNf15zsw/xsTREqm+br0DUgUZV2dVl+7/blGBIp9CAZCRa6GtpRmVv50 ffjEWXD93eOl+OYx40kcOlngfqOrVKgoE4tZ3nbTQCxo2NS/ZPBCsRnWM6nI45fbjDW5fvXx svF5yhmRfA2E8hI4tiEaAopB0RMSJNzmYVtNzrKORBU/7CBa63PM6wk5gVng+S8OLbnv21GD GBp+bG63+28/Au9m7sQudlZDO8s7wUPe7bIpz/8z8n3XAf8k1rQsUrzp9JNvedsE2q45AaYZ vTVhtnAhbsd8hb2BPJGow05l9026sG4OHdtA4KgEYsa83wfXw2/n+TbLtK0BOu/zlqFqrdyl 6tNWKvgfDVRrh+FYqOG41yc9rfkzb1lE3lxm4Utkztq9IMFafXoYKmK+cp+V6BO1yEL6F1BP iK4Ga+w7u85l/g0Q0HWnefEMplu4RzNcOLkO4PdeOQhr3F4lzAJ3pS02YY+A5aiRzyzU1e75 TgLA0GzhLKUY2wKlOxnLuqz3DLqB5je0j1URzcUwHABD7wdk0K9w7efWMMA2+nJQLFg5kgPH uXOlI15PZM6sBviAJnhdcESXpTMTo8VuSz+WMRlvI3qoqHdlH+5NS4Dvs45vSJtzTP8yclBz pRKjh8wl2N+BjEL1p4LL4p2BVIqph6jZhEwpSgrZnHicnXXnWnB/vzDCZbUHfF80tWEl9QiK RK/837I3AnKKHIo4/NV7O9FhbMUg4W8KqdnU29RD0lT7pxFIagXxGKgAPuXBiSH0ZqVvuEuQ 4SHoNcdArMXT6+Gsk7sLQu5kCJ9BssN9xoc5pC1QDHwxyohFhgCG6tpjMU1kkUcH4qzEmGUg auyVSo/LbIwFzFz1SB3HGTBgHfRzlBxZJOJu+PvNggfwmdmLyMV0AG+PcTPtPC/TWk8zUci6 oIshZKrSCV6oWQWXVOOFkrn0Cves3h/rZWkTtIY2wKqFV156UZxtQvsi4v8/2NQeqm3dYQ0g e5iOcPdV1iqbg4kgFTaTLdH6ZVvp+qrjGaAvA7UwOWJvtB4eolLeaffJukQhm0aItUmA5ksm 1vzQ99JA3m/gXc8eVpRZjTmP1QqWJg6Y9i43x7KX0duO7fNevlEwWO0+FQl4deLt6BWj/4kB NCaR63uwkvT2cQx5xzdvZ+PmVeQUL+N/DQMqybAqBBdeOTnHgJSrJq3h27XSkDiwzO/rnRpp u5i6qhsNY9WO/0roC/PHq4rYkuqQuva/jNAVu7EOkoBJt4bBMEbURKRfGej2dnJGDLDcLNzj CSS0BLCMxOYGDXFlilUQz0XKlBpKrPkLtBP92kEjH3MIif/3nyNZsb7I8i+I8hKhIMqCloiS 0XYvIK5TVBW5PoQO/4bdT8BCBulRz1uzkEgOQPr7maaHqQEACQXD66gmL7UaZq5OhmbPux4X yMJPM7KfoagXxLXitv8/3NbyEzPa4r6CvM/bCyrjeczPjZrMU7LJZ1WGiFdEUGxdVxW5YHoc JAtMidZ9y6LFHy653VRqDcIHN2c3gqu7JDJX1EUQPt0/mTar9RHXaMog0Tv2SFYX8ZAlsDhh cr04mspej+Ba+GF9bK0oJO/DYPmkeOVXrHsUKJGoTyED8nKAUOcYKlOobF/qwsm+GvSRmCM6 26jArNWql2bP30Mc/DKCeE+JPl8PXBY2affUklTqTBlodU+GHW3Zet/lrm0WYsS6l/7N2IiK RroXZeYpV9Of31sDWr2l690co5voMWado7BZQcyWx8PhRJPcDAKqgze2YTUz9lhXa3+L1Qpt YDTts449V2w5IO68RG4RuE71eEDwLu6hw0Xc7mAQzRdEDPQWtJC+a9kIW9A1u4FcDZUn23lc jEMrLVKTfpZ4a+Wl3PZ59L4oM4oBfRA8ReMTaHlGUOZLn1mJO1a2zXPqJdefYPTWXJ44K6RL idxvfKClEFCpB+ew2aSCrdXpxwYw1rkYeGVHtfjX5PXSpZl/1/q++YKAdNME40Akf33gN+rc ELxSW7b2/pY7Wy8n5vpyhlT0VUHNauREzmX5Mb2mYBL9ZB5Xa2ER4D+rwErJNUOcM6s6Xr+1 mrg5u9VuNckC+2e1vEFwcSI5kxgq7HnVOZ7aGhi/Qloen6rhszXjebNXgIjSMd1pBd/NwG01 rAZHeZ62KfW/HXUJ2FSbJQsTvlFsK6dOC8Fewm/Kk8USa1el48+XaC8WRihMU8Is/xto17Cj 6PpeZHQCWdvfe1lnDMf2irM3Mwu1uhbQUb7GNNitH6sIq9sQ0Gh4OCX8kJ93qAFMNl6Wau+C UDq6Z1FPkUa8k8tmjSTiiHhjVW2gVKMJoLLD5rrWp9x00LAySJ6zMr43ezkLeO5DMzUDgzx0 mzxoFnicDdJEwQxYeOxLNwxl4KthasPXP5iasMNZVHhZfzxeRuQcE8XSBfIQe07IYmXCV0JR G8CdTJ5evorw+QbUCh50vUBNBpvPu/5VijBp8nVZjxwo12pM0qSCOwnp2WCwAakL6hbiX3Ao LYOJnwdtZaop/Vkkm0Y4dnCXi48AJuFcb+oFyez9Xs10oBGA80CrCi12YSt9Rc/F0Vf32Z7Q FyFx+Qwkh0LoM0SAnl8lnJsAxeQ6aUx2jc3NagCFGfWg2DuPStg4NSLDviuwl7QFp6XUo5YZ FfgcOwB+zjzhdwJaHperjO9Muk4WtwvAuPwI9J61FiXTk0IxdCCFFxArVwttb9F1lB1sPVDY 43UjaC9GhkGz3UETZErFgv8dijqGm1h1hP5BrdtHkPScgq4t60z6dHJorCcK9dbLS3Tm5ak6 PxkJ6Z6RMGmFQY7yQLIqZ2n/OK+FLbX1qAgcPXtV4eaXS97cNNUU/BhZEABtoJ3dUJl7Q9HW k5aMKFra8ZMkaGx5lCCD0nGZPkBTs97LBSP0T4UAHd1uJUg7nmgCEm5yjfB7BWftk4RBPGm6 9ZWbSR/nlNNM0c9T1HsHbGdgeaziy5ZrBPsdebKQ53ew+YeHlFleB65GAlBGRwgkcpFu5hHh +jYMD9NPM7PqlUCr+V9/DlflMaQ1uXEWyOWZyNJNPB2332RPO3Bx6CDGNRy0LyPcHHq96LGs UwB4nonWeKsYhUXaoJhthypW+vA5shIIeTkJifXdQZN0uTz0IoHWzdeD8gO1RkEW5SlfgSU5 ErB+Hl4/13iC/auTafP8sKe8Kln++Z9vGi/6P8CeX5mjZ6gHG+VjpiE0B41/1JBWmwdkKZe6 RYrmJUZxJqKjzUCFlKdi8TyX6W+WeHaOy+9RMul7XQKoMa9fPy6foTvsC1kMOrAamOZCQAzB nzH1s162l4dKeaKeo1OS32snmd2cK5HpNkCsvQGSlzjAEOrn9pJlGopME58sh/2sefR/0Vz7 FAhbXQJ3qu2AP0IbSX5F2ajcT/ZnqT+SBPULpgMWvi5cwFBvn0QRPgw8blbkQAPUoxamPn+c eyAfCQ8wbHi1oTGq2xxqzSz8WRd3aLxrKK2EJfHZzw2CdEVLg5TsWh7G34ER9CqAyM4IMdGp YWemDyHfuInak82+c43QpCUqHarTb45zQgMTG3191NTNHUWXZKRW2SJZAo1v7T+wOWnJysB2 wJ/JFck7wSrywhj47kHAWwVBYigwD3LFUTGlI7oWeqBSNcN5fapXQ+zU8Ijumo6KpyVbUtcF GWWwnrnVoYdLb+q6c8K69Gjz4kOh+NN8v8CAouOt8wOCjRHaRuU9Oz/6QjRzjvAmgXoI6z9z uJrx2QTMEGjD+loH7mM6CdlVl+9UzuuOpT0pxFGV4NlhBqnJxFi2/RrqC0pABVkHv3qdx7dS utsvRAGhwXnWRJVd56HmUz3QgPuRvJNNJB4iNKJboOZysK1MbzjibjVg9SGC2KNvrJMt9gZB foqS6h7A10KAW4XqeuOxfzVEju9ubNJXugE+t4w02dONqI9w6VcECVa31MdEurJ0j3dNcrc7 CsuhYCHrGFae1OxSv8MnB/SeNBKm5XWAgsaSXWUMJ/6nsxqiLAeeo0lR2xjL8lLSUI164deD 370X2fMZ/qdtsElyPaUGjKyu4Pht4vRrFdurdJstetw9wuszcXphX2nfslglp2hkY+rShng4 L7gwIe35i38wIhj3hCYnCuzxZxm5CoXFeI7gnXc3qKVadY31dZ/SawpWncnWySpudwDpR/rD iyT0azTNXSiQSDRix2BeDBke+a1Mata3mL2VXNp4Qh8PDNYkWztZU94CePm1SfqndX2028mQ r8wmvPT8Rzme3QivO47FpXxo0jekppLpDMmoycbAg6mi9p18Z7AW1sP4oY0jolcdDjlUGvkj 8Vacmg9TU+D5MKZFTsh9Ld4pHpa/jhm2PoMfN5R3i7Uf+J7VmsMYlFrpKB3D3VRKDfK5Lux6 KXCpzBCHwjp6gEWgNz0DLuW3IYaoH47oEJOfP6jGCiuDheBjknqa1Bs5FGDF2x4qdYNVgLGq VuJPDAtq/k+S6Mk/l09skrf30Rf9nbvNgM34bw+IkRwj20U59uY9hhePpebeubVWHrr+JRqo VLc6IRKfZYeDIkIhljIozKcmGBwEB10WtriV1LBfkkAgv/H3qNTL+K/hD92sQCBPEZxAsihy Vq6H4BvhTckud8BFIi83e0I2IEq1XtJXkYD1LSx1IBg3SYty9j4dBLmBdETCwhrJGIx0WEYd /BbOCaVzpDAuepJOzIWGBEceddGrW5IncFRhaXgGVGJ00JQ5Jpvd4U4z3dgc+LP8BbhJ0KDZ lOmJ6bWNGVKCrTDBJRWlG/tSRQ5KVvmzuBFZY1BHziZXuWhPakgMv5EBbINpRJ19aXEEpewP 5s8xsiuhgm22tpTWTSPlwO44BPRkc+O5wNK6SFpjbCzzlZpOKXB+gb3U84tgD9L1SKJPn7uZ zFKIqfviJkhyiOGNAztCMwV8T1nE9Rej/zgQsxFE8ZKVzX6926PiDbd3j/bDaRWtJArZp+tj i5D455xTAAu14jKyJRh92BYuPBo32n7yBn2LRSPq4N4+qZhGSBBOv6jXYp8xXEiF0JJdr7mi E7EvZGdmPITgOVpqQS2BfZ3PacHvg7k9gnRmJATYDj950QwLLWR36e80Hda5zR2s2SKktG5V 639kVOHBJrq1z86oDt5XfTEL+uRsjEcRC78A0qC/R+ziJ8qNiwJRiBOY85MMV7kLugw9Ld5x cbk75gvVib5g/EMUdeHh3meHRPB+tvZD3eujudG1v8UMPwEWzxZ0nUf9l+3Y/6eIAkGqoDCs ZJuBO7w9HmW3n/4fFeHEHak9kFOhYr8U1KT7GIRAiFisv8Od7/izFBdgJ+2wOlw6HTKiV0J0 IgY9EKmNBAxcnVEw0JVCoVTyXxgxh1J0+hDrfdYvy8tfmYrN2niLaBS81ItHiKjgd0CfrC/9 zFopcg2DcyBFjTfMOmMzBnwzXJZLMq8o2IHXFlF1wjFQUYy8iz9D4HFBLWyfTzLkcaSFjp7j Yq2wRITMhAXnXDaMqVAdWybRdhSmT871ug0RMrl9lpUxtpfAchu6teNwtZ0w3UOPphkSm+n/ ptig9M1cSkZGoFWJTjFxbKfhO3VgTcnI3SMTkwpBXE675AGgyF2NZJRNeZWBD5pXMsJe2vLu yBY/UfQIdmdmI9/uUS16vmtZBfzXQFreGJZvQ5Dsk7QHTqQG56J2UEHB2fqMvmotZZGCp15b wQUOHnMxNkbIuMNw+aIi+v9/IzKZClZE11lt1ZBnRVWT5IJAAcgG4VYy/pkBCTn1obOishax VliZYJc7KE0vNUNTs2i5oK1g72rX7+H16ZkNuB22RAogLf1RAsskhmpRlF2gswIciQw8eSmT qzAjuOzIPufdI6rTtJ2dl+YfaZBQUR0h8vZoAiv+Zpnt4G9Qn6EGm518WXt/hJFlbGJxxrWs IojeovJr3ne6ehUdtcByocpHm/50xHOZOgGGsPzA1c702V7kE2qswLt9cKkdDY+u6JgeL5Df kHA/fnQYLkL3zrWHc4CEcyUfnGJO/mE4MlaatpPnkZCWqusnofdBtmEraI79Mk9hbechYaq3 DBFHXRNeV8G7DotzkU5SFg2uKcBt+yPqu+x5QQZbxUggCDd069xXnAq2Iohe5i/Yf3btVdbl OevA/JNbAEcdnYnbvl5QgNvM36KtjrTa3osK/iPeuStuB8x658rMuP0kz80FnWweAhwNpRYc AHKz7xwWb6EHAodcxykpd119bE0Gbgb2P1D5birq5RcNOn/voYgTHHFYf8XrLL3i8xr4QxiD WK225OdpxUDyQulfnWyB4vTEPFmDnkgMNDUmRGuEhUbYeo7EI+27fcHLu5VDg5WY7DdogRPx Ik7bO5Mpv0O1Df8Q4qgdjT7dBTfN5c03CZ9KVHRwSZdZZ6Ya+F/0wKs4zJ48OJWGxenPlOR/ Xlrj+JLqeSk+2e/4fK+p9JFZzdnQQ5bin0AlbcrPp/6q29oQ7dQGdjS8mfSMc3JUgey+Y6Tk 2s6w/I8caUxrj9Nyl1RF1wzkXTLt7on2IQA6SkV4UNKOnwWvJrshVUMrZKNZFF+yfRJsM49U YoxHBhR6rYzpKPGwqS8/w3OJ+i4UCAr4l/8gwXtMPCrKOi2ObEektRSxM9tVN7pOoiHkGNyi /bCyExU1DCktjVP+ofnvGBvuggTKSjAcdq/3jq4PQLPTD5R5/52L4ybRRebS8y0WM2voOMzV 8EtXlzf4zz9V87Wh0PznB2guoM8OUjWNe1EydxEXa91h0osPcWjGi4B5jTvg7qHiajPqPrRJ RKXg2YHHbshunYv47AXhbDeVs+aa4mCxjr6IjVrRKd2wummxDc9qLjktkkLSYhjSJ5JjuNig AYdlGTEJmM+8dADnsf9LXitJLGgl4DJNWqJ3SLkToJMiij/jvbBPdvqCigWl4sKjsTj4SiMf MHUzbon2jnDfmYcLqOEEwmNj7VoFx0faJkbvOtrgYZStrFfbq02jGvIM9ZjWZYDJ30jU9kOY 5zNISrN+f63v9+5MiuW3O5BHqqTVS9n9/AdD0alMO0HNht8DWIE5P4UhFuG33HHLbyNIHWgZ 2iK8Lc3ehrY8OXtV4TXd5MG+6ViZet3EtFs5bvCRSTy1uVct0uIyve0y8X2wSgEmnuYh5L5w NDcR/5OsdF9J3MqNubY7sue+3VDPuissy1nB+L4C1623h0jlsXVA1Sof3+cgoTAut/PjY/Lj CYfr70kcIyC4I6o/AmKidhP2JbEBp+HA2hybAG465NtsvV6d6fr5L4JY24f4/9ygJPh392cz w9T1DXPeZfYp9UgoFS9BUozrMmNYXoEOkBV81nvn2r3A/g28YNh9cXHvufmL571HQM/q/4NJ IzjzNZ8CvXuebnskY3vaMNf3vqHlziQcrd3MjciL5lXNl3UN+nooMxGNFY5ST81P7+5a7O+X otSc8YhhEQD9TH6CnQR6mqR6Mj2ewwYf7oHZuQgfxzFo+LbdSd01OgaBVAlX5SFevnn4nnod bG0VaDZQzVBOvtlFktSKA47I1GF0YVXVF9JMRI7KPdvW/3LByY7F7l1LMNGR43TI7K6LRN6P 4Yyacbe6Iy7/dll9cc/rjOB0ZkbDKYpi7HOJAvfbMI8WLh2mlA7uhyHYZqtn6WPrfDnkerbw eO1QzwIyIa+aeZg6e5wveoADLHvG+6acrbLiRQDdGCfDqbJr0InerGsP4vTuyIFjxOPf74gr 6JBFXHBY4EWQz6CxcI+xI52fEQy1DOdvQf+hCciGBt5NjEZb/fEP5dHDXyKjAhRq0KWb13ht 3VHRE4Jmbdfonj8o1SsFyQn2jpl7l5ltqkKDF6P7Gc2rklgjw8JZ4TCfl6j4tcQMHqup+RLF 8SZE1k4W8xS5V6yr+g5DyHE2LY5+n6xC6Bcm2eEB2U/qD13ruzOASjXZxdFCKL0c931IE6gB J1YQLwLFWoOKY2YQblhb1PSPHGmd7GZJAaefDBSyEWP3pS1gnmnqkF5yaiR1KkkuOEXJkxMk QxClsn+/dpMdWOhbQk53deVl3U0nuMEEzGwgCGOrcylbKsRTC2H0q009qcw/2r8Si8/a81C2 iHbyfwWa1oJ7oBYPSnOBdssX49QQ5Q4Shzk68rBuXpPc5CuBfukqz8qFWDkg0SQBYspOcdor FuWqAsfagGVRX0cOb2HZjvxrdzeNgewjGFdzFRBoQvbTDBhtlfFTD8osxxVwxeiR/69p9b7f P6m22szCKOFT1f5BNbGCSjgcEJmneDc4YnmSwEEffNH3EaMG6dz3zSfHJgvnkFUoDy/b2NPg DR4hOuqg9lkn4DhCL8K1ILIycykTIfocXCgR66tkQHZUKApxG1UQAaP0IkRUqZ5RDz/9abYi whKm0F/KW9pSMiMHYddu/G62kLJkHs3Umn8aZ+x9MNdfmXhJehAf7JYF/Giq236rLuDYtcoI E9JzpZ04aJafJNomyrEvLwC7/BEbPpCUWMq6aqjwHA1mcwTqZUs9IOfKmOTPyWxji7GNIepq g2eR1amHz5QLGg4D1CYsxEYBd63Q85QFo6K2qVzwyJCdXfL4UbRTcs0lfs62IovBY4BAd/T2 cy+zTofKsb5IhIut3XzW6wAfEFCSB4vWY04QflmDBomsSDIOzZCOFGo9vbKcSEctEpgEt6CV BKD87T8LTvpF9YtHshp/p9kt+5X2x2wxpHI03sSUk4wMvHFA692Kz7C8xfj3zQ+SLut01wcI Eb9BlGuDAubIJFFl1M1yagIzZzDgOrVp/oJED2nf9LQWzNv9UcovnmRZtLEVpPhkgYTJZNa6 BeCiKrnRkxQ/scKoX1kN2sVZM69FPc9eptH/KUlrQgs6+IqLs34JinW48ESYfCM0IFT/zbd3 /Msx6blqBvxs7cwX3dVE5bz+6v1wybmYHN7PEazLUXu8e6IQEhhblalfJkywb99he2/AMbnd dKWP4XCczDQnnjfr79xj6WpIZRV0Kk9O2mxlU+/Rpz1bouh01sIkhnY1snBr3xRnHLLJZEPS gz4TWKs1Bn2+xem/7BXO6kV9XUKm0nwoDKANK2oHnEmRlcSmPxOuAsBDsTXt63tTYVE6f8/9 DCjeBT9dpu6GZ/uByDnmRq7a+UXTXlaObGmUnJlS+7g/SopaYAMaSh6DgopOgeOQdAWlOYVG 51lTHmRQMs8S4R804RjjmNO7dFwvsCHqEe+0IIiroccZMaLtEsbbEP6djx57nzXbeUFowBna PYA4nhNcnQDD4qtpN0UZieBW9fDO/+WOzpsw0QgHHA29lvBKVzfa2uxgtpVYdxqly7VW+yJK cb+DtCBBDqkibhSpY/wVmWZkDjFfSpliwyYB4yLhX+ZXbnP9cAs9Q4GP+wK8e7BFg5UXRSpk wv21rf9GSRi+4kqXDltxBqT7SsAHnNcNiJlvOSwAp8bqUHkERa7dggoiMC5z4ggUPtahkosl nVBRJ7c9x2+1Y3Vejj+rHZ4IHjOAl6gFJpDlaURS6bonAOYHTYhNJJSrJCaF+5QjQus/nbxz F7r69W41O7eccVj/yaLfxP01eZEw1mct5BtU4Z69FsaMktR0/lSu0TDrrdd4mIembotj2EFe PzEWEdgEkQrqqyeD0yHKGJ3u7HEHCe3J0UeGVgevcMBork8JMHoyBRyyPMWfR37lESky+u1C SfX/HN5cRnoR24AL2fOhxrG2nrUOFuZl+rjYLF5n0vA3Z4lPhBkVJ3O7l5NFZ22LoirqG5Tx Tcy9HCGfBLgmzEIb54XXcxzaojLjYp1yntCsY5U4q7Am6h9/HKzjmkCRcv8ncGOotwD6K/Qt urxQ6Uw7mq8eBiTZtgnrIJ7c1vwTGXorHXWZw3VqhJ8pt8d6hruKhpjf+fNZU2U4m2DEmYmd Sxnu1MgDHUySy44VkN7ye4Rzd2gHZ13pVSOYGSZRS4sbfIiZJVJIXgHS6HBNjXwOWl0GwKJg tfdiBgx1fDLE68dmOJ4Oh6IQy9PqTFdFXgfQLvzGW4jH8E/CKx/q/zuzfOOzfwbUZhheDQF3 y7dC3nZpDEnG/jwXcFginoPDr9XfwDvv5uG13lkdexvdOzD9l61xz4jec0etk8citkU4mkNB bRXQ5SSUxWyuNjOSmlkEeGSZd/OoEfhhlyJIsHKbgfID5daPNgcojYkoGlK08+ED72x4sMOZ A4znUSEOviQ1ygB08Z9nY77tEFIL+focdVSK4AQvw7DWiCeDNdw8My9Q3EiAsVuuzSaA3XF8 9cimiNLrWceBtnnwlnogkno+EohvS4W7d9NzaCqGruwz/61e2q1P/wsSrAWHNVkM6QgkTV1r hPg0LxjnSe0+nXPZToz9lb4v+jyheK7Q31NYoaD/bYV0NfPWWmY8nUMHK3bu+ftFdSXuN68f 8zORh803aGeVqLmF5uYwvTrGI5UHVO668x6JKXWK7MQEicPbrljuHw6B6T2SbOsGRTRFddvs QMJISYcYktL6gxiZU37Iu0p087BLAS6rX4Jo/QoNoE/0zSxtNYTdpRHcev51fTvKg2QlUEbr qZwNBaJDSHC9gBurdNxExYKNDwNfDE/M646cY72DkpYygoSkrAQ5LsLtPyKKRJ4EqLSz0WeX UcMeiads24yZDjkTp4qtyNa/CJOGEUPtbW/LzFiKjcu1bvUVJPi9Pyy4a3r7h5Klr+E5QcoV fSLq7+f8fFGD/mNnjeIKEe5JDUkfe+yxdjFYcVBCDZVG145PIBiKbXcyo/qSkGirgT+N4A0C rLUoyxjMV/Up4YHGLp/Ihx8L3rxaBz+qMCqCJdTw5sXOYj1blSoy9w9Vrlan+apTu+dEfNkT yarzjTPFjTc4ibXU/oiO+AjoOy2UahiADQjvfBEK9eFzSOb9Fgw04g2nNZij3H3HdznOkozT t/+ZATkWu6ArASq/tVCzv5h2FDb7y0FnV272ST0iPkxnb4ibpNalEnN+OXhR0OoPV+IWBQaS RecS5u+aWInP3FWrlm6QL9PIQO0PJx0V8yLZUcEXIITa6C0pV+4sSQhwB2orpgcy4VbVyYsE YZ15P56URdwJllTaY7KoPGfuRWIN1rqysMD7Zb8vKBFoBkU3XVNw5RuenUWCjk6L3wP4RurV j3fXF+hnWFBUPlEQ7gybieMnroNR2WD2LH9WraHv5BgeGW32Z/+54n+BIfus2Wbl9xP4qqjz DkN/grbxCBswU1t6z3g1pGOB2Adr525LYvhI79WLjd9sebNi0lt+qTxdafYa6ZbR+OcmAPlX GRumNlxXISiXw81hZLmavVb918Z2uJGPleUS5CZAtl5e9wCFrrvSJpFtxzhHfhK9ow06gqRu LJVoh5QyIi4MAfy2w4S5yqwLwmN3NjJSQGp4WBB28S+yHJQ7B+dM7jyNlQXcGh6fgKIU2Zr1 F5qegY26wvRsY/nXdJbLQbQGbPzhNbfMvo+W6jfXcdnwkF4dXOqG7tt4bhOvdJj02sTuX990 1jrHslxHGbShKePsw2t6c2VXeHkwIoihOWmuXwLo07k176dVExRDSOhXKqwyzSUyYOq9kJW2 NKa0F+MJZZ4/HraS6bI1tluEgzi/7gCqbvYj1xpHnpahP3tEO3w+lRdTeBRtHb8E0nDs62dU /HRfiqMY3AtHq034OREnvUxbXZyoS+f1LNAbb/DguQ5Wr0iopfLH8CcUSgR7jyKZ7keuaIeI 5O56fPRmhjuv6MaiFheELxg4swQd71/cB/fI+FNh2Tzh71nSCIkzLsOj+StWE9dQ+uNCvndq OA2H5jEbtuxPQD1+UcETJPI1Db5f+5QyO9bB1LgdtUT9bj1IbW+EVP1vdbSB7ZG+kFbQem2M PCXIkdct17jnC0ec9BcFrw0G1qvzyUQ7MTBmudvJY6lABx7E2c7s4SJr1OshMTMtirGIWId2 Yie6FyYQv7sBDsxfBFGBxw4Dg0E4mx1j8z/NeWAKYMFv4HdOvEcDzNzCQu3jRx8Ms5l5Q+xg ay03HZlcVCnGjzMSFyMJ+a2jPdgTI45n7G1jLiJs9w65BmtS/hkBoRgkoHdhyG8RUbeYtMr2 +pexA5L9zvV9RM4+U5oLxEtgeiPiahu+zL0/r3f7pAUgkANRBeqPsmClLd/NyCMmeAfA2A0z nLJSQ880H3fiKv039uFaqCdB5m2LWmetX+ImWj1K93aE5rlz4xApBFAbwcfM0Gf1OZNb3nCI fz/Lr1Jfo/vAv3Pbqals28Cyp07FuN9gbT0pQGYmW/hY9G0jbnKwP3BztrcRDQKqrh69hXvb o16ER2r9w1d7rvUiT9TFobaPuvFc62Tbk7DY3GdawnNnxQveDILLyrjUQHZLn6Hm5beNWmaL v5zYrwgzE3SqLIDWg8sGTkz+YPr8Vy/H0Jf31nKtRLJJZltQ/X5SSMoJlFKBiDE0EyOdL3ah eVl3R/U15PKgLiA7VrJ3XVq0PCXTxQJD817TmyqZ7FTUBucgqb14LjtWfQHb1Azgc/vD3zhl MFAY1M/38Qut+9ygEugXaTwHwrOqi86MSKPjHTHenn+bbZHspAxhSaaSdCODu2slKGVnHYhE v7qLI1HugveFICeXaWOuHBHUsbErFiMyVwTGlsXNsnbX97T5sHHh82qL5TynEREu3xJMWTXa czMXZqLwHjCfCMC7BRipm+oPSiciEatlDs3RjcV8n1DAsP4pZUcKsP4naToA/Qe2qYsEsCTW /rzBQ4s+f+mku1Qv+X5CvPWnePxs2XBy3ozFYNvU9Rd+MK6TvL8/caUI6k0kriv71WiXUE0r xlsee65Nb1DaB7h3NQ8cmZlBS8T6YCTQ3aDN3GPJgi2C1QRlOISRhc62ugpCC5MXiX+OD+KN YDd6P6cQmWUQeHa5IVRM1LIoyt0CdDKbxAkHGAyh0a1F2gSqPVYgqwBw4c70/PFcr6ChMP/w rGMYSbYqHopNKgMLjaU656u7dEnZ/9KIqOswZO7z9oWaD1zFcBwhPNLkxiK9U/dVVtf3Kvke XDIEzg0Odq2tMeS3OTNm8Yu/GsQvUstMX9IRJxeQ5JDGcm809HyVTqz7Ls8JKWiCHpuzgaSo x+9dr8jEqw2WoLc4eQSVwzIthlcII3tGREN/VfVbRfz4DvFGc+oTYlhhlZFuUQ5SE5VYozqR uvPakAUN1C4c/c/Z7P8jpXLzf4bFe47UJA/TsfXS5sZ4Gvf4Zml6YZ4t50/3BM5/0mQpmtS/ gSckU2Atp43sGxgQK1J30yAmTDT92AHoprRGRDNck1f9Do/WgFuG4ybD/+bJ9Eqcnr9ssTkV rIByiyg8YkD5KkxXXS9vFw59+tKLqzuuXAvzWPTFg01KztYdHyaFkL9f4tpvNdMrl/tF+a5P 8E5SDy8A99g7C+UMaF3xBfGbcBtBGNqFup6B/R5rqmvqJiwS2GO8iBdziSJBJ/DDXJVDm78V NPxx8fMt5BeNxZfd02ndyS+hRqswjQuUorQ1CHPqiIzu+ipw1m/JEOKn2sIMLveGq3FA6dJJ 40fJuDqP9E5bcxWgk0zFOm2eGcanxGaqc+RYbjC1QG4bmInrT9Dqy80cvZjYBdNPH3W29tHg U6BjlebYdQFXQDE6nm95roGjtQLiBrmfihQOcZh4ny4DyqxG3VvjXDbP76R7RdnS8kNpwZ5X Zk17WVInRnCWcZqP4I1sA/FnwCpwqbzf5mfINlZtN5lwOYu36fKMn+kmZ0fvkjb9gBywhr2V Wj+wPi8wHhbDUEJYQNhQEOUBEOs7Ljm+pOjNDk3Z8aM0ikXK556KFEiduxHKkUgdspZ7Qyxo kJf7RYXS8xdi1EKgW6X3GG6k0D7t2zkYEZekC9HNBxzyGqQEehLHCWigyvbKVNJ0GXykQb5z 4XpOOqKbhjOm5DLXjek8PI/oQ5jirSOjXjd3jTwRjO3UzEcl760rBcQY3JwxgwDRZROqjP2z DiZuN0C2r6iQBrd95eexuhDLNcAjG98jArkkb4YldfYDN8IAYfLMf0zl0/2I8Z0Cen9zKDo1 sRu212Do96ylbtwDvOu364LTvxhf+lLMGl7xaQYQoFXtGy6Btj+UAddjKmVZ3b0cLN3fvaew aopLil9kw2FZIEE6uTXkY0V0GcTTDjx9q91x1E/80EvTlSyPtV8VeawuebqPezHjlY3fiUiJ lvIt3JNYMU9G/bpBrjOv4ys45SVL5GM8JF1uDU6yOIxO899NSchcEcxEBFjHkBmYkkoflaaU zssg1W3nY7/4RG5ZW/cVO9YDt/nFiEvjR9EIyBvHVrpdPaSzHkbTsoAyjqfvFaPt2cqUSm2c KuDOOBBWWgqr9uNazNhp/6LBFp0nLaKgfgEwS+tCdTXlQhsefIPON17IJZCnz0+8Weol7czY M41a0bIWOKUhVEFkan1wUc/s/PMi/JdhPkn4UNLQsYACtk/doaH7DE9kkMIIZR6aHtoLSvTx 4620JKPBDTuJS86BZiZTC0RihZ4U6g3lOyRI7QvhcXHTQY2AeGhPS/YQCU4xzjgWq8ljSVNk Z3+1dYnFsRQRFNy2QrOiAcXoiuWRH3O9DqZgGOsvyTwScmJwfTyJVOW2nRUTTJJ+tg3jkl8l sNPuVgaa3TTcE1jV19QxCnZmCTM5UAgCEdaEHs/m34HP1xDShRUHvKwn6G6JLcMeyC4Pc/fC 6yhW33Fjhb0wO5uMVsKHcdwD9lIWH6hhO5qkZ8HsqqZ/Ox0wkLgabptXp+ztI1nF+PopsKX5 SNhnw7veRNO9lGFoU92YnD3Nfyase983Z1kU3PSbpci4n3lFWSwCQ1WV1zEjfAhIpRwMkPLF 5rFXqGsiEYUaOVnMQM6EhTZGCkovff7qJ3b6zFUeWdgBX2Y80jugx5AVa/Axy/dqYemEU4fI 8XmwEoST7EzENg7M5wJtTydWQVLC7fiIh47gNatFHrwTAUoa8QAk4rMNoWQDj28PRJJMpAs2 Zey0oVt4KVHExlUrz5OTaKGRhDz4b8zki5Zoa89nKks7xtWxdg9t5pZqm/PwHUJB2uY3U7xT fUqWGklvdsEFumGwtLi+JLcg9Jt8p4VCyZEy7H5NqZwJ7TGqlsoAQ3P4pk+QmwVJxXtZntYn UEsDBAoAAQAIAMA5wTDRD+pkFwAAAAYAAAALAAAAZ3picG1lai52aWSQsX0Y70kxTLdNGPAS b33W6P5BHSxd6FBLAQIUAAoAAQAIAMA5wTA89Wfy11QAAEdRAAANAAAAAAAAAAEAIAAAAAAA AABucXJtdm1xam4uZXhlUEsBAhQACgABAAgAwDnBMNEP6mQXAAAABgAAAAsAAAAAAAAAAQAg AAAAAlUAAGd6YnBtZWoudmlkUEsFBgAAAAACAAIAdAAAAEJVAAAAAA== ----------txmlfhpmjshzijgmgccb-- From m.cave-ayland@webbased.co.uk Tue Jun 1 13:37:49 2004 From: m.cave-ayland@webbased.co.uk (Mark Cave-Ayland) Date: Tue, 1 Jun 2004 13:37:49 +0100 Subject: [Mapserver-users] bug postgis query alias In-Reply-To: <8F4A22E017460A458DB7BBAB65CA6AE5219367@openmanage> Message-ID: <8F4A22E017460A458DB7BBAB65CA6AE50265E1@openmanage> Hi Vladimir, I think I know what this might be. We had a similar problem caused by the fact that the Mapserver lexer has a very limited set of characters it will let through - the symptom being that Mapserver would truncate my DATA clause at the offending characters (in our case it was a colon) whenever I used a casting such as '::bigint' in the DATA string. The patch we are currently running against 3.6.5 is the following: --- mapserver-3.6.5.vanilla/maplexer.l Wed Sep 18 16:14:17 2002 +++ mapserver-3.6.5/maplexer.l Fri May 9 16:30:45 2003 @@ -348,7 +348,7 @@ [a-z/\.][a-z0-9/\._\-\=]* { return(MS_STRING); } [a-z/\.][a-z0-9/\.\-\=]* { return(MS_STRING); } -[a-z/\.][a-z0-9/\. \-\=]* { return(MS_STRING); } +[a-z/\.][a-z0-9/\. \-\=:'<>]* { return(MS_STRING); } \n { msyylineno++; } This allow us to use the :'<> characers in a Mapserver DATA clause. If you also include a \+ in the second regex to allow a + in the data string then hopefully your query will work. I don't know whether this has already been resolved in version 4. I didn't submit this as a patch as I wasn't sure what effect it would have on the other fields used by Mapserver since VALUE_STRING is not just used for the DATA clause - one of the other developers should be able to comment on this. Hope this helps, Mark. --- Mark Cave-Ayland Webbased Ltd. Tamar Science Park Derriford Plymouth PL6 8BX England Tel: +44 (0)1752 764445 Fax: +44 (0)1752 764446 This email and any attachments are confidential to the intended recipient and may also be privileged. If you are not the intended recipient please delete it from your system and notify the sender. You should not copy it or use it for any purpose nor disclose or distribute its contents to any other person. > -----Original Message----- > From: mapserver-users-admin@lists.gis.umn.edu > [mailto:mapserver-users-admin@lists.gis.umn.edu] On Behalf Of > Vladimir Guzmán > Sent: 01 June 2004 13:04 > To: mapserver-users@lists.gis.umn.edu > Subject: Re: [Mapserver-users] bug postgis query alias > > > Yes, the query runs fine in the pgsql monitor: > gps=> select gid,'>' as sentido,tiempo,360-rumbo+90 as > rumbo,velocidad,gps_geom,oid from gps_vehi where > tiempo>='2004-05-31 05:00:00' and tiempo<='2004-06-02 04:59:59'; > gid | sentido | tiempo | rumbo | velocidad | > gps_geom | oid > -------+---------+---------------------+-------+-----------+-- -------------------------------+--------- > 46275 | > | 2004-05-31 15:16:09 | 450 | 0 | > SRID=1;POINT(-74.06318 4.67302) | 7731018 > 46276 | > | 2004-05-31 15:16:15 | 450 | 0 | > SRID=1;POINT(-74.06318 4.67302) | 7731019 > 46277 | > | 2004-05-31 15:16:21 | 450 | 0 | > SRID=1;POINT(-74.06319 4.67301) | 7731020 > ... > ... > > The error is just: > > *Warning*: MapServer Error in msDrawMap(): Failed to draw > layer named > 'puntosgps'. > in */usr/local/apache/htdocs/gps/index.phtml* on line *33* > > > Vladimir Ilich Guzmán R. > ------------------------ > http://maintask.com > > > > strk wrote: > > >On Mon, May 31, 2004 at 03:29:45PM -0500, Vladimir Guzmán wrote: > > > > > >>Hello. > >>I'm implementing a gps tracking system. > >>I want to show the car's orientation like this: > >>http://maintask.com/test.png The layer's data is something > like this: > >>----------------------------- > >>gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as > >>rumbo,velocidad,gps_geom,oid from gps_vehi where > tiempo>='2004-05-29 > >>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using > unique gid > >>using srid=1 > >>----------------------------- > >>The field 'sentido' contains '>'. > >> > >>The problem is that if I use something like this: > >>----------------------------- > >>gps_geom from (select gid,'>' as sentido,tiempo,360-rumbo+90 as > >>rumbo,velocidad,gps_geom,oid from gps_vehi where > tiempo>='2004-05-29 > >>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using > unique gid > >>using srid=1 > >>----------------------------- > >>The query doesn't work. > >> > >>So I had to create a column in potgres called 'sentido' and all the > >>rows > >>containing '>'. > >> > >>Is this a bug? > >> > >> > > > >What's the error message ? > >Can you run the query from the pgsql monitor ? > >--strk; > > > > > > > >>The rest of the layer: > >> > >>LAYER > >> NAME "puntosgps" > >> CONNECTIONTYPE postgis > >> CONNECTION "user=gps password=gps dbname=gps host=localhost" DATA > >>"gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as > >>rumbo,velocidad,gps_geom,oid from gps_vehi where > tiempo>='2004-05-29 > >>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using > unique gid > >>using srid=1" TYPE POINT > >>PROJECTION > >> "proj=latlong" > >> "datum=WGS84" > >>END > >> LABELANGLEITEM 'rumbo' > >> LABELITEM 'sentido' > >> CLASS > >> NAME 'Parado' > >> EXPRESSION ([velocidad] = 0) > >> SIZE 14 > >> SYMBOL 'circle' > >> COLOR 0 0 215 > >> OUTLINECOLOR 204 204 204 > >> END > >> CLASS > >> NAME '0-10' > >> EXPRESSION ([velocidad] > 0 AND[velocidad] <= 10) > >> SIZE 14 > >> SYMBOL 'circle' > >> COLOR 255 255 204 > >> OUTLINECOLOR 204 204 204 > >> LABEL > >> TYPE TRUETYPE > >> FORCE TRUE > >> FONT arial > >> ANTIALIAS TRUE > >> COLOR 0 0 0 > >> OUTLINECOLOR 255 255 255 > >> SIZE 8 > >> END > >> END > >>... > >>... > >> > >>Thanks a lot. > >> > >>-- > >>Vladimir Ilich Guzmán R. > >>------------------------ > >>http://maintask.com > >> > >> > >>_______________________________________________ > >>Mapserver-users mailing list Mapserver-users@lists.gis.umn.edu > >>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users > >> > >> > >_______________________________________________ > >Mapserver-users mailing list > >Mapserver-users@lists.gis.umn.edu > >http://lists.gis.umn.edu/mailman/listinfo/mapserver-users > > > > > > > > > > > _______________________________________________ > Mapserver-users mailing list > Mapserver-users@lists.gis.umn.edu > http://lists.gis.umn.edu/mailman/listinfo/maps> erver-users > From ikeivy2000@hotmail.com Tue Jun 1 13:40:13 2004 From: ikeivy2000@hotmail.com (ikeivy2000@hotmail.com) Date: Tue, 1 Jun 2004 08:40:13 -0400 Subject: [Mapserver-users] Failed (mapserver-users@lists.gis.umn.edu) Message-ID: <200406011240.i51CeiFS021588@lists.gis.umn.edu> This is a multi-part message in MIME format. ------=_NextPart_000_0016----=_NextPart_000_0016 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit Mail Transaction Failed - This mail couldn't be converted ------------- failed message ------------- 9J,-oM!#2wUkkj1Tt46R-öY_XG..Ynö02hh8zA