CSIS URI variables in praxis 4 [RA/IA]: Heat mortality risk/impact #46

DenoBeno · 2019-09-16T14:57:15Z

I have implemented "Heat mortality risk/impact screening", please take a look
https://csis.myclimateservice.eu/node/1356/edit

@humerh: Are the uris correct?
@p-a-s-c-a-l: Is this how we want the variables used?
@therter: I hope that you can support this in the map soon...

DenoBeno · 2019-09-16T15:02:24Z

@p-a-s-c-a-l , @therter : please note that updating of the existing heat hazard resources with resources that use variables is more important than you think. Right now, we have over 100 resources linked to "European Wide Data Package" https://csis.myclimateservice.eu/node/682. That is completely unmaintainable:

that is: it's nearly impossible to double-check if any of the resources is missing and if all of them are correctly defined. Not to mention updating anything.

p-a-s-c-a-l · 2019-09-17T11:57:27Z

@humerh: I replaced the template URLs listed under Impact Calculation Service (Mortality) with some variables and got the following errors:

https://service.emikat.at/EmiKatTst/api/scenarios/2846/feature/view.2975/table/data?rownum=1000&filter=STUDY_VARIANT%3D’BASELINE’&filter=TIME_PERIOD%3D’Baseline’&filter=EMISSIONS_SCENARIO%3D’Baseline’&filter=EVENT_FREQUENCY%3D’rare’&filter=SZ_ID%3D2846 - not working: "Error during data retrieval - EMIKAT-Server.DB.ConnectionProblem: Can't access db: java.sql.SQLSyntaxErrorException: ORA-01756: Anführungsstrich fehlt bei Zeichenfolge\n - "
EMIKAT GeoJSON: https://service.emikat.at/EmiKatTst/api/scenarios/2846/feature/view.2975/table/geojson?rownum=1000&filter=STUDY_VARIANT%3D’BASELINE’&filter=TIME_PERIOD%3D’Baseline’&filter=EMISSIONS_SCENARIO%3D’Baseline’&filter=EVENT_FREQUENCY%3D’rare’&filter=SZ_ID%3D2846 - OK
or CSV: https://service.emikat.at/EmiKatTst/api/scenarios/2846/feature/view.2975/table/csv?rownum=1000&filter=STUDY_VARIANT%3D’BASELINE’&filter=TIME_PERIOD%3D’Baseline’&filter=EMISSIONS_SCENARIO%3D’Baseline’&filter=EVENT_FREQUENCY%3D’rare’&filter=SZ_ID%3D2846 - ok
WMS: https://service.emikat.at/geoserver/clarity/wms?service=WMS&version=1.1.0&request=GetMap&layers=clarity%3Aview.2975&bbox=4672000.0%2C1979500.0%2C4687500.0%2C1988000.0&width=768&height=421&srs=EPSG%3A3035&format=image%2Fgif&CQL_FILTER=STUDY_VARIANT%3D%27BASELINE%27%20and%20TIME_PERIOD=%27Baseline%27%20AND%20EMISSIONS_SCENARIO=%27Baseline%27%20AND%20EVENT_FREQUENCY=%27rare%27%20AND%20SZ_ID=2846 - not working: Rendering process failed 10

DenoBeno · 2019-09-17T12:17:37Z

There is a mix of various capitalizations for the variable values in the links. Not sure if that's the reason for the error, but it doesn't look correct to me:

filter=STUDY_VARIANT%3D’BASELINE’&filter=TIME_PERIOD%3D’Baseline’&filter=EMISSIONS_SCENARIO%3D’Baseline’&filter=EVENT_FREQUENCY%3D’rare’&filter=SZ_ID%3D2846 - ok

I also wonder if the single quotes can be written as ' or must be written as %27?

DenoBeno · 2019-09-17T12:31:10Z

I looked into https://service.emikat.at/EmiKatTst/api/scenarios/2846/feature/view.2975/table/geojson?rownum=1000&filter=STUDY_VARIANT%3D’BASELINE’&filter=TIME_PERIOD%3D’Baseline’&filter=EMISSIONS_SCENARIO%3D’Baseline’&filter=EVENT_FREQUENCY%3D’Rare’&filter=SZ_ID%3D2846 and the output seems to be wrong to me. I also tried with 'rare', the result is the same - this filter seems to be ignored.

using %27 instead of ' doesn't seem to have any effect.

In fact, it would seem that other filters are ignored too. E.g., I'm also getting this out of it:

DenoBeno · 2019-09-17T12:36:55Z

https://service.emikat.at/EmiKatTst/api/scenarios/2846/feature/view.2975/table/data?rownum=1000&filter=STUDY_VARIANT%3D%E2%80%99BASELINE%E2%80%99&filter=TIME_PERIOD%3D%E2%80%99Baseline%E2%80%99&filter=EMISSIONS_SCENARIO%3D%E2%80%99Baseline%27&filter=EVENT_FREQUENCY%3D%27rare%27&filter=SZ_ID%3D%272846%27

does seem to work a bit better, so at least here it could be the quotes. (I replaced ' by %27). But the result is empty:

DenoBeno · 2019-09-17T13:23:49Z

@humerh and I have tested this now - the filters seem to be completely broken at the moment. Possibly due to renaming of the parameters earlier today?

@humerh will fix this ASAP.

p-a-s-c-a-l · 2019-09-18T12:35:05Z

@humerh any news on that? Could you please post a REST API URL that actually works so that i can test my implementation in clarity-h2020/simple-table-component#5 ?

humerh · 2019-09-18T14:11:59Z

This should be solved now. Sorry.

DenoBeno · 2019-09-19T15:33:51Z

This works now:

https://service.emikat.at/EmiKatTst/api/scenarios/2846/feature/view.2975/table/data?rownum=1000&filter=STUDY_VARIANT='BASELINE'&filter=TIME_PERIOD='Baseline'&filter=EMISSIONS_SCENARIO='Baseline'&filter=EVENT_FREQUENCY='Rare'&filter=SZ_ID=2846

Thus, this must work too:

https://service.emikat.at/EmiKatTst/api/scenarios/${emikat_id}/feature/view.2975/table/data?rownum=1000&filter=STUDY_VARIANT='${study_variant}'&filter=TIME_PERIOD='${time_period}'&filter=EMISSIONS_SCENARIO='${emissions_scenario}'&filter=EVENT_FREQUENCY='${event_frequency}'&filter=SZ_ID=${emikat_id}

DenoBeno · 2019-09-19T16:00:07Z

I have a problem with map. Looking at the #46, I would expect that the same link as there must work here, just "clarity:view.2974" replaced by "clarity:view.2975"

however, https://service.emikat.at/geoserver/clarity/wms?service=WMS&version=1.1.0&request=GetMap&layers=clarity:view.2975&bbox=4672000.0,1979500.0,4687500.0,1988000.0&width=768&height=421&srs=EPSG:3035&format=image/gif&CQL_FILTER=STUDY_VARIANT=%27BASELINE%27%20and%20TIME_PERIOD=%27Baseline%27%20AND%20EMISSIONS_SCENARIO=%27Baseline%27%20AND%20EVENT_FREQUENCY=%27Rare%27%20AND%20SZ_ID=2846&styles=T_A fails.

ah, OK - last parameter is too much. So this works:

https://service.emikat.at/geoserver/clarity/wms?service=WMS&version=1.1.0&request=GetMap&layers=clarity:view.2975&bbox=4672000.0,1979500.0,4687500.0,1988000.0&width=768&height=421&srs=EPSG:3035&format=image/gif&CQL_FILTER=STUDY_VARIANT='BASELINE' and TIME_PERIOD='Baseline' AND EMISSIONS_SCENARIO='Baseline' AND EVENT_FREQUENCY='Rare' AND SZ_ID=2846

And thus, this must be OK too:

https://service.emikat.at/geoserver/clarity/wms?service=WMS&version=1.1.0&request=GetMap&layers=clarity:view.2975&bbox=4672000.0,1979500.0,4687500.0,1988000.0&width=768&height=421&srs=EPSG:3035&format=image/gif&CQL_FILTER=STUDY_VARIANT='${study_variant}' and TIME_PERIOD='${time_period}' AND EMISSIONS_SCENARIO='${emissions_scenario}' AND EVENT_FREQUENCY='${event_frequency}' AND SZ_ID=${emikat_id}

DenoBeno · 2019-09-19T16:04:20Z

Status: https://csis.myclimateservice.eu/node/1356 has been updated, for potential issues see #45 (comment)

p-a-s-c-a-l · 2019-09-20T15:09:13Z

You can test the JSON API response with the new simple table component here (need to be logged-in in CSIS in the same browser!).

You can even change the URL Template to test the other APIs like Population Exposure, but beware of the ${} pitfall.

p-a-s-c-a-l · 2019-09-23T08:02:04Z

Basic EMIKAT parameters are now supported in the MapComponent, which means the WMS template URL is now parametrised. No new "virtual" layers are added for all / several parameter combinations, therefore we have to work now on a parameter selection user interface (see clarity-h2020/csis#101)

Here are two example Links to parametrised RA/IA Maps. Difference is that one Map shows Rare events while the other shows frequent Events.:

However, the layers are not loaded, it seems that the server is extremely slow (see also clarity-h2020/emikat#9 (comment))

DenoBeno · 2019-10-14T16:17:44Z

This should be OK now no?

p-a-s-c-a-l · 2019-10-15T09:24:06Z

OK

p-a-s-c-a-l · 2020-03-02T11:37:19Z

Update EMIKAT JSON API URIs has described here

p-a-s-c-a-l · 2020-03-25T13:16:25Z

done

DenoBeno assigned humerh, p-a-s-c-a-l, therter and patrickkaleta Sep 16, 2019

DenoBeno mentioned this issue Sep 16, 2019

Which EMIKAT-generated resources do we need to include in the screening Data Package(s)? #42

Closed

DenoBeno changed the title ~~CSIS URI variables in praxis 1: Heat mortality risk/impact~~ CSIS URI variables in praxis 2: Heat mortality risk/impact Sep 16, 2019

DenoBeno mentioned this issue Sep 16, 2019

CSIS URI variables in praxis 1 [HC]: heat hazard indices #47

Closed

p-a-s-c-a-l added the enhancement New feature or request label Sep 17, 2019

p-a-s-c-a-l added this to the 1st Data Package milestone Sep 17, 2019

DenoBeno mentioned this issue Sep 17, 2019

How to choose which "variable combinations" to use in a study? clarity-h2020/csis#101

Closed

DenoBeno mentioned this issue Sep 19, 2019

CSIS URI variables in praxis 3 [EE]: Population Exposure #49

Closed

DenoBeno mentioned this issue Sep 21, 2019

CSIS URI variables in praxis 2 [HC-LE]: Local Effects for Heatwaves #45

Closed

p-a-s-c-a-l changed the title ~~CSIS URI variables in praxis 2: Heat mortality risk/impact~~ CSIS URI variables in praxis 4 [RA/IA]: Heat mortality risk/impact Sep 26, 2019

p-a-s-c-a-l closed this as completed Oct 15, 2019

p-a-s-c-a-l added the BB: Catalogue of ER & AO Catalogue of Elements at Risk and Adaptation Options Building Block label Oct 30, 2019

p-a-s-c-a-l reopened this Mar 2, 2020

p-a-s-c-a-l mentioned this issue Mar 3, 2020

New EMIKAT calculation currently not possible clarity-h2020/emikat#33

Closed

p-a-s-c-a-l closed this as completed Mar 25, 2020

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

CSIS URI variables in praxis 4 [RA/IA]: Heat mortality risk/impact #46

CSIS URI variables in praxis 4 [RA/IA]: Heat mortality risk/impact #46

DenoBeno commented Sep 16, 2019 •

edited

Loading

DenoBeno commented Sep 16, 2019

p-a-s-c-a-l commented Sep 17, 2019

DenoBeno commented Sep 17, 2019

DenoBeno commented Sep 17, 2019 •

edited

Loading

DenoBeno commented Sep 17, 2019 •

edited

Loading

DenoBeno commented Sep 17, 2019

p-a-s-c-a-l commented Sep 18, 2019 •

edited

Loading

humerh commented Sep 18, 2019

DenoBeno commented Sep 19, 2019

DenoBeno commented Sep 19, 2019 •

edited

Loading

DenoBeno commented Sep 19, 2019 •

edited

Loading

p-a-s-c-a-l commented Sep 20, 2019

p-a-s-c-a-l commented Sep 23, 2019

DenoBeno commented Oct 14, 2019

p-a-s-c-a-l commented Oct 15, 2019

p-a-s-c-a-l commented Mar 2, 2020

p-a-s-c-a-l commented Mar 25, 2020

CSIS URI variables in praxis 4 [RA/IA]: Heat mortality risk/impact #46

CSIS URI variables in praxis 4 [RA/IA]: Heat mortality risk/impact #46

Comments

DenoBeno commented Sep 16, 2019 • edited Loading

DenoBeno commented Sep 16, 2019

p-a-s-c-a-l commented Sep 17, 2019

DenoBeno commented Sep 17, 2019

DenoBeno commented Sep 17, 2019 • edited Loading

DenoBeno commented Sep 17, 2019 • edited Loading

DenoBeno commented Sep 17, 2019

p-a-s-c-a-l commented Sep 18, 2019 • edited Loading

humerh commented Sep 18, 2019

DenoBeno commented Sep 19, 2019

DenoBeno commented Sep 19, 2019 • edited Loading

DenoBeno commented Sep 19, 2019 • edited Loading

p-a-s-c-a-l commented Sep 20, 2019

p-a-s-c-a-l commented Sep 23, 2019

DenoBeno commented Oct 14, 2019

p-a-s-c-a-l commented Oct 15, 2019

p-a-s-c-a-l commented Mar 2, 2020

p-a-s-c-a-l commented Mar 25, 2020

DenoBeno commented Sep 16, 2019 •

edited

Loading

DenoBeno commented Sep 17, 2019 •

edited

Loading

DenoBeno commented Sep 17, 2019 •

edited

Loading

p-a-s-c-a-l commented Sep 18, 2019 •

edited

Loading

DenoBeno commented Sep 19, 2019 •

edited

Loading

DenoBeno commented Sep 19, 2019 •

edited

Loading