pggeodb.nancy.inrae.fr/db_arboretum |
|
View: v_arb_mbuee
pggeodb.nancy.inrae.fr/db_arboretum |
|
View: v_arb_mbuee
Schema
Owner
albenard
Descriptions
There is no description for view v_arb_mbuee
Columns
Name | Data type | Description |
|---|---|---|
arb_id |
integer |
|
arb_etiquette |
varchar(64) |
|
arb_cle_externe_arb |
varchar(16) |
|
arb_annee_plantation |
varchar(16) |
|
arb_plantation |
varchar(16) |
|
arb_saison_plant |
varchar(16) |
|
arb_x_plan_l93 |
double precision |
|
arb_y_plan_l93 |
double precision |
|
zon_tree |
public.ltree |
|
zon_libelle |
varchar(64) |
|
zon_code |
varchar(64) |
|
tax_libelle |
varchar(255) |
|
tax_sous_embranchement |
varchar(16) |
|
tax_nom_simple |
varchar(64) |
|
tax_synonyme |
varchar(128) |
|
tax_origine |
varchar(5) |
|
geom |
public.geometry |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table v_arb_mbuee
Definition
arb_id,
arb_etiquette,
arb_cle_externe_arb,
arb_annee_plantation,
arb_plantation,
arb_saison_plant,
arb_x_plan_l93,
arb_y_plan_l93,
zon_tree,
zon_libelle,
zon_code,
tax_libelle,
tax_sous_embranchement,
tax_nom_simple,
tax_synonyme,
tax_origine,
geom)
AS
SELECT t_arbre_arb.arb_id,
t_arbre_arb.arb_etiquette,
t_arbre_arb.arb_cle_externe AS arb_cle_externe_arb,
t_arbre_arb.arb_annee_plantation,
t_arbre_arb.arb_plantation,
t_arbre_arb.arb_saison_plant,
t_arbre_arb.arb_x_plan_l93,
t_arbre_arb.arb_y_plan_l93,
tr_zone_etude_zon.zon_tree,
tr_zone_etude_zon.zon_libelle,
tr_zone_etude_zon.zon_code,
tr_taxon_tax.tax_libelle,
tr_taxon_tax.tax_sous_embranchement,
tr_taxon_tax.tax_nom_simple,
tr_taxon_tax.tax_synonyme,
tr_taxon_tax.tax_origine,
t_arbre_arb.arb_geom_plan AS geom
FROM tr_taxon_tax
JOIN t_arbre_arb ON tr_taxon_tax.tax_id = t_arbre_arb.arb_tax_id
JOIN tr_zone_etude_zon ON t_arbre_arb.arb_zon_id = tr_zone_etude_zon.zon_id
WHERE tr_taxon_tax.tax_nom_simple::text ~~ 'Abies_cephalonica%'::text AND
t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Acer_pseudoplatanus%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Alnus_glutinosa%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Betula_pendula%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Cupressus_arizonica%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Fagus_sylvatica%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Fraxinus_excelsior%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Larix_sibirica%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Picea_abies%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Pinus_contorta%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Pinus_halepensis%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Pinus_nigra%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Pinus_sylvestris%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Pseudotsuga_menziesii%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Quercus_ilex%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Quercus_petraea%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Quercus_pubescens%'::text AND t_arbre_arb.arb_mort = false OR tr_taxon_tax.tax_nom_simple::text ~~ 'Quercus_robur%'::text AND t_arbre_arb.arb_mort = false;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|