Opened 13 years ago

Closed 13 years ago

#75 closed enhancement (fixed)

Integrate Richard's map index

Reported by: Dominic Hargreaves Owned by: David Sheldon
Priority: major Milestone: Main release and major publicity
Component: Website Version:
Keywords: Cc:

Description

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

Change History (8)

comment:1 Changed 13 years ago by Nick Burch

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

comment:2 Changed 13 years ago by Nick Burch

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

comment:3 Changed 13 years ago by Nick Burch

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.

comment:4 in reply to:  3 Changed 13 years ago by David Sheldon

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.

comment:5 Changed 13 years ago by Nick Burch

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)

comment:6 Changed 13 years ago by Nick Burch

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

comment:7 Changed 13 years ago by Nick Burch

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 :)

comment:8 Changed 13 years ago by Nick Burch

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.