| Author |
Message |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 23/02/2012 06:18:51
|
subpardaemon
Joined: 09/02/2012 15:12:00
Messages: 13
Offline
|
hi marc,
after a lot of querying around, i've managed to find a definitive and corroborated ADM1/ADM2 structure for serbia.
primary source: http://hu.wikipedia.org/wiki/Szerbia_k%C3%B6rzetei
corroborated by my serbian friends.
i'm attaching a tab-separated CSV that holds all the records to modify, delete and add. (there is a duplicate ADM2 level item, and another that needs to be added.)
before updating, please demote all current ADM2 items either to ADM3 or ADMD -- they are NOT ADM2 level items. the ADM1 division is correct; and the attached file holds the correct ADM2 divisions. there is another subdivision on ADM3 level but i couldn't get a sufficient list for that.
(basically, serbia has the voivodina and central serbia division on ADM1, and then there is grad beograd (the capital and surrounding area), and all the rest are "okrugs" (counties) on the ADM2 level. the "opstinas" are subdivisions under the okrugs and grad beograd, presumably they would be ADM3.)
also, there's a column for the hungarian (language code: hu) names of the ADM2 divisions, please insert them in the correct db.
cheers!
| Description |
the adm2 divisions |
Download
|
| Filesize |
2 Kbytes
|
| Downloaded: |
10356 time(s) |
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 28/02/2012 07:27:52
|
subpardaemon
Joined: 09/02/2012 15:12:00
Messages: 13
Offline
|
any ETA when Grad Beograd will be inserted as an ADM2 division?
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 28/02/2012 15:08:16
|
marc
Joined: 08/12/2005 07:39:47
Messages: 4501
Offline
|
It is here:
http://www.geonames.org/8199669/belgrade.html
The admin2 codes are official codes?
Best Regards
Marc
|
 |
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 01/03/2012 12:37:57
|
subpardaemon
Joined: 09/02/2012 15:12:00
Messages: 13
Offline
|
no, they're not, i couldn't find any official codes for ADM2 divisions (and i've tried), so far they seem to be nonexistent. in wikipedia (http://en.wikipedia.org/wiki/Municipalities_and_cities_of_Serbia , see lowermost table) they are given numbers, but that's only because of the cyrillic alphabet -- they are just ordered. but then the city of belgrade doesn't have a numeric code, instead it has a special status. so i guess either numbers like that (and maybe 99 for the city of belgrade as an ADM2 div), or the abbrevs i came up would do just fine.
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 02/03/2012 12:51:36
|
lillolollo
Joined: 10/01/2010 23:12:00
Messages: 120
Offline
|
Serbia have official codes
http://webrzs.stat.gov.rs/WebSite/repository/documents/00/00/56/87/RG10_013_eng.pdf
Bye
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 02/03/2012 12:51:36
|
lillolollo
Joined: 10/01/2010 23:12:00
Messages: 120
Offline
|
Complete list
http://webrzs.stat.gov.rs/WebSite/repository/documents/00/00/44/11/Sistematski_spisak_naselja.pdf
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 03/03/2012 07:47:13
|
subpardaemon
Joined: 09/02/2012 15:12:00
Messages: 13
Offline
|
could you then collect the ADM2 codes for the okrugs? the complete list is huge and is in cyrillic (i can read cyrillic but not that fast), the csv is there for the download and modify and upload. i'd really like to start using serbia, but until the official ADM2 codes are used, there's little point in that. (it's only about twentysomething okrugs and one belgrade, shouldn't take too long.)
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 06/03/2012 06:59:32
|
lillolollo
Joined: 10/01/2010 23:12:00
Messages: 120
Offline
|
I'm sorry but I do not understand the Cyrillic
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 12/03/2012 06:54:19
|
subpardaemon
Joined: 09/02/2012 15:12:00
Messages: 13
Offline
|
marc,
here's the definitive list of serbia's ADM2 divisions with the codes taken from lillolollo's link (the cyrillic long list), so except for grad beograd (which does not have an ADM2 level code yet it is an ADM2 level division), all codes are official. i nominate in absentia of a real ADM2 code for grad beograd the code GB.
mind you, i really had to dig deep to be able to reboot my ability to read cyrillic (esp. the serbian version). but it worked in the end.
| Description |
final corrections; features the new ADM2 entity geocode for belgrade (grad beograd) and the official okrug codes |
Download
|
| Filesize |
2 Kbytes
|
| Downloaded: |
10378 time(s) |
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 17/03/2012 07:32:13
|
lillolollo
Joined: 10/01/2010 23:12:00
Messages: 120
Offline
|
Beograd have code 0
I have found the official list and tree okrugs->municipalities whit code in xls format
http://webrzs.stat.gov.rs/WebSite/userFiles/file/Opsti%20podaci%20u%20Republici%20Srbiji/Latinica/Opstine%20Gradovi%20tekuce%20stanje%202011.xls
Bye
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 17/03/2012 07:32:13
|
lillolollo
Joined: 10/01/2010 23:12:00
Messages: 120
Offline
|
ops wrong link
http://webrzs.stat.gov.rs/WebSite/userFiles/file/Opsti%20podaci%20u%20Republici%20Srbiji/Latinica/Opstine%20Gradovi%20tekuce%20stanje%202011.xls
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 18/03/2012 06:19:12
|
subpardaemon
Joined: 09/02/2012 15:12:00
Messages: 13
Offline
|
yes, but code 0 in geonames is reserved for unknown/unassigned, so it would be a very bad idea to use 0 for grad beograd.
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 27/03/2012 07:00:04
|
lillolollo
Joined: 10/01/2010 23:12:00
Messages: 120
Offline
|
marc is on holiday
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 27/03/2012 07:39:45
|
marc
Joined: 08/12/2005 07:39:47
Messages: 4501
Offline
|
No exactly on holiday, but working abroad in Brindisi and of course it needs a lot of time to explore the fantastic region: Alberobello, Matera, Castel del Monte, Gargano, Trani, Bari, Gallipoli, and many many more
Next week I will be back
Best Regards
Marc
|
 |
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 29/03/2012 06:12:50
|
lillolollo
Joined: 10/01/2010 23:12:00
Messages: 120
Offline
|
yes Puglia and Basilicata are beautiful and cuisine is delicious
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 12/04/2012 06:59:38
|
lillolollo
Joined: 10/01/2010 23:12:00
Messages: 120
Offline
|
marc can you insert the codes please?
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 12/04/2012 21:23:13
|
marc
Joined: 08/12/2005 07:39:47
Messages: 4501
Offline
|
I have inserted the adm2 codes and the adm3 codes where I have found them with a simple name comparison. a lot of adm3 are still missing.
Marc
|
 |
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 13/04/2012 06:47:41
|
lillolollo
Joined: 10/01/2010 23:12:00
Messages: 120
Offline
|
Many admin divisions have the old code I think
Like Opština Bač
|
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 13/04/2012 07:20:24
|
marc
Joined: 08/12/2005 07:39:47
Messages: 4501
Offline
|
I found 54 more to update.
Marc
|
 |
|
|
 |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 20/04/2012 07:21:43
|
lillolollo
Joined: 10/01/2010 23:12:00
Messages: 120
Offline
|
marc I'have cecked all Serbia entryes
here can found documents for update in the future
http://webrzs.stat.gov.rs/WebSite/Public/PageView.aspx?pKey=411
If you change the laguage in cirillyc you can found ciryllic place name
Bye
|
|
|
 |
|
|