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/
4. Esta palestra é contraindicada para terraplanistas
7. Sistema Geométrico
9. Sistema Geográfico
14. https://thetruesize.com/
26. • PSC - project steering committee • OSGeo - Open Source Geospatial Foundation • Suporte pago ou gratuito
27. Instalação http://postgis.net/install/ Postgres.App brew install postgis yum install postgis
32. SRID Spatial Reference Identifier
33. Cilíndrica Plana Cônica
39. ST_SRID SELECT id, name, ST_SRID(coordinates) as srid FROM boundaries WHERE id = 3828;
40. ST_Point Latitudine: -23.625531 Longitudine: -46.640963 SELECT ST_Point(-46.640963, -23.625531)
41. ST_AsText SELECT ST_AsText( ST_Point(-46.640963, -23.625531) ) as point;
42. ST_Transform SELECT ST_AsText( ST_Transform(ST_Point(-46.640963, -23.625531), 3857) );
43. ST_SetSRID SELECT ST_SetSRID(ST_Point(-46.640963, -23.625531), 4326);
44. ST_Transform SELECT ST_AsText( ST_Transform( ST_SetSRID( ST_Point(-46.640963, -23.625531), 4326 ), 3857 ));
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) );
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;
51. https://postgis.net/docs/reference.html
52. http://arturprado.com/ artur.prado@youse.com.br @artur.prado