units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2,921 rows where COUNTY = 6 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, GAP_STS
MNG_AGENCY >30
- Los Angeles, City of 491
- Mountains Recreation and Conservation Authority 336
- Los Angeles, County of 175
- Long Beach, City of 148
- Torrance, City of 73
- Los Angeles - Department of Parks and Recreation, County of 65
- Glendale, City of 61
- Santa Clarita, City of 51
- Whittier, City of 48
- Redondo Beach, City of 37
- Pasadena, City of 37
- Burbank, City of 34
- Santa Monica, City of 31
- Pomona, City of 30
- Palmdale, City of 30
- Mountains Restoration Trust 30
- Las Virgenes Municipal Water District 28
- United States National Park Service 27
- California Department of Parks and Recreation 26
- Azusa, City of 26
- La Verne, City of 26
- Rancho Palos Verdes, City of 25
- Claremont, City of 24
- Los Angeles County Flood Control District 23
- Arcadia, City of 23
- Cerritos, City of 22
- Hermosa Beach, City of 22
- South Pasadena, City of 22
- United States Army Corps of Engineers 21
- Beverly Hills, City of 21
- …
DES_TP >30
- Local Park 1,649
- Local Recreation Area 504
- Local Other or Unknown 221
- Local Conservation Area 86
- Private Recreation or Education 45
- Recreation Management Area 28
- Private Conservation 20
- National Recreation Area 20
- State Recreation Area 15
- Local Historic or Cultural Area 11
- State Park 10
- State Historic or Cultural Area 6
- State Conservation Area 5
- National Forest 4
- Resource Management Area 4
- Private Historic or Cultural 4
- State Other or Unknown 3
- National Public Lands 2
- Conservation Area 2
- State Resource Management Area 2
- Federal Other or Unknown 2
- None 1
- None 1
- None 1
- None 1
- National Monument or Landmark 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 26
- City Agency 1,983
- Open Space District 336
- County Agency 175
- County Agency - Parks 65
- Federal Agency 61
- State Agency 55
- Non Profit - Conservation 35
- Water District 33
- School District 33
- Irrigation District 27
- Flood District 23
- Non Profit - Land Trust 22
- Recreation/Parks District 15
- Non Profit - Other 10
- County Agency - Other 7
- Cemetery District 6
- Port/Harbor District 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Commercial 4
- Sanitation District 4
- Home Owners Association 3
- Other 3
- Special District - Other 2
- Non Profit - Education 2
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 2,326
- Restricted Access 244
- No Public Access 202
- Unknown Access 149
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
999 | 999 | 998 | {"type": "Polygon", "coordinates": [[[-118.24932, 33.93589], [-118.24931, 33.93673], [-118.24783, 33.93674], [-118.24784, 33.93589], [-118.24932, 33.93589]]]} | Open Access 1 | 6218 | 109th Street Recreation Center | 15168 | 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.184 | 109th Street Rec. Ctr. | 0 | Local Recreation Area 3 | 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 |
4371 | 4371 | 4370 | {"type": "MultiPolygon", "coordinates": [[[[-118.24124, 33.92765], [-118.24116, 33.9276], [-118.24085, 33.92733], [-118.24124, 33.92733], [-118.24124, 33.92765]]], [[[-118.24433, 33.92779], [-118.24433, 33.92814], [-118.24389, 33.92811], [-118.2427, 33.92796], [-118.24172, 33.92781], [-118.24433, 33.92779]]], [[[-118.24465, 33.92779], [-118.24465, 33.92817], [-118.24449, 33.92815], [-118.24449, 33.92779], [-118.24465, 33.92779]]], [[[-118.24611, 33.9282], [-118.24572, 33.9282], [-118.24571, 33.92817], [-118.24482, 33.92817], [-118.24482, 33.92779], [-118.24607, 33.92779], [-118.24611, 33.92784], [-118.24611, 33.9282]]]]} | Unknown Access 4 | 45850 | 117th and Compton | 28898 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 2.884 | 117th and Compton | None 387 | |||
8163 | 8163 | 8162 | {"type": "Polygon", "coordinates": [[[-118.34102, 33.92741], [-118.34102, 33.92741], [-118.34058, 33.92712], [-118.34101, 33.92713], [-118.34102, 33.92741]]]} | Open Access 1 | 46481 | 118th Street Mini Park | 29761 | 1130 | Hawthorne, City of 299 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | Los Angeles 6 | 0.154 | 118th Street MP | 0 | Local Park 2 | 4 | |
4363 | 4363 | 4362 | {"type": "Polygon", "coordinates": [[[-118.32926, 33.98393], [-118.32926, 33.98408], [-118.32896, 33.98418], [-118.32863, 33.98434], [-118.32863, 33.98418], [-118.3287, 33.98418], [-118.32926, 33.98393]]]} | Open Access 1 | 45774 | 11th Avenue Park | 28781 | 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#11th | Los Angeles 6 | 0.207 | 11th Avenue Park | 0 | Local Park 2 | 4 |
7327 | 7327 | 7326 | {"type": "MultiPolygon", "coordinates": [[[[-118.19093, 33.78373], [-118.19093, 33.78389], [-118.19012, 33.78389], [-118.19012, 33.78373], [-118.19093, 33.78373]]], [[[-118.19225, 33.78389], [-118.1912, 33.78389], [-118.1912, 33.78373], [-118.19225, 33.78373], [-118.19225, 33.78389]]], [[[-118.19492, 33.78372], [-118.19492, 33.78389], [-118.19388, 33.78389], [-118.19388, 33.78372], [-118.19492, 33.78372]]], [[[-118.19623, 33.78372], [-118.19623, 33.78389], [-118.19519, 33.78389], [-118.19519, 33.78372], [-118.19623, 33.78372]]]]} | Open Access 1 | 6641 | 14th Street Park and Playground | 15173 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.661 | 14th Street Park and Playground | 0 | Local Recreation Area 3 | 4 | |
17044 | 17044 | 17043 | {"type": "Polygon", "coordinates": [[[-118.24477, 34.05427], [-118.24461, 34.05444], [-118.24459, 34.05443], [-118.24454, 34.05449], [-118.24455, 34.05451], [-118.24403, 34.05507], [-118.2432, 34.05453], [-118.24394, 34.05373], [-118.24477, 34.05427]]]} | Open Access 1 | 45773 | 1st and Broadway Civic Center Park | 29093 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | Los Angeles 6 | 2.682 | 1st and Broadway Civic Ctr. Park | 0 | Local Park 2 | 4 | |
2391 | 2391 | 2390 | {"type": "Polygon", "coordinates": [[[-118.20432, 33.79536], [-118.20431, 33.79659], [-118.20427, 33.79663], [-118.20404, 33.79662], [-118.20404, 33.79554], [-118.20398, 33.79553], [-118.20397, 33.79536], [-118.20432, 33.79536]]]} | Open Access 1 | 45873 | 21st to Hill Mini Park | 28944 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://longbeach.granicus.com/MediaPlayer.php?view_id=12&clip_id=4470 | Los Angeles 6 | 0.91 | 21st to Hill MP | 0 | Local Park 2 | 4 |
7015 | 7015 | 7014 | {"type": "Polygon", "coordinates": [[[-118.28389, 33.72397], [-118.28434, 33.72394], [-118.28451, 33.72426], [-118.28467, 33.72499], [-118.28458, 33.72533], [-118.2844, 33.72593], [-118.28373, 33.7268], [-118.28244, 33.72785], [-118.28077, 33.72872], [-118.28047, 33.72883], [-118.28046, 33.72831], [-118.28107, 33.728], [-118.28046, 33.72628], [-118.28046, 33.72509], [-118.28209, 33.72464], [-118.28381, 33.72421], [-118.28389, 33.72419], [-118.28392, 33.72412], [-118.28389, 33.72397]]]} | Open Access 1 | 5957 | 22nd Street Landing | 15183 | 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 | 30.559 | 22nd Street Landing | 0 | None 574 | ||
15381 | 15381 | 15380 | {"type": "Polygon", "coordinates": [[[-118.20463, 33.81903], [-118.20462, 33.81984], [-118.20458, 33.82011], [-118.20441, 33.82001], [-118.20429, 33.81989], [-118.20428, 33.81985], [-118.20429, 33.81892], [-118.20458, 33.81893], [-118.20463, 33.81903]]]} | Open Access 1 | 46593 | 34th St Greenbelt | 29894 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.928 | 34th St Greenbelt | 2007 | Local Recreation Area 3 | 4 | |
5715 | 5715 | 5714 | {"type": "Polygon", "coordinates": [[[-118.2636, 33.99857], [-118.26343, 33.99857], [-118.26343, 33.99811], [-118.2636, 33.99811], [-118.2636, 33.99857]]]} | Open Access 1 | 45781 | 49th Street Pocket Park | 28800 | 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/49thStPark.htm | Los Angeles 6 | 0.189 | 49th Street PP | 0 | Local Park 2 | 4 |
13964 | 13964 | 13963 | {"type": "Polygon", "coordinates": [[[-118.32431, 34.18417], [-118.32398, 34.1841], [-118.32369, 34.18399], [-118.32355, 34.18389], [-118.32353, 34.18384], [-118.32354, 34.18379], [-118.3236, 34.18374], [-118.32402, 34.1836], [-118.32431, 34.18417]]]} | Open Access 1 | 36624 | 5 Points Art Monument | 28590 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 0.597 | 5 Points Art Monument | None 1195 | |||
971 | 971 | 970 | {"type": "Polygon", "coordinates": [[[-118.20138, 33.84854], [-118.20124, 33.85039], [-118.20107, 33.85039], [-118.20104, 33.85032], [-118.20116, 33.84873], [-118.20105, 33.84872], [-118.20105, 33.84854], [-118.20138, 33.84854]]]} | Open Access 1 | 6612 | 51st St Greenbelt | 29907 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.011 | 51st St Greenbelt | 2008 | Local Recreation Area 3 | 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 | |
15209 | 15209 | 15208 | {"type": "Polygon", "coordinates": [[[-118.00477, 34.57499], [-118.0027, 34.57501], [-118.0027, 34.57318], [-118.00476, 34.57316], [-118.00477, 34.57499]]]} | Open Access 1 | 46097 | 70TH ST EAST & North of AVENUE R | 29446 | 1242 | Palmdale, City of 205 | City 2 | City Agency 2 | http://www.cityofpalmdale.org/Residents/Recreation-and-Culture | City 2 | 1242 | Palmdale, City of 201 | City 2 | City Agency 2 | Los Angeles 6 | 9.525 | 70TH ST EAST & North of AVENUE R | None 1330 | |||
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 |
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 |
2212 | 2212 | 2211 | {"type": "Polygon", "coordinates": [[[-118.38166, 33.88367], [-118.38133, 33.88367], [-118.38133, 33.88325], [-118.38166, 33.88326], [-118.38166, 33.88367]]]} | Open Access 1 | 6131 | 8th Street Parkette | 15220 | 1194 | Manhattan Beach, City of 495 | City 2 | City Agency 2 | http://www.ci.manhattan-beach.ca.us/city-services/parks-and-recreation | City 2 | 1194 | Manhattan Beach, City of 486 | City 2 | City Agency 2 | Los Angeles 6 | 0.347 | 8th Street Parkette | 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 |
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]);