• Replies 2 replies
  • Subscribers 97 subscribers
  • Views 65 views
  • Users 0 members are here
Options
Related

using GeoArea functionality

Kathleen Smith
$organization

Hi everyone,

I'm taking a crack at setting up some Geo Areas, and I was wondering if anyone has done this for their venues and would be willing to share a sample of their code from their updated stored procedures?  Maybe it's just 'Friday Brain', but I'm having a bit of bother trying to convert from US to UK poscode formats.  I'd be happy to share my final output with you!

Cheers,
Kathleen

Parents
  • $organization

    We don't do anything fancy with US postcodes, we just categorize them all as Foreign. Our Geo-Areas are as follows:

    id          description                   
    ----------- ------------------------------
    1           Inner London
    2           Neighbours
    3           Outer London
    4           South East
    5           Other UK addresses
    0           Bad Address UK
    6           Foreign

     If you want the code for this let me know and I can send it on; however I doesn't sound as if it is as detailed as you would like.

    Caryl

Reply
  • $organization

    We don't do anything fancy with US postcodes, we just categorize them all as Foreign. Our Geo-Areas are as follows:

    id          description                   
    ----------- ------------------------------
    1           Inner London
    2           Neighbours
    3           Outer London
    4           South East
    5           Other UK addresses
    0           Bad Address UK
    6           Foreign

     If you want the code for this let me know and I can send it on; however I doesn't sound as if it is as detailed as you would like.

    Caryl

Children
No Data