units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,394 rows where AGNCY_LEV = 2 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 525
- Los Angeles, City of 485
- San Jose, City of 253
- San Francisco, City and County of 238
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 144
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 90
- Modesto, City of 85
- Santa Rosa, City of 82
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Tracy, City of 73
- Santa Cruz, City of 72
- Torrance, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- Davis, City of 65
- San Luis Obispo, City of 64
- Santa Barbara, City of 64
- Newport Beach, City of 64
- Glendale, City of 61
- Bakersfield, City of 61
- Manteca, City of 61
- Riverside, City of 60
- …
DES_TP >30
- Local Park 7,352
- Local Recreation Area 1,414
- Local Other or Unknown 661
- Local Conservation Area 149
- Local Historic or Cultural Area 38
- Local Resource Management Area 6
- National Monument or Landmark 5
- State Conservation Area 2
- None 1
- None 1
- National Forest 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
- …
MNG_AG_TYP 14
- City Agency 10,292
- Open Space District 21
- Recreation/Parks District 19
- County Agency 16
- Non Profit - Other 11
- Commercial 9
- Non Profit - Conservation 7
- State Agency 5
- County Agency - Parks 4
- Other 3
- County Agency - Other 2
- Non Profit - Land Trust 2
- Port/Harbor District 2
- Community Services District 1
ACCESS_TYP 4
- Open Access 9,898
- Restricted Access 260
- No Public Access 207
- Unknown Access 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
378 | 378 | 377 | {"type": "Polygon", "coordinates": [[[-119.20947, 36.30166], [-119.20848, 36.30166], [-119.20849, 36.30084], [-119.20946, 36.30084], [-119.20947, 36.30166]]]} | Open Access 1 | 1136 | Jennings Park | 20389 | 1106 | Farmersville, City of 155 | City 2 | City Agency 2 | City 2 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | Tulare 29 | 1.978 | Jennings Park | 0 | Local Park 2 | 4 | ||
381 | 381 | 380 | {"type": "Polygon", "coordinates": [[[-119.21304, 36.31701], [-119.213, 36.31821], [-119.20857, 36.31818], [-119.20859, 36.31659], [-119.20864, 36.31665], [-119.20877, 36.31669], [-119.20887, 36.31664], [-119.21059, 36.31665], [-119.21139, 36.31671], [-119.21209, 36.31679], [-119.21304, 36.31701]]]} | Open Access 1 | 1141 | Liberty Park | 21210 | 1106 | Farmersville, City of 155 | City 2 | City Agency 2 | City 2 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | Tulare 29 | 16.086 | Liberty Park | 0 | Local Park 2 | 4 | ||
384 | 384 | 383 | {"type": "Polygon", "coordinates": [[[-119.20715, 36.29112], [-119.20714, 36.29174], [-119.20533, 36.29176], [-119.20533, 36.29057], [-119.20679, 36.29058], [-119.20679, 36.29112], [-119.20715, 36.29112]]]} | Open Access 1 | 1151 | Roy Park | 24712 | 1106 | Farmersville, City of 155 | City 2 | City Agency 2 | City 2 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | Tulare 29 | 4.789 | Roy Park | 0 | Local Park 2 | 4 | ||
516 | 516 | 515 | {"type": "Polygon", "coordinates": [[[-120.62395, 36.98985], [-120.62208, 36.98986], [-120.62208, 36.98902], [-120.62395, 36.98902], [-120.62395, 36.98985]]]} | Open Access 1 | 25989 | Pierini Park | 23664 | 1460 | Dos Palos, City of 194 | City 2 | City Agency 2 | City 2 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | Merced 37 | 3.824 | Pierini Park | 0 | Local Park 2 | 4 | ||
527 | 527 | 526 | {"type": "Polygon", "coordinates": [[[-120.63533, 36.98758], [-120.63434, 36.98758], [-120.63433, 36.98728], [-120.63533, 36.98728], [-120.63533, 36.98758]]]} | Open Access 1 | 25990 | Des Park | 18106 | 1460 | Dos Palos, City of 194 | City 2 | City Agency 2 | City 2 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | Merced 37 | 0.735 | Des Park | 0 | Local Park 2 | 4 | ||
2104 | 2104 | 2103 | {"type": "Polygon", "coordinates": [[[-120.57389, 34.97384], [-120.57321, 34.97483], [-120.57204, 34.97432], [-120.57273, 34.97333], [-120.57389, 34.97384]]]} | Open Access 1 | 17330 | Leroy Park | 21178 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 3.784 | Leroy Park | 0 | Local Park 2 | 4 | ||
2317 | 2317 | 2316 | {"type": "Polygon", "coordinates": [[[-120.59124, 34.95777], [-120.59116, 34.96061], [-120.58835, 34.96058], [-120.58837, 34.96035], [-120.58852, 34.95999], [-120.58868, 34.9598], [-120.58886, 34.95964], [-120.5892, 34.95938], [-120.58939, 34.95916], [-120.58958, 34.95879], [-120.58962, 34.9586], [-120.58965, 34.95785], [-120.58967, 34.9578], [-120.58974, 34.95777], [-120.59124, 34.95777]]]} | Open Access 1 | 16995 | Jack O'Conell Park | 20306 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 14.461 | Jack O'Conell Park | 0 | Local Park 2 | 4 | ||
4061 | 4061 | 4060 | {"type": "Polygon", "coordinates": [[[-121.47735, 41.95551], [-121.47721, 41.95551], [-121.4772, 41.95545], [-121.4769, 41.95545], [-121.4769, 41.95537], [-121.47735, 41.95536], [-121.47735, 41.95551]]]} | Open Access 1 | 45609 | Mike Bunch Park | 28435 | 1704 | Tulelake, City of 719 | City 2 | City Agency 2 | City 2 | 1704 | Tulelake, City of 702 | City 2 | City Agency 2 | Siskiyou 28 | 0.11 | Mike Bunch Park | 0 | Local Park 2 | 4 | ||
4234 | 4234 | 4233 | {"type": "Polygon", "coordinates": [[[-120.13118, 35.99946], [-120.13084, 35.99947], [-120.13084, 35.99912], [-120.13117, 35.99912], [-120.13118, 35.99946]]]} | Open Access 1 | 45105 | Avenal Neighborhood Park | 32506 | 1017 | Avenal, City of 735 | City 2 | City Agency 2 | City 2 | 1017 | Avenal, City of 719 | City 2 | City Agency 2 | https://www.cityofavenal.com/Facilities/Facility/Details/Avenal-Neighborhood-Park-3 | Kings 44 | 0.287 | Avenal Neighborhood Park | 0 | Local Park 2 | 4 | |
4348 | 4348 | 4347 | {"type": "Polygon", "coordinates": [[[-121.47463, 41.94817], [-121.47463, 41.94844], [-121.47419, 41.94844], [-121.47419, 41.94817], [-121.47463, 41.94817]]]} | Open Access 1 | 45654 | Ridgeview Park | 28470 | 1704 | Tulelake, City of 719 | City 2 | City Agency 2 | City 2 | 1704 | Tulelake, City of 702 | City 2 | City Agency 2 | Siskiyou 28 | 0.275 | Ridgeview Park | 0 | Local Park 2 | 4 | ||
4353 | 4353 | 4352 | {"type": "Polygon", "coordinates": [[[-121.47657, 41.95688], [-121.47601, 41.95688], [-121.47601, 41.95673], [-121.47656, 41.95673], [-121.47657, 41.95688]]]} | Open Access 1 | 45682 | Veterans Memorial Park | 28496 | 1704 | Tulelake, City of 719 | City 2 | City Agency 2 | City 2 | 1704 | Tulelake, City of 702 | City 2 | City Agency 2 | Siskiyou 28 | 0.189 | Veterans Memorial Park | 0 | Local Park 2 | 4 | ||
4927 | 4927 | 4926 | {"type": "Polygon", "coordinates": [[[-120.57718, 34.95846], [-120.57722, 34.95871], [-120.57726, 34.95884], [-120.57749, 34.95931], [-120.57749, 34.95936], [-120.57745, 34.95938], [-120.57717, 34.95939], [-120.57718, 34.95846]]]} | Open Access 1 | 35362 | Guadalupe holding 1 | 19545 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.328 | Guadalupe holding 1 | 0 | Local Other or Unknown 14 | 4 | ||
4928 | 4928 | 4927 | {"type": "Polygon", "coordinates": [[[-120.58052, 34.96254], [-120.58034, 34.96267], [-120.57983, 34.9626], [-120.57981, 34.9625], [-120.58012, 34.96231], [-120.58041, 34.96249], [-120.58052, 34.96254]]]} | Open Access 1 | 35363 | Guadalupe holding 2 | 19547 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.371 | Guadalupe holding 2 | 0 | Local Other or Unknown 14 | 4 | ||
5141 | 5141 | 5140 | {"type": "Polygon", "coordinates": [[[-120.57892, 34.964], [-120.57887, 34.96401], [-120.57829, 34.96412], [-120.57829, 34.964], [-120.57892, 34.964]]]} | Open Access 1 | 35415 | Guadalupe holding 6 | 19551 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.1 | Guadalupe holding 6 | 0 | Local Other or Unknown 14 | 4 | ||
5576 | 5576 | 5575 | {"type": "Polygon", "coordinates": [[[-115.38799, 32.80773], [-115.38799, 32.80773], [-115.38527, 32.80861], [-115.38529, 32.80805], [-115.38575, 32.80776], [-115.38593, 32.80758], [-115.38606, 32.80752], [-115.38613, 32.80752], [-115.38626, 32.80747], [-115.38633, 32.80732], [-115.38658, 32.80735], [-115.38676, 32.80729], [-115.38696, 32.80727], [-115.3875, 32.80728], [-115.38775, 32.80735], [-115.38787, 32.80744], [-115.38799, 32.80773]]]} | Open Access 1 | 48782 | Earl Walker Park | 33508 | 2436 | Holtville Community Redevelopment Agency 810 | City 2 | City Agency 2 | City 2 | 1139 | Holtville, City of 209 | City 2 | City Agency 2 | http://www.holtville.ca.gov/section.php?id=61 | Imperial 20 | 4.792 | Earl Walker Park | 0 | Local Park 2 | 4 | |
6132 | 6132 | 6131 | {"type": "Polygon", "coordinates": [[[-119.20262, 36.30185], [-119.2026, 36.30265], [-119.20192, 36.3026], [-119.20185, 36.30252], [-119.20175, 36.30248], [-119.20153, 36.30251], [-119.20151, 36.30182], [-119.20257, 36.30181], [-119.20262, 36.30185]]]} | Open Access 1 | 1120 | Armstrong Park | 15595 | 1106 | Farmersville, City of 155 | City 2 | City Agency 2 | City 2 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | Tulare 29 | 2.065 | Armstrong Park | 0 | Local Park 2 | 4 | ||
6146 | 6146 | 6145 | {"type": "Polygon", "coordinates": [[[-119.20698, 36.30827], [-119.20697, 36.30938], [-119.20663, 36.30949], [-119.2063, 36.30958], [-119.20595, 36.30965], [-119.20552, 36.30971], [-119.20556, 36.30825], [-119.20572, 36.30826], [-119.20698, 36.30827]]]} | Open Access 1 | 1146 | Lone Oak Park | 21439 | 1106 | Farmersville, City of 155 | City 2 | City Agency 2 | City 2 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | Tulare 29 | 4.622 | Lone Oak Park | 0 | Local Park 2 | 4 | ||
6151 | 6151 | 6150 | {"type": "Polygon", "coordinates": [[[-121.92056, 41.96329], [-121.92015, 41.9633], [-121.92014, 41.96304], [-121.92012, 41.96303], [-121.92011, 41.96278], [-121.92056, 41.96277], [-121.92056, 41.96329]]]} | Open Access 1 | 48342 | Dorris Park | 32906 | 1699 | Dorris, City of 829 | City 2 | City Agency 2 | City 2 | 1699 | Dorris, City of 809 | City 2 | City Agency 2 | Siskiyou 28 | 0.509 | Dorris Park | 0 | Local Park 2 | 4 | ||
7869 | 7869 | 7868 | {"type": "Polygon", "coordinates": [[[-120.12771, 36.00901], [-120.12558, 36.00898], [-120.12556, 36.00807], [-120.1277, 36.00811], [-120.12771, 36.00901]]]} | Open Access 1 | 9869 | Floyd Rice Park | 18965 | 1017 | Avenal, City of 735 | City 2 | City Agency 2 | City 2 | 1017 | Avenal, City of 719 | City 2 | City Agency 2 | Kings 44 | 4.787 | Floyd Rice Park | 0 | Local Park 2 | 4 | ||
13147 | 13147 | 13146 | {"type": "Polygon", "coordinates": [[[-120.58049, 34.96217], [-120.58041, 34.96249], [-120.58017, 34.96234], [-120.58038, 34.96212], [-120.58049, 34.96217]]]} | Open Access 1 | 35256 | Guadalupe holding 7 | 19552 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.158 | Guadalupe holding 7 | 0 | Local Other or Unknown 14 | 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]);