How postgis changed the insurance market in Brazil

We can offer a one-size-fits-all product, or we can truly understand our users and offer something valuable and customized to their needs. Geolocation is the key to learn what is going on around them to make better, user-centric decisions.

Transcript

1. http://arturprado.com/
   

   View Slide

2. View Slide

3. View Slide

4. Esta palestra é contraindicada para
   terraplanistas
   

   View Slide

5. View Slide

6. View Slide

7. Sistema Geométrico
   

   View Slide

8. View Slide

9. Sistema Geográfico
   

   View Slide

10. View Slide

11. View Slide

12. View Slide

13. View Slide

14. https://thetruesize.com/
    

    View Slide

15. View Slide

16. View Slide

17. View Slide

18. View Slide

19. View Slide

20. View Slide

21. View Slide

22. View Slide

23. View Slide

24. View Slide

25. View Slide

26. ● PSC - project steering
    committee
    ● OSGeo - Open Source
    Geospatial Foundation
    ● Suporte pago ou gratuito
    

    View Slide

27. Instalação
    http://postgis.net/install/
    Postgres.App
    brew install postgis
    yum install postgis
    

    View Slide

28. View Slide

29. View Slide

30. View Slide

31. View Slide

32. SRID
    Spatial Reference Identifier
    

    View Slide

33. Cilíndrica Plana Cônica
    

    View Slide

34. View Slide

35. View Slide

36. View Slide

37. View Slide

38. View Slide

39. ST_SRID
    SELECT
    id,
    name,
    ST_SRID(coordinates) as srid
    FROM boundaries
    WHERE id = 3828;
    

    View Slide

40. ST_Point
    Latitudine: -23.625531
    Longitudine: -46.640963
    SELECT ST_Point(-46.640963, -23.625531)
    

    View Slide

41. ST_AsText
    SELECT ST_AsText(
    ST_Point(-46.640963, -23.625531)
    ) as point;
    

    View Slide

42. ST_Transform
    SELECT ST_AsText(
    ST_Transform(ST_Point(-46.640963, -23.625531), 3857)
    );
    

    View Slide

43. ST_SetSRID
    SELECT ST_SetSRID(ST_Point(-46.640963, -23.625531), 4326);
    

    View Slide

44. ST_Transform
    SELECT ST_AsText(
    ST_Transform(
    ST_SetSRID(
    ST_Point(-46.640963, -23.625531), 4326
    ), 3857
    ));
    

    View Slide

45. ST_Covers
    SELECT id, name
    FROM boundaries
    WHERE ST_Covers(
    boundaries.coordinates,
    ST_Transform(ST_SetSRID(ST_Point(-46.640963, -23.625531),
    4326), 3857)
    );
    

    View Slide

46. View Slide

47. View Slide

48. View Slide

49. ST_DistanceSphere
    SELECT
    name AS origin,
    'Youse' AS destination,
    ST_DistanceSphere(
    point,
    ST_Transform(ST_SetSRID(ST_Point(-46.6824622, -23.5941306), 4326), 3857)
    ) AS distance
    FROM markers
    WHERE id = 174;
    

    View Slide

50. View Slide

51. https://postgis.net/docs/reference.html
    

    View Slide

52. http://arturprado.com/
    artur.prado@youse.com.br
    @artur.prado
    

    View Slide