SELECT distinct '<precinct id="10500'|| precinct_id || '">'|| CHR(13) ||
CHR(10) ||'<name>' || location_name || '</name>'|| CHR(13) || CHR(10)
||'<locality_id>1040000' || county_code || '</locality_id>'|| CHR(13) ||
CHR(10) ||'<ward>' || precinct_code || '</ward>'|| CHR(13) || CHR(10)
||'<polling_location_id>109' || location_id ||
'</polling_location_id>'|| CHR(13) || CHR(10) ||'</precinct>' FROM
ems_mdvoters@mdvoters;