wiki:GIS/Data

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

--

GIS Data

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

Asia

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()

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()

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()

Other Data Sources

L0

L1

L2

OGC (WMS/WFS)

Aerial Imagery

See Also

Note: See TracWiki for help on using the wiki.