zlacker

I digitalized Berlin's registration form

submitted by nicbou+(OP) on 2023-09-19 08:24:19 | 555 points 310 comments
[view article] [source] [go to bottom]

NOTE: showing posts with links only show all posts
◧◩
15. Bayart+M3[view] [source] [discussion] 2023-09-19 09:01:58
>>nicbou+1
I've been planning to move to Berlin and your site [1] is a life-saver.

[1]: https://allaboutberlin.com

◧◩
41. klaust+W5[view] [source] [discussion] 2023-09-19 09:17:24
>>nicbou+1
The worst thing is that this differs by state. In Hessen the communal IT provider (ekom21) offers the service to fill out the entire form online in a UI that resembles yours, but then you still have to go to the "Meldeamt" to sign it (although you do that digitally on a tablet there) because currently the "schriftform" (means: manually signed) is required. It might be changed in the future to be "textform" (means: must be written down) and then it can happen completely digitally.

Unfortunately, from the bigger cities I checked (Frankfurt, Darmstadt, Kassel, Gießen, Marburg, Wiesbaden), none of them used that service, only some smaller districts like Bad Vilbel[1] or Limburg[2] offer the service.

[1]: https://onlineantrag.ekom21.de/olav/zuziehen?mbom=6440003 [2]: https://www.limburg.de/redirect.phtml?extlink=1&La=1&url_fid... "Voranmeldung eines Zuzugs"

◧◩◪
45. ulfw+q6[view] [source] [discussion] 2023-09-19 09:21:11
>>Firmwa+72
None of that is true.

They'd love to "digitise" but their problem is that there is ZERO Software culture in Germany. Likely they'd have some shitty accounting or consulting firm with their 24 yr old associate who can do some Java code something for 10 Billion EUR. It'll take 10 years and obviously won't scale or work properly.

That's why it still hasn't happened. There is no one who can write a requirements doc with much useful content in it besides "make it digital" either.

When they wanted a mobile app to warn of Covid risks nearby they found no one who could write mobile apps besides SAP (not a mobile nor end-user company) and Deutsche Telekom (a Telco, used to be state-owned back in the day). That'll tell you how this will go.

https://news.sap.com/2020/06/corona-warn-app-deutsche-teleko...

◧◩◪◨⬒
53. klaust+27[view] [source] [discussion] 2023-09-19 09:26:53
>>Firmwa+e4
With the ISDN (https://en.wikipedia.org/wiki/Integrated_Services_Digital_Ne...) network, Germany had the most advanced digital switching infrastructure in the world. It offered two 64kbit/s lines into every household, and that in the 80s. Unfortunately, due to political decisions that were highly influenced by Leo Kirch and his commercial TV provider (Premiere), Germany's public telecoms infrastructure was a) privaticed into Deutsche Telekom and b) shifted to put copper TV cable into every household instead of fiber.

In east Germany, after reunification in the 1990s, Deutsche Telekom started to introduce a fiber into every home (OPAL - https://de.wikipedia.org/wiki/Optische_Anschlussleitung) but then they shifted their focus to DSL and reusing the old copper wires for telephone lines and abandoned this. No, not only abandoned. They opened up the streets again to lay new copper wire.

Now, fiber to the home is back on the table.

68. schaco+r8[view] [source] 2023-09-19 09:45:42
>>nicbou+(OP)
We did this as well several years ago, even with an iOS app, a guide to the process and a German cheat sheet: https://amty.io

Every new Berliner feels this pain, but the worse part is getting an appointment. Not just for your Anmeldung, but for anything you need to do here.

◧◩◪◨⬒⬓
77. klaust+q9[view] [source] [discussion] 2023-09-19 09:55:10
>>klaust+27
If you understand German and are interested in the history, I highly recommend https://cre.fm/cre191-internet-im-festnetz
94. fl7305+jb[view] [source] 2023-09-19 10:09:52
>>nicbou+(OP)
"The Bürgeramt also wants to know that you live on the second floor on the right."

Meanwhile in Sweden, the government instituted a nationwide "Dwelling Units Register", where each apartment etc is uniquely numbered.

There is a precise way to number apartments based on the floor number, order of front doors on each floor etc.

Do you live on a steep hill, and have to go down two floors to reach your apartment which has windows facing out the other side of the building? No problem, the numbering system handles that.

https://www.lantmateriet.se/en/real-property/property-inform...

https://www.lantmateriet.se/globalassets/fastigheter/fastigh...

◧◩◪
106. nicbou+2d[view] [source] [discussion] 2023-09-19 10:21:23
>>Vingdo+W7
I wrote a tool for that: https://allaboutberlin.com/guides/berlin-burgeramt-appointme...

It's officially sanctioned by the city, but it's capped to one request every 3 minutes to avoid replacing the official website. Every few months, I ask them for permission to add other services, and I get ghosted.

However, the tool is open source, so you can just `pip install` it and run it on any appointment type you want.

https://github.com/nicbou/burgeramt-appointments-websockets

107. raybb+5d[view] [source] 2023-09-19 10:21:44
>>nicbou+(OP)
Reminds me of last year when I made a small site to help find appointments slots for the municipality in Brussels.

Website was taking so much effort to see the appointments and people said throughout they day they randomly opened so many of my classmates were checking all the time. So I made this to see appointments on one page instead of clicking many boxes.

https://blog.rayberger.org/automating-ixelles-appointment-ch...

◧◩
122. nicbou+dg[view] [source] [discussion] 2023-09-19 10:43:15
>>raybb+5d
I did that too: https://allaboutberlin.com/guides/berlin-burgeramt-appointme...

It took me a few months to get it sanctioned by Berlin's IT department, and I could not replicate that success with other services. However it's a start.

◧◩
126. nicbou+Yg[view] [source] [discussion] 2023-09-19 10:46:17
>>emj+V5
> you need to save the form as a PDF or a readable text file

Why?

In this case, the data will live for a few weeks at most. The goal would be a QR code that contains the data as a hash: https://forms.berlin/#[form data]. This is to avoid storing or seeing any user data.

I was also considering a P2P solution with WebRTC. This would let you transmit your form without the server seeing the data. You'd just need to both visit a URL at the same time.

The idea is that I can't store private information, and the Bürgeramt can't install any new software.

◧◩
127. nicbou+2h[view] [source] [discussion] 2023-09-19 10:47:04
>>ogou+R4
I made a tool for that: https://allaboutberlin.com/tools/appointment-finder
◧◩
128. nicbou+ch[view] [source] [discussion] 2023-09-19 10:48:19
>>schaco+r8
Yes! I used to link to it. I'm also a big fan of Chatterbug.

For the appointment, there's this: https://allaboutberlin.com/tools/appointment-finder

◧◩
135. nicbou+Oh[view] [source] [discussion] 2023-09-19 10:52:15
>>matttp+M5
Don't forget to ask for a pension payments refund! https://allaboutberlin.com/guides/pension-payments-refund
◧◩◪
138. nisa+zj[view] [source] [discussion] 2023-09-19 11:03:26
>>jcarra+Za
It's scary - if you apply for government student assistance you can apply online and it get's printed out - they had to employ people for printing! https://www.tagesschau.de/investigativ/funk/studenten-bafoeg...
◧◩◪◨
145. ravdee+Kl[view] [source] [discussion] 2023-09-19 11:18:20
>>nicbou+2d
Maybe this was you as well https://www.reddit.com/r/berlin/comments/q7ekx8/1010_is_the_... :-)

Your form helped immensely in the anmeldung process last year for me. Keep fighting the good fight sir.

◧◩◪
151. nicbou+dn[view] [source] [discussion] 2023-09-19 11:29:18
>>abdusc+T6
This is not true. I tested it before: https://nicolasbouliane.com/blog/berlin-buergeramt-experimen...
153. dctoed+zn[view] [source] 2023-09-19 11:31:30
>>nicbou+(OP)
For some U.S. tales, e.g., the challenges of digitizing California's Supplemental Nutrition Assistance Program (SNAP) sign-up process, see the excellent Recoding America by Jennifer Pahlka, former deputy CTO of the United States and now the founder of the non-profit organization Code For America. [0]

(Memorable passage: A civil servant described a complex government policy as having been "vomited" onto an impenetrable sign-up form — for my contract-drafting course, I stole that as the label "barf clause" to describe long, wall-of-words provisions such as the 357-word "Fragment 1" in an example I had students rewrite in class last week. [1])

[0] https://www.amazon.com/Recoding-America-Government-Failing-D...

[1] https://toedtclassnotes.site44.com/#guar-wow-1

◧◩
194. CalRob+OE[view] [source] [discussion] 2023-09-19 13:16:05
>>Bissne+T4
That brings to mind the romance of waiting in the immigration queue in Dublin at 4 AM with my wife so we could get registered by the end of the day. https://www.rte.ie/radio/radio1/clips/20853936/ . Simpler times.

Of course, the Irish government did eventually put in place an appointment booking system that was so comically bad bots would take all of the appointments immediately for resale on Facebook marketplace. It never crossed their mind to use a CAPTCHA. I only got my own appointment by writing a scraper for it.

◧◩
208. askono+2K[view] [source] [discussion] 2023-09-19 13:44:44
>>271605+i8
Coming from Estonia it is hard to believe how Germany still requires you to show up at government entities. I thought Germany was a very advanced country. I've done everything online for the past 10 or so years, having to only show up to the police to retrieve my new national id card or passport once it's ready, but every other service is entirely online: https://e-estonia.com/solutions/
◧◩◪◨
209. nickke+3K[view] [source] [discussion] 2023-09-19 13:44:49
>>danjac+mH
They have one already, but it's probably not as big: https://digitalservice.bund.de/
◧◩◪◨⬒⬓⬔
236. aleph_+P11[view] [source] [discussion] 2023-09-19 15:05:02
>>Bucket+Zv
> Even the most technologically progressive regions of Germany still think it's 1997. Elsewhere, it's like the wall never came down.

It is in my opinion a little bit more complicated. The central issue is: many ideas for digitization that other countries or private companies do or have done are very privacy-invading.

Germany had two surveillance states on its soil in the 20th century (of which one ended only a little bit more than 30 years ago). Additionally, lots of German citizens remember the aftermath of the dragnet investigation to fight the RAF in the 80s. So privacy and the possibilities of surveillance are very sensitive topics in the German population.

Additionally, basically every German citizen knows that when data accumulates, politicians will find a reason to use this data to spy on the citizens (prosecution of criminals ... blah blah). Thus there is an insane distrust in the German population in the politicians. Just to give a more recent examples: when the TollCollect system for truck toll was introduced, there were from beginning on concerns that the billing data will become abused. The politicians appeased the citizens that this will never happen. Of course it did happen:

> https://www.spiegel.de/politik/deutschland/verbrechensvorbeu...

"Rasterfahndung, heimliche Online-Durchsuchung, Datenauswertung der Lkw-Maut - Bundesinnenminister Wolfgang Schäuble und die Unionsfraktion drängen auf zahlreiche Verschärfungen der Sicherheitsgesetze. Die SPD will mitziehen - aber nicht beim Datensammeln zur Verbrechensvorbeugung.

Entsprechende Pläne präsentierten Unionspolitiker nach Informationen des SPIEGEL in einer Koalitionsrunde am vergangenen Donnerstag. Unter anderem sollen dem Bundeskriminalamt die Rasterfahndung und die heimliche Online-Durchsuchung von Privatcomputern erlaubt werden. Außerdem sollen die Daten der Lkw-Maut dabei helfen, Verbrechen aufzuklären."

DeepL translation: "Grid searches, secret online searches, data analysis of truck tolls - Federal Interior Minister Wolfgang Schäuble and the CDU/CSU parliamentary group are pushing for numerous tightening of security laws. The SPD wants to go along - but not with data collection for crime prevention.

According to SPIEGEL, Union politicians presented plans to this effect at a coalition meeting last Thursday. Among other things, the Federal Criminal Police Office is to be allowed to conduct dragnet searches and secret online searches of private computers. In addition, the data from the truck toll is to help solve crimes."

> https://www.zeit.de/online/2007/37/kommentar-online-durchsuc...

"Das Computer-Ausspähen wird also kommen. Wieder einmal wird der Gesetzgeber das Grundgesetz einschränken. Es mag nachvollziehbare Gründe dafür geben, wenn es darum geht, Terroristen davon abzuhalten, Hunderte von Menschen zu töten. Aber es braucht wenig prophetische Fähigkeiten, um vorauszusagen, dass es so kommen wird, wie es in der Vergangenheit immer gekommen ist: Erst versprechen die Innenpolitiker und die Sicherheitsbehörden hoch und heilig, das neue scharfe Schwert nur bei den ganz gefährlichen Straftaten und Verbrechern zu benutzen. Doch dann kommen die Drogenhändler, die Kinderschänder, die Betrüger und schließlich die Steuerhinterzieher. Und plötzlich sind auch Onlinedurchsuchungen ein ganz normales Instrument polizeilicher Ermittlungen.

Das war so bei der Kronzeugenregelung, bei der Datenspeicherung zur LKW-Maut und bei der Telefonüberwachung. Die gehört längst zum polizeilichen Alltag und wird von Richtern routinemäßig genehmigt. Auch beim Großen Lauschangriff drängt die Union seit Langem auf eine Ausweitung. Ihr passt es überhaupt nicht, dass die Polizei die Mikrofone ausschalten muss, wenn die belauschten Gespräche privat werden."

DeepL translation:

"So computer spying is coming. Once again, the legislature will restrict the Basic Law. There may be understandable reasons for this if the goal is to prevent terrorists from killing hundreds of people. But it takes little prophetic ability to predict that things will turn out the way they always have in the past: first, domestic politicians and the security authorities promise on high and holy to use the new sharp sword only on the very dangerous crimes and criminals. But then come the drug dealers, the child molesters, the fraudsters and finally the tax evaders. And suddenly online searches are also a normal instrument of police investigations.

This was the case with the leniency program, data storage for truck tolls and telephone surveillance. This has long been part of everyday police life and is routinely approved by judges. The CDU/CSU has also long been pushing for an expansion of the large-scale eavesdropping program. It does not like the fact that the police have to switch off the microphones when the conversations they listen in on become private."

Thus: never trust a politicians: politicians are nearly all fraudsters who belong into a high-security jail instead of a parliament.

◧◩◪◨
242. swores+q71[view] [source] [discussion] 2023-09-19 15:26:18
>>prenne+Ac
Customary (and extremely welcomed by the many postmen & women I've had the pleasure to know, my father having worked for Royal Mail / CWU) in England as well as Scotland (and I'm sure in Wales/NI too - probably elsewhere as well, and even in places where it's not customary it won't do any harm to thank people providing year round services to you with a small gift once a year!)

Also, while I agree with you that in this case (having a full postcode as well as name) it would have likely been an easy task for the local postie, Royal Mail do actually have a small team* of people who work in figuring out more tricky ones, so if a local person can't work it out for being on their beat it can be sent to the "address detectives" (great title!) to try to solve.

This is a great example of that from a year or two ago, including a few other similar stories at the end: https://www.theguardian.com/uk-news/2022/jan/07/lives-across...

* My knowledge is both 20 years out of date and fuzzy in my memory, so I've no clue how big a team it is nor if there's enough confusingly-addressed items to need anyone working on it full time, or if it's just one aspect in a wider set of responsibilities that a team does when needed.

◧◩◪
251. PaulHo+ic1[view] [source] [discussion] 2023-09-19 15:44:01
>>nforge+hc
This Youtube describes how that scenario plays out in defense contracting in Germany

https://www.youtube.com/watch?v=8jDUVtUA7rg

"Perun" used to be a video game streamer but thanks to the Russia-Ukraine war he now one of the best warbloggers and even does appearances together with top generals and pros like Anders Puck Nielsen.

◧◩
265. Comput+xt1[view] [source] [discussion] 2023-09-19 16:49:00
>>PaulHo+ob1
I’ve actually heard a lot of success stories regarding chassis/frame/body straightening on trucks with trees (lots of YouTube videos but here’s a rare blog post [0]). The hilarity ensues when one attempts to straighten the chassis of a unibody vehicle in the same manner (true story, and no, it wasn’t me).

[0]: https://blacksprucehound.com/2018/01/16/redneck-vehicle-fram...

◧◩◪◨⬒⬓
266. tim333+1u1[view] [source] [discussion] 2023-09-19 16:50:43
>>ido+Xp
We have this stuff >>5911218
267. Oliver+au1[view] [source] 2023-09-19 16:51:30
>>nicbou+(OP)
There's a book by Jen Pahlka called Recoding America. https://www.worldcat.org/title/Recoding-America-:-why-govern...

Germany seems to have similar sorts of federal / state / municipal government issues and other bureaucratic constraints as the US. And, this article makes it clear it has the same sorts of opportunities for improvement.

Maybe it's time to establish Programmieren für Deutschland as a parallel org to Code for America.

◧◩◪◨
275. joseph+wG1[view] [source] [discussion] 2023-09-19 17:45:26
>>jlange+le
Australia also has the Digital Transformation Agency[1] to do things in house like the UK does it. I’m not sure how many government IT projects use them though. Some departments also seem to have their own (competent) in house software teams, like the ABS, the DSD (Aussie NSA) and the ATO (aus tax office).

And thank god for that, because there’s also an ungodly number of consultants milking the Australian taxpayers for all we’re worth.

[1] https://www.dta.gov.au/

[go to top]