PES/EIS/Eco-status spatial layer for FBIS

[jeremyshelton]

Hi @NyakudyaA

Below are some layers that we have been waiting for SANBI to publish so that we can include in the FBIS. Our focus is on the PES/EIS/Eco-status spatial layer(s):

Find the final NBA 2018 river data for download at: http://filegooi.co.za/get2/f48139cb1aecc49a944062a0b15010a9/NBA2018_Rivers_Final_Sep2019.zip

For the metadata please follow this link and click on the right hand column under Metadata “download pdf”

http://bgis.sanbi.org/SpatialDataset/Detail/2692

Please have a look and lets chat about these at next week's zoom

@helendallas @timlinux

[jeremyshelton]

Hi @NyakudyaA Have you been able to have a look at these yet? Thoughts? @helendallas

[NyakudyaA]

Hi @NyakudyaA Have you been able to have a look at these yet? Thoughts? @helendallas

Hi @jeremyshelton, I am on it today and will uploa them for comments

[NyakudyaA]

@jeremyshelton I see this layer also has GeoZone in the attributes list. Are we going to use this to replace the geoclass layers already in use?

[jeremyshelton]

@NyakudyaA hhmmm not sure. I think lets pick this up with the group early in the new year & get Tims advice. Have made a note...

[NyakudyaA]

@jeremyshelton Here is the layer https://maps.kartoza.com/geoserver/kartoza/wms?service=WMS&version=1.1.0&request=GetMap&layers=kartoza:nba_2018_rivers&styles=&bbox=15.9057273864746,-34.796329498291,34.0566444396973,-19.8364105224609&width=768&height=632&srs=EPSG:4326&format=application/openlayers The metadata from sanbi link has dissapeared.

In which spatial drawer would you like this to show up ?

[helendallas]

@jeremyshelton PLease can we chat about this and get our duck in a row before Admire adds

[jeremyshelton]

@NyakudyaA I will ask Nancy to resend the metadata. In the meantime, would you mind adding the layer to this folder on dropbox (so we can look at the columns and decide which columns we need to use and lose): https://www.dropbox.com/sh/uav5smvf4l3qx0i/AAAQ-4A4UELKaPraW3wYHoXna?dl=0

[jeremyshelton]

@NyakudyaA here is the new link:https://bgis.sanbi.org/SpatialDataset/Detail/3697 Also PDF attached: NBA2018_Rivers_metadata.pdf

[jeremyshelton]

@NyakudyaA @dimasciput Present Ecological State (PES) needs its own (new) drawer in the 'Spatial' filters tab. We can specify what to include in this once we've seen columns in the spreadsheet.

[NyakudyaA]

@NyakudyaA I will ask Nancy to resend the metadata. In the meantime, would you mind adding the layer to this folder on dropbox (so we can look at the columns and decide which columns we need to use and lose): https://www.dropbox.com/sh/uav5smvf4l3qx0i/AAAQ-4A4UELKaPraW3wYHoXna?dl=0

I do not have access to that dropbox but can you check it out here http://filegooi.co.za/get2/a986e926465159781ae032da5b882a53/NBA2018_Rivers.zip.

[NyakudyaA]

@jeremyshelton I do not see the Present Ecological State (PES) layer anywhere. Please send me the link to it

[jeremyshelton]

Is the PES layer not in here: http://filegooi.co.za/get2/a986e926465159781ae032da5b882a53/NBA2018_Rivers.zip ?

That what was sent to us by SANBI. It is also in the Kartoza dropbox folder...

[jeremyshelton]

@NyakudyaA priority attributes and fields from the NBA 2018 layers:

What we need is a drawer called 'National Biodiversity Assessment 2018, and then there will be five drawers within that, the names of which will correspond to the correct label column below

[NyakudyaA]

@NyakudyaA priority attributes and fields from the NBA 2019 layers:

To add in its own drawer in the spatial filters. @NyakudyaA to split the NBA layer to generate those different types and populate them in geocontext

[NyakudyaA]

@dimasciput you can proceed to add this to the spatial filters list:

[helendallas]

@jeremyshelton Please can you check this and close if all working correctly.

[jeremyshelton]

@dimasciput @NyakudyaA Could you give an update on progress with adding the this? Again, this would be a layer, as well as a drawer in the spatial filters.

[helendallas]

@NyakudyaA Please can you include the full name as per the table, not just the code. You have done it for some but not all of them.

[NyakudyaA]

@NyakudyaA Please can you include the full name as per the table, not just the code. You have done it for some but not all of them.

@helendallas I would have to create separate lookups tables for those values and join them to the respective tables for consistency sake because currently, I do not manipulate the raw data . I try to server it as is that's why you see it's inconsistent.

[helendallas]

If I updated the dbf file, would the correct labels come through?

We really want to avoid using abbreviations that may not be known by the user community. Obviously the dbf file should of been served correctly with the full names. Perhaps I can raise this with the NBA team as well.

@jeremyshelton Thoughts?

[NyakudyaA]

If I updated the dbf file, would the correct labels come through?

We really want to avoid using abbreviations that may not be known by the user community. Obviously the dbf file should of been served correctly with the full names. Perhaps I can raise this with the NBA team as well.

@jeremyshelton Thoughts?

I will then have to ingest it in the DB again. Can you share the updated layer and will ingest it. it should be quick

[helendallas]

@NyakudyaA I am not a GIS expert, os wanted to check that I wont mess anything up if I rename codes in NBA2018_Rivers_Final_Sep2019.dbf to be the full label and not the abbreviation

[NyakudyaA]

@NyakudyaA I am not a GIS expert, os wanted to check that I wont mess anything up if I rename codes in NBA2018_Rivers_Final_Sep2019.dbf to be the full label and not the abbreviation

What you have done is correct. I just need the shapefile including the DBF so that I can load it in the database again

[helendallas]

@NyakudyaA I am not able to save a dbf file in excel. So not sure that I will be able to do this. Suggestions welcome

[NyakudyaA]

@NyakudyaA I am not able to save a dbf file in excel. So not sure that I will be able to do this. Suggestions welcome

Do not worry about this. I will fix it on my side

[helendallas]

@NyakudyaA thanks so much!

[jeremyshelton]

@NyakudyaA @dimasciput

Can we please action this soonest? I am busy testing the layers and see that we still have the erroneous labels. Can we please implement the correct labels, categories and details as per Helen's table provided above.

Thanks!

@helendallas @timlinux

[NyakudyaA]

I have updated the layers here to show the correct labels, please test and revert. Maybe thy might need to be reingested again cc @dimasciput

[helendallas]

@NyakudyaA @dimasciput Still not correct on live site

and spatial filters not available on testing site

[NyakudyaA]

@NyakudyaA @dimasciput Still not correct on live site

and spatial filters not available on testing site

@dimasciput Need to update geocontext values again

[helendallas]

@NyakudyaA Please confirm if you are still planning to expand labels for the categories as per this ticket.

[NyakudyaA]

@NyakudyaA Please confirm if you are still planning to expand labels for the categories as per this ticket.

It's already implemented. @dimasciput please fetch for all the values for Spatial filters in the drawer National Biodiversity Assessment 2018

[helendallas]

@dimasciput Please fetch so we can check and close ticket, thanks

[jeremyshelton]

@dimasciput can you give an update on this ticket?

[dimasciput]

@jeremyshelton I'm still fetching catchment data, will do this later. I think we can do this in the background, so it should be fine if we want to open the site while fetching data from geocontext.

[jeremyshelton]

OK thanks @dimasciput - let us know when you are ready for us to test. Let's keep this ticket open until then 👍

[jeremyshelton]

@dimasciput is this now ready to test?

[dimasciput]

@jeremyshelton not yet, I'm still fetching other spatial data.

@NyakudyaA I still couldn't get any data from https://geocontext.kartoza.com/api/v1/geocontext/value/group/19.18611/-33.98/national_biodiversity_assessment_2018/

[NyakudyaA]

@jeremyshelton not yet, I'm still fetching other spatial data.

@NyakudyaA I still couldn't get any data from https://geocontext.kartoza.com/api/v1/geocontext/value/group/19.18611/-33.98/national_biodiversity_assessment_2018/

I will look it up @dimasciput still bust trying to fix qgis-server issues here

[helendallas]

@jeremyshelton PLease check if this has been resolved and close if you are happy.

[helendallas]

Not sure if sorted, moving to FBIS V5 project

[jeremyshelton]

This is not sorted yet.

There are still a lot of incorrect category labels and use of letter cases (e.g. upper case vs lower case etc).

Here is a link (see sheet called 'NBA 2018') to a spreadsheet with all of the correct labels for the different categories within each filter group: https://www.dropbox.com/home/FRC_Kartoza%20Shared%20Folder%20for%20FBIS/Filters?select=FBIS+FILTER+TESTING_MAY2020.xlsx

I cannot correct these via the FBIS admin pages to @NyakudyaA I think this must be done your end?

@dimasciput @helendallas

[helendallas]

@dimasciput @jeremyshelton From my checking it seems that a few of the labels are all correct, but that some of the categories/details still need revision.

@NyakudyaA are you able to correct these please?

Link provided above.

[helendallas]

I have linked this ticket to #2400