TNRIS / InteractiveWaterPlan

Source for the TWDB 2012 Interactive State Water Plan
http://2012.texasstatewaterplan.org
6 stars 0 forks source link

Connect entities to sources via closest point #109

Closed jseppi closed 9 years ago

jseppi commented 9 years ago

Could use CartoDB with an ST_ClosestPoint query: http://www.postgis.org/docs/ST_ClosestPoint.html

Or could precompute by making a table with EntityId, MapSourceId, MappingPoint during the data ETL (ref: http://stackoverflow.com/questions/24415806/coordinate-of-the-closest-point-on-a-line)