GENUKI Maintainers' Pages

Version 1.28

Definition Of The Format For Church Database Entries

Source files

The searches are all performed on a central MySQL database using SQL queries. Changes made by maintainers are not made to the central database itself, but to a set of source files which are used collectively to replace the entire database at regular intervals or when the need arises.

The source files consist of comma separated text files named churches.csv, with one file per county. The churches.csv file for a county can be held in any convenient location on a server accessible to both the county's church database maintainer, and the system administrator. Note that the county's church database maintainer need not be the same person as the county maintainer. Contact the system administrator if you have a problem locating your churches.csv file.

Database creation/update

The URL for a county's churches.csv file is held as part of the county's entry in the County database table. Contact the system administrator if you need the entry changed.

A program is run by the system administrator to collect all the county churches.csv files and build the database from source. When any section has been changed, a database rebuild is required to activate the change; a simple rebuild is performed at 06:00 every day.

Definition of fields

The fields in the churches.csv file are as follows. Each field description contains the field content, its size and type. The column letters are those that would head a spreadsheet format of the churches.csv file.

ColumnContentExplanation
ACounty Chapman county code, 3 characters, upper case.
BLocation The OS grid reference of the church [XXnnnnnn or XXnnnnnnnnnn (upper case)].
CApproximate A multi-valued flag indicating whether the grid reference is exact or approximate.
DName Name of the church.
EURL This is typically the historic parish or township which includes this church and will point to a GENUKI parish page.
FDedication The dedication of the church.
GURL The URL of a GENUKI page specifically for the church which is displayed instead of the generic page giving details of the church.
HStreet The name of the street where the church is located.
ICode A code used to group the denominations by type (see Notes below).
JDenomination The exact denomination.
KFounding The founding date of the church.
LClosing The closing date of the church.
MURL The URL of a picture of the church.
NURL The URL of the church's own web page.
OGraveyard Boolean flag indicating whether the church has ever had a graveyard.
PHistory Boolean flag indicating whether the distinct page for the church has a Church History section.
QRecords Boolean flag indicating whether the distinct page for the church has a Church Records section.
RName The name of the person holding the copyright.
SConditions Anything else to do with copyright.
TFlag A flag field.
UID A unique identity.
VChurch History Text Text under the Church History heading.
WChurch Records Text Text under the Church Records heading.
XCemeteries Text Text under the Cemeteries heading.
YChurch Move Link Link connecting entries for churches that have moved.

Notes