pggeodb-preprod.nancy.inra.fr/db_phyto - db_phyto on pggeodb-preprod.nancy.inra.fr |
|
View: v_extraction_floraine
pggeodb-preprod.nancy.inra.fr/db_phyto - db_phyto on pggeodb-preprod.nancy.inra.fr |
|
View: v_extraction_floraine
Schema
public
Owner
albenard
Descriptions
There is no description for view v_extraction_floraine
Fields
Name | Data type | Description |
|---|---|---|
pau_id |
integer |
|
x |
double precision |
|
y |
double precision |
|
x_arrondi |
double precision |
|
y_arrondi |
double precision |
|
geom_arrondi |
public.geometry |
|
maille |
text |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table v_extraction_floraine
Definition
pau_id,
x,
y,
x_arrondi,
y_arrondi,
geom_arrondi,
maille)
AS
SELECT v_parcelles_x_y.pau_id,
st_x(v_parcelles_x_y.geom2154) AS x,
st_y(v_parcelles_x_y.geom2154) AS y,
5::double precision * trunc(st_x(v_parcelles_x_y.geom2154) / 5000::double
precision) AS x_arrondi,
5::double precision * trunc(st_y(v_parcelles_x_y.geom2154) / 5000::double
precision) AS y_arrondi,
st_setsrid(st_makepoint(5000::double precision *
trunc(st_x(v_parcelles_x_y.geom2154) / 5000::double precision), 5000::double precision * trunc(st_y(v_parcelles_x_y.geom2154) / 5000::double precision)), 2154) AS geom_arrondi,
replace((('E'::text || to_char(5::double precision *
trunc(st_x(v_parcelles_x_y.geom2154) / 5000::double precision), '9999'::text)) || 'N'::text) || (5::double precision * trunc(st_y(v_parcelles_x_y.geom2154) / 5000::double precision)), ' '::text, '0'::text) AS maille
FROM v_parcelles_x_y,
tr_sig_bdtopo_lorraine
WHERE NOT v_parcelles_x_y.geom2154 IS NULL AND
st_contains(tr_sig_bdtopo_lorraine.geom, st_setsrid(st_makepoint(5000::double precision * trunc(st_x(v_parcelles_x_y.geom2154) / 5000::double precision), 5000::double precision * trunc(st_y(v_parcelles_x_y.geom2154) / 5000::double precision)), 2154));
This file was generated with SQL Manager 2011 for PostgreSQL (www.pgsqlmanager.com) at 28/03/2012 14:37 |
|