table1
Data license: http://open.canada.ca/en/open-government-licence-canada · Data source: https://open.canada.ca/data/en/dataset/90fed587-1364-4f33-a9ee-208181dc0b97
416 rows sorted by notes descending
This data as json, CSV (advanced)
Suggested facets: label, biometrics
notes ✖
- ASCs only collect biometrics You must already be legally in the U.S. to go to an ASC read the ASC’s health and safety rules before you go 127
- The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. 123
- Most applicants are not eligible to give biometrics at a POE. Make sure you’re eligible before you go. 60
- Walk-in appointments are unavailable 58
- The VAC will only provide limited biometric services until further notice . Visit the VAC’s website before you go. 10
- Offers other services in local languages 6
- Starting November 2, 2019: New set of services Offers other services in local languages 6
- The VAC is temporarily closed until further notice 6
- The VAC will provide limited services until further notice . Visit the VAC's website before you go to find out what services are available. 6
- ASCs only collect biometrics You must already be legally in the U.S. to go to an ASC read the ASC’s health and safety rules before you go 2
- This VAC is open temporarily only to collect biometrics . This VAC will close permanently on November 19, 2021. 2
- = ASCs only collect biometrics You must already be legally in the U.S. to go to an ASC read the ASC’s health and safety rules before you go 1
- For biometrics collection only. 1
- For biometrics collection only. Please email the Embassy to book your appointment. 1
- The ASC is temporarily closed until further notice 1
- The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. 1
- The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find 1
- The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available 1
- The VAC will provide limited services until further notice. Visit the VAC’s website before you go to find out what services are available. 1
- The VAC will provide only limited services until further notice . Visit the VAC’s website before you go to find out what services are available. 1
- This VAC is only offering biometrics collection services for Family class priority applicants Study and work permit applicants 1
| Link | rowid | city_ascii | label | country | website | biometrics | notes ▲ | latitude | longitude | id |
|---|---|---|---|---|---|---|---|---|---|---|
| 359 | 359 | St. John's, Newfoundland Service Canada Centre and Passport Services | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 360 | 360 | Fredericton, New Brunswick Service Canada Centre and Passport Services | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 361 | 361 | Dartmouth, Nova Scotia Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 362 | 362 | Halifax, Nova Scotia Service Canada Centre and Passport Services | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 363 | 363 | Charlottetown, Prince Edward Island Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 364 | 364 | Sainte-Foy, Quebec Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 365 | 365 | Laval, Quebec Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 366 | 366 | Montreal, Quebec Parc-Extension Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 367 | 367 | Montreal, Quebec Verdun Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 368 | 368 | Brossard, Quebec Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 369 | 369 | Saint-Laurent, Quebec Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 370 | 370 | Sherbrooke, Quebec Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 371 | 371 | Gatineau, Quebec Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 372 | 372 | Winnipeg, Manitoba Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 373 | 373 | Winnipeg, Manitoba Winnipeg Crestview Service Canada Centre | SCO | Canada | Appointments are currently unavailable | Walk-in appointments are unavailable | ||||
| 374 | 374 | Saskatoon, Saskatchewan Service Canada Centre and passport services SCO | SCO | Canada | http://www.servicecanada.gc.ca/tbsc-fsco/sc-dsp.jsp?rc=4318&lang=eng | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | |||
| 375 | 375 | Regina, Saskatchewan Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 376 | 376 | Medicine Hat, Alberta Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 377 | 377 | Lethbridge, Alberta Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 378 | 378 | Red Deer, Alberta Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 379 | 379 | Fort McMurray, Alberta Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 380 | 380 | Calgary, Alberta Calgary Royal Vista Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 381 | 381 | Calgary, Alberta Calgary Centre Service Canada Centre and Passport Services | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 382 | 382 | Calgary, Alberta Calgary Temple Crossing Service Canada Centre | SCO | Canada | Appointments are currently unavailable | Walk-in appointments are unavailable | ||||
| 383 | 383 | Calgary, Alberta Calgary Sundance Service Canada Centre and Passport Services | SCO | Canada | Appointments are currently unavailable | Walk-in appointments are unavailable | ||||
| 384 | 384 | Edmonton, Alberta Edmonton Hermitage Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 385 | 385 | Edmonton, Alberta Edmonton Westlink Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 386 | 386 | Edmonton, Alberta Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 387 | 387 | Prince George, British Columbia Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 388 | 388 | Kelowna, British Columbia Passport Services Centre | SCO Temporarily Closed | Canada | Appointments are currently unavailable | Walk-in appointments are unavailable | ||||
| 389 | 389 | Richmond, British Columbia Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 390 | 390 | Vancouver, British Columbia Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 391 | 391 | Surrey, British Columbia Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 392 | 392 | Chilliwack, British Columbia Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 393 | 393 | New Westminster, British Columbia Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 394 | 394 | Burnaby, British Columbia Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 395 | 395 | Abbotsford, British Columbia Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 396 | 396 | Victoria, British Columbia Service Canada Centre and Passport Services | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 397 | 397 | Whitehorse, Yukon Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 398 | 398 | Yellowknife, Northwest Territories Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 399 | 399 | Iqaluit, Nunavut Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 400 | 400 | Ottawa, Ontario Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 401 | 401 | Ottawa, Ontario Ottawa East Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 402 | 402 | Hamilton, Ontario Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 403 | 403 | St. Catharines, Ontario Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 404 | 404 | Whitby, Ontario Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 405 | 405 | Brampton, Ontario Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 406 | 406 | Mississauga, Ontario Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 407 | 407 | Toronto, Ontario Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 408 | 408 | Scarborough, Ontario Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 409 | 409 | North York, Ontario Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 410 | 410 | Toronto, Ontario Toronto - West Humber Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 411 | 411 | Toronto, Ontario Toronto - College Street Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 412 | 412 | Windsor, Ontario Passport Services Centre | SCO | Canada | http://www.servicecanada.gc.ca/tbsc-fsco/sc-dsp.jsp?rc=3000&lang=eng | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | |||
| 413 | 413 | Kitchener, Ontario Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 414 | 414 | London, Ontario Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 415 | 415 | Sudbury, Ontario Service Canada Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 416 | 416 | Thunder Bay, Ontario Passport Services Centre | SCO | Canada | By appointment only Click here to make an appointment | Walk-in appointments are unavailable | ||||
| 279 | 279 | San Francisco | Temporary VAC For biometrics only Closing November 19, 2021 | United States | https://www.vfsglobal.ca/Canada/USA/ | By appointment only | This VAC is open temporarily only to collect biometrics . This VAC will close permanently on November 19, 2021. | |||
| 294 | 294 | Seattle | Temporary VAC For biometrics only Closing November 19, 2021 | United States | https://www.vfsglobal.ca/Canada/USA/ | By appointment only | This VAC is open temporarily only to collect biometrics . This VAC will close permanently on November 19, 2021. | 47.6211 | -122.3244 | 1840021117 |
| 194 | 194 | Mexico City | VAC Open with limited services | Mexico | https://www.vfsglobal.ca/canada/Mexico/English/index.html | By appointment only Appointment requests can be made via email only: [email protected] | This VAC is only offering biometrics collection services for Family class priority applicants Study and work permit applicants | 19.4333 | -99.1333 | 1484247881 |
| 52 | 52 | Bucharest | VAC Open with limited services | Romania | https://visa.vfsglobal.com/rou/en/can | By appointment only | The VAC will provide only limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 44.4 | 26.0833 | 1642414442 |
| 230 | 230 | Ouagadougou | VAC Open with limited services | Burkina Faso | https://visa.vfsglobal.com/bfa/en/can | By appointment only | The VAC will provide limited services until further notice. Visit the VAC’s website before you go to find out what services are available. | 12.3572 | -1.5353 | 1854029208 |
| 3 | 3 | Abidjan | VAC Open with limited services | Ivory Coast | https://visa.vfsglobal.com/civ/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | |||
| 4 | 4 | Abu Dhabi | VAC Open with limited services | United Arab Emirates | https://visa.vfsglobal.com/are/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 24.4781 | 54.3686 | 1784176710 |
| 5 | 5 | Abuja | VAC Open with limited services | Nigeria | https://visa.vfsglobal.com/nga/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 9.0556 | 7.4914 | 1566342270 |
| 6 | 6 | Accra | VAC Open with limited services | Ghana | https://visa.vfsglobal.com/gha/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 5.6037 | -0.187 | 1288299415 |
| 8 | 8 | Ahmedabad | VAC Open with limited services | India | https://www.vfsglobal.ca/canada/india/ | By appointment only Biometrics appointments are free . Don’t pay anyone for an appointment. | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | |||
| 13 | 13 | Algiers | VAC Open with limited services | Algeria | https://visa.vfsglobal.com/dza/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 36.7764 | 3.0586 | 1012973369 |
| 14 | 14 | Almaty | VAC Open with limited services | Kazakhstan | https://visa.vfsglobal.com/kaz/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 43.25 | 76.9 | 1398351701 |
| 18 | 18 | Ankara | VAC Open with limited services | Turkey | https://visa.vfsglobal.com/tur/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 39.93 | 32.85 | 1792572891 |
| 19 | 19 | Antananarivo | VAC Open with limited services | Madagascar | https://visa.vfsglobal.com/mdg/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | -18.9386 | 47.5214 | 1450978461 |
| 21 | 21 | Asuncion | VAC Open with limited services | Paraguay | https://www.vfsglobal.ca/canada/paraguay/english/index.html | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | -25.3 | -57.6333 | 1600057911 |
| 22 | 22 | Athens | VAC Open with limited services | Greece | https://visa.vfsglobal.com/grc/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 37.9794 | 23.7161 | 1300715560 |
| 24 | 24 | Auckland | VAC Open with limited services | New Zealand | http://www.vfsglobal.ca/canada/newzealand/ | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | -36.85 | 174.7833 | 1554435911 |
| 29 | 29 | Bali | VAC Open with limited services | Indonesia | http://www.vfsglobal.ca/canada/indonesia/english/index.html | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | |||
| 30 | 30 | Bamako | VAC Open with limited services | Mali | https://visa.vfsglobal.com/mli/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 12.6458 | -7.9922 | 1466965925 |
| 31 | 31 | Bangalore | VAC Open with limited services | India | https://www.vfsglobal.ca/canada/india/ | By appointment only Biometrics appointments are free . Don’t pay anyone for an appointment. | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 12.9699 | 77.598 | 1356410365 |
| 32 | 32 | Bangkok | VAC Open with limited services | Thailand | https://www.vfsglobal.ca/canada/thailand/ | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 13.75 | 100.5167 | 1764068610 |
| 37 | 37 | Beirut | VAC Open with limited services | Lebanon | https://visa.vfsglobal.com/lbn/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 33.8869 | 35.5131 | 1422847713 |
| 38 | 38 | Belgrade | VAC Open with limited services | Serbia | https://visa.vfsglobal.com/srb/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 44.8167 | 20.4667 | 1688374696 |
| 40 | 40 | Berlin | VAC Open with limited services | Germany | https://visa.vfsglobal.com/deu/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 52.5167 | 13.3833 | 1276451290 |
| 43 | 43 | Bishkek | VAC Open with limited services | Kyrgyzstan | https://visa.vfsglobal.com/kgz/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 42.8667 | 74.5667 | 1417191971 |
| 45 | 45 | Bogota | VAC Open with limited services | Colombia | https://www.vfsglobal.ca/Canada/Colombia/English/index.html | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 4.6126 | -74.0705 | 1170483426 |
| 48 | 48 | Brasilia | VAC Open with limited services | Brazil | http://www.vfsglobal.ca/canada/brazil/english/index.html | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | -15.7744 | -48.0773 | 1076144436 |
| 49 | 49 | Bridgetown | VAC Open with limited services | Barbados | https://www.vfsglobal.ca/Canada/Barbados/ | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 13.0975 | -59.6167 | 1052274244 |
| 54 | 54 | Buenos Aires | VAC Open with limited services | Argentina | http://www.vfsglobal.ca/canada/argentina/english/index.html | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | -34.5997 | -58.3819 | 1032717330 |
| 60 | 60 | Cape Town | VAC Open with limited services | South Africa | https://visa.vfsglobal.com/zaf/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | -33.925 | 18.425 | 1710680650 |
| 61 | 61 | Caracas | VAC Open with limited services | Venezuela | https://www.vfsglobal.ca/Canada/Venezuela/English/index.html | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 10.5 | -66.9333 | 1862748204 |
| 63 | 63 | Castries | VAC Open with limited services | Saint Lucia | http://www.vfsglobal.ca/Canada/Saint-Lucia | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 14.0167 | -60.9833 | 1662922505 |
| 64 | 64 | Cebu | VAC Open with limited services | Philippines | https://www.vfsglobal.ca/canada/Philippines/ | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | |||
| 65 | 65 | Chandigarh | VAC Open with limited services | India | https://www.vfsglobal.ca/canada/india/ | By appointment only Biometrics appointments are free . Don’t pay anyone for an appointment. | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 30.7353 | 76.7911 | 1356739179 |
| 70 | 70 | Chennai | VAC Open with limited services | India | https://www.vfsglobal.ca/canada/india/ | By appointment only Biometrics appointments are free . Don’t pay anyone for an appointment. | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 13.0825 | 80.275 | 1356374944 |
| 78 | 78 | Colombo | VAC Open with limited services | Sri Lanka | http://www.vfsglobal.ca/canada/srilanka/ | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 6.9167 | 79.8333 | 1144251314 |
| 79 | 79 | Conakry | VAC Open with limited services | Guinea | https://visa.vfsglobal.com/gin/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 9.5092 | -13.7122 | 1324568159 |
| 83 | 83 | Dakar | VAC Open with limited services | Senegal | https://visa.vfsglobal.com/sen/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 14.7319 | -17.4572 | 1686604760 |
| 89 | 89 | Dhaka | VAC Open with limited services | Bangladesh | http://www.vfsglobal.ca/Canada/bangladesh/index.html | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 23.7161 | 90.3961 | 1050529279 |
| 90 | 90 | Doha | VAC Open with limited services | Qatar | https://visa.vfsglobal.com/qat/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 25.3 | 51.5333 | 1634459660 |
| 93 | 93 | Dubai | VAC Open with limited services | United Arab Emirates | https://visa.vfsglobal.com/are/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 25.2697 | 55.3094 | 1784736618 |
| 94 | 94 | Dublin | VAC Open with limited services | Ireland | https://visa.vfsglobal.com/irl/en/can | By appointment only | The VAC will provide limited services until further notice . Visit the VAC’s website before you go to find out what services are available. | 53.3425 | -6.2658 | 1372595407 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "table1" (city_ascii TEXT, label TEXT, country TEXT, website TEXT, biometrics TEXT, notes TEXT, latitude REAL, longitude REAL, id INTEGER);