I have a hydrography dataset containing navigable waterways: ponds, lakes, rivers, and streams. I need to find the maximum distance ANY location within the state can be from a navigable waterway. I'm familiar with the st_geometry predicates but I'm not sure how to attack this problem.
I do not have a table of predefined point geometries. The ANY location is the set of X,Y real numbers contained within the state.
I have a collection of polygons and lines, all contained within a much larger region (another polygon) and need to find the X,Y of the most remote point and the distance from it to the nearest waterway.
How do I proceed with figuring out the maximum distance any point can lie from any navigable waterway?
The dataset is large and the geographic area covers an entire state. I don't expect an instant answer and this will not be part of an on-the-fly solution. For development purposes, I have a subset of the dataset covering only a few hundred acres with limited hydrographic features
Postgres 9.6.1 / PostGIS 2.3.1