Location

Unknown Location

Location Acronym

Latitude and Longitude

The Latitude and Longitude of Locations are used by the Contact Navigator, Site Navigator and Meteorology Station Navigator to perform map-based search 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).

Illustrative snapshot:

1. Click on the button to activate the map-based-search form.
2. Displays current latitude of the cursor position in the map.
3. Displays current longitude of the cursor position in the map.
4. The surrounding area (km) determine the radius of the circle when click on the map (in this example, its "400").
5. 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.

• Alternate Key (AK1): Location Name + Location Postcode uniquely identifies a location.
• Virtual columns (such as State, Region etc) can be added to the LocationFactor table.
• Location tab in the Data Dictionary has detailed information on the columuns used in Location and LocationFactor tables.

Illustrative snapshot:

1. 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 LocationSetupDataGrid.
   • Click here for an illustration of the main form template.
2. Sites which are located in the selected location (ie "Cowra" is the snapshot)
3. Location subform displays Virtual column information of the selected location (ie "Cowra" in the snapshot).

• 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.

1. Location name and postcode are disabled since the location has dependant data. Click here for information on editing restricted value.
2. Location Acronym
3. Location Latitude and Longitude
4. Virtual column name (in second step of the wizard). Click here 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.
5. A value for the displayed Virtual column can be entered on this part of the data grid.

• Click on Export button in the main form or use [ Record > Export > Export Location ] to start Export Wizard to export displayed locations. 
• Use [ Record > Export > Export Data Entry Template ] to start Export Template Wizard to export required column (to import later) into a Excel spreadsheet that can be used to enter locations. The spreadsheet can be used by the Import Wizard to import locations into the database.

• Click on Import button in the main form or use [ Record > Import > Import Location ] to start Import Location Wizard to import locations as well as sites and site years from external source file.
  
  • The default order of columns displayed can be changed by editing the column list of the Misc Group LocationSetupDataGrid.
  • The source file must have LocationName and LocationPostcode columns.
  • click here to read important note on importing data.