superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where MNG_AGENCY = 113 sorted by map 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3988 | 3988 | 3987 | {"type": "Polygon", "coordinates": [[[-117.97279, 33.88354], [-117.97261, 33.88413], [-117.972, 33.88412], [-117.9719, 33.88422], [-117.97193, 33.88435], [-117.97207, 33.88454], [-117.97217, 33.88471], [-117.97227, 33.88494], [-117.97225, 33.88493], [-117.97208, 33.88457], [-117.97193, 33.88437], [-117.97164, 33.88404], [-117.97158, 33.88394], [-117.97147, 33.88371], [-117.9714, 33.88344], [-117.97137, 33.88329], [-117.97136, 33.88245], [-117.97132, 33.88232], [-117.97128, 33.88225], [-117.97113, 33.88209], [-117.97093, 33.88198], [-117.97079, 33.88194], [-117.97065, 33.88192], [-117.97006, 33.88198], [-117.96907, 33.88205], [-117.96901, 33.88204], [-117.96899, 33.88201], [-117.96903, 33.882], [-117.96904, 33.88195], [-117.97006, 33.88193], [-117.97008, 33.88182], [-117.97133, 33.88179], [-117.97188, 33.88135], [-117.97186, 33.88058], [-117.97233, 33.88058], [-117.97235, 33.88309], [-117.97279, 33.88354]]]} | Open Access 1 | Emery Park | 18625 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 9.042 | Emery 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 | ||
7675 | 7675 | 7674 | {"type": "Polygon", "coordinates": [[[-117.96874, 33.86227], [-117.96816, 33.86226], [-117.96814, 33.86223], [-117.96814, 33.86192], [-117.96874, 33.86192], [-117.96874, 33.86227]]]} | Open Access 1 | Olive Park | 23125 | 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.522 | Olive Park | ||
4562 | 4562 | 4561 | {"type": "Polygon", "coordinates": [[[-117.96739, 33.85816], [-117.96643, 33.85817], [-117.96643, 33.85902], [-117.96532, 33.85904], [-117.96531, 33.85817], [-117.96617, 33.85817], [-117.96618, 33.85792], [-117.96625, 33.85787], [-117.96627, 33.85779], [-117.96642, 33.85778], [-117.9664, 33.85667], [-117.96737, 33.85666], [-117.96739, 33.85816]]]} | Open Access 1 | Gilbert Park | 19293 | 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.329 | Gilbert 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 | ||
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 | ||
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 | ||
1799 | 1799 | 1798 | {"type": "Polygon", "coordinates": [[[-117.95884, 33.87703], [-117.95875, 33.87723], [-117.95842, 33.87775], [-117.95824, 33.87799], [-117.95802, 33.87823], [-117.95757, 33.87863], [-117.95706, 33.87897], [-117.95666, 33.87917], [-117.95521, 33.87968], [-117.95472, 33.87906], [-117.95661, 33.87804], [-117.95699, 33.87779], [-117.95739, 33.8774], [-117.95757, 33.87717], [-117.95776, 33.87685], [-117.9578, 33.87682], [-117.95785, 33.87682], [-117.95844, 33.87696], [-117.95884, 33.87703]]]} | Open Access 1 | Bastanchury Park | 15859 | 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.512 | Bastanchury Park | ||
470 | 470 | 469 | {"type": "Polygon", "coordinates": [[[-117.95528, 33.87307], [-117.95525, 33.87309], [-117.95481, 33.87321], [-117.95455, 33.87326], [-117.95425, 33.87328], [-117.95421, 33.87325], [-117.9542, 33.87238], [-117.95425, 33.87232], [-117.95425, 33.87207], [-117.95433, 33.87204], [-117.95437, 33.87199], [-117.95437, 33.87193], [-117.95435, 33.8719], [-117.95467, 33.8719], [-117.95469, 33.8721], [-117.9551, 33.8721], [-117.95512, 33.87268], [-117.95516, 33.87283], [-117.95528, 33.87307]]]} | Open Access 1 | Adlena Park | 15266 | 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.838 | Adlena 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 | ||
4191 | 4191 | 4190 | {"type": "Polygon", "coordinates": [[[-117.9531, 33.87725], [-117.953, 33.87735], [-117.95292, 33.87747], [-117.95288, 33.87762], [-117.95287, 33.87779], [-117.95084, 33.87777], [-117.95078, 33.87775], [-117.95077, 33.87723], [-117.9531, 33.87725]]]} | Open Access 1 | Fern Drive Park | 18874 | 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.952 | Fern Drive 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 | ||
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 | ||
7266 | 7266 | 7265 | {"type": "Polygon", "coordinates": [[[-117.94549, 33.87542], [-117.94548, 33.8764], [-117.94546, 33.87698], [-117.94376, 33.87684], [-117.94367, 33.87682], [-117.94362, 33.87677], [-117.94347, 33.87634], [-117.9434, 33.87595], [-117.94312, 33.8753], [-117.94359, 33.8752], [-117.94542, 33.87532], [-117.94545, 33.87534], [-117.94546, 33.87542], [-117.94549, 33.87542]]]} | Open Access 1 | Muckenthaler Cultural Center | 22582 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 8.615 | Muckenthaler Cultural Ctr. | ||
7378 | 7378 | 7377 | {"type": "Polygon", "coordinates": [[[-117.94313, 33.86297], [-117.94253, 33.86297], [-117.94252, 33.86267], [-117.94195, 33.86267], [-117.94195, 33.862], [-117.94199, 33.86199], [-117.94204, 33.86196], [-117.94216, 33.86195], [-117.94235, 33.8619], [-117.94244, 33.86185], [-117.94267, 33.86168], [-117.94313, 33.86205], [-117.94313, 33.86297]]]} | Open Access 1 | Nicolas Park | 22752 | 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.841 | Nicolas Park | ||
5324 | 5324 | 5323 | {"type": "Polygon", "coordinates": [[[-117.94028, 33.86813], [-117.93751, 33.86817], [-117.93748, 33.86675], [-117.93903, 33.86673], [-117.93904, 33.86678], [-117.94015, 33.86677], [-117.94014, 33.86701], [-117.94015, 33.86728], [-117.94017, 33.86737], [-117.94023, 33.8675], [-117.94026, 33.86761], [-117.94028, 33.86813]]]} | Open Access 1 | Independence Park | 20191 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 9.625 | Independence 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 | ||
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 | ||
4303 | 4303 | 4302 | {"type": "Polygon", "coordinates": [[[-117.93299, 33.87368], [-117.93293, 33.87371], [-117.93199, 33.87372], [-117.93199, 33.87369], [-117.93201, 33.87367], [-117.93199, 33.8724], [-117.93298, 33.87239], [-117.93299, 33.87368]]]} | Open Access 1 | Ford Park | 18986 | 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.29 | Ford Park | ||
1186 | 1186 | 1185 | {"type": "Polygon", "coordinates": [[[-117.93066, 33.87017], [-117.9288, 33.87019], [-117.92878, 33.86888], [-117.93064, 33.86886], [-117.93066, 33.87017]]]} | Open Access 1 | Amerige Park | 15457 | 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.176 | Amerige 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]);