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. Artur Caliendo Prado
   http://arturprado.com/
   artur.prado@youse.com.br
   @artur.prado @artur_caliendo
   @arturcp
   

   View Slide

5. il percorso degli aerei
   Dove siamo?
   il sistema di coordinate
   il problema da risolvere
   Postgis
   Funzioni
   

   View Slide

6. View Slide

7. View Slide

8. il percorso degli aerei
   Dove siamo?
   il sistema di coordinate
   il problema da risolvere
   Postgis
   Funzioni
   

   View Slide

9. Sistema geometrico
   

   View Slide

10. View Slide

11. Sistema Geografico
    

    View Slide

12. View Slide

13. View Slide

14. View Slide

15. View Slide

16. https://thetruesize.com/
    

    View Slide

17. View Slide

18. Non tutte le ciambelle escono col buco.
    

    View Slide

19. View Slide

20. View Slide

21. View Slide

22. il percorso degli aerei
    Dove siamo?
    il sistema di coordinate
    il problema per risolvere
    Postgis
    Funzioni
    

    View Slide

23. View Slide

24. View Slide

25. View Slide

26. View Slide

27. View Slide

28. il percorso degli aerei
    Dove siamo?
    il sistema di coordinate
    il problema da risolvere
    Postgis
    Funzioni
    

    View Slide

29. ● PSC - project steering
    committee
    ● OSGeo - Open Source
    Geospatial Foundation
    ● Regione Toscana - SITA
    cartoteca
    ● Associazione Italiana per
    l'Informazione Geografica
    Libera (GFOSS.it)
    ● Supporto gratuito o a
    pagamento
    

    View Slide

30. Installazione
    http://postgis.net/install/
    Postgres.App
    brew install postgis
    yum install postgis
    

    View Slide

31. View Slide

32. View Slide

33. View Slide

34. View Slide

35. SRID
    Spatial Reference Identifier
    

    View Slide

36. Cilindrica Piana Conica
    

    View Slide

37. View Slide

38. View Slide

39. View Slide

40. View Slide

41. View Slide

42. il percorso degli aerei
    Dove siamo?
    il sistema di coordinate
    il problema da risolvere
    Postgis
    Funzioni
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

49. 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

50. View Slide

51. View Slide

52. View Slide

53. 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

54. View Slide

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

    View Slide

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

    View Slide