#!/bin/sh

ssh nimoy mysqldump --compatible=postgresql --add-locks=false --set-charset \

--no-data --lock-tables=false --password geoscrub geoscrub

-- MySQL dump 10.13  Distrib 5.5.24, for debian-linux-gnu (x86_64)

--

-- Host: localhost    Database: geoscrub

-- ------------------------------------------------------

-- Server version	5.5.24-0ubuntu0.12.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES latin1 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,POSTGRESQL' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--

-- Table structure for table "geoscrub"

--

DROP TABLE IF EXISTS "geoscrub";

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "geoscrub" (

  "geoscrubID" int(11) unsigned NOT NULL DEFAULT '0',

  "sourceTable" varchar(50) CHARACTER SET utf8 NOT NULL,

  "sourceID" int(11) unsigned DEFAULT NULL,

  "countryVerbatim" varchar(100) CHARACTER SET utf8 DEFAULT NULL,

  "countryID" int(11) unsigned DEFAULT NULL,

  "isInCountry" int(1) DEFAULT NULL,

  "distErrCountry" double DEFAULT NULL,

  "stateProvinceVerbatim" varchar(100) CHARACTER SET utf8 DEFAULT NULL,

  "stateProvinceID" int(11) unsigned DEFAULT NULL,

  "isInStateProvince" int(1) DEFAULT NULL,

  "distErrStateProvince" double DEFAULT NULL,

  "countyParishVerbatim" varchar(100) CHARACTER SET utf8 DEFAULT NULL,

  "countyParishID" int(11) unsigned DEFAULT NULL,

  "isInCountyParish" int(1) DEFAULT NULL,

  "distErrCountyParish" double DEFAULT NULL,

  "elevationVerbatim" varchar(50) CHARACTER SET utf8 DEFAULT NULL,

  "elevMaxVerbatim" varchar(50) CHARACTER SET utf8 DEFAULT NULL,

  "elevMinVerbatim" varchar(50) CHARACTER SET utf8 DEFAULT NULL,

  "latitudeDecimalVerbatim" decimal(10,5) DEFAULT NULL,

  "longitudeDecimalVerbatim" decimal(10,5) DEFAULT NULL,

  "isBadLatLong" int(1) DEFAULT NULL,

  "badLatLongReason" varchar(250) CHARACTER SET utf8 DEFAULT NULL,

  "latitudeDecimalCorrected" decimal(10,5) DEFAULT NULL,

  "longitudeDecimalCorrected" decimal(10,5) DEFAULT NULL,

  "latLongCorrectedRemarks" varchar(250) CHARACTER SET utf8 DEFAULT NULL,

  "localityVerbatim" varchar(1000) CHARACTER SET utf8 DEFAULT NULL,

  "isCultivated" int(1) unsigned DEFAULT NULL,

  "isCultivatedReason" varchar(255) DEFAULT NULL,

  "countryStd" varchar(150) DEFAULT NULL,

  "stateProvinceStd" varchar(150) DEFAULT NULL,

  "isNewWorld" int(1) DEFAULT NULL,

  KEY "geoscrubID_idx" ("geoscrubID"),

  KEY "sourceTable_idx" ("sourceTable"),

  KEY "sourceID_idx" ("sourceID"),

  KEY "Index_isCultivated" ("isCultivated"),

  KEY "Index_isCultivatedReason" ("isCultivatedReason"),

  KEY "countryStd" ("countryStd"),

  KEY "stateProvinceStd" ("stateProvinceStd"),

  KEY "isNewWorld" ("isNewWorld"),

  KEY "countryID" ("countryID"),

  KEY "stateProvinceID" ("stateProvinceID")

);

/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2012-10-30 16:02:51

#!/bin/sh

ssh nimoy mysqldump --compatible=postgresql --add-locks=false --set-charset \

--no-create-info --lock-tables=false --password geoscrub geoscrub

SET standard_conforming_strings = off;

-- MySQL dump 10.13  Distrib 5.5.24, for debian-linux-gnu (x86_64)

--

-- Host: localhost    Database: geoscrub

-- ------------------------------------------------------

-- Server version	5.5.24-0ubuntu0.12.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

SET NAMES 'latin1';

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,POSTGRESQL' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--

-- Table structure for table "geoscrub"

--

DROP TABLE IF EXISTS "geoscrub";

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "geoscrub" (

  "geoscrubID" integer NOT NULL DEFAULT '0',

  "sourceTable" varchar(50) NOT NULL,

  "sourceID" integer DEFAULT NULL,

  "countryVerbatim" varchar(100) DEFAULT NULL,

  "countryID" integer DEFAULT NULL,

  "isInCountry" integer DEFAULT NULL,

  "distErrCountry" double precision DEFAULT NULL,

  "stateProvinceVerbatim" varchar(100) DEFAULT NULL,

  "stateProvinceID" integer DEFAULT NULL,

  "isInStateProvince" integer DEFAULT NULL,

  "distErrStateProvince" double precision DEFAULT NULL,

  "countyParishVerbatim" varchar(100) DEFAULT NULL,

  "countyParishID" integer DEFAULT NULL,

  "isInCountyParish" integer DEFAULT NULL,

  "distErrCountyParish" double precision DEFAULT NULL,

  "elevationVerbatim" varchar(50) DEFAULT NULL,

  "elevMaxVerbatim" varchar(50) DEFAULT NULL,

  "elevMinVerbatim" varchar(50) DEFAULT NULL,

  "latitudeDecimalVerbatim" decimal(10,5) DEFAULT NULL,

  "longitudeDecimalVerbatim" decimal(10,5) DEFAULT NULL,

  "isBadLatLong" integer DEFAULT NULL,

  "badLatLongReason" varchar(250) DEFAULT NULL,

  "latitudeDecimalCorrected" decimal(10,5) DEFAULT NULL,

  "longitudeDecimalCorrected" decimal(10,5) DEFAULT NULL,

  "latLongCorrectedRemarks" varchar(250) DEFAULT NULL,

  "localityVerbatim" varchar(1000) DEFAULT NULL,

  "isCultivated" integer DEFAULT NULL,

  "isCultivatedReason" varchar(255) DEFAULT NULL,

  "countryStd" varchar(150) DEFAULT NULL,

  "stateProvinceStd" varchar(150) DEFAULT NULL,

  "isNewWorld" integer DEFAULT NULL,

  "geoscrubID_idx_index" boolean,

  "sourceTable_idx_index" boolean,

  "sourceID_idx_index" boolean,

  "Index_isCultivated_index" boolean,

  "Index_isCultivatedReason_index" boolean,

  "countryStd_index" boolean,

  "stateProvinceStd_index" boolean,

  "isNewWorld_index" boolean,

  "countryID_index" boolean,

  "stateProvinceID_index" boolean

);

/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2012-10-30 16:02:51

ALTER TABLE geoscrub ADD PRIMARY KEY ("geoscrubID");

ALTER TABLE geoscrub ADD UNIQUE ("sourceID");

SELECT

DISTINCT ON (

      "countryVerbatim"

    , "stateProvinceVerbatim"

    , "countyParishVerbatim"

    , "latitudeDecimalVerbatim"

    , "longitudeDecimalVerbatim"

)

*

FROM geoscrub

WHERE

NOT (

    -- Empty coordinates

    "latitudeDecimalVerbatim" = 0

    AND "longitudeDecimalVerbatim" = 0

)

ORDER BY

      "countryVerbatim"

    , "stateProvinceVerbatim"

    , "countyParishVerbatim"

    , "latitudeDecimalVerbatim"

    , "longitudeDecimalVerbatim"

    , "geoscrubID"

;

ALTER TABLE :table ADD PRIMARY KEY ("geoscrubID");

ALTER TABLE :table ADD UNIQUE ("sourceID");

geoscrubID,sourceTable,sourceID,countryVerbatim,countryID,isInCountry,distErrCountry,stateProvinceVerbatim,stateProvinceID,isInStateProvince,distErrStateProvince,countyParishVerbatim,countyParishID,isInCountyParish,distErrCountyParish,elevationVerbatim,elevMaxVerbatim,elevMinVerbatim,latitudeDecimalVerbatim,longitudeDecimalVerbatim,isBadLatLong,badLatLongReason,latitudeDecimalCorrected,longitudeDecimalCorrected,latLongCorrectedRemarks,localityVerbatim,isCultivated,isCultivatedReason,countryStd,stateProvinceStd,isNewWorld,geoscrubID_idx_index,sourceTable_idx_index,sourceID_idx_index,Index_isCultivated_index,Index_isCultivatedReason_index,countryStd_index,stateProvinceStd_index,isNewWorld_index,countryID_index,stateProvinceID_index

geoscrub,VegCore,Filter,Comments

geoscrubID,locationID,,

sourceTable,OMIT,,Not geoscrub-related

sourceID,OMIT,,Not needed because geoscrubID is provided

countryVerbatim,country,,

countryID,OMIT,,Not needed

isInCountry,latLongInCountry,,

distErrCountry,distanceToCountry_km,,"Assuming units based on the range of values and the circumference of the Earth [1].

[1] ""Circumference 40,075.017 km"" (http://en.wikipedia.org/wiki/Earth)"

stateProvinceVerbatim,stateProvince,,

stateProvinceID,OMIT,,Not needed

isInStateProvince,latLongInStateProvince,,

distErrStateProvince,distanceToStateProvince_km,,"Assuming units based on the range of values and the circumference of the Earth [1].

[1] ""Circumference 40,075.017 km"" (http://en.wikipedia.org/wiki/Earth)"

countyParishVerbatim,OMIT,,Not geoscrubbed

countyParishID,OMIT,,Not geoscrubbed

isInCountyParish,UNUSED,,

distErrCountyParish,UNUSED,,

elevationVerbatim,OMIT,,Not geoscrub-related

elevMaxVerbatim,OMIT,,Not geoscrub-related

elevMinVerbatim,OMIT,,Not geoscrub-related

latitudeDecimalVerbatim,decimalLatitude,,

longitudeDecimalVerbatim,decimalLongitude,,

isBadLatLong,latLongDomainInvalid,,

badLatLongReason,*badLatLongReason,,

latitudeDecimalCorrected,UNUSED,,

longitudeDecimalCorrected,UNUSED,,

latLongCorrectedRemarks,*latLongCorrectedRemarks,,

localityVerbatim,OMIT,,Not geoscrubbed

isCultivated,OMIT,,Not geoscrub-related

isCultivatedReason,OMIT,,Not geoscrub-related

countryStd,acceptedCountry,,

stateProvinceStd,acceptedStateProvince,,

isNewWorld,OMIT,,Not geoscrub-related

geoscrubID_idx_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

sourceTable_idx_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

sourceID_idx_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_isCultivated_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_isCultivatedReason_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

countryStd_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

stateProvinceStd_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

isNewWorld_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

countryID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

stateProvinceID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

geoscrub,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments

geoscrubID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",

isInCountry,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists",

geoscrubID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",

geoscrubID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",

geoscrubID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",

geoscrubID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",

latitudeDecimalVerbatim,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",

longitudeDecimalVerbatim,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",

countryVerbatim,/location/locationplace/*_id/place/country,

isInCountry,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/cond/_exists",

latitudeDecimalVerbatim,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg",

longitudeDecimalVerbatim,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg",

countryStd,/location/locationplace/*_id/place/matched_place_id/place/country,

distErrCountry,/location/locationplace/*_id/place/matched_place_id/place/distance_to_country_m/_km_to_m/value,"Assuming units based on the range of values and the circumference of the Earth [1].

[1] ""Circumference 40,075.017 km"" (http://en.wikipedia.org/wiki/Earth)"

distErrStateProvince,/location/locationplace/*_id/place/matched_place_id/place/distance_to_state_m/_km_to_m/value,"Assuming units based on the range of values and the circumference of the Earth [1].

[1] ""Circumference 40,075.017 km"" (http://en.wikipedia.org/wiki/Earth)"

isInCountry,/location/locationplace/*_id/place/matched_place_id/place/georeference_valid/_first/2/_and/1,

isInStateProvince,/location/locationplace/*_id/place/matched_place_id/place/georeference_valid/_first/2/_and/2,

stateProvinceStd,/location/locationplace/*_id/place/matched_place_id/place/stateprovince,

isInCountry,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/cond/_exists",

geoscrubID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then",

stateProvinceVerbatim,/location/locationplace/*_id/place/stateprovince,

geoscrubID,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/1",

Index_isCultivatedReason_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

Index_isCultivated_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

badLatLongReason,,** No join mapping for *badLatLongReason ** 

countryID,,** No non-empty join mapping for OMIT ** Not needed

countryID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

countryStd_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

countyParishID,,** No non-empty join mapping for OMIT ** Not geoscrubbed

countyParishVerbatim,,** No non-empty join mapping for OMIT ** Not geoscrubbed

distErrCountyParish,,** No non-empty join mapping for UNUSED ** 

elevMaxVerbatim,,** No non-empty join mapping for OMIT ** Not geoscrub-related

elevMinVerbatim,,** No non-empty join mapping for OMIT ** Not geoscrub-related

elevationVerbatim,,** No non-empty join mapping for OMIT ** Not geoscrub-related

geoscrubID_idx_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

isBadLatLong,,** No join mapping for latLongDomainInvalid ** 

isCultivated,,** No non-empty join mapping for OMIT ** Not geoscrub-related

isCultivatedReason,,** No non-empty join mapping for OMIT ** Not geoscrub-related

isInCountyParish,,** No non-empty join mapping for UNUSED ** 

isNewWorld,,** No non-empty join mapping for OMIT ** Not geoscrub-related

isNewWorld_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

latLongCorrectedRemarks,,** No join mapping for *latLongCorrectedRemarks ** 

latitudeDecimalCorrected,,** No non-empty join mapping for UNUSED ** 

localityVerbatim,,** No non-empty join mapping for OMIT ** Not geoscrubbed

longitudeDecimalCorrected,,** No non-empty join mapping for UNUSED ** 

sourceID,,** No non-empty join mapping for OMIT ** Not needed because geoscrubID is provided

sourceID_idx_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

sourceTable,,** No non-empty join mapping for OMIT ** Not geoscrub-related

sourceTable_idx_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

stateProvinceID,,** No non-empty join mapping for OMIT ** Not needed

stateProvinceID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

stateProvinceStd_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation

Put template:

<VegBIEN>

    <_simplifyPath id="-1">

        <next>parent_id</next>

        <path>

            <location>

                <locationplace>

                    <place_id>

                        <place>

                            <coordinates_id>

                                <coordinates>

                                    <latitude_deg>

                                        <_nullIf>

                                            <null>0</null>

                                            <type>float</type>

                                            <value>$latitudeDecimalVerbatim</value>

                                        </_nullIf>

                                    </latitude_deg>

                                    <longitude_deg>

                                        <_nullIf>

                                            <null>0</null>

                                            <type>float</type>

                                            <value>$longitudeDecimalVerbatim</value>

                                        </_nullIf>

                                    </longitude_deg>

                                </coordinates>

                            </coordinates_id>

                            <country>$countryVerbatim</country>

                            <matched_place_id>

                                <place>

                                    <coordinates_id>

                                        <coordinates>

                                            <latitude_deg>$latitudeDecimalVerbatim</latitude_deg>

                                            <longitude_deg>$longitudeDecimalVerbatim</longitude_deg>

                                        </coordinates>

                                    </coordinates_id>

                                    <country>$countryStd</country>

                                    <distance_to_country_m><_km_to_m><value>$distErrCountry</value></_km_to_m></distance_to_country_m>

                                    <distance_to_state_m><_km_to_m><value>$distErrStateProvince</value></_km_to_m></distance_to_state_m>

                                    <georeference_valid>

                                        <_and>

                                            <1>$isInCountry</1>

                                            <2>$isInStateProvince</2>

                                        </_and>

                                    </georeference_valid>

                                    <stateprovince>$stateProvinceStd</stateprovince>

                                </place>

                            </matched_place_id>

                            <placecode>$geoscrubID</placecode>

                            <stateprovince>$stateProvinceVerbatim</stateprovince>

                        </place>

                    </place_id>

                </locationplace>

            </location>

        </path>

    </_simplifyPath>

</VegBIEN>

Inserted 7 new rows into database

geoscrubID,locationID,,

sourceTable,OMIT,,Not geoscrub-related

sourceID,OMIT,,Not needed because geoscrubID is provided

countryVerbatim,country,,

countryID,OMIT,,Not needed

isInCountry,latLongInCountry,,

distErrCountry,distanceToCountry_km,,"Assuming units based on the range of values and the circumference of the Earth [1].

[1] ""Circumference 40,075.017 km"" (http://en.wikipedia.org/wiki/Earth)"

stateProvinceVerbatim,stateProvince,,

stateProvinceID,OMIT,,Not needed

isInStateProvince,latLongInStateProvince,,

distErrStateProvince,distanceToStateProvince_km,,"Assuming units based on the range of values and the circumference of the Earth [1].

[1] ""Circumference 40,075.017 km"" (http://en.wikipedia.org/wiki/Earth)"

countyParishVerbatim,OMIT,,Not geoscrubbed

countyParishID,OMIT,,Not geoscrubbed

isInCountyParish,UNUSED,,

distErrCountyParish,UNUSED,,

elevationVerbatim,OMIT,,Not geoscrub-related

elevMaxVerbatim,OMIT,,Not geoscrub-related

elevMinVerbatim,OMIT,,Not geoscrub-related

latitudeDecimalVerbatim,decimalLatitude,,

longitudeDecimalVerbatim,decimalLongitude,,

isBadLatLong,latLongDomainInvalid,,

latitudeDecimalCorrected,UNUSED,,

longitudeDecimalCorrected,UNUSED,,

localityVerbatim,OMIT,,Not geoscrubbed

isCultivated,OMIT,,Not geoscrub-related

isCultivatedReason,OMIT,,Not geoscrub-related

countryStd,acceptedCountry,,

stateProvinceStd,acceptedStateProvince,,

isNewWorld,OMIT,,Not geoscrub-related

geoscrubID_idx_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

sourceTable_idx_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

sourceID_idx_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_isCultivated_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

Index_isCultivatedReason_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

countryStd_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

stateProvinceStd_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

isNewWorld_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

countryID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

stateProvinceID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation

latLongDomainInvalid

*badLatLongReason

*latLongCorrectedRemarks