You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Adrian Crum <ad...@sandglass-software.com> on 2013/09/28 19:03:28 UTC
Re: Geo Location Discussion
The idea is to pick out the model features that are useful to fix the
current model - like replacing the CountryCapital entity with
GeoLocCharacteristic. The GeoLocCharacteristic entity could contain
Country Capital, State Capital, County Seat, etc.
Adrian Crum
Sandglass Software
www.sandglass-software.com
On 9/28/2013 1:07 AM, Jacques Le Roux wrote:
> Thanks for Sharing Adrian. Indeed this would be a lot of changes.
>
>>>> Years later there is so
>>>> much code written around those things, that we don't want to change
>>>> them. So, that is why I choose to replace them locally.
>
> I agree!
>
> Jacques
>
> Adrian Crum wrote:
>> http://www.sandglass-software.com/products/sandglass/documents/v1/LocationModels.pdf
>>
>> Adrian Crum
>> Sandglass Software
>> www.sandglass-software.com
>>
>> On 9/26/2013 12:50 PM, Jacques Le Roux wrote:
>>> Adrian Crum wrote:
>>>> I will prepare a PDF of the model I am using and share it.
>>>>
>>>> David makes a good point in that discussion: "this is why I'm a little
>>>> picky about who makes data model changes... they aren't too complex but
>>>> for anyone that hasn't done them a fair amount it is easy to miss
>>>> things, and once the entities are used becomes difficult to fix."
>>>>
>>>> There are a lot of things like that in OFBiz - despite our best
>>>> intentions, some things didn't come out right. Years later there is so
>>>> much code written around those things, that we don't want to change
>>>> them. So, that is why I choose to replace them locally.
>>>
>>> Yes I know. We discussed this part lengthly, there were a lot of good ideas and finally a consensus.
>>> But we can always improve and use the data migration page. We should not stay fossilised, despites some opininons, like Skip
>>> recently.
>>>
>>> Jacques
>>>
>>>> Adrian Crum
>>>> Sandglass Software
>>>> www.sandglass-software.com
>>>>
>>>> On 9/26/2013 7:01 AM, Jacques Le Roux wrote:
>>>>> I think it mostly started from there https://issues.apache.org/jira/browse/OFBIZ-1923
>>>>> and related thread/s in dev ML (look for geopoint)
>>>>>
>>>>> I'm open to discussion...
>>>>>
>>>>> Jacques
>>>>>
>>>>>
>>>>> Adrian Crum wrote:
>>>>>> I agree there is a lot of overlap in the data and in the geo data model.
>>>>>>
>>>>>> The Geo data model is a denormalized, disorganized mess. That was the
>>>>>> reason for my changes - so I can comment all of it out and replace it
>>>>>> with a better model on my local copy.
>>>>>>
>>>>>> Yes, it needs to be fixed - but there seems to be a problem finding
>>>>>> agreement on what the model should look like.
>>>>>>
>>>>>> Conceptually, geo data is location data - just like contact mechanisms.
>>>>>> From my perspective, the geo artifacts should be in the same component
>>>>>> as the contact mechanism artifacts. It doesn't belong in the framework.
>>>>>>
>>>>>> Adrian Crum
>>>>>> Sandglass Software
>>>>>> www.sandglass-software.com
>>>>>>
>>>>>> On 9/26/2013 12:33 AM, Pierre Smits wrote:
>>>>>>> It seems that there is a significant overlap between the data in
>>>>>>> CountryCodeData.xml and GeoData.xml.
>>>>>>>
>>>>>>> Would it not - in the spirit of slimdown - wise to merge the two sets (and
>>>>>>> possible others related to Country and GEO data)?
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> Pierre Smits
>>>>>>>
>>>>>>> *ORRTIZ.COM <http://www.orrtiz.com>*
>>>>>>> Services & Solutions for Cloud-
>>>>>>> Based Manufacturing, Professional
>>>>>>> Services and Retail & Trade
>>>>>>> http://www.orrtiz.com
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Sep 25, 2013 at 10:46 PM, <ad...@apache.org> wrote:
>>>>>>>
>>>>>>>> Author: adrianc
>>>>>>>> Date: Wed Sep 25 20:46:40 2013
>>>>>>>> New Revision: 1526296
>>>>>>>>
>>>>>>>> URL: http://svn.apache.org/r1526296
>>>>>>>> Log:
>>>>>>>> Move geo-related seed data to the GeoData.xml file. No functional change.
>>>>>>>>
>>>>>>>> Modified:
>>>>>>>> ofbiz/trunk/framework/common/data/CommonTypeData.xml
>>>>>>>> ofbiz/trunk/framework/common/data/GeoData.xml
>>>>>>>>
>>>>>>>> Modified: ofbiz/trunk/framework/common/data/CommonTypeData.xml
>>>>>>>> URL:
>>>>>>>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/common/data/CommonTypeData.xml?rev=1526296&r1=1526295&r2=1526296&view=diff
>>>>>>>>
>>>>>>>> ==============================================================================
>>>>>>>> --- ofbiz/trunk/framework/common/data/CommonTypeData.xml (original)
>>>>>>>> +++ ofbiz/trunk/framework/common/data/CommonTypeData.xml Wed Sep 25
>>>>>>>> 20:46:40 2013
>>>>>>>> @@ -64,26 +64,6 @@ under the License.
>>>>>>>> <Enumeration description="Lang: Spanish" enumCode="LANG_SP"
>>>>>>>> enumId="KWTR_LANG_SP" sequenceId="21" enumTypeId="KW_THES_REL"/>
>>>>>>>> <Enumeration description="Lang: French" enumCode="LANG_FR"
>>>>>>>> enumId="KWTR_LANG_FR" sequenceId="22" enumTypeId="KW_THES_REL"/>
>>>>>>>>
>>>>>>>> - <GeoType description="City" geoTypeId="CITY" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> - <GeoType description="Group" geoTypeId="GROUP" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> - <GeoType description="State" geoTypeId="STATE" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> - <GeoType description="Postal Code" geoTypeId="POSTAL_CODE"
>>>>>>>> hasTable="N" parentTypeId=""/>
>>>>>>>> - <GeoType description="Country" geoTypeId="COUNTRY" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> - <GeoType description="County" geoTypeId="COUNTY" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> - <GeoType description="County-City" geoTypeId="COUNTY_CITY"
>>>>>>>> hasTable="N" parentTypeId=""/>
>>>>>>>> - <GeoType description="Municipality" geoTypeId="MUNICIPALITY"
>>>>>>>> hasTable="N" parentTypeId=""/>
>>>>>>>> - <GeoType description="Province" geoTypeId="PROVINCE" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> - <GeoType description="Region" geoTypeId="REGION" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> - <GeoType description="Territory" geoTypeId="TERRITORY" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> - <GeoType description="Sales Territory" geoTypeId="SALES_TERRITORY"
>>>>>>>> hasTable="N" parentTypeId="TERRITORY"/>
>>>>>>>> - <GeoType description="Service Territory"
>>>>>>>> geoTypeId="SERVICE_TERRITORY" hasTable="N" parentTypeId="TERRITORY"/>
>>>>>>>> -
>>>>>>>> - <GeoAssocType geoAssocTypeId="GROUP_MEMBER" description="Geo Group
>>>>>>>> Member"/>
>>>>>>>> - <GeoAssocType geoAssocTypeId="REGIONS" description="For a region of a
>>>>>>>> larger Geo, i.e. states, counties, provinces..."/>
>>>>>>>> - <GeoAssocType geoAssocTypeId="COUNTY_CITY" description="City in a
>>>>>>>> county"/>
>>>>>>>> - <GeoAssocType geoAssocTypeId="COUNTY_SEAT"
>>>>>>>> description="Administrative Main City of a County"/>
>>>>>>>> - <GeoAssocType geoAssocTypeId="POSTAL_CODE" description="Postal code
>>>>>>>> associated to a GeoType"/>
>>>>>>>> -
>>>>>>>> <!-- sync status -->
>>>>>>>> <StatusType description="Synchronize" hasTable="N" parentTypeId=""
>>>>>>>> statusTypeId="SYNCHRONIZE_STATUS"/>
>>>>>>>> <StatusItem description="Not-Synchronized" sequenceId="01"
>>>>>>>> statusCode="NOT_SYNCHRONIZED" statusId="NOT_SYNCHRONIZED"
>>>>>>>> statusTypeId="SYNCHRONIZE_STATUS"/>
>>>>>>>>
>>>>>>>> Modified: ofbiz/trunk/framework/common/data/GeoData.xml
>>>>>>>> URL:
>>>>>>>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/common/data/GeoData.xml?rev=1526296&r1=1526295&r2=1526296&view=diff
>>>>>>>>
>>>>>>>> ==============================================================================
>>>>>>>> --- ofbiz/trunk/framework/common/data/GeoData.xml (original)
>>>>>>>> +++ ofbiz/trunk/framework/common/data/GeoData.xml Wed Sep 25 20:46:40 2013
>>>>>>>> @@ -19,6 +19,27 @@ under the License.
>>>>>>>> -->
>>>>>>>>
>>>>>>>> <entity-engine-xml>
>>>>>>>> +
>>>>>>>> + <GeoType description="City" geoTypeId="CITY" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> + <GeoType description="Group" geoTypeId="GROUP" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> + <GeoType description="State" geoTypeId="STATE" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> + <GeoType description="Postal Code" geoTypeId="POSTAL_CODE"
>>>>>>>> hasTable="N" parentTypeId=""/>
>>>>>>>> + <GeoType description="Country" geoTypeId="COUNTRY" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> + <GeoType description="County" geoTypeId="COUNTY" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> + <GeoType description="County-City" geoTypeId="COUNTY_CITY"
>>>>>>>> hasTable="N" parentTypeId=""/>
>>>>>>>> + <GeoType description="Municipality" geoTypeId="MUNICIPALITY"
>>>>>>>> hasTable="N" parentTypeId=""/>
>>>>>>>> + <GeoType description="Province" geoTypeId="PROVINCE" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> + <GeoType description="Region" geoTypeId="REGION" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> + <GeoType description="Territory" geoTypeId="TERRITORY" hasTable="N"
>>>>>>>> parentTypeId=""/>
>>>>>>>> + <GeoType description="Sales Territory" geoTypeId="SALES_TERRITORY"
>>>>>>>> hasTable="N" parentTypeId="TERRITORY"/>
>>>>>>>> + <GeoType description="Service Territory"
>>>>>>>> geoTypeId="SERVICE_TERRITORY" hasTable="N" parentTypeId="TERRITORY"/>
>>>>>>>> +
>>>>>>>> + <GeoAssocType geoAssocTypeId="GROUP_MEMBER" description="Geo Group
>>>>>>>> Member"/>
>>>>>>>> + <GeoAssocType geoAssocTypeId="REGIONS" description="For a region of a
>>>>>>>> larger Geo, i.e. states, counties, provinces..."/>
>>>>>>>> + <GeoAssocType geoAssocTypeId="COUNTY_CITY" description="City in a
>>>>>>>> county"/>
>>>>>>>> + <GeoAssocType geoAssocTypeId="COUNTY_SEAT"
>>>>>>>> description="Administrative Main City of a County"/>
>>>>>>>> + <GeoAssocType geoAssocTypeId="POSTAL_CODE" description="Postal code
>>>>>>>> associated to a GeoType"/>
>>>>>>>> +
>>>>>>>> <!--
>>>>>>>> Based on: ISO 3166 https://www.iso.org/obp/ui/#search
>>>>>>>> and
>>>>>>>> http://www.iso.org/iso/home/standards/country_codes/country_names_and_code_elements.htm
>>>>>>>> .
Re: Geo Location Discussion
Posted by Jacques Le Roux <ja...@les7arts.com>.
Then please open a Jira and we will continue there
Thanks
Jacques
Adrian Crum wrote:
> The idea is to pick out the model features that are useful to fix the
> current model - like replacing the CountryCapital entity with
> GeoLocCharacteristic. The GeoLocCharacteristic entity could contain
> Country Capital, State Capital, County Seat, etc.
>
> Adrian Crum
> Sandglass Software
> www.sandglass-software.com
>
> On 9/28/2013 1:07 AM, Jacques Le Roux wrote:
>> Thanks for Sharing Adrian. Indeed this would be a lot of changes.
>>
>>>>> Years later there is so
>>>>> much code written around those things, that we don't want to change
>>>>> them. So, that is why I choose to replace them locally.
>>
>> I agree!
>>
>> Jacques
>>
>> Adrian Crum wrote:
>>> http://www.sandglass-software.com/products/sandglass/documents/v1/LocationModels.pdf
>>>
>>> Adrian Crum
>>> Sandglass Software
>>> www.sandglass-software.com
>>>
>>> On 9/26/2013 12:50 PM, Jacques Le Roux wrote:
>>>> Adrian Crum wrote:
>>>>> I will prepare a PDF of the model I am using and share it.
>>>>>
>>>>> David makes a good point in that discussion: "this is why I'm a little
>>>>> picky about who makes data model changes... they aren't too complex but
>>>>> for anyone that hasn't done them a fair amount it is easy to miss
>>>>> things, and once the entities are used becomes difficult to fix."
>>>>>
>>>>> There are a lot of things like that in OFBiz - despite our best
>>>>> intentions, some things didn't come out right. Years later there is so
>>>>> much code written around those things, that we don't want to change
>>>>> them. So, that is why I choose to replace them locally.
>>>>
>>>> Yes I know. We discussed this part lengthly, there were a lot of good ideas and finally a consensus.
>>>> But we can always improve and use the data migration page. We should not stay fossilised, despites some opininons, like Skip
>>>> recently.
>>>>
>>>> Jacques
>>>>
>>>>> Adrian Crum
>>>>> Sandglass Software
>>>>> www.sandglass-software.com
>>>>>
>>>>> On 9/26/2013 7:01 AM, Jacques Le Roux wrote:
>>>>>> I think it mostly started from there https://issues.apache.org/jira/browse/OFBIZ-1923
>>>>>> and related thread/s in dev ML (look for geopoint)
>>>>>>
>>>>>> I'm open to discussion...
>>>>>>
>>>>>> Jacques
>>>>>>
>>>>>>
>>>>>> Adrian Crum wrote:
>>>>>>> I agree there is a lot of overlap in the data and in the geo data model.
>>>>>>>
>>>>>>> The Geo data model is a denormalized, disorganized mess. That was the
>>>>>>> reason for my changes - so I can comment all of it out and replace it
>>>>>>> with a better model on my local copy.
>>>>>>>
>>>>>>> Yes, it needs to be fixed - but there seems to be a problem finding
>>>>>>> agreement on what the model should look like.
>>>>>>>
>>>>>>> Conceptually, geo data is location data - just like contact mechanisms.
>>>>>>> From my perspective, the geo artifacts should be in the same component
>>>>>>> as the contact mechanism artifacts. It doesn't belong in the framework.
>>>>>>>
>>>>>>> Adrian Crum
>>>>>>> Sandglass Software
>>>>>>> www.sandglass-software.com
>>>>>>>
>>>>>>> On 9/26/2013 12:33 AM, Pierre Smits wrote:
>>>>>>>> It seems that there is a significant overlap between the data in
>>>>>>>> CountryCodeData.xml and GeoData.xml.
>>>>>>>>
>>>>>>>> Would it not - in the spirit of slimdown - wise to merge the two sets (and
>>>>>>>> possible others related to Country and GEO data)?
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>>
>>>>>>>> Pierre Smits
>>>>>>>>
>>>>>>>> *ORRTIZ.COM <http://www.orrtiz.com>*
>>>>>>>> Services & Solutions for Cloud-
>>>>>>>> Based Manufacturing, Professional
>>>>>>>> Services and Retail & Trade
>>>>>>>> http://www.orrtiz.com
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Sep 25, 2013 at 10:46 PM, <ad...@apache.org> wrote:
>>>>>>>>
>>>>>>>>> Author: adrianc
>>>>>>>>> Date: Wed Sep 25 20:46:40 2013
>>>>>>>>> New Revision: 1526296
>>>>>>>>>
>>>>>>>>> URL: http://svn.apache.org/r1526296
>>>>>>>>> Log:
>>>>>>>>> Move geo-related seed data to the GeoData.xml file. No functional change.
>>>>>>>>>
>>>>>>>>> Modified:
>>>>>>>>> ofbiz/trunk/framework/common/data/CommonTypeData.xml
>>>>>>>>> ofbiz/trunk/framework/common/data/GeoData.xml
>>>>>>>>>
>>>>>>>>> Modified: ofbiz/trunk/framework/common/data/CommonTypeData.xml
>>>>>>>>> URL:
>>>>>>>>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/common/data/CommonTypeData.xml?rev=1526296&r1=1526295&r2=1526296&view=diff
>>>>>>>>>
>>>>>>>>> ==============================================================================
>>>>>>>>> --- ofbiz/trunk/framework/common/data/CommonTypeData.xml (original)
>>>>>>>>> +++ ofbiz/trunk/framework/common/data/CommonTypeData.xml Wed Sep 25
>>>>>>>>> 20:46:40 2013
>>>>>>>>> @@ -64,26 +64,6 @@ under the License.
>>>>>>>>> <Enumeration description="Lang: Spanish" enumCode="LANG_SP"
>>>>>>>>> enumId="KWTR_LANG_SP" sequenceId="21" enumTypeId="KW_THES_REL"/>
>>>>>>>>> <Enumeration description="Lang: French" enumCode="LANG_FR"
>>>>>>>>> enumId="KWTR_LANG_FR" sequenceId="22" enumTypeId="KW_THES_REL"/>
>>>>>>>>>
>>>>>>>>> - <GeoType description="City" geoTypeId="CITY" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> - <GeoType description="Group" geoTypeId="GROUP" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> - <GeoType description="State" geoTypeId="STATE" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> - <GeoType description="Postal Code" geoTypeId="POSTAL_CODE"
>>>>>>>>> hasTable="N" parentTypeId=""/>
>>>>>>>>> - <GeoType description="Country" geoTypeId="COUNTRY" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> - <GeoType description="County" geoTypeId="COUNTY" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> - <GeoType description="County-City" geoTypeId="COUNTY_CITY"
>>>>>>>>> hasTable="N" parentTypeId=""/>
>>>>>>>>> - <GeoType description="Municipality" geoTypeId="MUNICIPALITY"
>>>>>>>>> hasTable="N" parentTypeId=""/>
>>>>>>>>> - <GeoType description="Province" geoTypeId="PROVINCE" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> - <GeoType description="Region" geoTypeId="REGION" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> - <GeoType description="Territory" geoTypeId="TERRITORY" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> - <GeoType description="Sales Territory" geoTypeId="SALES_TERRITORY"
>>>>>>>>> hasTable="N" parentTypeId="TERRITORY"/>
>>>>>>>>> - <GeoType description="Service Territory"
>>>>>>>>> geoTypeId="SERVICE_TERRITORY" hasTable="N" parentTypeId="TERRITORY"/>
>>>>>>>>> -
>>>>>>>>> - <GeoAssocType geoAssocTypeId="GROUP_MEMBER" description="Geo Group
>>>>>>>>> Member"/>
>>>>>>>>> - <GeoAssocType geoAssocTypeId="REGIONS" description="For a region of a
>>>>>>>>> larger Geo, i.e. states, counties, provinces..."/>
>>>>>>>>> - <GeoAssocType geoAssocTypeId="COUNTY_CITY" description="City in a
>>>>>>>>> county"/>
>>>>>>>>> - <GeoAssocType geoAssocTypeId="COUNTY_SEAT"
>>>>>>>>> description="Administrative Main City of a County"/>
>>>>>>>>> - <GeoAssocType geoAssocTypeId="POSTAL_CODE" description="Postal code
>>>>>>>>> associated to a GeoType"/>
>>>>>>>>> -
>>>>>>>>> <!-- sync status -->
>>>>>>>>> <StatusType description="Synchronize" hasTable="N" parentTypeId=""
>>>>>>>>> statusTypeId="SYNCHRONIZE_STATUS"/>
>>>>>>>>> <StatusItem description="Not-Synchronized" sequenceId="01"
>>>>>>>>> statusCode="NOT_SYNCHRONIZED" statusId="NOT_SYNCHRONIZED"
>>>>>>>>> statusTypeId="SYNCHRONIZE_STATUS"/>
>>>>>>>>>
>>>>>>>>> Modified: ofbiz/trunk/framework/common/data/GeoData.xml
>>>>>>>>> URL:
>>>>>>>>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/common/data/GeoData.xml?rev=1526296&r1=1526295&r2=1526296&view=diff
>>>>>>>>>
>>>>>>>>> ==============================================================================
>>>>>>>>> --- ofbiz/trunk/framework/common/data/GeoData.xml (original)
>>>>>>>>> +++ ofbiz/trunk/framework/common/data/GeoData.xml Wed Sep 25 20:46:40 2013
>>>>>>>>> @@ -19,6 +19,27 @@ under the License.
>>>>>>>>> -->
>>>>>>>>>
>>>>>>>>> <entity-engine-xml>
>>>>>>>>> +
>>>>>>>>> + <GeoType description="City" geoTypeId="CITY" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> + <GeoType description="Group" geoTypeId="GROUP" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> + <GeoType description="State" geoTypeId="STATE" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> + <GeoType description="Postal Code" geoTypeId="POSTAL_CODE"
>>>>>>>>> hasTable="N" parentTypeId=""/>
>>>>>>>>> + <GeoType description="Country" geoTypeId="COUNTRY" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> + <GeoType description="County" geoTypeId="COUNTY" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> + <GeoType description="County-City" geoTypeId="COUNTY_CITY"
>>>>>>>>> hasTable="N" parentTypeId=""/>
>>>>>>>>> + <GeoType description="Municipality" geoTypeId="MUNICIPALITY"
>>>>>>>>> hasTable="N" parentTypeId=""/>
>>>>>>>>> + <GeoType description="Province" geoTypeId="PROVINCE" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> + <GeoType description="Region" geoTypeId="REGION" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> + <GeoType description="Territory" geoTypeId="TERRITORY" hasTable="N"
>>>>>>>>> parentTypeId=""/>
>>>>>>>>> + <GeoType description="Sales Territory" geoTypeId="SALES_TERRITORY"
>>>>>>>>> hasTable="N" parentTypeId="TERRITORY"/>
>>>>>>>>> + <GeoType description="Service Territory"
>>>>>>>>> geoTypeId="SERVICE_TERRITORY" hasTable="N" parentTypeId="TERRITORY"/>
>>>>>>>>> +
>>>>>>>>> + <GeoAssocType geoAssocTypeId="GROUP_MEMBER" description="Geo Group
>>>>>>>>> Member"/>
>>>>>>>>> + <GeoAssocType geoAssocTypeId="REGIONS" description="For a region of a
>>>>>>>>> larger Geo, i.e. states, counties, provinces..."/>
>>>>>>>>> + <GeoAssocType geoAssocTypeId="COUNTY_CITY" description="City in a
>>>>>>>>> county"/>
>>>>>>>>> + <GeoAssocType geoAssocTypeId="COUNTY_SEAT"
>>>>>>>>> description="Administrative Main City of a County"/>
>>>>>>>>> + <GeoAssocType geoAssocTypeId="POSTAL_CODE" description="Postal code
>>>>>>>>> associated to a GeoType"/>
>>>>>>>>> +
>>>>>>>>> <!--
>>>>>>>>> Based on: ISO 3166 https://www.iso.org/obp/ui/#search
>>>>>>>>> and
>>>>>>>>> http://www.iso.org/iso/home/standards/country_codes/country_names_and_code_elements.htm
>>>>>>>>> .