Integrate Richard's map index

[dom]

Lots of people have been asking about exact dates and so on, and we now have a .rtf file from Richard listing them.

[nick]

One option would be to put the dates into the database, add a table to look up a tile to a sheet (eg sheet_number, min_easting, max_easting, min_northing, max_northing). We can then call a script with the easting and northings, and get back the sheet #(s), names and dates

[nick]

For my maps from the next batch, the dates are:

• 1 - Shetland - 61/63
• 2 - Shetland - 61/67
• 3 - Shetland - 61/63
• 7 - Pentland - 59/60
• 8 - Lewis - 60/61
• 9 - Cape Wrath - 59/60
• 28 - Nairnete - 47/48
• 30 - Banff - 47/49
• 39 - Dufftown - 46/48
• 40 - Inverurie - 46/48
• 45 - Aberdeen - 46/48
• 61 - Falkirk - 61/62
• 64 - St Andrews - 45/49
• 75 - Dunbar - 46/49
• 79 - Lanark - 46/49

And for Richard's 7th edition maps from the second batch:

• 76 - Carlisle - 1955
• 95 - Blackburn - 1953
• 103 - Doncaster - 1955
• 108 - Denbigh - 1952
• 116 - Dolgelley - 1953
• 127 - Aberystwyth - 1952
• 132 - Coventry - 1954
• 142 - Hereford - 1952
• 143 - Gloucester - 1953
• 144 - Cheltenham - 1953
• 151 - Pembroke - 1952
• 153 - Swansea - 1952

And Richard's folded maps from the second batch:

• 72 - Girvan - 55/61
• 90 - Settle - 47/48
• 95 - Blackburn - 45/47
• 96 - Leeds - 47/51
• 129 - Ludlow - 52/54
• 136 - Bury St Edmunds - 54/58
• 138 - Fishguard - 52/54
• 139 - Cardigan - 57/61
• 140 - Llandovery - 52/55

[nick]

I was thinking about renaming the tiles directories, eg

090-tiles => 090-tiles-1956

Then, have alter the make-smaller script to output for scaled 1 (in another directory) a set of text files, one per tile, containing year and sheet.

090-tiles-1956/tile-044-055.jpg =>

scaled1/044/055.jpg

meta1/044/055.txt (090\n1956\n)

We can then have a CGI that you call with one or more e+n's (eg each corner of the map), and it'll return the sheet numbers and years. Finally, call this, and output the info somewhere useful on screen.

[davids]

Replying to nick: Much as I think that people overuse SQL databases, one file per tile is taking the piss a bit. If you want to do that, why not make it an EXIF header. Otherwise I suspect it might be better to use a table in the database and have an import script.

[nick]

The SQL solution would require quite a bit more work to keep up-to-date than a simple rsync (which is all we need to do now for the image uploads)

Adding to the exif headers would be an option, assuming we can query it without too great an overhead. (We'd still want a script to do the checking)

[nick]

Thinking about it, one file per directory (i.e. easting) should work. Not too many small files, not too much work to re-generate (whenever any file in a dir changes), and not too much work to parse either

[nick]

I've done a script to generate these files, and it seems happy. I've uploaded an initial set of files (in meta1) to urchin and encore

Next up, I need to rename all my tile directories to include their years (currently, only my scottish ones have the year). Then, we can write the CGI to use the files :)