wiki:GIS/Data

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

--

GIS Data

Table of Contents

  1. Asia
    1. India
    2. Philippines
    3. Vietnam
  2. Other Data Sources
    1. L0
    2. L1
    3. L2
    4. OGC (WMS/WFS)
    5. Aerial Imagery
  3. See Also

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 (e.g. Kalookan -> Caloocan, Albuquerque -> Alburquerque)

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.