Skip to main content
Question

Convert entire POSTGIS schema (1900 tables) to KML subfolders inside a single directory KML file.

  • June 23, 2020
  • 1 reply
  • 55 views

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.

1 reply

debbiatsafe
Safer
Forum|alt.badge.img+20

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).


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings