Changes between Initial Version and Version 1 of Noeud - parcours RHT

Timestamp:

Nov 30, 2011 5:04:46 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ +1 @@
+back to first page[..][[BR]]
+back to ["RHT"][[BR]]
+
+Les données ont été préalablement projetées en 3035 sous ArcGis[[BR]]
+Intégration de la table avec id_drain, fnode, tnode
+{{{
+D:
+cd D:\CelineJouanin\RHT_Estimkart\RHT_October_newversion
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I rhtvs2_3035.shp rhtvs2 > rhtvs2.sql 
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0_RHT -h localhost -U postgres -p 5432 -f rhtvs2.sql 
+
+ALTER TABLE rhtvs2 SET SCHEMA rht;
+
+-- Constraints
+ALTER TABLE rht.rhtvs2 DROP CONSTRAINT rht_pkey;
+ALTER TABLE rht.rhtvs2 ADD CONSTRAINT  pk_id_drain PRIMARY KEY (id_drain);
+
+-- Create an index on rht
+CREATE INDEX indexrhtvs2 ON rht.rhtvs2
+  USING GIST ( the_geom GIST_GEOMETRY_OPS );
+
+DROP INDEX IF EXISTS rht.indexrhtvs2;
+CREATE INDEX indexrht2
+ON rht.rhtvs2
+USING btree (id_drain);
+}}}
+
+
+