##### Child pages
• Assignment - Basic Queries
Go to start of banner

# Assignment 6 - Basic Queries(10 points)

Go to start of metadata

You are viewing an old version of this page. View the current version.

Version 28

# Assignment 6 - Basic Queries

### Format: Text or PDF document. Place on Student Work Zone section of the wiki or turn in by 5pm to Barbara's mailbox, UEP office, 97 Talbot Ave

The purpose of this assignment is for you to learn and practice some of the basic queries you can perform with GIS.

In this assignment, you need to perform an analysis in which you use all of the following, in any order or in combination - there are tip sheets for each of these functions on our GIS Resources - Tip Sheets wiki (see the sections: Working with Tables and Basic Query Functions):

• Select by attribute
• Select by location
• Statistics for selected features
• Summarize by an attribute field value
• Field Calculator or Geometry Calculator
• Optional: Spatial Join (for aggregating point information by polygons)

For example, you could use these tools to analyze parcels in Boston which meet certain conditions for redevelopment based on their attributes and their location relative to other features or demographics, and to prioritize these according to some criteria. Or using MassGIS data you might look for potential land acquisition areas that would serve both environmental ends and provide open space for currently underserved communities. Or you may want to look at what sections of a community may be most vulnerable to a natural or man-made disaster based on census demographics, living/working in hazardous areas, and distance from emergency response facilities and evacuation routes.

It would be ideal to do this assignment as a mini-test of a project idea or at least using data you are likely to use in your project.  If more applicable, use data we have in-house or that you can download online.  But keep it very simple for this assignment! If you have trouble thinking of something, talk to the instructor or TA - we are brimming with ideas.

#### What to turn in:

Turn in a brief report that includes the following:

• The goal of your analysis
• The steps you went through (i.e., the queries you performed, in order) - you may use graphics to explain if you like
• A map or maps that show the results along with summary table(s) you create
• A note on why the results of your analysis are or might be incorrect (e.g., a caveat to someone reading or wanting to use these results)

#### Tips for the assignment

You can use Snag-It to  "snag" graphics of your map or maps and put them in your write up with an explanation of what they are showing - you don't necessarily need to do a full-blown stand-alone map of the same quality as earlier assignments.  Same with tables showing the results of summarizing, or showing statistics - just use Snag-It or the Print Screen function on your computer (press CTRL and PRNT SCRN at the same time, then paste into a Word document).

Finally, if the selection tools aren't working as they should, try closing out of ArcMap and only loading the layers from which you are selecting. ArcGIS seems to sometimes just get tired or to run out of memory or something, especially if you have a lot of layers up. Start fresh with just he layers you need for the assignment and it should work.

E-mail the instructor and TA if you have problems!

• No labels