Format date and export to SQLite in QGIS
HTML-код
- Опубликовано: 26 ноя 2024
- In this video I explain a couple of things that should be useful to anyone working with dates and/or large datasets in QGIS. Computers really don't always get on that well with date formats so it's useful to know how to fix it when things aren't right. It's also useful to know how to export to other formats in QGIS - it's super-useful for that!
Here's the exprssion I used in the video to format the wonky date format in the original csv. There are other ways to do these things but I think it's useful to know how this kind of thing works..
right( "GAME_DATE" ,4) || '-' || left( "GAME_DATE" ,2)|| '-' ||substr( "GAME_DATE" ,4,2)
My NBA court data for QGIS: drive.google.c...
NBA shot data: github.com/Dom...
See my intro and intermediate QGIS courses for more: www.udemy.com/...