Shortcut: WD:DMRC

Wikidata:WikiProject Delhi Metro

From Wikidata
Jump to navigation Jump to search

Welcome to the Wikiproject for List of Station of Delhi Metro (Q271195)! This page attempts to collect all relevant resources to help add information about different aspects of this topic. It is broadly sub-divided into organizations, lines, and stations. Each of these divisions has a sub-page with a Wikidata table to help with the work, interesting queries that can be run on existing data, and properties relevant to those objects.


How can I help?

[edit]
  • If you are new to Wikidata, and want to do basic editing, you use the table of stations and add missing properties.
  • If you are a photographer, you could take photos of stations and add them to Commons, and then to Wikidata.
  • If you are multilingual, you could help by adding labels to stations.
  • If you are familiar with Delhi Metro, or know of resources that have a lot of data, you could add them to the resources section on this page.
  • If you are familiar with Wikidata, you could propose adding properties to certain object types.
  • We have a lot of doubts and questions in the scratchpad section, please feel free to suggest solutions and discuss.

Organizations

[edit]

While technically different, the Delhi Metro (Q271195) is closely linked to Rapid Metro Gurgaon (Q7294170) and Noida Metro (Q16909221). They are all an instance of (P31) rapid transit (Q15099348) which are located in the administrative territorial entity (P131) of Delhi (Q1353), Noida (Q278204), Faridabad (Q200663), Ghaziabad (Q207098), and Gurgaon (Q238508). See Wikidata:WikiProject Delhi Metro/Organizations for a list of metro systems and relevant properties.

List of metro systems in the NCR region 
SELECT DISTINCT ?item ?itemLabel WHERE {
  ?item wdt:P31 wd:Q15099348.
  ?item wdt:P131 ?area.
  
  FILTER (
    ?area = wd:Q278204 ||
    ?area = wd:Q238508 ||
    ?area = wd:Q1353 ||
    ?area = wd:Q200663 ||
    ?area = wd:Q207098
    )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!
Comparison of length of metro systems 
#defaultView:BarChart
#Comparison of lengths of different metro systems
SELECT DISTINCT ?item ?itemLabel ?len WHERE {
  ?item wdt:P31 wd:Q15099348.
  { ?item wdt:P131 wd:Q278204 }
  UNION { ?item wdt:P131 wd:Q238508 }
  UNION { ?item wdt:P131 wd:Q1353 }
  UNION { ?item wdt:P131 wd:Q200663 }
  UNION { ?item wdt:P131 wd:Q207098 }
  
  ?item wdt:P2043 ?len
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!

Properties

[edit]
Title ID Data type Description Examples Inverse
instance ofP31Iteminstance of: that class of which this subject is a particular example and member; different from P279 (subclass of); for example: K2 is an instance of mountain; volcano is a subclass of mountain (and an instance of volcanic landform)Delhi Metro <instance of> rapid transit-
imageP18Commons media fileillustration and image: image of relevant illustration of the subject; if available, also use more specific properties (sample: coat of arms image, locator map, flag image, signature image, logo image, collage image)Douglas Adams <image> Douglas adams portrait cropped.jpg-
logo imageP154Commons media filelogo: graphic mark or emblem commonly used by commercial enterprises, organizations and productsKansas City Royals <logo image> Kansas City Royals Insignia.svg-
inceptionP571Point in timedate of establishment, founding and date of the first award: time when an entity begins to exist; for date of official opening use P1619Society of Jesus <inception> -
countryP17Itemhistorical country, state and sovereign state: sovereign state that this item is in (not to be used for human beings)Wusung Radio Tower <country> People's Republic of China-
located in the administrative territorial entityP131Itemadministrative territorial entity: the item is located on the territory of the following administrative entity. Use P276 for specifying locations that are non-administrative places and for items about events. Use P1382 if the item falls only partially into the administrative entity.Seattle <located in the administrative territorial entity> King County-
patronageP3872Quantityridership and number of individuals: number of passengers, patrons or visitors in specified time periodTimes Square–42nd Street/Port Authority Bus Terminal <patronage> 64,815,739-
daily patronageP1373Quantitypassengers per day: number of daily passengers, patrons or visitors in specified time periodTexas Eagle <daily patronage> 821-
detail mapP1621Commons media filemap: map containing details about the entire locationSicily <detail map> Map of region of Sicily, Italy, with provinces-en.svg-
lengthP2043Quantitylength and length overall: measured dimension of an objectTrans-Siberian railway <length> 9,289 kilometre-

Lines

[edit]

You can see a list of lines and their properties on Wikidata:WikiProject Delhi Metro/Lines.

Queries

[edit]
Comparison of length of lines 
#defaultView:BarChart
#Comparison of length of lines
SELECT ?item ?itemLabel ?length WHERE {
  ?item wdt:P16 wd:Q271195.
  ?item wdt:P31 wd:Q15079663.
  ?item wdt:P2043 ?length
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
 }
Try it!
Timeline of line openings 
#defaultView:Timeline
#Timeline of line openings
SELECT ?item ?itemLabel ?image ?inception WHERE {
  ?item wdt:P16 wd:Q271195.
  ?item wdt:P31 wd:Q15079663.
  ?item wdt:P18 ?image.
  ?item wdt:P571 ?inception.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!
Locations covered by the line 
#defaultView:Graph
#Locations covered by the line
SELECT ?item ?itemLabel ?loc ?locLabel WHERE {
  ?item wdt:P16 wd:Q271195.
  ?item wdt:P31 wd:Q15079663.
  ?item wdt:P131 ?loc.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!
Comparison of speed limits of lines (bad visualization, I just wanted to use ?rgb) 
#defaultView:BubbleChart
#Comparison of speed limits of lines
SELECT ?item ?itemLabel ?speed ?rgb WHERE {
  ?item wdt:P16 wd:Q271195.
  ?item wdt:P31 wd:Q15079663.
  ?item wdt:P3086 ?speed.
  ?item wdt:P465 ?rgb.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
 }
Try it!

Properties

[edit]
Title ID Data type Description Examples Inverse
transport networkP16Itemtransport network: network the infrastructure is a part ofYellow Line <transport network> Delhi Metro-
instance ofP31Iteminstance of: that class of which this subject is a particular example and member; different from P279 (subclass of); for example: K2 is an instance of mountain; volcano is a subclass of mountain (and an instance of volcanic landform)Yellow Line <instance of> rapid transit railway line-
inceptionP571Point in timedate of establishment, founding and date of the first award: time when an entity begins to exist; for date of official opening use P1619Society of Jesus <inception> -
located in the administrative territorial entityP131Itemadministrative territorial entity: the item is located on the territory of the following administrative entity. Use P276 for specifying locations that are non-administrative places and for items about events. Use P1382 if the item falls only partially into the administrative entity.Seattle <located in the administrative territorial entity> King County-
imageP18Commons media fileillustration and image: image of relevant illustration of the subject; if available, also use more specific properties (sample: coat of arms image, locator map, flag image, signature image, logo image, collage image)Douglas Adams <image> Douglas adams portrait cropped.jpg-
terminusP559Itemterminus: the feature (intersecting road, train station, etc.) at the end of a linear featureOklahoma State Highway 74 <terminus> Interstate 35 in Oklahoma and Oklahoma State Highway 7-
lengthP2043Quantitylength and length overall: measured dimension of an objectTrans-Siberian railway <length> 9,289 kilometre-
track gaugeP1064Itemtrack gauge: spacing of the rails on a railway trackBelgrade–Bar railway <track gauge> 1435 mm track gauge-
type of electrificationP930Itemrailway electrification system: electrification system scheme and/or voltageChannel Tunnel <type of electrification> 25 kV AC railway electrification-
sRGB color hex tripletP465StringsRGB: sRGB hex triplet format for subject color (e.g. 7FFFD4) specifying the 8-bit red, green and blue componentsaquamarine <sRGB color hex triplet> 7FFFD4-
speed limitP3086Quantityspeed limit: maximum speed allowed on a transport route or in a certain areaInterstate 285 <speed limit> 65 mile per hour-
route diagram templateP3858ItemWikimedia route diagram: Wikimedia template with route diagramCentral line <route diagram template> Template:Central line RDT-
owned byP127Itemproprietor, property and owned by: owner of the subjectChoupette <owned by> Karl Lagerfeldowner of
operatorP137Itemoperator: person, profession, organization or entity that operates the equipment, facility, or serviceYamanote Line <operator> East Japan Railway Companyitem operated

Stations

[edit]

The following is not the entire list of stations, its only the ones that have instance of (P31) and transport network (P16). To see a list of items that don't have these properties, but have a Wikipedia page in the right category use petscan (works on Chrome). You can also see stations with relevant properties on Wikidata:WikiProject Delhi Metro/Stations. Ideally we'd want labels in English, Hindi, Urdu, and Punjabi as they are the primary languages in Delhi. You can track the progress of the labels on Wikidata:WikiProject Delhi Metro/Stations labels.


Queries

[edit]
Stations and their important properties (supports multiple views) [might slow down browser] 
# All Delhi Metro stations and their important properties
SELECT ?item ?inception ?coordinate_location ?adjacent_stationLabel ?image ?located_in_the_administrative_territorial_entity ?located_in_the_administrative_territorial_entityLabel WHERE {
  ?item wdt:P16 wd:Q271195.
  ?item wdt:P31 wd:Q928830.
  OPTIONAL { ?item wdt:P571 ?inception. }
  OPTIONAL { ?item wdt:P625 ?coordinate_location. }
  OPTIONAL { ?item wdt:P197 ?adjacent_station. }
  OPTIONAL { ?item wdt:P18 ?image. }
  OPTIONAL { ?item wdt:P131 ?located_in_the_administrative_territorial_entity. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!
Daily patronage from stations 
#defaultView:BarChart
#Daily patronage from different stations
#Data mostly from January 2015
SELECT ?item ?itemLabel ?patronage WHERE {
  ?item wdt:P16 wd:Q271195.
  ?item wdt:P31 wd:Q928830.
  ?item wdt:P1373 ?patronage. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!
Map of stations 
#defaultView:Map
#Map of Delhi Metro stations
SELECT ?item ?itemLabel ?coord WHERE {
  ?item wdt:P16 wd:Q271195.
  ?item wdt:P31 wd:Q928830.
  ?item wdt:P625 ?coord. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!
Facilities available at stations 
#defaultView:TreeMap
#Facilities available at stations
SELECT ?facility ?facilityLabel ?item ?itemLabel WHERE {
  ?item wdt:P16 wd:Q271195.
  ?item wdt:P31 wd:Q928830.
  ?item wdt:P912 ?facility. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!
Timeline of station opening 
#defaultView:Timeline
#Timeline of station opening
SELECT ?item ?itemLabel ?inception WHERE {
  ?item wdt:P16 wd:Q271195.
  ?item wdt:P31 wd:Q928830.
  ?item wdt:P571 ?inception. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!
Network of metro stations 
#defaultView:Graph
#Network of metro stations
SELECT ?item ?itemLabel ?linkTo WHERE {
  ?item wdt:P16 wd:Q271195.
  ?item wdt:P31 wd:Q928830.
  OPTIONAL { ?item wdt:P197 ?linkTo }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!

Properties

[edit]
Title ID Data type Description Examples Inverse
transport networkP16Itemtransport network: network the infrastructure is a part ofBotanical Garden metro station <transport network> Delhi Metro-
instance ofP31Iteminstance of: that class of which this subject is a particular example and member; different from P279 (subclass of); for example: K2 is an instance of mountain; volcano is a subclass of mountain (and an instance of volcanic landform)Botanical Garden metro station <instance of> metro station-
inceptionP571Point in timedate of establishment, founding and date of the first award: time when an entity begins to exist; for date of official opening use P1619Botanical Garden metro station <inception> 12 Nov 2009-
coordinate locationP625Geographic coordinatesgeographic coordinates: geocoordinates of the subject. For Earth, please note that only WGS84 coordinating system is supported at the momentMount Everest <coordinate location> 27° 59′ 17.00″ N 86° 55′ 31.00″ E-
connecting lineP81Itemrailway line and rail track: railway line(s) subject is directly connected toNoida Sector 18 metro station <connecting line> Blue Line-
adjacent stationP197ItemThe stations next to this station, sharing the same line(s). Should be qualified with connecting line (P81), direction (P560), and start time (P580).Noida Sector 18 metro station <adjacent station> Botanical Garden metro station-
floors below groundP1139Quantitynumber of floors below ground: total number of below ground floors of the buildingTaipei 101 <floors below ground> 5-
floors above groundP1101Quantitynumber of floors above ground: above ground floor count of a building (ground floor and attic included)Empire State Building <floors above ground> 102-
station codeP296Stringrailway station code: generic identifier for a railway station, when possible, use specific property on certain coding system (e.g. P1378 for China Railway TMIS codes)Reuchenette-Péry railway station <station code> REU-
located in the administrative territorial entityP131Itemadministrative territorial entity: the item is located on the territory of the following administrative entity. Use P276 for specifying locations that are non-administrative places and for items about events. Use P1382 if the item falls only partially into the administrative entity.Seattle <located in the administrative territorial entity> King County-
imageP18Commons media fileillustration and image: image of relevant illustration of the subject; if available, also use more specific properties (sample: coat of arms image, locator map, flag image, signature image, logo image, collage image)Douglas Adams <image> Douglas adams portrait cropped.jpg-
number of platform tracksP1103Quantitynumber of tracks served by the platforms at a railway stationReading railway station <number of platform tracks> 15-
daily patronageP1373Quantitypassengers per day: number of daily passengers, patrons or visitors in specified time periodTexas Eagle <daily patronage> 821-
has facilityP912Itemfacility: Use with objects like toilet (Q7857), parking lot (Q6501349), police station (Q861951) etc.Botanical Garden metro station <has facility> toilet-


Scratchpad: questions, tasks, doubts

[edit]

Resources

[edit]

From English Wikipedia

[edit]

Delhi Metro website

[edit]

External

[edit]

Participants

[edit]
[+] Add yourself to the list

The participants listed below can be notified using the following template in discussions:
{{Ping project|Delhi Metro}}

Userbox

[edit]

A userbox is available that you can add on your userpage.

This user is a member of WikiProject Delhi Metro.

Use {{WikiProject Delhi Metro member}} on your userpage to use the userbox. (Feel free to translate the userbox into your own language!)

Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:WikiProject_Delhi_Metro&oldid=1819218041"