1

I am a beginner at GIS/ArcGIS and have a quick question about locating a field in an attribute table of a feature using SQL. Attached is an image of a (crude) example of the kind of attribute table I am working with, but in Excel instead of in ArcGIS. I am looking to find a specific data point of one city/one demographic group. More specifically, I am attempting to find the records that match a specific value (or value range) in a field that I already know the name of. I know the column/row name, I just need to find the specific value given these two names. For example, how I would I find the population under 10 years of age in New York? I know that doing "City" = 'New York' in the SQL box will highlight the entire row in the attribute table, but I am not sure how to find a specific text field within a row.

enter image description here

Improve this question
3
  • Hello! I am attempting to find the records that match a specific value (or value range) in a field that you already know the name of (the column/row name) and I clarified that in my question. I know the column/row name (for example, "New York" and "Pop. Under 10 Years") and am looking to find the value that intersects those two. Thanks!!
    – Rachel
    Mar 20 at 22:30
  • Depending on what you really want..."City" = 'New York' AND "Pop_Under_10_years" = 11 or "City" = 'New York' OR "Pop_Under_10_years" = 44 (Note that your field name may not be what I've written here, but you have to use the real field name, not the field alias).
    – Son of a Beach
    Mar 20 at 22:58
  • Thank you, that helps clarify!! I appreciate it.
    – Rachel
    Mar 20 at 23:49

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.