Does this sound like your problem:
https://gis.stackexchange.com/questions/97966/invalid-kml-representation-on-st-geomfromkml
Also look here:
https://trac.osgeo.org/postgis/search?q=kml&noquickjump=1&ticket=on
Can you try using a new version of Postgis?
Or try posting the how output of something like:
select geom from mytable where gid=<geom_that_fails>;
And someone here can try it on 2.x version for you.
-Steve
On 6/1/2017 6:14 PM, juancotrina wrote:
Hi Tom for yor answer. I don't want to simplify any polygon. My porpose
is export all vertice from spatial table (postgis) to kml, but using
ST_AsKml only export some points, therefore it does not allow drawing
the polygon completely into Google Earh.
I using Postgis 1.3.5.
Juan
On Thu, Jun 1, 2017 at 2:55 PM, Tom van Tilburg-2 [via PostGIS] <[hidden
email] </user/SendEmail.jtp?type=node&node=5011240&i=0>> wrote:
Hi Juan,
I'm not sure I understand your question. Do you mean that you want
to simplify the polygon so it has less points? In that case, use
ST_Simplify before your ST_AsKml function.
Read more about it over here:
https://postgis.net/docs/ST_Simplify.html
<https://postgis.net/docs/ST_Simplify.html>
Best,
Tom
On Thu, Jun 1, 2017 at 9:50 PM, juancotrina <[hidden email]
<http:///user/SendEmail.jtp?type=node&node=5011239&i=0>> wrote:
Hi everybody:
I want to export a polygon from postgis with lots of vertice to
kml using
FUNCTION st_askml, but no export all points. How can I solve
this problem?,
Thanks to help me.
Juan Cotrina.
--
View this message in context:
http://postgis.17.x6.nabble.com/Postgis-Polygon-to-Google-Maps-Polygon-tp4470594p5011238.html
<http://postgis.17.x6.nabble.com/Postgis-Polygon-to-Google-Maps-Polygon-tp4470594p5011238.html>
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
[hidden email]
<http:///user/SendEmail.jtp?type=node&node=5011239&i=1>
https://lists.osgeo.org/mailman/listinfo/postgis-users
<https://lists.osgeo.org/mailman/listinfo/postgis-users>
_______________________________________________
postgis-users mailing list
[hidden email] <http:///user/SendEmail.jtp?type=node&node=5011239&i=2>
https://lists.osgeo.org/mailman/listinfo/postgis-users
<https://lists.osgeo.org/mailman/listinfo/postgis-users>
------------------------------------------------------------------------
If you reply to this email, your message will be added to the
discussion below:
http://postgis.17.x6.nabble.com/Postgis-Polygon-to-Google-Maps-Polygon-tp4470594p5011239.html
<http://postgis.17.x6.nabble.com/Postgis-Polygon-to-Google-Maps-Polygon-tp4470594p5011239.html>
To unsubscribe from Postgis Polygon to Google Maps Polygon, click here.
NAML
<http://postgis.17.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
------------------------------------------------------------------------
View this message in context: Re: Postgis Polygon to Google Maps Polygon
<http://postgis.17.x6.nabble.com/Postgis-Polygon-to-Google-Maps-Polygon-tp4470594p5011240.html>
Sent from the PostGIS - User mailing list archive
<http://postgis.17.x6.nabble.com/PostGIS-User-f3516033.html> at Nabble.com.
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users