[postgis-users] Making Tiger shapefiles routable

2012-03-28 Thread Hilton Long
Has a set of standard queries been developed to make Tiger shapefiles routable? It would need to eliminate gaps and ensure that all end nodes and intersecting nodes corresponded with each other. <>___ postgis-users mailing list postgis-users@pos

[postgis-users] Why aren't ST_ClosestPoints to polylines ST_Contained in those polylines?

2012-03-24 Thread Hilton Long
I created a table of ST_ClosestPoint()s to polylines. I assumed that if the closest points were on the line the queries below would give equal results, but that's not happening. "InsideWorking".simplified is a line. "gaps".closeststartpoint is a point. SELECT "gaps".closeststartpoint FR

[postgis-users] Need help detecting lassos

2012-02-18 Thread Hilton Long
I'd like to be able to detect all line loops that are not closed, but where one end of the line loops around and terminates on another line (a lasso). Querying a table containing several of these returns no ST_IsClosed=true, or ST_IsValid=false, or ST_IsSimple=false. Ultimately, I'd like to spli