The KID reports that the cave has 0 entrances - how can this be?
The database contains a field "quantity_of_entrances" which is the
total number of entrances to the cave, whether they are numbered or not. It
is completed only for the main record for the cave and if there is
more than one entrance.
When the raw data was imported from the DOS based Paradox system to this MySQL
database numeric fields which were originally empty were converted into the
numeric value 0.0 by the database (in databases a numeric field MUST have a
numeric value, it can't be empty). Numeric fields which did have a value
such as "3" show up correctly as 3. To fix the problem the
"" entries have to be replaced by the special database keyword
`NULL'.
A similar problem was found for fields of type float such as the cave length
and temperature. These have now been fixed and a fix for the
quantity_of_entrances field will also be done soon.
Example: a search for Mammoth Cave at Jenolan, NSW shows;
2J-13 Mammoth Cave at Jenolan, Entrance is cave type; (3 entrances);
2J-14 Mammoth Cave at Jenolan, Entrance is pothole type; (0 entrances);
2J-15 Mammoth Cave at Jenolan, Entrance is pothole type; (0 entrances);
The main entrance shows correctly 3 entrances. The other entrances to
Mammoth Cave have zero as the value of the "quantity_of_entrances"
field.
Top