Trends and insights from our IT experts

Considering how adapting to change is our guiding principle, we aim to quickly respond, invest all the necessary resources, and provide the much-needed reassurance and guidelines to our employees. Sometimes, that can be a tough feat, but we always manage to push through by reassessing our growth opportunities while taking care of Symphony’s core - people.

In this article, we will put together some of the basic spatial data types and operations while leveraging PostGIS to build something that resembles a real-world application that can be useful for our daily lives. The focus will be on the database layer of the application, as that’s where most of the GIS magic happens, but we will ultimately build a full-stack application featuring PostGIS database, Java Spring Boot back-end, and HTML/JavaScript front-end.

The series of successes we have achieved are centered around the one thing that drives us forward - our community members and their expertise, which is why Symphony was recently named as one of the Impact Stars in Central Europe in 2021, as part of the 22nd Deloitte Technology Fast 50 Programme.

From adding numbers to translating sentences, it’s all just simple operations on binary data. “But how is it even possible to operate on textual data?” Good question! Let’s find out.

If you are a web developer who wants to achieve faster time to market for new products and features, cut (almost eliminate) time to provision and manage infrastructure, minimize downtime and security risks, along with costs - this is the place for you.

In this article, we will cover some basics of PostGIS and what it can do, along with some tips and tricks that can be used to simplify solutions or improve performance. In short - PostGIS is a Postgres extension that adds support for storing and manipulating spatial data types.