Changes between Version 1 and Version 2 of RHE

Timestamp:

Sep 27, 2011 9:53:51 AM (14 years ago)

Author:

celine

Comment:

--

RHE

@@ -12 +12 @@
 
 {{{
-Alter table rhe set schema rht;
-ALTER TABLE rht.rhe DROP CONSTRAINT enforce_srid_the_geom;
-UPDATE rht.rhe SET the_geom = ST_transform(the_geom, 3035); 
-ALTER TABLE rht.rhe ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+Create schema rhe;
+Alter table rhe set schema rhe;
+ALTER TABLE rhe.rhe DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE rhe.rhe SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE rhe.rhe ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+
+DROP INDEX IF EXISTS rhe.indexrhe;
+CREATE INDEX indexrhe
+ON rhe.rhe
+USING btree (id_drainv2);
+
+select count(*) from rhe.rhe ---65740 lines
 }}}