You are not logged in. Click here to log in.

Application Lifecycle Management
Login
 Projects
 Reports
 Wiki
 Documents
 Trackers
 SCM Repositories
Last ModifiedRecently Visited Items
Search In Project
Search inClear
anonymous
 csip-crdb #27092
csip-crdb Mercurial repository by casesp
This repository contains update SQL scripts for the CRdb data mart used by USDA in conjunction with CSIP services. Each new update file added to this repository should represent either a portion of a new version of CRdb or an entire CRdb new version. The CRdb data mart acquired a new requirement to maintain its versioning history the first week of February 2017 in order to comply with security review requirements imposed on USDA by OCIO and its IT components.
Clone:
https://alm.engr.colostate.edu/cb/hg/csip-crdb
Last push: Dec 08 2023 13:26
Push:
https://alm.engr.colostate.edu/cb/hg/csip-crdb
Size: 2.1 GB
Forks: 0 Pull requests: 0 pending
Forks
Changes
Files
Pull Requests
Branches & Tags
Statistics

Author Comment Items
casesp
Dec 08 2023 13:26 
Update:  #114921 Correct dec values and add start dates.
365d6e14f889c1b91fa1fc314326561c9294868f branches: tip , default
CRQ-114921
casesp
Dec 08 2023 09:33 
Update:  #114862 Adding data for new locations.
c815c8d6a2d9070c2a9094c54311212027ed17e3 branches: tip , default
CRQ-114862
casesp
Oct 09 2023 16:45 
Update:  Suffolk County updates from April of 2023, already in database.
3dc4bc9fc02de972a25f26d31b1110d636a909cb branches: tip , default
--
casesp
Oct 09 2023 16:41 
Update:  #112435  Updating animal_class table
026aef7d09eaa0b0d441d17cae2fc7cf4ef01c52 branches: tip , default
CRQ-112435
casesp
Feb 24 2023 13:50 
--  GRAS Tracker #106468.  Update Remove animal_class_id=15, and update animal_kind_id=4 pct value from 3.0 to 3.5
9047f170bc341399cc54c5517cd544efac7a4855 branches: tip , default
  • modified
    Distribution/gras schema/gras.tracker.106468.sql
CRQ-106468
casesp
Feb 24 2023 13:40 
--  Update.  Remove animal_class_id=15, and update animal_kind_id=1 pct value from 3.0 to 3.5
b844cb934eae6d7cf613ad9245e85892bd599b56 branches: tip , default
  • modified
    Distribution/gras schema/gras.tracker.106468.sql
--
casesp
Feb 24 2023 12:38 
--  GRAS Tracker #106468.  Remove old animal tables and create new ones, with new data
c00ef233f3fc2caa5692837af6fe854ed4dc8f69 branches: tip , default
CRQ-106468
casesp
Nov 16 2022 09:20 
Update:  #104100  Set correct LRR's as already modeled.
688ab64af5b805dbcc1c9ac1047ea6e99ec889ad branches: tip , default
  • modified
    Distribution/common schema/whole_lrr_v42.sql
CRQ-104100
casesp
Nov 16 2022 09:16 
Update:  #104100  (mlra_v42 table already existed, but was not in the repo.  Adding to repo.)
Added two new tables for use in surrogate modeling, but can also be useful to other applications needing information about MLRA boundaries and LRR boundaries and associated data.
e17290447f18f01464cf50145fa1874119719df9 branches: tip , default
CRQ-104100
casesp
Nov 16 2022 09:13 
Update:  #104100  Added two new tables for use in surrogate modeling, but can also be useful to other applications needing information about MLRA boundaries and LRR boundaries and associated data.
2b1428fc4221642250007ff3272b2e69dffe7a8b branches: tip , default
CRQ-104100
casesp
Nov 16 2022 08:50 
Update:  #104100  Added two new tables for use in surrogate modeling, but can also be useful to other applications needing information about MLRA boundaries and LRR boundaries and associated data.
b8068076c37091c1bce58b9979327afd4a461e04 branches: tip , default
CRQ-104100
casesp
Nov 04 2022 10:58 
Update:  #103635  Allowing NULLs in the bit value.
021f8d053189a5e9f4b9d3f13d7a0345b4d0df58 branches: tip , default
CRQ-103635
casesp
Oct 26 2022 12:45 
Update:  #103179 Tables have been updated and new data inserted.
497b77470a540f3f0d7d1aaff72aef751c5bec83 branches: tip , default
CRQ-103179
casesp
Oct 26 2022 10:39 
Update:  #102738 Changed columns to all be "NOT NULL".  Each field should always have a value.
550c1768d52b1e0558780b7bf557305612f9afe9 branches: tip , default
CRQ-102738
casesp
Oct 24 2022 14:31 
Update:  #102738  Added column to rhem.soil_texture_table and imported new data.
e39042b7bb823529259eaf9503d859176b0093a3 branches: tip , default
CRQ-102738
casesp
Sep 14 2022 08:47 
--  Update: #101454  Second update script for this tracker.  Both are needed.
b0c8b131a3dc6ae9df8446824e3656ab1d0cf5d5 branches: tip , default
CRQ-101454
casesp
Sep 12 2022 14:02 
--   Update:  #101452 Removed ESD Tables and Schema.
902bee999a02795c7226c5d2035336c6b0411846 branches: tip , default
CRQ-101452
casesp
Sep 12 2022 13:36 
--  Update: #101453 Removed unused tables.
fb34cc03a177a47c7e64e815c2dd3e852152a65f branches: tip , default
CRQ-101453
casesp
Sep 12 2022 13:19 
--  Update:  Removed testing/QA values.
033404e44fbca73f22545c0811eb5a8f50338e9a branches: tip , default
  • modified
    Distribution/gras schema/101456-tracker.sql
--
casesp
Sep 12 2022 11:56 
--  Update:  #101456  faa_water_adjustment tables updates
502cada82d7aa8502e67576958aff6ef512ea504 branches: tip , default
CRQ-101456
57 Commits found, displaying 1 to 20
First« Previous123Next »Last