Anna Pestereva

Anna Pestereva is the Application Developer and Cartographer at Aerial Services, Inc. She combines her diverse backgrounds in web and desktop application development, cartography training and GIS research with passion for open source software to create efficient and innovative spatial solutions for the clients, as well as to benefit diverse automation efforts in the company. Anna is GIS-P, has a MS in Cartography and MA in Geography, and loves sharing her knowledge - don't hesitate to ask her questions!

Daily Discoveries of a FOSS4G User: PostGIS and Its Bag of Tricks

As I mentioned in the previous post, there were a couple of handy PostGIS functions I found quite useful after importing prepped data via shp2pgsql tool. They involve working with Spatial Reference of geometries and working with Multi* geometries. 1. PostGIS: ST_SetSRID vs ST_Transform Even after figuring out the way to define Spatial Reference in QGIS – it’s still possible to miss …

Daily Discoveries of a FOSS4G User: PostGIS and Its Bag of Tricks Read More »

Daily Discoveries of a FOSS4G User: QGIS, the Vector Doctor.

After returning from the amazing FOSS4G-NA conference in Raleigh, NC, I just couldn’t get back to my pre-conference self! In the spirit of continuous learning I decided to try finding better ways to solve common problems and explore these great free and open source geospatial technologies further. My hope is that this review of various …

Daily Discoveries of a FOSS4G User: QGIS, the Vector Doctor. Read More »

Scroll to Top