units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
491 rows where MNG_AGENCY = 24 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP >30
- Local Park 303
- Local Recreation Area 115
- Local Other or Unknown 19
- Local Conservation Area 4
- National Forest 1
- Local Historic or Cultural Area 1
- None 1
- Local Resource Management Area 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
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 414
- No Public Access 34
- Restricted Access 20
- Unknown Access 3
MNG_AG_TYP 1
- City Agency 471
MNG_AGENCY 1
- Los Angeles, City of · 471 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
7138 | 7138 | 7137 | {"type": "Polygon", "coordinates": [[[-118.24127, 33.93867], [-118.24126, 33.93886], [-118.24082, 33.93867], [-118.24091, 33.93867], [-118.24127, 33.93867]]]} | Open Access 1 | 6221 | Watts Towers of Simon Rodia State Historic Park | 30713 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.109 | Watts Towers of Simon Rodia SHP | 1978 | None 584 | ||
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 | |
4370 | 4370 | 4369 | {"type": "Polygon", "coordinates": [[[-118.47207, 33.99034], [-118.47192, 33.99044], [-118.47173, 33.99025], [-118.47189, 33.99014], [-118.47207, 33.99034]]]} | Unknown Access 4 | 45826 | San Juan Garage | 28845 | 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.124 | San Juan Garage | None 386 | |||
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 | |
15072 | 15072 | 15071 | {"type": "Polygon", "coordinates": [[[-118.25693, 34.0028], [-118.25661, 34.0028], [-118.25661, 34.00258], [-118.2567, 34.00258], [-118.25674, 34.00268], [-118.25687, 34.00265], [-118.25693, 34.0028]]]} | Open Access 1 | 45837 | Vernon Library Pocket Park | 28857 | 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://eng.lacity.org/docs/dpw/bids/E170940F.pdf | Los Angeles 6 | 0.126 | Vernon Library PP | 0 | Local Park 2 | 4 |
3875 | 3875 | 3874 | {"type": "Polygon", "coordinates": [[[-118.28833, 33.97082], [-118.28833, 33.9712], [-118.2882, 33.9712], [-118.2882, 33.97082], [-118.28833, 33.97082]]]} | Open Access 1 | 45783 | 76th Street Pocket Park | 28802 | 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.lanlt.org/parks-and-gardens.php#76th | Los Angeles 6 | 0.128 | 76th Street PP | 0 | Local Park 2 | 4 |
14867 | 14867 | 14866 | {"type": "Polygon", "coordinates": [[[-118.28476, 33.94818], [-118.28463, 33.94818], [-118.28463, 33.9478], [-118.28476, 33.9478], [-118.28476, 33.94818]]]} | Open Access 1 | 45784 | 97th Street Pocket Park | 28803 | 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.128 | 97th Street PP | 0 | Local Park 2 | 4 | |
2462 | 2462 | 2461 | {"type": "Polygon", "coordinates": [[[-118.35722, 34.10552], [-118.35702, 34.10564], [-118.35703, 34.10532], [-118.35722, 34.10533], [-118.35722, 34.10552]]]} | No Public Access 3 | 12466 | Los Angeles Department of Water and Power | 21482 | 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.129 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
1027 | 1027 | 1026 | {"type": "Polygon", "coordinates": [[[-118.46676, 33.98488], [-118.4666, 33.98497], [-118.46642, 33.98477], [-118.46658, 33.98467], [-118.46676, 33.98488]]]} | Open Access 1 | 6327 | Canal Park | 16796 | 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.131 | Canal Park | 0 | Local Park 2 | 4 | |
7123 | 7123 | 7122 | {"type": "Polygon", "coordinates": [[[-118.24813, 33.79292], [-118.24798, 33.79293], [-118.24796, 33.79259], [-118.24811, 33.79258], [-118.24813, 33.79292]]]} | Open Access 1 | 6194 | East Wilmington Vest Pocket Park | 18386 | 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.132 | East Wilmington Vest PP | 0 | Local Park 2 | 4 | |
5700 | 5700 | 5699 | {"type": "Polygon", "coordinates": [[[-118.41819, 34.25299], [-118.41809, 34.25306], [-118.41777, 34.25275], [-118.41787, 34.25268], [-118.41819, 34.25299]]]} | Open Access 1 | 45739 | Amistad Park | 28743 | 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.138 | Amistad Park | 0 | Local Park 2 | 4 | |
17068 | 17068 | 17067 | {"type": "Polygon", "coordinates": [[[-118.41271, 34.21563], [-118.41251, 34.21562], [-118.41224, 34.21561], [-118.41271, 34.21543], [-118.41278, 34.21558], [-118.41276, 34.21562], [-118.41271, 34.21563]]]} | Open Access 1 | 45531 | Bellaire Avenue Pocket Park | 28362 | 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://cd2.lacity.org/DISTRICT2/CD2Resources/index.htm | Los Angeles 6 | 0.138 | Bellaire Avenue PP | 0 | Local Park 2 | 4 |
15064 | 15064 | 15063 | {"type": "Polygon", "coordinates": [[[-118.28888, 34.00161], [-118.28837, 34.00161], [-118.28837, 34.0015], [-118.28888, 34.0015], [-118.28888, 34.00161]]]} | Open Access 1 | 45822 | Orchard Avenue Pocket Park | 28841 | 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/outdoorFitness.htm | Los Angeles 6 | 0.141 | Orchard Avenue 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]);