def equip_point_meta
      begin
        equips = read({filter: '"equip"'})['rows']
        puts equips
        equips.map! do |eq|
          eq.delete('disMacro')
          eq['description'] = eq['id'].match(/[(NWTC)|(\$siteRef)] (.*)/)[1]
          eq['id'] = eq['id'].match(/:([a-z0-9\-]*)/)[1]
          eq['points'] = []
          read({filter: "\"point and equipRef==#{eq['id']}\""})['rows'].each do |p|
            p.delete('analytics')
            p.delete('disMacro')
            p.delete('csvUnit')
            p.delete('csvColumn')
            p.delete('equipRef')
            p.delete('point')
            p.delete('siteRef')

            p['id'] = p['id'].match(/:([a-z0-9\-]*)/)[1]
            p['name'] = p['navName']
            p.delete('navName')
            eq['points'] << p
          end
          eq
        end
      rescue Exception => e
        puts "error: #{e}"
        nil
      end
    end
def equip_point_meta
      begin
        equips = read({filter: '"equip"'})['rows']
        puts equips
        equips.map! do |eq|
          eq.delete('disMacro')
          eq['description'] = eq['id'].match(/[(NWTC)|(\$siteRef)] (.*)/)[1]
          eq['id'] = eq['id'].match(/:([a-z0-9\-]*)/)[1]
          eq['points'] = []
          read({filter: "\"point and equipRef==#{eq['id']}\""})['rows'].each do |p|
            p.delete('analytics')
            p.delete('disMacro')
            p.delete('csvUnit')
            p.delete('csvColumn')
            p.delete('equipRef')
            p.delete('point')
            p.delete('siteRef')

            p['id'] = p['id'].match(/:([a-z0-9\-]*)/)[1]
            p['name'] = p['navName']
            p.delete('navName')
            eq['points'] << p
          end
          eq
        end
      rescue Exception => e
        puts "error: #{e}"
        nil
      end
    end
return meta data for all equip with related points