Re: [udig-users] Spatial relationships

[Jody Garnett <jody.garnett@xxxxxxxxx>]

Is your point and your polygon both in the same coordinate reference system?

Jody

Dubravka Boskovic wrote:
> My geometry attribute is called THE_GEOM. I have a polygon which 
> contains POINT(7453535 5026367), and when I execute CQL statement 
> CONTAINS(THE_GEOM, POINT(7453535 5026367)) it selects nothing, whereas 
> NOT CONTAINS(THE_GEOM, POINT(7453535 5026367)) selects all the 
> polygons including the one that contains the point specified in the 
> statement. Same with other operators, I tried several different 
> examples. Is this a bug or am I doing something wrong?
> Dubravka
>
>
> > Hi Dubravka you should be okay with the example you provided ... the 
> > ATTR1 will need to be the geometry attribute for the data you are 
> > working with. The table view does not show geometry attributes it is 
> > true; to figure out the name...
> > - open up the default feature editor
> > - click on properties for the layer (or catalog entry) and look at 
> > the description of the feature type
> >
> > What we cannot do at this time is a "join" between two layers...
> >
> > When we get a working example sorted out we can add it to this page: 
> > http://udig.refractions.net/confluence/display/EN/Selection+using+CQL
> >
> > Note if you are using shapefiles the attribute is often called 
> > THE_GEOM ... giving us DWITH( THE_GEOM, POINT(135.12,48.26), 0.1, km )
> >
> > I am not sure if it actually pays attention to the km part ... we 
> > will have to check.
> > Jody
> >
> > Dubravka Boskovic wrote:
> > > Hi,
> > >
> > > How can I perform query such as: which objects are within specified 
> > > distance (e.g. 10km) from a certain point? I tried CQL expression in 
> > > Table view in the form of DWITHIN(ATTR1, POINT(X Y), Z, kilometers), 
> > > but the geometry attribute of the object does not exist in Table 
> > > view, so the query returns nothing. Similar thing happened with 
> > > other operators. Is it possible to perform spatial query to select 
> > > objects from the table that are in some spatial relationship with a 
> > > given object?
> > >
> > >
> > > Dubravka
> > >  ------------------------------------------------------------------------ 
> > >
> > >
> > > _______________________________________________
> > > udig-users mailing list
> > > udig-users@xxxxxxxxxxxxxxxxxxxxx
> > > http://lists.refractions.net/mailman/listinfo/udig-users
>
> _______________________________________________
> udig-users mailing list
> udig-users@xxxxxxxxxxxxxxxxxxxxx
> http://lists.refractions.net/mailman/listinfo/udig-users