chapmanjacobd
/ split_by_silence.sh
Created
February 28, 2022 02:07
— forked from vi/split_by_silence.sh
Using FFmpeg to split multimedia file into parts based on audio volume level
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 | |
| IN=$1 | |
| OUT=$2 | |
| true ${SD_PARAMS:="-55dB:d=0.3"}; | |
| true ${MIN_FRAGMENT_DURATION:="20"}; | |
| export MIN_FRAGMENT_DURATION | |
| if [ -z "$OUT" ]; then |
chapmanjacobd
/ geo_update_trigger.sql
Created
February 2, 2019 07:38
— forked from mmohiudd/geo_update_trigger.sql
Update geometry and geography data with a trigger for PostgreSQL(PostGIS)
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
| DROP TABLE IF EXISTS test_table; | |
| CREATE TABLE test_table( | |
| id bigserial NOT NULL, | |
| latitude double precision, | |
| longitude double precision, | |
| geom geometry, | |
| geog geography, | |
| updated_ts double precision, | |
| CONSTRAINT test_table_unique_key UNIQUE (id) | |
| ); |