saniBID RedBasica - plugin to assist in sewage collection networks projects with Leonardo Nazareth.

and uh that should start us off we should be live right this moment alrighty um welcome to everyone and welcome to the qgis open day for august or this month whichever you prefer so our first session is going to be fantastically interesting um it's going to be given to us by leonardo and he will be taking us through an amazing plugin that he's been working on that works on network analysis specifically to do with sanitation um so i'm going to hand right over to him to take us through this awesome work he's doing over to you leonardo okay thank you em well like i'm saying i'm leonardo nazareth and i'm really thankful for being here and i want to thanks the qgis open day organization for the opportunity to talk to you guys well let me share my screen and amy please talk me if anything goes wrong i will do let me stop the camera and again here i have to change it okay it's good yep i can see perfectly okay so um well i'm talk i will talk about sunny beach head bicycle which is a qgis plugin for support in sewage collection network projects i was talking with him before the presentation it's been developing since 2016. it's a long time and we have the support of the amer inter-american development bank and the spanish agents for international development cooperation so it's a part of an ecosystem of free plug-ins and courses the with sanitation theme as background and we are working now to develop this website to put all the material together and now we are releasing the version 1.0 which is the first 100 open source version because until the last version we depended a lot of an exo spreadsheet to do all the calculations so the challenge was to bring the exo spreadsheet to to works with qgs uh just to put in context how big is the water and sanitation problem around the world well according to the united nations we have 2 billion people with lack access to safely managed drinking water services and 3.6 billion people almost half of the global population lacks safely managed sanitation services like we can see here at the right we have this two maps and we can see that the lighter the color the worse the situation so it shows us uh how the situation is worse in countries in developing countries like in south america central america africa and some countries in asia too well in my uh i have this strong i believe that if we give access to technology and knowledge to the professionals and we can face this challenge uh to give universal access to everyone so in based in this philosophy how can qgis as an open source software of gis helps us to face this challenge i have separated here some typical planning and management steps of sanitation working qgis helps us the first one we have a preliminary studies which is the definition of the project area definition of watersheds work with topography population growth studies or analysis in all this this step we have a lot of material and tutorials free in the internet and we already have the tools inside qgis for example uh the material that professor hans from ehe delft university makes available through his youtube channel and also through the the portal gis open courseware so uh then we have the planning project step which is the design and sizing of sewage collection systems and the comparison of alternatives and we have the implementation of water and sanitation services and it can be supervised by mobile softwares for example like q field or input app from leicester consulting they are also free so we can we can work with that and in the management step we have the asset management evaluation of network performancy we can look for leaks or obstructions in our network and in this field we also have just water which is a free plug-in too for from for cuisines farcuges and it's it is well known and there are some companies using it around the world so where sunnybeat fits here and well let me put the next here sunnybeard is inside the planning and project and it's it's inside of this this step mainly because there aren't many qgis solutions focused in this in this area so now let's stop talking a little bit and i'll go to the fun part of the presentation which is the working with the plug-in and we'll do a little example here any questions amy or we're good we're good we just have a couple of people greeting us from all over the world particularly brazil so hi my crew [Laughter] okay let me see here okay you are seeing the sunny beat the github yes i am okay here i have to thank some people well to install the the plugin is really simple we can let me see my camera is on or off apparently it's off oh good it it's supposed to be uh okay so chewy style qgis plugin it's really simple it's like almost the the plugins in qgis sunnybeat has his own github so github dot cons like sunnybeard slash hedge like a red in in english but in portuguese in spanish is red underscore basically and the links will be available in the in the presentation that i will give you okay so first of all i want to thank you my developers like i was told before i have martin and fed federico sanchez from argentina working with me and now i have the support of martha too and because i'm not a python specialist so i'm just to the the sanitation consultation part i have the ideas and they put the magic to to happens okay i will download here we can go to code and download the zip file this is the plugin and i will save it on my desktop it's already done and now going to the thermos qgis okay here choose install plugins in zip files we can come here in plugins uh manage and install plugins and then i click here and find it in my computer the next step is just to open and click in in install plugin i already have installed so i will not do this but it's okay uh with the plug installed we can show the toolbars and the pano2 so i came here in view toolbars and i find here sunny beach hedgehog with a click all these green bottles are from sunny beach and i can go to view panos and do a click in sunny beach so i have this this panel here now what uh sunnybit has that make it different from the other softwares include the paid ones and we always try to keep it as simple as possible so the user needs to enter almost nothing while it's doing the the sewer network while it's drawing drowning uh the plugin i always put the designed network in the shallowest depth as possible respecting the the project's parameter so why it's important why put the depth in the shallowest is the best way the optimizing the the network uh the depth of the network is the factor that most uh influences the cost of the of implementation of sewerage system so in order to save money we have to seek for the shallowest network as possible okay now we are starting a new project here and we just need some and let me open here we just need some base layers to start a project and in this case uh we will work with cap ichin is a city on the north of aichi that we have working it to do a condominium project and we we have here the image we can see we work mainly in the downtown part of the city which is pretty dense how you can see let me just put a little bigger here okay and we have also some base layers for example the streets the construction all that came from openstreetmap so it's all free and available everyone can go and and download it and we have here the contour level which was generated based on the dem file so the dem file in this case i will show it here it was done by a drone survey so it's pretty accurate in this in this particular case but we can work with srtm or aloe's dm and for basic projects it will be enough uh these all srtm and allows are uh disposable are available online it's really really simple to download it and there is some plugins in qgis to help us in that so now we have to configure our our project to sunnybeat head basically and i do that clicking here in this first button and i have to create a new layer if i had i uh if i already have a layer i can select here for but in this case i will create a new one and this will be the pipes layer the sewer the silverage network so i will put sewer network and click ok the layer is created and it's here well let me just turn off a little bit to keep it cleaner to see and now to start a sewerage network project we always look for the topography because we have to go from upstream to downstream i will talk a little bit more about it later but that's how we have to know now yeah general i will always explain a little bit more so to help us in this visualization i will turn on i will put this i will click in this button which will add in another layer and it's important to say that to drowning here is in sunny big hedge basket we always use the tools from qgis then achieve tools from drawing editing in all the stuffs so i will put the layer in the edition mode click here to add a new line in like in qgis i do left clicks with the mouse in the start and end of point that i want to put my arrow looking here at the contron level i don't know if you can see the contouring level pretty well because it's let me put it a little bit darker here under here okay here is now we're looking for the we are looking these contouring levels and we can put where probably will be the lowest point in each one of these blocks just sort of clicking and manually entering those yeah yeah it's like just to help us to visualize where the topographer are going and where we should put our network okay and now we can start to drowning the the network which is the main part of the presentation okay i put the sewer network layer on the edit mode and here add lin i add the line feature i can use the advanced digitalizing tool to see the distance and stuff like that and where the same thing left clicks will be the vertex of the collector that i'm drowning and this vertex represents manholes a little explanation here the main holes in sewage systems will be always in the corner when we have a change of the directions of the the network and also we normally limit the maximum length of each segment of the network to 100 meters it's because the operation and maintenance but another story just let's keep it in mind okay i will start drawing a network here and what happens if i don't follow the the arrows here i will show you guys i will start drawing a network from here and i'll go to here here always doing left clicks and i go here and i will finish here to finish i do the right click with the mouse and it will show me this window where i have to put the name of this segment or the name of the collector and the initial count the number of the first segment of this network so i will put here collector one and it will start for the beginning to start for the the number one okay so it's here let me just show you we have some informations here which is the identification of the the collector and the number of the segment and the extension okay so uh we'll draw another uh networks here i'll put here and i will connect to here to do the connection we can use the snapping tool here in qgis so i enable it and i do a left click here and right click to end so collector 2 starting from the one i will do another collector here collector three starting from one and i can do something like that it's just a an example so don't don't worry if nothing and another one here just to finish collector five okay now that i have the my little network drawn i can create some nodes that will represent the manholes and i do it clicking here in the second button here i can name this layer that will be created so i will put manholes and i can select a haster where the nodes will capture the terrain elevation so i will choose the mdt which is my dem and click ok so here we have the elevation the terrain elevation in each one of these points and how i know if this if this network that we're drowning it's good if the layout is good how i said before we have to look for the we have to seek for the shallows depth so we have a tool here to estimate the depth of the sewer and it will help us because we can uh look for the best alternative before i send everything to the calculations so we have to we can test some alternatives and when we think it's it's good we send for the calculations uh this third button here is the to estimate the depth and base it in some basic parameters we can change it and the the the value change but i will keep it as the default we have the minimal coverage we have the diameter we have slope and we can put an initial depth in each initial segment of the network so clicking ok and i have to just uh refresh the canvas or go the winzo out and it's okay so here i have the depth of the the network for example here we are the minimum that but we can see here it's a little bit deeper but in general it's good if i want to change something in my in my network it's really simple i just put on the sewer network put on the addition mode i can using the qgis to select some segments i want to change for example these two and i will deal it okay then i start drowning again i don't need to worry with this main hose because it will be refreshed so i can start drowning here here and connect here so it will be the collector six starting from the one okay so like i said i need to refresh the manholes just click in the second button and say again where the haster file is and clicking ok it will be refreshed so i have now the the new positions of the manholes and then i can go here again and do another estimative so everything fine here well the [Music] the next step uh we have another two that i will talk a little bit about that is the rename the the segment so i can rename if i i want to rename this segment i will put collector seven start phone one and the name is change it we have some rules about names too because to do the calculations i have to follow some order but i will not into details here too i will just avoid talk about that we have open course that explains everything with some details now we have another layer that can help us i will just save here and save here and the layer will be created here it's a point layer and it works to identify blocks and put the number of hazard for households for beginning and end of the plan but we also can use it to put some concentration concentrated uh wastewater flows and say where it is discharging in our network for example i will let me see a good point to put it okay i will put it here i will call it concentration concentrated 01 and the number of households at the beginning of plan it will be we will have a concentrated flow with the equivalent of the number of households i put here so i will put 200 households in the beginning of the plan and 2 000 for end of the plan clicking ok it's here and how can i inform where the the concentrated flow are discharging i can just select one segment and here in the panel i have the informations of the segment that are selected and i can just put the name here c01 it will be it needs to be exactly like it's here and to save i can click and save or i can go to the downstream to the downstream segment clicking here or go into the the upstream clicking here it's a navigation button for the the collectors and here i see that i have the equivalent quantity of occupied lots in the block at the beginning of the plan so i have 200 households here great the next step we have some tools to see to look for errors in our network because who whom who work with networks in qgis and other softwares knows that it could be uh real headaches we have a lot of topology in your horse so the first one is to check if all the of the segments are good connected i click here and in this case it's selected only the last uh segment i have so there is no other segment down strings it if i click here and the plugin select another one for example if it will select this probably i will have a connection error in this area so i believe that we are good now and then we have the another verification network consistent which will search for another topological errors and look for segments without manholes and other stuffs i click here and there's no unconformities so we can now go to the calculation part the calculation here uh i will just do a little intro about hydraulics because it's not a fun part for those who not work with sanitation i believe but in general terms the size of the sewage network have to serve the people at the beginning of the plan and also from the end of the plan when when the population probably will grow in terms of hydraulic hydraulic it means that the pipe have to have the capacity to collect all the future waste water flow but we have also to ensure that the in the beginning of the plan when the waste water flow is smaller we have the solid particles of the waste water be carried by the liquid part so we always check this these two things when we are sizing our network and well clicking him in the last button i will open the calculation application and i just put some name for my my example i can choose a choose a country that i'm working put the name of the city for a second yeah of course so um paulo bernardo says um that he was trying to follow the steps but it seems to have some problem or issue with the projection system he is using um sigris 2000 espg4674 is there a specific spg with which the plugin works no uh i don't talk about that but it's if the project is in the in some planned projection like srt uh like uh wgs utm or serious mu like he is using it should work fine but there's some steps to do because we have to put the all the project in this in this projection before create the zebra network layer so probably here we want to go back again start a new project change the project's uh projection like clicking here and after that he can create the sewer network well it should work if don't work i have i will at the end of the the presentation i will send you guys a link for the youtube channel that will have uh entire course a lot of tutorials about that is that are those free tutorials yeah we have um uh 20 videos i believe it's really it's in details there that's just passing fast here because we don't have this this much time absolutely and i will get the link for those tutorials from leonardo and put them into the description of this video um for the recording um palo says thanks a lot okay thank you paulo and i will put my name here as an author and click ok so we have here the parameters window first of all we have to put the occupants rate uh number of households number of people per household so i put four people in each household here and then we have the concentrate the the contribution of sewage types so we can consider the contribution being concentrated per block just a zipper further we can do the the contribution concentrated in the blocks like we did to the concentrated wastewater flow but in this case we we need to inform all the blocks the number of the households in beginning and off plan and inform where it is discharging in our network and we have the linear contribution where we just inform the population from beginning and from the end of the plan and this population will be the flow the wastewater flow of this population will be distributed along the sewage network so i will use the linear contribution and just put 200 people at the beginning of the plane start of the plan here and i will put 500 people for the end of the plan okay we also have a second window here and in this window it's it's important to say that all the calculations are done in the brazilian standards but the user can change all the parameters to best fit his his local standards uh here are the parameters i will not change anything just to keep it simple and i also have a pipes catalog and the manholes catalog 2 everything is flexible so the user can change as he wants let me see now i click in ok and here we have the main window of our example this window is like us it's simulating a spreadsheet like i said we use it to work with excel and now we bring all the calculations from for this this window here each row is one segment of my network so i can see that we have some integrative here it's integrated so i can select one segment here and the segment will be selected on my qgis canvas i also we have the columns that are the attributes and you can just send them out here and see the tooltip what this attribute means and the unit of it so here we have uh flows attributes here the attributes that are talking about dabs slopes the diameters adopted in our in our network in each one of these segments and here are the hydraulic checks so to sizing our network we have to looking for the hydraulic checks do the adjusts to the network works fine and i can change all the yellow cells in these in this window manually so i can just select and put a valor another value that i want looking for the the hydraulic checks i can see here that in these three segments i have a problem with the water level so in sanitation we work with gravity as in we don't use the pipes in the full capacity we let me see in this project in this project i'm working with tops seven five percent of the diameter of my pipe so here the end shows me that in this case for the end of plan this segment is over than 100 percent of his capacity of the pipe so i can just click here and put another diameter and it it has to be in the catalog of the pipes but i know that 200 is there and i just click enter and the calculations are done so i now i have 50 of the pipe fully i can do the same here but i can also select more than one click with the right bottom mouse and as its value put for example 200 and see what happens this is good but in this one is eight five percent so i have to reach seven five so i can put 250 here and it's okay we also have some functions to do this calculation sem automatic same automatically so i'm not talking about that now but if you have a lot of segments it's better to use the the the functions okay another check that we have to to to look is the attractive force this means that the solid particles will not be carried for the by the the liquid particles of the the wastewater my minimum attractive forest in this project is one pascal and i have 0.85 to fix that i can select the slope of this segment and increase it a little bit so i will put a half percent and it's good now okay all the calculations of depth are done automatically and it's always seeking for the shallowest uh network as possible as i said but the user also can do changes manually here for example if i have an interference in this last segment of the collector one i can just put a value here for example 4 meters and the calculations will be done if i do it in another in an intermediate uh segment for example here the calculations be done and here it comes shallowest again because the calculations are running but if i i change here i have to check again at the hydraulic checks okay i will just delete it and lastly the last step of the calculations is the adjust water level calculation it is done to avoid the phenomenon of back water a drought back water in the pipes and it's the most complex calculation we have in this in this application i have tested it with 500 segments and it takes no longer than two minutes so it's pretty good in this case it will be just a second i will click ok and it's calculating here and everything is done i do another check at the hydraulics and we can see the adjusters here for example this the bottom of this main hole is a little bit deeper to avoid the phenomenon okay everything done how can we export the data back to qgis i came here export data create qgis layer and i can create a new layer with the information but i will override the current layer click ok and let's go back here nothing change so i have to click on this button that will alternate the style of my layers clicking here i can see now the information brings from the from the calculation and i will just using the labels too in qgis i can replace the labels of the manholes and all the stylish all the labels are done with qgis [Music] the qgis2 so you can personalize do all the stuff you need with the style in the labels okay another way to see the the results we can just go to server network select one specific segment and we have here all the informations of the segments uh like in the calculation application we can just extend the mouse a little bit and we'll see what this means so this one is the total flow rate at the end of the planes in liters per second so all the informations including the drought informations are here we can go to the next one and see what happens all the information are here uh okay lastly i believe everything's done so i will show you guys uh a different style that i work in the using the key gis symbology and labels rules in this one i have to thanks marcelo de sa from the qgis brazilian community because a couple years ago a couple years ago i put the some doubts in the the qgis community and he asks me and he answers me so inspires me to do this this style here from the manholes let me load it this is so we in this style you can see we have a cleaner visualization and we can also see the the guideline to show from where this information are coming from i just talk a little bit about this this is the collector name and segment the extension the diameter that are adopted in this segment the slope this is a a little step or uh how can i say two buckets it's a step or a drop that we have here to avoid the backwash the backwater phenomenon and here in the main holes we have the type of the manhole the depth the terrain elevation and the elevation in the bottom of this manhole so thank you marcelo again for doing that and helping doing that so [Music] okay uh i believe that that is all we have our network finished here i will come back to my presentation just to show you guys the links that i i was talking about change here okay well amy i don't know if you have a lot of questions but if you have i can answer but first i have to talk that we have an entire course it's free and it's available on the youtube channel let me see if it's working here okay so the youtube channel is sunny beach head basically and who wants to know more and learning all the details of the the the plugin we can come here in this playlist and we have a lot of videos here it's like 20 videos so almost the all the videos have five or ten minutes but we have some big videos like 23 minutes about the calculation steps it's important to say that this course had been done in the the older version so it's using the excel spreadsheet you do the calculations but we are already working to update it and probably in september and or october the videos will be will be refreshed but all the drowning steps it's good you can't follow because it's the same that we present in this you 1.0 version and we have the information the download and more information in the github you can come here and we have some links and i will put here the link for the quick guide we have a 20 page quick guide it's in french english and spanish and portuguese of course and ah it's important to say that the videos are also they are in portuguese but we have it's subtitled in french spanish and english and so everyone can follow the steps well that's everything i thank you guys for the patience uh sorry by the way english like i was told english no it was absolutely fantastic not a problem at all i hope it was understandable no absolutely i think your presentation was absolutely fantastic very clear and easy to follow so thank you so much for showing us this fantastic um plugin and i think it's great that there are some extra videos and a whole youtube channel that people can really go find out information um there are a couple of comments and questions that i'd like to just pose to you okay put my camera on so we can see each other alrighty so um let me have a look at our little live chat here so a lot of questions i might be butchering that i'm sorry my english tongue doesn't do that um so the data visualization was excellent and he was happy to have helped um this one is the who helped me in the in this style oh brilliant so do you have any suggestions for generating longitudinal profiles of pipelines a long longitudinal sure so do you have any suggestions for generating longitudinal profiles of pipelines uh i don't know what that means but it's problem uh a bad english for me is um foreign it's from the hera okay so let me check if i can see it on there can you put in the chat yes i can maybe because you can then go from english to portuguese i'm sorry i don't speak enough languages yeah uh well if you're having fun and maybe some very patchy zulu there we go i put it in the comments where can i see the comments ah technology issues well just let me put in the youtube channel and i can see awesome i'll just move on to the next question so long um john boyd says the plug-in looks great does it facilitate inflow and infiltration checks or do you just run the plug-in with with the different parameters yeah we're in brazil and we work without uh considering the the if the intake of uh drainage water drainage water let me see from pluvial water so we have the intake we have a parameter for intakes uh in the example let me see i was considering i can see here in the parameters uh intake rate i have considered in this 0.01 liters per second per kilometer but you can change it but again it the calculations are done just considering uh the separated of the sewerage and the proven water let me see do you have any suggestions of generating ah longitudinal profiles of course uh we are working in a two-two longitude program longitude now profiles right now probably it will be done in two months and it will be not just for generate this this profiles but also to check if they if the network is in the right place if we have some interferences you and you can and we can adjust the depth of the the segments using this profile so just wait a couple months and we'll have this too okay great so it's basically in the pipeline yeah um so um the next sort of question along the line is it's a good solution for network planning can i use this tool to analyze an existing network within an enterprise environment with data stored in postgres sql yeah you can use it well the connection with qgis brings us a lot of possibilities for example i don't comment here but we have and we have the possibility to export this for uh the ink format which works with sewer with swim which is an open source software to do all this is more complex hydraulic and hydraulic analysis so it's it's possible to you link everything the the layers are there the layers are in shape file now but you can change it for job package you can put in in some database formats and it will work fine including all the calculations are done based in uh postgresql databases all righty great stuff um we have another comment that i've just sent for to you that's from perry i'm sure you'll be able to read it yeah yeah it's he's talking about the the the question about the longitudinal profiles that i don't understand he is my father oh hi nice to meet you thank you for watching he helps me in this plugin it's the specialist in sanitation too oh wow fantastic we have um gurus in the room with us yeah i bring my crew back backup um so yeah those are all the questions we've had and i just wanted to thank you so much for giving us this fantastic talk and introducing us to the um plugin i think you know it's got so much applicability around the world especially for infrastructure planning and even maintenance and also you know bull building new infrastructure and i think it's really great because you know qgis is so widely used and free and open source and coming from a developing country and a developing background i think this is an amazing tool to be able to use um okay thank you m and i want to thank you all and if you have an doubt you can send me an email the email is here i will send the links to them to put in the in the video in the description i will put them next oh one last question has popped in um whether it would export data to swim ah this is nerve cell i'm reading here yeah and i said let me well it's take it takes three three seconds i believe uh we have the the calculations here and we have the export data we can put generate input file and export the the network that we have sizing for the final flow or initial flow and i click i just select from where i will save it and it's here in my desktop probably uh let me see it's here so i can open it using swin or other one of the hindered file one of the hundred programs that work with it so it's it's another possibility well thank you all if you have another questions send me an email i would be happy to to answer you all that's great all right thank you so much everyone for watching um please do hang on cheers leonardo please do hang on for the next um session that will be coming um in the next hour so whoever's following today's qgis open day do come in it's going to be really interesting with um just 3d visualizations so we will see you all for the next session that's coming up in 10 minutes thanks so much leonardo bye-bye i'll see you in a couple minutes alrighty

Channel: QGIS

Views: 711

Keywords:

Id: 1GWNg3zp8H0

Length: 51min 5sec (3065 seconds)

Published: Fri Aug 27 2021