Hi all, I hope some one can help with this query.
I have two polygon tables called.. 1. parcel 2. zones The zones table contains a copy of ALL polygon objects in the parcel table, as well as copies of ALL polygons from other tables such as road segments, railway land etc. It also contains fields for Zoning (Rural, Roads_Rural, Residential, Commercial...etc) and Class (Rural or Urban) Read the SQL query below and then please advise what can solve the following problem. Select * From PARCEL, ZONES where PARCEL . obj entirely within ZONES . obj and ZONES . CLASS like "%RURAL%" into ZONES_PROPERTY_RURAL The problem occurs where a parcel object contains a hole in the polygon. These objects don't get selected with the above statement. Basically I am trying to get the computer to select the parcels required, on the fly, when it opens the workspace so if the zoning laws change (e.g. due to road realignments), I don't have to look for work to do (hey, I'm lazy, I admit it!) I'm nine yards there, can anyone help me get the last 36 inches. (Will post solutions) James Torrie Assets Engineer Rangitikei District Council 06 327 8174 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11471
