130 likes | 345 Views
GIS-INTEGRATION. NSF Industry/University Cooperative Research Center High Performance Database Research Center Naphtali D. Rishe, Director, rishe@fiu.edu. High Performance Database Research Center. HPDRC Expertise: Data visualization Spatial databases
E N D
GIS-INTEGRATION NSF Industry/University Cooperative Research Center High Performance Database Research Center Naphtali D. Rishe, Director, rishe@fiu.edu HPDRC.FIU.edu TerraFly.com
High Performance Database Research Center HPDRC Expertise: • Data visualization • Spatial databases • Internet-distributed heterogeneous databases • Database design methodologies • Information analysis • GIS • Location Data • Health Informatics Director: Dr. Naphtali David Rishe The Inaugural Outstanding University Professor of FIU Awards: $40M, Patents: 4, Books: 4, Papers: 250 HPDRC.FIU.edu TerraFly.com
TERRAFLY GIS Solutions Based On Geo-Spatial Research Technology • Next generation GIS: Internet geo-visualization & spatial cloud-computing platform and service • Advanced geo-spatial computing engine • Open architecture, API provided • 40 TB database of aerial imagery and spatial data • Rich datasets in a user-friendly environment • Professionally customizable to domain requirements • NASA, NSF, IBM and USGS funded technology HPDRC.FIU.edu TerraFly.com
Web-Based Open Architecture API Geo-Spatial Mapping Solution HPDRC.FIU.edu TerraFly.com
Address Locator Demographic Data Nationwide Layers: 2000 US Census, Businesses, Schools, Travel, Features (airports, heliports, public buildings, churches, hospitals, libraries, post offices, towers, tunnels, water, etc.), Property Lines and much more Vicinity Information HPDRC.FIU.edu TerraFly.com
TerraFly Maps HPDRC.FIU.edu TerraFly.com
Your System Your Data TerraFly IntegrationSolution TerraFly system HPDRC.FIU.edu TerraFly.com
Historical Property Values Time Series Animation Player Layer Control Query Date Range Census Block Groups are Selectable HPDRC.FIU.edu TerraFly.com
MapReduce in TerraFly • MapReduce use cases • Spatial data indexing [SSDBM’09] • Support to geospatial queries [SSDBM’10] • Parallel spatial data processing [GrC’10] • Parallel set-similarity spatial joins • Real Estate data analytics HPDRC.FIU.edu TerraFly.com
Disaster Influence on Property Prices (1) • Objective: How an event influenced property values? • Property transaction geo-database • Join of property public records (Deeds, Tax Roll) • Method • Virtual Community (VC) is set of homes with similar characteristics within a geographical area • We considerunit price per VC, e.g. median of $/sq-foot • We compute VC’s change rate of unit prices to compare communities HPDRC.FIU.edu TerraFly.com
Disaster Influence on Property Prices (2) • Dataset: Miami-Dade county records (~ 20M) • Community Boundaries: U.S. Census Blocks and Tracts (polygons) • Hadoop MapReduce to self-join the dataset in parallel on community values at different times and compute rates Map Reduce … … Reduce Map (Computes community values and change rate) (Partitions records by: Community, Type, Date) Output: Community value change rate Input: dataset, tstart, tend HPDRC.FIU.edu TerraFly.com
Disaster Influence on Property Prices (3) Hurricane Andrew, August 1992, Q2’92 vs. Q4’92 Raise Drop No change HPDRC.FIU.edu TerraFly.com