Does anyone know of a pre-written function/SQL code (or something similar) that can take an inputted Latitude and Longitude and return the nearest Zip+4 centroid?
I see many offerings for products/data that will give the lat/long for a given zip5 or zip+4, but nothing that does it in the other direction. Could somebody help me a bit on this, either a known piece of code or a way to do it in SQL. I have standard edition so I do not have Oracle Spatial, only Oracle Locator.
Also, if you know of a product that can do this, I'm willing to buy the code or data. I haven't found anything out there myself.
Thanks,
Dan
Show trimmed content