Skip to main content
Solved

Compare zoning of parcels in two Oracle databases

  • October 18, 2012
  • 1 reply
  • 13 views
fmelizard
Safer
Forum|alt.badge.img+21
I have an Oracle database with a parcels layer and a zoning layer. I also have another Oracle database with parcels table and an "attributes" table containing which zone applies to which parcel.

 

 

I want to use the relationship between the two layers to compare with the "attributes" table and produce a list of records to correct, based on the assumption that the map layers are correct.

 

 

I've tried the AreaOnAreaOverlayer and the Clipper transformer without success.

 

 

What method would you recommend to efficiently achieve the correct result?

Best answer by kathyross

Hi Steve,

 

 

I'd likely recommend using a SpatialFilter to first determine which Parcel is in which Zone.

 

 

To locate whether the attributes table contains the correct Zone per parcel, perhaps try the FeatureMerger transformer.

 

 

Wish you well.

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

K
Forum|alt.badge.img+4
  • kathyross
  • Best Answer
  • October 19, 2012
Hi Steve,

 

 

I'd likely recommend using a SpatialFilter to first determine which Parcel is in which Zone.

 

 

To locate whether the attributes table contains the correct Zone per parcel, perhaps try the FeatureMerger transformer.

 

 

Wish you well.

 

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.