Osclass Support Forums
General osclass questions => General discussion => Topic started by: dsf on January 08, 2023, 10:18:56 AM
-
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 :D
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 (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 (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