topic Re: Survey Data after plotting in Autocad 2D gives very small lengths and areas in AutoCAD Forum

Survey Data after plotting in Autocad 2D gives very small lengths and areas

Anonymous — Tue, 03 Dec 2019 05:55:58 GMT

recently i did a survey and after importing the data from excel to autocad 2D, area is far less.
i had surveyed a area of 11000 sq feet and after importing the data from excel to autocad it shows a area of just 18 square feet .
i have tried setting my units and dim. style
but nothing helps .

Please Help ASAP.

Re: Survey Data after plotting in Autocad 2D gives very small lengths and areas

imadHabash — Tue, 03 Dec 2019 07:54:27 GMT

Since we don't have your drawing , i suggest to :

check your INSUNITS system variable .
check -DWGUNITS all settings .

Re: Survey Data after plotting in Autocad 2D gives very small lengths and areas

Alfred.NESWADBA — Tue, 03 Dec 2019 13:35:25 GMT

Hi,

>> after importing the data from excel to autocad 2D

How did you do that, which units have you had in Excel and which in AutoCAD

- alfred -

Re: Survey Data after plotting in Autocad 2D gives very small lengths and areas

Anonymous — Tue, 03 Dec 2019 17:18:42 GMT

sir
i have already set that . the unit of the data i have taken through TS
survey was in meters .
and i tried to import that to autocad by putting UNITS to "engineering"
and precision to 0'-0".
and again in DIMSTYLE i changed units to engineering

and after importing using "sw dtm " when i measure lengths it measures 7" (
7 inch) only.
and a little higher and whole area gives very little area.

please sir suggest me to correctly import and if possible help me import
the data in feets as i feel comfortable in working with feets.

Re: Survey Data after plotting in Autocad 2D gives very small lengths and areas

Anonymous — Tue, 03 Dec 2019 17:24:42 GMT

hii sir ,
sir units in my TS was set to meters and soo should be the units in excel.

and i at first set up UNITS in autocad to "engineering" and precision 0'-0"
and inches
and in DIMSTYLE too i set units to engineering inches

and when i import from excel using SW DTM , the length measures just 6"/7"
( in inches)
i dnt knw if i should be importing the data in same units as i have taken
in TS.
and is there any method optional tht i could import data in feets in
autocad.
help me sir
thank you .

Re: Survey Data after plotting in Autocad 2D gives very small lengths and areas

Alfred.NESWADBA — Tue, 03 Dec 2019 17:40:31 GMT

Hi,

>> and when i import from excel using SW DTM

I don't know this software and so I don't know if that transforms data between different coordinate systems or different units. But when it's just an insert of object at the location defined in the XLS (in Meter) then your DWG-file should also be set to Meter as units.

When you need it later in Feet or Inch (and as long as you are not dependent on geographic coordinate systems) you can always use command _SCALE to scale your geometry from Meter to the units you want to have (and change _UNITS to this new setting too).

- alfred -

Re: Survey Data after plotting in Autocad 2D gives very small lengths and areas

АлексЮстасу — Tue, 03 Dec 2019 17:52:17 GMT

When importing, I don 't think units are recalculated.
Therefore, it is necessary either to recalculate the values from meters to feet in the source (in Excel or the like), or to use the Scale command with the required factor (3.280839895 or the like) with the base point of 0,0.
Alfred.NESWADBA wrote faster! 😀

Re: Survey Data after plotting in Autocad 2D gives very small lengths and areas

Anonymous — Tue, 03 Dec 2019 17:58:35 GMT

Are you using a State and Plane projection or Long Lat?

Long lat will import exactly as you describe. State and Plane projection will import at correct scale, whether that be Meters, Feet, Parsecs, etc.

Re: Survey Data after plotting in Autocad 2D gives very small lengths and areas

Anonymous — Wed, 04 Dec 2019 05:27:37 GMT

sorry sir i didn't get what u said .
please explain me sir how can i know if it is in state and plain projection of in Lat .

i have not heard about it before

Thank you for your time sir.

Re: Survey Data after plotting in Autocad 2D gives very small lengths and areas

АлексЮстасу — Wed, 04 Dec 2019 12:20:14 GMT

You have a plained orthogonal projection, as you wrote that units are meters.

If you scale the entire drawing (as Alfred.NESWADBA advised you) with a factor of feet relative to the base point of 0,0 - you will have both coordinates and dimensions corresponding to feet.

Re: Survey Data after plotting in Autocad 2D gives very small lengths and areas

АлексЮстасу — Wed, 04 Dec 2019 15:00:18 GMT

You can convert a drawing to other units with coordinate and distance changes using -DWGUNITS.