Update LSA Population Values

It is not unusual for LRS to receive updated LSA data sometime after the preliminary upload.  Rather than incorporate those values into the spreadsheet and then redo the upload process, it is quicker and easier to do it in MySQL.

  1. In the spreadsheet that contains updated LSA values, rename (if necessary) the FSCS column to fscskey, and rename (if necessary) the LSA column to popu_lsa.
  2. Set the format of the worksheet to “General.”
  3. Save the file as .CSV (for Windows) with a filename of _YYYY_lsa, where YYYY is the 4 digit year.
  4. Upload the file to the LRSi public database.
  5. Update the survey year’s table using the following SQL, which is an example for 2017.
UPDATE _2017 a JOIN _2017_lsa b ON a.fscskey = b.fscskey SET a.popu_lsa = b.popu_lsa;

In the example above, we alias the _2017 (a) and _2017_lsa (b) tables because they have columns in common (fscskey and popu_lsa).

Scroll to Top