units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where YR_EST = 1988
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2057 | 2057 | 2056 | {"type": "Polygon", "coordinates": [[[-121.92375, 37.78824], [-121.92371, 37.79157], [-121.92282, 37.79279], [-121.92257, 37.79317], [-121.92246, 37.79338], [-121.92238, 37.79339], [-121.92136, 37.79311], [-121.92102, 37.79304], [-121.92085, 37.79303], [-121.92051, 37.79305], [-121.92034, 37.79308], [-121.92004, 37.79317], [-121.91971, 37.79243], [-121.92063, 37.79058], [-121.92103, 37.79031], [-121.92183, 37.78958], [-121.92185, 37.78914], [-121.92215, 37.78874], [-121.92211, 37.78833], [-121.92375, 37.78824]]]} | Open Access 1 | 15693 | Diablo Vista Park | 18136 | 1080 | Danville, Town of 473 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | Contra Costa 12 | 31.879 | Diablo Vista Park | 1988 | Local Park 2 | 4 | |
2282 | 2282 | 2281 | {"type": "MultiPolygon", "coordinates": [[[[-121.41906, 40.08837], [-121.4188, 40.08813], [-121.41794, 40.08773], [-121.41618, 40.08765], [-121.4157, 40.08789], [-121.41499, 40.08896], [-121.41395, 40.08941], [-121.41338, 40.08993], [-121.40486, 40.09007], [-121.39998, 40.09008], [-121.39987, 40.08632], [-121.40012, 40.08631], [-121.4003, 40.07897], [-121.40494, 40.07899], [-121.40491, 40.08264], [-121.41455, 40.08261], [-121.41443, 40.0862], [-121.41903, 40.08615], [-121.41906, 40.08837]]], [[[-121.41908, 40.08983], [-121.41908, 40.08983], [-121.41367, 40.08992], [-121.41408, 40.08954], [-121.41521, 40.08902], [-121.41588, 40.08799], [-121.41623, 40.08782], [-121.41695, 40.08789], [-121.4176, 40.08785], [-121.41802, 40.08795], [-121.41866, 40.08826], [-121.41907, 40.08862], [-121.41908, 40.08983]]]]} | Open Access 1 | 18228 | Butte Creek House Ecological Reserve | 32073 | 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/Butte-Creek-House-ER | Butte 42 | 326.4 | Butte Creek House ER | 1988 | State Conservation Area 8 | 2 |
2698 | 2698 | 2697 | {"type": "Polygon", "coordinates": [[[-121.88152, 37.40723], [-121.88065, 37.40766], [-121.87982, 37.40658], [-121.88092, 37.40605], [-121.88122, 37.40607], [-121.88121, 37.40631], [-121.88124, 37.40663], [-121.88134, 37.40694], [-121.88142, 37.40709], [-121.88152, 37.40723]]]} | Open Access 1 | 18272 | Northwod Park | 22898 | 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.74 | Northwod Park | 1988 | Local Park 2 | 4 | |
2702 | 2702 | 2701 | {"type": "Polygon", "coordinates": [[[-121.98702, 37.84243], [-121.98682, 37.8427], [-121.98682, 37.84458], [-121.98515, 37.84459], [-121.98438, 37.84461], [-121.98427, 37.84188], [-121.98417, 37.83749], [-121.9868, 37.83743], [-121.98681, 37.84188], [-121.98674, 37.84189], [-121.98676, 37.84226], [-121.98682, 37.84239], [-121.98682, 37.84245], [-121.98702, 37.84243]]]} | Open Access 1 | 18284 | Oak Hill Park | 22979 | 1080 | Danville, Town of 473 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | Contra Costa 12 | 43.825 | Oak Hill Park | 1988 | Local Park 2 | 4 | |
4257 | 4257 | 4256 | {"type": "Polygon", "coordinates": [[[-122.04021, 37.29085], [-122.03975, 37.29115], [-122.03962, 37.29121], [-122.03955, 37.29119], [-122.03915, 37.29056], [-122.03909, 37.29044], [-122.03905, 37.29024], [-122.03905, 37.28996], [-122.03907, 37.28992], [-122.03913, 37.2899], [-122.03968, 37.28987], [-122.04021, 37.29085]]]} | Open Access 1 | 14641 | Beauchamps Park | 15939 | 1326 | Saratoga, City of 520 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | Santa Clara 19 | 2.353 | Beauchamps Park | 1988 | Local Park 2 | 4 | |
5081 | 5081 | 5080 | {"type": "Polygon", "coordinates": [[[-122.45903, 37.6453], [-122.45838, 37.64534], [-122.45836, 37.64531], [-122.45811, 37.64533], [-122.4581, 37.64537], [-122.45738, 37.64542], [-122.45736, 37.6454], [-122.45608, 37.64547], [-122.45658, 37.64439], [-122.45723, 37.64335], [-122.45728, 37.64333], [-122.4578, 37.64347], [-122.4581, 37.64353], [-122.45841, 37.64358], [-122.45886, 37.6436], [-122.45903, 37.6453]]]} | Open Access 1 | 15294 | Westborough Recreation Park | 33382 | 1341 | South San Francisco, City of 60 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/departments/parks-recreation/recreation-division/rentals/westborough-recreation-building | San Mateo 15 | 10.787 | Westborough Rec. Park | 1988 | Local Recreation Area 3 | 4 |
5264 | 5264 | 5263 | {"type": "Polygon", "coordinates": [[[-119.86364, 35.18945], [-119.86136, 35.18943], [-119.86133, 35.19036], [-119.85911, 35.19035], [-119.85909, 35.18697], [-119.86363, 35.187], [-119.86364, 35.18945]]]} | Restricted Access 2 | 24542 | Carrizo Plains | 30592 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | San Luis Obispo 1 | 32.937 | Carrizo Plains | 1988 | Private Conservation 16 | 2 | |
5517 | 5517 | 5516 | {"type": "MultiPolygon", "coordinates": [[[[-119.95634, 38.71971], [-119.95634, 38.72329], [-119.95166, 38.72325], [-119.95168, 38.71982], [-119.95175, 38.71981], [-119.95176, 38.71976], [-119.95627, 38.71969], [-119.95628, 38.71971], [-119.95634, 38.71971]]], [[[-119.96098, 38.70512], [-119.956, 38.70507], [-119.95595, 38.70137], [-119.96086, 38.70139], [-119.96093, 38.70508], [-119.96098, 38.70512]]], [[[-119.96537, 38.68314], [-119.96078, 38.68316], [-119.96075, 38.68315], [-119.96072, 38.67619], [-119.96075, 38.67616], [-119.96075, 38.67577], [-119.96525, 38.67573], [-119.96537, 38.68314]]], [[[-119.98409, 38.70137], [-119.97475, 38.70153], [-119.97477, 38.70426], [-119.97402, 38.7044], [-119.97321, 38.70452], [-119.97231, 38.70459], [-119.97089, 38.7048], [-119.97027, 38.70492], [-119.96945, 38.70491], [-119.96901, 38.70476], [-119.96813, 38.7044], [-119.96786, 38.70425], [-119.9676, 38.70404], [-119.96738, 38.70379], [-119.96725, 38.70359], [-119.96708, 38.70327], [-119.96695, 38.70295], [-119.96687, 38.70217], [-119.96678, 38.70021], [-119.96673, 38.69977], [-119.96657, 38.69949], [-119.96636, 38.69929], [-119.96612, 38.69909], [-119.96605, 38.69839], [-119.966, 38.69814], [-119.96588, 38.69785], [-119.96569, 38.69744], [-119.96549, 38.69717], [-119.96524, 38.69701], [-119.9652, 38.69405], [-119.96079, 38.69407], [-119.96075, 38.6904], [-119.96977, 38.69038], [-119.96975, 38.68689], [-119.97469, 38.68689], [-119.9747, 38.69405], [-119.98407, 38.69397], [-119.98409, 38.70137]]], [[[-119.96575, 38.74152], [-119.961, 38.74152], [-119.96102, 38.7379], [-119.96097, 38.73427], [-119.961, 38.73427], [-119.96102, 38.73424], [-119.96108, 38.73424], [-119.96113, 38.73428], [-119.96569, 38.73427], [-119.96575, 38.74152]]], [[[-119.97452, 38.67576], [-119.96983, 38.67573], [-119.96489, 38.67568], [-119.96485, 38.67263], [-119.97445, 38.67245], [-119.97452, 38.67576]]]]} | Open Access 1 | 22165 | Red Lake Wildlife Area | 30491 | 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/Red-Lake-WA | Alpine 51 | 861.648 | Red Lake Wildlife Area | 1988 | State Conservation Area 8 | 2 |
5883 | 5883 | 5882 | {"type": "Polygon", "coordinates": [[[-121.79615, 37.84596], [-121.79612, 37.85312], [-121.78698, 37.85311], [-121.78682, 37.86267], [-121.7869, 37.86771], [-121.76938, 37.8679], [-121.75848, 37.8682], [-121.75124, 37.86778], [-121.74761, 37.8678], [-121.74759, 37.86706], [-121.74713, 37.86697], [-121.74651, 37.86696], [-121.74643, 37.8669], [-121.74623, 37.86694], [-121.74596, 37.86696], [-121.74577, 37.86703], [-121.74561, 37.86711], [-121.74553, 37.8671], [-121.7452, 37.867], [-121.74488, 37.86694], [-121.7445, 37.86682], [-121.74398, 37.8668], [-121.7439, 37.86682], [-121.74331, 37.86684], [-121.74332, 37.86446], [-121.74207, 37.86445], [-121.74225, 37.85418], [-121.74225, 37.85306], [-121.75089, 37.85318], [-121.76983, 37.85308], [-121.769, 37.84586], [-121.77327, 37.84574], [-121.78699, 37.84591], [-121.7916, 37.84595], [-121.79615, 37.84596]]]} | Open Access 1 | 280 | Round Valley Regional Park | 3309 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/round_valley | Contra Costa 12 | 2043.438 | Round Valley RP | 1988 | Local Park 2 | 4 |
6043 | 6043 | 6042 | {"type": "Polygon", "coordinates": [[[-122.26792, 37.96302], [-122.26857, 37.96816], [-122.26709, 37.974], [-122.26116, 37.97362], [-122.25988, 37.97196], [-122.25803, 37.97045], [-122.25843, 37.97011], [-122.25925, 37.97024], [-122.25905, 37.9699], [-122.25909, 37.96979], [-122.25944, 37.96981], [-122.25945, 37.9698], [-122.25937, 37.96937], [-122.25917, 37.9691], [-122.25945, 37.96877], [-122.26023, 37.96872], [-122.26042, 37.96845], [-122.26044, 37.96786], [-122.25934, 37.96664], [-122.25928, 37.96632], [-122.25876, 37.96567], [-122.25836, 37.96559], [-122.25836, 37.96533], [-122.25857, 37.96513], [-122.25858, 37.96488], [-122.25837, 37.9646], [-122.25816, 37.9646], [-122.25802, 37.96456], [-122.25792, 37.96466], [-122.25781, 37.96453], [-122.25605, 37.96454], [-122.25633, 37.96429], [-122.25636, 37.96409], [-122.25628, 37.96388], [-122.2557, 37.96378], [-122.25569, 37.96356], [-122.25557, 37.96322], [-122.25763, 37.96279], [-122.25906, 37.96256], [-122.25948, 37.96236], [-122.25958, 37.96227], [-122.26003, 37.96162], [-122.26043, 37.96117], [-122.26075, 37.96101], [-122.2628, 37.96024], [-122.2637, 37.95959], [-122.26792, 37.96302]]]} | Open Access 1 | 945 | Sobrante Ridge Regional Preserve | 3319 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/sobrante_ridge | Contra Costa 12 | 276.758 | Sobrante Ridge RPr | 1988 | Local Conservation Area 4 | 2 |
6554 | 6554 | 6553 | {"type": "Polygon", "coordinates": [[[-121.58605, 38.59505], [-121.57671, 38.5975], [-121.57669, 38.59709], [-121.57651, 38.59671], [-121.58026, 38.59567], [-121.58339, 38.59485], [-121.58581, 38.59418], [-121.58605, 38.59505]]]} | Open Access 1 | 3275 | Sacramento Bypass Wildlife Area | 30493 | 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/Sacramento-Bypass-WA | Yolo 33 | 19.773 | Sacramento Bypass Wildlife Area | 1988 | State Conservation Area 8 | 2 |
7884 | 7884 | 7883 | {"type": "MultiPolygon", "coordinates": [[[[-117.09041, 32.59194], [-117.08874, 32.59193], [-117.08862, 32.59124], [-117.09041, 32.59124], [-117.09041, 32.59194]]], [[[-117.09041, 32.59281], [-117.08888, 32.5928], [-117.08876, 32.5921], [-117.09041, 32.5921], [-117.09041, 32.59281]]], [[[-117.09247, 32.5929], [-117.09246, 32.59485], [-117.09092, 32.59489], [-117.09085, 32.59495], [-117.09086, 32.59468], [-117.09078, 32.59463], [-117.09068, 32.59391], [-117.08962, 32.59388], [-117.08903, 32.5938], [-117.08889, 32.59289], [-117.09247, 32.5929]]], [[[-117.0925, 32.59116], [-117.09057, 32.59116], [-117.09056, 32.59064], [-117.09054, 32.59036], [-117.09052, 32.58935], [-117.09248, 32.58934], [-117.0925, 32.59116]]], [[[-117.0925, 32.59125], [-117.09248, 32.59195], [-117.09057, 32.59194], [-117.09057, 32.59124], [-117.0925, 32.59125]]], [[[-117.09248, 32.59211], [-117.09247, 32.59281], [-117.09058, 32.59281], [-117.09058, 32.5921], [-117.09248, 32.59211]]], [[[-117.09712, 32.59353], [-117.0952, 32.59484], [-117.09266, 32.59476], [-117.09267, 32.59285], [-117.09269, 32.59124], [-117.09486, 32.59122], [-117.09486, 32.59116], [-117.09492, 32.59115], [-117.09491, 32.58932], [-117.09709, 32.58931], [-117.09712, 32.59353]]], [[[-117.09479, 32.59116], [-117.0927, 32.59118], [-117.09271, 32.58934], [-117.09478, 32.58932], [-117.09479, 32.59116]]], [[[-117.11856, 32.59129], [-117.11842, 32.59139], [-117.11778, 32.59134], [-117.11803, 32.59127], [-117.11807, 32.59124], [-117.11807, 32.59117], [-117.11854, 32.59117], [-117.11854, 32.59124], [-117.11821, 32.59124], [-117.1182, 32.59125], [-117.11856, 32.59129]]]]} | Restricted Access 2 | 12592 | San Diego Bay National Wildlife Refuge | 24851 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | San Diego 4 | 93.78 | San Diego Bay NWR | 1988 | National Wildlife Refuge 105 | 2 | |
8064 | 8064 | 8063 | {"type": "Polygon", "coordinates": [[[-121.98834, 37.82338], [-121.98797, 37.82358], [-121.98781, 37.82371], [-121.98767, 37.82384], [-121.98754, 37.82399], [-121.98744, 37.82414], [-121.98744, 37.82312], [-121.98772, 37.82326], [-121.98788, 37.82331], [-121.98804, 37.82335], [-121.98834, 37.82338]]]} | Open Access 1 | 11868 | Bret Harte Park | 16365 | 1080 | Danville, Town of 473 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | Contra Costa 12 | 0.871 | Bret Harte Park | 1988 | Local Park 2 | 4 | |
8585 | 8585 | 8584 | {"type": "Polygon", "coordinates": [[[-121.89616, 37.33775], [-121.89607, 37.3379], [-121.89601, 37.33804], [-121.89584, 37.33812], [-121.89562, 37.33784], [-121.89606, 37.33763], [-121.89616, 37.33775]]]} | Open Access 1 | 13727 | Pellier Park | 23570 | 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.342 | Pellier Park | 1988 | Local Park 2 | 4 | |
8589 | 8589 | 8588 | {"type": "Polygon", "coordinates": [[[-121.8648, 37.33265], [-121.8647, 37.33318], [-121.86433, 37.33313], [-121.86441, 37.33274], [-121.8648, 37.33265]]]} | Open Access 1 | 13657 | Forestdale Tot Lot | 18999 | 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.418 | Forestdale Tot Lot | 1988 | Local Recreation Area 3 | 4 | |
8794 | 8794 | 8793 | {"type": "Polygon", "coordinates": [[[-122.40243, 37.60703], [-122.40183, 37.60732], [-122.40179, 37.60732], [-122.40159, 37.60726], [-122.40126, 37.60708], [-122.40111, 37.60697], [-122.4009, 37.60677], [-122.4018, 37.60631], [-122.40243, 37.60703]]]} | Open Access 1 | 14305 | Green Hills Park | 19463 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 2.016 | Green Hills Park | 1988 | Local Park 2 | 4 | |
9239 | 9239 | 9238 | {"type": "Polygon", "coordinates": [[[-121.98155, 37.80527], [-121.97896, 37.80538], [-121.9786, 37.80534], [-121.97827, 37.80535], [-121.97806, 37.80538], [-121.9774, 37.80533], [-121.97689, 37.80511], [-121.97665, 37.80346], [-121.97708, 37.80344], [-121.97708, 37.80338], [-121.97718, 37.80319], [-121.97732, 37.80305], [-121.97747, 37.80302], [-121.97789, 37.80301], [-121.97818, 37.80304], [-121.97876, 37.80274], [-121.97935, 37.8027], [-121.97927, 37.80133], [-121.98122, 37.80125], [-121.98133, 37.80333], [-121.98155, 37.80527]]]} | Open Access 1 | 15367 | Osage Station Park | 23232 | 1080 | Danville, Town of 473 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | Contra Costa 12 | 34.231 | Osage Station Park | 1988 | Local Park 2 | 4 | |
10535 | 10535 | 10534 | {"type": "Polygon", "coordinates": [[[-121.88902, 37.33131], [-121.88912, 37.33132], [-121.88924, 37.33138], [-121.88939, 37.3315], [-121.88951, 37.33163], [-121.89039, 37.33279], [-121.89041, 37.33286], [-121.89041, 37.33293], [-121.89037, 37.333], [-121.89033, 37.33304], [-121.89023, 37.33308], [-121.89014, 37.33309], [-121.89003, 37.33307], [-121.88994, 37.33301], [-121.88886, 37.33158], [-121.88884, 37.33149], [-121.88886, 37.33142], [-121.88893, 37.33135], [-121.88902, 37.33131]]]} | Open Access 1 | 18747 | Plaza de Ceasr Chavez | 23778 | 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.432 | Plaza de Ceasr Chavez | 1988 | None 924 | ||
10810 | 10810 | 10809 | {"type": "Polygon", "coordinates": [[[-121.71529, 38.10019], [-121.71529, 38.10019], [-121.71017, 38.10389], [-121.71003, 38.1021], [-121.71, 38.10142], [-121.70992, 38.10079], [-121.70982, 38.09949], [-121.70988, 38.0985], [-121.71529, 38.10019]]]} | Open Access 1 | 23598 | Decker Island Wildlife Area | 30432 | 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/Decker-Island-WA | Solano 26 | 35.275 | Decker Island Wildlife Area | 1988 | State Conservation Area 8 | 2 |
12455 | 12455 | 12454 | {"type": "Polygon", "coordinates": [[[-121.59051, 38.59963], [-121.58988, 38.60014], [-121.58947, 38.59987], [-121.58912, 38.5999], [-121.58023, 38.60232], [-121.58004, 38.6021], [-121.57981, 38.60196], [-121.57968, 38.60192], [-121.57948, 38.60191], [-121.57928, 38.60195], [-121.57829, 38.60222], [-121.57384, 38.60305], [-121.57343, 38.6031], [-121.57201, 38.60346], [-121.57135, 38.60364], [-121.56337, 38.60595], [-121.56091, 38.60671], [-121.56062, 38.60684], [-121.56037, 38.60693], [-121.5601, 38.60707], [-121.5599, 38.60722], [-121.55559, 38.60276], [-121.55593, 38.60259], [-121.57225, 38.59792], [-121.57589, 38.59754], [-121.5765, 38.5974], [-121.5765, 38.59739], [-121.57618, 38.5968], [-121.57651, 38.59671], [-121.57669, 38.59709], [-121.5767, 38.59749], [-121.57672, 38.5975], [-121.58604, 38.59505], [-121.58605, 38.59504], [-121.58581, 38.59418], [-121.587, 38.59388], [-121.58722, 38.59473], [-121.59051, 38.59963]]]} | Open Access 1 | 28097 | Sacramento Bypass Wildlife Area | 30493 | 219 | Central Valley Flood Protection Board 1027 | State 5 | State Agency 5 | http://www.cvfpb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Sacramento-Bypass-WA | Yolo 33 | 412.675 | Sacramento Bypass Wildlife Area | 1988 | 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]);