IMPORTING POINTS

[mwilson]

Is it possible to import points from a file using
latitude & longitude instead of northing easting.

Thanks Mike

[Jmurphy]

Yes, Just set your coordinate system to LL Then depending on how you import them or what tools you use.

[ekubaskie]

Lat & long have various datums just like the other coordinate systems. The best results come from importing the points into a lat-long drawing in the correct datum, save, and then attach the latlong dwg from a drawing in your desired coordinate system and query the points.

If your points have elevation data, import that as object data at the LL stage, and then add a property modify action to the query to set the final Z-value.

[mwilson]

What is the format to use. I have tried this format in the csv file:

89-42-22.07

But it only reads the 89 from the file.
I need to know how to format the csv file.

Thanks Mike

[ekubaskie]

That's kind of the hassle with LL coordinate input in Map - you have to have decimal degrees. I usually use excel to convert the csv.

[mwilson]

How do you convert the coordinates in the csv file?

[sdaniel.3467]

"What is the format to use. I have tried this format in the csv file:"
The format for LAT LONG conversion/import must be in decimal format. For example -89d33'44" = -89.562222. I use an excel formula to convert the degrees, minutes seconds into decimal then build a script in excel to draw the points.

The formula to convert to decimal in excel is: Degrees + minutes/60 + seconds/3600
I made columns for Degrees, Minutes, Seconds. If this is columns A, B, C your formula in column D would be =A1+B1/60+C1/3600 Then in columns E, F, G, H do the same for the longitude value. In column I the formula to create a script for drawing the point is:
=CONCATENATE("point ",H1,",",D1)
Longitude comes first (it's the X value) then Latitude (the Y value).

"Is it possible to import points from a file using
latitude & longitude instead of northing easting."

Yes, it is possible. to import any coordinate into AutoCAD/Map.
It sounds like you were having a format issue... see above.

Hope this helps!