pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr

View: v_buffer

Schema

public

Owner

jmartin

Descriptions

There is no description for view v_buffer

Fields

Rules

Indices

There are no indices for table v_buffer

Definition

CREATE VIEW public.v_buffer (
   par_id,
   par_annee,
   par_recno,
   par_os,
   par_grd_cat,
   geom,
   par_typologie,
   id,
   x,
   y,
   pts_geom,
   prop_bois,
   prop_anthro)
AS
SELECT tr_parcellaire_par.par_id,
   tr_parcellaire_par.par_annee,
   tr_parcellaire_par.par_recno,
   tr_parcellaire_par.par_os,
   tr_parcellaire_par.par_grd_cat,
   tr_parcellaire_par.geom,
   tr_parcellaire_par.par_typologie,
   centroid.id,
   centroid.x,
   centroid.y,
   centroid.pts_geom,
   centroid.prop_bois,
   centroid.prop_anthro
FROM "analyse".centroid
    JOIN tr_parcellaire_par ON st_intersects(st_buffer(centroid.pts_geom,
        500::double precision), tr_parcellaire_par.geom)
WHERE centroid.par_annee = tr_parcellaire_par.par_annee::double precision;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23