superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where MNG_AGENCY = 156 sorted by PARK_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11356 | 11356 | 11355 | {"type": "Polygon", "coordinates": [[[-117.14745, 33.63659], [-117.14743, 33.63711], [-117.1473, 33.63771], [-117.14628, 33.6377], [-117.1457, 33.63776], [-117.14565, 33.63775], [-117.14565, 33.63773], [-117.14558, 33.63768], [-117.14557, 33.6362], [-117.14581, 33.6362], [-117.14597, 33.63623], [-117.14633, 33.63635], [-117.14648, 33.63646], [-117.14667, 33.63664], [-117.14703, 33.63668], [-117.14745, 33.63659]]]} | Open Access 1 | Woodbine Park | 27682 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 5.863 | Woodbine Park | ||
1830 | 1830 | 1829 | {"type": "Polygon", "coordinates": [[[-117.08924, 33.70343], [-117.08706, 33.70344], [-117.08706, 33.7026], [-117.08923, 33.7026], [-117.08924, 33.70343]]]} | Open Access 1 | Winchester Park | https://www.gorecreation.org/winchester-park | 32958 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 4.617 | Winchester Park | |
11173 | 11173 | 11172 | {"type": "Polygon", "coordinates": [[[-117.16102, 33.67575], [-117.1606, 33.67571], [-117.16019, 33.67569], [-117.15874, 33.67568], [-117.15832, 33.67565], [-117.15805, 33.6756], [-117.15778, 33.67551], [-117.15753, 33.6754], [-117.15729, 33.67527], [-117.15728, 33.67518], [-117.15756, 33.67483], [-117.15769, 33.67465], [-117.15792, 33.67428], [-117.1581, 33.67388], [-117.15817, 33.67368], [-117.15829, 33.67327], [-117.15836, 33.67286], [-117.15838, 33.67265], [-117.15838, 33.67219], [-117.16102, 33.67219], [-117.16102, 33.67575]]]} | Open Access 1 | Wheatfield Park | 27450 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 26.884 | Wheatfield Park | ||
1818 | 1818 | 1817 | {"type": "Polygon", "coordinates": [[[-117.10035, 33.59259], [-117.10035, 33.59281], [-117.09998, 33.59281], [-117.09998, 33.59259], [-117.10035, 33.59259]]]} | Open Access 1 | Watermill Park | https://www.gorecreation.org/watermill-park | 32956 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.202 | Watermill Park | |
1829 | 1829 | 1828 | {"type": "Polygon", "coordinates": [[[-117.08763, 33.62003], [-117.08747, 33.62042], [-117.08731, 33.62075], [-117.08708, 33.62114], [-117.08686, 33.62144], [-117.08672, 33.62146], [-117.08613, 33.6211], [-117.08582, 33.62084], [-117.08558, 33.62059], [-117.08556, 33.62054], [-117.08589, 33.62021], [-117.08615, 33.62004], [-117.08763, 33.62003]]]} | Open Access 1 | Washington Park | https://www.gorecreation.org/washington-park | 32957 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 4.751 | Washington Park | |
1037 | 1037 | 1036 | {"type": "Polygon", "coordinates": [[[-117.09164, 33.59241], [-117.09164, 33.59294], [-117.09127, 33.59294], [-117.09128, 33.59241], [-117.09164, 33.59241]]]} | Open Access 1 | Wagon Wheel Park | https://www.gorecreation.org/wagon-wheel-pocket-park | 32813 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.493 | Wagon Wheel Park | |
1803 | 1803 | 1802 | {"type": "Polygon", "coordinates": [[[-117.12524, 33.61775], [-117.1252, 33.61781], [-117.12512, 33.61779], [-117.12504, 33.61781], [-117.12499, 33.61786], [-117.12497, 33.6179], [-117.12497, 33.61797], [-117.12508, 33.61815], [-117.1251, 33.61824], [-117.1251, 33.61875], [-117.12505, 33.61879], [-117.1246, 33.61878], [-117.12428, 33.61874], [-117.12289, 33.61845], [-117.12287, 33.61838], [-117.12314, 33.61751], [-117.12319, 33.61745], [-117.12411, 33.61765], [-117.1244, 33.6177], [-117.12469, 33.61772], [-117.12524, 33.61772], [-117.12524, 33.61775]]]} | Open Access 1 | Victory Park | https://www.gorecreation.org/victory-park | 32955 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 5.573 | Victory Park | |
10635 | 10635 | 10634 | {"type": "Polygon", "coordinates": [[[-116.97842, 33.77656], [-116.97832, 33.77657], [-116.97832, 33.77675], [-116.97407, 33.77677], [-116.97406, 33.77478], [-116.97515, 33.77476], [-116.97514, 33.77305], [-116.97822, 33.77304], [-116.97831, 33.7731], [-116.97831, 33.77394], [-116.97834, 33.7741], [-116.97841, 33.77424], [-116.97842, 33.77656]]]} | Open Access 1 | Valley-Wide Regional Park | 26784 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 35.983 | Valley-Wide RP | ||
1032 | 1032 | 1031 | {"type": "Polygon", "coordinates": [[[-116.89525, 33.7441], [-116.89337, 33.74412], [-116.89328, 33.74405], [-116.89328, 33.74281], [-116.89515, 33.74281], [-116.89518, 33.74327], [-116.89525, 33.74369], [-116.89525, 33.7441]]]} | Open Access 1 | Valle Vista Community Center Park | https://www.gorecreation.org/valle-vista-community-center | 32811 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 6.349 | Valle Vista Community Ctr. Park | |
1057 | 1057 | 1056 | {"type": "Polygon", "coordinates": [[[-116.89403, 33.75911], [-116.89402, 33.7592], [-116.89372, 33.75945], [-116.89348, 33.75971], [-116.89336, 33.7599], [-116.89326, 33.7601], [-116.89319, 33.76013], [-116.89307, 33.7601], [-116.89305, 33.75874], [-116.8932, 33.75872], [-116.89319, 33.75788], [-116.89322, 33.75789], [-116.89332, 33.75814], [-116.89345, 33.75837], [-116.89366, 33.75869], [-116.89321, 33.75894], [-116.89321, 33.75896], [-116.89355, 33.75931], [-116.89398, 33.75906], [-116.89403, 33.75911]]]} | Open Access 1 | Valle Vista | 32830 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2.049 | Valle Vista | ||
1802 | 1802 | 1801 | {"type": "Polygon", "coordinates": [[[-117.10368, 33.56934], [-117.10349, 33.5695], [-117.10328, 33.56964], [-117.10305, 33.56976], [-117.10281, 33.56986], [-117.10252, 33.56992], [-117.10235, 33.56998], [-117.1021, 33.57001], [-117.10184, 33.57002], [-117.1018, 33.56996], [-117.10181, 33.56909], [-117.10179, 33.56869], [-117.10174, 33.5683], [-117.10162, 33.56772], [-117.10331, 33.56894], [-117.10368, 33.56934]], [[-117.10326, 33.56921], [-117.10295, 33.5694], [-117.10314, 33.56961], [-117.10344, 33.56942], [-117.10326, 33.56921]]]} | Open Access 1 | Tucalota Park | https://www.gorecreation.org/tucalota-park | 32954 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 6.009 | Tucalota Park | |
10110 | 10110 | 10109 | {"type": "MultiPolygon", "coordinates": [[[[-117.15071, 33.71106], [-117.15047, 33.71125], [-117.1483, 33.70946], [-117.14795, 33.70921], [-117.14757, 33.70902], [-117.14736, 33.70894], [-117.14712, 33.70887], [-117.14666, 33.70878], [-117.1463, 33.70876], [-117.14549, 33.70876], [-117.1454, 33.70869], [-117.14539, 33.70708], [-117.14555, 33.70695], [-117.14757, 33.70698], [-117.14756, 33.70842], [-117.14855, 33.70924], [-117.14852, 33.7093], [-117.15071, 33.71106]]], [[[-117.15379, 33.71395], [-117.15075, 33.7115], [-117.15065, 33.71141], [-117.15092, 33.7112], [-117.15111, 33.71138], [-117.15131, 33.71153], [-117.15146, 33.71167], [-117.15149, 33.71168], [-117.15164, 33.71182], [-117.15166, 33.71182], [-117.15182, 33.71196], [-117.15378, 33.71354], [-117.15379, 33.71395]]]]} | Open Access 1 | Sunrise Park | 26028 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 16.291 | Sunrise Park | ||
1779 | 1779 | 1778 | {"type": "Polygon", "coordinates": [[[-117.12666, 33.60337], [-117.12642, 33.60338], [-117.12634, 33.60344], [-117.12614, 33.60397], [-117.12609, 33.60403], [-117.126, 33.6041], [-117.12598, 33.60425], [-117.12589, 33.60441], [-117.12586, 33.6046], [-117.1258, 33.60466], [-117.1256, 33.60452], [-117.12526, 33.60422], [-117.1251, 33.60406], [-117.1251, 33.60402], [-117.12495, 33.60384], [-117.12488, 33.60381], [-117.12481, 33.60373], [-117.12455, 33.60333], [-117.12417, 33.60257], [-117.12433, 33.60226], [-117.12621, 33.60171], [-117.12636, 33.60165], [-117.12657, 33.60158], [-117.12657, 33.6023], [-117.12666, 33.60317], [-117.12666, 33.60337]]]} | Open Access 1 | Spencer's Crossing Sports Park | https://www.gorecreation.org/spencer-s-crossing-sports-park | 32953 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 11.574 | Spencer's Crossing Sports Park | |
1774 | 1774 | 1773 | {"type": "Polygon", "coordinates": [[[-117.10569, 33.59244], [-117.10566, 33.59249], [-117.10549, 33.59255], [-117.10527, 33.59259], [-117.10527, 33.59237], [-117.10566, 33.59232], [-117.10569, 33.59244]]]} | Open Access 1 | Sicily Pocket Park | https://www.gorecreation.org/sicily-pocket-park | 32952 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.212 | Sicily PP | |
1773 | 1773 | 1772 | {"type": "Polygon", "coordinates": [[[-117.10414, 33.59578], [-117.10314, 33.59579], [-117.10235, 33.59573], [-117.10126, 33.59573], [-117.10119, 33.59566], [-117.10119, 33.59378], [-117.10149, 33.59377], [-117.10195, 33.5938], [-117.10217, 33.59384], [-117.10258, 33.59395], [-117.10253, 33.59434], [-117.10304, 33.59459], [-117.10341, 33.59472], [-117.10369, 33.59478], [-117.10413, 33.59481], [-117.10414, 33.59578]]]} | Open Access 1 | Sheffield Park | https://www.gorecreation.org/sheffield-park | 32951 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 11.164 | Sheffield Park | |
7768 | 7768 | 7767 | {"type": "MultiPolygon", "coordinates": [[[[-116.97389, 33.8206], [-116.97385, 33.82061], [-116.97383, 33.82076], [-116.97369, 33.82132], [-116.97296, 33.82208], [-116.97298, 33.82244], [-116.97248, 33.82236], [-116.97231, 33.82235], [-116.97213, 33.82237], [-116.97195, 33.82241], [-116.97083, 33.8228], [-116.97083, 33.82282], [-116.97085, 33.82284], [-116.97079, 33.82283], [-116.96954, 33.8221], [-116.96917, 33.82185], [-116.96941, 33.82193], [-116.96942, 33.82191], [-116.96882, 33.82151], [-116.96728, 33.82063], [-116.96925, 33.81897], [-116.96925, 33.81895], [-116.96475, 33.81713], [-116.96418, 33.81688], [-116.96355, 33.81655], [-116.96625, 33.81654], [-116.97061, 33.81781], [-116.97216, 33.81651], [-116.97221, 33.81651], [-116.97236, 33.81694], [-116.97251, 33.81729], [-116.97379, 33.82002], [-116.97388, 33.82032], [-116.97389, 33.8206]]], [[[-116.97209, 33.8164], [-116.97063, 33.81762], [-116.9669, 33.81654], [-116.96702, 33.81653], [-116.96683, 33.81645], [-116.96679, 33.81605], [-116.97207, 33.81627], [-116.97209, 33.8164]]], [[[-116.97454, 33.82302], [-116.97444, 33.82314], [-116.97395, 33.82284], [-116.97395, 33.82281], [-116.97385, 33.82274], [-116.97377, 33.82265], [-116.9737, 33.8225], [-116.97369, 33.82241], [-116.97369, 33.8223], [-116.97398, 33.82117], [-116.97439, 33.82263], [-116.97454, 33.82302]]]]} | Open Access 1 | San Jacinto River Park | 24905 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 88.794 | San Jacinto River Park | ||
8919 | 8919 | 8918 | {"type": "Polygon", "coordinates": [[[-117.15436, 33.65971], [-117.15425, 33.65986], [-117.15419, 33.66001], [-117.15416, 33.66016], [-117.15416, 33.66038], [-117.15407, 33.66045], [-117.15396, 33.66045], [-117.15397, 33.66005], [-117.15418, 33.65966], [-117.15431, 33.65967], [-117.15436, 33.65971]]]} | Open Access 1 | Rolling Hills Park | 24582 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.378 | Rolling Hills Park | ||
8684 | 8684 | 8683 | {"type": "Polygon", "coordinates": [[[-117.14906, 33.69572], [-117.14903, 33.69575], [-117.14866, 33.69568], [-117.14869, 33.69561], [-117.14868, 33.69555], [-117.1486, 33.6954], [-117.14891, 33.69532], [-117.14906, 33.69572]]]} | Open Access 1 | Richmond Park | 24341 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.305 | Richmond Park | ||
8532 | 8532 | 8531 | {"type": "Polygon", "coordinates": [[[-116.94753, 33.77378], [-116.94645, 33.77378], [-116.94643, 33.77353], [-116.94504, 33.7735], [-116.94411, 33.77344], [-116.94409, 33.77242], [-116.94607, 33.7724], [-116.94608, 33.7727], [-116.94639, 33.77271], [-116.94642, 33.77315], [-116.94752, 33.77314], [-116.94753, 33.77378]]]} | Open Access 1 | Rancho Park | 24162 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 7.901 | Rancho Park | ||
1725 | 1725 | 1724 | {"type": "Polygon", "coordinates": [[[-117.10739, 33.5618], [-117.10726, 33.56198], [-117.10691, 33.56184], [-117.10667, 33.56178], [-117.10481, 33.5615], [-117.10488, 33.56124], [-117.10476, 33.56095], [-117.10462, 33.56091], [-117.10488, 33.56061], [-117.10506, 33.56033], [-117.10522, 33.56023], [-117.10531, 33.5602], [-117.1054, 33.56019], [-117.10553, 33.56021], [-117.10561, 33.56024], [-117.10568, 33.5603], [-117.10587, 33.56056], [-117.10606, 33.56072], [-117.10616, 33.56101], [-117.10622, 33.5611], [-117.10628, 33.56116], [-117.10641, 33.56124], [-117.10653, 33.56135], [-117.10666, 33.56143], [-117.10682, 33.56148], [-117.10703, 33.56151], [-117.10716, 33.56156], [-117.10725, 33.56164], [-117.10739, 33.5618]]]} | Open Access 1 | Rancho Bella Vista Park | https://www.gorecreation.org/rancho-bella-vista-park-and-community-center | 32950 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 5.345 | Rancho Bella Vista 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]);