back to first page [..][[BR]] back to ["Gis Structures"] == Describing the CCM layers == To download and load the data into postgreSQL you must follow ["CCM2 download and load"] [[BR]] == French names river and wso_id == ["Names river"] === Some links === http://ccm.jrc.ec.europa.eu/php/index.php?action=view&id=23 [[BR]] http://edo.jrc.ec.europa.eu/php/index.php?action=view&id=42 [[BR]] De Jager, A.L., Vogt, J.V. (2010). Development and demonstration of a structured hydrological feature coding system for Europe , Hydrological Sciences Journal, 55, 5, 661, Taylor and Francis [[BR]] http://www.informaworld.com/smpp/section?content=a923839709&fulltext=713240928 [[BR]] Vogt, J.V. et al. (2007). A pan-European River and Catchment Database. EC-JRC (Report EUR 22920 EN) Luxembourg, 120 p. [[BR]] http://ccm.jrc.ec.europa.eu/documents/CCM2-Report_EUR-22920-EN_2007_STD.pdf[[BR]] Vogt, J.V. et al. (2007). Developing a pan-European Data Base of Drainage Networks and Catchment Boundaries from a 100 Metre DEM. Proceedings AGILE International Conference, May 2007. [[BR]] http://ccm.jrc.ec.europa.eu/documents/JVogt_etal_AGILE2007.pdf [[BR]] Vogt, J.V., E. Rimaviciute, A de Jager (2008). CCM 2.1 Release Notes.[[BR]] http://ccm.jrc.ec.europa.eu/documents/JVogt_etal_CCM21.pdf [[BR]] === table riversegments === [[Color(,#3849ce,gid)]]: id (corresponds to line number)[[BR]] [[Color(,#3849ce,wso1_id)]]: id of the primary catchment drained by the river segment.[[BR]] [[Color(,#3849ce,wso_id)]]: id of the Sea-outlet to which the river segment belongs.[[BR]] [[Color(,#3849ce,rvr_id)]]: reference of the name of the river to which the segment belongs (often 0)[[BR]] [[Color(,#3849ce,fromnode)]]: upstream node [[BR]] [[Color(,#3849ce,tonode)]]: downstream node[[BR]] [[Color(,#3849ce,strahler)]]: the stream order hierarchy, the sizes range from a first order stream to the largest a 11th order stream[[BR]] [[Color(,#3849ce,pfafstette)]]: Pfafstetter code (?) of the river segment and its primary catchment[[BR]] [[Color(,#3849ce,nextdownid)]]: next segment identifyer downstream points to wso_id[[BR]] [[Color(,#3849ce,longpath)]]: identifies wether the river segment is part of the longest flow path in the River Basin (sea-outlet), Y(es) or NULL[[BR]] [[Color(,#3849ce,maindrain_)]]: ?[[BR]] [[Color(,#3849ce,maindrain1)]]: ?[[BR]] [[Color(,#3849ce,length)]]: length of a river segment in meters[[BR]] [[Color(,#3849ce,cum_len)]]: cumulated length of the upstream flow network, including the river segment itself (longest route ?)-in meters[[BR]] [[Color(,#3849ce,pixels_100)]]: area directly drained by the river segment (area of the primary catchment), in 100m*100m grid-cells[[BR]] [[Color(,#3849ce,catchment_)]]: ?[[BR]] [[Color(,#3849ce,cont_pixel)]]: area upstream of the From Node drained by the river segment in 100m*100m grid-cells[[BR]] [[Color(,#3849ce,drain_km2)]]: full area drained by the river segment and upstream area - in square kilometres[[BR]] [[Color(,#3849ce,alt_gradie)]]: relief Energy of the river segment : ((Elevation at From Node-Elevation at !ToNode)/Segment Length)*100 in per cent[[BR]] [[Color(,#3849ce,burned)]]: percentage grid-cells of the river segment having a high confidence level with respect to its geographical position[[BR]] [[Color(,#3849ce,confidence)]]: percentage of grid-cells of the river segment having a high confidence level with respect to its geographical position[[BR]] [[Color(,#3849ce,window)]]: here 2003[[BR]] [[Color(,#3849ce,shape_leng)]]: segment length in metres[[BR]] [[Color(,#3849ce,the_geom)]]: the_geom [[BR]] === table rivernodes === [[Color(,#3849ce,gid)]]: id (corresponds to line number ?)[[BR]] [[Color(,#3849ce,id)]]: id of the river Basin (Seaoutlet) to which the catchment belongs [[BR]] [[Color(,#3849ce,wso_id)]]: Id of the river basin (sea outlet) to which the river node belongs [[BR]] [[Color(,#3849ce,source)]]: Type of source Y = River source, N =No not river source, M = river mouth[[BR]] [[Color(,#3849ce,len_tom)]]: Length from the node to the river mouth in meter[[BR]] [[Color(,#3849ce,num_seg)]]: Number of segments to reach the river mouth from the node [[BR]] [[Color(,#3849ce,elev)]]: Elevation at node in meter[[BR]] [[Color(,#3849ce,x_laea)]]: x re-projected to LAEA at a 1 kilometer resolution (I assume)[[BR]] [[Color(,#3849ce,y_laea)]]: ordinate re-projected to LAEA at a 1 kilometer resolution (I assume)[[BR]] [[Color(,#3849ce,window)]]: here 2003[[BR]] === table seaoutlets === [[Color(,#3849ce,sea_cd)]]: 1 (North Atlantic Sea, Caspian Sea), 2 (Mediterranean West, Persian Gulf), 4 (Celtic Sea Channel, Mediterranean East), 5 (Black Sea), 6 (Baltic Sea), 7 (Barents Sea East), 8 (Barents Sea West), 9 (White Sea) [[BR]] [[Color(,#3849ce,system_cd)]]: A,C,H,I,J,M,N,Q,S,T,V,Z ||[[Image(source:data/Docs/trac/CCM21/seaoutlets_sea_cd_europe.png,300px)]]||[[Image(source:data/Docs/trac/CCM21/seaoutlets_system_cd.png,300px)]]|| === table catchments === [[Image(source:data/Docs/trac/CCM21/CCM_drainage_bassins.jpg,300px)]] Two tables : Catchment_E and Catchment_W (with the version of Laurent, now just one catchment) [[Color(,#3849ce,objectid)]]: [[BR]] [[Color(,#3849ce,wso1_id, wso2_id...wso11_id)]]: id of the Primary catchment (wso1-id) and of all higher order catchment to which the primary catchement belongs. wso1_id=-9999 : inclusions due to a lake, wso1_id=0 : inclusion due to the Sea [[BR]] [[Color(,#3849ce,wso_id)]]: River Bassin (sea-outlet) ID to which the catchment belongs [[BR]] [[Color(,#3849ce,strahler)]]: strahler order of the river segment draining the catchment. If no river segment exist in the catchment, Strahler order 0 (zero) is assigned [[BR]] [[Color(,#3849ce,feature_co)]]: [[BR]] [[Color(,#3849ce,nextdownid)]]: [[BR]] [[Color(,#3849ce,y_centroid)]]: [[BR]] [[Color(,#3849ce,x_centroid)]]: [[BR]] [[Color(,#3849ce,x_inside_L)]]: [[BR]] [[Color(,#3849ce,Y_inside_L)]]: [[BR]] [[Color(,#3849ce,xmax_laea)]]: [[BR]] [[Color(,#3849ce,ymax_laea)]]: [[BR]] [[Color(,#3849ce,area)]]: [[BR]] [[Color(,#3849ce,area_km2)]]: area of the primary catchment in km²[[BR]] [[Color(,#3849ce,perimeter)]]: [[BR]] [[Color(,#3849ce,elev_min)]]: minimum elevation in the primary catchment [[BR]] [[Color(,#3849ce,elev_max)]]: maximum elevation in the primary catchment [[BR]] [[Color(,#3849ce,elev_mean)]]: average elevation in the primary catchment [[BR]] [[Color(,#3849ce,elev_std)]]: standard deviation of the elevation in the primary catchment [[BR]] [[Color(,#3849ce,slope_min)]]: minimum slope in the primary catchment [[BR]] [[Color(,#3849ce,slope_max)]]: maximum slope in the primary catchment [[BR]] [[Color(,#3849ce,slope_mean)]]: average slope in the primary catchment, in percent [[BR]] [[Color(,#3849ce,slope_std)]]: standard deviation of the slope in the primary catchment [[BR]] [[Color(,#3849ce,rain_min)]]: minimum long-term average annual precipitation in the primary catchment, in millimeters[[BR]] [[Color(,#3849ce,rain_max)]]: maximum long-term average annual precipitation in the primary catchment, in millimeters[[BR]] [[Color(,#3849ce,rain_mean)]]: mean long-term average annual precipitation in the primary catchment, in millimeters[[BR]] [[Color(,#3849ce,rain_std)]]: standard deviation of the long-term average annual precipitation in the primary catchment, in millimeters[[BR]] [[Color(,#3849ce,temp_min)]]: minimum long-term average annual temperature in the primary catchment, in degrees Celsius[[BR]] [[Color(,#3849ce,temp_max)]]: maximum long-term average annual temperature in the primary catchment, in degrees Celsius[[BR]] [[Color(,#3849ce,temp_mean)]]: mean long-term average annual temperature in the primary catchment, in degrees Celsius[[BR]] [[Color(,#3849ce,temp_std)]]: standard deviation of the long-term average annual temperature in the primary catchment, in degrees Celsius[[BR]] [[Color(,#3849ce,window)]]: the ID of the data window to which the named river belongs[[BR]] [[Color(,#3849ce,Shape_Leng)]]: [[BR]] [[Color(,#3849ce,Shape_Area)]]: [[BR]] == Comparison BDCarthage (green) - CCM (red) from different views == [[Image(source:data/Docs/trac/Comparaison BDCarthage CCM Vue3.jpg,600px)]] [[Image(source:data/Docs/trac/Comparaison BDCarthage CCM Vue 2.jpg,600px)]] == Comparison WFD art3 (red) - WFD art5(gray) - CCM (large light blue) from different rivers and lakes in Ireland == [[Image(source:data/Docs/trac/IEWE.jpg,600px)]] == Comparision of riversegments length CCM #32 == == Layers necessary for France == - Europe - France[[BR]] [[Image(source:data/Docs/trac/CCM21/Europe-France Longueur des tronçons CCM.jpeg,300px)]][[BR]] - Loire Bretagne - Bretagne[[BR]] [[Image(source:data/Docs/trac/CCM21/Loire Bretagne Longueur des tronçons CCM.jpeg,300px)]][[BR]] - Bassins français[[BR]] [[Image(source:data/Docs/trac/CCM21/Longueur des tronçons CCM par bassin.jpeg,300px)]] More details on how to explore the ccm (get the upstream segments...) here ["CCM2 download and load"][[BR]]