units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where MNG_AGENCY = 130
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
DES_TP 3
- Local Park 13
- Local Recreation Area 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 15
MNG_AGENCY 1
- Monterey Park, City of · 15 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
327 | 327 | 326 | {"type": "Polygon", "coordinates": [[[-118.11643, 34.05357], [-118.11612, 34.05357], [-118.11571, 34.05344], [-118.11533, 34.05395], [-118.11472, 34.05395], [-118.11472, 34.05415], [-118.1132, 34.05415], [-118.11324, 34.05404], [-118.11325, 34.0539], [-118.11322, 34.05366], [-118.11315, 34.05352], [-118.11294, 34.05326], [-118.11289, 34.05308], [-118.11289, 34.05142], [-118.11424, 34.05142], [-118.11452, 34.0518], [-118.11562, 34.05217], [-118.11642, 34.0526], [-118.11643, 34.05357]]]} | Open Access 1 | 870 | Garvey Ranch Park | 19228 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 18.252 | Garvey Ranch Park | 0 | Local Park 2 | 4 | |
474 | 474 | 473 | {"type": "Polygon", "coordinates": [[[-118.12741, 34.05935], [-118.12683, 34.05934], [-118.12682, 34.05887], [-118.12559, 34.05887], [-118.12556, 34.05667], [-118.12621, 34.05666], [-118.12622, 34.05665], [-118.12636, 34.05664], [-118.12637, 34.05666], [-118.12738, 34.05665], [-118.12741, 34.05935]]]} | Open Access 1 | 1522 | Barnes Park | 15822 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 10.866 | Barnes Park | 0 | Local Park 2 | 4 | |
548 | 548 | 547 | {"type": "Polygon", "coordinates": [[[-118.15647, 34.05666], [-118.15646, 34.05679], [-118.15646, 34.05778], [-118.15644, 34.05794], [-118.15638, 34.05807], [-118.15629, 34.05821], [-118.15617, 34.05832], [-118.15602, 34.05842], [-118.15588, 34.05847], [-118.1557, 34.05851], [-118.15503, 34.05852], [-118.15472, 34.05857], [-118.15455, 34.05864], [-118.15439, 34.05873], [-118.15425, 34.05885], [-118.15413, 34.05899], [-118.15386, 34.05887], [-118.15282, 34.05887], [-118.15247, 34.05879], [-118.15243, 34.05791], [-118.15263, 34.0577], [-118.15341, 34.0578], [-118.15337, 34.0579], [-118.15335, 34.05804], [-118.15336, 34.05818], [-118.1534, 34.05832], [-118.15395, 34.05819], [-118.15397, 34.05823], [-118.154, 34.05823], [-118.15416, 34.05865], [-118.15624, 34.05811], [-118.15597, 34.05736], [-118.1557, 34.05742], [-118.15551, 34.05691], [-118.15574, 34.05671], [-118.15586, 34.05668], [-118.15608, 34.0566], [-118.15618, 34.05658], [-118.15628, 34.05659], [-118.15644, 34.05662], [-118.15647, 34.05666]]]} | Open Access 1 | 1823 | Highlands Park | 19944 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 6.944 | Highlands Park | 0 | Local Park 2 | 4 | |
649 | 649 | 648 | {"type": "Polygon", "coordinates": [[[-118.11732, 34.04134], [-118.1173, 34.04236], [-118.11727, 34.04249], [-118.11474, 34.04187], [-118.11626, 34.04052], [-118.11732, 34.04134]]]} | Open Access 1 | 3140 | La Loma Park | 20771 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 7.134 | La Loma Park | 0 | Local Park 2 | 4 | |
904 | 904 | 903 | {"type": "Polygon", "coordinates": [[[-118.11526, 34.0661], [-118.11415, 34.06611], [-118.11415, 34.06495], [-118.11462, 34.06495], [-118.11464, 34.06501], [-118.11526, 34.06501], [-118.11526, 34.0661]]]} | Open Access 1 | 5796 | Sierra Vista Park | 25468 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 3.152 | Sierra Vista Park | 0 | Local Park 2 | 4 | |
2989 | 2989 | 2988 | {"type": "Polygon", "coordinates": [[[-118.11269, 34.05079], [-118.11265, 34.05082], [-118.11229, 34.05082], [-118.11226, 34.05061], [-118.11221, 34.0505], [-118.11199, 34.05018], [-118.11143, 34.05025], [-118.11167, 34.05007], [-118.11173, 34.04997], [-118.11177, 34.04982], [-118.11185, 34.04936], [-118.11246, 34.05018], [-118.11256, 34.05034], [-118.11265, 34.05059], [-118.11269, 34.05079]]]} | Open Access 1 | 20636 | Water Conservation Park | 29840 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 1.559 | Water Conservation Park | None 245 | |||
5095 | 5095 | 5094 | {"type": "Polygon", "coordinates": [[[-118.12792, 34.04127], [-118.12456, 34.04129], [-118.12403, 34.04169], [-118.12235, 34.04018], [-118.12452, 34.04017], [-118.12453, 34.04046], [-118.1279, 34.04046], [-118.12796, 34.04061], [-118.128, 34.04084], [-118.12799, 34.04102], [-118.12792, 34.04127]]]} | Open Access 1 | 919 | George E. Elder Park | 19262 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 12.0 | George E. Elder Park | 0 | Local Park 2 | 4 | |
6577 | 6577 | 6576 | {"type": "Polygon", "coordinates": [[[-118.13748, 34.03363], [-118.13748, 34.03388], [-118.13705, 34.0339], [-118.13705, 34.03402], [-118.13679, 34.03403], [-118.13681, 34.03454], [-118.13694, 34.03458], [-118.13695, 34.03502], [-118.13626, 34.03502], [-118.13624, 34.03364], [-118.13748, 34.03363]]]} | Open Access 1 | 3887 | Bella Vista Park | 15980 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 2.631 | Bella Vista Park | 0 | Local Park 2 | 4 | |
8110 | 8110 | 8109 | {"type": "Polygon", "coordinates": [[[-118.14277, 34.05426], [-118.14265, 34.05462], [-118.14261, 34.05471], [-118.14255, 34.05477], [-118.14245, 34.05485], [-118.14151, 34.05531], [-118.14135, 34.05534], [-118.14116, 34.05531], [-118.14065, 34.05505], [-118.14194, 34.05333], [-118.14258, 34.05367], [-118.14231, 34.05389], [-118.14227, 34.0541], [-118.14226, 34.05422], [-118.14253, 34.05427], [-118.14277, 34.05426]]]} | Open Access 1 | 12274 | Sequoia Park | 25310 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 5.492 | Sequoia Park | 0 | Local Park 2 | 4 | |
8912 | 8912 | 8911 | {"type": "Polygon", "coordinates": [[[-118.15216, 34.04539], [-118.15131, 34.04719], [-118.15128, 34.04733], [-118.15069, 34.04734], [-118.15062, 34.04731], [-118.15038, 34.04692], [-118.15038, 34.04688], [-118.15064, 34.04671], [-118.15084, 34.04648], [-118.15092, 34.04635], [-118.15147, 34.04521], [-118.15152, 34.04519], [-118.15216, 34.04539]]]} | Open Access 1 | 14582 | Sunnyslopes Park | 26013 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 4.285 | Sunnyslopes Park | 0 | Local Park 2 | 4 | |
10845 | 10845 | 10844 | {"type": "Polygon", "coordinates": [[[-118.16373, 34.05598], [-118.16384, 34.05618], [-118.1639, 34.05635], [-118.16405, 34.05714], [-118.16416, 34.05956], [-118.16422, 34.05972], [-118.16396, 34.05985], [-118.16372, 34.06002], [-118.16293, 34.06076], [-118.16249, 34.0611], [-118.16064, 34.06229], [-118.16049, 34.06229], [-118.16049, 34.05599], [-118.16373, 34.05598]]]} | Restricted Access 2 | 20634 | Monterey Park Golf Course | 33070 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 46.811 | Monterey Park GC | 0 | Local Recreation Area 3 | 4 | |
10847 | 10847 | 10846 | {"type": "Polygon", "coordinates": [[[-118.12837, 34.0455], [-118.12829, 34.04553], [-118.12817, 34.04553], [-118.12743, 34.04535], [-118.1272, 34.04532], [-118.11801, 34.04309], [-118.11799, 34.04277], [-118.11801, 34.04266], [-118.12629, 34.04467], [-118.12828, 34.0447], [-118.12838, 34.04547], [-118.12837, 34.0455]]]} | Open Access 1 | 20633 | Edison Trails Park | 18447 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 12.372 | Edison Trails Park | 0 | Local Park 2 | 4 | |
10848 | 10848 | 10847 | {"type": "Polygon", "coordinates": [[[-118.13797, 34.05473], [-118.13779, 34.05502], [-118.13711, 34.05474], [-118.13729, 34.05444], [-118.13797, 34.05473]]]} | Open Access 1 | 20635 | Cascade Park | 16936 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 0.644 | Cascade Park | 0 | Local Park 2 | 4 | |
11313 | 11313 | 11312 | {"type": "Polygon", "coordinates": [[[-118.16049, 34.05346], [-118.16049, 34.05373], [-118.15995, 34.05373], [-118.15986, 34.0536], [-118.16001, 34.0535], [-118.16008, 34.05343], [-118.16012, 34.05335], [-118.16049, 34.05346]]]} | Open Access 1 | 22158 | Pine Tree Park | 23683 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 0.443 | Pine Tree Park | 0 | Local Park 2 | 4 | |
15355 | 15355 | 15354 | {"type": "Polygon", "coordinates": [[[-118.1282, 34.0656], [-118.1281, 34.0656], [-118.12809, 34.06563], [-118.128, 34.0656], [-118.12791, 34.06559], [-118.12785, 34.06561], [-118.12781, 34.06564], [-118.12768, 34.06564], [-118.12768, 34.06541], [-118.1282, 34.06541], [-118.1282, 34.0656]]]} | Open Access 1 | 46544 | Beth Ryan Park | 29839 | 1213 | Monterey Park, City of 133 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 0.269 | Beth Ryan Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);