units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
309 rows where AGNCY_ID = 1188, DES_TP = 2 and MNG_AGENCY = 24
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
ACCESS_TYP 3
- Open Access 289
- No Public Access 16
- Restricted Access 4
MNG_AG_TYP 1
- City Agency 309
MNG_AGENCY 1
- Los Angeles, City of · 309 ✖
DES_TP 1
- Local Park · 309 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44 | 44 | 43 | {"type": "Polygon", "coordinates": [[[-118.35044, 34.13077], [-118.35003, 34.13136], [-118.34933, 34.1306], [-118.3496, 34.13019], [-118.35044, 34.13077]]]} | Open Access 1 | 99 | El Paseo Cahuenga Park | 18526 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.546 | El Paseo Cahuenga Park | 0 | Local Park 2 | 4 | |
66 | 66 | 65 | {"type": "Polygon", "coordinates": [[[-118.24767, 33.99122], [-118.24568, 33.99122], [-118.24567, 33.98955], [-118.24762, 33.98955], [-118.24767, 33.99122]]]} | Open Access 1 | 190 | Augustus Hawkins Natural Park | 15707 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 8.369 | Augustus Hawkins Natural Park | 0 | Local Park 2 | 4 | |
95 | 95 | 94 | {"type": "Polygon", "coordinates": [[[-118.50316, 34.16163], [-118.50227, 34.16163], [-118.50228, 34.15971], [-118.50316, 34.15991], [-118.50316, 34.16163]]]} | Open Access 1 | 302 | Encino Park | 18668 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 4.067 | Encino Park | 0 | Local Park 2 | 4 | |
127 | 127 | 126 | {"type": "MultiPolygon", "coordinates": [[[[-118.41914, 34.18293], [-118.4191, 34.18296], [-118.41829, 34.18296], [-118.41826, 34.18294], [-118.41825, 34.1818], [-118.41911, 34.18181], [-118.41914, 34.18184], [-118.41914, 34.18293]]], [[[-118.42023, 34.18293], [-118.42019, 34.18296], [-118.41938, 34.18296], [-118.41935, 34.18294], [-118.41934, 34.18184], [-118.42023, 34.18184], [-118.42023, 34.18293]]]]} | Open Access 1 | 335 | Valley Glen Community Park | 26789 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 5.115 | Valley Glen Community Park | 0 | Local Park 2 | 4 | |
156 | 156 | 155 | {"type": "Polygon", "coordinates": [[[-118.27409, 34.2411], [-118.27374, 34.24114], [-118.2736, 34.24083], [-118.27329, 34.24038], [-118.2733, 34.24033], [-118.27334, 34.24031], [-118.27398, 34.2402], [-118.27404, 34.24086], [-118.27409, 34.2411]]]} | Open Access 1 | 494 | Fehlhaber-Houk Park | 28620 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/parks/facility/fehlhaberHoukPk.htm | Los Angeles 6 | 1.175 | Fehlhaber-Houk Park | 0 | Local Park 2 | 4 |
159 | 159 | 158 | {"type": "Polygon", "coordinates": [[[-118.24886, 34.06967], [-118.24887, 34.07033], [-118.24883, 34.07039], [-118.24876, 34.07043], [-118.24868, 34.07045], [-118.2486, 34.07043], [-118.24854, 34.0704], [-118.2485, 34.07035], [-118.24848, 34.07029], [-118.24848, 34.07024], [-118.24877, 34.06965], [-118.24882, 34.06963], [-118.24886, 34.06967]]]} | Open Access 1 | 405 | Everett Park | 18763 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.521 | Everett Park | 0 | Local Park 2 | 4 | |
319 | 319 | 318 | {"type": "Polygon", "coordinates": [[[-118.18189, 34.12005], [-118.18189, 34.12005], [-118.17889, 34.12008], [-118.1804, 34.11888], [-118.18088, 34.11808], [-118.18153, 34.11815], [-118.18189, 34.12005]]]} | Open Access 1 | 855 | Garvanza Park | 19226 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 8.274 | Garvanza Park | 0 | Local Park 2 | 4 | |
331 | 331 | 330 | {"type": "Polygon", "coordinates": [[[-118.36901, 34.03598], [-118.36855, 34.03714], [-118.36689, 34.03694], [-118.36745, 34.03546], [-118.36901, 34.03598]]]} | Open Access 1 | 908 | Genesee Avenue Park | 19255 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 5.852 | Genesee Avenue Park | 0 | Local Park 2 | 4 | |
449 | 449 | 448 | {"type": "Polygon", "coordinates": [[[-118.18446, 34.11514], [-118.1843, 34.11529], [-118.18412, 34.11522], [-118.1843, 34.11518], [-118.18446, 34.11514]]]} | Open Access 1 | 1807 | Highland Park | 19932 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.045 | Highland Park | 0 | Local Park 2 | 4 | |
493 | 493 | 492 | {"type": "Polygon", "coordinates": [[[-118.40813, 34.28144], [-118.40657, 34.28258], [-118.40505, 34.28116], [-118.40662, 34.28002], [-118.40813, 34.28144]]]} | Open Access 1 | 1998 | Hubert H. Humphrey Memorial Park | 20130 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 9.987 | Hubert H. Humphrey Memorial Park | 0 | Local Park 2 | 4 | |
511 | 511 | 510 | {"type": "Polygon", "coordinates": [[[-118.19601, 34.05796], [-118.19489, 34.05976], [-118.19436, 34.05954], [-118.19513, 34.0583], [-118.1952, 34.05834], [-118.19523, 34.05833], [-118.19532, 34.05836], [-118.19542, 34.05832], [-118.19563, 34.05796], [-118.19573, 34.058], [-118.19601, 34.05796]]]} | Open Access 1 | 1704 | Henry Alvarez Memorial Park | 19822 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.566 | Henry Alvarez Memorial Park | 0 | Local Park 2 | 4 | |
514 | 514 | 513 | {"type": "Polygon", "coordinates": [[[-118.29549, 34.09994], [-118.29552, 34.10008], [-118.29552, 34.10036], [-118.2955, 34.10049], [-118.29546, 34.10058], [-118.29538, 34.10069], [-118.29515, 34.10094], [-118.29543, 34.10117], [-118.29519, 34.10127], [-118.2953, 34.10134], [-118.2953, 34.10166], [-118.29326, 34.10167], [-118.29326, 34.10131], [-118.29305, 34.10119], [-118.29296, 34.10103], [-118.29294, 34.10094], [-118.29294, 34.10085], [-118.29299, 34.10075], [-118.29298, 34.09918], [-118.29357, 34.0992], [-118.29358, 34.09919], [-118.29391, 34.09915], [-118.29454, 34.09916], [-118.29462, 34.0992], [-118.29469, 34.09919], [-118.29473, 34.09923], [-118.29489, 34.09928], [-118.29489, 34.09935], [-118.29492, 34.09941], [-118.29518, 34.0996], [-118.29539, 34.09978], [-118.29549, 34.09994]]]} | Open Access 1 | 1713 | Barnsdall Park | 15825 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 14.293 | Barnsdall Park | 0 | Local Park 2 | 4 | |
546 | 546 | 545 | {"type": "Polygon", "coordinates": [[[-118.2789, 33.99551], [-118.27847, 33.99551], [-118.27847, 33.99538], [-118.27889, 33.99538], [-118.2789, 33.99551]]]} | Open Access 1 | 45788 | Broadway Park | 28807 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.146 | Broadway Park | 0 | Local Park 2 | 4 | |
640 | 640 | 639 | {"type": "Polygon", "coordinates": [[[-118.38183, 34.28065], [-118.38163, 34.2808], [-118.38181, 34.28097], [-118.38084, 34.28168], [-118.38011, 34.28099], [-118.38128, 34.28013], [-118.38183, 34.28065]]]} | Open Access 1 | 2675 | Kagel Canyon Park | 20542 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.465 | Kagel Canyon Park | 0 | Local Park 2 | 4 | |
659 | 659 | 658 | {"type": "MultiPolygon", "coordinates": [[[[-118.28551, 34.06276], [-118.28488, 34.06277], [-118.28427, 34.06357], [-118.28256, 34.0628], [-118.28336, 34.06157], [-118.28425, 34.06197], [-118.2855, 34.06197], [-118.28551, 34.06276]]], [[[-118.28408, 34.06152], [-118.28355, 34.06128], [-118.28407, 34.06049], [-118.28408, 34.06152], [-118.28408, 34.06152]]]]} | Open Access 1 | 3260 | Lafayette Park | 20832 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 9.08 | Lafayette Park | 0 | Local Park 2 | 4 | |
691 | 691 | 690 | {"type": "Polygon", "coordinates": [[[-118.18789, 34.13489], [-118.18738, 34.13556], [-118.18733, 34.13557], [-118.18727, 34.13555], [-118.18726, 34.13551], [-118.18778, 34.13483], [-118.18789, 34.13489]]]} | Open Access 1 | 3556 | Lanark/Shelby Park | 20998 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.274 | Lanark/Shelby Park | 0 | Local Park 2 | 4 | |
696 | 696 | 695 | {"type": "Polygon", "coordinates": [[[-118.6462, 34.21201], [-118.64612, 34.21245], [-118.64599, 34.21284], [-118.64584, 34.21312], [-118.6452, 34.21418], [-118.64505, 34.21455], [-118.64495, 34.21491], [-118.64489, 34.21494], [-118.6445, 34.21492], [-118.64449, 34.21195], [-118.64612, 34.21195], [-118.64617, 34.21197], [-118.6462, 34.21201]]]} | Open Access 1 | 3832 | Lazy J Ranch Park | 21122 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 8.44 | Lazy J Ranch Park | 0 | Local Park 2 | 4 | |
701 | 701 | 700 | {"type": "Polygon", "coordinates": [[[-118.33238, 34.00416], [-118.3308, 34.00412], [-118.3308, 34.00412], [-118.33091, 34.00377], [-118.33196, 34.00376], [-118.33238, 34.00416]]]} | Open Access 1 | 3898 | Leimert Park | 21145 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.262 | Leimert Park | 0 | Local Park 2 | 4 | |
712 | 712 | 711 | {"type": "Polygon", "coordinates": [[[-118.32015, 34.02603], [-118.31946, 34.02603], [-118.31946, 34.02567], [-118.32015, 34.02568], [-118.32015, 34.02603]]]} | Open Access 1 | 4016 | Leslie N. Shaw Park | 21179 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.627 | Leslie N. Shaw Park | 0 | Local Park 2 | 4 | |
730 | 730 | 729 | {"type": "Polygon", "coordinates": [[[-118.33247, 34.0566], [-118.33202, 34.05756], [-118.33104, 34.05732], [-118.33138, 34.05632], [-118.33247, 34.0566]]]} | Open Access 1 | 4724 | Los Angeles High Memorial Park | 21483 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.835 | Los Angeles High Memorial 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]);