Đỗ Thành Long soiqualang

Alt + F11

Sub Paste_OneCell()

    'Copy and Paste 1 Cell
    'Range("A1").Copy Range("B1")

    'Cut and Paste 1 Cell
    'Range("A1").Cut Range("B1")

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.

WMS/WFS server | What's another MapServer, GeoServer?

Tôi đang tìm kiếm một giải pháp WMS/WFS server khác mà không dùng MapServer hay GeoServer, đơn giản trong cài đặt và hiệu quả trong sử dụng.

https://stackoverflow.com/questions/5334378/wms-wfs-server-am-i-crazy-to-write-my-own

https://github.com/infostreams/mbtiles-php/

Max files per directory on NTFS vol vs FAT32

After a quick search on google I found these:

FAT32

Maximum disk size: 2 terabytes
Maximum file size: 4 gigabytes
Maximum number of files on disk: 268,435,437
Maximum number of files in a single folder: 65,534

Zip file by command line

Window

Install 7zip

7z a -tzip {yourfile.zip} {yourfolder}
7z a -tzip nongnghiep_vn.zip nongnghiep_vn.sql

Change password postgresql

psql --help

Connection options:
  -h, --host=HOSTNAME      database server host or socket directory (default: "local socket")
  -p, --port=PORT          database server port (default: "5432")
  -U, --username=USERNAME  database user name (default: "ictla")
 -w, --no-password never prompt for password

Get the position of a div/span tag

function getPos(el) {
    // yay readability
    for (var lx=0, ly=0;
         el != null;
         lx += el.offsetLeft, ly += el.offsetTop, el = el.offsetParent);
    return {x: lx,y: ly};
}

	## 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')