jcYUHKmw

1CREATE ALIAS IF NOT EXISTS H2GIS_NETWORK FOR "org.h2gis.network.functions.NetworkFunctions.load"; CALL H2GIS_NETWORK();
2
3CREATE SPATIAL INDEX ON "GIS.OSM_ROADS_FREE_1" (the_geom);
4CREATE 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);
5
6create table ROUTES_VANNES_DEC AS SELECT * FROM ST_EXPLODE('ROUTES_VANNES');
7
8ALTER TABLE ROUTES_VANNES_DEC ADD column id serial;
9ALTER TABLE ROUTES_VANNES_DEC ADD primary key (id);
10ALTER TABLE ROUTES_VANNES_DEC ALTER COLUMN the_geom LINESTRING;
11
12
13SELECT ST_GRAPH('ROUTES_VANNES_DEC');
14
15SELECT ST_CONNECTEDCOMPONENTS('ROUTES_VANNES_DEC_EDGES', 'undirected');