calands: units_with_maps: 1 row where COUNTY = 1 and YR

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where COUNTY = 1 and YR_EST = 1993

Search:

descending

This data as json, copyable, CSV (advanced)

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
636	636	635	{"type": "MultiPolygon", "coordinates": [[[[-120.01824, 35.08213], [-120.01787, 35.08288], [-120.01747, 35.08289], [-120.0172, 35.08288], [-120.01694, 35.08285], [-120.01663, 35.08279], [-120.01626, 35.08266], [-120.01409, 35.08167], [-120.01362, 35.08148], [-120.00652, 35.07888], [-120.00653, 35.07884], [-120.00601, 35.07864], [-120.00568, 35.07847], [-120.00534, 35.07823], [-120.00501, 35.07793], [-120.00497, 35.07795], [-120.00328, 35.07603], [-120.00298, 35.07573], [-120.00265, 35.07544], [-120.00207, 35.07499], [-120.0017, 35.07474], [-120.00119, 35.07444], [-119.99754, 35.07251], [-119.99713, 35.07232], [-119.99678, 35.07219], [-119.98576, 35.06856], [-119.98545, 35.06841], [-119.98513, 35.06821], [-119.98209, 35.06579], [-119.98171, 35.06556], [-119.98148, 35.06546], [-119.98117, 35.06536], [-119.97668, 35.06425], [-119.97628, 35.06412], [-119.97597, 35.06398], [-119.97167, 35.06165], [-119.97128, 35.06149], [-119.97087, 35.06137], [-119.97217, 35.05829], [-119.9747, 35.058], [-119.97726, 35.05921], [-119.97944, 35.05725], [-119.98068, 35.05796], [-119.97898, 35.05877], [-119.97938, 35.06072], [-119.97966, 35.0618], [-119.98324, 35.06098], [-119.98518, 35.06168], [-119.98706, 35.06489], [-119.98864, 35.0649], [-119.98957, 35.06346], [-119.99135, 35.06312], [-120.00038, 35.07285], [-120.00192, 35.07333], [-120.00559, 35.07172], [-120.00724, 35.07243], [-120.00976, 35.07533], [-120.01365, 35.07571], [-120.01416, 35.08144], [-120.01824, 35.08213]]], [[[-120.01779, 35.08305], [-120.0166, 35.08545], [-120.01522, 35.08605], [-120.0152, 35.08662], [-120.01434, 35.0881], [-120.01356, 35.0935], [-120.00519, 35.09141], [-120.00523, 35.10318], [-119.98731, 35.10298], [-119.98729, 35.10654], [-119.97833, 35.10652], [-119.97832, 35.10291], [-119.97359, 35.1029], [-119.97357, 35.09927], [-119.96881, 35.09925], [-119.96876, 35.08868], [-119.95951, 35.0885], [-119.95157, 35.08845], [-119.95156, 35.08366], [-119.95597, 35.08374], [-119.95596, 35.0795], [-119.96024, 35.08052], [-119.962, 35.07814], [-119.96192, 35.07765], [-119.96214, 35.07625], [-119.96542, 35.07335], [-119.97054, 35.06215], [-119.9708, 35.06153], [-119.9712, 35.06164], [-119.97156, 35.06179], [-119.97588, 35.06413], [-119.97627, 35.06429], [-119.97662, 35.0644], [-119.98115, 35.06553], [-119.9814, 35.06561], [-119.98161, 35.0657], [-119.98183, 35.06583], [-119.98198, 35.06594], [-119.98505, 35.06836], [-119.9853, 35.06853], [-119.98563, 35.06869], [-119.98592, 35.0688], [-119.9967, 35.07235], [-119.99704, 35.07247], [-119.99744, 35.07265], [-120.00072, 35.07438], [-120.00168, 35.07506], [-120.00221, 35.07532], [-120.00267, 35.0757], [-120.00317, 35.07619], [-120.00475, 35.07799], [-120.00495, 35.0782], [-120.00516, 35.07837], [-120.00538, 35.07854], [-120.00562, 35.07869], [-120.00588, 35.07881], [-120.00615, 35.07893], [-120.01338, 35.08157], [-120.01585, 35.08276], [-120.01693, 35.08312], [-120.01754, 35.08314], [-120.01754, 35.08305], [-120.01779, 35.08305]], [[-119.9952, 35.08891], [-119.9952, 35.08889], [-119.97833, 35.08487], [-119.97832, 35.09262], [-119.97355, 35.09259], [-119.97356, 35.09587], [-119.97832, 35.0959], [-119.97833, 35.09928], [-119.98281, 35.0993], [-119.98281, 35.10293], [-119.98729, 35.10298], [-119.98727, 35.09272], [-119.98727, 35.08885], [-119.9952, 35.08891]]], [[[-120.04112, 35.11963], [-120.03198, 35.1193], [-120.03254, 35.1046], [-120.04107, 35.10485], [-120.04112, 35.11963]]], [[[-120.02788, 35.12491], [-120.02346, 35.12491], [-120.02345, 35.12125], [-120.02787, 35.12125], [-120.02788, 35.12491]]], [[[-119.63819, 35.12007], [-119.63788, 35.12445], [-119.63673, 35.12369], [-119.63598, 35.12325], [-119.63513, 35.12262], [-119.63365, 35.12162], [-119.63272, 35.12097], [-119.63197, 35.12038], [-119.63135, 35.11985], [-119.63118, 35.11967], [-119.63819, 35.12007]]], [[[-119.63786, 35.12466], [-119.6374, 35.13102], [-119.63287, 35.13103], [-119.63354, 35.12361], [-119.62915, 35.12356], [-119.62946, 35.11957], [-119.6309, 35.11965], [-119.63117, 35.11993], [-119.63166, 35.12035], [-119.63202, 35.12065], [-119.63259, 35.12109], [-119.63352, 35.12175], [-119.63509, 35.12281], [-119.63579, 35.12333], [-119.6366, 35.12382], [-119.63786, 35.12466]]], [[[-119.9969, 35.13988], [-119.99213, 35.13988], [-119.99211, 35.13619], [-119.99688, 35.13619], [-119.9969, 35.13988]]], [[[-120.03681, 35.14771], [-120.02796, 35.14749], [-120.02794, 35.14361], [-120.02352, 35.14364], [-120.02351, 35.13966], [-120.03235, 35.13959], [-120.03237, 35.14356], [-120.03679, 35.14353], [-120.03681, 35.14771]]], [[[-120.05858, 35.14787], [-120.05319, 35.14786], [-120.05094, 35.14468], [-120.0498, 35.14391], [-120.04814, 35.14118], [-120.05399, 35.1411], [-120.05405, 35.1448], [-120.05846, 35.14478], [-120.05858, 35.14787]]], [[[-119.86801, 35.19038], [-119.86365, 35.19037], [-119.86363, 35.187], [-119.868, 35.18702], [-119.86801, 35.19038]]], [[[-119.77358, 35.20445], [-119.7733, 35.20414], [-119.77301, 35.20386], [-119.77227, 35.20319], [-119.77181, 35.20265], [-119.77137, 35.202], [-119.77096, 35.20149], [-119.77074, 35.20114], [-119.77035, 35.20035], [-119.76994, 35.19942], [-119.76979, 35.19918], [-119.76945, 35.19867], [-119.76871, 35.19784], [-119.7683, 35.19719], [-119.76797, 35.19677], [-119.76774, 35.19641], [-119.76745, 35.19602], [-119.76626, 35.19468], [-119.76591, 35.19424], [-119.76581, 35.19403], [-119.76579, 35.19391], [-119.76578, 35.19377], [-119.76579, 35.19365], [-119.76598, 35.1929], [-119.766, 35.19267], [-119.76594, 35.19227], [-119.76584, 35.19198], [-119.76569, 35.19171], [-119.76548, 35.19144], [-119.76536, 35.19132], [-119.76477, 35.19086], [-119.76457, 35.19066], [-119.76386, 35.18968], [-119.74168, 35.18959], [-119.74142, 35.18957], [-119.74114, 35.1895], [-119.74062, 35.18931], [-119.73987, 35.18912], [-119.73964, 35.18905], [-119.73932, 35.1889], [-119.73792, 35.18805], [-119.73771, 35.18799], [-119.73749, 35.18798], [-119.73735, 35.18801], [-119.73722, 35.18807], [-119.73697, 35.18825], [-119.73663, 35.18847], [-119.73622, 35.18881], [-119.73613, 35.18894], [-119.7361, 35.18905], [-119.7361, 35.18917], [-119.73622, 35.18948], [-119.73625, 35.18963], [-119.73621, 35.19002], [-119.73617, 35.19016], [-119.73609, 35.19031], [-119.73569, 35.19079], [-119.73562, 35.1909], [-119.73554, 35.19106], [-119.73544, 35.19151], [-119.73536, 35.19236], [-119.73514, 35.19313], [-119.73392, 35.19314], [-119.73404, 35.17759], [-119.74714, 35.17769], [-119.74709, 35.16395], [-119.75141, 35.16394], [-119.75143, 35.16756], [-119.75584, 35.16756], [-119.75582, 35.17503], [-119.76454, 35.17502], [-119.76454, 35.17878], [-119.76896, 35.1788], [-119.76897, 35.18245], [-119.77352, 35.18247], [-119.77358, 35.20445]]], [[[-119.7734, 35.20452], [-119.75565, 35.20436], [-119.75558, 35.21207], [-119.74715, 35.21199], [-119.74724, 35.20443], [-119.74723, 35.2006], [-119.73815, 35.20057], [-119.73832, 35.19311], [-119.73534, 35.19313], [-119.73556, 35.19238], [-119.7356, 35.19202], [-119.73564, 35.19157], [-119.73574, 35.1911], [-119.73579, 35.19097], [-119.73586, 35.19087], [-119.73628, 35.19037], [-119.73636, 35.19022], [-119.73641, 35.19004], [-119.73645, 35.18971], [-119.73645, 35.18958], [-119.7364, 35.1894], [-119.7363, 35.18916], [-119.7363, 35.1891], [-119.73631, 35.18902], [-119.73639, 35.18891], [-119.73664, 35.18868], [-119.73684, 35.18854], [-119.73707, 35.1884], [-119.73735, 35.18819], [-119.73747, 35.18815], [-119.73761, 35.18814], [-119.73773, 35.18816], [-119.73784, 35.1882], [-119.7392, 35.18903], [-119.73952, 35.18919], [-119.7398, 35.18928], [-119.74049, 35.18944], [-119.74091, 35.18961], [-119.74113, 35.18967], [-119.74137, 35.18973], [-119.74163, 35.18976], [-119.76375, 35.18984], [-119.76429, 35.19061], [-119.76443, 35.19079], [-119.76463, 35.19098], [-119.76521, 35.19144], [-119.76532, 35.19154], [-119.76552, 35.19179], [-119.76566, 35.19204], [-119.76575, 35.19231], [-119.76579, 35.19257], [-119.7658, 35.19273], [-119.76577, 35.19292], [-119.7656, 35.19362], [-119.76558, 35.19384], [-119.76559, 35.19398], [-119.76564, 35.19413], [-119.76575, 35.19434], [-119.76609, 35.19477], [-119.76728, 35.19611], [-119.76757, 35.19648], [-119.7678, 35.19685], [-119.76813, 35.19727], [-119.76854, 35.19793], [-119.76928, 35.19876], [-119.76973, 35.19945], [-119.77017, 35.20041], [-119.77058, 35.20125], [-119.77082, 35.20161], [-119.77126, 35.20217], [-119.77164, 35.20274], [-119.77192, 35.20308], [-119.77211, 35.20329], [-119.77286, 35.20397], [-119.7732, 35.2043], [-119.7734, 35.20452]]], [[[-120.04133, 35.17693], [-120.04156, 35.19146], [-120.0412, 35.20587], [-120.0412, 35.20954], [-120.02336, 35.20944], [-120.02334, 35.20595], [-120.00546, 35.20563], [-120.00546, 35.19845], [-119.99653, 35.19839], [-119.99655, 35.19097], [-119.98787, 35.19088], [-119.98783, 35.1874], [-119.98301, 35.18737], [-119.98301, 35.19088], [-119.97003, 35.19089], [-119.95196, 35.19078], [-119.95203, 35.1906], [-119.95258, 35.18965], [-119.95549, 35.18556], [-119.95679, 35.18359], [-119.95699, 35.18324], [-119.95719, 35.18278], [-119.95772, 35.18123], [-119.9579, 35.18089], [-119.95817, 35.18054], [-119.95835, 35.18036], [-119.95937, 35.17945], [-119.95959, 35.17928], [-119.95988, 35.17909], [-119.96018, 35.17892], [-119.9641, 35.17693], [-119.96428, 35.17682], [-119.96452, 35.17661], [-119.96487, 35.17615], [-119.96502, 35.1759], [-119.9651, 35.1757], [-119.96626, 35.17174], [-119.96636, 35.17131], [-119.96639, 35.17104], [-119.9664, 35.17076], [-119.9663, 35.16584], [-119.96625, 35.16507], [-119.96626, 35.16482], [-119.96644, 35.16382], [-119.96647, 35.16339], [-119.9665, 35.16329], [-119.96657, 35.16318], [-119.96685, 35.16291], [-119.96705, 35.16266], [-119.96715, 35.16249], [-119.96719, 35.16231], [-119.96712, 35.16135], [-119.96707, 35.16121], [-119.96694, 35.16097], [-119.96689, 35.16075], [-119.96684, 35.15986], [-119.96675, 35.15946], [-119.96671, 35.15847], [-119.96674, 35.15832], [-119.96679, 35.1582], [-119.96718, 35.15772], [-119.96724, 35.15758], [-119.96728, 35.15744], [-119.96726, 35.15692], [-119.96731, 35.15645], [-119.96731, 35.15627], [-119.96726, 35.1561], [-119.96701, 35.15558], [-119.96699, 35.15546], [-119.96705, 35.15522], [-119.96713, 35.15506], [-119.96727, 35.15481], [-119.96729, 35.15468], [-119.96727, 35.1546], [-119.96723, 35.15453], [-119.96689, 35.15419], [-119.96671, 35.15394], [-119.96662, 35.15378], [-119.96657, 35.1536], [-119.96651, 35.15318], [-119.96642, 35.15278], [-119.9664, 35.15262], [-119.96643, 35.1524], [-119.96658, 35.15187], [-119.96666, 35.15139], [-119.96675, 35.15118], [-119.96704, 35.15066], [-119.96707, 35.15054], [-119.96708, 35.15039], [-119.96704, 35.15018], [-119.96695, 35.15001], [-119.96685, 35.1499], [-119.96631, 35.14941], [-119.96621, 35.14925], [-119.96618, 35.14912], [-119.96619, 35.14902], [-119.96627, 35.14881], [-119.96629, 35.14869], [-119.96628, 35.14858], [-119.96622, 35.14837], [-119.96622, 35.14825], [-119.96624, 35.14814], [-119.96628, 35.14804], [-119.96637, 35.1479], [-119.96644, 35.14783], [-119.96652, 35.14781], [-119.96661, 35.14781], [-119.96689, 35.14786], [-119.96719, 35.14788], [-119.96746, 35.14797], [-119.96767, 35.14802], [-119.96785, 35.14803], [-119.96801, 35.14802], [-119.96817, 35.14799], [-119.96832, 35.14794], [-119.9694, 35.14741], [-119.96968, 35.14732], [-119.96995, 35.14729], [-119.97041, 35.14735], [-119.97092, 35.14733], [-119.97147, 35.14736], [-119.97162, 35.14734], [-119.97188, 35.14725], [-119.97202, 35.14723], [-119.97213, 35.14723], [-119.9724, 35.14729], [-119.97269, 35.14729], [-119.97292, 35.14725], [-119.9733, 35.14714], [-119.97357, 35.14703], [-119.97379, 35.14691], [-119.9737, 35.1468], [-119.97347, 35.14692], [-119.97326, 35.147], [-119.96977, 35.14696], [-119.96976, 35.14716], [-119.96957, 35.1472], [-119.96937, 35.14727], [-119.96825, 35.14782], [-119.96809, 35.14787], [-119.96796, 35.14789], [-119.96779, 35.1479], [-119.96763, 35.14787], [-119.96732, 35.14776], [-119.9672, 35.14774], [-119.96688, 35.14772], [-119.96661, 35.14767], [-119.96646, 35.14768], [-119.96633, 35.14773], [-119.96624, 35.14781], [-119.96615, 35.14794], [-119.96608, 35.14809], [-119.96605, 35.14822], [-119.96605, 35.14835], [-119.96612, 35.14868], [-119.9661, 35.14879], [-119.96603, 35.14897], [-119.96602, 35.14911], [-119.96605, 35.14927], [-119.96613, 35.14943], [-119.96621, 35.14952], [-119.96678, 35.15005], [-119.96688, 35.15021], [-119.96692, 35.15037], [-119.96691, 35.15049], [-119.96688, 35.15061], [-119.96658, 35.15114], [-119.96651, 35.15134], [-119.9664, 35.15195], [-119.96626, 35.15239], [-119.96624, 35.15263], [-119.96625, 35.15279], [-119.96635, 35.15318], [-119.9664, 35.15359], [-119.96646, 35.15381], [-119.96657, 35.15401], [-119.96668, 35.15417], [-119.96686, 35.15439], [-119.96708, 35.15458], [-119.96712, 35.15469], [-119.9671, 35.15478], [-119.967, 35.15495], [-119.9669, 35.15515], [-119.96685, 35.15534], [-119.96683, 35.15547], [-119.96685, 35.1556], [-119.96709, 35.15612], [-119.96714, 35.15632], [-119.96715, 35.15645], [-119.96711, 35.15669], [-119.96709, 35.15694], [-119.96711, 35.15745], [-119.96708, 35.15755], [-119.96703, 35.15766], [-119.9667, 35.15805], [-119.96663, 35.15816], [-119.96657, 35.15833], [-119.96654, 35.1585], [-119.96659, 35.15947], [-119.96667, 35.15986], [-119.96673, 35.16078], [-119.96678, 35.161], [-119.96691, 35.16126], [-119.96695, 35.16137], [-119.96702, 35.16233], [-119.96698, 35.16248], [-119.96687, 35.16264], [-119.96668, 35.16286], [-119.96642, 35.16311], [-119.96634, 35.16326], [-119.96631, 35.16336], [-119.96627, 35.16383], [-119.96609, 35.16477], [-119.96608, 35.16508], [-119.96613, 35.16584], [-119.96623, 35.17077], [-119.96622, 35.17106], [-119.96619, 35.17132], [-119.9661, 35.17171], [-119.96494, 35.17568], [-119.96486, 35.17586], [-119.96472, 35.17608], [-119.96437, 35.17654], [-119.96415, 35.17673], [-119.96401, 35.17682], [-119.96009, 35.1788], [-119.95974, 35.179], [-119.95944, 35.1792], [-119.95922, 35.17938], [-119.9582, 35.18029], [-119.95798, 35.18053], [-119.95773, 35.18086], [-119.95756, 35.18118], [-119.95702, 35.18278], [-119.95686, 35.18314], [-119.95667, 35.18348], [-119.95534, 35.18551], [-119.95245, 35.18956], [-119.95229, 35.18982], [-119.95188, 35.19054], [-119.95179, 35.19077], [-119.93446, 35.19071], [-119.9346, 35.2], [-119.92377, 35.19746], [-119.92361, 35.19746], [-119.92348, 35.19749], [-119.92101, 35.19831], [-119.92074, 35.19835], [-119.92048, 35.19832], [-119.92025, 35.19824], [-119.91605, 35.19608], [-119.91528, 35.19575], [-119.91472, 35.19544], [-119.91453, 35.19535], [-119.91408, 35.19523], [-119.91364, 35.19516], [-119.91328, 35.19513], [-119.9127, 35.19513], [-119.91245, 35.19511], [-119.91218, 35.19505], [-119.91181, 35.19492], [-119.91078, 35.19477], [-119.91046, 35.19476], [-119.9101, 35.1948], [-119.90975, 35.1949], [-119.90937, 35.19506], [-119.9092, 35.19511], [-119.90873, 35.1952], [-119.90824, 35.19527], [-119.90742, 35.19533], [-119.90626, 35.19535], [-119.90544, 35.19539], [-119.90482, 35.19545], [-119.90369, 35.1956], [-119.90285, 35.19566], [-119.902, 35.19567], [-119.90112, 35.19564], [-119.90095, 35.1956], [-119.90081, 35.19554], [-119.90071, 35.19547], [-119.90056, 35.19533], [-119.90042, 35.19528], [-119.90032, 35.19527], [-119.8997, 35.19531], [-119.89952, 35.19535], [-119.89841, 35.1957], [-119.89821, 35.19574], [-119.89803, 35.19576], [-119.89762, 35.19576], [-119.89726, 35.19577], [-119.8948, 35.19604], [-119.89411, 35.19616], [-119.89321, 35.1964], [-119.89281, 35.19647], [-119.88872, 35.19673], [-119.88748, 35.19676], [-119.88725, 35.1968], [-119.88707, 35.19687], [-119.88693, 35.19698], [-119.88653, 35.19738], [-119.88643, 35.19754], [-119.88637, 35.19772], [-119.88637, 35.19803], [-119.8864, 35.1983], [-119.88687, 35.2004], [-119.88687, 35.2006], [-119.88684, 35.20076], [-119.88644, 35.20165], [-119.88607, 35.20238], [-119.88545, 35.20345], [-119.88474, 35.20454], [-119.88469, 35.20466], [-119.88467, 35.20479], [-119.88468, 35.20493], [-119.8855, 35.20825], [-119.886, 35.21015], [-119.88606, 35.21049], [-119.88614, 35.21083], [-119.88633, 35.21157], [-119.88634, 35.21178], [-119.88641, 35.21206], [-119.88668, 35.21313], [-119.88677, 35.21338], [-119.88354, 35.2122], [-119.88315, 35.21209], [-119.8828, 35.21201], [-119.88238, 35.21197], [-119.88106, 35.21196], [-119.88107, 35.20472], [-119.88128, 35.19108], [-119.88206, 35.19108], [-119.88207, 35.19044], [-119.8902, 35.19041], [-119.89027, 35.18323], [-119.89891, 35.18328], [-119.89898, 35.17596], [-119.89924, 35.1613], [-119.89894, 35.14648], [-119.88986, 35.14656], [-119.88987, 35.13937], [-119.88102, 35.13935], [-119.88098, 35.13207], [-119.87187, 35.13212], [-119.87183, 35.12527], [-119.88094, 35.12522], [-119.88091, 35.11734], [-119.89916, 35.11737], [-119.89908, 35.10264], [-119.88083, 35.10263], [-119.88075, 35.08757], [-119.89398, 35.08773], [-119.89379, 35.07965], [-119.88933, 35.07968], [-119.88928, 35.07595], [-119.89364, 35.07589], [-119.89351, 35.07235], [-119.88923, 35.07243], [-119.88913, 35.06605], [-119.89761, 35.06589], [-119.89759, 35.06562], [-119.8938, 35.06473], [-119.89497, 35.04442], [-119.89652, 35.04495], [-119.89702, 35.04515], [-119.89782, 35.04553], [-119.89858, 35.04596], [-119.8993, 35.04644], [-119.90431, 35.05029], [-119.90496, 35.05073], [-119.90576, 35.05118], [-119.90644, 35.0515], [-119.90713, 35.05178], [-119.9125, 35.05365], [-119.91323, 35.05395], [-119.91366, 35.05417], [-119.92206, 35.05872], [-119.92524, 35.0603], [-119.92561, 35.06046], [-119.92606, 35.06056], [-119.92648, 35.06059], [-119.92882, 35.06054], [-119.92906, 35.06052], [-119.92935, 35.06048], [-119.92971, 35.06038], [-119.92998, 35.06028], [-119.9334, 35.05874], [-119.93382, 35.05856], [-119.93387, 35.05863], [-119.9342, 35.05852], [-119.93458, 35.05842], [-119.93527, 35.05828], [-119.93588, 35.05823], [-119.93638, 35.05822], [-119.93689, 35.05825], [-119.93739, 35.05831], [-119.9388, 35.05862], [-119.93883, 35.05854], [-119.94931, 35.06091], [-119.94891, 35.06435], [-119.94888, 35.06621], [-119.94683, 35.06761], [-119.94394, 35.07144], [-119.94007, 35.07305], [-119.93918, 35.07393], [-119.93713, 35.07497], [-119.93714, 35.07498], [-119.94272, 35.07632], [-119.94274, 35.07981], [-119.93394, 35.07986], [-119.93395, 35.08342], [-119.92504, 35.0834], [-119.92504, 35.09229], [-119.92955, 35.09232], [-119.92957, 35.09909], [-119.94281, 35.09915], [-119.94283, 35.10279], [-119.94723, 35.10281], [-119.94725, 35.10646], [-119.95164, 35.10646], [-119.95163, 35.10283], [-119.96051, 35.10286], [-119.96052, 35.10648], [-119.95607, 35.10648], [-119.95606, 35.10649], [-119.95609, 35.11376], [-119.96053, 35.11378], [-119.96053, 35.11745], [-119.95611, 35.11739], [-119.95614, 35.1247], [-119.95173, 35.1247], [-119.95171, 35.12106], [-119.94732, 35.12105], [-119.94731, 35.12106], [-119.94733, 35.1247], [-119.93852, 35.1247], [-119.9385, 35.12105], [-119.9341, 35.12105], [-119.93408, 35.11739], [-119.9296, 35.11739], [-119.92962, 35.12836], [-119.93414, 35.12836], [-119.93417, 35.13205], [-119.95177, 35.13211], [-119.95186, 35.13583], [-119.96056, 35.13593], [-119.96057, 35.14329], [-119.97385, 35.14339], [-119.97386, 35.1507], [-119.97835, 35.15074], [-119.97836, 35.15438], [-119.98771, 35.15445], [-119.98788, 35.16173], [-119.98775, 35.17644], [-120.00546, 35.17637], [-120.02363, 35.17689], [-120.02805, 35.1769], [-120.02803, 35.16947], [-120.02361, 35.16945], [-120.0236, 35.16573], [-120.03245, 35.16577], [-120.03249, 35.17691], [-120.04133, 35.17693]], [[-119.93416, 35.13206], [-119.92509, 35.13199], [-119.92509, 35.13573], [-119.92963, 35.13574], [-119.92964, 35.13942], [-119.93422, 35.13942], [-119.93416, 35.13206]], [[-119.93407, 35.11373], [-119.94286, 35.11375], [-119.94286, 35.11011], [-119.93406, 35.11008], [-119.93407, 35.11373]], [[-119.90907, 35.08792], [-119.90902, 35.08367], [-119.9002, 35.08387], [-119.9002, 35.0878], [-119.90336, 35.08785], [-119.90336, 35.09164], [-119.91217, 35.09168], [-119.91217, 35.08796], [-119.90907, 35.08792]]], [[[-119.898, 35.21951], [-119.88106, 35.21955], [-119.88106, 35.21213], [-119.88242, 35.21214], [-119.88281, 35.21219], [-119.88325, 35.21229], [-119.89579, 35.21684], [-119.89613, 35.21701], [-119.89644, 35.21721], [-119.89672, 35.21744], [-119.89696, 35.2177], [-119.89721, 35.21806], [-119.898, 35.21951]]], [[[-119.95222, 35.21933], [-119.9521, 35.21956], [-119.95202, 35.21975], [-119.95196, 35.21997], [-119.95194, 35.22017], [-119.95196, 35.22962], [-119.95195, 35.2298], [-119.95175, 35.23113], [-119.95165, 35.23445], [-119.93442, 35.23439], [-119.93451, 35.21977], [-119.91653, 35.21963], [-119.89822, 35.21951], [-119.89739, 35.21799], [-119.89719, 35.21769], [-119.89698, 35.21745], [-119.89674, 35.21722], [-119.89648, 35.21702], [-119.89619, 35.21684], [-119.89588, 35.21669], [-119.89566, 35.2166], [-119.88699, 35.21346], [-119.88685, 35.21312], [-119.88667, 35.21245], [-119.88652, 35.21181], [-119.8865, 35.21153], [-119.88631, 35.21081], [-119.88623, 35.21047], [-119.88617, 35.21012], [-119.88565, 35.2082], [-119.88484, 35.20482], [-119.88485, 35.20472], [-119.88489, 35.2046], [-119.88563, 35.20347], [-119.88625, 35.20239], [-119.88679, 35.20128], [-119.88696, 35.20091], [-119.88702, 35.20075], [-119.88704, 35.20053], [-119.88703, 35.20034], [-119.88655, 35.19818], [-119.88653, 35.19785], [-119.88656, 35.19765], [-119.88666, 35.19748], [-119.88705, 35.19707], [-119.88722, 35.19696], [-119.88742, 35.1969], [-119.88873, 35.19687], [-119.89281, 35.19661], [-119.89324, 35.19653], [-119.89411, 35.1963], [-119.89479, 35.19618], [-119.8973, 35.19591], [-119.89764, 35.19589], [-119.89801, 35.1959], [-119.89823, 35.19588], [-119.89842, 35.19584], [-119.89958, 35.19548], [-119.89971, 35.19545], [-119.90039, 35.19541], [-119.90045, 35.19544], [-119.90059, 35.19557], [-119.90077, 35.19568], [-119.90091, 35.19573], [-119.90113, 35.19577], [-119.90211, 35.19581], [-119.90296, 35.19579], [-119.90381, 35.19573], [-119.90494, 35.19558], [-119.90554, 35.19552], [-119.90615, 35.19549], [-119.90735, 35.19547], [-119.90819, 35.19541], [-119.90869, 35.19534], [-119.90926, 35.19524], [-119.90947, 35.19517], [-119.90979, 35.19503], [-119.9101, 35.19494], [-119.91047, 35.1949], [-119.9108, 35.19491], [-119.91177, 35.19506], [-119.91215, 35.19518], [-119.91245, 35.19525], [-119.91272, 35.19527], [-119.91323, 35.19527], [-119.91358, 35.19529], [-119.914, 35.19536], [-119.91445, 35.19547], [-119.91458, 35.19553], [-119.91517, 35.19586], [-119.91592, 35.19618], [-119.92018, 35.19836], [-119.92046, 35.19846], [-119.92076, 35.19848], [-119.92104, 35.19844], [-119.92352, 35.19762], [-119.92362, 35.1976], [-119.92374, 35.1976], [-119.93453, 35.20012], [-119.93461, 35.20016], [-119.93469, 35.20522], [-119.95194, 35.20535], [-119.95209, 35.21077], [-119.95207, 35.21348], [-119.95209, 35.21366], [-119.9522, 35.21413], [-119.95222, 35.21933]]]]}	Open Access 1	4868	Carrizo Plains Ecological Reserve	32106	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/Carrizo-Plains-ER	San Luis Obispo 1	38876.762	Carrizo Plains ER	1993	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]);