Four tables containing the world's 7 continents, 252 countries, 3,916 administrative divisions and 22,598 cities in a sql script for Oracle.
Demo: https://demo.insum.ca/ords/f?p=131
Note: An administrative division can be a state, region, province, territory, etc.
- Execute
compiled/install.sql
.
Note: Our testing environment takes 135 seconds to complete.
- Execute
compiled/uninstall.sql
.
Use this method if you wish to understand how to the tables are populated from http://www.geonames.org/.
- Execute
source/install.sql
.
Note: Our testing environment takes 120 seconds to complete.
- Execute
source/uninstall.sql
.
Use this if you were using a previous build of Oracle Geo Data and only wish to update your data.
- Execute
source/update.sql
.
Note: Our testing environment takes 115 seconds to complete.
Special thanks to http://www.geonames.org/
Thanks to Insum Solutions for sponsoring this project.
MIT © Vincent Morneau