Skip to content

Instantly share code, notes, and snippets.

@psiborg
psiborg / pop_os.md
Last active May 13, 2021 03:22
Pop!_OS

Pop OS

sudo apt install htop

sudo apt install ffmpeg

sudo apt install vlc
@psiborg
psiborg / import.bat
Last active January 25, 2021 19:21
Import Shapefiles to SQL Server
@echo off
set osgeopath="C:\OSGeo4W64\bin"
set basepath="C:\Users\{username}\Downloads\Esri"
rem echo %osgeopath%
rem echo %basepath%
cd "%basepath%\GIS_Data_&_Maps_CD1[World_Europe]\europe\basemap"
for %%f IN (*.shp) DO %osgeopath%\ogr2ogr.exe -overwrite -f MSSQLSpatial "MSSQL: Driver={SQL Server Native Client 11.0}; Server=localhost; Database=esri_europe_basemap; Trusted_Connection=yes" "%%f"
@psiborg
psiborg / ffmpeg.md
Last active December 17, 2022 14:51
FFmpeg
@psiborg
psiborg / ffmpeg.md
Created October 20, 2020 02:04 — forked from protrolium/ffmpeg.md
ffmpeg guide

ffmpeg

Converting Audio into Different Formats / Sample Rates

Minimal example: transcode from MP3 to WMA:
ffmpeg -i input.mp3 output.wma

You can get the list of supported formats with:
ffmpeg -formats

Convert WAV to MP3, mix down to mono (use 1 audio channel), set bit rate to 64 kbps and sample rate to 22050 Hz:

@psiborg
psiborg / Soundflower.md
Created July 7, 2020 20:20
Sunflower - MacOS system extension that allows applications to pass audio to other applications.
@psiborg
psiborg / git.md
Created June 19, 2020 00:01
Copy a Git repo to another repo
@psiborg
psiborg / Reproject.md
Last active May 7, 2020 04:19
QGIS 3.x #qgis
  1. Download a GeoTIFF (e.g., https://earthobservatory.nasa.gov/features/NightLights)

  2. Open a GeoTIFF (e.g., BlackMarble_2016_3km_gray_geo.tif)

  3. Select "Raster" > "Projections" > "Warp (Reproject)"

  4. In the "Parameters" tab:

    • Source CRS: Default CRS: EPSG:4326 - WGS 84
    • Target CRS: Project CRS: EPSG:3857 - WGS 84 / Pseudo-Mercator
    • Reprojected: [Save to File…] BlackMarble_2016_3km_gray_geo_epsg3857.tif
@psiborg
psiborg / Minikube.md
Last active March 16, 2020 17:02
Installing Kubernetes with Minikube #kubernetes #minikube #osx
@psiborg
psiborg / .bash_profile
Created September 25, 2019 02:37
Bash Profile #osx
export HISTCONTROL=ignoreboth:erasedups
export PS1='\[\e]0;\u@\h: \w\a\]${debian_chroot:+($debian_chroot)}\[\033[01;32m\]\u@\h\[\033[00m\]:\[\033[01;34m\]\w \$\[\033[00m\] '
export CLICOLOR=1
export LSCOLORS=ExFxBxDxCxegedabagacad