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"] === 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 catchments === [[Image(source:data/Docs/trac/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/Europe-France Longueur des tronçons CCM.jpeg,300px)]][[BR]] - Loire Bretagne - Bretagne[[BR]] [[Image(source:data/Docs/trac/Loire Bretagne Longueur des tronçons CCM.jpeg,300px)]][[BR]] - Bassins français[[BR]] [[Image(source:data/Docs/trac/Longueur des tronçons CCM par bassin.jpeg,3000px)]] More details on how to explore the ccm (get the upstream segments...) here ["CCM2 download and load"][[BR]]