Advertisement:

Author Topic: Osclass GEO Databases  (Read 892 times)

Aficionado

  • Guest
Osclass GEO Databases
« on: December 15, 2017, 04:11:37 pm »

It seems that an other TOTALLY neglected area is Osclass Country database (geo).

I have several manually created countries and other countries that i UPDATED or Changed myself. I'm pretty sure others also have done that.

So, i would like to SHARE those and also maybe GET some i don't have.

Currently there is no easy way to do that. You can't even EASILY export ONE country and IMPORT it to an other site (move it).

Last time i wanted to do what with a NEW country i have created myself the db, i couldn't import it due to some #numbers conflict with an existing country. I did what with a LOT of help from ... yes ... you guessed it right .... Teseo.

So, how hard it could be for a PLUGIN that EXPORTS a country with a new ID number (or something like that, i don't know Osclass internals) ? So everybody can import it ?

I hope i get some interest in that,

Thanks !


Aficionado

  • Guest
Re: Osclass GEO Databases
« Reply #1 on: December 15, 2017, 04:23:50 pm »

teseo

  • Hero Member
  • *****
  • Posts: 6169
Re: Osclass GEO Databases
« Reply #2 on: December 18, 2017, 01:24:56 pm »
Hi,

Problem is that there must be some kind of "central authority" (like the official Osclass Geodata database) controlling all of this, to ensure no location ID is duplicated. Sharing custom-built country structures might provoke problems very difficult to solve on another installation.

Regards

Aficionado

  • Guest
Re: Osclass GEO Databases
« Reply #3 on: December 18, 2017, 01:28:55 pm »
Hi,

Problem is that there must be some kind of "central authority" (like the official Osclass Geodata database) controlling all of this, to ensure no location ID is duplicated. Sharing custom-built country structures might provoke problems very difficult to solve on another installation.

Regards


Teseo, i do know and fully understand that "Location ID". But could that be user CONFIGURABLE ? No ? I mean some unique number that doesn't conflict with an already existed installation. During EXPORT that number can be selected.

Am i correct ? Or i'm writing nosense ?
 ::)

Also Osclass team doesn't really care much about GEO, so ....

Aficionado

  • Guest
Re: Osclass GEO Databases
« Reply #4 on: December 18, 2017, 01:32:27 pm »
Also the same problem with Unique country ID, exist for their own OSclass geo database. For example they have a country already in their GEO db. But someone creates a new better and corrected db for the same country.

How Osclass geo provide that second db to others ? He can't have two,am i right ?


teseo

  • Hero Member
  • *****
  • Posts: 6169
Re: Osclass GEO Databases
« Reply #5 on: December 18, 2017, 02:05:49 pm »
Also the same problem with Unique country ID, exist for their own OSclass geo database. For example they have a country already in their GEO db. But someone creates a new better and corrected db for the same country.

How Osclass geo provide that second db to others ? He can't have two,am i right ?

Ok, let's forget for a moment the other big problem (possible ID's duplicated in two custom country database set) and concentrate in replacing an existent set with another.

Location ID's are stored in a lot of database tables (ads, users, stats, etc), so if you're not installing Osclass from scratch, you'd need to set a complicated mechanism to convert everything to the new ID's, a formidable task to build on the developer side, and a highly demanding process on the webmaster side.

As you can see, it's not a case contemplated anywhere, it's assumed the webmasters will pick countries and they'll need to stick to it. If you add new locations to a given country, the next free ID will be used (so, these would be unique for the site, no guarantee this same ID won't pop-up later when you're adding another country) :(

Aficionado

  • Guest
Re: Osclass GEO Databases
« Reply #6 on: December 18, 2017, 02:12:39 pm »

I understand but we DO know what Country IDs are used in an existing Osclass ?

So, during the EXPORT of a country, can't we select a unique number ?

Anyway, i trust you know better that it can't be done easily. Pitty. Because the current Osclass geo is not good at all and i hoped things could be improved.


teseo

  • Hero Member
  • *****
  • Posts: 6169
Re: Osclass GEO Databases
« Reply #7 on: December 18, 2017, 02:44:54 pm »
So, during the EXPORT of a country, can't we select a unique number ?

A unique number for each and everyone of the [possibly] thousands of locations inside a country...

Let's think that we choose ID's starting on 1000000 (assuming the current official database is not using any of them -probably not, but you need to make sure of that downloading and reviewing all of the available ones -at first glance looks like regions have ID's over 780000 and cities below that number).

Let's assume we succeeded and no conflict with existing official data sets. Even so, what guarantee we have that another user won't choose to export and share another country with same ID's starting with 1000000? If not in the official data sets, we have no way to know that, and a normal user might find himself in a very big mess.

Bottom line, this need a strict central coordination.

Regards

Aficionado

  • Guest
Re: Osclass GEO Databases
« Reply #8 on: December 18, 2017, 02:56:28 pm »
So it is not only a COUNTRY unique number but also for each regions and cities.

Aficionado

  • Guest
Re: Osclass GEO Databases
« Reply #9 on: December 18, 2017, 02:57:35 pm »

Bottom line, this need a strict central coordination.


So we are doomed.

dev101

  • Osclass Hero
  • Hero Member
  • *
  • Posts: 2155
  • osclass.work
Re: Osclass GEO Databases
« Reply #10 on: December 21, 2017, 03:16:24 pm »
I vaguely remember this was asked by you before? I disagree about geo section being neglected, on the contrary, many new countries were added "lately" (by "lately" I mean in the past year or so), and as teseo spotlessly explained above, it is managed by Osclass Team. They use publicly available (and verified) sources of places, because they cannot really check them manually by themselves, and as I once in the beginning asked, the ID scheme is also unknown to me (and still is, but now I can make an educated guess they either use custom or some 3rd party scheme).

You can send them via email your files if you like, but it is up to them how/if they will be used & updated.

Regards

dev101

  • Osclass Hero
  • Hero Member
  • *
  • Posts: 2155
  • osclass.work
Re: Osclass GEO Databases
« Reply #11 on: December 21, 2017, 03:20:04 pm »
error :)

Aficionado

  • Guest
Re: Osclass GEO Databases
« Reply #12 on: December 21, 2017, 03:33:33 pm »
I vaguely remember this was asked by you before? I disagree about geo section being neglected, on the contrary, many new countries were added "lately" (by "lately" I mean in the past year or so), and as teseo spotlessly explained above, it is managed by Osclass Team. They use publicly available (and verified) sources of places, because they cannot really check them manually by themselves, and as I once in the beginning asked, the ID scheme is also unknown to me (and still is, but now I can make an educated guess they either use custom or some 3rd party scheme).

You can send them via email your files if you like, but it is up to them how/if they will be used & updated.

Regards


I'm not saying there are countries missing. I said it is neglected. Not updated.

Yes, i have asked before the same thing (more-or-less) and i got no usefull replies. But in the meantime (from my old request) others also asked the very same question about not updated countries and how this could be improved. They also got no replies.

One good example was MY country that was ... what can i say ... absurd. It took me a week to create my country and then i send them to Osclass (i have no idea if they put it online or not).

An other example was France and somne other countries that had hundreds of dups. Not sure if they fixed it, i told Osclass team that at some point.

I'm pretty sure people would like to share a better version of their own country. So maybe several versions of a country could exist and the user can check them and select. For example France geo provided by userAAA, June 2017.

All in all, all i see is the usual people reply to me (you, teseo and a 1-2 others), but none of us can make this better without Osclass team.

« Last Edit: December 21, 2017, 03:35:07 pm by Aficionado »

xop32

  • Jr. Member
  • **
  • Posts: 77
  • trend following
Re: Osclass GEO Databases
« Reply #13 on: December 27, 2017, 04:00:14 am »
a site I am currently working on is a uk based site, so I need good regions and citys for the uk for my osclass project

the default import from oclass for the uk  regions/ citys is a mess really, it looks like its been set up from 10 year old data pulled of Wikipedia or something

for example:

Isle de wight ?? - I am not French ( isle of wight )
Tyne y Wear ?? French again ( tyne and wear )
Great London ?? - greater London
Great Manchester - greater Manchester


not to mention missing regions

the united kingdom in osclass is only made up of England!!

no regions/ciys for wales
no regions/citys for Scotland
no region/citys for northern Ireland


like mentioned above I am doing my own complete import of regions





Aficionado

  • Guest
Re: Osclass GEO Databases
« Reply #14 on: December 27, 2017, 04:49:40 pm »
a site I am currently working on is a uk based site, so I need good regions and citys for the uk for my osclass project

the default import from oclass for the uk  regions/ citys is a mess really, it looks like its been set up from 10 year old data pulled of Wikipedia or something


like mentioned above I am doing my own complete import of regions

I have tried so many times to find a way to improve all that, along with Osclass and their community, but failed.

I know what you mean, i had to rebuild all UK myself (i copied gumtree.com data for regions etc etc).

Apart from 3-4 people here, the rest is not much of community i'm afraid.