units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 2 and YR_EST = 1979
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, MNG_AG_LEV, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6535 | 6535 | 6534 | {"type": "Polygon", "coordinates": [[[-122.51383, 38.36841], [-122.50814, 38.36943], [-122.50109, 38.36935], [-122.50067, 38.3693], [-122.50062, 38.37298], [-122.49612, 38.37301], [-122.49619, 38.38388], [-122.49155, 38.38386], [-122.49153, 38.38309], [-122.49061, 38.38253], [-122.48896, 38.38256], [-122.48894, 38.38236], [-122.48691, 38.3824], [-122.48686, 38.38021], [-122.4822, 38.38028], [-122.48217, 38.37661], [-122.48672, 38.37655], [-122.48672, 38.37492], [-122.48674, 38.37294], [-122.49158, 38.37294], [-122.49147, 38.36576], [-122.50061, 38.36569], [-122.50092, 38.36636], [-122.50569, 38.36502], [-122.50569, 38.36589], [-122.50542, 38.36613], [-122.50591, 38.36725], [-122.51009, 38.36459], [-122.51073, 38.36522], [-122.5103, 38.36548], [-122.51046, 38.36566], [-122.51001, 38.36593], [-122.51001, 38.36594], [-122.51145, 38.36594], [-122.51318, 38.36769], [-122.51383, 38.36841]]]} | Restricted Access 2 | 3227 | Bouverie Wildflower Preserve | 16305 | 3005 | Audubon Canyon Ranch 837 | Non Profit 6 | Non Profit - Conservation 12 | http://www.egret.org | Non Governmental Organization 10 | 3005 | Audubon Canyon Ranch 814 | Non Profit 6 | Non Profit - Conservation 12 | Sonoma 16 | 527.836 | Bouverie Wildflower Preserve | 1979 | Private Conservation 16 | 2 | |
12672 | 12672 | 12671 | {"type": "Polygon", "coordinates": [[[-122.1579, 38.02489], [-122.15653, 38.0249], [-122.15653, 38.02492], [-122.15716, 38.02516], [-122.14088, 38.02769], [-122.14074, 38.02715], [-122.13972, 38.02728], [-122.13935, 38.02633], [-122.13962, 38.02572], [-122.14132, 38.02522], [-122.1414, 38.02511], [-122.14103, 38.02493], [-122.14094, 38.02472], [-122.14094, 38.02428], [-122.1414, 38.0241], [-122.14146, 38.02396], [-122.1419, 38.02371], [-122.1421, 38.023], [-122.14233, 38.0228], [-122.14331, 38.0225], [-122.14464, 38.02239], [-122.14591, 38.02221], [-122.14632, 38.02195], [-122.1516, 38.02283], [-122.15255, 38.0231], [-122.1543, 38.02374], [-122.15431, 38.02375], [-122.15437, 38.02376], [-122.15483, 38.02393], [-122.15722, 38.02463], [-122.1579, 38.02489]]]} | Restricted Access 2 | 29625 | Martinez Regional Shoreline | 21927 | 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 | Contra Costa 12 | 140.251 | Martinez Reg. Shoreline | 1979 | Local Park 2 | 4 | |
15622 | 15622 | 15621 | {"type": "MultiPolygon", "coordinates": [[[[-120.99849, 38.71474], [-120.9984, 38.72556], [-120.99379, 38.72559], [-120.98918, 38.72557], [-120.98919, 38.72192], [-120.99263, 38.72192], [-120.99266, 38.72007], [-120.99614, 38.7201], [-120.99614, 38.71828], [-120.99268, 38.71828], [-120.99266, 38.71736], [-120.98803, 38.71733], [-120.98799, 38.72006], [-120.98457, 38.72003], [-120.9846, 38.71472], [-120.99849, 38.71474]]], [[[-120.99758, 38.75808], [-120.99756, 38.75933], [-120.99756, 38.76166], [-120.99276, 38.76166], [-120.99278, 38.75805], [-120.99758, 38.75808]]], [[[-121.01128, 38.76173], [-121.01128, 38.76536], [-121.00666, 38.76527], [-121.00665, 38.76166], [-121.01128, 38.76173]]], [[[-121.0308, 38.73276], [-121.03076, 38.73635], [-121.02602, 38.73638], [-121.02145, 38.73638], [-121.02146, 38.73434], [-121.02149, 38.7328], [-121.02595, 38.7328], [-121.0308, 38.73276]]], [[[-121.04395, 38.75464], [-121.04405, 38.75901], [-121.04389, 38.7595], [-121.04381, 38.75961], [-121.03042, 38.75956], [-121.0304, 38.76194], [-121.02538, 38.76194], [-121.02521, 38.75456], [-121.04395, 38.75464]]], [[[-121.03722, 38.76319], [-121.03512, 38.76242], [-121.03273, 38.7626], [-121.03226, 38.76226], [-121.03304, 38.76135], [-121.03306, 38.7614], [-121.0331, 38.76146], [-121.03318, 38.76147], [-121.03327, 38.76146], [-121.03337, 38.7614], [-121.03465, 38.76141], [-121.03489, 38.76138], [-121.03451, 38.76022], [-121.03598, 38.76012], [-121.03594, 38.76022], [-121.03594, 38.7603], [-121.03614, 38.76073], [-121.03636, 38.7611], [-121.03646, 38.7613], [-121.03657, 38.76144], [-121.03676, 38.76161], [-121.03687, 38.76175], [-121.03709, 38.76217], [-121.03715, 38.76242], [-121.03722, 38.76319]]]]} | Restricted Access 2 | 21565 | Pine Hill Ecological Reserve | 23679 | 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/Pine-Hill-ER | El Dorado 34 | 666.591 | Pine Hill ER | 1979 | State Conservation Area 8 | 2 |
16688 | 16688 | 16687 | {"type": "MultiPolygon", "coordinates": [[[[-121.63315, 37.64335], [-121.63279, 37.64354], [-121.63119, 37.64418], [-121.63057, 37.64447], [-121.63043, 37.64468], [-121.6299, 37.64486], [-121.6299, 37.64487], [-121.63006, 37.64497], [-121.63002, 37.64507], [-121.62922, 37.64539], [-121.62826, 37.64573], [-121.62691, 37.6458], [-121.62516, 37.64599], [-121.62365, 37.64629], [-121.62244, 37.64643], [-121.62214, 37.64651], [-121.62194, 37.6466], [-121.62173, 37.64676], [-121.62146, 37.64691], [-121.6207, 37.64726], [-121.62042, 37.6474], [-121.61916, 37.64814], [-121.61877, 37.64833], [-121.61798, 37.64868], [-121.61776, 37.64881], [-121.61748, 37.64901], [-121.61629, 37.64942], [-121.61606, 37.64953], [-121.61546, 37.64993], [-121.61533, 37.65003], [-121.61518, 37.65021], [-121.61513, 37.65033], [-121.6151, 37.65043], [-121.61301, 37.6504], [-121.61269, 37.65007], [-121.61244, 37.64986], [-121.6122, 37.64971], [-121.61168, 37.64944], [-121.61131, 37.64928], [-121.61086, 37.64912], [-121.61072, 37.64903], [-121.61065, 37.64895], [-121.61061, 37.64888], [-121.61055, 37.64863], [-121.61056, 37.64847], [-121.61063, 37.64829], [-121.61065, 37.64816], [-121.61063, 37.64801], [-121.61056, 37.64787], [-121.6104, 37.64773], [-121.61002, 37.64752], [-121.60982, 37.64745], [-121.60955, 37.64741], [-121.60932, 37.64743], [-121.60918, 37.64745], [-121.60859, 37.64765], [-121.60841, 37.64776], [-121.60835, 37.64783], [-121.60829, 37.64792], [-121.60802, 37.64928], [-121.60802, 37.64939], [-121.60805, 37.64948], [-121.60817, 37.64971], [-121.60823, 37.64993], [-121.60823, 37.65016], [-121.60819, 37.65031], [-121.60817, 37.65033], [-121.60554, 37.65029], [-121.60101, 37.65028], [-121.60085, 37.65019], [-121.60074, 37.65007], [-121.6007, 37.64994], [-121.60072, 37.64979], [-121.60077, 37.64972], [-121.60091, 37.64963], [-121.60108, 37.64957], [-121.60133, 37.64953], [-121.60146, 37.6495], [-121.6016, 37.64943], [-121.60173, 37.64932], [-121.60183, 37.64917], [-121.60187, 37.64902], [-121.60185, 37.64886], [-121.60179, 37.64872], [-121.60167, 37.64861], [-121.60153, 37.64855], [-121.5997, 37.6484], [-121.59955, 37.64835], [-121.59939, 37.64827], [-121.59924, 37.64818], [-121.59913, 37.64807], [-121.59903, 37.64794], [-121.59882, 37.64757], [-121.5988, 37.64746], [-121.59881, 37.64736], [-121.59884, 37.64721], [-121.59891, 37.64706], [-121.59905, 37.64688], [-121.59907, 37.64679], [-121.59907, 37.6467], [-121.59901, 37.64658], [-121.59887, 37.64644], [-121.59879, 37.64631], [-121.59863, 37.6457], [-121.59845, 37.64541], [-121.59843, 37.64523], [-121.59848, 37.64498], [-121.59844, 37.64484], [-121.59837, 37.64477], [-121.59818, 37.64464], [-121.59808, 37.64454], [-121.59802, 37.64442], [-121.59797, 37.6442], [-121.59793, 37.64412], [-121.59787, 37.64405], [-121.59686, 37.64345], [-121.59666, 37.64328], [-121.59655, 37.64315], [-121.59599, 37.64223], [-121.59585, 37.64204], [-121.59569, 37.64188], [-121.59554, 37.64176], [-121.59485, 37.64133], [-121.59467, 37.64119], [-121.5945, 37.64099], [-121.59427, 37.64065], [-121.59421, 37.64052], [-121.59411, 37.64041], [-121.594, 37.64034], [-121.5939, 37.6403], [-121.59381, 37.64028], [-121.59365, 37.64027], [-121.59307, 37.64039], [-121.59267, 37.64051], [-121.59248, 37.64059], [-121.59224, 37.64072], [-121.59174, 37.64125], [-121.59162, 37.64135], [-121.59144, 37.64145], [-121.59126, 37.6415], [-121.59103, 37.64153], [-121.59084, 37.64151], [-121.58975, 37.64127], [-121.5895, 37.64114], [-121.58844, 37.64035], [-121.58828, 37.64026], [-121.58812, 37.64021], [-121.58795, 37.64018], [-121.58675, 37.63988], [-121.58625, 37.63969], [-121.58591, 37.63952], [-121.58626, 37.63876], [-121.58647, 37.6376], [-121.58578, 37.63733], [-121.5853, 37.63725], [-121.58475, 37.63904], [-121.58125, 37.63841], [-121.58095, 37.63837], [-121.58023, 37.63833], [-121.5808, 37.63644], [-121.57877, 37.63615], [-121.5782, 37.63798], [-121.577, 37.6377], [-121.57571, 37.63751], [-121.57448, 37.63754], [-121.57424, 37.63758], [-121.57346, 37.63776], [-121.57311, 37.63786], [-121.57169, 37.63838], [-121.57169, 37.63624], [-121.57146, 37.6361], [-121.57128, 37.63606], [-121.57114, 37.63607], [-121.57099, 37.6361], [-121.57076, 37.63624], [-121.57067, 37.63635], [-121.57061, 37.63651], [-121.5706, 37.63872], [-121.5704, 37.63878], [-121.57018, 37.63879], [-121.56976, 37.63874], [-121.5693, 37.63861], [-121.56875, 37.63839], [-121.56763, 37.63785], [-121.5638, 37.63691], [-121.56162, 37.63659], [-121.55909, 37.63636], [-121.55729, 37.63602], [-121.55719, 37.62034], [-121.5584, 37.62065], [-121.57076, 37.62095], [-121.57114, 37.62135], [-121.57194, 37.62208], [-121.57211, 37.6227], [-121.57269, 37.62315], [-121.57303, 37.62355], [-121.57348, 37.62369], [-121.57357, 37.62382], [-121.57462, 37.62338], [-121.57431, 37.62292], [-121.57378, 37.62276], [-121.57355, 37.6225], [-121.57319, 37.62222], [-121.573, 37.62147], [-121.57279, 37.62139], [-121.57221, 37.62098], [-121.58753, 37.62133], [-121.58739, 37.60781], [-121.60578, 37.60802], [-121.60564, 37.62145], [-121.61113, 37.62148], [-121.61116, 37.63585], [-121.62366, 37.63608], [-121.62366, 37.64326], [-121.63315, 37.64335]]], [[[-121.59535, 37.65026], [-121.58738, 37.65023], [-121.5874, 37.64329], [-121.577, 37.64309], [-121.57506, 37.63858], [-121.5749, 37.6377], [-121.57569, 37.63769], [-121.57685, 37.63785], [-121.5771, 37.63789], [-121.57932, 37.63842], [-121.57982, 37.63848], [-121.58088, 37.63854], [-121.58121, 37.63857], [-121.58481, 37.63929], [-121.58504, 37.63936], [-121.58529, 37.63946], [-121.5859, 37.63981], [-121.58632, 37.64], [-121.58807, 37.64051], [-121.5882, 37.64056], [-121.58837, 37.64065], [-121.58947, 37.64144], [-121.58967, 37.64155], [-121.58986, 37.64161], [-121.5909, 37.64183], [-121.59111, 37.64184], [-121.59132, 37.64182], [-121.59137, 37.64387], [-121.59141, 37.64467], [-121.59202, 37.64823], [-121.59234, 37.64851], [-121.59329, 37.64875], [-121.59393, 37.64908], [-121.59438, 37.64926], [-121.59491, 37.64983], [-121.59535, 37.65026]]], [[[-121.61271, 37.6504], [-121.60843, 37.65033], [-121.60847, 37.65024], [-121.60848, 37.65016], [-121.60848, 37.64988], [-121.60842, 37.64968], [-121.60828, 37.64942], [-121.60826, 37.64928], [-121.60851, 37.64802], [-121.60854, 37.64795], [-121.60861, 37.64788], [-121.60871, 37.64782], [-121.60923, 37.64765], [-121.60945, 37.64761], [-121.60964, 37.64762], [-121.60984, 37.64767], [-121.61023, 37.64788], [-121.61034, 37.64797], [-121.6104, 37.64809], [-121.6104, 37.6482], [-121.61031, 37.64846], [-121.6103, 37.64863], [-121.61038, 37.64896], [-121.61051, 37.64914], [-121.61061, 37.64922], [-121.61072, 37.64928], [-121.61138, 37.64953], [-121.61196, 37.64981], [-121.61218, 37.64995], [-121.61239, 37.6501], [-121.61271, 37.6504]]]]} | Restricted Access 2 | 23048 | Carnegie State Vehicular Recreation Area | 16885 | 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 | Alameda 17 | 3858.038 | Carnegie SVRA | 1979 | State Recreation Area 39 | 4 | |
16789 | 16789 | 16788 | {"type": "MultiPolygon", "coordinates": [[[[-120.74252, 37.27339], [-120.73801, 37.28775], [-120.73803, 37.29353], [-120.72413, 37.29258], [-120.72414, 37.28789], [-120.71512, 37.28784], [-120.71515, 37.2805], [-120.70615, 37.28052], [-120.70625, 37.26775], [-120.70642, 37.25213], [-120.70653, 37.25216], [-120.70654, 37.25215], [-120.70641, 37.2521], [-120.70645, 37.2499], [-120.70639, 37.24428], [-120.70665, 37.24428], [-120.70702, 37.24491], [-120.70732, 37.24525], [-120.71901, 37.2545], [-120.72423, 37.25905], [-120.73083, 37.26454], [-120.73586, 37.26762], [-120.74252, 37.27339]]], [[[-120.85194, 37.24763], [-120.85193, 37.24991], [-120.8519, 37.25195], [-120.85118, 37.25691], [-120.8512, 37.26022], [-120.85118, 37.27587], [-120.85119, 37.29287], [-120.85117, 37.29466], [-120.85051, 37.29446], [-120.84875, 37.29431], [-120.84796, 37.29407], [-120.84712, 37.29378], [-120.84611, 37.29362], [-120.84403, 37.29454], [-120.84249, 37.29477], [-120.84174, 37.29435], [-120.84255, 37.2932], [-120.84234, 37.29211], [-120.84212, 37.29197], [-120.84232, 37.29178], [-120.84266, 37.2917], [-120.84287, 37.29154], [-120.84305, 37.29131], [-120.84329, 37.29097], [-120.84436, 37.29066], [-120.84487, 37.28979], [-120.84492, 37.2888], [-120.84475, 37.28831], [-120.84376, 37.28554], [-120.84296, 37.28441], [-120.84333, 37.28298], [-120.84367, 37.28206], [-120.84364, 37.28158], [-120.84265, 37.28125], [-120.8423, 37.28126], [-120.84202, 37.28155], [-120.84084, 37.28229], [-120.8399, 37.2828], [-120.83792, 37.28341], [-120.83728, 37.28345], [-120.83693, 37.2834], [-120.83652, 37.28314], [-120.8353, 37.28266], [-120.83461, 37.28243], [-120.83346, 37.28186], [-120.83313, 37.28166], [-120.83145, 37.28131], [-120.83075, 37.2804], [-120.82988, 37.28012], [-120.82941, 37.28006], [-120.82891, 37.28012], [-120.82781, 37.28071], [-120.82674, 37.28065], [-120.82668, 37.28014], [-120.82746, 37.27962], [-120.82848, 37.27936], [-120.82902, 37.27931], [-120.82951, 37.27916], [-120.83005, 37.27901], [-120.83074, 37.27865], [-120.83166, 37.27853], [-120.83174, 37.27803], [-120.83153, 37.27737], [-120.83071, 37.27651], [-120.82901, 37.27551], [-120.82839, 37.27501], [-120.828, 37.27449], [-120.82758, 37.27416], [-120.82746, 37.27415], [-120.82721, 37.27384], [-120.82694, 37.2734], [-120.8268, 37.27295], [-120.82683, 37.27157], [-120.82699, 37.27105], [-120.82744, 37.27045], [-120.82822, 37.26968], [-120.82884, 37.26958], [-120.82942, 37.26917], [-120.82932, 37.27003], [-120.82952, 37.27116], [-120.82984, 37.2715], [-120.83055, 37.27171], [-120.83143, 37.27151], [-120.83201, 37.27086], [-120.83243, 37.26846], [-120.83273, 37.26788], [-120.8329, 37.26747], [-120.83266, 37.26632], [-120.83229, 37.26584], [-120.83111, 37.26585], [-120.8306, 37.26615], [-120.82954, 37.26657], [-120.82816, 37.26687], [-120.82773, 37.2667], [-120.82766, 37.26637], [-120.82814, 37.26572], [-120.82941, 37.26468], [-120.83006, 37.26402], [-120.83055, 37.26377], [-120.83075, 37.26342], [-120.83091, 37.26296], [-120.83103, 37.26243], [-120.83123, 37.26215], [-120.83134, 37.26163], [-120.83029, 37.26066], [-120.82984, 37.25999], [-120.82979, 37.25963], [-120.82946, 37.25997], [-120.82945, 37.25983], [-120.81555, 37.25869], [-120.81536, 37.27295], [-120.81281, 37.27297], [-120.81034, 37.27066], [-120.80641, 37.26816], [-120.80429, 37.26568], [-120.80294, 37.26417], [-120.80086, 37.2619], [-120.7972, 37.26047], [-120.79462, 37.26047], [-120.79222, 37.2564], [-120.79063, 37.25607], [-120.7898, 37.25668], [-120.7882, 37.25662], [-120.7863, 37.25551], [-120.78269, 37.25634], [-120.77959, 37.25569], [-120.7768, 37.25676], [-120.76999, 37.2572], [-120.76637, 37.25882], [-120.76432, 37.25878], [-120.76431, 37.25882], [-120.76082, 37.25881], [-120.76082, 37.26605], [-120.75626, 37.26611], [-120.7565, 37.27746], [-120.74319, 37.27327], [-120.74299, 37.2732], [-120.7427, 37.27291], [-120.74264, 37.259], [-120.74261, 37.25898], [-120.74259, 37.25155], [-120.74259, 37.24989], [-120.74269, 37.24434], [-120.74267, 37.24043], [-120.74265, 37.22992], [-120.74917, 37.22993], [-120.751, 37.22997], [-120.75999, 37.22993], [-120.76078, 37.22982], [-120.76081, 37.24439], [-120.77891, 37.24433], [-120.77899, 37.22991], [-120.77942, 37.22992], [-120.77943, 37.22991], [-120.77945, 37.22269], [-120.77944, 37.22268], [-120.77912, 37.22269], [-120.77909, 37.22973], [-120.77898, 37.22973], [-120.77903, 37.22281], [-120.77902, 37.21892], [-120.77904, 37.21359], [-120.77974, 37.21321], [-120.78051, 37.21301], [-120.78131, 37.21298], [-120.78217, 37.21315], [-120.7827, 37.21385], [-120.78281, 37.21451], [-120.78336, 37.21478], [-120.7837, 37.21528], [-120.78312, 37.21704], [-120.78341, 37.21808], [-120.78344, 37.21884], [-120.78296, 37.21992], [-120.7831, 37.22054], [-120.78371, 37.22157], [-120.78507, 37.22288], [-120.7854, 37.2229], [-120.78609, 37.22237], [-120.78768, 37.22177], [-120.78963, 37.22157], [-120.79073, 37.22166], [-120.7915, 37.22221], [-120.79242, 37.22255], [-120.79346, 37.22264], [-120.79384, 37.22172], [-120.79529, 37.22218], [-120.79745, 37.22224], [-120.79819, 37.22262], [-120.79904, 37.22276], [-120.79952, 37.22312], [-120.7999, 37.22391], [-120.79999, 37.22457], [-120.80051, 37.22528], [-120.80091, 37.22561], [-120.80208, 37.22604], [-120.80281, 37.22599], [-120.80388, 37.22556], [-120.8043, 37.22564], [-120.80482, 37.22613], [-120.80484, 37.22691], [-120.80491, 37.22787], [-120.80532, 37.22874], [-120.80597, 37.22945], [-120.80642, 37.22977], [-120.80665, 37.22979], [-120.80793, 37.22805], [-120.80897, 37.22843], [-120.80989, 37.22953], [-120.81019, 37.2304], [-120.80994, 37.23241], [-120.80997, 37.2329], [-120.80995, 37.23294], [-120.80996, 37.23295], [-120.83466, 37.21965], [-120.83507, 37.22048], [-120.83537, 37.22099], [-120.83607, 37.22144], [-120.83635, 37.22194], [-120.83628, 37.22285], [-120.83589, 37.22382], [-120.83618, 37.22416], [-120.83666, 37.22434], [-120.83801, 37.22413], [-120.83924, 37.22397], [-120.8399, 37.22384], [-120.84047, 37.22403], [-120.84204, 37.22424], [-120.84265, 37.22455], [-120.84307, 37.22507], [-120.84316, 37.22596], [-120.8429, 37.22701], [-120.84161, 37.22791], [-120.84124, 37.22828], [-120.84101, 37.2288], [-120.84113, 37.22934], [-120.84163, 37.22975], [-120.84299, 37.22997], [-120.8433, 37.23141], [-120.84375, 37.23193], [-120.84443, 37.23229], [-120.84467, 37.23295], [-120.84448, 37.23427], [-120.84441, 37.23468], [-120.84445, 37.235], [-120.84447, 37.23586], [-120.84527, 37.23647], [-120.84603, 37.23636], [-120.84692, 37.23643], [-120.84749, 37.23689], [-120.84773, 37.23721], [-120.84782, 37.23771], [-120.84776, 37.23829], [-120.84772, 37.2388], [-120.84761, 37.23955], [-120.84745, 37.23979], [-120.84696, 37.24014], [-120.84634, 37.24028], [-120.84501, 37.24012], [-120.8443, 37.24082], [-120.84436, 37.24127], [-120.84425, 37.24161], [-120.84397, 37.24265], [-120.84466, 37.24361], [-120.84533, 37.2439], [-120.84672, 37.24387], [-120.84744, 37.24424], [-120.84785, 37.24463], [-120.84846, 37.24507], [-120.84873, 37.24552], [-120.84868, 37.24578], [-120.84831, 37.24618], [-120.84832, 37.2462], [-120.84907, 37.24651], [-120.84919, 37.24655], [-120.84998, 37.24643], [-120.85036, 37.24607], [-120.85075, 37.24582], [-120.85127, 37.24631], [-120.85123, 37.24707], [-120.85137, 37.24739], [-120.85194, 37.24763]], [[-120.83487, 37.2587], [-120.83483, 37.25799], [-120.83458, 37.25776], [-120.83409, 37.25753], [-120.83398, 37.25719], [-120.83326, 37.257], [-120.833, 37.25675], [-120.83297, 37.25598], [-120.83266, 37.2557], [-120.83177, 37.25559], [-120.83093, 37.25593], [-120.83093, 37.25633], [-120.83094, 37.25634], [-120.83149, 37.25595], [-120.83206, 37.25591], [-120.83237, 37.256], [-120.83257, 37.25668], [-120.83275, 37.2568], [-120.8328, 37.25696], [-120.83312, 37.25717], [-120.83349, 37.25721], [-120.83383, 37.25737], [-120.83378, 37.25767], [-120.83343, 37.25808], [-120.83346, 37.25824], [-120.83426, 37.2587], [-120.83492, 37.2594], [-120.83518, 37.25941], [-120.83521, 37.25922], [-120.83487, 37.2587]], [[-120.83243, 37.25842], [-120.83243, 37.25767], [-120.8312, 37.25698], [-120.83103, 37.25694], [-120.83094, 37.25696], [-120.83094, 37.25742], [-120.83114, 37.25765], [-120.83123, 37.25835], [-120.83277, 37.25929], [-120.83294, 37.25929], [-120.83289, 37.259], [-120.83243, 37.25842]], [[-120.78869, 37.22995], [-120.78863, 37.22968], [-120.78917, 37.22895], [-120.7892, 37.22851], [-120.78869, 37.22792], [-120.78626, 37.22666], [-120.78285, 37.22599], [-120.7826, 37.22597], [-120.78219, 37.22627], [-120.78194, 37.22663], [-120.78194, 37.22712], [-120.78285, 37.22808], [-120.78299, 37.22842], [-120.78302, 37.22902], [-120.78316, 37.22943], [-120.78351, 37.23009], [-120.78382, 37.23029], [-120.78485, 37.23039], [-120.78537, 37.2305], [-120.78643, 37.23162], [-120.78674, 37.23213], [-120.78711, 37.23298], [-120.78746, 37.23345], [-120.78797, 37.23389], [-120.79009, 37.23474], [-120.79055, 37.2348], [-120.79152, 37.23462], [-120.79223, 37.23435], [-120.79324, 37.23353], [-120.79326, 37.23325], [-120.79232, 37.23243], [-120.79052, 37.23119], [-120.78975, 37.23087], [-120.78909, 37.23043], [-120.78869, 37.22995]]]]} | Restricted Access 2 | 31036 | Grasslands Wildlife Management Area | 19449 | 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 | Merced 37 | 12351.617 | Grasslands WMA | 1979 | Conservation Area 13 | 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]);