Scripps Ranch Homeowners Associations
Okay, this is way-cool. My favorite geek, Drew Meyers, shared his latest tech toy on the 
Geek Estate Blog.
It wasn’t immediately obvious to me how I might apply the embeddable spreadsheet feature of Google’s EditGrid, but I have this primal need to try everything at least once. Drew, being the good company man he is, would much rather I share Zillow’s first quarter market report for San Diego. I just may do that soon, but today I will instead share a little project in which we have been knee-deep for the past month.
At a recent Scripps Ranch Community Planning Group meeting, the chair suggested that it would be nice to have a comprehensive list of homeowners associations (HOAs) and management companies for the many neighborhoods comprising Scripps Ranch. His thought was that in the event of future emergencies (think fires), a single go-to resource for contact information would be helpful. So, with the help of our underpaid (as in, “not paid”) high school intern, Jeremy Haywood, we set about compiling the information. The result is the following spreadsheet, presented in two pages. The first indicates whether or not each neighborhood has an HOA and/or Mello Roos assessment, and the second lists the HOA management companies and phone numbers.
We (that would be the “royal we,” think “Jeremy”) are almost finished mapping this information using GoogleMaps. Knowing that you are all now tingly with anticipation, rest assured we will be sharing the visual version of our spreadsheet when it is finished. In the meantime, I am off to think up something else I can put in an embeddable spreadsheet that is not Zillow’s first quarter market report. I just love messin’ with Drew.
May 8th, 2008 at 9:42 am
Since my goal was to get you to post the San Diego sheet using the Edit Grid application, I was only half successful. I suppose I’ll have to devise some new tactics next time. But you’re in luck — I can’t hold it against you that you chose to use editgrid to highlight data other than Zillow’s Q1 report
May 8th, 2008 at 2:42 pm
This is a really nifty little tool… thanks for sharing
May 8th, 2008 at 3:00 pm
Drew says, “You’re welcome.”
May 8th, 2008 at 3:33 pm
What, don’t ya think I can fend for myself Kris?
You’re welcome Utah SEO!!
May 9th, 2008 at 8:09 am
Hey, that’s my idea! After reading Drew’s kewl tip I immediately began a spreadsheet with HOAs & developments in my area to blog about. Mine will have links to their websites as most here are self-managed…but same idea. Unfortunately, I don’t have a Jeremy, so it could be awhile til it’s done. But it is great to see the toolie in action! Nice job!!
May 9th, 2008 at 8:38 am
Lisa - My spreadsheet actuall had all of the web site links. I just deleted that column due to width constraints here. The final version with companion mash-up will ultimately live on our web site and will include that info. Great minds…
May 11th, 2008 at 2:09 pm
That’s a neat application… I wonder if it imports excel spreadsheets? I’ll have to go try it out.
May 11th, 2008 at 3:52 pm
Milan - This was/is an excel spreadsheet which I imported.