superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where MNG_AGENCY = 113 sorted by SUID_NMA 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 | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13085 | 13085 | 13084 | {"type": "Polygon", "coordinates": [[[-117.9268, 33.89343], [-117.92673, 33.89381], [-117.92554, 33.89382], [-117.92558, 33.89251], [-117.92583, 33.89233], [-117.9259, 33.89215], [-117.92642, 33.8921], [-117.9268, 33.89343]]]} | Open Access 1 | Fullerton Tennis Center | 33372 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 4.416 | Fullerton Tennis Ctr. | ||
14570 | 14570 | 14569 | {"type": "Polygon", "coordinates": [[[-117.92866, 33.89741], [-117.92882, 33.89797], [-117.92866, 33.89899], [-117.92858, 33.89939], [-117.9284, 33.89986], [-117.9283, 33.90048], [-117.92833, 33.90094], [-117.92835, 33.90216], [-117.92806, 33.90241], [-117.92794, 33.9026], [-117.92783, 33.90284], [-117.92789, 33.90288], [-117.9279, 33.90291], [-117.92781, 33.90302], [-117.9277, 33.9032], [-117.92761, 33.90344], [-117.92753, 33.90373], [-117.92731, 33.90489], [-117.92713, 33.90576], [-117.92694, 33.90573], [-117.92669, 33.905], [-117.92544, 33.90564], [-117.92569, 33.90539], [-117.92485, 33.90469], [-117.92436, 33.90485], [-117.92358, 33.90507], [-117.92102, 33.90616], [-117.92255, 33.90495], [-117.9231, 33.90425], [-117.92225, 33.90389], [-117.9208, 33.90429], [-117.91838, 33.90369], [-117.91644, 33.90441], [-117.91697, 33.90527], [-117.91723, 33.90563], [-117.91661, 33.906], [-117.91638, 33.9061], [-117.91607, 33.90635], [-117.91599, 33.90644], [-117.91597, 33.90666], [-117.91591, 33.90695], [-117.91599, 33.9071], [-117.91639, 33.90737], [-117.9165, 33.90748], [-117.91741, 33.90864], [-117.91682, 33.90936], [-117.91585, 33.90911], [-117.91587, 33.90892], [-117.91585, 33.9087], [-117.9158, 33.90844], [-117.91565, 33.90813], [-117.91565, 33.90737], [-117.91479, 33.90656], [-117.91478, 33.9065], [-117.91495, 33.90578], [-117.91552, 33.90518], [-117.91511, 33.90406], [-117.914, 33.90357], [-117.91408, 33.90355], [-117.91405, 33.90301], [-117.92042, 33.90291], [-117.92104, 33.9032], [-117.92165, 33.90284], [-117.9233, 33.90281], [-117.92395, 33.90322], [-117.92419, 33.903], [-117.92478, 33.90242], [-117.92544, 33.90204], [-117.92462, 33.90094], [-117.92431, 33.90085], [-117.92499, 33.90051], [-117.92625, 33.90048], [-117.92705, 33.89942], [-117.92638, 33.89873], [-117.92586, 33.89916], [-117.92559, 33.89875], [-117.92564, 33.89751], [-117.92502, 33.89757], [-117.92475, 33.89873], [-117.92401, 33.89851], [-117.92397, 33.89859], [-117.92398, 33.89926], [-117.92302, 33.89914], [-117.92231, 33.89932], [-117.92197, 33.89983], [-117.92155, 33.89925], [-117.92203, 33.89917], [-117.92261, 33.89901], [-117.92316, 33.89878], [-117.92376, 33.89842], [-117.92436, 33.89784], [-117.9253, 33.89671], [-117.92571, 33.89644], [-117.92618, 33.89618], [-117.92651, 33.89606], [-117.92665, 33.89614], [-117.92714, 33.89625], [-117.92701, 33.89671], [-117.92702, 33.89673], [-117.92798, 33.89658], [-117.92793, 33.89672], [-117.92771, 33.89701], [-117.92866, 33.89741]]]} | Restricted Access 2 | Fullerton Municipal Golf Course | 32990 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 120.213 | Fullerton Municipal GC | ||
14174 | 14174 | 14173 | {"type": "MultiPolygon", "coordinates": [[[[-117.90223, 33.90123], [-117.90203, 33.90123], [-117.90195, 33.90126], [-117.90189, 33.90132], [-117.9019, 33.90164], [-117.90138, 33.90168], [-117.9013, 33.90184], [-117.90058, 33.90185], [-117.90057, 33.90126], [-117.90037, 33.90108], [-117.90105, 33.90102], [-117.90222, 33.90088], [-117.90223, 33.90123]]], [[[-117.90115, 33.90289], [-117.90087, 33.90313], [-117.90081, 33.90314], [-117.90073, 33.90276], [-117.90072, 33.90264], [-117.90113, 33.90261], [-117.90115, 33.90289]]]]} | Restricted Access 2 | Rolling Hills School Park | 31645 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 3.345 | Rolling Hills School Park | ||
14166 | 14166 | 14165 | {"type": "Polygon", "coordinates": [[[-117.95912, 33.85653], [-117.95701, 33.85656], [-117.957, 33.85652], [-117.95681, 33.85652], [-117.95681, 33.85643], [-117.95683, 33.85632], [-117.95687, 33.85621], [-117.95692, 33.85617], [-117.95779, 33.85624], [-117.95908, 33.85624], [-117.95911, 33.85624], [-117.95912, 33.85626], [-117.95912, 33.85653]]]} | Restricted Access 2 | Orangethorpe School Park | 31634 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1.855 | Orangethorpe School Park | ||
14142 | 14142 | 14141 | {"type": "Polygon", "coordinates": [[[-117.93319, 33.89474], [-117.93316, 33.89535], [-117.93309, 33.89568], [-117.93278, 33.89561], [-117.93269, 33.8958], [-117.93199, 33.89562], [-117.93177, 33.89614], [-117.93144, 33.89605], [-117.93131, 33.89545], [-117.93168, 33.89521], [-117.93261, 33.89468], [-117.93285, 33.89466], [-117.93289, 33.89473], [-117.93319, 33.89474]]]} | Restricted Access 2 | Laguna Road School Park | 31597 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 3.913 | Laguna Road School Park | ||
13992 | 13992 | 13991 | {"type": "Polygon", "coordinates": [[[-117.92663, 33.9084], [-117.92635, 33.90978], [-117.92621, 33.90981], [-117.92598, 33.90991], [-117.92543, 33.90885], [-117.92549, 33.90833], [-117.92663, 33.9084]]]} | Restricted Access 2 | Hermosa School Park | 31593 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 3.279 | Hermosa School Park | ||
11374 | 11374 | 11373 | {"type": "Polygon", "coordinates": [[[-117.93306, 33.85925], [-117.93087, 33.85927], [-117.93085, 33.85841], [-117.93095, 33.85834], [-117.93094, 33.85814], [-117.93273, 33.85814], [-117.93274, 33.85836], [-117.93282, 33.85836], [-117.93286, 33.85845], [-117.93296, 33.85847], [-117.93297, 33.8587], [-117.93305, 33.85871], [-117.93306, 33.85925]]]} | Open Access 1 | Woodcrest Park | 27706 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 5.9 | Woodcrest Park | ||
11103 | 11103 | 11102 | {"type": "Polygon", "coordinates": [[[-117.95946, 33.89516], [-117.95944, 33.89529], [-117.95901, 33.89539], [-117.95876, 33.89578], [-117.9585, 33.89568], [-117.95824, 33.89563], [-117.95786, 33.8956], [-117.95761, 33.89562], [-117.9573, 33.89568], [-117.95708, 33.89575], [-117.95683, 33.89586], [-117.95665, 33.89597], [-117.95635, 33.89622], [-117.95581, 33.8969], [-117.95563, 33.89718], [-117.95534, 33.89782], [-117.95514, 33.89811], [-117.95482, 33.8979], [-117.95448, 33.89773], [-117.95424, 33.89768], [-117.95403, 33.89785], [-117.95392, 33.8978], [-117.95385, 33.89781], [-117.95378, 33.89783], [-117.9537, 33.8979], [-117.95333, 33.8979], [-117.95322, 33.89784], [-117.95337, 33.89767], [-117.95351, 33.89746], [-117.9536, 33.89728], [-117.95366, 33.89711], [-117.95371, 33.8969], [-117.95375, 33.89649], [-117.95446, 33.89655], [-117.95539, 33.89628], [-117.95557, 33.89572], [-117.95621, 33.89554], [-117.95879, 33.89553], [-117.95917, 33.89496], [-117.95946, 33.89516]]]} | Open Access 1 | West Coyote Hills Tree Park | 27355 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 10.985 | West Coyote Hills Tree Park | ||
11099 | 11099 | 11098 | {"type": "Polygon", "coordinates": [[[-117.9656, 33.89629], [-117.96545, 33.89728], [-117.96541, 33.89748], [-117.96538, 33.89752], [-117.96531, 33.89754], [-117.96504, 33.89748], [-117.96428, 33.89741], [-117.96414, 33.89738], [-117.96409, 33.89735], [-117.96408, 33.89729], [-117.96422, 33.89681], [-117.96426, 33.89675], [-117.96432, 33.8967], [-117.96433, 33.89666], [-117.96433, 33.89661], [-117.96429, 33.89655], [-117.96441, 33.89612], [-117.96519, 33.89621], [-117.96549, 33.89621], [-117.96557, 33.89623], [-117.9656, 33.89629]]]} | Open Access 1 | West Cayote Hills Park | 27353 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 4.153 | West Cayote Hills Park | ||
10956 | 10956 | 10955 | {"type": "Polygon", "coordinates": [[[-117.89393, 33.89797], [-117.89361, 33.8981], [-117.89352, 33.8982], [-117.892, 33.8977], [-117.89197, 33.89767], [-117.89201, 33.89714], [-117.89197, 33.89631], [-117.89214, 33.89632], [-117.8924, 33.89638], [-117.89264, 33.89641], [-117.89313, 33.89638], [-117.89324, 33.89639], [-117.89339, 33.89646], [-117.89353, 33.89664], [-117.89379, 33.89703], [-117.89396, 33.89743], [-117.894, 33.89775], [-117.89398, 33.89788], [-117.89393, 33.89797]]]} | Open Access 1 | Vista Park | 27182 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 7.256 | Vista Park | ||
10932 | 10932 | 10931 | {"type": "MultiPolygon", "coordinates": [[[[-117.9517, 33.89275], [-117.95168, 33.89324], [-117.95223, 33.8943], [-117.95231, 33.8947], [-117.95234, 33.89508], [-117.95216, 33.8959], [-117.95199, 33.89628], [-117.95173, 33.89662], [-117.95065, 33.89747], [-117.95085, 33.89781], [-117.95053, 33.89796], [-117.95044, 33.89771], [-117.95038, 33.89738], [-117.95046, 33.89736], [-117.9505, 33.89732], [-117.95052, 33.89725], [-117.95051, 33.89719], [-117.95072, 33.89709], [-117.95129, 33.89667], [-117.95134, 33.89644], [-117.95147, 33.89644], [-117.95157, 33.89638], [-117.95179, 33.89606], [-117.95185, 33.89593], [-117.95188, 33.89583], [-117.95191, 33.89559], [-117.95189, 33.89535], [-117.95183, 33.89517], [-117.95171, 33.89495], [-117.95167, 33.89484], [-117.9516, 33.89471], [-117.95153, 33.89466], [-117.9517, 33.89442], [-117.95158, 33.89435], [-117.95079, 33.89438], [-117.95056, 33.894], [-117.95024, 33.89392], [-117.95025, 33.89384], [-117.95063, 33.89381], [-117.95058, 33.89291], [-117.95037, 33.89275], [-117.95082, 33.89273], [-117.9517, 33.89275]]], [[[-117.95344, 33.8969], [-117.95336, 33.89724], [-117.95322, 33.8975], [-117.95296, 33.89739], [-117.95269, 33.89761], [-117.95269, 33.89765], [-117.95257, 33.89769], [-117.95231, 33.89794], [-117.9522, 33.89807], [-117.95213, 33.89818], [-117.95158, 33.89852], [-117.95157, 33.89855], [-117.95103, 33.89856], [-117.95076, 33.89859], [-117.95064, 33.89858], [-117.95051, 33.89815], [-117.95069, 33.89809], [-117.95084, 33.8985], [-117.95148, 33.89844], [-117.95344, 33.8969]]]]} | Open Access 1 | Virgil Grissom Park | 27152 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 10.582 | Virgil Grissom Park | ||
9171 | 9171 | 9170 | {"type": "Polygon", "coordinates": [[[-117.97185, 33.86827], [-117.97115, 33.86828], [-117.97113, 33.86658], [-117.97184, 33.86657], [-117.97185, 33.86827]]]} | Open Access 1 | Valencia Park | 26764 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 3.014 | Valencia Park | ||
10471 | 10471 | 10470 | {"type": "Polygon", "coordinates": [[[-117.91753, 33.86783], [-117.9174, 33.86783], [-117.91739, 33.86746], [-117.91753, 33.86746], [-117.91753, 33.86783]]]} | Open Access 1 | Truslow Park | 26555 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 0.132 | Truslow Park | ||
10439 | 10439 | 10438 | {"type": "Polygon", "coordinates": [[[-117.9141, 33.89576], [-117.9139, 33.89588], [-117.91379, 33.8961], [-117.91346, 33.8963], [-117.91289, 33.89645], [-117.91246, 33.89661], [-117.91214, 33.89641], [-117.91245, 33.89621], [-117.91262, 33.89613], [-117.91343, 33.89577], [-117.9141, 33.89576]]]} | Open Access 1 | Trail Rest Park | 26508 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1.792 | Trail Rest Park | ||
7783 | 7783 | 7782 | {"type": "Polygon", "coordinates": [[[-117.92836, 33.90467], [-117.92815, 33.9048], [-117.9281, 33.90476], [-117.92804, 33.90473], [-117.92797, 33.90475], [-117.92791, 33.9048], [-117.92753, 33.90466], [-117.92763, 33.90412], [-117.92794, 33.90402], [-117.92836, 33.90467]]]} | Open Access 1 | San Juan Park | 24919 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1.044 | San Juan Park | ||
8915 | 8915 | 8914 | {"type": "Polygon", "coordinates": [[[-117.90101, 33.90102], [-117.90037, 33.90108], [-117.90001, 33.90073], [-117.89951, 33.90038], [-117.89902, 33.90054], [-117.8984, 33.90065], [-117.8984, 33.89966], [-117.89885, 33.89971], [-117.89974, 33.89975], [-117.90096, 33.89975], [-117.90101, 33.90102]]]} | Open Access 1 | Rolling Hills Park | 24578 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 6.44 | Rolling Hills Park | ||
8904 | 8904 | 8903 | {"type": "Polygon", "coordinates": [[[-117.95103, 33.89252], [-117.95065, 33.89253], [-117.95003, 33.89257], [-117.94996, 33.89212], [-117.94981, 33.89213], [-117.94979, 33.89207], [-117.94994, 33.892], [-117.9499, 33.89172], [-117.95102, 33.89171], [-117.95103, 33.89252]]]} | Open Access 1 | Roger Chaffee Park | 24558 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 2.261 | Roger Chaffee Park | ||
8824 | 8824 | 8823 | {"type": "Polygon", "coordinates": [[[-117.95261, 33.89908], [-117.9526, 33.89956], [-117.95255, 33.89978], [-117.9525, 33.89992], [-117.9524, 33.90012], [-117.95175, 33.90019], [-117.95156, 33.90033], [-117.95142, 33.9005], [-117.95098, 33.90079], [-117.95065, 33.90125], [-117.94932, 33.90117], [-117.94926, 33.90118], [-117.94923, 33.90132], [-117.94933, 33.90169], [-117.94929, 33.90187], [-117.94908, 33.90193], [-117.94865, 33.90197], [-117.94839, 33.90209], [-117.94829, 33.90217], [-117.94816, 33.90222], [-117.94793, 33.90221], [-117.94787, 33.90219], [-117.94768, 33.90207], [-117.94753, 33.90207], [-117.94741, 33.90208], [-117.94733, 33.90212], [-117.94713, 33.90224], [-117.94707, 33.9025], [-117.94713, 33.90256], [-117.94724, 33.90274], [-117.94739, 33.90291], [-117.94764, 33.90304], [-117.94762, 33.90309], [-117.94765, 33.90311], [-117.94781, 33.90312], [-117.94828, 33.90377], [-117.94812, 33.90449], [-117.94779, 33.9046], [-117.94737, 33.9048], [-117.947, 33.9048], [-117.94651, 33.90469], [-117.94579, 33.90442], [-117.94503, 33.90436], [-117.94472, 33.90431], [-117.94389, 33.90395], [-117.94361, 33.90368], [-117.9433, 33.9033], [-117.943, 33.90278], [-117.943, 33.90266], [-117.94306, 33.9024], [-117.94319, 33.90219], [-117.94337, 33.90199], [-117.94355, 33.90164], [-117.94359, 33.9014], [-117.94359, 33.90134], [-117.94355, 33.90128], [-117.94347, 33.90126], [-117.94325, 33.90126], [-117.94321, 33.90133], [-117.94288, 33.90133], [-117.94227, 33.90126], [-117.94215, 33.90127], [-117.94187, 33.90119], [-117.94188, 33.8994], [-117.94205, 33.89918], [-117.94405, 33.89916], [-117.94737, 33.89917], [-117.94761, 33.8996], [-117.94784, 33.89974], [-117.94838, 33.90001], [-117.94866, 33.90023], [-117.94906, 33.90052], [-117.94931, 33.90064], [-117.94932, 33.90066], [-117.94943, 33.90075], [-117.9495, 33.90091], [-117.95016, 33.90099], [-117.9503, 33.90097], [-117.95054, 33.90086], [-117.95038, 33.90053], [-117.95046, 33.9005], [-117.95067, 33.90078], [-117.95092, 33.90069], [-117.95134, 33.90036], [-117.95204, 33.89996], [-117.95223, 33.89975], [-117.95244, 33.89927], [-117.9525, 33.89906], [-117.95261, 33.89908]]]} | Open Access 1 | Robert E. Ward Nature Preserve | 24486 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 76.176 | Robert E. Ward Nature Preserve | ||
8682 | 8682 | 8681 | {"type": "Polygon", "coordinates": [[[-117.92986, 33.86435], [-117.92876, 33.86437], [-117.92876, 33.86349], [-117.92985, 33.86348], [-117.92986, 33.86435]]]} | Open Access 1 | Richman Park | 24338 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 2.445 | Richman Park | ||
8303 | 8303 | 8302 | {"type": "Polygon", "coordinates": [[[-117.95468, 33.86909], [-117.95385, 33.86908], [-117.95384, 33.86891], [-117.95335, 33.8689], [-117.95334, 33.86852], [-117.95468, 33.86851], [-117.95468, 33.86909]]]} | Open Access 1 | Pooch Park | 23890 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1.698 | Pooch Park |
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]);