Skip to content

Instantly share code, notes, and snippets.

View nextstopsun's full-sized avatar

Nikolai Lebedev nextstopsun

7 followers · 5 following
  • Moscow
View GitHub Profile
@nextstopsun
nextstopsun / msft_urls.csv
Created November 14, 2022 14:28
msft_urls
We can't make this file beautiful and searchable because it's too large.
Pakistan,123031112,https://minedbuildings.blob.core.windows.net/global-buildings/2022-10-22/global-buildings.geojsonl/RegionName%3DPakistan/quadkey%3D123031112/part-00184-0bb2b168-55d3-4db4-8ea5-fee18b0aa622.c000.csv.gz,4.2MB
Pakistan,123031113,https://minedbuildings.blob.core.windows.net/global-buildings/2022-10-22/global-buildings.geojsonl/RegionName%3DPakistan/quadkey%3D123031113/part-00182-0bb2b168-55d3-4db4-8ea5-fee18b0aa622.c000.csv.gz,362.0KB
Pakistan,123031122,https://minedbuildings.blob.core.windows.net/global-buildings/2022-10-22/global-buildings.geojsonl/RegionName%3DPakistan/quadkey%3D123031122/part-00136-0bb2b168-55d3-4db4-8ea5-fee18b0aa622.c000.csv.gz,25.0KB
Pakistan,123031123,https://minedbuildings.blob.core.windows.net/global-buildings/2022-10-22/global-buildings.geojsonl/RegionName%3DPakistan/quadkey%3D123031123/part-00156-0bb2b168-55d3-4db4-8ea5-fee18b0aa622.c000.csv.gz,1.7MB
Pakistan,123031130,https://minedbuildings.blob.core.windows.net/global-buildings/2022-10-22/global-buildings.geojsonl
@nextstopsun
nextstopsun / test.sql
Last active May 31, 2019 09:38
SQL ownership and trigger insert problem
DROP TABLE IF EXISTS parent CASCADE;
DROP TABLE IF EXISTS child;
DROP TABLE IF EXISTS log;
DROP ROLE IF EXISTS tbl_owners;
CREATE ROLE tbl_owners;
GRANT tbl_owners TO current_user;
CREATE TABLE parent (
id SERIAL PRIMARY KEY
@nextstopsun
nextstopsun / # osgeo-qgis - 2019-05-14_18-09-24.txt
Created May 14, 2019 16:03
osgeo-qgis (osgeo/osgeo4mac/osgeo-qgis) on macOS 10.14.4 - Homebrew build logs
Homebrew build logs for osgeo/osgeo4mac/osgeo-qgis on macOS 10.14.4
Build date: 2019-05-14 18:09:24
@nextstopsun
nextstopsun / configure.log
Last active March 7, 2019 14:07
postgis build log
checking for a BSD-compatible install... /usr/bin/install -c
checking build system type... x86_64-pc-linux-gnu
checking host system type... x86_64-pc-linux-gnu
checking how to print strings... printf
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
@nextstopsun
nextstopsun / # qgis - 2019-02-28_00-40-27.txt
Created February 27, 2019 21:42
qgis (osgeo/osgeo4mac/qgis) on macOS 10.14.3 - Homebrew build logs
Homebrew build logs for osgeo/osgeo4mac/qgis on macOS 10.14.3
Build date: 2019-02-28 00:40:27
@nextstopsun
nextstopsun / # qgis - 2019-02-27_13-50-50.txt
Created February 27, 2019 10:51
qgis (osgeo/osgeo4mac/qgis) on macOS 10.14.3 - Homebrew build logs
Homebrew build logs for osgeo/osgeo4mac/qgis on macOS 10.14.3
Build date: 2019-02-27 13:50:50
@nextstopsun
nextstopsun / # qgis - 2019-02-27_13-17-17.txt
Created February 27, 2019 10:22
qgis (osgeo/osgeo4mac/qgis) on macOS 10.14.3 - Homebrew build logs
Homebrew build logs for osgeo/osgeo4mac/qgis on macOS 10.14.3
Build date: 2019-02-27 13:17:17
@nextstopsun
nextstopsun / # grass7 - 2019-01-03_00-31-01.txt
Created January 2, 2019 21:42
grass7 (osgeo/osgeo4mac/grass7) on macOS 10.14.2 - Homebrew build logs
Homebrew build logs for osgeo/osgeo4mac/grass7 on macOS 10.14.2
Build date: 2019-01-03 00:31:01
@nextstopsun
nextstopsun / # grass7 - 2019-01-03_00-02-13.txt
Created January 2, 2019 21:18
grass7 (osgeo/osgeo4mac/grass7) on macOS 10.14.2 - Homebrew build logs
Homebrew build logs for osgeo/osgeo4mac/grass7 on macOS 10.14.2
Build date: 2019-01-03 00:02:13
@nextstopsun
nextstopsun / CGAL 4.13 + SFCGAL 1.3.5 on Alpine Linux
Created November 12, 2018 13:24
ldd libSFCGAL.so.1
ldd (0x7f6270ad8000)
libCGAL_Core.so.13 => /usr/local/lib64/libCGAL_Core.so.13 (0x7f626fddb000)
libCGAL.so.13 => /usr/local/lib64/libCGAL.so.13 (0x7f626fbbe000)
libgmp.so.10 => /usr/lib/libgmp.so.10 (0x7f626f95a000)
libmpfr.so.4 => /usr/lib/libmpfr.so.4 (0x7f626f705000)
libboost_thread-mt.so.1.66.0 => /usr/lib/libboost_thread-mt.so.1.66.0 (0x7f626f4dc000)
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x7f626f189000)
libgcc_s.so.1 => /usr/lib/libgcc_s.so.1 (0x7f626ef77000)
libc.musl-x86_64.so.1 => ldd (0x7f6270ad8000)
libboost_system-mt.so.1.66.0 => /usr/lib/libboost_system-mt.so.1.66.0 (0x7f626ed72000)