CREATE ALIAS IF NOT EXISTS H2GIS_NETWORK FOR "org.h2gis.network.functions.NetworkFunctions.load"; CALL H2GIS_NETWORK();

CREATE SPATIAL INDEX ON "GIS.OSM_ROADS_FREE_1" (the_geom);
CREATE table routes_vannes as SELECT ST_TRANSFORM(ST_SETSRID(ST_INTERSECTION(a.the_geom , b.the_geom), 4326), 2154) as the_geom, MAXSPEED, PK, fclass from "GIS.OSM_ROADS_FREE_1" as a , FENCE as b where a.the_geom &&  b.the_geom and ST_INTERSECTS(a.the_geom , b.the_geom);

create table ROUTES_VANNES_DEC AS SELECT * FROM ST_EXPLODE('ROUTES_VANNES');

ALTER TABLE ROUTES_VANNES_DEC ADD column id serial;
ALTER TABLE ROUTES_VANNES_DEC ADD primary key (id);
ALTER TABLE ROUTES_VANNES_DEC ALTER COLUMN the_geom LINESTRING;


SELECT ST_GRAPH('ROUTES_VANNES_DEC');

SELECT ST_CONNECTEDCOMPONENTS('ROUTES_VANNES_DEC_EDGES', 'undirected');