SQL Assignment
Budget: $10 – $30 USD
https://hifld-geoplatform.opendata.arcgis.com/datasets/mobile-home-parks/explore?location=32.118155%2C-107.796306%2C3.77
* You can use wget in your Ubuntu command terminal to directly download data from a URL. For more information, execute man wget at the Ubuntu command prompt.
* You can download the historical tornado data here: https://opendata.arcgis.com/datasets/fbc68200d74942b6805ca914b86ae5f3_0.csv?outSR=%7B%22latestWkid%22%3A3857%2C%22wkid%22%3A102100%7D
* For more information on the historical tornado track data, visit this link.
* You can download the mobile home park data here: https://opendata.arcgis.com/datasets/4cdbccc5c538452aa91ceee277c460f9_0.csv?outSR=%7B%22latestWkid%22%3A3857%2C%22wkid%22%3A102100%7D
* For more information on the mobile home park data, visit this link.
* Values -999 and -99999 appearing in data tables generally represent values which are unknown. Therefore, these values need to either be estimated or disregarded when using a data table containing them.
* In MySQL, function UPPER(string) converts a string to all uppercase letters. Likewise, function LOWER(string) converts a string to all lowercase letters.
* You can use wget in your Ubuntu command terminal to directly download data from a URL. For more information, execute man wget at the Ubuntu command prompt.
* You can download the historical tornado data here: https://opendata.arcgis.com/datasets/fbc68200d74942b6805ca914b86ae5f3_0.csv?outSR=%7B%22latestWkid%22%3A3857%2C%22wkid%22%3A102100%7D
* For more information on the historical tornado track data, visit this link.
* You can download the mobile home park data here: https://opendata.arcgis.com/datasets/4cdbccc5c538452aa91ceee277c460f9_0.csv?outSR=%7B%22latestWkid%22%3A3857%2C%22wkid%22%3A102100%7D
* For more information on the mobile home park data, visit this link.
* Values -999 and -99999 appearing in data tables generally represent values which are unknown. Therefore, these values need to either be estimated or disregarded when using a data table containing them.
* In MySQL, function UPPER(string) converts a string to all uppercase letters. Likewise, function LOWER(string) converts a string to all lowercase letters.