calands: units_with_maps: 2 rows where ACCESS_TYP = 1, DES_TP = 15, MNG_AGENCY = 47 and UNIT

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

2 rows where ACCESS_TYP = 1, DES_TP = 15, MNG_AGENCY = 47 and UNIT_NAME = "Emerald Bay State Park"

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
16594	16594	16593	{"type": "MultiPolygon", "coordinates": [[[[-120.11123, 38.95078], [-120.11122, 38.95411], [-120.11094, 38.95439], [-120.11033, 38.95475], [-120.1101, 38.95493], [-120.10987, 38.95525], [-120.10972, 38.95562], [-120.10926, 38.9563], [-120.1087, 38.9568], [-120.10769, 38.95759], [-120.10724, 38.95777], [-120.10604, 38.95815], [-120.10549, 38.95837], [-120.10226, 38.95843], [-120.10228, 38.96101], [-120.10208, 38.9612], [-120.10178, 38.96144], [-120.10145, 38.96163], [-120.10093, 38.96197], [-120.09796, 38.96197], [-120.09798, 38.96568], [-120.0937, 38.96566], [-120.09332, 38.96568], [-120.08929, 38.96887], [-120.08892, 38.96908], [-120.08875, 38.96916], [-120.08861, 38.96917], [-120.08845, 38.96912], [-120.0882, 38.969], [-120.08797, 38.96885], [-120.08788, 38.96878], [-120.08781, 38.96867], [-120.08783, 38.96852], [-120.08787, 38.96847], [-120.08786, 38.96835], [-120.08784, 38.96828], [-120.08777, 38.96825], [-120.08761, 38.9682], [-120.08681, 38.96816], [-120.08657, 38.96809], [-120.08614, 38.96791], [-120.08582, 38.96782], [-120.08532, 38.96773], [-120.08492, 38.9676], [-120.08467, 38.96751], [-120.08429, 38.96733], [-120.08408, 38.96718], [-120.08389, 38.96691], [-120.08386, 38.96675], [-120.08382, 38.96643], [-120.08382, 38.96609], [-120.08379, 38.96588], [-120.08369, 38.96573], [-120.08367, 38.96561], [-120.0837, 38.96557], [-120.08382, 38.96556], [-120.08394, 38.96558], [-120.08446, 38.96574], [-120.08467, 38.96576], [-120.08532, 38.96577], [-120.08541, 38.96574], [-120.08547, 38.96572], [-120.08557, 38.96561], [-120.08564, 38.9654], [-120.08565, 38.96517], [-120.08568, 38.96509], [-120.08596, 38.96493], [-120.08604, 38.96484], [-120.08619, 38.96477], [-120.08661, 38.96476], [-120.08703, 38.96471], [-120.0875, 38.96469], [-120.08773, 38.96466], [-120.08827, 38.96465], [-120.08889, 38.96473], [-120.08912, 38.96482], [-120.08931, 38.96492], [-120.08945, 38.96497], [-120.08959, 38.96498], [-120.08971, 38.96495], [-120.09009, 38.96478], [-120.09022, 38.96487], [-120.09056, 38.96486], [-120.09074, 38.96483], [-120.09083, 38.96476], [-120.09131, 38.96422], [-120.09199, 38.96374], [-120.09213, 38.9636], [-120.09276, 38.96323], [-120.09325, 38.96283], [-120.09339, 38.9627], [-120.09386, 38.96213], [-120.09392, 38.96208], [-120.09403, 38.96192], [-120.09421, 38.96159], [-120.09467, 38.96105], [-120.09519, 38.96059], [-120.09583, 38.95998], [-120.0965, 38.95962], [-120.09669, 38.95948], [-120.0971, 38.95929], [-120.0975, 38.95907], [-120.09818, 38.95862], [-120.09869, 38.95842], [-120.09871, 38.9584], [-120.09872, 38.95834], [-120.09878, 38.95828], [-120.0989, 38.95827], [-120.09906, 38.95829], [-120.10008, 38.95796], [-120.10045, 38.95794], [-120.10086, 38.95786], [-120.10139, 38.95765], [-120.1014, 38.95763], [-120.10205, 38.95721], [-120.10248, 38.95698], [-120.10311, 38.95672], [-120.10326, 38.95658], [-120.10332, 38.95648], [-120.10333, 38.95634], [-120.10327, 38.95618], [-120.1032, 38.9561], [-120.10318, 38.95592], [-120.10324, 38.95579], [-120.10345, 38.95576], [-120.10417, 38.95581], [-120.10439, 38.95573], [-120.10461, 38.95552], [-120.10471, 38.95546], [-120.10521, 38.95532], [-120.10536, 38.95526], [-120.10561, 38.95509], [-120.10581, 38.9548], [-120.10594, 38.9545], [-120.10606, 38.954], [-120.10616, 38.95387], [-120.10646, 38.95364], [-120.10651, 38.95358], [-120.1066, 38.95341], [-120.10665, 38.95324], [-120.10665, 38.95308], [-120.10663, 38.95298], [-120.10656, 38.95281], [-120.1065, 38.95276], [-120.1065, 38.95273], [-120.10627, 38.95238], [-120.10619, 38.95229], [-120.10604, 38.95206], [-120.10599, 38.95202], [-120.10598, 38.95198], [-120.10578, 38.95178], [-120.10578, 38.95175], [-120.10569, 38.95166], [-120.10563, 38.95154], [-120.10557, 38.95148], [-120.10556, 38.95135], [-120.10559, 38.95129], [-120.10589, 38.95125], [-120.10594, 38.95129], [-120.10595, 38.95134], [-120.10591, 38.95155], [-120.10595, 38.95164], [-120.10612, 38.95173], [-120.10625, 38.95182], [-120.10636, 38.95184], [-120.10638, 38.95182], [-120.10637, 38.9518], [-120.10624, 38.95169], [-120.10615, 38.95157], [-120.10608, 38.95132], [-120.10607, 38.95119], [-120.10621, 38.95094], [-120.10619, 38.95089], [-120.10586, 38.9509], [-120.10577, 38.95088], [-120.10571, 38.95082], [-120.10565, 38.95072], [-120.10561, 38.9507], [-120.10551, 38.95058], [-120.10541, 38.95037], [-120.10519, 38.9501], [-120.10519, 38.95008], [-120.1051, 38.95], [-120.10497, 38.9498], [-120.10492, 38.94969], [-120.10478, 38.94953], [-120.10463, 38.94942], [-120.10438, 38.94931], [-120.10401, 38.94922], [-120.10356, 38.94916], [-120.10331, 38.94918], [-120.10274, 38.94939], [-120.10265, 38.94943], [-120.10226, 38.94951], [-120.10205, 38.94948], [-120.10186, 38.94937], [-120.10134, 38.94915], [-120.10087, 38.94893], [-120.10054, 38.94895], [-120.10037, 38.949], [-120.10011, 38.94902], [-120.09991, 38.94906], [-120.09982, 38.94911], [-120.09926, 38.94925], [-120.09901, 38.94923], [-120.09881, 38.94924], [-120.09857, 38.94939], [-120.09798, 38.94962], [-120.09763, 38.94978], [-120.09716, 38.95003], [-120.09663, 38.95023], [-120.09646, 38.95034], [-120.09622, 38.95044], [-120.09578, 38.95059], [-120.09537, 38.95063], [-120.09517, 38.95069], [-120.09446, 38.95107], [-120.0942, 38.95117], [-120.09334, 38.95126], [-120.09298, 38.95135], [-120.09278, 38.95145], [-120.09222, 38.95185], [-120.0919, 38.95207], [-120.09145, 38.95242], [-120.09129, 38.95258], [-120.09032, 38.95335], [-120.09024, 38.95344], [-120.08992, 38.95373], [-120.08949, 38.9542], [-120.08927, 38.95453], [-120.08872, 38.95513], [-120.08872, 38.95519], [-120.08834, 38.95572], [-120.08815, 38.95608], [-120.08773, 38.95672], [-120.08767, 38.95678], [-120.08766, 38.95681], [-120.0874, 38.95722], [-120.08729, 38.95734], [-120.08707, 38.95765], [-120.08684, 38.95802], [-120.08616, 38.95871], [-120.08587, 38.95896], [-120.08573, 38.95904], [-120.08551, 38.95912], [-120.08525, 38.95918], [-120.08507, 38.95924], [-120.0849, 38.95936], [-120.08425, 38.96017], [-120.08417, 38.96062], [-120.08405, 38.96085], [-120.08398, 38.96094], [-120.08387, 38.96105], [-120.08375, 38.96112], [-120.08337, 38.96118], [-120.08317, 38.9613], [-120.08304, 38.96151], [-120.08289, 38.96172], [-120.08245, 38.96219], [-120.08236, 38.96233], [-120.08179, 38.963], [-120.08165, 38.96346], [-120.08148, 38.9637], [-120.08133, 38.96397], [-120.08117, 38.96415], [-120.08108, 38.96432], [-120.08103, 38.96455], [-120.08081, 38.96496], [-120.08072, 38.96504], [-120.08052, 38.9651], [-120.08018, 38.96515], [-120.07987, 38.96526], [-120.07947, 38.96548], [-120.07936, 38.96551], [-120.07922, 38.96552], [-120.07903, 38.96547], [-120.07893, 38.96542], [-120.0787, 38.9652], [-120.07863, 38.96499], [-120.07856, 38.96489], [-120.07854, 38.9648], [-120.07855, 38.96441], [-120.07852, 38.96429], [-120.07853, 38.96423], [-120.07849, 38.96411], [-120.07848, 38.964], [-120.07846, 38.96398], [-120.07842, 38.96348], [-120.0784, 38.96345], [-120.07837, 38.96324], [-120.0783, 38.96291], [-120.07831, 38.96255], [-120.07828, 38.96253], [-120.07827, 38.96238], [-120.07824, 38.96237], [-120.07824, 38.96223], [-120.07822, 38.96219], [-120.07818, 38.96194], [-120.07816, 38.96191], [-120.07807, 38.96131], [-120.07801, 38.96116], [-120.07795, 38.96078], [-120.07792, 38.96075], [-120.07793, 38.96049], [-120.07796, 38.96034], [-120.07797, 38.95987], [-120.07799, 38.95982], [-120.07801, 38.95947], [-120.07803, 38.95945], [-120.07804, 38.95937], [-120.07808, 38.95922], [-120.07808, 38.95893], [-120.07802, 38.95844], [-120.07801, 38.95819], [-120.07795, 38.95793], [-120.07792, 38.95788], [-120.07792, 38.95779], [-120.07784, 38.95743], [-120.07782, 38.95729], [-120.07783, 38.95691], [-120.07788, 38.95675], [-120.07791, 38.95635], [-120.07795, 38.95623], [-120.07799, 38.95619], [-120.07801, 38.95609], [-120.07803, 38.95607], [-120.07824, 38.95526], [-120.07829, 38.95461], [-120.07828, 38.95409], [-120.07817, 38.95377], [-120.07814, 38.95372], [-120.07811, 38.95344], [-120.08426, 38.95142], [-120.08429, 38.95148], [-120.08434, 38.95152], [-120.0846, 38.95153], [-120.08499, 38.95149], [-120.08637, 38.95111], [-120.08667, 38.95104], [-120.08762, 38.95094], [-120.08785, 38.95095], [-120.08788, 38.95106], [-120.0878, 38.95123], [-120.08769, 38.95137], [-120.08767, 38.95149], [-120.08771, 38.95152], [-120.08782, 38.95154], [-120.08816, 38.95143], [-120.08871, 38.95102], [-120.08962, 38.95047], [-120.09025, 38.94995], [-120.09095, 38.94961], [-120.09134, 38.94937], [-120.09176, 38.94915], [-120.09211, 38.94893], [-120.09309, 38.9485], [-120.09358, 38.94832], [-120.09443, 38.94786], [-120.09784, 38.94773], [-120.1073, 38.94752], [-120.10838, 38.94803], [-120.10888, 38.94834], [-120.10908, 38.94857], [-120.10927, 38.94888], [-120.10938, 38.94899], [-120.10955, 38.94915], [-120.11005, 38.94946], [-120.11056, 38.94998], [-120.11123, 38.95078]]], [[[-120.10148, 38.9535], [-120.10149, 38.95359], [-120.10143, 38.95381], [-120.10127, 38.95412], [-120.10105, 38.95422], [-120.10093, 38.95432], [-120.10074, 38.95441], [-120.10051, 38.95448], [-120.10028, 38.95453], [-120.10012, 38.95447], [-120.09997, 38.95436], [-120.09993, 38.95418], [-120.1, 38.95398], [-120.10027, 38.95371], [-120.10039, 38.9537], [-120.10063, 38.95375], [-120.10073, 38.95373], [-120.10083, 38.95362], [-120.10085, 38.95355], [-120.10107, 38.95359], [-120.10114, 38.95343], [-120.10125, 38.95333], [-120.10137, 38.95338], [-120.10148, 38.9535]]]]}	Open Access 1	20473	Emerald Bay State Park	1951	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=506	El Dorado 34	623.814	Emerald Bay SP	1953	State Park 15	4
16625	16625	16624	{"type": "Polygon", "coordinates": [[[-120.1065, 38.95273], [-120.10651, 38.95276], [-120.10656, 38.95281], [-120.10663, 38.95298], [-120.10665, 38.95308], [-120.10665, 38.95325], [-120.10661, 38.95341], [-120.10651, 38.95357], [-120.10646, 38.95364], [-120.10616, 38.95387], [-120.10606, 38.954], [-120.10594, 38.9545], [-120.10581, 38.9548], [-120.10561, 38.95509], [-120.10536, 38.95526], [-120.10521, 38.95532], [-120.10471, 38.95546], [-120.10461, 38.95552], [-120.10439, 38.95573], [-120.10417, 38.95581], [-120.10345, 38.95576], [-120.10324, 38.95579], [-120.10318, 38.95592], [-120.1032, 38.95609], [-120.10327, 38.95618], [-120.10334, 38.95634], [-120.10332, 38.95649], [-120.10326, 38.95658], [-120.10311, 38.95672], [-120.10248, 38.95698], [-120.10205, 38.95721], [-120.1014, 38.95763], [-120.10139, 38.95765], [-120.10086, 38.95786], [-120.10045, 38.95794], [-120.10007, 38.95796], [-120.09906, 38.95829], [-120.0989, 38.95827], [-120.09878, 38.95828], [-120.09872, 38.95834], [-120.09871, 38.9584], [-120.09869, 38.95842], [-120.09818, 38.95862], [-120.0975, 38.95907], [-120.0971, 38.95929], [-120.09669, 38.95948], [-120.0965, 38.95962], [-120.09583, 38.95998], [-120.09519, 38.96059], [-120.09467, 38.96105], [-120.09421, 38.96159], [-120.09403, 38.96192], [-120.09392, 38.96208], [-120.09386, 38.96213], [-120.09339, 38.9627], [-120.09325, 38.96283], [-120.09276, 38.96323], [-120.09213, 38.9636], [-120.09199, 38.96374], [-120.09131, 38.96422], [-120.09083, 38.96476], [-120.09074, 38.96483], [-120.09056, 38.96486], [-120.09022, 38.96487], [-120.09008, 38.96478], [-120.08971, 38.96495], [-120.0896, 38.96498], [-120.08945, 38.96496], [-120.08931, 38.96492], [-120.08912, 38.96482], [-120.08889, 38.96473], [-120.08827, 38.96465], [-120.08773, 38.96466], [-120.0875, 38.96469], [-120.08703, 38.96471], [-120.08661, 38.96476], [-120.08619, 38.96477], [-120.08604, 38.96484], [-120.08596, 38.96493], [-120.08568, 38.96509], [-120.08565, 38.96517], [-120.08564, 38.9654], [-120.08557, 38.96561], [-120.08547, 38.96572], [-120.08541, 38.96574], [-120.08532, 38.96577], [-120.08467, 38.96576], [-120.08446, 38.96574], [-120.08394, 38.96558], [-120.08382, 38.96556], [-120.0837, 38.96558], [-120.08367, 38.96562], [-120.08369, 38.96573], [-120.08379, 38.96588], [-120.08382, 38.96605], [-120.08382, 38.96643], [-120.08386, 38.96675], [-120.08389, 38.96691], [-120.08408, 38.96718], [-120.08429, 38.96733], [-120.08467, 38.96751], [-120.08492, 38.9676], [-120.08532, 38.96773], [-120.08582, 38.96782], [-120.08614, 38.96791], [-120.08657, 38.96809], [-120.08681, 38.96816], [-120.08761, 38.9682], [-120.08777, 38.96825], [-120.08784, 38.96828], [-120.08786, 38.96835], [-120.08787, 38.96847], [-120.08783, 38.96852], [-120.08781, 38.96867], [-120.08788, 38.96878], [-120.08797, 38.96885], [-120.0882, 38.969], [-120.08845, 38.96912], [-120.0886, 38.96917], [-120.08875, 38.96916], [-120.08892, 38.96908], [-120.08924, 38.96889], [-120.08937, 38.96884], [-120.08402, 38.97336], [-120.0741, 38.96542], [-120.0746, 38.95335], [-120.07811, 38.95344], [-120.07814, 38.95372], [-120.07828, 38.95409], [-120.07829, 38.95461], [-120.07824, 38.95526], [-120.07803, 38.95608], [-120.07801, 38.95609], [-120.07799, 38.95619], [-120.07795, 38.95623], [-120.07791, 38.95635], [-120.07788, 38.95675], [-120.07783, 38.95692], [-120.07782, 38.95729], [-120.07784, 38.95743], [-120.07792, 38.95779], [-120.07792, 38.95788], [-120.07795, 38.95793], [-120.07801, 38.95819], [-120.07802, 38.95844], [-120.07808, 38.95893], [-120.07808, 38.95922], [-120.07804, 38.95937], [-120.07804, 38.95945], [-120.07801, 38.95948], [-120.07799, 38.95982], [-120.07797, 38.95987], [-120.07796, 38.96034], [-120.07793, 38.96049], [-120.07792, 38.96075], [-120.07794, 38.96077], [-120.07801, 38.96116], [-120.07807, 38.96131], [-120.07816, 38.96191], [-120.07818, 38.96194], [-120.07822, 38.96219], [-120.07824, 38.96223], [-120.07824, 38.96236], [-120.07827, 38.96237], [-120.07828, 38.96253], [-120.07831, 38.96255], [-120.0783, 38.96291], [-120.07837, 38.96324], [-120.0784, 38.96345], [-120.07842, 38.96347], [-120.07846, 38.96398], [-120.07848, 38.964], [-120.07849, 38.96411], [-120.07853, 38.96424], [-120.07852, 38.96429], [-120.07855, 38.9644], [-120.07854, 38.9648], [-120.07856, 38.96489], [-120.07863, 38.96499], [-120.0787, 38.9652], [-120.07893, 38.96542], [-120.07903, 38.96548], [-120.07922, 38.96552], [-120.07936, 38.96551], [-120.07947, 38.96548], [-120.07986, 38.96526], [-120.08018, 38.96515], [-120.08052, 38.9651], [-120.08071, 38.96503], [-120.08081, 38.96496], [-120.08103, 38.96455], [-120.08108, 38.96432], [-120.08117, 38.96415], [-120.08133, 38.96397], [-120.08148, 38.9637], [-120.08165, 38.96346], [-120.08179, 38.963], [-120.08236, 38.96233], [-120.08245, 38.96219], [-120.08289, 38.96172], [-120.08304, 38.96151], [-120.08317, 38.9613], [-120.08337, 38.96118], [-120.08375, 38.96112], [-120.08387, 38.96105], [-120.08398, 38.96094], [-120.08405, 38.96085], [-120.08417, 38.96062], [-120.08425, 38.96017], [-120.0849, 38.95937], [-120.08507, 38.95924], [-120.08525, 38.95918], [-120.08551, 38.95912], [-120.08573, 38.95904], [-120.08587, 38.95896], [-120.08616, 38.95871], [-120.08684, 38.95802], [-120.08707, 38.95765], [-120.08729, 38.95734], [-120.0874, 38.95722], [-120.08766, 38.95681], [-120.08767, 38.95678], [-120.08773, 38.95672], [-120.08815, 38.95608], [-120.08834, 38.95572], [-120.08872, 38.95519], [-120.08872, 38.95514], [-120.08927, 38.95453], [-120.08949, 38.95421], [-120.08972, 38.95395], [-120.09032, 38.95335], [-120.09129, 38.95258], [-120.09145, 38.95242], [-120.0919, 38.95207], [-120.09222, 38.95185], [-120.09252, 38.95162], [-120.09278, 38.95144], [-120.09298, 38.95135], [-120.09334, 38.95126], [-120.0942, 38.95117], [-120.09446, 38.95107], [-120.09517, 38.95069], [-120.09537, 38.95063], [-120.09578, 38.95059], [-120.09595, 38.95054], [-120.09646, 38.95034], [-120.09663, 38.95023], [-120.09716, 38.95003], [-120.09763, 38.94978], [-120.09798, 38.94962], [-120.09857, 38.94939], [-120.09881, 38.94924], [-120.09901, 38.94923], [-120.09926, 38.94925], [-120.09982, 38.94911], [-120.09991, 38.94906], [-120.10011, 38.94902], [-120.10037, 38.949], [-120.10054, 38.94895], [-120.10087, 38.94893], [-120.10134, 38.94915], [-120.10186, 38.94937], [-120.10205, 38.94948], [-120.10226, 38.94951], [-120.10265, 38.94943], [-120.10274, 38.94939], [-120.10331, 38.94918], [-120.10357, 38.94916], [-120.10401, 38.94922], [-120.10424, 38.94927], [-120.10438, 38.94931], [-120.10463, 38.94942], [-120.10478, 38.94953], [-120.10492, 38.94969], [-120.10497, 38.9498], [-120.1051, 38.95], [-120.10519, 38.95008], [-120.10519, 38.9501], [-120.10542, 38.95037], [-120.10551, 38.95058], [-120.10561, 38.9507], [-120.10565, 38.95072], [-120.10571, 38.95082], [-120.10577, 38.95088], [-120.10586, 38.9509], [-120.10619, 38.95089], [-120.10621, 38.95094], [-120.10607, 38.95119], [-120.10608, 38.95131], [-120.10615, 38.95156], [-120.10624, 38.95169], [-120.10637, 38.9518], [-120.10638, 38.95182], [-120.10636, 38.95184], [-120.10625, 38.95182], [-120.10612, 38.95173], [-120.10595, 38.95164], [-120.10591, 38.95155], [-120.10595, 38.95133], [-120.10593, 38.95129], [-120.10589, 38.95125], [-120.10559, 38.95129], [-120.10556, 38.95135], [-120.10557, 38.95148], [-120.10563, 38.95154], [-120.10569, 38.95166], [-120.10578, 38.95175], [-120.10578, 38.95178], [-120.10598, 38.95198], [-120.10599, 38.95202], [-120.10604, 38.95206], [-120.10608, 38.95214], [-120.10627, 38.95238], [-120.1065, 38.95273]], [[-120.10126, 38.95333], [-120.10114, 38.95343], [-120.10107, 38.95359], [-120.10086, 38.95355], [-120.10083, 38.95362], [-120.10073, 38.95373], [-120.10063, 38.95375], [-120.10039, 38.9537], [-120.10027, 38.95371], [-120.1, 38.95398], [-120.09993, 38.95418], [-120.09998, 38.95436], [-120.10012, 38.95447], [-120.10028, 38.95453], [-120.10051, 38.95448], [-120.10074, 38.95441], [-120.10093, 38.95432], [-120.10105, 38.95422], [-120.10127, 38.95412], [-120.10143, 38.95381], [-120.10149, 38.95359], [-120.10148, 38.9535], [-120.10137, 38.95338], [-120.10126, 38.95333]]]}	Open Access 1	44443	Emerald Bay State Park	1951	209	California State Lands Commission 75	State 5	State Agency 5	http://www.slc.ca.gov/	Other State 5	204	California Department of Parks and Recreation 47	State 5	State Agency 5	http://www.parks.ca.gov/?page_id=506	El Dorado 34	716.025	Emerald Bay SP	1953	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]);