back to first page[..][[BR]]
back to ["RHT"] - ["Download and load RHT"][[BR]]
Go to ["CookBook join RHT-BDMAP"][[BR]]

NTF_France_II_degrees / NTF Lambert zone II (srid 27572) --> ETRS1989-LAEA (srid 3035)

== Integrating topology (rht_vs2_export_cjouanin_sept11.csv) ==

{{{
#!sql
drop table  if exists rht.topologie_rht_sept2011;
CREATE TABLE rht.topologie_rht_sept2011
(
  ID_DRAIN integer,
  Xcdg numeric,
  Ycdg numeric,
  Xstart numeric,
  Ystart numeric,
  Lg numeric,
  Gridid integer,
  Fnode integer,
  Tnode integer,
  Long numeric
);

copy rht.topologie_rht_sept2011 from 'D:/CelineJouanin/RHT_Estimkart/rht_vs2_export_cjouanin_sept11.csv' with csv delimiter as ';' header; 
alter table rht.topologie_rht_sept2011 add constraint  pk_id_drain_topo primary key (id_drain);
set client_encoding to 'latin1';
}}}

id_drain 30000 sans topologie [[BR]]
Create a view rht_topology
{{{
#!sql
Alter table rht.topologie_rht_sept2011 rename column Length to length;
ALTER TABLE rht.topologie_rht_sept2011 RENAME COLUMN id_drain TO id_draintopo;
}}}