db_biljou_carto on db.silva.inrae.fr |
|
View: safran_indic_combid_11_1959_pen15
db_biljou_carto on db.silva.inrae.fr |
|
View: safran_indic_combid_11_1959_pen15
Schema
Owner
biljoucarto_php7
Descriptions
There is no description for view safran_indic_combid_11_1959_pen15
Fields
Name | Data type | Description |
|---|---|---|
id_maille |
integer |
|
annee |
integer |
|
def |
real |
|
def_cartid |
integer |
|
deb |
integer |
|
deb_cartid |
integer |
|
dur |
integer |
|
dur_cartid |
integer |
|
geom |
public.geometry |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table safran_indic_combid_11_1959_pen15
Definition
id_maille,
annee,
def,
def_cartid,
deb,
deb_cartid,
dur,
dur_cartid,
geom)
AS
SELECT safran_indic_lai_2_ru_050_tc_d_vb_1.id_maille,
safran_indic_lai_2_ru_050_tc_d_vb_1.annee,
safran_indic_lai_2_ru_050_tc_d_vb_1.def,
safran_indic_lai_2_ru_050_tc_d_vb_1.def_cartid,
safran_indic_lai_2_ru_050_tc_d_vb_1.deb,
safran_indic_lai_2_ru_050_tc_d_vb_1.deb_cartid,
safran_indic_lai_2_ru_050_tc_d_vb_1.dur,
safran_indic_lai_2_ru_050_tc_d_vb_1.dur_cartid,
polygone_safran.geom3857 AS geom
FROM safran.safran_indic_lai_2_ru_050_tc_d_vb_1
JOIN polygone_safran ON safran_indic_lai_2_ru_050_tc_d_vb_1.id_maille =
polygone_safran.gid
WHERE safran_indic_lai_2_ru_050_tc_d_vb_1.def_cartid = 1892;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|