units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
314 rows where DES_TP = 2, MNG_AGENCY = 24 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
ACCESS_TYP 3
- Open Access 291
- No Public Access 16
- Restricted Access 7
MNG_AG_TYP 1
- City Agency · 314 ✖
MNG_AGENCY 1
- Los Angeles, City of · 314 ✖
DES_TP 1
- Local Park · 314 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5497 | 5497 | 5496 | {"type": "Polygon", "coordinates": [[[-118.39276, 34.11874], [-118.39267, 34.11881], [-118.3926, 34.11875], [-118.39271, 34.11867], [-118.39276, 34.11874]]]} | No Public Access 3 | 12821 | Los Angeles City Water Resource Parkland | 21477 | 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.028 | Los Angeles City Water Resource Parkland | 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 | |
2878 | 2878 | 2877 | {"type": "Polygon", "coordinates": [[[-118.31233, 34.03401], [-118.31231, 34.03394], [-118.31235, 34.03388], [-118.31242, 34.03384], [-118.31252, 34.03386], [-118.31252, 34.03389], [-118.31239, 34.03402], [-118.31236, 34.03402], [-118.31233, 34.03401]]]} | Open Access 1 | 18875 | Gramercy Park | 29322 | 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.056 | Gramercy Park | 0 | Local Park 2 | 4 | |
15414 | 15414 | 15413 | {"type": "Polygon", "coordinates": [[[-118.36138, 34.08051], [-118.36127, 34.08051], [-118.36128, 34.08027], [-118.36137, 34.08028], [-118.36138, 34.08051]]]} | Open Access 1 | 46642 | Rosewood Gardens Park | 29970 | 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.06 | Rosewood Gardens Park | 0 | Local Park 2 | 4 | |
4018 | 4018 | 4017 | {"type": "Polygon", "coordinates": [[[-118.43109, 34.19476], [-118.43107, 34.19479], [-118.43103, 34.19481], [-118.4306, 34.19481], [-118.4306, 34.19476], [-118.43109, 34.19476]]]} | Open Access 1 | 1478 | Hartland Mini Park | 19710 | 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.065 | Hartland MP | 0 | Local Park 2 | 4 | |
4340 | 4340 | 4339 | {"type": "Polygon", "coordinates": [[[-118.53693, 34.27607], [-118.53692, 34.27621], [-118.53659, 34.27619], [-118.5366, 34.27615], [-118.53663, 34.27612], [-118.53693, 34.27607]]]} | Open Access 1 | 45525 | Rinaldi Park | 28359 | 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.082 | Rinaldi Park | 0 | Local Park 2 | 4 | |
4826 | 4826 | 4825 | {"type": "Polygon", "coordinates": [[[-118.31504, 34.05232], [-118.31497, 34.05239], [-118.31494, 34.05241], [-118.31469, 34.05242], [-118.31465, 34.0524], [-118.31463, 34.05237], [-118.31463, 34.05232], [-118.31504, 34.05232]]]} | Open Access 1 | 45733 | Wilton Place Park | 28736 | 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.082 | Wilton Place Park | 0 | Local Park 2 | 4 | |
9070 | 9070 | 9069 | {"type": "Polygon", "coordinates": [[[-118.21233, 34.04451], [-118.21222, 34.04468], [-118.2119, 34.04453], [-118.21233, 34.04451], [-118.21233, 34.04451]]]} | Open Access 1 | 15012 | Ross Valencia Community Park | 28733 | 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/laniVestPocketPk.htm | Los Angeles 6 | 0.088 | Ross Valencia Community Park | 0 | Local Park 2 | 4 |
14704 | 14704 | 14703 | {"type": "Polygon", "coordinates": [[[-118.30056, 34.0395], [-118.30046, 34.0395], [-118.30046, 34.03918], [-118.30049, 34.03915], [-118.30055, 34.03915], [-118.30056, 34.0395]]]} | Open Access 1 | 45059 | West Adams Heights Park | 32572 | 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 | https://www.laparks.org/park/west-adams-heights-park | Los Angeles 6 | 0.088 | West Adams Heights Park | 2014 | Local Park 2 | 4 |
4223 | 4223 | 4222 | {"type": "Polygon", "coordinates": [[[-118.2713, 33.93401], [-118.2713, 33.93437], [-118.2712, 33.93437], [-118.2712, 33.93401], [-118.2713, 33.93401]]]} | Open Access 1 | 45017 | 111th Place Neighborhood Park | 27920 | 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/environmental/pdf/111thPark.pdf | Los Angeles 6 | 0.09 | 111th Place Neighborhood Park | 0 | Local Park 2 | 4 |
7175 | 7175 | 7174 | {"type": "Polygon", "coordinates": [[[-118.4562, 33.98757], [-118.45619, 33.98741], [-118.45652, 33.98749], [-118.45654, 33.98752], [-118.45652, 33.98755], [-118.4562, 33.98757]]]} | Open Access 1 | 6336 | Triangle Park | 26531 | 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/trianglePk.htm | Los Angeles 6 | 0.09 | Triangle Park | 0 | Local Park 2 | 4 |
6532 | 6532 | 6531 | {"type": "Polygon", "coordinates": [[[-118.42634, 34.19022], [-118.42593, 34.19022], [-118.4259, 34.19019], [-118.42589, 34.19014], [-118.42634, 34.19014], [-118.42634, 34.19022]]]} | Open Access 1 | 2916 | Kittridge Mini Park | 20680 | 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.091 | Kittridge MP | 0 | Local Park 2 | 4 | |
5695 | 5695 | 5694 | {"type": "Polygon", "coordinates": [[[-118.27159, 33.95943], [-118.27159, 33.95959], [-118.27132, 33.95959], [-118.27132, 33.95944], [-118.27159, 33.95943]]]} | Open Access 1 | 45734 | Wall Street Community Park | 28737 | 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.102 | Wall Street Community Park | 0 | Local Park 2 | 4 | |
4367 | 4367 | 4366 | {"type": "Polygon", "coordinates": [[[-118.53738, 34.16715], [-118.53715, 34.16715], [-118.53732, 34.16686], [-118.53734, 34.16685], [-118.53738, 34.16687], [-118.53738, 34.16715]]]} | Open Access 1 | 45811 | Mecca Avenue Park | 28831 | 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/meccaAvePk.htm | Los Angeles 6 | 0.103 | Mecca Avenue Park | 0 | Local Park 2 | 4 |
16577 | 16577 | 16576 | {"type": "Polygon", "coordinates": [[[-118.26074, 33.99884], [-118.26054, 33.99884], [-118.26054, 33.99864], [-118.26074, 33.99864], [-118.26074, 33.99884]]]} | Open Access 1 | 45740 | McKinley Avenue Pocket Park | 28744 | 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.105 | McKinley Avenue PP | 0 | Local Park 2 | 4 | |
4358 | 4358 | 4357 | {"type": "Polygon", "coordinates": [[[-118.2853, 33.94082], [-118.2853, 33.94114], [-118.28516, 33.94114], [-118.28516, 33.94082], [-118.2853, 33.94082]]]} | Open Access 1 | 45731 | 105th Street Pocket Park | 28734 | 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/environmental/105th.htm | Los Angeles 6 | 0.111 | 105th Street PP | 0 | Local Park 2 | 4 |
7141 | 7141 | 7140 | {"type": "Polygon", "coordinates": [[[-118.23684, 33.93818], [-118.23642, 33.93819], [-118.23642, 33.93808], [-118.23684, 33.93808], [-118.23684, 33.93818]]]} | Open Access 1 | 6227 | Grape Street Pocket Park | 19447 | 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.116 | Grape Street PP | 0 | Local Park 2 | 4 | |
5390 | 5390 | 5389 | {"type": "Polygon", "coordinates": [[[-118.27253, 33.98433], [-118.27253, 33.98468], [-118.2724, 33.98468], [-118.2724, 33.98433], [-118.27253, 33.98433]]]} | Open Access 1 | 45782 | 61st Street Pocket Park | 28801 | 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.118 | 61st Street PP | 0 | Local Park 2 | 4 | |
7192 | 7192 | 7191 | {"type": "Polygon", "coordinates": [[[-118.53705, 34.04425], [-118.53705, 34.04425], [-118.53673, 34.04434], [-118.53687, 34.04401], [-118.53705, 34.04425]]]} | Open Access 1 | 6344 | Aiglon Plaza | 15299 | 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.12 | Aiglon Plaza | 0 | Local Park 2 | 4 | |
11917 | 11917 | 11916 | {"type": "Polygon", "coordinates": [[[-118.32874, 34.04001], [-118.32859, 34.04032], [-118.32844, 34.04027], [-118.32856, 34.04001], [-118.32874, 34.04001]]]} | Open Access 1 | 24518 | Washington Irvin Pocket Park | 27269 | 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.126 | Washington Irvin PP | 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]);