units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
65 rows where MNG_AGENCY = 273 and MNG_AG_TYP = 7 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, GAP_STS
DES_TP 8
- Local Park 44
- Local Recreation Area 15
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
AGNCY_LEV 4 ✖
- County 60
- State 3
- Federal 1
- Special District 1
ACCESS_TYP 3
MNG_AG_TYP 1
- County Agency - Parks · 65 ✖
MNG_AGENCY 1
- Los Angeles - Department of Parks and Recreation, County of · 65 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11442 | 11442 | 11441 | {"type": "Polygon", "coordinates": [[[-118.36175, 33.93255], [-118.36175, 33.93272], [-118.36145, 33.93272], [-118.36146, 33.93255], [-118.36175, 33.93255]]]} | Open Access 1 | 48138 | Lennox Community Garden | 32666 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.127 | Lennox Community Garden | 0 | Local Park 2 | 4 | |
11446 | 11446 | 11445 | {"type": "Polygon", "coordinates": [[[-118.49983, 34.28887], [-118.49978, 34.28895], [-118.49972, 34.28892], [-118.49959, 34.28878], [-118.49971, 34.28866], [-118.49975, 34.28864], [-118.49983, 34.28865], [-118.49987, 34.28867], [-118.49989, 34.28871], [-118.49989, 34.28876], [-118.49983, 34.28885], [-118.49983, 34.28887]]]} | Open Access 1 | 48139 | Knollwood Pool | 32669 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/knollwood-pool/ | Los Angeles 6 | 0.141 | Knollwood Pool | 0 | Local Recreation Area 3 | 4 |
4302 | 4302 | 4301 | {"type": "Polygon", "coordinates": [[[-118.1262, 34.18898], [-118.12621, 34.18904], [-118.12603, 34.18933], [-118.12602, 34.18935], [-118.12595, 34.18934], [-118.12593, 34.18924], [-118.12595, 34.18897], [-118.12609, 34.18896], [-118.1262, 34.18898]]]} | Open Access 1 | 48153 | Ganesha Park | 32689 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.181 | Ganesha Park | 0 | Local Park 2 | 4 | |
14869 | 14869 | 14868 | {"type": "Polygon", "coordinates": [[[-118.23121, 34.21905], [-118.23088, 34.21936], [-118.23059, 34.21958], [-118.23052, 34.21953], [-118.23111, 34.21899], [-118.23121, 34.21905]]]} | Open Access 1 | 45388 | Pickens Canyon Park | 32497 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Pickens_Canyon_Park | Los Angeles 6 | 0.22 | Pickens Canyon Park | 0 | Local Park 2 | 4 |
15076 | 15076 | 15075 | {"type": "Polygon", "coordinates": [[[-118.23107, 34.20894], [-118.23096, 34.20934], [-118.23094, 34.20936], [-118.2309, 34.20936], [-118.23081, 34.20922], [-118.23064, 34.20904], [-118.23064, 34.20902], [-118.23066, 34.209], [-118.23091, 34.20896], [-118.23103, 34.20892], [-118.23106, 34.20892], [-118.23107, 34.20894]]]} | Open Access 1 | 45856 | Mira Vista Park | 32494 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.249 | Mira Vista Park | 0 | Local Park 2 | 4 | |
15080 | 15080 | 15079 | {"type": "Polygon", "coordinates": [[[-118.29689, 33.82584], [-118.29682, 33.82596], [-118.29682, 33.82618], [-118.2968, 33.82621], [-118.2963, 33.82621], [-118.2963, 33.82584], [-118.29689, 33.82584]]]} | Open Access 1 | 45860 | Park Learning Grove County Park | 32495 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Park_Learning_Grove_County_Park | Los Angeles 6 | 0.488 | Park Learning Grove County Park | 0 | Local Park 2 | 4 |
9757 | 9757 | 9756 | {"type": "Polygon", "coordinates": [[[-118.13253, 34.18988], [-118.13208, 34.1899], [-118.13157, 34.19001], [-118.1315, 34.18999], [-118.13147, 34.18994], [-118.13148, 34.18975], [-118.13166, 34.18963], [-118.13189, 34.1897], [-118.13207, 34.18969], [-118.13216, 34.18976], [-118.13253, 34.18988]]]} | Open Access 1 | 47869 | Altadena Triangle Park | 32467 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/altadena-triangle-park/ | Los Angeles 6 | 0.524 | Altadena Triangle Park | 0 | Local Park 2 | 4 |
3251 | 3251 | 3250 | {"type": "Polygon", "coordinates": [[[-118.29179, 33.95328], [-118.2918, 33.95365], [-118.29183, 33.9538], [-118.29183, 33.9539], [-118.29183, 33.95646], [-118.29181, 33.95682], [-118.29178, 33.957], [-118.29171, 33.95701], [-118.29167, 33.95699], [-118.29163, 33.95683], [-118.29164, 33.95301], [-118.29179, 33.95328]]]} | Open Access 1 | 48155 | Vermont Median | 32692 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/vermont-median/ | Los Angeles 6 | 1.804 | Vermont Median | None 267 | ||
11447 | 11447 | 11446 | {"type": "Polygon", "coordinates": [[[-117.92427, 33.98937], [-117.92229, 33.98922], [-117.92235, 33.98879], [-117.92237, 33.98878], [-117.9235, 33.98886], [-117.92365, 33.98889], [-117.92386, 33.98897], [-117.92404, 33.98909], [-117.92417, 33.98922], [-117.92427, 33.98937]]]} | Open Access 1 | 48140 | Albatross Road Rest Area | 32670 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/albatross-road-rest-area/ | Los Angeles 6 | 1.94 | Albatross Road Rest Area | None 1016 | ||
15073 | 15073 | 15072 | {"type": "Polygon", "coordinates": [[[-118.18749, 33.88301], [-118.18743, 33.88376], [-118.18718, 33.88544], [-118.18669, 33.88544], [-118.18708, 33.88292], [-118.18749, 33.88301]]]} | Open Access 1 | 45852 | 72nd Street Equestrian Park | 32687 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/72nd-street-equestrian-park/ | Los Angeles 6 | 2.957 | 72nd Street Equestrian Park | 0 | Local Recreation Area 3 | 4 |
12117 | 12117 | 12116 | {"type": "Polygon", "coordinates": [[[-117.99458, 34.12298], [-117.99417, 34.12402], [-117.9937, 34.1239], [-117.99361, 34.12392], [-117.99355, 34.12398], [-117.99303, 34.12384], [-117.99314, 34.12361], [-117.99327, 34.12338], [-117.99379, 34.12268], [-117.99452, 34.12288], [-117.99452, 34.12294], [-117.99458, 34.12298]]]} | Open Access 1 | 25055 | Pamela County Park | 32487 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 3.221 | Pamela County Park | 0 | Local Park 2 | 4 | |
7171 | 7171 | 7170 | {"type": "Polygon", "coordinates": [[[-118.35661, 33.997], [-118.35664, 33.99732], [-118.3566, 33.99764], [-118.35649, 33.99812], [-118.35562, 33.99999], [-118.35552, 34.0001], [-118.35507, 33.99981], [-118.35523, 33.99961], [-118.35538, 33.99937], [-118.35616, 33.99787], [-118.35624, 33.99763], [-118.35627, 33.99744], [-118.35627, 33.99713], [-118.35625, 33.99705], [-118.35661, 33.997]]]} | Open Access 1 | 6300 | Ruben Ingold Parkway | 32500 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 3.496 | Ruben Ingold Parkway | 0 | Local Recreation Area 3 | 4 | |
14361 | 14361 | 14360 | {"type": "Polygon", "coordinates": [[[-118.06988, 33.99872], [-118.06952, 33.9999], [-118.06946, 33.99989], [-118.06895, 34.00172], [-118.06907, 33.9998], [-118.06853, 33.99908], [-118.06839, 33.99832], [-118.06841, 33.99817], [-118.06988, 33.99872]]]} | Open Access 1 | 44426 | Amigo Park | 32468 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 4.805 | Amigo Park | 0 | Local Park 2 | 4 | |
6595 | 6595 | 6594 | {"type": "Polygon", "coordinates": [[[-118.25395, 33.98347], [-118.25395, 33.98424], [-118.25222, 33.98424], [-118.25221, 33.98296], [-118.25369, 33.98295], [-118.25369, 33.98333], [-118.25356, 33.98334], [-118.25355, 33.98347], [-118.25395, 33.98347]]]} | Open Access 1 | 4396 | Mary M. Bethune Park | 32493 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 5.272 | Mary M. Bethune Park | 0 | Local Park 2 | 4 | |
12120 | 12120 | 12119 | {"type": "Polygon", "coordinates": [[[-117.88105, 33.97321], [-117.88105, 33.97363], [-117.88019, 33.97411], [-117.87969, 33.97351], [-117.87952, 33.97333], [-117.87924, 33.97313], [-117.87907, 33.97304], [-117.87886, 33.97296], [-117.8791, 33.97249], [-117.88026, 33.97249], [-117.88105, 33.97321]]]} | Open Access 1 | 25065 | Bill Blevins Park | 32455 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov | Los Angeles 6 | 5.317 | Bill Blevins Park | 0 | Local Park 2 | 4 |
1298 | 1298 | 1297 | {"type": "MultiPolygon", "coordinates": [[[[-118.63104, 34.48996], [-118.62998, 34.48997], [-118.63, 34.49077], [-118.6298, 34.49064], [-118.62911, 34.4906], [-118.62852, 34.49022], [-118.62868, 34.49003], [-118.62891, 34.48982], [-118.62916, 34.48964], [-118.62959, 34.48941], [-118.62992, 34.48929], [-118.62996, 34.48928], [-118.62997, 34.48932], [-118.63014, 34.48925], [-118.63046, 34.48916], [-118.63071, 34.4891], [-118.63102, 34.48905], [-118.63104, 34.48996]]], [[[-118.63006, 34.48904], [-118.63005, 34.48905], [-118.62996, 34.48909], [-118.62996, 34.48904], [-118.63006, 34.48904]]]]} | Open Access 1 | 7290 | Del Valle Park | 32472 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 5.473 | Del Valle Park | 0 | Local Park 2 | 4 | |
2419 | 2419 | 2418 | {"type": "Polygon", "coordinates": [[[-118.19323, 33.89597], [-118.19317, 33.89601], [-118.19241, 33.89603], [-118.19236, 33.896], [-118.19235, 33.89575], [-118.19232, 33.8957], [-118.19227, 33.89498], [-118.19219, 33.89361], [-118.19265, 33.8936], [-118.19265, 33.89352], [-118.19306, 33.89352], [-118.19315, 33.89475], [-118.19323, 33.89597]]]} | Open Access 1 | 6260 | East Rancho Dominguez Park | 32484 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 5.518 | East Rancho Dominguez Park | 0 | Local Park 2 | 4 | |
15075 | 15075 | 15074 | {"type": "MultiPolygon", "coordinates": [[[[-118.25097, 33.92044], [-118.25063, 33.92044], [-118.24952, 33.91637], [-118.24986, 33.91637], [-118.25097, 33.92044]]], [[[-118.25181, 33.92354], [-118.25148, 33.92354], [-118.25064, 33.92046], [-118.25098, 33.92046], [-118.25181, 33.92354]]]]} | Open Access 1 | 45854 | Compton Creek Walking Path | 32466 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 6.121 | Compton Creek Walking Path | 0 | Local Recreation Area 3 | 4 | |
4255 | 4255 | 4254 | {"type": "Polygon", "coordinates": [[[-117.90325, 33.97998], [-117.90158, 33.98014], [-117.90166, 33.97993], [-117.90157, 33.97938], [-117.90144, 33.97842], [-117.90299, 33.97827], [-117.90325, 33.97998]]]} | Open Access 1 | 14365 | Carolyn Rosas Park | 32479 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 6.897 | Carolyn Rosas Park | 0 | Local Park 2 | 4 | |
7136 | 7136 | 7135 | {"type": "Polygon", "coordinates": [[[-118.25168, 33.92627], [-118.25166, 33.92628], [-118.25155, 33.92629], [-118.24941, 33.92628], [-118.2494, 33.92627], [-118.24939, 33.92597], [-118.24941, 33.92501], [-118.25156, 33.92501], [-118.25156, 33.92543], [-118.25145, 33.92544], [-118.25168, 33.92627]]]} | Open Access 1 | 6232 | George Washington Carver Park | 32461 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 6.973 | George Washington Carver 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]);