Cdp Water Report Pdf Scrapping and Reporting

1. Cdp pdf scrapping

generate a tool that can read and parse cdp water reports, and format the data for future processing.

- Identify and export CDP Water report version
- Identify which data is provided by the company in the CDP Water report
- Define data structure, for later processing and consumption. (Include version
    - Example:
        - Report: https://www.coca-colacompany.com/content/dam/journey/us/en/policies/pdf/sustainability/2020-cdp-water-response.pdf
        - W1.1 Output: https://jsoneditoronline.org/#left=cloud.fe7d980567fe47c0be79451c9b001f82&right=local.mobuqi
- Generate a tool that processes pdf data and generate a JSON output
- Generate a tool that transforms that json and insert data in sql tables.
- Plus: Make it work online providing an API

Possible libraries to use:
- pdfreader: https://pdfreader.readthedocs.io/en/latest/index.html
- pdfminer: https://github.com/pdfminer/pdfminer.six
- Or another one in another language.




CDP Water report definition:
https://guidance.cdp.net/en/guidance?cid=20&ctype=theme&idtype=ThemeID&incchild=1&microsite=0&otype=Questionnaire&tags=TAG-596%2CTAG-607%2CTAG-600

Some examples:
https://www.unilever.com/Images/unilever-cdp-water-response-2020_tcm244-558531_en.pdf
https://www.coca-colacompany.com/content/dam/journey/us/en/policies/pdf/sustainability/2020-cdp-water-response.pdf
https://www.pepsico.com/docs/album/esg-topics-policies/2020-cdp-water-response.pdf?sfvrsn=a6df494a_0

2. CDP Reporting generator

Generate a reverse tool, that providing cdp data generates a new cdp report.