IT-Naturschutz/konova
7
0
Fork 0
Code Issues 6 Pull Requests 1 Actions Projects Releases 37 Wiki Activity

EGON connection #131

New Issue
Closed
opened 2022-02-28 12:20:44 +01:00 by mpeltriaux · 2 comments
mpeltriaux commented 2022-02-28 12:20:44 +01:00
Owner
Copy Link

Status quo

EGON needs to receive relevant data just as it used to, for now. Future developments on the EGON project might make this feature obsolet.

ToDo

Old code

Take note of the relevant old code: https://git.naturschutz.rlp.de/SGD-Nord/ksp/src/branch/master/src/main/java/de/processware/ksp/support/mqrabbit/Sender.java

There needs to be a gml created, based on the intervention data. This gml will be sent to the rabbitmq broker, where EGON will take the data from. That's it.

# Status quo EGON needs to receive relevant data just as it used to, for now. Future developments on the EGON project might make this feature obsolet. # ToDo ## Old code Take note of the relevant old code: https://git.naturschutz.rlp.de/SGD-Nord/ksp/src/branch/master/src/main/java/de/processware/ksp/support/mqrabbit/Sender.java There needs to be a gml created, based on the intervention data. This gml will be sent to the rabbitmq broker, where EGON will take the data from. That's it.
mpeltriaux added the
feature
 label 2022-02-28 12:20:44 +01:00
mpeltriaux self-assigned this 2022-02-28 12:20:44 +01:00
mpeltriaux commented 2022-03-07 14:57:02 +01:00
Author
Owner
Copy Link

Problems on existing XML

  1. xlink:href references have not been updated. URLs do not exist.
  2. Only one Verfahrensrecht is transmitted, beside the fact multiple Verfahrensrechte can be selected on the form
  3. Raumreferenz Datum Abgleich looks like a dummy date
  4. Fotoverweis is not a real reference but simply the 'main' file decoded as base64
  5. flurstuecksKennzeichen contains concatenated data about the intersected parcels. Example below: 070275|031|00040|000000
    1. 070275|... --> Gemarkung code
      1. This info is not being parsed by the WFS parcel fetcher
    2. ...|031|... --> Flur
      1. Seems to be always 3 digit long
    3. ...|...|00040|... --> Flurstückszähler
      1. Seems to be always 5 digit long
    4. ...|...|...|000000 --> Flurstuecksnenner
      1. Seems to be always 6 digit long

Example XML

<wfs:FeatureCollection>
    <oneo:Eingriffsverfahren gml:id="EIV-123">
        <oneo:azEintragungsstelle>xx</oneo:azEintragungsstelle>
        <oneo:azZulassungsstelle>yy</oneo:azZulassungsstelle>
        <oneo:bemerkungZulassungsstelle/>
        <oneo:eintragungsstelle xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/907/710147">LK Neuwied</oneo:eintragungsstelle>
        <oneo:zulassungsstelle xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/1053/1764150">Kreisverwaltung Neuwied</oneo:zulassungsstelle>
        <oneo:ersatzzahlung>2.101,50</oneo:ersatzzahlung>
        <oneo:kompensationsart xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/88140/774898901">Ersatzzahlung</oneo:kompensationsart>
        <oneo:verfahrensrecht xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/1048/710067">LBauO</oneo:verfahrensrecht>
        <oneo:verfahrenstyp xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/44382/623645439">Genehmigung</oneo:verfahrenstyp>
        <oneo:eingreifer>
            <oneo:Eingreifer>
                <oneo:art xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/1053/710185">Sonstige und private Träger</oneo:art>
                <oneo:bemerkung>
xyz
</oneo:bemerkung>
            </oneo:Eingreifer>
        </oneo:eingreifer>
        <oneo:erfasser>
            <oneo:Erfasser>
                <oneo:name/>
                <oneo:bemerkung/>
            </oneo:Erfasser>
        </oneo:erfasser>
        <oneo:zulassung>
            <oneo:Zulassungstermin>
                <oneo:bauBeginn/>
                <oneo:erlass>22.11.2018</oneo:erlass>
                <oneo:rechtsKraft/>
            </oneo:Zulassungstermin>
        </oneo:zulassung>
        <oneo:geometrie>
            <gml:multiSurfaceProperty>
                <gml:MultiPolygon srsName="http://www.opengis.net/gml/srs/epsg.xml#25832">
                    <gml:polygonMember>
                        <gml:Polygon>
                            <gml:exterior>
                                <gml:LinearRing>
                                    <gml:posList>
388323.900852098 5611104.71098249 388296.208851846 5611128.59798249 388296.016851846 5611121.64998249 388295.338851846 5611097.09298249 388294.264851846 5611058.17198249 388291.029851804 5610940.95198249 388329.174852154 5610948.35498249 388333.603852196 5611103.7409825 388323.900852098 5611104.71098249
</gml:posList>
                                </gml:LinearRing>
                            </gml:exterior>
                        </gml:Polygon>
                    </gml:polygonMember>
                </gml:MultiPolygon>
            </gml:multiSurfaceProperty>
        </oneo:geometrie>
        <oneo:kennung>EIV-123</oneo:kennung>
        <oneo:bezeichnung>Neubau ABC</oneo:bezeichnung>
        <oneo:bemerkung/>
        <oneo:verantwortlicheStelle xlink:href=""/>
        <oneo:veroffentlichtAm/>
        <oneo:raumreferenz>
            <oneo:Raumreferenz>
                <oneo:datumAbgleich>31.12.1990 00:00:00</oneo:datumAbgleich>
                <oneo:ortsangabe>
                    <oneo:Ortsangaben>
                        <oneo:kreisSchluessel xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/588/700434">Neuwied</oneo:kreisSchluessel>
                        <oneo:gemeindeSchluessel xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/910/708567">Asbach</oneo:gemeindeSchluessel>
                        <oneo:verbandsgemeindeSchluessel xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/589/702001">Asbach</oneo:verbandsgemeindeSchluessel>
                        <oneo:flurstuecksKennzeichen>07027503100040000000</oneo:flurstuecksKennzeichen>
                    </oneo:Ortsangaben>
                </oneo:ortsangabe>
            </oneo:Raumreferenz>
        </oneo:raumreferenz>
        <oneo:foto>
            <oneo:Foto>
                <oneo:aufnahmezeitpunkt>24.10.2018</oneo:aufnahmezeitpunkt>
                <oneo:bemerkung>Baugenehmigung und SN UNB</oneo:bemerkung>
                <oneo:fotoverweis>BASE64_DECODED_FILE</oneo:fotoverweis>
                <oneo:dateiname>Baugenehmigung_und_SN_UNB.pdf</oneo:dateiname>
                <oneo:hauptfoto>true</oneo:hauptfoto>
            </oneo:Foto>
        </oneo:foto>
    </oneo:Eingriffsverfahren>
</wfs:FeatureCollection>
## Problems on existing XML 1. xlink:href references have not been updated. URLs do not exist. 1. Only one Verfahrensrecht is transmitted, beside the fact multiple Verfahrensrechte can be selected on the form 1. Raumreferenz Datum Abgleich looks like a dummy date 1. Fotoverweis is not a real reference but simply the 'main' file decoded as base64 1. flurstuecksKennzeichen contains concatenated data about the intersected parcels. Example below: 070275|031|00040|000000 1. 070275|... --> Gemarkung code 1. This info is not being parsed by the WFS parcel fetcher 1. ...|031|... --> Flur 1. Seems to be always 3 digit long 1. ...|...|00040|... --> Flurstückszähler 1. Seems to be always 5 digit long 1. ...|...|...|000000 --> Flurstuecksnenner 1. Seems to be always 6 digit long ## Example XML ```xml <wfs:FeatureCollection> <oneo:Eingriffsverfahren gml:id="EIV-123"> <oneo:azEintragungsstelle>xx</oneo:azEintragungsstelle> <oneo:azZulassungsstelle>yy</oneo:azZulassungsstelle> <oneo:bemerkungZulassungsstelle/> <oneo:eintragungsstelle xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/907/710147">LK Neuwied</oneo:eintragungsstelle> <oneo:zulassungsstelle xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/1053/1764150">Kreisverwaltung Neuwied</oneo:zulassungsstelle> <oneo:ersatzzahlung>2.101,50</oneo:ersatzzahlung> <oneo:kompensationsart xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/88140/774898901">Ersatzzahlung</oneo:kompensationsart> <oneo:verfahrensrecht xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/1048/710067">LBauO</oneo:verfahrensrecht> <oneo:verfahrenstyp xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/44382/623645439">Genehmigung</oneo:verfahrenstyp> <oneo:eingreifer> <oneo:Eingreifer> <oneo:art xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/1053/710185">Sonstige und private Träger</oneo:art> <oneo:bemerkung> xyz </oneo:bemerkung> </oneo:Eingreifer> </oneo:eingreifer> <oneo:erfasser> <oneo:Erfasser> <oneo:name/> <oneo:bemerkung/> </oneo:Erfasser> </oneo:erfasser> <oneo:zulassung> <oneo:Zulassungstermin> <oneo:bauBeginn/> <oneo:erlass>22.11.2018</oneo:erlass> <oneo:rechtsKraft/> </oneo:Zulassungstermin> </oneo:zulassung> <oneo:geometrie> <gml:multiSurfaceProperty> <gml:MultiPolygon srsName="http://www.opengis.net/gml/srs/epsg.xml#25832"> <gml:polygonMember> <gml:Polygon> <gml:exterior> <gml:LinearRing> <gml:posList> 388323.900852098 5611104.71098249 388296.208851846 5611128.59798249 388296.016851846 5611121.64998249 388295.338851846 5611097.09298249 388294.264851846 5611058.17198249 388291.029851804 5610940.95198249 388329.174852154 5610948.35498249 388333.603852196 5611103.7409825 388323.900852098 5611104.71098249 </gml:posList> </gml:LinearRing> </gml:exterior> </gml:Polygon> </gml:polygonMember> </gml:MultiPolygon> </gml:multiSurfaceProperty> </oneo:geometrie> <oneo:kennung>EIV-123</oneo:kennung> <oneo:bezeichnung>Neubau ABC</oneo:bezeichnung> <oneo:bemerkung/> <oneo:verantwortlicheStelle xlink:href=""/> <oneo:veroffentlichtAm/> <oneo:raumreferenz> <oneo:Raumreferenz> <oneo:datumAbgleich>31.12.1990 00:00:00</oneo:datumAbgleich> <oneo:ortsangabe> <oneo:Ortsangaben> <oneo:kreisSchluessel xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/588/700434">Neuwied</oneo:kreisSchluessel> <oneo:gemeindeSchluessel xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/910/708567">Asbach</oneo:gemeindeSchluessel> <oneo:verbandsgemeindeSchluessel xlink:href="http://register.naturschutz.rlp.de/repository/services/referenzliste/589/702001">Asbach</oneo:verbandsgemeindeSchluessel> <oneo:flurstuecksKennzeichen>07027503100040000000</oneo:flurstuecksKennzeichen> </oneo:Ortsangaben> </oneo:ortsangabe> </oneo:Raumreferenz> </oneo:raumreferenz> <oneo:foto> <oneo:Foto> <oneo:aufnahmezeitpunkt>24.10.2018</oneo:aufnahmezeitpunkt> <oneo:bemerkung>Baugenehmigung und SN UNB</oneo:bemerkung> <oneo:fotoverweis>BASE64_DECODED_FILE</oneo:fotoverweis> <oneo:dateiname>Baugenehmigung_und_SN_UNB.pdf</oneo:dateiname> <oneo:hauptfoto>true</oneo:hauptfoto> </oneo:Foto> </oneo:foto> </oneo:Eingriffsverfahren> </wfs:FeatureCollection> ```
mpeltriaux referenced this issue from a commit 2022-03-09 08:34:35 +01:00
#131 WIP: EGON exporter
mpeltriaux referenced this issue from a commit 2022-03-09 08:34:35 +01:00
#131 EGON exporter
mpeltriaux referenced this issue from a commit 2022-03-21 12:20:17 +01:00
#131 EGON export
mpeltriaux commented 2022-03-21 13:22:43 +01:00
Author
Owner
Copy Link

Merged in #135

# Merged in #135
btuelek referenced this issue from a commit 2024-12-05 13:18:37 +01:00
#131 WIP: EGON exporter
btuelek referenced this issue from a commit 2024-12-05 13:18:37 +01:00
#131 EGON exporter
btuelek referenced this issue from a commit 2024-12-05 13:18:37 +01:00
#131 EGON export
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
backlog
Absolutely no priority, but maybe some day...
bug
Something is not working
duplicate
This issue or pull request already exists
enhancement
Idea for existing feature
feature
New feature
help wanted
Need some help
invalid
Something is wrong
question
More information is needed
wontfix
This won't be fixed
bug
Something is not working
duplicate
This issue or pull request already exists
enhancement
New feature
help wanted
Need some help
in discussion
invalid
Something is wrong
MAUS - Pacht
Issues für Maus-Pacht / Version processware
priority
1
priority
2
priority
3
priority
4
priority
5
question
More information is needed
wontfix
This won't be fixed
No Label
feature
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
btuelek jhaeder mmannfeld mmueller mpeltriaux sgorell srieder tnette
No Assignees mpeltriaux
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: IT-Naturschutz/konova#131
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?