Is it possible to import points from a file using
latitude & longitude instead of northing easting.
Thanks Mike
|
Is it possible to import points from a file using
latitude & longitude instead of northing easting.
Thanks Mike
Yes, Just set your coordinate system to LL Then depending on how you import them or what tools you use.
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.
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
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.
"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!