| Re: [udig-users] Unable to apply a spatial Filter using CQL language in the Table View |
|
Not from you specifically. I understood that Mauricio will have a look
into the problem, and then I am just hoping some news were posted on
this mailing list when the problem is detected/solved. As usual, sooner
would be the best, but it seems that there are many problems on all the
spatial statements in CQL ... and I guess it would take time ... Regards, Jacques Jody Garnett a écrit : Waiting for new from me? We talked about this in the uDig IRC meeting yesterday:- http://udig-news.blogspot.com/2009/02/irc-logs-feb-6th.html I am still not sure where the problem is on this one; mauricio was going to have a look - let me know if you guys get stuck. Jody On Sat, Feb 7, 2009 at 7:59 AM, Jacques LESCOT < jacques.lescot@xxxxxxxxxxxxxxxx> wrote:The problem is not related with the distance value or its unit, but with the DWITHIN statement itself. >From Mauricio's answer, the problem was related with the cql library 2.2.x. I am waiting further news from you so that I can check this on a fixed version. Thanks again for these answers. :-) Regards, Jacques Jody Garnett a écrit : Sorry for the short reply (from my mobile). The units in this _expression_ are completely useless as far as I know. You can say 10 km or 10 m and it will amount to the same thing ... 10. The actual number will be taken against the the raw geometry values; so if they are in lat/lon you will need a distance measured in linear degrees or something. I have solved the problem a couple times as a programmer; but cannot remember right now. The other thing (my usual solution) is to convert the data into an equal area projection measured in meters; and work form there (10km = 10,000 m). Hope this helps, Jody On Thu, Feb 5, 2009 at 11:41 PM, Jacques LESCOT <jacques.lescot@xxxxxxxxxxxxxxxx> wrote: Sorry, I do not really understand your answer ... do you advise me to change the unit ? I had no more chance with "DWITHIN(the_geom, POINT(2 48), 100000, meters)" Do you have any working example using the DWITHIN statement ? Thanks for your help, Jacques Jody Garnett a écrit : The 100 KM is not actually I'm km but are in the units of the data. On 05/02/2009, at 9:30 PM, Jacques LESCOT <jacques.lescot@xxxxxxxxxxxxxxxx> <jacques.lescot@xxxxxxxxxxxxxxxx> <jacques.lescot@xxxxxxxxxxxxxxxx> <jacques.lescot@xxxxxxxxxxxxxxxx> wrote: Hi, I am able to run some "basic" filter, like LOCALIZED_NAME LIKE 'Casier %', but I can not figure out how to apply a spatial filter using CQL language in the Table view ? Here is the filter I would like to apply : DWITHIN(the_geom, POINT(2 48), 100, kilometers) - I followed example given here :http://udig.refractions.net/confluence/display/EN/Common+Query+Language#CommonQueryLanguage-SpatialRelationships - "the_geom" is the column that contain spatial information Any help appreciated. Regards, -- <Signature_AWT.jpg> Jacques LESCOT Project Manager Eclipse Technical Expertjacques.lescot@xxxxxxxxxxxxxxxx Standard : +33(0)5 61 00 52 90 Direct : +33(0)5 61 00 06 60 Mobile : +33(0)6 74 49 23 34 Fax : +33(0)5 61 00 51 46 Anyware Technologies Lake Park ZAC de l'Hers - Allée du Lac BP 87216 31672 Labège Cedex Francewww.anyware-tech.com This message and any attachments (the "Message") are confidential and intended solely for the addressees. Any unauthorized modification, edition, use or dissemination is prohibited. Neither Anyware Technologies nor its headquarters Wavecom shall be liable for the Message if altered, changed, falsified or edited, diffused without authorization. _______________________________________________ udig-users mailing listudig-users@lists.refractions.nethttp://lists.refractions.net/mailman/listinfo/udig-users -- [image: Anyware Technologies] <http://www.anyware-tech.com> <http://www.anyware-tech.com> *Jacques LESCOT* Project Manager Eclipse Technical Expertjacques.lescot@xxxxxxxxxxxxxxxx Standard : +33(0)5 61 00 52 90 Direct : +33(0)5 61 00 06 60 Mobile : +33(0)6 74 49 23 34 Fax : +33(0)5 61 00 51 46 *Anyware Technologies * Lake Park ZAC de l'Hers - Allée du Lac BP 87216 31672 Labège Cedex Francewww.anyware-tech.com This message and any attachments (the "Message") are confidential and intended solely for the addressees. Any unauthorized modification, edition, use or dissemination is prohibited. Neither Anyware Technologies nor its headquarters Wavecom shall be liable for the Message if altered, changed, falsified or edited, diffused without authorization. -- [image: Anyware Technologies] <http://www.anyware-tech.com> *Jacques LESCOT* Project Manager Eclipse Technical Expert jacques.lescot@xxxxxxxxxxxxxxxx Standard : +33(0)5 61 00 52 90 Direct : +33(0)5 61 00 06 60 Mobile : +33(0)6 74 49 23 34 Fax : +33(0)5 61 00 51 46 *Anyware Technologies * Lake Park ZAC de l'Hers - Allée du Lac BP 87216 31672 Labège Cedex France www.anyware-tech.com This message and any attachments (the "Message") are confidential and intended solely for the addressees. Any unauthorized modification, edition, use or dissemination is prohibited. Neither Anyware Technologies nor its headquarters Wavecom shall be liable for the Message if altered, changed, falsified or edited, diffused without authorization. --
Any unauthorized modification, edition, use or dissemination is prohibited. Neither Anyware Technologies nor its headquarters Wavecom shall be liable for the Message if altered, changed, falsified or edited, diffused without authorization. |
