superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where ACCESS_TYP = 1 and MNG_AGENCY = 81
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
147 | 147 | 146 | {"type": "Polygon", "coordinates": [[[-117.06482, 34.0268], [-117.06482, 34.02935], [-117.06276, 34.02935], [-117.06275, 34.02844], [-117.06105, 34.02844], [-117.06104, 34.02824], [-117.06068, 34.02824], [-117.06068, 34.028], [-117.06226, 34.02701], [-117.06227, 34.02671], [-117.06276, 34.02671], [-117.06278, 34.02675], [-117.06478, 34.02675], [-117.06482, 34.0268]]]} | Open Access 1 | 7th Street Park | 15216 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 19.276 | 7th Street Park | ||
1384 | 1384 | 1383 | {"type": "Polygon", "coordinates": [[[-116.9995, 34.04903], [-116.99943, 34.06273], [-116.99495, 34.06294], [-116.99063, 34.06317], [-116.98635, 34.06342], [-116.98636, 34.05627], [-116.99075, 34.05601], [-116.99075, 34.05284], [-116.99567, 34.0507], [-116.99568, 34.05225], [-116.99773, 34.05245], [-116.99774, 34.0498], [-116.9995, 34.04903]]]} | Open Access 1 | El Dorado Ranch Park | 15122 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 333.169 | El Dorado Ranch Park | ||
1681 | 1681 | 1680 | {"type": "Polygon", "coordinates": [[[-117.03793, 34.0333], [-117.03774, 34.0333], [-117.03772, 34.03306], [-117.03753, 34.03312], [-117.03753, 34.0329], [-117.03793, 34.0329], [-117.03793, 34.0333]]]} | Open Access 1 | Avenue A Park | 15724 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 0.292 | Avenue A Park | ||
1682 | 1682 | 1681 | {"type": "Polygon", "coordinates": [[[-117.0606, 34.00857], [-117.06059, 34.00958], [-117.05997, 34.00973], [-117.05876, 34.01027], [-117.05774, 34.01012], [-117.05774, 34.00862], [-117.05777, 34.00858], [-117.0606, 34.00857]]]} | Open Access 1 | Avenue I Park | 15725 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 10.26 | Avenue I Park | ||
2307 | 2307 | 2306 | {"type": "Polygon", "coordinates": [[[-117.04339, 34.05126], [-117.04339, 34.05286], [-117.04294, 34.05323], [-117.04227, 34.05323], [-117.0421, 34.05338], [-117.042, 34.05336], [-117.04199, 34.0534], [-117.04175, 34.05336], [-117.04137, 34.05318], [-117.04117, 34.05313], [-117.04082, 34.05313], [-117.04077, 34.05309], [-117.04077, 34.05125], [-117.04339, 34.05126]]]} | Open Access 1 | Bryant Glen Sports Complex | 16457 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 12.946 | Bryant Glen Sports Complex | ||
4254 | 4254 | 4253 | {"type": "Polygon", "coordinates": [[[-117.02997, 34.03356], [-117.02997, 34.03377], [-117.02941, 34.03377], [-117.02914, 34.03394], [-117.02885, 34.03399], [-117.02788, 34.03405], [-117.02754, 34.03409], [-117.02722, 34.03415], [-117.0269, 34.03424], [-117.02635, 34.03443], [-117.02582, 34.03455], [-117.02582, 34.03393], [-117.02624, 34.03374], [-117.02655, 34.03364], [-117.02714, 34.03341], [-117.02743, 34.03333], [-117.02775, 34.03332], [-117.02809, 34.03329], [-117.02842, 34.03316], [-117.02872, 34.03302], [-117.02896, 34.033], [-117.02925, 34.03307], [-117.02953, 34.03319], [-117.02978, 34.03334], [-117.02997, 34.03356]]]} | Open Access 1 | Flag Hill Veterans Memorial Park | 18934 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 7.782 | Flag Hill Veterans Memorial Park | ||
5581 | 5581 | 5580 | {"type": "Polygon", "coordinates": [[[-117.0605, 34.03403], [-117.06048, 34.03454], [-117.06042, 34.03459], [-117.06031, 34.03462], [-117.05978, 34.03468], [-117.05958, 34.03467], [-117.05925, 34.03461], [-117.05886, 34.03462], [-117.05837, 34.03461], [-117.05816, 34.03462], [-117.05804, 34.03464], [-117.05766, 34.03465], [-117.05764, 34.0344], [-117.05758, 34.03439], [-117.0575, 34.03409], [-117.05732, 34.03407], [-117.05731, 34.03403], [-117.0605, 34.03403]]]} | Open Access 1 | John Tooker Civic Park | 20469 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 4.463 | John Tooker Civic Park | ||
6171 | 6171 | 6170 | {"type": "Polygon", "coordinates": [[[-117.05757, 34.03438], [-117.05718, 34.03439], [-117.05715, 34.03446], [-117.05706, 34.03448], [-117.05706, 34.03408], [-117.05716, 34.03403], [-117.05731, 34.03403], [-117.05733, 34.03408], [-117.0575, 34.03408], [-117.05757, 34.03438]]]} | Open Access 1 | Lillian Eaton Park | 21235 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 0.418 | Lillian Eaton Park | ||
9930 | 9930 | 9929 | {"type": "Polygon", "coordinates": [[[-117.08475, 34.02397], [-117.08434, 34.02442], [-117.0841, 34.02475], [-117.084, 34.02492], [-117.08364, 34.02579], [-117.08322, 34.02575], [-117.08315, 34.0258], [-117.08211, 34.02545], [-117.08205, 34.0254], [-117.08204, 34.02536], [-117.08205, 34.02532], [-117.08221, 34.02516], [-117.08255, 34.02491], [-117.08274, 34.0248], [-117.08314, 34.02462], [-117.08405, 34.02429], [-117.08427, 34.02418], [-117.08468, 34.02392], [-117.08475, 34.02397]]]} | Open Access 1 | Dunlap Neighborhood Park | 27997 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 4.959 | Dunlap Neighborhood Park | ||
11224 | 11224 | 11223 | {"type": "MultiPolygon", "coordinates": [[[[-117.00876, 34.01403], [-117.00847, 34.01408], [-117.00827, 34.01415], [-117.00803, 34.01428], [-117.00786, 34.01441], [-117.00773, 34.01456], [-117.00763, 34.01473], [-117.00757, 34.01491], [-117.00755, 34.01512], [-117.00748, 34.01517], [-117.00748, 34.01529], [-117.0042, 34.01527], [-117.00417, 34.01412], [-117.00484, 34.01389], [-117.00517, 34.01359], [-117.0064, 34.01388], [-117.008, 34.01403], [-117.00876, 34.01403]]], [[[-117.01091, 34.01525], [-117.00967, 34.01531], [-117.0079, 34.0153], [-117.00791, 34.01517], [-117.00785, 34.01513], [-117.00784, 34.01506], [-117.00786, 34.01493], [-117.0079, 34.01482], [-117.00798, 34.01467], [-117.00806, 34.01456], [-117.00817, 34.01446], [-117.00827, 34.01438], [-117.00852, 34.01428], [-117.00956, 34.01406], [-117.01027, 34.01412], [-117.0109, 34.01408], [-117.01091, 34.01525]]]]} | Open Access 1 | Wildwood Park | 27524 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 21.305 | Wildwood Park | ||
11494 | 11494 | 11493 | {"type": "MultiPolygon", "coordinates": [[[[-117.09215, 34.0368], [-117.09204, 34.03679], [-117.09202, 34.0367], [-117.09198, 34.03622], [-117.09184, 34.03579], [-117.09149, 34.03486], [-117.09225, 34.03531], [-117.09239, 34.03546], [-117.09248, 34.03564], [-117.09251, 34.03583], [-117.09248, 34.03603], [-117.09221, 34.03651], [-117.09216, 34.03664], [-117.09215, 34.0368]]], [[[-117.09306, 34.0368], [-117.09235, 34.0368], [-117.09235, 34.0367], [-117.09239, 34.03659], [-117.09262, 34.03619], [-117.09268, 34.03605], [-117.09271, 34.03589], [-117.0927, 34.03571], [-117.09263, 34.0355], [-117.09251, 34.03531], [-117.09232, 34.03514], [-117.09202, 34.03497], [-117.0928, 34.03401], [-117.09291, 34.03401], [-117.09292, 34.03525], [-117.09286, 34.03527], [-117.09306, 34.0368]]]]} | Open Access 1 | Yucaipa Skate Park | 27846 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 5.321 | Yucaipa Skate Park | ||
15534 | 15534 | 15533 | {"type": "Polygon", "coordinates": [[[-117.04088, 34.03129], [-117.04088, 34.0317], [-117.04024, 34.0317], [-117.04024, 34.03129], [-117.04088, 34.03129]]]} | Open Access 1 | Center Park | 17038 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 0.67 | Ctr. Park | ||
15552 | 15552 | 15551 | {"type": "Polygon", "coordinates": [[[-117.03651, 34.01272], [-117.03651, 34.01406], [-117.03622, 34.01408], [-117.03483, 34.01386], [-117.03483, 34.01294], [-117.03626, 34.01277], [-117.0365, 34.01267], [-117.0365, 34.01271], [-117.03651, 34.01272]]]} | Open Access 1 | Equestrian Center | 18690 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 4.895 | Equestrian Ctr. |
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]);