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.
Convert entire POSTGIS schema (1900 tables) to KML subfolders inside a single directory KML file.
Userlevel 3
+17
- Safer
- 588 replies
-
24 June 2020
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).
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.