53 73 Journal of Taiwan Land Research Vol. 9, No.2 pp. 53~73 Google Maps/Earth Urmap API * ** 95 4 7 95 7 4 摘 要 ASP Google Maps/Earth Urmap API * ** E-mail jthwang@mail.ntpu.edu.tw 53
The Applicibility of Google Maps/Earth and Urmap API to Real Estate Database* Jin-Tsong Hwang** Abstract Whether the real estate market is prosperous or not, purchasing or renting houses always exists. Real estate agencies are market information provider. It is the goal of the consumer and the agency to get sufficient real estate market information. In this paper, an interface was designed which based on information platform and map development tools provided by two main map server providers. In addition, the functions of API between them were compared. The real estate database and digital photos of properties were processed and adopted as resources in this paper. We try to use the function of Google Maps/Earth and Urmap API to build an interface which can show the results of query among real estate database in two- and three-dimensional formats. The result shows that this kind of platform, which combines the two major map server functions, can really activate with the real estate database contains. Keywords: Real Estate Database, Digital Map 54
Google Maps/Earth Urmap API 360 GPS WebGIS Google Google Maps Google earth Google Maps 1 UrMap 1 2006 API Application Programming Interface Google Urmap Yahoo! Yahoo! 55
Maps API Google Urmap Google Maps Urmap Google Maps Google Maps Urmap API ASP Map 360 Google earth 56
Google Maps/Earth Urmap API Google Maps Google Maps Google Maps AJAX API Yahoo! Maps Yahoo! Maps MSN MSN Windows Live Local A9 Maps A9 Maps 2006 Urmap API 1.0 1.01 Google Maps API v1 Urmap API v1.01 GIS Google Maps Google Earth GIS GIS Active Server Page, ASP ASP Internet Information Server IIS script HTML ASP Script CGI Active X ASP 57
MSN Google Maps Urmap Yahoo! Maps Window Live Local A9 Maps 23 API(Flash) API(AJAX) 50000 / 10 16 18 10 15 12 20 Wi-Fi ASP IIS ASP PC ASP ASP ASP 2004 asp ASP ASP ASP HTML ASP 2005 1. ASP Windows FrontPage Dreamweaver 58
Google Maps/Earth Urmap API 2. ASP HTML 3. ASP HTML VB Script Java Script Active X Windows ActiveX ASP ADO 4. ASP HTML 5. ASP Access Mysql Microsoft SQL Server FoxPro dbase Oracle Open DataBase Connectivity, ODBC ODBC Microsoft 6. ASP Object-Oriented ASP Request Response Server Application Session Application Session ASP JavaScript XML Asynchronous JavaScript + XML, AJAX AJAX Adaptive Path Jesse James Garrett 2005 2 18 A New Approach to Web Application Jess James Garrett, 2005a; 2005b AJAX Asynchronous JavaScript + XML AP Server AJAX CPU AJAX A J A X JavaScript XML CSS Cascading Style Sheets XSLT Extensible Stylesheet Language Transformation DOM Document Object Model HTML XMLHttpRequest AJAX 59
Jesse James Garrett 2005a AJAX 1. XHTML CSS 2. DOM 3. XML XSLT 4. XMLHttpRequest 5. JavaScript AJAX JavaScript Layer AJAX XML AJAX AJAX AJAX AJAX JavaScript Google Earth Google Earth Google Keyhole 3D Windows XP 0.61 KML GPS 60
Google Maps/Earth Urmap API AJAX http://adaptivepath.com/publications/essays/archives/000385.php, 2005a KML XML KML Google Earth Google Earth 1 Google Maps Urmap Google Maps Google API Google Maps 2 Google 2006 Urmap API 1.0 script Google Maps 2 1. 系統需求 Google maps API IE web IIS Google maps 61
Google API Key http://www.google.com/apis/maps/signup.html Urmap http://www.urmap.com/searchengine/api/signup.html KEY 2. 地圖的顯示與行為控制 Google maps Urmap HTML ASP API Key script c:\inetpub\wwwroot\ API script map.addcontrol new GLargeMapControl ; map.addcontrol new GMapTypeControl ; Google maps Urmap Google IKNOS Urmap Google Map 3. 內含影像 Google Maps ESRI Arcmap 2 Landsat 7 15 IKNOS 1 0.6 Google Earth 2 2005 1 Urmap 8 2 2 Urmap 62
Google Maps/Earth Urmap API Google Urmap API Google Maps API V1 Urmap API V 1.01!DOCTYPE html PUBLIC "-//W3C//DTD <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML XHTML 1.0 Strict//EN" <html xmlns="http://www.w3.org/1999/xhtml" <head> <script 1.0 Strict//EN"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <script src= http://maps.google.com/maps?file=api&v=1& src="http://www.urmap.com/searchengine/api/ key=your_website_key> </script> </head> <body> getapi.jsp?v=1&key= YOUR_WEBSITE_KEY "> </script> <head> <body> Google M a p s Urmap <div id="map" style= "width: 400px;height:300px"></ <div id="map" style= "width: 400px;height:300px"></ html div></div> <script type="text/javascript"></script> <script> //<![CDATA[ div></div> <script type="text/javascript"></script> <script> //<![CDATA[ var map= new GMap docume nt. getelementbyid var map= new UMap document. getelementbyid "map" ; "map" ; G M a p map.addcontrol new GLargeMapControl ; map.addcontrol new GMapTypeControl ; map.setcontroltype U_FULL_CONTROL ; map.addcontrol U_TYPE_CONTROL ; map.centerandzoom new GPoint 121.53786, m a p. c e n t e r A n d Z o o m n e w U L a t L n g 121.53786 25.04599, 8 ; //]] </script> </body> </html> 25.04599,121.53786, 2 ; //]] </script> </body> </html> 25.04599 1 16 G o o g l e U r m a p 63
a Google b Urmap c Google b Urmap Google Maps Urmap 2003 1. 資料庫之資料處理 64
Google Maps/Earth Urmap API 5000 82 30000 82 1500 82 3000 82 20000 89 5000 82 20000 87 Excel MS Access ArcGIS Google Maps Urmap WGS84 TWD67 TM2 Google Earth Maps WGS84 TM2 E N GRS67 TWD67 GRS67 TWD97 GRS80 WGS84 Google Earth/Map 2. 外加資料的處理 65
Photo Vista MGI Photo-Vista, verision 3.0 360 GIS GIS KML Google Earth 1. 介面設計 ASP 360 API Google Earth Google Maps Google Maps 66
Google Maps/Earth Urmap API a 360 b Target Google Earth Google Maps Urmap a Google Maps b Urmap 2. ASP 與資料庫連結查詢 action ASP POST GET <form> method 67
a b a Google Maps b Urmap 2001 ODBC ODBC ASP ODBC <% Set DataConn = Server.CreateObject "ADODB.Connection" DataConn.Open Provider=Microsoft.Jet.OLEDB.4.0; Data Source = ntpu.mdb" Set rst = Server.CreateObject "ADODB.Recordset" rst.open "Select * From RE where total_price > "& s_price &" and total_price < "& t_price &" and age < "& h_age &" and TF < "& h_floor &"", DataConn,3 %> Response.write "<a href=google_r.asp?lng=" & ptlng & "&lat="& ptlat & "&area=" & ptarea &"&price="& ptprice &"&Address="& ptaddre &" target=" "right"">" & ptaddre &"</a> <br> 68
Google Maps/Earth Urmap API 3. Google Maps 與 Urmap 的同步與切換 Google Maps Urmap Script Google Maps Urmap Urmap Google Maps API function swap2u { UrMap var map = new UMap document.getelementbyid "map" ; map.setcontroltype U_FULL_CONTROL ; map.centerandzoom new ULatLng lat, lng, 10 -zoomlevel_z ; map.addlistener 'moveend', function { } ; } 4. Google Earth 的驅動 Google Maps Google Earth Windows Google Earth KML Keyhole Markup Language MIME Multipurpose Internet Mail Extension Application / keyhole KML Google Earth Google Earth ASP Google Earth response.contenttype "application/keyhole" <?xml version="1.0" encoding="utf-8"?> <kml xmlns="http://earth.google.com/kml/2.0"> Google Earth KML 69
KML Placements folder points name coordinate response.write ASP ASP coordinate 5. 討論與分析 1 Urmap API Google Maps Google Maps Urmap API 2 Google Maps Urmap XML JavaScript GIS 3 WebGIS ESRI 4 HTML 5 TWD67 TM2 Google Maps Urmap WGS84 Perl 70
Google Maps/Earth Urmap API Google Maps Urmap API ASP JavaScript Google Earth 1. Google Maps Urmap API Urmap API 2006 Google Maps JavaScript 2. 3. 360 4. GIS Google Maps Urmap Script 71
GIS GIS GIS http://gis.ascc.net/googlemap/ GIS http://gis.ascc.net/istis/tools.html 1 http://www.urmap.com/ 2 http://www.urmap.com/searchengine/api/documentation/#controlsexample http://www.housingradar.com/ http://www.housingmaps.com/ http://www.coloradofuture.com/ http://iadc.geo.ntnu.edu.tw/ Yahoo! Maps http://maps.yahoo.com/ 2001 2005 ASP 2004 Dreamweaver 2004 MX ASP A9 Maps http://maps.a9.com/ Google Maps 1 http://maps.google.com/ Google Maps 2 http://maps.google.com/apis/maps/ Google Earth 1 http://earth.google.com/ Google Earth 2 2005 http://earth.google.com/ coverage/coverage_list.pdf Jesse James Garrett 2005a http://adaptivepath.com/publications/essays/archives/ 000385.php 72
Google Maps/Earth Urmap API Jesse James Garrett 2005b http://blog.xuite.net/asdic.sea/diary/4477013 MSN Windows Live Local http://local.live.com/ 73