Regions Level-3

[GoogleCodeExporter]

There are 55 regions in the nuts_codes table that match code like 'RO%'.
There are 55 regions in the nuts_layers table that match code like 'RO%'.
Joining the tables using code produces 55 results, so the correspondence is 
correct. 

However only 8 regions are displayed in the dropdown box. 
Most important problem: none of the counties are in it.
Pressing zone from coordinates yields empty results. 

See already published caches. They should all match Argeş county, that is 
region RO311. None do so. 

Original issue reported on code.google.com by andrixnet on 9 Apr 2014 at 7:56

[GoogleCodeExporter]

regions displayed must follow European Union level NUTS-2, and
Romania (following
http://en.wikipedia.org/wiki/Administrative_divisions_of_RomaniaRomania)
has 8 regions NUTS-2, so actually it works as designed.

2014-04-09 9:56 GMT+02:00 <opencaching-pl@googlecode.com>:

Original comment by wloczynutka on 9 Apr 2014 at 9:39

[GoogleCodeExporter]

can it be made to work at NUTS_3 level? 
See here: http://en.wikipedia.org/wiki/Counties_of_Romania

For romanians, the NUTS_2 regions have no meaning and users will have much 
problem relating to them, it being a mandatory field for a cache. 

And there is already political controversy in our government on redefining 
administrative organization of the country. 

Original comment by andrixnet on 9 Apr 2014 at 9:47

[GoogleCodeExporter]

It can be made, but it must be done only for selected countries (because
regions of PL, B, L and NL works perfect witch nuts_2 layer)
Make it configurable seems very complex and time consuming work, at the
moment We have not spare programmers to perform that complex code change.

So I suggest close this issue as unreal to do.

2014-04-09 11:47 GMT+02:00 <opencaching-pl@googlecode.com>:

Original comment by wloczynutka on 9 Apr 2014 at 10:21

[GoogleCodeExporter]

I've changed priority to low, type to enhancement. 
It is a must for Romania, for the reasons explained above. 

I understand the resources required and I and a friend will also look into it 
some time later. 
Thank you. 

Original comment by andrixnet on 9 Apr 2014 at 3:43

• Added labels: Priority-Low, Type-Enhancement, Usability
• Removed labels: Priority-Medium, Type-Defect

[GoogleCodeExporter]

When you start work on it, to keep integrity I suggest keep current regions 
level-1 (country) and level-2 (districts) and add third selector for level-3 
regions.

as I said this is complex task.

requirments: 
================================================================================
==
- changes must apply on every page witch region selecting: especially newcache, 
editcache, search pages and all cache display pages (viewcache, main page, 
newest cache page, myneighbourd pages and so on.)
- level-3 should be active only for countries specified in config.
- level-3 have to be loaded on the fly (without page reload, by ajax 
technology) on events:
a) region-2 is selected by user 
b) coordinates are loaded from gpx (newcache)  
c) on user entered coordinates from keyboard.
on event 2 and 3 autaomatic select proper region from given coordinates.(using 
the same script as for level-2, maybe need add few lines of code) 

Original comment by wloczynutka on 9 Apr 2014 at 7:35

• Changed title: Regions Level-3

[GoogleCodeExporter]

Understood. It is indeed a complex task. 
I will set up a copy of my node as development where I will perform the more 
complicated programming. 

Thank you for the details, they will be most helpful. 

Original comment by andrixnet on 9 Apr 2014 at 8:44

[GoogleCodeExporter]

Question: isn't region supposed to be filled automatically from coordinates: 

This is what I get for any cache:

 Region from coordinates:
N 44° 52.096'  E 24° 49.158'
Country

Region found by Opencaching Romania

Region found by Google Maps

=====================
no results when pressing "region from coordinates"

Original comment by andrixnet on 10 Apr 2014 at 8:47

[GoogleCodeExporter]

this button only opens the window.
Automatic filling country/region is done other way (via ajax) and on events 
(when user fill coords or load it from gpx), 
but this is not implemented on editcache I think, but works on newcache.

Original comment by wloczynutka on 10 Apr 2014 at 9:21

[GoogleCodeExporter]

My non-working testcase was from newcache.

Original comment by andrixnet on 10 Apr 2014 at 10:36

[GoogleCodeExporter]

I meant: 
- button only displays small window, do not taka any action on both edit/new 
cache page
- automatic fill region data is done by ajax scripts, only on new cache page.

Original comment by wloczynutka on 11 Apr 2014 at 9:22

[GoogleCodeExporter]

I'd like to ask about this issue status: 7 months with no action. I suggest to 
close this issue as abandoned.

Original comment by wloczynutka on 5 Nov 2014 at 10:20

[GoogleCodeExporter]

I had little progress on this, so far, but not significant. 
There were/are other issues with higher importance.

However this is very significant for our country and should remain open until 
solved.
Thank you.

Original comment by andrixnet on 6 Nov 2014 at 8:40

[GoogleCodeExporter]

Note: in table cache_location only adm1 and adm3 are filled (at this time). 
All adm1, adm2, adm3, adm4 should be filled to correctly acomplish this 
feature. 

Further investigation is necessary on how to correlate existing data with 
proper fields.

Original comment by andrixnet on 7 Nov 2014 at 10:26