CMS Location Data

[BN_IT_Support]

I have a CMS/Pages custom database that uses a 'location' field.  Can someone tell me where the location data is stored please, it doesn't't appear to be in the CMS ibf_cms_database_xx table.

Thanks

[opentype]

It’s in there. It’s stored like this:

{"lat":null,"long":null,"addressLines":["146 Rua Campevas"],"city":"S\u00e3o Paulo","region":"S\u00e3o Paulo","country":"BR","postalCode":"05016-010"}

And you can just look up the field ID as with any other field. 

[BN_IT_Support]

Got it thanks - stupidly I was looking for a field with 'location' in the name!