Property talk:P10451
Documentation
system of 5-digit unique numeric identifiers for geographic objects in Berlin used for addressing, mostly streets
List of violations of this constraint: Database reports/Constraint violations/P10451#Item P625, SPARQL
|
This property is being used by: Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.) |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
w.wiki
- https://w.wiki/4vcv - a query for checking Bezirk 01 Mitte BerlinBerlinBerlinBerlin (talk) 21:40, 7 March 2022 (UTC)
- https://w.wiki/4w6Z - 02 Friedrichshain-Kreuzberg BerlinBerlinBerlinBerlin (talk) 01:01, 10 March 2022 (UTC)
- https://w.wiki/4wFx 0301 OT Prenzlauer Berg BerlinBerlinBerlinBerlin (talk) 15:01, 10 March 2022 (UTC)
- https://w.wiki/4z7H Filter Apfel and Commons Category and coordinates BerlinBerlinBerlinBerlin (talk) 22:21, 24 March 2022 (UTC)
Street not found
- OT Neukölln: Q105971192 Schwarzer Weg 12049, only found "Straße 645 (Schwarzer Weg); 10965 Berlin (Neukölln)" street id:10958 BerlinBerlinBerlinBerlin (talk) 15:53, 10 March 2022 (UTC)
- OT Neukölln: Q105971165 Kirchhofweg, only found Kirchhofstr. BerlinBerlinBerlinBerlin (talk) 15:54, 10 March 2022 (UTC)
not found in RBS
- Thüringer Allee (Q109534393) found as Thüringerallee BerlinBerlinBerlinBerlin (talk) 01:13, 11 March 2022 (UTC)
Adding Berlin Street ID to existing items
Transfer of values from street key property
@MB-one: can you transfer the street key (Property:P1945) values to this new property? BerlinBerlinBerlinBerlin (talk) 14:08, 6 March 2022 (UTC)
- @BerlinBerlinBerlinBerlin:
- https://w.wiki/4vFw can generate the necessary inputs for Quickstatements.
- Should I go ahead and create the statments? MB-one (talk) 17:58, 6 March 2022 (UTC)
- @MB-one: Thanks! I used your query to obtain the pairs, as input I used:
qid,P10451 Q1005415,"""00806""" Q1016029,"""40477"""
- After start, I saw that some lines are duplicated, probably due to "OPTIONAL { ?item wdt:P131 ?liegt_in_der_Verwaltungseinheit. }".
But it seems insertion is only done once.I will work on deletion of the values in the street key property later. BerlinBerlinBerlinBerlin (talk) 22:54, 6 March 2022 (UTC) - New query: https://w.wiki/4vJH BerlinBerlinBerlinBerlin (talk) 23:04, 6 March 2022 (UTC)
- After start, I saw that some lines are duplicated, probably due to "OPTIONAL { ?item wdt:P131 ?liegt_in_der_Verwaltungseinheit. }".
Remove P1945 if P10451 exists
https://w.wiki/4vJK BerlinBerlinBerlinBerlin (talk) 23:14, 6 March 2022 (UTC)
Adding Berlin Street ID to all existing street items
For today I planned to finish adding Berlin Street ID to all streets in Berlin that have one, and start adding new streets to WD, but QuickStatements is broken:
- https://quickstatements.toolforge.org/#/batch/78085 - Friedrichsfelde - each marked as error - I added these manually
- https://quickstatements.toolforge.org/#/batch/78086 - Karlshorst - each marked as error - I added these manually
- https://quickstatements.toolforge.org/#/batch/78087 - Alt-Hohenschönhausen - each marked as error - not done manually by me, no time for this.
Statistics for P10451 value
- https://w.wiki/4wVZ 805 streets in Berlin having no value (excluding dissolved streets)
- https://w.wiki/4wVi 2532 streets having one
- https://w.wiki/4wVm 2600 items having one
BerlinBerlinBerlinBerlin (talk) 17:23, 11 March 2022 (UTC)
The task has been completed 2022-03-12, statistics for P10451 value as of now (a few bridges and stations got an id in the meantime)
- https://w.wiki/4wVZ 27 streets in Berlin having no value (excluding dissolved streets), they should be set to "no value", only two are so far, some need merging
- https://w.wiki/4wVi 3308 streets having one
- https://w.wiki/4wVm 3391 items having one
BerlinBerlinBerlinBerlin (talk) 12:07, 13 March 2022 (UTC)
Ortsteil Alt-Hohenschönhausen
Here is the source code for CSV statements
qid,P10451 Q97577068,"""43811""" Q97445954,"""40099""" Q97381049,"""43801""" Q97624626,"""40210""" Q89256218,"""40567""" Q97682094,"""40589""" Q1394176,"""40783""" Q89478329,"""40810""" Q89194301,"""40814""" Q97500672,"""40882""" Q89095580,"""40955""" Q97588870,"""40977""" Q105627021,"""41093""" Q14538357,"""41588""" Q1589685,"""41214""" Q1661428,"""41774""" Q1781896,"""40308""" Q105627010,"""41798""" Q89257374,"""41871""" Q105627015,"""41877""" Q89255751,"""41915""" Q97456030,"""42120""" Q89195481,"""42281""" Q97538710,"""41837""" Q97633893,"""08331""" Q89018967,"""42342""" Q69308744,"""43266""" Q105626973,"""43447""" Q89095884,"""43535""" Q89095399,"""43813"""
BerlinBerlinBerlinBerlin (talk) 17:31, 11 March 2022 (UTC) @MB-one, Pfadintegral, M2k~dewiki: - can you run it at https://quickstatements.toolforge.org/#/batch ?
- it seems as if the space at the end of the first line didn't cause QS to raise an error on import of the statements but after starting the batch lead to causing an error for each statements. BerlinBerlinBerlinBerlin (talk) 12:20, 12 March 2022 (UTC)
Adding Berlin Street ID to all existing non-street items
Bundesautobahn
5x Bundesautobahn 100
- Q109565108 Charlottenburg-Nord
- Q109565229 Grunewald
- Q109537358 Schmargendorf
- Q109534247 Westend
- Q109533391 Wilmersdorf
BerlinBerlinBerlinBerlin (talk) 21:54, 12 March 2022 (UTC)
@Pfadintegral: Gibt es offizielle Streckenabschnitte bei der A100? Die Abschnitte haben ja verschiedene Eröffnungstermine und auch zur Modelierung der Abfahrten und Anschlusstellen wären getrennte Objekte wohl hilfreich. BerlinBerlinBerlinBerlin (talk) 22:02, 12 March 2022 (UTC)
- Ich fürchte, ich weiß es nicht. Wenn, dann korrespondieren sie aber vermutlich nicht mit den Berliner Verwaltungseinheiten. Wenn die Grenzziehungen auf OpenStreetMap korrekt sind, dann ist z.B. der in Westend befindlich Teil der A100 nicht zusammenhängend und umfasst an manchen Orten nur eine der zwei Richtungen. Ich glaube nicht, dass eine Entität ist, für die ein Wikidata-Objekt sinnvoll wäre. Pfadintegral (talk) 07:56, 13 March 2022 (UTC)
- @Pfadintegral:, ja die Aufsplittung nach Ortsteilen hat sicher nichts mit physischer Realität zu tun und findet sich wohl auch nicht in besonderer Verwendung in der öffentlichen Verwaltung. In de:Bundesautobahn 100 sind in der Infobox rechts die AS/AD von 1 bis 26 (28 im Bau, 31 geplannt) durchnummeriert. Es könnte bei Verlinkung mit Nachrichtenartikeln, Aktivitäten von z.B. Bürgerinitiativen und von Planungs- und Bauunterlagen eine Rolle spielen. BerlinBerlinBerlinBerlin (talk) 11:19, 13 March 2022 (UTC)
AS
@Pfadintegral: guck mal im Verzeichnis nach "100 AS" - zu viele Treffer, also einen Buchstaben anhängen z.B. "100 AS B", das wird noch interessant: Ausfahrt, Einfahrt, Hauptfahrbahn. Aber noch genug anderes zu tun, Autobahn später. BerlinBerlinBerlinBerlin (talk) 15:25, 16 March 2022 (UTC)
A 115 BAB
ID 05576, dort unter anderem:
- A 115 BAB Autobahnzubringer Magdebg/Leipz (Avus); 99999 Berlin (keine Zuordnung)
ob 99999 Berlin sich auf ausserhalb Berlin bezieht? BerlinBerlinBerlinBerlin (talk) 19:27, 16 March 2022 (UTC)
Duplicates created by batch having a commons-link
@M2k~dewiki: https://www.wikidata.org/w/index.php?title=Q109565145&action=history isn't a separate street, it is just the section of Q63241455 located in a specific Ortsteil, here Charlottenburg-Nord. AFAICS that applies to all of the duplicates listed to "Unique value" violations and in each case an ID starting with Q1095 is involved and each of these which I checked were created by a temporary batch by you. If you want to create street sections by Ortsteil, maybe don't call them streets (P31=street)? BerlinBerlinBerlinBerlin (talk) 18:24, 14 March 2022 (UTC)
Street part
Following my post regarding duplicates created by batch, the creator User:M2k~dewiki decided to convert them to P31=part [1]. There was no information posted here, and I just found out because I wanted to merge the items and get rid of the violations. The conversion means, for some parts of streets, distinguished by location in Ortsteil, Wikidata now has separate entities [2] keeping the label and having a description "street" (not "street part") A list of some are all of the related edits: [3].
Will this be done for all streets? What is next? By postcode? By postcode and Ortsteil? By kind of pavement? By speed limits? Will this be done with squares and bridges too?
Will streets that have parts completely be covered by parts? For the example above this hasn't been done, only one of the two parts by Ortsteil exists. What about the data that is then duplicated, e.g. regarding location in administrative entity (country, district, Ortsteil)? If it can be inferred from the parts, then the whole doesn't need it? But that would mean that streets that are not located in different Ortsteil have different properties in use.
@M2k~dewiki, Pfadintegral, MB-one: what do you think? BerlinBerlinBerlinBerlin (talk) 16:44, 15 March 2022 (UTC)
- I don't think it's a good idea. Having items for sections of streets may be useful - to model different usage, different inception date for different stretches, streets being split off other streets etc. - but a subdivision solely by Ortsteil doesn't make sense to me. As mentioned in another discussion above, these "parts" sometimes aren't even contigous and in many cases only cover one side of a street. The only purpose seems to be to map to the (in my opinion rather strange) way that Berlin streets are modeled on Commons. Pfadintegral (talk) 19:39, 15 March 2022 (UTC)
- @Pfadintegral: additionally: The "Adressauskunft: Straßen und Plätze von Berlin" gives Ortsteile, but they probably refer to the Grundstücke located at the streets, it doesn't mean the street is located in all the Ortsteile that are listed. BerlinBerlinBerlinBerlin (talk) 02:16, 21 March 2022 (UTC)
- @Pfadintegral: fyi https://www.openstreetmap.org/relation/16566#map=18/52.53610/13.36857 - houses 20 to 30 are shown as in Mitte, but the corresponding OSM way is in Wedding. Three OSM ways are named An der Kieler Brücke. [4] the one with the houses is a "pedestrian way". Adressauskunft gives numbers 20 to 31 in Mitte. Item: Q111344986. Maybe, in WD the item should only be marked partially as a street. BerlinBerlinBerlinBerlin (talk) 19:03, 23 March 2022 (UTC)
Items that represent street and part
[5] @M2k~dewiki: what is the logic behind this? BerlinBerlinBerlinBerlin (talk) 17:04, 15 March 2022 (UTC)
Adding names to items not existing in Adressauskunft
@M2k~dewiki: [6] - can you explain? BerlinBerlinBerlinBerlin (talk) 19:32, 22 March 2022 (UTC)
Spelling errors in Commons
During the last three weeks I found some spelling errors. Example, page created 2012:
Category:Epihanienweg (Berlin-Westend)
curprev 20:27, 23 March 2022 BerlinBerlinBerlinBerlin talk contribs 147 bytes +88 This category needs discussion undo
curprev 03:43, 30 December 2021 Pi bot talk contribs m 59 bytes +21 Adding { {Wikidata Infobox} }, current Wikidata ID is Q109534260 undo
curprev 20:11, 13 May 2012 Fridolin freudenfett talk contribs 38 bytes +38 ←Created page with 'Category:Streets in Berlin-Westend' thank
Property since 2022-03-24 in Commons Wikidata Infobox
- 2022-03-07 Proposal
- 2022-03-24 Addition
- c:Template:Wikidata Infobox
- Example : c:Category:Monbijoustraße (Berlin-Mitte)
BerlinBerlinBerlinBerlin (talk) 21:15, 24 March 2022 (UTC) }}
Removal of Berlin Street ID
@A.Savin: you removed a Berlin Street ID [7] from Wikidata. Can you explain? Users took a lot of care to add the IDs to Wikidata and you jump in and remove without any talk on this talk page. BerlinBerlinBerlinBerlin (talk) 01:25, 27 March 2022 (UTC)
Redirecting an item represnting on entity to another item representing another entity
@A.Savin: can you explain [8]? And additionally explain why you did it again without discussing?[9] BerlinBerlinBerlinBerlin (talk) 04:11, 27 March 2022 (UTC)
- And again [10] BerlinBerlinBerlinBerlin (talk) 23:48, 27 March 2022 (UTC)