superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where MNG_AGENCY = 236
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1556 | 1556 | 1555 | {"type": "Polygon", "coordinates": [[[-118.03691, 34.06477], [-118.0369, 34.06637], [-118.03687, 34.06641], [-118.03654, 34.06638], [-118.03614, 34.06638], [-118.0361, 34.06635], [-118.0361, 34.0657], [-118.03603, 34.065], [-118.03613, 34.06478], [-118.03686, 34.06474], [-118.03691, 34.06477]]]} | Open Access 1 | Arceo Park | 15573 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 3.373 | Arceo Park | ||
1727 | 1727 | 1726 | {"type": "Polygon", "coordinates": [[[-118.05352, 34.07636], [-118.05344, 34.07676], [-118.05258, 34.07641], [-118.05258, 34.07637], [-118.05352, 34.07636]]]} | Open Access 1 | Baldwin Mini Park | 15778 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 0.527 | Baldwin MP | ||
4260 | 4260 | 4259 | {"type": "Polygon", "coordinates": [[[-118.04858, 34.07115], [-118.04761, 34.07159], [-118.04685, 34.07197], [-118.04685, 34.07037], [-118.04858, 34.07115]]]} | Open Access 1 | Fletcher Park | 18948 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 3.459 | Fletcher Park | ||
5956 | 5956 | 5955 | {"type": "Polygon", "coordinates": [[[-118.02084, 34.08493], [-118.02045, 34.08668], [-118.01823, 34.08646], [-118.01896, 34.08495], [-118.01904, 34.08466], [-118.02084, 34.08493]]]} | Open Access 1 | Lambert Park | 20992 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 9.285 | Lambert Park | ||
8731 | 8731 | 8730 | {"type": "Polygon", "coordinates": [[[-118.03917, 34.08228], [-118.03852, 34.0832], [-118.03847, 34.08344], [-118.0383, 34.08335], [-118.0383, 34.08331], [-118.03824, 34.08325], [-118.03818, 34.08325], [-118.03813, 34.08328], [-118.03781, 34.08313], [-118.03833, 34.08216], [-118.03864, 34.0822], [-118.03869, 34.08229], [-118.03874, 34.08232], [-118.03885, 34.08231], [-118.03892, 34.08225], [-118.03917, 34.08228]]]} | Open Access 1 | Rio Vista PArk | 24391 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 2.146 | Rio Vista PArk | ||
11500 | 11500 | 11499 | {"type": "Polygon", "coordinates": [[[-118.01207, 34.07165], [-118.01152, 34.07275], [-118.01061, 34.07243], [-118.01091, 34.07179], [-118.01001, 34.07147], [-118.01024, 34.07101], [-118.01027, 34.07098], [-118.01031, 34.07098], [-118.01204, 34.07159], [-118.01207, 34.07161], [-118.01207, 34.07165]]]} | Open Access 1 | Zamora Park | 27852 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 4.492 | Zamora Park | ||
11757 | 11757 | 11756 | {"type": "Polygon", "coordinates": [[[-118.04947, 34.08112], [-118.04899, 34.0824], [-118.04774, 34.08199], [-118.04798, 34.0809], [-118.04947, 34.08112]]]} | Open Access 1 | Gibson Mariposa Neighborhood Park | http://www.ci.el-monte.ca.us/Government/ParksRecCommunitySrvs.aspx | 28369 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 4.413 | Gibson Mariposa Neighborhood Park | |
12535 | 12535 | 12534 | {"type": "Polygon", "coordinates": [[[-118.04159, 34.07653], [-118.04137, 34.07675], [-118.04135, 34.07673], [-118.04131, 34.07675], [-118.0408, 34.07723], [-118.04095, 34.07699], [-118.04114, 34.0766], [-118.0414, 34.07651], [-118.04159, 34.07653]]]} | Open Access 1 | Gateway/Veterans Park | 29641 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 0.32 | Gateway/Veterans Park | ||
12536 | 12536 | 12535 | {"type": "Polygon", "coordinates": [[[-118.06605, 34.064], [-118.06572, 34.06421], [-118.06559, 34.06431], [-118.06518, 34.06471], [-118.06469, 34.06509], [-118.06328, 34.06608], [-118.06323, 34.06603], [-118.06325, 34.06601], [-118.06324, 34.06547], [-118.0637, 34.06546], [-118.06591, 34.06386], [-118.06605, 34.064]]]} | Open Access 1 | Lashbrook Park | 29644 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 2.289 | Lashbrook Park | ||
12537 | 12537 | 12536 | {"type": "Polygon", "coordinates": [[[-118.03987, 34.07959], [-118.03911, 34.08069], [-118.03782, 34.08311], [-118.03785, 34.08315], [-118.03742, 34.08386], [-118.03733, 34.08382], [-118.03894, 34.0808], [-118.03944, 34.08002], [-118.03981, 34.07956], [-118.03987, 34.07959]]]} | Open Access 1 | Rio Hondo River Trail | 29645 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 1.227 | Rio Hondo River Trail | ||
12547 | 12547 | 12546 | {"type": "Polygon", "coordinates": [[[-118.03556, 34.06661], [-118.0355, 34.06665], [-118.03549, 34.0667], [-118.03547, 34.06671], [-118.03547, 34.06675], [-118.03544, 34.06676], [-118.03544, 34.06686], [-118.03529, 34.06686], [-118.03527, 34.06691], [-118.03478, 34.06691], [-118.03478, 34.06651], [-118.03525, 34.06652], [-118.03527, 34.06653], [-118.03556, 34.06654], [-118.03556, 34.06661]]]} | Restricted Access 2 | El Monte Aquatic Center | 29652 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 0.668 | El Monte Aquatic Ctr. | ||
12600 | 12600 | 12599 | {"type": "Polygon", "coordinates": [[[-118.03583, 34.06522], [-118.03583, 34.06637], [-118.03578, 34.06639], [-118.03464, 34.06639], [-118.03464, 34.06484], [-118.03578, 34.06484], [-118.0358, 34.06507], [-118.03578, 34.06508], [-118.03579, 34.0652], [-118.03583, 34.06522]]]} | Restricted Access 2 | Community Center Complex | 29686 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 4.633 | Community Ctr. Complex | ||
15481 | 15481 | 15480 | {"type": "Polygon", "coordinates": [[[-118.02351, 34.05601], [-118.02203, 34.05722], [-118.02147, 34.05675], [-118.02129, 34.05687], [-118.02041, 34.05611], [-118.02205, 34.05478], [-118.02209, 34.0548], [-118.02351, 34.05601]]]} | Open Access 1 | Mountain View Park | 22553 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 9.752 | Mtn. View Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);