units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by map
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 314
- San Jose, City of 218
- San Francisco, City and County of 215
- Mountains Recreation and Conservation Authority 204
- California Department of Fish and Wildlife 197
- Sacramento, City of 195
- California Department of Parks and Recreation 159
- Ventura, City of 148
- Roseville, City of 114
- Oakland, City of 109
- East Bay Regional Park District 109
- Consumnes Community Services District 93
- Fresno, City of 91
- Santa Barbara, County of 89
- Santa Rosa, City of 80
- Hayward Area Recreation and Park District 79
- Stockton, City of 78
- Modesto, City of 75
- Napa, City of 74
- Los Angeles, County of 71
- Torrance, City of 69
- Tracy, City of 68
- Brentwood, City of 67
- Santa Cruz, City of 58
- San Luis Obispo, City of 58
- San Ramon, City of 58
- Bakersfield, City of 56
- Manteca, City of 56
- Fremont, City of 53
- Clovis, City of 53
- …
DES_TP >30
- Local Park 5,515
- Local Recreation Area 947
- Local Other or Unknown 820
- Private Conservation 362
- Local Conservation Area 220
- State Conservation Area 139
- State Park 88
- Local Historic or Cultural Area 88
- State Recreation Area 76
- State Resource Management Area 62
- Private Recreation or Education 62
- Recreation Management Area 36
- State Other or Unknown 33
- State Historic or Cultural Area 30
- National Wildlife Refuge 26
- National Recreation Area 22
- National Forest 19
- Federal Other or Unknown 15
- National Public Lands 12
- Private Agricultural 11
- Private Other or Unknown 11
- Local Resource Management Area 10
- Resource Management Area 9
- National Monument or Landmark 7
- Conservation Area 5
- National Park 5
- Historic or Cultural Area 4
- Area of Critical Environmental Concern 3
- None 1
- None 1
- …
COUNTY >30 ✖
- Los Angeles 1,202
- Sacramento 621
- Alameda 573
- Santa Clara 537
- Contra Costa 505
- Ventura 470
- San Mateo 361
- Sonoma 337
- Monterey 322
- San Joaquin 313
- Fresno 308
- Santa Barbara 302
- Placer 274
- Marin 257
- San Francisco 238
- Stanislaus 237
- Santa Cruz 230
- Solano 204
- Napa 198
- San Luis Obispo 177
- Kern 170
- Yolo 145
- Tulare 139
- Merced 136
- Butte 132
- Humboldt 128
- El Dorado 121
- Yuba 102
- Shasta 82
- Mendocino 71
- …
MNG_AG_TYP 28
- City Agency 5,903
- Recreation/Parks District 822
- County Agency 704
- State Agency 500
- Non Profit - Land Trust 342
- Open Space District 240
- Federal Agency 181
- Community Services District 170
- Water District 139
- County Agency - Parks 136
- Non Profit - Conservation 85
- Flood District 75
- Cemetery District 55
- Non Profit - Other 21
- County Agency - Other 19
- School District 18
- Port/Harbor District 13
- Home Owners Association 11
- Irrigation District 11
- Special District - Other 10
- Sanitation District 6
- Joint Powers Authority 6
- Commercial 4
- Mitigation Bank 3
- Other 2
- Airport District 1
- Non Profit - Cemetery District 1
- Home Owners Associatin 1
ACCESS_TYP 4
- Open Access 8,219
- Restricted Access 518
- No Public Access 508
- Unknown Access 234
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6896 | 6896 | 6895 | {"type": "Polygon", "coordinates": [[[-118.26651, 34.14003], [-118.26593, 34.14003], [-118.26583, 34.13988], [-118.26593, 34.1398], [-118.26577, 34.13959], [-118.26554, 34.1394], [-118.26554, 34.13885], [-118.26557, 34.13885], [-118.2656, 34.13883], [-118.2665, 34.13883], [-118.26651, 34.14003]]]} | Open Access 1 | 5742 | Pacific Park | 23302 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 2.515 | Pacific Park | 0 | Local Park 2 | 4 | |
8277 | 8277 | 8276 | {"type": "Polygon", "coordinates": [[[-118.26691, 34.09233], [-118.26691, 34.09236], [-118.26676, 34.09258], [-118.2656, 34.09211], [-118.26575, 34.09207], [-118.26597, 34.09195], [-118.26602, 34.09195], [-118.26688, 34.09229], [-118.26691, 34.09233]]]} | Open Access 1 | 12659 | Silver Lake Recreation Center | 25488 | 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.877 | Silver Lake Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
1830 | 1830 | 1829 | {"type": "Polygon", "coordinates": [[[-118.26701, 34.13428], [-118.26655, 34.13428], [-118.26622, 34.13352], [-118.26699, 34.13353], [-118.26701, 34.13428]]]} | Open Access 1 | 15711 | Chevy Chase Park | 17187 | 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.18 | Chevy Chase Park | 0 | Local Park 2 | 4 | |
7543 | 7543 | 7542 | {"type": "Polygon", "coordinates": [[[-118.26713, 34.15245], [-118.26713, 34.15277], [-118.2668, 34.15277], [-118.2668, 34.15246], [-118.26713, 34.15245]]]} | Open Access 1 | 20649 | Milford Mini Park | 22221 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.264 | Milford MP | 0 | Local Park 2 | 4 | |
8271 | 8271 | 8270 | {"type": "Polygon", "coordinates": [[[-118.26732, 34.09326], [-118.26728, 34.09328], [-118.26706, 34.09327], [-118.26693, 34.09329], [-118.26678, 34.09335], [-118.26666, 34.09344], [-118.26648, 34.09369], [-118.26625, 34.09394], [-118.26615, 34.0941], [-118.26608, 34.09428], [-118.26604, 34.09456], [-118.26599, 34.09467], [-118.26588, 34.0948], [-118.26568, 34.09491], [-118.2656, 34.09498], [-118.26552, 34.09509], [-118.26549, 34.09521], [-118.26551, 34.09537], [-118.26555, 34.09546], [-118.26562, 34.09553], [-118.26574, 34.09561], [-118.26592, 34.09568], [-118.26592, 34.09572], [-118.266, 34.09572], [-118.2661, 34.09577], [-118.26628, 34.09592], [-118.26639, 34.0961], [-118.26644, 34.09629], [-118.26645, 34.1041], [-118.26392, 34.1041], [-118.26111, 34.10034], [-118.26118, 34.10018], [-118.26119, 34.10003], [-118.2614, 34.09995], [-118.26172, 34.09933], [-118.26178, 34.09924], [-118.26189, 34.09916], [-118.26213, 34.09908], [-118.26229, 34.09907], [-118.2627, 34.09926], [-118.26271, 34.09926], [-118.26209, 34.09818], [-118.26187, 34.09749], [-118.26183, 34.09659], [-118.26229, 34.09573], [-118.26228, 34.09572], [-118.262, 34.09572], [-118.26233, 34.09515], [-118.26246, 34.09497], [-118.26262, 34.0948], [-118.2633, 34.09419], [-118.26345, 34.09402], [-118.26357, 34.09385], [-118.26372, 34.09356], [-118.2638, 34.09327], [-118.26383, 34.093], [-118.2638, 34.09263], [-118.26381, 34.09255], [-118.26402, 34.09221], [-118.26412, 34.09212], [-118.26425, 34.09204], [-118.26445, 34.09198], [-118.26462, 34.09197], [-118.26478, 34.092], [-118.26503, 34.09209], [-118.26517, 34.09212], [-118.26539, 34.09214], [-118.26559, 34.09211], [-118.26636, 34.09242], [-118.26676, 34.09258], [-118.26671, 34.09269], [-118.26672, 34.09272], [-118.26675, 34.09275], [-118.26741, 34.09302], [-118.26743, 34.09306], [-118.26743, 34.09311], [-118.26732, 34.09326]]]} | Open Access 1 | 12660 | Silver Lake Reservoir | 25489 | 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 | 117.771 | Silver Lake Reservoir | 0 | Local Recreation Area 3 | 4 | |
13936 | 13936 | 13935 | {"type": "Polygon", "coordinates": [[[-118.26813, 34.03678], [-118.26797, 34.03702], [-118.26752, 34.03682], [-118.26768, 34.03658], [-118.26813, 34.03678]]]} | Open Access 1 | 36542 | Venice Hope Park | 29327 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1717 | Los Angeles - Community Redevelopment Agency, City of 829 | City 2 | City Agency 2 | Los Angeles 6 | 0.357 | Venice Hope Park | 0 | Local Park 2 | 4 | |
15393 | 15393 | 15392 | {"type": "Polygon", "coordinates": [[[-118.26837, 34.11576], [-118.26813, 34.11585], [-118.2677, 34.11526], [-118.26719, 34.11465], [-118.26658, 34.11399], [-118.26597, 34.11338], [-118.26604, 34.11332], [-118.26617, 34.11327], [-118.2663, 34.11326], [-118.26647, 34.1133], [-118.26667, 34.11343], [-118.26716, 34.11388], [-118.26734, 34.11406], [-118.26762, 34.11441], [-118.26797, 34.11499], [-118.26837, 34.11576]]]} | Open Access 1 | 46643 | Sunnynook Park | 29971 | 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.519 | Sunnynook Park | 0 | Local Park 2 | 4 | |
7145 | 7145 | 7144 | {"type": "Polygon", "coordinates": [[[-118.2689, 33.87422], [-118.26878, 33.87562], [-118.26841, 33.87564], [-118.2685, 33.8756], [-118.26855, 33.87556], [-118.2686, 33.87545], [-118.26862, 33.87537], [-118.26869, 33.87443], [-118.26868, 33.87423], [-118.2689, 33.87422]]]} | Open Access 1 | 6237 | Walnut Street Park | 27244 | 1048 | Carson, City of 304 | City 2 | City Agency 2 | http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp | City 2 | 1048 | Carson, City of 300 | City 2 | City Agency 2 | Los Angeles 6 | 0.677 | Walnut Street Park | 0 | Local Park 2 | 4 | |
12181 | 12181 | 12180 | {"type": "Polygon", "coordinates": [[[-118.26901, 34.01254], [-118.26854, 34.01333], [-118.26797, 34.01311], [-118.26846, 34.01233], [-118.26901, 34.01254]]]} | Restricted Access 2 | 46855 | Trinity Street Elementary School Park | 31927 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | Los Angeles 6 | 1.374 | Trinity Street Elementary School Park | 0 | Local Park 2 | 4 | |
16930 | 16930 | 16929 | {"type": "Polygon", "coordinates": [[[-118.26938, 33.95566], [-118.26937, 33.95639], [-118.26526, 33.95641], [-118.26526, 33.95567], [-118.26938, 33.95566]]]} | Open Access 1 | 25043 | Green Meadows Recreation Center | 30907 | 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/reccenter/facility/greenMeadowsRC.htm | Los Angeles 6 | 7.636 | Green Meadows Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
250 | 250 | 249 | {"type": "Polygon", "coordinates": [[[-118.26941, 34.15733], [-118.26731, 34.15813], [-118.26727, 34.15765], [-118.26685, 34.15765], [-118.26684, 34.15655], [-118.2686, 34.15653], [-118.26939, 34.15648], [-118.2694, 34.15651], [-118.26941, 34.15733]]]} | Open Access 1 | 680 | Fremont Park | 19098 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 7.714 | Fremont Park | 0 | Local Park 2 | 4 | |
1527 | 1527 | 1526 | {"type": "Polygon", "coordinates": [[[-118.26948, 33.99658], [-118.26946, 33.99832], [-118.26534, 33.99833], [-118.2653, 33.99661], [-118.26948, 33.99658]]]} | Open Access 1 | 12887 | South Park | 25672 | 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 | 18.202 | South Park | 0 | Local Park 2 | 4 | |
3955 | 3955 | 3954 | {"type": "Polygon", "coordinates": [[[-118.26969, 34.25985], [-118.2653, 34.25981], [-118.26529, 34.25816], [-118.26968, 34.25821], [-118.26969, 34.25985]]]} | Unknown Access 4 | 46417 | Haines Canyon | 29694 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 18.279 | Haines Canyon | None 341 | |||
7114 | 7114 | 7113 | {"type": "Polygon", "coordinates": [[[-118.26976, 33.7748], [-118.2695, 33.77481], [-118.26952, 33.77513], [-118.2687, 33.77517], [-118.26849, 33.77245], [-118.26957, 33.77239], [-118.26976, 33.7748]]]} | Open Access 1 | 6189 | Wilmington Recreation Center | 27599 | 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 | 7.337 | Wilmington Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16537 | 16537 | 16536 | {"type": "Polygon", "coordinates": [[[-118.27002, 33.99328], [-118.26535, 33.99331], [-118.26534, 33.99254], [-118.27002, 33.99253], [-118.27002, 33.99328]]]} | Open Access 1 | 45534 | South Los Angeles Wetlands Pocket Park | 28365 | 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 | http://www.lastormwater.org/green-la/proposition-o/south-los-angeles-wetlands-park/ | Los Angeles 6 | 9.005 | South Los Angeles Wetlands PP | 0 | Local Park 2 | 4 |
5704 | 5704 | 5703 | {"type": "Polygon", "coordinates": [[[-118.27079, 34.05157], [-118.27054, 34.05146], [-118.27065, 34.05131], [-118.27066, 34.05133], [-118.27079, 34.05157]]]} | Open Access 1 | 45766 | Valencia Triangle | 28772 | 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.063 | Valencia Triangle | 0 | Local Other or Unknown 14 | 4 | |
7154 | 7154 | 7153 | {"type": "Polygon", "coordinates": [[[-118.27119, 33.81246], [-118.27117, 33.81496], [-118.27118, 33.81506], [-118.27114, 33.8152], [-118.2711, 33.81522], [-118.27103, 33.81523], [-118.27069, 33.81501], [-118.27055, 33.81496], [-118.27043, 33.81493], [-118.26943, 33.81494], [-118.2694, 33.81493], [-118.2694, 33.81477], [-118.26951, 33.81241], [-118.27119, 33.81246]]]} | Open Access 1 | 6251 | Scott Park | 25204 | 1048 | Carson, City of 304 | City 2 | City Agency 2 | http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp | City 2 | 1048 | Carson, City of 300 | City 2 | City Agency 2 | Los Angeles 6 | 11.27 | Scott Park | 0 | 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 |
5690 | 5690 | 5689 | {"type": "Polygon", "coordinates": [[[-118.27132, 34.06879], [-118.27084, 34.06957], [-118.27011, 34.06925], [-118.27043, 34.06874], [-118.27067, 34.06885], [-118.27073, 34.06876], [-118.27089, 34.06883], [-118.27101, 34.06865], [-118.27132, 34.06879]]]} | Open Access 1 | 45754 | Lake Street Park | 28758 | 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/reccenter/facility/lakestComC.htm | Los Angeles 6 | 1.52 | Lake Street Park | 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 |
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]);