calands: units_with_maps: 55 rows where ACCESS_TYP = 1, GAP_STS = 4 and MNG

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

55 rows where ACCESS_TYP = 1, GAP_STS = 4 and MNG_AGENCY = 244

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
741	741	740	{"type": "Polygon", "coordinates": [[[-119.09273, 35.41839], [-119.09269, 35.4184], [-119.0927, 35.41955], [-119.0925, 35.41955], [-119.09243, 35.41949], [-119.09241, 35.41509], [-119.09269, 35.41509], [-119.09269, 35.41693], [-119.09273, 35.41694], [-119.09273, 35.41839]]]}	Open Access 1	47535	Coffee Road Dog Park	31240	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	3.164	Coffee Road Dog Park	Local Park 2	4
1828	1828	1827	{"type": "Polygon", "coordinates": [[[-119.10455, 35.332], [-119.10449, 35.33213], [-119.1042, 35.33249], [-119.10409, 35.33265], [-119.10377, 35.33321], [-119.10345, 35.33315], [-119.10324, 35.33313], [-119.10202, 35.33313], [-119.10203, 35.33142], [-119.10265, 35.33141], [-119.10291, 35.33143], [-119.1035, 35.33153], [-119.10366, 35.33158], [-119.10407, 35.33173], [-119.10438, 35.33189], [-119.10455, 35.332]]]}	Open Access 1	15709	Haggin Oaks Park	19595	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	8.867	Haggin Oaks Park	Local Park 2	4
1832	1832	1831	{"type": "Polygon", "coordinates": [[[-118.9871, 35.38807], [-118.98635, 35.39014], [-118.98528, 35.39015], [-118.98515, 35.39008], [-118.9851, 35.38998], [-118.98512, 35.38969], [-118.98579, 35.38777], [-118.9871, 35.38807]]]}	Open Access 1	15716	Jefferson Park	20379	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	7.672	Jefferson Park	Local Park 2	4
1835	1835	1834	{"type": "Polygon", "coordinates": [[[-119.01169, 35.36081], [-119.01169, 35.36208], [-119.01092, 35.3621], [-119.01092, 35.36252], [-119.00964, 35.36251], [-119.00964, 35.36083], [-119.01067, 35.36084], [-119.01169, 35.36081]]]}	Open Access 1	15745	Lowell Park	21556	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	7.789	Lowell Park	Local Park 2	4
1848	1848	1847	{"type": "Polygon", "coordinates": [[[-119.06364, 35.30097], [-119.06363, 35.30281], [-119.06336, 35.30281], [-119.06335, 35.30314], [-119.06185, 35.30313], [-119.06178, 35.30308], [-119.0618, 35.30095], [-119.06364, 35.30097]]]}	Open Access 1	15806	Seasons Park	25269	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	9.786	Seasons Park	Local Park 2	4
1852	1852	1851	{"type": "Polygon", "coordinates": [[[-119.08385, 35.30273], [-119.08229, 35.30339], [-119.08218, 35.30485], [-119.082, 35.30482], [-119.08163, 35.30473], [-119.08113, 35.30457], [-119.07997, 35.30404], [-119.07995, 35.30395], [-119.08142, 35.30189], [-119.08327, 35.30222], [-119.08343, 35.30228], [-119.08359, 35.30236], [-119.08381, 35.30261], [-119.08385, 35.30273]]]}	Open Access 1	15821	Silver Creek Park	25485	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	14.436	Silver Creek Park	Local Park 2	4
1853	1853	1852	{"type": "Polygon", "coordinates": [[[-118.94539, 35.40501], [-118.94194, 35.40505], [-118.94195, 35.40379], [-118.94538, 35.40375], [-118.94539, 35.40501]]]}	Open Access 1	15841	University Park	26685	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	10.772	University Park	Local Park 2	4
2012	2012	2011	{"type": "MultiPolygon", "coordinates": [[[[-119.04066, 35.38085], [-119.03996, 35.38135], [-119.03996, 35.38137], [-119.04001, 35.38139], [-119.03999, 35.3814], [-119.03994, 35.38136], [-119.03887, 35.38086], [-119.03876, 35.38068], [-119.03878, 35.37921], [-119.03902, 35.37912], [-119.03902, 35.37941], [-119.03905, 35.37966], [-119.03919, 35.38019], [-119.0393, 35.38037], [-119.03946, 35.38055], [-119.03971, 35.38073], [-119.03995, 35.38083], [-119.04029, 35.38088], [-119.04066, 35.38085]]], [[[-119.0408, 35.37833], [-119.04077, 35.37851], [-119.04078, 35.37858], [-119.04084, 35.37869], [-119.04113, 35.379], [-119.0413, 35.37924], [-119.0414, 35.37947], [-119.04145, 35.37963], [-119.04145, 35.37973], [-119.04147, 35.37981], [-119.04146, 35.38004], [-119.04133, 35.38029], [-119.04124, 35.38041], [-119.04089, 35.38068], [-119.04074, 35.38073], [-119.04044, 35.38078], [-119.0402, 35.38078], [-119.03998, 35.38073], [-119.03971, 35.3806], [-119.03947, 35.38041], [-119.03938, 35.38029], [-119.03928, 35.38005], [-119.03919, 35.37972], [-119.03914, 35.37927], [-119.03916, 35.37887], [-119.03922, 35.37859], [-119.03924, 35.37836], [-119.03931, 35.3783], [-119.03989, 35.37827], [-119.04073, 35.37827], [-119.0408, 35.37833]]], [[[-119.04392, 35.37812], [-119.04261, 35.37937], [-119.04157, 35.38017], [-119.04156, 35.3801], [-119.04159, 35.37994], [-119.04158, 35.3798], [-119.04152, 35.37946], [-119.04139, 35.37918], [-119.04132, 35.37907], [-119.04089, 35.37855], [-119.04094, 35.37832], [-119.04101, 35.37828], [-119.04195, 35.37828], [-119.04222, 35.37886], [-119.04252, 35.37876], [-119.04232, 35.37827], [-119.04295, 35.37829], [-119.04306, 35.37836], [-119.04317, 35.37837], [-119.04326, 35.37834], [-119.04331, 35.37827], [-119.04329, 35.3782], [-119.04376, 35.37811], [-119.04392, 35.37812]]]]}	Open Access 1	15400	Beach Park	15907	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	20.975	Beach Park	Local Park 2	4
2033	2033	2032	{"type": "Polygon", "coordinates": [[[-119.10222, 35.31481], [-119.10201, 35.31491], [-119.1019, 35.31494], [-119.10156, 35.31509], [-119.10071, 35.31532], [-119.09985, 35.31547], [-119.09901, 35.31553], [-119.09895, 35.31548], [-119.09894, 35.31394], [-119.09901, 35.31388], [-119.09963, 35.31383], [-119.10035, 35.31369], [-119.10092, 35.31351], [-119.10133, 35.31334], [-119.10222, 35.31481]]]}	Open Access 1	15525	Campus Park South	16789	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	12.103	Campus Park South	Local Park 2	4
2040	2040	2039	{"type": "MultiPolygon", "coordinates": [[[[-119.01395, 35.37273], [-119.01395, 35.37311], [-119.01318, 35.37311], [-119.01346, 35.37273], [-119.01395, 35.37273]]], [[[-119.05443, 35.35901], [-119.05445, 35.36059], [-119.05436, 35.36107], [-119.05426, 35.36139], [-119.05419, 35.36153], [-119.05255, 35.3611], [-119.05321, 35.35937], [-119.05339, 35.359], [-119.05351, 35.35899], [-119.05443, 35.35901]]]]}	Open Access 1	15572	Centennial Park	17017	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	9.321	Centennial Park	Local Park 2	4
2064	2064	2063	{"type": "Polygon", "coordinates": [[[-119.0362, 35.37357], [-119.03618, 35.37524], [-119.03409, 35.37523], [-119.03411, 35.37355], [-119.0362, 35.37357]]]}	Open Access 1	15713	Jastro Park	20371	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	8.712	Jastro Park	Local Park 2	4
2070	2070	2069	{"type": "MultiPolygon", "coordinates": [[[[-119.09431, 35.35724], [-119.0943, 35.35725], [-119.09426, 35.35729], [-119.09431, 35.35724], [-119.09431, 35.35724]]], [[[-119.08834, 35.36239], [-119.08786, 35.36246], [-119.08722, 35.36249], [-119.08654, 35.36248], [-119.0861, 35.36243], [-119.08543, 35.36232], [-119.08164, 35.36152], [-119.08424, 35.36153], [-119.08834, 35.36239]]], [[[-119.02713, 35.39614], [-119.02712, 35.39635], [-119.02711, 35.39672], [-119.02713, 35.39614]]], [[[-119.02674, 35.39741], [-119.02674, 35.39755], [-119.02672, 35.39763], [-119.02654, 35.39763], [-119.02674, 35.39741]]], [[[-119.02641, 35.39791], [-119.02621, 35.39794], [-119.02607, 35.39794], [-119.02606, 35.39785], [-119.02599, 35.39775], [-119.02607, 35.39773], [-119.02621, 35.39763], [-119.0263, 35.39769], [-119.02635, 35.39779], [-119.02636, 35.39787], [-119.02641, 35.39791]]], [[[-119.02178, 35.39907], [-119.02148, 35.39921], [-119.0203, 35.40001], [-119.01991, 35.40029], [-119.01945, 35.40047], [-119.01908, 35.40058], [-119.01919, 35.4005], [-119.01939, 35.40045], [-119.01982, 35.4003], [-119.02163, 35.39909], [-119.02178, 35.39907]]], [[[-119.0052, 35.40238], [-119.00401, 35.4033], [-119.00212, 35.40409], [-119.00081, 35.40484], [-118.99972, 35.40551], [-118.99971, 35.40526], [-118.99957, 35.40533], [-118.99936, 35.40547], [-118.99862, 35.40627], [-118.99861, 35.40506], [-118.99977, 35.40441], [-118.9999, 35.40409], [-119.00016, 35.40412], [-119.0005, 35.40394], [-119.00138, 35.40357], [-119.00203, 35.40325], [-119.00299, 35.4029], [-119.00299, 35.40318], [-119.00301, 35.40319], [-119.00346, 35.40299], [-119.00389, 35.40272], [-119.00484, 35.402], [-119.00497, 35.40202], [-119.00508, 35.40236], [-119.0052, 35.40238]]], [[[-119.13374, 35.35293], [-119.13363, 35.35294], [-119.13062, 35.35428], [-119.13061, 35.3543], [-119.13074, 35.35449], [-119.13061, 35.35455], [-119.13046, 35.35455], [-119.13003, 35.35397], [-119.12984, 35.35354], [-119.12785, 35.35442], [-119.12785, 35.35504], [-119.12311, 35.35657], [-119.11618, 35.35764], [-119.11612, 35.35706], [-119.11601, 35.35648], [-119.11592, 35.3561], [-119.11576, 35.35554], [-119.11551, 35.35554], [-119.11539, 35.35555], [-119.11555, 35.35612], [-119.11568, 35.35668], [-119.11577, 35.35724], [-119.11582, 35.35769], [-119.11452, 35.3579], [-119.11053, 35.36103], [-119.1049, 35.36116], [-119.10437, 35.36116], [-119.10436, 35.36109], [-119.09785, 35.36107], [-119.09764, 35.36108], [-119.09737, 35.36114], [-119.09718, 35.36121], [-119.09698, 35.36131], [-119.09696, 35.36129], [-119.09687, 35.36135], [-119.09355, 35.36143], [-119.09347, 35.36155], [-119.09348, 35.36156], [-119.09459, 35.36157], [-119.09459, 35.36268], [-119.09416, 35.36296], [-119.09398, 35.36311], [-119.09385, 35.36326], [-119.09223, 35.36556], [-119.09223, 35.36562], [-119.09213, 35.36569], [-119.0919, 35.36361], [-119.09187, 35.36319], [-119.09171, 35.36321], [-119.09155, 35.36319], [-119.09151, 35.36321], [-119.09153, 35.36353], [-119.09161, 35.36416], [-119.09157, 35.36419], [-119.09159, 35.36442], [-119.09045, 35.36329], [-119.09026, 35.36337], [-119.0901, 35.36339], [-119.09005, 35.36341], [-119.09043, 35.36378], [-119.08865, 35.36378], [-119.08848, 35.36383], [-119.08808, 35.36389], [-119.08752, 35.3639], [-119.08735, 35.36389], [-119.08687, 35.36377], [-119.08673, 35.36377], [-119.08671, 35.36622], [-119.08335, 35.36622], [-119.08335, 35.36497], [-119.08089, 35.36464], [-119.08029, 35.36422], [-119.07864, 35.36428], [-119.0774, 35.36467], [-119.07576, 35.36459], [-119.07448, 35.36498], [-119.07448, 35.36875], [-119.06279, 35.36871], [-119.06263, 35.36886], [-119.06253, 35.36901], [-119.06247, 35.36926], [-119.06239, 35.36948], [-119.06225, 35.36962], [-119.06209, 35.36973], [-119.06177, 35.36986], [-119.06158, 35.36997], [-119.06101, 35.37033], [-119.06067, 35.37065], [-119.06059, 35.37074], [-119.06026, 35.37097], [-119.0599, 35.37114], [-119.05914, 35.37136], [-119.05893, 35.37144], [-119.05823, 35.37175], [-119.05808, 35.37184], [-119.05781, 35.37207], [-119.05763, 35.37232], [-119.05742, 35.37269], [-119.05726, 35.37289], [-119.05715, 35.37298], [-119.05709, 35.37306], [-119.05695, 35.37315], [-119.05687, 35.37307], [-119.05674, 35.373], [-119.05658, 35.37294], [-119.05657, 35.37493], [-119.05594, 35.37539], [-119.05581, 35.37544], [-119.05568, 35.37547], [-119.05359, 35.37547], [-119.05321, 35.3755], [-119.05289, 35.37556], [-119.05249, 35.37567], [-119.05214, 35.37582], [-119.05198, 35.3759], [-119.05207, 35.37591], [-119.052, 35.37595], [-119.05198, 35.37594], [-119.05114, 35.37639], [-119.05074, 35.3759], [-119.05022, 35.37614], [-119.04953, 35.37652], [-119.04924, 35.37677], [-119.04864, 35.37709], [-119.04808, 35.37736], [-119.0469, 35.37804], [-119.04604, 35.37857], [-119.04547, 35.37926], [-119.04527, 35.37926], [-119.04501, 35.37947], [-119.04489, 35.3784], [-119.04487, 35.37839], [-119.04387, 35.37919], [-119.04372, 35.38069], [-119.04363, 35.38069], [-119.04151, 35.38209], [-119.04043, 35.38159], [-119.04006, 35.38187], [-119.04006, 35.38188], [-119.04113, 35.38237], [-119.03992, 35.38317], [-119.041, 35.38318], [-119.041, 35.38326], [-119.04027, 35.38326], [-119.04025, 35.38336], [-119.03974, 35.38359], [-119.03893, 35.3844], [-119.03572, 35.38927], [-119.03545, 35.38958], [-119.03476, 35.39015], [-119.03449, 35.39044], [-119.03436, 35.39064], [-119.03426, 35.39084], [-119.03387, 35.39229], [-119.0339, 35.39231], [-119.03382, 35.39262], [-119.03344, 35.39256], [-119.03308, 35.39335], [-119.03283, 35.39442], [-119.03169, 35.39585], [-119.03036, 35.39485], [-119.03012, 35.39522], [-119.03147, 35.39624], [-119.03025, 35.39759], [-119.02906, 35.39668], [-119.02876, 35.39691], [-119.02853, 35.39702], [-119.02934, 35.39764], [-119.02971, 35.39765], [-119.02993, 35.39773], [-119.03099, 35.39862], [-119.02983, 35.39908], [-119.0267, 35.39991], [-119.02663, 35.39997], [-119.02533, 35.40015], [-119.02437, 35.4005], [-119.02319, 35.40136], [-119.02135, 35.40291], [-119.02108, 35.40309], [-119.02108, 35.40332], [-119.02058, 35.40356], [-119.01998, 35.40228], [-119.01964, 35.40245], [-119.01941, 35.40267], [-119.01933, 35.40287], [-119.01928, 35.40308], [-119.01921, 35.40362], [-119.01913, 35.40387], [-119.01868, 35.40416], [-119.01844, 35.40428], [-119.0181, 35.40451], [-119.01779, 35.40466], [-119.01745, 35.40476], [-119.01723, 35.40485], [-119.01695, 35.40502], [-119.01674, 35.40511], [-119.01668, 35.40515], [-119.01628, 35.40519], [-119.01593, 35.40524], [-119.01569, 35.40538], [-119.01551, 35.40553], [-119.01525, 35.4057], [-119.01501, 35.40577], [-119.01467, 35.4058], [-119.01449, 35.40587], [-119.0144, 35.40598], [-119.01417, 35.40604], [-119.01394, 35.40608], [-119.01341, 35.40625], [-119.01297, 35.40644], [-119.01261, 35.40664], [-119.01239, 35.40677], [-119.01232, 35.4069], [-119.01206, 35.40694], [-119.0117, 35.40693], [-119.01084, 35.40678], [-119.01075, 35.40675], [-119.0106, 35.40691], [-119.01047, 35.40702], [-119.01034, 35.40706], [-119.01019, 35.40707], [-119.0101, 35.40711], [-119.00993, 35.4071], [-119.00975, 35.40718], [-119.00947, 35.4069], [-119.0076, 35.40481], [-119.0093, 35.40411], [-119.00883, 35.40333], [-119.00932, 35.40335], [-119.01019, 35.40331], [-119.01215, 35.40229], [-119.01452, 35.40157], [-119.01632, 35.40071], [-119.01701, 35.40056], [-119.01747, 35.40059], [-119.01847, 35.40098], [-119.01903, 35.40061], [-119.01911, 35.40095], [-119.01956, 35.40177], [-119.01966, 35.40177], [-119.01975, 35.40174], [-119.01982, 35.40161], [-119.01976, 35.40142], [-119.01976, 35.40134], [-119.01979, 35.40127], [-119.02002, 35.40099], [-119.02024, 35.4008], [-119.02027, 35.40073], [-119.02043, 35.40073], [-119.02059, 35.40069], [-119.02072, 35.40067], [-119.02083, 35.40063], [-119.02085, 35.40057], [-119.02094, 35.4005], [-119.02113, 35.40045], [-119.02125, 35.40031], [-119.02125, 35.40024], [-119.02138, 35.40017], [-119.0215, 35.40012], [-119.02169, 35.40012], [-119.02189, 35.40007], [-119.02206, 35.39993], [-119.02236, 35.39976], [-119.02263, 35.39968], [-119.02279, 35.39968], [-119.02294, 35.39965], [-119.02381, 35.39966], [-119.02404, 35.39963], [-119.02439, 35.39951], [-119.02454, 35.39935], [-119.02467, 35.39929], [-119.02481, 35.39928], [-119.02489, 35.39919], [-119.02512, 35.39905], [-119.02529, 35.39889], [-119.02556, 35.39872], [-119.02569, 35.39859], [-119.02574, 35.39843], [-119.02589, 35.39812], [-119.02594, 35.39804], [-119.0261, 35.39804], [-119.02645, 35.39906], [-119.02658, 35.39912], [-119.0268, 35.39902], [-119.02684, 35.39878], [-119.027, 35.39846], [-119.02705, 35.39832], [-119.02715, 35.39817], [-119.02735, 35.39792], [-119.02762, 35.39767], [-119.0278, 35.39747], [-119.02821, 35.39709], [-119.02868, 35.39679], [-119.02842, 35.39659], [-119.02867, 35.39641], [-119.02868, 35.39639], [-119.0273, 35.39534], [-119.0279, 35.39354], [-119.0298, 35.39498], [-119.02999, 35.39457], [-119.02933, 35.39407], [-119.03095, 35.39315], [-119.03268, 35.38893], [-119.03506, 35.38556], [-119.03725, 35.3837], [-119.03812, 35.38299], [-119.03859, 35.38267], [-119.03887, 35.38259], [-119.03915, 35.38237], [-119.03969, 35.38188], [-119.03973, 35.38182], [-119.03966, 35.38169], [-119.04, 35.3814], [-119.03999, 35.38139], [-119.03994, 35.38136], [-119.04066, 35.38085], [-119.04261, 35.37937], [-119.04393, 35.37811], [-119.04397, 35.37811], [-119.04474, 35.3772], [-119.0452, 35.37633], [-119.04521, 35.37622], [-119.04746, 35.37475], [-119.04776, 35.37437], [-119.04856, 35.37403], [-119.04906, 35.37375], [-119.04974, 35.37329], [-119.05034, 35.37295], [-119.05157, 35.37286], [-119.05249, 35.37273], [-119.0534, 35.37254], [-119.05406, 35.37237], [-119.05494, 35.37209], [-119.05558, 35.37184], [-119.05641, 35.37149], [-119.05701, 35.37119], [-119.05759, 35.37085], [-119.05796, 35.37062], [-119.05867, 35.37013], [-119.06307, 35.36666], [-119.06374, 35.3662], [-119.06408, 35.36591], [-119.06461, 35.36558], [-119.06555, 35.36508], [-119.06608, 35.36481], [-119.06693, 35.36445], [-119.06751, 35.36422], [-119.06808, 35.36402], [-119.07566, 35.36175], [-119.07651, 35.36155], [-119.07702, 35.36146], [-119.07771, 35.36138], [-119.07841, 35.36133], [-119.07912, 35.36133], [-119.08016, 35.36139], [-119.08052, 35.36144], [-119.08137, 35.36158], [-119.08556, 35.36248], [-119.08649, 35.36261], [-119.08732, 35.36262], [-119.08778, 35.36259], [-119.08824, 35.36254], [-119.0887, 35.36246], [-119.08881, 35.36242], [-119.08904, 35.36238], [-119.09009, 35.36211], [-119.09077, 35.36199], [-119.09135, 35.36194], [-119.09182, 35.36192], [-119.09207, 35.36101], [-119.09219, 35.36047], [-119.09223, 35.35999], [-119.09224, 35.35945], [-119.09242, 35.35944], [-119.0958, 35.35593], [-119.09588, 35.35588], [-119.09593, 35.35582], [-119.09605, 35.35572], [-119.09644, 35.35544], [-119.0967, 35.35529], [-119.09697, 35.35517], [-119.09726, 35.35508], [-119.09752, 35.35504], [-119.10187, 35.35502], [-119.10338, 35.35499], [-119.1036, 35.35496], [-119.10373, 35.35492], [-119.10345, 35.35512], [-119.10673, 35.35599], [-119.10726, 35.35605], [-119.11347, 35.35537], [-119.1137, 35.35529], [-119.11872, 35.35304], [-119.11873, 35.35211], [-119.11959, 35.35145], [-119.12028, 35.35097], [-119.12029, 35.35088], [-119.12083, 35.35044], [-119.12107, 35.3503], [-119.12123, 35.35017], [-119.12138, 35.35008], [-119.12148, 35.35008], [-119.12167, 35.34995], [-119.12168, 35.34985], [-119.122, 35.34967], [-119.12232, 35.34951], [-119.1225, 35.34944], [-119.12278, 35.34937], [-119.12298, 35.34929], [-119.12335, 35.34921], [-119.1234, 35.34913], [-119.12354, 35.3491], [-119.12367, 35.34905], [-119.12402, 35.34898], [-119.12475, 35.3489], [-119.12484, 35.34896], [-119.12502, 35.34892], [-119.12509, 35.34885], [-119.1255, 35.34885], [-119.12571, 35.34885], [-119.12655, 35.34895], [-119.12676, 35.34898], [-119.12696, 35.34904], [-119.12705, 35.34912], [-119.12687, 35.34951], [-119.1268, 35.3497], [-119.12672, 35.34974], [-119.12665, 35.34989], [-119.12679, 35.35006], [-119.12653, 35.35088], [-119.12368, 35.35086], [-119.12258, 35.35175], [-119.12266, 35.35225], [-119.12297, 35.35229], [-119.12489, 35.35236], [-119.12614, 35.35219], [-119.12658, 35.35228], [-119.12806, 35.35122], [-119.12832, 35.35117], [-119.1288, 35.35123], [-119.13109, 35.3512], [-119.13121, 35.35109], [-119.13167, 35.35142], [-119.13311, 35.35234], [-119.13374, 35.35293]], [[-119.03877, 35.38317], [-119.03877, 35.38305], [-119.03858, 35.38316], [-119.03859, 35.38317], [-119.03877, 35.38317]], [[-119.04959, 35.37458], [-119.04882, 35.37431], [-119.0486, 35.37427], [-119.04848, 35.37415], [-119.04813, 35.37429], [-119.04784, 35.37448], [-119.04732, 35.37497], [-119.04696, 35.37516], [-119.04551, 35.37616], [-119.0452, 35.3766], [-119.04485, 35.37733], [-119.04485, 35.37748], [-119.04492, 35.37792], [-119.04492, 35.37801], [-119.04508, 35.37805], [-119.04545, 35.37772], [-119.04567, 35.37758], [-119.04662, 35.37681], [-119.04681, 35.37673], [-119.04715, 35.37664], [-119.04747, 35.37659], [-119.04788, 35.37643], [-119.04815, 35.37629], [-119.04859, 35.37584], [-119.04863, 35.37569], [-119.04879, 35.3755], [-119.04893, 35.37543], [-119.04904, 35.37533], [-119.04903, 35.37532], [-119.04886, 35.37525], [-119.04888, 35.37516], [-119.04914, 35.37501], [-119.0492, 35.37487], [-119.04964, 35.37462], [-119.04959, 35.37458]]]]}	Open Access 1	15731	Kern River Parkway Park	425	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/Kern_River_Parkway.htm	Kern 36	1162.113	Kern River Parkway Park	Local Park 2	4
2072	2072	2071	{"type": "Polygon", "coordinates": [[[-119.08788, 35.34847], [-119.08765, 35.34958], [-119.08739, 35.34955], [-119.0873, 35.34987], [-119.08642, 35.34968], [-119.08619, 35.34962], [-119.08615, 35.34959], [-119.08615, 35.34954], [-119.08649, 35.349], [-119.08668, 35.34876], [-119.08709, 35.34828], [-119.08715, 35.34827], [-119.08753, 35.34839], [-119.08788, 35.34847]]]}	Open Access 1	15736	Kroll Park	20725	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	4.23	Kroll Park	Local Park 2	4
2089	2089	2088	{"type": "Polygon", "coordinates": [[[-119.08688, 35.35815], [-119.0863, 35.35809], [-119.08464, 35.35808], [-119.08465, 35.35618], [-119.08519, 35.35581], [-119.08537, 35.35573], [-119.08562, 35.35569], [-119.08616, 35.35571], [-119.08618, 35.35651], [-119.08619, 35.35658], [-119.08625, 35.35674], [-119.08632, 35.35687], [-119.08646, 35.35703], [-119.08666, 35.35717], [-119.08677, 35.35726], [-119.08683, 35.35734], [-119.08688, 35.35746], [-119.08692, 35.35753], [-119.08695, 35.35775], [-119.08688, 35.35815]]]}	Open Access 1	15782	Quailwood Park	24054	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	10.603	Quailwood Park	Local Park 2	4
2093	2093	2092	{"type": "Polygon", "coordinates": [[[-119.05003, 35.27664], [-119.05002, 35.27782], [-119.04797, 35.27782], [-119.04796, 35.27669], [-119.04803, 35.27664], [-119.05003, 35.27664]]]}	Open Access 1	15831	Stonecreek Park	25884	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	6.07	Stonecreek Park	Local Park 2	4
4071	4071	4070	{"type": "Polygon", "coordinates": [[[-118.84576, 35.40858], [-118.84563, 35.40886], [-118.84545, 35.40907], [-118.84519, 35.40927], [-118.84487, 35.40941], [-118.84463, 35.40947], [-118.84433, 35.4095], [-118.84432, 35.40956], [-118.84396, 35.40956], [-118.8436, 35.40926], [-118.84359, 35.40874], [-118.84447, 35.40874], [-118.84447, 35.4086], [-118.84576, 35.40858]]]}	Open Access 1	44489	Solera Gardens Park	25599	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	3.672	Solera Gardens Park	Local Park 2	4
4089	4089	4088	{"type": "Polygon", "coordinates": [[[-119.04966, 35.37461], [-119.0492, 35.37487], [-119.04914, 35.37501], [-119.04888, 35.37516], [-119.04886, 35.37525], [-119.04905, 35.37533], [-119.04893, 35.37543], [-119.04879, 35.3755], [-119.04863, 35.37569], [-119.04859, 35.37584], [-119.04815, 35.37629], [-119.04788, 35.37643], [-119.04747, 35.37659], [-119.04715, 35.37664], [-119.04681, 35.37673], [-119.04662, 35.37681], [-119.04567, 35.37758], [-119.04545, 35.37772], [-119.04508, 35.37805], [-119.04492, 35.37801], [-119.04492, 35.37792], [-119.04485, 35.37748], [-119.04485, 35.37733], [-119.0452, 35.3766], [-119.04551, 35.37616], [-119.04696, 35.37516], [-119.04732, 35.37497], [-119.04784, 35.37448], [-119.04813, 35.37429], [-119.04848, 35.37415], [-119.0486, 35.37427], [-119.04882, 35.37431], [-119.04966, 35.37461]]]}	Open Access 1	44507	Yokuts Park	27774	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	16.385	Yokuts Park	Local Park 2	4
5186	5186	5185	{"type": "Polygon", "coordinates": [[[-119.02991, 35.33394], [-119.02831, 35.33395], [-119.0283, 35.33234], [-119.0299, 35.33233], [-119.02991, 35.33394]]]}	Open Access 1	15867	Wilson Park	27606	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	6.42	Wilson Park	Local Park 2	4
5341	5341	5340	{"type": "Polygon", "coordinates": [[[-119.09118, 35.33179], [-119.09102, 35.33191], [-119.09102, 35.33198], [-119.09091, 35.33199], [-119.09089, 35.33192], [-119.0906, 35.33184], [-119.09057, 35.33144], [-119.08986, 35.33144], [-119.08986, 35.33028], [-119.09117, 35.33028], [-119.09118, 35.33179]]]}	Open Access 1	15855	Westwold Park	27436	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	4.455	Westwold Park	Local Park 2	4
5343	5343	5342	{"type": "Polygon", "coordinates": [[[-119.11756, 35.35004], [-119.11751, 35.35008], [-119.11691, 35.35006], [-119.11646, 35.34992], [-119.11632, 35.34986], [-119.11616, 35.34976], [-119.11592, 35.34954], [-119.11571, 35.34922], [-119.11566, 35.34907], [-119.11564, 35.34891], [-119.11564, 35.34882], [-119.11567, 35.34856], [-119.11613, 35.34859], [-119.11752, 35.34862], [-119.11755, 35.34892], [-119.11756, 35.35004]]]}	Open Access 1	15875	Windsor Park	27637	1019	Bakersfield, City of 248	City 2	City Agency 2	http://www.bakersfieldcity.us/recreation/	City 2	1019	Bakersfield, City of 244	City 2	City Agency 2		Kern 36	5.964	Windsor Park	Local Park 2	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]);