pggeodb.nancy.inra.fr/db_phyto - db_phyto on pggeodb.nancy.inra.fr |
|
View: v_dendro_hetre_vosges
pggeodb.nancy.inra.fr/db_phyto - db_phyto on pggeodb.nancy.inra.fr |
|
View: v_dendro_hetre_vosges
Schema
public
Owner
albenard
Descriptions
There is no description for view v_dendro_hetre_vosges
Fields
Name | Data type | Description |
|---|---|---|
localisation |
varchar(32) |
|
x |
double precision |
|
y |
double precision |
|
sysgeo |
varchar(40) |
|
pau |
varchar(32) |
|
etude |
varchar(160) |
|
lien |
text |
|
the_geom |
public.geometry |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table v_dendro_hetre_vosges
Definition
localisation,
x,
y,
sysgeo,
pau,
etude,
lien,
the_geom)
AS
SELECT t_localisation_loc.loc_nom AS localisation,
t_localisation_loc.loc_x_centre AS x,
t_localisation_loc.loc_y_centre AS y,
t_localisation_loc.loc_xy_syst_geo AS sysgeo,
t_parcelleunitaire_pau.pau_nom AS pau,
t_etude_etu.etu_nom AS etude,
'https://appgeodb.nancy.inra.fr/sigeco'::text AS lien,
st_setsrid(st_makepoint(t_localisation_loc.loc_x_centre,
t_localisation_loc.loc_y_centre), 2154) AS the_geom
FROM t_etude_etu
JOIN tj_parcelleunitaire_utilisee_pau_etu_pae ON t_etude_etu.etu_id =
tj_parcelleunitaire_utilisee_pau_etu_pae.pae_etu_id
JOIN t_parcelleunitaire_pau ON
tj_parcelleunitaire_utilisee_pau_etu_pae.pae_pau_id = t_parcelleunitaire_pau.pau_id
JOIN t_localisation_loc ON t_parcelleunitaire_pau.pau_loc_id =
t_localisation_loc.loc_id
WHERE t_etude_etu.etu_nom::text = 'Dendroécologie du Hêtre dans les Vosges'::text;
This file was generated with SQL Manager 2011 for PostgreSQL (www.pgsqlmanager.com) at 28/03/2012 14:37 |
|