[title type=”2″]1 Day, 1.2m Features, 5 Easy Steps[/title] As a mini project for our Pet Project Day initiative, designed to support our creativity and curiosity around technology, we’ve been able to show in just a single day how quickly a data management system for OS Mastermap with building heights can be put together, providing an industry specific output – in this case AIXM for the Aeronautical and Air Traffic Management industry. [columns count=’2′] [column_item] [title type=”3″]How we did it…[/title] So here’s how to go from the classic OS Mastermap product to an industry specific exchange model in just 5 easy steps:
- Using GO Loader studio and a template project, connect to a database and create the database tables, columns and indexes (primary/foreign key and spatial).
- Again using GO Loader, load the actual OS Mastermap GML data into the database (that’s 1.2 million features folks…).
- Follow up the OS Mastermap load by creating the building heights table and loading the CSV using Oracle SQL Developer.
- Now the data is all present, and linked using the TOID, GO Publisher is used to connect to the database and to create a schema mapping from the OS Mastermap tables to the GML Vertical Structure feature type in the AIXM model. An OGC Web Feature Service is then deployed to a Tomcat 7 application server implementing this runtime schema mapping.
- Finally, using the free ATM Viewer WFS Client, the service can be consumed and the 2.5D buildings with OS Mastermap horizontal geometry and building height property can be displayed.
Thanks and credit to the Ordnance Survey for the data supplied under our developer license. [/column_item] [column_item] [/column_item] [/columns]