units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2 sorted by MNG_AG_ID descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
DES_TP >30
- Local Park 7,486
- Local Recreation Area 1,440
- Local Other or Unknown 663
- Local Conservation Area 143
- Local Historic or Cultural Area 37
- Local Resource Management Area 6
- National Monument or Landmark 5
- None 1
- None 1
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
LAYER 10 ✖
ACCESS_TYP 4
- Open Access 9,925
- Restricted Access 363
- No Public Access 207
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,524 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5575 | 5575 | 5574 | {"type": "Polygon", "coordinates": [[[-122.36754, 37.72678], [-122.36734, 37.727], [-122.36723, 37.72694], [-122.36712, 37.72698], [-122.36703, 37.72705], [-122.36698, 37.72714], [-122.36697, 37.72723], [-122.36708, 37.7273], [-122.36688, 37.72752], [-122.36589, 37.72698], [-122.36647, 37.72634], [-122.36666, 37.72629], [-122.36754, 37.72678]]]} | Open Access 1 | 48781 | Hillpoint Park | 33507 | 2290 | San Francisco, City and County of, Redevelopment Agency 809 | City 2 | City Agency 2 | http://www.sfredevelopment.org/index.aspx?page=104 | City 2 | 2290 | San Francisco, City and County of, Redevelopment Agency 788 | City 2 | City Agency 2 | https://www.cmgsite.com/project/hunters-point-parks-hillside-central-park-hillpoint-park-and-innes-court-park/ | San Francisco 13 | 2.47 | Hillpoint Park | 2003 | Local Park 2 | 4 |
15325 | 15325 | 15324 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19586], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | 48970 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1153 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | Los Angeles 6 | 5.621 | 0 | Local Other or Unknown 14 | 4 | ||
7127 | 7127 | 7126 | {"type": "Polygon", "coordinates": [[[-118.24292, 33.94311], [-118.24258, 33.94313], [-118.24261, 33.94276], [-118.24292, 33.94277], [-118.24292, 33.94311]]]} | Restricted Access 2 | 6216 | Watts Historic Train Station | 29326 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1717 | Los Angeles - Community Redevelopment Agency, City of 829 | City 2 | City Agency 2 | Los Angeles 6 | 0.287 | Watts Historic Train Station | 0 | Local Historic or Cultural Area 19 | 4 | |
13936 | 13936 | 13935 | {"type": "Polygon", "coordinates": [[[-118.26813, 34.03678], [-118.26797, 34.03702], [-118.26752, 34.03682], [-118.26768, 34.03658], [-118.26813, 34.03678]]]} | Open Access 1 | 36542 | Venice Hope Park | 29327 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1717 | Los Angeles - Community Redevelopment Agency, City of 829 | City 2 | City Agency 2 | Los Angeles 6 | 0.357 | Venice Hope Park | 0 | Local Park 2 | 4 | |
3553 | 3553 | 3552 | {"type": "Polygon", "coordinates": [[[-118.32226, 33.97102], [-118.3222, 33.97106], [-118.32211, 33.97108], [-118.322, 33.97105], [-118.32196, 33.97104], [-118.32192, 33.97096], [-118.32194, 33.97086], [-118.32203, 33.9708], [-118.32211, 33.97078], [-118.32221, 33.97079], [-118.32224, 33.97081], [-118.32227, 33.9709], [-118.32226, 33.97102]]]} | Open Access 1 | 7716 | Circle Park (5th Avenue) | 29160 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | Los Angeles 6 | 0.212 | Circle Park (5th Avenue) | None 296 | ||
5697 | 5697 | 5696 | {"type": "Polygon", "coordinates": [[[-118.24283, 34.12002], [-118.2427, 34.12011], [-118.24249, 34.11991], [-118.24263, 34.11981], [-118.24283, 34.12002]]]} | Open Access 1 | 45736 | Drew Street Park | 29109 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | Los Angeles 6 | 0.116 | Drew Street Park | 0 | Local Park 2 | 4 | |
6420 | 6420 | 6419 | {"type": "Polygon", "coordinates": [[[-118.34333, 34.10414], [-118.34241, 34.10414], [-118.34241, 34.10351], [-118.34332, 34.10352], [-118.34333, 34.10414]]]} | Open Access 1 | 1893 | Dorothy J. and Benjamin B. Smith Park | 29107 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | Los Angeles 6 | 1.441 | Dorothy J. and Benjamin B. Smith Park | 0 | Local Park 2 | 4 | |
7636 | 7636 | 7635 | {"type": "Polygon", "coordinates": [[[-118.31351, 33.97087], [-118.3135, 33.97102], [-118.3134, 33.97108], [-118.31327, 33.97108], [-118.31322, 33.97104], [-118.31317, 33.97098], [-118.31318, 33.97087], [-118.31325, 33.9708], [-118.31334, 33.97077], [-118.31341, 33.97078], [-118.31346, 33.9708], [-118.31351, 33.97087]]]} | Open Access 1 | 7705 | Circle Park (Gramercy) | 29159 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | Los Angeles 6 | 0.216 | Circle Park (Gramercy) | None 637 | ||
9483 | 9483 | 9482 | {"type": "MultiPolygon", "coordinates": [[[[-118.35436, 34.11245], [-118.35429, 34.11252], [-118.35299, 34.11466], [-118.35297, 34.11244], [-118.35436, 34.11245]]], [[[-118.35377, 34.11413], [-118.35376, 34.1142], [-118.35361, 34.11442], [-118.35356, 34.11455], [-118.35354, 34.11476], [-118.35355, 34.11511], [-118.3535, 34.11524], [-118.35333, 34.11552], [-118.35348, 34.11564], [-118.353, 34.11529], [-118.35299, 34.11526], [-118.35373, 34.11404], [-118.35377, 34.11413]]]]} | Open Access 1 | 47826 | Runyon Canyon Park | 31769 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | Los Angeles 6 | 4.702 | Runyon Canyon Park | 0 | Local Park 2 | 4 | |
11229 | 11229 | 11228 | {"type": "Polygon", "coordinates": [[[-118.47355, 34.29793], [-118.47245, 34.29891], [-118.47229, 34.29879], [-118.4722, 34.29887], [-118.47221, 34.29894], [-118.47213, 34.29901], [-118.47089, 34.29806], [-118.47156, 34.29743], [-118.47171, 34.2975], [-118.47187, 34.29753], [-118.47223, 34.29752], [-118.47272, 34.29745], [-118.47288, 34.29749], [-118.47324, 34.29764], [-118.47333, 34.2977], [-118.47355, 34.29793]]]} | Open Access 1 | 48024 | West Lakeside Street Park | 32503 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | Los Angeles 6 | 6.243 | West Lakeside Street Park | 0 | Local Park 2 | 4 | |
15042 | 15042 | 15041 | {"type": "Polygon", "coordinates": [[[-118.33513, 34.1361], [-118.33399, 34.13613], [-118.33065, 34.14103], [-118.32259, 34.13646], [-118.32257, 34.1343], [-118.32662, 34.13429], [-118.33423, 34.13423], [-118.33431, 34.13463], [-118.33462, 34.13512], [-118.33462, 34.13529], [-118.33478, 34.1354], [-118.33491, 34.13558], [-118.3349, 34.13582], [-118.33505, 34.13595], [-118.33513, 34.1361]]]} | Open Access 1 | 45704 | Cahuenga Peak Phase 1 | 29079 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | Los Angeles 6 | 130.502 | Cahuenga Peak Phase 1 | None 1301 | ||
15408 | 15408 | 15407 | {"type": "Polygon", "coordinates": [[[-118.26272, 34.09928], [-118.26229, 34.09907], [-118.26213, 34.09908], [-118.2619, 34.09916], [-118.26178, 34.09924], [-118.26172, 34.09933], [-118.2614, 34.09995], [-118.26119, 34.10003], [-118.26115, 34.0999], [-118.26088, 34.0994], [-118.26078, 34.09911], [-118.26076, 34.09887], [-118.26076, 34.09824], [-118.26078, 34.09802], [-118.26083, 34.09784], [-118.26097, 34.09757], [-118.26169, 34.09659], [-118.26181, 34.0963], [-118.26192, 34.09588], [-118.262, 34.09572], [-118.2623, 34.09572], [-118.26183, 34.09659], [-118.26187, 34.09749], [-118.26209, 34.09818], [-118.26272, 34.09928]]]} | Open Access 1 | 46636 | Silver Lake Meadows Park | 29963 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | Los Angeles 6 | 8.811 | Silver Lake Meadows Park | 0 | Local Park 2 | 4 | |
16895 | 16895 | 16894 | {"type": "Polygon", "coordinates": [[[-118.244, 33.99945], [-118.244, 34.00174], [-118.24354, 34.00179], [-118.24362, 33.99941], [-118.244, 33.99945]]]} | Open Access 1 | 10195 | Fred Roberts Recreation Center | 29143 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | Los Angeles 6 | 2.495 | Fred Roberts Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
17044 | 17044 | 17043 | {"type": "Polygon", "coordinates": [[[-118.24477, 34.05427], [-118.24461, 34.05444], [-118.24459, 34.05443], [-118.24454, 34.05449], [-118.24455, 34.05451], [-118.24403, 34.05507], [-118.2432, 34.05453], [-118.24394, 34.05373], [-118.24477, 34.05427]]]} | Open Access 1 | 45773 | 1st and Broadway Civic Center Park | 29093 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | Los Angeles 6 | 2.682 | 1st and Broadway Civic Ctr. Park | 0 | Local Park 2 | 4 | |
4301 | 4301 | 4300 | {"type": "Polygon", "coordinates": [[[-118.65948, 34.17172], [-118.6594, 34.17201], [-118.65917, 34.17207], [-118.65913, 34.1721], [-118.65863, 34.17207], [-118.65863, 34.17156], [-118.65948, 34.17172]]]} | Open Access 1 | 48152 | Hidden Hills Demonstration Gardens | 32688 | 1713 | Hidden Hills, City of 742 | City 2 | City Agency 2 | http://www.hiddenhillscity.org/ | City 2 | 1713 | Hidden Hills, City of 728 | City 2 | City Agency 2 | Los Angeles 6 | 0.895 | Hidden Hills Demonstration Gardens | 0 | Local Park 2 | 4 | |
15299 | 15299 | 15298 | {"type": "Polygon", "coordinates": [[[-117.97481, 34.14373], [-117.9748, 34.14592], [-117.97453, 34.14593], [-117.97453, 34.14687], [-117.9745, 34.14687], [-117.9745, 34.1459], [-117.97473, 34.14589], [-117.97476, 34.14586], [-117.97476, 34.14373], [-117.97481, 34.14373]]]} | Open Access 1 | 46437 | Lemon Trail | 29710 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.341 | Lemon Trail | 0 | Local Recreation Area 3 | 4 | |
15300 | 15300 | 15299 | {"type": "Polygon", "coordinates": [[[-117.96999, 34.14575], [-117.9696, 34.14575], [-117.96915, 34.14556], [-117.96899, 34.14555], [-117.96898, 34.14547], [-117.96986, 34.1455], [-117.96996, 34.14548], [-117.96999, 34.14575]]]} | Open Access 1 | 46439 | Civic Center Park | 32522 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.468 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
15301 | 15301 | 15300 | {"type": "Polygon", "coordinates": [[[-117.97472, 34.14357], [-117.97464, 34.14362], [-117.96441, 34.1437], [-117.96441, 34.14354], [-117.97458, 34.14347], [-117.97472, 34.14357]]]} | Open Access 1 | 46438 | Royal Oaks Trail North | 29711 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 4.034 | Royal Oaks Trail North | None 1352 | |||
3616 | 3616 | 3615 | {"type": "Polygon", "coordinates": [[[-117.19803, 33.68999], [-117.19798, 33.69004], [-117.19756, 33.69004], [-117.19729, 33.69001], [-117.19718, 33.69006], [-117.19712, 33.69012], [-117.19679, 33.68999], [-117.19679, 33.68896], [-117.19757, 33.68896], [-117.19795, 33.68893], [-117.198, 33.68896], [-117.19803, 33.68916], [-117.19803, 33.68999]]]} | Open Access 1 | 39101 | Lazy Creek Park | 21121 | 1707 | Menifee, City of 667 | City 2 | City Agency 2 | http://www.cityofmenifee.us/284/Community-Services | City 2 | 1707 | Menifee, City of 655 | City 2 | City Agency 2 | Riverside 10 | 3.416 | Lazy Creek Park | 0 | Local Park 2 | 4 | |
5170 | 5170 | 5169 | {"type": "Polygon", "coordinates": [[[-117.18847, 33.67958], [-117.18846, 33.68071], [-117.1863, 33.68073], [-117.18629, 33.68042], [-117.18631, 33.6803], [-117.18635, 33.68018], [-117.18647, 33.68], [-117.18687, 33.67957], [-117.18847, 33.67958]]]} | Open Access 1 | 39102 | Lyle Marsh Park | 21604 | 1707 | Menifee, City of 667 | City 2 | City Agency 2 | http://www.cityofmenifee.us/284/Community-Services | City 2 | 1707 | Menifee, City of 655 | City 2 | City Agency 2 | Riverside 10 | 5.86 | Lyle Marsh 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]);