Hi,

The current geo for United Kingdom is not what it should be. There are 4 regions and then Cities. But those 4 are not Regions but kind of Countries.

So they should be 4 different countries, and then their regions/subdivisions.

The way it is now, for Example if you select England there is a huge ammount of mixed cities.

Please, take this under serious considetion as it is wrong.

Thank you

See some example from UK BIG classified ads sites:

Yes, UK does not fit well into Osclass structure and alternative is to create 4 countries instead of just UK

If i can help on this, let me know.

From my extended research the best way/structure is the one from

https://www.gumtree.com/

the best (for me) uk classified sites. Gumtree has

United Kingdom:

    England 31,674
    Isle Of Man 3
    Jersey 2
    Northern Ireland 201
    Scotland 1,271
    Wales 239


Under England:

     
    Bedfordshire 347
    Berkshire 897
    Bristol 380
    Buckinghamshire 644
    Cambridgeshire 694
    Cheshire 739
    Cornwall 147
    County Durham 39
    Cumbria 181
    Derbyshire 381
    Devon 488
    Dorset 487
    East Sussex 96
    East Yorkshire 19
    Essex 863
    Gloucestershire 522
    Hampshire 1,223
    Herefordshire 12
    Hertfordshire 948
    Isle of Wight 16
    Kent 982
    Lancashire 1,098
    Leicestershire 551
    Lincolnshire 332
    London 9,160
    Manchester 1,012
    Merseyside 591
    Norfolk 370
    North Yorkshire 117
    Northamptonshire 421
    Northumberland 65
    Nottinghamshire 443
    Oxfordshire 655
    Rutland 14
    Shropshire 212
    Somerset 921
    South Yorkshire 107
    Staffordshire 430
    Suffolk 356
    Surrey 1,102
    Tyne and Wear 414
    Warwickshire 339
    West Midlands 1,474
    West Sussex 190
    West Yorkshire 408
    Wiltshire 426
    Worcestershire 326


etc etc etc

Maybe i got the reply wrong. Do you mean to make this on our own or you plan to do it at some point?

You got it wrong 
Will check next week what can be done...

https://forums.osclasspoint.com/osclass/is-it-possible-to-add-living-things-to-country-region-and-city/msg35286/#msg35286

Same problem that I was talking about

https://forums.osclasspoint.com/osclass/is-it-possible-to-add-living-things-to-country-region-and-city/msg35286/#msg35286

Same problem that I was talking about

Hi,

Let's wait to see if they can come up with a better structure.

Well, first we need new country details in following formats (with unique country code that does not interfere with any other country:
#ISO ISO3 ISO-Numeric fips Country Capital Area(in sq km) Population Continent tld CurrencyCode CurrencyName Phone Postal Code Format Postal Code Regex Languages geonameid neighbours EquivalentFipsCode
AD AND 020 AN Andorra Andorra la Vella 468 77006 EU .ad EUR Euro 376 AD### ^(?:AD)*(\d{3})$ ca 3041565 ES,FR
AE ARE 784 AE United Arab Emirates Abu Dhabi 82880 9630959 AS .ae AED Dirham 971 ar-AE,fa,en,hi,ur 290557 SA,OM
AF AFG 004 AF Afghanistan Kabul 647500 37172386 AS .af AFN Afghani 93 fa-AF,ps,uz-AF,tk 1149361 TM,CN,IR,TJ,PK,UZ
AG ATG 028 AC Antigua and Barbuda St. John's 443 96286 NA .ag XCD Dollar +1-268 en-AG 3576396
AI AIA 660 AV Anguilla The Valley 102 13254 NA .ai XCD Dollar +1-264 en-AI 3573511
AL ALB 008 AL Albania Tirana 28748 2866376 EU .al ALL Lek 355 #### ^(\d{4})$ sq,el 783754 MK,GR,ME,RS,XK
AM ARM 051 AM Armenia Yerevan 29800 2951776 AS .am AMD Dram 374 ###### ^(\d{6})$ hy 174982 GE,IR,AZ,TR
AO AGO 024 AO Angola Luanda 1246700 30809762 AF .ao AOA Kwanza 244 pt-AO 3351879 CD,NA,ZM,CG

Then for each country file in following format (with name {country_code}.txt):
5653 Phrakhtaes Phrakhtaes 34.56717 33.02724 L LCTY GB 05 0 32 Europe/London 2014-09-30
5654 Glossa tou Shyllou Glossa tou Shyllou 34.57083 33.02917 L LCTY GB 05 0 18 Europe/London 2014-10-01
5655 Arkosyia Arkosyia 34.57917 33.025 L LCTY GB 05 0 5 Europe/London 2014-10-01
5656 Ammoskatharaes Ammoskatharaes 34.56795 33.01775 L LCTY GB 05 0 51 Europe/London 2014-10-01
5657 Skaloua Tris Kazoulies Skaloua Tris Kazoulies 34.57083 33.01667 L LCTY GB 05 0 42 Europe/London 2014-10-01
5659 Shilliostasha Shilliostasha 34.575 33.02083 L LCTY GB 05 0 21 Europe/London 2014-10-01
5660 Ammos tou Dhiplarkakou Ammos tou Dhiplarkakou 34.58333 33.01667 L LCTY GB 05 0 9 Europe/London 2014-10-01
5662 Langouna tou Tarratsou Langouna tou Tarratsou 34.58795 33.00711 L LCTY GB 05 0 12 Europe/London 2014-10-01
5663 Vounaroudhkia tou Vromonerou Vounaroudhkia tou Vromonerou 34.59167 33.00833 L LCTY GB 05 0 6 Europe/London 2014-10-01
5664 Vromonero Kannoudhkia Vromonero Kannoudhkia 34.59583 33.00417 L LCTY GB 05 0 2 Europe/London 2014-10-01
5665 Limnia Limnia 34.60417 33.00417 L LCTY GB 05 0 1 Europe/London 2014-10-01
5666 Aplostres Aplostres 34.60833 33.00417 L LCTY GB 05 0 0 Europe/London 2014-10-01
These are details about columns:
The main 'geoname' table has the following fields :
---------------------------------------------------
geonameid         : integer id of record in geonames database
name              : name of geographical point (utf8) varchar(200)
asciiname         : name of geographical point in plain ascii characters, varchar(200)
alternatenames    : alternatenames, comma separated, ascii names automatically transliterated, convenience attribute from alternatename table, varchar(10000)
latitude          : latitude in decimal degrees (wgs84)
longitude         : longitude in decimal degrees (wgs84)
feature class     : see http://www.geonames.org/export/codes.html, char(1)
feature code      : see http://www.geonames.org/export/codes.html, varchar(10)
country code      : ISO-3166 2-letter country code, 2 characters
cc2               : alternate country codes, comma separated, ISO-3166 2-letter country code, 200 characters
admin1 code       : fipscode (subject to change to iso code), see exceptions below, see file admin1Codes.txt for display names of this code; varchar(20)
admin2 code       : code for the second administrative division, a county in the US, see file admin2Codes.txt; varchar(80)
admin3 code       : code for third level administrative division, varchar(20)
admin4 code       : code for fourth level administrative division, varchar(20)
population        : bigint (8 byte int)
elevation         : in meters, integer
dem               : digital elevation model, srtm3 or gtopo30, average elevation of 3''x3'' (ca 90mx90m) or 30''x30'' (ca 900mx900m) area in meters, integer. srtm processed by cgiar/ciat.
timezone          : the iana timezone id (see file timeZone.txt) varchar(40)
modification date : date of last modification in yyyy-MM-dd format
Usually, we need to know admin codes to be included as region & city (may differ from country to country).
Problem could be that file with data does not seem to have identifier if it's england, scotland, ...

Files are from here:
https://www.geonames.org/countries/

Since this can take a very long time, how can we safely make ourselfs a 2-3 (or whatever number is needed) countries reflecting the whole UK structure?

Is there a problem to do that manually (within the dashboard/locations)? Not a big deal, takes 2-3 hours tops. Will that create any issues?

Thanks

No. You can do that manually as well

It would be so nice if we could somehow export a Country, so any user can import it (safely) if there is a need.

It could be an un-official Country geo, since several countries available at the geo repo, are not correct. They may be correct in a way but NOT for a classifieds site.

Its more-less export from country, region and city table.
Nothing else.

Its more-less export from country, region and city table.
Nothing else.

Sure but what happens if the "numbers" of the counties and cities already exist for some other country?

You can offset all numbers by 1000000