On 18/01/16 18:56, Robert Whittaker (OSM lists) wrote: > On 18 January 2016 at 16:41, Bogus Zaba <[email protected]> wrote: >> I was however a bit surprised to see that the progress tool referenced >> here : http://robert.mathmos.net/osm/schools/progress/ >> includes Welsh postcodes but uses Edubase rather than estyn as the data >> source. As far as I can make out, estyn is the more comprehensive data >> source for Wales, Edubase is by no means complete. > I set up http://robert.mathmos.net/osm/schools/progress/ . I was aware > of the Estyn source, but was hoping that Edubase already had all the > Welsh schools covered, as the Edubase data was easier to import > automatically. You seem to be suggesting that this isn't the case. It > looks like the Estyn numbers are actually a three-digit LA code > followed by a four-digit school code, which correspond to the > "LA/Establishment Number" stored in Edubase. I did a quick check with > the Isle of Anglesey schools, and it seems both Estyn and Edubase have > the same number -- 56. If you area aware of significant numbers of > schools missing from Edubase, then please let me know, and I'll see > how easy it would be to import the Estyn data too. In the mean time, > I'm afraid the Estyn codes won't be picked up by my tool. > > Robert. >
Robert - Many thanks for prompt reply. I think on further investigation you are correct - Edubase *does* contain all the schools that I have looked at in this area based on the Estyn listing. I had a full list of Estyn-listed establishments and was cross-checking to the Edubase list but using only the web-based edubase query tool (http://www.education.gov.uk/edubase/home.xhtml). I now see that in using that query you have to be careful to try both "Ruthin" and "Ruthun" or "Denbigh" and "Dinbych" - ie English and Welsh versions of the placenames. Something you might think a local would not take too long to work out... Is there a way of downloading the whole of the edubase database so that I do not run into the problems of searching on terms that I may not get quite right? Thanks also for explaining the relationship between the estyn id and the edubase establishment - that helps in tying things together. At the end of the day however, if Welsh schools are tagged with ref:estyn=* but not with ref:edubase=*, am I right in thinking that they will not be picked up as "progress" in the quarterly project? Thanks again for your work and specific help on this. Bogus Zaba -- Dr Bogumil N Zaba _______________________________________________ Talk-GB mailing list [email protected] https://lists.openstreetmap.org/listinfo/talk-gb
