Queries

               
{{#visualdataquery:[[name::Afghanistan]] [[states/name::Badakhshan]]
|schema=Country 
|?states/cities/name
|?states/cities/latitude
|?states/cities/longitude
|format=datatable 
}} 

pagetitle	Name	Latitude	Longitude
Data:Countries/Afghanistan	Ashkāsham	36.68333	71.53333
Data:Countries/Afghanistan	Fayzabad	37.11664	70.58002
Data:Countries/Afghanistan	Jurm	36.86477	70.83421
Data:Countries/Afghanistan	Khandūd	36.95127	72.318
Data:Countries/Afghanistan	Rāghistān	37.66079	70.67346
Data:Countries/Afghanistan	Wākhān	37.0571	73.34928

{{#visualdataquery:[[name::Afghanistan]]   [[states/name::Badakhshan]] [[states/cities/name::A~]][[states/cities/latitude::36.68333000]] [[states/cities/restaurants/name::bbb]]      
|schema=Country   
|?states/cities/name
|?states/cities/latitude
|format=datatable 
}} 

pagetitle	Name	Latitude
Data:Countries/Afghanistan	Ashkāsham	36.68333

{{#visualdataquery:[[name::Afghanistan]]   [[states/name::Badakhshan]] [[states/cities/name::A~]][[states/cities/restaurants/name::bbb]]      
|schema=Country   
|?states/cities/name
|?states/cities/latitude
|?states/cities/longitude
|format=json 
|hierarchical-conditions=true 
|pagetitle-name=article 
}} 

article "Data:Countries/Afghanistan" data states cities name "Ashkāsham" latitude "36.68333" longitude "71.53333"

{{#visualdataquery:[[name::Afghanistan]]
|schema=Country 
|?states/name
|?states/state_code
|format=table 
}}

pagetitle	Name	State code
Data:Countries/Afghanistan	Badakhshan	BDS
Data:Countries/Afghanistan	Badghis	BDG
Data:Countries/Afghanistan	Baghlan	BGL
Data:Countries/Afghanistan	Balkh	BAL
Data:Countries/Afghanistan	Bamyan	BAM
Data:Countries/Afghanistan	Daykundi	DAY
Data:Countries/Afghanistan	Farah	FRA
Data:Countries/Afghanistan	Faryab	FYB
Data:Countries/Afghanistan	Ghazni	GHA
Data:Countries/Afghanistan	Ghōr	GHO
Data:Countries/Afghanistan	Helmand	HEL
Data:Countries/Afghanistan	Herat	HER
Data:Countries/Afghanistan	Jowzjan	JOW
Data:Countries/Afghanistan	Kabul	KAB
Data:Countries/Afghanistan	Kandahar	KAN
Data:Countries/Afghanistan	Kapisa	KAP
Data:Countries/Afghanistan	Khost	KHO
Data:Countries/Afghanistan	Kunar	KNR
Data:Countries/Afghanistan	Kunduz Province	KDZ
Data:Countries/Afghanistan	Laghman	LAG
Data:Countries/Afghanistan	Logar	LOG
Data:Countries/Afghanistan	Nangarhar	NAN
Data:Countries/Afghanistan	Nimruz	NIM
Data:Countries/Afghanistan	Nuristan	NUR
Data:Countries/Afghanistan	Paktia	PIA
Data:Countries/Afghanistan	Paktika	PKA
Data:Countries/Afghanistan	Panjshir	PAN
Data:Countries/Afghanistan	Parwan	PAR
Data:Countries/Afghanistan	Samangan	SAM
Data:Countries/Afghanistan	Sar-e Pol	SAR
Data:Countries/Afghanistan	Takhar	TAK
Data:Countries/Afghanistan	Urozgan	URU
Data:Countries/Afghanistan	Zabul	ZAB

 
{{#visualdataquery:
[[name::Canada]][[states/name::Q~]]
|schema=Country
|?states/name 
|?states/cities/name 
|?states/cities/latitude 
|limit=50
|format=datatable 
}}

pagetitle	Name	Name	Latitude
Data:Countries/Canada	Quebec	Abitibi-Témiscamingue	48.10018
Data:Countries/Canada	Quebec	Acton Vale	45.65007
Data:Countries/Canada	Quebec	Adstock	46.05007
Data:Countries/Canada	Quebec	Albanel	48.88324
Data:Countries/Canada	Quebec	Alma	48.55009
Data:Countries/Canada	Quebec	Amos	48.56688
Data:Countries/Canada	Quebec	Amqui	48.46382
Data:Countries/Canada	Quebec	Ange-Gardien	45.35008
Data:Countries/Canada	Quebec	Asbestos	45.76678
Data:Countries/Canada	Quebec	Baie-Comeau	49.21679
Data:Countries/Canada	Quebec	Baie-D'Urfé	45.41397
Data:Countries/Canada	Quebec	Baie-Saint-Paul	47.44109
Data:Countries/Canada	Quebec	Barraute	48.43349
Data:Countries/Canada	Quebec	Bas-Saint-Laurent	48.0503
Data:Countries/Canada	Quebec	Beaconsfield	45.43341
Data:Countries/Canada	Quebec	Beauceville	46.21785
Data:Countries/Canada	Quebec	Beauharnois	45.31341
Data:Countries/Canada	Quebec	Beaupré	47.04428
Data:Countries/Canada	Quebec	Bécancour	46.34106
Data:Countries/Canada	Quebec	Bedford	45.11678
Data:Countries/Canada	Quebec	Beloeil	45.56839
Data:Countries/Canada	Quebec	Berthierville	46.08336
Data:Countries/Canada	Quebec	Blainville	45.66678
Data:Countries/Canada	Quebec	Bois-des-Filion	45.66678
Data:Countries/Canada	Quebec	Boisbriand	45.61678
Data:Countries/Canada	Quebec	Bonaventure	48.04573
Data:Countries/Canada	Quebec	Boucherville	45.59104
Data:Countries/Canada	Quebec	Breakeyville	46.68037
Data:Countries/Canada	Quebec	Bromont	45.31678
Data:Countries/Canada	Quebec	Brossard	45.45008
Data:Countries/Canada	Quebec	Brownsburg-Chatham	45.68342
Data:Countries/Canada	Quebec	Buckingham	45.58563
Data:Countries/Canada	Quebec	Cabano	47.68065
Data:Countries/Canada	Quebec	Cacouna	47.91657
Data:Countries/Canada	Quebec	Candiac	45.38338
Data:Countries/Canada	Quebec	Cantley	45.5668
Data:Countries/Canada	Quebec	Cap-Chat	49.10009
Data:Countries/Canada	Quebec	Cap-Santé	46.67159
Data:Countries/Canada	Quebec	Capitale-Nationale	47.376
Data:Countries/Canada	Quebec	Carignan	45.45008
Data:Countries/Canada	Quebec	Carleton	48.09838
Data:Countries/Canada	Quebec	Carleton-sur-Mer	48.10749
Data:Countries/Canada	Quebec	Centre-du-Québec	46.01985
Data:Countries/Canada	Quebec	Chambly	45.45008
Data:Countries/Canada	Quebec	Chambord	48.43339
Data:Countries/Canada	Quebec	Chandler	48.34935
Data:Countries/Canada	Quebec	Chapais	49.78344
Data:Countries/Canada	Quebec	Charlemagne	45.71678
Data:Countries/Canada	Quebec	Château-Richer	46.96031
Data:Countries/Canada	Quebec	Châteauguay	45.38338

See also

• Demo VisualData 1.0
• New task
• Page upload
• CRUD
• Result formats
• Dependent values
• Geolocation
• Queries
• Query cities (join queries)
• Dynamic catalogue
• Official docs