Skip to content

Instantly share code, notes, and snippets.

View soiqualang's full-sized avatar
🙃
hihihaha

Đỗ Thành Long soiqualang

🙃
hihihaha
42 followers · 67 following
View GitHub Profile
@soiqualang
soiqualang / angularjs_watch_multi_variable.html
Created November 12, 2019 04:31
How to $watch multiple variable change in AngularJs
<!DOCTYPE html>
<html>
<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.6.9/angular.min.js"></script>
<body>
<div ng-app="myApp" ng-controller="myCtrl">
<p>var1: <input type="text" ng-model="var1"></p>
<p>var2: <input type="text" ng-model="var2"></p>
<p>var3: <input type="text" ng-model="var3"></p>
@soiqualang
soiqualang / qgis_arcgis_replace.md
Created November 13, 2019 02:18
Replace in QGIS and ArcGIS

replace in qgis

case when "Loai_hinh" is 'Nha hang' then replace("Loai_hinh",'Nha hang','Nhà hàng') else "Loai_hinh" end

replace in arcgis

Replace([ten_truong],"old_value","new_value")
Replace( [Vehicle_1] ,0,"NULL")
@soiqualang
soiqualang / psql_create_bbox_column.sql
Created November 13, 2019 02:19
PostgrteSQL/ PostGIS create bbox column
SELECT
gid,
"OBJECTID",
"MA_DVHCP",
ten_quan,
"Shape_Leng",
"Shape_Area",
the_geom,
imgvitri,
id,
@soiqualang
soiqualang / psql_spatial_query.sql
Created November 13, 2019 02:51
PostGIS - Spatial query: #st_intersection #st_difference #st_union #st_symdifference
POLYGON((104.91514205932 19.444427490235, 104.51963424682 19.224700927735, 104.53062057495 18.73031616211, 104.93711471557 18.367767333985, 105.77207565307 18.499603271485, 105.58530807495 19.070892333985, 104.91514205932 19.444427490235))
POLYGON((105.22275924682 19.74105834961, 105.06895065307 19.070892333985, 105.59629440307 18.301849365235, 106.29941940307 18.477630615235, 106.38731002807 18.90609741211, 105.57432174682 19.76303100586, 105.22275924682 19.74105834961))
LINESTRING(104.23398971557 18.86215209961, 106.49717330932 19.356536865235)
POINT(105.42051315307 18.873138427735)
--st_intersection
select st_intersection(GeomFromEWKT('SRID=4326;POLYGON((104.91514205932 19.444427490235, 104.51963424682 19.224700927735, 104.53062057495 18.73031616211, 104.93711471557 18.367767333985, 105.77207565307 18.499603271485, 105.58530807495 19.070892333985, 104.91514205932 19.444427490235))'),GeomFromEWKT('SRID=4326;POLYGON((105.22275924682 19.74105834961, 105.06895065307 19.070892333985, 105.59629440307 18.3018
@soiqualang
soiqualang / psql_excel_csv.md
Created November 13, 2019 03:00
PostgreSQL VS Excel, CSV

psql2csv

COPY texexcel FROM 'D:\tmp\QuyTrinh_Full_v2_2.csv' WITH CSV HEADER; --chay ok COPY "CongDoan"("CongDoanID","TenCongDoan","HanhDong","Thutu","ThoiGianToiDa","NhomID","GhiChu","QuiTrinhID") FROM 'D:\tmp\QuyTrinh_Full_v2_2.csv' CSV HEADER DELIMITER ',';

psql2csv

copy dbo."DoanhNghiep" to 'C:\Users\Administrator\Desktop\l4\doanhnghiep.csv' csv;

csv2psql

COPY dbo."DoanhNghiep" FROM 'D:\tmp\doanhnghiep.csv' WITH CSV HEADER;

@soiqualang
soiqualang / XYZ Tiles base map on QGIS Server.txt
Created November 13, 2019 03:10
XYZ Tiles base map on QGIS Server
XYZ Tiles base map on QGIS Server
http://dev.dothanhlong.org/cgi-bin/xyz_tiles/qgis_mapserv.fcgi?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetCapabilities
http://qgs.webmapp.it/cgi-bin/test/qgis_mapserv.fcgi?MAP=/usr/lib/cgi-bin/test/xyz_tiles.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=1174461,5729736,1175761,5731386&CRS=EPSG:3857&WIDTH=491&HEIGHT=624&LAYERS=OpenStreetMap&FORMAT=image/png
http://qgs.webmapp.it/cgi-bin/test/qgis_mapserv.fcgi?MAP=/usr/lib/cgi-bin/test/xyz_tiles.qgs&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=1174461,5729736,1175761,5731386&CRS=EPSG:3857&WIDTH=491&HEIGHT=624&LAYERS=WebMapp_Tiles&FORMAT=image/png
@soiqualang
soiqualang / postgresql-set-id-seq.sql
Created August 8, 2019 07:32 — forked from henriquemenezes/postgresql-set-id-seq.sql
PostgreSQL set Next ID Sequence Value to MAX(id) from Table
-- Get Max ID from table
SELECT MAX(id) FROM table;
-- Get Next ID from table
SELECT nextval('table_id_seq');
-- Set Next ID Value to MAX ID
SELECT setval('table_id_seq', (SELECT MAX(id) FROM table));
@soiqualang
soiqualang / GoogleSpreadsheet.html
Created February 5, 2020 04:00 — forked from terrywbrady/GoogleSpreadsheet.html
Sample HTML/JS to parse a Google Spreadsheet
<!doctype html>
<html>
<head>
<script src="//ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<script type="text/javascript">
var spData = null;
function doData(json) {
spData = json.feed.entry;
}
@soiqualang
soiqualang / pg_add_fkey.sql
Created February 11, 2020 03:49
PostgreSQl add FOREIGN KEY
ALTER TABLE congtrinh.dap_hientrang_table
ADD CONSTRAINT dap_hientrang_table_maso_huyen_fkey FOREIGN KEY (maso_huyen) REFERENCES bandonen.hanhchinh_huyen_polygon(maso);
@soiqualang
soiqualang / filterObject.js
Created February 12, 2020 10:31
filter Object in Javascript
const developers = {
1: {
id: 1,
name: "Brendan",
family: "Eich"
},
2: {
id: 2,
name: "John",
family: "Resig"