Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Existing datasets may be available as CSV files as CSV is a particularly common data exchange format. CSV files can be brought into Konect and mapped as point features.

CSV files can be interpreted by Konect Manager as point feature GIS files if they have two columns that contain the longitude and latitude of point objects in the WGS 84 coordinate system.


STEP-BY-STEP

Imported data can be used to create a new dataset or be appended to an existing dataset.

...


If the two coordinate columns have the names ‘X’ and ‘Y’, then importing a CSV file is the same as importing a TAB or SHP file.

If the coordinate columns are not called ‘X’ and ‘Y’, then Konect Manager asks the user to select which columns contain the longitude and latitude.

As an example, import the file ‘Bins.CSV’ (available for download at Bins.zip) which stores the longitude and latitude in the columns ‘Long’ and ‘Lat’.

      1. Press the ‘Browse’ button and select the file ‘Bins.CSV’.
      2. The ‘Select geometry fields’ control appears.



      3. Select ‘Long’ for the longitude field and ‘Lat’ for the latitude field.

        Image Added

      4. Press the ‘Ok’ button
      5. Select ‘Create a new dataset’.
      6. Press the ‘Create new’ button.
      7. Press the ‘Yes’ button.
      8. Give the dataset the name ‘Bins’ and press ‘Ok’.

Go to the ‘Data’  tab and select the ‘Bins’ dataset to view the 6 bins that are along the streets George and Mary in the city of Brisbane, Australia.

The grid at the bottom of the ‘Data’ tab gives the aspatial bin information.

Image Added

Note: the order of the records is not the same as in the file ‘Bins.CSV’.




Creating A New Dataset

To Use the following steps to create a new dataset by importing a TAB CSV file, do the following steps:

1    Go to the ‘Catalogue’ tab in Konect Manager.

...

3    Select the ‘Import’ tab.

4    Select ‘MapInfo TAB’ ‘CSV' in the ‘Dataset’ list.

5    Press the ‘Browse’ button. Select and 'Open' the required file. In this example we have used ‘FN Property.TAB’

 Image Removed

‘Bins.csv' has been used.

Image Added     

6    Konect Manager reads the contents of the selected file and displays the number of records and the number of data fields in the file. It also draws a rectangle, called the bounding rectangle, that geographically encompasses all the map features in the file. The user can use this information to check that the correct data is being imported.

...

12  The records are appended and Konect Manager automatically goes to the ‘Datasets’ item in the ‘Catalogue’..

Importing CSV files

As mentioned above, Konect Manager can import a CSV file into a dataset if there are two columns in the file that contain the longitude and latitude of a point feature.

If the two coordinate columns have the names ‘X’ and ‘Y’, then importing a CSV file is the same as importing a TAB or SHP file.

If the coordinate columns are not called ‘X’ and ‘Y’, then Konect Manager asks the user to select which columns contain the longitude and latitude.

As an example, import the file ‘Bins.CSV’ (available for download at Bins.zip) which stores the longitude and latitude in the columns ‘Long’ and ‘Lat’.

...

Go to the ‘Data’  tab and select the ‘Bins’ dataset to view the 6 bins that are along the streets George and Mary in the city of Brisbane, Australia.

Image Removed

The grid at the bottom of the ‘Data’ tab gives the aspatial bin information.

Image Removed

Note: the order of the records is not the same as in the file ‘Bins.CSV’.