Geo: States and Provinces

[AlanLattimore]

Does anyone know of a comprehensive list of geos, especially for the UK/France/Germany?

Thanks in advance,
Alan

[BJ Freeman]

did a google search on Europe Geocode
http://batchgeocode.blogspot.com/2006/06/google-serves-up-geocoding-including.html

AlanLattimore sent the following on 11/2/2007 5:44 PM:
> Does anyone know of a comprehensive list of geos, especially for the
> UK/France/Germany?
>
> Thanks in advance,
> Alan

[AlanLattimore]

Looks like an exciting and important ability to standardize addresses, esp for foreign commerce.  I'm not there yet.

I have a customer from the UK, shipping to:
Bryncethin
Bridgend, Bridgend, CF32 9UU
United Kingdom

I create a Party in OFBiz.  When I add the postal address, Brigend doesn't appear in the Geos table as a State/Province.

So far I've worked around problems like this by sticking "Bryncethin" in the "Address 3" field and
"Bridgend, Bridgend" in the "City" field, leaving the State/Province field empty, but my experience says this will fail royally as my business grows.

Other people with larger systems must have run into this issue.  What are you doing?

Best regards,
Alan

[BJ Freeman]

we are adding a address corrections and considering a a change to the
PostalAddress Entity that would cover such things.
you can add you Geo to the table through webtools.

https://localhost.com:8443/webtools/control/ViewRelations?entityName=PostalAddress
gives you the relationships of GEO to address.
you can click in Geo and add yours if you want.

also if you don't find you Geotype you can add it here
https://localhost.com:8443/webtools/control/FindGeneric?entityName=GeoType&find=true&VIEW_SIZE=50&VIEW_INDEX=0

AlanLattimore sent the following on 11/4/2007 9:06 AM:

> Looks like an exciting and important ability to standardize addresses, esp
> for foreign commerce.  I'm not there yet.
>
> I have a customer from the UK, shipping to:
> Bryncethin
> Bridgend, Bridgend, CF32 9UU
> United Kingdom
>
> I create a Party in OFBiz.  When I add the postal address, Brigend doesn't
> appear in the Geos table as a State/Province.
>
> So far I've worked around problems like this by sticking "Bryncethin" in the
> "Address 3" field and
> "Bridgend, Bridgend" in the "City" field, leaving the State/Province field
> empty, but my experience says this will fail royally as my business grows.
>
> Other people with larger systems must have run into this issue.  What are
> you doing?
>
> Best regards,
> Alan
>
>

... [show rest of quote]

[SkipDever]

BJ

For most, you need to take the .com out of your local host links.

Skip

-----Original Message-----
From: BJ Freeman [mailto:[hidden email]]
Sent: Sunday, November 04, 2007 9:30 AM
To: [hidden email]
Subject: Re: Geo: Missing States/Provinces and Shipping Addresses


we are adding a address corrections and considering a a change to the
PostalAddress Entity that would cover such things.
you can add you Geo to the table through webtools.

Doesnt work:
https://localhost.com:8443/webtools/control/ViewRelations?entityName=PostalA
ddress

Works:
https://localhost:8443/webtools/control/ViewRelations?entityName=PostalAddre
ss

gives you the relationships of GEO to address.
you can click in Geo and add yours if you want.

also if you don't find you Geotype you can add it here
https://localhost.com:8443/webtools/control/FindGeneric?entityName=GeoType&f
ind=true&VIEW_SIZE=50&VIEW_INDEX=0

AlanLattimore sent the following on 11/4/2007 9:06 AM:

> Looks like an exciting and important ability to standardize addresses, esp
> for foreign commerce.  I'm not there yet.
>
> I have a customer from the UK, shipping to:
> Bryncethin
> Bridgend, Bridgend, CF32 9UU
> United Kingdom
>
> I create a Party in OFBiz.  When I add the postal address, Brigend doesn't
> appear in the Geos table as a State/Province.
>
> So far I've worked around problems like this by sticking "Bryncethin" in

the

> "Address 3" field and
> "Bridgend, Bridgend" in the "City" field, leaving the State/Province field
> empty, but my experience says this will fail royally as my business grows.
>
> Other people with larger systems must have run into this issue.  What are
> you doing?
>
> Best regards,
> Alan
>
>

[BJ Freeman]

thanks skip missed that.


skip@theDevers sent the following on 11/4/2007 10:21 AM:

> BJ
>
> For most, you need to take the .com out of your local host links.
>
> Skip
>
> -----Original Message-----
> From: BJ Freeman [mailto:[hidden email]]
> Sent: Sunday, November 04, 2007 9:30 AM
> To: [hidden email]
> Subject: Re: Geo: Missing States/Provinces and Shipping Addresses
>
>
> we are adding a address corrections and considering a a change to the
> PostalAddress Entity that would cover such things.
> you can add you Geo to the table through webtools.
>
> Doesnt work:
> https://localhost.com:8443/webtools/control/ViewRelations?entityName=PostalA
> ddress
>
> Works:
> https://localhost:8443/webtools/control/ViewRelations?entityName=PostalAddre
> ss
>
> gives you the relationships of GEO to address.
> you can click in Geo and add yours if you want.
>
> also if you don't find you Geotype you can add it here
> https://localhost.com:8443/webtools/control/FindGeneric?entityName=GeoType&f
> ind=true&VIEW_SIZE=50&VIEW_INDEX=0
>
> AlanLattimore sent the following on 11/4/2007 9:06 AM:
>> Looks like an exciting and important ability to standardize addresses, esp
>> for foreign commerce.  I'm not there yet.
>>
>> I have a customer from the UK, shipping to:
>> Bryncethin
>> Bridgend, Bridgend, CF32 9UU
>> United Kingdom
>>
>> I create a Party in OFBiz.  When I add the postal address, Brigend doesn't
>> appear in the Geos table as a State/Province.
>>
>> So far I've worked around problems like this by sticking "Bryncethin" in
> the
>> "Address 3" field and
>> "Bridgend, Bridgend" in the "City" field, leaving the State/Province field
>> empty, but my experience says this will fail royally as my business grows.
>>
>> Other people with larger systems must have run into this issue.  What are
>> you doing?
>>
>> Best regards,
>> Alan
>>
>>
>
>
>
>

... [show rest of quote]

[Christian Geisert]

AlanLattimore schrieb:
> Does anyone know of a comprehensive list of geos, especially for the
> UK/France/Germany?

There are geos for France and UK in the framework/common/data directory
(GeoData_FR.xml and GeoData_UK.xml)

I'll submit a patch for the German federal states (Bundesländer) soon.

--
Christian