Ready for your workflow

Flexible data delivery

Formats
Microsoft Access, MySQL, CSV, DBF, SQL Server and custom formats.
Updates
Refreshed every 120 days. Master-license updates are available for $25.00.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
Records
68,919
Version
2.0.0
Release date
Oct 28, 2026
Before you choose
Explore the samples
Canada Geocode Database List

Canada Geocode Database v.2.0.0

68,919 Database Records


Canada Geocode Database catalog icon Canada Geocode Database Download
Canada Geocode Database artwork

Explore 64,545 distinct geographic names across 68,919 source rows for Canada. Includes feature identifiers, coordinates, designations and current source codes.

The package includes 33 current NGA fields in CSV, JSON and SQLite, plus schemas, samples and field statistics. Names and coordinates should be verified for operational use.

Table Schema Database Field Statistics

Release structure

Canada Geocode Database

Review the published tables, record coverage, and field names included with release 2.0.0.

Database
#706
Version
2.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
TableRecordsFields
geographic_names68919rk, ufi, uni, full_name, nt, lat_dd, long_dd, efctv_dt, term_dt_f, term_dt_n, desig_cd, fc, cc_ft, adm1, ft_link, name_rank, lang_cd, transl_cd, script_cd, name_link, cc_nm, generic, full_nm_nd, sort_gen, sort_name, lat_dms, long_dms, mgrs, mod_dt_ft, mod_dt_nm, dialect_cd, display, gis_notes

Release at a glance

What is inside this database

64,545 distinct names in 68,919 source rows.

68,919Geographic Names

Feature Class

  • H26,646
  • T23,851
  • P14,553
  • S2,040
  • L1,312
  • A467
  • R30
  • V17
  • U3

Table and column statistics

Select a table to review its schema, record total and fields. Distinct counts exclude nulls. Missing counts include null and blank values where measured.

geographic names68,919 records · 33 fields
rk
Distinct
5
Missing
0 (0.0%)
ufi
Distinct
53,717
Missing
0 (0.0%)
uni
Distinct
64,545
Missing
0 (0.0%)
full_name
Distinct
51,976
Missing
0 (0.0%)
nt
Distinct
4
Missing
0 (0.0%)
lat_dd
Distinct
46,542
Missing
0 (0.0%)
long_dd
Distinct
48,525
Missing
0 (0.0%)
efctv_dt
Distinct
0
Missing
68,919 (100.0%)
term_dt_f
Distinct
8
Missing
68,791 (99.8%)
term_dt_n
Distinct
4
Missing
68,914 (100.0%)
desig_cd
Distinct
171
Missing
0 (0.0%)
fc
Distinct
9
Missing
0 (0.0%)
cc_ft
Distinct
5
Missing
0 (0.0%)
adm1
Distinct
30
Missing
0 (0.0%)
ft_link
Distinct
0
Missing
68,919 (100.0%)
name_rank
Distinct
4
Missing
8,808 (12.8%)
lang_cd
Distinct
16
Missing
56,801 (82.4%)
transl_cd
Distinct
2
Missing
65,693 (95.3%)
script_cd
Distinct
1
Missing
67,178 (97.5%)
name_link
Distinct
3,418
Missing
65,461 (95.0%)
cc_nm
Distinct
6
Missing
68,697 (99.7%)
generic
Distinct
67
Missing
67,552 (98.0%)
full_nm_nd
Distinct
51,902
Missing
0 (0.0%)
sort_gen
Distinct
65
Missing
67,552 (98.0%)
sort_name
Distinct
51,375
Missing
0 (0.0%)
lat_dms
Distinct
35,542
Missing
0 (0.0%)
long_dms
Distinct
43,179
Missing
0 (0.0%)
mgrs
Distinct
53,506
Missing
0 (0.0%)
mod_dt_ft
Distinct
1,599
Missing
0 (0.0%)
mod_dt_nm
Distinct
1,318
Missing
0 (0.0%)
dialect_cd
Distinct
6
Missing
64,347 (93.4%)
display
Distinct
9
Missing
0 (0.0%)
gis_notes
Distinct
3
Missing
68,915 (100.0%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

geographic namesDownload this sample CSV
rkufiunifull_namentlat_ddlong_ddefctv_dtterm_dt_fterm_dt_ndesig_cdfccc_ftadm1ft_linkname_ranklang_cdtransl_cdscript_cdname_linkcc_nmgenericfull_nm_ndsort_gensort_namelat_dmslong_dmsmgrsmod_dt_ftmod_dt_nmdialect_cddisplaygis_notes
191615019211685Harrison BankN55.05-56.666667BNKUUCAN,QUFS1-0001CAN,QUFHarrison BankHARRISONBANK55:03:00-56:40:0021UWB21296004062024-04-17T18:36:35.000Z2024-04-17T18:36:35.000Z1,2,3,4,5,6,7,8,91: An undersea bank located on the Labrador Shelf in the Labrador Sea; named in association with Cape Harrison, Newfoundland and Labrador, Canada. Approved by the U.S. Board on Geographic Names (USBGN) at Meeting 228; July 20, 2004 (Updated at USBGN 292; April 16, 2024).
1-567828-239382Learmouth BankV54.416667-133.083333BNKHCANCA-BCLearmouth BankLEARMOUTHBANK54:25:00-133:05:0008UPF24371315742025-01-29T18:02:54.000Z2025-01-29T18:02:54.000Z1,2,3,4,51: A bank located in the Dixon Entrance between Alaska and British Columbia; name origin unknown.
1-564727-798149FogoN49.7-54.283333PPLPCANCA-NL1FogoFOGO49:42:00-54:17:0021UXR95892088191993-12-14T00:00:00.000Z1993-09-01T00:00:00.000Z1,2,3,4,5
1-15063739164260Hudson BaieV59-86BAYHCANCA-000Hudson BaieHUDSONBAIE59:00:00-86:00:0016VEL57451404822018-07-12T00:00:00.000Z2007-06-15T00:00:00.000Z1,2,3,4,5
1-1506373-2149795Hudson BayN59-86BAYHCANCA-0001engHudson BayHUDSONBAY59:00:00-86:00:0016VEL57451404822018-07-12T00:00:00.000Z2018-07-12T00:00:00.000Z1,2,3,4,5
1-1506366-2149768Bay of FundayV45-66BAYHCAN,USAS1-000Bay of FundayBAYOFFUNDAY45:00:00-66:00:0020TKQ63554873302018-07-12T00:00:00.000Z2018-07-12T00:00:00.000Z1,2,3,4,5
1-1506378-2149810Inside PassageN48-122.4CHNHCAN,USAS1-0001engCAN,USAInside PassageINSIDEPASSAGE48:00:00-122:24:0010UEU44757164742020-05-28T00:00:00.000Z2014-10-23T00:00:00.000Z1,2,3,4,5
1-1506381-2149813James BayN53.49878127-80.50781789BAYHCANCA-0001engJames BayJAMESBAY53:29:56-80:30:2817UNV32648278712024-08-13T12:29:55.000Z2024-08-13T12:29:55.000Z1,2,3,4,5
1-15063819343322Baie JamesN53.49878127-80.50781789BAYHCANCA-0002fraBaieBaie JamesBAIEBAIEJAMES53:29:56-80:30:2817UNV32648278712024-08-13T12:29:55.000Z2024-08-13T12:29:55.000Z1,2,3,4,5
1-15063739343298Baie d’HudsonN59-86BAYHCANCA-0002fraBaieBaie d'HudsonBAIEBAIEDHUDSON59:00:00-86:00:0016VEL57451404822018-07-12T00:00:00.000Z2018-07-12T00:00:00.000Z1,2,3,4,5
1-1506373-2149796Hudson’s BayV59-86BAYHCANCA-000Hudson's BayHUDSONSBAY59:00:00-86:00:0016VEL57451404822018-07-12T00:00:00.000Z2007-06-15T00:00:00.000Z1,2,3,4,5
1-1506366-2149769Bay of FundyN45-66BAYHCAN,USAS1-0001engCAN,USABay of FundyBAYOFFUNDY45:00:00-66:00:0020TKQ63554873302018-07-12T00:00:00.000Z2018-07-12T00:00:00.000Z1,2,3,4,5
1-15063669164258Baie de FundyN45-66BAYHCAN,USAS1-0002fraBaieBaie de FundyBAIEBAIEDEFUNDY45:00:00-66:00:0020TKQ63554873302018-07-12T00:00:00.000Z2018-07-12T00:00:00.000Z1,2,3,4,5
11434348218526099WerenkoN48.8-93.08083AIRQSCANCA-ON1engNOT_TRANSLITERATEDWerenkoWERENKO48:48:00-93:04:5115UVQ94064052262024-06-04T17:27:41.000Z2017-08-04T00:00:00.000Z1,2,3,4,5
11434234218524959OspikaN56.27075-124.06385AIRFSCANCA-BC1engNOT_TRANSLITERATEDOspikaOSPIKA56:16:15-124:03:5010VDH34116367232024-06-04T17:27:41.000Z2017-08-04T00:00:00.000Z1,2,3,4,5
11434243518525052Picton GreenbushN44.00113-77.07346AIRFSCANCA-ON1engNOT_TRANSLITERATEDPicton GreenbushPICTONGREENBUSH44:00:04-77:04:2418TUP33764740882024-06-04T17:27:41.000Z2017-08-04T00:00:00.000Z1,2,3,4,5
11434020118522818AshernN51.15917-98.33317AIRFSCANCA-MB1engNOT_TRANSLITERATEDAshernASHERN51:09:33-98:19:5914UNB46631677372024-06-04T17:27:41.000Z2017-08-04T00:00:00.000Z1,2,3,4,5
11434043018523047Brandon MuniN49.91-99.95227AIRPSCANCA-MB1engNOT_TRANSLITERATEDBrandon MuniBRANDONMUNI49:54:36-99:57:0814UMA31627290592024-06-04T17:27:41.000Z2017-08-04T00:00:00.000Z1,2,3,4,5
11434328318525900Truant SouthN52.27785-113.91522AIRFSCANCA-AB1engNOT_TRANSLITERATEDTruant SouthTRUANTSOUTH52:16:40-113:54:5512UUC01131959462024-06-04T17:27:41.000Z2017-08-04T00:00:00.000Z1,2,3,4,5
11434348218526099WerenkoN48.8-93.08083AIRQSCANCA-ON1engNOT_TRANSLITERATEDWerenkoWERENKO48:48:00-93:04:5115UVQ94064052262024-06-04T17:27:41.000Z2017-08-04T00:00:00.000Z1,2,3,4,5

Records Information

68,919 geographic name rows; 64,545 distinct UNI name identifiers; 53,717 distinct UFI feature identifiers. Shared-country name rows are included only when the exact CAN token occurs in cc_ft.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.

License rights

Single Product Publication

Read the complete Oddity Software Single Product Publication License

Use the entire listed package for internal work, customer-facing websites and apps, and client projects. The license is for this product, not one named project. Raw dataset handoff or standalone resale needs a separate grant.

Downloads of an eligible purchased version are unlimited while it remains the current public version. A newer release does not automatically become part of the earlier order.

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Oddity Support

How can we help?

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details