Jerome Gasperi jjrom
jjrom
/ splitcopy.sh
Created
November 14, 2018 21:26
Split a large SQL query file with one COPY to a large SQL query file with several COPY (one every 10000 lines)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sed '0~10000 s/$/\n\\\.\nCOPY landcover\.landcover \(ogc_fid, wkb_geometry, dn\) FROM stdin\;/g' < itag_landcover.sql > itag_landcover.sql.new |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # | |
| # Convert a 3 dimension KML file into a PNG image | |
| # | |
| # Author : Jérôme Gasperi (https://github.com/jjrom) | |
| # Date : 2018-11-07 | |
| # | |
| FILENAME=__NULL__ | |
| COLORTABLE=__NULL__ | |
| SIZE=1000x1000 |
jjrom
/ ST_SplitDateLine.sql
Last active
April 1, 2016 07:35
Split an input polygon in EPSG:4326 against the -180/180 date line
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- Copyright (C) 2016 Jerome Gasperi <jerome.gasperi@gmail.com> | |
| -- With priceless contribution from Nicolas Ribot <nicky666@gmail.com> | |
| -- | |
| -- This work is placed into the public domain. | |
| -- | |
| -- SYNOPSYS: | |
| -- ST_SplitDateLine(polygon) | |
| -- | |
| -- DESCRIPTION: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Add this to apache configuration file (not in .htaccess !) | |
| <Location /> | |
| SetOutputFilter DEFLATE | |
| SetEnvIfNoCase Request_URI \.(?:gif|jpe?g|png)$ no-gzip dont-vary | |
| SetEnvIfNoCase Request_URI \.(?:mp3|wav|wma|au|m4p|snd|mid|wmv|mpg|mpeg|mp4|qt|mov)$ no-gzip dont-vary | |
| SetEnvIfNoCase Request_URI \.pdf$ no-gzip dont-vary | |
| SetEnvIfNoCase Request_URI \.(?:exe|t?gz|zip|gz2|sit|rar)$ no-gzip dont-vary | |
| </Location> |