Hi Jarkko,
I believe the answers to most of your questions can
be found in the Polygon and Advanced Oracle Extension Help (the question mark on
the Extension tool bar). You asked "what does unbalanced Mpolygon
actually mean?", from the Help file:
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">
face=Arial size=2>Balancing - Process where the polygon object recalculates
which boundaries are outer or inner. Boundaries are designated as inner or outer
when the polygon is created and when new boundaries are added to the
object.
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">
face=Arial size=2>
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">
face=Arial size=2>You can edit the polygon object to rebalance it and then you
should be able to export to Oracle. Please see Mpolygon>Rebalancing in
the Autodesk Map Polygon and Advanced Oracle extension Help.
Regards,
Andrea Bell
GIS Product Support
Technician
> Hi all!
>
> I
have a problem with "Polygon and Oracle extension".
> I have several
thousands (30 000+) of lines and arcs imported from an
> old Finnish GIS
application called FinGIS. Those lines and arcs define
> 4200+ areas.
Some areas are inside the others.
> FinGIS' data was divided into 1sqkm
files and it had to cut the lines on
> the file borders and calculate new
endpoints for the resulting lines.
> Sometimes this resulted as a small
(1mm) gaps between the lines. So with
> AutoCAD I have to do some
"drawing cleanup". First "snap clustered
> nodes" with 0.005 tolerance,
then "break crossing objects" and "delete
> duplicate objects". Finally I
am able to create a polygon topology
> without any errors.
> Now I
use "Polygon and Oracle extensions" "convert topology to polygons"
>
-function to create Oracle-type polygons on a new layer. Everything
>
seems to work fine and I get the areas I wanted with the islands correct
> and all.
> Now the problem occurs when I try to write these to
Oracle. Over 4000 of
> these areas are exported just fine but 140 of them
cannot be exported.
> The error message says something like "AutoCAD
cannot export unbalanced
> mpolygons to Oracle". Is there any "official"
explanation on what does
> this "unbalanced mpolygon" actually
mean?
> With a help from our Finnish reseller/distributor Viasys we've
noticed
> that the problem areas all have arcs on them. According to
Viasys
> AutoCAD has generated the new areas so that the arc and the line
> actually create a new really really small area, meaning that the line
> and the arc actually cross each other again, even though I managed to
> create a topology without any errors!
> So where is the real
problem, in topology creation or in polygon
> creation or in both, and
what do I do to get rid of it?
> I really hope you understand what I
mean.
> At first the new "Polygon and Oracle extension" looked really
good. It
> was exactly what I wanted. However this problem means that I
have no use
> for it after all.
>
> Thanks,
>
j.
>
> --
> Jarkko Aaltonen
> City Survey
Department
> City Of Tampere
> Finland
>