Markus Christian is making a very useful recommendation. PostGIS/Postgres is a better database for this purpose.
The UI tools for Postgres are different from MySQL and perhaps a little harder to learn intuitively but the investment of time in learning is repaid by the many spatial analysis and display tools in PostGIS that are not available for MySQL. PostGIS in Action by R Obe and L Hsu has been very helpful. You can see it on Manning Publications(www.manning.com/obe/) David Hine David Hine | Land and Water Management | ....making it visible.... -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Monday, 17 January 2011 7:06 PM To: Dr. Markus Müller Cc: [email protected] Subject: Re: [Geoserver-users] mySQL datastore - display of polygonsfails [resend] One quick question. You are aware of the fact that mysql does not implement the full OpenGIS specification. http://dev.mysql.com/doc/refman/5.5/en/functions-that-test-spatial-relations hips-between-geometries.html Relationship tests are always based on the MBR of the geometries. For example, an intersection test of 2 polygons is handled as an intersection test of the MBRs of these polygons. The result may not be what you are expecting. I would recommend postgis. Yust my 2 cents Quoting "Dr. Markus Müller" <[email protected]>: > [Sorry for the resend - nobody uses mysql with geoserver on this list?] > > > Dear listers, > > I want to use mySQL as datastore for geoserver but have trouble with > polygons: they are only displayed as points although the geometry type > in mysql is polygon or multipolygon. I use: > - windows vista home premium > - xampp-win32-1.7.3 > - geoserver 2.0.2 and corresponding mysql plugin > - FWTools 2.4.7 for importing shapefiles into my mysql database > > If I use a shapefile datastore with the same data it is displayed fine, > so I guess something between mysql and geoserver goes wrong. > > Anybody experience with this problem or any ideas? > > > Thanks and regards, > > Markus > > > ---------------------------------------------------------------------------- -- > Protect Your Site and Customers from Malware Attacks > Learn about various malware tactics and how to avoid them. Understand > malware threats, the impact they can have on your business, and how you > can protect your company and customers by using code signing. > http://p.sf.net/sfu/oracle-sfdevnl > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ---------------------------------------------------------------------------- -- Protect Your Site and Customers from Malware Attacks Learn about various malware tactics and how to avoid them. Understand malware threats, the impact they can have on your business, and how you can protect your company and customers by using code signing. http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users ------------------------------------------------------------------------------ Protect Your Site and Customers from Malware Attacks Learn about various malware tactics and how to avoid them. Understand malware threats, the impact they can have on your business, and how you can protect your company and customers by using code signing. http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
