GENUKI Maintainers' Pages

Version 2.1

Adding Or Modifying An Entry In The Gazetteer

Source files

Searches on the Gazetteer are performed on a central MySQL database using SQL queries. Changes made by maintainers are not made to the central database itself, but to source files which are used collectively to update the database at regular intervals or when the need arises.

The source files consist of comma separated text files named CCCplaces.csv, where CCC is the upper case 3-letter Chapman County code. The county's CCCplaces.csv file is held in the filestore of the server to which a symbolic link is provided in the home directory of the county's gazetteer maintainer. Note that the county's gazetteer maintainer need not be the same person as the county maintainer. Contact the system administrator if you have a problem locating your CCCplaces.csv file.

Database creation/update

A program is run by the system administrator to collect all the county CCCplaces.csv files and update/build the gazetteer.

Updating the gazetteer

Refer to the definition of gazetteer fields for details of what to enter in each field.

Use an editor to update the places.csv file for your county. A simple text editor will be adequate, but it might be easier to use a spreadsheet editor if you have one available. Don't forget to save the updated file back in its original csv format.

To add a new entry, simply insert a new empty line in the file and add the new entry. The file should be sorted by placename so locate the right point in the file for the new entry.

To modify an existing entry, locate the entry and edit the fields that need changing, taking care to use the correct flags - some of these are not obvious, so look at similar entries to get the right values.

Improving the gazetteer

There are some tasks that county maintainers should undertake to improve the gazetteer. It may well be worthwhile recruiting a competent volunteer to do the bulk of the work but quality control procedures will be needed, and cooperation to ensure the correct URLs are used on the entries.

Copyright warning

It would be a breach of copyright/database right to systematically copy placenames and grid references from a map or gazetteer that is in copyright. NPE OS maps are a useful additional source that is out of copyright and can be found at:

[Last updated at 14.41 on Monday, 1 September 2014, by Mel Lockie. 2014]
Hosted by Mythic Beasts Ltd.