search

nowcommunity / NOW-Data

Data related to the NOW databse
MIT License
0 stars 0 forks source link

Extract a list of localities under all private projects. Indrė will investigate the status. #74

Open karilint opened 4 months ago

karilint commented 4 months ago

SELECT MIN(u.lau_date) first_update, p.pid, p.proj_name, l.lid, l.loc_name, l.loc_status FROM now_proj p JOIN now_plr pl ON pl.pid=p.pid JOIN now_loc l ON l.lid=pl.lid JOIN now_lau u ON u.lid=l.lid WHERE p.proj_records=1 AND u.lau_date < '2017-11-23' GROUP BY l.lid ORDER BY p.pid, l.lid

karilint commented 4 months ago

Activity Show details Write a comment… indre.zliobaite Nov 20, 2023 11:08 AM Laura’s release pending

karilint commented 4 months ago

20221123_private_project_localities_older_than_5_years.xlsx