Deriving bearing in degrees minutes seconds format from field calculator

up vote
1
down vote

favorite

I'd like to know if there's a formula for calculating bearings of lines in degrees minutes seconds format. I already have been able to get the bearings in decimal degrees using:

CONCAT(format_number(degrees(azimuth(start_point($geometry), end_point($geometry))), 2), '°')

edited Nov 25 at 17:29

Vince

14.3k32646

asked Nov 25 at 17:05

Kobina

152

add a comment |

up vote
1
down vote

favorite

I'd like to know if there's a formula for calculating bearings of lines in degrees minutes seconds format. I already have been able to get the bearings in decimal degrees using:

CONCAT(format_number(degrees(azimuth(start_point($geometry), end_point($geometry))), 2), '°')

edited Nov 25 at 17:29

Vince

14.3k32646

asked Nov 25 at 17:05

Kobina

152

add a comment |

up vote
1
down vote

favorite

I'd like to know if there's a formula for calculating bearings of lines in degrees minutes seconds format. I already have been able to get the bearings in decimal degrees using:

CONCAT(format_number(degrees(azimuth(start_point($geometry), end_point($geometry))), 2), '°')

edited Nov 25 at 17:29

Vince

14.3k32646

asked Nov 25 at 17:05

Kobina

152

I'd like to know if there's a formula for calculating bearings of lines in degrees minutes seconds format. I already have been able to get the bearings in decimal degrees using:

CONCAT(format_number(degrees(azimuth(start_point($geometry), end_point($geometry))), 2), '°')

qgis

edited Nov 25 at 17:29

Vince

14.3k32646

asked Nov 25 at 17:05

Kobina

152

edited Nov 25 at 17:29

Vince

14.3k32646

asked Nov 25 at 17:05

Kobina

152

edited Nov 25 at 17:29

Vince

14.3k32646

edited Nov 25 at 17:29

Vince

14.3k32646

edited Nov 25 at 17:29

Vince

14.3k32646

asked Nov 25 at 17:05

Kobina

152

asked Nov 25 at 17:05

Kobina

152

asked Nov 25 at 17:05

Kobina

152

add a comment |

1 Answer
1

active

oldest

votes

up vote
3
down vote

accepted

If you want to use an intermediate field containing the bearings in decimal degrees, I suggest not adding the '°' sign, but create a field "DEGREES" of type 'real' and populate it like this:

degrees(azimuth(start_point($geometry), end_point($geometry)))

Then, by using this field calculator expression in a new text field, you can format your angle in degrees, minutes, seconds:

concat(floor("DEGREES"), '° ', floor("DEGREES"*60 % 60), ''' ', "DEGREES"*3600 % 60, '''')

Or you could also do it with a single expression from the geometry directly:

concat(floor(degrees(azimuth(start_point($geometry), end_point($geometry)))), '° ', 

floor(degrees(azimuth(start_point($geometry), end_point($geometry)))*60 % 60), ''' ', 

degrees(azimuth(start_point($geometry), end_point($geometry)))*3600 % 60, '''')

answered Nov 25 at 18:31

FSimardGIS

98427

Thank you @FSimardGIS, I've successfully derived the bearing in dms in the field calculator with your expression. Worked like magic
– Kobina
Nov 26 at 6:10

add a comment |

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f303850%2fderiving-bearing-in-degrees-minutes-seconds-format-from-field-calculator%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
3
down vote

accepted

If you want to use an intermediate field containing the bearings in decimal degrees, I suggest not adding the '°' sign, but create a field "DEGREES" of type 'real' and populate it like this:

degrees(azimuth(start_point($geometry), end_point($geometry)))

Then, by using this field calculator expression in a new text field, you can format your angle in degrees, minutes, seconds:

concat(floor("DEGREES"), '° ', floor("DEGREES"*60 % 60), ''' ', "DEGREES"*3600 % 60, '''')

Or you could also do it with a single expression from the geometry directly:

concat(floor(degrees(azimuth(start_point($geometry), end_point($geometry)))), '° ', 

floor(degrees(azimuth(start_point($geometry), end_point($geometry)))*60 % 60), ''' ', 

degrees(azimuth(start_point($geometry), end_point($geometry)))*3600 % 60, '''')

answered Nov 25 at 18:31

FSimardGIS

98427

Thank you @FSimardGIS, I've successfully derived the bearing in dms in the field calculator with your expression. Worked like magic
– Kobina
Nov 26 at 6:10

add a comment |

up vote
3
down vote

accepted

If you want to use an intermediate field containing the bearings in decimal degrees, I suggest not adding the '°' sign, but create a field "DEGREES" of type 'real' and populate it like this:

degrees(azimuth(start_point($geometry), end_point($geometry)))

Then, by using this field calculator expression in a new text field, you can format your angle in degrees, minutes, seconds:

concat(floor("DEGREES"), '° ', floor("DEGREES"*60 % 60), ''' ', "DEGREES"*3600 % 60, '''')

Or you could also do it with a single expression from the geometry directly:

concat(floor(degrees(azimuth(start_point($geometry), end_point($geometry)))), '° ', 

floor(degrees(azimuth(start_point($geometry), end_point($geometry)))*60 % 60), ''' ', 

degrees(azimuth(start_point($geometry), end_point($geometry)))*3600 % 60, '''')

answered Nov 25 at 18:31

FSimardGIS

98427

Thank you @FSimardGIS, I've successfully derived the bearing in dms in the field calculator with your expression. Worked like magic
– Kobina
Nov 26 at 6:10

add a comment |

up vote
3
down vote

accepted

If you want to use an intermediate field containing the bearings in decimal degrees, I suggest not adding the '°' sign, but create a field "DEGREES" of type 'real' and populate it like this:

degrees(azimuth(start_point($geometry), end_point($geometry)))

Then, by using this field calculator expression in a new text field, you can format your angle in degrees, minutes, seconds:

concat(floor("DEGREES"), '° ', floor("DEGREES"*60 % 60), ''' ', "DEGREES"*3600 % 60, '''')

Or you could also do it with a single expression from the geometry directly:

concat(floor(degrees(azimuth(start_point($geometry), end_point($geometry)))), '° ', 

floor(degrees(azimuth(start_point($geometry), end_point($geometry)))*60 % 60), ''' ', 

degrees(azimuth(start_point($geometry), end_point($geometry)))*3600 % 60, '''')

answered Nov 25 at 18:31

FSimardGIS

98427

If you want to use an intermediate field containing the bearings in decimal degrees, I suggest not adding the '°' sign, but create a field "DEGREES" of type 'real' and populate it like this:

degrees(azimuth(start_point($geometry), end_point($geometry)))

Then, by using this field calculator expression in a new text field, you can format your angle in degrees, minutes, seconds:

concat(floor("DEGREES"), '° ', floor("DEGREES"*60 % 60), ''' ', "DEGREES"*3600 % 60, '''')

Or you could also do it with a single expression from the geometry directly:

concat(floor(degrees(azimuth(start_point($geometry), end_point($geometry)))), '° ', 

floor(degrees(azimuth(start_point($geometry), end_point($geometry)))*60 % 60), ''' ', 

degrees(azimuth(start_point($geometry), end_point($geometry)))*3600 % 60, '''')

answered Nov 25 at 18:31

FSimardGIS

98427

answered Nov 25 at 18:31

FSimardGIS

98427

answered Nov 25 at 18:31

FSimardGIS

98427

answered Nov 25 at 18:31

FSimardGIS

98427

Thank you @FSimardGIS, I've successfully derived the bearing in dms in the field calculator with your expression. Worked like magic
– Kobina
Nov 26 at 6:10

add a comment |

Thank you @FSimardGIS, I've successfully derived the bearing in dms in the field calculator with your expression. Worked like magic
– Kobina
Nov 26 at 6:10

Thank you @FSimardGIS, I've successfully derived the bearing in dms in the field calculator with your expression. Worked like magic
– Kobina
Nov 26 at 6:10

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Geographic Information Systems Stack Exchange!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Vrftjkry