units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where YR_EST = 1920
This data as json, copyable, CSV (advanced)
MNG_AGENCY 4
DES_TP 3
MNG_AG_TYP 2
ACCESS_TYP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
864 | 864 | 863 | {"type": "Polygon", "coordinates": [[[-122.29161, 37.89499], [-122.29154, 37.89662], [-122.28999, 37.89658], [-122.29007, 37.89494], [-122.29161, 37.89499]]]} | Open Access 1 | 5579 | Albany Memorial Park | 15328 | 1002 | Albany, City of 274 | City 2 | City Agency 2 | http://www.albanyca.org/index.aspx?page=473 | City 2 | 1002 | Albany, City of 269 | City 2 | City Agency 2 | Alameda 17 | 6.13 | Albany Memorial Park | 1920 | Local Park 2 | 4 | |
5037 | 5037 | 5036 | {"type": "MultiPolygon", "coordinates": [[[[-121.64557, 41.00813], [-121.64549, 41.01183], [-121.64071, 41.01185], [-121.64074, 41.00817], [-121.64557, 41.00813]]], [[[-121.64872, 41.01547], [-121.64863, 41.01865], [-121.64381, 41.01864], [-121.64381, 41.01552], [-121.64625, 41.01552], [-121.64872, 41.01547]]]]} | Open Access 1 | 25912 | McArthur-Burney Falls Memorial State Park | 14072 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=455 | Shasta 27 | 76.124 | McArthur-Burney Falls Memorial SP | 1920 | State Park 15 | 4 |
8830 | 8830 | 8829 | {"type": "Polygon", "coordinates": [[[-122.1431, 37.44885], [-122.14308, 37.45144], [-122.14138, 37.4509], [-122.14138, 37.44884], [-122.1431, 37.44885]]]} | Open Access 1 | 16038 | Eleanor Pardee Park | 18556 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 9.675 | Eleanor Pardee Park | 1920 | Local Park 2 | 4 | |
11336 | 11336 | 11335 | {"type": "Polygon", "coordinates": [[[-122.5722, 38.48217], [-122.57203, 38.48231], [-122.57203, 38.48233], [-122.57126, 38.4831], [-122.57107, 38.48361], [-122.57102, 38.48404], [-122.57104, 38.48421], [-122.57101, 38.48469], [-122.57095, 38.48496], [-122.57095, 38.48534], [-122.57098, 38.4857], [-122.57096, 38.48717], [-122.57058, 38.4879], [-122.56978, 38.48853], [-122.56939, 38.4889], [-122.56931, 38.48957], [-122.56892, 38.49018], [-122.56649, 38.49258], [-122.56657, 38.49371], [-122.55722, 38.49465], [-122.55671, 38.4877], [-122.55667, 38.48774], [-122.55666, 38.48768], [-122.54765, 38.48748], [-122.54777, 38.49106], [-122.5461, 38.49103], [-122.5459, 38.48742], [-122.5429, 38.48734], [-122.53923, 38.48511], [-122.53826, 38.48362], [-122.54059, 38.48146], [-122.53803, 38.48085], [-122.53528, 38.47475], [-122.536, 38.47259], [-122.53499, 38.47104], [-122.53511, 38.46823], [-122.53513, 38.46819], [-122.53518, 38.46721], [-122.53468, 38.46679], [-122.53333, 38.46651], [-122.52986, 38.46659], [-122.52922, 38.46657], [-122.52863, 38.46642], [-122.52646, 38.46702], [-122.52303, 38.4685], [-122.52011, 38.47042], [-122.51998, 38.47028], [-122.51986, 38.46761], [-122.52064, 38.46764], [-122.52066, 38.46709], [-122.52537, 38.46722], [-122.52559, 38.46286], [-122.52558, 38.46263], [-122.52988, 38.46251], [-122.52991, 38.46625], [-122.53999, 38.46599], [-122.53962, 38.46864], [-122.53955, 38.4687], [-122.53915, 38.47125], [-122.5435, 38.4714], [-122.54284, 38.4766], [-122.55635, 38.47683], [-122.55643, 38.48048], [-122.5635, 38.47967], [-122.56352, 38.4796], [-122.56437, 38.47953], [-122.56877, 38.47897], [-122.56896, 38.47949], [-122.56908, 38.47955], [-122.56915, 38.47964], [-122.56919, 38.47974], [-122.56935, 38.47988], [-122.56943, 38.47993], [-122.56967, 38.48005], [-122.56979, 38.4802], [-122.5699, 38.4803], [-122.57015, 38.48043], [-122.57043, 38.48071], [-122.5706, 38.48082], [-122.57083, 38.48083], [-122.57109, 38.48077], [-122.57123, 38.48076], [-122.57132, 38.48077], [-122.57148, 38.48076], [-122.57163, 38.48074], [-122.57183, 38.48079], [-122.57194, 38.48087], [-122.57192, 38.48137], [-122.5722, 38.48217]]]} | Open Access 1 | 22086 | Sugarloaf Ridge State Park | 1761 | 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=481 | Sonoma 16 | 1147.726 | Sugarloaf Ridge SP | 1920 | State Park 15 | 4 |
14452 | 14452 | 14451 | {"type": "Polygon", "coordinates": [[[-122.51122, 38.46753], [-122.51122, 38.46754], [-122.50786, 38.46768], [-122.50783, 38.46616], [-122.50805, 38.46617], [-122.50804, 38.46635], [-122.50829, 38.46668], [-122.5085, 38.46687], [-122.50879, 38.46703], [-122.50919, 38.46716], [-122.51001, 38.46737], [-122.51041, 38.46735], [-122.51064, 38.46739], [-122.51072, 38.46734], [-122.5108, 38.46743], [-122.51122, 38.46753]]]} | Open Access 1 | 47060 | Sugarloaf Ridge State Park | 1761 | 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=481 | Napa 11 | 3.946 | Sugarloaf Ridge SP | 1920 | State Park 15 | 4 |
15705 | 15705 | 15704 | {"type": "Polygon", "coordinates": [[[-119.96788, 38.93696], [-119.96716, 38.93808], [-119.96692, 38.93882], [-119.96734, 38.93893], [-119.96695, 38.93973], [-119.96669, 38.94016], [-119.9666, 38.94043], [-119.9664, 38.94068], [-119.96631, 38.94081], [-119.96625, 38.94096], [-119.96611, 38.94122], [-119.96603, 38.94149], [-119.96602, 38.94177], [-119.96604, 38.94205], [-119.96572, 38.94257], [-119.96554, 38.94452], [-119.96536, 38.94453], [-119.96523, 38.94455], [-119.96498, 38.94464], [-119.96485, 38.94474], [-119.96423, 38.94526], [-119.9642, 38.94528], [-119.96415, 38.94528], [-119.964, 38.94391], [-119.96426, 38.94258], [-119.96414, 38.94251], [-119.96435, 38.94196], [-119.96434, 38.9418], [-119.96449, 38.94166], [-119.96448, 38.94092], [-119.96347, 38.94023], [-119.96245, 38.94032], [-119.96204, 38.93986], [-119.962, 38.93969], [-119.96214, 38.93955], [-119.96216, 38.93944], [-119.9634, 38.93944], [-119.9643, 38.93877], [-119.96429, 38.93697], [-119.96662, 38.93695], [-119.96788, 38.93696]]]} | Restricted Access 2 | 24106 | Bijou Municipal Golf Course | 33083 | 1411 | South Lake Tahoe, City of 990 | City 2 | City Agency 2 | http://www.cityofslt.us/index.aspx?nid=196 | City 2 | 1411 | South Lake Tahoe, City of 954 | City 2 | City Agency 2 | El Dorado 34 | 46.201 | Bijou Municipal GC | 1920 | Local Recreation Area 3 | 4 | |
16529 | 16529 | 16528 | {"type": "MultiPolygon", "coordinates": [[[[-122.5446, 38.44399], [-122.5446, 38.444], [-122.54375, 38.444], [-122.5446, 38.44399], [-122.5446, 38.44399]]], [[[-122.54373, 38.44399], [-122.54369, 38.444], [-122.54415, 38.45134], [-122.54085, 38.45145], [-122.54078, 38.45142], [-122.53959, 38.45144], [-122.54025, 38.45857], [-122.52597, 38.45883], [-122.52396, 38.45669], [-122.5238, 38.45628], [-122.52436, 38.45532], [-122.52737, 38.45522], [-122.52986, 38.45161], [-122.52978, 38.44934], [-122.53326, 38.44746], [-122.53314, 38.44409], [-122.52088, 38.44421], [-122.51105, 38.44507], [-122.51103, 38.4516], [-122.50915, 38.45185], [-122.50918, 38.45294], [-122.51103, 38.45268], [-122.51102, 38.45981], [-122.51949, 38.45895], [-122.5247, 38.45886], [-122.52477, 38.46261], [-122.52559, 38.4626], [-122.52558, 38.46264], [-122.52559, 38.46294], [-122.52537, 38.46722], [-122.52067, 38.46709], [-122.52064, 38.46764], [-122.51986, 38.46761], [-122.51981, 38.46652], [-122.5153, 38.46671], [-122.51519, 38.46358], [-122.51514, 38.46357], [-122.51517, 38.46317], [-122.51071, 38.46359], [-122.51079, 38.46734], [-122.51025, 38.46745], [-122.50959, 38.46728], [-122.5089, 38.46698], [-122.50817, 38.46621], [-122.50756, 38.46618], [-122.507, 38.4658], [-122.50699, 38.46563], [-122.50682, 38.46568], [-122.50666, 38.46531], [-122.50611, 38.4651], [-122.50594, 38.46496], [-122.50579, 38.46466], [-122.50613, 38.46417], [-122.50686, 38.46413], [-122.50693, 38.46416], [-122.50699, 38.46414], [-122.50698, 38.46411], [-122.50692, 38.46408], [-122.50654, 38.46406], [-122.50653, 38.46392], [-122.50656, 38.45718], [-122.50612, 38.45717], [-122.50479, 38.45702], [-122.50421, 38.45703], [-122.50368, 38.45701], [-122.50306, 38.45632], [-122.5021, 38.45614], [-122.50209, 38.4534], [-122.49716, 38.45331], [-122.49707, 38.45554], [-122.49706, 38.45692], [-122.48278, 38.45695], [-122.48286, 38.45331], [-122.48281, 38.45328], [-122.47827, 38.45342], [-122.47814, 38.44624], [-122.48295, 38.44602], [-122.48301, 38.44104], [-122.48579, 38.44071], [-122.4857, 38.44126], [-122.48499, 38.44141], [-122.48466, 38.44201], [-122.48437, 38.44203], [-122.48432, 38.44232], [-122.48466, 38.44226], [-122.4848, 38.44234], [-122.48483, 38.44232], [-122.48768, 38.44231], [-122.48765, 38.43787], [-122.49227, 38.43787], [-122.4922, 38.43385], [-122.49403, 38.43381], [-122.49409, 38.43384], [-122.50138, 38.43384], [-122.51278, 38.43342], [-122.51279, 38.4334], [-122.52462, 38.43314], [-122.52463, 38.43313], [-122.52442, 38.4295], [-122.52922, 38.42951], [-122.52962, 38.42966], [-122.53364, 38.43129], [-122.53365, 38.43131], [-122.53371, 38.4313], [-122.53405, 38.43147], [-122.53401, 38.44403], [-122.54372, 38.4439], [-122.54373, 38.44399]], [[-122.53944, 38.44865], [-122.53942, 38.44851], [-122.53934, 38.44849], [-122.53926, 38.44772], [-122.53745, 38.44762], [-122.53745, 38.44764], [-122.53695, 38.44763], [-122.53729, 38.44806], [-122.53734, 38.4485], [-122.53777, 38.44893], [-122.53828, 38.4493], [-122.53945, 38.4498], [-122.53972, 38.4498], [-122.53963, 38.44866], [-122.53944, 38.44865]]]]} | Open Access 1 | 1258 | Sugarloaf Ridge State Park | 1761 | 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=481 | Sonoma 16 | 2909.687 | Sugarloaf Ridge SP | 1920 | State Park 15 | 4 |
16541 | 16541 | 16540 | {"type": "MultiPolygon", "coordinates": [[[[-121.65836, 41.01556], [-121.65826, 41.02462], [-121.65621, 41.0246], [-121.65623, 41.02276], [-121.65687, 41.02277], [-121.65688, 41.02242], [-121.65732, 41.02242], [-121.65734, 41.02066], [-121.65293, 41.02058], [-121.65291, 41.02234], [-121.65287, 41.02331], [-121.65223, 41.02331], [-121.65214, 41.02593], [-121.64907, 41.02589], [-121.64911, 41.02524], [-121.64847, 41.02522], [-121.64866, 41.02226], [-121.64707, 41.02226], [-121.64696, 41.02216], [-121.6468, 41.02213], [-121.64664, 41.02226], [-121.64385, 41.02226], [-121.64378, 41.02449], [-121.64259, 41.02461], [-121.64219, 41.02452], [-121.64188, 41.02439], [-121.641, 41.02393], [-121.64022, 41.02362], [-121.63982, 41.0235], [-121.63923, 41.02331], [-121.63885, 41.0231], [-121.63806, 41.02277], [-121.63776, 41.02253], [-121.63752, 41.02243], [-121.63728, 41.02225], [-121.639, 41.02228], [-121.63899, 41.01863], [-121.63159, 41.01853], [-121.63128, 41.01837], [-121.63096, 41.01817], [-121.63077, 41.01785], [-121.6302, 41.01744], [-121.62997, 41.0173], [-121.62983, 41.01714], [-121.62945, 41.0168], [-121.62892, 41.01653], [-121.62892, 41.01544], [-121.63102, 41.01546], [-121.64381, 41.01552], [-121.64382, 41.01864], [-121.64863, 41.01864], [-121.64872, 41.01547], [-121.64625, 41.01552], [-121.64669, 41.0154], [-121.64711, 41.01524], [-121.64751, 41.01505], [-121.64787, 41.01483], [-121.64821, 41.01459], [-121.6485, 41.01431], [-121.64876, 41.01402], [-121.64898, 41.0137], [-121.64915, 41.01337], [-121.64927, 41.01303], [-121.64935, 41.01268], [-121.64938, 41.01245], [-121.64939, 41.01159], [-121.64939, 41.01137], [-121.64935, 41.01115], [-121.6493, 41.01101], [-121.64918, 41.01073], [-121.649, 41.01047], [-121.64878, 41.01022], [-121.6483, 41.00982], [-121.64804, 41.00963], [-121.64751, 41.00927], [-121.64665, 41.00878], [-121.6461, 41.00852], [-121.64584, 41.00844], [-121.64557, 41.00837], [-121.64556, 41.00813], [-121.64074, 41.00818], [-121.64076, 41.00456], [-121.65056, 41.00449], [-121.65051, 41.00811], [-121.65523, 41.00817], [-121.65512, 41.01553], [-121.65836, 41.01556]]], [[[-121.64556, 41.00865], [-121.64586, 41.00874], [-121.64608, 41.00883], [-121.64645, 41.00901], [-121.64701, 41.00931], [-121.64754, 41.00965], [-121.64779, 41.00982], [-121.64827, 41.0102], [-121.6486, 41.0105], [-121.64874, 41.01067], [-121.64885, 41.01084], [-121.64893, 41.01102], [-121.64899, 41.01121], [-121.64902, 41.0114], [-121.64903, 41.01159], [-121.64901, 41.01244], [-121.64899, 41.01265], [-121.64892, 41.01297], [-121.64881, 41.01328], [-121.64866, 41.01357], [-121.64847, 41.01386], [-121.64824, 41.01412], [-121.64797, 41.01437], [-121.64768, 41.0146], [-121.64735, 41.0148], [-121.647, 41.01498], [-121.64662, 41.01512], [-121.64623, 41.01524], [-121.64583, 41.01533], [-121.64541, 41.01538], [-121.64556, 41.00865]]]]} | Open Access 1 | 5260 | McArthur-Burney Falls Memorial State Park | 14072 | 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=455 | Shasta 27 | 616.671 | McArthur-Burney Falls Memorial SP | 1920 | State Park 15 | 4 |
16612 | 16612 | 16611 | {"type": "Polygon", "coordinates": [[[-122.53326, 38.44746], [-122.52978, 38.44934], [-122.52986, 38.45161], [-122.52737, 38.45522], [-122.52436, 38.45532], [-122.5238, 38.45628], [-122.52396, 38.45669], [-122.52597, 38.45883], [-122.51949, 38.45895], [-122.51102, 38.45981], [-122.51105, 38.44507], [-122.52088, 38.44421], [-122.53314, 38.44409], [-122.53326, 38.44746]]]} | Open Access 1 | 25862 | Sugarloaf Ridge State Park | 1761 | 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=481 | Sonoma 16 | 640.189 | Sugarloaf Ridge SP | 1920 | State Park 15 | 4 |
16617 | 16617 | 16616 | {"type": "Polygon", "coordinates": [[[-121.6594, 41.02909], [-121.65936, 41.02915], [-121.65932, 41.02919], [-121.65924, 41.02919], [-121.65906, 41.0291], [-121.65894, 41.02901], [-121.65773, 41.02891], [-121.65702, 41.02894], [-121.65677, 41.02898], [-121.65659, 41.02899], [-121.65604, 41.02896], [-121.65561, 41.02889], [-121.65529, 41.02881], [-121.65481, 41.02861], [-121.65472, 41.02854], [-121.65467, 41.02851], [-121.65433, 41.02849], [-121.65401, 41.02843], [-121.65347, 41.0283], [-121.65294, 41.02827], [-121.65249, 41.02815], [-121.65222, 41.02801], [-121.65152, 41.02769], [-121.65056, 41.02746], [-121.65023, 41.0274], [-121.64984, 41.02737], [-121.64947, 41.02736], [-121.64872, 41.02737], [-121.6483, 41.02741], [-121.64811, 41.02741], [-121.64796, 41.02737], [-121.64781, 41.0273], [-121.64772, 41.02716], [-121.64782, 41.02673], [-121.64784, 41.02588], [-121.64789, 41.02559], [-121.64808, 41.02512], [-121.64813, 41.02478], [-121.64813, 41.02466], [-121.64809, 41.02462], [-121.64803, 41.02466], [-121.6478, 41.02492], [-121.64766, 41.02505], [-121.64739, 41.02549], [-121.64718, 41.02577], [-121.64677, 41.02613], [-121.64671, 41.02629], [-121.64668, 41.02646], [-121.64657, 41.02652], [-121.64638, 41.02653], [-121.64622, 41.0265], [-121.6461, 41.02614], [-121.64594, 41.02582], [-121.6454, 41.02515], [-121.64521, 41.02501], [-121.64495, 41.02489], [-121.64464, 41.02482], [-121.64397, 41.02477], [-121.64371, 41.02478], [-121.64275, 41.02489], [-121.64246, 41.02489], [-121.64224, 41.02484], [-121.64195, 41.02474], [-121.64069, 41.02412], [-121.64014, 41.02391], [-121.63897, 41.02356], [-121.63785, 41.0231], [-121.63769, 41.02298], [-121.63757, 41.02284], [-121.63745, 41.02279], [-121.63706, 41.02266], [-121.63672, 41.02263], [-121.63663, 41.02261], [-121.63658, 41.02256], [-121.63655, 41.02248], [-121.63658, 41.02241], [-121.63665, 41.02236], [-121.63675, 41.02232], [-121.6368, 41.02226], [-121.637, 41.02187], [-121.63703, 41.02173], [-121.63702, 41.02164], [-121.63704, 41.02152], [-121.63711, 41.02141], [-121.63705, 41.02131], [-121.63705, 41.02124], [-121.63709, 41.02121], [-121.6371, 41.02099], [-121.63712, 41.02094], [-121.63707, 41.02073], [-121.63707, 41.0205], [-121.63706, 41.02047], [-121.63698, 41.02046], [-121.63694, 41.02033], [-121.63683, 41.02026], [-121.63658, 41.02012], [-121.63648, 41.02012], [-121.63623, 41.02015], [-121.63615, 41.02015], [-121.63611, 41.0201], [-121.63611, 41.02003], [-121.63616, 41.01999], [-121.63644, 41.01995], [-121.63646, 41.01988], [-121.63644, 41.01972], [-121.6364, 41.0196], [-121.63631, 41.01951], [-121.63614, 41.01948], [-121.63585, 41.01948], [-121.63565, 41.01945], [-121.63536, 41.01944], [-121.63506, 41.01951], [-121.63482, 41.01962], [-121.63465, 41.01973], [-121.63457, 41.01982], [-121.63427, 41.01987], [-121.63415, 41.01994], [-121.63397, 41.01999], [-121.63368, 41.02], [-121.63353, 41.01995], [-121.63326, 41.01969], [-121.63312, 41.0196], [-121.63304, 41.01952], [-121.63298, 41.01949], [-121.63278, 41.01947], [-121.63209, 41.01932], [-121.63186, 41.01922], [-121.63137, 41.0191], [-121.63126, 41.019], [-121.6312, 41.01899], [-121.63113, 41.01901], [-121.63112, 41.01904], [-121.63117, 41.01909], [-121.63115, 41.01911], [-121.63104, 41.0191], [-121.63089, 41.01902], [-121.63059, 41.01874], [-121.63056, 41.01867], [-121.63059, 41.01862], [-121.63057, 41.01851], [-121.63022, 41.01802], [-121.62998, 41.01781], [-121.62984, 41.01775], [-121.62967, 41.01773], [-121.62954, 41.01779], [-121.62952, 41.01787], [-121.62954, 41.01796], [-121.62966, 41.01812], [-121.63003, 41.01848], [-121.63021, 41.01877], [-121.63028, 41.01915], [-121.63028, 41.0193], [-121.63018, 41.01939], [-121.63039, 41.01945], [-121.6305, 41.01953], [-121.63063, 41.01958], [-121.63087, 41.01959], [-121.63104, 41.01972], [-121.63102, 41.01977], [-121.63104, 41.01986], [-121.63101, 41.01994], [-121.63092, 41.01994], [-121.63072, 41.01989], [-121.63058, 41.01976], [-121.63043, 41.01974], [-121.62994, 41.01973], [-121.62966, 41.0196], [-121.62944, 41.01957], [-121.62899, 41.01936], [-121.62876, 41.01932], [-121.62829, 41.01908], [-121.62801, 41.01901], [-121.62742, 41.01889], [-121.62721, 41.01889], [-121.62705, 41.01895], [-121.6269, 41.01898], [-121.62676, 41.01898], [-121.6266, 41.01895], [-121.62623, 41.01873], [-121.62551, 41.01834], [-121.62539, 41.01823], [-121.62503, 41.01802], [-121.6248, 41.0178], [-121.62476, 41.0176], [-121.62454, 41.01734], [-121.62447, 41.01717], [-121.62435, 41.0171], [-121.6242, 41.01692], [-121.62414, 41.01671], [-121.62413, 41.01657], [-121.62376, 41.01646], [-121.62353, 41.01653], [-121.62296, 41.01662], [-121.62272, 41.01661], [-121.62252, 41.01655], [-121.62312, 41.01621], [-121.62339, 41.01609], [-121.62368, 41.01599], [-121.62399, 41.01592], [-121.62462, 41.01583], [-121.62494, 41.0158], [-121.62525, 41.01575], [-121.62555, 41.01567], [-121.62632, 41.01541], [-121.62892, 41.01544], [-121.62892, 41.01653], [-121.62945, 41.0168], [-121.62983, 41.01714], [-121.62997, 41.0173], [-121.6302, 41.01744], [-121.63077, 41.01785], [-121.63096, 41.01817], [-121.63128, 41.01837], [-121.63159, 41.01853], [-121.63899, 41.01863], [-121.639, 41.02229], [-121.6373, 41.02225], [-121.63752, 41.02243], [-121.63776, 41.02253], [-121.63806, 41.02277], [-121.63885, 41.0231], [-121.63923, 41.02331], [-121.63982, 41.0235], [-121.64022, 41.02362], [-121.64051, 41.02373], [-121.641, 41.02393], [-121.64188, 41.02439], [-121.64219, 41.02452], [-121.64259, 41.02461], [-121.64378, 41.02448], [-121.64385, 41.02226], [-121.64664, 41.02226], [-121.6468, 41.02213], [-121.64696, 41.02216], [-121.64707, 41.02226], [-121.64867, 41.02226], [-121.64847, 41.02521], [-121.64912, 41.02523], [-121.64908, 41.02589], [-121.65213, 41.02592], [-121.65223, 41.0233], [-121.65288, 41.0233], [-121.65291, 41.02234], [-121.65293, 41.02058], [-121.65735, 41.02066], [-121.65732, 41.02243], [-121.65689, 41.02242], [-121.65688, 41.02277], [-121.65623, 41.02277], [-121.65621, 41.02459], [-121.65826, 41.02462], [-121.65825, 41.02581], [-121.65816, 41.0258], [-121.65802, 41.02568], [-121.65786, 41.02543], [-121.65765, 41.02535], [-121.65751, 41.02534], [-121.65692, 41.02545], [-121.65677, 41.02544], [-121.65656, 41.02539], [-121.65617, 41.02538], [-121.65595, 41.02533], [-121.65554, 41.02528], [-121.65545, 41.02525], [-121.6554, 41.02518], [-121.6554, 41.02505], [-121.65543, 41.02497], [-121.6554, 41.02491], [-121.65529, 41.02487], [-121.65496, 41.02467], [-121.65493, 41.02462], [-121.65492, 41.02451], [-121.65499, 41.02439], [-121.65502, 41.02426], [-121.65509, 41.02413], [-121.65519, 41.02399], [-121.6554, 41.02381], [-121.65546, 41.02386], [-121.65551, 41.02384], [-121.6556, 41.02377], [-121.65563, 41.02368], [-121.65566, 41.02368], [-121.65573, 41.0237], [-121.65586, 41.02369], [-121.65587, 41.02367], [-121.65581, 41.02353], [-121.65582, 41.02346], [-121.65587, 41.02338], [-121.65586, 41.02315], [-121.65577, 41.02306], [-121.6556, 41.023], [-121.65545, 41.02259], [-121.65546, 41.02247], [-121.65566, 41.02227], [-121.65574, 41.02222], [-121.65583, 41.02223], [-121.65591, 41.0222], [-121.65601, 41.02213], [-121.65601, 41.022], [-121.65603, 41.02198], [-121.65607, 41.02196], [-121.65612, 41.02189], [-121.65621, 41.02186], [-121.65634, 41.02159], [-121.65635, 41.02109], [-121.65631, 41.021], [-121.65614, 41.02076], [-121.65612, 41.02077], [-121.65614, 41.02084], [-121.65622, 41.02098], [-121.65623, 41.02117], [-121.65622, 41.02146], [-121.65618, 41.02146], [-121.65613, 41.02144], [-121.65613, 41.02133], [-121.65611, 41.02123], [-121.65604, 41.02112], [-121.65604, 41.02105], [-121.65594, 41.02091], [-121.65586, 41.02089], [-121.65577, 41.02109], [-121.65566, 41.02126], [-121.65535, 41.02144], [-121.65516, 41.02153], [-121.65494, 41.02158], [-121.65471, 41.0216], [-121.65421, 41.02154], [-121.65402, 41.02158], [-121.65393, 41.0217], [-121.65391, 41.02179], [-121.65391, 41.02196], [-121.65394, 41.02212], [-121.65394, 41.02247], [-121.65391, 41.02266], [-121.65384, 41.0228], [-121.65385, 41.0229], [-121.65396, 41.02312], [-121.65396, 41.02323], [-121.65388, 41.02339], [-121.65364, 41.02362], [-121.65339, 41.02382], [-121.65323, 41.02403], [-121.6531, 41.02435], [-121.6531, 41.02458], [-121.65317, 41.02477], [-121.6534, 41.02513], [-121.65345, 41.02536], [-121.65385, 41.0259], [-121.65401, 41.02597], [-121.65435, 41.02607], [-121.65441, 41.02617], [-121.6546, 41.02634], [-121.65485, 41.0265], [-121.65507, 41.02662], [-121.6553, 41.02669], [-121.65578, 41.02669], [-121.65586, 41.02673], [-121.65616, 41.02729], [-121.6564, 41.02766], [-121.65652, 41.02788], [-121.65666, 41.02803], [-121.65689, 41.02812], [-121.65708, 41.02814], [-121.65732, 41.02829], [-121.65743, 41.02823], [-121.65757, 41.0282], [-121.65779, 41.02811], [-121.65811, 41.02806], [-121.65859, 41.02817], [-121.65872, 41.02833], [-121.65884, 41.02852], [-121.65919, 41.02874], [-121.65929, 41.02885], [-121.65938, 41.02898], [-121.6594, 41.02909]]]} | Open Access 1 | 29195 | McArthur-Burney Falls Memorial State Park | 14072 | 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=455 | Shasta 27 | 192.42 | McArthur-Burney Falls Memorial SP | 1920 | State Park 15 | 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]);