data/pgsql/init_metier_vue.sql

-- version pgsql
-- creation de vue et destruction des tables coorespondantes
-- dans var.inc : $vue_pos = 1 et $vue_parcelle =1 pour empecher la maj


-- vu sur le pos dynmap

CREATE OR REPLACE VIEW pos AS 
 SELECT *
   FROM dblink('dbname=arles_dynmap'::text,
            'SELECT type_, (id_sect||'' ''||substring(nom_zone,0,30)) , g FROM
            sb_data_338 inner join sb_geom_338 on sb_data_338.rowid=sb_geom_338.rowid') 
            as (pos varchar(10), libelle varchar(40), geom geometry);

-- vue sur les parcelles dynmap

CREATE OR REPLACE VIEW parcelle AS 
 SELECT *
   FROM dblink('dbname=arles_dynmap'::text,
            'SELECT substring(idu_id,7,6), supf_id , g ,null, '''', '''', null, null FROM
            sb_data_170 inner join sb_geom_170 on sb_data_170.rowid=sb_geom_170.rowid') 
            as (parcelle varchar(6), surface numeric(10,3), geom geometry, proprietaire varchar(6),
            debut varchar(4), rivoli varchar(4), section varchar(7), pos varchar(10));
1	fraynaud	40	-- version pgsql
2			-- creation de vue et destruction des tables coorespondantes
3			-- dans var.inc : $vue_pos = 1 et $vue_parcelle =1 pour empecher la maj
4
5
6
7			-- vu sur le pos dynmap
8
9			CREATE OR REPLACE VIEW pos AS
10			SELECT *
11			FROM dblink('dbname=arles_dynmap'::text,
12			'SELECT type_, (id_sect\|\|'' ''\|\|substring(nom_zone,0,30)) , g FROM
13			sb_data_338 inner join sb_geom_338 on sb_data_338.rowid=sb_geom_338.rowid')
14			as (pos varchar(10), libelle varchar(40), geom geometry);
15
16			-- vue sur les parcelles dynmap
17
18			CREATE OR REPLACE VIEW parcelle AS
19			SELECT *
20			FROM dblink('dbname=arles_dynmap'::text,
21			'SELECT substring(idu_id,7,6), supf_id , g ,null, '''', '''', null, null FROM
22			sb_data_170 inner join sb_geom_170 on sb_data_170.rowid=sb_geom_170.rowid')
23			as (parcelle varchar(6), surface numeric(10,3), geom geometry, proprietaire varchar(6),
24			debut varchar(4), rivoli varchar(4), section varchar(7), pos varchar(10));