Function reference • mapdotoro

All functions

bassin_hydrographique: bassin_hydrographique

check_duplicate(): Check for duplicate measure in streams axis.

clean_column_names(): Format column names

clean_duplicated(): Drop all the duplicated rows from a duplicated data.frame.

continuity: continuity

create_continuity_area_full_side_matview(): Create continuity_area_full_side view

create_continuity_width_full_side_matview(): Create continuity_width_full_side view

create_landcover_area_full_side_matview(): Create landcover_area_full_side view

create_network_axis_matview(): Create network axis view for mapdoapp application.

create_network_metrics_matview(): Create network metrics view for mapdoapp application.

create_table_bassin_hydrographique(): Create bassin_hydrographique table structure.

create_table_continuity_area(): Create continuity_area table structure.

create_table_continuity_width(): Create continuity_width table structure.

create_table_elevation_profiles(): Create elevation_profiles table structure.

create_table_hydro_axis(): Create hydro_axis table structure.

create_table_hydro_sites(): Create hydro_sites table structure.

create_table_hydro_swaths(): Create hydro_swaths table structure

create_table_landcover_area(): Create landcover_area table structure.

create_table_region_hydrographique(): Create region_hydrographique table structure.

create_table_roe(): Create roe table structure

create_table_talweg_metrics(): Create talweg_metrics table structure.

create_table_valley_bottom(): Create valley_bottom table structure.

create_valley_bottom_full_side_matview(): Create valley_bottom_full_side view

db_con(): Postgresql database connection.

elevation_profiles: elevation_profiles

fct_continuity_area_insert_delete_reaction(): Add trigger function to react from continuity_area insert or delete.

fct_continuity_width_insert_delete_reaction(): Add trigger function to react from continuity_width insert or delete.

fct_elevation_profiles_insert_delete_reaction(): Add trigger function to react from elevation_profiles insert or delete.

fct_hydro_swaths_insert_delete_reaction(): Add trigger function to react from hydro_swaths insert or delete

fct_landcover_area_insert_delete_reaction(): Add trigger function to react from landcover_area insert or delete.

fct_talweg_metrics_insert_delete_reaction(): Add trigger function to react from talweg_metrics insert or delete.

fct_valley_bottom_insert_delete_reaction(): Add trigger function to react from valley_bottom insert or delete.

hydro_sites: hydro_sites

import_hydro_sites(): Get hydrologic sites from Hubeau API.

landcover: landcover

pivot_continuity_width(): Prepare continuity dataset to have width for each label

pivot_landcover_continuity_area(): Prepare landcover or continuity dataset to have area for each label.

prepare_bassin_hydrographique(): Prepare bassin_hydrographique dataset to database export.

prepare_continuity_area(): Prepare continuity area to database export.

prepare_continuity_width(): Prepare continuity width to database export.

prepare_elevation_profiles(): Prepare elevation profiles to database export.

prepare_hydro_axis(): Prepare hydrologic axis dataset to database export.

prepare_hydro_sites(): Prepare hydrometric sites to database export.

prepare_hydro_swaths_and_axis(): Prepare hydro_swaths dataset to database export.

prepare_landcover_area(): Prepare landcover area to database export.

prepare_region_hydrographique(): Prepare region_hydrographique dataset to database export.

prepare_roe(): Prepare roe dataset to database export.

prepare_talweg_metrics(): Prepare talweg metrics to database export.

prepare_valley_bottom(): Prepare valley_bottom to database export.

referentiel_hydro: referentiel_hydro

refresh_all_materialized_views(): Refresh all the materialized view in public schema database.

region_hydrographique: region_hydrographique

remove_rows(): Remove rows in database table based on field identifier.

roe: roe

set_displayed_bassin_region(): Set display column value for bassin or region table.

swaths: swaths

talweg_metrics: talweg_metrics

trig_continuity_area(): Create trigger to update tables from continuity_area modifications.

trig_continuity_width(): Create trigger to update tables from continuity_width modifications.

trig_elevation_profiles(): Create trigger to update tables from elevation_profiles modifications.

trig_hydro_swaths(): Create trigger to update tables from hydro_swaths modifications.

trig_landcover_area(): Create trigger to update tables from landcover_area modifications.

trig_talweg_metrics(): Create trigger to update tables from talweg_metrics modifications.

trig_valley_bottom(): Create trigger to update tables from valley_bottom modifications.

troncon_bdtopo_id: troncon_bdtopo_id

upsert_bassin_hydrographique(): Delete existing rows and insert hydrologic bassin to database

upsert_continuity_area(): Delete existing rows and insert continuity area to database.

upsert_continuity_width(): Delete existing rows and insert continuity width to database.

upsert_elevation_profiles(): Delete existing rows and insert elevation profiles to database.

upsert_hydro_sites(): Delete existing rows and insert hydrometric sites to database.

upsert_hydro_swaths_and_axis(): Delete existing rows and insert hydrologic network splited by swaths to database.

upsert_landcover_area(): Delete existing rows and insert landcover area to database.

upsert_region_hydrographique(): Delete existing rows and insert hydrologic region to database.

upsert_roe(): Delete existing rows and insert roe to database

upsert_talweg_metrics(): Delete existing rows and insert talweg metrics to database.

upsert_valley_bottom(): Delete existing rows and insert valley botom to database.

valley_bottom: valley_bottom