Spatial SQL =
a
query language which specifies the information to retrieve +
a
presentation language which specifies how the information has to be
displayed.
Two parts:
SET LEGEND COLOR black FOR SELECT boundary (geometry) FROM plot; SET LEGEND COLOR blue PATTERN dashed FOR SELECT interior (geometry) FROM zone WHERE type"‘URBAN’; SET LEGEND COLOR red FOR SELECT interior (geometry) FROM historical-monument; SET CONTEXT FOR plot.geometry SELECT historical-monument.geometry, zone.geometry, plot.name FROM historical-monument, plot, zone;
SET MODE highlight; SELECT plot.geometry FROM plot, historical-monument, zone WHERE plot.geometry INSIDE zone.geometry AND zone.type"‘URBAN’ AND distance (historical-monument.geometry, plot.geometry<500;