This was something I tried with C++ waaaay back:http://code.kx.com/wsvn/code/contrib/rtripathi/geo/utm.qhttp://code.kx.com/wsvn/code/contrib/rtripathi/geo/data.zipTo run:* Download + unzip data.zip (contains all US zip codes + theirlatitude/longitudes and some census data)* Load utm.q* Currently the only entertaining purpose it serves is in finding outwhat your neighborhood is like (Alaska and Hawaii are outliers, needsome modifications):q)neighbors[10005;5]zip state town longitude latitude population1990 allocation---------------------------------------------------------------------------10002 NY “NEW YORK” 73.98768 40.71523 84143 0.00467710004 NY “GOVERNORS ISLAND” 74.01902 40.6936 3593 0.000210005 NY “NEW YORK” 74.00834 40.70565 202 1.1e-0510006 NY “NEW YORK” 74.01347 40.70845 119 7e-0610007 NY “NEW YORK” 74.00702 40.7139 3374 0.00018810013 NY “NEW YORK” 74.00253 40.71851 21860 0.00121510038 NY “NEW YORK” 74.0013 40.71009 14015 0.00077910280 NY “NEW YORK” 74.01632 40.71054 5574 0.0003111201 NY “BROOKLYN” 73.99034 40.69402 46980 0.002611Disclaimer: this is a hackjob put together (NJ will inevitably appearnear NY), so any suggestions for improvement are welcome.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| KDB/Q position - NYC | 0 | 1 | September 10, 2008 | |
| KX Community Meetup, New York | 2 | 0 | April 5, 2023 | |
| Climate Data | 1 | 0 | September 29, 2023 | |
| Kx Community Meetup Groups | 0 | 0 | May 12, 2014 | |
| a new GUI for q | 0 | 1 | January 15, 2009 |