Creating New Areas
This section covers what information an Updater or State Coordinator needs to provide for adding a new area into the KID. The procedure is similar to creating new organisations.
The Area and Organisations entities do not have a web-based interface for creating new entries like caves, maps or people have. Instead the information required needs to be emailed to the KID System Administrator.
Only a State Cordinator has the authority to add new areas to the KID. If the KID System Administrator receives a request for adding a new area it will be refered to that State’s State Coordinator. This tutorial is therefore directed to State Coordinators rather than updaters.
To know what information fields to include and their size you need to check on the latest version of the region table in the KID.
Go to the KID Documents for Updaters page and under “ASF KID Specifications” click on “Region Tables”. A direct link is here. A page showing the structure of the Regions Table in the database will appear. The table will look something like what is shown below. Note that the table may show additional fields than what are shown here if the table structure has been altered since this documentation.
Table RE0000: Region
| FID | Field | Type | Null | Key | Default |
|---|---|---|---|---|---|
| 226 | area_id | varchar(9) | PRI | ||
| 225 | state_code | char(2) | YES | ||
| 81 | area_code | char(3) | YES | ||
| 80 | area_name | varchar(50) | YES | ||
| 10019 | lat_long | varchar(35) | YES | ||
| 618 | area_250k_map_sheet_name | varchar(45) | YES | ||
| 10021 | coord_club | varchar(25) | YES | ||
| 621 | area_comment | varchar(62) | YES |
From the above you can see what fields are required and what is the maximum size of the field. You will need to provide information for most fields except area_id. The area_id is created by the System Administrator. If you are not sure what a field means you can look it up in the Region or Area Definitions for ASF KID.
The state_code is given by the table below.
| Code | State |
|---|---|
| 2 | New South Wales |
| 3 | Victoria |
| 4 | Queensland |
| 5 | South Australia |
| 6 | West Australia |
| 7 | Tasmania |
| 8 | Northern Territory |
| 9 | Territories & Islands administered by the Commonwealth of Australia |
The area_code is a 1 to 3 letter code which needs to be unique on a state basis and is chosen by the State Coordinator, not centrally.
The area_comment is at most 62 characters.
The lat_long if given should be the centroid latitude and longitude separated by a space character (see the example for Bungonia below).
This is an example for the NSW area “Bungonia”.
| Field | Value |
|---|---|
| state_code | 2 |
| area_code | B |
| area_name | Bungonia |
| lat_long | 34°50’S 150°00’E |
| area_250k_map_sheet_name | Wollongong |
| coord_club | SSS |
| area_comment | Hot, dry area |
Email this data to the KID System Administrator. The KID System Administrator will take this data and create a script that inserts the data into the region table.
TODO: The RE0000 table will eventually have latitude and longitude in separate fields.