provide identification body exports for Grant & Subhransu

[alexshepard]

I sent them the export that Ken-ichi made for me in December.

Need to document how that was produced here.

Find out from the Umass guys if they need regular exports of this content. If so, figure out a schedule and routinize it.

[alexshepard]

psql inaturalist_production -c "COPY ( 
SELECT
  i.id,
  it.name AS ident_taxon_name,
  pot.name AS previous_obs_taxon_name,
  body,
  disagreement
FROM
  identifications i
    LEFT JOIN taxa it ON it.id = i.taxon_id
    LEFT JOIN taxa pot ON pot.id = i.previous_observation_taxon_id
WHERE
  LENGTH(body) > 100
) TO STDOUT WITH CSV HEADER" > ~/kueda/idents-long-bodies-20231211.csv

[alexshepard]

grant wants us to add:

observation_id: id of the observation so that we can open up the associated web page and look at the images, and link to all the other observation metadata. ident_taxon_id: so that we can link to the iNat taxonomy. previous_obs_taxon_id: similarly, so that we can link to the iNat taxonomy.

[alexshepard]

can this be the same dataset that we make in #44 ?