calands: superunits_with_maps: 28 rows where ACCESS_TYP = 1, LAYER = 2 and MNG

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

28 rows where ACCESS_TYP = 1, LAYER = 2 and MNG_AGENCY = 287

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME
1060	1060	1059	{"type": "Polygon", "coordinates": [[[-118.02482, 33.98022], [-118.02407, 33.9806], [-118.02376, 33.98114], [-118.02378, 33.98121], [-118.02382, 33.98124], [-118.02386, 33.98126], [-118.02393, 33.98125], [-118.02374, 33.98136], [-118.02358, 33.98126], [-118.02323, 33.98115], [-118.0225, 33.98121], [-118.0216, 33.98166], [-118.01997, 33.98163], [-118.01995, 33.98253], [-118.01677, 33.98248], [-118.01673, 33.98326], [-118.01617, 33.98356], [-118.01558, 33.98377], [-118.01406, 33.98404], [-118.01334, 33.98402], [-118.0129, 33.9839], [-118.01238, 33.98365], [-118.01159, 33.98351], [-118.01098, 33.98353], [-118.01011, 33.98279], [-118.00999, 33.982], [-118.01028, 33.98102], [-118.01084, 33.98063], [-118.01287, 33.9814], [-118.01311, 33.98104], [-118.01375, 33.98062], [-118.01378, 33.98056], [-118.01378, 33.9805], [-118.01371, 33.98042], [-118.01361, 33.9804], [-118.01256, 33.98079], [-118.01267, 33.98046], [-118.01485, 33.97894], [-118.01564, 33.97894], [-118.01564, 33.97709], [-118.01907, 33.97712], [-118.01997, 33.97662], [-118.01998, 33.97533], [-118.0235, 33.97537], [-118.0214, 33.97828], [-118.02166, 33.9793], [-118.02168, 33.97931], [-118.02173, 33.97925], [-118.02178, 33.97918], [-118.02178, 33.97915], [-118.02303, 33.97958], [-118.02325, 33.97977], [-118.02331, 33.97974], [-118.02366, 33.98006], [-118.02415, 33.97987], [-118.02482, 33.98022]]]}	Open Access 1	Worsham Canyon Open Space		14873	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	154.404	Worsham Canyon OS
1236	1236	1235	{"type": "Polygon", "coordinates": [[[-118.01451, 33.95008], [-118.01401, 33.9514], [-118.01308, 33.95088], [-118.01304, 33.95089], [-118.01275, 33.95073], [-118.01441, 33.95002], [-118.01451, 33.95008]]]}	Open Access 1	Anaconda Park		15464	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	2.702	Anaconda Park
1378	1378	1377	{"type": "MultiPolygon", "coordinates": [[[[-118.03213, 33.99081], [-118.03186, 33.9908], [-118.03187, 33.99053], [-118.03212, 33.99053], [-118.03213, 33.99081]]], [[[-118.03399, 33.98995], [-118.03398, 33.99019], [-118.0325, 33.99019], [-118.03251, 33.98994], [-118.03399, 33.98995]]], [[[-118.03322, 33.98945], [-118.03321, 33.98986], [-118.03274, 33.98986], [-118.03275, 33.98944], [-118.03322, 33.98945]]], [[[-118.03607, 33.99067], [-118.03607, 33.99067], [-118.03508, 33.99066], [-118.03587, 33.99044], [-118.03606, 33.99043], [-118.03607, 33.99067]]], [[[-118.03783, 33.99604], [-118.03756, 33.99644], [-118.03728, 33.99647], [-118.03727, 33.99604], [-118.03757, 33.99584], [-118.03783, 33.99604]]], [[[-118.0374, 33.99507], [-118.03728, 33.99507], [-118.03728, 33.99483], [-118.03734, 33.99483], [-118.0374, 33.99507]]], [[[-118.03924, 33.99587], [-118.0392, 33.99627], [-118.0389, 33.9963], [-118.03892, 33.99616], [-118.03906, 33.99613], [-118.03913, 33.99609], [-118.03915, 33.99604], [-118.03917, 33.99586], [-118.03924, 33.99587]]], [[[-118.04615, 34.00015], [-118.04611, 34.00027], [-118.04606, 34.00029], [-118.046, 34.00034], [-118.04595, 34.00041], [-118.04595, 34.00044], [-118.04593, 34.00044], [-118.04593, 34.00008], [-118.04615, 34.00015]]]]}	Open Access 1	Hellman Park	http://www.lamountains.com/parks.asp?parkid=633	14853	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	2.86	Hellman Park
2267	2267	2266	{"type": "MultiPolygon", "coordinates": [[[[-118.03963, 33.98542], [-118.03962, 33.98623], [-118.03916, 33.98622], [-118.03917, 33.98541], [-118.03963, 33.98542]]], [[[-118.04078, 33.98623], [-118.03971, 33.98623], [-118.0397, 33.98582], [-118.04077, 33.98583], [-118.04078, 33.98623]]]]}	Open Access 1	Broadway Park		16409	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	2.032	Broadway Park
2776	2776	2775	{"type": "Polygon", "coordinates": [[[-118.03492, 33.98096], [-118.03491, 33.98163], [-118.03392, 33.98163], [-118.03394, 33.98096], [-118.03492, 33.98096]]]}	Open Access 1	Central Park		17064	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	1.688	Central Park
4339	4339	4338	{"type": "MultiPolygon", "coordinates": [[[[-118.0454, 33.98641], [-118.0454, 33.98717], [-118.04443, 33.98717], [-118.04443, 33.9864], [-118.0454, 33.98641]]], [[[-118.04592, 33.9864], [-118.04592, 33.98717], [-118.04548, 33.98716], [-118.04548, 33.9864], [-118.04592, 33.9864]]], [[[-118.04752, 33.98641], [-118.04752, 33.98724], [-118.04609, 33.98725], [-118.0461, 33.98641], [-118.04752, 33.98641]]]]}	Open Access 1	Founders Memorial Park		19019	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	5.779	Founders Memorial Park
4424	4424	4423	{"type": "Polygon", "coordinates": [[[-118.03492, 33.97189], [-118.03492, 33.97353], [-118.03427, 33.97353], [-118.03331, 33.9734], [-118.03332, 33.97241], [-118.03385, 33.9724], [-118.03385, 33.97215], [-118.03394, 33.97214], [-118.03395, 33.97189], [-118.0344, 33.9719], [-118.03442, 33.97215], [-118.03447, 33.97213], [-118.03448, 33.9719], [-118.03492, 33.97189]]]}	Open Access 1	Friends Park Complex		19117	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	5.692	Friends Park Complex
4583	4583	4582	{"type": "Polygon", "coordinates": [[[-118.0358, 33.96005], [-118.03541, 33.96044], [-118.03449, 33.95981], [-118.03489, 33.95943], [-118.0358, 33.96005]]]}	Open Access 1	Kennedy Park		20601	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	1.527	Kennedy Park
5245	5245	5244	{"type": "MultiPolygon", "coordinates": [[[[-118.05395, 33.99771], [-118.05385, 33.99785], [-118.05376, 33.9978], [-118.05374, 33.99776], [-118.05379, 33.99767], [-118.05387, 33.99761], [-118.05395, 33.99771]]], [[[-118.05481, 33.99824], [-118.05455, 33.99845], [-118.05418, 33.99801], [-118.0541, 33.99797], [-118.05419, 33.99786], [-118.05447, 33.99773], [-118.05481, 33.99824]]], [[[-118.05463, 33.99697], [-118.05456, 33.99704], [-118.05445, 33.99709], [-118.05438, 33.99708], [-118.05432, 33.99701], [-118.05462, 33.99687], [-118.05463, 33.99697]]]]}	Open Access 1	Hoover Fountain and Park		20078	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	0.789	Hoover Fountain and Park
5416	5416	5415	{"type": "Polygon", "coordinates": [[[-118.04432, 33.97678], [-118.04324, 33.97681], [-118.04324, 33.97595], [-118.04431, 33.97595], [-118.04432, 33.97678]]]}	Open Access 1	J.G. Whittier Park		20294	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	2.325	J.G. Whittier Park
6050	6050	6049	{"type": "Polygon", "coordinates": [[[-118.02931, 33.95594], [-118.0286, 33.95664], [-118.02858, 33.95668], [-118.02856, 33.95668], [-118.0283, 33.9565], [-118.02902, 33.95578], [-118.02909, 33.95578], [-118.02931, 33.95594]]]}	Open Access 1	Laurel Park		21103	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	0.838	Laurel Park
6078	6078	6077	{"type": "Polygon", "coordinates": [[[-118.03725, 33.96882], [-118.03725, 33.96957], [-118.03679, 33.96957], [-118.0368, 33.96954], [-118.0368, 33.96881], [-118.03725, 33.96882]]]}	Open Access 1	Lee Owens Park		21134	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	0.873	Lee Owens Park
6080	6080	6079	{"type": "Polygon", "coordinates": [[[-117.99593, 33.93932], [-117.99532, 33.9402], [-117.99459, 33.93977], [-117.99393, 33.93977], [-117.99376, 33.94011], [-117.99329, 33.94011], [-117.99324, 33.94009], [-117.99322, 33.94006], [-117.99324, 33.93934], [-117.99593, 33.93932]]]}	Open Access 1	Leffingwell Ranch Park		21137	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	3.955	Leffingwell Ranch Park
6971	6971	6970	{"type": "Polygon", "coordinates": [[[-118.02298, 33.96402], [-118.02183, 33.96545], [-118.01994, 33.9644], [-118.02109, 33.96296], [-118.02298, 33.96402]]]}	Open Access 1	Michigan Park		22200	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	9.971	Michigan Park
7274	7274	7273	{"type": "Polygon", "coordinates": [[[-117.9869, 33.95804], [-117.98648, 33.95805], [-117.9864, 33.95809], [-117.98534, 33.9581], [-117.98445, 33.95834], [-117.98413, 33.95852], [-117.98303, 33.95922], [-117.98195, 33.95881], [-117.98125, 33.95823], [-117.98154, 33.95805], [-117.98175, 33.95808], [-117.98243, 33.95767], [-117.9827, 33.95744], [-117.98339, 33.95729], [-117.98337, 33.95714], [-117.98383, 33.95702], [-117.98396, 33.95707], [-117.98483, 33.95676], [-117.98529, 33.95633], [-117.98569, 33.9564], [-117.98619, 33.9569], [-117.98671, 33.95678], [-117.98673, 33.95685], [-117.98678, 33.95718], [-117.98678, 33.9572], [-117.98674, 33.95723], [-117.98675, 33.95738], [-117.98681, 33.95741], [-117.9869, 33.95804]]]}	Open Access 1	Murphy Ranch Park		22609	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	19.414	Murphy Ranch Park
7874	7874	7873	{"type": "MultiPolygon", "coordinates": [[[[-118.05718, 33.99178], [-118.05479, 33.99178], [-118.05477, 33.99], [-118.05543, 33.99001], [-118.05718, 33.99178]]], [[[-118.05829, 33.99261], [-118.05747, 33.99178], [-118.05572, 33.99], [-118.05744, 33.98999], [-118.05804, 33.99178], [-118.05829, 33.99261]]]]}	Open Access 1	Palm Park		23346	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	12.606	Palm Park
7984	7984	7983	{"type": "Polygon", "coordinates": [[[-118.0032, 33.93615], [-118.00318, 33.93794], [-118.00101, 33.9369], [-118.00093, 33.93678], [-118.00093, 33.93533], [-118.00095, 33.93532], [-118.003, 33.93532], [-118.00301, 33.93614], [-118.0032, 33.93615]]]}	Open Access 1	Parnell Park		23471	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	11.57	Parnell Park
8003	8003	8002	{"type": "Polygon", "coordinates": [[[-118.00272, 33.96169], [-118.00267, 33.96172], [-118.00217, 33.96176], [-118.0021, 33.96173], [-118.002, 33.96147], [-118.00205, 33.96143], [-118.00216, 33.96141], [-118.00237, 33.96144], [-118.00269, 33.96162], [-118.00271, 33.96164], [-118.00272, 33.96169]]]}	Open Access 1	Pat Nixon Fountain and Park		23503	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	0.433	Pat Nixon Fountain and Park
10445	10445	10444	{"type": "MultiPolygon", "coordinates": [[[[-118.01025, 33.96928], [-118.00905, 33.97078], [-118.0088, 33.97086], [-118.00826, 33.97078], [-118.00886, 33.97002], [-118.00795, 33.9695], [-118.00792, 33.9694], [-118.00843, 33.96896], [-118.00845, 33.96883], [-118.00937, 33.96935], [-118.00969, 33.96896], [-118.01025, 33.96928]]], [[[-118.01077, 33.9639], [-118.01053, 33.9642], [-118.01004, 33.96394], [-118.01029, 33.9636], [-118.01076, 33.96386], [-118.01077, 33.9639]]]]}	Open Access 1	Arroyo Pescadero	http://www.habitatauthority.org/trails/	28934	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	6.298	Arroyo Pescadero
11192	11192	11191	{"type": "MultiPolygon", "coordinates": [[[[-118.01971, 33.9463], [-118.01948, 33.94639], [-118.0187, 33.94601], [-118.0188, 33.94587], [-118.01971, 33.9463]]], [[[-118.02441, 33.94909], [-118.02429, 33.94915], [-118.02312, 33.94834], [-118.02309, 33.94835], [-118.02273, 33.94811], [-118.02217, 33.94776], [-118.02113, 33.94717], [-118.01977, 33.94652], [-118.01997, 33.94642], [-118.0218, 33.94729], [-118.02441, 33.94909]]], [[[-118.02875, 33.95205], [-118.02866, 33.9521], [-118.02863, 33.95209], [-118.02683, 33.95086], [-118.02586, 33.9502], [-118.02583, 33.95021], [-118.02442, 33.94925], [-118.02455, 33.94918], [-118.02875, 33.95205]]], [[[-118.0343, 33.95582], [-118.03418, 33.95593], [-118.02874, 33.95219], [-118.02897, 33.95206], [-118.03424, 33.95571], [-118.03424, 33.95573], [-118.0343, 33.95577], [-118.0343, 33.95582]]], [[[-118.03717, 33.95872], [-118.03703, 33.95885], [-118.03668, 33.95829], [-118.03638, 33.95788], [-118.03613, 33.95758], [-118.0359, 33.95733], [-118.03546, 33.9569], [-118.03488, 33.95643], [-118.03434, 33.95604], [-118.03443, 33.95594], [-118.03449, 33.95593], [-118.03464, 33.95603], [-118.03588, 33.95693], [-118.03583, 33.95701], [-118.03629, 33.95748], [-118.03652, 33.95776], [-118.03685, 33.9582], [-118.03717, 33.95872]]], [[[-118.03931, 33.96332], [-118.03916, 33.96347], [-118.03773, 33.96032], [-118.03718, 33.95913], [-118.03732, 33.95899], [-118.03752, 33.95938], [-118.03931, 33.96332]]], [[[-118.04156, 33.96787], [-118.04144, 33.96798], [-118.04115, 33.9678], [-118.04095, 33.96749], [-118.04066, 33.96694], [-118.03923, 33.96375], [-118.03947, 33.96351], [-118.04096, 33.96681], [-118.04132, 33.96748], [-118.04156, 33.96787]]], [[[-118.04196, 33.96851], [-118.04195, 33.96896], [-118.04149, 33.96827], [-118.04163, 33.96827], [-118.04186, 33.96837], [-118.04196, 33.96851]]], [[[-118.04487, 33.9734], [-118.0447, 33.97344], [-118.04446, 33.97273], [-118.04436, 33.97272], [-118.04389, 33.97181], [-118.04218, 33.9693], [-118.0422, 33.96892], [-118.04223, 33.96892], [-118.04482, 33.97273], [-118.0446, 33.97274], [-118.04487, 33.9734]]], [[[-118.04525, 33.97459], [-118.04524, 33.97537], [-118.04508, 33.97537], [-118.04508, 33.97499], [-118.04498, 33.97459], [-118.04478, 33.97363], [-118.04476, 33.97359], [-118.04494, 33.97354], [-118.04499, 33.97363], [-118.04511, 33.97393], [-118.04506, 33.97395], [-118.04518, 33.97451], [-118.04514, 33.97453], [-118.04525, 33.97454], [-118.04525, 33.97459]]], [[[-118.04667, 33.97726], [-118.04666, 33.97899], [-118.04648, 33.97899], [-118.04643, 33.97793], [-118.04625, 33.97792], [-118.04626, 33.97744], [-118.0462, 33.97719], [-118.04612, 33.97704], [-118.04609, 33.97704], [-118.04605, 33.97698], [-118.04598, 33.97698], [-118.04591, 33.97681], [-118.04549, 33.97617], [-118.04519, 33.97553], [-118.04531, 33.97554], [-118.04612, 33.97674], [-118.04615, 33.97674], [-118.04648, 33.97725], [-118.04667, 33.97726]]], [[[-118.0466, 33.97922], [-118.0466, 33.97959], [-118.04643, 33.9796], [-118.04643, 33.97921], [-118.0466, 33.97922]]], [[[-118.0466, 33.98071], [-118.04651, 33.98046], [-118.04647, 33.98028], [-118.04646, 33.98001], [-118.04647, 33.97965], [-118.0466, 33.97965], [-118.0466, 33.98071]]], [[[-118.04847, 33.98263], [-118.04817, 33.98262], [-118.0478, 33.98224], [-118.04779, 33.98214], [-118.04774, 33.98209], [-118.04768, 33.98209], [-118.04727, 33.98168], [-118.04725, 33.98168], [-118.0469, 33.98132], [-118.04673, 33.98109], [-118.04674, 33.98097], [-118.04693, 33.98097], [-118.04698, 33.98107], [-118.04714, 33.98127], [-118.04847, 33.98263]]], [[[-118.05016, 33.98446], [-118.04996, 33.98445], [-118.04937, 33.98386], [-118.04936, 33.98381], [-118.04841, 33.98285], [-118.04867, 33.98285], [-118.04936, 33.98354], [-118.04937, 33.98359], [-118.05014, 33.98437], [-118.05016, 33.9844], [-118.05016, 33.98446]]], [[[-118.05017, 33.98468], [-118.05017, 33.98468], [-118.05003, 33.98454], [-118.05016, 33.98453], [-118.05017, 33.98468]]], [[[-118.05456, 33.98908], [-118.05249, 33.98698], [-118.05247, 33.987], [-118.05037, 33.98487], [-118.05037, 33.98457], [-118.05301, 33.98724], [-118.05299, 33.98726], [-118.05304, 33.98731], [-118.05456, 33.98886], [-118.05456, 33.98908]]], [[[-118.05979, 33.99413], [-118.05964, 33.99427], [-118.05961, 33.99425], [-118.05543, 33.99001], [-118.05476, 33.98932], [-118.05476, 33.98901], [-118.05979, 33.99413]]], [[[-118.06622, 33.99876], [-118.06611, 33.99887], [-118.06562, 33.99842], [-118.06563, 33.99838], [-118.06513, 33.998], [-118.06432, 33.99751], [-118.06306, 33.99676], [-118.06303, 33.99677], [-118.06164, 33.99595], [-118.06104, 33.99554], [-118.06045, 33.99509], [-118.06004, 33.99473], [-118.05975, 33.99437], [-118.05987, 33.99425], [-118.06005, 33.99448], [-118.06015, 33.99457], [-118.06135, 33.99559], [-118.06214, 33.99609], [-118.06226, 33.99612], [-118.06226, 33.99615], [-118.0651, 33.99784], [-118.0655, 33.99813], [-118.06582, 33.99838], [-118.06622, 33.99876]]]]}	Open Access 1	Whittier Greenway Trail		27475	1380	Whittier, City of 287	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	34.842	Whittier Greenway Trail

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);