2017 歐洲旅行之流水帳2017-07-06
Private Content
Place Report development2016-09-27
Place.Report development
URL->https://place.report/
1. Website statement:
1. Place.Report is a Google map API application which helps Sales to identify possible local customers.
2. Place.Report was an idea came out while developing the StreetView.cc website, both websites apply the same algorithm but pick up different target audiences.
--
2. Release Note
First released on 9/27, 2016 v2.0 (from streetview v1.3)
a. Functions:
[Public] Target Area Search, Store Search, Place.Report
[Priviate] MyPlaces, Place.Rank
b. Support Countries:
US, United States
TW, Taiwan
c. Target Audiences:
Sales: door-to-door, telephone
Marketing company
Local store owners
d. Keywords:
Geomarketing, Store Research, Marketing ROI measurement
--
3. Bug Report / Discussion
Please leave a comment below if there was an issue or anything you would like to discuss
IP 全球地理位置資料庫開發日誌2016-09-06
IP 全球地理位置資料庫開發日誌
話說從頭, 這是中文式流水帳。
開發的綠起是為了把 streetview.cc 的入口寫的完美一些,
所以在網路上找了些免費的 IP 資料庫來使用,
想利用 IP 來定位 Google maps 的起始位置。
開始先找到的是 MaxMind 的 GeoLite2 (GeoIP2免費版),
接著就花了點時間把將近三百萬筆資料寫進 MySql 裡,
接著隨機性的測試一下, 還可以哇!!
然後發現怎麼故鄉台灣的IP都只能定位到陳有蘭溪??
稍稍研究之後, 原來似乎還沒有人把台灣的IP區段給補完, (人才都跑那去了?)
也許警政或調查機關有, 不過我沒有找到就是了~~
最接近的就是 IPIP.net 的創辦人高先生在今年初時自己的微博說:
「 嗯，就在刚才，已经把手里的台湾的IP 库地级市和区县库数据都搞定了，貌似这个是全球独一份吧？台湾本地公司都没有。。」
哇, 牛人說牛話了, 於是我花了點時間在 IPIP.net 上撈了一份 17monipdb 做再開發。
只是 17monipdb 可能是免費的關係, 數據上有些許錯誤,
不過對於鑑別中國IP的地理應該還是可以的,
所以我就花了點時間把 17monipdb的結果(中國) 整合到 GeoLite2 之中。
然而, 這並沒有解決陳有蘭溪的問題。
我又把念頭放到再來轉個資料庫看看, 查了查。決定就是你了!!
IP2LOCATION 上吧!! (其實真沒有幾家有開源的)
抓回來一看, 天啊!! 4百多萬筆資料啊!!
不過有了匯入 GeoIP2 的經驗, 不怕不怕。
花了些時間等待匯入資料庫後, 交叉比對目前這兩大開源的資料庫如下:
從上表可知, IP2LOCATION 對於IP表切得較細, 不過對於地理地址定位來說, GeoIP2 的比較齊全,
另外IP2LOCATION是只有一張資料表, 在執行上的效率較差, GeoIP2是兩張表格, 效率較好。
理想的作法應該是採用 GeoIP2 的資料結構, 補上 IP2LOCATION 的有效資料。
雖然這樣能解決陳有蘭溪的問題, 不過我得回頭做別的事了。
目前的作法是把IP2LOCATION列為參考資料, 待有空或是有想法時再將兩個資料庫整合再一起囉。
未來的開發的意向大概就是把兩個資料庫截長補短, 然後整合進一個台灣的IP區段, 為家鄉盡一份心力;
然後再加上 Google maps 的定位去自動資料庫的校正和補充。就算大功告成啦~
現就以此文將此開發暫告一段落; 我得來繼續寫 streetview.cc 大數據!!
--
IP GeoLocation Service2016-08-29
IP GeoLocation Service development 中文版
http://ip.ymc2.com/
Website statement:
1. The ip.ymc2.com is a customized website for IP query purpose.
--
V1.3 Released on 9/6, 2016
1. Include a reference DB from ip2location.com, DB11 LITE
2. Optimize MySQL commands to shorten query time
3. Minor texts fixed.
V1.2 Released on 9/4, 2016
1. Include 17monipdb.dat (Open-Source Database of CHINA IP) to better locate location in China
2. Enable to display city name in both Chinese and English (CHINA only)
V1.1 Released on 8/30, 2016
1. Support Country-CountryName. US-> United States
2. Apply Country - Language- Googlemaps look-up to set default on Google maps UI
V1.0 Released on 8/29, 2016
Function: Giving an IP address, return its GeoLocation including City, Country and Latitude & Longitude. (and maybe other information as well)
Support: IPV4 format only.
API usage: Provide JSON result, but only for internal usage now.
Database & Tables :
1. GeoIP2
Version: 20160802 open-source
Max Note: 804,007 geo-location data, and 2,180,870 ip-blocks data were imported.
This product includes GeoLite2 data created by MaxMind, available from http://www.maxmind.com
2. IP2LOCATION LITE-DB11
Version: 20160901 open-source
Max Note: 4,016,410 data were imported.
This site or product includes IP2Location LITE data available from http://www.ip2location.com
3. 17monipdb:
Version: FREE 20160601
Max Note: This db is mainly to locate specific IP-address where $country=CN. Total 96,817 data were imported. (225 duplicate values on row startIpNum row; 2 duplicate values on row EndIpNum. Unable to setup primary key.)
The API includes 17monipdb.dat, 作者©高春辉, available from https://www.ipip.net/download.html
4. Googlemaps Languages Support list: Gmap-language.csv, source-> https://developers.google.com/maps/faq#languagesupport
5. a revised Country codes (ISO 3166) and official language table: country-language.csv, source-> http://download.geonames.org/export/dump/countryInfo.txt
6. a table to look-up locId with city name in Chinese and in English (China IP only) locId-cn_city.csv
Max Note: Please open it with Notepad before importing to your db. It includes Chinese characters.
--
Report Error: Please leave a comment below if there was an error result.
Six Flags Chicago 六旗芝加哥攻略2016-07-04
Six Flags Chicago 六旗芝加哥攻略
今天麥大叔要來寫一篇攻略, 造福在美國中西部的華人們。這趟我們兩人花了超過300美元在人最多的國慶周末抵達六旗芝加哥, 瘋狂玩了一整天之後, 頭昏昏有一些感想如下:
» Read More
mysql 改 mysqli 語法2016-03-30
自虐啊!!! 改什麼mysqli, 瘋了嗎?
寫mysql寫的好好的, 改個屁 mysqli!
好了, 以上發洩完畢, 為了及早準備PHP7.0的時代,
麥大叔這兩天花了點時間改了note資料庫的程式碼 (接下來還有幾個網站要改...哭哭)
主要異動是把即將缷任的mysql語句改為mysqli,
過程其實還好, 只要確定原本的輸出是什麼, mysqli 也能輸出同樣的東西即可。
比較麻煩的是取出多筆資料時要做的迴圈, 會需要一些改變。
心得
1. mysqli 語法改用物件的方式寫會比較順利
$link = @mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
$db = new mysqli(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME);
2. mysqli 多筆資料時的輸出情況, 以fetch_object做廻圈, 再用json去轉陣列
3. SQL語法包括UPDATE, INSERT INTO時, 宣告字碼 utf8, 避免存入亂碼
$db->set_charset("utf8");
以上, 供後人參考!
寫mysql寫的好好的, 改個屁 mysqli!
好了, 以上發洩完畢, 為了及早準備PHP7.0的時代,
麥大叔這兩天花了點時間改了note資料庫的程式碼 (接下來還有幾個網站要改...哭哭)
主要異動是把即將缷任的mysql語句改為mysqli,
過程其實還好, 只要確定原本的輸出是什麼, mysqli 也能輸出同樣的東西即可。
比較麻煩的是取出多筆資料時要做的迴圈, 會需要一些改變。
心得
1. mysqli 語法改用物件的方式寫會比較順利
$link = @mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
$db = new mysqli(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME);
2. mysqli 多筆資料時的輸出情況, 以fetch_object做廻圈, 再用json去轉陣列
$result = $db->query($sql);
if($result){
while ($row = $result->fetch_object()){ // Cycle through results
$stdClass[] = $row;
}
$result->close(); // Free result set
}
$val = json_decode(json_encode($stdClass), true); //Transform stdClass to Array
$val = array_map('array_values', $val); //remove Key of the Array (may not required)
if($result){
while ($row = $result->fetch_object()){ // Cycle through results
$stdClass[] = $row;
}
$result->close(); // Free result set
}
$val = json_decode(json_encode($stdClass), true); //Transform stdClass to Array
$val = array_map('array_values', $val); //remove Key of the Array (may not required)
3. SQL語法包括UPDATE, INSERT INTO時, 宣告字碼 utf8, 避免存入亂碼
$db->set_charset("utf8");
以上, 供後人參考!
文字樣式作弊表2016-03-28
文字樣式作弊表 - 僅供 Max Chen website 文字部份使用. 使用方式 span class="xx"
標題
v1
underline,bolder,16pt
v2
border-bottom,15pt
內文
t1
藍底白字 : 使用在某種程度的高光顯示
t2
黃底紅字: 不太確定該怎麼使用
t3
黃底: 一般程度的高光顯示
t4
灰色刪除線: 使用在某種需留住但不重要或是有笑果的時候
coding 程式碼專用
自定情況: 就自定吧
標題
v1
underline,bolder,16pt
v2
border-bottom,15pt
內文
t1
藍底白字 : 使用在某種程度的高光顯示
t2
黃底紅字: 不太確定該怎麼使用
t3
黃底: 一般程度的高光顯示
t4
灰色刪除線: 使用在某種需留住但不重要或是有笑果的時候
coding 程式碼專用
$result = $db->query($sql);
if($result){
while ($row = $result->fetch_object()){ // Cycle through results
$stdClass[] = $row;
}
$result->close(); // Free result set
}
$val = json_decode(json_encode($stdClass), true); //Transform stdClass to Array
$val = array_map('array_values', $val); //remove Key of the Array (may not required)
if($result){
while ($row = $result->fetch_object()){ // Cycle through results
$stdClass[] = $row;
}
$result->close(); // Free result set
}
$val = json_decode(json_encode($stdClass), true); //Transform stdClass to Array
$val = array_map('array_values', $val); //remove Key of the Array (may not required)
自定情況: 就自定吧
StreetView.cc Development Diary2016-03-15
Streetview.cc Development Diary
Kind of a note to memorize something that I may forget in few days after....
Ver 2.1 Released:
Public
StreetView: Display places with Google See-Inside features.
Coverage: Reveal areas which have been scanned by system.
SeeInside: SeeInside a place with the UI combines Google maps(pegman) and its StreetView image on the same page.
Private
SECRETS
Website Version
2016/10/07 - Ver 2.1 Released. all major function revised.
2016S2S3 - Development https://Place.Report website
2016/4/13 - Revise See-Inside judgement programming (v1.1)
2016/4/12 - Comment_Service implemented
2016/4/01 - Ver 1.3 Released. mysqli implemented
2016/3/25 - Ver 1.2 Released. New function: mapScan, Providing Linear and area two types scanning.
2016/3/22 - Website Automation Test Success!!
2016/3/17 - Improve processing efficiency by using curl instead of file_get_contents
2016/3/15 - Big-Data Place Report trial. (providing Place Ranks)
2016/3/12 - Ver 1.1 Released. New functions: Coverage, PlaceRank, SeeInside
2016/3/12 - Integrated g.ymc2.com, an URL Shorten API. a JSON application
2016/3/10 - Ver 1.0 released to DOMAIN: streetview.cc HOST: netfirms.com
Function: Home, OnePageReport, PlaceSearch, mapProcess
2016/3/01 Defined three modules, placeid, cid and cbk, to figure out if a store has the SEE-INSIDE feature or not.
2016/2/15 Start Coding .........A Google maps Javascript V3 Journey....
--
Problems/Issues/Improvements Ideas 2.1:
1. CSS Layout for mobile device. TBH, i don't really care about this for sure.
2. Google API limitation. a Major concerns
3. Facebook Graph API
Update Place.DB (Automatic and Manual)
Define a mid-term relationship for Place.DB and Seeing.DB (maybe a Pano.DB)?
Useful Statistic Data
Replace mysql to my_sqli sentence
Rethink the function: judge_seeinside, judgement see-inside...
Implement google analytic
IP rule for certain function
--
Major Fixed:
1. How to process place results generated by Google maps API (Async) to db?
-> 1) generate a click button within the async function.
-> 2) generate an auto-run php page.
2. How to curl the place results generated by Google maps API (async) to a html.element?
-> 1) Curl does not work on async page. (empty element)
-> 2) Include the Google maps API script on the parent page
3. Improve server efficiency:
-> A test reveals that curl is 50 percent faster than file_get_contents.
-> Replace file_get_contents with curl function.
4. Website automation test solution:
-> Tried Selenium webdriver, but was unable to figure out a way to make it work on wamp server.
-> Tried Selenium IDE, Works, however it had file size limits for processing codes(20KB?), and also there was no flow control (if-else) at the moment for testing purpose.
-> Turned out a solution which is to connect the server with localhost, and write php pages to the server via fopen(ftp), and then automatically run these pages to process results.
5. Encode the imgurl of all pano:
-> Applied JSON to communicate with g.ymc2.com (url shorten service)
6. fopen($ftp_path): failed to open stream at certain time ?
-> It seems like the hosting server issue (connection error or what?)
-> Use curl to do ftp method. (not sure if doing this is right, but it temporally works!)
7. The owner-response-rate (Google Reviews)
-> Find the recent 10 reviews and check to see if response from the owner exists
Google Place Big Data Report2016-03-06
PHP MySQL DB 資料庫網站開發2016-02-18
最近忙著和Google maps API奮鬥, 想寫一個跟街景有關的資料庫網站。(好痛苦啊! DOM完全不熟的說!)
不過今天突然心血來潮, 想回顧自己到底寫過幾組完整的PHP+MySQL網站，也一併回顧自己寫程式的來時路。
» Read More
Google Street View Image API 心得2016-02-10
最近開始研究 Google map 的一些API應用,
首先, 下圖是用 iframe 包圍的一張全景圖
位置接近於
緯度 45.832617
經度 6.8651769
朝向15.44度方向
視角是-5度 (朝下)
視野是100度
而根據以上這些數據, 就可以呼叫 Google Street View Image API 取出影像
呼叫方式 https://maps.googleapis.com/maps/api/streetview?參數
參數包括:
size: 長x寬 (影像大小)
location:經度,緯度 (影像位置)
fov: 20-120 (視野大小)
heading: 0-360 (方位)
pitch:-90-90 (視線角度)
根據 Google 官方文件 提到, 用 location 這個參數做定位時, 會找到最接近點的全景圖, 所以有不確定性。
建議是採用pano id的方式去做定位。
只不過 pano id要怎麼呼叫我查了老半天還是看不太懂, 先暫時寫到這裡, 後續有發現在補完。
= 2016 02.16 補充 =
pano id 的呼叫方式:
pano: #panoid
sensor: false (可忽略 App Key)
首先, 下圖是用 iframe 包圍的一張全景圖
位置接近於
緯度 45.832617
經度 6.8651769
朝向15.44度方向
視角是-5度 (朝下)
視野是100度
而根據以上這些數據, 就可以呼叫 Google Street View Image API 取出影像
呼叫方式 https://maps.googleapis.com/maps/api/streetview?參數
參數包括:
size: 長x寬 (影像大小)
location:經度,緯度 (影像位置)
fov: 20-120 (視野大小)
heading: 0-360 (方位)
pitch:-90-90 (視線角度)
根據 Google 官方文件 提到, 用 location 這個參數做定位時, 會找到最接近點的全景圖, 所以有不確定性。
建議是採用pano id的方式去做定位。
只不過 pano id要怎麼呼叫我查了老半天還是看不太懂, 先暫時寫到這裡, 後續有發現在補完。
= 2016 02.16 補充 =
pano id 的呼叫方式:
pano: #panoid
sensor: false (可忽略 App Key)
Google 推薦攝影師2015-10-13
Google 推薦攝影師服務
你想要採用Google街景的服務, 展示你的生意嗎? 試試下面的例子
Jade Mountain Café 玉山咖啡
2611 E Johnson St, Madison, WI 53704
2005年中成立 Snowforest LLC 的挺立與我(麥大叔), 目前皆為Google推薦攝影師, 我們目前正在協助威斯康辛本地的小型企業拓展他們的能見度, 包括了本地的中西式餐館, 禮品店, 婚紗店, 廚具店, 剌青店, 水煙店...等各式小生意作坊。
若你也是威斯康辛當地的華人, 經營一間實體店鋪, 歡迎您與我們連繫, 我們會協助您理解 Google 街景幫助推展店鋪的相關內容。
以下是Google推薦攝影師能為店鋪提供的幫助之重點提示:
» Read More
你想要採用Google街景的服務, 展示你的生意嗎? 試試下面的例子
Jade Mountain Café 玉山咖啡
2611 E Johnson St, Madison, WI 53704
2005年中成立 Snowforest LLC 的挺立與我(麥大叔), 目前皆為Google推薦攝影師, 我們目前正在協助威斯康辛本地的小型企業拓展他們的能見度, 包括了本地的中西式餐館, 禮品店, 婚紗店, 廚具店, 剌青店, 水煙店...等各式小生意作坊。
若你也是威斯康辛當地的華人, 經營一間實體店鋪, 歡迎您與我們連繫, 我們會協助您理解 Google 街景幫助推展店鋪的相關內容。
以下是Google推薦攝影師能為店鋪提供的幫助之重點提示:
» Read More
Google maps Sticker2015-10-01
Google maps Sticker
最近剛完成了 Google maps 的 window sticker,
整體設計的概念是藉著使用者經驗, 透過類似的圖像而去連結 Google maps 的一個概念。
稍稍修改了一個 Pegman 的圖示, 加上 Google maps 的 有名標示紅Pin; 最後放在三色地圖的底圖上。
文字訊息維持 simple is the best 的原則, 只宣傳需要傳遞的訊息。
然後之前寫的縮網址+QR-Code功能URL Shorten總算派上用場啦, 加上QR-code 在地宣傳 Snowforest。
以上就是這個貼紙的思考。
Embed Google Street View on the webpage2015-08-28
Here is an instruction which shows you how to embed a google street view tour on your website.
Step 1. Open the Google map on your browser, and Key in your business name on the Search tab.
Step 2. Click the See Inside tab, and then guide the Street View screen to your prefer initial view spot (the default screen of your Google Street View).
» Read More
Step 1. Open the Google map on your browser, and Key in your business name on the Search tab.
Step 2. Click the See Inside tab, and then guide the Street View screen to your prefer initial view spot (the default screen of your Google Street View).
» Read More
Street View | Trusted Photographer2015-08-22
Street View Trusted | Trusted Photographer
Do you want to apply the Google Street View technology to show your business to the world? Try below sample:
Jade Mountain Café
2611 E Johnson St, Madison, WI 53704
Ting-Li Lin and Max Chen (myself), who founded Snowforst.co, are helping Wisconsin local business to spread their visibility! Although they are both Google Trusted Photographers, their photography capabilities is way beyond than this.
I am currently marketing Google Street View services in most towns in Sauk county, like: Sauk City, Baraboo, Reedsburg and Wisconsin Dells area. If you see me stop by your business store, don't be surprised. I see your potential and would like to help promote your store. I believe Street View for business is a great marketing tool for local business for the below reasons:
» Read More
Do you want to apply the Google Street View technology to show your business to the world? Try below sample:
Jade Mountain Café
2611 E Johnson St, Madison, WI 53704
Ting-Li Lin and Max Chen (myself), who founded Snowforst.co, are helping Wisconsin local business to spread their visibility! Although they are both Google Trusted Photographers, their photography capabilities is way beyond than this.
I am currently marketing Google Street View services in most towns in Sauk county, like: Sauk City, Baraboo, Reedsburg and Wisconsin Dells area. If you see me stop by your business store, don't be surprised. I see your potential and would like to help promote your store. I believe Street View for business is a great marketing tool for local business for the below reasons:
» Read More
Max Chen2015-08-01
>> 中文版
Hey~ Nice to meet you~
I'm Max Chen <u870820@gmail.com>, an engineer, backpacker, photographer, web programmer, and blogger.
I have an M.S in Industrial System Engineering from UW-Madison, and I've worked at ASUSTek Inc., PEGATRON corp., and now Hankscraft Inc.. In the past, I did research in the UW-Madison Naturalistic Decision Making and Simulation Lab with Dr. Douglas Wiegmann , and at the Waisman Center. My research interests were focused on User Experience, Aviation Safety and Patient Safety.
I am a professional in project management and quality engineering, and I enjoy working on "complex problem" projects with hard to identify root causes or projects involving with cross-functional teams. I make a living by utilizing my knowledge and experience in both the quality and manufacturing fields. I am also a certified six sigma black belt of the American Society for Quality.
I was born in Taipei, Taiwan, and I have lived in Prague, Czech for 2 years, Shanghai, China for 3 years, and I now live in Madison, Wisconsin. Traveling and seeing the world is what brings excitement to me in life. While traveling I found a passion for photography. Taking photos and sharing what I have seen has become my treasure. In 2003 I launched a blog to present my photography.
In my free time, I like to do web programming. After not finding a photo album service I liked, I decided to code on for myself, it is called Max Chen Photo Database. It was just a start, my other web application could be found here(mandarin). In addition, my latest web project isPlace.Report which utilized Google maps API and Facebook Graph API, a data-mining informative service.
In mid 2015, I started a new adventure with Ting-Li Lin. We set up Snowforest, a company specialzing in architecture photography and beyond. Snowforest's mission is to deliver artful images and to ensure every customer is satisfied. Snowforest is a new challenge and a new chance to us, and I devote myself in it and like to picture a wonderful future with it.
In my leisure time, I enjoy swimming, running, reading, watching movies, and playing games. I am not good at writing, but I will try my best to record thoughts, studies, and stories in here. I would like to share my life experiences with my friends and future generations. Someday, we will become someones' memory, and here is the best place to remember me.
Below is a list of social medias I am using. Let's exchange our thoughts via:
twitter
facebook: mandarinEdited by Max Chen on Oct 10, 2016. Thank you Tara for proof reading.
Max was waiting to take a sunset
Max in Grand Canyon.
Max and Tingli were at Grand Teton.
Upper Peninsula2013-10-08
Upper Peninsula U.P. 密西根上半島之旅
10月第一周, 麥大叔請了一天假, 組成了三天的週末,
前往密西根上半島 (英文簡稱為UP) Road Trip...
超簡易行程如下:
Day 1: Madison, WI -> Munising, MI
- HIWATHA National Foredst
- Pictured Rocks Cruise
Day2: Munising, MI -> Sault Ste Marie, MI
- Tahquamenon Falls State Park
- Great Lakes Shipwreck Museum
Day3: Sault Ste Marie, MI -> Madison, WI
- Sault Ste Marie City: Soo Locks, Historical Tower
- Mackniac Bridge at St. Ignace
- Manistique Lighthouse
- Palm Books State Park
--
以後每年秋天都要去一趟才行, 真的超美的! 不虛此行。
Cesky Krumlov2009-06-17
Cesky Krumlov
Czech Republic, UNESCO, 27images
Equip: Canon EOS 300D, EF16-35L
Date: 2004年02月6日; 2004年03月07日
Album: Cesky Krumlov
[2009 Update]
Cesky Krumlov是捷克境內"非常非常"迷人的小鎮~
捷克朋友們幾乎一致推薦 Cesky Krumlov 為捷克境內必訪的第一景點。(第二才是Prague)
多年後重溫舊照, CK的美景歷歷如目, 彩繪塔還在眼前閃爍金黃色的太陽光影...
時間似乎在Cesky Krumlov 靜止了,
我說: 它是波西米亞最閃亮的一顆珍珠! 朋友, 你若有機會拜訪捷克。
布拉格可以不去, Cesky Krumlo 你一定得來!
» Read More
[46_100] 新竹行2009-04-29
[21_100] Google街景2009-04-01
Google 街景
這個 Google 街景實在是一個非常酷的 Kill Application, 我實在是相見恨晚啊!!!
運用的技術原理很簡單, 就是找台可錄影有GPS的車子, 然後放到街上轉轉,
再把所有拍攝到的相片按照GPS記錄器放到 Google map 上~ Done!
像是上圖就是啥咧? 就是 Google 街景車拍攝到的日本美少女外拍啦~
» Read More
©Max Chen 2003-2024 V2.1