Hi Bill, Sorry if this isn't exactly correct; I'm writing from an extremely slow laptop with no access to FME. You should be able to accomplish your required result without using the tblDoc table at all, though you may wish to link to it later... First, add the Parcel shapefile and tblParcelDoc to the workspace as data sources. Next, run them through a FeatureMerger, with the Parcel stream as the Requestor and the tblParcelDoc stream as the Supplier. Make sure to specify a list to write 1:m relationship data to. Next, take the Complete (and incomplete?) output ports and connect them to a single ListExploder. This will create a single feature for each match in the above FeatureMerger. Finally, run the output of this through a Dissolver to remove interior lines and optionally an Aggregator if you want to form regions for disjoint DocNum parcels. If you have any donut polygons, you may have to build a process to account for these as the Dissolver (I think) doesn't dissolve donuts. Which is why it's not called the Coffee transformer. Let me know if I misunderstood the initial question; I think this should work. Jason -- Jason Birch, Sr. Applications Analyst Information Technology Office, City of Nanaimo 455 Wallace St., Nanaimo, BC, Canada, V9R 5J6 Phone: (250) 755-4460 Extension 250
________________________________ From: [email protected] on behalf of Bill Voigt Sent: Mon 2005-09-19 5:55 PM To: [email protected] Cc: Raymond Kinser (E-mail) Subject: [fme] Queries for shapefiles and attributes Here's a challenging project that I can't figure out how to solve in FME 1. I have a parcel shapefile with APN (Assessor Parcel Number) 2. 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 3. I have a table tblDoc with a uniuqe field [DocNo] with other attributes pertaining to the document 4. 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 <http://groups.yahoo.com/group/fme> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . ________________________________ 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
<<winmail.dat>>
