No subject


Mon Mar 16 11:32:08 PDT 2009


> Never worked with osm data, but since I created the .prj generator in
> pgsql2shp, I can tell you it reads the srid of the geometry and looks up =
the

> srtext in spatial ref and outputs that to the .prj file.

> I suspect osm data is in Mercator not long lat.  If you want your output =
to
> be in long lat, you need to transform and use an sql statement

> pgsql2shp -f "/path/to/filename" -h myserver -u apguser -P apgpassword
> mygisdb=20
> =09"SELECT field1 AS hs_num, field2...., ST_Transform(the_geom,4326) As
> the_geom FROM planet_osm_line"

I tried what u said as follows:
______________________________________________
pgsql2shp -f ../data/myfile gis "SELECT *, ST_Transform(way,4326) As the_ge=
om FROM planet_osm_line"

Output:

Preparing table for user query... Failed: ERROR:  AddToPROJ4SRSCache: Canno=
t find SRID (4326) in spatial_ref_sys

______________________________________________

Then With reference to this http://postgis.refractions.net/pipermail/postgi=
s-users/2008-February/018486.html web=20
page I executed the following in the postgres database

______________________________________________
gis=3D# SELECT UpdateGeometrySRID ('public', 'planet_osm_polygon','way', 42=
36);

Output:

ERROR:  constraint "enforce_srid_way" of relation "planet_osm_polygon" does=
 not exist
CONTEXT:  SQL statement "ALTER TABLE public.planet_osm_polygon DROP constra=
int enforce_srid_way"
PL/pgSQL function "updategeometrysrid" line 53 at EXECUTE statement
SQL statement "SELECT UpdateGeometrySRID('', $1 , $2 , $3 , $4 )"
PL/pgSQL function "updategeometrysrid" line 4 at SQL statement
______________________________________________

I don't know what to do now, please guide !

--=20
Regards,
Anisha Kaul


-------------------------------------
Hi-Tech Gears Limited, Gurgaon, India


--Boundary-01=_hWsSLSUYcXYblQn
content-type: text/html; charset=iso-8859-1
content-transfer-encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<html><head><meta name="qrichtext" content="1" /><style type="text/css">
p, li { white-space: pre-wrap; }
</style></head><body style=" font-family:'Utopia'; font-size:13pt; font-weight:400; font-style:normal;">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Hi,</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Many thanks to all of you for bothering to reply !!</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">From <span style=" font-style:italic;">Chris Hermansen </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">&gt; <span style=" font-family:'Courier New,courier';">Anisha, why are you converting to shape file?</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">I failed to load the map directly from the database !</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">So I thought it will be a boostup for me if I manage to load the map from a shape file, and then I can go for the database reading !</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">I didn't have any problem in loading a world map from a shape file directly downloaded from the internet, but I am facing problems when I convert the postgres data in a shape file and then try to load it.</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">From Regina</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">&gt; Never worked with osm data, but since I created the .prj generator in</span></p>
<pre style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">&gt; </span><span style=" font-family:'Courier New,courier';">pgsql2shp, I can tell you it reads the srid of the geometry and looks up the</span></pre>
<pre style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></pre>
<pre style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">&gt; </span><span style=" font-family:'Courier New,courier';">srtext in spatial ref and outputs that to the .prj file.</span></pre>
<pre style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></pre>
<pre style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">&gt; </span><span style=" font-family:'Courier New,courier';">I suspect osm data is in Mercator not long lat.  If you want your output to</span></pre>
<pre style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">&gt; </span><span style=" font-family:'Courier New,courier';">be in long lat, you need to transform and use an sql statement</span></pre>
<pre style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></pre>
<pre style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">&gt; </span><span style=" font-family:'Courier New,courier';">pgsql2shp -f "/path/to/filename" -h myserver -u apguser -P apgpassword</span></pre>
<pre style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">&gt; </span><span style=" font-family:'Courier New,courier';">mygisdb </span></pre>
<pre style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">&gt; </span><span style=" font-family:'Courier New,courier';">	"SELECT field1 AS hs_num, field2...., ST_Transform(the_geom,4326) As</span></pre>
<pre style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">&gt; </span><span style=" font-family:'Courier New,courier';">the_geom FROM planet_osm_line"</span></pre>
<pre style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:12px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></pre>
<pre style=" margin-top:0px; margin-bottom:12px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">I tried what u said as follows:</span></pre>
<pre style=" margin-top:0px; margin-bottom:12px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">______________________________________________</span></pre>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">pgsql2shp -f ../data/myfile gis "SELECT *, ST_Transform(way,4326) As the_geom FROM planet_osm_line"</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">Output:</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">Preparing table for user query... Failed: ERROR:  AddToPROJ4SRSCache: Cannot find SRID (4326) in spatial_ref_sys</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">______________________________________________</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">Then With reference to this http://postgis.refractions.net/pipermail/postgis-users/2008-February/018486.html web page I executed the following in the postgres database</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">______________________________________________</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">gis=# SELECT UpdateGeometrySRID ('public', 'planet_osm_polygon','way', 4236);</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">Output:</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">ERROR:  constraint "enforce_srid_way" of relation "planet_osm_polygon" does not exist</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">CONTEXT:  SQL statement "ALTER TABLE public.planet_osm_polygon DROP constraint enforce_srid_way"</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">PL/pgSQL function "updategeometrysrid" line 53 at EXECUTE statement</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">SQL statement "SELECT UpdateGeometrySRID('', $1 , $2 , $3 , $4 )"</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">PL/pgSQL function "updategeometrysrid" line 4 at SQL statement</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">______________________________________________</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Courier New,courier';">I don't know what to do now, please guide !</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0; font-family:'Courier New,courier';"></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">-- </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Regards,</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Anisha Kaul</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"></p></body></html><html><body>

<table border=0 cellspacing=1 cellpadding=5 width="100%">
<tr><td bgcolor="#FFFFFF">
<table border=0 cellspacing=0 cellpadding=0 width="100%">
<tr><td colspan=3 bgcolor="#FFFFFF">
<p style="color:#000000;background-color:#FFFFFF;font-family:arial,helvetica,sans-serif;font-size:8pt;font-style:normal;text-align:left;""></p></td></tr></table>
<table border=0 cellspacing=0 cellpadding=0 width="100%">
<tr><td colspan=3>
<table border=0 cellspacing=0 cellpadding=0 width="100%">
<tr wrap>
<td bgcolor="#FFFFFF" align="left">
<p style=";bgcolor="#FFFFFF"> 
<img src="cid:company-logo.gif at 1262927843906">
</td><td bgcolor="#FFFFFF"><p style="color:#003333;background-color:#FFFFFF;font-family:arial,helvetica,sans-serif;font-size:8pt;font-style:normal;text-align:right;"">
Hi-Tech Gears Limited, Gurgaon, India<br>
</p><td></tr></table>
</td></tr></table></td></tr></table>
</td></tr></table></body></html>

--Boundary-01=_hWsSLSUYcXYblQn--
--NIMP_AF_12631913696871387
content-type: application/octet-stream; name="company-logo.gif"
content-transfer-encoding: base64
content-disposition: inline; filename="company-logo.gif"
content-id: <company-logo.gif at 1262927843906>

/9j/4AAQSkZJRgABAgAAZABkAAD/7AARRHVja3kAAQAEAAAAZAAA/+4ADkFkb2JlAGTAAAAAAf/b
AIQAAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQICAgICAgICAgIC
AwMDAwMDAwMDAwEBAQEBAQECAQECAgIBAgIDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMD
AwMDAwMDAwMDAwMDAwMDAwMD/8AAEQgAMQCAAwERAAIRAQMRAf/EALAAAAEDBQEBAAAAAAAAAAAA
AAAGBwgBBAUJCgMCAQEAAgMBAQEAAAAAAAAAAAAAAgMBBAUGBwgQAAAHAAEDAQMGCQcNAAAAAAEC
AwQFBgcIABESEyEUCUFRFZUXGDFhIjLT1RZnWHGBIzNztDiRsUJSstKzJCU1dbUmEQABAwMCBQIC
CAYDAQAAAAABAAIDEQQFIRIxQVETBmFxIjKBkbHhchQVB/DRQiMzU6HBUjT/2gAMAwEAAhEDEQA/
AOyK1Tuq6rsNszGiXQ2b1zPGEWtMzTRqDmXl5CURRVImTsdNZNAh1/EhSqJlKVITH8hMBQIr77CN
w/ictn1Wf9a9ER9hG4fxOWz6rP8ArXoiPsI3D+Jy2fVZ/wBa9ER9hG4fxOWz6rP+teiI+wjcP4nL
Z9Vn/WvRFQcI28AER5O2sAAO4iMWcAAA/CI/9V6IqfYXtvft95+0/Vpuw/jAfpXsIez5OshpIqOC
HQFx4BNpmkfL7I2mnmVc3xv7WuySsPOOKuZKURjJNFd22UZO1EJYSJrFXYrF7dx7imbt37dNpVbJ
Y5PkIKQkToVKnr2tmUH8SKkTF9QfKxatXjLbXX0kWWQ7g4iABtZVEDy7c5RKo1KcXCZwEpiAYBDq
fakpWhoo/mIO52tw7nROtKUbQoa2VajSPLizN7VdCTx61EFgZBwo/wD2Yj2stOFVdN3yjKOUZxbx
NYhHSiJ1yCIpAp4mAIbTWnNXNo75dapXhhm1icUw5QWkVCgUxkyxpzHKU/fwMYpZURKU/iPYR9g9
h+YesCjhuFKA06a9NU0BIJFRx1VDYdtJBED8o7MQQ7dwMw8e3fv2795YO3ft1B72MZ3HkBnXko9x
gFdwoPUJPvc6v8amK0jzKUj0i9+6j53Gs0w7d+4idxPplAPYP+TqxzXNIa4UcRUeo6j0R7446B7m
ioqKkcOvskG3fxzyxxlNafESozu3zjxONhKo2vdMcWSYkVv6mPioFK4HlJF6r/oopJHUN8gdRDmk
0BFVXHcW8xLYXse4cQCD9hTr0qwahmmw17KNAuYaNB3mHkJKvTq7UrSUjnsYk4UWQXABMoZup7oY
pinUVD8ohyGAfIOgcHAuBqAaH0PRXK8yj/EzyP8A7Ko/3Vv1lFLXoiO3f2dEUe3/ACw43Rj55Gvt
mo6LyPdLM3aRZFVYqTluoZJdEF0W6iCpk1CCURIYwdwH5uiJe0DX8w1QsibOrzX7h9EGblkyQzz1
1mXvRTGbHXQORJYqK/gYCn8RIJiiHfuHboicfoixU8JiwM4YpjFMENKiUxR7GKYGDgQMUQ9oGAfw
dYPBFrKiNvn814scKY5GtXewsrXxzzSesFkriEq5CMGu0Ohq+52WbbpOBYsrEMsqKhlTkUcEbql8
wL5j1tQ7C0g/NyXPv5p4mnttLo6GtOiyTrkevac00twvTHDw80lSqPH1ggeiMm0sY2xOd9492Ehk
2BIdmciogICUnsKICPfqYY4OBI0C0Ycg4QksjO7bonPrkbIqYrUphWiUCTz2STIxlcyjaxGso2uQ
Kz5WEY/RDNBAIg/0c9STBZukiidNITHRP5pAU1vdjqQeHVWiE9oXj/nPGvJRM2THsHr1e1rlPrmk
y+WQ2eTldenmFICtP7MSXp9XqFbzlaIs0kkNglbEq2ZRrGLSOcVE5EzsxTgRyf05WmLvs9kLbD4l
pfkL122AN4uJNKt9jqegqr33tvZWUl5O7+zG0k+wHAeui05Xnfb7zZqO2c4ZjjtyAPmNAev4SJn6
D8QbV+LMTO0qDnXqTYlbz2j06VYW6XiEHrdB+uKnrIulDIgqdQixEfv0OFsvD8rD4k+fGy5SWGj9
1n+ZkimI4bidrXA8K1ANK6Lwn5+PIyOyOy4ZbU3DiAfQJotDxTR0r5reXweeckKXoPH/AD6K3S+p
vfi7clL7T7Tm3vUY9ka7HugzmBlAnpCDWUTH3U6bhmqsmfyUMmJDdvF5eSWytvKI57KaDITPx9vC
7GW/bfLqwyloFS1h1cRQ9Fy8hLA25cHOmZJFF3nMJ17bRVziP/NOKlx8RbKahOX6MkIGKuVLgKpk
WQ3zTdQluUWz1ih//ZSsrHRWZlySgVCakrvqVzKzVIhKMzKvVQQIdUiTdv4Keb8Hnv7Pxy5uLZuM
uZbq+kbAx9s18wkj1fM2Z9GR2sRIL43EN26JnZbKfJ27O5LG0Rs3Cp4PqB9dDTrRaldEofHMk7x6
0rIs3m1HiXJ3C62rqz3VdAtUjXLa10WlzYwVjp2iZrTbRRbFZYB2jIQ7xN66ZvmJVhbKqHSWBP3+
PxWWmx+VtvMY8WzJtxs0sYitbcFze24h8boydKjiDVpp1CriNpYZe1bZvlcZJ2NNCaauHH0XcDp3
YOV2BiXuI/QNwH5TD393lPZ7R9od/k79fjbaGwO2akyAlfZQvrKP8TPI/wDsqj/dW/UkUteiIH2A
YfkAhxH8QAUREf5uiLSXWtJl4nHcyzvCout2LZ5OV0ixWmFSz2Dt0ilAM7JPqJPJuUlCqoRq4NEU
xQQFFVdYoJh5JkEhVCKZWEMXTHkvoH0pDsYOwP8AjviEpamDGNZRRE7Q6NIDOCqwYJkaN1/f0zFM
UnkUPEAAfZ0RTq6IsTP/APYZ3/wst/69x0RQ/wAkk0oX4c2aTS5hBCH4U0+WX7j2L6UZiMe+U8vx
CRAQH8Q9Tj/yN9wqLn/5pPwH7FEniHybxbcs5qOsRryDawU68iasgqo4QFstaG0WawCxA5TlL759
EyQKeP5wkMPs7D103NcGkkLzdvNEGbdwqRRTfv8Acavx34gaLosu6I3quVZHedJkXi4lEoMYRtM3
J0qJRAe4EMU3j84j2Dv1pxODZmucNwDq06hd6d/bxxfSpDeHX0XEny25xaF8T7KeJ9WyBrd5em65
yq5D19tTqxDLvpi6v8vg8PYJzsPXEQQdWGVrVUvU8ZggZUhO4rABQOoVQn3v9nsbjLDHZrzSWSPu
4uNrbZxPwxm4q1r/AGa7mvA5x13cuhtHtdGJSPg5keyeWRsnP8riV4yJ13ktjuTUvKyMarnSmKV+
Gh3OJITaJpGEPR0odGztKdIWJWNZzFncOpaQcqtvJy+aGcKlXzjMVZTZ6DyqbMWEs8t20vdvJ+Mm
hqTpWhpx4aBad5c3Udk/FNgk7bYiDQcG66/RxTuZfjXOrRLFGWKx3vXWd6u8YWyWS7Pop0lc7XhU
tJx8lK5NGKR9eVqU/mEyqi3atVfFrINWaiYLkSWP4jO2MeKu4sHPf2f6NhMm6Qu3Da18ji4trT5t
DT2Xkc4+RmPfc2FndzZee1MDWtaSdrxtrSvDmf5LKpY7zSl5GKtCmo8jXWvOdGeWh/Ta++VbTme0
Voi/JVK+jUbRWmJpGCoMnYJIkWfxRcN03BVWyq5xDw2MThcBa+NPyN1cwTYe3up2mMybRM2ZsRli
DhQgkAgkcKE8lL9avn+XPw8llM66Nvbhvw1NWmWpH4aivSqgXydgNzx/kBi+b6vf99sru7brxqtk
6OuwUnWGtiPTdPr8BUhYJSbx0raWFKbzEgkzdnMKrVZ64A/5agFJ67wWzxF3hs35RgWwW9mzF3ML
YmzGYta6I1FXaitB9VV1e7cw+QWsFzA5jzcx13DX5l3BaaHblhgXb8P0Dbx9v428mI/5+vyBH/ik
/EF9uTen02s4rovNrYrqMgWnZRnY6TbDRDMJCVLW6RVXVmnDRrAVUAfPyxkWqKKPmT1FOxfIO/fo
ia6mfGE4SaKXRFaPfpWfb54xQXTeFjImKjNDmH0iENDU3M5ewWOIi7Dcp+cN7kzZrKswVcEOAnIU
PICJlTfHn4aNTxKE/S+RtRczuN1/doxjZqDRWEu+zm7mtKNBkGECjqbmdlHt5dVNwgxRaNnHonVR
M9FqkcxykVpie1cNZbZFOFFRmuR2Eco7jcpIbhR7GhVIDY2DaIyVhurVOxWSryNsg4nPlKjMIGbD
Fujg6kzCguImIYQIkZjHxJ+FGe6hKRdSZcttP1PX5qNomerWuPpM7adqCI0OczdobMoqQ0CGnT1p
Cw1+QWVkZltFNW7Rl3UUTOogkuRSZzP4v/GfTb9hmeNqXvlMkuS03ZIXCJy+Z9AxlW0oaZM2OvW9
/EyULeZ91GMK7NVlVst9JIMl1DuEBRSVIY5yEVrxd+LxxW5w3iwZHh0RtK00Si3OwmnrPnTaLqKK
NbgKlJybCTlY6yzT2vSJmd+YizCSaM0JI5FytFVzIKABE8tZT9b4WUEl4nN6vABkmJUymMoPnx5K
QAIUoCYxzAPsAAEREfZ1Jpo4HoVCRu+NzOrSPrXIR8DSocitY+CDyPlsbpszYt944cxYnU8lpUgz
cMpS/pVLIs1SuNKhDSSLcrqSslKlJZvHpd/TWk/QS8g8+4bYuC5wDvlIoVyHYyNjXFo+IGo/50+x
YXmf8cneOWXE6c4OZJjG0suQ2sUicwXQ8ZZYu7WsLxSyECtPHyUk7dGv7ABhjrKjAkrrZcZdbsvJ
JMETpuNhkcAeHBwqtGO7uppDavY7aPTjzGvr96W8xxwX+EZTvgX1PZIL6Wvudt+Wez7DTICVgEH0
rpuuuKW6XzuInJV9H10snCKTUbAg9WdlZAs1OsKoI+I9fYP2yYbj9svJcW34r2ZlqGR/1PDZNzto
50Gp6BaHkcbzlrSWNpLGgVNNAapIvOUGeJ8gT8p6Zx802nPKLG2VU+Q3LllTLjJa4jfgk0HcMtKW
u0Stay3M60ReQe2CPj1nLNys2ZIxxSLCVyj0oJrwftw3xcfnLrKS3bWtifa7GwVNBIJP6tvGp0HF
ca4jum+RfqUm4Y5kRLtDQgCtPp6fWnuzj4nMUtoOhacvx0rFhp13zhPMqrRGnI6nwcbPR7dxCpqS
MLZSwfv+dL1GJjpBQYh7HD6b5JYSOB8w8qr/ABl0zw6LxZto8eSWmZe6SdzdLpsnd2OBPztbuAJ5
ArXihbJn3ZKRzjiZYCKNr8FRy9RyWOlPjEwVvrNly3HsNz6kWm05/BZ5T56R3uySl3YRlbGZSjV0
bpKsY9W3aGi2nXKsd72qxROdVUU1znTSKPby37ayeLXFhlMvKb7FtvjcysgoY2gRgneGmgBI2qi1
ycuWjuWYWA22QaHRNkmFHlp03NJ1PoVD3Q+Q96fF4r8ZdBCk2xrWOUGJ6RV77eHb9/yHp7qc1Onp
TOaQj811sKxsiMdb1UzS6ZH7tyUfd0UWzdv27Hjt3FmcnnvKsRbnH+JjD3MYt3DaHSGFwEgbz150
WHvkFxjrG7Bdfx3Ee6SnzUcK6ru10z/FfgI/IMFcCgPyCJW8kBg7/OURDv1+So9I3g8S4L7AkxTo
Cv3LkNyopFthYyy1a2VSLhLLXZtkhJQk9AS0e3ipmFl450RVq/jZSPeqILoqFMmqkoYpgEBHoikX
WsTyGl2mwXmn5rSatc7YzJH2i1QFaiYufsTBIzY6bKalWjVN3ItUxZpdiKmMAemX/VDsRNlPcKuI
NpcV93ZOMeFzi9VoquYV00nmVTdFiM3VaybIKE1SUjBRCoINJp4RGPMUzVAHSopkIKhhEiU+d8X+
OmSFhQzDEcyoRq5MPbDALVenwsU5hp6SrCdJkJqNdN2oOGsq+pqJIpVwUwKnjyg3E3pABQIkrDcJ
eH1d0IuswPGPDYbTSWNe4IXyLzWqsbQ0tjp+rKvLIwlW8amuwm3squo6WcI+mos5UMqcTHMJhIk9
JfD54MTEhbJaT4i8eXkneXSr62P1crqXvU0+cTqVncPV1ixpTovXFkRK/UVRFNQ7sPVMInEREid2
k4tkuF51PUnF84pmU00zWZljVWgV6MqteNKqwiMerJGi4hs1aGeqsItsiZQS+QpoEAfYUOxEieJE
hGNeJPFZB+/YNDPOPGKt0E3jts3F0qfOK4T0ECOFCeuoYfZ4lAwj83Uo2Plr2gXU40Fae9FguA0J
UjDHjYwEEjnZsveXBG7VETNWpnToU1TJtWqP9F7w4UTbGEqZQExgTHsHYB6w1rnV2gmgqfQdfZSD
S4acFG3j9mVzoDjTZXQmFbYPp67SM5CvKzNzk6x/ZtUqhG6j+St6Zp9pOumySakwUFQjzOw7t0yE
KYx8yOBYeJ05cT7evRaMFuY5nEDSuitrzlF6sm+VS5PmebS+SxkdEM5dtZmjt9ZItqhCakW0xrRk
9TXr7tCw2CaqzlJwcCmboxLoFCiYzc5boLwWtr24nysLzSmoqeXrX+PRWOtBJKJiNRr/ADSi1vEI
Kz5/Pxee0rMmFyWatnVYdydWjm0SV8g9ares9VhmrV4o2OzBQhexhTBQ5DGKYA7dYZfXkbt0dxMH
jnU6Kc0cckbmBnEEajRL6SzHPTtJL0aNnrR85RXQZvJCj1xVBJ2sQyMco4RPHoHekScnKPpeZTKf
mgIdwHo69uXCjpZ3O6guJCkYXsjDI2Rlp0pXl7cPdMRx+xV/RahKQ25V3F3k2/n4sYQYKCaLMnCC
OfU5pYljHsbMVzL2DQYqdlkWqIARqxdpJdhOkoYbJsheTgBlzcvlLRXcXa8qH09VrW0EzHOLmRNF
dKfcpFo51QGp010KJTGyyapF03CNTgW6qayY+SS6SqcaQ5FkjB5FOAgJRDuHWob2eECKaaVpdpta
TtNeR46K/sOc7dLHE4jWooSPVMHpRShyl499zD5BCXPt3EO4/wDKux+b29u/RXJnXWhSGSck9msa
1BuNsY2BGIi237PRqxipmatYt0dcXCyPoLJD4mL+QI9jF7D0ROP98H9x2sfVyP6PoiPvg/uO1j6u
R/R9ER98H9x2sfVyP6PoiPvg/uO1j6uR/R9EVfvgh8uHaz9XIf7gdEXk45dIOUF2y+Gawog5RVbr
JjHI9lEV0zJKkHsUB7HIYQ6wSWio4hZHFRr1RxiWu5pRslsPG3Xo6kZqmk3o8bAsY1uvW2Laiz+d
M2EU/ko6VdMkGVbsShUjpmKuVdBBT1BFIAHexWRnxFwL22p3Q4GjhUGhBoQCNDShryqtO5jEgLHB
20ilR/1omiRzHIE4SPg1qjzOkgirdZbhHzFguLK0z0e7tFYhao6ZREpZq3Lq1xGLj6+2PGu40rSV
jVAUBu7Ikssmp25fLcw+4Ny22shvFCA1rRSpPyg6jU1BNCOIVMGNtmsIEs9PUnpRJRfCsqVcRHi2
51qRyKx/2ljZTRXU0lb2YQjiHZMH6b6PFgwaMQX8gBFv2FLzQApEjj1efM8m1hpZ2O8fKdg01rr8
Wp9fpNSsDF2tR/dmp7lKGDyLHa6nZ27Su84nqNxzu35pYiSmjrSJJODvDRhFzki6K6iVE3FkGFjy
skXqhTqN25h9PxOVM5Kp/LMtOIpH21iNkjXABrRQt1FRXUV1I0qrv021/wB01adSscpi+TKLsHJ2
nPr1IqJa16IMnpqaCkPXGSTIraBjHLeupOmjBNdiVYDlP7wChh/pPEqZSYZ5xltz2/krLbqf8YoS
a8Bu519vRUjF2v8Atn+sr6Jh2Ie/Rr1Wt86FyQrhNzCR73UHr5lDLELLlFSKB5GLOmRxCbXEhk1A
OgcwnRFM6iplLoPOMx2yxtrYtLm7Se22vACtd3H1+5P0u0/2z09yridxLCbPU2VPslK5m2Ngxvkp
oCUlZbunZrEElNU1lR5mKQm7BCybyNgZaIYgK6DQW5jqKqB5gmYCF1ofLcvFcuuG2tkHbQPlbQgG
o0BHt7LDsXbFhBlnp7lLPPKlm+bXeu3mNhucs88rU8vYGsHbdPlJyrSK54hGIZMp2FMzQTmI6HIg
CzQiphORQClMY6KSKSdV55RkchC+GW2tGMeKEtY1pArX4aHT+OZKstsdbREPbJNuB0BJ191KKN0J
5rnIzHJ5tQbrV2NaZWWPeKWCLVSREXsY9XRX94SRFBJMBT8B8zFETmKAAPt688t9bCUv6sv8/wDt
D0RenREdER0RHREdER0RHREdER0RHREdER0RHREdEXgv+Yb+VL/ih0Rf/9k=
--NIMP_AF_12631913696871387--
--NIMP_AF_12631913696871386--