Pinned Loading

1. nws_notifier.py nws_notifier.py

   1

   from datetime import datetime

   2

   import logging

   3

   import requests

   4

   5

   logger = logging.getLogger(__name__)

2. access-in-pandas.md access-in-pandas.md

   1

   # Reading MS Access data in Pandas

   2

   3

   1. Download and install 32-bit Python 3.9 (this is the latest version that works with Access drivers) https://www.python.org/ftp/python/3.9.13/python-3.9.13.exe

   4

   2. Create a virtualenv: ```mkvirtualenv -p 3.9 pandas-32bit```

   5

   3. Install pandas 2.0.3 (the last with 32-bit wheels) and pyodbc: ```pip install pandas==2.0.3 pyodbc sqlalchemy```

3. havenbrook_anoka.json havenbrook_anoka.json

   1

   {"type": "FeatureCollection", "features": [{"id": "1221", "type": "Feature", "properties": {"address": "7864, Tyler Street Northeast, Spring Lake Park, Anoka County, Minnesota, 55432, United States"}, "geometry": {"type": "Point", "coordinates": [-93.24663934343434, 45.110740070707074]}}, {"id": "8502", "type": "Feature", "properties": {}, "geometry": null}, {"id": "10463", "type": "Feature", "properties": {"address": "13201, Osage Street Northwest, Oaks, Coon Rapids, Anoka County, Minnesota, 55448, United States"}, "geometry": {"type": "Point", "coordinates": [-93.31852135173119, 45.21072492686441]}}, {"id": "12598", "type": "Feature", "properties": {"address": "13217, Mankato Street Northeast, Blaine, Anoka County, Minnesota, 55449, United States"}, "geometry": {"type": "Point", "coordinates": [-93.21843252941177, 45.210043]}}, {"id": "16229", "type": "Feature", "properties": {"address": "1008, 128th Avenue Northeast, Johnsville, Blaine, Anoka County, Minnesota, 55434, United States"}, "geometry": {"type": "Point", "coordinates": [-93.24396126666667, 45.202035599999995]}}, {"id": "16925", "type": "Feature", "properties": {"address": "3444, 132nd Lane Northwest, Riverdale, Coon Rapids, Anoka County, Minnesota, 55448, United States"}, "geometry": {"type": "Point", "coordinates": [-93.35418532713051, 45.211740171275515]}}, {"id": "18594", "type": "Feature", "properties": {"address": "13206, Tyler Street Northeast, Blaine, Anoka County, Minnesota, 55434, United States"}, "geometry": {"type": "Point", "coordinates": [-93.2455739672624, 45.20965726810466]}}, {"id": "22031", "type": "Feature", "properties": {"address": "820, Paul Parkway Northeast, Blaine, Anoka County, Minnesota, 55434, United States"}, "geometry": {"type": "Point", "coordinates": [-93.24998229545454, 45.192902136363635]}}, {"id": "22978", "type": "Feature", "properties": {"address": "653, 117th Circle Northeast, Blaine, Anoka County, Minnesota, 55434, United States"}, "geometry": {"type": "Point", "coordinates": [-93.2545316709563, 45.183309070679115]}}, {"id": "24311", "type": "Feature", "properties": {"address": "1307, 9th Avenue, Federal Premium Ammunition, Anoka, Anoka County, Minnesota, 55303, United States"}, "geometry": {"type": "Point", "coordinates": [-93.373652, 45.188423]}}, {"id": "26255", "type": "Feature", "properties": {"address": "12117, Davenport Street Northeast, Johnsville, Blaine, Anoka County, Minnesota, 55449, United States"}, "geometry": {"type": "Point", "coordinates": [-93.22903113333334, 45.19087293333333]}}, {"id": "35671", "type": "Feature", "properties": {"address": "2329, 124th Lane Northwest, Elizabeth Court, Coon Rapids, Anoka County, Minnesota, 55448, United States"}, "geometry": {"type": "Point", "coordinates": [-93.3247433918919, 45.196477851351354]}}, {"id": "35857", "type": "Feature", "properties": {"address": "1706, 119th Avenue Northwest, Sherbrook, Coon Rapids, Anoka County, Minnesota, 55448, United States"}, "geometry": {"type": "Point", "coordinates": [-93.308736, 45.186442]}}, {"id": "37638", "type": "Feature", "properties": {"address": "7321, Tempo Terrace Northeast, Fridley, Anoka County, Minnesota, 55432, United States"}, "geometry": {"type": "Point", "coordinates": [-93.25946441156785, 45.10118318368652]}}, {"id": "37678", "type": "Feature", "properties": {"address": "7310, Lyric Lane Northeast, Fridley, Anoka County, Minnesota, 55432, United States"}, "geometry": {"type": "Point", "coordinates": [-93.26074789977436, 45.1010831666151]}}, {"id": "46671", "type": "Feature", "properties": {}, "geometry": null}, {"id": "46839", "type": "Feature", "properties": {"address": "11712, Norway Street Northwest, Northdale, Coon Rapids, Anoka County, Minnesota, 55448, United States"}, "geometry": {"type": "Point", "coordinates": [-93.28440617445278, 45.182151489675974]}}, {"id": "46894", "type": "Feature", "properties": {"address": "11501, Magnolia Street Northwest, Northdale, Coon Rapids, Anoka County, Minnesota, 55448, United States"}, "geometry": {"type": "Point", "coordinates": [-93.282279, 45.179371]}}, {"id": "49852", "type": "Feature", "properties": {"address": "6330, Jefferson Street Northeast, Fridley, Anoka County, Minnesota, 55432, United States"}, "geometry": {"type": "Point", "coordinates": [-93.25573612244898, 45.08371120408163]}}, {"id": "51077", "type": "Feature", "properties": {"address": "11421, Quince Street Northwest, Northdale, Coon Rapids, Anoka County, Minnesota, 55448, United States"}, "geometry": {"type": "Point", "coordinates": [-93.28889412531427, 45.17737156709448]}}, {"id": "53649", "type": "Feature", "properties": {"address": "146, 63rd Way Northeast, Fridley, Anoka County, Minnesota, 55432, United States"}, "geometry": {"type": "Point", "coordinates": [-93.274832, 45.082607653061224]}}, {"id": "72265", "type": "Feature", "properties": {"address": "10616, Wren Street Northwest, Riverview, Thompson Riverview Terrace, Coon Rapids, Anoka County, Minnesota, 55433, United States"}, "geometry": {"type": "Point", "coordinates": [-93.3297851142892, 45.16265272618377]}}, {"id": "74816", "type": "Feature", "properties": {"address": "2311, 108th Avenue Northwest, Riverview, Coon Rapids, Anoka County, Minnesota, 55433, United States"}, "geometry": {"type": "Point", "coordinates": [-93.3252833760395, 45.166315314339855]}}, {"id": "74917", "type": "Feature", "properties": {"address": "2050, 107th Avenue Northwest, Coon Rapids, Anoka County, Minnesota, 55433, United States"}, "geometry": {"type": "Point", "coordinates": [-93.31958068045411, 45.164100079317116]}}, {"id": "82985", "type": "Feature", "properties": {"address": "1030, Hathaway Lane Northeast, Fridley, Anoka County, Minnesota, 55432, United States"}, "geometry": {"type": "Point", "coordinates": [-93.24239388438711, 45.07120003338411]}}, {"id": "86227", "type": "Feature", "properties": {"address": "820, 108th Lane Northwest, Northdale, Coon Rapids, Anoka County, Minnesota, 55448, United States"}, "geometry": {"type": "Point", "coordinates": [-93.285491775, 45.166162225]}}, {"id": "88706", "type": "Feature", "properties": {}, "geometry": null}, {"id": "89665", "type": "Feature", "properties": {"address": "Stinson Boulevard Northeast, St. Anthony, Ramsey County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.2269695, 45.0397645]}}, {"id": "96748", "type": "Feature", "properties": {"address": "4710, 3rd Street Northeast, Fridley, Anoka County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.26420018367347, 45.05390104081633]}}, {"id": "97043", "type": "Feature", "properties": {"address": "4516, 5th Street Northeast, Columbia Heights, Anoka County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.2603611632653, 45.05039128571429]}}, {"id": "99771", "type": "Feature", "properties": {"address": "14333, Crane Street Northwest, Andover, Anoka County, Minnesota, 55304, United States"}, "geometry": {"type": "Point", "coordinates": [-93.30160427759174, 45.23248411549238]}}, {"id": "99772", "type": "Feature", "properties": {"address": "14315, Crane Street Northwest, Andover, Anoka County, Minnesota, 55304, United States"}, "geometry": {"type": "Point", "coordinates": [-93.30161683651376, 45.23268840729053]}}, {"id": "100207", "type": "Feature", "properties": {"address": "915, 143rd Avenue Northwest, Andover, Anoka County, Minnesota, 55304, United States"}, "geometry": {"type": "Point", "coordinates": [-93.28988384823766, 45.23017767333371]}}, {"id": "103249", "type": "Feature", "properties": {"address": "1759, 148th Lane Northwest, Andover, Anoka County, Minnesota, 55304, United States"}, "geometry": {"type": "Point", "coordinates": [-93.30957344893615, 45.24066648911594]}}, {"id": "108876", "type": "Feature", "properties": {"address": "3448, South Coon Creek Drive Northwest, Andover, Anoka County, Minnesota, 55304, United States"}, "geometry": {"type": "Point", "coordinates": [-93.35338262814423, 45.23271729273409]}}, {"id": "111802", "type": "Feature", "properties": {"address": "759, 95th Lane Northeast, Blaine, Anoka County, Minnesota, 55434, United States"}, "geometry": {"type": "Point", "coordinates": [-93.252855, 45.14446063636364]}}, {"id": "119207", "type": "Feature", "properties": {}, "geometry": null}, {"id": "122139", "type": "Feature", "properties": {"address": "2436, 136th Lane Northwest, Andover, Anoka County, Minnesota, 55304, United States"}, "geometry": {"type": "Point", "coordinates": [-93.3285213877551, 45.217691]}}, {"id": "126680", "type": "Feature", "properties": {"address": "4427, Monroe Street Northeast, Columbia Heights, Anoka County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.25242820408162, 45.04872328571429]}}, {"id": "126996", "type": "Feature", "properties": {"address": "4205, Jefferson Street Northeast, Columbia Heights, Anoka County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.25495177551021, 45.0447366122449]}}, {"id": "127073", "type": "Feature", "properties": {"address": "4131, Jefferson Street Northeast, Columbia Heights, Anoka County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.25493481632654, 45.04334879591836]}}, {"id": "127433", "type": "Feature", "properties": {"address": "4343, 6th Street Northeast, Columbia Heights, Anoka County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.258826, 45.04718]}}, {"id": "127895", "type": "Feature", "properties": {"address": "4241, 4th Street Northeast, Columbia Heights, Anoka County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.2614078367347, 45.04531673469388]}}, {"id": "127955", "type": "Feature", "properties": {"address": "4253, 6th Street Northeast, Columbia Heights, Anoka County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.25878181632653, 45.04551767346939]}}, {"id": "128968", "type": "Feature", "properties": {"address": "4044, Jefferson Street Northeast, Columbia Heights, Anoka County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.25514808163265, 45.04178844897959]}}, {"id": "129235", "type": "Feature", "properties": {"address": "3857, Quincy Street Northeast, Columbia Heights, Anoka County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.251024, 45.037736]}}, {"id": "132785", "type": "Feature", "properties": {"address": "1107, 42nd Avenue Northeast, Columbia Heights, Anoka County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.24409075220362, 45.04467419771949]}}, {"id": "133413", "type": "Feature", "properties": {"address": "1122, 40th Avenue Northeast, Columbia Heights, Anoka County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.24299916949151, 45.040883728813554]}}, {"id": "133875", "type": "Feature", "properties": {"address": "3912, Tyler Street Northeast, Columbia Heights, Anoka County, Minnesota, 55421, United States"}, "geometry": {"type": "Point", "coordinates": [-93.24168868262443, 45.03867437486348]}}]}

4. bc-parks-geopandas.ipynb bc-parks-geopandas.ipynb

   1

   {

   2

     "cells": [

   3

       {

   4

         "cell_type": "markdown",

   5

         "metadata": {