topic Re: query to select objects in an area bounded in Geoprocessing Questions

query to select objects in an area bounded

MikeHenson — Thu, 16 Oct 2014 18:13:53 GMT

really needing help with this. See the attached image. I have subdivisions represented by polygons, and within those polygons, I have more data representing sewer lines. I need to query certain size lines, within the subdivision polygon and am not sure which geoprocessing tool to use.

For example.....looking at the image.....how would I query 6" sewer lines with the North Hills Subdivisons. Each set of data, (sewers and subdivisions) are in separate shape files.

Any guidance you folks could give would be greatly appreciate.

Re: query to select objects in an area bounded

CoryMacNeil1 — Thu, 16 Oct 2014 18:24:18 GMT

Hi Mike,

I would start by doing a Select by Attributes and select all of your sewer lines with an attribute value of 6". Perform a definition query on the subdivision layers for where the subdivision name equals North Hills Subdivisions. Then you can do a Select by Location (based on the selected features) that intersect (or completely contains or has their centroid in; whatever you think suits your scenario the best) the North Hills Subdivisions.

I hope this helps.

Cory

Re: query to select objects in an area bounded

MikeHenson — Thu, 16 Oct 2014 18:56:02 GMT

Cory….thanks for those great steps. I have one issue, and I’m sure its on me, not you! As I do the select by location (based on the selected features) that intersect, it is picking up all pipe sizes, not just the 6” that was in the previous selection. Any ideas? Thanks

Re: query to select objects in an area bounded

DanPatterson_Retired — Thu, 16 Oct 2014 18:58:13 GMT

Query using select by attributes to select the pipe size that you want first...then proceed...you are given options to select from the selected set or similar wording, but in general, make general selections/queries first, then move on to your remaining processes

Re: query to select objects in an area bounded

MikeHenson — Thu, 16 Oct 2014 19:36:48 GMT

I appreciate everyones help but I am still missing something. I set up to view only "North Hills" subdivision under that layers properties.

I then did a select by attribute, selecting only 6" pipe. See image 1.jpg (only 6" pipe selected)

then I did a select by location, using the selection set of sewer lines, intersecting with the subdivision layer. See image 2.jpg.

See Image 3.jpg as the result. 8" pipe is then selected along w/ 6"

Re: query to select objects in an area bounded

CoryMacNeil1 — Thu, 16 Oct 2014 19:44:16 GMT

Hi Mike, try changing your Selection Type from NEW_SELECTION to CURRENTLY SELECTED (or something similar to that.

Cheers,

Cory

Re: query to select objects in an area bounded

CoryMacNeil1 — Thu, 16 Oct 2014 19:49:47 GMT

Hi Mike,

Take a look at my Select by Location Window. Notice that the Selection Method is set to ‌select from the currently selected features in‌

Re: query to select objects in an area bounded

DanPatterson_Retired — Thu, 16 Oct 2014 19:52:21 GMT

you missed.... ...you are given options to select from the selected set or similar wording,....

Re: query to select objects in an area bounded

MikeHenson — Thu, 16 Oct 2014 19:56:31 GMT

how about "subset". See attached image. Also, I'm a bit concerned that I may be using a different tool than you. Mine says "select layer by location" and your says "select by location"

Re: query to select objects in an area bounded

CoryMacNeil1 — Thu, 16 Oct 2014 19:58:09 GMT

SUBSET_SELECTION should work. You can use the Selection menu at the top of the screen and when you do the Select By Location option becomes available. Essentially the same thing.

Re: query to select objects in an area bounded

DanPatterson_Retired — Thu, 16 Oct 2014 19:58:42 GMT

same thing...give it a try..try it through arctoolbox, and also through the main menu, they are essentially the same just different visually etc.

Re: query to select objects in an area bounded

MikeHenson — Thu, 16 Oct 2014 20:00:51 GMT

I have just been doing a search and found it there. Sometimes I am not sure where to drill down to find a tool!

MKH

Re: query to select objects in an area bounded

MikeHenson — Thu, 16 Oct 2014 20:05:58 GMT

Cory and Dan....I appreciate you guys staying with me on this! I would be lost without the help of the forum. Many thanks!

Re: query to select objects in an area bounded

DanPatterson_Retired — Thu, 16 Oct 2014 20:15:42 GMT

good luck and keep at it

Re: query to select objects in an area bounded

CoryMacNeil1 — Fri, 17 Oct 2014 11:53:29 GMT

No problem Mike. That is what the forums are for. There are a lot of tools available, even people who have been working with the software for a long time don't know all of them. Sometimes you just have to find time to play around and explore what is available.

Cheers,

Cory