Add an SQL Layer using "Drag-and-Drop"

 

Map layers can be created directly from SQL Queries as shown in previous chapter.

Additionally, you can also add SQL Layers via "Drag-and-Drop" method below.

On the Map page, click the Add SQL Layer as shown below:

 

Give you Layer a name and select your Data Source from the drop-down menu as show below:

 

Select the desired table from the drop-down (Note: Queries can include multiple tables).

 

 

Select the GEOM column from your table using the Geometry Column drop-down as show below.

Next, select any additional columns you wish to include in the Layer (for pop-up content, etc..).

You can select multiple columns, as shown below.

 

Click the Add SQL Layer button as shown below: