# Bike Route Steepness Point Generation

The following documentation assumes you are working in the project at the location below:\
\&#xNAN;***...\Active\_Transportation\Bike\_Maps\OnlineBikeMap\_Slope***

* #### Prep Data Prior to Running Models
  * Make sure both ***ATD\_ADMIN.CTN*** and ***Land Spot Elevations Year 2003*** are added to the map
  * A definition query should be set on the BLANK layer to include on the segments you want to create steepness points from.

    * ie. The query below would include only segments with a Level of Comfort value that were created after a given data.

    `BIKE_LEVEL_OF_COMFORT IS NOT NULL And CREATED_DATE >= TO_DATE('2021-12-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')`
* **Run sequence of models to create output located in Default.tbx**
  * Run ***1. Elevation and Length Generator***
    * *This model will run in approximately 3 minutes*
  * Once model 1 is completed Run ***2. Point on line layer Separator***
    * *This model will run in approximately 30 Seconds*
  * Once model 2 is completed Run ***3. Slope Calculation***
    * *This model will run in approximately 2 minutes*
  * Once model 3 is completed Run ***4. Line Angle Slope Direction***
    * *This model will run in approximately 2 minutes*
* **Symbolizing output layer**
  * Add final output (***SlopePoints\_Final***) from models above to map.\
    ![](https://2080616366-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M3vG5OVht6_BV2LYSXk%2Fuploads%2FpZTyhGK5h3EunIj4D501%2Fimage.png?alt=media\&token=bd139464-2495-4eab-9431-87244fef6037)
  * Apply symbology from ***SlopePoints\_Symbology.lyrx*** to match input below:\
    ![](https://2080616366-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M3vG5OVht6_BV2LYSXk%2Fuploads%2FQrVlzXlGazIaiAvCY1zq%2Fimage.png?alt=media\&token=ecaf388a-ce6a-4a6e-b999-1a4f41228913)
  * Result will appear in Table of Contents like shown below:\
    ![](https://2080616366-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M3vG5OVht6_BV2LYSXk%2Fuploads%2FncgcfkKvTL5NuLJdHJZV%2Fimage.png?alt=media\&token=d8523d64-40f2-43f9-95d4-40a9a6e321fc)