Project

General

Profile

1
[MoveDB MSAccess to PostgreSQL]
2
  sourcefilename=C:\Users\visitor\Downloads\cvs-eep-archive-2014-10-07-correctedCVSData.mdb
3
  sourceusername=
4
  sourcepassword=
5
  sourcesystemdatabase=
6
  destinationmethod=DUMP
7
  destinationserver=
8
  destinationport=5432
9
  destinationusername=postgres
10
  destinationpassword=
11
  destinationdatabase=
12
  maintenancedb=postgres
13
  destinationdumpfilename=F:\Downloads\data.sql
14
  sourcetables[]="address","address\ADDRESS_ID","address\party_ID","address\organization_ID","address\orgPosition","address\email","address\deliveryPoint","address\city","address\administrativeArea","address\postalCode","address\country","address\currentFlag","address\addressStartDate","address\dba_src_ID","archiveLog","archiveLog\archiveLog_ID","archiveLog\archiveLogUser","archiveLog\archiveLogComment","archiveLog\commentDate","aux_Role","aux_Role\ROLE_ID","aux_Role\roleCode","aux_Role\roleDescription","aux_Role\accessionCode","aux_Role\roleProject","aux_Role\roleObservation","aux_Role\roleTaxonInt","aux_Role\roleClassInt","aux_Role\dba_src_ID","classContributor","classContributor\CLASSCONTRIBUTOR_ID","classContributor\COMMCLASS_ID","classContributor\PARTY_ID","classContributor\ROLE_ID","classContributor\dba_src_ID","commClass","commClass\COMMCLASS_ID","commClass\OBSERVATION_ID","commClass\classStartDate","commClass\classStopDate","commClass\inspection","commClass\tableAnalysis","commClass\multivariateAnalysis","commClass\expertSystem","commClass\classPublication_ID","commClass\classNotes","commClass\commName","commClass\commCode","commClass\commFramework","commClass\commLevel","commClass\accessionCode","commClass\dba_src_ID","commClass\dba_dataSource","commClass\classStopReason","commConcept","commConcept\COMMCONCEPT_ID","commConcept\COMMNAME_ID","commConcept\reference_ID","commConcept\commDescription","commConcept\accessionCode","commConcept\dba_src_ID","commConcept\commName","commConcept\referenceText","commConcept\scientific","commConcept\translated","commConcept\code","commConcept\originalAuthorCode","commConcept\common","commConcept\commLevel","commConcept\alliance","commConcept\includeInPicklistNow","commConcept\PhysGroup","commConcept\FormGroup","commConcept\EcolGroup","commConcept\4thApproxName","commConcept\NatureServeUID","commConcept\classificationSystem","commCorrelation","commCorrelation\COMMCORRELATION_ID","commCorrelation\COMMSTATUS_ID","commCorrelation\COMMCONCEPT_ID","commCorrelation\commConvergence","commCorrelation\correlationStart","commCorrelation\correlationStop","commCorrelation\dba_src_ID","commInterpretation","commInterpretation\COMMINTERPRETATION_ID","commInterpretation\COMMCLASS_ID","commInterpretation\COMMCONCEPT_ID","commInterpretation\commcode","commInterpretation\commname","commInterpretation\classFit","commInterpretation\classConfidence","commInterpretation\commAuthority_ID","commInterpretation\notes","commInterpretation\type","commInterpretation\nomenclaturalType","commInterpretation\dba_src_ID","commInterpretation\framework_id","commInterpretation\primaryDetermination","commInterpretation\primaryDeterminationStatus","commInterpretation\primaryComments","commInterpretation\primaryStartDate","commInterpretation\primarySTOPDate","commInterpretation\dba_interpretationStatus","commInterpretation\previousFit","commInterpretation\orderDeterminationForEvent","commInterpretation\duplicateDetermination","commLineage","commLineage\COMMLINEAGE_ID","commLineage\parentCommStatus_ID","commLineage\childCommStatus_ID","commLineage\dba_src_ID","commName","commName\COMMNAME_ID","commName\commName","commName\reference_ID","commName\dateEntered","commName\dba_src_ID","commStatus","commStatus\COMMSTATUS_ID","commStatus\COMMCONCEPT_ID","commStatus\reference_ID","commStatus\commConceptStatus","commStatus\commParent_ID","commStatus\commLevel","commStatus\startDate","commStatus\stopDate","commStatus\commPartyComments","commStatus\PARTY_ID","commStatus\dba_src_ID","commStatus\accessionCode","commUsage","commUsage\COMMUSAGE_ID","commUsage\COMMNAME_ID","commUsage\commName","commUsage\COMMCONCEPT_ID","commUsage\usageStart","commUsage\usageStop","commUsage\commNameStatus","commUsage\classSystem","commUsage\PARTY_ID","commUsage\COMMSTATUS_ID","commUsage\dba_src_ID","coverIndex","coverIndex\COVERINDEX_ID","coverIndex\COVERMETHOD_ID","coverIndex\coverCode","coverIndex\upperLimit","coverIndex\lowerLimit","coverIndex\coverPercent","coverIndex\indexDescription","coverIndex\dba_src_ID","coverMethod","coverMethod\COVERMETHOD_ID","coverMethod\reference_ID","coverMethod\coverType","coverMethod\coverEstimationMethod","coverMethod\accessionCode","coverMethod\dba_src_ID","cust_cvs_SoilDepth","cust_cvs_SoilDepth\DepthID","cust_cvs_SoilDepth\observation_ID","cust_cvs_SoilDepth\module","cust_cvs_SoilDepth\corner","cust_cvs_SoilDepth\depth","cvs_taxonAlt_translate","cvs_taxonAlt_translate\CVS_taxonAlt_ID","cvs_taxonAlt_translate\SppID","cvs_taxonAlt_translate\sciNAmeComplex","cvs_taxonAlt_translate\sciNAme","cvs_taxonAlt_translate\plantAccessionCode","definedValue","definedValue\DEFINEDVALUE_ID","definedValue\USERDEFINED_ID","definedValue\tableRecord_ID","definedValue\definedValue","definedValue\dba_src_ID","disturbanceObs","disturbanceObs\disturbanceObs_ID","disturbanceObs\OBSERVATION_ID","disturbanceObs\disturbanceType","disturbanceObs\disturbanceIntensity","disturbanceObs\disturbanceAge","disturbanceObs\disturbanceExtent","disturbanceObs\disturbanceComment","disturbanceObs\dba_src_ID","embargo","embargo\embargo_ID","embargo\plot_ID","embargo\embargoReason","embargo\embargoStart","embargo\embargoStop","embargo\defaultStatus","embargo\dba_src_ID","entry_CarSpList","entry_CarSpList\sppID","entry_CarSpList\FAMILY","entry_CarSpList\GENUS","entry_CarSpList\X","entry_CarSpList\SPECIES","entry_CarSpList\TRI","entry_CarSpList\TRI_NAME","entry_CarSpList\QUAD","entry_CarSpList\QUAD_NAME","entry_CarSpList\AUTHOR","entry_CarSpList\SCIENTIFIC_NAME_WITH_AUTHORS","entry_CarSpList\SCIENTIFIC_NAME","entry_CarSpList\NC_Std","entry_CarSpList\NC_CODE","entry_CarSpList\SynCode","entry_CarSpList\SynID","entry_CarSpList\reference_ID","entry_CarSpList\SOURCE","entry_CarSpList\party_ID","entry_CarSpList\perspectiveDate","entry_CarSpList\DUKE_CODE","entry_CarSpList\USDA_CODE","entry_CarSpList\US_Synonym","entry_CarSpList\US_COMMON_NAME","entry_CarSpList\bln_newRec","entry_CarSpList\plantConcept_ID","entry_CarSpList\plantAccessionCode","entry_CarSpList\plantGroupAccessionCodes","entry_CarSpList\includeInPicklistNow","entry_CarSpList\USDA_Woody","entry_CarSpList\Woody","entry_CarSpList\Duration","entry_CarSpList\US_Nativity","entry_CarSpList\GrowthForm_extended","entry_CarSpList\GrowthForm_short","entry_cover","entry_cover\HerbLineID","entry_cover\AlternateOrder","entry_cover\plotID","entry_cover\NC_Code","entry_cover\altReference_ID","entry_cover\unknownSp","entry_cover\CBS_1","entry_cover\CBS_2","entry_cover\CBS_3","entry_cover\CBS_4","entry_cover\CBS_5","entry_cover\CBS_6","entry_cover\CBS_7","entry_cover\CBS_8","entry_cover\CBS_9","entry_cover\CBS_10","entry_cover\CBS_11","entry_cover\CBS_12","entry_cover\col1","entry_cover\col2","entry_cover\col3","entry_cover\col4","entry_cover\col5","entry_cover\col6","entry_cover\col7","entry_cover\col8","entry_cover\col9","entry_cover\col10","entry_cover\col11","entry_cover\col12","entry_cover\col13","entry_cover\col14","entry_cover\col15","entry_cover\col16","entry_cover\col17","entry_cover\col18","entry_cover\col19","entry_cover\col20","entry_cover\avcov","entry_cover\notes","entry_cover\errors","entry_cover\NC_Code_History","entry_cover\duplicate","entry_cover\TreeFillin","entry_cover\userDefined1","entry_cover\userDefined2","entry_cover\userDefined3","entry_cover\userDefined4","entry_cover\userDefined5","entry_cover\userDefined6","entry_cover\userDefined7","entry_cover\userDefined8","entry_cover\userDefined9","entry_cover\userDefined10","entry_cover\userDefined11","entry_cover\userDefined12","entry_cover\userDefined13","entry_cover\userDefined14","entry_cover\userDefined15","entry_cover\userDefined16","entry_cover\log_createDate","entry_cover\log_createUser","entry_cover\log_modifiedDate","entry_cover\log_modifiedUser","entry_cover\collectionFlag","entry_plots_cover","entry_plots_cover\plotID","entry_plots_cover\project","entry_plots_cover\team","entry_plots_cover\plot","entry_plots_cover\cvs_level","entry_plots_cover\date","entry_plots_cover\depth","entry_plots_cover\Ares_H","entry_plots_cover\notesPlot","entry_plots_cover\str1","entry_plots_cover\str2","entry_plots_cover\str3","entry_plots_cover\str4","entry_plots_cover\str5","entry_plots_cover\str6","entry_plots_cover\str7","entry_plots_cover\str8","entry_plots_cover\str9","entry_plots_cover\str10","entry_plots_cover\str11","entry_plots_cover\str12","entry_plots_cover\head1","entry_plots_cover\head2","entry_plots_cover\head3","entry_plots_cover\head4","entry_plots_cover\head5","entry_plots_cover\head6","entry_plots_cover\head7","entry_plots_cover\head8","entry_plots_cover\head9","entry_plots_cover\head10","entry_plots_cover\head11","entry_plots_cover\head12","entry_plots_cover\head13","entry_plots_cover\head14","entry_plots_cover\head15","entry_plots_cover\head16","entry_plots_cover\head17","entry_plots_cover\head18","entry_plots_cover\head19","entry_plots_cover\head20","entry_plots_cover\headerrors","entry_plots_cover\plotSrc","entry_plots_cover\log_pcreateDate","entry_plots_cover\log_pcreateUser","entry_plots_cover\log_pmodifiedDate","entry_plots_cover\log_pmodifiedUser","entry_plots_cover\vmd_year","entry_plots_cover\cp_entry_plotDone","entry_plots_cover\cp_yearNum","entry_plots_cover\cp_authorObsCode","entry_plots_stems","entry_plots_stems\plotID","entry_plots_stems\project","entry_plots_stems\team","entry_plots_stems\plot","entry_plots_stems\cvs_level","entry_plots_stems\date","entry_plots_stems\Ares","entry_plots_stems\PlotSubSeedling","entry_plots_stems\PlotSubSapling","entry_plots_stems\PlotSubTree","entry_plots_stems\SubSamplingNarrative","entry_plots_stems\notesPlot","entry_plots_stems\notesPlot_indiv","entry_plots_stems\headerrors","entry_plots_stems\minimumDBH","entry_plots_stems\minimumdgh","entry_plots_stems\minimumHt","entry_plots_stems\AllStemsPlanted","entry_plots_stems\log_pcreateDate","entry_plots_stems\log_pcreateUser","entry_plots_stems\log_pmodifiedDate","entry_plots_stems\log_pmodifiedUser","entry_plots_stems\vmd_year","entry_plots_stems\cp_entry_plotDone","entry_plots_stems\cp_yearNum","entry_plots_stems\cp_authorObsCode","entry_plots_stems\plotXYReversedOrientation","entry_stems","entry_stems\TreeLineID","entry_stems\AlternateOrder","entry_stems\plotID","entry_stems\NC_Code","entry_stems\altReference_ID","entry_stems\unknownSp","entry_stems\Module","entry_stems\isPlanted","entry_stems\Subseedling","entry_stems\CHt_0_50","entry_stems\CHt_50_100","entry_stems\CHt_100_137","entry_stems\SubSapling","entry_stems\C0_1","entry_stems\C1_2","entry_stems\SubTree","entry_stems\C2Plus","entry_stems\C5Plus","entry_stems\C10Plus","entry_stems\C15Plus","entry_stems\C20Plus","entry_stems\C25Plus","entry_stems\C30Plus","entry_stems\C35Plus","entry_stems\BigStem1","entry_stems\BigStem2","entry_stems\BigStem3","entry_stems\BigStem4","entry_stems\BigStem5","entry_stems\BigStem6","entry_stems\BigStem7","entry_stems\BigStem8","entry_stems\BigStem9","entry_stems\BigStem10","entry_stems\BigStem11","entry_stems\BigStem12","entry_stems\Notes","entry_stems\errors","entry_stems\NC_Code_History","entry_stems\duplicate","entry_stems\TreeSummarySamplingCase","entry_stems\IsIndividualRecord","entry_stems\stemIDCode","entry_stems\stemSource","entry_stems\stemHealth","entry_stems\stemComment","entry_stems\stemX","entry_stems\stemY","entry_stems\dgh","entry_stems\Height","entry_stems\DBH","entry_stems\resprout","entry_stems\userDefined1","entry_stems\userDefined2","entry_stems\userDefined3","entry_stems\userDefined4","entry_stems\userDefined5","entry_stems\userDefined6","entry_stems\userDefined7","entry_stems\userDefined8","entry_stems\userDefined9","entry_stems\userDefined10","entry_stems\userDefined11","entry_stems\userDefined12","entry_stems\userDefined13","entry_stems\userDefined14","entry_stems\userDefined15","entry_stems\userDefined16","entry_stems\record_src","entry_stems\log_createDate","entry_stems\log_createUser","entry_stems\log_modifiedDate","entry_stems\log_modifiedUser","entry_stems\vmdMapSequence","entry_stems\vmd_recoverySortOrder","fieldList","fieldList\fieldList_ID","fieldList\tableName","fieldList\fieldName","fieldList\listValue","fieldList\valueDesc","fieldList\sortOrd","fieldList\entry_displayValue","fieldList\entry_description","fieldList\entry_hideValue","fieldList\entry_sortingOrder","fieldList\entry_newRecord","fieldList\entry_obsoleteValue","fieldList\entry_obsoleteUseInstead","graphic","graphic\GRAPHIC_ID","graphic\OBSERVATION_ID","graphic\graphicName","graphic\graphicLocation","graphic\graphicDescription","graphic\graphicType","graphic\graphicDate","graphic\graphicData","graphic\dba_src_ID","graphic\accessionCode","migrationEntity","migrationEntity\migrationEntity_ID","migrationEntity\migrationPkg_ID","migrationEntity\tableName","migrationEntity\record_ID","migrationEntity\sourceRecord_ID","migrationEntity\entryDBPath","migrationEntity\migrationDBPath","migrationPackage","migrationPackage\migrationPkg_ID","migrationPackage\migrationGUID","migrationPackage\migrationName","migrationPackage\migrationDescription","migrationPackage\userName","migrationPackage\archiveFullPath","migrationPackage\entryFullPath","migrationPackage\migrationDBFullPath","migrationPackage\migrationDateStart","migrationPackage\migrationDateEnd","migrationPackage\totalRecordsAdded","migrationPackage\plotsAdded","migrationPackage\observationsAdded","namedPlace","namedPlace\NAMEDPLACE_ID","namedPlace\placeSystem","namedPlace\placeName","namedPlace\placeDescription","namedPlace\placeCode","namedPlace\owner","namedPlace\reference_ID","namedPlace\accessionCode","namedPlace\dba_src_ID","namedPlaceCorrelation","namedPlaceCorrelation\NAMEDPLACECORRELATION_ID","namedPlaceCorrelation\PARENTPLACE_ID","namedPlaceCorrelation\CHILDPLACE_ID","namedPlaceCorrelation\placeConvergence","note","note\NOTE_ID","note\NOTELINK_ID","note\PARTY_ID","note\ROLE_ID","note\noteDate","note\noteType","note\noteText","note\dba_src_ID","note\accessionCode","noteLink","noteLink\NOTELINK_ID","noteLink\tableName","noteLink\attributeName","noteLink\tableRecord","noteLink\dba_src_ID","observation","observation\OBSERVATION_ID","observation\PREVIOUSOBS_ID","observation\PLOT_ID","observation\PROJECT_ID","observation\authorObsCode","observation\obsStartDate","observation\obsEndDate","observation\dateAccuracy","observation\dateEntered","observation\COVERMETHOD_ID","observation\coverDispersion","observation\autoTaxonCover","observation\STRATUMMETHOD_ID","observation\methodNarrative","observation\taxonObservationArea","observation\stemSizeLimit","observation\stemObservationArea","observation\stemSampleMethod","observation\originalData","observation\effortLevel","observation\plotValidationLevel","observation\floristicQuality","observation\bryophyteQuality","observation\lichenQuality","observation\observationNarrative","observation\landscapeNarrative","observation\homogeneity","observation\phenologicAspect","observation\representativeness","observation\standMaturity","observation\successionalStatus","observation\basalArea","observation\hydrologicRegime","observation\soilMoistureRegime","observation\soilDrainage","observation\waterSalinity","observation\waterDepth","observation\shoreDistance","observation\soilDepth","observation\organicDepth","observation\SOILTAXON_ID","observation\soilTaxonSrc","observation\soilTaxonComplex","observation\soilMapUnit","observation\percentBedRock","observation\percentRockGravel","observation\percentWood","observation\percentLitter","observation\percentBareSoil","observation\percentWater","observation\percentOther","observation\nameOther","observation\treeHt","observation\shrubHt","observation\fieldHt","observation\nonvascularHt","observation\submergedHt","observation\treeCover","observation\shrubCover","observation\fieldCover","observation\nonvascularCover","observation\floatingCover","observation\submergedCover","observation\dominantStratum","observation\growthform1Type","observation\growthform2Type","observation\growthform3Type","observation\growthform1Cover","observation\growthform2Cover","observation\growthform3Cover","observation\totalCover","observation\accessionCode","observation\notesPublic","observation\notesMgt","observation\revisions","observation\cust_cvs_CowardinSystem","observation\cust_cvs_mcnab_LFI_asp","observation\cust_cvs_mcnab_LFI_45","observation\cust_cvs_mcnab_LFI_90","observation\cust_cvs_mcnab_LFI_135","observation\cust_cvs_mcnab_LFI_180","observation\cust_cvs_mcnab_LFI_225","observation\cust_cvs_mcnab_LFI_270","observation\cust_cvs_mcnab_LFI_315","observation\cust_cvs_mcnab_TSI_asp","observation\cust_cvs_mcnab_TSI_45","observation\cust_cvs_mcnab_TSI_90","observation\cust_cvs_mcnab_TSI_135","observation\cust_cvs_mcnab_TSI_180","observation\cust_cvs_mcnab_TSI_225","observation\cust_cvs_mcnab_TSI_270","observation\cust_cvs_mcnab_TSI_315","observation\cust_cvs_mcnab_LFI","observation\cust_cvs_mcnab_TSI","observation\cust_cvs_LeafType","observation\cust_cvs_LeafPhenology","observation\cust_cvs_CanopyHeight","observation\cust_cvs_compassType","observation\cust_cvs_LocationSource","observation\cust_cvs_GPSLocationX","observation\cust_cvs_GPSLocationY","observation\cust_cvs_Ownership","observation\cust_cvs_taxaRichness","observation\cust_cvs_lengthSoilProbe","observation\cust_cvs_percentHistosol","observation\cust_cvs_percentBedrock","observation\cust_cvs_percentBoulder","observation\cust_cvs_percentGravelCobble","observation\cust_cvs_percentMineralSoil","observation\cust_cvs_percentCWD","observation\cust_cvs_percentFWD","observation\cust_cvs_percentDuff","observation\cust_cvs_percentLitter","observation\cust_cvs_percentNonVasc","observation\cust_cvs_percentWater","observation\cust_cvs_percentOther","observation\cust_cvs_percentOtherName","observation\cust_cvs_samplingLevel","observation\cust_cvs_postDsgPoly","observation\cust_cvs_stemsSampled","observation\cust_cvs_stemSamplingNarrative","observation\cust_eep_plotLastPlantedDate","observation\cust_eep_plotNotSampled","observation\cust_eep_plotNotSampledReason","observation\entry_ares_herbs","observation\entry_ares_trees","observation\entry_currentLandUse","observation\entry_depth","observation\entry_elevationUnits","observation\entry_formerLandUse","observation\entry_identificationNarrative","observation\entry_IntensiveModuleList","observation\entry_moduleSize_Overall","observation\entry_moduleSizeX","observation\entry_moduleSizeY","observation\entry_photosTaken","observation\entry_physClass","observation\entry_plot_X","observation\entry_plot_Y","observation\entry_soilModulesSampled","observation\entry_subsequentObsNum","observation\entry_taxonomicAuthority_ID","observation\entry_taxonomicAuthorityDate","observation\entry_team","observation\entry_plot","observation\entry_numberOfModules","observation\errors","observation\dba_src_ID","observation\dba_notes","observation\numberOfTaxa","observationContributor","observationContributor\OBSERVATIONCONTRIBUTOR_ID","observationContributor\OBSERVATION_ID","observationContributor\PARTY_ID","observationContributor\ROLE_ID","observationContributor\contributionDate","observationContributor\dba_src_ID","observationContributor\unsure","observationSynonym","observationSynonym\OBSERVATIONSYNONYM_ID","observationSynonym\synonymObservation_ID","observationSynonym\primaryObservation_ID","observationSynonym\PARTY_ID","observationSynonym\ROLE_ID","observationSynonym\classStartDate","observationSynonym\classStopDate","observationSynonym\synonymComment","observationSynonym\dba_src_ID","observationSynonym\accessionCode","party","party\PARTY_ID","party\salutation","party\givenName","party\middleName","party\surName","party\suffix","party\entry_userInitials","party\organizationName","party\currentName_ID","party\contactInstructions","party\email","party\accessionCode","party\partyType","party\dba_src_ID","party\dba_unsure","partyMember","partyMember\partyMember_ID","partyMember\parentParty_ID","partyMember\childParty_ID","partyMember\role_ID","partyMember\memberStart","partyMember\memberStop","partyMember\dba_src_ID","place","place\PLOTPLACE_ID","place\PLOT_ID","place\calculated","place\NAMEDPLACE_ID","place\dba_src_ID","plantConcept","plantConcept\PLANTCONCEPT_ID","plantConcept\PLANTNAME_ID","plantConcept\reference_ID","plantConcept\plantname","plantConcept\plantNameWithAuthority","plantConcept\plantCode","plantConcept\plantDescription","plantConcept\accessionCode","plantConcept\dba_src_ID","plantConcept\entry_sppID","plantConcept\USDAPlantsCode","plantConcept\VascularPlant","plantConcept\denorm_kingdom","plantConcept\denorm_division","plantConcept\denorm_category","plantConcept\denorm_family","plantConcept\denorm_genus","plantConcept\denorm_species","plantConcept\denorm_triAbbr","plantConcept\denorm_triName","plantConcept\denorm_quadAbbr","plantConcept\denorm_quadName","plantConcept\denorm_hybridX","plantConcept\taxonLevel","plantConcept\taxonRank","plantConcept\lowestParentName","plantConcept\lowestParentConcept_ID","plantConcept\lowestChildRank","plantConcept\commonName","plantConcept\growthForm_short","plantConcept\woody","plantConcept\exotic","plantConcept\usda_code","plantConcept\usda_growthForm","plantConcept\sensitiveSpeciesFuzzPlot","plantCorrelation","plantCorrelation\PLANTCORRELATION_ID","plantCorrelation\PLANTSTATUS_ID","plantCorrelation\PLANTCONCEPT_ID","plantCorrelation\plantConvergence","plantCorrelation\correlationStart","plantCorrelation\correlationStop","plantCorrelation\dba_src_ID","plantLineage","plantLineage\PLANTLINEAGE_ID","plantLineage\childPlantStatus_ID","plantLineage\parentPlantStatus_ID","plantLineage\dba_src_ID","plantName","plantName\PLANTNAME_ID","plantName\plantName","plantName\reference_ID","plantName\dateEntered","plantName\dba_src_ID","plantStatus","plantStatus\PLANTSTATUS_ID","plantStatus\PLANTCONCEPT_ID","plantStatus\reference_ID","plantStatus\plantConceptStatus","plantStatus\startDate","plantStatus\stopDate","plantStatus\plantPartyComments","plantStatus\plantParentName","plantStatus\plantParentConcept_id","plantStatus\plantParent_ID","plantStatus\plantLevel","plantStatus\PARTY_ID","plantStatus\dba_src_ID","plantStatus\denorm_FamilyName","plantStatus\accessionCode","plantUsage","plantUsage\PLANTUSAGE_ID","plantUsage\PLANTNAME_ID","plantUsage\PLANTCONCEPT_ID","plantUsage\usageStart","plantUsage\usageStop","plantUsage\plantNameStatus","plantUsage\plantName","plantUsage\classSystem","plantUsage\acceptedSynonym","plantUsage\PARTY_ID","plantUsage\PLANTSTATUS_ID","plantUsage\dba_src_ID","plot","plot\PLOT_ID","plot\authorPlotCode","plot\reference_ID","plot\PARENT_ID","plot\plotObsolete","plot\REPLACEMENTPLOT_ID","plot\realLatitude","plot\realLongitude","plot\locationAccuracy","plot\confidentialityStatus","plot\confidentialityFieldsBlocked","plot\confidentialityReason","plot\latitude","plot\longitude","plot\authorCoordinateType","plot\authorCoordinateUnits","plot\authorE","plot\authorN","plot\authorZone","plot\authorDatum","plot\authorLocation","plot\locationNarrative","plot\plotRationaleNarrative","plot\azimuth","plot\dsgpoly","plot\shape","plot\area","plot\standSize","plot\placementMethod","plot\permanence","plot\layoutNarrative","plot\elevation","plot\elevationAccuracy","plot\elevationRange","plot\slopeAspect","plot\minSlopeAspect","plot\maxSlopeAspect","plot\slopeGradient","plot\minSlopeGradient","plot\maxSlopeGradient","plot\topoPosition","plot\landform","plot\surficialDeposits","plot\rockType","plot\county","plot\cust_cvs_province","plot\stateProvince","plot\COUNTRY","plot\dateentered","plot\submitter_surname","plot\submitter_givenname","plot\submitter_email","plot\accessionCode","plot\notesPublic","plot\notesMgt","plot\revisions","plot\cust_eep_reach","plot\dba_src_ID","project","project\PROJECT_ID","project\projectName","project\projectDescription","project\startDate","project\stopDate","project\accessionCode","project\dba_src_ID","project\entry_projectCode","project\entry_projectCodeSource","project\entry_contactDetails","project\entry_eep_length","project\entry_eep_width","project\entry_eep_area","project\entry_eep_requiredPlots","project\entry_eep_projectType","project\entry_riverBasin_np_ID","projectContributor","projectContributor\PROJECTCONTRIBUTOR_ID","projectContributor\PROJECT_ID","projectContributor\PARTY_ID","projectContributor\ROLE_ID","projectContributor\surname","projectContributor\cheatRole","projectContributor\dba_src_ID","reference","reference\reference_ID","reference\shortName","reference\fulltext","reference\referenceType","reference\title","reference\titleSuperior","reference\pubDate","reference\pubYear","reference\pubMonth","reference\pubDay","reference\accessDate","reference\conferenceDate","reference\referenceJournal_ID","reference\volume","reference\issue","reference\pageRange","reference\totalPages","reference\publisher","reference\publicationPlace","reference\isbn","reference\edition","reference\numberOfVolumes","reference\chapterNumber","reference\reportNumber","reference\communicationType","reference\degree","reference\url","reference\doi","reference\additionalInfo","reference\accessionCode","reference\dba_src_ID","reference\cust_cvs_IsTaxonomicManual","reference\cust_cvs_unparsedAuthors","reference\cust_cvs_referenceJournalName","referenceAltIdent","referenceAltIdent\referenceAltIdent_ID","referenceAltIdent\reference_ID","referenceAltIdent\system","referenceAltIdent\identifier","referenceAltIdent\dba_src_ID","referenceContributor","referenceContributor\referenceContributor_ID","referenceContributor\reference_ID","referenceContributor\referenceParty_ID","referenceContributor\roleType","referenceContributor\position","referenceContributor\dba_src_ID","referenceJournal","referenceJournal\referenceJournal_ID","referenceJournal\journal","referenceJournal\issn","referenceJournal\abbreviation","referenceJournal\accessionCode","referenceJournal\dba_src_ID","referenceParty","referenceParty\referenceParty_ID","referenceParty\type","referenceParty\positionName","referenceParty\salutation","referenceParty\givenName","referenceParty\surname","referenceParty\suffix","referenceParty\organizationName","referenceParty\currentParty_ID","referenceParty\accessionCode","referenceParty\dba_src_ID","soilObs","soilObs\SOILOBS_ID","soilObs\OBSERVATION_ID","soilObs\soilHorizon","soilObs\soilDepthTop","soilObs\soilDepthBottom","soilObs\soilColor","soilObs\soilOrganic","soilObs\soilTexture","soilObs\soilSand","soilObs\soilSilt","soilObs\soilClay","soilObs\soilCoarse","soilObs\soilPH","soilObs\exchangeCapacity","soilObs\baseSaturation","soilObs\soilDescription","soilObs\cust_cvs_collectionName","soilObs\cust_cvs_Lab","soilObs\cust_cvs_N","soilObs\cust_cvs_S","soilObs\cust_cvs_P","soilObs\cust_cvs_Ca_ppm","soilObs\cust_cvs_Mg_ppm","soilObs\cust_cvs_K_ppm","soilObs\cust_cvs_Na_ppm","soilObs\cust_cvs_percent_Ca","soilObs\cust_cvs_percent_Mg","soilObs\cust_cvs_percent_K","soilObs\cust_cvs_percent_Na","soilObs\cust_cvs_percent_Othr","soilObs\cust_cvs_percent_H","soilObs\cust_cvs_B_ppm","soilObs\cust_cvs_Fe_ppm","soilObs\cust_cvs_Mn_ppm","soilObs\cust_cvs_Cu_ppm","soilObs\cust_cvs_Zn_ppm","soilObs\cust_cvs_Al_ppm","soilObs\cust_cvs_Density","soilObs\cust_cvs_Ca_over_Mg_ppm","soilObs\dba_src_ID","soilTaxon","soilTaxon\SOILTAXON_ID","soilTaxon\soilCode","soilTaxon\soilName","soilTaxon\soilLevel","soilTaxon\SOILPARENT_ID","soilTaxon\soilFramework","soilTaxon\accessionCode","soilTaxon\dba_src_ID","stemCount","stemCount\STEMCOUNT_ID","stemCount\TAXONIMPORTANCE_ID","stemCount\stemDiameter","stemCount\stemDiameterAccuracy","stemCount\stemHeight","stemCount\stemHeightAccuracy","stemCount\stemCount","stemCount\stemTaxonArea","stemCount\dba_src_ID","stemCount\cust_cvs_ddh","stemCount\cust_cvs_ddhAccuracy","stemCount\cust_cvs_isPlanted","stemCount\cust_cvs_subsamplingFactor","stemCount\entry_herbLineID","stemCount\entry_treeLineID","stemCount\entry_recordCount","stemCount\entry_sortOrder","stemLocation","stemLocation\STEMLOCATION_ID","stemLocation\STEMCOUNT_ID","stemLocation\stemCode","stemLocation\stemXPosition","stemLocation\stemYPosition","stemLocation\stemHealth","stemLocation\dba_src_ID","stemLocation\cust_cvs_stemSource","stemLocation\cust_cvs_stemComment","stemLocation\cust_cvs_resprout","stemLocation\entry_sortOrder","stratum","stratum\STRATUM_ID","stratum\OBSERVATION_ID","stratum\STRATUMTYPE_ID","stratum\STRATUMMETHOD_ID","stratum\stratumName","stratum\stratumHeight","stratum\stratumBase","stratum\stratumCover","stratum\stratumDescription","stratum\dba_src_ID","stratum\stratumArea","stratum\stratumLabel","stratumMethod","stratumMethod\STRATUMMETHOD_ID","stratumMethod\reference_ID","stratumMethod\stratumMethodName","stratumMethod\stratumMethodDescription","stratumMethod\stratumAssignment","stratumMethod\accessionCode","stratumMethod\dba_src_ID","stratumType","stratumType\STRATUMTYPE_ID","stratumType\STRATUMMETHOD_ID","stratumType\stratumIndex","stratumType\stratumName","stratumType\stratumDescription","stratumType\dba_src_ID","stratumType\stratumOrder","taxonAlt","taxonAlt\taxonAlt_ID","taxonAlt\taxonInterpretation_ID","taxonAlt\plantConcept_ID","taxonAlt\taxonAltFit","taxonAlt\taxonAltConfidence","taxonAlt\taxonAltNotes","taxonAlt\dba_src_ID","taxonImportance","taxonImportance\taxonImportance_ID","taxonImportance\taxonObservation_ID","taxonImportance\stratum_ID","taxonImportance\cover","taxonImportance\basalArea","taxonImportance\biomass","taxonImportance\inferenceArea","taxonImportance\cust_cvs_StemFrequency","taxonImportance\dba_src_ID","taxonImportance\entry_herbLineID","taxonImportance\entry_treeLineID","taxonImportance\cust_cvs_corner1Presence","taxonImportance\cust_cvs_corner2Presence","taxonImportance\cust_cvs_corner3Presence","taxonImportance\cust_cvs_corner4Presence","taxonImportance\cust_cvs_corner5Presence","taxonImportance\cust_cvs_originalCoverCode","taxonInterpretation","taxonInterpretation\TAXONINTERPRETATION_ID","taxonInterpretation\TAXONOBSERVATION_ID","taxonInterpretation\stemLocation_ID","taxonInterpretation\PLANTCONCEPT_ID","taxonInterpretation\interpretationDate","taxonInterpretation\PLANTNAME_ID","taxonInterpretation\PARTY_ID","taxonInterpretation\ROLE_ID","taxonInterpretation\interpretationType","taxonInterpretation\reference_ID","taxonInterpretation\originalInterpretation","taxonInterpretation\currentInterpretation","taxonInterpretation\taxonFit","taxonInterpretation\taxonConfidence","taxonInterpretation\collector_ID","taxonInterpretation\collectionNumber","taxonInterpretation\collectionDate","taxonInterpretation\museum_ID","taxonInterpretation\museumAccessionNumber","taxonInterpretation\groupType","taxonInterpretation\notes","taxonInterpretation\notesPublic","taxonInterpretation\notesMgt","taxonInterpretation\revisions","taxonInterpretation\dba_src_ID","taxonInterpretation\accessionCode","taxonObservation","taxonObservation\TAXONOBSERVATION_ID","taxonObservation\OBSERVATION_ID","taxonObservation\authorPlantName","taxonObservation\reference_ID","taxonObservation\currentTaxonInterpPlantConcept_ID","taxonObservation\taxonInferenceArea","taxonObservation\accessionCode","taxonObservation\dba_src_ID","taxonObservation\cust_cvs_corner1Presence","taxonObservation\cust_cvs_corner2Presence","taxonObservation\cust_cvs_corner3Presence","taxonObservation\cust_cvs_corner4Presence","taxonObservation\cust_cvs_corner5Presence","taxonObservation\entry_herbLineID","taxonObservation\entry_treeLineID","taxonObservation\entry_sppID","taxonObservation\entry_unknownSp","taxonObservation\entry_sortOrder","taxonObservation\cust_cvs_collectionFlag","taxonObservation\taxonObservationNotes","taxonObservation\temp_taxonUpToDate","telephone","telephone\TELEPHONE_ID","telephone\PARTY_ID","telephone\phoneNumber","telephone\phoneType","telephone\dba_src_ID","temp_cvs_taxonAlt_translate1","temp_cvs_taxonAlt_translate1\CVS_taxonAlt_ID","temp_cvs_taxonAlt_translate1\SppID","temp_cvs_taxonAlt_translate1\sciNAmeComplex","temp_cvs_taxonAlt_translate1\sciNAme","temp_cvs_taxonAlt_translate1\plantAccessionCode","translateValues","translateValues\translateID","translateValues\table","translateValues\field","translateValues\oldFieldVAlue","translateValues\newFieldVAlue","userDataset","userDataset\userDataset_ID","userDataset\usr_ID","userDataset\datasetStart","userDataset\datasetStop","userDataset\accessionCode","userDataset\datasetName","userDataset\datasetDescription","userDataset\datasetType","userDataset\datasetSharing","userDataset\datasetPassword","userDatasetItem","userDatasetItem\userDatasetItem_ID","userDatasetItem\userDataset_ID","userDatasetItem\itemAccessionCode","userDatasetItem\itemType","userDatasetItem\itemStart","userDatasetItem\itemStop","userDatasetItem\notes","userDefined","userDefined\USERDEFINED_ID","userDefined\userDefinedName","userDefined\userDefinedMetadata","userDefined\userDefinedCategory","userDefined\userDefinedType","userDefined\tableName","userDefined\accessionCode","userDefined\dba_src_ID","usr","usr\usr_ID","usr\party_ID","usr\password","usr\permission_type","usr\begin_time","usr\last_connect","usr\ticket_count","usr\email_address","usr\preferred_name","usr\remote_address","versionLog","versionLog\versionLog_ID","versionLog\versionNumber","versionLog\versionDate","versionLog\versionDescription","versionLog\databaseType","versionLog\databaseDomain","versionLog\recordCreated","Z_backend_TableDescription","Z_backend_TableDescription\Z_backend_tbl_descID","Z_backend_TableDescription\tableName","Z_backend_TableDescription\tableModule","Z_backend_TableDescription\actualTableName","Z_backend_TableDescription\entryTableName","Z_backend_TableDescription\importOrder","Z_backend_TableDescription\Client","Z_backend_TableDescription\Backend","Z_backend_TableDescription\Temp","Z_backend_TableDescription\Archive","Z_backend_TableDescription\countRecords","Z_backend_TableDescription\countNewRecords","Z_FieldDescription","Z_FieldDescription\Z_field_ID","Z_FieldDescription\TableName","Z_FieldDescription\FieldName","Z_FieldDescription\FieldLabel","Z_FieldDescription\key","Z_FieldDescription\references","Z_FieldDescription\FieldDefinition","Z_FieldDescription\altHelpDefinition","Z_FieldDescription\nonNullRecs","Z_FieldDescription\dataEntryImpl","Z_FieldDescription\fieldType","Z_FieldDescription\fieldLength","Z_FieldDescription\fieldModule","Z_FieldDescription\archiveField","Z_FieldDescription\countNonNulls","zvegbank_version","zvegbank_version\verID","zvegbank_version\versionNumber","zvegbank_version\versionDate","zvegbank_version\versionDescription","zvegbank_version\databaseType","zvegbank_version\databaseDomain"
15
  dropdatabase=0
16
  createtables=0
17
  unicode=1
18
  autocommit=1
19
  transferdefaultvalues=1
20
  transferindexes=0
21
  transferautonumbers=1
22
  transferrecords=1
23
  columnlist=0
(6-6/9)