Dolbex » 2009

Professional GeoCoding Service

If you have more than a couple thousand records you want to geocode all at once we found a great service from USC’s GIS department that allows you to geocode records in an Access database. It’s not terribly fast but we were able to geocode nearly 200,000 records in a couple of days. Just make sure your computer isn’t set to go to sleep an hour after you step away from the computer…. :/

https://webgis.usc.edu/Default.aspx

Deleting from multiple tables in mySQL

DELETE users.*, profiles.*
FROM users u, profiles prof
WHERE u.id = prof.user_id
AND u.created < '2009-01-01'

Finding and Clearing Orphans

DELETE orphan_table FROM orphan_table
LEFT JOIN user_table
ON orphan_table.user_id = user_table.id
WHERE user_table.id IS NULL;

Geocoding, MySQL | June 30, 2009

Professional GeoCoding Service

MySQL |

Deleting from multiple tables in mySQL

MySQL | June 3, 2009

Finding and Clearing Orphans