Regione Piemonte DAE scrap

portale DAE sanita Regione Piemonte scrap
wget https://portaledae.sanita.regione.piemonte.it/Public/Map


sed -i -e '1,158d' Map
sed -i -e '2,$d' Map


sed -i -e 's/"},/"}\n/g' Map
sed -i -e 's/,/ /g' Map
sed -i -e 's/:null/:"null"/g' Map
sed -i -e 's/://g' Map
sed -i -e "s:\\\[\"]:':g" Map

i segg. da controlalre
sed -i -e 's/\\//g' Map
sed -i -e "s/u0027/'/g" Map


aggiustare campi
awk -F "\"" '{print $3 "," $14 "," $18 "," $22 "," $25 "," $27 "," $32 "," $36 "," $42}' Map > Map.csv

aggiungere
sed -i '1 i\ref,description,addr,location,lat,lon,ref:vatin,access,operator' Map.csv