<div dir="ltr"><div style="font-family:arial,sans-serif;font-size:13px">For some reason when I reverse_geocode geometry point 0101000020AD10000095D4096822CC53C08A1F63EE5AAA4140</div><div style="font-family:arial,sans-serif;font-size:13px">it returns error </div><div style="font-family:arial,sans-serif;font-size:13px"><div>ERROR:  invalid input syntax for type numeric: " "</div><div>********** Error **********</div><div><br></div><div>ERROR: invalid input syntax for type numeric: " "</div><div>SQL state: 22P02</div></div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">I performed UPDATE tiger.geocode_settings SET setting = 'true' WHERE name = 'debug_reverse_geocode'; to try to get a grasp of what was going on; however, there are so many CTEs in the debug I cant get a grasp of what is really happening. </div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">Does anyone familiar with this system know why this is throwing this error? It seems to only happen with lon,lat around -79.1866 35.3309. </div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">SELECT r.addy[1] FROM reverse_geocode(ST_GeomFromText('POINT(-79.1866 35.3309)',4269),true) AS r<br></div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">NOTICE:  Statement 1: </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">  </span>    WITH ref AS (</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">       </span>        SELECT '0101000020AD10000095D4096822CC53C08A1F63EE5AAA4140'::geometry As ref_geom ) , </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                       </span>f AS </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                     </span>( SELECT faces.* FROM faces  CROSS JOIN ref</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                       </span>WHERE faces.statefp = '37' AND faces.countyfp = '105' </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                            </span>AND ST_Intersects(faces.the_geom, ref_geom)</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                                </span>    ),</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                  </span>e AS </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                     </span>( SELECT edges.tlid , edges.statefp, edges.the_geom, CASE WHEN edges.tfidr = f.tfid THEN 'R' WHEN edges.tfidl = f.tfid THEN 'L' ELSE NULL END::varchar As eside,</div><div style="font-family:arial,sans-serif;font-size:13px">                    ST_ClosestPoint(edges.the_geom,ref_geom) As center_pt, ref_geom</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                         </span>FROM edges INNER JOIN f ON (f.statefp = edges.statefp AND (edges.tfidr = f.tfid OR edges.tfidl = f.tfid)) </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                                </span>    CROSS JOIN ref</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                      </span>WHERE edges.statefp = '37' AND edges.countyfp = '105' </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                            </span>AND ST_DWithin(edges.the_geom, ref.ref_geom, 0.01) AND (edges.mtfcc LIKE 'S%') --only consider streets and roads</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                           </span>  )<span style="white-space:pre-wrap">   </span>,</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                  </span>ea AS </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                    </span>(SELECT e.statefp, e.tlid, a.fromhn, a.tohn, e.center_pt, ref_geom, a.zip, a.side, e.the_geom</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                              </span>FROM e LEFT JOIN addr As a ON (a.statefp = '37'  AND e.tlid = a.tlid and e.eside = a.side) </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                              </span>)</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">          </span>SELECT * </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">         </span>FROM (SELECT DISTINCT ON(tlid,side)  foo.fullname, foo.streetname, foo.streettypeabbrev, foo.zip,  foo.center_pt,</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                        </span>  side, to_number(fromhn, '999999') As fromhn, to_number(tohn, '999999') As tohn, ST_GeometryN(ST_Multi(line),1) As line, </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                      </span>   dist</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">          </span>FROM </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">             </span>  (SELECT e.tlid, e.the_geom As line, n.fullname, COALESCE(n.prequalabr || ' ','')  || <a href="http://n.name/" target="_blank">n.name</a><div style="display:inline-block;width:16px;height:16px"> </div> AS streetname, n.predirabrv, COALESCE(suftypabrv, pretypabrv) As streettypeabbrev,</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">          </span>      n.sufdirabrv, e.zip, e.side, e.fromhn, e.tohn , e.center_pt,</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">             </span>          ST_Distance_Sphere(ST_SetSRID(e.center_pt,4326),ST_SetSRID(ref_geom,4326)) As dist</div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                         </span>FROM ea AS e </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                                     </span>LEFT JOIN (SELECT featnames.* FROM featnames </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                     </span>    WHERE featnames.statefp = '37'   ) AS n ON (n.statefp =  e.statefp AND n.tlid = e.tlid) </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                         </span>ORDER BY dist LIMIT 50 ) As foo </div><div style="font-family:arial,sans-serif;font-size:13px"><span style="white-space:pre-wrap">                          </span>ORDER BY foo.tlid, foo.side,  CASE 0 WHEN 0 THEN 0  WHEN 1 THEN CASE WHEN foo.fullname ~ '[0-9]+' THEN 0 ELSE 1 END ELSE CASE WHEN foo.fullname > '' AND NOT (foo.fullname ~ '[0-9]+') THEN 0 ELSE 1 END END ,  foo.fullname ASC NULLS LAST, dist LIMIT 50) As f ORDER BY f.dist, CASE WHEN fullname > '' THEN 0 ELSE 1 END</div></div>