Skip to content

NaturalHistoryMuseum/data-importer

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ke2sql

Import KE EMu data into SQL.

/usr/lib/ke2sql/bin/python commands/run_one.py --local-scheduler

copy (select "gbifID" AS "ID","gbifOccurrenceID" AS "occurrenceID", "gbifLastInterpreted" AS "lastInterpreted","gbifLastParsed" AS "lastParsed","gbifIssue" AS "issue","gbifKingdom" AS "kingdom","gbifKingdomKey" AS "kingdomKey","gbifPhylum" AS "phylum","gbifPhylumKey" AS "phylumKey","gbifClass" AS "class","gbifClassKey" AS "classKey","gbifOrder" AS "order","gbifOrderKey" AS "orderKey","gbifFamily" AS "family","gbifFamilyKey" AS "familyKey","gbifGenus" AS "genus","gbifGenusKey" AS "genusKey","gbifSubgenus" AS "subGenus","gbifSubgenusKey" AS "subGenusKey","gbifSpecies" AS "species","gbifSpeciesKey" AS "speciesKey","gbifTaxonRank" AS "taxonRank","gbifIdentifiedBy" AS "identifiedBy","gbifScientificName" AS "scientificName","gbifTaxonKey" AS "taxonKey","gbifRecordedBy" AS "recordedBy","gbifEventDate" AS "eventDate","gbifRecordNumber" AS "recordNumber","gbifContinent" AS "continent","gbifCountry" AS "country","gbifStateProvince" AS "stateProvince","gbifHabitat" AS "habitat","gbifCountryCode" AS "countryCode","gbifIslandGroup" AS "islandGroup","gbifDecimalLongitude" AS "decimalLongitude","gbifDecimalLatitude" AS "decimalLatitude" from gbif.occurrence) to '/usr/lib/ke2sql/src/data-importer/data_importer/data/gbif.csv' with CSV HEADER;

About

Import KE EMu data into SQL

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •  

Languages