Changes between Version 4 and Version 5 of BDCarthage2011 into eda2.0_RHT

Timestamp:

Sep 21, 2011 9:37:13 AM (14 years ago)

Author:

celine

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -37 +37 @@
 select ST_IsClosed(the_geom), id_bdcarth from bd_carthage2011.troncon_hydrographique order by ST_IsClosed(the_geom);  ---5 fermés
 
+create table rht.rht_300 as select id_drain, gid, st_buffer(the_geom,300) as the_geom from rht.rht;
+CREATE INDEX indexrht_300 ON rht.rht_300
+  USING GIST ( the_geom GIST_GEOMETRY_OPS );
+
 drop table if exists rht.rht_bdcarthage_200;
 create table rht.rht_bdcarthage_200 as select r.*, id_bdcarth as gidbdc from rht.rht_200 r join bd_carthage2011.troncon_hydrographique bdc on ST_contains(r.the_geom,bdc.the_geom) order by id_drain;