{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Geomapping Public Comments" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Of the 3919 files sent by the DEC, we were able to map the origin of 2611 comments (66%). An anonymized dataframe as been provided, \"anon_w_locations.csv\". \n", "\n", "This csv contains:\n", "- the suject line of the email comment sent (\"subject\")\n", "- the date submitted (\"month\", \"day\", \"year\")\n", "- city (\"city)\n", "- state (\"region1\")\n", "- zipcode (\"postal_code\")\n", "- latitude (\"lat\")\n", "- longitude (\"lng\")\n", "- stance (0 = \"anti-renewal\", 1 = \"pro-renewal\")\n", "\n", "17 of the 38 pro-renewal comments have been mapped, one being Greenidge itself. 2594 of the 3872 anti-renewal comments have been mapped. There have been 14 identified from out of state, 3 of which are pro-renewal and 11 being anti-renewal." ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | subject | \n", "month | \n", "day | \n", "year | \n", "city | \n", "region1 | \n", "postal_code | \n", "lat | \n", "lng | \n", "stance | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Please Deny Title 5 Permit | \n", "11.0 | \n", "15.0 | \n", "21.0 | \n", "Peekskill | \n", "New York | \n", "10566 | \n", "41.282600 | \n", "-73.924101 | \n", "0 | \n", "
1 | \n", "Luc - Greenidge Generating Station | \n", "11.0 | \n", "19.0 | \n", "21.0 | \n", "Ithaca | \n", "NY | \n", "14850 | \n", "42.435835 | \n", "-76.481422 | \n", "0 | \n", "
2 | \n", "Jean - Deny Greenidge's Title V Air Permit | \n", "10.0 | \n", "9.0 | \n", "21.0 | \n", "Mineola | \n", "NY | \n", "11501-1365 | \n", "40.748224 | \n", "-73.651264 | \n", "0 | \n", "
3 | \n", "hua - Deny Greenidge's Title V Air Permit | \n", "10.0 | \n", "5.0 | \n", "21.0 | \n", "Albany | \n", "NY | \n", "12208-1010 | \n", "42.641204 | \n", "-73.834502 | \n", "0 | \n", "
4 | \n", "Grennidge Power Plant | \n", "10.0 | \n", "22.0 | \n", "21.0 | \n", "Penn Yan | \n", "NY | \n", "14527 | \n", "42.716076 | \n", "-77.066421 | \n", "1 | \n", "