Map SQL Test







1. Marker und Polygone mit SQL-Abfrage

SQL (Marker):

SELECT
ST_X(Georeferenz) AS lng,
ST_Y(Georeferenz) AS lat,
IF(Alpenkonvention, 'blue', 'yellow') AS color,
'hex' AS symbol,
5 AS size,
CONCAT('AIS-Informat Nr. ', Nummer, ' (', Ortsname, ')') AS description
FROM
informanten
WHERE
Erhebung = 'AIS'

SQL2 (Polygone):

SELECT
AsText(Geodaten) AS geo,
Name AS description,
IF(Alpenkonvention, 'blue', 'yellow') AS color
FROM Orte
WHERE Id_Kategorie = 80

SQL-Ergebnis:

SQL-Ergebnis 2:

 

Shortcode:

[map lat="43.50890510132282" lng="12.578458054884743" zoom=4 height="500px"]
[markerGroup login="va" query="SELECT ST_X(Georeferenz) AS lng, ST_Y(Georeferenz) AS lat, IF(Alpenkonvention, 'blue', 'yellow') AS color, 'hex' AS symbol, 5 AS size, CONCAT('AIS-Informat Nr. ', Nummer, ' (', Ortsname, ')') AS description FROM informanten WHERE Erhebung = 'AIS'"]

[polygonGroup login="va" query="SELECT AsText(Geodaten) as geo, Name as description, IF(Alpenkonvention, 'blue', 'yellow') AS color FROM Orte WHERE Id_Kategorie = 80"][/polygonGroup]
[/map]

 

Karte: