MySQL has limited spatial capabilities - they do have geometry storage and a
spatial index. The main problem is that all spatial operations are done
against the bounds of the geometries. So they're not exactly accurate. So
if your polygons are all boxes then it'll work great, if not then it'll also
return points that are outside of polygon but in its box (at least this is
my understanding of MySQL functions). Now, GeoTools does have the
capabilities to deal with this - to not pass the spatial filters to MySQL to
try to handle, but to do the filtering itself. This is what we do for
Shapefiles. I'm not sure where exactly the MySQL datastore stands though,
if it does the right thing. It was coded pretty quickly and hasn't seen a
lot of love. You should be able to test it pretty easily though. And if it
didn't work but you could get dirty with java code it may not be that hard
to fix.
GeoServer does not have the ability to join across datastores, so your
second idea won't really work.
hope that helps,
Chris
On Fri, Dec 17, 2010 at 9:04 AM, Stephen Crawford <[email protected]> wrote:
> All.
>
> I've been using Geoserver with postgres/postgis for years and we use it
> in almost all of our tools. I now have a project where the user has an
> existing mySQL database. The data are all points, and for the most part
> we will be just plotting points, querying the data by some attribute;
> for this we don't even need geoserver. However they would like the
> ability to also select points by polygons such as states or ecoregions
> or watersheds, etc. Does mySQL have enough spatial capability to do
> this? And/or with geoserver can one select the points from a feature
> layer in one datastore (mySQL) using a polygon layer from another data
> store?
>
> Thanks,
> Steve
>
> --
> Stephen Crawford
> Center for Environmental Informatics
> The Pennsylvania State University
> [email protected]
> 814.865.9905
>
>
>
>
> ------------------------------------------------------------------------------
> Lotusphere 2011
> Register now for Lotusphere 2011 and learn how
> to connect the dots, take your collaborative environment
> to the next level, and enter the era of Social Business.
> http://p.sf.net/sfu/lotusphere-d2d
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
