fix absolute path issue and add community and ward to data