**Hi !**

**Some generalities about topography**

The topographic points are represented in 3 coordinates:

X - to the North

Y - to the Est

Z - altitude

Zero angle is to the North and is increased in the clock wise.

The trigonometric circle has 400 grades (not only 360 like in math).

There are predefined points (the X, Y, Z coordinates are known).

*Here is OK: this points can be stored in a table (table PredefPoints).*

Based on this points and some measurements (angles & distances) is possible to calculate new points.

**And here is where I am in trouble:**

**1)**

Based on this calculated points and other measurements will be calculate other points and so on.

**I can't know how many intermediate points will be calculate**until the last point (the purpose point) will be calculate.

**2)**

The mathematical method

**is not the same for each case**.

While to implement math is an easy problem, to design the database is a big one because, as I see now, I must store the calculated points in a table in order to refer again in the next iteration.

In order to make things even harder to accomplish after this points are calculated once is very probable to iterate the calculations, making small changes in measurements values, in order to eliminate the measurements errors.

But I need to store at least the original values for measurements (if not the new values and the new values again and again) in order to restart iterations after a human error.

Also is needed to store even the mathematical method used to calculate each point.

More than I need a report to show how each point has been calculated:

**Base points, measurements, mathematical method =>, New Point.**

Some ideas on how to design a database to reach this ?

**Thank you !**