The Applicibility of Google Maps/Earth and Urmap API to Real Estate Database* Jin-Tsong Hwang** Abstract Whether the real estate market is prosperous

Size: px

Start display at page:

Download "The Applicibility of Google Maps/Earth and Urmap API to Real Estate Database* Jin-Tsong Hwang** Abstract Whether the real estate market is prosperous"

共机宦
5 years ago
Views:

1 53 73 Journal of Taiwan Land Research Vol. 9, No.2 pp. 53~73 Google Maps/Earth Urmap API * ** 摘要 ASP Google Maps/Earth Urmap API * ** jthwang@mail.ntpu.edu.tw 53

2 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

3 Google Maps/Earth Urmap API 360 GPS WebGIS Google Google Maps Google earth Google Maps 1 UrMap API Application Programming Interface Google Urmap Yahoo! Yahoo! 55

4 Maps API Google Urmap Google Maps Urmap Google Maps Google Maps Urmap API ASP Map 360 Google earth 56

5 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 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

6 MSN Google Maps Urmap Yahoo! Maps Window Live Local A9 Maps 23 API(Flash) API(AJAX) / Wi-Fi ASP IIS ASP PC ASP ASP ASP 2004 asp ASP ASP ASP HTML ASP ASP Windows FrontPage Dreamweaver 58

7 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 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

8 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

9 Google Maps/Earth Urmap API AJAX a 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

10 Google API Key Urmap 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 Google Earth Urmap Urmap 62

11 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=" <head> <script 1.0 Strict//EN"> <html xmlns=" <head> <script src= src=" 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 , 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 , 8 ; //]] </script> </body> </html> , , 2 ; //]] </script> </body> </html> G o o g l e U r m a p 63

12 a Google b Urmap c Google b Urmap Google Maps Urmap 資料庫之資料處理 64

13 Google Maps/Earth Urmap API 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

14 Photo Vista MGI Photo-Vista, verision GIS GIS KML Google Earth 1. 介面設計 ASP 360 API Google Earth Google Maps Google Maps 66

15 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

open "Select * From RE where total_price > "& s_price &" and total_price < "& t_price &" and age < "& h_age &" and TF < "& h_floor &"",

16 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

17 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=" Google Earth KML 69

18 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

19 Google Maps/Earth Urmap API Google Maps Urmap API ASP JavaScript Google Earth 1. Google Maps Urmap API Urmap API 2006 Google Maps JavaScript GIS Google Maps Urmap Script 71

20 GIS GIS GIS GIS Yahoo! Maps ASP 2004 Dreamweaver 2004 MX ASP A9 Maps Google Maps 1 Google Maps 2 Google Earth 1 Google Earth coverage/coverage_list.pdf Jesse James Garrett 2005a php 72

21 Google Maps/Earth Urmap API Jesse James Garrett 2005b MSN Windows Live Local 73

epub 61-2

epub 61-2 2 Web Dreamweaver UltraDev Dreamweaver 3 We b We b We Dreamweaver UltraDev We b Dreamweaver UltraDev We b We b 2.1 Web We b We b D r e a m w e a v e r J a v a S c r i p t We b We b 2.1.1 Web We b C C +