topic Re: Bug - Lat Long Decimal calculation is wrong in Point Tables in Civil 3D Forum

Bug - Lat Long Decimal calculation is wrong in Point Tables

spotts — Tue, 04 Jul 2023 01:14:29 GMT

Decimal degrees are not correctly calculated in Point Tables. Instead of converting example 34°11'51" to 34.1975, the software does not do the proper calculation, drops the degree/minutes, and throws in a decimal point. Incorrect output shown is 34.1151

Re: Bug - Lat Long Decimal calculation is wrong in Point Tables

ChicagoLooper — Tue, 04 Jul 2023 01:53:04 GMT

@spotts

<<….not correctly calculated in Point Tables….>>

Just to be clear, can you explain ‘point table?’ Would it be possible to upload a more complete screenshot instead of a partial one?

How are the coordinates (yellow numbers) calculated? What’s the formula, if any, that was used to convert from DMS to decimal degrees? Or was no formula is needed because Civil3D already knows how to convert without using one?

Re: Bug - Lat Long Decimal calculation is wrong in Point Tables

dwayne — Thu, 11 Jan 2024 19:36:14 GMT

Spotts is correct.

degrees minutes seconds should map to decimal degrees as degrees.(minutes/60+seconds/(60*60)) not degrees.minutesseconds

ie 35 degrees, 15 minutes, 10 seconds should be 35.(15/60+10/60^2) which is 35.252777, not 35.151000

I get this error when I use annotate note layout contents latitude or longitude and set the format to decimal dms. If I use the format decimals, the label is correct.

This is a big error, giving locations thousands of feet away from the correct latitude or longitude for 45 minutes.

Re: Bug - Lat Long Decimal calculation is wrong in Point Tables

ChicagoLooper — Thu, 11 Jan 2024 20:15:24 GMT

@dwayne wrote

<<.... set the format to decimal dms...>>

Upload two screenshots.

Upload a screenshot clearly displaying the window where you input the Lat/Long.

More importantly, upload a second screenshot where you SET THE FORMAT TO DECIMAL DMS. You can choose the output from from a list of available options:

decimal degrees
degrees, minutes, seconds
degrees, decimal minutes
etc.

If you're getting degrees, decimal minutes for the result when you want decimal degrees, I'd look carefully at the output chosen and not assume AutoCAD is at fault.

BTW, this is post is 6-months old. The OP might have figured out the solution by now.

Your screenshots are welcomed.