LESSON MENU | PREV LESSON | NEXT LESSON
Lesson 12 - Scenario Sub-Area Query Menu
THE "SCENARIO SUB-AREA QUERY MENU " TOOL ALLOWS YOU TO CREATE A VIRTUAL SUBAREA USED FOR GENERATING SCENARIO STATISTICS. YOU CAN CREATE A SUBAREA BY QUERYING DATA FROM THE DATABASE FILE (DBF) FROM THE ORIGINAL SHAPEFILE UPLOAD. THE STEPS BELOW OUTLINE HOW TO DO THIS USING PLACES.
1. From the Scenario Detail menu, click on "SCENARIO SUBAREA QUERY MENU".
2. The resulting page will show a list of all subarea query layers for the current scenario. To create a new subarea query, click "Create a New Subarea Query".
3. The resulting page will show a list of all the fields that were part of the orginal uploaded shapefile. Current Place Type, Current Development Percent and Place Type FAR (Floor-Area-Ratio) are also included. This enables you to find parcels based on their place type, place type percent or place type FAR as they are currently marked in Places.
4. There are four columns listed on the page: field name, field type, operator and value:
  • Field Name - The name of the field from the shapefile.
  • Field Type - The data type for the field (number or character).
  • Operator - The operator for your query: equals, greater than, less than, between, like, not like, not equal to.
  • Value - The value or values for your query.
5. Let's say you want to find all undeveloped parcels in the city of Davis:
  1. Next to the field Current Place Type, select "EQUALS" from he operator drop-down.
  2. Select "Blank Place Type" from the value box.
  3. Next to the field CITY_NAME, select "EQUALS" from the operator drop-down.
  4. Enter "Davis" in the value box.
  5. Next to the field DEVLEOPED, select "NOT EQUAL TO" from the operator drop-down.
  6. Enter "X" in the value box.
  7. Click "Perform this Query".
6. The resulting page will give you the total number of parcels found that match your query parameters. Below that, you will also see all of the field data for the first 20 parcels found matching the query (you will likely have to scroll to the right to see all of the data). You can view more than the first 20 records by clicking on the link for 50 / 100 / 500 results. It will take some time to display a larger number of results.
7. You can view the query results on the map by clicking "View Query Results on Map". You can then zoom and pan around on the map to ensure your query is correct.
8. Once you've verified that your results are correct, select a Subarea Name for your query and then click "Create Subarea".
9. Your new subarea query will now show up in the subarea query list. From here, you can mark whether the subarea query will be available for viewing on the map.
10. You can click "View Subarea Statistics" next to the subarea query to see scenario statistics for those parcels included in your subarea query.
Tip: If you change the Place Type of a parcel(s) in the subarea query so that it doesn’t match the original parameters of the query, the parcel(s) will no longer be part of the subarea query. For example: If you mark a Place Type on one of the parcels from the subarea query in step 5, that parcel will be removed from the subarea query because it no longer fits the parameter "Current Place Type" EQUALS "Blank Place Type". That parcel will not be calculated into the subarea’s scenario statistics.
LESSON MENU | PREV LESSON | NEXT LESSON