Skip to content

Instantly share code, notes, and snippets.

View soiqualang's full-sized avatar
🙃
hihihaha

Đỗ Thành Long soiqualang

🙃
hihihaha
View GitHub Profile
-- Tim kiem cac cua hang TGDĐ cach 1000m
SELECT * FROM hcm_tgdd WHERE ST_DWithin(
    ST_Transform(geom, 32648),
    ST_Transform(ST_SetSRID(ST_Point(106.69093,10.77082), 4326), 32648),
    1000
);

-- Tao diem tu toa do
SELECT ST_SetSRID(ST_Point(106.69093, 10.77082), 4326);
@soiqualang
soiqualang / ghep_mang.js
Created April 12, 2024 08:43
So sanh va ghep mang
var doman_v1 = [
['recid', 'Year', 'Income', 'Type', 'Time'],
[42, '2011-05-01', '', 'doman', 1304182800000],
[41, '2012-01-01', '26', 'doman', 1325350800000],
[40, '2012-02-01', '234', 'doman', 1328029200000],
[39, '2012-03-01', '12', 'doman', 1330534800000],
[36, '2013-01-01', '', 'doman', 1356973200000],
[35, '2013-02-01', '267', 'doman', 1359651600000],
];
@soiqualang
soiqualang / blur_unblur_fb_mess.js
Last active March 26, 2024 09:19
blur_unblur_fb_mess
// Cái hàm để add sự kiện
function toggle_blur(messDiv){
// Add event listeners to handle hover effect
messDiv.addEventListener("mouseover", function() {
this.style.filter = "none"; // Remove blur on hover
});
messDiv.addEventListener("mouseout", function() {
this.style.filter = "blur(5px)"; // Add blur when not hovering
});
@soiqualang
soiqualang / liz.sh
Created January 13, 2024 15:25 — forked from mdouchin/liz.sh
PostgreSQL/PostGIS in Termux: help script to install and manage PostgreSQL & PostGIS
#!/usr/bin/env bash
COMMAND="$1"
shift
function liz_storage() {
echo "Storage - configure termux setup storage"
termux-setup-storage
}
@soiqualang
soiqualang / seed-cache.html
Created August 16, 2023 06:19 — forked from jelmervdl/seed-cache.html
Geoserver Tile Cache seeding tool
<!DOCTYPE html>
<html>
<head>
<title>Seed tool</title>
<style>
.seed-status {
display: inline-block;
padding; 2px;
background: #ccc;
}
@soiqualang
soiqualang / GeoServer GWC REST Example
Created August 16, 2023 06:13 — forked from alexgleith/GeoServer GWC REST Example
Truncate and Seed GWC cached layers in GeoServer
import json
import urllib2
import base64
baseURL = "https://domain.example:8080/geoserver/gwc/rest/seed/"
descURL = "https://domain.example:8080/geoserver/gwc/rest/layers/"
un = 'username'
pw = 'biglongtrickypassword'
def truncateLayer(layer):
@soiqualang
soiqualang / GeoWebCacheService.py
Created August 16, 2023 06:12 — forked from gordcorp/GeoWebCacheService.py
Empty and reseed GeoServer GeoWebCache
import requests
class GeoWebCacheService(object):
"""Class to communicate with the geowebcache api.
Api doco here: http://geowebcache.org/docs/current/rest/seed.html
"""
_url = None
_username = None
_password = None
@soiqualang
soiqualang / mbtile-server.py
Created August 7, 2023 14:33 — forked from schoenobates/mbtile-server.py
Really quick and dirty way to serve tiles from a MBTiles file
#!/usr/bin/env python
from BaseHTTPServer import BaseHTTPRequestHandler, HTTPServer
import re
import sqlite3 as sqlite
# Hacky serving of MBtile data
# Put filename to the MBTiles file below: this could be done with cmd line options
# but this is a hack so there ....
@soiqualang
soiqualang / Install Android apps or apk files in Windows using Windows Subsystem for Android (No Emulator).md This Guide will show you how to install and run apk files or Android apps in any Edition of Windows 11 using Windows Subsystem for Android. WSA or Windows Subsystem for Android is a Tool that allows Windows to run Android Apps directly without using any emulator.

Install Android apps or apk files in Windows using Windows Subsystem for Android

WSA or Windows Subsystem for Android is a Tool that allows Windows to run Android Apps directly without using any emulator. The problem is Windows Subsystem for Android is currently only available through preview via the Beta Channel of the Windows Insider Program. But if you follow my guide, you don't have to be in Windows Insider Program to try it out. The only thing you need is Windows 11 installed and some patience.

Prerequisites:

  • Windows Subsystem for Android or WSA must be Installed.

Click here to view the guide that shows how to install Windows Subsystem for Android in any Edition of Windows 11 (including Windows 11 Home) non Inider or stable release.

How to Install Android Apps or apk files in Windows Subsystem for Android:

@soiqualang
soiqualang / docker-compose.yml
Created February 23, 2023 04:43
nginx-proxy-manager | -p 80:80 -p 81:81 -p 443:443
version: '3'
services:
app:
image: 'jc21/nginx-proxy-manager:latest'
restart: always
ports:
- '80:80'
- '1084:81'
- '443:443'
volumes: