Building the mesh of a UTM zone with Excel and AutoCAD.

Call it whatever you want, index maps or Cartographic quadrants, geodesic grid, when you need the name is the least. To work this in a GIS program should be simple, but suppose what we have is AutoCAD.

A few days ago I explained the origin of the cartographic grid, and the meaning of the UTM coordinates; We will use the same 16 zone as an example, although it applies to the others, the central axis of that strip is the only line that is totally vertical and precisely it is in the east = 300,000 coordinate.

Utm coordinates

This strip has 6 degrees, and if we see it is expanding from the north pole to the equator, where the latitude is zero; then towards the south pole it is reduced, and the latitudes are the same but in the opposite hemisphere. Well, how to build it

1 Let's build the coordinates with Excel

For this, simply use the tool that We had previously used to convert geographic coordinates to UTM, I will select the spheroid WGS84, then I place the latitudes and longitudes of interest:

The latitudes: From the equator to the north, each of the sections of the imaten has 8 degrees up to the letter w, only the x has 12 degrees, so that from N to W we would have 9 × 8 = 72, when adding 12 we will arrive to 84 degrees, in the northern hemisphere. To do it with respect to the southern hemisphere would be exactly the same, but instead of the N it would carry S. GoogleEarth does not show the rest to avoid the problem that that segment would require an infinite calculation. In this case we are going to build it up to the W segment.

When building it in Excel we have the following table:
Geographic to utm

The lengths. If we look at it, to build the left line it only requires the limit length between the 15 and 16 zones (90 degrees). To build the right limit, the table generates a problem because when entering 84 length, I calculate the same coordinates but in the 17 zone, so I will use 84 degrees, zero minutes and 0.00000001 seconds, so the value always falls in the zone 16 and since the coordinate is two decimals there is no loss of data.

Utm coordinates

Utm mesh 2 Draw the points with AutoCAD

To draw it in AutoCAD, it's simple, column R has the concatenation to do Copypaste. So we have the contents of this column copied into Excel, then into AutoCAD, we activate the point command (draw / point / multiple point) and we paste on the command line. Immediately we have the points of this mesh drawn.

If you do not see them, change the format in format / point style and leave an 5% relative to the screen.

The next step could be to draw the lines that join this mesh, but let's try to do it combining Excel and AutoCAD, because if the mesh was more dense we would have many segments of points to do.

3 Build the vertical lines.

Utm To do this you do the same as to build the points, only that instead of using the command point we use the command line; And ready, just delete the leftover line.

Sure that can be done only by drawing, but remember that this mesh is only the segments of 8 degrees, when you do denser meshes you will find the utility.

4. Construct horizontal lines.

Latitudes utm lengthsTo make the horizontal lines just place the coordinates of the left boundary in a column and to the right of this the coordinates of the right boundary. This you do better in another column with special copy and paste, paste values, so you do not have problems with copying formulas, you should stay like the image shown.

Lat long utm The next thing is to select the content of both columns, then in AutoCAD you have to copy, in AutoCAD you do command line and paste.

And hey, just delete the surplus.

I insist, for many this procedure will seem unnecessary, but when you make denser meshes it will be very practical because deleting the surplus will be simple because there will be long lines that can be easily selected and eliminated. So I leave to your creativity how to take advantage of this procedure to build the complete mesh at different dial scales.

It is clear that what I have is not a georeferenced mesh, because that does not AutoCAD, what I have is a mesh with UTM coordinates equivalent to latitudes and geographical longitudes. To georeference it, it would have to be done with ArcGIS, CadCorp, Map3D, manifold, Microstation Goegraphics or any cartographic application similar to these. But we will see it on another occasion, because we must bear in mind that the units ...

14 Replies to "Building the mesh of a UTM zone with Excel and AutoCAD."

  1. Could you explain how I download the shapefile of the UTM coordinate grid? Thank you so much.

  2. Any of those templates that are there, just search for "template to convert geographic coordinates to UTM" on Google.
    You have to convert the waypoints to dwg format to see them with AutoCAD. You can use Babel to convert them. If they were taken with a gPS they are already georeferenced.

  3. Because the east coordinates of the UTM zones have their range.
    To the center, the central meridian is 500,000 and is so that a coordinate is never negative, but if you reproject it to another zone, it is obvious that it will mark you negative.
    It does not make sense for a property in one area to reproject it in another, because you are placing it where it does not belong.
    If it is data that fall in the zone boundary you have to use geographical coordinates.

  4. Good Morning; I have a question; because in the Arcgis when I project a georeferenced map in the 18SUR zone to the 19SUR zone the East coordinates; they appear negative; What is the problem, please can someone help me. my mail is Elder27@gmail.com. Thank you.

  5. Good day; Could you tell me what program I use to convert geographic coordinates to WGS84, and another query like under GPS waitpoints garmin to Autocad, and how georeferenced; thank you, please write me to the mail Elder27@gmail.com; I will be eternally grateful.

  6. I have a sketch with arbitrary coordinates paste it from autocad to google earth to get its coordinates

  7. I do not understand the query well, I suppose you mean the coordinates in x, y form of the vertices of the batch.

    You make a point there and you see the properties

  8. Hello

    Regarding the topic of UTM coordinates, I draw a map in Auto Cad that is georeferenced and I want to know what the UTM coordinates of a batch of this plane are.

    How can I know?

    Thanks in advance

  9. Many garcias, you don't know how I wanted to do this.

    Again thanks for sharing your knowledge

  10. Good morning, I could provide information on how to perform the conversion of coordinates manually, I need to make software that performs this activity thanks in advance. I would be very grateful if the info you can give me will send it to the mail Carlos_bmx@hotmail.com
    Atte Carlos Azabache

Leave an answer

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.