units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where YR_EST = 1998
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, DES_TP
MNG_AG_TYP 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
213 | 213 | 212 | {"type": "Polygon", "coordinates": [[[-121.44057, 41.00434], [-121.44008, 41.00444], [-121.44004, 41.00437], [-121.43945, 41.00437], [-121.43934, 41.00404], [-121.43939, 41.00396], [-121.44023, 41.00367], [-121.44032, 41.00373], [-121.44038, 41.00381], [-121.44057, 41.00434]]]} | Open Access 1 | 663 | Fall River Mills Ecological Reserve | 32163 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Fall-River-Mills-ER | Shasta 27 | 1.448 | Fall River Mills ER | 1998 | State Conservation Area 8 | 2 |
261 | 261 | 260 | {"type": "Polygon", "coordinates": [[[-122.16261, 37.9746], [-122.1626, 37.9801], [-122.16254, 37.98012], [-122.16252, 37.98011], [-122.16149, 37.98051], [-122.16049, 37.98141], [-122.1587, 37.98292], [-122.15833, 37.98316], [-122.15779, 37.98345], [-122.15791, 37.98902], [-122.15339, 37.98907], [-122.15338, 37.98794], [-122.15359, 37.97455], [-122.16261, 37.9746]]]} | Open Access 1 | 884 | Sky Ranch | 7292 | 3045 | John Muir Land Trust 108 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jmlt.org/ | Non Governmental Organization 10 | 3045 | John Muir Land Trust 105 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.muirheritagelandtrust.org/sky_ranch.html | Contra Costa 12 | 233.641 | Sky Ranch | 1998 | Private Conservation 16 | 2 |
1397 | 1397 | 1396 | {"type": "MultiPolygon", "coordinates": [[[[-121.79422, 37.23369], [-121.79422, 37.23411], [-121.79394, 37.2341], [-121.79396, 37.23297], [-121.7941, 37.23298], [-121.79415, 37.23301], [-121.79415, 37.2334], [-121.79412, 37.23355], [-121.79415, 37.23363], [-121.79422, 37.23369]]], [[[-121.79425, 37.23083], [-121.79424, 37.23137], [-121.79415, 37.23143], [-121.79411, 37.23151], [-121.79411, 37.23157], [-121.79414, 37.2317], [-121.79414, 37.23196], [-121.79409, 37.23208], [-121.7941, 37.23215], [-121.79413, 37.2322], [-121.79422, 37.23227], [-121.79422, 37.23281], [-121.79396, 37.23281], [-121.79398, 37.23083], [-121.79425, 37.23083]]], [[[-121.79425, 37.23012], [-121.79425, 37.23066], [-121.79397, 37.23067], [-121.79398, 37.23012], [-121.79425, 37.23012]]]]} | Open Access 1 | 8689 | Albertson Parkway | 15341 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 2.047 | Albertson Parkway | 1998 | Local Recreation Area 3 | 4 | |
1573 | 1573 | 1572 | {"type": "Polygon", "coordinates": [[[-122.6827, 38.37594], [-122.67746, 38.37597], [-122.67742, 38.37485], [-122.67626, 38.37485], [-122.67625, 38.37486], [-122.67626, 38.37627], [-122.67517, 38.37592], [-122.67173, 38.37464], [-122.67171, 38.3738], [-122.67535, 38.37375], [-122.67531, 38.37112], [-122.67644, 38.37111], [-122.67646, 38.37237], [-122.68263, 38.37226], [-122.6827, 38.37594]]]} | No Public Access 3 | 47544 | Oken | 31257 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 77.773 | Oken | 1998 | None 126 | ||
2015 | 2015 | 2014 | {"type": "Polygon", "coordinates": [[[-122.24953, 38.33972], [-122.2495, 38.33982], [-122.24681, 38.34172], [-122.24631, 38.34201], [-122.24589, 38.3422], [-122.24419, 38.34269], [-122.2439, 38.34282], [-122.24389, 38.34308], [-122.24364, 38.34288], [-122.24369, 38.3377], [-122.2464, 38.33768], [-122.24636, 38.33853], [-122.24837, 38.33907], [-122.24953, 38.33972]]]} | Restricted Access 2 | 16953 | Hills / Bergen Addition | 19975 | 3035 | Land Trust of Napa County 140 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.napalandtrust.org/ | Non Governmental Organization 10 | 3035 | Land Trust of Napa County 137 | Non Profit 6 | Non Profit - Land Trust 10 | Napa 11 | 45.324 | Hills / Bergen Addition | 1998 | Private Conservation 16 | 2 | |
2286 | 2286 | 2285 | {"type": "Polygon", "coordinates": [[[-122.77518, 38.5124], [-122.77517, 38.51382], [-122.77439, 38.51382], [-122.77438, 38.51457], [-122.77441, 38.51462], [-122.77411, 38.51462], [-122.77416, 38.51461], [-122.77419, 38.51457], [-122.77419, 38.51408], [-122.77381, 38.51408], [-122.77007, 38.51134], [-122.77015, 38.51127], [-122.77266, 38.51126], [-122.77306, 38.5114], [-122.7732, 38.51147], [-122.77398, 38.51204], [-122.77415, 38.51213], [-122.77433, 38.5122], [-122.77453, 38.51225], [-122.77453, 38.5124], [-122.77518, 38.5124]]]} | Restricted Access 2 | 16876 | Haroutunian - North | 19687 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 17.875 | Haroutunian - North | 1998 | None 190 | ||
2829 | 2829 | 2828 | {"type": "MultiPolygon", "coordinates": [[[[-121.90675, 36.49739], [-121.90673, 36.50102], [-121.90221, 36.50098], [-121.90222, 36.50821], [-121.90218, 36.50822], [-121.90219, 36.51184], [-121.89773, 36.51178], [-121.89769, 36.5118], [-121.89768, 36.51303], [-121.89645, 36.51258], [-121.89643, 36.5126], [-121.8964, 36.5126], [-121.89572, 36.51561], [-121.88356, 36.50521], [-121.8826, 36.50435], [-121.88418, 36.50437], [-121.8842, 36.50081], [-121.88872, 36.50083], [-121.88876, 36.49724], [-121.90675, 36.49739]]], [[[-121.92476, 36.51831], [-121.9219, 36.51998], [-121.91891, 36.52179], [-121.91077, 36.52017], [-121.90666, 36.51653], [-121.90673, 36.51189], [-121.91565, 36.51192], [-121.91564, 36.51012], [-121.92009, 36.51014], [-121.92012, 36.51091], [-121.92457, 36.51093], [-121.92476, 36.51831]]], [[[-121.9098, 36.50829], [-121.90903, 36.50905], [-121.90898, 36.51153], [-121.90673, 36.51153], [-121.90672, 36.50851], [-121.90869, 36.50852], [-121.9087, 36.50828], [-121.9098, 36.50829]]], [[[-121.9379, 36.51209], [-121.93641, 36.51184], [-121.93574, 36.51282], [-121.93567, 36.51306], [-121.93098, 36.51383], [-121.93099, 36.50959], [-121.92896, 36.50799], [-121.92945, 36.50798], [-121.92967, 36.50784], [-121.92986, 36.5078], [-121.93061, 36.50786], [-121.93112, 36.50798], [-121.93188, 36.50784], [-121.93233, 36.50812], [-121.93274, 36.50805], [-121.93272, 36.50791], [-121.93315, 36.50797], [-121.93359, 36.50829], [-121.93399, 36.50793], [-121.93423, 36.50787], [-121.935, 36.50814], [-121.93512, 36.50811], [-121.93537, 36.50817], [-121.93548, 36.50813], [-121.93556, 36.50813], [-121.9356, 36.5082], [-121.93622, 36.50826], [-121.93683, 36.50864], [-121.93703, 36.50879], [-121.93722, 36.50895], [-121.93742, 36.50917], [-121.93757, 36.50936], [-121.93769, 36.50956], [-121.93779, 36.50977], [-121.93791, 36.51012], [-121.93796, 36.51048], [-121.93796, 36.51121], [-121.9379, 36.51209]]]]} | No Public Access 3 | 18696 | Point Lobos Ranch | 23853 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Monterey 14 | 1115.979 | Point Lobos Ranch | 1998 | State Park 15 | 4 | |
3982 | 3982 | 3981 | {"type": "Polygon", "coordinates": [[[-121.89406, 37.32792], [-121.89275, 37.32857], [-121.89265, 37.3285], [-121.8925, 37.32845], [-121.89138, 37.32763], [-121.8911, 37.32724], [-121.89105, 37.32715], [-121.89102, 37.32702], [-121.89101, 37.32684], [-121.89111, 37.3266], [-121.89112, 37.32646], [-121.89111, 37.32609], [-121.89113, 37.32566], [-121.89146, 37.32555], [-121.89168, 37.32557], [-121.89406, 37.32792]]]} | Open Access 1 | 38017 | Discovery Meadow | 18164 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 11.493 | Discovery Meadow | 1998 | None 345 | ||
5738 | 5738 | 5737 | {"type": "Polygon", "coordinates": [[[-115.39721, 32.70888], [-115.3965, 32.71603], [-115.39651, 32.72278], [-115.39116, 32.72283], [-115.38802, 32.73027], [-115.38802, 32.73065], [-115.38463, 32.73065], [-115.38568, 32.72835], [-115.38577, 32.72807], [-115.38586, 32.72762], [-115.38709, 32.72343], [-115.38805, 32.72342], [-115.38806, 32.72285], [-115.38725, 32.72285], [-115.38738, 32.72244], [-115.38807, 32.72065], [-115.38808, 32.71976], [-115.38837, 32.71975], [-115.38893, 32.71803], [-115.3902, 32.71249], [-115.39188, 32.70941], [-115.39232, 32.70913], [-115.39232, 32.70888], [-115.39721, 32.70888]]]} | Open Access 1 | 1634 | Heber Dunes State Vehicular Recreation Area | 1560 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=408 | Imperial 20 | 325.49 | Heber Dunes SVRA | 1998 | State Recreation Area 39 | 4 |
6334 | 6334 | 6333 | {"type": "MultiPolygon", "coordinates": [[[[-120.64648, 35.26403], [-120.6472, 35.26495], [-120.64806, 35.26558], [-120.65018, 35.26686], [-120.65005, 35.26688], [-120.65051, 35.26715], [-120.6505, 35.26724], [-120.65042, 35.26725], [-120.65016, 35.26742], [-120.65007, 35.26754], [-120.65021, 35.26759], [-120.65035, 35.26745], [-120.65045, 35.26738], [-120.65055, 35.26736], [-120.65064, 35.26737], [-120.65075, 35.26743], [-120.65084, 35.26751], [-120.65095, 35.26769], [-120.65107, 35.26796], [-120.65113, 35.26821], [-120.65121, 35.26863], [-120.65115, 35.26905], [-120.65112, 35.2692], [-120.6511, 35.26907], [-120.65069, 35.26907], [-120.65068, 35.26822], [-120.65061, 35.26821], [-120.65061, 35.26808], [-120.64979, 35.26807], [-120.64979, 35.26784], [-120.64983, 35.26767], [-120.6499, 35.26748], [-120.64949, 35.26732], [-120.64925, 35.26727], [-120.64799, 35.26586], [-120.64717, 35.26522], [-120.64705, 35.26501], [-120.64543, 35.26502], [-120.64631, 35.26418], [-120.6441, 35.26144], [-120.64438, 35.26143], [-120.64607, 35.26355], [-120.64648, 35.26403]]], [[[-120.6551, 35.27467], [-120.65496, 35.27451], [-120.65502, 35.27417], [-120.65502, 35.27394], [-120.655, 35.27378], [-120.65496, 35.27356], [-120.65486, 35.27327], [-120.65477, 35.2731], [-120.65245, 35.26974], [-120.65236, 35.26973], [-120.65236, 35.26961], [-120.65211, 35.26932], [-120.65193, 35.26903], [-120.65131, 35.26903], [-120.65137, 35.26862], [-120.65123, 35.2679], [-120.65103, 35.2675], [-120.6509, 35.26736], [-120.65104, 35.26744], [-120.65135, 35.26773], [-120.65214, 35.26877], [-120.65262, 35.26946], [-120.65269, 35.26961], [-120.65408, 35.27162], [-120.65489, 35.27288], [-120.65481, 35.27292], [-120.65499, 35.2733], [-120.65518, 35.27398], [-120.65519, 35.2742], [-120.65518, 35.27438], [-120.6551, 35.27467]]]]} | Open Access 1 | 1645 | Railroad Safety Trail | 28708 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 17.512 | Railroad Safety Trail | 1998 | Local Recreation Area 3 | 4 | |
7768 | 7768 | 7767 | {"type": "MultiPolygon", "coordinates": [[[[-121.91337, 37.21541], [-121.91338, 37.21573], [-121.9133, 37.21598], [-121.91283, 37.21682], [-121.91283, 37.21688], [-121.91264, 37.21704], [-121.91146, 37.21738], [-121.90988, 37.21769], [-121.90972, 37.21775], [-121.90935, 37.21795], [-121.9092, 37.21805], [-121.90907, 37.21818], [-121.90898, 37.21835], [-121.90896, 37.21847], [-121.90898, 37.2186], [-121.90906, 37.21877], [-121.90945, 37.21929], [-121.90958, 37.21953], [-121.90962, 37.21968], [-121.90963, 37.21981], [-121.9096, 37.21994], [-121.90954, 37.22007], [-121.90939, 37.22022], [-121.90915, 37.22038], [-121.9089, 37.22058], [-121.90879, 37.22068], [-121.90869, 37.22086], [-121.90861, 37.22116], [-121.90855, 37.22132], [-121.90845, 37.22147], [-121.90836, 37.22158], [-121.90828, 37.22164], [-121.90818, 37.22167], [-121.90742, 37.22181], [-121.90727, 37.22185], [-121.90707, 37.22197], [-121.90694, 37.22213], [-121.9059, 37.22399], [-121.90585, 37.22411], [-121.90583, 37.22424], [-121.90582, 37.22448], [-121.90585, 37.22464], [-121.90594, 37.22479], [-121.90618, 37.22508], [-121.90627, 37.22525], [-121.9061, 37.22548], [-121.90528, 37.22593], [-121.90453, 37.22627], [-121.90415, 37.22638], [-121.90407, 37.22636], [-121.90405, 37.22635], [-121.90398, 37.22619], [-121.90466, 37.22602], [-121.90536, 37.22565], [-121.90585, 37.22538], [-121.90604, 37.22522], [-121.90553, 37.22437], [-121.90571, 37.22391], [-121.90632, 37.22303], [-121.9067, 37.22208], [-121.90757, 37.22161], [-121.90795, 37.22168], [-121.90833, 37.22138], [-121.90835, 37.22089], [-121.90907, 37.22031], [-121.90929, 37.22022], [-121.90937, 37.21976], [-121.90935, 37.21926], [-121.90876, 37.21865], [-121.909, 37.21809], [-121.90978, 37.21752], [-121.91034, 37.21739], [-121.91117, 37.21728], [-121.91184, 37.21704], [-121.91219, 37.21698], [-121.91254, 37.21679], [-121.91282, 37.21654], [-121.91283, 37.21644], [-121.91298, 37.2163], [-121.9131, 37.21558], [-121.91301, 37.2153], [-121.91282, 37.2151], [-121.91245, 37.21453], [-121.9122, 37.21392], [-121.91196, 37.21364], [-121.91069, 37.2135], [-121.90989, 37.21358], [-121.9092, 37.21339], [-121.90897, 37.21268], [-121.90866, 37.21232], [-121.90677, 37.2109], [-121.9061, 37.21129], [-121.90478, 37.21127], [-121.90385, 37.21062], [-121.90349, 37.20986], [-121.90221, 37.2094], [-121.90166, 37.20902], [-121.9015, 37.20793], [-121.9001, 37.20744], [-121.89927, 37.20682], [-121.89887, 37.2068], [-121.89907, 37.20665], [-121.89937, 37.20666], [-121.90016, 37.20728], [-121.90167, 37.20782], [-121.90187, 37.20885], [-121.90237, 37.20926], [-121.90366, 37.20973], [-121.90406, 37.21051], [-121.90488, 37.2111], [-121.90598, 37.21111], [-121.90676, 37.21066], [-121.90786, 37.21151], [-121.90885, 37.21217], [-121.90914, 37.21254], [-121.90936, 37.21322], [-121.90988, 37.21339], [-121.91069, 37.21331], [-121.91168, 37.21341], [-121.91202, 37.21346], [-121.91215, 37.21359], [-121.91217, 37.21355], [-121.91233, 37.21362], [-121.91261, 37.21437], [-121.91282, 37.21463], [-121.91282, 37.2147], [-121.91293, 37.21478], [-121.91337, 37.21541]]], [[[-121.90434, 37.22877], [-121.90427, 37.22967], [-121.90399, 37.23037], [-121.90361, 37.23118], [-121.9034, 37.23133], [-121.903, 37.23149], [-121.90293, 37.23154], [-121.90288, 37.2316], [-121.90284, 37.23167], [-121.90247, 37.23206], [-121.90274, 37.23206], [-121.90244, 37.23221], [-121.90228, 37.23238], [-121.90199, 37.23246], [-121.90193, 37.23246], [-121.90181, 37.23258], [-121.90175, 37.23271], [-121.90145, 37.23298], [-121.90117, 37.23312], [-121.90061, 37.23332], [-121.89995, 37.23334], [-121.8996, 37.23363], [-121.89954, 37.23364], [-121.89906, 37.23292], [-121.89868, 37.23329], [-121.89862, 37.23324], [-121.89848, 37.23318], [-121.89819, 37.23314], [-121.8981, 37.23313], [-121.8977, 37.23324], [-121.89745, 37.23336], [-121.89727, 37.23352], [-121.89655, 37.23425], [-121.89588, 37.23481], [-121.89611, 37.23508], [-121.89399, 37.23616], [-121.89279, 37.23567], [-121.89162, 37.23626], [-121.89169, 37.23796], [-121.89026, 37.23961], [-121.88867, 37.23781], [-121.88855, 37.23792], [-121.88694, 37.23855], [-121.88682, 37.23805], [-121.88683, 37.23801], [-121.88721, 37.2379], [-121.88743, 37.2378], [-121.88829, 37.23734], [-121.88855, 37.23717], [-121.88878, 37.23697], [-121.88913, 37.23652], [-121.88928, 37.23634], [-121.88966, 37.236], [-121.88993, 37.23578], [-121.89016, 37.23563], [-121.89082, 37.23523], [-121.89207, 37.2345], [-121.89246, 37.23433], [-121.89322, 37.23409], [-121.89351, 37.23395], [-121.8939, 37.23371], [-121.89399, 37.23354], [-121.89424, 37.23322], [-121.89444, 37.23268], [-121.89467, 37.23234], [-121.89496, 37.23234], [-121.89496, 37.23239], [-121.89498, 37.23243], [-121.89504, 37.23247], [-121.8951, 37.23248], [-121.89591, 37.23249], [-121.89624, 37.23247], [-121.89643, 37.23243], [-121.89663, 37.23237], [-121.89681, 37.23229], [-121.89699, 37.23217], [-121.89703, 37.23216], [-121.89707, 37.23217], [-121.89718, 37.23225], [-121.89735, 37.23233], [-121.89759, 37.2324], [-121.89776, 37.23242], [-121.8979, 37.23242], [-121.89836, 37.23236], [-121.89857, 37.23234], [-121.89965, 37.23238], [-121.89986, 37.23237], [-121.90023, 37.23232], [-121.90057, 37.23223], [-121.90089, 37.23209], [-121.90121, 37.23189], [-121.90141, 37.23172], [-121.90164, 37.23146], [-121.90212, 37.23057], [-121.90235, 37.23023], [-121.90274, 37.22974], [-121.90284, 37.22956], [-121.90294, 37.22935], [-121.90303, 37.22892], [-121.90303, 37.2286], [-121.903, 37.22844], [-121.9027, 37.2274], [-121.90249, 37.22673], [-121.90316, 37.22625], [-121.90328, 37.22624], [-121.90336, 37.22628], [-121.90345, 37.22642], [-121.90356, 37.22669], [-121.9036, 37.22683], [-121.90358, 37.22749], [-121.90365, 37.22778], [-121.90374, 37.22778], [-121.90391, 37.22802], [-121.90401, 37.22851], [-121.90416, 37.22861], [-121.90434, 37.22877]]], [[[-121.88664, 37.23864], [-121.88642, 37.23872], [-121.88642, 37.23875], [-121.88623, 37.23882], [-121.88622, 37.23881], [-121.88605, 37.23887], [-121.88604, 37.23889], [-121.88582, 37.23898], [-121.88558, 37.23914], [-121.88569, 37.23945], [-121.88604, 37.24032], [-121.88343, 37.24172], [-121.88313, 37.24139], [-121.88231, 37.24182], [-121.88174, 37.24115], [-121.88165, 37.24123], [-121.88245, 37.24218], [-121.8805, 37.24322], [-121.88041, 37.24323], [-121.87886, 37.24438], [-121.87548, 37.24514], [-121.87551, 37.24536], [-121.87505, 37.24548], [-121.87496, 37.24525], [-121.87495, 37.24506], [-121.875, 37.24426], [-121.87512, 37.24341], [-121.87574, 37.2434], [-121.87692, 37.24332], [-121.87786, 37.24282], [-121.87904, 37.24232], [-121.87937, 37.24214], [-121.87967, 37.24193], [-121.88046, 37.24121], [-121.88073, 37.24103], [-121.88096, 37.2409], [-121.88179, 37.24049], [-121.88207, 37.24037], [-121.88342, 37.23991], [-121.88373, 37.23977], [-121.88403, 37.23961], [-121.8843, 37.23942], [-121.88458, 37.23917], [-121.88479, 37.23894], [-121.88504, 37.23861], [-121.88516, 37.23849], [-121.88541, 37.2383], [-121.88565, 37.23818], [-121.88606, 37.23807], [-121.88634, 37.23803], [-121.88646, 37.23805], [-121.88652, 37.2381], [-121.88664, 37.23864]]]]} | Open Access 1 | 47650 | Guadalupe Creek Parkchain | 31394 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 150.151 | Guadalupe Creek Parkchain | 1998 | None 644 | ||
8506 | 8506 | 8505 | {"type": "MultiPolygon", "coordinates": [[[[-121.8745, 37.24237], [-121.87114, 37.24308], [-121.86974, 37.24299], [-121.86921, 37.24284], [-121.86916, 37.24032], [-121.86917, 37.23982], [-121.87002, 37.23903], [-121.8703, 37.23842], [-121.86993, 37.23811], [-121.8704, 37.23744], [-121.87043, 37.23726], [-121.87032, 37.23705], [-121.87024, 37.23673], [-121.87044, 37.2367], [-121.87153, 37.2368], [-121.87286, 37.23664], [-121.87313, 37.23707], [-121.87327, 37.23783], [-121.87198, 37.23837], [-121.87207, 37.23927], [-121.87209, 37.23928], [-121.87353, 37.23875], [-121.87432, 37.24069], [-121.87452, 37.2413], [-121.87459, 37.24175], [-121.87458, 37.24219], [-121.8745, 37.24237]]], [[[-121.87421, 37.24683], [-121.87403, 37.248], [-121.87327, 37.24818], [-121.87217, 37.24946], [-121.87134, 37.24941], [-121.87124, 37.25039], [-121.86991, 37.25028], [-121.87066, 37.24708], [-121.87073, 37.2471], [-121.87233, 37.24556], [-121.87239, 37.24556], [-121.87276, 37.24568], [-121.87286, 37.24589], [-121.87288, 37.24654], [-121.873, 37.24659], [-121.87334, 37.24645], [-121.8734, 37.24649], [-121.87345, 37.2466], [-121.87352, 37.2466], [-121.87359, 37.24666], [-121.87362, 37.24674], [-121.8737, 37.24681], [-121.87388, 37.24683], [-121.87403, 37.24682], [-121.87421, 37.24683]]]]} | Open Access 1 | 13326 | Almaden Lake | 15389 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 86.225 | Almaden Lake | 1998 | None 712 | ||
8587 | 8587 | 8586 | {"type": "Polygon", "coordinates": [[[-121.87643, 37.24514], [-121.87505, 37.24548], [-121.87496, 37.24522], [-121.87496, 37.24514], [-121.87531, 37.24513], [-121.876, 37.24502], [-121.87635, 37.24494], [-121.87643, 37.24514]]]} | Open Access 1 | 13653 | Chris Hotts Park | 17222 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.878 | Chris Hotts Park | 1998 | Local Park 2 | 4 | |
8593 | 8593 | 8592 | {"type": "Polygon", "coordinates": [[[-121.90177, 37.31871], [-121.90143, 37.31907], [-121.90143, 37.31907], [-121.90145, 37.3187], [-121.90177, 37.31871]]]} | Open Access 1 | 13668 | Gregory Plaza Tot Lot | 19501 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.146 | Gregory Plaza Tot Lot | 1998 | Local Recreation Area 3 | 4 | |
8959 | 8959 | 8958 | {"type": "Polygon", "coordinates": [[[-121.87932, 37.71033], [-121.87889, 37.71066], [-121.87865, 37.71097], [-121.8787, 37.71169], [-121.87816, 37.7125], [-121.87229, 37.71242], [-121.87235, 37.70994], [-121.87327, 37.70992], [-121.87444, 37.7098], [-121.87538, 37.70957], [-121.87712, 37.70894], [-121.87827, 37.70876], [-121.87927, 37.70879], [-121.87941, 37.70991], [-121.87932, 37.71033]]]} | Open Access 1 | 14758 | Emerald Glen Park | 18614 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 49.118 | Emerald Glen Park | 1998 | Local Park 2 | 4 | |
9638 | 9638 | 9637 | {"type": "Polygon", "coordinates": [[[-121.89357, 37.23685], [-121.89348, 37.23689], [-121.89352, 37.23696], [-121.89427, 37.23791], [-121.89428, 37.23794], [-121.89425, 37.23798], [-121.89373, 37.23825], [-121.89364, 37.23832], [-121.89355, 37.23842], [-121.89352, 37.23843], [-121.89349, 37.23841], [-121.89266, 37.23737], [-121.8926, 37.23734], [-121.89286, 37.2372], [-121.8927, 37.23699], [-121.89264, 37.23682], [-121.89285, 37.23678], [-121.89292, 37.23697], [-121.89335, 37.23688], [-121.89324, 37.23638], [-121.89339, 37.23647], [-121.89347, 37.23656], [-121.89357, 37.23685]]]} | Open Access 1 | 16281 | Almaden Winery Park | 15391 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 3.606 | Almaden Winery Park | 1998 | Local Park 2 | 4 | |
9764 | 9764 | 9763 | {"type": "MultiPolygon", "coordinates": [[[[-122.77929, 38.89026], [-122.77004, 38.89005], [-122.76995, 38.88925], [-122.76949, 38.88924], [-122.76949, 38.88295], [-122.77003, 38.88295], [-122.77003, 38.88386], [-122.77094, 38.8841], [-122.77094, 38.88206], [-122.77262, 38.88206], [-122.77318, 38.88256], [-122.7732, 38.8842], [-122.77256, 38.8848], [-122.77195, 38.8836], [-122.77156, 38.88428], [-122.7713, 38.88488], [-122.77001, 38.88564], [-122.77, 38.88636], [-122.77079, 38.88756], [-122.77094, 38.88785], [-122.77186, 38.88911], [-122.77411, 38.8901], [-122.77754, 38.88952], [-122.77825, 38.8897], [-122.77831, 38.88934], [-122.77928, 38.88935], [-122.77929, 38.89026]]], [[[-122.77318, 38.88244], [-122.77318, 38.88244], [-122.77277, 38.88206], [-122.77317, 38.88206], [-122.77318, 38.88244]]]]} | Open Access 1 | 17928 | Boggs Lake Ecological Reserve | 32060 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Boggs-Lake-ER | Lake 40 | 42.42 | Boggs Lake ER | 1998 | State Conservation Area 8 | 2 |
12264 | 12264 | 12263 | {"type": "Polygon", "coordinates": [[[-122.34065, 38.43479], [-122.33607, 38.43482], [-122.3342, 38.43477], [-122.33024, 38.43188], [-122.31255, 38.42754], [-122.31252, 38.42674], [-122.30773, 38.42655], [-122.30763, 38.4229], [-122.30341, 38.42274], [-122.30339, 38.41911], [-122.30753, 38.41926], [-122.31223, 38.4194], [-122.31238, 38.42307], [-122.31712, 38.42325], [-122.31731, 38.42695], [-122.32649, 38.42714], [-122.3313, 38.42785], [-122.3314, 38.43135], [-122.33603, 38.4315], [-122.33604, 38.43157], [-122.33849, 38.43177], [-122.34057, 38.43186], [-122.34065, 38.43479]]]} | Open Access 1 | 25818 | Rector Reservoir Wildlife Area | 30490 | 206 | California Department of Veterans Affairs 170 | State 5 | State Agency 5 | http://www.cdva.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Napa 11 | 349.564 | Rector Reservoir Wildlife Area | 1998 | State Conservation Area 8 | 2 | |
15530 | 15530 | 15529 | {"type": "MultiPolygon", "coordinates": [[[[-121.78185, 36.907], [-121.78058, 36.90929], [-121.78003, 36.90997], [-121.78001, 36.90996], [-121.77957, 36.90881], [-121.77992, 36.9084], [-121.78017, 36.90825], [-121.7805, 36.90816], [-121.78062, 36.90806], [-121.78084, 36.90757], [-121.78086, 36.90724], [-121.78104, 36.90676], [-121.78109, 36.90643], [-121.7809, 36.90633], [-121.78068, 36.90633], [-121.78084, 36.90607], [-121.78116, 36.90591], [-121.78124, 36.90598], [-121.78185, 36.907]]], [[[-121.79118, 36.91207], [-121.78804, 36.91346], [-121.78801, 36.91344], [-121.78752, 36.91366], [-121.78741, 36.91367], [-121.78732, 36.91362], [-121.78572, 36.91221], [-121.78347, 36.90873], [-121.78327, 36.90803], [-121.78299, 36.90757], [-121.78302, 36.90722], [-121.78247, 36.90717], [-121.78132, 36.90536], [-121.78121, 36.90501], [-121.78346, 36.90541], [-121.78347, 36.9054], [-121.78339, 36.90527], [-121.78353, 36.90396], [-121.78416, 36.90417], [-121.78453, 36.90434], [-121.78489, 36.90453], [-121.7852, 36.90473], [-121.78674, 36.90593], [-121.78786, 36.90689], [-121.78976, 36.90898], [-121.79013, 36.90949], [-121.7905, 36.9101], [-121.7908, 36.91073], [-121.79102, 36.91139], [-121.79118, 36.91207]]], [[[-121.81321, 36.91185], [-121.81215, 36.91259], [-121.80981, 36.90863], [-121.80903, 36.90862], [-121.8086, 36.90776], [-121.80773, 36.90721], [-121.80786, 36.90653], [-121.80678, 36.90649], [-121.80663, 36.90699], [-121.80672, 36.9076], [-121.8062, 36.90843], [-121.80617, 36.9086], [-121.80291, 36.90858], [-121.803, 36.9068], [-121.80244, 36.89698], [-121.80239, 36.89645], [-121.80563, 36.89841], [-121.80602, 36.89867], [-121.80637, 36.89896], [-121.80659, 36.8992], [-121.80678, 36.89947], [-121.80723, 36.90033], [-121.80761, 36.90121], [-121.80777, 36.90179], [-121.80784, 36.90284], [-121.80796, 36.90327], [-121.80818, 36.90368], [-121.80847, 36.90406], [-121.80877, 36.90434], [-121.80899, 36.90451], [-121.80972, 36.90495], [-121.80985, 36.90512], [-121.80991, 36.90511], [-121.81003, 36.9052], [-121.81033, 36.90553], [-121.8105, 36.90577], [-121.81064, 36.90601], [-121.81075, 36.90627], [-121.81056, 36.9063], [-121.81064, 36.90656], [-121.81082, 36.90702], [-121.81104, 36.90778], [-121.81116, 36.9081], [-121.81131, 36.90841], [-121.81158, 36.90885], [-121.81178, 36.90912], [-121.81221, 36.90964], [-121.8125, 36.9101], [-121.81273, 36.91059], [-121.81296, 36.91131], [-121.81321, 36.91185]]], [[[-121.84027, 36.93839], [-121.83995, 36.93852], [-121.83673, 36.93888], [-121.83567, 36.93828], [-121.83287, 36.93742], [-121.82875, 36.93642], [-121.82699, 36.93585], [-121.82577, 36.9355], [-121.82498, 36.93534], [-121.82463, 36.93488], [-121.82462, 36.93484], [-121.82464, 36.93457], [-121.82455, 36.93425], [-121.82397, 36.9338], [-121.82401, 36.93376], [-121.82401, 36.93375], [-121.82332, 36.9332], [-121.82299, 36.93295], [-121.82251, 36.93231], [-121.82264, 36.93183], [-121.82293, 36.93153], [-121.82296, 36.93155], [-121.82339, 36.93139], [-121.82358, 36.93069], [-121.82336, 36.92926], [-121.82346, 36.92882], [-121.82361, 36.92852], [-121.82374, 36.92842], [-121.82396, 36.92815], [-121.82915, 36.92783], [-121.82916, 36.92782], [-121.82877, 36.92714], [-121.82884, 36.92623], [-121.82942, 36.92507], [-121.83029, 36.92516], [-121.83193, 36.92747], [-121.83266, 36.92732], [-121.83667, 36.93538], [-121.83789, 36.93482], [-121.84027, 36.93839]]], [[[-121.82473, 36.9352], [-121.8247, 36.93526], [-121.82359, 36.9349], [-121.82381, 36.93391], [-121.82387, 36.93387], [-121.82444, 36.9343], [-121.82451, 36.93452], [-121.82449, 36.93488], [-121.82473, 36.9352]]]]} | Open Access 1 | 1163 | Watsonville Slough Ecological Reserve | 32347 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Watsonville-Slough-ER | Santa Cruz 5 | 568.569 | Watsonville Slough ER | 1998 | State Conservation Area 8 | 2 |
15534 | 15534 | 15533 | {"type": "Polygon", "coordinates": [[[-122.12958, 40.15278], [-122.12882, 40.15322], [-122.12754, 40.15169], [-122.1274, 40.15145], [-122.12654, 40.15098], [-122.12535, 40.1509], [-122.12415, 40.15059], [-122.12324, 40.15114], [-122.12248, 40.15109], [-122.12157, 40.15063], [-122.12095, 40.15023], [-122.12059, 40.14919], [-122.12063, 40.14923], [-122.12064, 40.14921], [-122.12017, 40.1479], [-122.11938, 40.14683], [-122.12133, 40.14572], [-122.12142, 40.14619], [-122.1217, 40.14694], [-122.1218, 40.14704], [-122.12196, 40.1471], [-122.12298, 40.14715], [-122.1234, 40.1472], [-122.12388, 40.14728], [-122.12417, 40.14734], [-122.12434, 40.14744], [-122.12451, 40.1476], [-122.12464, 40.14776], [-122.12488, 40.14831], [-122.12505, 40.14861], [-122.12526, 40.14881], [-122.12549, 40.14908], [-122.12561, 40.14917], [-122.12695, 40.14969], [-122.12664, 40.15041], [-122.12752, 40.1509], [-122.1279, 40.15016], [-122.12872, 40.15076], [-122.12883, 40.15096], [-122.12913, 40.15137], [-122.12923, 40.15229], [-122.12942, 40.15264], [-122.12958, 40.15278]]]} | Open Access 1 | 18147 | Butler Slough Ecological Reserve | 32071 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Butler-Slough-ER | Tehama 18 | 57.88 | Butler Slough ER | 1998 | State Conservation Area 8 | 2 |
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]);