The downloading of data from SWAD and SPA Database
into ArcView was tested on ESRI® ArcView GIS 3.2. If you have any
problems please contact Anthony
, your computing support or ESRI
For instructions on using ArcMap click here
These instructions assume a basic knowledge about ArcView. Note that
if you have a choice we recommend that you use ArcMap, as it is far
simpler to import text files and use the hyperlink tool than in ArcView.
Instructions on importing sites into ArcView GIS
|Downloading data from SWAD and SPA Database:
- First search either the SWAD or SPA Database. This should produce
a list of sites, at the base of which will be an option to download
a file that can be imported into either ArcMap or ArcView.
- Choose the ArcView option and click on the download file button.
After a short pause a dialogue box will appear asking whether you
wish save a file called arcviewfile.txt to disk.
Click on the OK button and save the file to an appropriate
folder. You can rename the file to whatever you want, but keep the
.txt suffix. (Note that file you have downloaded
contains a list of files with XY coordinates as Ordnance Survey northings
|Importing arcviewfile.txt into ArcView:
- Open a new or existing Project in ArcView.
- If a new Project, load a map of Scotland or the part of Scotland
you are interested in (for help on this see ArcView help files or
- The map of Scotland should now be displayed in the View1 window.
- Highlight Tables in the Table of Contents
window and click on Add button. An Add Table
dialogue box will appear. Change the List of Files of Type
to Delimited Text (*.txt) and select the appropriate
file to load. Click OK.
- A new window will appear displaying the contents of the file. Close
- Click on the View1 window containing the map fo
- Click on View on the menu at the top of the page
and select Add Event Theme.
- Choose the file you have just downloaded and select the X
field to be Eastings and the Y field
to be Northings. Click
- A new Theme (the file you have imported) will appear
in the legend in the View window. Click on the new
theme so that a tick appears. The sites in the downloaded file will
appear on the map.
|Loading a script into ArcView so that Hot Links can be used:
- In order to use the Hot Link feature in ArcView a script needs to
be loaded. This tells ArcView to launch your default web browser when
you click on a point. This script needs to be loaded into each new
- Click on Scripts in the Table of Contents window and then click
- A new window called Script1 will appear.
- Copy the following text (from theVal to the second
end) and paste it into
the Script1 window. You will need to replace the red
and bold text with the location of your web browser.
In the example below, Internet Explorer is launched, but this could
be Mozilla, Opera or whatever.
theVal = SELF
' see if the value of the field is not null
'trim "/" off the end of hyperlinks
number i = theVal.Count
theValTrim = theVal.Left(i-1)
if (not (theVal.IsNull)) then
' if the file listed in the field exists, then run browser
if (File.Exists(theVal.AsFileName)) then
' use the path to the video player executable
System.Execute("C:\Program Files\Internet Explorer\iexplore.exe" ++theValTrim)
' if the file doesn’t exist, tell the user
MsgBox.Warning("File "+theVal+" not found.","Hot Link")
- Once you have completed the script, click on Script
in the menu at the top of the page and click on Compile.
- Close the script window.
- You can rename the script if you like by highlighting the script
in the Table of Contents window and pressing "Control
+ R" or going to Properties on the
|Link the theme (imported file) to the script:
- Click on the theme (the file you imported) in the legend in View1.
- Click on Theme menu at the top of the page and select properties.
A new wndow will appear.
- For Field select Url, for Preferred
Action choose Link to User Script and for
Script click on the button to the right of the text
box. Choose script1 or whatever the script is called and click OK.
Click OK again to close the window.
|Select a point a query SWAD or SPA Database:
- Click on the Hot Link button
on the tool bar at the top of the page.
Your cursor will change to a jagged line.
- Click with the lefthand mouse button on the site on the map you
want more information. Your browser should be automatically launched
and the results of your search displayed.