Commits

Breadcrumbs

History for

onexplorerFixes

User selector

All users

All time

Commit History

Commits on Dec 17, 2020

• Merge branch 'master' into explorerFixes

  SimonGoring

  committed
  f61b123

  Copy full SHA for f61b123

• Changed field name in `doifreeze` to record, added helper table function

  Show description for 1abef78
  SimonGoring

  committed
  1abef78

  Copy full SHA for 1abef78

• Merge branch 'master' of github.com:NeotomaDB/Neotoma_SQL

  SimonGoring

  committed
  c829a6d

  Copy full SHA for c829a6d

• Simple gettoptaxa.

  SimonGoring

  committed
  10c1c19

  Copy full SHA for 10c1c19

• update explorer search query [time]

  Show description for eb177b5
  jknelsonPSU

  authored
  eb177b5

  Copy full SHA for eb177b5

Commits on Dec 10, 2020

• Update explorersearch.sql

  Show description for e0775a1
  jknelsonPSU

  authored
  e0775a1

  Copy full SHA for e0775a1

Commits on Dec 7, 2020

• Adding toptaxon search

  Show description for ad483d0
  SimonGoring

  committed
  ad483d0

  Copy full SHA for ad483d0

Commits on Dec 2, 2020

• Merge branch 'master' of github.com:NeotomaDB/Neotoma_SQL

  SimonGoring

  committed
  e5f10a2

  Copy full SHA for e5f10a2

Commits on Nov 23, 2020

• make chronid variable dynamic

  

  Jonathan K Nelson

  authored and

  Jonathan K Nelson

  committed
  2ea4742

  Copy full SHA for 2ea4742

Commits on Nov 13, 2020

• Moved the trigger function `site_bounding` to a file in the `ti` folder

  Show description for d02c51d
  SimonGoring

  committed
  d02c51d

  Copy full SHA for d02c51d

Commits on Nov 12, 2020

• Adding a trigger to get missing latitude and longitude fields filled.

  Show description for 4ded3bc
  SimonGoring

  committed
  4ded3bc

  Copy full SHA for 4ded3bc

Commits on Oct 29, 2020

• `ti.getanalysisunitbyid` fix applied. Returns double precision.

  Show description for 1470395
  SimonGoring

  committed
  1470395

  Copy full SHA for 1470395

• Changed the date format for the recent uploads.

  Show description for b638b96
  SimonGoring

  committed
  b638b96

  Copy full SHA for b638b96

Commits on Oct 24, 2020

• Straightforward `ts` functions for chroncontrols.

  SimonGoring

  committed
  25ac8bc

  Copy full SHA for 25ac8bc

• Added an index to support the upsert in chroncontrolevents.

  Show description for dfbbb48
  SimonGoring

  committed
  dfbbb48

  Copy full SHA for dfbbb48

Commits on Oct 23, 2020

• update chron control age basis.

  Show description for 8d813f2
  SimonGoring

  committed
  8d813f2

  Copy full SHA for 8d813f2

• Updating the data variables and re-formatting explorer search.

  SimonGoring

  committed
  0c537db

  Copy full SHA for 0c537db

Commits on Sep 28, 2020

• Removing `stewardupdates` from the repository.

  SimonGoring

  committed
  88a6501

  Copy full SHA for 88a6501

• Updating the sequencing data and removing steward table updates.

  SimonGoring

  committed
  befa88b

  Copy full SHA for befa88b

Commits on Sep 17, 2020

• Updating lakeparam and chronbyid.

  SimonGoring

  committed
  8d8d2e1

  Copy full SHA for 8d8d2e1

• Oops, fixing updatesitegeopolinsert.

  SimonGoring

  committed
  7097696

  Copy full SHA for 7097696

• Removed references to the steward updates. Functions should work now.

  SimonGoring

  committed
  17e1b37

  Copy full SHA for 17e1b37

Commits on Sep 16, 2020

• Using distinct in the json_agg works only with a jsonb object.

  SimonGoring

  committed
  4bd0ead

  Copy full SHA for 4bd0ead

• For geopaths added grant permissions and madesure duplicate adds don't happen.

  SimonGoring

  committed
  36a7fab

  Copy full SHA for 36a7fab

• Oops, this is the chonology by id function :)

  SimonGoring

  committed
  edf505f

  Copy full SHA for edf505f

• Added the function for the ndb.geopaths.

  Show description for 2d0f448
  SimonGoring

  committed
  2d0f448

  Copy full SHA for 2d0f448

Commits on Sep 8, 2020

• Fixing chronologybyid for Explorer.

  SimonGoring

  committed
  483ea7e

  Copy full SHA for 483ea7e

Commits on Aug 11, 2020

• Some function cleanup.

  SimonGoring

  committed
  fe4bffa

  Copy full SHA for fe4bffa

• Updated indexes. Implemented on `neotomatilia`.

  Show description for c9d817d
  SimonGoring

  committed
  c9d817d

  Copy full SHA for c9d817d

• Moved indexes out of the root folder and into a folder in `function`.

  Show description for c53bbf3
  SimonGoring

  committed
  c53bbf3

  Copy full SHA for c53bbf3

Commits on Aug 7, 2020

• Updated specimen date id in ti.insertspecimendatecal

  SimonGoring

  committed
  3311272

  Copy full SHA for 3311272

Commits on Jul 13, 2020

• A set of smaller updates to help fix things.

  Show description for e05a1f1
  SimonGoring

  committed
  e05a1f1

  Copy full SHA for e05a1f1

• Updated `getsites` to deal with geography data.

  SimonGoring

  committed
  faec20e

  Copy full SHA for faec20e

Commits on Jul 10, 2020

• Grouped and tested highest taxon.\nSingle query fix for get pollen spore higher taxa.

  SimonGoring

  committed
  ed3269a

  Copy full SHA for ed3269a

Commits on Jun 24, 2020

• Insert aggregate geochron now has the proper defaults.

  SimonGoring

  committed
  fb9e474

  Copy full SHA for fb9e474