Adminer setup
Enables plugins, and SQLite no-login.
Instructions
- Copy
index.php
to a new directory - Download Adminer to
adminer.php
Enables plugins, and SQLite no-login.
index.php
to a new directoryadminer.php
#### 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 |
Setup:
Samsung Galaxy Tab S5e SM-T720
Android Pie on Linux 4.9.112 (not rooted)
Termux
# 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 |
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.
## 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') |