Presumably you'll need to iterate over hosts anyway, so why not move directly towards your automation tools' (ansible, chef, puppet, etc) host inventory and not fuss with DNS...
/etc/ansible/{dev,test,stage,prod}-hosts
[nyc-dns]
10.0.1.1
10.0.2.1
[nyc-web]
10.0.1.21
10.0.2.21
[nyc-db]
10.0.1.201
10.0.2.201
[nyc:children]
nyc-dns
nyc-web
nyc-db
[lax-dns]
10.0.1.1
10.0.2.1
[lax-web]
10.0.1.21
10.0.2.21
[lax-db]
10.0.1.201
10.0.2.201
[lax:children]
lax-dns
lax-web
lax-db
[dns:children]
nyc-dns
lax-dns
[web:children]
nyc-web
lax-web
[db:children]
nyc-db
lax-db