pggeodb.nancy.inra.fr/db_phyto - db_phyto on pggeodb.nancy.inra.fr |
|
View: v_parcelles_x_y
pggeodb.nancy.inra.fr/db_phyto - db_phyto on pggeodb.nancy.inra.fr |
|
View: v_parcelles_x_y
Schema
public
Owner
phyto_admin
Descriptions
There is no description for view v_parcelles_x_y
Fields
Name | Data type | Description |
|---|---|---|
pau_id |
bigint |
|
x |
double precision |
|
y |
double precision |
|
xy_systeme |
varchar(40) |
|
geom2154 |
public.geometry |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table v_parcelles_x_y
Definition
pau_id,
x,
y,
xy_systeme,
geom2154)
AS
SELECT DISTINCT t_parcelleunitaire_pau.pau_id,
COALESCE(t_parcelleunitaire_pau.pau_x_centre, t_localisation_loc.loc_x_centre) AS x,
COALESCE(t_parcelleunitaire_pau.pau_y_centre, t_localisation_loc.loc_y_centre) AS y,
COALESCE(t_parcelleunitaire_pau.pau_xy_syst_geo,
t_localisation_loc.loc_xy_syst_geo) AS xy_systeme,
COALESCE(t_parcelleunitaire_pau.pau_geom2154,
t_localisation_loc.loc_geom2154) AS geom2154
FROM t_parcelleunitaire_pau
JOIN t_localisation_loc ON t_parcelleunitaire_pau.pau_loc_id =
t_localisation_loc.loc_id;
This file was generated with SQL Manager 2011 for PostgreSQL (www.pgsqlmanager.com) at 28/03/2012 14:37 |
|