units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,084 rows where ACCESS_TYP = 1 and DES_TP = 2 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 9,084 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189 | 189 | 188 | {"type": "Polygon", "coordinates": [[[-121.69813, 38.13724], [-121.69797, 38.13757], [-121.69794, 38.13778], [-121.698, 38.138], [-121.698, 38.13839], [-121.69766, 38.13941], [-121.69748, 38.13979], [-121.69707, 38.14119], [-121.69655, 38.14207], [-121.69614, 38.14262], [-121.69612, 38.14317], [-121.69601, 38.14374], [-121.69455, 38.14262], [-121.69398, 38.1421], [-121.69404, 38.14198], [-121.69415, 38.14179], [-121.69439, 38.14132], [-121.69453, 38.14097], [-121.69475, 38.14037], [-121.69492, 38.14001], [-121.6952, 38.13921], [-121.6953, 38.13884], [-121.69555, 38.13824], [-121.69594, 38.13708], [-121.6961, 38.13642], [-121.69719, 38.1368], [-121.69813, 38.13724]]]} | Open Access 1 | 520 | Sandy Beach Park | 25025 | 2187 | Solano Tri-City and County Cooperative Planning Group 74 | Special District 4 | Open Space District 6 | Special District 4 | 2187 | Solano Tri-City and County Cooperative Planning Group 72 | Special District 4 | Open Space District 6 | Solano 26 | 36.239 | Sandy Beach Park | 0 | Local Park 2 | 4 | ||
351 | 351 | 350 | {"type": "Polygon", "coordinates": [[[-119.32193, 36.20761], [-119.32189, 36.20923], [-119.32081, 36.20925], [-119.32078, 36.20934], [-119.31981, 36.20934], [-119.31987, 36.20762], [-119.32193, 36.20761]]]} | Open Access 1 | 969 | Tulare Veterans Memorial Park | 26570 | 2168 | Tulare Veterans Memorial District 144 | Special District 4 | Cemetery District 11 | Special District 4 | 2168 | Tulare Veterans Memorial District 140 | Special District 4 | Cemetery District 11 | Tulare 29 | 8.555 | Tulare Veterans Memorial Park | 0 | Local Park 2 | 4 | ||
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 | ||
818 | 818 | 817 | {"type": "Polygon", "coordinates": [[[-117.1878, 34.44347], [-117.18605, 34.44348], [-117.18605, 34.44269], [-117.18779, 34.44268], [-117.1878, 34.44347]]]} | Open Access 1 | 5287 | Mendel Park | 22148 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 3.478 | Mendel Park | 0 | Local Park 2 | 4 | ||
910 | 910 | 909 | {"type": "Polygon", "coordinates": [[[-117.21458, 34.53082], [-117.21419, 34.53082], [-117.21418, 34.53128], [-117.21261, 34.53128], [-117.2126, 34.53013], [-117.21265, 34.53009], [-117.21457, 34.53009], [-117.21458, 34.53082]]]} | Open Access 1 | 5810 | Thunderbird Park | 26338 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 5.461 | Thunderbird Park | 0 | Local Park 2 | 4 | ||
1307 | 1307 | 1306 | {"type": "MultiPolygon", "coordinates": [[[[-118.63657, 34.26504], [-118.63633, 34.26516], [-118.63617, 34.26526], [-118.63601, 34.2654], [-118.63587, 34.26558], [-118.6358, 34.26572], [-118.63574, 34.26588], [-118.63571, 34.26605], [-118.63569, 34.26628], [-118.63564, 34.26647], [-118.63554, 34.26667], [-118.63539, 34.26684], [-118.63447, 34.26759], [-118.63418, 34.26779], [-118.63386, 34.26798], [-118.63327, 34.26823], [-118.63273, 34.2646], [-118.63657, 34.26504]]], [[[-118.63485, 34.26765], [-118.63449, 34.26821], [-118.63372, 34.26845], [-118.63334, 34.26871], [-118.63329, 34.2684], [-118.6338, 34.26819], [-118.63416, 34.26801], [-118.63449, 34.2678], [-118.63477, 34.26758], [-118.63485, 34.26765]]], [[[-118.65762, 34.27232], [-118.65772, 34.2726], [-118.65771, 34.27281], [-118.65769, 34.27297], [-118.65755, 34.27344], [-118.65753, 34.27346], [-118.65749, 34.27338], [-118.65642, 34.27257], [-118.65573, 34.27221], [-118.6555, 34.27195], [-118.65574, 34.27169], [-118.65574, 34.27168], [-118.65499, 34.27151], [-118.65408, 34.27081], [-118.65349, 34.27065], [-118.65242, 34.27019], [-118.65185, 34.27015], [-118.65094, 34.26998], [-118.65002, 34.26966], [-118.65006, 34.26918], [-118.64922, 34.26888], [-118.64886, 34.26879], [-118.64705, 34.26807], [-118.64679, 34.26814], [-118.64604, 34.26809], [-118.6458, 34.26796], [-118.64547, 34.26785], [-118.64495, 34.26758], [-118.64462, 34.26755], [-118.64414, 34.26724], [-118.64391, 34.26694], [-118.64358, 34.26675], [-118.64244, 34.26649], [-118.64221, 34.26578], [-118.64205, 34.2657], [-118.64022, 34.26616], [-118.63857, 34.266], [-118.63825, 34.26619], [-118.63802, 34.26604], [-118.63773, 34.26595], [-118.63661, 34.26612], [-118.63614, 34.26631], [-118.6356, 34.26704], [-118.6354, 34.2672], [-118.63532, 34.26713], [-118.6356, 34.26688], [-118.6357, 34.26676], [-118.63579, 34.26662], [-118.63588, 34.26636], [-118.63591, 34.26604], [-118.63594, 34.26588], [-118.636, 34.26574], [-118.63609, 34.2656], [-118.63624, 34.26544], [-118.63642, 34.2653], [-118.63663, 34.2652], [-118.63687, 34.26513], [-118.63725, 34.26529], [-118.63763, 34.2653], [-118.63817, 34.26541], [-118.6387, 34.26529], [-118.64734, 34.26629], [-118.64784, 34.26632], [-118.6482, 34.2663], [-118.64863, 34.26625], [-118.64905, 34.26617], [-118.64946, 34.26604], [-118.64985, 34.26589], [-118.65022, 34.26569], [-118.65061, 34.26543], [-118.65172, 34.26447], [-118.65208, 34.26407], [-118.65307, 34.2632], [-118.65352, 34.26283], [-118.65404, 34.26249], [-118.65458, 34.26292], [-118.65468, 34.26296], [-118.65481, 34.26299], [-118.65467, 34.26301], [-118.65448, 34.26298], [-118.6544, 34.26301], [-118.65435, 34.26305], [-118.65433, 34.2631], [-118.65433, 34.26316], [-118.65435, 34.2632], [-118.65288, 34.26389], [-118.65201, 34.26446], [-118.65231, 34.26447], [-118.65299, 34.26403], [-118.65496, 34.2631], [-118.65568, 34.26311], [-118.6557, 34.26352], [-118.65602, 34.26352], [-118.65602, 34.26311], [-118.65619, 34.26311], [-118.65614, 34.26652], [-118.6561, 34.2667], [-118.65643, 34.26684], [-118.65636, 34.26695], [-118.65626, 34.2677], [-118.65595, 34.26773], [-118.65595, 34.26945], [-118.6562, 34.26962], [-118.65629, 34.26981], [-118.65688, 34.27019], [-118.65701, 34.27046], [-118.65718, 34.27077], [-118.65734, 34.27095], [-118.6567, 34.2711], [-118.65679, 34.2714], [-118.65666, 34.27168], [-118.65762, 34.27232]]]]} | Open Access 1 | 10485 | Corriganville Park | 8979 | 2117 | Rancho Simi Open Space Conservation Agency 345 | Special District 4 | Open Space District 6 | Special District 4 | 2117 | Rancho Simi Open Space Conservation Agency 342 | Special District 4 | Open Space District 6 | http://www.rsrpd.org/park/corrignavilleparkandtrail/corrignavilleparkandtrail.html | Ventura 8 | 178.572 | Corriganville 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 | ||
2506 | 2506 | 2505 | {"type": "Polygon", "coordinates": [[[-117.3015, 33.61798], [-117.3012, 33.61831], [-117.29877, 33.61679], [-117.29902, 33.61646], [-117.3015, 33.61798]]]} | Open Access 1 | 48910 | Regency-Heritage Park | 33631 | 2437 | Ortega Trail Recreation and Park District 529 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 1706 | Wildomar, City of 522 | City 2 | City Agency 2 | http://www.cityofwildomar.org/community/parks_trails/parks/regency-heritage_park | Riverside 10 | 3.114 | Regency-Heritage Park | 0 | Local Park 2 | 4 | |
2660 | 2660 | 2659 | {"type": "Polygon", "coordinates": [[[-117.25827, 34.54145], [-117.25718, 34.54179], [-117.25716, 34.54027], [-117.25826, 34.54028], [-117.25827, 34.54145]]]} | Open Access 1 | 18164 | Corwin Park | 17669 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 3.691 | Corwin Park | 0 | Local Park 2 | 4 | ||
2666 | 2666 | 2665 | {"type": "Polygon", "coordinates": [[[-121.21401, 36.33581], [-121.21125, 36.33739], [-121.2107, 36.33678], [-121.2099, 36.33723], [-121.2097, 36.3372], [-121.20858, 36.33591], [-121.21228, 36.33384], [-121.21401, 36.33581]]]} | Open Access 1 | 18207 | Oak Park | 30778 | 2042 | Greenfield Public Recreation District 542 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2042 | Greenfield Public Recreation District 535 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 24.875 | Oak Park | 0 | Local Park 2 | 4 | ||
3014 | 3014 | 3013 | {"type": "Polygon", "coordinates": [[[-116.03991, 34.14688], [-116.03988, 34.15024], [-116.03658, 34.15029], [-116.03661, 34.14692], [-116.03991, 34.14688]]]} | Open Access 1 | 24302 | Luckie Park | 21581 | 2265 | Twentynine Palms Park and Recreation District 571 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2265 | Twentynine Palms Park and Recreation District 563 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 28.066 | Luckie Park | 0 | Local Park 2 | 4 | ||
3110 | 3110 | 3109 | {"type": "Polygon", "coordinates": [[[-118.368, 34.09588], [-118.36753, 34.09588], [-118.36753, 34.09577], [-118.36799, 34.09577], [-118.368, 34.09588]]]} | Open Access 1 | 47991 | Havenhurst Park | 32412 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/19/773 | Los Angeles 6 | 0.129 | Havenhurst Park | 0 | Local Park 2 | 4 | |
3362 | 3362 | 3361 | {"type": "Polygon", "coordinates": [[[-116.30843, 34.14128], [-116.30425, 34.14132], [-116.30424, 34.13951], [-116.30642, 34.1395], [-116.30643, 34.13956], [-116.30842, 34.13955], [-116.30843, 34.14128]]]} | Open Access 1 | 24295 | Sunburst Park | 25986 | 2230 | Joshua Tree Park and Recreation District 627 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2230 | Joshua Tree Park and Recreation District 616 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 18.753 | Sunburst 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 | ||
4163 | 4163 | 4162 | {"type": "Polygon", "coordinates": [[[-117.13273, 33.61299], [-117.13267, 33.61334], [-117.13238, 33.61333], [-117.13235, 33.61297], [-117.13273, 33.61299]]]} | Open Access 1 | 48381 | Mahogany Meadows Pocket Park | 32945 | 6124 | Mahogany Hills Home Owner Association 727 | Private 7 | Home Owners Association 16 | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/mahogany-meadows-pocket-park | Riverside 10 | 0.3 | Mahogany Meadows 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]);