929 new features in WINDEV, WEBDEV and WINDEV Mobile 2024

STORE AND HANDLE SPATIAL DATAWITH HFSQL HFSQL 2024 allows you to manipulate geometric and geographic data. You can store these types of data in HFSQL databases and perform advanced SQL queries. For example, “list of parcels a given path goes through” or “list of schools within a 1-mile radius”. 187 N e w f e a t u r e W D W B WM SPATIAL DATA Spatial data allows you to define the: • position, • shape, • extension of objects on the surface of the Earth. Spatial data can be used to store points of interest (charging sta- tions, restaurants, hotels), roads, rivers, lakes or surfaces such as properties (land registry), forests, mountains, administrative zones, etc. This type of data is essential to the creation of a GIS. Spatial data includes both geographic and geometric information (see below). Benefit of this new feature in version 2024 : New data type, infinite possibilities 188 N e w f e a t u r e W D W B WM NEW WLANGUAGE TYPES TO DESCRIBE SPATIAL DATA Two coordinate systems are available, according to the intended use: • geometric coordinates (2D, geometry) • geographic coordinates (latitude/longitude, GPS, geography) Geometric 2D coordinates can be used over short distances (up to 50 km / 31 mi). For longer distances, it is necessary to use geographic coordinates, which factor in the Earth’s curvature. You can manipulate these types of data using new WLanguage types. For the gemoetric system (2D), several new types are available: Point2D , Polygogne2D , Linestring2D , etc. The new MultiXXX type allows you to store a set the previous types. These types are also available for the geographic system: Point- Geo , PolygonGeo , LinestringGeo , etc. Benefit of this new feature in version 2024 : Always more programming possibilities in WLanguage 189 N e w f e a t u r e W D W B WM HOW TO RETRIEVE SPATIAL DATA? There are several methods to retrieve spatial data. Data can: • be specified directly by the developer • be the result of user input (e.g. coordinates) • be imported from a device such as a GPS tracker • come from GPX files • be downloaded from files available online Almost every smartphone can provide GPS information. Once retrieved, this data can be used in a wide range of fields: • land register • natural areas and protected zones • urban planning • defense and security areas • and many more. New WLanguage functions enable you to serialize and deserialize the new types. Numerous formats are supported: JSON, XML, CSV, text, etc. Benefit of this new feature in version 2024 : More possibilities SPATIAL DATA 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 36