The design of the spatial database is the formal process of analyzing facts about the real world into a structured model. Database design is characterized by the following phases: requirement analysis, logical design and physical design. In more common terms, you basically need a plan, a design layout and then the data to complete the process.

https://tmackinnon.com/wp-content/uploads/Keji-new-forest-polys-ft.jpg350500Ted MacKinnonhttps://tmackinnon.com/wp-content/uploads/marker3.pngTed MacKinnon2014-03-05 11:30:112018-12-18 18:44:45Geomatics - GIS data base modeling

Digital Terrain Modeling is the process of simulating or representing the relief and patterns of a surface with numerical and digital methods. It has always been an integral component to geology related fields such as geomorphology, hydrology, tectonics and oceanography but over the past decade has also become a major component to non geophysical applications such as GIS modeling, surveying and land use planning.

Terrain Models are derived from data represented by digital elevation models (DEMs) and can include shaded relief models, slope and aspect models, perspective scene generation, and drainage basin analysis (and other models).

The slope or the gradient of a straight line within a Cartesian coordinate system is known as the measure of how steep a line is relative to the horizontal axis.

In calculations; it is generally represented by the letter m, and defined as the change in the Y coordinate divided by the corresponding change in the X coordinate, between two distinct points on the line (X1, Y1 and X2, Y2). Since the Y axis is vertical and the X axis is horizontal by convention, slope is often referred to as the rise over the run or the change in the vertical coordinates, divided by the change in the horizontal coordinates.

Basically, the larger the slope value, the steeper the line is. A horizontal line has a slope of 0, a 45 degree line has a slope of 1, and the slope of a vertical line is typically undefined. In trigonometry two lines are considered to be parallel if and only if their slopes are equal or if they both are vertical and therefore undefined. Two lines are considered to be perpendicular if and only if the product of their slopes is -1 or one has a slope of 0 and the other is vertical and undefined.

There are two common ways to describe slope. One method is to use the angle of the slope in degrees (0 to 90), and the other is to represent the slope as a percentage (0 to 100). Expressing slope as a percent is common but can be confusing because a percent slope can be greater then 100%. A 100% slope is actually only a 45 degree angle due to the fact that the rise and run of a 45 degree angle are equal and when divided always equals 1 and when multiplied by 100 will equal 100%.

In terrain modeling we generally model an entire surface and not just one line so we need to calculate the slope of a best fit surface plane (which is made of lines). Because the terrain model is usually continuous across the entire surface, it is important to be able to calculate how to represent grid cells (or pixels) when going from one elevation to the next. To do this we generally need to know the aspect or the direction that the surface plane is sloped as well. Together the slope combined with the aspect of the surface can virtually define the surface plane completely.

In the example shown to the left, a slope map of Lismore, Nova Scotia was derived from a digital elevation model (DEM) calculated using PCI Geomatica remote sensing software. It is represented with a grey scale color ramp therefore the color white represents a 0 slope and the shades of grey increase through to black which represents an undefined slope. The majority of slopes for this map do not exceed 17 degrees (except for vertical slopes) as this is a relative low lying area of Appalachian terrain.

The image above and to the right is of an actual bedrock cliff with some technical information embedded onto it so it may be used to help better understand slope. The black arrow represents the slope or the measured angle that the rock is dipping towards. The slope in the image would be 45 degrees approximately so the slope would be 1 or 100%. The rise and the run of a slope with a 45 degree angle will always equals 1, thus when multiplied by 100 to calculate percent slope will equal always equal 100%.

The image below is a Slope Model that I derived from a digital elevation model (DEM) of Lismore, Nova Scotia. The values of the slopes of the DEM are represented by a 0-255 grey scale color ramp, therefore the color white represents a 0 slope and the shades of grey increase through to black which represents an undefined slope. The majority of slopes for this map do not exceed 17 degrees (except for vertical slopes) as this is a relative low lying area of Appalachian terrain.

Click here to learn a little more about Slope Models and how the image below was created.

https://tmackinnon.com/wp-content/uploads/lismore-slopes.jpg648624Ted MacKinnonhttps://tmackinnon.com/wp-content/uploads/marker3.pngTed MacKinnon2006-02-25 14:10:272012-03-27 14:16:29Example of a Slope Map