search

geogeeks-au / maps-for-lost-towns

Georeferencing historic maps through crowdsourcing
4 stars 1 forks source link

Export the database to a spreadsheet to enable creation of taxonomies #21

Closed keithamoss closed 8 years ago

keithamoss commented 8 years ago

Helen is going to spend some time creating taxonomies for the maps.

e.g. Fun maps, Projects that never happened, whatever else turns up!

This will be an input to the UI work.

This will be a manual task, so Helen needs an easy way to browse the whole list, see the image, and categorise it.

Required fields:

Originally this was going to be a spreadsheet, but then we thought about creating a quick HTML viewer optimised for efficient paging through maps.

keithamoss commented 8 years ago 
SELECT series, img.filename, fields->'title' as title, object_url FROM sro_digital_objects_collection AS "do", sro_images AS "img" WHERE fields->>'filename' = replace(img.filename, ' ', '_')