1 / 12

ArcGIS Queries

ArcGIS Queries. Maneesh Sharma West Virginia GIS Technical Center Department of Geology and Geography West Virginia University Morgantown 26505 Maneesh.Sharma@mail.wvu.edu. Overview. Queries in feature classes Attribute Query Demonstration Location Query Demonstration

jerom
Download Presentation

ArcGIS Queries

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ArcGIS Queries Maneesh Sharma West Virginia GIS Technical Center Department of Geology and Geography West Virginia University Morgantown 26505 Maneesh.Sharma@mail.wvu.edu

  2. Overview • Queries in feature classes • Attribute Query • Demonstration • Location Query • Demonstration • Query in Data driven Pages • Dynamic query • Demonstration • Questions

  3. Queries in a feature class • Attribute Query • “A query that extracts data/features from a layer based on the value of its attribute data” • Query can be • Simple query • Compound query • Subquery

  4. Simple Query • A query expression needs 3 components • Attribute Field Operator Field Attribute Value "AssessedAcres" >=0.19 • The result will show a set of selected features

  5. Simple Query • Different types of operators can be used • Calculations can be done • "AssessedAcres" >=0.12*100 Or "Perimeter" >="Acres" *10

  6. Compound Query • Multiple attribute and operators can be used to create compound query • Complex expressions can be created by using AND or OR "Perimeter" >=7361.83or"Acres" <=0.35

  7. Subqueries • A subquery is a nested query • Supported just by geodatabase data sources only • Will NOT work with shapefiles "Entity" NOT IN (SELECT"ENTITY"FROMBLDTYPES2) • Demonstration

  8. Location Query • A location query is based on their location relative to other features that meet certain conditions • Main types • Near • Intersect • Inside

  9. Location Query • Three things needed for query • Layer that contains features you want to select • Location relationship that needs to be analyzed • Layer that contains related features • “Building types within 2000 ft of selected parcel” • Demonstration

  10. Query in Data Driven Pages • Each layer can take advantage of the Data Driven Page setup • Layer has to have the page number from the index layer associated with the features • By setting the Page Definition by using page number, you can show or hide each feature on the map

  11. Query in Data Driven Pages • Demonstration

More Related