calands: units_with_maps: 18 rows where AGNCY_LEV = 3, DES_TP = 2 and MNG

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

18 rows where AGNCY_LEV = 3, DES_TP = 2 and MNG_AGENCY = 165

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
431	431	430	{"type": "Polygon", "coordinates": [[[-117.28428, 33.76243], [-117.28273, 33.76246], [-117.2827, 33.76182], [-117.28324, 33.76181], [-117.28324, 33.76162], [-117.28425, 33.76159], [-117.28428, 33.76243]]]}	Open Access 1	48878	Goodhope Park	33599	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	3.022	Goodhope Park	Local Park 2	4
1099	1099	1098	{"type": "Polygon", "coordinates": [[[-116.95489, 33.98303], [-116.95487, 33.98323], [-116.9546, 33.98346], [-116.95406, 33.98442], [-116.95376, 33.98457], [-116.95354, 33.98473], [-116.95305, 33.98462], [-116.9529, 33.9843], [-116.95287, 33.98398], [-116.95261, 33.98389], [-116.95215, 33.98347], [-116.952, 33.98315], [-116.95168, 33.98291], [-116.95142, 33.98279], [-116.95117, 33.98291], [-116.95089, 33.98273], [-116.95074, 33.98224], [-116.9509, 33.98148], [-116.95086, 33.98132], [-116.95083, 33.98091], [-116.95085, 33.9806], [-116.95075, 33.98032], [-116.95062, 33.97963], [-116.95038, 33.97899], [-116.95009, 33.9787], [-116.95005, 33.97853], [-116.94976, 33.97837], [-116.94969, 33.97798], [-116.94962, 33.97766], [-116.94941, 33.97749], [-116.94973, 33.97706], [-116.95035, 33.97679], [-116.95069, 33.97669], [-116.9508, 33.97634], [-116.9513, 33.9761], [-116.9513, 33.97605], [-116.95342, 33.97612], [-116.95481, 33.97613], [-116.95449, 33.97627], [-116.95418, 33.97658], [-116.95416, 33.97729], [-116.95406, 33.97855], [-116.95382, 33.97883], [-116.95364, 33.97944], [-116.95373, 33.98027], [-116.95402, 33.9808], [-116.95406, 33.98136], [-116.95422, 33.98197], [-116.9546, 33.98262], [-116.95489, 33.98303]]]}	Open Access 1	6503	Bogart County Park	16226	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	70.98	Bogart County Park	Local Park 2	4
3697	3697	3696	{"type": "Polygon", "coordinates": [[[-117.43583, 33.96849], [-117.43536, 33.96974], [-117.43501, 33.97033], [-117.43446, 33.97086], [-117.43443, 33.97085], [-117.43427, 33.971], [-117.43171, 33.97095], [-117.43118, 33.97227], [-117.433, 33.97287], [-117.43293, 33.9733], [-117.43265, 33.97349], [-117.43197, 33.97466], [-117.43188, 33.97477], [-117.43138, 33.97492], [-117.43111, 33.97531], [-117.43102, 33.97528], [-117.43086, 33.97546], [-117.4307, 33.9756], [-117.43, 33.97602], [-117.4298, 33.9762], [-117.42956, 33.97649], [-117.42946, 33.97658], [-117.42929, 33.97668], [-117.42923, 33.97697], [-117.429, 33.97716], [-117.42792, 33.97905], [-117.42513, 33.97828], [-117.42577, 33.97715], [-117.42647, 33.97737], [-117.42771, 33.97462], [-117.42799, 33.97381], [-117.42717, 33.97361], [-117.42691, 33.97415], [-117.42674, 33.9741], [-117.42662, 33.97435], [-117.42677, 33.97442], [-117.42548, 33.97708], [-117.42489, 33.97821], [-117.42302, 33.97768], [-117.42279, 33.9779], [-117.4225, 33.9787], [-117.4225, 33.97903], [-117.4218, 33.98023], [-117.42087, 33.97983], [-117.4201, 33.97938], [-117.41876, 33.97847], [-117.42046, 33.97761], [-117.42057, 33.97678], [-117.41981, 33.97625], [-117.41726, 33.97756], [-117.41297, 33.97467], [-117.41574, 33.97359], [-117.41586, 33.97327], [-117.41563, 33.97311], [-117.41663, 33.9693], [-117.41524, 33.96978], [-117.41515, 33.97005], [-117.41285, 33.97113], [-117.41121, 33.96974], [-117.41244, 33.96917], [-117.41288, 33.96841], [-117.41392, 33.96765], [-117.41477, 33.96672], [-117.41487, 33.96652], [-117.4155, 33.96578], [-117.41588, 33.96605], [-117.41622, 33.96583], [-117.41621, 33.96581], [-117.4157, 33.96541], [-117.41653, 33.96498], [-117.41658, 33.96504], [-117.41774, 33.96484], [-117.42157, 33.96549], [-117.42287, 33.96409], [-117.42349, 33.96386], [-117.42531, 33.96378], [-117.42585, 33.96357], [-117.42679, 33.96353], [-117.42722, 33.96266], [-117.42797, 33.9627], [-117.42798, 33.96274], [-117.42896, 33.96279], [-117.43583, 33.96849]]]}	Open Access 1	30004	Martha McLean Anza Narrows Park	9503	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3	http://santaanarivertrail.org/home.html	Riverside 10	615.445	Martha McLean Anza Narrows Park	Local Park 2	4
4081	4081	4080	{"type": "Polygon", "coordinates": [[[-117.12462, 33.54378], [-117.12448, 33.54508], [-117.12437, 33.54616], [-117.12388, 33.54512], [-117.12356, 33.54429], [-117.12362, 33.54435], [-117.12371, 33.54437], [-117.12389, 33.54459], [-117.12438, 33.54458], [-117.12447, 33.54378], [-117.12462, 33.54378]], [[-117.12427, 33.54564], [-117.12424, 33.54563], [-117.1242, 33.54564], [-117.12424, 33.54573], [-117.12426, 33.54572], [-117.12427, 33.54564]]]}	Open Access 1	48876	Overlook Park	33597	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	2.188	Overlook Park	Local Park 2	4
4206	4206	4205	{"type": "Polygon", "coordinates": [[[-117.34495, 33.64111], [-117.34461, 33.64156], [-117.34354, 33.6409], [-117.34412, 33.64026], [-117.34444, 33.64045], [-117.34428, 33.64065], [-117.34495, 33.64111]]]}	Open Access 1	48872	Perret Park	33593	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	2.063	Perret Park	Local Park 2	4
4875	4875	4874	{"type": "Polygon", "coordinates": [[[-114.62963, 33.43504], [-114.62963, 33.43504], [-114.62692, 33.43503], [-114.6273, 33.43394], [-114.62962, 33.4339], [-114.62963, 33.43504]]]}	Open Access 1	14733	Thirty Eighth Street County Park	26304	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	7.153	Thirty Eighth Street County Park	Local Park 2	4
6259	6259	6258	{"type": "Polygon", "coordinates": [[[-117.14043, 33.54708], [-117.14033, 33.54714], [-117.14015, 33.54747], [-117.14, 33.54759], [-117.1397, 33.54789], [-117.13919, 33.54827], [-117.13902, 33.54831], [-117.13885, 33.54827], [-117.13872, 33.54818], [-117.13868, 33.54811], [-117.13866, 33.54803], [-117.13865, 33.54803], [-117.13819, 33.54827], [-117.13775, 33.54854], [-117.1376, 33.54869], [-117.13734, 33.54913], [-117.13712, 33.54933], [-117.13684, 33.54927], [-117.13672, 33.54927], [-117.13643, 33.54949], [-117.13623, 33.54973], [-117.13611, 33.54969], [-117.13681, 33.54916], [-117.13676, 33.5491], [-117.13698, 33.54886], [-117.13707, 33.54872], [-117.13719, 33.54846], [-117.13729, 33.54833], [-117.13743, 33.54823], [-117.13791, 33.548], [-117.13812, 33.54786], [-117.13818, 33.54775], [-117.13821, 33.54764], [-117.1382, 33.54752], [-117.13815, 33.54746], [-117.13968, 33.54619], [-117.14015, 33.54657], [-117.13848, 33.54781], [-117.13848, 33.54782], [-117.13852, 33.54785], [-117.1402, 33.54661], [-117.14042, 33.54677], [-117.14043, 33.54708]]]}	Open Access 1	48875	Guenther Willows Park	33596	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	8.902	Guenther Willows Park	Local Park 2	4
6266	6266	6265	{"type": "Polygon", "coordinates": [[[-117.32215, 34.01575], [-117.32169, 34.01627], [-117.32155, 34.01645], [-117.32148, 34.01656], [-117.3214, 34.01675], [-117.32125, 34.01722], [-117.32099, 34.01872], [-117.32092, 34.01895], [-117.32079, 34.01927], [-117.32066, 34.01927], [-117.32063, 34.01926], [-117.32061, 34.01922], [-117.32022, 34.01922], [-117.32021, 34.01866], [-117.32021, 34.01575], [-117.32215, 34.01575]]]}	Open Access 1	48879	Highgrove Community Park	33600	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3	https://rivcoccsd.org/new-page-2	Riverside 10	9.518	Highgrove Community Park	Local Park 2	4
6276	6276	6275	{"type": "Polygon", "coordinates": [[[-117.51151, 33.77707], [-117.51138, 33.77733], [-117.51089, 33.77824], [-117.51044, 33.77898], [-117.50991, 33.77901], [-117.5099, 33.77885], [-117.50991, 33.77865], [-117.50988, 33.77857], [-117.50981, 33.7785], [-117.50971, 33.77848], [-117.50949, 33.77851], [-117.50935, 33.77852], [-117.50932, 33.77819], [-117.50853, 33.77823], [-117.51151, 33.77707]]]}	Open Access 1	48880	Montecito Ranch Park	33601	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	5.314	Montecito Ranch Park	Local Park 2	4
6290	6290	6289	{"type": "Polygon", "coordinates": [[[-117.47088, 33.75654], [-117.47089, 33.75734], [-117.47087, 33.75752], [-117.47083, 33.75766], [-117.47078, 33.75779], [-117.47069, 33.75793], [-117.47059, 33.75805], [-117.47046, 33.75817], [-117.47029, 33.75828], [-117.47011, 33.75837], [-117.46993, 33.75843], [-117.46972, 33.75847], [-117.46952, 33.75849], [-117.46907, 33.75844], [-117.46903, 33.7584], [-117.469, 33.75799], [-117.46894, 33.75779], [-117.46891, 33.75762], [-117.46891, 33.75742], [-117.46893, 33.75725], [-117.46899, 33.75702], [-117.46946, 33.75622], [-117.47088, 33.75654]]]}	Open Access 1	48882	Coral Canyon Park	33603	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3	https://rivcoccsd.org/new-page-2	Riverside 10	9.031	Coral Canyon Park	Local Park 2	4
6369	6369	6368	{"type": "Polygon", "coordinates": [[[-116.68439, 33.67798], [-116.68332, 33.67893], [-116.68325, 33.67922], [-116.68303, 33.67923], [-116.68266, 33.68164], [-116.68233, 33.68175], [-116.68215, 33.68145], [-116.68192, 33.68122], [-116.68198, 33.68044], [-116.68174, 33.68004], [-116.68091, 33.67917], [-116.68038, 33.67794], [-116.67964, 33.67719], [-116.6792, 33.6776], [-116.67885, 33.6784], [-116.67838, 33.67849], [-116.67788, 33.67828], [-116.67766, 33.6776], [-116.67571, 33.67759], [-116.6757, 33.67582], [-116.67894, 33.67586], [-116.6796, 33.67582], [-116.67984, 33.67574], [-116.68008, 33.67574], [-116.68006, 33.67523], [-116.68191, 33.67527], [-116.68211, 33.67525], [-116.68334, 33.67622], [-116.68347, 33.67629], [-116.68439, 33.67742], [-116.68439, 33.67798]]]}	Open Access 1	1753	Herkey Creek Park	19866	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	62.283	Herkey Creek Park	Local Park 2	4
6477	6477	6476	{"type": "Polygon", "coordinates": [[[-116.7286, 33.74804], [-116.72433, 33.74805], [-116.72439, 33.75331], [-116.72419, 33.75332], [-116.72401, 33.75332], [-116.7238, 33.75328], [-116.72363, 33.75324], [-116.72265, 33.75277], [-116.72224, 33.75263], [-116.72198, 33.75258], [-116.72159, 33.75253], [-116.72116, 33.75253], [-116.72079, 33.75257], [-116.72033, 33.75266], [-116.72006, 33.75267], [-116.72007, 33.75162], [-116.72, 33.74448], [-116.72147, 33.74447], [-116.72155, 33.74437], [-116.72169, 33.74442], [-116.72174, 33.74435], [-116.72185, 33.74399], [-116.72191, 33.74398], [-116.72254, 33.74304], [-116.72217, 33.74269], [-116.72259, 33.74237], [-116.72285, 33.74216], [-116.72316, 33.742], [-116.72341, 33.74181], [-116.7237, 33.74169], [-116.72465, 33.74205], [-116.7254, 33.74138], [-116.72574, 33.74058], [-116.72635, 33.74011], [-116.72689, 33.74058], [-116.72747, 33.74026], [-116.72757, 33.74037], [-116.72842, 33.73989], [-116.72855, 33.73978], [-116.72856, 33.74444], [-116.7286, 33.74804]], [[-116.72097, 33.75236], [-116.72113, 33.75235], [-116.72111, 33.75222], [-116.72095, 33.75223], [-116.72097, 33.75236]]]}	Open Access 1	2065	Idyllwild Park	20173	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	183.588	Idyllwild Park	Local Park 2	4
6572	6572	6571	{"type": "MultiPolygon", "coordinates": [[[[-116.74317, 33.79362], [-116.74314, 33.79385], [-116.7431, 33.79399], [-116.74302, 33.79414], [-116.74292, 33.79427], [-116.74278, 33.7944], [-116.74237, 33.79466], [-116.74219, 33.79482], [-116.74206, 33.79497], [-116.74179, 33.79539], [-116.74168, 33.79551], [-116.74155, 33.79559], [-116.74108, 33.7958], [-116.74093, 33.79592], [-116.74092, 33.79375], [-116.74317, 33.79362]]], [[[-116.74967, 33.79645], [-116.74694, 33.79669], [-116.74655, 33.7964], [-116.74644, 33.79628], [-116.74637, 33.79615], [-116.74631, 33.79597], [-116.74625, 33.79529], [-116.74617, 33.7951], [-116.74607, 33.79493], [-116.74588, 33.79475], [-116.74566, 33.79462], [-116.74541, 33.79454], [-116.74513, 33.7945], [-116.74488, 33.79452], [-116.74463, 33.79457], [-116.74437, 33.79468], [-116.74415, 33.79481], [-116.74394, 33.795], [-116.74367, 33.79537], [-116.74353, 33.7955], [-116.74341, 33.79558], [-116.74291, 33.79584], [-116.74266, 33.79603], [-116.74249, 33.79624], [-116.74222, 33.79673], [-116.74212, 33.79683], [-116.74198, 33.79692], [-116.7418, 33.79698], [-116.74162, 33.79699], [-116.74147, 33.79697], [-116.74133, 33.79692], [-116.74118, 33.79683], [-116.74107, 33.7967], [-116.74101, 33.79656], [-116.741, 33.79642], [-116.74104, 33.79624], [-116.74116, 33.79608], [-116.74128, 33.79599], [-116.74169, 33.7958], [-116.74188, 33.79568], [-116.74203, 33.79552], [-116.74233, 33.79506], [-116.74243, 33.79494], [-116.7426, 33.7948], [-116.74296, 33.79457], [-116.74315, 33.79439], [-116.74328, 33.79422], [-116.74337, 33.79403], [-116.74343, 33.79383], [-116.74345, 33.79361], [-116.74964, 33.79325], [-116.74967, 33.79645]]], [[[-116.74653, 33.79671], [-116.74533, 33.79682], [-116.74224, 33.79708], [-116.74237, 33.79698], [-116.74246, 33.79687], [-116.74273, 33.79638], [-116.74281, 33.79627], [-116.74293, 33.79614], [-116.7431, 33.79602], [-116.74357, 33.79578], [-116.74374, 33.79566], [-116.7439, 33.79551], [-116.74416, 33.79514], [-116.74436, 33.79497], [-116.7445, 33.79488], [-116.74468, 33.79481], [-116.74501, 33.79474], [-116.74525, 33.79474], [-116.74548, 33.7948], [-116.74567, 33.79491], [-116.74584, 33.79506], [-116.74592, 33.7952], [-116.74597, 33.79533], [-116.74603, 33.79601], [-116.74608, 33.79622], [-116.74616, 33.79637], [-116.74624, 33.79647], [-116.74636, 33.79658], [-116.74653, 33.79671]]]]}	Open Access 1	3816	Lawler Lodge Park	21114	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	65.857	Lawler Lodge Park	Local Park 2	4
6930	6930	6929	{"type": "Polygon", "coordinates": [[[-117.38678, 33.93378], [-117.38579, 33.93434], [-117.38492, 33.93328], [-117.38591, 33.93272], [-117.38678, 33.93378]]]}	Open Access 1	5826	Washington Park	27271	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	3.904	Washington Park	Local Park 2	4
7766	7766	7765	{"type": "Polygon", "coordinates": [[[-116.73697, 33.76722], [-116.73616, 33.76785], [-116.73441, 33.76766], [-116.73406, 33.7661], [-116.73443, 33.76596], [-116.73465, 33.76583], [-116.73672, 33.76566], [-116.73697, 33.76722]]]}	Open Access 1	8479	Pine Cove County Park	23674	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	12.829	Pine Cove County Park	Local Park 2	4
12519	12519	12518	{"type": "Polygon", "coordinates": [[[-114.53743, 33.67682], [-114.53197, 33.67681], [-114.53248, 33.67467], [-114.53295, 33.67313], [-114.53327, 33.67189], [-114.53329, 33.67168], [-114.53329, 33.67139], [-114.53305, 33.66978], [-114.53407, 33.66976], [-114.53408, 33.66975], [-114.53406, 33.66967], [-114.5349, 33.66965], [-114.53487, 33.66951], [-114.53726, 33.66945], [-114.53743, 33.67682]]]}	Open Access 1	29002	Mayflower Park	21976	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	83.858	Mayflower Park	Local Park 2	4
14673	14673	14672	{"type": "Polygon", "coordinates": [[[-117.12413, 33.54745], [-117.1241, 33.54807], [-117.12362, 33.54832], [-117.12356, 33.54832], [-117.1238, 33.54812], [-117.12375, 33.54797], [-117.1237, 33.54794], [-117.12368, 33.54781], [-117.12365, 33.54779], [-117.12366, 33.54745], [-117.12413, 33.54745]]]}	Open Access 1	48873	Discovery Park	33594	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	0.789	Discovery Park	Local Park 2	4
16907	16907	16906	{"type": "MultiPolygon", "coordinates": [[[[-117.28967, 33.96077], [-117.28341, 33.96053], [-117.2834, 33.9588], [-117.27911, 33.95864], [-117.27924, 33.97577], [-117.27248, 33.97567], [-117.27263, 33.9681], [-117.27025, 33.96821], [-117.26599, 33.96828], [-117.26594, 33.96835], [-117.26596, 33.96841], [-117.26565, 33.96828], [-117.26498, 33.96811], [-117.26462, 33.96804], [-117.26425, 33.968], [-117.26205, 33.96801], [-117.26202, 33.9678], [-117.26195, 33.96753], [-117.26186, 33.96732], [-117.26159, 33.96684], [-117.26154, 33.96669], [-117.2615, 33.96651], [-117.26149, 33.96511], [-117.26157, 33.96459], [-117.26163, 33.964], [-117.26163, 33.96292], [-117.26359, 33.9629], [-117.26364, 33.96109], [-117.26583, 33.96108], [-117.27028, 33.96085], [-117.27022, 33.95383], [-117.26442, 33.95384], [-117.26441, 33.95378], [-117.26332, 33.9538], [-117.26331, 33.95385], [-117.26145, 33.95385], [-117.26146, 33.95309], [-117.26258, 33.9529], [-117.26317, 33.95206], [-117.26383, 33.9523], [-117.26522, 33.95207], [-117.26576, 33.95184], [-117.26609, 33.95135], [-117.26724, 33.95078], [-117.26779, 33.9508], [-117.26829, 33.95058], [-117.26854, 33.95028], [-117.26878, 33.9504], [-117.26915, 33.94959], [-117.26996, 33.9497], [-117.27311, 33.94967], [-117.27372, 33.95019], [-117.27458, 33.95018], [-117.27491, 33.94965], [-117.27769, 33.94962], [-117.27803, 33.94991], [-117.27902, 33.9499], [-117.27903, 33.95], [-117.27972, 33.9496], [-117.28005, 33.94971], [-117.28022, 33.94938], [-117.28036, 33.94942], [-117.28052, 33.94944], [-117.28081, 33.94945], [-117.28075, 33.94974], [-117.27955, 33.95066], [-117.27999, 33.95123], [-117.28068, 33.95157], [-117.28148, 33.95174], [-117.28208, 33.95155], [-117.283, 33.95065], [-117.28318, 33.95073], [-117.28342, 33.95074], [-117.28342, 33.95217], [-117.28268, 33.95219], [-117.28269, 33.95286], [-117.28342, 33.95286], [-117.28341, 33.95706], [-117.28965, 33.95723], [-117.28967, 33.96077]]], [[[-117.27916, 33.97742], [-117.27893, 33.98246], [-117.27681, 33.98251], [-117.2768, 33.98294], [-117.27544, 33.98297], [-117.27543, 33.98193], [-117.27461, 33.98195], [-117.27443, 33.98088], [-117.27461, 33.98005], [-117.27456, 33.97966], [-117.27402, 33.97911], [-117.27302, 33.97818], [-117.27307, 33.9778], [-117.27275, 33.97739], [-117.27916, 33.97742]]], [[[-117.33111, 33.99157], [-117.33111, 33.99602], [-117.33084, 33.99614], [-117.33066, 33.99616], [-117.33057, 33.99616], [-117.33029, 33.9955], [-117.32766, 33.99547], [-117.32624, 33.99648], [-117.32499, 33.9975], [-117.32499, 33.99752], [-117.32524, 33.99752], [-117.32476, 33.99813], [-117.32447, 33.99824], [-117.32441, 33.9983], [-117.32359, 33.9987], [-117.32342, 33.99872], [-117.32334, 33.99881], [-117.32298, 33.99893], [-117.32241, 33.9994], [-117.32241, 33.99911], [-117.3224, 33.9991], [-117.32183, 33.9994], [-117.32136, 33.99961], [-117.32051, 33.99995], [-117.32014, 34.00007], [-117.31975, 34.00017], [-117.31941, 34.00024], [-117.319, 34.00029], [-117.31833, 34.00032], [-117.31842, 33.99984], [-117.3184, 33.99978], [-117.31834, 33.99974], [-117.31829, 33.99972], [-117.3182, 33.99973], [-117.31814, 33.99976], [-117.31782, 34.00012], [-117.31734, 34.00032], [-117.31723, 34.00057], [-117.31686, 34.00093], [-117.31411, 34.00094], [-117.31402, 34.00068], [-117.31401, 33.99955], [-117.31359, 33.99933], [-117.31355, 33.99748], [-117.30501, 33.99733], [-117.30499, 33.99916], [-117.30277, 33.9992], [-117.30277, 34.00006], [-117.30069, 34.00013], [-117.30069, 34.00109], [-117.29847, 34.0011], [-117.29848, 33.99928], [-117.29847, 33.99927], [-117.29735, 33.99929], [-117.29737, 34.00111], [-117.29626, 34.00112], [-117.2962, 33.99748], [-117.28765, 33.99735], [-117.28766, 33.99601], [-117.2878, 33.99587], [-117.2879, 33.99572], [-117.28797, 33.99556], [-117.28798, 33.99533], [-117.28794, 33.99516], [-117.28786, 33.995], [-117.28779, 33.99491], [-117.28757, 33.99469], [-117.28748, 33.99455], [-117.28744, 33.99444], [-117.28741, 33.99422], [-117.28745, 33.99361], [-117.29055, 33.99365], [-117.29056, 33.99364], [-117.2905, 33.98991], [-117.28769, 33.98985], [-117.2878, 33.98673], [-117.28873, 33.98589], [-117.28944, 33.98553], [-117.28984, 33.98428], [-117.29031, 33.9839], [-117.2904, 33.98289], [-117.29019, 33.98193], [-117.28998, 33.97943], [-117.29036, 33.97924], [-117.29085, 33.97918], [-117.29134, 33.97885], [-117.29168, 33.97827], [-117.29167, 33.9777], [-117.29176, 33.97692], [-117.29192, 33.97653], [-117.29239, 33.97614], [-117.29264, 33.97591], [-117.29267, 33.97558], [-117.29645, 33.97553], [-117.30505, 33.9756], [-117.30509, 33.9782], [-117.30856, 33.97827], [-117.30855, 33.97858], [-117.30858, 33.97875], [-117.30862, 33.97892], [-117.30872, 33.97916], [-117.30884, 33.97936], [-117.30899, 33.97955], [-117.30917, 33.97971], [-117.3094, 33.97987], [-117.30942, 33.98245], [-117.30938, 33.98249], [-117.3093, 33.98268], [-117.30891, 33.98257], [-117.30879, 33.98287], [-117.30914, 33.98304], [-117.30946, 33.98353], [-117.30905, 33.98366], [-117.30874, 33.98384], [-117.30854, 33.98408], [-117.30846, 33.98444], [-117.30857, 33.98475], [-117.30826, 33.985], [-117.30838, 33.98514], [-117.30829, 33.9852], [-117.30821, 33.9852], [-117.30776, 33.98526], [-117.30773, 33.98518], [-117.30724, 33.98534], [-117.30683, 33.98541], [-117.30665, 33.98547], [-117.30679, 33.98592], [-117.30691, 33.98608], [-117.30697, 33.98611], [-117.30732, 33.98646], [-117.3074, 33.98659], [-117.30948, 33.98662], [-117.30949, 33.98747], [-117.31157, 33.98746], [-117.31155, 33.98663], [-117.31262, 33.98662], [-117.31249, 33.98677], [-117.31243, 33.98688], [-117.31237, 33.98706], [-117.31236, 33.98718], [-117.31237, 33.98729], [-117.31243, 33.98749], [-117.31256, 33.98768], [-117.31348, 33.98862], [-117.31357, 33.98877], [-117.31362, 33.9889], [-117.31363, 33.98902], [-117.31366, 33.99021], [-117.30935, 33.99019], [-117.3094, 33.99372], [-117.31804, 33.99378], [-117.31805, 33.99021], [-117.32679, 33.99021], [-117.32684, 33.99154], [-117.33111, 33.99157]], [[-117.30635, 33.98599], [-117.30643, 33.98556], [-117.30631, 33.98559], [-117.30517, 33.98554], [-117.30502, 33.98631], [-117.30628, 33.98638], [-117.30635, 33.98599]], [[-117.30536, 33.98103], [-117.30537, 33.98102], [-117.30534, 33.97912], [-117.3051, 33.97911], [-117.30512, 33.98102], [-117.30536, 33.98103]], [[-117.3058, 33.9818], [-117.3058, 33.98178], [-117.30526, 33.98141], [-117.30544, 33.982], [-117.3058, 33.9818]], [[-117.30567, 33.98484], [-117.30566, 33.98473], [-117.30546, 33.98474], [-117.30548, 33.98485], [-117.30567, 33.98484]], [[-117.30653, 33.9817], [-117.30654, 33.98169], [-117.30645, 33.98116], [-117.30591, 33.9812], [-117.306, 33.98175], [-117.30653, 33.9817]], [[-117.30729, 33.98298], [-117.30734, 33.98297], [-117.30724, 33.98263], [-117.3073, 33.98234], [-117.30665, 33.98207], [-117.30658, 33.98394], [-117.3064, 33.98396], [-117.30651, 33.9849], [-117.30667, 33.98515], [-117.30664, 33.98518], [-117.30657, 33.98519], [-117.30653, 33.98526], [-117.30655, 33.98536], [-117.30678, 33.98527], [-117.30681, 33.98532], [-117.30719, 33.98526], [-117.30771, 33.98509], [-117.30797, 33.98508], [-117.30769, 33.98468], [-117.30751, 33.98381], [-117.30747, 33.98338], [-117.30729, 33.98298]], [[-117.30641, 33.97914], [-117.3064, 33.97915], [-117.30687, 33.97983], [-117.30812, 33.97974], [-117.30865, 33.9792], [-117.30641, 33.97914]], [[-117.30699, 33.98202], [-117.30731, 33.98217], [-117.30748, 33.98176], [-117.30746, 33.98163], [-117.30714, 33.9815], [-117.30699, 33.98202]]], [[[-117.29011, 33.98252], [-117.29019, 33.98289], [-117.29011, 33.98384], [-117.28964, 33.9842], [-117.28926, 33.98542], [-117.28856, 33.98579], [-117.2878, 33.98649], [-117.28795, 33.9825], [-117.29011, 33.98252]]], [[[-117.29246, 33.97558], [-117.29244, 33.97584], [-117.29178, 33.9764], [-117.29173, 33.97646], [-117.29156, 33.9769], [-117.29146, 33.97768], [-117.29147, 33.97824], [-117.29117, 33.97874], [-117.29076, 33.97902], [-117.29027, 33.97909], [-117.28983, 33.97931], [-117.28978, 33.97939], [-117.28996, 33.98164], [-117.28798, 33.98165], [-117.28813, 33.97564], [-117.29246, 33.97558]]]]}	Open Access 1	9281	Box Springs Mountain Park	9491	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/about-us/trails-committee/adopt-a-trail/trail-lists-and-maps/	Riverside 10	2481.577	Box Springs Mtn. 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]);