Rijkswaterstaat / wm-ws-dl

wm-ws-dl documentation
https://rijkswaterstaatdata.nl/waterdata
11 stars 2 forks source link

invalid Y-coordinate for location KOMo #13

Open veenstrajelmer opened 7 months ago

veenstrajelmer commented 7 months ago

incorrect location

import matplotlib.pyplot as plt
plt.close("all")
import ddlpy

locations = ddlpy.locations()
bool_stations = locations['Y'] < 3e6
selected = locations.loc[bool_stations]
print(selected[["Naam","X","Y","Coordinatenstelsel"]].sort_index())

# Create a spatial plot
fig, ax = plt.subplots(figsize=(13, 8))
ax.plot(locations.X, locations.Y, 'k.')

Gives:

                    Naam         X        Y Coordinatenstelsel
Code                                                          
KOMo  Kwdznd mg o(-7mWS)  757148.6  5862.89              25831
KOMo  Kwdznd mg o(-7mWS)  757148.6  5862.89              25831
KOMo  Kwdznd mg o(-7mWS)  757148.6  5862.89              25831
KOMo  Kwdznd mg o(-7mWS)  757148.6  5862.89              25831

And: image

TvLoon-RWS commented 7 months ago

This issue has been passed on to our data delivery partner, and will be fixed by the next metadata synchronisation in a few weeks time. The coordinate should be equal to KOMb; X 654848.317 Y 5880513.971

veenstrajelmer commented 6 months ago

Update 16-5-2024 (and 9-10-2024): @TvLoon-RWS There is now one additional station with incorrect y-coordinates. Output from the python code in the initial issue description:

                      Naam           X        Y Coordinatenstelsel
Code                                                              
HKN   Hollandse Kust Noord  166021.443     0.00              25831
HKN   Hollandse Kust Noord  166021.443     0.00              25831
HKN   Hollandse Kust Noord  166021.443     0.00              25831
HKN   Hollandse Kust Noord  166021.443     0.00              25831
HKN   Hollandse Kust Noord  166021.443     0.00              25831
HKN   Hollandse Kust Noord  166021.443     0.00              25831
HKN   Hollandse Kust Noord  166021.443     0.00              25831
HKN   Hollandse Kust Noord  166021.443     0.00              25831
HKN   Hollandse Kust Noord  166021.443     0.00              25831
HKN   Hollandse Kust Noord  166021.443     0.00              25831
HKN   Hollandse Kust Noord  166021.443     0.00              25831
KOMo    Kwdznd mg o(-7mWS)  757148.600  5862.89              25831
KOMo    Kwdznd mg o(-7mWS)  757148.600  5862.89              25831
KOMo    Kwdznd mg o(-7mWS)  757148.600  5862.89              25831
KOMo    Kwdznd mg o(-7mWS)  757148.600  5862.89              25831
KDoekes-RWS commented 5 months ago

The incorrect coordinates are in DDL but not in DONAR.

TvLoon-RWS commented 1 month ago

HKN has for a brief moment been given data under these faulty coordinates. This has been since 2024-06-12. new data is now given out under HKN with coordinates X 587398.972 Y 5839436.37

A new synchronization with the list of live locations is planned next month. Hopefully KOMo is corrected by that point.