929 new features in WINDEV, WEBDEV and WINDEV Mobile 2024

190 N e w f e a t u r e W D W B WM CALCULATION FUNCTIONS FOR SPATIAL DATA You can perform specific operations using spatial data: Calculate plot areas, road lengths, perimeters, stored shapes, etc. It is also possible to perform operations on different sets of data, such as calculating distances, finding nearest neighbors, calculat- ing the union or intersection of several geographic areas, etc. The new Shape functions enable you to perform all these opera- tions (see new feature 372, sorted alphabetically). Benefit of this new feature in version 2024: Powerful programming 191 N e w f e a t u r e W D W B WM HOW TO STORE SPATIAL DATA? In version 2024, storing spatial data is as easy as it gets. Simply use HFSQL. Store data in the new item types: PointGeo , PolygonGeo , LinestringGeo , etc. Benefit of this new feature in version 2024 : HFSQL, a truly universal solution 192 N e w f e a t u r e W D W B WM SPATIAL INDEX FOR QUICK SEARCHES To optimize performance on spatial queries, HFSQL has introduced spatial indexes. Spatial indexes make it possible to quickly process very large vol- umes of data, which is an essential feature given the size of most spatial datasets. A spatial index can be described with a single click in the data model editor. Benefit of this new feature in version 2024 : A special index for spatial data 193 N e w f e a t u r e W D W B WM QUERIES ON SPATIAL DATA You can create queries such as: “Find the 5 nearest charging sta- tions to my location”, or “Count the number of plots of land in town XYZ within 0.5 miles from a school, with a surface area of at least 4000 Sq. foot”. Queries can be written in SQL, or generated using the query editor. 20 new SQL commands (see new feature 151) can be used to set the desired conditions: distance, area, intersection, etc. Example of a query that finds the 5 nearest charging stations to given point: Benefit of this new feature in version 2024 : Ability to create advanced queries These maps are stored as datasets in HFSQL 2024 SELECT TOP 5 * FROM charging_stations ORDER BY ST_Distance(charging_stations.position, {pMyPosition}) Find the 5 nearest EV charging stations Find plots larger than 10,000 Sq. foot Calculate distance between 2 points taking into account the Earth’s curvature EXAMPLES OF HFSQL QUERIES N e w f e a t u r e s i n W I ND E V 2 0 2 4 WE B D E V 2 0 2 4 W I ND E V Mo b i l e 2 0 2 4 37