query-c27e1607f2a93d9041c0f73f24d92c32
(3) Map of footprints: city or town levelNo.3 (2020.10.04T1013 created)
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# map of footprints at city or town level
# also viewable as table, timeline, and image grid
#defaultView:Map
SELECT DISTINCT ?location ?locationLabel ?locationDescription ?countryLabel ?image ?coord ?first
WHERE {
# define "?location, ?firsttime" as:
VALUES (?location ?firsttime)
# Aix-en-Provence (Q47465), September 1999 (Q1150759)
{(wd:Q47465 wd:Q1150759)
# Baisha Li Autonomous County, Hainan (Q203510), 12 October 2023 (Q69306950)
(wd:Q203510 wd:Q69306950)
# Baoting Li and Miao Autonomous County, Hainan (Q807080), 14 October 2023 (Q69306952)
(wd:Q807080 wd:Q69306952)
# Beidaihe (Q814657), TBD
(wd:Q814657 "TBD")
# Beijing (Q956), TBD
(wd:Q956 "TBD")
# Boston (Q100), TBD
(wd:Q100 "TBD")
# Cambridge MA (Q49111), TBD
(wd:Q49111 "TBD")
# Cannes (Q39984), TBD
(wd:Q39984 "TBD")
# Changjiang Li Autonomous County, Hainan (Q1027323), 28 September 2023 (Q69306936)
(wd:Q1027323 wd:Q69306936)
# Changping (Q393485), TBD
(wd:Q393485 "TBD")
# Chengde (Q58675), TBD
(wd:Q58675 "TBD")
# Chengmai County (Q511654), 10 August 2023 (Q69306887)
(wd:Q511654 wd:Q69306887)
# Chibi, Hubei (Q615021), 19 August 2023 (Q69306896)
(wd:Q615021 wd:Q69306896)
# Dalian (Q74881), 21 October 2006 (Q22663473)
(wd:Q74881 wd:Q22663473)
# Danzhou, Hainan (Q1015132), 29 September 2023 (Q69306937)
(wd:Q1015132 wd:Q69306937)
# Ding'an County, Hainan (Q1022249), 9 October 2023 (Q69306947)
(wd:Q1022249 wd:Q69306947)
# Disneyland CA (Q181185), 20 April 2004 (Q69305488)
(wd:Q181185 wd:Q69305488)
# Dongfang, Hainan (Q174123), 27 September 2023 (Q69306935)
(wd:Q174123 wd:Q69306935)
# Fangshan (Q393462), TBD
(wd:Q393462 "TBD")
# Gong County HENAN (Q1359997, visiting Kang Baiwan's Mansions and Song Tombs), TBD
(wd:Q1359997 "TBD")
# Grand Canyon National Park (Q220289), 22 April 2004 (Q69305491)
(wd:Q220289 wd:Q69305491)
# Great Smoky Mountains National Park (Q464004), TBD
(wd:Q464004 "TBD")
# Guangzhou (Q16572), July 1997 (Q3188203)
(wd:Q16572 wd:Q3188203)
# Haikou, Hainan (Q189823), 12 August 2023 (Q69306889)
(wd:Q189823 wd:Q69306889)
# Hangzhou (Q4970), 21 January 2005 (Q22662978)
(wd:Q4970 wd:Q22662978)
# Hollywood (Q34006), 25 April 2004 (Q69305496)
(wd:Q34006 wd:Q69305496)
# Honolulu (Q18094), 26 February 2006 (Q22663366)
(wd:Q18094 wd:Q22663366)
# Huiji District (Q1360072), TBD
(wd:Q1360072 "TBD")
# Indianapolis (Q6346), 19 October 2002 (Q69304661)
(wd:Q6346 wd:Q69304661)
# Ji County TIANJIN (Q1205847), TBD
(wd:Q1205847 "TBD")
# Jiading (Q662101), 27 February 2007 (Q22663567)
(wd:Q662101 wd:Q22663567)
# Jiahe County, Hunan (Q1338495), 18 August 2023 (Q69306895)
(wd:Q1338495 wd:Q69306895)
# Jiuchong "DENG COUNTY"/XICHUAN (Q5943561, or Pengjiazhuang Shengchandui, Chengying Dadui, Taocha Gongshe, Pengqiao Qu, Deng County), August 1979 (Q13080499)
(wd:Q5943561 wd:Q13080499)
# Kaifeng (Q208471), TBD
(wd:Q208471 "TBD")
# Las Vegas (Q23768), 22 April 2004 (Q69305491)
(wd:Q23768 wd:Q69305491)
# Ledong Li Autonomous County, Hainan (Q1027316), 26 September 2023 (Q69306934)
(wd:Q1027316 wd:Q69306934)
# Lingao County, Hainan (Q1028107), 30 September 2023 (Q69306938)
(wd:Q1028107 wd:Q69306938)
# Lingshui Li Autonomous County, Hainan (Q944615), 25 September 2023 (Q69306933)
(wd:Q944615 wd:Q69306933)
# Linxiang, Hunan (Q1025442), 4 September 2023 (Q69306912)
(wd:Q1025442 wd:Q69306912)
# Los Angeles (Q65), 19 April 2004 (Q69305485)
(wd:Q65 wd:Q69305485)
# Maoming, Guangdong (Q38927), 17 August 2023 (Q69306894)
(wd:Q38927 wd:Q69306894)
# Marseille (Q23482), TBD
(wd:Q23482 "TBD")
# Miyun (Q1022269), TBD
(wd:Q1022269 "TBD")
# Nanchang (Q171943), 4 February 1975 (Q69292163)
(wd:Q171943 wd:Q69292163)
# Nanjing (Q16666), 31 October 2006 (Q22663483)
(wd:Q16666 wd:Q22663483)
# Narita (Q273798), 26 August 2004 (Q69305691)
(wd:Q273798 wd:Q69305691)
# New Haven (Q49145), 24 August 2001 (Q69304006)
(wd:Q49145 wd:Q69304006)
# New York City (Q60), TBD
(wd:Q60 "TBD")
# Niagara Falls USA (Q128133), TBD
(wd:Q128133 "TBD")
# Nice (Q33959), TBD
(wd:Q33959 "TBD")
# Paris (Q90), TBD
(wd:Q90 "TBD")
# Philadelphia (Q1345), TBD
(wd:Q1345 "TBD")
# Pinggu (Q393469), TBD
(wd:Q393469 "TBD")
# Qi County HENAN (Q1198543), February 1976 (Q3092759)
(wd:Q1198543 wd:Q3092759)
# Qian'an (Q1016726), TBD
(wd:Q1016726 "TBD")
# Qingdao (Q170322), 18 July 2003 (Q69305070)
(wd:Q170322 wd:Q69305070)
# Qinhuangdao (Q58560),TBD
(wd:Q58560 "TBD")
# Qionghai, Hainan (Q1005059), 23 September 2023 (Q69306931)
(wd:Q1005059 wd:Q69306931)
# Qiongzhong Li and Miao Autonomous County, Hainan (Q1027336), 11 October 2023 (Q69306949)
(wd:Q1027336 wd:Q69306949)
# Rhode Island (Q1387), TBD
(wd:Q1387 "TBD")
# Sanya (Q319804),24 January 2005 (Q22662981)
(wd:Q319804 wd:Q22662981)
# Shanghai (Q8686), TBD
(wd:Q8686 "TBD")
# Suzhou (Q42622), 17 August 2003 (Q69305119)
(wd:Q42622 wd:Q69305119)
# Taiyuan (Q72778), TBD
(wd:Q72778 "TBD")
# Thousand Islands USA (Q1050549), TBD
(wd:Q1050549 "TBD")
# Tianjin (Q11736), TBD
(wd:Q11736 "TBD")
# Toulon (Q44160), TBD
(wd:Q44160 "TBD")
# Tunchang County, Hainan (Q1022271), 10 October 2023 (Q69306948)
(wd:Q1022271 wd:Q69306948)
# Universal Studios Hollywood (Q1337576), 24 April 2004 (Q69305494)
(wd:Q1337576 wd:Q69305494)
# Vermont (Q16551), 28 November 2002 (Q69304723)
(wd:Q16551 wd:Q69304723)
# Wanning, Hainan (Q997593), 24 September 2023 (Q69306932)
(wd:Q997593 wd:Q69306932)
# Washington DC (Q61), TBD
(wd:Q61 "TBD")
# Wenchang, Hainan (Q997767), 22 September 2023 (Q69306930)
(wd:Q997767 wd:Q69306930)
# Wuzhishan, Hainan (Q1001424), 13 October 2023 (Q69306951)
(wd:Q1001424 wd:Q69306951)
# Wuzhou, Guangxi (Q571652), 9 August 2023 (Q69306886)
(wd:Q571652 wd:Q69306886)
# Xiangyin County, Hunan (Q1199408), 8 August 2023 (Q69306885)
(wd:Q1199408 wd:Q69306885)
# Xinxiang (Q404362), TBD
(wd:Q404362 "TBD")
# Xinzheng (Q1024662), 17 April 2017 (Q33122539)
(wd:Q1024662 wd:Q33122539)
# Xuwen County, Guangdong (Q1374567), 6 September 2023 (Q69306914)
(wd:Q1374567 wd:Q69306914)
# Yanqing (Q596545), TBD
(wd:Q596545 "TBD")
# Yongcheng (Q1199067), TBD
(wd:Q1199067 "TBD")
# Zhengzhou (Q30340), March 1979 (Q3294923)
(wd:Q30340 wd:Q3294923)
# Zhongshan County, Guangxi (Q197906), 5 September 2023 (Q69306913)
(wd:Q197906 wd:Q69306913)
# Zhouzhuang (Q61948), 12 August 2002 (Q69304550)
(wd:Q61948 wd:Q69304550)}
# optional: show ?location's country (P17) as ?country
OPTIONAL {?location wdt:P17 ?country}
# optional: show ?location's image (P18) as ?image
OPTIONAL {?location wdt:P18 ?image}
# optional: show ?location's coordinate location (P625) as ?coord
OPTIONAL {?location wdt:P625 ?coord}
# optional: show ?firsttime's point in time (P585) as ?first
OPTIONAL {?firsttime wdt:P585 ?first}
# show label in auto language as default, and English when no default label exists
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".}
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?coord"):::projected
v3("?country")
v6("?first"):::projected
v2("?firsttime")
v4("?image"):::projected
v1("?location"):::projected
c6(["bd:serviceParam"]):::iri
c8(["#91;AUTO_LANGUAGE#93;,en"]):::literal
bind0[/VALUES ?firsttime ?location/]
bind0-->v1
bind0-->v2
bind00(["wd:Q47465"])
bind00 --> bind0
bind01(["wd:Q1150759"])
bind01 --> bind0
bind02(["wd:Q203510"])
bind02 --> bind0
bind03(["wd:Q69306950"])
bind03 --> bind0
bind04(["wd:Q807080"])
bind04 --> bind0
bind05(["wd:Q69306952"])
bind05 --> bind0
bind06(["wd:Q814657"])
bind06 --> bind0
bind07(["TBD"])
bind07 --> bind0
bind08(["wd:Q956"])
bind08 --> bind0
bind09(["TBD"])
bind09 --> bind0
bind010(["wd:Q100"])
bind010 --> bind0
bind011(["TBD"])
bind011 --> bind0
bind012(["wd:Q49111"])
bind012 --> bind0
bind013(["TBD"])
bind013 --> bind0
bind014(["wd:Q39984"])
bind014 --> bind0
bind015(["TBD"])
bind015 --> bind0
bind016(["wd:Q1027323"])
bind016 --> bind0
bind017(["wd:Q69306936"])
bind017 --> bind0
bind018(["wd:Q393485"])
bind018 --> bind0
bind019(["TBD"])
bind019 --> bind0
bind020(["wd:Q58675"])
bind020 --> bind0
bind021(["TBD"])
bind021 --> bind0
bind022(["wd:Q511654"])
bind022 --> bind0
bind023(["wd:Q69306887"])
bind023 --> bind0
bind024(["wd:Q615021"])
bind024 --> bind0
bind025(["wd:Q69306896"])
bind025 --> bind0
bind026(["wd:Q74881"])
bind026 --> bind0
bind027(["wd:Q22663473"])
bind027 --> bind0
bind028(["wd:Q1015132"])
bind028 --> bind0
bind029(["wd:Q69306937"])
bind029 --> bind0
bind030(["wd:Q1022249"])
bind030 --> bind0
bind031(["wd:Q69306947"])
bind031 --> bind0
bind032(["wd:Q181185"])
bind032 --> bind0
bind033(["wd:Q69305488"])
bind033 --> bind0
bind034(["wd:Q174123"])
bind034 --> bind0
bind035(["wd:Q69306935"])
bind035 --> bind0
bind036(["wd:Q393462"])
bind036 --> bind0
bind037(["TBD"])
bind037 --> bind0
bind038(["wd:Q1359997"])
bind038 --> bind0
bind039(["TBD"])
bind039 --> bind0
bind040(["wd:Q220289"])
bind040 --> bind0
bind041(["wd:Q69305491"])
bind041 --> bind0
bind042(["wd:Q464004"])
bind042 --> bind0
bind043(["TBD"])
bind043 --> bind0
bind044(["wd:Q16572"])
bind044 --> bind0
bind045(["wd:Q3188203"])
bind045 --> bind0
bind046(["wd:Q189823"])
bind046 --> bind0
bind047(["wd:Q69306889"])
bind047 --> bind0
bind048(["wd:Q4970"])
bind048 --> bind0
bind049(["wd:Q22662978"])
bind049 --> bind0
bind050(["wd:Q34006"])
bind050 --> bind0
bind051(["wd:Q69305496"])
bind051 --> bind0
bind052(["wd:Q18094"])
bind052 --> bind0
bind053(["wd:Q22663366"])
bind053 --> bind0
bind054(["wd:Q1360072"])
bind054 --> bind0
bind055(["TBD"])
bind055 --> bind0
bind056(["wd:Q6346"])
bind056 --> bind0
bind057(["wd:Q69304661"])
bind057 --> bind0
bind058(["wd:Q1205847"])
bind058 --> bind0
bind059(["TBD"])
bind059 --> bind0
bind060(["wd:Q662101"])
bind060 --> bind0
bind061(["wd:Q22663567"])
bind061 --> bind0
bind062(["wd:Q1338495"])
bind062 --> bind0
bind063(["wd:Q69306895"])
bind063 --> bind0
bind064(["wd:Q5943561"])
bind064 --> bind0
bind065(["wd:Q13080499"])
bind065 --> bind0
bind066(["wd:Q208471"])
bind066 --> bind0
bind067(["TBD"])
bind067 --> bind0
bind068(["wd:Q23768"])
bind068 --> bind0
bind069(["wd:Q69305491"])
bind069 --> bind0
bind070(["wd:Q1027316"])
bind070 --> bind0
bind071(["wd:Q69306934"])
bind071 --> bind0
bind072(["wd:Q1028107"])
bind072 --> bind0
bind073(["wd:Q69306938"])
bind073 --> bind0
bind074(["wd:Q944615"])
bind074 --> bind0
bind075(["wd:Q69306933"])
bind075 --> bind0
bind076(["wd:Q1025442"])
bind076 --> bind0
bind077(["wd:Q69306912"])
bind077 --> bind0
bind078(["wd:Q65"])
bind078 --> bind0
bind079(["wd:Q69305485"])
bind079 --> bind0
bind080(["wd:Q38927"])
bind080 --> bind0
bind081(["wd:Q69306894"])
bind081 --> bind0
bind082(["wd:Q23482"])
bind082 --> bind0
bind083(["TBD"])
bind083 --> bind0
bind084(["wd:Q1022269"])
bind084 --> bind0
bind085(["TBD"])
bind085 --> bind0
bind086(["wd:Q171943"])
bind086 --> bind0
bind087(["wd:Q69292163"])
bind087 --> bind0
bind088(["wd:Q16666"])
bind088 --> bind0
bind089(["wd:Q22663483"])
bind089 --> bind0
bind090(["wd:Q273798"])
bind090 --> bind0
bind091(["wd:Q69305691"])
bind091 --> bind0
bind092(["wd:Q49145"])
bind092 --> bind0
bind093(["wd:Q69304006"])
bind093 --> bind0
bind094(["wd:Q60"])
bind094 --> bind0
bind095(["TBD"])
bind095 --> bind0
bind096(["wd:Q128133"])
bind096 --> bind0
bind097(["TBD"])
bind097 --> bind0
bind098(["wd:Q33959"])
bind098 --> bind0
bind099(["TBD"])
bind099 --> bind0
bind0100(["wd:Q90"])
bind0100 --> bind0
bind0101(["TBD"])
bind0101 --> bind0
bind0102(["wd:Q1345"])
bind0102 --> bind0
bind0103(["TBD"])
bind0103 --> bind0
bind0104(["wd:Q393469"])
bind0104 --> bind0
bind0105(["TBD"])
bind0105 --> bind0
bind0106(["wd:Q1198543"])
bind0106 --> bind0
bind0107(["wd:Q3092759"])
bind0107 --> bind0
bind0108(["wd:Q1016726"])
bind0108 --> bind0
bind0109(["TBD"])
bind0109 --> bind0
bind0110(["wd:Q170322"])
bind0110 --> bind0
bind0111(["wd:Q69305070"])
bind0111 --> bind0
bind0112(["wd:Q58560"])
bind0112 --> bind0
bind0113(["TBD"])
bind0113 --> bind0
bind0114(["wd:Q1005059"])
bind0114 --> bind0
bind0115(["wd:Q69306931"])
bind0115 --> bind0
bind0116(["wd:Q1027336"])
bind0116 --> bind0
bind0117(["wd:Q69306949"])
bind0117 --> bind0
bind0118(["wd:Q1387"])
bind0118 --> bind0
bind0119(["TBD"])
bind0119 --> bind0
bind0120(["wd:Q319804"])
bind0120 --> bind0
bind0121(["wd:Q22662981"])
bind0121 --> bind0
bind0122(["wd:Q8686"])
bind0122 --> bind0
bind0123(["TBD"])
bind0123 --> bind0
bind0124(["wd:Q42622"])
bind0124 --> bind0
bind0125(["wd:Q69305119"])
bind0125 --> bind0
bind0126(["wd:Q72778"])
bind0126 --> bind0
bind0127(["TBD"])
bind0127 --> bind0
bind0128(["wd:Q1050549"])
bind0128 --> bind0
bind0129(["TBD"])
bind0129 --> bind0
bind0130(["wd:Q11736"])
bind0130 --> bind0
bind0131(["TBD"])
bind0131 --> bind0
bind0132(["wd:Q44160"])
bind0132 --> bind0
bind0133(["TBD"])
bind0133 --> bind0
bind0134(["wd:Q1022271"])
bind0134 --> bind0
bind0135(["wd:Q69306948"])
bind0135 --> bind0
bind0136(["wd:Q1337576"])
bind0136 --> bind0
bind0137(["wd:Q69305494"])
bind0137 --> bind0
bind0138(["wd:Q16551"])
bind0138 --> bind0
bind0139(["wd:Q69304723"])
bind0139 --> bind0
bind0140(["wd:Q997593"])
bind0140 --> bind0
bind0141(["wd:Q69306932"])
bind0141 --> bind0
bind0142(["wd:Q61"])
bind0142 --> bind0
bind0143(["TBD"])
bind0143 --> bind0
bind0144(["wd:Q997767"])
bind0144 --> bind0
bind0145(["wd:Q69306930"])
bind0145 --> bind0
bind0146(["wd:Q1001424"])
bind0146 --> bind0
bind0147(["wd:Q69306951"])
bind0147 --> bind0
bind0148(["wd:Q571652"])
bind0148 --> bind0
bind0149(["wd:Q69306886"])
bind0149 --> bind0
bind0150(["wd:Q1199408"])
bind0150 --> bind0
bind0151(["wd:Q69306885"])
bind0151 --> bind0
bind0152(["wd:Q404362"])
bind0152 --> bind0
bind0153(["TBD"])
bind0153 --> bind0
bind0154(["wd:Q1024662"])
bind0154 --> bind0
bind0155(["wd:Q33122539"])
bind0155 --> bind0
bind0156(["wd:Q1374567"])
bind0156 --> bind0
bind0157(["wd:Q69306914"])
bind0157 --> bind0
bind0158(["wd:Q596545"])
bind0158 --> bind0
bind0159(["TBD"])
bind0159 --> bind0
bind0160(["wd:Q1199067"])
bind0160 --> bind0
bind0161(["TBD"])
bind0161 --> bind0
bind0162(["wd:Q30340"])
bind0162 --> bind0
bind0163(["wd:Q3294923"])
bind0163 --> bind0
bind0164(["wd:Q197906"])
bind0164 --> bind0
bind0165(["wd:Q69306913"])
bind0165 --> bind0
bind0166(["wd:Q61948"])
bind0166 --> bind0
bind0167(["wd:Q69304550"])
bind0167 --> bind0
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P17".-> v3
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P18".-> v4
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P625".-> v5
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P585".-> v6
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c6 --"wikibase:language"--> c8
end