RSS

Geograph Knowledgebase / FAQ


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=1
For Excel: http://www.geograph.org.uk/export.excel.xml.php?u=XXXX&supp=1&taken=1&submitted=1&hits=1&tags=1

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#csv

· 1 of 163 questions shown. View All
· 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.


You are not logged in login | register