schuem/watermask2map

watermask2map's Issues

postgres queries limited by CPU

Currently wms is querying postgres on every zoom and pan operation. Querying and rendering is taking about 10-14 s. When zooming and panning I get the following warning from glances:

                     2019-01-25 14:38:33 (0:00:04) - CRITICAL on CPU_SYSTEM (100.0)
                     2019-01-25 14:38:33 (0:00:16) - WARNING on CPU_USER (86.8)
                     2019-01-25 14:38:04 (0:00:06) - WARNING on CPU_USER (86.6)
                     2019-01-25 14:37:34 (0:00:04) - CRITICAL on CPU_SYSTEM (100.0)
                     2019-01-25 14:37:27 (0:00:04) - CRITICAL on CPU_SYSTEM (100.0)
                     2019-01-25 14:37:27 (0:00:11) - WARNING on CPU_USER (86.8)
                     2019-01-25 14:36:54 (0:00:04) - CRITICAL on CPU_SYSTEM (100.0)

The virtual machine is currently running on 4 cores. I have tried optimizing with work_mem (right now at 8MB, tested 4-64MB) and shared_buffers (128MB right now, tested 512MB) with no visible improvement.

on hover -> highlight in map, table, chart

Error on clicking features

After clicking features the following error occurs:

XML Parsing Error: no root element found
Location: http://seca-vista.geo.uni-potsdam.de/watermask/test.php?id=20476
Line Number 7, Column 1: test.php:7:1

transform wms into epsg 3857

Currently leaflet is loading the wms but it cannot be visualized. The wms is right now on epsg:4326, ie not projected and cannot be shown (this thread has a short explanation). It needs to be transformed into epsg 3857.

some features are not displayed in d3

do not ceil domain for very small reservoirs

Security Error when loading libraries from API in zim server

Following error occurs when loading libraries in index.html

The address is http://seca-vista.geo.uni-potsdam.de/watermask/

SecurityError: The operation is insecure. ol.js:198
aj.prototype.s
https://cdnjs.cloudflare.com/ajax/libs/openlayers/4.6.4/ol.js:198:279
kj.prototype.Ti
https://cdnjs.cloudflare.com/ajax/libs/openlayers/4.6.4/ol.js:206:348
k.tg
https://cdnjs.cloudflare.com/ajax/libs/openlayers/4.6.4/ol.js:126:129

http://seca-vista.geo.uni-potsdam.de/watermask/:412:12
b
https://cdnjs.cloudflare.com/ajax/libs/openlayers/4.6.4/ol.js:46:348
Sc.prototype.b
https://cdnjs.cloudflare.com/ajax/libs/openlayers/4.6.4/ol.js:49:206
k.bi
https://cdnjs.cloudflare.com/ajax/libs/openlayers/4.6.4/ol.js:129:352
b
https://cdnjs.cloudflare.com/ajax/libs/openlayers/4.6.4/ol.js:46:348
Sc.prototype.b
https://cdnjs.cloudflare.com/ajax/libs/openlayers/4.6.4/ol.js:49:206
k.mq
https://cdnjs.cloudflare.com/ajax/libs/openlayers/4.6.4/ol.js:73:388
b
https://cdnjs.cloudflare.com/ajax/libs/openlayers/4.6.4/ol.js:46:348
Sc.prototype.b
https://cdnjs.cloudflare.com/ajax/libs/openlayers/4.6.4/ol.js:49:206
Od
https://cdnjs.cloudflare.com/ajax/libs/openlayers/4.6.4/ol.js:70:302
k.Lp
https://cdnjs.cloudflare.com/ajax/libs/openlayers/4.6.4/ol.js:59:399
self-hosted:984:17

clicking on empty areas apparently triggers query

while clicking around I noticed that when we click on empty land (no dam areas) still the visualization window opens and starts processing something, which never ends. This should not happen: areas of no watermasks should not be reactive.

scale map to 100% of viewport

caching mapserver renderings

we definitely need to implement caching of mapserver in order to reduce time for opening webviz.

not showing most recent polygons

the most recent polygons are already present in the postgis database, but still not being shown in visualization. Why it that the case? It the query not working properly?

See for example id_cogerh=4055

add constraint

to PostgreSQL, only distinct combinations of ingestion_time and source_id per cogerh_id should be allowed, otherwise there will be duplicates (there already are ...)

add date offsets to chart

add offset of 1 month for d3.scale.domain to enhance chart
see https://github.com/d3/d3-time/blob/master/README.md#interval_offset

add funceme dataset as static layer

the funceme dataset would be very helpful for visual validation of the results at this stage.

properly style chart

• add margins for labels and add labels
• minor ticks for months, major ticks for years
• add circles for data points
• set max to next natural number
• use same font for chart as for panel heading

after click on poly show only the most recent watermask

Currently, after clicking on a polygon, a table, a d3 graph and a set of polygons will be shown. The set of polygons should be replaced by one polygon only.

I suppose this is an easy task, but should be only addressed after issue #17 is fixed

delete duplicate entries in database

evenly distribute divs in container

https://css-tricks.com/snippets/css/a-guide-to-flexbox/

go back in time one commit please

Martin: the DEMs are making the whole thing really really slow, maybe we can leave it for now until we have a better idea.
cheers!

units of area to hectar

please change the area units in the graph and tables to hectar (1 ha = 10 000 sqm).

sending jquery GET request to node.js server not working outside the uni network

In index.html the following client request is not reaching the server:
$.get('http://141.89.96.184:5155',{'id_funceme':idtest});

The server was up in the console by node mongolisten.js