I have 1900 tables inside a single schema inside a PostGIS database. I need to convert each table into a KML folder and then have all folders placed inside one giant KML parent folder and viewed in Google Earth. Additionally, I have 5 syle colors classes I need to apply to the tables as well.
Question
Convert entire POSTGIS schema (1900 tables) to KML subfolders inside a single directory KML file.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+21- Safer
Hi @eranchazan
I would recommend taking a look at our KML tutorials. For styling, I would recommend starting off by taking a look at Writing KML with Basic Styling.
As for the folder structure, a simple method would be to use a Feature Type fanout as explained here. If you want greater control over the folder structure, you can try the KML ID (article here).