Systems and methods for advanced sanitary sewer infrastructure management

Abstract

Systems and methods for managing a sanitary sewer infrastructure. In an embodiment, a plurality of representations of infrastructure assets are re-projected 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. Each of the re-projected plurality of representations of infrastructure assets and its associated geospatial coordinate is stored in one or more databases. Subsequently, geospatial coordinates, collected in the field, may be received from one or more user devices, wherein each geospatial coordinate corresponds to a geospatial location of an infrastructure asset. A stored geospatial coordinate associated with one or more of the stored re-projected plurality of representations of infrastructure assets may then be adjusted based on the received geospatial coordinates.

What is claimed is: 
     
         1 . A method for managing a sanitary sewer infrastructure, the method comprising using at least one hardware 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.   
     
     
         2 . The method of  claim 1 , comprising using the at least one hardware processor to:
 continually receive datasets comprising an asset identifier and geospatial coordinates, associated with the asset identifier and collected in the field, from one or more user devices; and   continually and automatically adjust stored geospatial coordinates associated with two or more of the stored re-projected plurality of representations of infrastructure assets based on each received dataset.   
     
     
         3 . The method of  claim 1 , further comprising adjusting points of one or more aerial image tiles based on the adjusted stored geo spatial coordinates associated with the first and second stored re-projected representations of infrastructure assets. 
     
     
         4 . The method of  claim 1 , wherein each of the geospatial coordinates, associated with the plurality of re-projected plurality of representations of infrastructure assets in the database, comprises a latitude value, a longitude value, and an elevation value, and is associated with a time, indicating when the geospatial coordinates were collected. 
     
     
         5 . The method of  claim 1 , wherein the re-projected plurality of representations of infrastructure assets comprise a representation of a first manhole and a representation of a second manhole, and wherein the method further comprises using the at least one hardware processor to:
 identify a first geospatial coordinate associated with the representation of the first manhole;   identify a second geospatial coordinate associated with the representation of the second manhole; and   automatically assign one or more geospatial coordinates to a representation of a pipe segment, located between the first manhole and the second manhole, based on the first geospatial coordinate and the second geospatial coordinate.   
     
     
         6 . The method of  claim 1 , further comprising, for each of the re-projected plurality of representations of infrastructure assets, storing the representation of the infrastructure asset in association with two or more attributes, wherein the two or more attributes comprise:
 the geospatial coordinates associated with the re-projected representation of an infrastructure asset; and   one or more of a time, an asset condition, an asset valuation, an environmental measurement, an inspection, a repair history, a contract, a work order, a purchase order, and a bid request.   
     
     
         7 . The method of  claim 6 , further comprising, by an application executed by one or more hardware processors:
 displaying a virtual map; and   displaying one or more of a plurality of layers overlaid on the virtual map, wherein each of the one or more layers comprises a visual depiction of each of a subset of one or more of the stored re-projected plurality of representations of infrastructure assets, wherein each representation of an infrastructure asset in the subset is associated with a set of one or more attributes matching one or more defined criteria.   
     
     
         8 . The method of  claim 7 , further comprising, by the application:
 receiving a selection of three or more points on the virtual map from a user;   determining a geospatial polygon by determining a geospatial coordinate for each of the received three or more points; and   identifying a subset of one or more of the stored re-projected plurality of representations of infrastructure assets that are each associated with a geospatial coordinate within the geospatial polygon; and   associating each of the identified subset of one or more of the stored re-projected plurality of representations of infrastructure assets with a common attribute.   
     
     
         9 . The method of  claim 8 , wherein the common attribute is one or more of a new user-defined layer, a contract, a work order, a purchase order, and a bid request. 
     
     
         10 . The method of  claim 7 , further comprising, by the application:
 receiving a time input from the user; and   updating each of the displayed one or more layers to comprise a visual depiction of each representation of an infrastructure in the subset that is also associated with a time attribute matching the received time input or within a range represented by the received time input.   
     
     
         11 . The method of  claim 7 , further comprising, by the application:
 generating at least one work order data structure representing a work order and corresponding to one or more infrastructure assets; and   associating the at least one work order data structure with a corresponding one or more of the re-projected plurality of representations of infrastructure assets.   
     
     
         12 . The method of  claim 11 , wherein associating the at least one work order data structure with a corresponding one or more of the re-projected plurality of representations of infrastructure assets comprises associating the at least one work order data structure with a fault data structure associated with a representation of an infrastructure asset, wherein the fault data structure represents a fault in the associated representation of an infrastructure asset. 
     
     
         13 . The method of  claim 7 , further comprising, by the application:
 generating at least one project plan data structure representing a project plan and corresponding to one or more infrastructure assets; and   associating the at least one project plan data structure with a corresponding one or more of the re-projected plurality of representations of infrastructure assets.   
     
     
         14 . The method of  claim 13 , wherein the at least one project plan data structure comprises two or more project plan data structures, and wherein the method further comprises using the at least one hardware processor to identify conflicts between two or more project plans based on the two or more project plan data structures. 
     
     
         15 . The method of  claim 14 , further comprising, by the application, highlighting the conflicts on the displayed virtual map. 
     
     
         16 . The method of  claim 13 , further comprising, by the application:
 determining properties affected by the project plan by comparing geospatial coordinates associated with the one or more representations of infrastructure assets associated with the at least one project plan data structure with property records; and   generating a communication to one or more owners of the determined properties.   
     
     
         17 . The method of  claim 16 , wherein each communication comprises a request for permission to enter an owner's property to inspect one or more infrastructure assets, and wherein the method further comprises, by the application, coordinating inspection of the one or more infrastructure assets. 
     
     
         18 . The method of  claim 7 , further comprising:
 receiving a plurality of ratings for a plurality of infrastructure assets;   storing each of the plurality of ratings in association with a corresponding one of the re-projected plurality of representations of infrastructure assets;   modeling one or more maintenance strategies for one or more infrastructure assets based on one or more of the stored plurality of ratings; and   overlaying a depiction of one or more budget scenarios associated with the modeled one or more maintenance strategies over the virtual map.   
     
     
         19 . 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. 
   
     
     
         20 . 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.