pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
View: v_ab_valid
pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr |
|
View: v_ab_valid
Schema
Owner
albenard
Descriptions
There is no description for view v_ab_valid
Fields
Name | Data type | Description |
|---|---|---|
etiq |
varchar(16) |
|
the_geom |
public.geometry |
|
x |
double precision |
|
y |
double precision |
|
systeme |
char(12) |
|
z |
double precision |
|
x_corr |
double precision |
|
y_corr |
double precision |
|
date_campagne |
date |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table v_ab_valid
Definition
etiq,
the_geom,
x,
y,
systeme,
z,
x_corr,
y_corr,
date_campagne)
AS
SELECT t_animal_ani.ani_etiq AS etiq,
t_positionnement_pos.the_geom,
t_positionnement_pos.pos_x AS x,
t_positionnement_pos.pos_y AS y,
t_positionnement_pos.pos_systeme AS systeme,
t_positionnement_pos.pos_z AS z,
t_positionnement_pos.pos_x_corrige AS x_corr,
t_positionnement_pos.pos_y_corrige AS y_corr,
t_campagne_pos_cpos.cpos_date AS date_campagne
FROM t_positionnement_pos
JOIN t_campagne_pos_cpos ON t_positionnement_pos.pos_cpos_id =
t_campagne_pos_cpos.cpos_id
JOIN t_animal_ani ON t_campagne_pos_cpos.cpos_ani_id = t_animal_ani.ani_id
WHERE t_animal_ani.ani_etiq::text = '280'::text;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |
|