units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where DES_TP = 2, MNG_AGENCY = 273 and MNG_AG_LEV = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL
MNG_AG_TYP 1
MNG_AGENCY 1
- Los Angeles - Department of Parks and Recreation, County of · 44 ✖
DES_TP 1
- Local Park · 44 ✖
ACCESS_TYP 1
- Open Access 44
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 | |
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 |
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 | |
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 | |
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 | |
1318 | 1318 | 1317 | {"type": "Polygon", "coordinates": [[[-118.19118, 34.02197], [-118.19118, 34.02211], [-118.19106, 34.02258], [-118.19107, 34.02339], [-118.19103, 34.0234], [-118.19104, 34.02342], [-118.19107, 34.02342], [-118.19107, 34.02376], [-118.19106, 34.02379], [-118.19101, 34.02381], [-118.1894, 34.02381], [-118.18936, 34.0238], [-118.18935, 34.02377], [-118.18934, 34.02201], [-118.19019, 34.02199], [-118.19018, 34.02203], [-118.19012, 34.02208], [-118.19011, 34.02214], [-118.19014, 34.0222], [-118.19022, 34.02222], [-118.19028, 34.02221], [-118.19032, 34.02217], [-118.19033, 34.02199], [-118.19118, 34.02197]]]} | Open Access 1 | 10714 | Ruben F. Salazar Park | 32499 | 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 | 7.928 | Ruben F. Salazar Park | 0 | Local Park 2 | 4 | |
7110 | 7110 | 7109 | {"type": "Polygon", "coordinates": [[[-118.37652, 33.91718], [-118.37652, 33.91844], [-118.37531, 33.91844], [-118.37531, 33.9191], [-118.37445, 33.9191], [-118.37445, 33.91718], [-118.37652, 33.91718]]]} | Open Access 1 | 6186 | Del Aire Park | 32481 | 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 | 8.059 | Del Aire Park | 0 | Local Park 2 | 4 | |
11926 | 11926 | 11925 | {"type": "Polygon", "coordinates": [[[-117.98939, 34.03587], [-117.98835, 34.03691], [-117.98681, 34.03585], [-117.98694, 34.0357], [-117.98631, 34.03527], [-117.98645, 34.03513], [-117.98709, 34.03556], [-117.98778, 34.03487], [-117.98818, 34.03514], [-117.9886, 34.03472], [-117.98924, 34.03517], [-117.98891, 34.03551], [-117.98916, 34.03568], [-117.98915, 34.0357], [-117.98939, 34.03587]]]} | Open Access 1 | 24531 | Avocado Heights Park | 32469 | 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 | 8.15 | Avocado Heights Park | 0 | Local Park 2 | 4 | |
14200 | 14200 | 14199 | {"type": "Polygon", "coordinates": [[[-117.97406, 34.57248], [-117.974, 34.57419], [-117.97185, 34.57418], [-117.97192, 34.57247], [-117.97406, 34.57248]]]} | Open Access 1 | 44051 | Jackie Robinson Park | 32458 | 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 | 9.226 | Jackie Robinson Park | 0 | Local Park 2 | 4 |
1102 | 1102 | 1101 | {"type": "Polygon", "coordinates": [[[-117.9216, 34.03221], [-117.92061, 34.0323], [-117.92052, 34.03227], [-117.92007, 34.03231], [-117.91957, 34.03233], [-117.91955, 34.03229], [-117.91964, 34.0311], [-117.91978, 34.03062], [-117.91984, 34.03031], [-117.9202, 34.03031], [-117.92158, 34.03021], [-117.92152, 34.03167], [-117.9216, 34.03221]]]} | Open Access 1 | 7055 | Rimgrove Park | 32498 | 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 | 9.626 | Rimgrove Park | 0 | Local Park 2 | 4 | |
1500 | 1500 | 1499 | {"type": "Polygon", "coordinates": [[[-117.88084, 33.98997], [-117.87854, 33.99011], [-117.87879, 33.9878], [-117.88042, 33.9879], [-117.88032, 33.98876], [-117.88034, 33.98896], [-117.88037, 33.98907], [-117.88043, 33.98918], [-117.88078, 33.98962], [-117.88084, 33.98979], [-117.88084, 33.98997]]]} | Open Access 1 | 10511 | Rowland Heights Park | 32462 | 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 | 10.174 | Rowland Heights 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]);