calands: units_with_maps: 21 rows where DES_TP = 104, MNG_AGENCY = 279 and MNG_AG

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

21 rows where DES_TP = 104, MNG_AGENCY = 279 and MNG_AG_LEV = 5

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
1157	1157	1156	{"type": "Polygon", "coordinates": [[[-116.91384, 32.82128], [-116.9136, 32.82217], [-116.91351, 32.82247], [-116.91325, 32.82312], [-116.91306, 32.82352], [-116.91285, 32.82388], [-116.91253, 32.82436], [-116.91234, 32.8246], [-116.91137, 32.82546], [-116.91041, 32.8248], [-116.9096, 32.82296], [-116.90946, 32.82252], [-116.90948, 32.82219], [-116.91047, 32.82103], [-116.91059, 32.82076], [-116.91384, 32.82128]]]}	Open Access 1	7356	CalTrans TransNet Environmental Mitigation	16740	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	33.902	CalTrans TransNet Environmental Mitigation	State Other or Unknown 104	4
3742	3742	3741	{"type": "Polygon", "coordinates": [[[-117.25665, 33.25608], [-117.25376, 33.25609], [-117.24955, 33.25549], [-117.24981, 33.25449], [-117.25017, 33.25456], [-117.25354, 33.25499], [-117.25356, 33.25494], [-117.25383, 33.25496], [-117.25409, 33.25496], [-117.25448, 33.25494], [-117.25623, 33.25464], [-117.25665, 33.25608]]]}	Unknown Access 4	44862	Zwierstra Mitigation Site	27873	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	19.59	Zwierstra Mitigation Site	State Other or Unknown 104	4
3744	3744	3743	{"type": "Polygon", "coordinates": [[[-117.00555, 32.56116], [-117.00554, 32.56472], [-117.00446, 32.56471], [-117.00445, 32.56601], [-117.00443, 32.56603], [-117.00418, 32.566], [-117.00401, 32.56588], [-117.00338, 32.56582], [-117.00337, 32.56469], [-117.00123, 32.56466], [-117.00126, 32.56109], [-117.00555, 32.56116]]]}	No Public Access 3	44877	Anderprises TransNet Environmental Mitigation	32283	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	42.881	Anderprises TransNet Environmental Mitigation	State Other or Unknown 104	4
4192	4192	4191	{"type": "Polygon", "coordinates": [[[-117.0144, 32.5799], [-117.00992, 32.57971], [-117.00998, 32.57781], [-117.0099, 32.57209], [-117.01425, 32.57223], [-117.01413, 32.57247], [-117.01413, 32.57266], [-117.01421, 32.57544], [-117.01423, 32.5755], [-117.01432, 32.57559], [-117.0144, 32.5799]]]}	Open Access 1	44884	Otay Mesa North TransNet Mitigation	23240	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	85.226	Otay Mesa North TransNet Mitigation	State Other or Unknown 104	4
4229	4229	4228	{"type": "Polygon", "coordinates": [[[-117.00555, 32.56025], [-117.00555, 32.56116], [-117.00126, 32.56109], [-117.00126, 32.56018], [-117.00555, 32.56025]]]}	Unknown Access 4	45096	Anderprizes Mitigation Site	15474	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	10.024	Anderprizes Mitigation Site	State Other or Unknown 104	4
4233	4233	4232	{"type": "Polygon", "coordinates": [[[-117.22555, 33.28986], [-117.2256, 33.29089], [-117.22556, 33.29117], [-117.22548, 33.29133], [-117.22538, 33.29147], [-117.22471, 33.29228], [-117.22418, 33.2926], [-117.22348, 33.29335], [-117.2233, 33.29351], [-117.22309, 33.29367], [-117.22289, 33.29379], [-117.22184, 33.29299], [-117.22186, 33.28931], [-117.22508, 33.28931], [-117.22501, 33.28939], [-117.22555, 33.28986]]]}	Unknown Access 4	45102	Tabata Mitigation Site	26160	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	32.975	Tabata Mitigation Site	State Other or Unknown 104	4
4260	4260	4259	{"type": "Polygon", "coordinates": [[[-117.16445, 32.95224], [-117.16113, 32.95233], [-117.16099, 32.94848], [-117.16432, 32.94852], [-117.16445, 32.95224]]]}	Unknown Access 4	45284	Zamudio TransNet Environmental Mitigation	27854	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	32.329	Zamudio TransNet Environmental Mitigation	State Other or Unknown 104	4
4283	4283	4282	{"type": "Polygon", "coordinates": [[[-117.19602, 33.3082], [-117.19539, 33.30858], [-117.19476, 33.3096], [-117.19489, 33.31006], [-117.19121, 33.31078], [-117.17733, 33.31358], [-117.1753, 33.3124], [-117.17474, 33.31238], [-117.17432, 33.31214], [-117.17484, 33.31196], [-117.17505, 33.31183], [-117.17532, 33.31156], [-117.17668, 33.31087], [-117.17692, 33.31068], [-117.17745, 33.31006], [-117.17764, 33.30976], [-117.17793, 33.30857], [-117.17885, 33.30794], [-117.17982, 33.30805], [-117.18065, 33.30842], [-117.18136, 33.30852], [-117.18243, 33.30861], [-117.1832, 33.30892], [-117.1835, 33.30895], [-117.18388, 33.30881], [-117.18464, 33.30826], [-117.18566, 33.30798], [-117.18604, 33.30812], [-117.1866, 33.30897], [-117.18759, 33.30877], [-117.1893, 33.30835], [-117.19086, 33.30808], [-117.19144, 33.30817], [-117.19185, 33.3085], [-117.19288, 33.30906], [-117.19314, 33.30909], [-117.19384, 33.30888], [-117.19458, 33.30843], [-117.19495, 33.30838], [-117.1953, 33.3083], [-117.19548, 33.30822], [-117.19602, 33.3082]]]}	Unknown Access 4	45285	Vessels Mitigation Site	27006	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	159.815	Vessels Mitigation Site	State Other or Unknown 104	4
4772	4772	4771	{"type": "MultiPolygon", "coordinates": [[[[-123.78953, 40.0753], [-123.7895, 40.07556], [-123.78937, 40.07563], [-123.78923, 40.07562], [-123.78895, 40.07539], [-123.78896, 40.07522], [-123.78889, 40.07509], [-123.78898, 40.0749], [-123.78947, 40.07503], [-123.78953, 40.0753]]], [[[-123.80311, 40.92168], [-123.80295, 40.92183], [-123.80259, 40.92175], [-123.80217, 40.92158], [-123.80189, 40.92163], [-123.80154, 40.92173], [-123.80135, 40.92181], [-123.80095, 40.92202], [-123.80048, 40.92219], [-123.79993, 40.92252], [-123.79977, 40.92257], [-123.79706, 40.92221], [-123.79506, 40.92144], [-123.79484, 40.91961], [-123.79532, 40.91907], [-123.79581, 40.91872], [-123.7969, 40.9187], [-123.7967, 40.91955], [-123.79647, 40.91965], [-123.7963, 40.91983], [-123.79616, 40.92023], [-123.79619, 40.92066], [-123.79623, 40.92097], [-123.79652, 40.92115], [-123.79731, 40.92106], [-123.79784, 40.92114], [-123.79858, 40.92122], [-123.80017, 40.92128], [-123.80216, 40.92123], [-123.80242, 40.92129], [-123.80298, 40.92146], [-123.80311, 40.92168]]], [[[-124.15195, 40.80245], [-124.15185, 40.80277], [-124.15156, 40.80277], [-124.15145, 40.80283], [-124.15145, 40.80296], [-124.15115, 40.80296], [-124.15115, 40.80236], [-124.15119, 40.80236], [-124.15157, 40.80212], [-124.15195, 40.80245]]], [[[-124.15907, 40.55577], [-124.15904, 40.5631], [-124.15159, 40.56302], [-124.15233, 40.56174], [-124.15358, 40.55931], [-124.15391, 40.55636], [-124.15462, 40.55636], [-124.15467, 40.55574], [-124.15907, 40.55577]], [[-124.15418, 40.562], [-124.15424, 40.56175], [-124.1541, 40.56175], [-124.15409, 40.56199], [-124.15418, 40.562]]]]}	Open Access 1	46933	Unnamed site - California Department of Transportation	30558	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	Humboldt 45	124.116		State Other or Unknown 104	4
7862	7862	7861	{"type": "MultiPolygon", "coordinates": [[[[-116.94813, 32.58902], [-116.9452, 32.5891], [-116.94513, 32.5821], [-116.94581, 32.58211], [-116.9458, 32.58217], [-116.94582, 32.58248], [-116.94603, 32.58271], [-116.94635, 32.58283], [-116.94672, 32.58291], [-116.94705, 32.58296], [-116.94715, 32.58293], [-116.94748, 32.58333], [-116.94808, 32.58424], [-116.94542, 32.58527], [-116.94582, 32.58582], [-116.947, 32.58786], [-116.94813, 32.58902]]], [[[-116.96324, 32.58239], [-116.96221, 32.58238], [-116.96223, 32.58109], [-116.96255, 32.58146], [-116.96287, 32.58187], [-116.96324, 32.58239]]], [[[-116.97107, 32.58246], [-116.96665, 32.58242], [-116.96664, 32.58433], [-116.9656, 32.58432], [-116.96528, 32.5838], [-116.96527, 32.58366], [-116.96504, 32.58323], [-116.96479, 32.58282], [-116.96439, 32.58227], [-116.96379, 32.5813], [-116.96318, 32.58026], [-116.96293, 32.57991], [-116.96267, 32.57957], [-116.96225, 32.57912], [-116.96225, 32.57881], [-116.96235, 32.5788], [-116.96238, 32.57507], [-116.97088, 32.57514], [-116.97107, 32.58246]]]]}	No Public Access 3	47715	Lonestar Ridge TransNet Environmental Mitigation	31496	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	191.623	Lonestar Ridge TransNet Environmental Mitigation	State Other or Unknown 104	4
13226	13226	13225	{"type": "Polygon", "coordinates": [[[-117.23056, 33.28559], [-117.23055, 33.28926], [-117.23037, 33.28927], [-117.23036, 33.28955], [-117.22971, 33.28951], [-117.22837, 33.28938], [-117.22838, 33.28563], [-117.23056, 33.28559]]]}	Unknown Access 4	45245	Lueng/Lowe TransNet Environmental Mitigation	21587	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	21.401	Lueng/Lowe TransNet Environmental Mitigation	State Other or Unknown 104	4
14573	14573	14572	{"type": "Polygon", "coordinates": [[[-117.24569, 32.9638], [-117.24306, 32.96378], [-117.24305, 32.96017], [-117.24531, 32.9602], [-117.24558, 32.96169], [-117.24569, 32.9638]]]}	Unknown Access 4	44878	Dean Family Trust TransNet Environmental Mitigation	17977	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	23.121	Dean Family Trust TransNet Environmental Mitigation	State Other or Unknown 104	4
14621	14621	14620	{"type": "Polygon", "coordinates": [[[-117.2959, 33.08404], [-117.29591, 33.08449], [-117.29589, 33.08457], [-117.29581, 33.08472], [-117.29571, 33.08486], [-117.29559, 33.08498], [-117.29544, 33.08509], [-117.29545, 33.08513], [-117.29301, 33.08641], [-117.29248, 33.08662], [-117.29177, 33.08681], [-117.2917, 33.08409], [-117.2959, 33.08404]]]}	Unknown Access 4	44854	Ayoub Mitigation Site	15736	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	20.055	Ayoub Mitigation Site	State Other or Unknown 104	4
14627	14627	14626	{"type": "Polygon", "coordinates": [[[-117.1923, 32.94906], [-117.191, 32.94919], [-117.19013, 32.94942], [-117.18969, 32.94958], [-117.1895, 32.94982], [-117.19051, 32.94991], [-117.19179, 32.94988], [-117.18881, 32.95146], [-117.18726, 32.95215], [-117.18661, 32.95216], [-117.18604, 32.95168], [-117.1852, 32.95166], [-117.18365, 32.9519], [-117.18288, 32.95212], [-117.18285, 32.94953], [-117.18356, 32.94954], [-117.18489, 32.94924], [-117.18599, 32.94907], [-117.18671, 32.94907], [-117.1883, 32.94888], [-117.18953, 32.94857], [-117.18983, 32.94848], [-117.19089, 32.94847], [-117.1916, 32.9486], [-117.1923, 32.94906]]]}	Open Access 1	44879	Deer Canyon Environmental Mitigation	17991	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	54.189	Deer Canyon Environmental Mitigation	State Other or Unknown 104	4
14639	14639	14638	{"type": "MultiPolygon", "coordinates": [[[[-117.30789, 33.14718], [-117.30772, 33.14736], [-117.30771, 33.14776], [-117.30743, 33.14776], [-117.30737, 33.14766], [-117.30705, 33.14753], [-117.30696, 33.14783], [-117.30706, 33.148], [-117.30683, 33.14848], [-117.30683, 33.14853], [-117.30595, 33.14884], [-117.30597, 33.14857], [-117.30597, 33.1483], [-117.30577, 33.14828], [-117.30574, 33.14806], [-117.30489, 33.14809], [-117.3046, 33.14818], [-117.30433, 33.14833], [-117.30412, 33.14849], [-117.30391, 33.14872], [-117.30376, 33.14923], [-117.30349, 33.14922], [-117.3037, 33.14814], [-117.30373, 33.14817], [-117.3073, 33.14696], [-117.30741, 33.14684], [-117.30789, 33.14718]]], [[[-117.3193, 33.14321], [-117.31899, 33.14379], [-117.31831, 33.14345], [-117.3183, 33.14347], [-117.31839, 33.14363], [-117.31815, 33.14354], [-117.31788, 33.14349], [-117.31604, 33.14329], [-117.31607, 33.14321], [-117.31607, 33.1432], [-117.31432, 33.143], [-117.31446, 33.14269], [-117.31497, 33.14275], [-117.31528, 33.14261], [-117.31575, 33.14215], [-117.31581, 33.14205], [-117.31585, 33.14202], [-117.31617, 33.14201], [-117.31631, 33.14205], [-117.31636, 33.14211], [-117.31637, 33.14234], [-117.3164, 33.14236], [-117.3166, 33.14232], [-117.31679, 33.1423], [-117.31684, 33.14228], [-117.31686, 33.14225], [-117.31696, 33.14196], [-117.317, 33.14192], [-117.31707, 33.1419], [-117.31748, 33.14197], [-117.31758, 33.14202], [-117.31763, 33.14209], [-117.31765, 33.14216], [-117.31757, 33.14238], [-117.31757, 33.14241], [-117.31791, 33.14259], [-117.31795, 33.1426], [-117.31799, 33.14258], [-117.31807, 33.14237], [-117.31814, 33.14231], [-117.31823, 33.14231], [-117.31849, 33.14237], [-117.31855, 33.1424], [-117.31858, 33.14246], [-117.31862, 33.14272], [-117.31852, 33.14303], [-117.31853, 33.14311], [-117.31855, 33.14318], [-117.31855, 33.14322], [-117.31857, 33.14324], [-117.31866, 33.14328], [-117.3188, 33.14331], [-117.319, 33.14317], [-117.31919, 33.14308], [-117.31925, 33.14311], [-117.31927, 33.14319], [-117.3193, 33.14321]]]]}	Unknown Access 4	44880	Hallmark Transnet Environmental Mitigation	19611	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	19.35	Hallmark Transnet Environmental Mitigation	State Other or Unknown 104	4
14640	14640	14639	{"type": "Polygon", "coordinates": [[[-117.23926, 33.28549], [-117.23926, 33.28909], [-117.23491, 33.28917], [-117.23491, 33.28905], [-117.2349, 33.28905], [-117.23474, 33.28918], [-117.23415, 33.29054], [-117.23405, 33.29043], [-117.23392, 33.29033], [-117.23377, 33.29024], [-117.23361, 33.29018], [-117.23148, 33.28969], [-117.23111, 33.28962], [-117.23055, 33.28956], [-117.23055, 33.28559], [-117.22838, 33.28563], [-117.22837, 33.28929], [-117.22772, 33.2893], [-117.22737, 33.28923], [-117.2265, 33.28895], [-117.22601, 33.28878], [-117.22595, 33.28872], [-117.22575, 33.28868], [-117.22571, 33.28792], [-117.22516, 33.28706], [-117.22519, 33.28669], [-117.22535, 33.28629], [-117.22535, 33.28602], [-117.22514, 33.28568], [-117.22551, 33.28334], [-117.22564, 33.28297], [-117.22601, 33.28228], [-117.22622, 33.28194], [-117.22668, 33.2815], [-117.22671, 33.28162], [-117.22676, 33.28169], [-117.22686, 33.28177], [-117.2269, 33.28184], [-117.22711, 33.28231], [-117.22773, 33.2829], [-117.22847, 33.28203], [-117.22846, 33.28202], [-117.22816, 33.28203], [-117.22708, 33.28113], [-117.22784, 33.28019], [-117.22798, 33.28008], [-117.22965, 33.279], [-117.22998, 33.27881], [-117.2345, 33.27683], [-117.23471, 33.27672], [-117.23494, 33.27658], [-117.23493, 33.28186], [-117.23731, 33.28182], [-117.23731, 33.2832], [-117.23567, 33.28324], [-117.23567, 33.2855], [-117.23923, 33.28544], [-117.23923, 33.28549], [-117.23926, 33.28549]]]}	Unknown Access 4	44885	Groves Property TransNet Mitigation	19537	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	281.423	Groves Property TransNet Mitigation	State Other or Unknown 104	4
14734	14734	14733	{"type": "Polygon", "coordinates": [[[-117.1954, 33.31432], [-117.19505, 33.31429], [-117.19404, 33.31474], [-117.19356, 33.31463], [-117.1905, 33.31328], [-117.18794, 33.31349], [-117.18526, 33.31418], [-117.1771, 33.31479], [-117.17421, 33.31628], [-117.17383, 33.31428], [-117.19121, 33.31078], [-117.19489, 33.31006], [-117.19536, 33.30995], [-117.1954, 33.31432]]]}	Unknown Access 4	45101	Morrison Mitigation Site	22497	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	123.583	Morrison Mitigation Site	State Other or Unknown 104	4
14745	14745	14744	{"type": "MultiPolygon", "coordinates": [[[[-117.11049, 33.29365], [-117.1103, 33.29404], [-117.11018, 33.29456], [-117.10973, 33.29441], [-117.10966, 33.29574], [-117.10934, 33.29638], [-117.10919, 33.29704], [-117.10856, 33.29701], [-117.1084, 33.29701], [-117.108, 33.29706], [-117.10539, 33.297], [-117.10342, 33.29701], [-117.10349, 33.29514], [-117.09361, 33.29524], [-117.09359, 33.29573], [-117.0939, 33.29709], [-117.09237, 33.29711], [-117.09236, 33.29895], [-117.08717, 33.29898], [-117.08717, 33.299], [-117.08758, 33.2997], [-117.08627, 33.2997], [-117.08578, 33.29899], [-117.08578, 33.29765], [-117.08601, 33.29714], [-117.08607, 33.29696], [-117.08675, 33.29551], [-117.08682, 33.2954], [-117.08689, 33.29514], [-117.08695, 33.29469], [-117.08703, 33.29393], [-117.08691, 33.29353], [-117.08651, 33.29263], [-117.08649, 33.29248], [-117.08633, 33.29237], [-117.08624, 33.29225], [-117.08614, 33.29206], [-117.08592, 33.29176], [-117.08553, 33.29148], [-117.08417, 33.29035], [-117.08402, 33.29019], [-117.08374, 33.2898], [-117.08357, 33.2894], [-117.08345, 33.2891], [-117.08344, 33.28894], [-117.08347, 33.2886], [-117.08347, 33.28849], [-117.08343, 33.2884], [-117.08337, 33.2883], [-117.08379, 33.28608], [-117.08366, 33.28608], [-117.08323, 33.2884], [-117.08322, 33.28867], [-117.08326, 33.28898], [-117.08322, 33.28899], [-117.08323, 33.28913], [-117.08341, 33.28973], [-117.08124, 33.28975], [-117.08127, 33.29053], [-117.08133, 33.29159], [-117.08062, 33.29177], [-117.08021, 33.29189], [-117.07879, 33.29235], [-117.07696, 33.2916], [-117.07696, 33.28976], [-117.07557, 33.28977], [-117.07543, 33.2898], [-117.07501, 33.28999], [-117.07487, 33.29007], [-117.07468, 33.29015], [-117.07438, 33.29036], [-117.07403, 33.29055], [-117.07393, 33.29064], [-117.07384, 33.29074], [-117.07377, 33.2908], [-117.07299, 33.29116], [-117.07275, 33.29112], [-117.07266, 33.29109], [-117.07259, 33.29103], [-117.07252, 33.29085], [-117.0721, 33.29005], [-117.07207, 33.29002], [-117.07148, 33.28984], [-117.07179, 33.28884], [-117.07215, 33.28903], [-117.07231, 33.2893], [-117.07268, 33.2904], [-117.07296, 33.2908], [-117.07345, 33.29061], [-117.0736, 33.29021], [-117.07394, 33.28991], [-117.07375, 33.28943], [-117.07386, 33.28913], [-117.07385, 33.28881], [-117.07414, 33.28832], [-117.07424, 33.28805], [-117.0745, 33.28774], [-117.07523, 33.28763], [-117.07565, 33.28742], [-117.07575, 33.2871], [-117.0762, 33.28686], [-117.07699, 33.28671], [-117.07699, 33.28419], [-117.08377, 33.28415], [-117.08378, 33.28411], [-117.08375, 33.28402], [-117.08356, 33.28372], [-117.0835, 33.28358], [-117.08347, 33.2834], [-117.08349, 33.28312], [-117.08578, 33.28314], [-117.0858, 33.28237], [-117.09026, 33.28235], [-117.09032, 33.28598], [-117.09412, 33.28591], [-117.0936, 33.28821], [-117.09497, 33.28826], [-117.09604, 33.28865], [-117.09643, 33.289], [-117.09718, 33.28857], [-117.09767, 33.28865], [-117.09805, 33.28835], [-117.09809, 33.28783], [-117.0986, 33.28763], [-117.09951, 33.28799], [-117.10078, 33.2877], [-117.10134, 33.28734], [-117.102, 33.2874], [-117.10224, 33.28696], [-117.10221, 33.2864], [-117.10192, 33.28561], [-117.10078, 33.2841], [-117.10097, 33.28334], [-117.09984, 33.28219], [-117.09941, 33.28162], [-117.09963, 33.28147], [-117.10078, 33.281], [-117.10118, 33.27924], [-117.10211, 33.27739], [-117.10345, 33.27742], [-117.1035, 33.27854], [-117.10541, 33.27853], [-117.10554, 33.28213], [-117.10477, 33.28215], [-117.1049, 33.28577], [-117.10488, 33.28619], [-117.10378, 33.28685], [-117.10371, 33.28889], [-117.10394, 33.28921], [-117.10401, 33.28977], [-117.10464, 33.28998], [-117.10631, 33.29012], [-117.10702, 33.29041], [-117.10735, 33.29025], [-117.10764, 33.29071], [-117.10777, 33.29107], [-117.10791, 33.29246], [-117.10809, 33.29246], [-117.10885, 33.29254], [-117.10944, 33.29314], [-117.11009, 33.29351], [-117.11049, 33.29365]], [[-117.09382, 33.28838], [-117.09381, 33.28837], [-117.09373, 33.28837], [-117.09371, 33.28847], [-117.0938, 33.28847], [-117.09382, 33.28838]]], [[[-117.08213, 33.28987], [-117.08177, 33.29006], [-117.08144, 33.29027], [-117.08143, 33.28986], [-117.08213, 33.28987]]], [[[-117.0864, 33.29585], [-117.0863, 33.29593], [-117.0863, 33.29598], [-117.08622, 33.29609], [-117.08608, 33.29602], [-117.08597, 33.29601], [-117.08367, 33.29624], [-117.08343, 33.29622], [-117.08309, 33.29612], [-117.08292, 33.29603], [-117.08276, 33.2959], [-117.08264, 33.29571], [-117.08236, 33.29487], [-117.08152, 33.29279], [-117.08151, 33.29269], [-117.0815, 33.29164], [-117.08145, 33.2905], [-117.08153, 33.29038], [-117.08175, 33.29023], [-117.08203, 33.29007], [-117.08237, 33.28992], [-117.08251, 33.28987], [-117.08347, 33.28987], [-117.08418, 33.29062], [-117.08474, 33.29111], [-117.08495, 33.29134], [-117.08526, 33.29154], [-117.08547, 33.29175], [-117.08559, 33.2919], [-117.08595, 33.29219], [-117.08614, 33.29242], [-117.08617, 33.29249], [-117.08624, 33.29258], [-117.08644, 33.29306], [-117.08658, 33.29329], [-117.08674, 33.29397], [-117.08671, 33.29421], [-117.0866, 33.29439], [-117.08661, 33.29466], [-117.08658, 33.29495], [-117.08649, 33.2953], [-117.08648, 33.2956], [-117.08642, 33.29575], [-117.0864, 33.29585]]]]}	Unknown Access 4	45088	Rancho Lilac Mitigation Site	24150	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	909.984	Rancho Lilac Mitigation Site	State Other or Unknown 104	4
14748	14748	14747	{"type": "MultiPolygon", "coordinates": [[[[-117.2483, 33.24507], [-117.24833, 33.24558], [-117.24831, 33.24561], [-117.24827, 33.24564], [-117.24827, 33.24579], [-117.24833, 33.24583], [-117.24834, 33.24606], [-117.2485, 33.24653], [-117.24854, 33.24677], [-117.24852, 33.24699], [-117.24841, 33.24737], [-117.24838, 33.2476], [-117.24839, 33.24781], [-117.24846, 33.24825], [-117.24847, 33.24864], [-117.24846, 33.24868], [-117.24839, 33.24871], [-117.2469, 33.24873], [-117.24645, 33.24865], [-117.24604, 33.24863], [-117.24565, 33.24867], [-117.24515, 33.24879], [-117.24508, 33.24877], [-117.24498, 33.24859], [-117.24493, 33.2451], [-117.2483, 33.24507]]], [[[-117.24931, 33.25309], [-117.24829, 33.25358], [-117.24817, 33.25368], [-117.24651, 33.25308], [-117.24637, 33.25305], [-117.246, 33.25299], [-117.24564, 33.25296], [-117.24533, 33.25296], [-117.24499, 33.25298], [-117.24498, 33.24895], [-117.24509, 33.24899], [-117.24517, 33.24899], [-117.2454, 33.2489], [-117.24562, 33.24884], [-117.24606, 33.24879], [-117.24646, 33.24882], [-117.2469, 33.2489], [-117.24928, 33.24886], [-117.24931, 33.25309]]]]}	Unknown Access 4	45093	Jeffries Ranch Mitigation Site	20385	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	79.98	Jeffries Ranch Mitigation Site	State Other or Unknown 104	4
14750	14750	14749	{"type": "Polygon", "coordinates": [[[-117.24229, 33.25127], [-117.2407, 33.24977], [-117.24069, 33.2488], [-117.24299, 33.24882], [-117.24498, 33.2488], [-117.24499, 33.25283], [-117.24415, 33.25258], [-117.24353, 33.25307], [-117.24362, 33.2534], [-117.24347, 33.25349], [-117.24338, 33.25304], [-117.24343, 33.25276], [-117.2434, 33.25222], [-117.24229, 33.25127]]]}	Unknown Access 4	45094	Timeout Holdings Mitigation Site	26371	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5	San Diego 4	31.483	Timeout Holdings Mitigation Site	State Other or Unknown 104	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]);