<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><br class="webkit-block-placeholder"></div><div>I understand that some data "gardening" has just completed.</div><div><br class="webkit-block-placeholder"></div><div>1. U.S. cities used to include the state in their name (e.g. Oakland, California), no longer. e.g Oakland is named "Oakland" with an alias of "Oakland, California".</div><div><br class="webkit-block-placeholder"></div><div>2. mailing addresses which referenced U.S. cities were updated: if the city was defined and the "State" field was empty, the "State" field got filled in with the appropriate state whenever possible.</div><div><br class="webkit-block-placeholder"></div><div>Anyone with an app that uses addresses (like a mapping mashup) would be wise to to look at the "/location/mailing_address" schema and some of your sample data to determine whether any code refactoring is required.</div><div><br class="webkit-block-placeholder"></div><div>I've spot checked a few mailing addresses and cities and things look good, but if you see anything unusual, let me know.</div><div><br class="webkit-block-placeholder"></div><div>Brendan</div><br><div><div>On Mar 26, 2008, at 11:59 AM, brendan wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I post this as a user, because I noticed <a href="http://dev.mqlx.com/~zak/arch/index.html">archiportal</a> had some breakage today after the new freebase release went out. If folks on the dev/data team want to pitch in more info, please do.<div><br class="webkit-block-placeholder"></div><div>1. the property /location/mailing_address/street_address_2 is now hidden in the UI. The UI now allows the user to create multiple values for the "street_address" property, instead.</div><div><br class="webkit-block-placeholder"></div><div>so... WARNING: if you have queries that ask for "/location/mailing_address/street_address" : null</div><div><br class="webkit-block-placeholder"></div><div>prepare for breakage because users are now creating multiple values of street_address through the UI: you must use [] instead of null.</div><div><br class="webkit-block-placeholder"></div><div>2. something less urgent: note that mailing_address now has properties for state and country. As an example, archiportal just asks for the citytown property and passes that and the street address up to the google api to get coordinates. That works because cities are named with the state they are in, for U.S. cities anyhow (e.g. "Oakland, California"). I'm not sure what the data team's plan is for this but eventually, the city names will change and you will have to query out the citytown and the state (and perhaps country) in order to have a fully qualified address. </div><div><br class="webkit-block-placeholder"></div><div>Question for someone on the data team? When you denude city names of the state info, would you please go through all mailing addresses to make sure that the state that the city belongs to is filled in (where it's known of course)? </div><div><br class="webkit-block-placeholder"></div><div>When does the data team plan on doing that?</div><div><br class="webkit-block-placeholder"></div><div>thanks,</div><div><br class="webkit-block-placeholder"></div><div>Brendan</div><div><div><br class="webkit-block-placeholder"></div><div><br></div></div></div>_______________________________________________<br>Developers mailing list<br><a href="mailto:Developers@freebase.com">Developers@freebase.com</a><br>http://lists.freebase.com/mailman/listinfo/developers<br></blockquote></div><br></body></html>