|
From: Cameron S. <cam...@gm...> - 2005-12-29 11:26:30
|
Thanks Chris,
I'm using MySQL because my client develops on Drupal, which is usually
installed with MySQL.
I think I might have hit one of MySQL's limitations. I want to
determine what political district a person lives in, so I'm testing
whether a point is within a polygon using:
SELECT ID, STATE, CD FROM cd99_109 WHERE Contains(ogc_geom,
GeomFromText('POINT(-87.395053 30.6159)'));
However, it seems that MySQL is using a BBox test for it's Contains
function so I often get multiple districts returned instead of just one.
Do you know if this is a MySQL limitation, or have I corrupted my
shapefile data during the import process?
Chris Holmes wrote:
> Quoting Cameron Shorter <cam...@gm...>:
>
>
>>I'm trying unsucessfully to create a MySQL datasource from the
>>Geoserver Configuration Web page.
>>
>>I select Config->Data->Store->New
>>I set DataStore ID=MySQL and all the other parameters.
>>
>>I'm using Geoserver 1.0RC7 and have copied the MySQL jars from
>>geoserver-mysql-ext-beta2.zip
>
> I'm pretty sure you don't need to copy the mysql jars, as I believe RC7
> comes with updated MySQL jars. The beta2 stuff is against 1.2.x, and
> I'm sorta surprised you get this far.
>
> The error itself sounds more like a mysql configuration problem, not
> being configured for tcp/ip connections, or perhaps not having proper
> permissions. But perhaps just using the 1.3.0 mysql stuff will fix the
> problem.
>
> Also note that we don't really recommend mysql, postgis is a far
> superior database and geotools datastore. Mysql's fine for basic
> querying, but that's about it.
>
> Chris
--
Cameron Shorter
http://cameron.shorter.net
|