soiqualang

## README.md

      
              5 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                soiqualang
                / README.md
            
            
              Created Aug 15, 2021
                — forked from FMCorz/README.md
            
              
                Adminer with SQLite no-login
              
          
      View README.md
  
      
    Adminer setup
Enables plugins, and SQLite no-login.
Instructions

Copy index.php to a new directory
Download Adminer to adminer.php


## postgis2shp.py
#### Author: Justin Lewis
#### This script can be used to export a single pg table to shapefile.
####
#### Developed in a linux environment but should require minimal modification to run on other platforms.
####
#### Dependancies:
###### fwtools (gdal > ogr2ogr), PostGIS database, Python, PyGreSQL

import os, _pg

## docker-on-android.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                soiqualang
                / docker-on-android.md
            
            
              Created May 11, 2021
                — forked from arno01/docker-on-android.md
            
              
                Docker on Android
              
          
      View docker-on-android.md
  
      
    WORK IN PROGRESS
Docker on Android
Setup:
Samsung Galaxy Tab S5e SM-T720
Android Pie on Linux 4.9.112 (not rooted)
Termux


## osgeo_compile.sh
# Compile/install GEOS. Taken from:
# http://grasswiki.osgeo.org/wiki/Compile_and_Install_Ubuntu#GEOS_2

cd /tmp
wget http://download.osgeo.org/geos/geos-3.4.2.tar.bz2
bunzip2 geos-3.4.2.tar.bz2
tar xvf  geos-3.4.2.tar

cd geos-3.4.2

## selenium.py
# install chromium, its driver, and selenium
!apt update
!apt install chromium-chromedriver
!pip install selenium
# set options to be headless, ..
from selenium import webdriver
options = webdriver.ChromeOptions()
options.add_argument('--headless')
options.add_argument('--no-sandbox')
options.add_argument('--disable-dev-shm-usage')

## dirname-filename-basename.bat
set filepath="C:\some path\having spaces.txt"

for /F "delims=" %%i in (%filepath%) do set dirname="%%~dpi"
for /F "delims=" %%i in (%filepath%) do set filename="%%~nxi"
for /F "delims=" %%i in (%filepath%) do set basename="%%~ni"

echo %dirname%
echo %filename%
echo %basename%

## HTML Application.hta
<html>
  <head>
	<!--
	@tag hta:application

	@attribute ApplicationName	Sets the name of the HTA.

	@attribute Border			[Thick]|Thin|None
	@attribute BorderStyle		[Normal]|Raised|Sunken|Complex|Static
	@attribute Caption			[Yes]|No

## xyz_vs_tms.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                soiqualang
                / xyz_vs_tms.md
            
            
              Created Dec 4, 2020
                — forked from tmcw/xyz_vs_tms.md
            
              
                The difference between XYZ and TMS tiles and how to convert between them
              
          
      View xyz_vs_tms.md
  
      
    The difference between XYZ and TMS tiles and how to convert between them
Lots of tile-based maps use either the XYZ or TMS scheme. These are the maps that have tiles
ending in /0/0/0.png or something. Sometimes if it's a script, it'll look like
&z=0&y=0&x=0 instead. Anyway, these are usually maps in Spherical Mercator.
Good examples are OpenStreetMap, Google Maps, MapBox, MapQuest, etc. Lots of maps.
Most of those are in XYZ. The best documentation for that is slippy map tilenames on the OSM Wiki, and Klokan's Tiles a la Google.

  
## GitDeleteCommands.ps1
## Delete a remote branch
$ git push origin --delete <branch> # Git version 1.7.0 or newer
$ git push origin :<branch> # Git versions older than 1.7.0

## Delete a local branch
$ git branch --delete <branch>
$ git branch -d <branch> # Shorter version
$ git branch -D <branch> # Force delete un-merged branches

## Delete a local remote-tracking branch

## wfs_download.py
from owslib.fes import *
from owslib.etree import etree
from owslib.wfs import WebFeatureService
wfs11 = WebFeatureService(url='http://example.com:8080/geoserver/wfs/', version='1.1.0')

f = open('download.sh', 'wb')
f.write('#!/bin/bash'+'\n')
f.write(''+'\n')
	#### Author: Justin Lewis
	#### This script can be used to export a single pg table to shapefile.
	####
	#### Developed in a linux environment but should require minimal modification to run on other platforms.
	####
	#### Dependancies:
	###### fwtools (gdal > ogr2ogr), PostGIS database, Python, PyGreSQL

	import os, _pg
	# Compile/install GEOS. Taken from:
	# http://grasswiki.osgeo.org/wiki/Compile_and_Install_Ubuntu#GEOS_2

	cd /tmp
	wget http://download.osgeo.org/geos/geos-3.4.2.tar.bz2
	bunzip2 geos-3.4.2.tar.bz2
	tar xvf geos-3.4.2.tar

	cd geos-3.4.2
	# install chromium, its driver, and selenium
	!apt update
	!apt install chromium-chromedriver
	!pip install selenium
	# set options to be headless, ..
	from selenium import webdriver
	options = webdriver.ChromeOptions()
	options.add_argument('--headless')
	options.add_argument('--no-sandbox')
	options.add_argument('--disable-dev-shm-usage')
	set filepath="C:\some path\having spaces.txt"

	for /F "delims=" %%i in (%filepath%) do set dirname="%%~dpi"
	for /F "delims=" %%i in (%filepath%) do set filename="%%~nxi"
	for /F "delims=" %%i in (%filepath%) do set basename="%%~ni"

	echo %dirname%
	echo %filename%
	echo %basename%
	<html>
	<head>
	<!--
	@tag hta:application

	@attribute ApplicationName Sets the name of the HTA.

	@attribute Border [Thick]\|Thin\|None
	@attribute BorderStyle [Normal]\|Raised\|Sunken\|Complex\|Static
	@attribute Caption [Yes]\|No
	## Delete a remote branch
	$ git push origin --delete <branch> # Git version 1.7.0 or newer
	$ git push origin :<branch> # Git versions older than 1.7.0

	## Delete a local branch
	$ git branch --delete <branch>
	$ git branch -d <branch> # Shorter version
	$ git branch -D <branch> # Force delete un-merged branches

	## Delete a local remote-tracking branch
	from owslib.fes import *
	from owslib.etree import etree
	from owslib.wfs import WebFeatureService
	wfs11 = WebFeatureService(url='http://example.com:8080/geoserver/wfs/', version='1.1.0')

	f = open('download.sh', 'wb')
	f.write('#!/bin/bash'+'\n')
	f.write(''+'\n')