Create table with enclosed text and polygon area values

[Anonymous]

I have closed polylines, which enclose mtext, representing room areas and room numbers (from CAD). The room numbers are not connected to the polylines. I need to generate a table that lists the room numbers with the room areas side by side.

All the polylines are closed and all the text insertion points lie within each polyline.

I have created a polygon topology and an object data table and used MAPEXPORT to create shp and sdf files but the Area value does not seem to extract the area from the polyline.

Any suggestions?

Paul

[parkr4st]

check the attached

dwg layer 0 rectangles and Mtext

tiff shows checked object properties; also checked AREA in the Properties list

RecTextTest.sdf has the resulting data set

Analyze; intersect that sdf file itself and all the data is available in one line.

a map import and export and you can select the data you want to retain to make the final data set

dave

[Anonymous]

Thanks Dave, although I'm not sure how I would align the data which is showing as offset in the attached screenshot (unaligned data.jpg)?

The other two attached screenshots show what I am starting with i.e. "Existing from CAD.jpg" and my desired output is shown in "Output.jpg"

Paul

[O_Eckmann · Accepted solution]

Hi,

you have to use ADEGENLINK to transfer mtext value to OD on closed englobing polyline, then MAPEXPORT to SHP and open DBF with Excel

here is a screencast of procedure.

Olivier

[Anonymous]

Olivier,

That's great. This will save me a lot of time. The screencast was very useful (albeit in French!). Essentially it came down to 3 commands, ADEDEFDATA, ADEGENLINK & MAPEXPORT and by accepting the default of 'select all' I don't need to select my polylines/text.

Just one final question; Is there a way of reducing the number of decimal places of the AREA value? or better still converting this value to square meters to two decimal places?

Thanks again.

Paul 

[O_Eckmann]

Hi,

Area value can be reduced to same number of decimal as LUPREC variable.

To do this, in command line enter LUPREC and set value to the number of desired decimal.

In MAP export dialog (2nd tab) you must edit filed source to replace

.AREA

with

(rtos .AREA 2 2)

I was surprised that number of decimal specified in rtos function is not used, but in my MAP 3D 2015 (french), value used to reduce number of decimal is LUPREC regardless of value entered in rtos function. Perhaps it could be different in other version of MAP.

Olivier

[АлексЮстасу]

Option with ODEDIT:
1. Also create OD - ADEDEFDATA. But you need to attach OD to closed polylines (ADEATTACHDATA or ODEDIT_ADEATTACHDATA).
2. Load the content of texts or text in the required field OD - ODEDIT_SETTEXT.
3. Load areas of closed polylines in the required OD field with the desired number of decimal places - ODEDIT_SETPROP.
It is convenient to view the result in the table - ODEDIT_TABLE.
Everything is only in AutoCAD, in the current dwg, only in OD, from the same menu.