RSS

Geograph Knowledgebase / FAQ

Keyword Search:

Photo Contributors

How do I get a list of my photos as a CSV?
On the bottom of your profile page, look for "Download: CSV , XML for Excel 2003 of all images".
This has links to download as Comma Separate Values (CSV) or Excel XML format.

These can be opened in spreadsheet software, eg LibreOffice or Micrsoft Excel.

The URL for these downloads looks like this:
For CSV: http://www.geograph.org.uk/export.csv.php?u=XXXX&supp=1&taken=1&submitted=1&hits=1&tags=1External link
For Excel: http://www.geograph.org.uk/export.excel.xml.php?u=XXXX&supp=1&taken=1&submitted=1&hits=1&tags=1External link

The parameters specify what is included. The contributor is u=XXXX, where XXXX is the user ID. If you use a link from your own profile, it will include your own ID.

Other options:
&supp=1 - include photos classed as supplemental
&taken=1 - include taken date
&submitted=1 - include submitted date
&hits=1 - include hit count
&tags=1 - include tags, in a list separated by question marks
&desc=1 - include description
&class=1 - include classification (geograph or supplemental)
&level=1 - include geograph points, eg 1st, 2nd, 3rd
&ll=1 - include latitude and longitude (in separate columns)
&en=1 - include numerical grid reference, in easting and northing, plus figures for precision
&ppos=1 - include photographer position, easting and northing

For more details, see the API help: http://www.geograph.org.uk/help/api#csvExternal link
· contributed by Craig Wallace, Sep 2013 · Edit this answer (Open for editing by anyone) · Provide an alternative answer!

· Can't find the answer you looking for? Ask a question now! ·


Creative Commons Licence [Some Rights Reserved] the content of this page is licensed under a Creative Commons Licence.


· Old FAQ page in case you still looking for it. But please let us know why so we can update this one!
You are not logged in login | register