Blog

Viewing posts for the category Database

Batch count vector features intersecting series of blocks in PostgreSQL

Posted by: Admire Nyakudya | in Database | 2 months, 1 week ago | Comments

The national mapping agency in South Africa (NGI ) caters for national mapping, digital topographic and other Geo-Spatial Information services. The department is mandated to provide spatial data for the whole country. In most cases, they have an in-house team that is responsible for digitizing aerial photography, field validation to produce vector data that is used to make 1:50 000 topographic maps.

Playing with Foreign Data Wrappers in PostgreSQL

Posted by: Gavin Fleming | in Database, FOSSGIS | 5 years ago | Comments

Recently I set out to try out the PostgreSQL foreign data wrapper (FDW) because I needed access to data that was in MySQL tables. The main reason I needed to play around was to expose my data to a range of PostgreSQL functions that are better and more recent that MySQL. I also needed to use MySQL data for views and lookups and data-driven styling for some Geoserver layers. FDWs allow remote access to tables or queries from various external third-party databases or file structures.

Template by Blacktie Mezzanine theme by CodingHouse