1 / 30

www.houseplanner.info

Dr. Carsten Lange Professor of Economics California State University, Pomona CLange@CsuPomona.edu.

dale
Download Presentation

www.houseplanner.info

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Dr. Carsten LangeProfessor of EconomicsCalifornia State University, PomonaCLange@CsuPomona.edu GIS Speaker Series, University of RedlandsRedlands, CA, December 5, 2012– House Purchase Planner - A web-based GIS application assisting house buyers to find a location that fits needs and budget www.houseplanner.info

  2. Project Background • Objective • Help perspective home buyers in the early stage of the buying process when they don’t know which type of house in which location they can afford • Study Area • Orange County, CA • Funding • Core Logic, First American • California State University • The Haynes Foundation • Timeline • Project developed: 2008 – 2012 • Website: www.houseplanner.info

  3. Outline • How to generate the data • How to develop the model • How to publish the results on the Internet

  4. Data Model • Location Based Data (assigned by the GIS) • Avg. household income in Census Block Group at location of sale • School quality at location of sale • Transaction Data • Price (endogenous) • Address • Bedrooms • Building Square ft • Date of Transaction • Pool Dummy • Foreclosure Status • Proximity based Data (generated by the GIS) • Distance to closest park from location of sale • Driving Time from location of sale to closest • beach • major mall • major park ` Project Database

  5. 45,916 geocoded locations with transaction data as attributes. Source: First American CoreLogic

  6. 45,916 geocoded locations with transaction data as attributes. Source: Core Logic, First American Source: First American CoreLogic

  7. Data Model • Location Based Data (assigned by the GIS) • Avg. household income in Census Block Group at location of sale • School quality at location of sale • Transaction Data • Price (endogenous) • Address • Bedrooms • Building Square ft • Date of Transaction • Pool Dummy • Foreclosure Status • Proximity based Data (generated by the GIS) • Distance to closest park from location of sale • Driving Time from location of sale to closest • beach • major mall • major park ` Project Database

  8. Source: ESRI

  9. Data Model • Location Based Data (assigned by the GIS) • Avg. household income in Census Block Group at location of sale • School quality at location of sale • Transaction Data • Price (endogenous) • Address • Bedrooms • Building Square ft • Date of Transaction • Pool Dummy • Foreclosure Status • Proximity based Data (generated by the GIS) • Distance to closest park from location of sale • Driving Time from location of sale to closest • beach • major mall • major park ` Project Database

  10. Outline • How to generate the data • How to develop the model • How to publish the results on the Internet

  11. Hedonic Regression Model DataRecord with price, Rooms, MinBeach, SchoolQ, MilesPark, … DataRecord with price, Rooms, MinBeach, SchoolQ, MilesPark, … DataRecord with price, Rooms, MinBeach, SchoolQ, MilesPark, … DataRecord with price, Rooms, MinBeach, SchoolQ, MilesPark, … DataRecord with price, Rooms, MinBeach, SchoolQ, MilesPark, … DataRecord with price, Rooms, MinBeach, SchoolQ, MilesPark, … DataRecord with price, Rooms, MinBeach, SchoolQ, MilesPark, … DataRecord with price, Rooms, MinBeach, SchoolQ, MilesPark, … DataRecord with price, Rooms, MinBeach, SchoolQ, MilesPark, … DataRecord with price, Rooms, MinBeach, SchoolQ, MilesPark, … DataRecord with price, Rooms, MinBeach, SchoolQ, MilesPark, … Regression Hedonic Price

  12. ArcMap provides Regression Tool

  13. Regression Coefficients* (β’s)

  14. Regression Coefficients* (β’s) Price *) Note, that the coefficients differ slightly from the ones used for the application, because they are based on a slightly different dataset

  15. Outline • How to generate the data • How to develop the model • How to publish the results on the Internet

  16. Application Infra-Structure ArcGISServer ArcGISOnline and JavaScript Esri, Redlands, CA STP Web Hosting,Redmond, WA Cal Poly, Pomona, CA • Application • Map Template fromESRI • Serves the map • Serves the map layerwith • Provides location information

  17. ArcGIS Server .Net Application ArcGIS JavaScript Template

  18. Your Questions Please Dr. Carsten Lange California State University, PomonaCLange@CsuPomona.edu

More Related