Christian and David, thanks for your advice. I am very aware that mySQL's spatial capabilities are limited in comparison to PostGIS (I used PostGIS for the last few years whenever I had the choice). But in this project the setting is about CMS/GIS integration and we want to use Joomla as CMS (as it is the most well-know CMS in Indonesia and the most easy to learn too), Joomla uses mySQL as database and therefore... So I will go on trying. The mail from nyem (from 17/10/2011 10:35) gives me some hope . :)
Kind regards, Markus On 17/01/2011 18:25, David Hine wrote: > 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
