BDM: BruGIS Data Management
This is a modal window.
The media could not be loaded, either because the server or network failed or because the format is not supported.
Formal Metadata
Title |
| |
Subtitle |
| |
Title of Series | ||
Number of Parts | 295 | |
Author | ||
Contributors | ||
License | 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. | |
Identifiers | 10.5446/43370 (DOI) | |
Publisher | ||
Release Date | ||
Language |
Content Metadata
Subject Area | ||
Genre | ||
Abstract |
| |
Keywords |
00:00
WordComputer virusPrisoner's dilemmaBridging (networking)Lecture/Conference
00:26
Data managementPlug-in (computing)Software frameworkComputing platformTheory of relativityProcess (computing)Form (programming)Web 2.0Information technology consulting
01:17
Self-organizationGeometryService (economics)Game controllerPlanningWeb 2.0Computing platformOpen sourceDataflowDatabaseProduct (business)System administratorWordNetwork topologyData storage deviceSoftware developerGroup actionBridging (networking)Computer animationLecture/Conference
03:03
Asynchronous Transfer ModeIntegrated development environmentMachine visionData managementDatabaseOpen sourceUniqueness quantificationData modelCurvatureConstraint (mathematics)Exclusive orText editorControl flowVisual systemCommunications protocolStandard deviationInternetworkingInterface (computing)ArchitectureMereologyMultitier architectureClient (computing)Plug-in (computing)ImplementationAuthorizationProxy serverScheduling (computing)IntranetNumbering schemeGamma functionSurfaceCurve fittingConnected spaceEndliche ModelltheorieProcess (computing)Open sourceTemporal logicPower (physics)Message passingControl flowDataflowSlide ruleState of matterServer (computing)Data structureSelf-organizationAuthenticationAdditionInternetworkingLocal ringSystem administratorDatabasePresentation of a groupScripting languagePerimeterPoint (geometry)Level (video gaming)Bridging (networking)Arithmetic meanMultiplication signComputer clusterAsynchronous Transfer ModeDirection (geometry)Set (mathematics)Scheduling (computing)BitParameter (computer programming)Integrated development environmentProgram flowchart
11:00
Gamma functionRAIDSoftware testingObject (grammar)View (database)Point (geometry)Bit rateDoubling the cube2 (number)Goodness of fitNetwork topologyCurveDatabaseComputer animation
12:34
Coma BerenicesSoftware testingPerturbation theoryMIDIPort scannerSurfaceThermodynamisches SystemIRIS-TPlanningInclusion mapBridging (networking)System administratorLevel (video gaming)Computer animation
14:26
InternetworkingDatabaseScheduling (computing)IntranetData managementArchitectureLocal ringBroadcast programmingSystem administratorProxy serverArithmetic meanComa BerenicesProgram flowchartLecture/Conference
14:50
Proxy serverDirected setDatabaseQuery languageGraphical user interfaceData managementText editorAuthorizationProcess (computing)Standard deviationArchitectureMilitary operationIntegrated development environmentProduct (business)Component-based software engineeringHuman migrationDependent and independent variablesFeedbackCodeSoftware testingLinear regressionLevel (video gaming)State observerPlug-in (computing)UsabilityProxy serverMathematicsCapability Maturity ModelMultiplication signIntegrated development environmentGoodness of fitStability theoryText editorGraphical user interfaceSoftware developerComputer animation
16:19
DecimalTheoryFormal languageLaptopLecture/Conference
Transcript: English(auto-generated)
00:07
Hello. Thank you for choosing this room. As you see, I'm not Grégoire. And if you expect that he's going to present,
00:21
I'm sorry he's going to be disappointed. First, a few words about Brudis. That's because I know you already know very well Brudis, but maybe one or two persons never heard about it.
00:40
So, first, Brudis is a WebGIS platform which allows to consult geographic and textual data, provide from different authentic sources, and put them in relation. Those data reflect the regulatory framework
01:02
for urban planning in Brussels-Capital region. Brudis is also a team, four people, me and three other guys, Grégoire, Eng, and Laurence.
01:23
Oh, she's a girl. Sorry. They are all here. And we are a multidisciplinary team specialized in geometrics. We work for a public interest organization,
01:40
Brussels Planning and Heritage, and the service we develop serves not only the public administration, but also the citizens. That's why already a few years ago we began to use open source technologies
02:22
so we can offer the best possible tool, keeping the cost as low as possible. You know how it works for public service.
02:40
Okay. Our latest development, according to this vision, it's a web tool under QGIS that can ensure a consistent and controlled production flow of databases, special databases that we publish under Brudis platform.
03:05
But our business is publishing, not producing special data. Other departments of our organization or other public interest organization
03:21
are the authentic sources of the data that we publish. That's why BDM is born. We need a tool which permits to let the producer of the data, the authentic source, to integrate and update the data
03:40
without direct connection to our database. BDM allows us to simply supervise the workflow of integrate, modify and publish data, and let the authentic sources to do their jobs.
04:05
The BDM tool is the only way to upgrade Brudis data. Addition is performed in an exclusive mode. The layer in addition, it's passed through three different states.
04:21
Check-in, the layer is available for modification. Check-out, the layer was already borrowed for modification and only the first user can modify. And staging, the modify layer was published in the staging database.
04:44
Oh, I forgot to tell you, but the BDM tool, it was developed by a Walloon native speaker. The text of the slide was written by a French native speaker.
05:01
The PowerPoint presentation was made by a Dutch native speaker. I'm a Romanian native speaker. I tell you this in English, but I confess it's a little bit Chinese for me, beginning from here.
05:23
You too? Okay, I hope my colleagues will answer the questions that you have at the end. So, the plug-in, it's working with other PUGs
05:45
and the BDM access transmits the message from the plug-in to GeoServer who really does the work.
06:01
I really don't know exactly how to explain you this, but it works with Django API
06:21
and messages that the GeoServer receives. This is the structure of our database and the way of publishing. I know every night a copy of our internet database.
06:43
It's copied in staging and on internet database. And the local scheduler makes a copy of the local scripts in each environment.
07:01
Now, we create this tool to have an easy way for the authentic source to create their data. I'm the first user, the breaker user,
07:24
because my colleagues let me try it and see if it works. And we arrive at the conclusion that the tool is working and it's okay. I teach the other user of our organization, for example,
07:43
to use this tool. But there are people, they never used QGs, so they need to publish the data without renewing QGs. So, we create a very simple tool.
08:06
Okay, it's two little tools. The first is bedm-admin. This is our tool, the administrator, and it permits us to create a new user to modify some parameters
08:24
and to allow for modification a set of layers, a specific layer, to each user. So, I'm going to do a new user.
08:50
Okay, it's important to fill also the e-mail. Why? Because the tool communicates each time there are important steps to do.
09:09
Okay, now I create the user and I'm going to try to find some... This is direct, it's our database here,
09:22
so find something to test, not breaking down something important. So, I see here all the layers I give to Azure T.
09:47
Now, the user can connect
10:01
and he sees directly the layer he has right to modify. As I said before, there are three states of the layers, check-in, check-out, and staging. To can modify a layer, it has to be check-in or check-out,
10:24
but it had to be me who takes this layer first to modify. So, this layer, if I want to modify now, I cannot, and you see, no tool, it's available because somebody else is modifying now.
10:42
So, I'm going to take this one and here a tool added, it's available. It makes a copy of a layer and it puts in a temporal place and now I can see it
11:03
and if I want, I can modify. I will try to add an object. It works with Snap, yes, Snap,
11:20
but here below, it's where I'm at. So, when I do the modification, don't forget to save
11:44
and as I told you, the layer, it's now check-out by Ezerty. It's a good usual, it's good to do a validate,
12:02
so we are sure that the layer, it's still the correct point of view of topological. There are no self-cross object or double points. When we are happy with all the modification we do,
12:24
we send it in staging database by doing submit and in a few seconds, okay, the layer now is staging.
12:43
If I want to take it, it's not possible. The only tool, it's under submit and that permit me to take the layer again and continue the modification or tomorrow, we have laboratory bridges
13:03
where we can see, when we can visualize the modification we do and once we agree, we send to the administrator, asks Brudis, a male, and says, okay, this layer, you can publish.
13:23
So, the administrator, he takes the user and he see, okay, this layer, it's in staging. He says, you can publish, so I publish
13:42
and now, the layer, it's again check-in. Somebody else who need do changing on this layer,
14:03
he can use it, me also. After 24 hours, I go to Brudis and show you Brudis and he gonna see the modification he has done.
14:25
Why we do that? It's important that people use the same tools and create the data in the same way. It's easy for us to publish
14:42
and we think it's a good tool. Okay, here I talk about the admin. Okay, it's created by command. They are directly forward to the proxy.
15:01
I think you know what's a proxy. Me neither, me not, sorry. Okay, the BDM editor, it's also a graphical user interface, also implemented by Django proxy. So, our tool, we think it's a good tool
15:29
because it's quite easy. It's our developer, he says. It's easy to change the environment.
15:41
He says it's solution mature and stable and we recently migrate from QGIS 2 to QGIS 3 and, okay, we do in an acceptable time the changes. But, well, sometimes there are problems.
16:03
There are lacks in the documentation and if there are problems, it's difficult to find exactly where the problem is. So, thank you very much for listening. If you have questions, I'll try to answer if I can,
16:26
but if not, my colleagues are here. Other questions? Myself as a member of the QGIS team, I'm pleased to see it's used in Brussels
16:41
in the very heart of Europe, so it's nice to see. But are there any questions? Yes. Hey, I'm curious how you ended to have this diverse team. You said that you have colleagues from all around Europe
17:04
and I'm curious how you created this team. The diversity of languages? Yeah, yeah, exactly. Okay. Well, we all meet in Brussels, that's all. I guess Brussels is used to many languages, isn't it?
17:21
Yes, that's why. Any other questions or remarks? Well, if you are interested, we are here, so maybe later we can talk and explain you
17:43
exactly how the tool is. Thank you. So we'll have a couple of minutes to change, prepare, because that's good, actually, because we need to switch laptops again, and who knows what happens.
Recommendations
Series of 15 media