Talk:Q110977521

From Wikidata
Jump to navigation Jump to search

Autodescription — Berlin S-Bahn station (Q110977521)

description: no description
Useful links:
Classification of the class Berlin S-Bahn station (Q110977521)  View with Reasonator View with SQID
For help about classification, see Wikidata:Classification.
Parent classes (classes of items which contain this one item)
Subclasses (classes which contain special kinds of items of this class)
⟨Berlin S-Bahn station⟩ on wikidata tree visualisation (external tool)(depth=1)
Generic queries for classes
See also


Deine Bearbeitungen der Berliner S-Bahn[edit]

Hallo @BerlinBerlinBerlinBerlin, ich bitte Dich Herzlichst: Bei deinen Bearbeitungen der Berliner S-Bahn - bitte arbeite sauber und komplett, oder lass es sein. Du hast bei Berlin-Gesundbrunnen station (Q678286) und Berlin Schönhauser Allee station (Q571403) die S-Bahn entfernt und anscheinen neue Items für die S-Bahn Station angelegt. Diese sind aber teilweise weder mit der Berlin-Gesundbrunnen station als Interchange Station noch als has part gekennzeichnet noch hast Du an den gegenüberliegenden (adjacent) Bahnhöfen die benachbarten Bahnhöfe modifiziert. Wenn Du solche Änderungen machst, bitte sehr sauber arbeiten. Ansonsten fange ich mit einem massenhaften revert an. Ich habe auf [1] einen Query angelegt, wo alle S- und U-Bahnhöfe und Linien angezeigt werden. Der hatte für Berlin vor Deinen Bearbeitungen einwandfrei funktioniert. Nun ist das nur noch ein Flickenteppich. Darum Bitte ich Dich meinen Kommentar zu berücksichtigen. --GodeNehler (talk) 11:00, 18 March 2022 (UTC)[reply]

@GodeNehler: remind you on Wikidata:No personal attacks. Regarding "sauber" - state where I did not work "sauber". Regarding "komplett" - I thought, no one can fix all errors with one edit. But if you can, here is one for you: Berlin Zoologischer Garten railway station (Q681785) Fernbahnhof part of U-Bahn and S-Bahn. That is wrong. BerlinBerlinBerlinBerlin (talk) 13:17, 20 March 2022 (UTC)[reply]
Sorry if I was to personal - I was little bit in bad mode. --GodeNehler (talk) 13:32, 20 March 2022 (UTC)[reply]
@GodeNehler: I can understand that you were unhappy about the changes. Sorry. For some explanations of my work please see below the section "Splitting Berlin S-Bahn to individual items". Hope we have a good cooperation and soon the connections are fixed. BerlinBerlinBerlinBerlin (talk) 13:44, 20 March 2022 (UTC)[reply]

Removal of S-Bhf. Ostkreuz from combined station Ostkreuz[edit]

@GodeNehler: can you elaborate on this removal? BerlinBerlinBerlinBerlin (talk) 13:20, 20 March 2022 (UTC)[reply]

@BerlinBerlinBerlinBerlin: I have removed it, because it was duplicated. I have left one entry of Q111251530. So from my point of view it is now correct or what do you think? --GodeNehler (talk) 13:28, 20 March 2022 (UTC)[reply]
@GodeNehler: you are right! I sent you a thank you via the thano-you-system, and now I am sending another one here. BerlinBerlinBerlinBerlin (talk) 13:31, 20 March 2022 (UTC)[reply]

Splitting Berlin S-Bahn to individual items[edit]

@GodeNehler: I started doing this as part of my work on Berlin Street ID (Property:P10451). The plan is to have at least one item for each Berlin Street ID.

There are individual IDs for S/U and for the rest (can be F[ern], R[egional], or combined F-R). Let's see how we can proceed. I think at first the new S-Bahn-station-items should be generated and then the connections should be fixed. Sometimes when the new item is created, the connections can be fixed immediately, but sometimes one adjacent station also needs a split. Would you help with the connections? BerlinBerlinBerlinBerlin (talk) 13:42, 20 March 2022 (UTC)[reply]

Fine with me --GodeNehler (talk) 15:54, 20 March 2022 (UTC)[reply]
@GodeNehler: each item that has P31 = Berlin S-Bahn station and is located in Berlin, should now have a Berlin Street ID and the splitting at least in the area of Berlin is probably mostly finished. The parts in Brandenburg I didn't split yet, but that can be done later and there shouldn't be so many. BerlinBerlinBerlinBerlin (talk) 01:08, 22 March 2022 (UTC)[reply]

Replace P31 S-Bahn-station with Berlin-S-Bahn-station[edit]

I will now try to replace via a batch instance of S-Bahn-station with instance of Berlin-S-Bahn-station if the station part of Berlin S-Bahn. This operation should have no effect on the connections, but when later on the splitting BerlinBerlinBerlinBerlin (talk) 13:42, 20 March 2022 (UTC)[reply]

I have seen it. I am not sure if it is a good idea. But it is OK for me.--GodeNehler (talk) 15:54, 20 March 2022 (UTC)[reply]
GodeNehler, my motivation was, that they have certain properties in common, e, g, platform height, electrification. So, one can state it in one place and does not need repetition. BerlinBerlinBerlinBerlin (talk) 01:02, 22 March 2022 (UTC)[reply]

Connections between stations[edit]

@GodeNehler: can you create a query only for S-Bahn and post the short link here? BerlinBerlinBerlinBerlin (talk) 15:22, 20 March 2022 (UTC)[reply]

Is it OK this way? One thing: some times P81 and sometimes P1192 need to be used. There are the Data not consistent. I have not cleaned them up - but maybe you like to do. :-)
--GodeNehler (talk) 15:54, 20 March 2022 (UTC)[reply]

S-Bahn Berlin, Germany 

#defaultView:Map{"hide":["?coordinates", "?line", "?rgb"]}
SELECT DISTINCT ?coordinates ?line ?item ?itemLabel ?connectLabel ?rgb
# ?image ?opening 

WITH {
  SELECT ?item (SAMPLE(?coordinates) AS ?coordinates) (SAMPLE(?lat1) AS ?lat1) (SAMPLE(?lon1) AS ?lon1) WHERE {
    ?item wdt:P361 wd:Q99654 .
    ?item wdt:P625 ?coordinates  .
    ?item p:P625 / psv:P625 / wikibase:geoLatitude ?lat1 .
    ?item p:P625 / psv:P625 / wikibase:geoLongitude ?lon1 .
  } GROUP BY ?item
} AS %stations

WITH {
  SELECT ?nextstation (SAMPLE(?lat2) AS ?lat2) (SAMPLE(?lon2) AS ?lon2) WHERE {
    ?nextstation wdt:P361 wd:Q99654 .
    ?nextstation p:P625 / psv:P625 / wikibase:geoLatitude ?lat2 .
    ?nextstation p:P625 / psv:P625 / wikibase:geoLongitude ?lon2 .
  } GROUP BY ?nextstation
} AS %nextstations

WITH {
  SELECT ?line ?connect ?rgb WHERE {
    INCLUDE %stations .
    INCLUDE %nextstations .
    ?item p:P197 ?nextstationstatement .
    ?nextstationstatement ps:P197 ?nextstation .
    {?nextstationstatement pq:P81 ?connect . ?connect wdt:P361 wd:Q99654} 
      UNION 
    {?nextstationstatement pq:P1192 ?connect . ?connect wdt:P361 wd:Q99654} .
    ?connect wdt:P465 ?rgb .
    FILTER(STR(?item) < STR(?nextstation)) .    
    BIND(CONCAT('LINESTRING (', STR(?lon1), ' ', STR(?lat1), ',', STR(?lon2), ' ', STR(?lat2), ')') AS ?str) .
    BIND(STRDT(?str, geo:wktLiteral) AS ?line) 
  }
} AS %lines 
 
WHERE {
  { INCLUDE %stations }  UNION { INCLUDE %lines  } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Try it!

@GodeNehler: shortened the code so that shorturl could be generated https://w.wiki/4yVr . I think it should all be changed to P1192, do you agree? S1, S2 etc. are services, not physical lines. I changed several manurally, but it should best be made via batch. I don't know how to do that. I need a break. BerlinBerlinBerlinBerlin (talk) 01:36, 22 March 2022 (UTC)[reply]

I tried to connect Q800501 Feuerbachstr. with Q111264179 Rathaus Steglitz, but no line shows up on the map. Maybe it needs time, or did I miss something? BerlinBerlinBerlinBerlin (talk) 01:51, 22 March 2022 (UTC)[reply]
Part of was missing. I changed the query, now operating on P31=Berlin-S-Bahn station : https://w.wiki/4yWK BerlinBerlinBerlinBerlin (talk) 02:00, 22 March 2022 (UTC)[reply]
All dots in the map seem to be connected now. BerlinBerlinBerlinBerlin (talk) 02:43, 22 March 2022 (UTC)[reply]
Retrieved from "https://www.wikidata.org/w/index.php?title=Talk:Q110977521&oldid=1600479639"