#Dag 1
| Tidspunkt | Emne | Form | Forberedelsestid |
|---|---|---|---|
| 9:00-10:00 | |||
| 10:00-10:10 | PAUSE | ||
| 10:10-11:10 | |||
| 11:10.11:15 | PAUSE | ||
| 11:15-12:00 | |||
| 12:00-12:30 | FROKOST | ||
| 12:30-13:30 |
| {"map": {"layer": [{"features_host": "http://192.168.99.100:32773/cgi-bin/qgis_mapserv.fcgi?MAP=/opt/ftpusers/test/jernbane_egedal.qgs&SERVICE=WFS&REQUEST=GetFeature&typeName=jernb&outputformat=GeoJSON", "name": "Jernbanen", "features_type": "LineString", "visible": false, "host": "http://192.168.99.100:32773/cgi-bin/qgis_mapserv.fcgi?MAP=/opt/ftpusers/test/jernbane_egedal.qgs", "layer_name": "jernb", "features_dataType": "json"}, {"features_host": "http://192.168.99.100:32773/cgi-bin/qgis_mapserv.fcgi?MAP=/opt/ftpusers/test/jernbane_egedal.qgs&SERVICE=WFS&REQUEST=GetFeature&typeName=togstat&outputformat=GeoJSON", "name": "togstat", "features_type": "Point", "visible": true, "host": "http://192.168.99.100:32773/cgi-bin/qgis_mapserv.fcgi?MAP=/opt/ftpusers/test/jernbane_egedal.qgs", "layer_name": "togstat", "features_dataType": "json"}, {"features_host": "http://192.168.99.100:32773/cgi-bin/qgis_mapserv.fcgi?MAP=/opt/ftpusers/test/jernbane_egedal.qgs&SERVICE=WFS&REQUEST=GetFeature&typeName=skov&outputformat=Ge |
#Dag 1
| Tidspunkt | Emne | Form | Forberedelsestid |
|---|---|---|---|
| 9:00-10:00 | |||
| 10:00-10:10 | PAUSE | ||
| 10:10-11:10 | |||
| 11:10.11:15 | PAUSE | ||
| 11:15-12:00 | |||
| 12:00-12:30 | FROKOST | ||
| 12:30-13:30 |
| LoadModule mapcache_module /usr/lib/apache2/modules/mod_mapcache.so | |
| <VirtualHost *:80> | |
| # The ServerName directive sets the request scheme, hostname and port that | |
| # the server uses to identify itself. This is used when creating | |
| # redirection URLs. In the context of virtual hosts, the ServerName | |
| # specifies what hostname must appear in the request's Host: header to | |
| # match this virtual host. For the default virtual host (this file) this | |
| # value is not decisive as it is used as a last resort host regardless. | |
| # However, you must set it for any further virtual host explicitly. | |
| #ServerName www.example.com |
| #!/bin/bash | |
| tiles=( 14_39 15_37 15_38 15_39 16_37 16_38 16_39 16_40 17_37 17_38 17_39 17_40 18_37 18_38 18_39 18_40 19_37 19_38 19_39 19_40 20_37 20_38 20_39 21_37 21_38 21_39 21_40 22_37 22_38 22_39 22_40 23_37 23_38 23_39 23_40 ) | |
| for i in "${tiles[@]}" | |
| do | |
| echo fetching $i | |
| filelist=`wget -q -O - http://repository.agic.umn.edu/imagery/stereoDEM/SETSM/ArcticDEM/$i/10m/ | sed -n 's/.*href="\([^"]*\).*/\1/p' | grep SETSM_ArcticDEM_` | |
| for file in $filelist | |
| do |
| DROP TABLE IF EXISTS stat.folketal; | |
| CREATE TABLE stat.folketal | |
| ( | |
| komkode character varying, | |
| tid character varying, | |
| antal integer | |
| ); | |
| COPY stat.folketal | |
| FROM PROGRAM |
| alias psql2markdown=" sed 's/+/|/g' | sed 's/^/|/' | sed 's/$/|/' | grep -v rows | grep -v '||'" |
| �PNG | |
| ��� | |
| IHDR������������j.>���tRNS��v��8���IDATx���[r� �T�e��66H<��Ni�Rv��4�$ ��(�������k[�l��+g�YgZ""��E6`KdGg�z��s(�,�� 0[̒{5+�?����ć̺ٚ��n��I�jZY�7�]�A�́�m��]JSP[WsCdj�� | |
| �1,�e^瞘�vg���:�i�%".�M�p����k�S�x��:�*��3f��:L��5a�v�1c�i��(� | |
| 0��t�17��a��"�ô~s?7���9�0[sScn�/u��ie�a����?�]���U������<�a���:+���9���]Q'��VU���m%hߢڪ��Nk��hW��� +�`ӂ��)�8hZP[4�U��Lǝ��K��hZP[(=�@��.���Mj��W.hZP[��д��0*�>�iAmQ�6}Mj��)HhZP[}L#�i��9�Mj��ʺ 4-�-�jk_д���U]������44-��h5�@�2�{.CS�c[|�s���i�w�F�Q�D;�f��N'6ƛ�J� | |
| ����g{@�n��ie+����iT�.VJ�'����fXEӗ_��o�ի�}3�w���4��0<U97!�%�A�Yje��f9� | |
| ����=���T(�=������?�o��s}#S0?�`�Ń ��A0�tj;V#�M�ë�h�S�À���"��0�?p[n�A8�����IEND�B`� |
| COPY | |
| (SELECT beliggenhedsadresse_kommune_kode, count(*) as antal | |
| FROM cvr.virksomheder | |
| WHERE beliggenhedsadresse_kommune_kode <> '' | |
| GROUP BY beliggenhedsadresse_kommune_kode | |
| ORDER BY antal DESC) | |
| TO PROGRAM 'cat <&0 > /tmp/data.csv; curl -F "file=@/tmp/data.csv;filename=cartodbtablename.csv" "https://{CARTODB_USER}.cartodb.com/api/v1/imports/?api_key={APIKEY}"' | |
| DELIMITER ',' | |
| CSV HEADER; |