units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,263 rows where AGNCY_TYP = 3 sorted by AGNCY_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, YR_EST, GAP_STS
MNG_AGENCY >30
- Los Angeles, County of 155
- Santa Barbara, County of 117
- San Diego, County of 117
- Orange, County of 91
- Los Angeles - Department of Parks and Recreation, County of 60
- Lake, County of 56
- Sacramento, County of 55
- Butte, County of 53
- Santa Cruz, County of 51
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 42
- Riverside, County of 38
- San Luis Obispo, County of 31
- Placer, County of 28
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- Yolo, County of 18
- Fresno, County of 17
- San Bernardino, County of 17
- Merced, County of 16
- Tulare, County of 15
- Humboldt, County of 12
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Imperial, County of 5
- …
DES_TP >30
- Local Park 687
- Local Other or Unknown 214
- Local Recreation Area 126
- Local Conservation Area 98
- Local Historic or Cultural Area 21
- National Forest 2
- National Monument or Landmark 2
- None 1
- State Conservation Area 1
- None 1
- National Recreation 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
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 1,135
- Restricted Access 63
- Unknown Access 36
- No Public 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9975 | 9975 | 9974 | {"type": "Polygon", "coordinates": [[[-122.11034, 37.25814], [-122.1099, 37.25831], [-122.10963, 37.25848], [-122.10956, 37.25855], [-122.10952, 37.25863], [-122.10951, 37.25873], [-122.10953, 37.25882], [-122.10846, 37.25883], [-122.10844, 37.25755], [-122.11032, 37.25756], [-122.11034, 37.25814]]]} | No Public Access 3 | 47967 | Saratoga Gap Open Space Preserve | 31468 | 373 | Santa Clara, County of 941 | County 3 | County Agency 3 | http://www.sccgov.org/sites/scc/Pages/default.aspx | County 3 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 4.827 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
4385 | 4385 | 4384 | {"type": "Polygon", "coordinates": [[[-120.7612, 38.50487], [-120.76067, 38.50489], [-120.75991, 38.50481], [-120.75994, 38.50463], [-120.76073, 38.5047], [-120.76118, 38.50468], [-120.7612, 38.50487]]]} | Open Access 1 | 45570 | Fiddletown Park | 28396 | 372 | Amador, County of 755 | County 3 | County Agency 3 | http://www.co.amador.ca.us/ | County 3 | 372 | Amador, County of 741 | County 3 | County Agency 3 | http://www.touramador.com/parks | Amador 52 | 0.575 | Fiddletown Park | 0 | Local Park 2 | 4 |
14991 | 14991 | 14990 | {"type": "Polygon", "coordinates": [[[-120.74127, 38.54448], [-120.74125, 38.54475], [-120.74104, 38.54487], [-120.74089, 38.54509], [-120.74089, 38.54533], [-120.74091, 38.54553], [-120.74099, 38.54569], [-120.74082, 38.54569], [-120.74076, 38.54552], [-120.74073, 38.54533], [-120.74063, 38.5451], [-120.74034, 38.54496], [-120.74036, 38.54455], [-120.74062, 38.54449], [-120.74127, 38.54448]]]} | Open Access 1 | 45637 | River Pines Playground | 28454 | 372 | Amador, County of 755 | County 3 | County Agency 3 | http://www.co.amador.ca.us/ | County 3 | 372 | Amador, County of 741 | County 3 | County Agency 3 | http://www.touramador.com/parks | Amador 52 | 1.32 | River Pines Playground | 0 | Local Recreation Area 3 | 4 |
14295 | 14295 | 14294 | {"type": "Polygon", "coordinates": [[[-121.61997, 37.90654], [-121.61837, 37.90657], [-121.61747, 37.90656], [-121.61748, 37.90592], [-121.61867, 37.90531], [-121.61898, 37.90506], [-121.61898, 37.90495], [-121.61947, 37.90532], [-121.61964, 37.90549], [-121.61976, 37.90565], [-121.61987, 37.90588], [-121.61992, 37.90603], [-121.61995, 37.90619], [-121.61997, 37.90654]]]} | Open Access 1 | 44229 | Slifer Park | 25558 | 369 | Contra Costa, County of 1106 | County 3 | County Agency 3 | http://www.co.contra-costa.ca.us/446/Parks-and-Recreation | County 3 | 369 | Contra Costa, County of 1060 | County 3 | County Agency 3 | Contra Costa 12 | 6.525 | Slifer Park | 0 | Local Park 2 | 4 | |
14953 | 14953 | 14952 | {"type": "Polygon", "coordinates": [[[-122.03078, 38.03015], [-122.03061, 38.03021], [-122.03036, 38.02969], [-122.03052, 38.02965], [-122.03078, 38.03015]]]} | Open Access 1 | 45559 | Big Oak Tree Park | 28387 | 369 | Contra Costa, County of 1106 | County 3 | County Agency 3 | http://www.co.contra-costa.ca.us/446/Parks-and-Recreation | County 3 | 369 | Contra Costa, County of 1060 | County 3 | County Agency 3 | http://www.contracosta.ca.gov/4398/Clyde | Contra Costa 12 | 0.241 | Big Oak Tree Park | 0 | Local Park 2 | 4 |
14961 | 14961 | 14960 | {"type": "Polygon", "coordinates": [[[-122.07002, 37.98678], [-122.06947, 37.98652], [-122.06924, 37.98637], [-122.06881, 37.98575], [-122.06874, 37.98561], [-122.06869, 37.98543], [-122.0683, 37.98352], [-122.06884, 37.98351], [-122.06919, 37.98462], [-122.06922, 37.98477], [-122.0692, 37.98517], [-122.06931, 37.98555], [-122.06955, 37.986], [-122.07001, 37.98661], [-122.07002, 37.98678]]]} | Open Access 1 | 45572 | Hayden Park | 28398 | 369 | Contra Costa, County of 1106 | County 3 | County Agency 3 | http://www.co.contra-costa.ca.us/446/Parks-and-Recreation | County 3 | 369 | Contra Costa, County of 1060 | County 3 | County Agency 3 | Contra Costa 12 | 4.478 | Hayden Park | 0 | Local Park 2 | 4 | |
3765 | 3765 | 3764 | {"type": "Polygon", "coordinates": [[[-120.42391, 37.95344], [-120.42385, 37.95358], [-120.42349, 37.95357], [-120.42294, 37.95347], [-120.42298, 37.95335], [-120.42353, 37.95346], [-120.42357, 37.95338], [-120.42391, 37.95344]]]} | Open Access 1 | 44974 | Jamestown Park | 20357 | 368 | Tuolumne, County of 680 | County 3 | County Agency 3 | http://www.tuolumnecounty.ca.gov/index.aspx?NID=448 | County 3 | 368 | Tuolumne, County of 670 | County 3 | County Agency 3 | Tuolumne 21 | 0.305 | Jamestown Park | 0 | Local Park 2 | 4 | |
14837 | 14837 | 14836 | {"type": "Polygon", "coordinates": [[[-120.40956, 38.04466], [-120.40948, 38.04466], [-120.409, 38.04374], [-120.40883, 38.04347], [-120.40869, 38.043], [-120.4079, 38.04234], [-120.40747, 38.04201], [-120.40725, 38.04153], [-120.40791, 38.04125], [-120.40799, 38.04128], [-120.40805, 38.04022], [-120.40801, 38.03973], [-120.4086, 38.03972], [-120.4092, 38.0398], [-120.40955, 38.04], [-120.40956, 38.04228], [-120.40952, 38.04272], [-120.40957, 38.0433], [-120.40956, 38.04466]]]} | Open Access 1 | 45360 | Columbia Pioneer Park | 17549 | 368 | Tuolumne, County of 680 | County 3 | County Agency 3 | http://www.tuolumnecounty.ca.gov/index.aspx?NID=448 | County 3 | 368 | Tuolumne, County of 670 | County 3 | County Agency 3 | Tuolumne 21 | 14.809 | Columbia Pioneer Park | 0 | Local Park 2 | 4 | |
3101 | 3101 | 3100 | {"type": "Polygon", "coordinates": [[[-122.54604, 39.88145], [-122.5458, 39.88281], [-122.54366, 39.88282], [-122.54397, 39.88098], [-122.54604, 39.88145]]]} | Open Access 1 | 48690 | Simpson-Finnell Park | 33429 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | https://www.co.tehama.ca.us/simpson-finnell-park | Tehama 18 | 8.049 | Simpson-Finnell Park | 0 | Local Park 2 | 4 |
3855 | 3855 | 3854 | {"type": "Polygon", "coordinates": [[[-122.13624, 40.16726], [-122.13608, 40.16757], [-122.13608, 40.16789], [-122.13579, 40.16833], [-122.13525, 40.16893], [-122.13502, 40.16922], [-122.13467, 40.1694], [-122.13392, 40.1697], [-122.13353, 40.16995], [-122.13318, 40.17051], [-122.13307, 40.17111], [-122.13021, 40.17111], [-122.13094, 40.17091], [-122.13251, 40.17066], [-122.13277, 40.17057], [-122.13318, 40.17011], [-122.13339, 40.16963], [-122.13448, 40.16788], [-122.13496, 40.16757], [-122.13539, 40.16737], [-122.13586, 40.16728], [-122.13624, 40.16726]]]} | Open Access 1 | 45504 | Cone Grove Park | 28336 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/cone-grove-park | Tehama 18 | 10.282 | Cone Grove Park | 0 | Local Park 2 | 4 |
4055 | 4055 | 4054 | {"type": "Polygon", "coordinates": [[[-122.30883, 40.14508], [-122.30881, 40.14591], [-122.30838, 40.14651], [-122.30818, 40.14666], [-122.30791, 40.14682], [-122.306, 40.14747], [-122.30603, 40.14724], [-122.30583, 40.14724], [-122.30582, 40.14753], [-122.30406, 40.1481], [-122.30412, 40.14504], [-122.30883, 40.14508]]]} | Open Access 1 | 44417 | Ridgeway Park | 24362 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | Tehama 18 | 24.281 | Ridgeway Park | 0 | Local Park 2 | 4 | |
4219 | 4219 | 4218 | {"type": "Polygon", "coordinates": [[[-122.11797, 40.03123], [-122.11791, 40.03135], [-122.11783, 40.03163], [-122.11781, 40.03191], [-122.11764, 40.03248], [-122.11763, 40.03275], [-122.11756, 40.03306], [-122.11552, 40.03307], [-122.11426, 40.03337], [-122.11309, 40.03337], [-122.11307, 40.0296], [-122.11571, 40.02933], [-122.11667, 40.03121], [-122.11797, 40.03123]]]} | Open Access 1 | 44979 | Mill Creek Park | 22224 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | Tehama 18 | 34.399 | Mill Creek Park | 0 | Local Park 2 | 4 | |
4812 | 4812 | 4811 | {"type": "Polygon", "coordinates": [[[-122.11291, 40.02963], [-122.11291, 40.03329], [-122.11092, 40.0333], [-122.11089, 40.03065], [-122.11223, 40.02981], [-122.11291, 40.02963]]]} | Open Access 1 | 48689 | Unnamed Site - Tehama, County of | 33428 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | Tehama 18 | 15.209 | 0 | Local Other or Unknown 14 | 4 | ||
14958 | 14958 | 14957 | {"type": "Polygon", "coordinates": [[[-122.14993, 40.05946], [-122.14908, 40.05981], [-122.14838, 40.05879], [-122.14924, 40.05843], [-122.14993, 40.05946]]]} | Open Access 1 | 45564 | Gerber Park | 28392 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/gerber-park | Tehama 18 | 2.613 | Gerber Park | 0 | Local Park 2 | 4 |
15013 | 15013 | 15012 | {"type": "Polygon", "coordinates": [[[-122.09227, 39.91075], [-122.09061, 39.91171], [-122.0895, 39.91054], [-122.08863, 39.90939], [-122.08995, 39.90859], [-122.0914, 39.90935], [-122.0916, 39.90961], [-122.09108, 39.90984], [-122.09107, 39.90985], [-122.09144, 39.91], [-122.09203, 39.91045], [-122.09227, 39.91075]]]} | Open Access 1 | 45666 | Tehama River County Park | 28483 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/tehama-county-river-park | Tehama 18 | 13.662 | Tehama River County Park | 0 | Local Park 2 | 4 |
14962 | 14962 | 14961 | {"type": "Polygon", "coordinates": [[[-121.63678, 39.14842], [-121.63578, 39.14842], [-121.63581, 39.14765], [-121.63579, 39.147], [-121.63636, 39.147], [-121.63677, 39.14682], [-121.63678, 39.14842]]]} | Open Access 1 | 45574 | Howard Harter Park | 28400 | 366 | Sutter, County of 1128 | County 3 | County Agency 3 | http://www.co.sutter.ca.us/ | County 3 | 366 | Sutter, County of 1083 | County 3 | County Agency 3 | Sutter 47 | 3.402 | Howard Harter Park | 0 | Local Park 2 | 4 | |
14981 | 14981 | 14980 | {"type": "Polygon", "coordinates": [[[-121.63358, 39.27281], [-121.63254, 39.27519], [-121.63254, 39.27536], [-121.6327, 39.27598], [-121.63105, 39.27599], [-121.63025, 39.27499], [-121.63004, 39.27326], [-121.63182, 39.27344], [-121.63195, 39.27327], [-121.63234, 39.27302], [-121.63264, 39.27265], [-121.63358, 39.27281]]]} | Open Access 1 | 45598 | Live Oak Park and Recreation Area | 28424 | 366 | Sutter, County of 1128 | County 3 | County Agency 3 | http://www.co.sutter.ca.us/ | County 3 | 366 | Sutter, County of 1083 | County 3 | County Agency 3 | https://www.co.sutter.ca.us/doc/living/entertainment/recreation/pw_live_oak_park | Sutter 47 | 17.329 | Live Oak Park and Rec. Area | 0 | Local Recreation Area 3 | 4 |
3211 | 3211 | 3210 | {"type": "Polygon", "coordinates": [[[-122.63748, 41.70784], [-122.63684, 41.70871], [-122.63636, 41.70858], [-122.63561, 41.70825], [-122.63577, 41.70803], [-122.63593, 41.70785], [-122.63621, 41.70776], [-122.63657, 41.70768], [-122.63678, 41.70769], [-122.63748, 41.70784]]]} | Open Access 1 | 28144 | Hibbard Field | 19892 | 365 | Siskiyou, County of 596 | County 3 | County Agency 3 | http://www.co.siskiyou.ca.us/ | County 3 | 365 | Siskiyou, County of 586 | County 3 | County Agency 3 | Siskiyou 28 | 2.667 | Hibbard Field | 0 | Local Recreation Area 3 | 4 | |
14963 | 14963 | 14962 | {"type": "Polygon", "coordinates": [[[-122.36062, 41.53532], [-122.36051, 41.53535], [-122.36013, 41.53516], [-122.35997, 41.53511], [-122.35979, 41.53509], [-122.35949, 41.53511], [-122.35905, 41.53521], [-122.35889, 41.53522], [-122.35875, 41.53521], [-122.35859, 41.53517], [-122.35845, 41.5351], [-122.35833, 41.53501], [-122.35823, 41.53491], [-122.35826, 41.53482], [-122.35867, 41.53464], [-122.35901, 41.53442], [-122.35919, 41.53425], [-122.35983, 41.53356], [-122.35993, 41.53355], [-122.36007, 41.53363], [-122.36017, 41.5337], [-122.36025, 41.5338], [-122.36031, 41.53391], [-122.36045, 41.53452], [-122.36067, 41.53505], [-122.36067, 41.53519], [-122.36062, 41.53532]]]} | Open Access 1 | 45576 | Hoy Park | 28402 | 365 | Siskiyou, County of 596 | County 3 | County Agency 3 | http://www.co.siskiyou.ca.us/ | County 3 | 365 | Siskiyou, County of 586 | County 3 | County Agency 3 | Siskiyou 28 | 5.259 | Hoy Park | 0 | Local Park 2 | 4 | |
14921 | 14921 | 14920 | {"type": "Polygon", "coordinates": [[[-120.44035, 39.66542], [-120.43985, 39.66578], [-120.43938, 39.66545], [-120.43915, 39.66551], [-120.43881, 39.66573], [-120.43851, 39.66605], [-120.43835, 39.66605], [-120.43777, 39.6656], [-120.43785, 39.66553], [-120.43894, 39.66527], [-120.43961, 39.66496], [-120.44035, 39.66542]]]} | Open Access 1 | 45494 | Calpine Park | 28323 | 364 | Sierra, County of 1126 | County 3 | County Agency 3 | http://www.sierracounty.ca.gov/index.aspx?nid=289 | County 3 | 364 | Sierra, County of 1081 | County 3 | County Agency 3 | Sierra 58 | 2.651 | Calpine 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]);