/[openfoncier]/trunk/data/pgsql/init_sig.sql
ViewVC logotype

Diff of /trunk/data/pgsql/init_sig.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 40 by fraynaud, Fri Jul 22 16:29:56 2011 UTC revision 146 by fraynaud, Wed Sep 28 14:06:11 2011 UTC
# Line 7  Line 7 
7  -- srid 2154 lambert 93  -- srid 2154 lambert 93
8    
9  SELECT AddGeometryColumn ( 'dossier', 'geom', 2154 , 'POINT', 2 );  SELECT AddGeometryColumn ( 'dossier', 'geom', 2154 , 'POINT', 2 );
10    
11  SELECT AddGeometryColumn ( 'parcelle', 'geom', 2154 , 'MULTIPOLYGON', 2 );  SELECT AddGeometryColumn ( 'parcelle', 'geom', 2154 , 'MULTIPOLYGON', 2 );
12  SELECT AddGeometryColumn ( 'batiment', 'geom', 2154 , 'MULTIPOLYGON', 2 );  SELECT AddGeometryColumn ( 'parcelle_lot', 'geom', 2154 , 'MULTIPOLYGON', 2 );
13    
14  SELECT AddGeometryColumn ( 'section', 'geom', 2154 , 'MULTIPOLYGON', 2 );  SELECT AddGeometryColumn ( 'section', 'geom', 2154 , 'MULTIPOLYGON', 2 );
 SELECT AddGeometryColumn ( 'pos', 'geom', 2154 , 'MULTIPOLYGON', 2 );  
15    SELECT AddGeometryColumn ( 'pos', 'geom', 2154 , 'MULTIPOLYGON', 2 );
16    SELECT AddGeometryColumn ( 'servitude_surfacique', 'geom', 2154 , 'MULTIPOLYGON', 2 );
17    SELECT AddGeometryColumn ( 'servitude_ligne', 'geom', 2154 , 'LINESTRING', 2 );
18    SELECT AddGeometryColumn ( 'servitude_point', 'geom', 2154 , 'POINT', 2 );
19    SELECT AddGeometryColumn ( 'parcelle_lot', 'geom', 2154 , 'MULTIPOLYGON', 2 );
Legend:
Removed from v.40  
changed lines
  Added in v.146
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26