...

create schema gadm;

CREATE TABLE gadm.gadm
(
  objectid integer NOT NULL,
  id_0 integer,
  iso character varying(5),
  name_0 character varying(50),
  id_1 integer,
  name_1 character varying(50),
  type_1 character varying(50),
  id_2 integer,
  name_2 character varying(70),
  type_2 character varying(50),
  id_3 integer,
  name_3 character varying(70),
  the_geom geometry,
  CONSTRAINT gadm7_pkey PRIMARY KEY (objectid ),
  CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2),
  CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 4326)
);

Name_0 is the country, Name_1 is the first order administrative areas etc.

ISO is a three letter country code

Getting the data

The Geokettle job GetGadmFromTheWeb.kjb is used to get the data from the web, unpack and store it to the database. The data is replaced

Image Added

Weave configuration

The XML code to incuded in Weave  config.xml

<!-- globalmap -->
<?include config_globalmap/globalmap.xml?>

<?xml version="1.0" encoding="UTF-8"?>

<config xmlns= "urn:com.cohga.server.config#1.0"
xmlns:xsi= "http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd= "http://www.w3.org/2001/XMLSchema"

<?include globalmap_ds_localhost.xml?>
<?include globalmap_gadm.xml?>
<?include globalmap_geonames.xml?>

<!-- resources -->
<?include resources/locale_input_text_en.xml?>
<?include resources/locale_input_text_sv.xml?>
<?include resources/locale_input_text_no.xml?>
<?include resources/locale_input_text_es.xml?>

</config>