GIS-INTEGRATION NSF Industry University Cooperative Research Center High Performance

GIS-INTEGRATION NSF Industry/University Cooperative Research Center High Performance Database Research Center Naphtali D. Rishe, Director, rishe@fiu. edu HPDRC. FIU. edu Terra. Fly. 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: $40 M, Patents: 4, Books: 4, Papers: 250 HPDRC. FIU. edu Terra. Fly. com

TERRA FLY GIS Solutions Based On Geo-Spatial Research Technology • Next generation GIS: Internet geo-visualization & spatial cloudcomputing 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 Terra. Fly. com

Web-Based Open Architecture API Geo-Spatial Mapping Solution HPDRC. FIU. edu Terra. Fly. com

Demographic Data Address Locator 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 Terra. Fly. com

Terra. Fly Maps HPDRC. FIU. edu Terra. Fly. com

Your System Your Data Terra. Fly Integration Solution Terra. Fly system HPDRC. FIU. edu Terra. Fly. com

Historical Property Values Time Series Animation Player Layer Control Query Date Range Census Block Groups are Selectable HPDRC. FIU. edu Terra. Fly. com

Map. Reduce in Terra. Fly Map. Reduce use cases ● ● ● Spatial data indexing [SSDBM’ 09] Geospatial query support [SSDBM’ 10] Parallel spatial data processing [Gr. C’ 10] Parallel set-similarity spatial joins Real Estate data analytics HPDRC. FIU. edu Terra. Fly. com

Disaster Influence on Property Prices (1) ● ● Objective: Provide computational analytics for estimating how an event influences property values Dataset: Miami-Dade county records (~ 20 M) Community Boundaries: U. S. Census Blocks and Tracts (polygons) Property transaction geo-database: Join of property public records (Deeds, Tax Roll) Parcel Date Value Area Type Location 1001 03 -10 -2005 100 K 840 Condo 1, 2 1002 03 -15 -2005 130 K 2000 Single-Family 2, 3 1003 12 -22 -2005 80 K 1085 Single-Family 2, 2 … … … HPDRC. FIU. edu Terra. Fly. com . . .

Disaster Influence on Property Prices (2) Value 03 -10 -2005 100 K … Loc. 1, 2 1002 03 -15 -2005 130 K 2, 3 1003 05 -22 -2005 80 K 3, 2 1004 06 -20 -2005 80 K 4, 2 1005 07 -10 -2006 100 K 5, 2 1006 03 -15 -2005 130 K 6, 3 1007 12 -22 -2005 80 K 7, 2 1008 12 -22 -2005 80 K 8, 2 … … 9000 03 -15 -2005 130 K 12 -22 -2005 80 K 9, 2 9002 01 -22 -2006 80 K 2, 2 9003 02 -10 -2006 100 K 1, 2 9004 03 -15 -2005 130 K 2, 3 9005 12 -22 -2005 80 K 2, 2 9006 12 -22 -2005 80 K 9, 2 Input: dataset, tstart, tend ● Method Reduce Map Community Rate Value 300 -10% 100 301 Reduce 9, 3 9001 Map … Date 1001 … Parcel -60% 80 302 15% 55 303 2% 60 … … … (Computes community values and change rate) (Partitions records by: Community, Type, Date) Output: Community value change rate Virtual Community (VC): a set of homes with similar characteristics within a geographical area • Consider unit price per VC, e. g. median of $/sq-foot • Compute VC’s unit price rate change to compare communities • Hadoop Map. Reduce: Temporal, in parallel, self-join of the dataset to compute property value rate change • …

Disaster Influence on Property Prices (3) Raise Drop No change Hurricane Andrew, August 1992, Q 2’ 92 vs. Q 4’ 92 HPDRC. FIU. edu Terra. Fly. com