Systems and methods for advanced sanitary sewer infrastructure management

A system for managing a sanitary sewer infrastructure, the system comprising:

• at least one hardware processor;
• and
• at least one executable software module that, when executed by the at least one hardware processor,
• re-project a plurality of representations of infrastructure assets, from one or more computer-aided design (CAD) tiles, from a plane coordinate system into a geospatial coordinate system, such that each of the re-projected plurality of representations of infrastructure assets is associated with a geospatial coordinate,
• store each of the re-projected plurality of representations of infrastructure assets and its associated geospatial coordinate in one or more databases,
• receive an asset identifier and geospatial coordinates, associated with the asset identifier and collected in the field, from a user device, wherein each received geospatial coordinate corresponds to a geospatial location of an infrastructure asset,
• identify a first one of the stored re-projected plurality of representations of infrastructure assets that is associated with the received asset identifier,
• adjust the stored geospatial coordinate associated with the first stored re-projected representation of an infrastructure asset in the database based on the received geospatial coordinate associated with the received asset identifier,
• identify one or more second ones of the stored re-projected plurality of representations of infrastructure assets that were re-projected from a same one of the one or more CAD tiles as the first stored re-projected representation of an infrastructure asset, and,
• for each of the one or more second stored re-projected representations of infrastructure assets, adjust the stored geospatial coordinate associated with the second stored re-projected representation of an infrastructure asset based on a relationship, in one of the one or more CAD tiles, between the second stored re-projected representation of an infrastructure asset and the first stored re-projected representation of an infrastructure asset.

A non-transitory computer-readable medium having instructions stored thereon, wherein the instructions, when executed by a processor, cause the processor to:

• re-project a plurality of representations of infrastructure assets, from one or more computer-aided design (CAD) tiles, from a plane coordinate system into a geospatial coordinate system, such that each of the re-projected plurality of representations of infrastructure assets is associated with a geospatial coordinate;
• store each of the re-projected plurality of representations of infrastructure assets and its associated geospatial coordinate in one or more databases;
• receive an asset identifier and geospatial coordinates, associated with the asset identifier and collected in the field, from a user device, wherein each received geospatial coordinate corresponds to a geospatial location of an infrastructure asset;
• identify a first one of the stored re-projected plurality of representations of infrastructure assets that is associated with the received asset identifier;
• adjust the stored geospatial coordinate associated with the first stored re-projected representation of an infrastructure asset in the database based on the received geospatial coordinate associated with the received asset identifier;
• identify one or more second ones of the stored re-projected plurality of representations of infrastructure assets that were re-projected from a same one of the one or more CAD tiles as the first stored re-projected representation of an infrastructure asset;
• and,
• for each of the one or more second stored re-projected representations of infrastructure assets, adjust the stored geospatial coordinate associated with the second stored re-projected representation of an infrastructure asset based on a relationship, in one of the one or more CAD tiles, between the second stored re-projected representation of an infrastructure asset and the first stored re-projected representation of an infrastructure asset.