GENUKI Maintainers' Pages

Version 2.0

Definition Of The Format For Church Database Entries

Source files

Searches on the Church Database 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 CCCchurches.csv, where CCC is the upper case 3-letter Chapman County code. The county's CCCchurches.csv file is held in the filestore of the genuki.org.uk server and a symbolic link to it is provided in the home directory of the county's church database maintainer. 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 CCCchurches.csv file.

Database creation/update

A program is run by the system administrator to collect all the county CCCchurches.csv files and update/build the church database.

Definition of fields

The fields in the CCCchurches.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 CCCchurches.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

[Last updated at 08.41 on Monday, 14 July 2014, by Mel Lockie. 2014]
Hosted by Mythic Beasts Ltd.