Joining tables ub WFS ?

classic Classic list List threaded Threaded
14 messages Options
Reply | Threaded
Open this post in threaded view
|

Joining tables ub WFS ?

lmorandini
Yes, I know it cannot be done using WFS or SLD, but, I have this sort of
requirement:

1) A 1.5 million rows table (the entire Italian 2001 census) in Oracle.
2) Some 9.000 polygons (Oracle Spatial) to make thematic maps out of.
3) Queries should be dynamic, since user may choose amongst more than a
hundred statisics.

Therefore, the selection of the BBOX-included polygons and the
subsequent join of this selection with a subset of the 1.5m-rows table
would make sense, allowing a good deal of flexibility with a resonable
response time.

Problem is, I cannot join tables in WFS or SLD (I mean, no filter
element for that)... any idea on how to solve this ?

Regards,

--------------------
    Luca Morandini
www.lucamorandini.it
--------------------



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Joining tables ub WFS ?

Justin Deoliveira-3
There is some work going on currently on one of the geoserver R&D
branches which is aimed at doing exactly this.

http://docs.codehaus.org/display/GEOTOOLS/ComplexDataStore+Documentation

Luca Morandini wrote:

> Yes, I know it cannot be done using WFS or SLD, but, I have this sort of
> requirement:
>
> 1) A 1.5 million rows table (the entire Italian 2001 census) in Oracle.
> 2) Some 9.000 polygons (Oracle Spatial) to make thematic maps out of.
> 3) Queries should be dynamic, since user may choose amongst more than a
> hundred statisics.
>
> Therefore, the selection of the BBOX-included polygons and the
> subsequent join of this selection with a subset of the 1.5m-rows table
> would make sense, allowing a good deal of flexibility with a resonable
> response time.
>
> Problem is, I cannot join tables in WFS or SLD (I mean, no filter
> element for that)... any idea on how to solve this ?
>
> Regards,
>
> --------------------
>    Luca Morandini
> www.lucamorandini.it
> --------------------
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Geoserver-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>


--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Joining tables ub WFS ?

lmorandini
Justin Deoliveira wrote:
> There is some work going on currently on one of the geoserver R&D
> branches which is aimed at doing exactly this.
>
> http://docs.codehaus.org/display/GEOTOOLS/ComplexDataStore+Documentation

Thanks, I saw that discussion... but I need this now: any workaround
(apart from help adding this feature, of course) ?

Regards,
--------------------
    Luca Morandini
www.lucamorandini.it
--------------------



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Re: Joining tables ub WFS ?

Brent Owens
We are looking to merge the branch into trunk in the new year. So if you
can help, it would be greatly appreciated and will speed things up. Ant
it is happening relatively *now*, so it might be a good solution for you =)

We have weekly IRC meetings that have been largly focused on this topic,
you are welcome to join them. Here is a page describing the meetings and
how to connect to them: http://docs.codehaus.org/display/GEOS/IRC

Brent Owens
(The Open Planning Project)



Luca Morandini wrote:

> Justin Deoliveira wrote:
>
>> There is some work going on currently on one of the geoserver R&D
>> branches which is aimed at doing exactly this.
>>
>> http://docs.codehaus.org/display/GEOTOOLS/ComplexDataStore+Documentation
>
>
> Thanks, I saw that discussion... but I need this now: any workaround
> (apart from help adding this feature, of course) ?
>
> Regards,
> --------------------
>    Luca Morandini
> www.lucamorandini.it
> --------------------
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Geoserver-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Re: Joining tables ub WFS ?

Justin Deoliveira-3
In reply to this post by lmorandini
The only other thing I can think of is joining your tables into a view
manually and setting up the feature source against the view.

Luca Morandini wrote:

> Justin Deoliveira wrote:
>
>> There is some work going on currently on one of the geoserver R&D
>> branches which is aimed at doing exactly this.
>>
>> http://docs.codehaus.org/display/GEOTOOLS/ComplexDataStore+Documentation
>
>
> Thanks, I saw that discussion... but I need this now: any workaround
> (apart from help adding this feature, of course) ?
>
> Regards,
> --------------------
>    Luca Morandini
> www.lucamorandini.it
> --------------------
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Geoserver-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>


--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Joining tables ub WFS ?

lmorandini
Justin Deoliveira wrote:
> The only other thing I can think of is joining your tables into a view
> manually and setting up the feature source against the view.

Hmmm.... does GeoServer recognize views as feature source ? I thought
the opposite was true.

Anyway, I suppose I would have to add the view as a FeatureType
dynamically, which should entail only a bit of Java coding, right ?

Regards,

--------------------
    Luca Morandini
www.lucamorandini.it
--------------------



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Joining tables ub WFS ?

lmorandini
In reply to this post by Brent Owens
Brent Owens wrote:
> We are looking to merge the branch into trunk in the new year. So if you
> can help, it would be greatly appreciated and will speed things up. Ant
> it is happening relatively *now*, so it might be a good solution for you =)

As much as I'd like joining the development team, this is not be the
best project to do it, since it would be hard to justify to this
specific customer the time I will spend on developing this feature.

Look, they have already ArcIMS onboard... sure, they're open to
open-source alternatives, but only as long as these alternatives work
out-of-the-box.

Regards,

--------------------
    Luca Morandini
www.lucamorandini.it
--------------------



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Re: Joining tables ub WFS ?

Brent Owens
Fair enough Luca =)

Brent Owens
(The Open Planning Project)



Luca Morandini wrote:

> Brent Owens wrote:
>
>> We are looking to merge the branch into trunk in the new year. So if
>> you can help, it would be greatly appreciated and will speed things
>> up. Ant it is happening relatively *now*, so it might be a good
>> solution for you =)
>
>
> As much as I'd like joining the development team, this is not be the
> best project to do it, since it would be hard to justify to this
> specific customer the time I will spend on developing this feature.
>
> Look, they have already ArcIMS onboard... sure, they're open to
> open-source alternatives, but only as long as these alternatives work
> out-of-the-box.
>
> Regards,
>
> --------------------
>    Luca Morandini
> www.lucamorandini.it
> --------------------
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Geoserver-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Re: Joining tables ub WFS ?

Javier de la Torre
In reply to this post by lmorandini
Uhmmm... that is interesting for me too..
I remember to have tried this and I also found that Geoserver was not  
recognizing the geometries inside a view...

Javier.

On 21/12/2005, at 22:39, Luca Morandini wrote:

> Justin Deoliveira wrote:
>> The only other thing I can think of is joining your tables into a  
>> view manually and setting up the feature source against the view.
>
> Hmmm.... does GeoServer recognize views as feature source ? I  
> thought the opposite was true.
>
> Anyway, I suppose I would have to add the view as a FeatureType  
> dynamically, which should entail only a bit of Java coding, right ?
>
> Regards,
>
> --------------------
>    Luca Morandini
> www.lucamorandini.it
> --------------------
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through  
> log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD  
> SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Geoserver-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Re: Joining tables ub WFS ?

alexander-petkov
On 12/21/05, Javier de la Torre <[hidden email]> wrote:
> Uhmmm... that is interesting for me too..
> I remember to have tried this and I also found that Geoserver was not
> recognizing the geometries inside a view...
>
> Javier.

Is that when using Oracle? I know it is definitely possible with PostGis.

Alex
N�HY޵隊X���'���u���[�������
ަ�k��!���W�~�鮆�zk��C� 塧m����@^ǚ��^��z�Z�f�z�j�!�x2�������ɫ,��� a{� �,�H��4�m���i�(��ܢo�v'��jYhr'ׯ:�rX��g����z��z�&j)b� b�ў�ǫ�����+-��.�ǟ����a��l��b��,���y�+��޷�b��?�+-�w������z��z�
Reply | Threaded
Open this post in threaded view
|

Re: Re: Joining tables ub WFS ?

Chris Holmes-2
Quoting Alexander Petkov <[hidden email]>:

> On 12/21/05, Javier de la Torre <[hidden email]> wrote:
> > Uhmmm... that is interesting for me too..
> > I remember to have tried this and I also found that Geoserver was
> not
> > recognizing the geometries inside a view...
> >
> > Javier.
>
> Is that when using Oracle? I know it is definitely possible with
> PostGis.

I believe people have got it working with oracle.  You have to add it by
hand (like modify the xml files), since our datastore won't recognize
views.  And the view needs an entry in the geom meta table.  If you dig
into the code I think you should find a way to make it work, like
there's no huge deal breakers afaik.

Thijs is one of our most experienced oracle users.  Do you have any
hints on how to get views working?  Or if you never did, where it fell
short?

Also, Alex, if it's not done already, could you add a little section to
the Postgis DataStore on how to get views working?  I think the key
trick is to name one of your columns 'oid', and everything works fine.

Chris

>
> Alex
> †+w­zf¢–+,¦‰ì¢·o$©–éä"w£*.‚·©¶èºe¢â•ë¢ºk¡¹^šÄ­¢èÂyhiÛazw°

----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
<a href="http://ads.osdn.com/?ad_idv37&alloc_id865&op=click">http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Re: Joining tables ub WFS ?

Thijs Brentjens-3
Hi Alexander,

For support of views, it depends on the version (Geoserver) you're using.
If that is 1.2.3 or an earlier version, views are not supported. But as
Chris says, you could configure it manually. As far as I can recall I:
1. created a table with the exact same name and definition as the view I
wanted (create table my_view as select... etc)
2. made an entry in user_sdo_geom_metadata for that table
3. created a spatial index on the geometry column of the table
4. then configured Geoserver (manually or with the web-admin, both should work)
5. dropped the table
6. created the view: create or replace view my_view as select ...etc (so
with the same select-statement as the table and the same name)

Configuring it manually (i.e. write the info.xml) should work, but I don't
know why I didn't do that. Anyway, it worked. But I'm sure there are more
elegant ways of doing it...

However, with an Oracle datastore it's far better to use one of the
1.3.0.RCx versions of Geoserver. Because with these versions views are
supported (for all JDBC-datastores, I think). I'm using them a lot actually
and I'm not using 1.2.3 anymore, since support for Oracle has been improved
(better SQL) for 1.3.0.RCx. Note that you still need to "register" the view
in user_sdo_geom_metadata. And the geometry column of the table that you're
using in the view should have a spatial index on it.

This email is a bit messy, but maybe it helps. If not, then please tell me
what database and which version of Geoserver you are using.

Best regards,
Thijs

PS @Chris: I've still got plans to add something to the docs on the Oracle
datastore, but time has been the problem and documenting isn't one of my
favorite things to do... Sorry for that.

At 00:54 22-12-2005, Chris Holmes wrote:

>Quoting Alexander Petkov <[hidden email]>:
>
> > On 12/21/05, Javier de la Torre <[hidden email]> wrote:
> > > Uhmmm... that is interesting for me too..
> > > I remember to have tried this and I also found that Geoserver was
> > not
> > > recognizing the geometries inside a view...
> > >
> > > Javier.
> >
> > Is that when using Oracle? I know it is definitely possible with
> > PostGis.
>
>I believe people have got it working with oracle.  You have to add it by
>hand (like modify the xml files), since our datastore won't recognize
>views.  And the view needs an entry in the geom meta table.  If you dig
>into the code I think you should find a way to make it work, like
>there's no huge deal breakers afaik.
>
>Thijs is one of our most experienced oracle users.  Do you have any
>hints on how to get views working?  Or if you never did, where it fell
>short?
>
>Also, Alex, if it's not done already, could you add a little section to
>the Postgis DataStore on how to get views working?  I think the key
>trick is to name one of your columns 'oid', and everything works fine.
>
>Chris
>
> >
> > Alex
> > †+w­zf¢­+,¦‰ì¢·o$©­éä"w£*.‚·©¶





-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
<a href="http://ads.osdn.com/?ad_idv37&alloc_id865&op=click">http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Re: Joining tables ub WFS ?

Bart van den Eijnden-4
In reply to this post by lmorandini
I have been using Oracle Spatial views with the 1.3 series and it works fine, even the admin tool recognizes the spatial views if you make sure they are advertized in SDO_GEOM_METADATA_TABLE.

I have also used purely administrative views without geometry (also through the admin tool).

Best regards,
Bart

Bart van den Eijnden
Syncera IT Solutions
Postbus 270
2600 AG  DELFT

tel.nr.: 015-7512436
email: [hidden email]

>>> Thijs Brentjens <[hidden email]> 12/22/2005 10:34:34 AM >>>
Hi Alexander,

For support of views, it depends on the version (Geoserver) you're using.
If that is 1.2.3 or an earlier version, views are not supported. But as
Chris says, you could configure it manually. As far as I can recall I:
1. created a table with the exact same name and definition as the view I
wanted (create table my_view as select... etc)
2. made an entry in user_sdo_geom_metadata for that table
3. created a spatial index on the geometry column of the table
4. then configured Geoserver (manually or with the web-admin, both should work)
5. dropped the table
6. created the view: create or replace view my_view as select ...etc (so
with the same select-statement as the table and the same name)

Configuring it manually (i.e. write the info.xml) should work, but I don't
know why I didn't do that. Anyway, it worked. But I'm sure there are more
elegant ways of doing it...

However, with an Oracle datastore it's far better to use one of the
1.3.0.RCx versions of Geoserver. Because with these versions views are
supported (for all JDBC-datastores, I think). I'm using them a lot actually
and I'm not using 1.2.3 anymore, since support for Oracle has been improved
(better SQL) for 1.3.0.RCx. Note that you still need to "register" the view
in user_sdo_geom_metadata. And the geometry column of the table that you're
using in the view should have a spatial index on it.

This email is a bit messy, but maybe it helps. If not, then please tell me
what database and which version of Geoserver you are using.

Best regards,
Thijs

PS @Chris: I've still got plans to add something to the docs on the Oracle
datastore, but time has been the problem and documenting isn't one of my
favorite things to do... Sorry for that.

At 00:54 22-12-2005, Chris Holmes wrote:

>Quoting Alexander Petkov <[hidden email]>:
>
> > On 12/21/05, Javier de la Torre <[hidden email]> wrote:
> > > Uhmmm... that is interesting for me too..
> > > I remember to have tried this and I also found that Geoserver was
> > not
> > > recognizing the geometries inside a view...
> > >
> > > Javier.
> >
> > Is that when using Oracle? I know it is definitely possible with
> > PostGis.
>
>I believe people have got it working with oracle.  You have to add it by
>hand (like modify the xml files), since our datastore won't recognize
>views.  And the view needs an entry in the geom meta table.  If you dig
>into the code I think you should find a way to make it work, like
>there's no huge deal breakers afaik.
>
>Thijs is one of our most experienced oracle users.  Do you have any
>hints on how to get views working?  Or if you never did, where it fell
>short?
>
>Also, Alex, if it's not done already, could you add a little section to
>the Postgis DataStore on how to get views working?  I think the key
>trick is to name one of your columns 'oid', and everything works fine.
>
>Chris
>
> >
> > Alex
> > *+w-zf¢-+,|*좷 o$©-éä"w£*.*·©¶





-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=click 
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
<a href="http://ads.osdn.com/?ad_idv37&alloc_id865&op=click">http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: Re: Joining tables ub WFS ?

alexander-petkov
In reply to this post by Chris Holmes-2
> Also, Alex, if it's not done already, could you add a little section to
> the Postgis DataStore on how to get views working?  I think the key
> trick is to name one of your columns 'oid', and everything works fine.
>
> Chris

I finally added a section here:
http://docs.codehaus.org/display/GEOSDOC/PostGIS+DataStore

I am not sure if that was the most appropriate place, so please move
it/edit as needed. A link to it on the "User guide" and FAQ sections
is still missing. I'll add a bit later.

Alex
N�HY޵隊X���'���u���[�������
ަ�k��!���W�~�鮆�zk��C� 塧m����@^ǚ��^��z�Z�f�z�j�!�x2�������ɫ,��� a{� �,�H��4�m���i�(��ܢo�v'��jYhr'ׯ:�rX��g����z��z�&j)b� b�ў�ǫ�����+-��.�ǟ����a��l��b��,���y�+��޷�b��?�+-�w������z��z�