I'm trying to get a table of the carbon/water footprints for all the elements in the European Commission's Product Environmental Footprint database, so I can use them in some downstream analyses. I've tried using the built-in SQL tool, and also opening the .zolca file as a Derby database. I found the built-in tool next to useless, since I had to guess blindly at the table names and column names; I've had a little better success navigating through Derby, but since all of the examined products or compounds are linked to their components and by products using anonymized IDs, I've still not be able to find the correct join to get "beef (organic) | 2 kg-CO2/kg | 30 L-H2O/kg" or similar.
I know the data are in the db. I feel like I'm missing something easy. Can someone offer me some insight??