topic [easy] How to extract specific information from database in ArcMap? in ArcGIS Online Questions

[easy] How to extract specific information from database in ArcMap?

TanyaBurman — Wed, 12 Feb 2014 21:05:50 GMT

Hey Everyone,

I have a file called list of schools in Toronto city (please see the screenshot)[ATTACH=CONFIG]31382[/ATTACH] So, the elementary schools have the word "EP" at the end of the school name. (the middle school has "MP" and high schools have "HP"). I have to find
the number of elementary schools.
Please note: the word "EP" is not always in bracket and some schools have not mentioned their status(as in elementary/middle/high).

Any help would be appreciated!
Thanks

Re: [easy] How to extract specific information from database in ArcMap?

TimWitt — Thu, 13 Feb 2014 11:10:28 GMT

Tanya,

You could use a select by attributes query. It should look like the following:

NAME LIKE '%EP%'

This should give you all the schools that have EP in them. You might need to look over the selection to wheat out schools that have 'ep' in their name.

Once you have your clean list, you can just read the number off your attribute table 🙂

I would recommend to add a field called TYPE and use the field calculator to fill in EP, with this you can do this process a lot faster next time.

Hope this helps!

Tim