Data management is a critical component of an integrity management plan. Current products and services in the integrity management sector can generate an enormous amount of uncontrolled and disjointed data, housed on multiple platforms. This text examines methods of mapping and linking multiple data sources to achieve optimal data usefulness, while reducing redundant data, through use of spatial and relational techniques. By defining relationships between fixed points, linear values can be generated from calibrated routes. Developing methods to introduce new data, standardized from spatial data, serves to maintain data quality. Recurring data transfer logistics, using relational keys in conjunction with ETL procedures, serve to link databases. Value is achieved on a large-scale using girth welds to automate the process of generating mile post values for point features. Data generated at remote sensors are aggregated from multiple vendors and populated using an exchange governed by universally unique identifiers (UUID).

Subject
Sensors, Materials, Materials performance, Calibration, Pipelines, Tools, Centerlining, Experimental data, Personnel, Corrosion modeling, Corrosion data, Integrity management, Corrosion protection
Keywords:
database, GIS, remote monitoring, spatial join, linear referencing
© 2022 Association for Materials Protection and Performance (AMPP). All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise) without the prior written permission of AMPP. Positions and opinions advanced in this work are those of the author(s) and not necessarily those of AMPP. Responsibility for the content of the work lies solely with the author(s).
2022
Association for Materials Protection and Performance (AMPP)
You do not currently have access to this content.