Skip to content

Instantly share code, notes, and snippets.

View giacecco's full-sized avatar

Gianfranco Cecconi giacecco

View GitHub Profile
@giacecco
giacecco / events.ics
Last active July 16, 2026 03:02
Circle: MAD Records Community
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//sebbo.net//ical-generator//EN
NAME:MAD Records Community
X-WR-CALNAME:MAD Records Community
BEGIN:VEVENT
UID:109c57d8-6ae9-4c4e-bc33-185b2a67a45a
SEQUENCE:0
DTSTAMP:20260716T030220Z
DTSTART:20260714T190000Z
@giacecco
giacecco / radio-ready-single-4166.ics
Last active July 16, 2026 03:02
Skool: Radio Ready Single
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//sebbo.net//ical-generator//EN
NAME:Radio Ready Single
X-WR-CALNAME:Radio Ready Single
BEGIN:VEVENT
UID:83622b31-6ec0-491c-94e0-96238be30a8e
SEQUENCE:0
DTSTAMP:20260716T030223Z
DTSTART:20260626T160000Z
@giacecco
giacecco / mastering.ics
Last active July 16, 2026 03:02
Skool: Mastering.com
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//sebbo.net//ical-generator//EN
NAME:Mastering.com
X-WR-CALNAME:Mastering.com
BEGIN:VEVENT
UID:4201a2ba-d020-4e18-a181-507973d9c4ac
SEQUENCE:0
DTSTAMP:20260716T030224Z
DTSTART:20260624T180000Z
@giacecco
giacecco / reverse-engineer-9251.ics
Last active July 16, 2026 03:02
Skool: The Reverse Engineer
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//sebbo.net//ical-generator//EN
NAME:The Reverse Engineer
X-WR-CALNAME:The Reverse Engineer
BEGIN:VEVENT
UID:ed192acd-ca70-4d3e-a63b-3a3c6b4884fc
SEQUENCE:0
DTSTAMP:20260716T030221Z
DTSTART:20260623T230000Z
0 info it worked if it ends with ok
1 verbose cli [ '/usr/bin/node', '/usr/bin/npm', 'install' ]
2 info using npm@2.14.9
3 info using node@v0.12.10
4 verbose node symlink /usr/bin/node
5 verbose readDependencies loading dependencies from /opt/package.json
6 warn package.json dicoim-main-website@0.0.1 No README data
7 verbose install where, deps [ '/opt', [ 'express' ] ]
8 verbose install where, peers [ '/opt', [] ]
9 verbose installManyTop reading for lifecycle /opt/package.json
@giacecco
giacecco / error
Last active October 27, 2015 14:00
.../database$ psql -d olaf_yr2_paper -f create_crowdflower_init_csv.sql
psql:create_crowdflower_init_csv.sql:5: \copy: arguments required
psql:create_crowdflower_init_csv.sql:14: ERROR: syntax error at or near "TO"
LINE 5: TO '/Users/giacecco/Documents/PhD/GitHub projects/OLAF-yr2...
^
.../database$
SELECT lr_town, ST_Union(mbr) AS geom
FROM os_open_names_with_towns
WHERE type = 'transportNetwork' AND lr_town = 'SOUTHAMPTON'
GROUP BY lr_town
DROP VIEW IF EXISTS os_open_names_with_towns;
CREATE VIEW os_open_names_with_towns AS
SELECT a.*, b.town AS lr_town
FROM
(SELECT * FROM os_open_names WHERE type = 'transportNetwork') AS a,
(SELECT town, bounding_box FROM lr_pp_town_definition) AS b
WHERE ST_Contains(b.bounding_box, a.mbr)
UNION
SELECT *, NULL AS lr_town FROM os_open_names WHERE type != 'transportNetwork';
DROP VIEW IF EXISTS lr_pp_town_definition;
CREATE VIEW lr_pp_town_definition AS
SELECT a.town, ST_MakeEnvelope(MIN(ST_X(b.geom)), MIN(ST_Y(b.geom)), MAX(ST_X(b.geom)), MAX(ST_Y(b.geom)), 4326) AS bounding_box
FROM
(SELECT DISTINCT town, pcd FROM lr_pp) AS a
LEFT JOIN
(SELECT pcd, geom FROM ons_pd WHERE doterm IS NULL) AS b
ON a.pcd = b.pcd
GROUP BY town;
[
{
"location" : {
"lat" : 50.936847,
"lon" : -1.3963189999999486
},
"panoramaId" : "MpgI98E7NEuIe0P0Ypi9-Q",
"pov" : {
"heading" : 120.97,
"pitch" : 13.3,