/* ================================================================================ Pivot example with variable number of columns in the output. ================================================================================ example data is straight forward, imagine a table with a customer identifier, an invoice date and an amount. */ DROP TABLE IF EXISTS invoice;
cuulee
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
cuulee
/ qlimt.xml
Created
June 9, 2020 05:54
— forked from tjukanovt/qlimt.xml
This file contains hidden or 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
| <!DOCTYPE qgis_style> | |
| <qgis_style version="2"> | |
| <symbols> | |
| <symbol clip_to_extent="1" name="qlimt" force_rhr="0" type="fill" alpha="1"> | |
| <layer enabled="1" pass="0" locked="0" class="GeometryGenerator"> | |
| <prop v="Fill" k="SymbolType"/> | |
| <prop v="with_variable('my_geom',
CASE WHEN 
 num_geometries( $geometry)>1
 THEN 
 geometry_n( $geometry, @geometry_part_num)
 ELSE
 $geometry
 END,
 with_variable('shape',rand(1,4),
 CASE WHEN 
 @shape =1
 THEN 
 minimal_circle( @my_geom )
 WHEN
 @shape =2
 THEN
 oriented_bbox( @my_geom )
 WHEN
 @shape =3
 THEN
 oriented_bbox( @my_geom )
 WHEN
 @shape =4
 THEN
 simplify(@my_geom, rand(1,20))
 END))
 " k="geometryModifier"/> | |
| <data_defined_properties> | |
| <Option type="Map"> | |
cuulee
/ mapOrder.js
Created
March 24, 2020 08:28
— forked from ecarter/mapOrder.js
Order an array of objects based on another array order
This file contains hidden or 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
| /** | |
| * Sort array of objects based on another array | |
| */ | |
| function mapOrder (array, order, key) { | |
| array.sort( function (a, b) { | |
| var A = a[key], B = b[key]; | |
cuulee
/ app.js
Created
December 27, 2019 02:51
— forked from pantharshit00/app.js
Simple express app using JWT authentication
This file contains hidden or 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
| /** | |
| * To get started install | |
| * express bodyparser jsonwebtoken express-jwt | |
| * via npm | |
| * command :- | |
| * npm install express bodyparser jsonwebtoken express-jwt --save | |
| */ | |
| // Bringing all the dependencies in | |
| const express = require('express'); |
cuulee
/ cuml_taxi_fare_prediction.ipynb
Created
December 18, 2019 00:39
— forked from gumdropsteve/cuml_taxi_fare_prediction.ipynb
cuML_Taxi_Fare_Prediction.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
cuulee
/ plot_missing_data.ipynb
Created
November 23, 2019 14:27
— forked from martinfleis/plot_missing_data.ipynb
Support for missing data in Geopandas plotting
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
cuulee
/ ensureMutationId.ts
Created
August 21, 2019 06:10
— forked from bkonkle/ensureMutationId.ts
Ensure an '$id' for every Mutation in PostGraphile
This file contains hidden or 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
| export const ensureMutationId: Plugin = builder => { | |
| builder.hook('GraphQLObjectType:fields:field', (field, build, context) => { | |
| const {pgSql: sql} = build | |
| const { | |
| scope: { | |
| isPgUpdateMutationField, | |
| isPgCreateMutationField, | |
| isPgDeleteMutationField, | |
| }, | |
| } = context |
cuulee
/ server.js
Created
August 2, 2019 04:40
— forked from zimmicz/server.js
PostGIS MVT Express routing
This file contains hidden or 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 express = require("express") | |
| const app = express() | |
| const { Pool } = require("pg") | |
| const SphericalMercator = require("sphericalmercator") | |
| const pool = new Pool({ | |
| host: "localhost", | |
| port: 15432, | |
| user: "postgres", | |
| database: "postgres" | |
| }) |
cuulee
/ postgres-pivot.md
Created
August 1, 2019 09:41
— forked from ryanguill/postgres-pivot.md
Example of postgres pivot using jsonb_object_agg for variable columns in output. To play with this yourself in an online repl, click here: http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=5dbbf7eadf0ed92f8d6a49fc5be8f3f2
cuulee
/ index.js
Created
July 29, 2019 10:31
— forked from stepankuzmin/index.js
PostGIS ST_AsMVT JSONB properties encoding bug
This file contains hidden or 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 fs = require("fs"); | |
| const geobuf = require("geobuf"); | |
| const Protobuf = require("pbf"); | |
| const pgp = require("pg-promise")(); | |
| const vt = require("vector-tile"); | |
| const db = pgp(process.env.DATABASE_URL); | |
| const tile_with_properties_as_jsonb = `WITH data AS ( | |
| SELECT * FROM (VALUES |