Downloaded the file that is there and loaded it up into Google Earth.
Right click on the Countries folder and click Save Place As Save it as a KML file, not a KMZ. Copy the Countries.kml file to the /tools/kml/ folder in wifidb.
Run the [url=https://github.com/pferland/WiFiDB/blob ... romKML.php[/url] script and it will populate the boundaries table in the wifi database.
Code: Select all
MariaDB [wifi]> select id, name from boundaries limit 10;
+----+-------------+
| id | name |
+----+-------------+
| 1 | Afghanistan |
| 2 | Albania |
| 3 | Algeria |
| 4 | Andorra |
| 5 | Angola |
| 6 | Angola |
| 7 | Antarctica |
| 8 | Antarctica |
| 9 | Antarctica |
| 10 | Antarctica |
+----+-------------+
10 rows in set (0.00 sec)