Justin,
thanks for your offer, I finally succeeded. The problem was that
geoserver seems to be able to identify geometry types when the data
comes from a shapefile and assigns a corresponding default
polygonsymbolizer (if using polygon data). When using mySQL this fails,
but after I manually assigned a simbolizer everything was fine.
Regards,
Markus
On 18/01/2011 22:24, Justin Deoliveira wrote:
Hi Markus,
If you are still unable to get the polygons to work can you provide an
sql dump of the table. Attaching it to an issue in the bug tracker
would be best. Feel free to assign it to me.
-Justin
On Mon, Jan 17, 2011 at 5:57 PM, "Dr. Markus Müller"
<markus.u.muel...@zoho.com <mailto:markus.u.muel...@zoho.com>> wrote:
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/
<http://www.manning.com/obe/>)
>
> David Hine
>
> David Hine | Land and Water Management | ....making it
> visible....
> -----Original Message-----
> From: christian.muel...@nvoe.at
<mailto:christian.muel...@nvoe.at>
[mailto:christian.muel...@nvoe.at <mailto:christian.muel...@nvoe.at>]
> Sent: Monday, 17 January 2011 7:06 PM
> To: Dr. Markus Müller
> Cc: geoserver-users@lists.sourceforge.net
<mailto:geoserver-users@lists.sourceforge.net>
> 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"<markus.u.muel...@zoho.com
<mailto:markus.u.muel...@zoho.com>>:
>
>> [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
>> Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
>> 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
> Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
> 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
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users