SELECT
ntile,
CAST(avg(length) AS INTEGER) AS avgAmount,
CAST(max(length) AS INTEGER) AS maxAmount,
CAST(min(length) AS INTEGER) AS minAmount
FROM (SELECT length, ntile(6) OVER (ORDER BY length) AS ntile FROM countries) x
GROUP BY ntile
ORDER BY ntile;
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 | |
## | |
## Tested on: Ubuntu 18.04 & ECW 5.4 & GDAL 2.3.1 | |
## | |
## Download the ERDAS ECW JP2 SDK v5.4 Linux | |
## https://download.hexagongeospatial.com/downloads/ecw/erdas-ecw-jp2-sdk-v5-4-linux | |
## Download GDAL v2.3 Source (ex. 2.3.1) |
This file has been truncated, but you can view the full file.
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
const https = require('https'); | |
const fs = require('fs'); | |
const LABELS_FILE = 'labels.json'; | |
if (!fs.existsSync(LABELS_FILE)) { | |
console.log(LABELS_FILE + ' does not exist!'); | |
return 1; | |
} else if (process.argv.length !== 5) { | |
console.log('Usage:' + process.argv[0] + ' ' + process.argv[1] + ' <owner> <repo> <token>'); | |
return 2; |
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
"""Calculate building floors from the Spanish Cadastre GIS files (SHP). | |
Once logged, data can be downloaded from https://www.sedecatastro.gob.es/ | |
and the data specification is at | |
http://www.catastro.minhap.gob.es/ayuda/manual_descriptivo_shapefile.pdf | |
This python script is to be used in the QGIS 2.x field calculator. | |
The "CONSTRU" field stores volumetric data and other attributes in the form | |
of a structured text code. Floor numbers are in roman numerals. | |
As for example, "-II+IV+TZA" is a building part with two underground floors, |
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
# /etc/default/monit | |
# You must set this variable to yes for monit to start | |
START=yes | |
# Options to pass to monit | |
#MONIT_OPTS= |