# Loading the data in a GIS ### Loading the data in a GIS This section describes how to load the combined CSV output file into five commonly-used GIS applications: * [QGIS](#qgis) * [ArcGIS Pro](#arcgis-pro) * [ArcMap](#arcmap) * [MapInfo Pro](#mapinfo-pro) * [Cadcorp SIS Desktop](#cadcorp-sis-desktop)

QGIS

The following step-by-step instructions show you how to load OS Open Names CSV files into QGIS. They were prepared using QGIS Desktop version 3. QGIS is an open-source GIS in which you can create, edit, visualise and publish geographic information. You can download it for free from the [Download QGIS for your platform page of the QGIS website](http://www.qgis.org/en/site/forusers/download.html). ## Loading and displaying the CSV supply To load and display CSV data in QGIS: 1. Open an existing project in QGIS or create a new one. 2. From the *Layer* tab, click *Add Layer* > *Add Delimited Text Layer…* or click ![Add Delimited Text Layer icon image](https://1897589978-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNpJpLP8RROUaWVQo5ea%2Fuploads%2FcO2ej7HLE1ll6RsOi2hD%2F4.png?alt=media) in the Manage Layers toolbar.

3. In the Data Source Manager | Delimited Text dialog: * File name: Click the ellipsis button (*…*), then navigate to and select the saved *outputfile.csv*. * File Format: Select *CSV (comma separated values)*. * Record and Fields Options: Select *First Record has field names*. * Geometry Definition: * Point coordinates: Select this option. 1. X field: Choose *Eastings* (or *EA* if the abbreviated column header was selected). 2. Y field: Choose *Northings* (or *NO* if the abbreviated column header was selected). 3. Geometry CRS: Select *EPSG:27700 – OSGB 1936 / British National Grid*. 4. Click *Add*.

QGIS Data Source Manager | Delimiter Text dialog.

*It may take a while for the data to load into the map pane. The result will look similar to the example below. OS Maps API Light 27700 was used as the background map for this example.*

QGIS UI showing loaded OS Open Names data in the map pane.

5. Save *outputfile* in the format of your choosing. *This will avoid having to repeat the process of geoprocessing outputfile.csv every time you need to use it.*

ArcGIS Pro

The following step-by-step instructions show you how to load OS Open Names CSV files into ArcGIS Pro. They were prepared using version 3.0. ## Loading and displaying the CSV supply To load and display CSV data in ArcGIS Pro: 1. Open ArcGIS Pro and create a new project. 2. In the Create a New Project dialog: * Name: Enter a project name. *Open\_Names in this example.* * Location: Browse to and select the location to which you want to save the project. * Create a new folder for this project: Leave this option selected (default setting). * Click *OK*.

3. When the project opens, add a background map for geographic context.\ \&#xNAN;*OS Maps API Light 27700 was added as the background map in this example.* 4. From the *Map* tab, click *Add Data* > *XY Point Data.*\

ArcGIS Pro UI showing the Map > Add Data > XY Point Data menu option. — ArcGIS Pro UI showing the *Map > Add Data > XY Point Data* menu option.

*A Geoprocessing pane will open to the right side of the map pane.* 5. In the Geoprocessing pane: * Input Table: Click ![ArcGIS Pro folder icon image](https://1897589978-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNpJpLP8RROUaWVQo5ea%2Fuploads%2F3i6x7uj1mDfDV8GruUCe%2F10.png?alt=media) to navigate to and select *outputfile.csv*. * Output Feature Class: This will auto-populate. * X Field: Select *GEOMETRY\_X* * Y Field: Select *GEOMETRY\_Y* * Coordinate System: Select *Current Map \[Map]*. \ \&#xNAN;*This will populate as British National Grid as OS Maps API Light 27700 map was added as a background map (step 3. above).*

ArcMap Pro Geoprocessing pane showing Parameters field options.

Click *Run* at the bottom right of the Geoprocessing pane.

ArcMap Pro Geoprocessing pane showing Run button and initialization progress. — ArcMap Pro Geoprocessing pane showing *Run* button and initialization progress.

It may take a while for the data to load into the map pane. The result will look similar to the example below.

ArcGIS Pro UI showing loaded OS Open Names data in the map pane. — ArcGIS Pro UI showing loaded OS Open Names dat in the map pane.

*This process results in the creation of a new file geodatabase in the new folder that was selected when the project was created (step 2. above).*

ArcMap

The following step-by-step instructions show you how to load OS Open Names CSV files into ArcMap. They were prepared using version 10.7.1. ## Loading and displaying the CSV supply To load and display CSV data in ArcMap: 1. Open ArcMap. 2. Click ![ArcMap Add Data button icon](https://1897589978-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNpJpLP8RROUaWVQo5ea%2Fuploads%2F7bWFH3FfSdKqAAMnOQEp%2F14.png?alt=media) (Add Data button) in the toolbar.

3. In the Add Data dialog, navigate to and select *outputfile.csv*, and then click *Add*.

4. The file will now display in the Table Of Contents.

5. Right-click *outputfile.csv* in the Table of Contents and select *Display XY data…*in the context menu.

ArcMap Table Of Contents showing the Display XY Data… action selected in the context menu. — ArcMap Table Of Contents showing the *Display XY Data…* action selected in the context menu.

6. In the Display XY Data dialog: * X Field: Select *GEOMETRY\_X* * Y Field: Select *GEOMETRY\_Y* * Coordinate System of the Input Coordinates: Select *British National Grid*. * Click *OK*.

* Click OK to close the warning dialog.\ \&#xNAN;*The Table Does Not Have Object-ID Field warning dialog alerts you to the fact that the resulting layer file is only a temporary table and needs to be saved (see step 7. below).*

ArcMap Table Does Not Have Object-ID Field warning dialog.

\ *It may take a while for the data to load into the map pane. The result will look similar to the example below. OS Maps API Light 27700 was used as the background map for geographic context.*

Figure 18: ArcMap UI showing loaded OS Open Names data in the map pane. — ArcMap UI showing loaded OS Open Names data in the map pane.

*To use the points in a meaningful way, you need to save the layer as a shapefile.* 7. To save the layer as a shapefile: 1. Right-click *outputfile.csv Events* in the Layers panel and then click *Export* in the context menu. 2. In the Export Data dialog, browse to and select a filename for the data, and then click *OK*.

ArcMap Export Data dialog showing selected shapefile.

\ \&#xNAN;*The shapefile may take a while to create. You can monitor the progress in the Export Progress window that opens automatically. This window will close when the export is complete.* 8. You will be given the option to add the newly created data to the workspace. Click Yes, to create a shapefile (and associated files) at the chosen location.

ArcMap alert dialog providing the option to add exported shapefile to the map as a layer.

MapInfo Pro

The following step-by-step instructions show you how to load OS Open Names CSV files into MapInfo. They were prepared using version MapInfo Pro 2019 (release build 58). ## Loading and displaying the CSV supply To load and display CSV data in MapInfo Pro: 1. Open MapInfo Pro. 2. Select *Open* > *Blank Workspace*.\

3. Add a background map for geographic context.\ \&#xNAN;*OS Maps API Light 27700 was added as the background map in this example.* 4. From the *HOME tab*, click *Open Table*.\

MapInfo Pro Home > Open Table action. — MapInfo Pro *Home > Open Table* action.

5. In the Open dialog: * Files of type: Change *MapInfo.tab* to *Comma delimited CSV (\*.csv)*. * Browse to and select *outputfile.csv*. * Click *Open*.\

MapInfo Pro Open dialog showing outputfile.csv selected. — MapInfo Pro Open dialog showing *outputfile.csv* selected.

6. In the Comma Delimited CSV Information dialog: * Delimiter: Ensure that *Other* is checked and that a comma is visible in the box next to it. * Check the *Use First Line for Column Titles* option. * Click *OK*.\

MapInfo Pro Comma Delimited CSV Information dialog.

\ \&#xNAN;*When the table has loaded, the outputfile Browser window will open. This may take a while*

MapInfo Pro outputfile Browser window — MapInfo Pro *outputfile Browser* window

7. To create the points from the table, from the *SPATIAL tab* click *Create* > *Create Points*.\

MapInfo Pro UI showing the Spatial > Create > Create Points action and the outputfile Browser window. — MapInfo Pro UI showing the *Spatial > Create > Create Points* action and the *outputfile Browser* window.

8. In the Create Points dialog: * Projection: Change this from Longitude / Latitude (WGS 84) to British National Grid \[EPSG:27700]. * *The easiest way to do this is to click the ellipsis button (to the right of the Projection field), press B on your keyboard 6 times, highlight British National Grid \[EPSG:27700] in the results, and then click OK.* * using Symbol: Optionally, change the symbol from a square (default style) by clicking the symbol button and following the instructions.\ \&#xNAN;*This example uses a red star that is more visible than the default square.* * Leave the other settings as they are (including Get X Coordinates from: *GEOMETRY\_X* and Get Y Coordinates from: *GEOMETRY\_Y*). * Click *OK*.\

*A progress bar will display and then close automatically when the geoprocessing is complete.*

MapInfo Pro geoprocessing Status dialog.

\ \&#xNAN;*When the process is complete, the points will display in the map pane in your chosen point style. The result will look similar to the example below:*

MapInfo Pro UI showing loaded OS Open Names data in the map pane.

\ \&#xNAN;*A .tab file (and associated .MAP and .ID files) is automatically created in the same folder as outputfile.csv. However, these are temporary files created as part of the point creation process and are difficult to query.* 9. To save the *outputfile* layer as a true .tab file: * From the *HOME* tab, click *Save* > *Save Copy As*. * In the Save Copy As dialog, select *outputfile* and click *Save As…*

MapInfo Pro Save Copy As dialog with outputfile selected. — MapInfo Pro Save Copy As dialog with *outputfile* selected.

* In the Save Copy of Table As dialog, navigate to the location where you would like to save the .tab file, name the file, select *MapInfo Extended (\*.tab)* in the Save as type field, and then click *Save*.

MapInfo Pro Save Copy of Table As dialog showing how to save outputfile as a true .tab file. — MapInfo Pro Save Copy of Table As dialog showing how to save *outputfile* as a true .tab file.

*A progress bar will once again appear and then disappear when the save has completed. The new .tab file, which is far easier to query, will now be available to use in MapInfo.*

Cadcorp SIS Desktop

The following step-by-step instructions show you how to load OS Open Names CSV files into Cadcorp SIS. They were prepared using version 9.0.2275.64 9 (build date July 17, 2020). ## Loading and displaying the CSV supply To load and display CSV data in Cadcorp SIS: 1. Open Cadcorp 2. From the File tab, click *New > Blank Map*.

Cadcorp UI showing the File > New > Blank Map action. — Cadcorp UI showing the *File > New > Blank Map* action.

3. Add a background map for geographic context:\ \&#xNAN;*Cadcorp has incorporated the OS Data Hub Web Map Tile Service into their Overlays*.
* Click *Add Overlay* > *Ordnance Survey (GB)* > *OS (GB) Data Hub* > *OS Maps API*. * In the OS (GB) Data Hub confirmation dialog, select: * *Yes,* to use the default Cadcorp AKI key. * *No,* to enter your own API key. * Click *Next.*

Cadcorp OS (GB) Data Hub dialog with the OS Maps API option selected. — Cadcorp OS (GB) Data Hub dialog with the *OS Maps API* option selected.

* Select your layer style and then click *Finish*.\ \&#xNAN;*There are four styles in two projections to choose from.*

Cadcorp OS Data Hub Maps API Layers dialog.

\ *You should now see the OS Maps API in your SIS Workspace Definitions.*

4. From the *Create* tab, click *Insert* > *Insert Points from CSV File.*

Cadcorp UI showing Create > Insert > Insert Points from a CSV File action. — Cadcorp UI showing *Create > Insert > Insert Points from a CSV File* action.

5. Browse to and select *outputfile.csv*, and then click *Next>*. 6. In the Database file dialog: * File Type: Select *Delimited.* * Click *Next*.

Cadcorp Database file dialog showing Delimited option selected. — Cadcorp Database file dialog showing *Delimited* option selected.

7. In the File format dialog: * Field Delimiter: Select *Comma*. * Select *First Row Contains Field Names*. * Click *Next*.

Cadcorp File format dialog showing Comma and First Row Contains Field Names options selected. — Cadcorp File format dialog showing *Comma* and *First Row Contains Field Names* options selected.

8. In the Database columns dialog, click *Next>*. 9. In the Recordset dialog, select which columns can be queried: * To select all columns, click *outputfile* in the Database Tables/Columns field and then click (forward icon).\ \&#xNAN;*This adds all columns to the Selected columns field on the right.* * Click *Next*.

Cadcorp Recordset dialog showing all output file columns in the Selected columns field.

10. In the View Points dialog: * X Field: Select *Geometry\_X*. * Y Field: Select *Geometry\_Y*. *The above settings determine which fields have your Easting and Northing.* * Click *Finish*. *You can view the points created counter on the bottom left of the dialog.*

Cadcorp View Points dialog showing Point Configuration field options.

\ \&#xNAN;*It may take a while for the table to load in the map pane. The result will look similar to the example below.*

Cadcorp UI showing loaded OS Open Names data in the map pane.

11. To make the points more visible: * Right-click *Imported outputfile* in SIS Workspace Definitions and then click *Properties* in the context menu. * In Geometry, select the *Override* checkbox next to the Pen, Brush and Symbol fields. * In Scale Overrides, change the entry in the Point field to *-0.1*.

Cadcorp Overlays dialog showing Styles tab options. — Cadcorp Overlays dialog showing *Styles* tab options.

\ \&#xNAN;*The points will now be visible and will look similar to the example below.*

Cadcorp UI showing loaded OS Open Names data with visible points in the map pane.