search

pimbongaerts / mesophotic

Ruby on Rails application to host scientific information on mesophotic coral ecosystems
http://www.mesophotic.org
MIT License
1 stars 1 forks source link

EZZ table information addition to mesophotic.org #153

Open gonzaloprb opened 6 months ago

gonzaloprb commented 6 months ago

[Uploading mesophotic_org_EEZ_16112023.csv…]() Need help to add EEZ information into mesophotic.org

💬 Entail a new "eez" table (attached) that has the id, name, and code to mesophotic.org

And then a new eez_id column in the locations table that links to this eez table. (https://en.wikipedia.org/wiki/Exclusive_economic_zone)

The #id and #description columns should match the current location categories in mesophotic.org

The new table in mesophotic.org should have the column SOVEREIGN1 to be able to map the information according to EEZ, and also summarise the publication records based on EEZ.

📝 I am sorry if the column names are confusing. Feel free to change them if necessary.

pimbongaerts commented 5 months ago

@gonzaloprb - could you upload the actual EEZ table? seems like the link that is not there is not working.

gonzaloprb commented 5 months ago

Sure, here you go mesophotic_org_EEZ_16112023.csv

ryanbooker commented 4 months ago

@gonzaloprb @pimbongaerts Should I add all the EEZs in the table on Wikipedia, or just the EEZ that we have Locations for? There are about 92 EEZs that correspond to our Locations, but there are about 199 EEZs in total according to the table in Wikipedia.

Although I could be reading the Wikipedia entry incorrectly. It's kinda confusing. Countries don't seem to have a 1:1 mapping to EEZ?

gonzaloprb commented 4 months ago

@pimbongaerts should confirm, but I reckon adding the 199 EEZs from Wikipedia is smarter thinking forward in case we have new locations in the future

Cheers, G

On 18 Apr 2024, at 19:41, Ryan Booker @.***> wrote:

@gonzaloprb https://github.com/gonzaloprb @pimbongaerts https://github.com/pimbongaerts Should I add all the EEZs in the table on Wikipedia, or just the EEZ that we have Locations for? There are about 92 EEZs that correspond to our Locations, but there are about 199 EEZs in total according to the table in Wikipedia.

— Reply to this email directly, view it on GitHub https://github.com/pimbongaerts/mesophotic/issues/153#issuecomment-2063665048, or unsubscribe https://github.com/notifications/unsubscribe-auth/AMR5LTKNKXNV73OEXL2AYJDY56WP5AVCNFSM6AAAAABDQ3LBAWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANRTGY3DKMBUHA. You are receiving this because you were mentioned.

pimbongaerts commented 4 months ago

Yes I agree!

On Fri, Apr 19, 2024, 14:21 Gonzalo Pérez-Rosales @.***> wrote:

@pimbongaerts should confirm, but I reckon adding the 199 EEZs from Wikipedia is smarter thinking forward in case we have new locations in the future

Cheers, G

On 18 Apr 2024, at 19:41, Ryan Booker @.***> wrote:

@gonzaloprb https://github.com/gonzaloprb @pimbongaerts < https://github.com/pimbongaerts> Should I add all the EEZs in the table on Wikipedia, or just the EEZ that we have Locations for? There are about 92 EEZs that correspond to our Locations, but there are about 199 EEZs in total according to the table in Wikipedia.

— Reply to this email directly, view it on GitHub < https://github.com/pimbongaerts/mesophotic/issues/153#issuecomment-2063665048>, or unsubscribe < https://github.com/notifications/unsubscribe-auth/AMR5LTKNKXNV73OEXL2AYJDY56WP5AVCNFSM6AAAAABDQ3LBAWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANRTGY3DKMBUHA>.

You are receiving this because you were mentioned.

— Reply to this email directly, view it on GitHub https://github.com/pimbongaerts/mesophotic/issues/153#issuecomment-2065631659, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAFTT2BSDSZHLTHKQEEHR7DY6B5Q3AVCNFSM6AAAAABDQ3LBAWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANRVGYZTCNRVHE . You are receiving this because you were mentioned.Message ID: @.***>