HackerConnect 2018 Presentation

Transcript

1. Navigate Threats. Seize Opportunities. January 22, 2018 10 Hacks That Are Making Life Easier for Agents
4. Enter Neighborhood, Address, Zip Code, Listing ID….
5. 1 Chatbots Amazon Lex
6. 1 Chatbots Can you tell me about your available rentals? Are there any [Layout] units available? Do you have any apartments available near [Location]?
7. 1 Chatbots Location Address Where are you looking? Budget $$$ What’s your budget? Layout Choice What layout are you looking for? Move-in Date Date When are planning to move? Appointment Time DateTime When are you available for a showing?
8. Do you have any 2 bedrooms available near 1035 Broadway? We do! What’s your budget? $3000 - $3400 When is your move-in date? Feb 1 Great, I have three 2 bedrooms available on February 1, when are you available for a showing? How about Wednesday at 5PM? Ok, I have you confirmed for an appointment at 5PM on Wednesday, January 24
9. 1 Chatbots Yes, we do! Your API Location: 1035 Broadway Layout: 2 Beds Do you have any 2 bedrooms available near 1035 Broadway?
10. 2 Geocoding API Do you have any 2 bedrooms available near 1035 Broadway?
11. 2 Geocoding API 1035 Broadway, New York, NY 40° 45' 31” -73° 59' 10” GET https://api.geocode.com?search=
12. 2 Geocoding API
13. 3 Address Validation 83-87A Woodhaven Blvd 2381 Cottage (LOT 8) LN 10A52 Cardinal Ct 2687 N Us 45-52 Hwy 447 HHP 609-17 N. Sheridan 361 Tompkins Ave.(Bet Putnam and Madison) 0 By Pass Road 1584 N 2500E RD 1000-10 Hinman (at Lee) 152 W32 516 156 0N299 KING (Y164) DR 5 Wesley Ave. Ext. 205-6-10 42nd Ave Bambini 433 East 75 127775 181-30 Union Tpke
14. 3 Address Validation
15. 3 Address Validation
16. 4 Spatial Databases CREATE TABLE location ( latitude DECIMAL(9,6), longitude DECIMAL(9,6) );
17. 4 Spatial Databases latitude, longitude, distance FROM ( SELECT z.zip, z.primary_city, z.latitude, z.longitude, p.radius, p.distance_unit * DEGREES(ACOS(COS(RADIANS(p.latpoint)) * COS(RADIANS(z.latitude)) * COS(RADIANS(p.longpoint - z.longitude)) + SIN(RADIANS(p.latpoint)) * SIN(RADIANS(z.latitude)))) AS distance FROM zip AS z JOIN ( /* these are the query parameters */ SELECT 42.81 AS latpoint, -70.81 AS longpoint, 50.0 AS radius, 111.045 AS distance_unit ) AS p ON 1=1 WHERE z.latitude BETWEEN p.latpoint - (p.radius / p.distance_unit) AND p.latpoint + (p.radius / p.distance_unit) AND z.longitude BETWEEN p.longpoint - (p.radius / (p.distance_unit * COS(RADIANS(p AND p.longpoint + (p.radius / (p.distance_unit * COS(RADIANS(p ) AS d WHERE distance <= radius ORDER BY distance
18. 4 Spatial Databases
19. 4 Spatial Databases
20. 4 Spatial Databases
21. 4 Spatial Databases
22. 5 Context 101 2nd
23. 5 Context
24. 5 Context
25. 5 Context
26. 5 Context Do you have any listings near 101 West 2nd Street, Hinsdale, IL 60521?
27. 5 Context
28. 5 Context
29. 5 Context
30. 6 OpenData 205 E. Houston P.S. 188 - The Island School 2 HPD Complaints R8B Zoning
31. 6 OpenData How are the schools in that area? Great! They had some of the top test scores in the city last year.
32. 6 OpenData
33. 6 Open Data Data.gov
34. 7 Photo Adjustment
35. 7 Photo Adjustment
36. 7 Photo Adjustment img.nestio.com/photo.jpg ?width=200 ?fit=crop&width=500&height=500
37. 7 Photo Adjustment width=500&height=500 width=500&height=500&crop=faces
38. 7 Photo Adjustment txt= Friendly!&txtclr=FF02C8 Friendly! blend=yasss.png
39. 8 Image Recognition Can you send me some photos? Here you go!
40. 8 Image Recognition Bathroom - 96.3% Indoors - 96.3% Room - 96.3% Toilet - 95.4%
41. 8 Image Recognition
42. S 8 Image Recognition Diagram - 97.5% Floor Plan - 97.5% Text - 70.3%
43. 9 Mechanical Turk
44. 9 Mechanical Turk Cats Dogs Breed Restrictions Weight Limit 50 lbs Deposit $200 We love your furry friends, so long as they are under 50 pounds, and are not an aggressive breed like Pit Bull or Rottweiler. Each pet requires a $200 deposit. Our Pet Policy
45. 10 Scheduling How about Wednesday at 5PM? When are you available for a showing?
46. 10 Scheduling
47. 10 Scheduling
48. Great! I have you confirmed for an appointment at 5PM on Wednesday, January 24
49. Thanks! @mikeocool January 22, 2018 Navigate Threats. Seize Opportunities. mike@nestio.com (We’re hiring)