Skip to content

Instantly share code, notes, and snippets.

View smellman's full-sized avatar

Taro Matsuzawa aka. btm smellman

141 followers · 9 following
View GitHub Profile
@smellman
smellman / openmaptiles-log-20200708.txt
Created July 11, 2020 06:09
openmaptiles logs 20200708
====> : Start SQL postprocessing: ./build/sql/* -> PostgreSQL
: Source code: https://github.com/openmaptiles/openmaptiles-tools/blob/master/bin/import-sql
Starting postgres docker compose target using default image (no recreate if exists)
Starting openmaptiles_postgres_1 ... done
docker-compose run --rm -u 1000:1000 openmaptiles-tools sh -c 'pgwait && import-sql' | \
awk -v s=": WARNING:" '$0~s{print; print "\n*** WARNING detected, aborting"; exit(1)} 1'
Importing /usr/src/app/sql/CleanNumeric.sql (md5 d8300fc8b346b6288993391fb4f3c31d - 18 lines) into Postgres...
Timing is on.
CREATE FUNCTION
Time: 11.222 ms
@smellman
smellman / Dockerfile
Created June 17, 2020 07:24
Sphinx + plantuml
FROM sphinxdoc/sphinx-latexpdf
WORKDIR /docs
RUN mkdir -p /usr/share/man/man1
RUN apt-get update \
&& apt-get install -y \
default-jre \
&& apt-get autoremove \
@smellman
smellman / my-postgres.conf
Created April 17, 2020 00:40
# DB Version: 12
# OS Type: linux
# DB Type: web
# Total Memory (RAM): 16 GB
# CPUs num: 12
# Connections num: 100
# Data Storage: ssd
max_connections = 100
shared_buffers = 4GB
@smellman
smellman / shinjuku-station-area.geojson
Created March 12, 2020 14:28
shinjuku station area
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@smellman
smellman / tokyo_station_area.geojson
Created March 12, 2020 14:16
tokyo station area
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@smellman
smellman / shinjuku.geojson
Created March 12, 2020 05:47
新宿
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@smellman
smellman / Makefile
Created March 1, 2020 09:58
docker-postgis #176
VERSIONS = $(foreach df,$(wildcard */Dockerfile),$(df:%/Dockerfile=%))
REPO_NAME ?= postgis
IMAGE_NAME ?= postgis
GIT=git
OFFIMG_LOCAL_CLONE=$(HOME)/official-images
OFFIMG_REPO_URL=https://github.com/docker-library/official-images.git
UNAME := $(shell uname)
build: $(VERSIONS)
@smellman
smellman / sakan_osm.svg
Created February 22, 2020 06:58
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@smellman
smellman / import_osm.sh
Created February 11, 2020 03:52
OpenMapTiles: Import OSM without quickstart.sh
#!/bin/bash
set -o errexit
set -o pipefail
set -o nounset
if [ $# -eq 0 ]; then
echo "you need to set version"
echo "example: $0 3.9"
exit 1
else
@smellman
smellman / invalid_fude.txt
Created January 1, 2020 01:12
筆ポリゴンでスペースが入って処理できないやつ一覧
Unable to open datasource `./26京都府2019/26201福知山市' with the following drivers.
Unable to open datasource `2019/26201福知山市2019_5.shp' with the following drivers.
Unable to open datasource `./26京都府2019/26214木津川市' with the following drivers.
Unable to open datasource `2019/26214木津川市2019_5.shp' with the following drivers.
Unable to open datasource `./26京都府2019/26344宇治田原町' with the following drivers.
Unable to open datasource `2019/26344宇治田原町2019_5.shp' with the following drivers.
Unable to open datasource `./26京都府2019/26407京丹波町' with the following drivers.
Unable to open datasource `2019/26407京丹波町2019_5.shp' with the following drivers.