Query to extract parcel data

[ralston]

What is the best way to extract land owner records from an Access file containing tax records that are linked to a map with polygons containing the Key_ID? I have created topology for the permit area and the for land parcels, and they can be linked. How do I set up the query to only extract those owners that have any part of their land within the permit boundary? The end result should be an Access table containing the sub-set of data for the permit.

Thanks!
Dave Ralston
Soil Tech, Inc.

[mjfarrell]

What is the best way to extract land owner records from an Access file containing tax records that are linked to a map with polygons containing the Key_ID? I have created topology for the permit area and the for land parcels, and they can be linked. How do I set up the query to only extract those owners that have any part of their land within the permit boundary? The end result should be an Access table containing the sub-set of data for the permit.

Thanks!
Dave Ralston
Soil Tech, Inc.

You need to drag your data source (Access file) into your MAP that contains those parcels
and create a Link Template, and then actually link the data to the cad objects.
Then in the MAP session you are creating the map you wish to publish this data in.
you will attach this source drawing with the linked data, and draw a polygon (polyline)
around your area of interest and use that polygon as your query boundary when you
specify the LOCATION portion of the query.

Dave it sounds like you are ready for a good MAP class to let you really harness
it's powers. You appear to be off to a decent start, and ready to have a Sherpa
guide you the rest of the way to the top.

8)

[ralston]

Michael,
Thanks again for taking the time to help me learn how to navigate Map! I continue to have problems understanding how to write Queries. There are so many options to select from that it is frustrating to try all the possibilities. My biggest problem was pointing the Query to the Link table and formatting the output report to include the correct columns. Anyway it finally worked.
Yes, I do want to take another class on Map. What do you recommend? I have had to cancel my AU trip this year, since my main client has set a deadline during the first week of Dec. that I cannot miss.
Thanks again!

Dave Ralston
Soil Tech, Inc.

[mjfarrell]

Dave,


The best approach to take with query creation is this:

First do a preview query of an ALL condition.
Ask yourself from WHERE in the attached
source drawings are you administering the data
or creating maps from them. And define a boundary
over this preview query as needed.

Then ask yourself WHAT properties make the objects you
are trying to modify, or create a topology from for example
before hitting the Properties button.
This is to limit the size of the working set, understand that as you
query the previously quired objects are not duplicated into
the map session.

Then ask where is the DATA coming from? In regards to
whether the objects have any intelligence at all.
If you are ready for SQL statements you don't need a class
from me :roll:

In the area of property Alteration queries.
Probably the biggest leap from CAD to this
type of data management is the use and
creation of range tables, to help perform a
multitudinous alteration in a single property
altering query statement.