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 / MSSQLSpatial.md
Last active September 5, 2019 04:30
[OGR2OGR] MSSQLSpatial - Microsoft SQL Server Spatial Database

[OGR2OGR] MSSQLSpatial - Microsoft SQL Server Spatial Database

Creating a layer from an OGR data source

ogr2ogr -overwrite -f MSSQLSpatial "MSSQL:server=.\MSSQLSERVER2008;database=geodb;trusted_connection=yes" "rivers.tab"

Connecting to a layer and dump the contents

ogrinfo -al "MSSQL:server=.\MSSQLSERVER2008;database=geodb;tables=rivers;trusted_connection=yes"

@soiqualang
soiqualang / Ionic_install Android_platform_notes.md
Created October 11, 2019 10:44

Instal on Linux notes

sudo chmod -R 777 /home/soiqualang/.npm
npm i -g cordova-res
sudo chown -R $USER:$(id -gn $USER) /home/soiqualang/.config
sudo chmod -R 777 /opt/lampp/htdocs/test_ionic/
ionic cordova resources android --force
@soiqualang
soiqualang / img_lst.sql
Last active July 6, 2020 08:07
Make and Update SEQUENCE in PostgreSQL - GeoServer WMST with Image mosaicking plugin
-- Adminer 4.6.3 PostgreSQL dump
DROP TABLE IF EXISTS "img_lst";
DROP SEQUENCE IF EXISTS raster.img_lst_fid_seq;
CREATE SEQUENCE raster.img_lst_fid_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
CREATE TABLE "raster"."img_lst" (
"fid" integer DEFAULT nextval('raster.img_lst_fid_seq') NOT NULL,
"the_geom" public.geometry(Polygon,32648),
"location" character varying(255),
@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 / 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;
}