IT-Naturschutz/konova
7
1
Fork 0
Code Issues 6 Pull Requests 1 Actions Projects Releases 28 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

  
priority
1

  
priority
2

  
priority
3

  
priority
4

  
priority
5

  
question

More information is needed

  
wontfix

This won't be fixed

No Label
backlog
bug
duplicate
enhancement
feature
help wanted
invalid
question
wontfix
bug
duplicate
enhancement
help wanted
in discussion
invalid
priority
1
priority
2
priority
3
priority
4
priority
5
question
wontfix
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
mpeltriaux
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

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?