FIG Peer Review Journal

Polynomial Transformation of Cassini Coordinates to UTM on the Excel Spreadsheet (9237)

Gacoki Thomas Gicira (Kenya)

Mr. Gacoki Thomas Gicira
ASSISTANT DIRECTOR
Kenya National Highways Authority
P.O Box 75466
NAIROBI
00200
Kenya

Corresponding author Mr. Gacoki Thomas Gicira (email: t.gachoki[at]kenha.co.ke; gachokit[at]yahoo.com, tel.: +254 0722 697912; +254 0728 961509)

[ abstract ] [ paper ] [ handouts ]

Published on the web 2018-03-10
Received 2017-10-01 / Accepted 2018-02-01

This paper is one of selection of papers published for the FIG Congress 2018 in Istanbul, Turkey and has undergone the FIG Peer Review Process.

FIG Congress 2018
ISBN 978-87-92853-78-3 ISSN 2308-3441
https://fig.net/resources/proceedings/fig_proceedings/fig2018/index.htm

Abstract

POLYNOMIAL TRANSFORMATION OF CASSINI COORDINATES TO UTM COORDINATES ON THE EXCEL SPREADSHEET T.G.Gacoki Kenya National Highways Authority ABSTRACT A procedure for transforming Cassini grid coordinates (planimetric only) to UTM coordinates on the Excel spreadsheet is outlined. A general second degree polynomial is used to compute twelve parameters which includes two scale parameters, one for the eastings, and the other for the northings and ten other unknowns. Three interconnected worksheets are used to compute the transformation. The first worksheet is used for data entry. The second worksheet computes the twelve transformation parameters necessary for the transformation by use of entries in the first worksheet, while the third worksheet computes the transformed coordinates in UTM by use of the entries in the first worksheet and the computed parameters in the second worksheet. A general third degree polynomial can also be used for the transformation by computing twenty unknowns. Key words Transformation, Polynomial, Cassini, UTM, Scale

Keywords: n/a

Back