A]Managing Data Tables and Spatial data Sets: Table joins, spatial joins, points in polygon analysis, performing spatial queries.
Ans)
a. Table joins
Step 1: Layer->Add layer->Add vector layer
  
Step 2: vector datasets (t12013-06-tract.shp)
  

Output: 
  


Step 3: Layer->Add layer-> Add Delimited Text Layer
  
 
Step 4: file name (tl_2013_06_tract)->Geometry Definition (No geometry)->change the datatype of GEO.id2 to Text(string)
  
 
Output:
  
Step 5: Right click on layer->open attribute table
  
 
Output:
  
 
Step 6: Right click on layer->properties
  
 
Step 7: joins-> click on + sign 
  
 
Step 8: Join layer(ca_track_pop)->join field (GEO.id2)->Target field (GOEID)->ok
  
After Adding:
  

Step 9: right click on layer-> open attribute table
  
 
Output:
  
 
Step 10: Right click on layer-> properties
  
 
Step 11: symbology->Graduated-> value (ALAND)-> color ramp (blue)-> mode (Equal Interval)->click on classify->apply->add
  
 Output:

b. Spatial joins
Step 1: Layer-> Add layer->Add vector layer
  
 
Step 2: Vector dataset (OEM_NursingHomes_001)->add
  
 
Output:
  
 
Step 3: Add second layer (nybb_12c)->add
  
 
Output: 
  
 
Step 4: vector-> Data Management Tools->Join Attributes by location
  
 
 
Step 5: Join to features in (nybb_12c)-> features they (intersect, overlap, equal)->by comparing to (OEM_NursingHomes_001)->Fields to add(select all )->run
  
 
Step 6: Right click on joined layer-> open attribute table 
  
 
Step 7: click on identify features
  
 
Step 8: Select one area 
  
 


c. points in polygon analysis
step 1: Layer->Add layer->Add vector layer
  
 
Step 2: vector datasets (ne_10m_admin_0_countries)->add
  
 
Output:
   
Step 3: Layer-> Add layer-> Add Delimited Text Layer
  
 
Step 4: file name (earthquakes.csv)->Geometry Definition (Point Coordination)->add
  
 
Output:
  
 
Step 5: vector-> Analysis Tools->Count points in polygon
  
 
Step 6:  Polygon (ne_10m_admin_0_countries)->points (earthquakes)->count field name(NUMPOINTS)->run
  
Step 7:  right click on count layer->open attribute table->check earthquake count
  
 
Step 8: Identify Features
  
 
Step 9: Select area where you want to check earthquakes counts
  

d. performing spatial queries
step 1: Layer->Add layer->Add vector layer
  
Step 2: vector datasets (ne_10m_populated_places_simple )
  
Output:
  
Step 3: Add another vector layer (ne_10m_rivers_lake_centerlines)->add
  
 
Output: 
  
 
Step 4: vector->Geoprocessing tools->buffer
   
Step 5: Input layer (buffered)->Distance (0.50)->run
  
 
Output:
  
 
Step 6: vector->Research tools->select by location
 
Step 7: Select features from (Buffered)->where the features(intersect, touch, overlap)->By comparing to the features from (ne_10m_populated_places_simple)->run
  
 
Output: 
