Here's a challenging project that I can't figure out how to
solve in FME
- I have a parcel shapefile with APN (Assessor Parcel Number)
- I have a table tblParceDoc containing two fields: APN and DocNo. The latter field is a reference to a Record map, survey, or parcel map. A single parcel may have serveral different documents, a given document may cover several parcels
- I have a table tblDoc with a uniuqe field [DocNo] with other attributes pertaining to the document
- Here is the relationship between the tables
Parcel
tblParcelDoc tblDoc
[Shape]
[APN] <-----1 to M--------> [APN]
[DocNo] <----M to 1 --------------> [DocNo]
What I'd like to get is a UNION of all parcel shapes for
each unique [DocNo]
In Arcview, I can link the three and for each record selection
in tblDoc, select all parcels in the shapefile. I can manually do a Union
for each
shape, but this is obviously not an efficient method.
Any advice would be appreciated.
--Bill
William G Voigt
(415) 485-3366 voice
GIS Analyst
(415) 485-3334 fax
Dept Public
Works 111 Morphew St
City of San Rafael San Rafael, CA 94901
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details.
YAHOO! GROUPS LINKS
- Visit your group "fme" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
