Howard Lee Cloud

學習 How to Copy PostGIS Table Data to Another Table

By Howard Lee 21 April 2022

I want to copy data in a table within postgis to another table, so I use following sql statement: INSERT INTO yourtablename (SELECT TO_DATE(name, 'YYYY-MM-DD'), TO_NUMBER(area, '9999999999.999999999'), TO_NUMBER(fd_depth, '9999'), TO_DATE(fdate, 'YYYY-MM-DD'), town_name, address, description, effect_range FROM yourtmptablename); Notice: Before you executing above snippet, please make sure yourtablename has same column names as output of column names from SELECT statement. I have encounter data format problem about “-"(hyphen) for numeric column

心得 How to Convert KML File to PostgreSQL, CSV or SHP format by ogr2ogr within QGIS-LTR | 如何使用 QGIS-LTR 裡的 ogr2ogr 程式，轉換 KML 檔案到 PostgreSQL, CSV 或是 SHP 格式

By Howard Lee 17 April 2022

I want to convert data with a KML file to another one with CSV-, SQL- and SHP-format using ogr2ogr, but I encounter the problem about loosing content of KML file what I want. This article is for describing what problems are and what solutions can used for overcome. Problem 1: I can use GUI-based software, which name is QGIS-LTR, with command parameters of ogr2ogr to successfully transform a file from

心得 Tutorial of Basic GraphQL API Service Setup

By Howard Lee 13 March 2022

I had been heard that GraphQL is a great tool for web frontend engineer because frontend engineer can query any form of data for variable needs of mobile-web and app. I want to explore GraphQL how to use, which ecosystem is becoming matured. In this article, we will go through it, and please following indexes. You can learn how to setup basic GraphQL API server without throttling. Article Index Introduction

學習 Fix Nodejs Graphql Circular Import

By Howard Lee 04 March 2022

Circular import components are common within nodejs and graphql. This article provide a easy way to resolve that warning. The easy solution is adding related imports to limited scope in javascript instead of importing them at file start position. The example scenario contains three parts: User, Role and UserRoleRel. An user has many roles and a role has many user had been taken. The relationship of many-to-many is recorded at

心得 MacOS Monterey(12.1) Use Openssl3.0

By Howard Lee 15 January 2022

I had found following problem as I install packages of python on macOS Monterey(12.1) by using a third party script: zipfile = ZipFile(StringIO(fp.read())) .pyenv/versions/2.7.18/lib/python2.7/socket.py", line 355, in read data = self._sock.recv(rbufsize) .pyenv/versions/2.7.18/lib/python2.7/ssl.py", line 754, in recv return self.read(buflen) .pyenv/versions/2.7.18/lib/python2.7/ssl.py", line 641, in read v = self._sslobj.read(len) ssl.SSLError: [SSL: KRB5_S_TKT_NYV] unexpected eof while reading (_ssl.c:1946) Briefly analysis for root-cause about this problem This is because macOS upgrade openssl to version 3.0.0

學習 Read Book 2022 | 2022 年我讀過的書

By Howard Lee 06 January 2022

2022 年讀過的書: 灰階思考。(2021 年 9 月購買, 2021 年 12 月下旬開始讀，2022 年 1 月 6 日看完) podcast 頻道：股癌的整理內容講投資心態和理財的原則被討厭

About

Category

Tag

Social