units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 2, DES_TP = 15 and MNG_AG_LEV = 5
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6677 | 6677 | 6676 | {"type": "Polygon", "coordinates": [[[-116.5326, 32.93414], [-116.53245, 32.94818], [-116.51564, 32.94847], [-116.51595, 32.93405], [-116.5326, 32.93414]]]} | Restricted Access 2 | 47524 | Anza-Borrego Desert State Park | 31229 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=638 | San Diego 4 | 609.836 | Anza-Borrego Desert SP | 1933 | State Park 15 | 4 |
16445 | 16445 | 16444 | {"type": "MultiPolygon", "coordinates": [[[[-121.85604, 36.61196], [-121.85602, 36.6123], [-121.85549, 36.61229], [-121.85577, 36.61211], [-121.85604, 36.61196]]], [[[-121.85503, 36.61264], [-121.85502, 36.61276], [-121.85445, 36.61346], [-121.85424, 36.61334], [-121.85428, 36.61329], [-121.85423, 36.61325], [-121.85459, 36.61297], [-121.8547, 36.61293], [-121.85469, 36.61289], [-121.85503, 36.61264]]], [[[-121.85604, 36.61247], [-121.85501, 36.61375], [-121.85459, 36.61352], [-121.85518, 36.61281], [-121.8552, 36.61252], [-121.8553, 36.61245], [-121.85604, 36.61247]]], [[[-121.8533, 36.61398], [-121.85293, 36.61445], [-121.8528, 36.61437], [-121.85329, 36.61399], [-121.8533, 36.61398]]], [[[-121.85436, 36.61357], [-121.85343, 36.61471], [-121.853, 36.61448], [-121.85358, 36.61376], [-121.85404, 36.6134], [-121.85436, 36.61357]]], [[[-121.85492, 36.61387], [-121.85399, 36.61501], [-121.85356, 36.61478], [-121.8544, 36.61375], [-121.85461, 36.61386], [-121.85471, 36.61376], [-121.85492, 36.61387]]], [[[-121.85888, 36.61211], [-121.85775, 36.61324], [-121.85526, 36.61568], [-121.85484, 36.61545], [-121.85489, 36.6154], [-121.85488, 36.61539], [-121.85465, 36.61527], [-121.85459, 36.61532], [-121.85412, 36.61507], [-121.85625, 36.61243], [-121.8563, 36.61191], [-121.85625, 36.61184], [-121.85666, 36.61162], [-121.85711, 36.61141], [-121.85758, 36.61124], [-121.85772, 36.61123], [-121.85771, 36.61156], [-121.85815, 36.61185], [-121.85742, 36.61288], [-121.85765, 36.61301], [-121.85847, 36.61185], [-121.85888, 36.61211]]], [[[-121.85282, 36.61454], [-121.85181, 36.61581], [-121.8514, 36.6156], [-121.85159, 36.61534], [-121.85218, 36.61487], [-121.85224, 36.61489], [-121.85227, 36.61484], [-121.85224, 36.61482], [-121.85236, 36.61472], [-121.85239, 36.61473], [-121.85244, 36.61466], [-121.85268, 36.61447], [-121.85282, 36.61454]]], [[[-121.85122, 36.61598], [-121.85089, 36.6164], [-121.85069, 36.61629], [-121.85102, 36.61587], [-121.85122, 36.61598]]], [[[-121.85389, 36.61511], [-121.85289, 36.61638], [-121.8519, 36.61586], [-121.85291, 36.61458], [-121.85389, 36.61511]]], [[[-121.85245, 36.61631], [-121.85231, 36.61649], [-121.85106, 36.61584], [-121.85123, 36.61567], [-121.85245, 36.61631]]], [[[-121.85065, 36.61633], [-121.85048, 36.61654], [-121.85045, 36.61652], [-121.85062, 36.61632], [-121.85065, 36.61633]]], [[[-121.85449, 36.61543], [-121.85331, 36.6166], [-121.85303, 36.61645], [-121.85403, 36.61518], [-121.85449, 36.61543]]], [[[-121.85165, 36.6162], [-121.85149, 36.6164], [-121.85156, 36.61645], [-121.85139, 36.61666], [-121.85111, 36.61651], [-121.85144, 36.61609], [-121.85165, 36.6162]]], [[[-121.85273, 36.61646], [-121.85259, 36.61664], [-121.85245, 36.61657], [-121.85259, 36.61638], [-121.85273, 36.61646]]], [[[-121.85107, 36.61656], [-121.85091, 36.61676], [-121.85077, 36.61669], [-121.85093, 36.61648], [-121.85107, 36.61656]]], [[[-121.85086, 36.61644], [-121.85053, 36.61686], [-121.85039, 36.61679], [-121.85072, 36.61637], [-121.85086, 36.61644]]], [[[-121.85214, 36.61647], [-121.85198, 36.61667], [-121.85191, 36.61664], [-121.85175, 36.61684], [-121.85153, 36.61673], [-121.85186, 36.61632], [-121.85214, 36.61647]]], [[[-121.85256, 36.61668], [-121.85223, 36.6171], [-121.85203, 36.61699], [-121.85218, 36.61679], [-121.85212, 36.61675], [-121.85228, 36.61654], [-121.85256, 36.61668]]], [[[-121.8515, 36.61678], [-121.85117, 36.6172], [-121.85081, 36.61701], [-121.85114, 36.61659], [-121.8515, 36.61678]]], [[[-121.85219, 36.61715], [-121.85187, 36.61756], [-121.8516, 36.61742], [-121.85175, 36.61722], [-121.85162, 36.61714], [-121.85145, 36.61735], [-121.85124, 36.61724], [-121.85157, 36.61682], [-121.85171, 36.61689], [-121.85155, 36.61709], [-121.85156, 36.61711], [-121.85162, 36.61713], [-121.85178, 36.61693], [-121.85219, 36.61715]]], [[[-121.85319, 36.61671], [-121.85218, 36.61771], [-121.85203, 36.61763], [-121.85288, 36.61654], [-121.85319, 36.61671]]], [[[-121.85035, 36.61749], [-121.85018, 36.61769], [-121.85011, 36.61766], [-121.84995, 36.61786], [-121.84964, 36.61769], [-121.84991, 36.61725], [-121.85013, 36.61737], [-121.84997, 36.61757], [-121.84998, 36.61759], [-121.85011, 36.61765], [-121.85028, 36.61745], [-121.85035, 36.61749]]], [[[-121.85183, 36.61761], [-121.85151, 36.61802], [-121.84994, 36.6172], [-121.85025, 36.61677], [-121.85036, 36.61683], [-121.85019, 36.61704], [-121.8502, 36.61705], [-121.85054, 36.61723], [-121.85071, 36.61702], [-121.85085, 36.6171], [-121.85069, 36.6173], [-121.8507, 36.61731], [-121.85083, 36.61738], [-121.851, 36.61717], [-121.85113, 36.61724], [-121.85098, 36.61745], [-121.85098, 36.61746], [-121.85105, 36.61749], [-121.85121, 36.61728], [-121.85183, 36.61761]]], [[[-121.84998, 36.61795], [-121.84979, 36.6182], [-121.84945, 36.61802], [-121.8496, 36.61775], [-121.84998, 36.61795]]], [[[-121.85055, 36.61825], [-121.85037, 36.61847], [-121.85029, 36.61844], [-121.85048, 36.61821], [-121.85055, 36.61825]]], [[[-121.85147, 36.61808], [-121.85115, 36.61849], [-121.85108, 36.61845], [-121.85124, 36.61826], [-121.85124, 36.61825], [-121.85117, 36.61822], [-121.85101, 36.61842], [-121.85052, 36.61816], [-121.85067, 36.61796], [-121.85067, 36.61795], [-121.8506, 36.61792], [-121.85045, 36.61812], [-121.85009, 36.61793], [-121.85041, 36.61752], [-121.85147, 36.61808]]], [[[-121.85069, 36.61832], [-121.85051, 36.61854], [-121.85044, 36.61851], [-121.85062, 36.61828], [-121.85069, 36.61832]]], [[[-121.85083, 36.61839], [-121.85065, 36.61861], [-121.85058, 36.61858], [-121.85076, 36.61836], [-121.85083, 36.61839]]], [[[-121.85522, 36.61573], [-121.85169, 36.61919], [-121.85126, 36.61896], [-121.85479, 36.6155], [-121.85522, 36.61573]]]]} | Restricted Access 2 | 951 | Monterey State Beach | 22431 | 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=576 | Monterey 14 | 46.342 | Monterey SB | 1960 | State Park 15 | 4 |
16536 | 16536 | 16535 | {"type": "Polygon", "coordinates": [[[-122.33871, 37.12078], [-122.33869, 37.12105], [-122.33865, 37.12119], [-122.3386, 37.12133], [-122.3384, 37.12172], [-122.33836, 37.12186], [-122.33837, 37.122], [-122.33841, 37.12213], [-122.33842, 37.12227], [-122.33842, 37.12255], [-122.33839, 37.12275], [-122.33828, 37.12302], [-122.3383, 37.12315], [-122.33826, 37.12344], [-122.33821, 37.12358], [-122.33818, 37.12372], [-122.33808, 37.124], [-122.3381, 37.12414], [-122.33801, 37.12441], [-122.33799, 37.12469], [-122.33794, 37.12483], [-122.33783, 37.12566], [-122.3378, 37.12581], [-122.33783, 37.12595], [-122.33781, 37.12609], [-122.33785, 37.12665], [-122.3378, 37.12678], [-122.33777, 37.1272], [-122.33769, 37.12748], [-122.33759, 37.12789], [-122.33755, 37.12803], [-122.33755, 37.12816], [-122.33748, 37.12844], [-122.33744, 37.12872], [-122.33742, 37.12901], [-122.33738, 37.12928], [-122.33739, 37.12942], [-122.33729, 37.12971], [-122.33729, 37.12999], [-122.33725, 37.13013], [-122.33725, 37.13027], [-122.3373, 37.1304], [-122.33733, 37.13068], [-122.33743, 37.13124], [-122.33743, 37.13139], [-122.3375, 37.13166], [-122.33751, 37.1318], [-122.33755, 37.13194], [-122.33768, 37.13219], [-122.33772, 37.13233], [-122.33774, 37.13247], [-122.33772, 37.13275], [-122.33774, 37.13289], [-122.33769, 37.13317], [-122.3377, 37.13331], [-122.33758, 37.13387], [-122.3377, 37.13428], [-122.33784, 37.13452], [-122.33808, 37.13506], [-122.33812, 37.13533], [-122.33823, 37.13545], [-122.33827, 37.13559], [-122.33837, 37.13574], [-122.33782, 37.1359], [-122.33754, 37.13615], [-122.33721, 37.13637], [-122.33717, 37.13651], [-122.33708, 37.1366], [-122.33691, 37.13662], [-122.3367, 37.13657], [-122.33653, 37.13663], [-122.33631, 37.13684], [-122.33614, 37.13704], [-122.33614, 37.13714], [-122.33612, 37.13722], [-122.33602, 37.13727], [-122.3356, 37.13722], [-122.33537, 37.13723], [-122.33516, 37.13732], [-122.33502, 37.13734], [-122.33464, 37.13748], [-122.33438, 37.13764], [-122.33402, 37.13768], [-122.33367, 37.13763], [-122.33354, 37.13767], [-122.33339, 37.13769], [-122.33328, 37.13777], [-122.33283, 37.13793], [-122.33259, 37.13804], [-122.33251, 37.13803], [-122.33247, 37.13613], [-122.33432, 37.1352], [-122.3303, 37.12878], [-122.31617, 37.13441], [-122.31223, 37.12991], [-122.32931, 37.12311], [-122.32532, 37.11843], [-122.32185, 37.11978], [-122.3192, 37.1165], [-122.31935, 37.11634], [-122.31944, 37.11622], [-122.31984, 37.11595], [-122.32002, 37.11593], [-122.32019, 37.11593], [-122.32072, 37.11602], [-122.32123, 37.11595], [-122.32158, 37.11601], [-122.32178, 37.11603], [-122.32193, 37.11596], [-122.3221, 37.11592], [-122.32243, 37.11583], [-122.3226, 37.11582], [-122.32271, 37.11572], [-122.32287, 37.11566], [-122.323, 37.11556], [-122.32339, 37.11509], [-122.32369, 37.11493], [-122.32396, 37.11477], [-122.32428, 37.11467], [-122.32444, 37.1146], [-122.32477, 37.11453], [-122.32495, 37.11446], [-122.32509, 37.11438], [-122.32535, 37.1142], [-122.32581, 37.11397], [-122.32609, 37.11379], [-122.32658, 37.11363], [-122.32675, 37.11361], [-122.32723, 37.11343], [-122.3274, 37.11335], [-122.32758, 37.11331], [-122.32787, 37.11317], [-122.32801, 37.11308], [-122.32831, 37.11295], [-122.32858, 37.11274], [-122.32873, 37.11268], [-122.32887, 37.11258], [-122.32897, 37.11247], [-122.32912, 37.11239], [-122.32929, 37.11238], [-122.32942, 37.11247], [-122.32951, 37.11274], [-122.32949, 37.11289], [-122.32965, 37.11314], [-122.32971, 37.11328], [-122.3297, 37.11356], [-122.32975, 37.11383], [-122.32973, 37.11397], [-122.32982, 37.11424], [-122.3299, 37.11437], [-122.33008, 37.11461], [-122.33042, 37.11494], [-122.33066, 37.1153], [-122.33077, 37.11542], [-122.33104, 37.1158], [-122.33141, 37.11613], [-122.3315, 37.11625], [-122.33161, 37.11636], [-122.33181, 37.11659], [-122.33209, 37.11675], [-122.33221, 37.11687], [-122.33225, 37.11689], [-122.33289, 37.11736], [-122.33379, 37.11765], [-122.33429, 37.11775], [-122.33523, 37.11803], [-122.33571, 37.11791], [-122.33626, 37.1176], [-122.33702, 37.11762], [-122.33722, 37.11744], [-122.33732, 37.11756], [-122.33749, 37.1178], [-122.33761, 37.1179], [-122.3377, 37.11803], [-122.338, 37.11838], [-122.33806, 37.11851], [-122.33814, 37.11879], [-122.3382, 37.11892], [-122.33828, 37.11904], [-122.3384, 37.11915], [-122.33848, 37.11928], [-122.33852, 37.11942], [-122.33843, 37.1197], [-122.33841, 37.11998], [-122.33842, 37.12012], [-122.33851, 37.12039], [-122.33859, 37.12052], [-122.33871, 37.12078]]]} | Restricted Access 2 | 47512 | Año Nuevo State Park | 31225 | 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=523 | San Mateo 15 | 706.242 | Año Nuevo SP | 1985 | State Park 15 | 4 |
16620 | 16620 | 16619 | {"type": "Polygon", "coordinates": [[[-123.06541, 38.44033], [-123.05955, 38.44293], [-123.04538, 38.44926], [-123.04539, 38.44927], [-123.04562, 38.44925], [-123.04585, 38.44919], [-123.04589, 38.4492], [-123.04619, 38.44914], [-123.0484, 38.44852], [-123.049, 38.44869], [-123.04985, 38.44907], [-123.05066, 38.44932], [-123.0507, 38.44928], [-123.05074, 38.44928], [-123.05045, 38.44962], [-123.05034, 38.44943], [-123.04937, 38.44908], [-123.0489, 38.44884], [-123.0484, 38.44869], [-123.04567, 38.44941], [-123.04531, 38.44945], [-123.0441, 38.4492], [-123.04357, 38.44907], [-123.04159, 38.44808], [-123.04025, 38.44779], [-123.04016, 38.44776], [-123.04007, 38.44769], [-123.03995, 38.44751], [-123.03969, 38.44739], [-123.0392, 38.44694], [-123.03906, 38.44686], [-123.03897, 38.44687], [-123.03891, 38.4469], [-123.0389, 38.44695], [-123.03898, 38.44752], [-123.03883, 38.44775], [-123.0387, 38.44809], [-123.03875, 38.44832], [-123.03918, 38.44845], [-123.0393, 38.44851], [-123.03972, 38.44864], [-123.03883, 38.45003], [-123.03798, 38.45013], [-123.03383, 38.45229], [-123.03039, 38.45281], [-123.02686, 38.45609], [-123.02698, 38.44592], [-123.02648, 38.44591], [-123.02648, 38.4457], [-123.02663, 38.4457], [-123.02677, 38.4456], [-123.02688, 38.44547], [-123.02696, 38.44525], [-123.02689, 38.44489], [-123.027, 38.44461], [-123.02727, 38.44453], [-123.02734, 38.44452], [-123.02825, 38.44081], [-123.02482, 38.43695], [-123.02672, 38.43336], [-123.02721, 38.43277], [-123.02695, 38.43235], [-123.027, 38.43192], [-123.02694, 38.43174], [-123.02649, 38.43088], [-123.02729, 38.42882], [-123.02432, 38.42532], [-123.02426, 38.42538], [-123.02413, 38.42539], [-123.02401, 38.42543], [-123.02382, 38.42565], [-123.02373, 38.42572], [-123.02331, 38.42587], [-123.02318, 38.42593], [-123.02308, 38.42604], [-123.0229, 38.42614], [-123.02246, 38.42611], [-123.02217, 38.42616], [-123.02199, 38.42616], [-123.02184, 38.42612], [-123.02172, 38.42604], [-123.02153, 38.42588], [-123.02141, 38.42581], [-123.02134, 38.42579], [-123.02087, 38.42578], [-123.02069, 38.42576], [-123.02053, 38.42571], [-123.0204, 38.42565], [-123.02016, 38.4255], [-123.01966, 38.42516], [-123.01937, 38.42504], [-123.01917, 38.42505], [-123.01906, 38.42508], [-123.01888, 38.42517], [-123.01853, 38.42547], [-123.01845, 38.42557], [-123.01833, 38.42595], [-123.01823, 38.42605], [-123.01811, 38.42612], [-123.01796, 38.42616], [-123.01779, 38.42616], [-123.01761, 38.42608], [-123.01751, 38.426], [-123.01741, 38.42596], [-123.017, 38.42594], [-123.01681, 38.42594], [-123.01669, 38.42598], [-123.01646, 38.42612], [-123.01635, 38.42617], [-123.01594, 38.42628], [-123.01579, 38.42627], [-123.0155, 38.42614], [-123.01506, 38.42601], [-123.01488, 38.42594], [-123.01475, 38.42567], [-123.01464, 38.42558], [-123.01416, 38.42563], [-123.01399, 38.42562], [-123.01385, 38.42558], [-123.01356, 38.42544], [-123.01343, 38.42532], [-123.01334, 38.42503], [-123.01321, 38.42497], [-123.01255, 38.42476], [-123.01212, 38.42482], [-123.01194, 38.42488], [-123.01185, 38.42493], [-123.0118, 38.42503], [-123.01184, 38.42531], [-123.01175, 38.42548], [-123.01153, 38.42566], [-123.01095, 38.42597], [-123.01072, 38.42603], [-123.01052, 38.42602], [-123.00991, 38.42591], [-123.00943, 38.42593], [-123.00878, 38.42605], [-123.00861, 38.42603], [-123.00819, 38.42578], [-123.00804, 38.42576], [-123.00786, 38.42576], [-123.00744, 38.42569], [-123.00699, 38.42553], [-123.00677, 38.42552], [-123.00644, 38.42557], [-123.00609, 38.42566], [-123.00589, 38.42567], [-123.00549, 38.42542], [-123.00533, 38.42542], [-123.00475, 38.4257], [-123.00458, 38.42575], [-123.00428, 38.42582], [-123.00415, 38.42588], [-123.00384, 38.42611], [-123.00331, 38.42631], [-123.00316, 38.42633], [-123.00273, 38.42628], [-123.00205, 38.42616], [-123.00181, 38.42609], [-123.00137, 38.42609], [-123.00105, 38.42593], [-123.00074, 38.42565], [-123.00057, 38.42555], [-123.00024, 38.42552], [-123.00005, 38.42542], [-122.9998, 38.42523], [-122.9995, 38.42505], [-122.99916, 38.42478], [-122.99896, 38.42475], [-122.99864, 38.42479], [-122.99855, 38.42478], [-122.99857, 38.42315], [-122.99912, 38.42213], [-122.99991, 38.42099], [-123.00012, 38.41976], [-123.00015, 38.41939], [-122.99931, 38.41841], [-122.99947, 38.41731], [-122.99932, 38.41526], [-122.99923, 38.41492], [-123.01096, 38.41481], [-123.01171, 38.41418], [-123.01283, 38.41436], [-123.01359, 38.41458], [-123.01375, 38.4133], [-123.01376, 38.41272], [-123.01384, 38.41186], [-123.01314, 38.41121], [-123.01167, 38.41116], [-123.01065, 38.40993], [-123.01062, 38.40751], [-123.01123, 38.40694], [-123.01147, 38.40646], [-123.01184, 38.40621], [-123.01239, 38.40385], [-123.01433, 38.40402], [-123.0144, 38.40379], [-123.01688, 38.40401], [-123.02128, 38.40565], [-123.02514, 38.40603], [-123.03424, 38.40718], [-123.03456, 38.40857], [-123.03622, 38.40922], [-123.03717, 38.40919], [-123.03759, 38.40963], [-123.03771, 38.41104], [-123.03832, 38.41113], [-123.03962, 38.41034], [-123.04027, 38.41069], [-123.04063, 38.41146], [-123.04125, 38.41231], [-123.04101, 38.4158], [-123.04139, 38.41629], [-123.04027, 38.41654], [-123.03749, 38.41814], [-123.03516, 38.41888], [-123.03558, 38.41986], [-123.03576, 38.41997], [-123.03616, 38.42027], [-123.03648, 38.42046], [-123.03665, 38.4206], [-123.03687, 38.42095], [-123.03712, 38.42126], [-123.03723, 38.42132], [-123.03754, 38.42142], [-123.03768, 38.42146], [-123.03781, 38.42147], [-123.03822, 38.42144], [-123.03868, 38.42134], [-123.03957, 38.42124], [-123.0399, 38.42117], [-123.04038, 38.42103], [-123.04051, 38.42102], [-123.04066, 38.42103], [-123.04098, 38.42108], [-123.04128, 38.42109], [-123.04173, 38.42114], [-123.04184, 38.42113], [-123.04244, 38.42085], [-123.04264, 38.42078], [-123.04361, 38.42071], [-123.04369, 38.4207], [-123.0443, 38.42046], [-123.04468, 38.42034], [-123.04484, 38.42032], [-123.04495, 38.42032], [-123.04513, 38.42039], [-123.04522, 38.4205], [-123.04525, 38.4206], [-123.04548, 38.42197], [-123.04555, 38.42212], [-123.04568, 38.42235], [-123.04596, 38.42257], [-123.04605, 38.42261], [-123.04668, 38.42274], [-123.04696, 38.42278], [-123.04751, 38.42288], [-123.0481, 38.4229], [-123.04836, 38.42296], [-123.04878, 38.42317], [-123.04894, 38.4232], [-123.05031, 38.42331], [-123.05054, 38.42335], [-123.0513, 38.42366], [-123.0515, 38.42377], [-123.05163, 38.42391], [-123.05175, 38.42419], [-123.05205, 38.42434], [-123.05207, 38.42445], [-123.05376, 38.42792], [-123.05044, 38.42964], [-123.04725, 38.43122], [-123.04724, 38.43124], [-123.06541, 38.44033]], [[-123.03771, 38.4441], [-123.03771, 38.44411], [-123.03877, 38.44657], [-123.03921, 38.44674], [-123.03939, 38.44685], [-123.03964, 38.4468], [-123.03967, 38.44643], [-123.0396, 38.44606], [-123.03964, 38.44545], [-123.03967, 38.44523], [-123.03972, 38.4451], [-123.03952, 38.44491], [-123.03923, 38.4445], [-123.03911, 38.444], [-123.03855, 38.44398], [-123.03821, 38.44399], [-123.03771, 38.4441]]]} | Restricted Access 2 | 29590 | Sonoma Coast State Park | 25609 | 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=451 | Sonoma 16 | 3374.346 | Sonoma Coast SP | 1934 | 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]);