Visualisation of Geological Observations on Web 2.0 Based Maps - Maps for the Future Children Education and Internet - page 171

Fig. 14.4 Structure of the relational database of the geological field observations. The code tables
are bilingual (English and Hungarian), the language of the documentation is selectable. Field
names in italics in the OBSERVATIONS main data table indicate that the data recording process may
happen directly or through the linked sub-tables
14.2.2 Data Fields or Categories?
If the data of the observation are collected in one form (Fig. 14.3 ), each category
represents one ore more records in the data tables. These forms are originally the
Word documents themselves, created by the documenters, but the creation of these
collections may work reversely if it is needed.
Creating the collections from the database is a question of querying the database.
In a query, which produces the form of the Word document (Fig. 14.3 ), the records
are collected from the main or sub-tables of the relational database.
Both in the forward and in the reverse process, the categories are basically the
followings:
1. Identification of the outcrop
2. List of the identified objects (with codes)
3. List of the documenters
4. Date and time of the documentation