Import directly to PostGIS databases


Many Spatial Manager Desktop™ users are familiar with the large number of options included in the application to export spatial data, but few users are aware of the possibility to directly Import Tables to a container, such as a Schema of a PostGIS database

Using Spatial Manager Desktop™, any Provider that brings access to spatial data files (such as SDF or SQLite) or spatial databases (such as SQL Server Spatial or PostGIS), which include Schemas inside their internal structure, allows you to directly Import tables to any of these Schemas. To do it, simply right-click on the corresponding access in the Data Sources panel of the application, and select the “Import” function

When working in PostGIS database servers, you must first create a new User Data Source (UDS) to connect and define the connection parameters of the server to access its spatial databases already containing their respective Schemas

The Import processes are very similar to the export processes and may include the same options for the copy and the transformations. Only one difference: when executing Import processes the target of the data is known and now it is necessary to define the source data and its connection parameters and options. As in any Export process, you can  immediately run the Import Task and/or save it while defined

Note: to learn more about UDSs and Tasks, see the post Export tables from PostGIS or SQL Server Spatial

In this example, several spatial data Tables are imported from different sources to the same Schema of a PostGIS database server to build spatial data information about a city

Please, watch the video:

 

Download

 

Summary
Review Date
Reviewed Item
Post
Author Rating
51star1star1star1star1star