No video :(

How to Calculate coordinates from distance and bearing where we have coordinate of a known point

Подписаться 58 тыс.

Просмотров 247 тыс.

50% 1

In this video I have shown how to calculate coordinates of points from a known point where we know the distance and bearings of other points.
Download this excel file here: goo.gl/NBGrxX
I have used EXCEL formula for the Calculations.
Topics Covered :
1) Coordinate calculation from distance and bearings
2) Concept of departure and latitude
3) Calculations of departure and latitude in excel
4) what is Departure and Latitude in Surbeying.
5) Concept of coordinate in Surveying
this video is helpful in land surveying field.
If you think this tutorial is helpful please Like & Share this video and dont forget Subscribe our channel to get free updates!
With best wishes
L&E Team!

Опубликовано:

10 дек 2017

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 210

@kuyanerd3635 5 лет назад

That extra tips at the end is wonderful. Thank you! 😉

@joshuarobertzarate5041 4 года назад

Thank you! God Bless!

@yinaranzamendez4372 5 лет назад

Thank you for this!

@kalomorris20 3 года назад

Thank you very much bro....i am about to go for my exam but was stuck with calculating the easting and northing for the other points. Your video has helped me a lot. Thank u very much bro. May God bless you. Keep doing more videos. Peace!

@LearnExplore 3 года назад

You are welcome 😊 Thank You for your valuable feedback 😊

@virgiliobaroy7343 7 месяцев назад

Wow. Brilliant and very helpful. Thank you.

@myraramesh6352 Год назад

This is wonderful! Simple yet so easy to understand 👍👍👍👍👍

@LearnExplore Год назад

Thank you so much

@dinoroy8962 Год назад

Thank you brother, its very clear tips

@Ling536 5 лет назад

Thanks for reminded... I almost forgot

@lynneaparker4089 3 года назад

This video was perfect! Thanks so much.

@LearnExplore 3 года назад

Thank You for your valuable feedback 😊

@krishnakantapal5691 3 года назад

Good

@cloudmaster978 4 года назад

Thanks bro...very helpful

@joysonaiii 6 лет назад

Very useful, thanks.

@LearnExplore 6 лет назад

you are welcome!

@nathanieleko8767 4 года назад

Wow! Love thisss

@imprashantyadav01 Год назад

THANK YOU SO MUCH SIR ...HELPED ME IN SURVEY PRACTICAL 🙏🙏🙏LOVE FROM NEPAL 🙏🙏

@LearnExplore Год назад

You are welcome. Thanks for this feedback. Love from India🙂

@tomasfernandezcuervo7721 6 лет назад

This was very helpful

@LearnExplore 6 лет назад

+tomas Fernandez Cuervo Thank u and pls SUBSCRIBE us

@scottdorion5376 2 года назад

Fantastic! Thank you!

@LearnExplore 2 года назад

Welcome

@SurveyEngrNurul Год назад

Thank you very much for your valuable information with nice video it's very important information for me. I learned from your video.

@LearnExplore Год назад

Thanks for this nice feedback

@houseoffaith6375 2 года назад

Please thank you very much Nice work.

@IonelEPopa 2 года назад

Thank you verry much for this exemple it helped me a lot.I did subscribed.

@getshakeel 2 года назад

thank you very helpful...

@LearnExplore 2 года назад

Glad to hear that

@chandandas-fw4eq 4 года назад

great work

@gvroadspv7711 5 лет назад

GOOD JOB

@localsfrmhighflyer 2 года назад

What a helpful video I like it very much. Can I create my own excel spreadsheet by following what you showed in your video? Or I have to download it from your link?

@LearnExplore 2 года назад

Thanks. I recommend you to make one. Then ofcourse you will learn a lot. Good luck. Any help am here

@panitiyoungyunpipatkul8957 4 года назад

Thank you so much

@LearnExplore 4 года назад

You're most welcome

@idseb1798 5 лет назад

good work

@waqasgulzar1919 4 года назад

Thank you

@pradipgorai1713 2 года назад

Very helpful

@markabrahamdeocampo2438 Год назад

How can I get the coordinates of first point.. Of easting and northing

@manojsable8482 4 года назад

pls make many samples video auto lvl bearing to convert coordinate bcoz when we r make a village map in that more galli is same bearing but its cordinate isnt same eg.take a squre parlel 2 side line same but coordinate ?pls

@sheilaghisley159 4 года назад

Thanks I'm a student surveyor

@habibsikander430 5 лет назад

good work dear

@ajmalhussain4571 3 года назад

Very very nice sir thnx

@mohdabdulshahid5969 2 года назад

This video was prefect thank you so much sir please give me excel file...

@LearnExplore 2 года назад

Its my pleasure

@marfanmukhtar1902 6 лет назад

good work bro

@LearnExplore 6 лет назад

+M Arfan Mukhtar Thank you

@marfanmukhtar1902 6 лет назад

welcome bro

@abdullahkarimi8035 4 года назад

Thank you my bro

@happykhan299 4 года назад

Great..can you please guide on Lamert datum transformation...I am facing this problem...will be great help.. Or any formula in excel.. Points or toposheet is on Lambert, indian zone1 wgs 84 N41.. Thanks

@happykhan299 4 года назад

Bro do you have any sofware..like geocal of blue marble..

@ASHGONDAL79 6 лет назад

nice

@davidjobes2413 4 года назад

Hello, very good video, much appreciated. Can you help me out as I am trying to locate some position but my bearings are not in decimal. They are in this format N.16 - 37E Can you give any advice how I convert to decimal please??

@LearnExplore 4 года назад

Thank you For this video already uploaded. pls check in our youtube channel

@davidjobes2413 4 года назад

@@LearnExplore Do you have a link to that video please? How to convert from N.16 - 37E to decimal format

@LearnExplore 4 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--BOj-hJynBc.html this video is si,ilar to your query

@davidjobes2413 4 года назад

@@LearnExplore I cannot match that problem to my problem. Are you able to tell me what N.16 - 37E is in decimal format. I have searched high and low and I cannot work this out at all. Any help would be appreciated

@LearnExplore 4 года назад

@@davidjobes2413 This is actually quadrantal bearing system. Here is few examples Example 1: N 16-37E means 16°37'00" and if you want to convert this degree minute second to decimal then watch this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--BOj-hJynBc.html Example 2: N 15-30W means 344°30'00" i.e. (360-15.5) Example 3: S 15-30E means 164°30'00" i.e. (180-15.5) Example 4: S 15-30W means 195°30'00" i.e. (180+15.5) Hope this examples will help you.

@reefcroaker 5 лет назад

How can I use Units as my measurements?

@juberqureshi9792 4 года назад

Sukriya

@clavellopez4390 5 лет назад

Sir where did get the the known coordinates?example if you plot the technical description of a land title.

@danielacosta6912 5 лет назад

tie line from reference point , BLLM1

@happykhan299 4 года назад

@LearnExplore 4 года назад

Use QGIS

@GladysLhynPAsis 5 лет назад

where 2923151.9610 in easting 1103222.9080 in northing from ? explain pls

@LearnExplore 4 года назад

The coordinate system of this data is "Kalyianpur Zone IIB"

@jaffarahmed8628 3 года назад

I want to generate the coordinates for a given distance with respect to the perpendicular centerline of the track, which is already aligned as per coordinate, is it possible??? as i have the coordinates for the track center of each location.!!

@LearnExplore 3 года назад

Yes it is possible. Needs complex excel formulas

@kirannb5354 4 года назад

Brother thank you soo much for Thai video, I want to export the points marked in CAD, and I want to move a robot arms to that exact point... How I can calculate..?

@LearnExplore 4 года назад

Thanks...what is robot arms? For exporting coordinate we have separate video.

@kirannb5354 4 года назад

@@LearnExplore It is Delta make SCARA robot. I have exported points coordinate from CAD into a excel. After if I use that point coordinate to move robot, then there offset around 30mm

@kirannb5354 4 года назад

@@LearnExplore if take length of selected point from origin point, and calculate it by L*sin@, and L*cos@, is it good idea...? Then can I get accurate point. Here the value of origin point is my robot's origin.

@najibulrahaman7404 4 года назад

Please make a video on open travers calculation using ts travers function data and atteched excel sheet under the video description link

@LearnExplore 4 года назад

Ok i will upload

@najibulrahaman7404 4 года назад

Learn & Explore thank you dada...

@krishnamrajurudraraju5997 3 года назад

Thanq for this

@LearnExplore 3 года назад

You are welcome

@shadyb834 2 года назад

Can I also use this excel if I want to convert the coordinates to distance and bearing?

@LearnExplore 2 года назад

We have different video for that. Pl check

@narainnarain999 2 года назад

Very nice

@mohammadakbar4661 4 года назад

Thanx for u

@SivaKumar-xd1gc 3 года назад

How thanks for the tutorial How to you convert true coordinates to local coordinates in excel.thanks.

@LearnExplore 3 года назад

True coordinate means?

@aftabhussain4903 2 года назад

sir, I have center (lat, long) and raduis in KM/ Mile, I want to find all coordinates of rectangle permiter around that center point upto to a radius ( thats I know)... How its possible

@LearnExplore 2 года назад

Convert lat long to UTM then ad and subtract the radius from easting & northing to get all four coordinates

@pennadasvnagasai8961 5 лет назад

COOL

@chriscagasan7765 3 года назад

Hi, the data I have is a starting point in DMS format, then bearings and distance in this format. Bearing: S 72° 32’ E, Distance: 7.30m. How do I proceed so I can plug it in Google Maps/Earth? TIA!

@LearnExplore 3 года назад

Sir First you have to convert Quardantral bearing to whole circle bearing. Then apply our formula

@chriscagasan7765 3 года назад

@@LearnExplore I converted that bearing using the formula deg+(min/60)+(sec/3600) and arrived at 72.5333. Is this the correct whole circle bearing value?

@LearnExplore 3 года назад

No its not. Since your bearing is in SE quardrant that means it is in 2nd quadrant if we split in 4 quardrants in clockwise manner. Whole Circle bearing is calculated clockwise from North. So in your case wcb will be (180-72.533)

@LearnExplore 3 года назад

You can watch this for concept ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xu8ROw8bK_Q.html

@nasirawan445 3 года назад

Helpful

@LearnExplore 3 года назад

Glad to hear that

@yeongweng523 3 года назад

Hi, want to ask is it the Northing represent x-axis and Easting represent y-axis?

@LearnExplore 3 года назад

No, X means Easting and Y means Northing

@fritzlopez6316 3 года назад

hi im new to this. where did you get the initial eating and northing coordinates values?

@LearnExplore 3 года назад

I have taken from site by Dgps

@rajashahbaz3441 6 лет назад

How i adjust the TRAVERSE which i do with triangle method.. Please reply.

@houseoffaith6375 2 года назад

Please where did you get the non coordinate.

@multi-topic4743 3 года назад

where did you get the easting and northing.. the first one

@LearnExplore 3 года назад

I had taken in with DGPS

@Muhammad-lk8gm 4 года назад

Can you please tell me. What the digits express after decimal

@LearnExplore 4 года назад

Digits after decimal provide more accuracy

@rahmatullah8054 7 месяцев назад

Dear sir bearing of point 1_2 is 306 its mean it taken in zone 4th where north positive and east negative Then i think easting must be came in negtive???

@nicholasspence1916 3 года назад

Hi from a known GPS coordinate I want to move X amount of feet in a fixed direction, how can I calculate the gps coordinates of the destination, please?

@LearnExplore 3 года назад

Yes ofcourse u can. The same formula as I shown will be used while calculating new corrdinate from dist and bearing

@symonsaz8496 Год назад

@@LearnExplore No it's not. If you use this formulas, the more distance you have, the more error you got. Earth surface isn't plane.

@aungmyothu9377 3 года назад

How to do for curve location?

@petronellubisi5427 5 лет назад

Please help it says I should specify start poiny

@LearnExplore 5 лет назад

Copy the excel data and paste it in autocad

@RameshKumar-rt8xb 2 года назад

Hii, How can I eextract conordinates for point A to point B? for say the coordinates of the width of a road

@LearnExplore 2 года назад

Use Same distance and bearing method

@uttamtev429 4 года назад

Yep

@globalknowledgeglobalknowl4983 6 лет назад

What is the permissible error?

@LearnExplore 6 лет назад

+debika Sarkar Ei excel sheet er jonne bolchen??

@Samar312 4 года назад

What format of coordinates have you used?

@LearnExplore 4 года назад

Kaliyanpur Zone IIB

@dennisdy6823 5 лет назад

formula for closing the line?

@LearnExplore 5 лет назад

Alreday Video uploaded in this regard

@user-sv9cm1ic7e 5 месяцев назад

Hello, I would like how to calculate XY coordinates while i have distance and Angles only?

@Rikrsh 2 года назад

🤗

@Brave15157 3 года назад

Hello i need this format of excel sheet formula

@LearnExplore 3 года назад

Prepare it by yourself. Because u could learn by own. 🙂

@christopherdannyroucou9197 4 года назад

how to calculate partial coordinate

@shakirnoor8418 3 года назад

You have converted the bearings froms DMS into RADIANS. kindly guide me

@joanm7045 2 года назад

What should I do if I only have the coordinates in Geographic Coordinate System?

@LearnExplore 2 года назад

First conver it to UTM by the help of QGIS. or if u want to convert a single coordinate then visit latlong.net and convert it. Simply search on Google

@rockk770 6 месяцев назад

Hello filipino watching from riyadh. I bought a parcel of land in the Philippines. I have bearing in lot title. Can you help me convert it to coordinates so i can reflect it on google map's. Is that possible. Thank you

@MelissaEnriquez-lo1st 7 дней назад

hey! I just wanted to know, how did you convert your bearing to decimal? Thanks!

@LearnExplore 7 дней назад

We have seperate video for that. Look for the video on our channel.

@MelissaEnriquez-lo1st 7 дней назад

@@LearnExplore Sir I am really desperate to find out the coordinates of the technical description of a lot. I need to identify the coordinates of each point and the only data that I have is the technical description and its bearings with its distances. The point 1 does not have a coordinates, what should I do?

@thivakarantony8278 2 года назад

good

@LearnExplore 2 года назад

Thanks

@ebenezerayiku4201 3 года назад

How did you generate the know eastern and Northern

@LearnExplore 3 года назад

It's just example

@loghenraj1992 3 года назад

i dont understand the radiants. What is the formula to convert bearing to radiant?

@LearnExplore 3 года назад

Radian is in pie format. Please use Google search

@loghenraj1992 3 года назад

@@LearnExplore when I googled it. It showed pie/180 but when I times it with tht, the answer is wrong. Can u tell the exact formula please?

@LearnExplore 3 года назад

A circle has 360 degrees or 2pi radians - going all the way around is 2 * pi * r / r. So a radian is about 360 /(2 * pi) or 57.3 degrees.

@loghenraj1992 3 года назад

@@LearnExplore thanks a lot. I'll try using it.

@jacquilynramilo4711 2 года назад

what if i i dont have a given bearing?

@LearnExplore 2 года назад

Then u have invalid data. A line without bearing is invalid

@markneller8004 6 лет назад

How did you get the starting coordinates? Normally they are shown like -33° 00' 00'' 151° 19' 18''.

@LearnExplore 6 лет назад

The coordinate format u given is in lat,long format But you have to convert the same to utm coordinate

@alimamyconteh6065 2 года назад

Thanks so much bro.and can u help us on videos for microsurvey land survey to learn more

@maanpal1190 6 лет назад

Plz help for downloading

@LearnExplore 6 лет назад

Link is already given pls check

@maanpal1190 6 лет назад

Download nhi ho RHA he sir plz send link my I'd. mannpal2016@gmail.com

@LearnExplore 6 лет назад

Ok you will receive over mail

@maanpal1190 6 лет назад

Learn & Explore thanks sir

@Brave15157 3 года назад

I need this sheet

@krushnasahu6410 2 года назад

Hi Sir, horizontal drilling directional drawing ka video banaye na. Plz.

@LearnExplore 2 года назад

Will try

@skcivilknowledge9630 3 года назад

Good night sir muje re wall ke coordinate ke nikate hai

@prabidhickaguru 5 лет назад

plz i need

@maazansari871 6 месяцев назад

How this Easting 2923151.9610 comes??

@kevinmaligaya3584 2 года назад

How you get the first coordinates ?

@LearnExplore 2 года назад

By DGPS or any gps

@kevinmaligaya3584 2 года назад

@@LearnExplore i only have the lot title . In the lot title there a bearing and distance. How i get the exact location using google maps or google earth. Please help me.

@LearnExplore 2 года назад

Open google map and find lat long. Then convert lat long to utm coordinate system through google search

@kevinmaligaya3584 2 года назад

@@LearnExplore there no lat long. Options 😥 i need to convert the bearing and distance to easting and northing? Sample input (N 40°23'E ) google will locate the lot?

@LearnExplore 2 года назад

Can u Find your location in google map