Skip to content

Instantly share code, notes, and snippets.

@anjesh
Created June 5, 2014 16:15
Show Gist options
  • Save anjesh/56bc0b8af4cc57c1911b to your computer and use it in GitHub Desktop.
Save anjesh/56bc0b8af4cc57c1911b to your computer and use it in GitHub Desktop.
ogr2ogr -f "kml" Baglung.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Baglung'"
ogr2ogr -f "kml" Mustang.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Mustang'"
ogr2ogr -f "kml" Myagdi.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Myagdi'"
ogr2ogr -f "kml" Parbat.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Parbat'"
ogr2ogr -f "kml" Bhaktapur.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Bhaktapur'"
ogr2ogr -f "kml" Dhading.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Dhading'"
ogr2ogr -f "kml" Kathmandu.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Kathmandu'"
ogr2ogr -f "kml" Kavrepalanchok.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Kavrepalanchok'"
ogr2ogr -f "kml" Lalitpur.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Lalitpur'"
ogr2ogr -f "kml" Nuwakot.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Nuwakot'"
ogr2ogr -f "kml" Rasuwa.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Rasuwa'"
ogr2ogr -f "kml" Sindhupalchok.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Sindhupalchok'"
ogr2ogr -f "kml" Dhanusa.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Dhanusa'"
ogr2ogr -f "kml" Dolakha.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Dolakha'"
ogr2ogr -f "kml" Mahottari.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Mahottari'"
ogr2ogr -f "kml" Ramechhap.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Ramechhap'"
ogr2ogr -f "kml" Sarlahi.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Sarlahi'"
ogr2ogr -f "kml" Sindhuli.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Sindhuli'"
ogr2ogr -f "kml" Bara.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Bara'"
ogr2ogr -f "kml" Makwanpur.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Makwanpur'"
ogr2ogr -f "kml" Parsa.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Parsa'"
ogr2ogr -f "kml" Rautahat.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Rautahat'"
ogr2ogr -f "kml" Chitawan.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Chitawan'"
ogr2ogr -f "kml" Bhojpur.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Bhojpur'"
ogr2ogr -f "kml" Dhankuta.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Dhankuta'"
ogr2ogr -f "kml" Morang.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Morang'"
ogr2ogr -f "kml" Sankhuwasabha.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Sankhuwasabha'"
ogr2ogr -f "kml" Sunsari.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Sunsari'"
ogr2ogr -f "kml" Terhathum.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Terhathum'"
ogr2ogr -f "kml" Ilam.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Ilam'"
ogr2ogr -f "kml" Jhapa.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Jhapa'"
ogr2ogr -f "kml" Panchthar.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Panchthar'"
ogr2ogr -f "kml" Taplejung.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Taplejung'"
ogr2ogr -f "kml" Khotang.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Khotang'"
ogr2ogr -f "kml" Okhaldhunga.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Okhaldhunga'"
ogr2ogr -f "kml" Saptari.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Saptari'"
ogr2ogr -f "kml" Siraha.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Siraha'"
ogr2ogr -f "kml" Solukhumbu.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Solukhumbu'"
ogr2ogr -f "kml" Udayapur.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Udayapur'"
ogr2ogr -f "kml" Baitadi.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Baitadi'"
ogr2ogr -f "kml" Dadeldhura.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Dadeldhura'"
ogr2ogr -f "kml" Darchula.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Darchula'"
ogr2ogr -f "kml" Kanchanpur.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Kanchanpur'"
ogr2ogr -f "kml" Achham.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Achham'"
ogr2ogr -f "kml" Bajhang.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Bajhang'"
ogr2ogr -f "kml" Bajura.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Bajura'"
ogr2ogr -f "kml" Doti.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Doti'"
ogr2ogr -f "kml" Kailali.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Kailali'"
ogr2ogr -f "kml" Banke.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Banke'"
ogr2ogr -f "kml" Bardiya.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Bardiya'"
ogr2ogr -f "kml" Dailekh.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Dailekh'"
ogr2ogr -f "kml" Jajarkot.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Jajarkot'"
ogr2ogr -f "kml" Surkhet.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Surkhet'"
ogr2ogr -f "kml" Dolpa.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Dolpa'"
ogr2ogr -f "kml" Humla.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Humla'"
ogr2ogr -f "kml" Jumla.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Jumla'"
ogr2ogr -f "kml" Kalikot.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Kalikot'"
ogr2ogr -f "kml" Mugu.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Mugu'"
ogr2ogr -f "kml" Dang.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Dang'"
ogr2ogr -f "kml" Pyuthan.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Pyuthan'"
ogr2ogr -f "kml" Rolpa.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Rolpa'"
ogr2ogr -f "kml" Rukum.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Rukum'"
ogr2ogr -f "kml" Salyan.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Salyan'"
ogr2ogr -f "kml" Gorkha.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Gorkha'"
ogr2ogr -f "kml" Kaski.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Kaski'"
ogr2ogr -f "kml" Lamjung.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Lamjung'"
ogr2ogr -f "kml" Manang.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Manang'"
ogr2ogr -f "kml" Syangja.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Syangja'"
ogr2ogr -f "kml" Tanahu.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Tanahu'"
ogr2ogr -f "kml" Kapilbastu.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Kapilbastu'"
ogr2ogr -f "kml" Arghakhanchi.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Arghakhanchi'"
ogr2ogr -f "kml" Gulmi.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Gulmi'"
ogr2ogr -f "kml" Nawalparasi.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Nawalparasi'"
ogr2ogr -f "kml" Palpa.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Palpa'"
ogr2ogr -f "kml" Rupandehi.kml NPL_adm4.shp -sql "select NAME_2 AS ZONE,NAME_3 AS DISTRICT, NAME_4 AS VDC from NPL_adm4 where NAME_3='Rupandehi'"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment