wiki:GIS/Data

Version 32 (modified by Fran Boon, 11 years ago) ( diff )

+AF_L3

GIS Data

This page lists sources for data, including some which has been pre-formatted for easy import into Sahana Eden.

IMPORTANT NOTE:
BE VERY CAREFUL WITH WHAT PROGRAMS YOU EDIT THESE FILES IN!

  • Excel can lose placenames in unicode languages
  • Excel and Open Office can truncate WKTs

It is safest (and fastest) to use a plain text editor (eg. Notepad++)

Asia

Afghanistan

Admin Boundaries:

These have come originally from COD with Pashto names and better Romanised names from Wikipedia.

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d AF_Lx.7z
python web2py.py -S eden -M

auth.override = True
settings.L10n.languages["prs"] = "Dari"
settings.L10n.languages["ps"] = "Pashto"
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
resource = s3db.resource("gis_location")
filename = "AF_L0.csv"
File = open(filename, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
filename = "AF_L1.csv"
File = open(filename, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
filename = "AF_L2.csv"
File = open(filename, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
filename = "AF_L3.csv"
File = open(filename, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Cambodia

Admin Boundaries:

These have come originally from COD with Khmer names, Hierarchy, Newer locations and better Romanised names from Wikipedia.
(The COD dataset is a little more complete than the GADM one, although is very similar)

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d KH_Lx.7z
python web2py.py -S eden -M

auth.override = True
settings.L10n.languages["km"] = "Khmer"
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "KH_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "KH_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "KH_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "KH_L3.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

India

Admin Boundaries:

These have come from GADM. The state name 'Orissa' has been updated to 'Odisha'.

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d IN_Lx.7z
python web2py.py -S eden -M

auth.override = True
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "IN_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "IN_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "IN_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "IN_L3.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Indonesia

Admin Boundaries:

These have come originally from GADM

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d ID_Lx.7z
python web2py.py -S eden -M

auth.override = True
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "ID_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "ID_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "ID_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Kyrgyzstan

Admin Boundaries:

These have come originally from COD

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d KG_Lx.7z
python web2py.py -S eden -M

auth.override = True
settings.L10n.languages["ky"] = "Kyrgyz"
settings.L10n.languages["ru"] = "Russian"
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "KG_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "KG_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "KG_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Malaysia

Admin Boundaries:

These have come originally from GADM

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d MY_Lx.7z
python web2py.py -S eden -M

auth.override = True
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "MY_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "MY_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "MY_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Myanmar

Admin Boundaries:

These have come originally from COD

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d MM_Lx.7z
python web2py.py -S eden -M

auth.override = True
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "MM_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "MM_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "MM_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "MM_L3.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "MM_L4.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "MM_L5.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Nepal

Admin Boundaries:

These have come originally from GADM

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d NP_Lx.7z
python web2py.py -S eden -M

auth.override = True
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "NP_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "NP_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "NP_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "NP_L3.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "NP_L4.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Philippines

Admin Boundaries:

These have come originally from GADM but have had L1s inserted by PhilGIS so their L1s become L2s, etc

  • Region Names have been modified to the format used by DSWD (Department of Social Welfare & Development)
  • A couple of other names have been corrected
    • Kalookan -> Caloocan
    • Albuquerque -> Alburquerque
    • Ozamis -> Ozamiz
    • Santo Nino -> Santo Niño (x2)
    • Names for Barangays in Tacloban City which have unique ones
    • Cotabato City & Isabela City marked as being directly in their L1s not in the L2s that they're capitals of

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d PH_Lx.7z
python web2py.py -S eden -M

auth.override = True
s3db.gis_location_name.language.requires = IS_IN_SET({"tl":"Tagalog"})
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "PH_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "PH_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "PH_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "PH_L3.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "PH_L4.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Timor-Leste

Admin Boundaries:

These have come originally from COD

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d TL_Lx.7z
python web2py.py -S eden -M

auth.override = True
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "TL_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "TL_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "TL_L3.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Vietnam

Admin Boundaries:

These have come originally from GADM but with their L1 removed (so we use their L2 as our L1, etc)

  • GADM file has terrible problems with place names: at least 3 different encodings!
  • These have mostly been resolved & the file contains place names with no diacritics (to make it easier for non-Vietnamese to search for such places) as well as Vi name_l10n
  • Many updated boundaries from http://gis.chinhphu.vn by selecting the place & then using this JS:
    points = plHighlight[0].latlngs[0];
    output = 'POLYGON ((';
    for (var i=0; i < points.length; i++) {
        p = points[i];
        output += p.longitude;
        output += ' ';
        output += p.latitude;
        output += ',';
    }
    output = output.slice(0, -1);
    output += '))';
    

or

output = 'MULTIPOLYGON (((';
points = plHighlight[0].latlngs[0];
for (var i=0; i < points.length; i++) {
    p = points[i];
    output += p.longitude;
    output += ' ';
    output += p.latitude;
    output += ',';
}
output = output.slice(0, -1); // Strip comma
output += ')),((';
points = plHighlight[1].latlngs[0];
for (var i=0; i < points.length; i++) {
    p = points[i];
    output += p.longitude;
    output += ' ';
    output += p.latitude;
    output += ',';
}
output = output.slice(0, -1); // Strip comma
output += ')))';

& then converted to WGS84 using:

ogr2ogr -f CSV CSV VN2000 Polygons.csv -s_srs EPSG:3405 -t_srs EPSG:4326 -lco GEOMETRY=AS_WKT
  • Old boundaries have been left and start / end dates have been added from Wikipedia.

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d VN_Lx.7z
python web2py.py -S eden -M

auth.override = True
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "VN_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "VN_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "VN_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "VN_L3.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Europe

Greece

Admin Boundaries:

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d JO_Lx.7z
python web2py.py -S eden -M

auth.override = True
settings.L10n.languages["el"] = "Greek"
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "GR_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "GR_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "GR_L3.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "GR_L4.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Middle East

Iraq

Admin Boundaries:

These have come originally from COD

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d IQ_Lx.7z
python web2py.py -S eden -M

auth.override = True
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "IQ_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "IQ_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "IQ_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "IQ_L3.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Jordan

Admin Boundaries:

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d JO_Lx.7z
python web2py.py -S eden -M

auth.override = True
settings.L10n.languages["ar"] = "Arabic"
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "JO_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "JO_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "JO_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "JO_L3.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "JO_Zaatari.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Lebanon

Admin Boundaries:

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d LB_Lx.7z
python web2py.py -S eden -M

auth.override = True
settings.L10n.languages["ar"] = "Arabic"
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "LB_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "LB_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "LB_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "LB_L3.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "LB_Wadi_Khaled.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Syria

Admin Boundaries:

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d SY_Lx.7z
python web2py.py -S eden -M

auth.override = True
settings.L10n.languages["ar"] = "Arabic"
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "SY_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "SY_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "SY_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "SY_L3.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Turkey

Admin Boundaries:

These have come originally from COD

Use 7-Zip to extract to your web2py folder & then install like this:

cd /home/web2py
p7zip -d TR_Lx.7z
python web2py.py -S eden -M

auth.override = True
resource = s3db.resource("gis_location")
stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
import_file = "TR_L0.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "TR_L1.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
import_file = "TR_L2.csv"
File = open(import_file, "r")
resource.import_xml(File, format="csv", stylesheet=stylesheet)
db.commit()
gis.update_location_tree()
db.commit()

Other Data Sources

L0

L1

L2

OGC (WMS/WFS)

Aerial Imagery

See Also

Note: See TracWiki for help on using the wiki.