units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,324 rows where ACCESS_TYP = 1 and MNG_AG_LEV = 3 sorted by YR_EST
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY >30
- Los Angeles, County of 153
- Santa Barbara, County of 105
- San Diego, County of 105
- Orange, County of 88
- Los Angeles - Department of Parks and Recreation, County of 57
- Lake, County of 56
- Butte, County of 53
- Santa Cruz, County of 49
- Sonoma County Regional Parks Dept., County of 47
- Kern, County of 46
- El Dorado, County of 44
- Monterey, County of 40
- Santa Clara County Parks and Recreation Dept., County of 40
- Marin County Parks Department, County of 32
- Riverside, County of 32
- San Luis Obispo, County of 29
- Placer, County of 27
- Sacramento, County of 26
- San Mateo County Parks and Recreation Dept., County of 24
- Stanislaus, County of 23
- Ventura, County of 22
- San Joaquin, County of 21
- San Bernardino, County of 20
- Yolo, County of 18
- Fresno, County of 16
- Merced, County of 16
- Tulare, County of 14
- Humboldt, County of 11
- Contra Costa County Public Works Dept., County of 9
- Mono, County of 7
- …
DES_TP >30
- Local Park 794
- Local Other or Unknown 194
- Local Recreation Area 122
- Local Conservation Area 89
- Local Historic or Cultural Area 21
- National Forest 2
- National Recreation Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- National Monument or Landmark 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
- …
ACCESS_TYP 1
- Open Access · 1,324 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 12 | 11 | {"type": "Polygon", "coordinates": [[[-120.70087, 35.73565], [-120.70026, 35.73762], [-120.70033, 35.73765], [-120.69995, 35.73853], [-120.69975, 35.73891], [-120.69913, 35.73992], [-120.6988, 35.73992], [-120.70087, 35.73565]]]} | Open Access 1 | 48 | Rios Caledonia Adobe | 24392 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 3.26 | Rios Caledonia Adobe | None 5 | |||
284 | 284 | 283 | {"type": "Polygon", "coordinates": [[[-116.4753, 32.60867], [-116.47487, 32.60888], [-116.47435, 32.60914], [-116.47431, 32.60887], [-116.47465, 32.60861], [-116.47505, 32.60838], [-116.4753, 32.60867]]]} | Open Access 1 | 766 | Campo Stone Store | 29229 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://ohp.parks.ca.gov/ListedResources/Detail/411 | San Diego 4 | 0.82 | Campo Stone Store | None 31 | ||
436 | 436 | 435 | {"type": "MultiPolygon", "coordinates": [[[[-122.50735, 38.11473], [-122.50721, 38.11477], [-122.50708, 38.11492], [-122.50687, 38.11486], [-122.50673, 38.11475], [-122.50645, 38.11496], [-122.50608, 38.11467], [-122.50597, 38.11454], [-122.5062, 38.11444], [-122.50605, 38.11434], [-122.50643, 38.1142], [-122.50655, 38.11334], [-122.50673, 38.11403], [-122.50667, 38.11408], [-122.50674, 38.11407], [-122.50688, 38.11442], [-122.5068, 38.1145], [-122.50682, 38.11454], [-122.50703, 38.11464], [-122.50716, 38.11469], [-122.50735, 38.11473]]], [[[-122.50745, 38.11324], [-122.50722, 38.11345], [-122.50723, 38.11346], [-122.50737, 38.11346], [-122.50737, 38.11352], [-122.50703, 38.11382], [-122.50688, 38.11383], [-122.50682, 38.11385], [-122.50685, 38.11358], [-122.50677, 38.11331], [-122.50745, 38.11324]]]]} | Open Access 1 | 840 | Black Point Boat Launch | 16137 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 2.255 | Black Point Boat Launch | None 45 | |||
862 | 862 | 861 | {"type": "MultiPolygon", "coordinates": [[[[-122.44333, 37.73556], [-122.44313, 37.73558], [-122.44241, 37.73578], [-122.44241, 37.73539], [-122.44331, 37.73537], [-122.44333, 37.73556]]], [[[-122.44368, 37.73938], [-122.44259, 37.73944], [-122.44255, 37.73931], [-122.44256, 37.73921], [-122.44259, 37.73912], [-122.44267, 37.73868], [-122.44269, 37.73845], [-122.44264, 37.73816], [-122.44246, 37.73767], [-122.44246, 37.73757], [-122.44249, 37.73744], [-122.44257, 37.73728], [-122.44269, 37.73716], [-122.44346, 37.73669], [-122.44358, 37.7381], [-122.44349, 37.73818], [-122.44344, 37.73829], [-122.44338, 37.73885], [-122.44341, 37.73894], [-122.44347, 37.73903], [-122.44356, 37.73911], [-122.44367, 37.73917], [-122.44368, 37.73938]]], [[[-122.44373, 37.73995], [-122.44352, 37.73987], [-122.44296, 37.73975], [-122.44281, 37.73967], [-122.44271, 37.7396], [-122.4437, 37.73954], [-122.44373, 37.73995]]], [[[-122.44456, 37.74017], [-122.44413, 37.74021], [-122.44402, 37.74012], [-122.44397, 37.7396], [-122.44443, 37.73996], [-122.44456, 37.74017]]], [[[-122.44606, 37.74084], [-122.44535, 37.74089], [-122.44491, 37.74082], [-122.44474, 37.74076], [-122.44454, 37.74065], [-122.44437, 37.7405], [-122.44425, 37.74033], [-122.44464, 37.7403], [-122.4448, 37.74057], [-122.4449, 37.74061], [-122.44511, 37.74067], [-122.44576, 37.74076], [-122.44606, 37.74084]]], [[[-122.44842, 37.74265], [-122.44711, 37.74253], [-122.44681, 37.74245], [-122.44656, 37.74233], [-122.44641, 37.74222], [-122.4463, 37.74206], [-122.44626, 37.74193], [-122.44622, 37.7415], [-122.44617, 37.74137], [-122.44609, 37.74122], [-122.44609, 37.74118], [-122.4462, 37.74109], [-122.44632, 37.74106], [-122.44643, 37.74117], [-122.44652, 37.74132], [-122.44657, 37.74144], [-122.4466, 37.74158], [-122.44659, 37.74176], [-122.44665, 37.74191], [-122.44677, 37.74209], [-122.44687, 37.74219], [-122.44699, 37.74227], [-122.44714, 37.74234], [-122.4473, 37.74235], [-122.44731, 37.74229], [-122.44768, 37.74232], [-122.44765, 37.7425], [-122.44842, 37.74257], [-122.44842, 37.74265]]], [[[-122.44946, 37.74283], [-122.44941, 37.7429], [-122.44925, 37.74282], [-122.44905, 37.74275], [-122.44863, 37.74267], [-122.44863, 37.74259], [-122.44905, 37.74267], [-122.44926, 37.74274], [-122.44946, 37.74283]]], [[[-122.45165, 37.74524], [-122.45158, 37.74527], [-122.45152, 37.74525], [-122.45075, 37.74432], [-122.45075, 37.74419], [-122.45081, 37.74427], [-122.45083, 37.74426], [-122.45083, 37.74424], [-122.45093, 37.74441], [-122.45165, 37.74524]]]]} | Open Access 1 | 5544 | Reservoir Lands (Glen Park) | 24301 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 10.112 | Reservoir Lands (Glen Park) | None 79 | |||
1088 | 1088 | 1087 | {"type": "Polygon", "coordinates": [[[-118.66774, 34.09258], [-118.6677, 34.09531], [-118.66548, 34.0953], [-118.66549, 34.09463], [-118.66547, 34.09257], [-118.66774, 34.09258]]]} | Open Access 1 | 6487 | Cold Creek Canyon | 29017 | 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 | 15.438 | Cold Creek Canyon | None 99 | |||
1400 | 1400 | 1399 | {"type": "Polygon", "coordinates": [[[-119.87288, 34.43682], [-119.8723, 34.43682], [-119.87211, 34.43667], [-119.872, 34.43654], [-119.87193, 34.43639], [-119.8719, 34.43628], [-119.87195, 34.43605], [-119.87205, 34.43605], [-119.87221, 34.43614], [-119.87248, 34.4365], [-119.87277, 34.43651], [-119.87288, 34.43682]]]} | Open Access 1 | 16492 | Glen Annie at Del Norte | 19314 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.987 | Glen Annie at Del Norte | None 119 | |||
1614 | 1614 | 1613 | {"type": "Polygon", "coordinates": [[[-118.65024, 34.1181], [-118.65024, 34.11939], [-118.6502, 34.12172], [-118.64565, 34.1217], [-118.64568, 34.1181], [-118.65024, 34.1181]]]} | Open Access 1 | 12332 | Secret Valley | 32667 | 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 | 41.753 | Secret Valley | None 129 | |||
2071 | 2071 | 2070 | {"type": "MultiPolygon", "coordinates": [[[[-119.89262, 34.43884], [-119.89269, 34.43916], [-119.89271, 34.4395], [-119.8927, 34.43963], [-119.89265, 34.43988], [-119.89261, 34.4399], [-119.89232, 34.4398], [-119.89214, 34.43966], [-119.89204, 34.43955], [-119.89163, 34.43896], [-119.89154, 34.43885], [-119.89133, 34.43865], [-119.89101, 34.43845], [-119.89073, 34.43834], [-119.89043, 34.43827], [-119.89028, 34.43826], [-119.88921, 34.43829], [-119.88894, 34.43834], [-119.88879, 34.4384], [-119.88854, 34.43802], [-119.88821, 34.43768], [-119.88786, 34.43766], [-119.88737, 34.43779], [-119.8877, 34.43814], [-119.88789, 34.4383], [-119.88793, 34.43836], [-119.888, 34.43839], [-119.8881, 34.4384], [-119.88817, 34.43844], [-119.88764, 34.43883], [-119.88746, 34.43904], [-119.88774, 34.43919], [-119.88766, 34.43931], [-119.88757, 34.43951], [-119.88754, 34.43952], [-119.88704, 34.43953], [-119.88708, 34.4393], [-119.88708, 34.43889], [-119.8874, 34.43825], [-119.88673, 34.43805], [-119.88627, 34.43734], [-119.88582, 34.43694], [-119.88519, 34.43694], [-119.88516, 34.43552], [-119.88529, 34.43552], [-119.88647, 34.43593], [-119.88718, 34.43652], [-119.89012, 34.43693], [-119.89012, 34.43702], [-119.88961, 34.437], [-119.88989, 34.43746], [-119.89066, 34.43751], [-119.89169, 34.43778], [-119.89209, 34.4381], [-119.8921, 34.43842], [-119.89218, 34.43853], [-119.8923, 34.43889], [-119.89262, 34.43884]]], [[[-119.88793, 34.44143], [-119.88788, 34.44135], [-119.88786, 34.44123], [-119.88781, 34.44124], [-119.88781, 34.44143], [-119.88746, 34.44144], [-119.88744, 34.44058], [-119.88687, 34.44047], [-119.88701, 34.43969], [-119.88749, 34.43967], [-119.88754, 34.4397], [-119.88757, 34.43995], [-119.88763, 34.44013], [-119.88767, 34.44021], [-119.88793, 34.44059], [-119.88803, 34.44081], [-119.88807, 34.44093], [-119.88815, 34.4414], [-119.88811, 34.44143], [-119.88793, 34.44143]]]]} | Open Access 1 | 15735 | Evergreen Acres | 18765 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 28.758 | Evergreen Acres | None 163 | |||
2408 | 2408 | 2407 | {"type": "Polygon", "coordinates": [[[-121.0023, 37.25798], [-121.00198, 37.25807], [-121.00186, 37.25773], [-121.00217, 37.25766], [-121.0023, 37.25798]]]} | Open Access 1 | 17242 | Library | 21216 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 0.28 | Library | None 201 | |||
2535 | 2535 | 2534 | {"type": "Polygon", "coordinates": [[[-119.88382, 34.43947], [-119.88316, 34.43948], [-119.88316, 34.43906], [-119.88317, 34.43903], [-119.8832, 34.43902], [-119.88379, 34.43902], [-119.88381, 34.43905], [-119.88382, 34.43947]]]} | Open Access 1 | 17758 | Bella Vista III | 15978 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.76 | Bella Vista III | None 208 | |||
2827 | 2827 | 2826 | {"type": "Polygon", "coordinates": [[[-123.35157, 38.74579], [-123.34595, 38.75146], [-123.34467, 38.75147], [-123.34463, 38.75104], [-123.34467, 38.75081], [-123.34467, 38.75048], [-123.3446, 38.74979], [-123.34462, 38.74965], [-123.34469, 38.74948], [-123.3448, 38.74935], [-123.34489, 38.74928], [-123.34501, 38.74924], [-123.34538, 38.74919], [-123.34563, 38.74912], [-123.34655, 38.74867], [-123.34697, 38.74845], [-123.34716, 38.74831], [-123.34759, 38.74796], [-123.34798, 38.74758], [-123.34816, 38.74738], [-123.34831, 38.74715], [-123.34849, 38.74679], [-123.34856, 38.74646], [-123.34856, 38.74625], [-123.34862, 38.74602], [-123.34891, 38.74524], [-123.34929, 38.74454], [-123.34942, 38.74438], [-123.34971, 38.74414], [-123.34987, 38.74391], [-123.34991, 38.74379], [-123.34994, 38.74357], [-123.34999, 38.74332], [-123.35017, 38.74288], [-123.35041, 38.74316], [-123.35054, 38.74344], [-123.35061, 38.74351], [-123.35068, 38.74355], [-123.35115, 38.74372], [-123.35137, 38.74388], [-123.35177, 38.74439], [-123.35189, 38.7446], [-123.35193, 38.74474], [-123.3519, 38.74493], [-123.35179, 38.74512], [-123.35157, 38.74535], [-123.35157, 38.74579]]]} | Open Access 1 | 950 | Soda Springs | 25589 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 43.51 | Soda Springs | None 234 | |||
2870 | 2870 | 2869 | {"type": "Polygon", "coordinates": [[[-121.26253, 38.63482], [-121.26223, 38.63496], [-121.26189, 38.63458], [-121.26213, 38.63445], [-121.26232, 38.63458], [-121.26253, 38.63482]]]} | Open Access 1 | 22211 | County Of Sacramento | 17713 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.387 | County Of Sacramento | None 238 | |||
2871 | 2871 | 2870 | {"type": "Polygon", "coordinates": [[[-121.35463, 38.5704], [-121.35403, 38.57048], [-121.35403, 38.57049], [-121.35418, 38.57064], [-121.35335, 38.57103], [-121.35193, 38.56789], [-121.3508, 38.56544], [-121.35129, 38.5652], [-121.35141, 38.56534], [-121.35162, 38.56568], [-121.35254, 38.56755], [-121.35262, 38.56769], [-121.35291, 38.56809], [-121.35322, 38.56887], [-121.35369, 38.5699], [-121.35378, 38.57004], [-121.354, 38.57024], [-121.35417, 38.57033], [-121.3544, 38.5704], [-121.35463, 38.5704]]]} | Open Access 1 | 22213 | County Of Sacramento | 17713 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 10.921 | County Of Sacramento | None 239 | |||
3103 | 3103 | 3102 | {"type": "Polygon", "coordinates": [[[-121.19386, 38.68632], [-121.1938, 38.68658], [-121.19368, 38.68675], [-121.19349, 38.68696], [-121.19364, 38.68726], [-121.19279, 38.68725], [-121.19296, 38.68688], [-121.19322, 38.68659], [-121.19337, 38.68648], [-121.19386, 38.68632]]]} | Open Access 1 | 21437 | Hennemen | 19819 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.241 | Hennemen | None 252 | |||
3104 | 3104 | 3103 | {"type": "Polygon", "coordinates": [[[-121.21365, 38.69062], [-121.21364, 38.69096], [-121.21285, 38.69062], [-121.21281, 38.69064], [-121.21278, 38.69063], [-121.21279, 38.6906], [-121.21277, 38.69058], [-121.21265, 38.69053], [-121.21197, 38.69046], [-121.21179, 38.69018], [-121.21179, 38.68988], [-121.21132, 38.68988], [-121.21132, 38.68978], [-121.21179, 38.68979], [-121.21215, 38.69], [-121.21225, 38.69001], [-121.21238, 38.69011], [-121.21327, 38.69049], [-121.21365, 38.69062]]]} | Open Access 1 | 21439 | Country Rose Estates | 17703 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.779 | Country Rose Estates | None 253 | |||
3105 | 3105 | 3104 | {"type": "Polygon", "coordinates": [[[-121.07628, 38.89266], [-121.07612, 38.89269], [-121.07591, 38.89206], [-121.07581, 38.89192], [-121.07522, 38.89193], [-121.07519, 38.89128], [-121.07542, 38.89125], [-121.07618, 38.89131], [-121.07614, 38.89251], [-121.07628, 38.89266]]]} | Open Access 1 | 21440 | Bernhard House | 16030 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 1.81 | Bernhard House | None 254 | |||
3251 | 3251 | 3250 | {"type": "Polygon", "coordinates": [[[-118.29179, 33.95328], [-118.2918, 33.95365], [-118.29183, 33.9538], [-118.29183, 33.9539], [-118.29183, 33.95646], [-118.29181, 33.95682], [-118.29178, 33.957], [-118.29171, 33.95701], [-118.29167, 33.95699], [-118.29163, 33.95683], [-118.29164, 33.95301], [-118.29179, 33.95328]]]} | Open Access 1 | 48155 | Vermont Median | 32692 | 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/vermont-median/ | Los Angeles 6 | 1.804 | Vermont Median | None 267 | ||
3367 | 3367 | 3366 | {"type": "Polygon", "coordinates": [[[-120.03019, 41.82727], [-120.03008, 41.83089], [-120.02524, 41.8308], [-120.02535, 41.82718], [-120.03019, 41.82727]]]} | Open Access 1 | 24348 | County Government Land | 17712 | 341 | Modoc, County of 629 | County 3 | County Agency 3 | http://www.co.modoc.ca.us/departments/parks-recreation | County 3 | 341 | Modoc, County of 618 | County 3 | County Agency 3 | Modoc 56 | 39.993 | County Government Land | None 276 | |||
3493 | 3493 | 3492 | {"type": "Polygon", "coordinates": [[[-119.84774, 36.85682], [-119.84773, 36.85954], [-119.84741, 36.8595], [-119.84434, 36.86227], [-119.84328, 36.8623], [-119.84113, 36.86119], [-119.8391, 36.85984], [-119.83905, 36.85717], [-119.84175, 36.85772], [-119.84229, 36.85626], [-119.8449, 36.85685], [-119.84774, 36.85682]]]} | Open Access 1 | 25924 | Scout Island | 25217 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 88.577 | Scout Island | None 291 | |||
3601 | 3601 | 3600 | {"type": "MultiPolygon", "coordinates": [[[[-121.85226, 37.38638], [-121.8517, 37.38678], [-121.84999, 37.38813], [-121.84975, 37.38828], [-121.84945, 37.38842], [-121.84944, 37.38838], [-121.85006, 37.38798], [-121.85006, 37.38796], [-121.84987, 37.38783], [-121.85011, 37.38763], [-121.85023, 37.38778], [-121.85081, 37.38712], [-121.8512, 37.38685], [-121.85151, 37.38647], [-121.85171, 37.38635], [-121.85226, 37.38638]]], [[[-121.8717, 37.37057], [-121.87117, 37.37057], [-121.87095, 37.37043], [-121.87064, 37.37051], [-121.86992, 37.37065], [-121.86924, 37.37057], [-121.8692, 37.3705], [-121.86676, 37.37021], [-121.86657, 37.3702], [-121.86634, 37.37021], [-121.86595, 37.37028], [-121.86565, 37.37039], [-121.86544, 37.37049], [-121.86287, 37.37227], [-121.86274, 37.37237], [-121.86252, 37.3726], [-121.86243, 37.37272], [-121.86232, 37.37295], [-121.86225, 37.37319], [-121.8622, 37.37382], [-121.86203, 37.37448], [-121.86205, 37.37456], [-121.8621, 37.37463], [-121.86223, 37.3747], [-121.86221, 37.37506], [-121.86222, 37.37604], [-121.86227, 37.3762], [-121.86235, 37.37636], [-121.86312, 37.37716], [-121.86253, 37.3777], [-121.86248, 37.37771], [-121.86245, 37.37771], [-121.86128, 37.37648], [-121.86152, 37.37246], [-121.86147, 37.37241], [-121.86171, 37.37224], [-121.86176, 37.37229], [-121.86466, 37.37034], [-121.86466, 37.37032], [-121.8645, 37.37036], [-121.86575, 37.36952], [-121.86589, 37.36949], [-121.86599, 37.36949], [-121.86606, 37.3695], [-121.86615, 37.36954], [-121.86782, 37.3697], [-121.86789, 37.36974], [-121.86791, 37.36972], [-121.86851, 37.36982], [-121.86876, 37.36991], [-121.86895, 37.36995], [-121.86908, 37.37003], [-121.8692, 37.37008], [-121.8693, 37.37008], [-121.8694, 37.37001], [-121.87017, 37.37015], [-121.87028, 37.37018], [-121.87029, 37.37016], [-121.87117, 37.3698], [-121.8717, 37.37057]]]]} | Open Access 1 | 29198 | Penitencia Creek Park Chain | 23583 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 27.686 | Penitencia Creek Park Chain | None 301 |
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]);