Examples

The following are examples of tasks which JEQL has been used to accomplish. They give an idea of the range of functionality available.

KML Processing

Convert KML/KMZ file into ESRI Shapefile format, converting into BC-Albers coordinate system

Full details

Convert CSV file of point locations to formatted KML

Full details Convert a CSV file containing point spatial features and attribute information into a KML file. The point features form the placemarks. Attributes of the features are used to determine folders. Summary statistics for the contents of each folder are also computed.

Create 3D pie charts in KML

Full details Using a shapefile of country boundaries, create a KML file showing 3D pie charts of statistics for each country.

Merge GPS and Depth-Sounder data streams to produce a KML Bathymetry dataset

Parse data from a KML file, reformat it, and output a new KML file

Spatial ETL

Collate multiple WKT files into a single JTS Test XML file

Non-Spatial ETL

Convert CSV file of keywords to an HTML tag cloud

Spatial Processing

Shape-Match Polygonal Datasets to determine discrepancies

Overlay two polygonal coverages

Assign point locations to nearest-neighbour polygons