Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Visual Clickable Layer of EPA Permitted Point Sources #3227

Open
rajadain opened this issue Jan 16, 2020 · 0 comments
Open

Add Visual Clickable Layer of EPA Permitted Point Sources #3227

rajadain opened this issue Jan 16, 2020 · 0 comments
Labels
NSF Funding Source: National Science Foundation
Milestone

Comments

@rajadain
Copy link
Member

Using the ms_pointsource table, add a visual layer showing the EPA Permitted Point Sources of Pollution:

image
image

The layer should be clickable, and clicking on a point-source should have a pop-up that shows the metadata associated with the point source:

SELECT * FROM ms_pointsource LIMIT 5;

 ogc_fid |                        geom                        | npdes_id  |     city     | state |  latitude  |  longitude   |   huc_12_cod    | avg_n_conc |   lbsn_yr   |  mgd   | avgpconc  |     lbsp_yr     |  kgn_yr  | kgp_yr 
---------+----------------------------------------------------+-----------+--------------+-------+------------+--------------+-----------------+------------+-------------+--------+-----------+-----------------+----------+--------
   23070 | 0101000020E610000015C5ABAC6D1454C038A0A52BD8A24340 | WV0005363 | CLARKSBURG   | WV    | 39.2722220 |  -80.3191940 |  50200020204.00 |       21.6 | 50005660.00 | 1100.0 |           |                 | 22702570 |       
   23071 | 0101000020E6100000C425C79DD2D358C06EA6423C12ED4340 | KS0100749 | PHILLIPSBURG | KS    | 39.8521190 |  -99.3097300 |                 |       90.1 | 17474523.00 |   19.2 | 0.0180000 |    1953.0000000 |  7933433 |    887
   23072 | 0101000020E6100000ACADD85F76F155C03E5C72DC29E94440 | IL0028053 | CICERO       | IL    | 41.8215900 |  -87.7728500 |  71200040705.00 |        7.8 | 15774767.00 |  680.0 | 0.9300000 | 1879062.0000000 |  7161744 | 853094
   23073 | 0101000020E6100000E50B5A48C04F5DC0A9DA6E826F564040 | CA0107409 | SAN DIEGO    | CA    | 32.6752780 | -117.2461110 | 181000000000.00 |       37.4 | 14942084.00 |  131.0 |           |                 |  6783706 |       
   23074 | 0101000020E61000004D4BAC8C469857C08FC2F5285C934240 | MO0002402 | CARTHAGE     | MO    | 37.1512500 |  -94.3793060 | 111000000000.00 |       93.0 | 10453958.00 |   11.8 |           |                 |  4746097 |       

Since it is a large number of points for the national dataset, we may have to use the Tiler with a UTF-Grid layer for interactivity. We may also have to look into grouping points at lower zoom levels.

@rajadain rajadain added the NSF Funding Source: National Science Foundation label Jan 16, 2020
@rajadain rajadain added this to the 1.27 milestone Jan 16, 2020
@rajadain rajadain modified the milestones: 1.27, 1.28 Mar 5, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
NSF Funding Source: National Science Foundation
Projects
None yet
Development

No branches or pull requests

1 participant