developing for merging grid data stuff
sql stuff working on missing hpms, etc
working on locating the unlocated.
working on locating the unlocated.
Merge branch 'feature/unidentification' into feature/develop
merge
working on this, close to ready to test

unfinished, but committing because my laptop is wonky
Merge branch 'feature/develop' of activimetrics.com:/home/james/repos/temp_jem/hpms_locator into feature/develop
working on finding hpms segments

initial attempt failed.  building on older work is a better idea.  IN
the middle of redoing the sql command to search based on trigram
matching but need to compile the trigram module before I can teest.
committing because laptop is wonky, as always.
working function

can get highland road in Alameda.

haven't yet done anything with highway numbers

need to sort out issue with long roads crossing multiple grid cells.
working on a more complicated query, got zippo
got it for first test case

matching on grid, returning distinct osm_id plus tags
add a bunch of test cases from sql query
add the whole sql query statement
trying to work out a complicated sql query

trying to pull in older sql query technique for tiger stuff to OSM
case.  The issue is that OSM has joined up many (but not all) of the
tiger segments already.

Untested, going a little crazy staring at the sql stuff
hackity hack

added streetlength type, change to that for return type, tweak end of
sql query
tweak response
scratch work developing sql select command
sql select function working for calaveras geary I680

highways are in the multilinestrings table
spit out the link name too

previously was just reporting geom, length.  Added the osm name as well,
to verify that I'm pulling the right street.

works in manual testing for some more difficult streets in Alameda.
Need to code up tests, and need to check length of segment as well.