create table ATM (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Adm (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, level int4 not null, parent int8, primary key (id));
create table Airport (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table AlternateName (id int8 not null, name varchar(200) not null, language varchar(7), source int4 not null, preferredName bool not null, shortName bool not null, alternateNameId int4, gisFeature int8 not null, primary key (id));
create table AmusePark (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Aqueduc (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Bank (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Bar (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Bay (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Beach (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Bridge (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Building (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table BusStation (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Camp (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Canyon (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Casino (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Castle (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Cemetery (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Cirque (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table City (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, zipCode int4, primary key (id));
create table CitySubdivision (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, zipCode int4, primary key (id));
create table Cliff (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Coast (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Continent (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Country (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, currencyCode varchar(255), area float8, equivalentFipsCode varchar(255), fipsCode varchar(255) unique, iso3166Alpha2Code varchar(255) not null unique, iso3166Alpha3Code varchar(255) not null unique, iso3166NumericCode int4 not null unique, phonePrefix varchar(255), postalCodeMask varchar(255), capitalName varchar(255), continent varchar(255), currencyName varchar(255), postalCodeRegex varchar(255), tld varchar(255), primary key (id));
create table Country_Language (Country_id int8 not null, spokenLanguages_id int8 not null);
create table CourtHouse (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table CustomsPost (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Dam (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Desert (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Factory (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Falls (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Farm (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Field (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table FishingArea (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Fjord (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Forest (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Garden (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table GisFeature (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Golf (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Gorge (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table GrassLand (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Gulf (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Hill (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Hospital (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Hotel (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table House (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Ice (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Island (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Lake (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Language (id int8 not null, iso639Alpha2LanguageCode varchar(255) unique, iso639Alpha3LanguageCode varchar(255) not null unique, iso639LanguageName varchar(255) not null unique, primary key (id));
create table Library (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table LightHouse (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Mall (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Marsh (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table MetroStation (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Military (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Mill (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Mine (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Mole (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Monument (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Mound (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Mountain (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Museum (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Oasis (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table ObservatoryPoint (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Ocean (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table OperaHouse (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Park (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Parking (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Plantation (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table PolicePost (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table PoliticalEntity (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Pond (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Port (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table PostOffice (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Prison (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Pyramid (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Quay (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Rail (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table RailRoadStation (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Ranch (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Ravin (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Reef (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Religious (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Reserve (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Restaurant (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Road (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table School (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Sea (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Spring (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Stadium (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table StatsUsage (id int8 not null, usage int8, statsUsageType varchar(255) not null unique, primary key (id));
create table Strait (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Stream (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Street (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Theater (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Tower (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Tree (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Tunnel (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table UnderSea (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Vineyard (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Volcano (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table WaterBody (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table Zoo (id int8 not null, name varchar(200) not null, location geometry not null, source varchar(255) not null, timezone varchar(40), countryCode varchar(3), adm1Code varchar(20), adm2Code varchar(80), adm3Code varchar(20), adm4Code varchar(20), featureId int8 not null unique, modificationDate timestamp, adm1Name varchar(200), adm2Name varchar(200), adm3Name varchar(200), adm4Name varchar(200), asciiName varchar(200), elevation int4, gtopo30 int4, population int4, featureClass varchar(4), featureCode varchar(10), adm int8, primary key (id));
create table app_user (id int8 not null, address varchar(150), country varchar(100), city varchar(50) not null, province varchar(100), postal_code varchar(15) not null, version int4, account_enabled bool, username varchar(50) not null unique, password varchar(255) not null, email varchar(255) not null unique, password_hint varchar(255), first_name varchar(50) not null, last_name varchar(50) not null, phone_number varchar(255), website varchar(255), account_expired bool not null, account_locked bool not null, credentials_expired bool not null, primary key (id));
create table role (id int8 not null, name varchar(20), description varchar(64), primary key (id));
create table user_role (user_id int8 not null, role_id int8 not null, primary key (user_id, role_id));
create index ATMgisFeatureCountryindex on ATM (countryCode);
create index ATMadm2NameIndex on ATM (adm2Name);
create index ATMgisFeatureIdIndex on ATM (featureId);
create index ATMadm4NameIndex on ATM (adm4Name);
create index ATMgisFeatureAsciiNameIndex on ATM (asciiName);
create index ATMadm1codeIndex on ATM (adm1Code);
create index ATMadm3codeIndex on ATM (adm3Code);
create index ATMgisFeatureFeatureClassindex on ATM (featureClass);
create index ATMadm2codeIndex on ATM (adm2Code);
create index ATMgisFeatureFeatureCodeindex on ATM (featureCode);
create index ATMadm3NameIndex on ATM (adm3Name);
create index ATMadm1NameIndex on ATM (adm1Name);
create index ATMadm4codeIndex on ATM (adm4Code);
create index ATMgisFeatureNameIndex on ATM (name);
alter table ATM add constraint FK637222053AEF83Dfe7a foreign key (adm) references Adm;
create index AdmgisFeatureCountryindex on Adm (countryCode);
create index Admadm2NameIndex on Adm (adm2Name);
create index AdmgisFeatureIdIndex on Adm (featureId);
create index Admadm4NameIndex on Adm (adm4Name);
create index AdmgisFeatureAsciiNameIndex on Adm (asciiName);
create index Admadm1codeIndex on Adm (adm1Code);
create index Admadm3codeIndex on Adm (adm3Code);
create index AdmgisFeatureFeatureClassindex on Adm (featureClass);
create index Admadm2codeIndex on Adm (adm2Code);
create index AdmgisFeatureFeatureCodeindex on Adm (featureCode);
create index Admadm3NameIndex on Adm (adm3Name);
create index Admadm1NameIndex on Adm (adm1Name);
create index Admadm4codeIndex on Adm (adm4Code);
create index AdmgisFeatureNameIndex on Adm (name);
create index admLevel on Adm (level);
alter table Adm add constraint FK637222053AEF83D1008a foreign key (adm) references Adm;
alter table Adm add constraint FK1008AC858883D foreign key (parent) references Adm;
create index AirportgisFeatureCountryindex on Airport (countryCode);
create index Airportadm2NameIndex on Airport (adm2Name);
create index AirportgisFeatureIdIndex on Airport (featureId);
create index Airportadm4NameIndex on Airport (adm4Name);
create index AirportgisFeatureAsciiNameIndex on Airport (asciiName);
create index Airportadm1codeIndex on Airport (adm1Code);
create index Airportadm3codeIndex on Airport (adm3Code);
create index AirportgisFeatureFeatureClassindex on Airport (featureClass);
create index Airportadm2codeIndex on Airport (adm2Code);
create index AirportgisFeatureFeatureCodeindex on Airport (featureCode);
create index Airportadm3NameIndex on Airport (adm3Name);
create index Airportadm1NameIndex on Airport (adm1Name);
create index Airportadm4codeIndex on Airport (adm4Code);
create index AirportgisFeatureNameIndex on Airport (name);
alter table Airport add constraint FK637222053AEF83D281cf4ab foreign key (adm) references Adm;
create index AlternatenameGisFeatureindex on AlternateName (gisFeature);
create index Alternatenameindex on AlternateName (name);
create index AmuseParkgisFeatureCountryindex on AmusePark (countryCode);
create index AmuseParkadm2NameIndex on AmusePark (adm2Name);
create index AmuseParkgisFeatureIdIndex on AmusePark (featureId);
create index AmuseParkadm4NameIndex on AmusePark (adm4Name);
create index AmuseParkgisFeatureAsciiNameIndex on AmusePark (asciiName);
create index AmuseParkadm1codeIndex on AmusePark (adm1Code);
create index AmuseParkadm3codeIndex on AmusePark (adm3Code);
create index AmuseParkgisFeatureFeatureClassindex on AmusePark (featureClass);
create index AmuseParkadm2codeIndex on AmusePark (adm2Code);
create index AmuseParkgisFeatureFeatureCodeindex on AmusePark (featureCode);
create index AmuseParkadm3NameIndex on AmusePark (adm3Name);
create index AmuseParkadm1NameIndex on AmusePark (adm1Name);
create index AmuseParkadm4codeIndex on AmusePark (adm4Code);
create index AmuseParkgisFeatureNameIndex on AmusePark (name);
alter table AmusePark add constraint FK637222053AEF83Dd76bcc45 foreign key (adm) references Adm;
create index AqueducgisFeatureCountryindex on Aqueduc (countryCode);
create index Aqueducadm2NameIndex on Aqueduc (adm2Name);
create index AqueducgisFeatureIdIndex on Aqueduc (featureId);
create index Aqueducadm4NameIndex on Aqueduc (adm4Name);
create index AqueducgisFeatureAsciiNameIndex on Aqueduc (asciiName);
create index Aqueducadm1codeIndex on Aqueduc (adm1Code);
create index Aqueducadm3codeIndex on Aqueduc (adm3Code);
create index AqueducgisFeatureFeatureClassindex on Aqueduc (featureClass);
create index Aqueducadm2codeIndex on Aqueduc (adm2Code);
create index AqueducgisFeatureFeatureCodeindex on Aqueduc (featureCode);
create index Aqueducadm3NameIndex on Aqueduc (adm3Name);
create index Aqueducadm1NameIndex on Aqueduc (adm1Name);
create index Aqueducadm4codeIndex on Aqueduc (adm4Code);
create index AqueducgisFeatureNameIndex on Aqueduc (name);
alter table Aqueduc add constraint FK637222053AEF83D35e8d712 foreign key (adm) references Adm;
create index BankgisFeatureCountryindex on Bank (countryCode);
create index Bankadm2NameIndex on Bank (adm2Name);
create index BankgisFeatureIdIndex on Bank (featureId);
create index Bankadm4NameIndex on Bank (adm4Name);
create index BankgisFeatureAsciiNameIndex on Bank (asciiName);
create index Bankadm1codeIndex on Bank (adm1Code);
create index Bankadm3codeIndex on Bank (adm3Code);
create index BankgisFeatureFeatureClassindex on Bank (featureClass);
create index Bankadm2codeIndex on Bank (adm2Code);
create index BankgisFeatureFeatureCodeindex on Bank (featureCode);
create index Bankadm3NameIndex on Bank (adm3Name);
create index Bankadm1NameIndex on Bank (adm1Name);
create index Bankadm4codeIndex on Bank (adm4Code);
create index BankgisFeatureNameIndex on Bank (name);
alter table Bank add constraint FK637222053AEF83D1f7a5c foreign key (adm) references Adm;
create index BargisFeatureCountryindex on Bar (countryCode);
create index Baradm2NameIndex on Bar (adm2Name);
create index BargisFeatureIdIndex on Bar (featureId);
create index Baradm4NameIndex on Bar (adm4Name);
create index BargisFeatureAsciiNameIndex on Bar (asciiName);
create index Baradm1codeIndex on Bar (adm1Code);
create index Baradm3codeIndex on Bar (adm3Code);
create index BargisFeatureFeatureClassindex on Bar (featureClass);
create index Baradm2codeIndex on Bar (adm2Code);
create index BargisFeatureFeatureCodeindex on Bar (featureCode);
create index Baradm3NameIndex on Bar (adm3Name);
create index Baradm1NameIndex on Bar (adm1Name);
create index Baradm4codeIndex on Bar (adm4Code);
create index BargisFeatureNameIndex on Bar (name);
alter table Bar add constraint FK637222053AEF83D103f3 foreign key (adm) references Adm;
create index BaygisFeatureCountryindex on Bay (countryCode);
create index Bayadm2NameIndex on Bay (adm2Name);
create index BaygisFeatureIdIndex on Bay (featureId);
create index Bayadm4NameIndex on Bay (adm4Name);
create index BaygisFeatureAsciiNameIndex on Bay (asciiName);
create index Bayadm1codeIndex on Bay (adm1Code);
create index Bayadm3codeIndex on Bay (adm3Code);
create index BaygisFeatureFeatureClassindex on Bay (featureClass);
create index Bayadm2codeIndex on Bay (adm2Code);
create index BaygisFeatureFeatureCodeindex on Bay (featureCode);
create index Bayadm3NameIndex on Bay (adm3Name);
create index Bayadm1NameIndex on Bay (adm1Name);
create index Bayadm4codeIndex on Bay (adm4Code);
create index BaygisFeatureNameIndex on Bay (name);
alter table Bay add constraint FK637222053AEF83D103fa foreign key (adm) references Adm;
create index BeachgisFeatureCountryindex on Beach (countryCode);
create index Beachadm2NameIndex on Beach (adm2Name);
create index BeachgisFeatureIdIndex on Beach (featureId);
create index Beachadm4NameIndex on Beach (adm4Name);
create index BeachgisFeatureAsciiNameIndex on Beach (asciiName);
create index Beachadm1codeIndex on Beach (adm1Code);
create index Beachadm3codeIndex on Beach (adm3Code);
create index BeachgisFeatureFeatureClassindex on Beach (featureClass);
create index Beachadm2codeIndex on Beach (adm2Code);
create index BeachgisFeatureFeatureCodeindex on Beach (featureCode);
create index Beachadm3NameIndex on Beach (adm3Name);
create index Beachadm1NameIndex on Beach (adm1Name);
create index Beachadm4codeIndex on Beach (adm4Code);
create index BeachgisFeatureNameIndex on Beach (name);
alter table Beach add constraint FK637222053AEF83D3d17143 foreign key (adm) references Adm;
create index BridgegisFeatureCountryindex on Bridge (countryCode);
create index Bridgeadm2NameIndex on Bridge (adm2Name);
create index BridgegisFeatureIdIndex on Bridge (featureId);
create index Bridgeadm4NameIndex on Bridge (adm4Name);
create index BridgegisFeatureAsciiNameIndex on Bridge (asciiName);
create index Bridgeadm1codeIndex on Bridge (adm1Code);
create index Bridgeadm3codeIndex on Bridge (adm3Code);
create index BridgegisFeatureFeatureClassindex on Bridge (featureClass);
create index Bridgeadm2codeIndex on Bridge (adm2Code);
create index BridgegisFeatureFeatureCodeindex on Bridge (featureCode);
create index Bridgeadm3NameIndex on Bridge (adm3Name);
create index Bridgeadm1NameIndex on Bridge (adm1Name);
create index Bridgeadm4codeIndex on Bridge (adm4Code);
create index BridgegisFeatureNameIndex on Bridge (name);
alter table Bridge add constraint FK637222053AEF83D77178fa9 foreign key (adm) references Adm;
create index BuildinggisFeatureCountryindex on Building (countryCode);
create index Buildingadm2NameIndex on Building (adm2Name);
create index BuildinggisFeatureIdIndex on Building (featureId);
create index Buildingadm4NameIndex on Building (adm4Name);
create index BuildinggisFeatureAsciiNameIndex on Building (asciiName);
create index Buildingadm1codeIndex on Building (adm1Code);
create index Buildingadm3codeIndex on Building (adm3Code);
create index BuildinggisFeatureFeatureClassindex on Building (featureClass);
create index Buildingadm2codeIndex on Building (adm2Code);
create index BuildinggisFeatureFeatureCodeindex on Building (featureCode);
create index Buildingadm3NameIndex on Building (adm3Name);
create index Buildingadm1NameIndex on Building (adm1Name);
create index Buildingadm4codeIndex on Building (adm4Code);
create index BuildinggisFeatureNameIndex on Building (name);
alter table Building add constraint FK637222053AEF83Dae9476d4 foreign key (adm) references Adm;
create index BusStationgisFeatureCountryindex on BusStation (countryCode);
create index BusStationadm2NameIndex on BusStation (adm2Name);
create index BusStationgisFeatureIdIndex on BusStation (featureId);
create index BusStationadm4NameIndex on BusStation (adm4Name);
create index BusStationgisFeatureAsciiNameIndex on BusStation (asciiName);
create index BusStationadm1codeIndex on BusStation (adm1Code);
create index BusStationadm3codeIndex on BusStation (adm3Code);
create index BusStationgisFeatureFeatureClassindex on BusStation (featureClass);
create index BusStationadm2codeIndex on BusStation (adm2Code);
create index BusStationgisFeatureFeatureCodeindex on BusStation (featureCode);
create index BusStationadm3NameIndex on BusStation (adm3Name);
create index BusStationadm1NameIndex on BusStation (adm1Name);
create index BusStationadm4codeIndex on BusStation (adm4Code);
create index BusStationgisFeatureNameIndex on BusStation (name);
alter table BusStation add constraint FK637222053AEF83D5a81a6b4 foreign key (adm) references Adm;
create index CampgisFeatureCountryindex on Camp (countryCode);
create index Campadm2NameIndex on Camp (adm2Name);
create index CampgisFeatureIdIndex on Camp (featureId);
create index Campadm4NameIndex on Camp (adm4Name);
create index CampgisFeatureAsciiNameIndex on Camp (asciiName);
create index Campadm1codeIndex on Camp (adm1Code);
create index Campadm3codeIndex on Camp (adm3Code);
create index CampgisFeatureFeatureClassindex on Camp (featureClass);
create index Campadm2codeIndex on Camp (adm2Code);
create index CampgisFeatureFeatureCodeindex on Camp (featureCode);
create index Campadm3NameIndex on Camp (adm3Name);
create index Campadm1NameIndex on Camp (adm1Name);
create index Campadm4codeIndex on Camp (adm4Code);
create index CampgisFeatureNameIndex on Camp (name);
alter table Camp add constraint FK637222053AEF83D1feea1 foreign key (adm) references Adm;
create index CanyongisFeatureCountryindex on Canyon (countryCode);
create index Canyonadm2NameIndex on Canyon (adm2Name);
create index CanyongisFeatureIdIndex on Canyon (featureId);
create index Canyonadm4NameIndex on Canyon (adm4Name);
create index CanyongisFeatureAsciiNameIndex on Canyon (asciiName);
create index Canyonadm1codeIndex on Canyon (adm1Code);
create index Canyonadm3codeIndex on Canyon (adm3Code);
create index CanyongisFeatureFeatureClassindex on Canyon (featureClass);
create index Canyonadm2codeIndex on Canyon (adm2Code);
create index CanyongisFeatureFeatureCodeindex on Canyon (featureCode);
create index Canyonadm3NameIndex on Canyon (adm3Name);
create index Canyonadm1NameIndex on Canyon (adm1Name);
create index Canyonadm4codeIndex on Canyon (adm4Code);
create index CanyongisFeatureNameIndex on Canyon (name);
alter table Canyon add constraint FK637222053AEF83D77df6e68 foreign key (adm) references Adm;
create index CasinogisFeatureCountryindex on Casino (countryCode);
create index Casinoadm2NameIndex on Casino (adm2Name);
create index CasinogisFeatureIdIndex on Casino (featureId);
create index Casinoadm4NameIndex on Casino (adm4Name);
create index CasinogisFeatureAsciiNameIndex on Casino (asciiName);
create index Casinoadm1codeIndex on Casino (adm1Code);
create index Casinoadm3codeIndex on Casino (adm3Code);
create index CasinogisFeatureFeatureClassindex on Casino (featureClass);
create index Casinoadm2codeIndex on Casino (adm2Code);
create index CasinogisFeatureFeatureCodeindex on Casino (featureCode);
create index Casinoadm3NameIndex on Casino (adm3Name);
create index Casinoadm1NameIndex on Casino (adm1Name);
create index Casinoadm4codeIndex on Casino (adm4Code);
create index CasinogisFeatureNameIndex on Casino (name);
alter table Casino add constraint FK637222053AEF83D77e17815 foreign key (adm) references Adm;
create index CastlegisFeatureCountryindex on Castle (countryCode);
create index Castleadm2NameIndex on Castle (adm2Name);
create index CastlegisFeatureIdIndex on Castle (featureId);
create index Castleadm4NameIndex on Castle (adm4Name);
create index CastlegisFeatureAsciiNameIndex on Castle (asciiName);
create index Castleadm1codeIndex on Castle (adm1Code);
create index Castleadm3codeIndex on Castle (adm3Code);
create index CastlegisFeatureFeatureClassindex on Castle (featureClass);
create index Castleadm2codeIndex on Castle (adm2Code);
create index CastlegisFeatureFeatureCodeindex on Castle (featureCode);
create index Castleadm3NameIndex on Castle (adm3Name);
create index Castleadm1NameIndex on Castle (adm1Name);
create index Castleadm4codeIndex on Castle (adm4Code);
create index CastlegisFeatureNameIndex on Castle (name);
alter table Castle add constraint FK637222053AEF83D77e1a118 foreign key (adm) references Adm;
create index CemeterygisFeatureCountryindex on Cemetery (countryCode);
create index Cemeteryadm2NameIndex on Cemetery (adm2Name);
create index CemeterygisFeatureIdIndex on Cemetery (featureId);
create index Cemeteryadm4NameIndex on Cemetery (adm4Name);
create index CemeterygisFeatureAsciiNameIndex on Cemetery (asciiName);
create index Cemeteryadm1codeIndex on Cemetery (adm1Code);
create index Cemeteryadm3codeIndex on Cemetery (adm3Code);
create index CemeterygisFeatureFeatureClassindex on Cemetery (featureClass);
create index Cemeteryadm2codeIndex on Cemetery (adm2Code);
create index CemeterygisFeatureFeatureCodeindex on Cemetery (featureCode);
create index Cemeteryadm3NameIndex on Cemetery (adm3Name);
create index Cemeteryadm1NameIndex on Cemetery (adm1Name);
create index Cemeteryadm4codeIndex on Cemetery (adm4Code);
create index CemeterygisFeatureNameIndex on Cemetery (name);
alter table Cemetery add constraint FK637222053AEF83Dce89e512 foreign key (adm) references Adm;
create index CirquegisFeatureCountryindex on Cirque (countryCode);
create index Cirqueadm2NameIndex on Cirque (adm2Name);
create index CirquegisFeatureIdIndex on Cirque (featureId);
create index Cirqueadm4NameIndex on Cirque (adm4Name);
create index CirquegisFeatureAsciiNameIndex on Cirque (asciiName);
create index Cirqueadm1codeIndex on Cirque (adm1Code);
create index Cirqueadm3codeIndex on Cirque (adm3Code);
create index CirquegisFeatureFeatureClassindex on Cirque (featureClass);
create index Cirqueadm2codeIndex on Cirque (adm2Code);
create index CirquegisFeatureFeatureCodeindex on Cirque (featureCode);
create index Cirqueadm3NameIndex on Cirque (adm3Name);
create index Cirqueadm1NameIndex on Cirque (adm1Name);
create index Cirqueadm4codeIndex on Cirque (adm4Code);
create index CirquegisFeatureNameIndex on Cirque (name);
alter table Cirque add constraint FK637222053AEF83D7851de95 foreign key (adm) references Adm;
create index CitygisFeatureCountryindex on City (countryCode);
create index Cityadm2NameIndex on City (adm2Name);
create index CitygisFeatureIdIndex on City (featureId);
create index Cityadm4NameIndex on City (adm4Name);
create index CitygisFeatureAsciiNameIndex on City (asciiName);
create index Cityadm1codeIndex on City (adm1Code);
create index Cityadm3codeIndex on City (adm3Code);
create index CitygisFeatureFeatureClassindex on City (featureClass);
create index Cityadm2codeIndex on City (adm2Code);
create index CitygisFeatureFeatureCodeindex on City (featureCode);
create index Cityadm3NameIndex on City (adm3Name);
create index Cityadm1NameIndex on City (adm1Name);
create index Cityadm4codeIndex on City (adm4Code);
create index CitygisFeatureNameIndex on City (name);
create index cityZipCode on City (zipCode);
alter table City add constraint FK637222053AEF83D200d8b foreign key (adm) references Adm;
create index CitySubdivisiongisFeatureCountryindex on CitySubdivision (countryCode);
create index CitySubdivisionadm2NameIndex on CitySubdivision (adm2Name);
create index CitySubdivisiongisFeatureIdIndex on CitySubdivision (featureId);
create index CitySubdivisionadm4NameIndex on CitySubdivision (adm4Name);
create index CitySubdivisiongisFeatureAsciiNameIndex on CitySubdivision (asciiName);
create index CitySubdivisionadm1codeIndex on CitySubdivision (adm1Code);
create index CitySubdivisionadm3codeIndex on CitySubdivision (adm3Code);
create index CitySubdivisiongisFeatureFeatureClassindex on CitySubdivision (featureClass);
create index CitySubdivisionadm2codeIndex on CitySubdivision (adm2Code);
create index CitySubdivisiongisFeatureFeatureCodeindex on CitySubdivision (featureCode);
create index CitySubdivisionadm3NameIndex on CitySubdivision (adm3Name);
create index CitySubdivisionadm1NameIndex on CitySubdivision (adm1Name);
create index CitySubdivisionadm4codeIndex on CitySubdivision (adm4Code);
create index CitySubdivisiongisFeatureNameIndex on CitySubdivision (name);
create index citySubdivisionZipCode on CitySubdivision (zipCode);
alter table CitySubdivision add constraint FK637222053AEF83Da260f462 foreign key (adm) references Adm;
create index CliffgisFeatureCountryindex on Cliff (countryCode);
create index Cliffadm2NameIndex on Cliff (adm2Name);
create index CliffgisFeatureIdIndex on Cliff (featureId);
create index Cliffadm4NameIndex on Cliff (adm4Name);
create index CliffgisFeatureAsciiNameIndex on Cliff (asciiName);
create index Cliffadm1codeIndex on Cliff (adm1Code);
create index Cliffadm3codeIndex on Cliff (adm3Code);
create index CliffgisFeatureFeatureClassindex on Cliff (featureClass);
create index Cliffadm2codeIndex on Cliff (adm2Code);
create index CliffgisFeatureFeatureCodeindex on Cliff (featureCode);
create index Cliffadm3NameIndex on Cliff (adm3Name);
create index Cliffadm1NameIndex on Cliff (adm1Name);
create index Cliffadm4codeIndex on Cliff (adm4Code);
create index CliffgisFeatureNameIndex on Cliff (name);
alter table Cliff add constraint FK637222053AEF83D3e2d5c0 foreign key (adm) references Adm;
create index CoastgisFeatureCountryindex on Coast (countryCode);
create index Coastadm2NameIndex on Coast (adm2Name);
create index CoastgisFeatureIdIndex on Coast (featureId);
create index Coastadm4NameIndex on Coast (adm4Name);
create index CoastgisFeatureAsciiNameIndex on Coast (asciiName);
create index Coastadm1codeIndex on Coast (adm1Code);
create index Coastadm3codeIndex on Coast (adm3Code);
create index CoastgisFeatureFeatureClassindex on Coast (featureClass);
create index Coastadm2codeIndex on Coast (adm2Code);
create index CoastgisFeatureFeatureCodeindex on Coast (featureCode);
create index Coastadm3NameIndex on Coast (adm3Name);
create index Coastadm1NameIndex on Coast (adm1Name);
create index Coastadm4codeIndex on Coast (adm4Code);
create index CoastgisFeatureNameIndex on Coast (name);
alter table Coast add constraint FK637222053AEF83D3e41676 foreign key (adm) references Adm;
create index ContinentgisFeatureCountryindex on Continent (countryCode);
create index Continentadm2NameIndex on Continent (adm2Name);
create index ContinentgisFeatureIdIndex on Continent (featureId);
create index Continentadm4NameIndex on Continent (adm4Name);
create index ContinentgisFeatureAsciiNameIndex on Continent (asciiName);
create index Continentadm1codeIndex on Continent (adm1Code);
create index Continentadm3codeIndex on Continent (adm3Code);
create index ContinentgisFeatureFeatureClassindex on Continent (featureClass);
create index Continentadm2codeIndex on Continent (adm2Code);
create index ContinentgisFeatureFeatureCodeindex on Continent (featureCode);
create index Continentadm3NameIndex on Continent (adm3Name);
create index Continentadm1NameIndex on Continent (adm1Name);
create index Continentadm4codeIndex on Continent (adm4Code);
create index ContinentgisFeatureNameIndex on Continent (name);
alter table Continent add constraint FK637222053AEF83D5f664d94 foreign key (adm) references Adm;
create index CountrygisFeatureCountryindex on Country (countryCode);
create index Countryadm2NameIndex on Country (adm2Name);
create index CountrygisFeatureIdIndex on Country (featureId);
create index Countryadm4NameIndex on Country (adm4Name);
create index CountrygisFeatureAsciiNameIndex on Country (asciiName);
create index Countryadm1codeIndex on Country (adm1Code);
create index Countryadm3codeIndex on Country (adm3Code);
create index CountrygisFeatureFeatureClassindex on Country (featureClass);
create index Countryadm2codeIndex on Country (adm2Code);
create index CountrygisFeatureFeatureCodeindex on Country (featureCode);
create index Countryadm3NameIndex on Country (adm3Name);
create index Countryadm1NameIndex on Country (adm1Name);
create index Countryadm4codeIndex on Country (adm4Code);
create index CountrygisFeatureNameIndex on Country (name);
create index countryIso3166NumericCodeIndex on Country (iso3166NumericCode);
create index countryIso3166Alpha2CodeIndex on Country (iso3166Alpha2Code);
create index countryIso3166Alpha3CodeIndex on Country (iso3166Alpha3Code);
create index countryFipsCode on Country (fipsCode);
alter table Country add constraint FK637222053AEF83D9c4fef76 foreign key (adm) references Adm;
alter table Country_Language add constraint FKA0193E21E34DFE30 foreign key (spokenLanguages_id) references Language;
alter table Country_Language add constraint FKA0193E21AB7EAC63 foreign key (Country_id) references Country;
create index CourtHousegisFeatureCountryindex on CourtHouse (countryCode);
create index CourtHouseadm2NameIndex on CourtHouse (adm2Name);
create index CourtHousegisFeatureIdIndex on CourtHouse (featureId);
create index CourtHouseadm4NameIndex on CourtHouse (adm4Name);
create index CourtHousegisFeatureAsciiNameIndex on CourtHouse (asciiName);
create index CourtHouseadm1codeIndex on CourtHouse (adm1Code);
create index CourtHouseadm3codeIndex on CourtHouse (adm3Code);
create index CourtHousegisFeatureFeatureClassindex on CourtHouse (featureClass);
create index CourtHouseadm2codeIndex on CourtHouse (adm2Code);
create index CourtHousegisFeatureFeatureCodeindex on CourtHouse (featureCode);
create index CourtHouseadm3NameIndex on CourtHouse (adm3Name);
create index CourtHouseadm1NameIndex on CourtHouse (adm1Name);
create index CourtHouseadm4codeIndex on CourtHouse (adm4Code);
create index CourtHousegisFeatureNameIndex on CourtHouse (name);
alter table CourtHouse add constraint FK637222053AEF83Db71a075 foreign key (adm) references Adm;
create index CustomsPostgisFeatureCountryindex on CustomsPost (countryCode);
create index CustomsPostadm2NameIndex on CustomsPost (adm2Name);
create index CustomsPostgisFeatureIdIndex on CustomsPost (featureId);
create index CustomsPostadm4NameIndex on CustomsPost (adm4Name);
create index CustomsPostgisFeatureAsciiNameIndex on CustomsPost (asciiName);
create index CustomsPostadm1codeIndex on CustomsPost (adm1Code);
create index CustomsPostadm3codeIndex on CustomsPost (adm3Code);
create index CustomsPostgisFeatureFeatureClassindex on CustomsPost (featureClass);
create index CustomsPostadm2codeIndex on CustomsPost (adm2Code);
create index CustomsPostgisFeatureFeatureCodeindex on CustomsPost (featureCode);
create index CustomsPostadm3NameIndex on CustomsPost (adm3Name);
create index CustomsPostadm1NameIndex on CustomsPost (adm1Name);
create index CustomsPostadm4codeIndex on CustomsPost (adm4Code);
create index CustomsPostgisFeatureNameIndex on CustomsPost (name);
alter table CustomsPost add constraint FK637222053AEF83Dfa8036c2 foreign key (adm) references Adm;
create index DamgisFeatureCountryindex on Dam (countryCode);
create index Damadm2NameIndex on Dam (adm2Name);
create index DamgisFeatureIdIndex on Dam (featureId);
create index Damadm4NameIndex on Dam (adm4Name);
create index DamgisFeatureAsciiNameIndex on Dam (asciiName);
create index Damadm1codeIndex on Dam (adm1Code);
create index Damadm3codeIndex on Dam (adm3Code);
create index DamgisFeatureFeatureClassindex on Dam (featureClass);
create index Damadm2codeIndex on Dam (adm2Code);
create index DamgisFeatureFeatureCodeindex on Dam (featureCode);
create index Damadm3NameIndex on Dam (adm3Name);
create index Damadm1NameIndex on Dam (adm1Name);
create index Damadm4codeIndex on Dam (adm4Code);
create index DamgisFeatureNameIndex on Dam (name);
alter table Dam add constraint FK637222053AEF83D10b70 foreign key (adm) references Adm;
create index DesertgisFeatureCountryindex on Desert (countryCode);
create index Desertadm2NameIndex on Desert (adm2Name);
create index DesertgisFeatureIdIndex on Desert (featureId);
create index Desertadm4NameIndex on Desert (adm4Name);
create index DesertgisFeatureAsciiNameIndex on Desert (asciiName);
create index Desertadm1codeIndex on Desert (adm1Code);
create index Desertadm3codeIndex on Desert (adm3Code);
create index DesertgisFeatureFeatureClassindex on Desert (featureClass);
create index Desertadm2codeIndex on Desert (adm2Code);
create index DesertgisFeatureFeatureCodeindex on Desert (featureCode);
create index Desertadm3NameIndex on Desert (adm3Name);
create index Desertadm1NameIndex on Desert (adm1Name);
create index Desertadm4codeIndex on Desert (adm4Code);
create index DesertgisFeatureNameIndex on Desert (name);
alter table Desert add constraint FK637222053AEF83D79cea035 foreign key (adm) references Adm;
create index FactorygisFeatureCountryindex on Factory (countryCode);
create index Factoryadm2NameIndex on Factory (adm2Name);
create index FactorygisFeatureIdIndex on Factory (featureId);
create index Factoryadm4NameIndex on Factory (adm4Name);
create index FactorygisFeatureAsciiNameIndex on Factory (asciiName);
create index Factoryadm1codeIndex on Factory (adm1Code);
create index Factoryadm3codeIndex on Factory (adm3Code);
create index FactorygisFeatureFeatureClassindex on Factory (featureClass);
create index Factoryadm2codeIndex on Factory (adm2Code);
create index FactorygisFeatureFeatureCodeindex on Factory (featureCode);
create index Factoryadm3NameIndex on Factory (adm3Name);
create index Factoryadm1NameIndex on Factory (adm1Name);
create index Factoryadm4codeIndex on Factory (adm4Code);
create index FactorygisFeatureNameIndex on Factory (name);
alter table Factory add constraint FK637222053AEF83D2223c8ea foreign key (adm) references Adm;
create index FallsgisFeatureCountryindex on Falls (countryCode);
create index Fallsadm2NameIndex on Falls (adm2Name);
create index FallsgisFeatureIdIndex on Falls (featureId);
create index Fallsadm4NameIndex on Falls (adm4Name);
create index FallsgisFeatureAsciiNameIndex on Falls (asciiName);
create index Fallsadm1codeIndex on Falls (adm1Code);
create index Fallsadm3codeIndex on Falls (adm3Code);
create index FallsgisFeatureFeatureClassindex on Falls (featureClass);
create index Fallsadm2codeIndex on Falls (adm2Code);
create index FallsgisFeatureFeatureCodeindex on Falls (featureCode);
create index Fallsadm3NameIndex on Falls (adm3Name);
create index Fallsadm1NameIndex on Falls (adm1Name);
create index Fallsadm4codeIndex on Falls (adm4Code);
create index FallsgisFeatureNameIndex on Falls (name);
alter table Falls add constraint FK637222053AEF83D4082838 foreign key (adm) references Adm;
create index FarmgisFeatureCountryindex on Farm (countryCode);
create index Farmadm2NameIndex on Farm (adm2Name);
create index FarmgisFeatureIdIndex on Farm (featureId);
create index Farmadm4NameIndex on Farm (adm4Name);
create index FarmgisFeatureAsciiNameIndex on Farm (asciiName);
create index Farmadm1codeIndex on Farm (adm1Code);
create index Farmadm3codeIndex on Farm (adm3Code);
create index FarmgisFeatureFeatureClassindex on Farm (featureClass);
create index Farmadm2codeIndex on Farm (adm2Code);
create index FarmgisFeatureFeatureCodeindex on Farm (featureCode);
create index Farmadm3NameIndex on Farm (adm3Name);
create index Farmadm1NameIndex on Farm (adm1Name);
create index Farmadm4codeIndex on Farm (adm4Code);
create index FarmgisFeatureNameIndex on Farm (name);
alter table Farm add constraint FK637222053AEF83D214c56 foreign key (adm) references Adm;
create index FieldgisFeatureCountryindex on Field (countryCode);
create index Fieldadm2NameIndex on Field (adm2Name);
create index FieldgisFeatureIdIndex on Field (featureId);
create index Fieldadm4NameIndex on Field (adm4Name);
create index FieldgisFeatureAsciiNameIndex on Field (asciiName);
create index Fieldadm1codeIndex on Field (adm1Code);
create index Fieldadm3codeIndex on Field (adm3Code);
create index FieldgisFeatureFeatureClassindex on Field (featureClass);
create index Fieldadm2codeIndex on Field (adm2Code);
create index FieldgisFeatureFeatureCodeindex on Field (featureCode);
create index Fieldadm3NameIndex on Field (adm3Name);
create index Fieldadm1NameIndex on Field (adm1Name);
create index Fieldadm4codeIndex on Field (adm4Code);
create index FieldgisFeatureNameIndex on Field (name);
alter table Field add constraint FK637222053AEF83D40bb0da foreign key (adm) references Adm;
create index FishingAreagisFeatureCountryindex on FishingArea (countryCode);
create index FishingAreaadm2NameIndex on FishingArea (adm2Name);
create index FishingAreagisFeatureIdIndex on FishingArea (featureId);
create index FishingAreaadm4NameIndex on FishingArea (adm4Name);
create index FishingAreagisFeatureAsciiNameIndex on FishingArea (asciiName);
create index FishingAreaadm1codeIndex on FishingArea (adm1Code);
create index FishingAreaadm3codeIndex on FishingArea (adm3Code);
create index FishingAreagisFeatureFeatureClassindex on FishingArea (featureClass);
create index FishingAreaadm2codeIndex on FishingArea (adm2Code);
create index FishingAreagisFeatureFeatureCodeindex on FishingArea (featureCode);
create index FishingAreaadm3NameIndex on FishingArea (adm3Name);
create index FishingAreaadm1NameIndex on FishingArea (adm1Name);
create index FishingAreaadm4codeIndex on FishingArea (adm4Code);
create index FishingAreagisFeatureNameIndex on FishingArea (name);
alter table FishingArea add constraint FK637222053AEF83D2ace7a17 foreign key (adm) references Adm;
create index FjordgisFeatureCountryindex on Fjord (countryCode);
create index Fjordadm2NameIndex on Fjord (adm2Name);
create index FjordgisFeatureIdIndex on Fjord (featureId);
create index Fjordadm4NameIndex on Fjord (adm4Name);
create index FjordgisFeatureAsciiNameIndex on Fjord (asciiName);
create index Fjordadm1codeIndex on Fjord (adm1Code);
create index Fjordadm3codeIndex on Fjord (adm3Code);
create index FjordgisFeatureFeatureClassindex on Fjord (featureClass);
create index Fjordadm2codeIndex on Fjord (adm2Code);
create index FjordgisFeatureFeatureCodeindex on Fjord (featureCode);
create index Fjordadm3NameIndex on Fjord (adm3Name);
create index Fjordadm1NameIndex on Fjord (adm1Name);
create index Fjordadm4codeIndex on Fjord (adm4Code);
create index FjordgisFeatureNameIndex on Fjord (name);
alter table Fjord add constraint FK637222053AEF83D40c4b7d foreign key (adm) references Adm;
create index ForestgisFeatureCountryindex on Forest (countryCode);
create index Forestadm2NameIndex on Forest (adm2Name);
create index ForestgisFeatureIdIndex on Forest (featureId);
create index Forestadm4NameIndex on Forest (adm4Name);
create index ForestgisFeatureAsciiNameIndex on Forest (asciiName);
create index Forestadm1codeIndex on Forest (adm1Code);
create index Forestadm3codeIndex on Forest (adm3Code);
create index ForestgisFeatureFeatureClassindex on Forest (featureClass);
create index Forestadm2codeIndex on Forest (adm2Code);
create index ForestgisFeatureFeatureCodeindex on Forest (featureCode);
create index Forestadm3NameIndex on Forest (adm3Name);
create index Forestadm1NameIndex on Forest (adm1Name);
create index Forestadm4codeIndex on Forest (adm4Code);
create index ForestgisFeatureNameIndex on Forest (name);
alter table Forest add constraint FK637222053AEF83D7dc4c83d foreign key (adm) references Adm;
create index GardengisFeatureCountryindex on Garden (countryCode);
create index Gardenadm2NameIndex on Garden (adm2Name);
create index GardengisFeatureIdIndex on Garden (featureId);
create index Gardenadm4NameIndex on Garden (adm4Name);
create index GardengisFeatureAsciiNameIndex on Garden (asciiName);
create index Gardenadm1codeIndex on Garden (adm1Code);
create index Gardenadm3codeIndex on Garden (adm3Code);
create index GardengisFeatureFeatureClassindex on Garden (featureClass);
create index Gardenadm2codeIndex on Garden (adm2Code);
create index GardengisFeatureFeatureCodeindex on Garden (featureCode);
create index Gardenadm3NameIndex on Garden (adm3Name);
create index Gardenadm1NameIndex on Garden (adm1Name);
create index Gardenadm4codeIndex on Garden (adm4Code);
create index GardengisFeatureNameIndex on Garden (name);
alter table Garden add constraint FK637222053AEF83D7eb45255 foreign key (adm) references Adm;
create index gisFeatureCountryindex on GisFeature (countryCode);
create index adm2NameIndex on GisFeature (adm2Name);
create index gisFeatureIdIndex on GisFeature (featureId);
create index adm4NameIndex on GisFeature (adm4Name);
create index gisFeatureAsciiNameIndex on GisFeature (asciiName);
create index adm1codeIndex on GisFeature (adm1Code);
create index adm3codeIndex on GisFeature (adm3Code);
create index gisFeatureFeatureClassindex on GisFeature (featureClass);
create index adm2codeIndex on GisFeature (adm2Code);
create index gisFeatureFeatureCodeindex on GisFeature (featureCode);
create index adm3NameIndex on GisFeature (adm3Name);
create index adm1NameIndex on GisFeature (adm1Name);
create index adm4codeIndex on GisFeature (adm4Code);
create index gisFeatureNameIndex on GisFeature (name);
alter table GisFeature add constraint FK637222053AEF83D foreign key (adm) references Adm;
create index GolfgisFeatureCountryindex on Golf (countryCode);
create index Golfadm2NameIndex on Golf (adm2Name);
create index GolfgisFeatureIdIndex on Golf (featureId);
create index Golfadm4NameIndex on Golf (adm4Name);
create index GolfgisFeatureAsciiNameIndex on Golf (asciiName);
create index Golfadm1codeIndex on Golf (adm1Code);
create index Golfadm3codeIndex on Golf (adm3Code);
create index GolfgisFeatureFeatureClassindex on Golf (featureClass);
create index Golfadm2codeIndex on Golf (adm2Code);
create index GolfgisFeatureFeatureCodeindex on Golf (featureCode);
create index Golfadm3NameIndex on Golf (adm3Name);
create index Golfadm1NameIndex on Golf (adm1Name);
create index Golfadm4codeIndex on Golf (adm4Code);
create index GolfgisFeatureNameIndex on Golf (name);
alter table Golf add constraint FK637222053AEF83D21f482 foreign key (adm) references Adm;
create index GorgegisFeatureCountryindex on Gorge (countryCode);
create index Gorgeadm2NameIndex on Gorge (adm2Name);
create index GorgegisFeatureIdIndex on Gorge (featureId);
create index Gorgeadm4NameIndex on Gorge (adm4Name);
create index GorgegisFeatureAsciiNameIndex on Gorge (asciiName);
create index Gorgeadm1codeIndex on Gorge (adm1Code);
create index Gorgeadm3codeIndex on Gorge (adm3Code);
create index GorgegisFeatureFeatureClassindex on Gorge (featureClass);
create index Gorgeadm2codeIndex on Gorge (adm2Code);
create index GorgegisFeatureFeatureCodeindex on Gorge (featureCode);
create index Gorgeadm3NameIndex on Gorge (adm3Name);
create index Gorgeadm1NameIndex on Gorge (adm1Name);
create index Gorgeadm4codeIndex on Gorge (adm4Code);
create index GorgegisFeatureNameIndex on Gorge (name);
alter table Gorge add constraint FK637222053AEF83D41cb2c8 foreign key (adm) references Adm;
create index GrassLandgisFeatureCountryindex on GrassLand (countryCode);
create index GrassLandadm2NameIndex on GrassLand (adm2Name);
create index GrassLandgisFeatureIdIndex on GrassLand (featureId);
create index GrassLandadm4NameIndex on GrassLand (adm4Name);
create index GrassLandgisFeatureAsciiNameIndex on GrassLand (asciiName);
create index GrassLandadm1codeIndex on GrassLand (adm1Code);
create index GrassLandadm3codeIndex on GrassLand (adm3Code);
create index GrassLandgisFeatureFeatureClassindex on GrassLand (featureClass);
create index GrassLandadm2codeIndex on GrassLand (adm2Code);
create index GrassLandgisFeatureFeatureCodeindex on GrassLand (featureCode);
create index GrassLandadm3NameIndex on GrassLand (adm3Name);
create index GrassLandadm1NameIndex on GrassLand (adm1Name);
create index GrassLandadm4codeIndex on GrassLand (adm4Code);
create index GrassLandgisFeatureNameIndex on GrassLand (name);
alter table GrassLand add constraint FK637222053AEF83D37331ca1 foreign key (adm) references Adm;
create index GulfgisFeatureCountryindex on Gulf (countryCode);
create index Gulfadm2NameIndex on Gulf (adm2Name);
create index GulfgisFeatureIdIndex on Gulf (featureId);
create index Gulfadm4NameIndex on Gulf (adm4Name);
create index GulfgisFeatureAsciiNameIndex on Gulf (asciiName);
create index Gulfadm1codeIndex on Gulf (adm1Code);
create index Gulfadm3codeIndex on Gulf (adm3Code);
create index GulfgisFeatureFeatureClassindex on Gulf (featureClass);
create index Gulfadm2codeIndex on Gulf (adm2Code);
create index GulfgisFeatureFeatureCodeindex on Gulf (featureCode);
create index Gulfadm3NameIndex on Gulf (adm3Name);
create index Gulfadm1NameIndex on Gulf (adm1Name);
create index Gulfadm4codeIndex on Gulf (adm4Code);
create index GulfgisFeatureNameIndex on Gulf (name);
alter table Gulf add constraint FK637222053AEF83D220b08 foreign key (adm) references Adm;
create index HillgisFeatureCountryindex on Hill (countryCode);
create index Hilladm2NameIndex on Hill (adm2Name);
create index HillgisFeatureIdIndex on Hill (featureId);
create index Hilladm4NameIndex on Hill (adm4Name);
create index HillgisFeatureAsciiNameIndex on Hill (asciiName);
create index Hilladm1codeIndex on Hill (adm1Code);
create index Hilladm3codeIndex on Hill (adm3Code);
create index HillgisFeatureFeatureClassindex on Hill (featureClass);
create index Hilladm2codeIndex on Hill (adm2Code);
create index HillgisFeatureFeatureCodeindex on Hill (featureCode);
create index Hilladm3NameIndex on Hill (adm3Name);
create index Hilladm1NameIndex on Hill (adm1Name);
create index Hilladm4codeIndex on Hill (adm4Code);
create index HillgisFeatureNameIndex on Hill (name);
alter table Hill add constraint FK637222053AEF83D225261 foreign key (adm) references Adm;
create index HospitalgisFeatureCountryindex on Hospital (countryCode);
create index Hospitaladm2NameIndex on Hospital (adm2Name);
create index HospitalgisFeatureIdIndex on Hospital (featureId);
create index Hospitaladm4NameIndex on Hospital (adm4Name);
create index HospitalgisFeatureAsciiNameIndex on Hospital (asciiName);
create index Hospitaladm1codeIndex on Hospital (adm1Code);
create index Hospitaladm3codeIndex on Hospital (adm3Code);
create index HospitalgisFeatureFeatureClassindex on Hospital (featureClass);
create index Hospitaladm2codeIndex on Hospital (adm2Code);
create index HospitalgisFeatureFeatureCodeindex on Hospital (featureCode);
create index Hospitaladm3NameIndex on Hospital (adm3Name);
create index Hospitaladm1NameIndex on Hospital (adm1Name);
create index Hospitaladm4codeIndex on Hospital (adm4Code);
create index HospitalgisFeatureNameIndex on Hospital (name);
alter table Hospital add constraint FK637222053AEF83Df1c1625a foreign key (adm) references Adm;
create index HotelgisFeatureCountryindex on Hotel (countryCode);
create index Hoteladm2NameIndex on Hotel (adm2Name);
create index HotelgisFeatureIdIndex on Hotel (featureId);
create index Hoteladm4NameIndex on Hotel (adm4Name);
create index HotelgisFeatureAsciiNameIndex on Hotel (asciiName);
create index Hoteladm1codeIndex on Hotel (adm1Code);
create index Hoteladm3codeIndex on Hotel (adm3Code);
create index HotelgisFeatureFeatureClassindex on Hotel (featureClass);
create index Hoteladm2codeIndex on Hotel (adm2Code);
create index HotelgisFeatureFeatureCodeindex on Hotel (featureCode);
create index Hoteladm3NameIndex on Hotel (adm3Name);
create index Hoteladm1NameIndex on Hotel (adm1Name);
create index Hoteladm4codeIndex on Hotel (adm4Code);
create index HotelgisFeatureNameIndex on Hotel (name);
alter table Hotel add constraint FK637222053AEF83D42ad194 foreign key (adm) references Adm;
create index HousegisFeatureCountryindex on House (countryCode);
create index Houseadm2NameIndex on House (adm2Name);
create index HousegisFeatureIdIndex on House (featureId);
create index Houseadm4NameIndex on House (adm4Name);
create index HousegisFeatureAsciiNameIndex on House (asciiName);
create index Houseadm1codeIndex on House (adm1Code);
create index Houseadm3codeIndex on House (adm3Code);
create index HousegisFeatureFeatureClassindex on House (featureClass);
create index Houseadm2codeIndex on House (adm2Code);
create index HousegisFeatureFeatureCodeindex on House (featureCode);
create index Houseadm3NameIndex on House (adm3Name);
create index Houseadm1NameIndex on House (adm1Name);
create index Houseadm4codeIndex on House (adm4Code);
create index HousegisFeatureNameIndex on House (name);
alter table House add constraint FK637222053AEF83D42ad700 foreign key (adm) references Adm;
create index IcegisFeatureCountryindex on Ice (countryCode);
create index Iceadm2NameIndex on Ice (adm2Name);
create index IcegisFeatureIdIndex on Ice (featureId);
create index Iceadm4NameIndex on Ice (adm4Name);
create index IcegisFeatureAsciiNameIndex on Ice (asciiName);
create index Iceadm1codeIndex on Ice (adm1Code);
create index Iceadm3codeIndex on Ice (adm3Code);
create index IcegisFeatureFeatureClassindex on Ice (featureClass);
create index Iceadm2codeIndex on Ice (adm2Code);
create index IcegisFeatureFeatureCodeindex on Ice (featureCode);
create index Iceadm3NameIndex on Ice (adm3Name);
create index Iceadm1NameIndex on Ice (adm1Name);
create index Iceadm4codeIndex on Ice (adm4Code);
create index IcegisFeatureNameIndex on Ice (name);
alter table Ice add constraint FK637222053AEF83D11e6b foreign key (adm) references Adm;
create index IslandgisFeatureCountryindex on Island (countryCode);
create index Islandadm2NameIndex on Island (adm2Name);
create index IslandgisFeatureIdIndex on Island (featureId);
create index Islandadm4NameIndex on Island (adm4Name);
create index IslandgisFeatureAsciiNameIndex on Island (asciiName);
create index Islandadm1codeIndex on Island (adm1Code);
create index Islandadm3codeIndex on Island (adm3Code);
create index IslandgisFeatureFeatureClassindex on Island (featureClass);
create index Islandadm2codeIndex on Island (adm2Code);
create index IslandgisFeatureFeatureCodeindex on Island (featureCode);
create index Islandadm3NameIndex on Island (adm3Name);
create index Islandadm1NameIndex on Island (adm1Name);
create index Islandadm4codeIndex on Island (adm4Code);
create index IslandgisFeatureNameIndex on Island (name);
alter table Island add constraint FK637222053AEF83D8318e635 foreign key (adm) references Adm;
create index LakegisFeatureCountryindex on Lake (countryCode);
create index Lakeadm2NameIndex on Lake (adm2Name);
create index LakegisFeatureIdIndex on Lake (featureId);
create index Lakeadm4NameIndex on Lake (adm4Name);
create index LakegisFeatureAsciiNameIndex on Lake (asciiName);
create index Lakeadm1codeIndex on Lake (adm1Code);
create index Lakeadm3codeIndex on Lake (adm3Code);
create index LakegisFeatureFeatureClassindex on Lake (featureClass);
create index Lakeadm2codeIndex on Lake (adm2Code);
create index LakegisFeatureFeatureCodeindex on Lake (featureCode);
create index Lakeadm3NameIndex on Lake (adm3Name);
create index Lakeadm1NameIndex on Lake (adm1Name);
create index Lakeadm4codeIndex on Lake (adm4Code);
create index LakegisFeatureNameIndex on Lake (name);
alter table Lake add constraint FK637222053AEF83D2405af foreign key (adm) references Adm;
create index iso639Alpha2LanguageCode on Language (iso639Alpha2LanguageCode);
create index iso639Alpha3LanguageCode on Language (iso639Alpha3LanguageCode);
create index LibrarygisFeatureCountryindex on Library (countryCode);
create index Libraryadm2NameIndex on Library (adm2Name);
create index LibrarygisFeatureIdIndex on Library (featureId);
create index Libraryadm4NameIndex on Library (adm4Name);
create index LibrarygisFeatureAsciiNameIndex on Library (asciiName);
create index Libraryadm1codeIndex on Library (adm1Code);
create index Libraryadm3codeIndex on Library (adm3Code);
create index LibrarygisFeatureFeatureClassindex on Library (featureClass);
create index Libraryadm2codeIndex on Library (adm2Code);
create index LibrarygisFeatureFeatureCodeindex on Library (featureCode);
create index Libraryadm3NameIndex on Library (adm3Name);
create index Libraryadm1NameIndex on Library (adm1Name);
create index Libraryadm4codeIndex on Library (adm4Code);
create index LibrarygisFeatureNameIndex on Library (name);
alter table Library add constraint FK637222053AEF83D6d20bc9b foreign key (adm) references Adm;
create index LightHousegisFeatureCountryindex on LightHouse (countryCode);
create index LightHouseadm2NameIndex on LightHouse (adm2Name);
create index LightHousegisFeatureIdIndex on LightHouse (featureId);
create index LightHouseadm4NameIndex on LightHouse (adm4Name);
create index LightHousegisFeatureAsciiNameIndex on LightHouse (asciiName);
create index LightHouseadm1codeIndex on LightHouse (adm1Code);
create index LightHouseadm3codeIndex on LightHouse (adm3Code);
create index LightHousegisFeatureFeatureClassindex on LightHouse (featureClass);
create index LightHouseadm2codeIndex on LightHouse (adm2Code);
create index LightHousegisFeatureFeatureCodeindex on LightHouse (featureCode);
create index LightHouseadm3NameIndex on LightHouse (adm3Name);
create index LightHouseadm1NameIndex on LightHouse (adm1Name);
create index LightHouseadm4codeIndex on LightHouse (adm4Code);
create index LightHousegisFeatureNameIndex on LightHouse (name);
alter table LightHouse add constraint FK637222053AEF83D691d3bca foreign key (adm) references Adm;
create index MallgisFeatureCountryindex on Mall (countryCode);
create index Malladm2NameIndex on Mall (adm2Name);
create index MallgisFeatureIdIndex on Mall (featureId);
create index Malladm4NameIndex on Mall (adm4Name);
create index MallgisFeatureAsciiNameIndex on Mall (asciiName);
create index Malladm1codeIndex on Mall (adm1Code);
create index Malladm3codeIndex on Mall (adm3Code);
create index MallgisFeatureFeatureClassindex on Mall (featureClass);
create index Malladm2codeIndex on Mall (adm2Code);
create index MallgisFeatureFeatureCodeindex on Mall (featureCode);
create index Malladm3NameIndex on Mall (adm3Name);
create index Malladm1NameIndex on Mall (adm1Name);
create index Malladm4codeIndex on Mall (adm4Code);
create index MallgisFeatureNameIndex on Mall (name);
alter table Mall add constraint FK637222053AEF83D247a34 foreign key (adm) references Adm;
create index MarshgisFeatureCountryindex on Marsh (countryCode);
create index Marshadm2NameIndex on Marsh (adm2Name);
create index MarshgisFeatureIdIndex on Marsh (featureId);
create index Marshadm4NameIndex on Marsh (adm4Name);
create index MarshgisFeatureAsciiNameIndex on Marsh (asciiName);
create index Marshadm1codeIndex on Marsh (adm1Code);
create index Marshadm3codeIndex on Marsh (adm3Code);
create index MarshgisFeatureFeatureClassindex on Marsh (featureClass);
create index Marshadm2codeIndex on Marsh (adm2Code);
create index MarshgisFeatureFeatureCodeindex on Marsh (featureCode);
create index Marshadm3NameIndex on Marsh (adm3Name);
create index Marshadm1NameIndex on Marsh (adm1Name);
create index Marshadm4codeIndex on Marsh (adm4Code);
create index MarshgisFeatureNameIndex on Marsh (name);
alter table Marsh add constraint FK637222053AEF83D46ae413 foreign key (adm) references Adm;
create index MetroStationgisFeatureCountryindex on MetroStation (countryCode);
create index MetroStationadm2NameIndex on MetroStation (adm2Name);
create index MetroStationgisFeatureIdIndex on MetroStation (featureId);
create index MetroStationadm4NameIndex on MetroStation (adm4Name);
create index MetroStationgisFeatureAsciiNameIndex on MetroStation (asciiName);
create index MetroStationadm1codeIndex on MetroStation (adm1Code);
create index MetroStationadm3codeIndex on MetroStation (adm3Code);
create index MetroStationgisFeatureFeatureClassindex on MetroStation (featureClass);
create index MetroStationadm2codeIndex on MetroStation (adm2Code);
create index MetroStationgisFeatureFeatureCodeindex on MetroStation (featureCode);
create index MetroStationadm3NameIndex on MetroStation (adm3Name);
create index MetroStationadm1NameIndex on MetroStation (adm1Name);
create index MetroStationadm4codeIndex on MetroStation (adm4Code);
create index MetroStationgisFeatureNameIndex on MetroStation (name);
alter table MetroStation add constraint FK637222053AEF83Dc33101fb foreign key (adm) references Adm;
create index MilitarygisFeatureCountryindex on Military (countryCode);
create index Militaryadm2NameIndex on Military (adm2Name);
create index MilitarygisFeatureIdIndex on Military (featureId);
create index Militaryadm4NameIndex on Military (adm4Name);
create index MilitarygisFeatureAsciiNameIndex on Military (asciiName);
create index Militaryadm1codeIndex on Military (adm1Code);
create index Militaryadm3codeIndex on Military (adm3Code);
create index MilitarygisFeatureFeatureClassindex on Military (featureClass);
create index Militaryadm2codeIndex on Military (adm2Code);
create index MilitarygisFeatureFeatureCodeindex on Military (featureCode);
create index Militaryadm3NameIndex on Military (adm3Name);
create index Militaryadm1NameIndex on Military (adm1Name);
create index Militaryadm4codeIndex on Military (adm4Code);
create index MilitarygisFeatureNameIndex on Military (name);
alter table Military add constraint FK637222053AEF83Daf72092d foreign key (adm) references Adm;
create index MillgisFeatureCountryindex on Mill (countryCode);
create index Milladm2NameIndex on Mill (adm2Name);
create index MillgisFeatureIdIndex on Mill (featureId);
create index Milladm4NameIndex on Mill (adm4Name);
create index MillgisFeatureAsciiNameIndex on Mill (asciiName);
create index Milladm1codeIndex on Mill (adm1Code);
create index Milladm3codeIndex on Mill (adm3Code);
create index MillgisFeatureFeatureClassindex on Mill (featureClass);
create index Milladm2codeIndex on Mill (adm2Code);
create index MillgisFeatureFeatureCodeindex on Mill (featureCode);
create index Milladm3NameIndex on Mill (adm3Name);
create index Milladm1NameIndex on Mill (adm1Name);
create index Milladm4codeIndex on Mill (adm4Code);
create index MillgisFeatureNameIndex on Mill (name);
alter table Mill add constraint FK637222053AEF83D24983c foreign key (adm) references Adm;
create index MinegisFeatureCountryindex on Mine (countryCode);
create index Mineadm2NameIndex on Mine (adm2Name);
create index MinegisFeatureIdIndex on Mine (featureId);
create index Mineadm4NameIndex on Mine (adm4Name);
create index MinegisFeatureAsciiNameIndex on Mine (asciiName);
create index Mineadm1codeIndex on Mine (adm1Code);
create index Mineadm3codeIndex on Mine (adm3Code);
create index MinegisFeatureFeatureClassindex on Mine (featureClass);
create index Mineadm2codeIndex on Mine (adm2Code);
create index MinegisFeatureFeatureCodeindex on Mine (featureCode);
create index Mineadm3NameIndex on Mine (adm3Name);
create index Mineadm1NameIndex on Mine (adm1Name);
create index Mineadm4codeIndex on Mine (adm4Code);
create index MinegisFeatureNameIndex on Mine (name);
alter table Mine add constraint FK637222053AEF83D249873 foreign key (adm) references Adm;
create index MolegisFeatureCountryindex on Mole (countryCode);
create index Moleadm2NameIndex on Mole (adm2Name);
create index MolegisFeatureIdIndex on Mole (featureId);
create index Moleadm4NameIndex on Mole (adm4Name);
create index MolegisFeatureAsciiNameIndex on Mole (asciiName);
create index Moleadm1codeIndex on Mole (adm1Code);
create index Moleadm3codeIndex on Mole (adm3Code);
create index MolegisFeatureFeatureClassindex on Mole (featureClass);
create index Moleadm2codeIndex on Mole (adm2Code);
create index MolegisFeatureFeatureCodeindex on Mole (featureCode);
create index Moleadm3NameIndex on Mole (adm3Name);
create index Moleadm1NameIndex on Mole (adm1Name);
create index Moleadm4codeIndex on Mole (adm4Code);
create index MolegisFeatureNameIndex on Mole (name);
alter table Mole add constraint FK637222053AEF83D24aebb foreign key (adm) references Adm;
create index MonumentgisFeatureCountryindex on Monument (countryCode);
create index Monumentadm2NameIndex on Monument (adm2Name);
create index MonumentgisFeatureIdIndex on Monument (featureId);
create index Monumentadm4NameIndex on Monument (adm4Name);
create index MonumentgisFeatureAsciiNameIndex on Monument (asciiName);
create index Monumentadm1codeIndex on Monument (adm1Code);
create index Monumentadm3codeIndex on Monument (adm3Code);
create index MonumentgisFeatureFeatureClassindex on Monument (featureClass);
create index Monumentadm2codeIndex on Monument (adm2Code);
create index MonumentgisFeatureFeatureCodeindex on Monument (featureCode);
create index Monumentadm3NameIndex on Monument (adm3Name);
create index Monumentadm1NameIndex on Monument (adm1Name);
create index Monumentadm4codeIndex on Monument (adm4Code);
create index MonumentgisFeatureNameIndex on Monument (name);
alter table Monument add constraint FK637222053AEF83Df0e717e7 foreign key (adm) references Adm;
create index MoundgisFeatureCountryindex on Mound (countryCode);
create index Moundadm2NameIndex on Mound (adm2Name);
create index MoundgisFeatureIdIndex on Mound (featureId);
create index Moundadm4NameIndex on Mound (adm4Name);
create index MoundgisFeatureAsciiNameIndex on Mound (asciiName);
create index Moundadm1codeIndex on Mound (adm1Code);
create index Moundadm3codeIndex on Mound (adm3Code);
create index MoundgisFeatureFeatureClassindex on Mound (featureClass);
create index Moundadm2codeIndex on Mound (adm2Code);
create index MoundgisFeatureFeatureCodeindex on Mound (featureCode);
create index Moundadm3NameIndex on Mound (adm3Name);
create index Moundadm1NameIndex on Mound (adm1Name);
create index Moundadm4codeIndex on Mound (adm4Code);
create index MoundgisFeatureNameIndex on Mound (name);
alter table Mound add constraint FK637222053AEF83D4714be9 foreign key (adm) references Adm;
create index MountaingisFeatureCountryindex on Mountain (countryCode);
create index Mountainadm2NameIndex on Mountain (adm2Name);
create index MountaingisFeatureIdIndex on Mountain (featureId);
create index Mountainadm4NameIndex on Mountain (adm4Name);
create index MountaingisFeatureAsciiNameIndex on Mountain (asciiName);
create index Mountainadm1codeIndex on Mountain (adm1Code);
create index Mountainadm3codeIndex on Mountain (adm3Code);
create index MountaingisFeatureFeatureClassindex on Mountain (featureClass);
create index Mountainadm2codeIndex on Mountain (adm2Code);
create index MountaingisFeatureFeatureCodeindex on Mountain (featureCode);
create index Mountainadm3NameIndex on Mountain (adm3Name);
create index Mountainadm1NameIndex on Mountain (adm1Name);
create index Mountainadm4codeIndex on Mountain (adm4Code);
create index MountaingisFeatureNameIndex on Mountain (name);
alter table Mountain add constraint FK637222053AEF83Dfc797ead foreign key (adm) references Adm;
create index MuseumgisFeatureCountryindex on Museum (countryCode);
create index Museumadm2NameIndex on Museum (adm2Name);
create index MuseumgisFeatureIdIndex on Museum (featureId);
create index Museumadm4NameIndex on Museum (adm4Name);
create index MuseumgisFeatureAsciiNameIndex on Museum (asciiName);
create index Museumadm1codeIndex on Museum (adm1Code);
create index Museumadm3codeIndex on Museum (adm3Code);
create index MuseumgisFeatureFeatureClassindex on Museum (featureClass);
create index Museumadm2codeIndex on Museum (adm2Code);
create index MuseumgisFeatureFeatureCodeindex on Museum (featureCode);
create index Museumadm3NameIndex on Museum (adm3Name);
create index Museumadm1NameIndex on Museum (adm1Name);
create index Museumadm4codeIndex on Museum (adm4Code);
create index MuseumgisFeatureNameIndex on Museum (name);
alter table Museum add constraint FK637222053AEF83D8a0bb632 foreign key (adm) references Adm;
create index OasisgisFeatureCountryindex on Oasis (countryCode);
create index Oasisadm2NameIndex on Oasis (adm2Name);
create index OasisgisFeatureIdIndex on Oasis (featureId);
create index Oasisadm4NameIndex on Oasis (adm4Name);
create index OasisgisFeatureAsciiNameIndex on Oasis (asciiName);
create index Oasisadm1codeIndex on Oasis (adm1Code);
create index Oasisadm3codeIndex on Oasis (adm3Code);
create index OasisgisFeatureFeatureClassindex on Oasis (featureClass);
create index Oasisadm2codeIndex on Oasis (adm2Code);
create index OasisgisFeatureFeatureCodeindex on Oasis (featureCode);
create index Oasisadm3NameIndex on Oasis (adm3Name);
create index Oasisadm1NameIndex on Oasis (adm1Name);
create index Oasisadm4codeIndex on Oasis (adm4Code);
create index OasisgisFeatureNameIndex on Oasis (name);
alter table Oasis add constraint FK637222053AEF83D48715ab foreign key (adm) references Adm;
create index ObservatoryPointgisFeatureCountryindex on ObservatoryPoint (countryCode);
create index ObservatoryPointadm2NameIndex on ObservatoryPoint (adm2Name);
create index ObservatoryPointgisFeatureIdIndex on ObservatoryPoint (featureId);
create index ObservatoryPointadm4NameIndex on ObservatoryPoint (adm4Name);
create index ObservatoryPointgisFeatureAsciiNameIndex on ObservatoryPoint (asciiName);
create index ObservatoryPointadm1codeIndex on ObservatoryPoint (adm1Code);
create index ObservatoryPointadm3codeIndex on ObservatoryPoint (adm3Code);
create index ObservatoryPointgisFeatureFeatureClassindex on ObservatoryPoint (featureClass);
create index ObservatoryPointadm2codeIndex on ObservatoryPoint (adm2Code);
create index ObservatoryPointgisFeatureFeatureCodeindex on ObservatoryPoint (featureCode);
create index ObservatoryPointadm3NameIndex on ObservatoryPoint (adm3Name);
create index ObservatoryPointadm1NameIndex on ObservatoryPoint (adm1Name);
create index ObservatoryPointadm4codeIndex on ObservatoryPoint (adm4Code);
create index ObservatoryPointgisFeatureNameIndex on ObservatoryPoint (name);
alter table ObservatoryPoint add constraint FK637222053AEF83Dcbf01ab6 foreign key (adm) references Adm;
create index OceangisFeatureCountryindex on Ocean (countryCode);
create index Oceanadm2NameIndex on Ocean (adm2Name);
create index OceangisFeatureIdIndex on Ocean (featureId);
create index Oceanadm4NameIndex on Ocean (adm4Name);
create index OceangisFeatureAsciiNameIndex on Ocean (asciiName);
create index Oceanadm1codeIndex on Ocean (adm1Code);
create index Oceanadm3codeIndex on Ocean (adm3Code);
create index OceangisFeatureFeatureClassindex on Ocean (featureClass);
create index Oceanadm2codeIndex on Ocean (adm2Code);
create index OceangisFeatureFeatureCodeindex on Ocean (featureCode);
create index Oceanadm3NameIndex on Ocean (adm3Name);
create index Oceanadm1NameIndex on Ocean (adm1Name);
create index Oceanadm4codeIndex on Ocean (adm4Code);
create index OceangisFeatureNameIndex on Ocean (name);
alter table Ocean add constraint FK637222053AEF83D487c8de foreign key (adm) references Adm;
create index OperaHousegisFeatureCountryindex on OperaHouse (countryCode);
create index OperaHouseadm2NameIndex on OperaHouse (adm2Name);
create index OperaHousegisFeatureIdIndex on OperaHouse (featureId);
create index OperaHouseadm4NameIndex on OperaHouse (adm4Name);
create index OperaHousegisFeatureAsciiNameIndex on OperaHouse (asciiName);
create index OperaHouseadm1codeIndex on OperaHouse (adm1Code);
create index OperaHouseadm3codeIndex on OperaHouse (adm3Code);
create index OperaHousegisFeatureFeatureClassindex on OperaHouse (featureClass);
create index OperaHouseadm2codeIndex on OperaHouse (adm2Code);
create index OperaHousegisFeatureFeatureCodeindex on OperaHouse (featureCode);
create index OperaHouseadm3NameIndex on OperaHouse (adm3Name);
create index OperaHouseadm1NameIndex on OperaHouse (adm1Name);
create index OperaHouseadm4codeIndex on OperaHouse (adm4Code);
create index OperaHousegisFeatureNameIndex on OperaHouse (name);
alter table OperaHouse add constraint FK637222053AEF83D74a87b2d foreign key (adm) references Adm;
create index ParkgisFeatureCountryindex on Park (countryCode);
create index Parkadm2NameIndex on Park (adm2Name);
create index ParkgisFeatureIdIndex on Park (featureId);
create index Parkadm4NameIndex on Park (adm4Name);
create index ParkgisFeatureAsciiNameIndex on Park (asciiName);
create index Parkadm1codeIndex on Park (adm1Code);
create index Parkadm3codeIndex on Park (adm3Code);
create index ParkgisFeatureFeatureClassindex on Park (featureClass);
create index Parkadm2codeIndex on Park (adm2Code);
create index ParkgisFeatureFeatureCodeindex on Park (featureCode);
create index Parkadm3NameIndex on Park (adm3Name);
create index Parkadm1NameIndex on Park (adm1Name);
create index Parkadm4codeIndex on Park (adm4Code);
create index ParkgisFeatureNameIndex on Park (name);
alter table Park add constraint FK637222053AEF83D25d80a foreign key (adm) references Adm;
create index ParkinggisFeatureCountryindex on Parking (countryCode);
create index Parkingadm2NameIndex on Parking (adm2Name);
create index ParkinggisFeatureIdIndex on Parking (featureId);
create index Parkingadm4NameIndex on Parking (adm4Name);
create index ParkinggisFeatureAsciiNameIndex on Parking (asciiName);
create index Parkingadm1codeIndex on Parking (adm1Code);
create index Parkingadm3codeIndex on Parking (adm3Code);
create index ParkinggisFeatureFeatureClassindex on Parking (featureClass);
create index Parkingadm2codeIndex on Parking (adm2Code);
create index ParkinggisFeatureFeatureCodeindex on Parking (featureCode);
create index Parkingadm3NameIndex on Parking (adm3Name);
create index Parkingadm1NameIndex on Parking (adm1Name);
create index Parkingadm4codeIndex on Parking (adm4Code);
create index ParkinggisFeatureNameIndex on Parking (name);
alter table Parking add constraint FK637222053AEF83D33f14b98 foreign key (adm) references Adm;
create index PlantationgisFeatureCountryindex on Plantation (countryCode);
create index Plantationadm2NameIndex on Plantation (adm2Name);
create index PlantationgisFeatureIdIndex on Plantation (featureId);
create index Plantationadm4NameIndex on Plantation (adm4Name);
create index PlantationgisFeatureAsciiNameIndex on Plantation (asciiName);
create index Plantationadm1codeIndex on Plantation (adm1Code);
create index Plantationadm3codeIndex on Plantation (adm3Code);
create index PlantationgisFeatureFeatureClassindex on Plantation (featureClass);
create index Plantationadm2codeIndex on Plantation (adm2Code);
create index PlantationgisFeatureFeatureCodeindex on Plantation (featureCode);
create index Plantationadm3NameIndex on Plantation (adm3Name);
create index Plantationadm1NameIndex on Plantation (adm1Name);
create index Plantationadm4codeIndex on Plantation (adm4Code);
create index PlantationgisFeatureNameIndex on Plantation (name);
alter table Plantation add constraint FK637222053AEF83Dc691078a foreign key (adm) references Adm;
create index PolicePostgisFeatureCountryindex on PolicePost (countryCode);
create index PolicePostadm2NameIndex on PolicePost (adm2Name);
create index PolicePostgisFeatureIdIndex on PolicePost (featureId);
create index PolicePostadm4NameIndex on PolicePost (adm4Name);
create index PolicePostgisFeatureAsciiNameIndex on PolicePost (asciiName);
create index PolicePostadm1codeIndex on PolicePost (adm1Code);
create index PolicePostadm3codeIndex on PolicePost (adm3Code);
create index PolicePostgisFeatureFeatureClassindex on PolicePost (featureClass);
create index PolicePostadm2codeIndex on PolicePost (adm2Code);
create index PolicePostgisFeatureFeatureCodeindex on PolicePost (featureCode);
create index PolicePostadm3NameIndex on PolicePost (adm3Name);
create index PolicePostadm1NameIndex on PolicePost (adm1Name);
create index PolicePostadm4codeIndex on PolicePost (adm4Code);
create index PolicePostgisFeatureNameIndex on PolicePost (name);
alter table PolicePost add constraint FK637222053AEF83Dd4b1cefe foreign key (adm) references Adm;
create index PoliticalEntitygisFeatureCountryindex on PoliticalEntity (countryCode);
create index PoliticalEntityadm2NameIndex on PoliticalEntity (adm2Name);
create index PoliticalEntitygisFeatureIdIndex on PoliticalEntity (featureId);
create index PoliticalEntityadm4NameIndex on PoliticalEntity (adm4Name);
create index PoliticalEntitygisFeatureAsciiNameIndex on PoliticalEntity (asciiName);
create index PoliticalEntityadm1codeIndex on PoliticalEntity (adm1Code);
create index PoliticalEntityadm3codeIndex on PoliticalEntity (adm3Code);
create index PoliticalEntitygisFeatureFeatureClassindex on PoliticalEntity (featureClass);
create index PoliticalEntityadm2codeIndex on PoliticalEntity (adm2Code);
create index PoliticalEntitygisFeatureFeatureCodeindex on PoliticalEntity (featureCode);
create index PoliticalEntityadm3NameIndex on PoliticalEntity (adm3Name);
create index PoliticalEntityadm1NameIndex on PoliticalEntity (adm1Name);
create index PoliticalEntityadm4codeIndex on PoliticalEntity (adm4Code);
create index PoliticalEntitygisFeatureNameIndex on PoliticalEntity (name);
alter table PoliticalEntity add constraint FK637222053AEF83Df48c5520 foreign key (adm) references Adm;
create index PondgisFeatureCountryindex on Pond (countryCode);
create index Pondadm2NameIndex on Pond (adm2Name);
create index PondgisFeatureIdIndex on Pond (featureId);
create index Pondadm4NameIndex on Pond (adm4Name);
create index PondgisFeatureAsciiNameIndex on Pond (asciiName);
create index Pondadm1codeIndex on Pond (adm1Code);
create index Pondadm3codeIndex on Pond (adm3Code);
create index PondgisFeatureFeatureClassindex on Pond (featureClass);
create index Pondadm2codeIndex on Pond (adm2Code);
create index PondgisFeatureFeatureCodeindex on Pond (featureCode);
create index Pondadm3NameIndex on Pond (adm3Name);
create index Pondadm1NameIndex on Pond (adm1Name);
create index Pondadm4codeIndex on Pond (adm4Code);
create index PondgisFeatureNameIndex on Pond (name);
alter table Pond add constraint FK637222053AEF83D260c15 foreign key (adm) references Adm;
create index PortgisFeatureCountryindex on Port (countryCode);
create index Portadm2NameIndex on Port (adm2Name);
create index PortgisFeatureIdIndex on Port (featureId);
create index Portadm4NameIndex on Port (adm4Name);
create index PortgisFeatureAsciiNameIndex on Port (asciiName);
create index Portadm1codeIndex on Port (adm1Code);
create index Portadm3codeIndex on Port (adm3Code);
create index PortgisFeatureFeatureClassindex on Port (featureClass);
create index Portadm2codeIndex on Port (adm2Code);
create index PortgisFeatureFeatureCodeindex on Port (featureCode);
create index Portadm3NameIndex on Port (adm3Name);
create index Portadm1NameIndex on Port (adm1Name);
create index Portadm4codeIndex on Port (adm4Code);
create index PortgisFeatureNameIndex on Port (name);
alter table Port add constraint FK637222053AEF83D260ca1 foreign key (adm) references Adm;
create index PostOfficegisFeatureCountryindex on PostOffice (countryCode);
create index PostOfficeadm2NameIndex on PostOffice (adm2Name);
create index PostOfficegisFeatureIdIndex on PostOffice (featureId);
create index PostOfficeadm4NameIndex on PostOffice (adm4Name);
create index PostOfficegisFeatureAsciiNameIndex on PostOffice (asciiName);
create index PostOfficeadm1codeIndex on PostOffice (adm1Code);
create index PostOfficeadm3codeIndex on PostOffice (adm3Code);
create index PostOfficegisFeatureFeatureClassindex on PostOffice (featureClass);
create index PostOfficeadm2codeIndex on PostOffice (adm2Code);
create index PostOfficegisFeatureFeatureCodeindex on PostOffice (featureCode);
create index PostOfficeadm3NameIndex on PostOffice (adm3Name);
create index PostOfficeadm1NameIndex on PostOffice (adm1Name);
create index PostOfficeadm4codeIndex on PostOffice (adm4Code);
create index PostOfficegisFeatureNameIndex on PostOffice (name);
alter table PostOffice add constraint FK637222053AEF83Dcfb5a79c foreign key (adm) references Adm;
create index PrisongisFeatureCountryindex on Prison (countryCode);
create index Prisonadm2NameIndex on Prison (adm2Name);
create index PrisongisFeatureIdIndex on Prison (featureId);
create index Prisonadm4NameIndex on Prison (adm4Name);
create index PrisongisFeatureAsciiNameIndex on Prison (asciiName);
create index Prisonadm1codeIndex on Prison (adm1Code);
create index Prisonadm3codeIndex on Prison (adm3Code);
create index PrisongisFeatureFeatureClassindex on Prison (featureClass);
create index Prisonadm2codeIndex on Prison (adm2Code);
create index PrisongisFeatureFeatureCodeindex on Prison (featureCode);
create index Prisonadm3NameIndex on Prison (adm3Name);
create index Prisonadm1NameIndex on Prison (adm1Name);
create index Prisonadm4codeIndex on Prison (adm4Code);
create index PrisongisFeatureNameIndex on Prison (name);
alter table Prison add constraint FK637222053AEF83D8efba1ab foreign key (adm) references Adm;
create index PyramidgisFeatureCountryindex on Pyramid (countryCode);
create index Pyramidadm2NameIndex on Pyramid (adm2Name);
create index PyramidgisFeatureIdIndex on Pyramid (featureId);
create index Pyramidadm4NameIndex on Pyramid (adm4Name);
create index PyramidgisFeatureAsciiNameIndex on Pyramid (asciiName);
create index Pyramidadm1codeIndex on Pyramid (adm1Code);
create index Pyramidadm3codeIndex on Pyramid (adm3Code);
create index PyramidgisFeatureFeatureClassindex on Pyramid (featureClass);
create index Pyramidadm2codeIndex on Pyramid (adm2Code);
create index PyramidgisFeatureFeatureCodeindex on Pyramid (featureCode);
create index Pyramidadm3NameIndex on Pyramid (adm3Name);
create index Pyramidadm1NameIndex on Pyramid (adm1Name);
create index Pyramidadm4codeIndex on Pyramid (adm4Code);
create index PyramidgisFeatureNameIndex on Pyramid (name);
alter table Pyramid add constraint FK637222053AEF83D5ce11d30 foreign key (adm) references Adm;
create index QuaygisFeatureCountryindex on Quay (countryCode);
create index Quayadm2NameIndex on Quay (adm2Name);
create index QuaygisFeatureIdIndex on Quay (featureId);
create index Quayadm4NameIndex on Quay (adm4Name);
create index QuaygisFeatureAsciiNameIndex on Quay (asciiName);
create index Quayadm1codeIndex on Quay (adm1Code);
create index Quayadm3codeIndex on Quay (adm3Code);
create index QuaygisFeatureFeatureClassindex on Quay (featureClass);
create index Quayadm2codeIndex on Quay (adm2Code);
create index QuaygisFeatureFeatureCodeindex on Quay (featureCode);
create index Quayadm3NameIndex on Quay (adm3Name);
create index Quayadm1NameIndex on Quay (adm1Name);
create index Quayadm4codeIndex on Quay (adm4Code);
create index QuaygisFeatureNameIndex on Quay (name);
alter table Quay add constraint FK637222053AEF83D26957c foreign key (adm) references Adm;
create index RailgisFeatureCountryindex on Rail (countryCode);
create index Railadm2NameIndex on Rail (adm2Name);
create index RailgisFeatureIdIndex on Rail (featureId);
create index Railadm4NameIndex on Rail (adm4Name);
create index RailgisFeatureAsciiNameIndex on Rail (asciiName);
create index Railadm1codeIndex on Rail (adm1Code);
create index Railadm3codeIndex on Rail (adm3Code);
create index RailgisFeatureFeatureClassindex on Rail (featureClass);
create index Railadm2codeIndex on Rail (adm2Code);
create index RailgisFeatureFeatureCodeindex on Rail (featureCode);
create index Railadm3NameIndex on Rail (adm3Name);
create index Railadm1NameIndex on Rail (adm1Name);
create index Railadm4codeIndex on Rail (adm4Code);
create index RailgisFeatureNameIndex on Rail (name);
alter table Rail add constraint FK637222053AEF83D26bfb2 foreign key (adm) references Adm;
create index RailRoadStationgisFeatureCountryindex on RailRoadStation (countryCode);
create index RailRoadStationadm2NameIndex on RailRoadStation (adm2Name);
create index RailRoadStationgisFeatureIdIndex on RailRoadStation (featureId);
create index RailRoadStationadm4NameIndex on RailRoadStation (adm4Name);
create index RailRoadStationgisFeatureAsciiNameIndex on RailRoadStation (asciiName);
create index RailRoadStationadm1codeIndex on RailRoadStation (adm1Code);
create index RailRoadStationadm3codeIndex on RailRoadStation (adm3Code);
create index RailRoadStationgisFeatureFeatureClassindex on RailRoadStation (featureClass);
create index RailRoadStationadm2codeIndex on RailRoadStation (adm2Code);
create index RailRoadStationgisFeatureFeatureCodeindex on RailRoadStation (featureCode);
create index RailRoadStationadm3NameIndex on RailRoadStation (adm3Name);
create index RailRoadStationadm1NameIndex on RailRoadStation (adm1Name);
create index RailRoadStationadm4codeIndex on RailRoadStation (adm4Code);
create index RailRoadStationgisFeatureNameIndex on RailRoadStation (name);
alter table RailRoadStation add constraint FK637222053AEF83Dc1225ae2 foreign key (adm) references Adm;
create index RanchgisFeatureCountryindex on Ranch (countryCode);
create index Ranchadm2NameIndex on Ranch (adm2Name);
create index RanchgisFeatureIdIndex on Ranch (featureId);
create index Ranchadm4NameIndex on Ranch (adm4Name);
create index RanchgisFeatureAsciiNameIndex on Ranch (asciiName);
create index Ranchadm1codeIndex on Ranch (adm1Code);
create index Ranchadm3codeIndex on Ranch (adm3Code);
create index RanchgisFeatureFeatureClassindex on Ranch (featureClass);
create index Ranchadm2codeIndex on Ranch (adm2Code);
create index RanchgisFeatureFeatureCodeindex on Ranch (featureCode);
create index Ranchadm3NameIndex on Ranch (adm3Name);
create index Ranchadm1NameIndex on Ranch (adm1Name);
create index Ranchadm4codeIndex on Ranch (adm4Code);
create index RanchgisFeatureNameIndex on Ranch (name);
alter table Ranch add constraint FK637222053AEF83D4b148a4 foreign key (adm) references Adm;
create index RavingisFeatureCountryindex on Ravin (countryCode);
create index Ravinadm2NameIndex on Ravin (adm2Name);
create index RavingisFeatureIdIndex on Ravin (featureId);
create index Ravinadm4NameIndex on Ravin (adm4Name);
create index RavingisFeatureAsciiNameIndex on Ravin (asciiName);
create index Ravinadm1codeIndex on Ravin (adm1Code);
create index Ravinadm3codeIndex on Ravin (adm3Code);
create index RavingisFeatureFeatureClassindex on Ravin (featureClass);
create index Ravinadm2codeIndex on Ravin (adm2Code);
create index RavingisFeatureFeatureCodeindex on Ravin (featureCode);
create index Ravinadm3NameIndex on Ravin (adm3Name);
create index Ravinadm1NameIndex on Ravin (adm1Name);
create index Ravinadm4codeIndex on Ravin (adm4Code);
create index RavingisFeatureNameIndex on Ravin (name);
alter table Ravin add constraint FK637222053AEF83D4b1676c foreign key (adm) references Adm;
create index ReefgisFeatureCountryindex on Reef (countryCode);
create index Reefadm2NameIndex on Reef (adm2Name);
create index ReefgisFeatureIdIndex on Reef (featureId);
create index Reefadm4NameIndex on Reef (adm4Name);
create index ReefgisFeatureAsciiNameIndex on Reef (asciiName);
create index Reefadm1codeIndex on Reef (adm1Code);
create index Reefadm3codeIndex on Reef (adm3Code);
create index ReefgisFeatureFeatureClassindex on Reef (featureClass);
create index Reefadm2codeIndex on Reef (adm2Code);
create index ReefgisFeatureFeatureCodeindex on Reef (featureCode);
create index Reefadm3NameIndex on Reef (adm3Name);
create index Reefadm1NameIndex on Reef (adm1Name);
create index Reefadm4codeIndex on Reef (adm4Code);
create index ReefgisFeatureNameIndex on Reef (name);
alter table Reef add constraint FK637222053AEF83D26ce34 foreign key (adm) references Adm;
create index ReligiousgisFeatureCountryindex on Religious (countryCode);
create index Religiousadm2NameIndex on Religious (adm2Name);
create index ReligiousgisFeatureIdIndex on Religious (featureId);
create index Religiousadm4NameIndex on Religious (adm4Name);
create index ReligiousgisFeatureAsciiNameIndex on Religious (asciiName);
create index Religiousadm1codeIndex on Religious (adm1Code);
create index Religiousadm3codeIndex on Religious (adm3Code);
create index ReligiousgisFeatureFeatureClassindex on Religious (featureClass);
create index Religiousadm2codeIndex on Religious (adm2Code);
create index ReligiousgisFeatureFeatureCodeindex on Religious (featureCode);
create index Religiousadm3NameIndex on Religious (adm3Name);
create index Religiousadm1NameIndex on Religious (adm1Name);
create index Religiousadm4codeIndex on Religious (adm4Code);
create index ReligiousgisFeatureNameIndex on Religious (name);
alter table Religious add constraint FK637222053AEF83D83ecfa1b foreign key (adm) references Adm;
create index ReservegisFeatureCountryindex on Reserve (countryCode);
create index Reserveadm2NameIndex on Reserve (adm2Name);
create index ReservegisFeatureIdIndex on Reserve (featureId);
create index Reserveadm4NameIndex on Reserve (adm4Name);
create index ReservegisFeatureAsciiNameIndex on Reserve (asciiName);
create index Reserveadm1codeIndex on Reserve (adm1Code);
create index Reserveadm3codeIndex on Reserve (adm3Code);
create index ReservegisFeatureFeatureClassindex on Reserve (featureClass);
create index Reserveadm2codeIndex on Reserve (adm2Code);
create index ReservegisFeatureFeatureCodeindex on Reserve (featureCode);
create index Reserveadm3NameIndex on Reserve (adm3Name);
create index Reserveadm1NameIndex on Reserve (adm1Name);
create index Reserveadm4codeIndex on Reserve (adm4Code);
create index ReservegisFeatureNameIndex on Reserve (name);
alter table Reserve add constraint FK637222053AEF83Da49ca49c foreign key (adm) references Adm;
create index RestaurantgisFeatureCountryindex on Restaurant (countryCode);
create index Restaurantadm2NameIndex on Restaurant (adm2Name);
create index RestaurantgisFeatureIdIndex on Restaurant (featureId);
create index Restaurantadm4NameIndex on Restaurant (adm4Name);
create index RestaurantgisFeatureAsciiNameIndex on Restaurant (asciiName);
create index Restaurantadm1codeIndex on Restaurant (adm1Code);
create index Restaurantadm3codeIndex on Restaurant (adm3Code);
create index RestaurantgisFeatureFeatureClassindex on Restaurant (featureClass);
create index Restaurantadm2codeIndex on Restaurant (adm2Code);
create index RestaurantgisFeatureFeatureCodeindex on Restaurant (featureCode);
create index Restaurantadm3NameIndex on Restaurant (adm3Name);
create index Restaurantadm1NameIndex on Restaurant (adm1Name);
create index Restaurantadm4codeIndex on Restaurant (adm4Code);
create index RestaurantgisFeatureNameIndex on Restaurant (name);
alter table Restaurant add constraint FK637222053AEF83Dd2c275d foreign key (adm) references Adm;
create index RoadgisFeatureCountryindex on Road (countryCode);
create index Roadadm2NameIndex on Road (adm2Name);
create index RoadgisFeatureIdIndex on Road (featureId);
create index Roadadm4NameIndex on Road (adm4Name);
create index RoadgisFeatureAsciiNameIndex on Road (asciiName);
create index Roadadm1codeIndex on Road (adm1Code);
create index Roadadm3codeIndex on Road (adm3Code);
create index RoadgisFeatureFeatureClassindex on Road (featureClass);
create index Roadadm2codeIndex on Road (adm2Code);
create index RoadgisFeatureFeatureCodeindex on Road (featureCode);
create index Roadadm3NameIndex on Road (adm3Name);
create index Roadadm1NameIndex on Road (adm1Name);
create index Roadadm4codeIndex on Road (adm4Code);
create index RoadgisFeatureNameIndex on Road (name);
alter table Road add constraint FK637222053AEF83D26f340 foreign key (adm) references Adm;
create index SchoolgisFeatureCountryindex on School (countryCode);
create index Schooladm2NameIndex on School (adm2Name);
create index SchoolgisFeatureIdIndex on School (featureId);
create index Schooladm4NameIndex on School (adm4Name);
create index SchoolgisFeatureAsciiNameIndex on School (asciiName);
create index Schooladm1codeIndex on School (adm1Code);
create index Schooladm3codeIndex on School (adm3Code);
create index SchoolgisFeatureFeatureClassindex on School (featureClass);
create index Schooladm2codeIndex on School (adm2Code);
create index SchoolgisFeatureFeatureCodeindex on School (featureCode);
create index Schooladm3NameIndex on School (adm3Name);
create index Schooladm1NameIndex on School (adm1Name);
create index Schooladm4codeIndex on School (adm4Code);
create index SchoolgisFeatureNameIndex on School (name);
alter table School add constraint FK637222053AEF83D93464794 foreign key (adm) references Adm;
create index SeagisFeatureCountryindex on Sea (countryCode);
create index Seaadm2NameIndex on Sea (adm2Name);
create index SeagisFeatureIdIndex on Sea (featureId);
create index Seaadm4NameIndex on Sea (adm4Name);
create index SeagisFeatureAsciiNameIndex on Sea (asciiName);
create index Seaadm1codeIndex on Sea (adm1Code);
create index Seaadm3codeIndex on Sea (adm3Code);
create index SeagisFeatureFeatureClassindex on Sea (featureClass);
create index Seaadm2codeIndex on Sea (adm2Code);
create index SeagisFeatureFeatureCodeindex on Sea (featureCode);
create index Seaadm3NameIndex on Sea (adm3Name);
create index Seaadm1NameIndex on Sea (adm1Name);
create index Seaadm4codeIndex on Sea (adm4Code);
create index SeagisFeatureNameIndex on Sea (name);
alter table Sea add constraint FK637222053AEF83D1442f foreign key (adm) references Adm;
create index SpringgisFeatureCountryindex on Spring (countryCode);
create index Springadm2NameIndex on Spring (adm2Name);
create index SpringgisFeatureIdIndex on Spring (featureId);
create index Springadm4NameIndex on Spring (adm4Name);
create index SpringgisFeatureAsciiNameIndex on Spring (asciiName);
create index Springadm1codeIndex on Spring (adm1Code);
create index Springadm3codeIndex on Spring (adm3Code);
create index SpringgisFeatureFeatureClassindex on Spring (featureClass);
create index Springadm2codeIndex on Spring (adm2Code);
create index SpringgisFeatureFeatureCodeindex on Spring (featureCode);
create index Springadm3NameIndex on Spring (adm3Name);
create index Springadm1NameIndex on Spring (adm1Name);
create index Springadm4codeIndex on Spring (adm4Code);
create index SpringgisFeatureNameIndex on Spring (name);
alter table Spring add constraint FK637222053AEF83D9401ee2d foreign key (adm) references Adm;
create index StadiumgisFeatureCountryindex on Stadium (countryCode);
create index Stadiumadm2NameIndex on Stadium (adm2Name);
create index StadiumgisFeatureIdIndex on Stadium (featureId);
create index Stadiumadm4NameIndex on Stadium (adm4Name);
create index StadiumgisFeatureAsciiNameIndex on Stadium (asciiName);
create index Stadiumadm1codeIndex on Stadium (adm1Code);
create index Stadiumadm3codeIndex on Stadium (adm3Code);
create index StadiumgisFeatureFeatureClassindex on Stadium (featureClass);
create index Stadiumadm2codeIndex on Stadium (adm2Code);
create index StadiumgisFeatureFeatureCodeindex on Stadium (featureCode);
create index Stadiumadm3NameIndex on Stadium (adm3Name);
create index Stadiumadm1NameIndex on Stadium (adm1Name);
create index Stadiumadm4codeIndex on Stadium (adm4Code);
create index StadiumgisFeatureNameIndex on Stadium (name);
alter table Stadium add constraint FK637222053AEF83Df21d53dd foreign key (adm) references Adm;
create index StraitgisFeatureCountryindex on Strait (countryCode);
create index Straitadm2NameIndex on Strait (adm2Name);
create index StraitgisFeatureIdIndex on Strait (featureId);
create index Straitadm4NameIndex on Strait (adm4Name);
create index StraitgisFeatureAsciiNameIndex on Strait (asciiName);
create index Straitadm1codeIndex on Strait (adm1Code);
create index Straitadm3codeIndex on Strait (adm3Code);
create index StraitgisFeatureFeatureClassindex on Strait (featureClass);
create index Straitadm2codeIndex on Strait (adm2Code);
create index StraitgisFeatureFeatureCodeindex on Strait (featureCode);
create index Straitadm3NameIndex on Strait (adm3Name);
create index Straitadm1NameIndex on Strait (adm1Name);
create index Straitadm4codeIndex on Strait (adm4Code);
create index StraitgisFeatureNameIndex on Strait (name);
alter table Strait add constraint FK637222053AEF83D943a2d9b foreign key (adm) references Adm;
create index StreamgisFeatureCountryindex on Stream (countryCode);
create index Streamadm2NameIndex on Stream (adm2Name);
create index StreamgisFeatureIdIndex on Stream (featureId);
create index Streamadm4NameIndex on Stream (adm4Name);
create index StreamgisFeatureAsciiNameIndex on Stream (asciiName);
create index Streamadm1codeIndex on Stream (adm1Code);
create index Streamadm3codeIndex on Stream (adm3Code);
create index StreamgisFeatureFeatureClassindex on Stream (featureClass);
create index Streamadm2codeIndex on Stream (adm2Code);
create index StreamgisFeatureFeatureCodeindex on Stream (featureCode);
create index Streamadm3NameIndex on Stream (adm3Name);
create index Streamadm1NameIndex on Stream (adm1Name);
create index Streamadm4codeIndex on Stream (adm4Code);
create index StreamgisFeatureNameIndex on Stream (name);
alter table Stream add constraint FK637222053AEF83D943a3ba0 foreign key (adm) references Adm;
create index StreetgisFeatureCountryindex on Street (countryCode);
create index Streetadm2NameIndex on Street (adm2Name);
create index StreetgisFeatureIdIndex on Street (featureId);
create index Streetadm4NameIndex on Street (adm4Name);
create index StreetgisFeatureAsciiNameIndex on Street (asciiName);
create index Streetadm1codeIndex on Street (adm1Code);
create index Streetadm3codeIndex on Street (adm3Code);
create index StreetgisFeatureFeatureClassindex on Street (featureClass);
create index Streetadm2codeIndex on Street (adm2Code);
create index StreetgisFeatureFeatureCodeindex on Street (featureCode);
create index Streetadm3NameIndex on Street (adm3Name);
create index Streetadm1NameIndex on Street (adm1Name);
create index Streetadm4codeIndex on Street (adm4Code);
create index StreetgisFeatureNameIndex on Street (name);
alter table Street add constraint FK637222053AEF83D943a3c23 foreign key (adm) references Adm;
create index TheatergisFeatureCountryindex on Theater (countryCode);
create index Theateradm2NameIndex on Theater (adm2Name);
create index TheatergisFeatureIdIndex on Theater (featureId);
create index Theateradm4NameIndex on Theater (adm4Name);
create index TheatergisFeatureAsciiNameIndex on Theater (asciiName);
create index Theateradm1codeIndex on Theater (adm1Code);
create index Theateradm3codeIndex on Theater (adm3Code);
create index TheatergisFeatureFeatureClassindex on Theater (featureClass);
create index Theateradm2codeIndex on Theater (adm2Code);
create index TheatergisFeatureFeatureCodeindex on Theater (featureCode);
create index Theateradm3NameIndex on Theater (adm3Name);
create index Theateradm1NameIndex on Theater (adm1Name);
create index Theateradm4codeIndex on Theater (adm4Code);
create index TheatergisFeatureNameIndex on Theater (name);
alter table Theater add constraint FK637222053AEF83D12c08ff1 foreign key (adm) references Adm;
create index TowergisFeatureCountryindex on Tower (countryCode);
create index Toweradm2NameIndex on Tower (adm2Name);
create index TowergisFeatureIdIndex on Tower (featureId);
create index Toweradm4NameIndex on Tower (adm4Name);
create index TowergisFeatureAsciiNameIndex on Tower (asciiName);
create index Toweradm1codeIndex on Tower (adm1Code);
create index Toweradm3codeIndex on Tower (adm3Code);
create index TowergisFeatureFeatureClassindex on Tower (featureClass);
create index Toweradm2codeIndex on Tower (adm2Code);
create index TowergisFeatureFeatureCodeindex on Tower (featureCode);
create index Toweradm3NameIndex on Tower (adm3Name);
create index Toweradm1NameIndex on Tower (adm1Name);
create index Toweradm4codeIndex on Tower (adm4Code);
create index TowergisFeatureNameIndex on Tower (name);
alter table Tower add constraint FK637222053AEF83D4d3f6e9 foreign key (adm) references Adm;
create index TreegisFeatureCountryindex on Tree (countryCode);
create index Treeadm2NameIndex on Tree (adm2Name);
create index TreegisFeatureIdIndex on Tree (featureId);
create index Treeadm4NameIndex on Tree (adm4Name);
create index TreegisFeatureAsciiNameIndex on Tree (asciiName);
create index Treeadm1codeIndex on Tree (adm1Code);
create index Treeadm3codeIndex on Tree (adm3Code);
create index TreegisFeatureFeatureClassindex on Tree (featureClass);
create index Treeadm2codeIndex on Tree (adm2Code);
create index TreegisFeatureFeatureCodeindex on Tree (featureCode);
create index Treeadm3NameIndex on Tree (adm3Name);
create index Treeadm1NameIndex on Tree (adm1Name);
create index Treeadm4codeIndex on Tree (adm4Code);
create index TreegisFeatureNameIndex on Tree (name);
alter table Tree add constraint FK637222053AEF83D27e7be foreign key (adm) references Adm;
create index TunnelgisFeatureCountryindex on Tunnel (countryCode);
create index Tunneladm2NameIndex on Tunnel (adm2Name);
create index TunnelgisFeatureIdIndex on Tunnel (featureId);
create index Tunneladm4NameIndex on Tunnel (adm4Name);
create index TunnelgisFeatureAsciiNameIndex on Tunnel (asciiName);
create index Tunneladm1codeIndex on Tunnel (adm1Code);
create index Tunneladm3codeIndex on Tunnel (adm3Code);
create index TunnelgisFeatureFeatureClassindex on Tunnel (featureClass);
create index Tunneladm2codeIndex on Tunnel (adm2Code);
create index TunnelgisFeatureFeatureCodeindex on Tunnel (featureCode);
create index Tunneladm3NameIndex on Tunnel (adm3Name);
create index Tunneladm1NameIndex on Tunnel (adm1Name);
create index Tunneladm4codeIndex on Tunnel (adm4Code);
create index TunnelgisFeatureNameIndex on Tunnel (name);
alter table Tunnel add constraint FK637222053AEF83D95fb7c88 foreign key (adm) references Adm;
create index UnderSeagisFeatureCountryindex on UnderSea (countryCode);
create index UnderSeaadm2NameIndex on UnderSea (adm2Name);
create index UnderSeagisFeatureIdIndex on UnderSea (featureId);
create index UnderSeaadm4NameIndex on UnderSea (adm4Name);
create index UnderSeagisFeatureAsciiNameIndex on UnderSea (asciiName);
create index UnderSeaadm1codeIndex on UnderSea (adm1Code);
create index UnderSeaadm3codeIndex on UnderSea (adm3Code);
create index UnderSeagisFeatureFeatureClassindex on UnderSea (featureClass);
create index UnderSeaadm2codeIndex on UnderSea (adm2Code);
create index UnderSeagisFeatureFeatureCodeindex on UnderSea (featureCode);
create index UnderSeaadm3NameIndex on UnderSea (adm3Name);
create index UnderSeaadm1NameIndex on UnderSea (adm1Name);
create index UnderSeaadm4codeIndex on UnderSea (adm4Code);
create index UnderSeagisFeatureNameIndex on UnderSea (name);
alter table UnderSea add constraint FK637222053AEF83De91a5677 foreign key (adm) references Adm;
create index VineyardgisFeatureCountryindex on Vineyard (countryCode);
create index Vineyardadm2NameIndex on Vineyard (adm2Name);
create index VineyardgisFeatureIdIndex on Vineyard (featureId);
create index Vineyardadm4NameIndex on Vineyard (adm4Name);
create index VineyardgisFeatureAsciiNameIndex on Vineyard (asciiName);
create index Vineyardadm1codeIndex on Vineyard (adm1Code);
create index Vineyardadm3codeIndex on Vineyard (adm3Code);
create index VineyardgisFeatureFeatureClassindex on Vineyard (featureClass);
create index Vineyardadm2codeIndex on Vineyard (adm2Code);
create index VineyardgisFeatureFeatureCodeindex on Vineyard (featureCode);
create index Vineyardadm3NameIndex on Vineyard (adm3Name);
create index Vineyardadm1NameIndex on Vineyard (adm1Name);
create index Vineyardadm4codeIndex on Vineyard (adm4Code);
create index VineyardgisFeatureNameIndex on Vineyard (name);
alter table Vineyard add constraint FK637222053AEF83D59903604 foreign key (adm) references Adm;
create index VolcanogisFeatureCountryindex on Volcano (countryCode);
create index Volcanoadm2NameIndex on Volcano (adm2Name);
create index VolcanogisFeatureIdIndex on Volcano (featureId);
create index Volcanoadm4NameIndex on Volcano (adm4Name);
create index VolcanogisFeatureAsciiNameIndex on Volcano (asciiName);
create index Volcanoadm1codeIndex on Volcano (adm1Code);
create index Volcanoadm3codeIndex on Volcano (adm3Code);
create index VolcanogisFeatureFeatureClassindex on Volcano (featureClass);
create index Volcanoadm2codeIndex on Volcano (adm2Code);
create index VolcanogisFeatureFeatureCodeindex on Volcano (featureCode);
create index Volcanoadm3NameIndex on Volcano (adm3Name);
create index Volcanoadm1NameIndex on Volcano (adm1Name);
create index Volcanoadm4codeIndex on Volcano (adm4Code);
create index VolcanogisFeatureNameIndex on Volcano (name);
alter table Volcano add constraint FK637222053AEF83D88e239d2 foreign key (adm) references Adm;
create index WaterBodygisFeatureCountryindex on WaterBody (countryCode);
create index WaterBodyadm2NameIndex on WaterBody (adm2Name);
create index WaterBodygisFeatureIdIndex on WaterBody (featureId);
create index WaterBodyadm4NameIndex on WaterBody (adm4Name);
create index WaterBodygisFeatureAsciiNameIndex on WaterBody (asciiName);
create index WaterBodyadm1codeIndex on WaterBody (adm1Code);
create index WaterBodyadm3codeIndex on WaterBody (adm3Code);
create index WaterBodygisFeatureFeatureClassindex on WaterBody (featureClass);
create index WaterBodyadm2codeIndex on WaterBody (adm2Code);
create index WaterBodygisFeatureFeatureCodeindex on WaterBody (featureCode);
create index WaterBodyadm3NameIndex on WaterBody (adm3Name);
create index WaterBodyadm1NameIndex on WaterBody (adm1Name);
create index WaterBodyadm4codeIndex on WaterBody (adm4Code);
create index WaterBodygisFeatureNameIndex on WaterBody (name);
alter table WaterBody add constraint FK637222053AEF83D6aa62f39 foreign key (adm) references Adm;
create index ZoogisFeatureCountryindex on Zoo (countryCode);
create index Zooadm2NameIndex on Zoo (adm2Name);
create index ZoogisFeatureIdIndex on Zoo (featureId);
create index Zooadm4NameIndex on Zoo (adm4Name);
create index ZoogisFeatureAsciiNameIndex on Zoo (asciiName);
create index Zooadm1codeIndex on Zoo (adm1Code);
create index Zooadm3codeIndex on Zoo (adm3Code);
create index ZoogisFeatureFeatureClassindex on Zoo (featureClass);
create index Zooadm2codeIndex on Zoo (adm2Code);
create index ZoogisFeatureFeatureCodeindex on Zoo (featureCode);
create index Zooadm3NameIndex on Zoo (adm3Name);
create index Zooadm1NameIndex on Zoo (adm1Name);
create index Zooadm4codeIndex on Zoo (adm4Code);
create index ZoogisFeatureNameIndex on Zoo (name);
alter table Zoo add constraint FK637222053AEF83D15fba foreign key (adm) references Adm;
alter table user_role add constraint FK143BF46A84C5D51E foreign key (user_id) references app_user;
alter table user_role add constraint FK143BF46ADF9B113E foreign key (role_id) references role;
create sequence Alternatename_sequence;
create sequence gisfeature_sequence;
create sequence hibernate_sequence;
create sequence language_id_seq;
create sequence stats_Usage_Sequence;
