No, not "deep shame", rather the opposite. Kudos for digging through the data by hand! :)
Free text fields are hard to analyze because users can put anything there and I guess your approach still provides the most reliable results.
Adding a GPS location to the the json_metadatacould actually make a nice (OPTIONAL) feature for reliable location reporting...