WhiteStar asked us to build an extensive web-hosted clip-zip-ship system to provide WhiteStar’s customers with access to their subscribed and cleansed/accurate geodata to replace their former labor-intensive CD-ROM shipping process.
The solution implements a microservces architecture including:
- a PostGIS database under Amazon Web Services’ Relational Database Service;
- an FME Server installation with a complex chain of 20 FME workspaces, 22 linked custom transformers, and a system of publish-subscribe notifications to preprocess and package requested data;
- an extensive Python library to parse queries and generate SQL on top of a complex underlying data schema;
- and an ElasticSearch full-text-search NoSQL database under Compose.io to support coordinate system selection auto-completion within the web application.
The web application allows selection of product, order vs. quote, output coordinate system, product-specific layers, and map-selected or form-entry specification of areas of interest, which are then submitted to the FME server for subsequent generation and delivery of results via subscriber email.