We have all the usual Geo Areas for NYC Metro Area but often want to easily select the TOP INCOME ZIPS in the Metro Area. All of these zip codes would included in one of our other Geo Area options. Is there a limit to how many geo areas a zip code can be assigned?
Thanks
Not certain I’m understanding – an address to me is made up of street address, city, state, postal code and country.
And zip code is just one element of an address. Geo Area would not look at all the elements would it?
I this means that I can’t use Geo Area as a way to identify folks in the Top Zip Codes since all the zip codes have been used to identify parts of the Metro area already.
From: Nick Reilingh [mailto:bounce-nicholasreilingh4883@tessituranetwork.com] Sent: Wednesday, April 06, 2016 3:48 PM To: McKinley, Leslie <LMcKinley@nycitycenter.org> Subject: Re: [Tessitura Technical Forum] Geo-Area Limitations
An address can only be assigned a single geo_area.
It is possible to assign geo_area based on criteria other than zip code, so if you need to split up a zip into multiple geo_areas this is possible, but likely is not done very often.
From: Leslie McKinley <bounce-lesliemckinley4321@tessituranetwork.com> Sent: 4/6/2016 1:41:33 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
As far as tessitura is concerned, an Address is a row in the T_ADDRESS table that has fields for street, city, state, etc, and also has a field for "geo_area", which stores an integer that references a row ID in TR_GEO_AREA. The value of geo_area for an address is set by arbitrary code in a localized procedure -- so the logic that determines which geo_area is assigned to which address doesn't HAVE to be a direct 1:1 assignment based on postal code, but it often is. But I think this point is moot since you are trying to assign based on zip code anyway.
You can use geo_area to identify your top zip codes, you would just be doubling the number of areas. So if your current geo_areas are Manhattan, Bronx, Queens; this would become Top Manhattan, Manhattan, Top Bronx, Bronx, Top Queens, Queens.
Then in criteria builder if you wanted to select your Manhattanites, you'd select both Top Manhattan and Manhattan. If you want just the top zips, you'd select all three of those areas.