Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
compiled
docs
source
.gitattributes
.gitignore
changelog.md new source data, new installation methods Mar 16, 2017
license new source data, new installation methods Mar 16, 2017
readme.md

readme.md

Oracle Geo Data

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.

Install - Standard (easiest)

  • Execute compiled/install.sql.

Note: Our testing environment takes 135 seconds to complete.

Uninstall

  • Execute compiled/uninstall.sql.

Install - from Source

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.

Uninstall

  • Execute source/uninstall.sql.

Update

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.

Table Definitions

See documentation.

Source Data

Special thanks to http://www.geonames.org/

Changelog

See changelog.

Sponsors

Thanks to Insum Solutions for sponsoring this project.

License

MIT © Vincent Morneau