I asked the County GIS departments for a shape file with E911 addresses
and they provided it. That worked for 3 counties out of 4. The 4th
didn't have a GIS department....but I got the data from a contractor who
had done GIS work for them.
Anyway, I needed that for other purposes, but once I had it I dropped it
into a MySQL table and then related it to a customer's address table.
So now when you enter a new customer in the system, accurate coordinates
get pulled out of the E911 table without having to rely on any buggy
geolocation.
I had thought about doing something similar to what you're describing,
but by using this pre-populated data. It would be a huge cinch to draw
a polygon in Manifold and populate a "price category" field based on
which polygon the 911 address landed in. It would be straight forward
and fast performing, and not require any GIS or Geocoding to be built
into the website. The only hangup is with user input there are some
roads that they will never spell the same as the database. Nobody is
consistent with numbered routes for example, so even though "NY Route
90" is equivalent to "State Rte 90" it's not obvious to me how the
database query could account for that.
On 2/18/2016 6:13 PM, Joe Falaschi wrote:
Does anyone know of an elegant solution to display a pricing page based on a
street address? I want to create a few polygons and if the address is within
polygon a, b, or c show a different pricing page. We have a wordpress site.
I've seen some google maps example that we can probably make work if done in an
iframe. Just curious if anyone has already done this and has any suggestions
on word press plugins or google maps libraries. Thanks!
Joe Falaschi
e-vergent
