0

Pyramid Geospatial for Postal Code

I am working on bubble map chart in Pyramid (2023.10) to show our clients number in a map using street address or postal code (default country is Canada), it works for street address but does not work when I use postal code, just wonder which format used for Canada?

6 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 6 mths ago
    • Reported - view

     ,

    The format of post codes in Canada according the Google is:

    "The postal code is a six-character code defined and maintained by Canada Post Corporation (CPC) for the purpose of sorting and delivering mail. The characters are arranged in the form 'ANA NAN', where 'A' represents an alphabetic character and 'N' represents a numeric character ( e.g. , K1A 0T6)."

    Here's an example:

    Hope that helps.

    Ian

      • Senior Director of Product
      • Ian_Macdonald
      • 6 mths ago
      • Reported - view

      Don't forget to set the map locale to Canada. That way you have a better chance of resolving the post codes correctly

       

      Ian

      • Ying_Dong
      • 6 mths ago
      • Reported - view

      Thanks Ian, I do set geospatial defaults to Canada and specific State too, it works for street address, but not postal code in my case, here is my screenshot.

      • Senior Director of Product
      • Ian_Macdonald
      • 6 mths ago
      • Reported - view

       

      I've done some testing by downloading the complete list of Canadian post codes by City and Province. I took the first 3 characters of the post code to give the Forward Sorting Areas (FSA) to add to the data.

      It seems that the MapBox service we licence only goes down to the FSA level, the complete 6 character post codes are not supported.

      You can add the full six character post code shape support through the custom map feature in Pyramid. To do this you will need to source the post code shape fie in geojson format. See Help for more details. From what I've read online, these have to be purchased, there don't appear to be any free versions, but you might find something with more assiduous searching.

      Hope that helps.

      Ian

      • Senior Director of Product
      • Ian_Macdonald
      • 6 mths ago
      • Reported - view

      BTW, the file I found was free and includes the lat/long centre of the full postcode. That might be helpful to you. You can find the website here.

      Hope that helps some more!

      Ian

      • Ying_Dong
      • 6 mths ago
      • Reported - view

      Thank you so much Ian, that is help

Content aside

  • Status Answered
  • 6 mths agoLast active
  • 6Replies
  • 36Views
  • 2 Following