OpenSource GIS surveying - water application
CC Attribution 3.0 Germany:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Picavet, Vincent
It became possible lately to deploy a full OpenSource application stack for field surveying. This presentation describes a water distribution and waste-water management project from a technical point of view, with a strong integration of mobile tools within an industrialized GIS.This projects features a GIS part, with a centralized reference data storage leveraging PostgreSQL/PostGIS, and uses QGIS as a user interface. This combination allows to manage custom data with high volumes efficiently. The project also includes an important mobile side. Implemented on a rugged tablet, a custom tool has been setup to capture and enrich field data. The software is based on ROAM, a new OpenSource software designed for field survey. The tablet is connected on a 3G/4G network and takes advantage of a GNSS antenna to increase GPS precision. It also features an autonomous offline data management module, so as to be able to work in bad network access conditions. The tablet also embeds all required data for greater efficiency. One specificity of this project is the implementation of a synchronization tool between the data used in mobile situation and the reference data, in a multi-user environment.This synchronization tool, developed with PostGIS and SpatiaLite, let users manage data history, data modifications, data merges, offline mode, as well as branches, for parallel versions of the same data. The latter enables the design of evolution scenarios of the network. A classic issue of the surveying work in mobile situation is therefore solved, being able to work in a disconnected mode with multiple land surveying teams smoothly, while keeping data traceability.The project currently evolves towards water simulation integration, interconnection with SCADA industrial systems, and sensor data automated integration (through webservices).All These components therefore constitute a full software package, fully opensource. The various components can be used for other applications than water management. The new features developed thanks to this project can solve mobile GIS issues, and optimize the TCO of GIS solutions for industrial projects, for real-world critical applications.
 from Hustlandia and I'm going to talk to you about the open source tool for surveying applications, especially in the field of water management. So yeah, if you don't know Hustlandia, we are a GIS company, open source GIS company, you can go on our website, you'll know more. That's not the subject of today. Today I'm going to talk to you about first the context of the project we realized, then the exact needs, then all about the GIS part we have developed for this project. I talk about data as well, and then more specifically about surveying, so the hardware part and then the software part for surveying application we developed. I'll have a word about versioning too and then I'll extend to a simulation and the future of the project. So, but the main part will be about surveying hardware and software. So the context of this project is a place in Romania which is called Valcea at Cunti. That's about 300,000 people and actually it's well known because it's called the capital of the hackers. It's a place where all the people are trying to do phishing to your email icons live, so and they have big BMW cars and sunglasses and all, it's pretty wet, but they also do some like normal stuff and there is a European project for the water network development in Cunti and so they got money to improve all the water distribution and waste water. So that's more or less 29 pumping stations, 19 wastewater stations, 1,000 kilometers of distribution pipes and 350 kilometers of waste water area. So there was a strong need for GIS setups, they are quite nothing to organize this project. The project is very global one. It goes from planning to IT to buying land and to buying pipes and actually building the water network distribution. I'll be talking about GIS only, so we worked with the APAVIL company which is the company in charge of water distribution. So the need was a desktop GIS first, they needed the employee to be able to do GIS on a classic desktop machine. They needed a field data model as well for water distribution. They wanted to build a model for that. They needed a centralized data repository as well, surveying tools which is the main focus here. And they had some very specific needs given the constraint of the country, they had to do offline because there is no internet everywhere. So they had to be able to do surveying with offline management. And they wanted also to have version management of the data. So they wanted to be able to do scenarios and to say, okay, if we develop this part, what's going to happen from one version of the data being able to have different branches. I'll talk about that later. Simulation coupling was important as well, so being able to run simulation for water distribution and then on the further needs there was map and web rendering. So we provided them with expertise. We had to buy hardware as for the GIS desktop and for the surveying tools and of course they had to find some software and they were very keen to open source. So they wanted open source software for all of the application, be it for desktop GIS, surveying or map and web rendering as well. So let's present that a bit further. As for the desktop GIS, the choice was quite evident now. You all know QGIS. So that's a project we chose to deploy for desktop application. And we did a lot of project development, I mean QGIS project development in this global project. So that's determining what object we were going to use, what the symbology would be for the different objects, defining composites to be able to print maps and edit some specific forms as well for the user, for the desktop GIS user to be able to enter the data with good ergonomics. We provided some plugin training. You probably know that QGIS is very extensible. So there was a lot of plugin development to adapt QGIS interface to their specific needs. So we provided training as well so that they would be able to develop their own plugin for their very specific needs. So that's for the desktop GIS. Also the data repository, well, PostGIS was a good choice as well, probably the best one. We used version 9.3 and we have a data model designed to do so I'll talk about that just after. We provided training as well on PostGIS so that was everything new for them. And we also used specialized for embedded data, so for as an embedded database and especially for offline management. That's globally the GIS architecture we are using. So QGIS are the client, desktop clients for data management, database management with PG and MIM as well a bit for the database. Then as central data repository on a server with the special database of PostgreSQL and PostGIS and some additional files as well for Waster for example. So that runs on the PC, that runs on the server. And the surveying part here is the one we paid attention to for this project because of the specific constraints that offline was for example. So we had tablets, I'll talk about that. So that's a mobile client, that's a PC tablet and the data had to be embedded as well inside the surveying material and software. So we used the special light and Waster light to embed the data on the hardware. And between the central repository and the specialized embedded database we developed a specific synchronization tool for offline management and versioning. That's a global picture. So I'll talk about this and this part more specifically. First of all, the data model. So we needed a distribution, water distribution data model as well as a wastewater data model. There is no standard, no global standard for water distribution models. So we talked with SCG, which is a Swiss public organization in charge of water distribution and they have a project which is named QWAT which concentrates on a focus on water as well. So we tried to materialize efforts to get the same data model so that our development we could make on our own could also be interesting for them and opposite what they were developing could be used on our data. So the model is pretty complex because you got nodes, pumps, valves, leaks, pipes, station pressures on it, etc. So lots of different objects and relations. But it's a pretty mature data model for water distribution and we are glad to be able to use it and discuss with them on some modification we had to make. As for wastewater, that's still a work in progress. There is a Swiss standard as well so maybe we're going to use that but not for sure yet. So that's the model. As for surveying specifically, so first part was getting good hardware for surveying. So we needed a GPS antenna. We used the Leica Zenos GG03, I'm not a hardware expert so that's not me who chose that but apparently that's top of the top antenna, GPS antenna, pretty expensive too. And they didn't want to use the embedded device which was delivered with the antenna so they chose to buy some PC tablet, PC oriented tablet so that's a rough tablet. You can use it under any conditions. That's Panasonic, that's G1, FZG1. So very good hardware and you can see they are happy to use it. So that's a hardware setup. So Panasonic FZG1, it's got Windows 8 and we needed to stay with Windows because drivers for the antenna are only available for Windows so we couldn't switch to Linux. But happily we could use Windows 7 which was much better on the tablet. So it's high end tablet, 64GB architecture, 4GB RAM, 113GB SSD disk, it's got Wi-Fi, it's got Bluetooth, it's got 4G connection, a 10 inch HD screen, it's got touch and stylus on the drug and it costs quite a lot of money. So that's 2500 euros which is in dollars, I don't know, 3000 dollars or something. So high end hardware, the most important part is that it's the PC architecture. So it's not Android, it's not iOS, it's a Windows tablet so it works exactly like a PC. So the software, we could have used QGIS just like it is just raw on this tablet because this is a Windows one but since it's oriented towards touch and using a stylus, QGIS is really not adapted to that. I don't know if you've ever tried QGIS on touching QGIS menus with your fingers, it doesn't work. So we had to find something else which would be more adapted to surveying and more adapted to our specific constraint and our specific field which is water management. So that's someone working on the tablet and that's the constraint we had for the tablet software. So we wanted NMEA GPS support which is the antenna we have, we wanted domain specific object as well so not like a generic GIS but very specific object like pipes and valves and all. We wanted to be able to digitize directly on the tablet, we wanted to be able to take notes to use the camera to take pictures, we wanted a good guy and good ergonomy especially for touch and stylus and we wanted that to be open source. Comfortable, translatable into Romanian and we wanted like a QGIS compatibility. What does that mean? I mean we wanted all the work done on the desktop to be also usable on the surveying hardware and software. So let's present you Worm. So Worm is a tool made by Nathan Woodrow who works for DMS in Australia. That's an open source application, that's a specific application but it's QGIS powered so it's based on QGIS libraries and it's very different applications, completely separated project but you can use the same rendering and you can use the same project so every project you do in QGIS you can use it with Worm. That was a very good point in terms of materialization of effort, you don't have to read with the work you did on your desktop, you can directly use the work you did on your desktop on your surveying software. It's got raster, vector raster, so same project and same rendering as well, the maps are exactly the same. You have vector raster and you can do online or offline data management. So that's a pretty good project, it's got data in specialites or you can use whatever data you want and a very important point, it's got a project management guide so I'll show you some screen shots just after so that developing a new project for mobile application is really easy. So it looks like that, as you can see it's a very simple interface, it's very oriented towards surveying because you don't have any menu, you don't have any small elements, it's big buttons, very simple features but important features. So that's exactly the rendering like we could see it in Qtis, so we did a Qtis project and then used it with ROM and you can see the main features which are classic GIS features. You have camera use as well, capture for digitizing with a GPS, capture a point for example and you have access to attributes as well so you can select any elements and access to the information which are specific here to pipes, that's in Romanian. Can any of you read Romanian? No, I can't neither, but that's a pipe. So you can enter new data, you have specific forms for the data you want to enter in so it's very clear, it's very big, you don't have any problem to enter your data. You can completely configure the forms so you can have some predefined data so that you know exactly what you are typing. We have a virtual keyboard to help for typing, not for normal keyboard or whatever. You can select the objects here, you created a new object, you can have some different raster layers as a background and you can capture the data. So you can record the GPS and then it will add new elements as soon as you move or you can capture as well points if you want. So that's the application, final application, so you can see it's very simple but it's very efficient in terms of surveying tool. What is good with ROM is that it's not only an application, it's a meta application, you can build an application with it and you got a project management guide with it so that you can define all your preclication inside a guide. So I would say I got a new project, for example a three inspection project, that's a sample project from ROM and you can select a few different configuration options, for example the title, the description, you can select, so you take a QGIS project and then you can select the layers you want to display, you can display logo, all kind of configuration and then you can see the map as the final application will render it. You can as well completely configure the forms you're going to have available for your user so you can say I want a field which is of type list for example, I want specific values for this field, etc. So every kind of form is configurable and you have a preview and you generate actually the project which I showed you earlier, so it's very easy, we actually set up the first project for the client showing him how you do that and then we said okay you got the project management tool and they built their own project, they are on application within a few weeks without problems so it was very good. So one point was versioning as well, so we had strong project requirements, we wanted data history, we wanted offline work and we wanted scenario management so that's all together makes like data management, data versioning needs and we actually built a new project called QGIS versioning which is based on post-GIS and spatial light and which is kind of a subversion for the database so with the concept of commits, branches and with a conflict management tool. So the principle is you get a working copy, you get an offline copy of your data, you get it on your tablet, tablet hardware and you can work on it and then get it back to the central database and you can as well do working copy inside the database without having to put it on your tablet so you can work directly everything inside the database. Next the workflow to update the data, so you got the reference repository which is the main repository for data. First of all to create a working copy for your user here so you got a local database then you do modification offline and third step is to do a working copy update whenever there is conflict you have to deal with conflict and merge your modifications with the modification which have been done meanwhile by the user B and then once everything is alright you can commit the modification to the reference repository and the user B can do exactly the same in between. So we got versioning and we got offline and we got some conflict management tool. So every time you commit your data you're going to say commit message and then it say okay it's you successfully committed your modification to the database or it says you have some updates to do before. We got conflict management, typically we got here data which has been modified on both sides so inside QGIS you have an interface where you can choose which data you want to keep or you can do modification of data. First point was about simulation that's not exactly surveying that's an extension of the water project globally. We integrated epanet which is a hydraulic simulation where you can do simulation on the water networks to know what pressure will be on what pipes etc. And we integrated that into the geo processing interface at QGIS. So it's a plugin and you can do time plots for example of the water level of tank. You get map of results with specific pressure points with indication on the pressure level for different pipes and all. So we are going to do the same with SWMM which is a code for simulation for wastewater. So for the future of the project so that was what was developed. The future of the project is to have better domain specific objects so there is a lot of QGIS guy mainly to do to better integrate some water management tools. We want to improve the surveying software as well so GPS tracking has been done, capture data on canvas has been done already as well but the ROM application can be now extended with plugins so you can add some new features to the surveying application. And then there is some more global improvement for SCADA connection for example to control the valves, remote, geo web services, sensor oriented services and globally to have an integrated software stack for water management, water distribution. And try to build a community as well so every people interested in water distribution software open source based on QGIS, PODGIS are invited to contribute to use it and then to fund it if you can. So that's mostly it for this presentation. If you have any question do not hesitate I think we have some time for questions. Thanks. Questions? No question? Or that's yeah. Do you know if there are some applications for park and green space management? Parks and green space management in the same way? So I don't know if there is any actually live at least not publicly probably there are some people who developed some application for park management in QGIS but they didn't publish it or didn't try to get others to use it. But if you already got QGIS and QGIS project and all if you want to do some surveying this ROM tool is really easy to set up. I mean within a few days you can have your application running and if you don't need any real complicated synchronization it's pretty easy to set up. I was wondering if the software for doing the synchronization between QGIS and SQLite is available? Yeah it's available. It's on GitHub. If you go to Iceland it's GitHub. It's still bit rough so it works in this case. We haven't deployed it in other projects than this one. But you can download it, use it and it should work. So it's open source as well. I have another question too about composers in QGIS. It seems like when I've used them that produces very large PDF files. Did you get into that problem? Well it depends also. You have two modes for exporting composers. You have vector mode or you have raster mode so you have to check that you are in vector mode for exporting and sometimes some layers cannot be exported as vector so the whole composer export is converted to raster. So that may be the case. And we are actually working as well on improving the SVGA export so that we can have some like real good SVGA export from QGIS if you want to go to Illustrator or something else and to have better editing for vector, big vector maps. Great, thank you. One more question, last one? No more question, perfect. Thank you.
 from Hustlandia and I'm going to talk to you about the open source tool for surveying  applications, especially in the field of water management.  So yeah, if you don't know Hustlandia, we are a GIS company, open source GIS company,  you can go on our website, you'll know more.  That's not the subject of today.  Today I'm going to talk to you about first the context of the project we realized, then  the exact needs, then all about the GIS part we have developed for this project.  I talk about data as well, and then more specifically about surveying, so the hardware  part and then the software part for surveying application we developed.  I'll have a word about versioning too and then I'll extend to a simulation and the future  of the project.  So, but the main part will be about surveying hardware and software.  So the context of this project is a place in Romania which is called Valcea at Cunti.  That's about 300,000 people and actually it's well known because it's called the capital  of the hackers.  It's a place where all the people are trying to do phishing to your email icons live, so  and they have big BMW cars and sunglasses and all, it's pretty wet, but they also do  some like normal stuff and there is a European project for the water network development in  Cunti and so they got money to improve all the water distribution and waste water.  So that's more or less 29 pumping stations, 19 wastewater stations, 1,000 kilometers of  distribution pipes and 350 kilometers of waste water area.  So there was a strong need for GIS setups, they are quite nothing to organize this project.  The project is very global one.  It goes from planning to IT to buying land and to buying pipes and actually building  the water network distribution.  I'll be talking about GIS only, so we worked with the APAVIL company which is the company  in charge of water distribution.  So the need was a desktop GIS first, they needed the employee to be able to do GIS on  a classic desktop machine.  They needed a field data model as well for water distribution.  They wanted to build a model for that.  They needed a centralized data repository as well, surveying tools which is the main focus  here.  And they had some very specific needs given the constraint of the country, they had to  do offline because there is no internet everywhere.  So they had to be able to do surveying with offline management.  And they wanted also to have version management of the data.  So they wanted to be able to do scenarios and to say, okay, if we develop this part,  what's going to happen from one version of the data being able to have different branches.  I'll talk about that later.  Simulation coupling was important as well, so being able to run simulation for water  distribution and then on the further needs there was map and web rendering.  So we provided them with expertise.  We had to buy hardware as for the GIS desktop and for the surveying tools and of course they  had to find some software and they were very keen to open source.  So they wanted open source software for all of the application, be it for desktop GIS,  surveying or map and web rendering as well.  So let's present that a bit further.  As for the desktop GIS, the choice was quite evident now.  You all know QGIS.  So that's a project we chose to deploy for desktop application.  And we did a lot of project development, I mean QGIS project development in this global  project.  So that's determining what object we were going to use, what the symbology would be  for the different objects, defining composites to be able to print maps and edit some specific  forms as well for the user, for the desktop GIS user to be able to enter the data with  good ergonomics.  We provided some plugin training.  You probably know that QGIS is very extensible.  So there was a lot of plugin development to adapt QGIS interface to their specific needs.  So we provided training as well so that they would be able to develop their own plugin  for their very specific needs.  So that's for the desktop GIS.  Also the data repository, well, PostGIS was a good choice as well, probably the best one.  We used version 9.3 and we have a data model designed to do so I'll talk about that just  after.  We provided training as well on PostGIS so that was everything new for them.  And we also used specialized for embedded data, so for as an embedded database and especially  for offline management.  That's globally the GIS architecture we are using.  So QGIS are the client, desktop clients for data management, database management with  PG and MIM as well a bit for the database.  Then as central data repository on a server with the special database of PostgreSQL and  PostGIS and some additional files as well for Waster for example.  So that runs on the PC, that runs on the server.  And the surveying part here is the one we paid attention to for this project because  of the specific constraints that offline was for example.  So we had tablets, I'll talk about that.  So that's a mobile client, that's a PC tablet and the data had to be embedded as well inside  the surveying material and software.  So we used the special light and Waster light to embed the data on the hardware.  And between the central repository and the specialized embedded database we developed  a specific synchronization tool for offline management and versioning.  That's a global picture.  So I'll talk about this and this part more specifically.  First of all, the data model.  So we needed a distribution, water distribution data model as well as a wastewater data model.  There is no standard, no global standard for water distribution models.  So we talked with SCG, which is a Swiss public organization in charge of water distribution  and they have a project which is named QWAT which concentrates on a focus on water as well.  So we tried to materialize efforts to get the same data model so that our development  we could make on our own could also be interesting for them and opposite what they were developing  could be used on our data.  So the model is pretty complex because you got nodes, pumps, valves, leaks, pipes, station  pressures on it, etc.  So lots of different objects and relations.  But it's a pretty mature data model for water distribution and we are glad to be able to  use it and discuss with them on some modification we had to make.  As for wastewater, that's still a work in progress.  There is a Swiss standard as well so maybe we're going to use that but not for sure yet.  So that's the model.  As for surveying specifically, so first part was getting good hardware for surveying.  So we needed a GPS antenna.  We used the Leica Zenos GG03, I'm not a hardware expert so that's not me who chose that but  apparently that's top of the top antenna, GPS antenna, pretty expensive too.  And they didn't want to use the embedded device which was delivered with the antenna so they  chose to buy some PC tablet, PC oriented tablet so that's a rough tablet.  You can use it under any conditions.  That's Panasonic, that's G1, FZG1.  So very good hardware and you can see they are happy to use it.  So that's a hardware setup.  So Panasonic FZG1, it's got Windows 8 and we needed to stay with Windows because drivers  for the antenna are only available for Windows so we couldn't switch to Linux.  But happily we could use Windows 7 which was much better on the tablet.  So it's high end tablet, 64GB architecture, 4GB RAM, 113GB SSD disk, it's got Wi-Fi,  it's got Bluetooth, it's got 4G connection, a 10 inch HD screen, it's got touch and stylus  on the drug and it costs quite a lot of money.  So that's 2500 euros which is in dollars, I don't know, 3000 dollars or something.  So high end hardware, the most important part is that it's the PC architecture.  So it's not Android, it's not iOS, it's a Windows tablet so it works exactly like a  PC.  So the software, we could have used QGIS just like it is just raw on this tablet because  this is a Windows one but since it's oriented towards touch and using a stylus, QGIS is  really not adapted to that.  I don't know if you've ever tried QGIS on touching QGIS menus with your fingers, it doesn't  work.  So we had to find something else which would be more adapted to surveying and more adapted  to our specific constraint and our specific field which is water management.  So that's someone working on the tablet and that's the constraint we had for the tablet  software.  So we wanted NMEA GPS support which is the antenna we have, we wanted domain specific  object as well so not like a generic GIS but very specific object like pipes and valves  and all.  We wanted to be able to digitize directly on the tablet, we wanted to be able to take  notes to use the camera to take pictures, we wanted a good guy and good ergonomy especially  for touch and stylus and we wanted that to be open source.  Comfortable, translatable into Romanian and we wanted like a QGIS compatibility.  What does that mean?  I mean we wanted all the work done on the desktop to be also usable on the surveying  hardware and software.  So let's present you Worm.  So Worm is a tool made by Nathan Woodrow who works for DMS in Australia.  That's an open source application, that's a specific application but it's QGIS powered  so it's based on QGIS libraries and it's very different applications, completely separated  project but you can use the same rendering and you can use the same project so every  project you do in QGIS you can use it with Worm.  That was a very good point in terms of materialization of effort, you don't have to read with the  work you did on your desktop, you can directly use the work you did on your desktop on your  surveying software.  It's got raster, vector raster, so same project and same rendering as well, the maps are exactly  the same.  You have vector raster and you can do online or offline data management.  So that's a pretty good project, it's got data in specialites or you can use whatever  data you want and a very important point, it's got a project management guide so I'll  show you some screen shots just after so that developing a new project for mobile application  is really easy.  So it looks like that, as you can see it's a very simple interface, it's very oriented  towards surveying because you don't have any menu, you don't have any small elements,  it's big buttons, very simple features but important features.  So that's exactly the rendering like we could see it in Qtis, so we did a Qtis project and  then used it with ROM and you can see the main features which are classic GIS features.  You have camera use as well, capture for digitizing with a GPS, capture a point for example and  you have access to attributes as well so you can select any elements and access to the  information which are specific here to pipes, that's in Romanian.  Can any of you read Romanian?  No, I can't neither, but that's a pipe.  So you can enter new data, you have specific forms for the data you want to enter in so  it's very clear, it's very big, you don't have any problem to enter your data.  You can completely configure the forms so you can have some predefined data so that  you know exactly what you are typing.  We have a virtual keyboard to help for typing, not for normal keyboard or whatever.  You can select the objects here, you created a new object, you can have some different  raster layers as a background and you can capture the data.  So you can record the GPS and then it will add new elements as soon as you move or you  can capture as well points if you want.  So that's the application, final application, so you can see it's very simple but it's very  efficient in terms of surveying tool.  What is good with ROM is that it's not only an application, it's a meta application, you  can build an application with it and you got a project management guide with it so that  you can define all your preclication inside a guide.  So I would say I got a new project, for example a three inspection project, that's a sample  project from ROM and you can select a few different configuration options, for example  the title, the description, you can select, so you take a QGIS project and then you can  select the layers you want to display, you can display logo, all kind of configuration  and then you can see the map as the final application will render it.  You can as well completely configure the forms you're going to have available for your user  so you can say I want a field which is of type list for example, I want specific values  for this field, etc.  So every kind of form is configurable and you have a preview and you generate actually  the project which I showed you earlier, so it's very easy, we actually set up the first  project for the client showing him how you do that and then we said okay you got the  project management tool and they built their own project, they are on application within  a few weeks without problems so it was very good.  So one point was versioning as well, so we had strong project requirements, we wanted  data history, we wanted offline work and we wanted scenario management so that's all  together makes like data management, data versioning needs and we actually built a new  project called QGIS versioning which is based on post-GIS and spatial light and which is  kind of a subversion for the database so with the concept of commits, branches and with  a conflict management tool.  So the principle is you get a working copy, you get an offline copy of your data, you  get it on your tablet, tablet hardware and you can work on it and then get it back to  the central database and you can as well do working copy inside the database without  having to put it on your tablet so you can work directly everything inside the database.  Next the workflow to update the data, so you got the reference repository which is the main  repository for data.  First of all to create a working copy for your user here so you got a local database  then you do modification offline and third step is to do a working copy update whenever  there is conflict you have to deal with conflict and merge your modifications with the modification  which have been done meanwhile by the user B and then once everything is alright you  can commit the modification to the reference repository and the user B can do exactly the  same in between.  So we got versioning and we got offline and we got some conflict management tool.  So every time you commit your data you're going to say commit message and then it say  okay it's you successfully committed your modification to the database or it says you have some updates  to do before.  We got conflict management, typically we got here data which has been modified on both  sides so inside QGIS you have an interface where you can choose which data you want to  keep or you can do modification of data.  First point was about simulation that's not exactly surveying that's an extension of the  water project globally.  We integrated epanet which is a hydraulic simulation where you can do simulation on  the water networks to know what pressure will be on what pipes etc.  And we integrated that into the geo processing interface at QGIS.  So it's a plugin and you can do time plots for example of the water level of tank.  You get map of results with specific pressure points with indication on the pressure level  for different pipes and all.  So we are going to do the same with SWMM which is a code for simulation for wastewater.  So for the future of the project so that was what was developed.  The future of the project is to have better domain specific objects so there is a lot  of QGIS guy mainly to do to better integrate some water management tools.  We want to improve the surveying software as well so GPS tracking has been done, capture  data on canvas has been done already as well but the ROM application can be now extended  with plugins so you can add some new features to the surveying application.  And then there is some more global improvement for SCADA connection for example to control  the valves, remote, geo web services, sensor oriented services and globally to have an  integrated software stack for water management, water distribution.  And try to build a community as well so every people interested in water distribution software  open source based on QGIS, PODGIS are invited to contribute to use it and then to fund it  if you can.  So that's mostly it for this presentation.  If you have any question do not hesitate I think we have some time for questions.  Thanks.  Questions?  No question?  Or that's yeah.  Do you know if there are some applications for park and green space management?  Parks and green space management in the same way?  So I don't know if there is any actually live at least not publicly probably there are some  people who developed some application for park management in QGIS but they didn't publish  it or didn't try to get others to use it.  But if you already got QGIS and QGIS project and all if you want to do some surveying this  ROM tool is really easy to set up.  I mean within a few days you can have your application running and if you don't need  any real complicated synchronization it's pretty easy to set up.  I was wondering if the software for doing the synchronization between QGIS and SQLite  is available?  Yeah it's available.  It's on GitHub.  If you go to Iceland it's GitHub.  It's still bit rough so it works in this case.  We haven't deployed it in other projects than this one.  But you can download it, use it and it should work.  So it's open source as well.  I have another question too about composers in QGIS.  It seems like when I've used them that produces very large PDF files.  Did you get into that problem?  Well it depends also.  You have two modes for exporting composers.  You have vector mode or you have raster mode so you have to check that you are in vector  mode for exporting and sometimes some layers cannot be exported as vector so the whole  composer export is converted to raster.  So that may be the case.  And we are actually working as well on improving the SVGA export so that we can have some like  real good SVGA export from QGIS if you want to go to Illustrator or something else and  to have better editing for vector, big vector maps.  Great, thank you.  One more question, last one?  No more question, perfect.  Thank you.
01_Vincent_Picavetpm_720p_0_251.png 01_Vincent_Picavetpm_720p_252_1391.png 01_Vincent_Picavetpm_720p_1392_3527.png 01_Vincent_Picavetpm_720p_3528_12839.png 01_Vincent_Picavetpm_720p_12840_13415.png 01_Vincent_Picavetpm_720p_13416_15191.png 01_Vincent_Picavetpm_720p_15192_16055.png 01_Vincent_Picavetpm_720p_16056_21671.png 01_Vincent_Picavetpm_720p_21672_31211.png 01_Vincent_Picavetpm_720p_31212_31295.png 01_Vincent_Picavetpm_720p_31296_31355.png 01_Vincent_Picavetpm_720p_31356_31583.png 01_Vincent_Picavetpm_720p_31584_31631.png 01_Vincent_Picavetpm_720p_31632_31691.png 01_Vincent_Picavetpm_720p_31692_31775.png 01_Vincent_Picavetpm_720p_31776_32255.png 01_Vincent_Picavetpm_720p_32256_32579.png 01_Vincent_Picavetpm_720p_32580_32639.png 01_Vincent_Picavetpm_720p_32640_32699.png 01_Vincent_Picavetpm_720p_32700_32939.png 01_Vincent_Picavetpm_720p_32940_32987.png 01_Vincent_Picavetpm_720p_32988_33047.png 01_Vincent_Picavetpm_720p_33048_33431.png 01_Vincent_Picavetpm_720p_33432_33515.png 01_Vincent_Picavetpm_720p_33516_33563.png 01_Vincent_Picavetpm_720p_33564_33683.png 01_Vincent_Picavetpm_720p_33684_33731.png 01_Vincent_Picavetpm_720p_33732_33779.png 01_Vincent_Picavetpm_720p_33780_34331.png 01_Vincent_Picavetpm_720p_34332_34619.png 01_Vincent_Picavetpm_720p_34620_34943.png 01_Vincent_Picavetpm_720p_34944_35105.png