calands: units_with_maps: 33 rows where GAP_STS = 4 and MNG

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

33 rows where GAP_STS = 4 and MNG_AGENCY = 84

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	DES_TP	GAP_STS
208	208	207	{"type": "Polygon", "coordinates": [[[-117.09538, 33.13695], [-117.09362, 33.13752], [-117.09362, 33.1357], [-117.09365, 33.13567], [-117.09379, 33.1356], [-117.0939, 33.13563], [-117.09401, 33.1356], [-117.09406, 33.13557], [-117.09407, 33.13551], [-117.09406, 33.1355], [-117.09382, 33.13558], [-117.09362, 33.13548], [-117.09357, 33.13283], [-117.09348, 33.13177], [-117.09397, 33.13182], [-117.09425, 33.13159], [-117.09432, 33.13154], [-117.09436, 33.13154], [-117.09442, 33.13154], [-117.09451, 33.13179], [-117.09458, 33.13207], [-117.09474, 33.13462], [-117.09453, 33.13534], [-117.09455, 33.13535], [-117.0948, 33.13527], [-117.09484, 33.13577], [-117.09489, 33.13594], [-117.09494, 33.13615], [-117.09502, 33.13635], [-117.09522, 33.13672], [-117.0953, 33.13686], [-117.09538, 33.13695]]]}	No Public Access 3	654	Reidy Canyon Creek	24281	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	16.798	Reidy Canyon Creek	Local Other or Unknown 14	4
235	235	234	{"type": "MultiPolygon", "coordinates": [[[[-117.09432, 33.11987], [-117.09377, 33.1199], [-117.09333, 33.11988], [-117.09298, 33.11971], [-117.09292, 33.11957], [-117.0934, 33.11955], [-117.09432, 33.11987]]], [[[-117.09563, 33.1199], [-117.09552, 33.12002], [-117.09533, 33.1203], [-117.09524, 33.12049], [-117.09521, 33.1206], [-117.09497, 33.12181], [-117.09491, 33.12286], [-117.09486, 33.12319], [-117.09477, 33.12344], [-117.0946, 33.1235], [-117.09447, 33.1232], [-117.09458, 33.12282], [-117.0946, 33.12228], [-117.09473, 33.12119], [-117.09482, 33.12061], [-117.09498, 33.12015], [-117.09521, 33.11975], [-117.09563, 33.1199]]]]}	No Public Access 3	684	Reidy Canyon Creek	24281	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	4.055	Reidy Canyon Creek	Local Other or Unknown 14	4
236	236	235	{"type": "Polygon", "coordinates": [[[-117.09461, 33.12373], [-117.09348, 33.12592], [-117.09308, 33.12668], [-117.09291, 33.12629], [-117.09353, 33.12505], [-117.09345, 33.12492], [-117.09371, 33.12472], [-117.09415, 33.12388], [-117.09461, 33.12373]]]}	No Public Access 3	687	Reidy Canyon Creek	24281	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	2.732	Reidy Canyon Creek	Local Other or Unknown 14	4
240	240	239	{"type": "Polygon", "coordinates": [[[-117.08384, 33.16747], [-117.08271, 33.16759], [-117.08326, 33.16655], [-117.08332, 33.16648], [-117.08345, 33.1664], [-117.08359, 33.16635], [-117.08368, 33.16634], [-117.08367, 33.16648], [-117.08368, 33.16662], [-117.08384, 33.16747]]]}	Open Access 1	645	City of Escondido Open Space	17312	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	2.034	City of Escondido OS	Local Recreation Area 3	4
251	251	250	{"type": "Polygon", "coordinates": [[[-117.0929, 33.12785], [-117.09258, 33.12797], [-117.09245, 33.12767], [-117.09253, 33.12696], [-117.09276, 33.12662], [-117.09289, 33.12693], [-117.09286, 33.12698], [-117.09278, 33.12727], [-117.09278, 33.12756], [-117.0929, 33.12785]]]}	No Public Access 3	683	Reidy Canyon Creek	24281	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	0.966	Reidy Canyon Creek	Local Other or Unknown 14	4
1730	1730	1729	{"type": "Polygon", "coordinates": [[[-117.08435, 33.17012], [-117.08438, 33.17027], [-117.08433, 33.17032], [-117.082, 33.17124], [-117.08208, 33.17105], [-117.08221, 33.17108], [-117.08271, 33.17089], [-117.08333, 33.17055], [-117.0842, 33.17013], [-117.08435, 33.17012]]]}	Open Access 1	12924	City of Escondido Open Space	17312	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	0.911	City of Escondido OS	Local Recreation Area 3	4
1736	1736	1735	{"type": "Polygon", "coordinates": [[[-117.10161, 33.14781], [-117.10054, 33.14783], [-117.10058, 33.14924], [-117.09922, 33.14927], [-117.09919, 33.14852], [-117.09833, 33.14853], [-117.09826, 33.14822], [-117.09916, 33.14747], [-117.09914, 33.1465], [-117.09734, 33.14653], [-117.09741, 33.14629], [-117.0975, 33.14628], [-117.09751, 33.14626], [-117.09905, 33.14625], [-117.10077, 33.14621], [-117.10158, 33.14671], [-117.10161, 33.14781]]]}	Open Access 1	12943	Rod McLeod Park	24547	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2	https://www.escondido.org/rod-mcleod-park.aspx	San Diego 4	17.211	Rod McLeod Park	Local Park 2	4
3820	3820	3819	{"type": "Polygon", "coordinates": [[[-117.07294, 33.13624], [-117.07138, 33.13696], [-117.07093, 33.13639], [-117.07125, 33.13623], [-117.07102, 33.13594], [-117.07231, 33.13531], [-117.07294, 33.13624]]]}	Open Access 1	45221	Grove Park	19534	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2	https://www.escondido.org/grove-park.aspx	San Diego 4	4.561	Grove Park	Local Park 2	4
3891	3891	3890	{"type": "Polygon", "coordinates": [[[-117.09429, 33.13135], [-117.094, 33.13143], [-117.09383, 33.13102], [-117.09403, 33.13085], [-117.09407, 33.13095], [-117.09412, 33.13095], [-117.09429, 33.13135]]]}	No Public Access 3	642	Reidy Canyon Creek	24281	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	0.372	Reidy Canyon Creek	Local Other or Unknown 14	4
4198	4198	4197	{"type": "Polygon", "coordinates": [[[-117.03223, 33.15748], [-117.03217, 33.15759], [-117.0322, 33.15761], [-117.03147, 33.15902], [-117.03133, 33.15897], [-117.03144, 33.15869], [-117.0315, 33.15844], [-117.03159, 33.15746], [-117.03223, 33.15748]]]}	Open Access 1	47689	Mayflower Dog Park	31425	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2	https://www.escondido.org/mayflower-dog-park.aspx	San Diego 4	1.445	Mayflower Dog Park	Local Park 2	4
4913	4913	4912	{"type": "Polygon", "coordinates": [[[-117.0835, 33.16545], [-117.08297, 33.16569], [-117.08281, 33.16578], [-117.08258, 33.16596], [-117.0824, 33.16616], [-117.0823, 33.16631], [-117.08099, 33.1689], [-117.08055, 33.16784], [-117.08057, 33.16783], [-117.0806, 33.16791], [-117.08073, 33.16802], [-117.08107, 33.16808], [-117.08126, 33.1679], [-117.0813, 33.16781], [-117.08104, 33.16772], [-117.08106, 33.16768], [-117.08136, 33.16777], [-117.08181, 33.16687], [-117.08187, 33.16673], [-117.0819, 33.16659], [-117.08189, 33.16635], [-117.0818, 33.16611], [-117.08154, 33.16625], [-117.08156, 33.16621], [-117.08344, 33.16511], [-117.0835, 33.16545]]]}	Open Access 1	12921	City of Escondido Open Space	17312	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	3.546	City of Escondido OS	Local Recreation Area 3	4
4915	4915	4914	{"type": "Polygon", "coordinates": [[[-117.08135, 33.16636], [-117.08112, 33.1665], [-117.08077, 33.16723], [-117.08057, 33.16742], [-117.08047, 33.16756], [-117.08057, 33.16782], [-117.08055, 33.16784], [-117.0802, 33.167], [-117.08128, 33.16637], [-117.08135, 33.16636]]]}	Open Access 1	12925	City of Escondido Open Space	17312	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	1.075	City of Escondido OS	Local Recreation Area 3	4
5007	5007	5006	{"type": "Polygon", "coordinates": [[[-117.08308, 33.12563], [-117.083, 33.12566], [-117.08273, 33.12596], [-117.08261, 33.1257], [-117.08295, 33.12535], [-117.08308, 33.12563]]]}	No Public Access 3	689	Escondido Creek	18706	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	0.332	Escondido Creek	Local Other or Unknown 14	4
5824	5824	5823	{"type": "Polygon", "coordinates": [[[-117.0387, 33.12652], [-117.03852, 33.12705], [-117.03677, 33.12981], [-117.03458, 33.12979], [-117.03462, 33.12717], [-117.03548, 33.12719], [-117.03508, 33.12661], [-117.03508, 33.12642], [-117.0387, 33.12652]]]}	Open Access 1	677	Mountain View Park	22554	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2	https://www.escondido.org/mountain-view-park.aspx	San Diego 4	26.279	Mtn. View Park	Local Park 2	4
5863	5863	5862	{"type": "MultiPolygon", "coordinates": [[[[-117.02636, 33.16692], [-117.02637, 33.16744], [-117.0263, 33.16767], [-117.02627, 33.16768], [-117.02381, 33.1705], [-117.0228, 33.17041], [-117.02244, 33.17066], [-117.02191, 33.17075], [-117.02157, 33.17076], [-117.0211, 33.17036], [-117.02039, 33.17028], [-117.0193, 33.16949], [-117.01888, 33.1689], [-117.01829, 33.16863], [-117.0182, 33.16854], [-117.01809, 33.16833], [-117.01805, 33.16832], [-117.01805, 33.16822], [-117.01821, 33.16823], [-117.01836, 33.16851], [-117.01841, 33.16856], [-117.019, 33.16883], [-117.01907, 33.16893], [-117.01899, 33.16898], [-117.01935, 33.16949], [-117.02041, 33.17025], [-117.02111, 33.17033], [-117.02157, 33.17072], [-117.02186, 33.17071], [-117.02188, 33.17067], [-117.02237, 33.17059], [-117.02276, 33.17032], [-117.02381, 33.17041], [-117.02579, 33.16812], [-117.02611, 33.1677], [-117.02619, 33.16744], [-117.02618, 33.16691], [-117.02636, 33.16692]]], [[[-117.03026, 33.16085], [-117.02978, 33.16201], [-117.02983, 33.16203], [-117.02952, 33.16302], [-117.02949, 33.16333], [-117.02954, 33.16362], [-117.02927, 33.16475], [-117.02785, 33.16432], [-117.02829, 33.16321], [-117.02812, 33.16305], [-117.02818, 33.16299], [-117.02891, 33.16214], [-117.029, 33.16188], [-117.02906, 33.16187], [-117.02931, 33.16168], [-117.02936, 33.16148], [-117.02948, 33.16128], [-117.02963, 33.16113], [-117.02986, 33.16099], [-117.03026, 33.16085]]], [[[-117.047, 33.14542], [-117.0464, 33.14577], [-117.04613, 33.14599], [-117.04568, 33.14639], [-117.04536, 33.1466], [-117.04502, 33.14677], [-117.04494, 33.1468], [-117.04431, 33.14709], [-117.04386, 33.14733], [-117.04316, 33.14765], [-117.04287, 33.14774], [-117.04248, 33.14783], [-117.04224, 33.14786], [-117.04113, 33.1479], [-117.04094, 33.14799], [-117.04089, 33.14791], [-117.04015, 33.14791], [-117.03971, 33.14795], [-117.03949, 33.14801], [-117.03909, 33.14814], [-117.0387, 33.1484], [-117.03852, 33.14855], [-117.03758, 33.14944], [-117.03759, 33.14947], [-117.03744, 33.14963], [-117.03729, 33.14987], [-117.03692, 33.14982], [-117.03731, 33.14903], [-117.03754, 33.14905], [-117.03827, 33.14831], [-117.03842, 33.14818], [-117.03841, 33.14815], [-117.03858, 33.14803], [-117.03896, 33.14783], [-117.03932, 33.14768], [-117.03981, 33.14758], [-117.04015, 33.14756], [-117.04116, 33.14756], [-117.04121, 33.14762], [-117.04189, 33.14763], [-117.04224, 33.1476], [-117.04252, 33.14756], [-117.04277, 33.14749], [-117.043, 33.14741], [-117.04507, 33.14646], [-117.04528, 33.14635], [-117.04539, 33.14627], [-117.04584, 33.14587], [-117.04623, 33.14554], [-117.04685, 33.14517], [-117.047, 33.14542]]], [[[-117.0675, 33.13214], [-117.06677, 33.13264], [-117.06648, 33.13289], [-117.06619, 33.13307], [-117.06584, 33.13324], [-117.06561, 33.13332], [-117.06516, 33.13344], [-117.06488, 33.13347], [-117.06459, 33.13312], [-117.06483, 33.1331], [-117.06485, 33.13313], [-117.06512, 33.13308], [-117.06552, 33.13296], [-117.06601, 33.13276], [-117.06651, 33.13245], [-117.06738, 33.13176], [-117.0675, 33.13214]]], [[[-117.06901, 33.13096], [-117.06874, 33.13109], [-117.06832, 33.13136], [-117.06801, 33.13163], [-117.06802, 33.13165], [-117.06769, 33.13191], [-117.06757, 33.13154], [-117.0683, 33.13093], [-117.0688, 33.13065], [-117.06901, 33.13096]]], [[[-117.0704, 33.13036], [-117.06983, 33.13063], [-117.0698, 33.1306], [-117.06925, 33.13085], [-117.06904, 33.13054], [-117.07019, 33.13002], [-117.0704, 33.13036]]], [[[-117.07179, 33.12972], [-117.07063, 33.13026], [-117.07043, 33.12995], [-117.07073, 33.12981], [-117.07071, 33.12977], [-117.07158, 33.12938], [-117.07179, 33.12972]]], [[[-117.07317, 33.12909], [-117.07202, 33.12961], [-117.07181, 33.12927], [-117.07295, 33.12874], [-117.07317, 33.12909]]], [[[-117.07456, 33.12844], [-117.07339, 33.12896], [-117.07334, 33.1289], [-117.07432, 33.12843], [-117.07448, 33.12836], [-117.07456, 33.12844]]], [[[-117.07591, 33.12782], [-117.07479, 33.12835], [-117.07472, 33.12824], [-117.07586, 33.12772], [-117.07591, 33.12782]]], [[[-117.07746, 33.12743], [-117.07699, 33.12747], [-117.07676, 33.12751], [-117.07641, 33.12762], [-117.07616, 33.12773], [-117.07608, 33.12761], [-117.07724, 33.12709], [-117.07746, 33.12743]]], [[[-117.08144, 33.1271], [-117.08115, 33.12721], [-117.08078, 33.1273], [-117.08026, 33.12738], [-117.07774, 33.12741], [-117.07754, 33.12707], [-117.07901, 33.12707], [-117.08015, 33.12704], [-117.08067, 33.12695], [-117.08102, 33.12686], [-117.08124, 33.12678], [-117.08144, 33.1271]]], [[[-117.08226, 33.12655], [-117.08202, 33.12674], [-117.08199, 33.12672], [-117.08166, 33.12695], [-117.08146, 33.12667], [-117.08176, 33.12645], [-117.08176, 33.12644], [-117.08207, 33.12614], [-117.08226, 33.12655]]], [[[-117.08271, 33.12607], [-117.08237, 33.12643], [-117.0822, 33.12601], [-117.08225, 33.12599], [-117.08254, 33.12569], [-117.08271, 33.12607]]], [[[-117.08966, 33.12061], [-117.08939, 33.12075], [-117.08924, 33.12087], [-117.08838, 33.12158], [-117.08823, 33.12129], [-117.08922, 33.12051], [-117.08949, 33.12035], [-117.08966, 33.12061]]], [[[-117.09276, 33.11986], [-117.09207, 33.11988], [-117.09152, 33.11994], [-117.09127, 33.11998], [-117.09056, 33.12017], [-117.09021, 33.1203], [-117.08986, 33.12046], [-117.0897, 33.12024], [-117.08998, 33.12008], [-117.09025, 33.11996], [-117.09048, 33.11986], [-117.09078, 33.11978], [-117.09107, 33.11977], [-117.09148, 33.11968], [-117.09186, 33.11961], [-117.09222, 33.11958], [-117.09265, 33.11958], [-117.09276, 33.11986]]], [[[-117.09679, 33.11874], [-117.09593, 33.11947], [-117.09577, 33.11965], [-117.09533, 33.11949], [-117.09538, 33.1194], [-117.09539, 33.11936], [-117.09511, 33.11927], [-117.09567, 33.119], [-117.09571, 33.11901], [-117.09634, 33.11858], [-117.09679, 33.11874]]], [[[-117.09969, 33.11766], [-117.09946, 33.1182], [-117.0989, 33.11818], [-117.09888, 33.11815], [-117.09867, 33.11815], [-117.09837, 33.11816], [-117.09803, 33.11822], [-117.09776, 33.11828], [-117.0975, 33.11838], [-117.09728, 33.11849], [-117.09706, 33.11865], [-117.09653, 33.11844], [-117.09691, 33.11816], [-117.09712, 33.11804], [-117.09749, 33.11788], [-117.09798, 33.11774], [-117.09798, 33.11772], [-117.09829, 33.11767], [-117.09893, 33.11765], [-117.09894, 33.11768], [-117.09931, 33.11768], [-117.09969, 33.11766]]], [[[-117.1043, 33.11385], [-117.10384, 33.11409], [-117.10355, 33.11429], [-117.10326, 33.11453], [-117.10283, 33.11502], [-117.10252, 33.11554], [-117.10242, 33.11581], [-117.10218, 33.11658], [-117.10203, 33.11686], [-117.10177, 33.1172], [-117.10174, 33.11727], [-117.10161, 33.11742], [-117.10146, 33.11755], [-117.10118, 33.11774], [-117.10097, 33.11726], [-117.10097, 33.11723], [-117.10128, 33.11699], [-117.1015, 33.11676], [-117.10182, 33.11591], [-117.10195, 33.1155], [-117.10213, 33.11513], [-117.10232, 33.11481], [-117.10255, 33.11452], [-117.10257, 33.11437], [-117.10284, 33.11418], [-117.10307, 33.11393], [-117.10311, 33.11394], [-117.10358, 33.11365], [-117.1043, 33.11385]]], [[[-117.11185, 33.10955], [-117.11069, 33.11042], [-117.11039, 33.11068], [-117.11003, 33.11107], [-117.10985, 33.11132], [-117.10976, 33.11149], [-117.10961, 33.1117], [-117.10939, 33.11195], [-117.10889, 33.11244], [-117.10817, 33.11317], [-117.10811, 33.11314], [-117.10768, 33.11353], [-117.10742, 33.11388], [-117.10735, 33.11405], [-117.10729, 33.11442], [-117.10718, 33.11439], [-117.10723, 33.11402], [-117.10738, 33.11364], [-117.10735, 33.11362], [-117.1076, 33.11327], [-117.10792, 33.11298], [-117.10786, 33.11293], [-117.10723, 33.11311], [-117.10723, 33.11314], [-117.10474, 33.11367], [-117.10402, 33.11348], [-117.10445, 33.11328], [-117.10496, 33.11313], [-117.10644, 33.11287], [-117.10742, 33.11262], [-117.10777, 33.1125], [-117.10831, 33.11222], [-117.10878, 33.11189], [-117.1092, 33.11145], [-117.10968, 33.11079], [-117.10997, 33.11045], [-117.11033, 33.11011], [-117.11091, 33.10963], [-117.11124, 33.1093], [-117.11185, 33.10955]]]]}	No Public Access 3	192	Escondido Creek	18706	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	62.151	Escondido Creek	Local Other or Unknown 14	4
5919	5919	5918	{"type": "Polygon", "coordinates": [[[-117.09, 33.11459], [-117.0896, 33.11481], [-117.0887, 33.11354], [-117.08925, 33.11325], [-117.09, 33.11432], [-117.08987, 33.1144], [-117.09, 33.11459]]]}	Open Access 1	406	Westside Park	27425	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2	https://www.escondido.org/westside-park.aspx	San Diego 4	2.35	Westside Park	Local Park 2	4
6001	6001	6000	{"type": "Polygon", "coordinates": [[[-117.0646, 33.13353], [-117.06399, 33.13352], [-117.06374, 33.13349], [-117.0637, 33.13339], [-117.06346, 33.13339], [-117.06325, 33.1334], [-117.063, 33.13347], [-117.06278, 33.13357], [-117.06261, 33.13369], [-117.06193, 33.13449], [-117.06258, 33.13619], [-117.06094, 33.13717], [-117.06087, 33.13699], [-117.06045, 33.13543], [-117.06028, 33.13504], [-117.0605, 33.13496], [-117.06093, 33.13475], [-117.06131, 33.1345], [-117.06178, 33.13412], [-117.06178, 33.13408], [-117.0623, 33.13348], [-117.0626, 33.13322], [-117.06264, 33.13326], [-117.06278, 33.13319], [-117.06292, 33.13314], [-117.06325, 33.13308], [-117.06358, 33.13309], [-117.06359, 33.13306], [-117.06426, 33.13311], [-117.0646, 33.13353]]]}	Open Access 1	648	Washington Park	27275	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2	https://www.escondido.org/washington-park.aspx	San Diego 4	12.694	Washington Park	Local Park 2	4
6015	6015	6014	{"type": "Polygon", "coordinates": [[[-117.09363, 33.12972], [-117.0934, 33.12982], [-117.09332, 33.12983], [-117.09264, 33.12819], [-117.09301, 33.12807], [-117.09327, 33.1289], [-117.09363, 33.12972]]]}	No Public Access 3	675	Reidy Canyon Creek	24281	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	1.523	Reidy Canyon Creek	Local Other or Unknown 14	4
6021	6021	6020	{"type": "Polygon", "coordinates": [[[-117.09032, 33.16855], [-117.09013, 33.16916], [-117.08888, 33.17318], [-117.08881, 33.17309], [-117.08922, 33.17174], [-117.08935, 33.17106], [-117.08962, 33.17044], [-117.08971, 33.17017], [-117.08973, 33.16987], [-117.08969, 33.16963], [-117.08924, 33.16964], [-117.08917, 33.16947], [-117.08972, 33.1694], [-117.08988, 33.16933], [-117.08991, 33.16921], [-117.08957, 33.16847], [-117.08962, 33.16834], [-117.08975, 33.16834], [-117.08977, 33.16836], [-117.08986, 33.16835], [-117.09023, 33.16843], [-117.09032, 33.16855]]]}	Open Access 1	694	City of Escondido Open Space	17312	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	2.827	City of Escondido OS	Local Recreation Area 3	4
6250	6250	6249	{"type": "Polygon", "coordinates": [[[-117.1192, 33.10579], [-117.11901, 33.10627], [-117.11885, 33.10655], [-117.11637, 33.10688], [-117.11677, 33.10621], [-117.11701, 33.10622], [-117.11704, 33.1061], [-117.11691, 33.10609], [-117.11713, 33.10571], [-117.11708, 33.10568], [-117.1178, 33.10446], [-117.1192, 33.10579]]]}	No Public Access 3	1410	Escondido Creek	18706	1102	Escondido, City of 86	City 2	City Agency 2	http://www.escondido.org/parks-open-space.aspx	City 2	1102	Escondido, City of 84	City 2	City Agency 2		San Diego 4	8.905	Escondido Creek	Local Other or Unknown 14	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]);