Brett Bonner bbopen
ebrelsford
/ nycproj2latlon.sql
Last active
December 21, 2015 05:39
Convert a table with coordinates in NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_Feet (common for NYC data) to lat and lon in 4326. We first convert the coordinates from feet to meters.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| UPDATE graffiti_locations | |
| SET the_geom = ST_Transform( | |
| ST_SetSRID( | |
| ST_MakePoint(x * 0.3048006096012192, y * 0.3048006096012192), | |
| 32118), | |
| 4326 | |
| ) |
hdemers
/ pydata-science.sh
Last active
June 1, 2020 07:17
Installation instructions for doing data science in a Python environment on Ubuntu. We'll install base packages like numpy, scipy, scikit-learn and pandas. We also install the IPython Notebook interactive environment. This is a best practice recommendation for doing research-type work. We make use of virtualenvwrapper, but don't show how to inst…
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mkvirtualenv datascience | |
| sudo apt-get install python-scipy libblas-dev liblapack-dev gfortran | |
| sudo apt-get install libffi-dev # for cryptography from scrapy | |
| sudo apt-get install libxslt-dev # for libxml from scrapy | |
| export BLAS=/usr/lib/libblas.so | |
| export LAPACK=/usr/lib/liblapack.so | |
| pip install numpy | |
| pip install scipy | |
| pip install scikit-learn | |
| pip install pandas |