,it is the location of site, Contact
or Meteorology Station.
The location information
used in the database are based on the
Australia Post database
but the table has only those locations that have
trials stored in database. So, it is highly recommended to add any new location
using the information from the Australia Post database.
latitude and longitude of the location in Australia.
The location table has a record for Unknown Location
(Location Name = Unknown Location
and Location Acronym
) which can be used when the location information is not available.
The string value of the "UnknownLocationAcronym" key in the
file must match the Unknown
record in the location table. Please
read important information
before making any changes in the config file.
<!-- An Unknown location acronym -->
<add key="UnknownLocationAcronym" value="UNKN0"
The location acronym has five characters and it uniquely identifies a location.
It is recommended to use four characters from the location name and remaining last
character from the first character of the postcode to create location acronym.
When a new location is added, the location acronym is generated by the system but
it can be changed as required. While importing location, the location acronym is
generated by the system if the source file does not have the location acronym for
Location is the default Trial Acronym Suffix
for the site
at the location.
Latitude and Longitude
The Latitude and Longitude of Locations are used by the
, Site Navigator
Meteorology Station Navigator
in the database. Though these values are optional,
it is strongly recommended to enter these values so that the map-based search can
be used in the navigator (as shown below).
- Click on the button to activate the map-based-search form.
- Displays current latitude of the cursor position in the map.
- Displays current longitude of the cursor position in the map.
- The surrounding area (km) determine the radius of the circle when click on the
map (in this example, its "400").
- In this example, the area in which the location will be searched to display in
the Contact Navigator. If a location does not
have latitude or longitude then the location is excluded from the search.
How is Latitude and Longitude
managed in Katmandoo?
When Latitude and Longitude is entered for an existing or a new Location, Katmandoo
checks whether the Latitude and Longitude already exist in the GeoCoordinate
table. If it does, then GeoCoordinateId is updated for the Location record.
If not, a new record is created in the GeoCoordinate table with given Latitude
and Longitude. Then new GeoCoordinateId is updated for the Location record.
Use [ Task > Trial > Site
> Manage Location ] to load Location Main Form with all the locations in the
- Location Main Form displaying all the locations that are stored in the database.
- Use [ View > Arrange columns in Main Form ] to change default order of displayed.
Alternately it can be changed by
editing the column list of the Misc Group
- Click here for
an illustration of the main form template.
- Sites which are located in the selected location
(ie "Cowra" is the snapshot)
- Location subform displays Virtual column information
of the selected location (ie "Cowra" in the snapshot).
To add/edit a location, follow the steps below :
- Select a location in the location main form to modify.
- Use [ Record > Add Location ] or [ Record > Edit Location ] or [ Record >
Repeat Location ] to load the Location Setup Form to add/edit a location.
- Click here
for an illustration of the setup form template.
- Location name and postcode are disabled since the location has dependant data. Click
for information on editing restricted value.
- Location Acronym
- Location Latitude and Longitude
- Virtual column name (in second step of the wizard). Click
for information on the Virtual column data entry data grid.
- Important Note: If there is not any virtual column for
LocationFactor table, then second page is disabled.
- A value for the displayed Virtual column can be entered on this part of the data