Point-in-poly using MySQL and Python
A couple weeks before the Texas primaries, the Chronicle quietly launched a cool little app that allows readers in our eight-county area to see which political races they can vote in, simply by typing in their address. Some local governments around here offer similar features, but none as lightweight and seamless as what we put together.
I bring this up because the way we implemented this project answers one question the CAR community has chattered about a lot lately: namely, how to run effective point-within-polygon queries using MySQL’s spatial extensions, which don’t yet have the same muscle as ...
-
OpenLawmaking: My Knight News Challenge application (updated)
In which I describe my last-minute entry to the Knight News Challenge. Read | 2 comments
-
Yes, I'm still alive
Some tidbits I've collected over the last month and a half. Read | 0 comments
-
Simple database backups with S3
Backing up your databases is easy with S3, boto and mysqldump. Read | 0 comments
Links
- NAMECHOP Cool little tool for splitting names into component parts. Hat tip to Neil Reisner. (0 comments)
- Congressmen want jail for NASA's credit card abusers | Chron.com Congressional supporters of a bill meant to curb government credit card abuse called Monday for stricter sanctions — including termination and jail time — against employees who misuse the cards ... (0 comments)
- NASA employees big spenders on government credit | Chron.com NASA employees have used government credit cards to ring up iPods, video games and even clothes from the agency's own gift shop, while at other times using the cards in ... (0 comments)
- Houston Politics: Contractors invested in NASA funding fight A quick look at federal contracting records shows that of the 30 members who signed the letter - Lampson included - 26 represent districts that received NASA-related contract business in ... (0 comments)
- Oklahoma Leaks Tens of Thousands of Social Security Numbers And this, friends, is why we always sanitize our input. (0 comments)
- Javascript marker clustering for Google Maps Handles clustering and loadtime issues for Google Maps with large numbers of points. (0 comments)
- Houston Politics: Schatte's Big Easy ties Local developer Andrew Schatte, in the news for his federal indictment alongside business partner Michael Surface, has long made his name in government circles, keeping politicians as close friends, doing ... (0 comments)
