LESSON MENU | PREV LESSON | NEXT LESSON
Lesson 7 - Apply Place Type Using a Query
THE "APPLY PLACE TYPE USING A QUERY" TOOL ALLOWS YOU TO APPLY A PLACE TYPE TO A SCENARIO BY QUERYING DATA FROM THE DATABASE FILE (DBF) FROM THE ORIGINAL SHAPEFILE UPLOAD. THE STEPS BELOW OUTLINE HOW TO DO THIS USING PLACES. YOU SHOULD BE FAMILIAR WITH THE VALUES IN THE DATABASE BEFORE USING THIS FUNCTION.
1. From the Scenario Detail menu, click on "APPLY PLACETYPE USING A QUERY".
2. 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.
3. There are four columns listed on the page: field name, field type, operator and value:
  • 1. Field Name - The name of the field from the shapefile.
  • 2. Field Type - The data type for the field (number or character).
  • 3. Operator - The operator for your query: equals, greater than, less than, between, like, not like, not equal to.
  • 4. Value - The value or values for your query.
4. Let's say you want to develop all undeveloped parcels in Yuba City:
  1. Next to the field Current Place Type, select "EQUALS" from the 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 "Yuba City" 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".
5. 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.
6. 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.

7. Once you've verified that your results are correct:

1. Select the place type
2. Enter the % place type
3. Click "Apply Place Type"

It may take a few seconds for your query to apply. Tip: If you're applying multiple queries in a row, an easy way to check your indicators after each query is by having a second browser open. If you have the second browser open to the "Scenario Detail Menu" or "Development Type Acre Statistics", you can refresh that screen after each query you apply to see how the query affected your indicators.

8. One you've applied your query, a new page gives you the following options:
  • Go Back to the Scenario Detail Menu.
  • Apply Place Type Using Another Query.
  • Apply the Previous Query.
LESSON MENU | PREV LESSON | NEXT LESSON