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 label descending
This data as json, CSV (advanced)
biometrics ✖
- By appointment only ( see instructions ) 132
- By appointment only 63
- You cannot give your biometrics at a Canadian port of entry (POE) unless you meet these 2 requirements: you’re eligible to apply for a study permit or work permit at a POE you start and finish your application at the POE 59
- By appointment only Click here to make an appointment 54
- Appointments are currently unavailable 4
- By appointment only If needed, the VAC will contact you to reschedule your appointment 2
- By appointment only Biometrics appointments are free . Don’t pay anyone for an appointment. 1
- You cannot give your biometrics at a Canadian port of entry (POE) unless you meet these 2 requirements: you're eligible to apply for a study permit or work permit at a POE you start and finish your application at the POE 1
Link | rowid | city_ascii | label ▲ | country | website | biometrics | notes | latitude | longitude | id |
---|---|---|---|---|---|---|---|---|---|---|
221 | 221 | Nur-Sultan | 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. | 51.1333 | 71.4333 | 1398516045 |
222 | 222 | Novosibirsk | VAC Open with limited services | Russia | https://visa.vfsglobal.com/rus/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. | 55.0333 | 82.9167 | 1643399240 |
227 | 227 | Osaka | VAC Open with limited services | Japan | http://www.vfsglobal.ca/canada/japan/ | 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.6936 | 135.5019 | 1392419823 |
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 |
233 | 233 | Panama City | VAC Open with limited services | Panama | http://www.vfsglobal.ca/canada/panama/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. | 9.0 | -79.5 | 1591672475 |
234 | 234 | Paris | VAC Open with limited services | France | https://visa.vfsglobal.com/fra/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. | 48.8566 | 2.3522 | 1250015082 |
235 | 235 | Perth | VAC Open with limited services | Australia | http://www.vfsglobal.ca/canada/australia/ | 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. | -31.9522 | 115.8589 | 1036178956 |
238 | 238 | Phnom Penh | VAC Open with limited services | Cambodia | http://www.vfsglobal.ca/canada/cambodia/ | 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. | 11.5696 | 104.921 | 1116260534 |
245 | 245 | Port Louis | VAC Open with limited services | Mauritius | https://visa.vfsglobal.com/mus/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. | -20.1667 | 57.5 | 1480131261 |
246 | 246 | Port of Spain | VAC Open with limited services | Trinidad and Tobago | https://www.vfsglobal.ca/Canada/Trinidad-and-Tobago/ | 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. | |||
247 | 247 | Port-au-Prince | VAC Open with limited services | Haiti | https://www.vfsglobal.ca/Canada/Haiti/ | 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.5425 | -72.3386 | 1332401940 |
249 | 249 | Porto Alegre | 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. | -30.0328 | -51.23 | 1076658221 |
251 | 251 | Pretoria | 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. | -25.7464 | 28.1881 | 1710176249 |
252 | 252 | Pristina | VAC Open with limited services | Kosovo | https://visa.vfsglobal.com/xkx/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.6667 | 21.1667 | 1901760068 |
253 | 253 | Pune | 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. | 18.5196 | 73.8553 | 1356081074 |
256 | 256 | Quito | VAC Open with limited services | Ecuador | http://www.vfsglobal.ca/canada/ecuador/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. | -0.2186 | -78.5097 | 1218441993 |
257 | 257 | Rabat | VAC Open with limited services | Morocco | https://visa.vfsglobal.com/mar/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. | 34.0253 | -6.8361 | 1504023252 |
259 | 259 | Rangoon (Yangon) | VAC Open with limited services | Burma (Myanmar) | http://www.vfsglobal.ca/canada/myanmar/ | 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. | |||
261 | 261 | Recife | 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. | -8.0539 | -34.8808 | 1076137337 |
267 | 267 | Rio de Janeiro | 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. | -22.9083 | -43.1964 | 1076887657 |
269 | 269 | Riyadh | VAC Open with limited services | Saudi Arabia | https://visa.vfsglobal.com/sau/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.65 | 46.71 | 1682999334 |
271 | 271 | Rome | VAC Open with limited services | Italy | https://visa.vfsglobal.com/ita/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. | 41.8931 | 12.4828 | 1380382862 |
272 | 272 | Rostov-on-Don | VAC Open with limited services | Russia | https://visa.vfsglobal.com/rus/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. | |||
273 | 273 | Saint Petersburg | VAC Open with limited services | Russia | https://visa.vfsglobal.com/rus/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. | 59.95 | 30.3167 | 1643616350 |
281 | 281 | San Jose | VAC Open with limited services | Costa Rica | http://www.vfsglobal.ca/canada/costarica/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. | 9.9333 | -84.0833 | 1188749877 |
284 | 284 | San Salvador | VAC Open with limited services | El Salvador | http://www.vfsglobal.ca/canada/elsalvador/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. | 13.6989 | -89.1914 | 1222647454 |
287 | 287 | Santo Domingo | VAC Open with limited services | Dominican Republic | https://www.vfsglobal.ca/Canada/DominicanRepublic/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. | 18.4764 | -69.8933 | 1214636202 |
288 | 288 | Santiago | VAC Open with limited services | Chile | https://www.vfsglobal.ca/Canada/Chile/ | 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.45 | -70.6667 | 1152554349 |
289 | 289 | Sao Paulo | 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. | -23.5504 | -46.6339 | 1076532519 |
297 | 297 | Shanghai | VAC Open with limited services | China | https://www.vfsglobal.ca/canada/china/english/index.html | By appointment only If needed, the VAC will contact you to reschedule your appointment | The VAC will only provide limited biometric services until further notice . Visit the VAC’s website before you go. | 31.1667 | 121.4667 | 1156073548 |
298 | 298 | Shenyang | VAC Open with limited services | China | https://www.vfsglobal.ca/canada/china/english/index.html | By appointment only If needed, the VAC will contact you to reschedule your appointment | The VAC will only provide limited biometric services until further notice . Visit the VAC’s website before you go. | 41.8039 | 123.4258 | 1156309382 |
299 | 299 | Singapore | VAC Open with limited services | Singapore | http://www.vfsglobal.ca/canada/singapore/ | 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 | 1.3 | 103.8 | 1702341327 |
301 | 301 | Skopje | VAC Open with limited services | Macedonia | https://visa.vfsglobal.com/mkd/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. | 41.9833 | 21.4333 | 1807600615 |
315 | 315 | Stockholm | VAC Open with limited services | Sweden | https://visa.vfsglobal.com/swe/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. | 59.3294 | 18.0686 | 1752425602 |
317 | 317 | Suva | VAC Open with limited services | Fiji | http://www.vfsglobal.ca/canada/fiji/ | 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.1333 | 178.4333 | 1242615095 |
318 | 318 | Sydney | VAC Open with limited services | Australia | http://www.vfsglobal.ca/canada/australia/ | 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.865 | 151.2094 | 1036074917 |
319 | 319 | Sylhet | 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. | 24.9 | 91.8667 | 1050646703 |
323 | 323 | Tbilisi | VAC Open with limited services | Georgia | https://visa.vfsglobal.com/geo/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. | 41.7225 | 44.7925 | 1268203191 |
324 | 324 | Tegucigalpa | VAC Open with limited services | Honduras | http://www.vfsglobal.ca/canada/honduras/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. | 14.0942 | -87.2067 | 1340344059 |
325 | 325 | Tel Aviv | VAC Open with limited services | Israel | https://visa.vfsglobal.com/isr/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. | |||
326 | 326 | The Hague | VAC Open with limited services | The Netherlands | https://visa.vfsglobal.com/nld/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. | |||
328 | 328 | Tokyo | VAC Open with limited services | Japan | http://www.vfsglobal.ca/canada/japan/ | 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. | 35.6897 | 139.6922 | 1392685764 |
332 | 332 | Tunis | VAC Open with limited services | Tunisia | https://visa.vfsglobal.com/tun/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.8008 | 10.18 | 1788742103 |
334 | 334 | Ulaanbaatar | VAC Open with limited services | Mongolia | http://www.vfsglobal.ca/canada/mongolia/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. | 47.9203 | 106.9172 | 1496024767 |
338 | 338 | Vienna | VAC Open with limited services | Austria | https://visa.vfsglobal.com/aut/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. | 48.2083 | 16.3731 | 1040261752 |
339 | 339 | Vladivostok | VAC Open with limited services | Russia | https://visa.vfsglobal.com/rus/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.1167 | 131.9 | 1643832017 |
340 | 340 | Warsaw | VAC Open with limited services | Poland | https://visa.vfsglobal.com/pol/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.2167 | 21.0333 | 1616024847 |
351 | 351 | Wuhan | VAC Open with limited services | China | https://www.vfsglobal.ca/canada/china/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.5872 | 114.2881 | 1156117184 |
353 | 353 | Yaoundé | VAC Open with limited services | Cameroon | https://visa.vfsglobal.com/cmr/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. | |||
355 | 355 | Yekaterinburg | VAC Open with limited services | Russia | https://visa.vfsglobal.com/rus/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. | 56.8356 | 60.6128 | 1643582706 |
356 | 356 | Yerevan | VAC Open with limited services | Armenia | https://visa.vfsglobal.com/arm/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. | 40.1814 | 44.5144 | 1051074169 |
7 | 7 | Addis Ababa | VAC | Ethiopia | https://visa.vfsglobal.com/eth/en/can | By appointment only | Starting November 2, 2019: New set of services Offers other services in local languages | 9.0272 | 38.7369 | 1231824991 |
28 | 28 | Baku | VAC | Azerbaijan | https://visa.vfsglobal.com/aze/en/can | By appointment only | Offers other services in local languages | 40.3667 | 49.8352 | 1031946365 |
57 | 57 | Cairo | VAC | Egypt | https://visa.vfsglobal.com/egy/en/can | By appointment only | Starting November 2, 2019: New set of services Offers other services in local languages | 30.0561 | 31.2394 | 1818253931 |
71 | 71 | Chisinau | VAC | Moldova | https://visa.vfsglobal.com/mda/en/can | By appointment only | Starting November 2, 2019: New set of services Offers other services in local languages | 47.0056 | 28.8575 | 1498011437 |
85 | 85 | Dar es Salaam | VAC | Tanzania | https://visa.vfsglobal.com/tza/en/can | By appointment only | Starting November 2, 2019: New set of services Offers other services in local languages | -6.8 | 39.2833 | 1834843853 |
125 | 125 | Hanoi | VAC | Vietnam | https://www.vfsglobal.ca/canada/vietnam/index.html | By appointment only | Offers other services in local languages | 21.0245 | 105.8412 | 1704413791 |
130 | 130 | Helsinki | VAC | Finland | https://visa.vfsglobal.com/fin/en/can | By appointment only | Offers other services in local languages | 60.1756 | 24.9342 | 1246177997 |
134 | 134 | Hong Kong | VAC | Hong Kong SAR | http://www.vfsglobal.ca/canada/Hongkong/english/index.html | By appointment only | Offers other services in local languages | |||
290 | 290 | Sarajevo | VAC | Bosnia and Herzegovina | https://visa.vfsglobal.com/bih/en/can | By appointment only | Starting November 2, 2019: New set of services Offers other services in local languages | |||
296 | 296 | Seoul | VAC | South Korea | http://www.vfsglobal.ca/canada/korea/english/index.html | By appointment only | Offers other services in local languages | |||
321 | 321 | Taipei | VAC | Taiwan | http://www.vfsglobal.ca/canada/taiwan/english/index.html | By appointment only | Offers other services in local languages | 25.0478 | 121.5319 | 1158881289 |
327 | 327 | Tirana | VAC | Albania | https://visa.vfsglobal.com/alb/en/can | By appointment only | Starting November 2, 2019: New set of services Offers other services in local languages | 41.33 | 19.82 | 1008162156 |
266 | 266 | Reykjavík | Temporary location | Iceland | #centred-popup-iceland | By appointment only | For biometrics collection only. Please email the Embassy to book your appointment. | |||
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 |
388 | 388 | Kelowna, British Columbia Passport Services Centre | SCO Temporarily Closed | Canada | Appointments are currently unavailable | Walk-in appointments are unavailable | ||||
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 | ||||
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 |
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);