Problem:  Create a map for the US Navy in San Diego, CA that shows the proposed natural gasline and related features.

Procedure Log:

Data:   ArcView Shapefiles provided by the US Navy
		
	landmarks.shp - Hospitals, schools, cemeteries and/or points of interest within vicinity of proposed natural gasline (point)
	ust.shp - Underground Storage Tank (UST) Sites (point)
	freeways.shp - Freeways within vicinity of proposed natural gasline (line)
	airports.shp - Airports located within vicinity of proposed natural gasline (polygon)
	military_installations.shp -  Military Installations located within vicinity of proposed natural gasline (polygon)
	water.shp - Bodies of water located within vicinity of proposed natural gasline (polygon)

	Map units for all shapefiles:  Meters

Use Select by Attributes to find US Hwy 163:
	
	Target layer:  freeways.shp
	Selection option:  Create a new selection
	Selection expression:  "HWYNAME" = 'US HWY 163'
	Result:  1 record selected from freeways.shp

Export the record for US Hwy 163 to a new shapefile named pipeline.shp:

	Target layer:  freeways.shp
	Method:  Right click the freeways.shp layer
		 Select Data-->Export Data
	Selection option:  Select features
	Selection option:  Use the Same Coordinate System as this layer's source data.
	Method:  Name the new layer 'pipeline.shp'
	Result:  New layer named pipeline.shp was created.

(Clear selections in freeways.shp before going any further with assignment.)

Use Select by Attributes to find Leaking Underground Storage Tank (LUST) sites:

	Target layer:  ust.shp
	Selection option:  Create a new selection
	Selection expression:  "SITETYPE" = 'LUST'
	Result:  76 records selected from ust.shp

Use Select by Location to find LUST's that are within 0.3 miles of the proposed pipeline:

	Selection option:  Select from the currently selected features in
	Target layer:  ust.shp
	Selection option:  are within a distance of
	Selection layer:  pipeline.shp
	Method:  Enter 0.3 miles as the buffer criteria
	Result:  22 records selected from ust.shp

Export the selected records from ust.shp to a new shapefile named lust.shp:

	Target layer:  ust.shp
	Method:  Right click the ust.shp layer
		 Select Data-->Export Data
	Selection option:  Select features
	Selection option:  Use the Same Coordinate System as this layer's source data.
	Method:  Name the new layer 'lust.shp'
	Result:  New layer named lust.shp was created.

(Clear selections in ust.shp before going any further with assignment.)

Use Select by Attribute to find schools located in the landmarks layer:

	Target layer:  landmarks.shp
	Selection option:  Create a new selection
	Selection expression:  "CFCC" = 'D43'
	Result:  299 records selected from landmarks.shp

Use Select by Location to find endangered schools that are within 2 miles of the proposed pipeline:

	Selection option:  Select from the currently selected features in
	Target layer:  landmarks.shp
	Selection option:  Are within a distance of
	Selection layer:  pipeline.shp
	Method:  Enter 2.0 miles as the buffer criteria
	Result:  59 records selected from landmarks.shp

Export the selected records from landmarks.shp into a new shapefile named e_schools.shp:

	Target layer:  landmarks.shp
	Method:  Right click the landmarks.shp layer
		 Select Data-->Export Data
	Selection option:  Select features
	Selection option:  Use the Same Coordinate System as this layer's source data.
	Method:  Name the new layer 'e_schools.shp'
	Result:  New layer named e_schools.shp was created.

(Clear selections in landmarks.shp before going any further with assignment.)

Use Joins and Relates to perform a spatial join on the endenagered schools layer with the proposed pipeline layer:

	Target layer:  e_schools.shp
	Method:  Joins from the Joins and Relates Menu
	Selection option:  Join data from another layer based on spatial location
	Selection layer:  pipeline.shp
	Selection option:  Each line will be given all the attributes of the point that is closest to it, and a distance field showing how close that point is (in map units).
	Output layer:  C:\Documents and Settings\User\My Documents\PRT462 Files\Assignment7 Folder\assign7revision\pipeschool.shp
	Result:  A 'virtual' layer is created named "pipeschool" which displays the joined data plus a distance field.

Use the Open Attribute Table to determine the name and distance of the endangered school that is farthest away from the proposed pipeline:

	Target layer:  pipeschool.shp
	Method:  Right-click the top of the "Distance" field column.
	Selection option:  Sort Descending
	Method:  Find the first record in the Attribute Table and find the name in the "NAME" field and find the distance in the "Distance" field.
	Result:  Glorietta School is the endangered school farthest away from the proposed pipeline with a distance of 3200.392837 meters.

Use Joins and Relates to perform a spatial join on the landmarks layer with the proposed pipeline layer:

	Target layer:  landmarks.shp
	Method:  Joins from the Joins and Relates Menu
	Selection option:  Join data from another layer based on spatial location
	Selection layer:  pipeline.shp
	Selection option:  Each line will be given all the attributes of the point that is closest to it, and a distance field showing how close that point is (in map units).
	Output layer:  C:\Documents and Settings\User\My Documents\PRT462 Files\Assignment7 Folder\assign7revision\pipeland.shp
	Result:  A 'virtual' layer is created named "pipeland" which displays the joined data plus a distance field.

Use the Open Attribute Table to determine the name and distance of the landmark that is closest to the proposed pipeline:

	Target layer:  pipeland.shp
	Method:  Right-click the top of the "Distance" field column.
	Selection option:  Sort Ascending
	Method:  Find the first record in the Attribute Table and find the name in the "NAME" field and find the distance in the "Distance" field.
	Result:  Snyder School is the landmark that is closest to the proposed pipeline with a distance of 52.705981 meters.

Use Open Attribute Table to add a field named "Distance" which will contain converted values from the "Distance field":

	Target layer:  pipeland.shp
	Method:  Click the "Options" Icon
	Selection option:  Float
	Result:  New field added named 'DistanceMi'
	Method:  Right-click the "DistanceMi" field
	Selection option:  Calculate values
	Selection expression:  [Distance] / 1609.344
	Method:  Click "OK"
		 Right-click the "DistanceMi" field
	Selection option:  Statistics
	Method:  The average distance is located beside the 'Mean:  ' string
	Result:  5.234618 miles is the average distance of landmarks to the proposed pipeline.

Use Select by Attributes to find all LUST's, not just those within 0.3 miles of the pipeline:

	Target layer:  ust.shp
	Selection option:  Create a new selection
	Selection expression:  "SITETYPE" = 'LUST'
	Result:  76 records selected from ust.shp

Export the selected records from ust.shp to a new shapefile named lust.shp:

	Target layer:  ust.shp
	Method:  Right click the ust.shp layer
		 Select Data-->Export Data
	Selection option:  Select features
	Selection option:  Use the Same Coordinate System as this layer's source data.
	Method:  Name the new layer 'lustall.shp'
	Result:  New layer named lustall.shp was created.

(Clear selections in ust.shp before going any further with assignment.)

Use Joins and Relates to perform a spatial join on the endenagered schools layer with the lustall layer:

	Target layer:  e_schools.shp
	Method:  Joins from the Joins and Relates Menu
	Selection option:  Join data from another layer based on spatial location
	Selection layer:  lustall.shp
	Selection option:  Each line will be given all the attributes of the point that is closest to it, and a distance field showing how close that point is (in map units).
	Output layer:  C:\Documents and Settings\User\My Documents\PRT462 Files\Assignment7 Folder\assign7revision\lustschool.shp
	Result:  A 'virtual' layer is created named "lustschool" which displays the joined data plus a distance field.

Use the Open Attribute Table to determine the name of the endangered school that is closest to a LUST:

	Target layer:  lustschool.shp
	Method:  Right-click the top of the "Distance" field column.
	Selection option:  Sort Ascending
	Method:  Find the first record in the Attribute Table and find the name in the "NAME" field.
	Result:  Saint Vincents School is the endangered school that is closest to a LUST.

Use Select by Location to find underground storage tank sites (LUST's and UST's) that are located on airports:

	Selection option:  Select features from
	Target layer:  ust.shp
	Selection option:  Intersect
	Selection layer:  airports.shp
	Result:  8 records selected from ust.shp

Use Open Attribute Table to switch the selection to show those underground storage tank sites (LUST's and UST's) that are not located on airports:

	Target layer:  ust.shp
	Method:  Click the "Options" icon
	Selection option:  Switch selection
	Result:  174 Records selected from ust.shp

Export the selected records from ust.shp to a new shapefile named usnotairport.shp:

	Target layer:  ust.shp
	Method:  Right click the ust.shp layer
		 Select Data-->Export Data
	Selection option:  Select features
	Selection option:  Use the Same Coordinate System as this layer's source data.
	Method:  Name the new layer 'usnotairport.shp'
	Result:  New layer named usnotairport.shp was created.

(Clear selections in ust.shp before going any further with assignment.)

Use Select by Location to find underground storage tank sites (LUST's and UST's) that are located on military installations:

	Selection option:  Select features from
	Target layer:  ust.shp
	Selection option:  Intersect
	Selection layer:  military_installations.shp
	Result:  1 record selected from ust.shp

Use Open Attribute Table to switch the selection to show those underground storage tank sites (LUST's and UST's) that are not located on military installations:

	Target layer:  ust.shp
	Method:  Click the "Options" icon
	Selection option:  Switch selection
	Result:  181 Records selected from ust.shp

Export the selected records from ust.shp to a new shapefile named usnotmilitary.shp:

	Target layer:  ust.shp
	Method:  Right click the ust.shp layer
		 Select Data-->Export Data
	Selection option:  Select features
	Selection option:  Use the Same Coordinate System as this layer's source data.
	Method:  Name the new layer 'usnotmilitary.shp'
	Result:  New layer named usnotmilitary.shp was created.

(Clear selections in ust.shp before going any further with assignment.)

Use Joins and Relates to Join the usnotairport layer with the usnotmilitary layer:
	
	Target layer:  usnotairport.shp
	Selection option:  Join attributes from a table
	Selection option:  SITENAME
	Selection layer:  usnotmilitary.shp
	Selection option:  SITENAME
	Result:  usnotmilitary.shp is joined to usnotairport.shp

Use Open Attribute Table to find out the number of underground storage tank sites (LUST's and UST's) that are not on either military installations or airports:
	
	Target layer:  usnotairport.shp
	Method:  Take note that there are 174 records in the joined table (excluding the 8 records that are not located on airports
		 Right-Click on any usnotmilitary field (i.e. usnotmilitary.LONGITUDE)
	Selection option:  Sort Descending
	Method:  Notice that the top record (LINBERGH FIELD, FID#46) has no information from the usnotmilitary table joined to it.
		 Therefore, this record (LINBERGH FIELD, FID#46) was located on an military reservation.  This means that one record is subtracted from the total of 174 records that weren't located on an airport.
	Result:  173 records are not located on either a military installation or an airport. 

Use Select by Attributes to find Schools in the Landmarks layer:
	
	Target layer:  landmarks.shp
	Selection option:  Create a new selection
	Selection expression:  "CFCC" = 'D43'
	Result:  299 records selected from landmarks.shp

Export the selected records from the landmarks layer to a new shapefile named allschools.shp:

	Target layer:  landmarks.shp
	Method:  Right click the landmarks.shp layer
		 Select Data-->Export Data
	Selection option:  Select features
	Selection option:  Use the Same Coordinate System as this layer's source data.
	Method:  Name the new layer 'allschools.shp'
	Result:  New layer named allschools.shp was created.

(Clear selections in landmarks.shp before going any further with assignment.)

Use Select by Location to find schools that are within 5 kilometers from a freeway:

	Selection option:  Select from the currently selected features in
	Target layer:  allschools.shp
	Selection option:  Are within a distance of
	Selection layer:  freeways.shp
	Method:  Enter 5.0 kilometers as the buffer criteria
	Result:  291 records selected from allschools.shp

Use Open Attribute Table to switch the selection to show the schools that are more than 5 kilometers from a freeway:

	Target layer:  allschools.shp
	Method:  Click the "Options" icon
	Selection option:  Switch selection
	Result:  8 Records selected from allschools.shp