I have US zipcodes data in a mysql table where each zipcode shape is stored as polygon. From a given point (latitude and longitude) I want to know the zipcodes that overlap within 1 mile radius and %area overlap.
Output of query zipcode1, %area overlap with radius circle 88235 5% 88236 10% did lot of research doesn't seem any easy solution. http://www.dopefish.de/archives/1245 this is the closest solution but here it assumes two rectangles. For me one is polygon shape and other is imaginary 1 mile radius circle.
أكثر...
Output of query zipcode1, %area overlap with radius circle 88235 5% 88236 10% did lot of research doesn't seem any easy solution. http://www.dopefish.de/archives/1245 this is the closest solution but here it assumes two rectangles. For me one is polygon shape and other is imaginary 1 mile radius circle.
أكثر...