superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where MNG_AGENCY = 156 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 47 ✖
MNG_AGENCY 1
- Valley-Wide Recreation and Park District · 47 ✖
ACCESS_TYP 1
- Open Access 47
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1329 | 1329 | 1328 | {"type": "Polygon", "coordinates": [[[-117.11809, 33.60912], [-117.1177, 33.60913], [-117.11763, 33.60919], [-117.11757, 33.60916], [-117.11748, 33.60914], [-117.11728, 33.60917], [-117.11713, 33.60916], [-117.11713, 33.60891], [-117.11707, 33.6089], [-117.11708, 33.60844], [-117.11675, 33.60837], [-117.11676, 33.60828], [-117.11681, 33.60805], [-117.11687, 33.60802], [-117.1173, 33.60803], [-117.11751, 33.60806], [-117.11765, 33.60802], [-117.11808, 33.60802], [-117.11809, 33.60912]]]} | Open Access 1 | Leon Park | https://www.gorecreation.org/leon-park | 32942 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 3.124 | Leon Park | |
1346 | 1346 | 1345 | {"type": "Polygon", "coordinates": [[[-117.14505, 33.7032], [-117.1446, 33.7032], [-117.14454, 33.70316], [-117.14445, 33.70315], [-117.14422, 33.70317], [-117.14303, 33.70317], [-117.14301, 33.70325], [-117.14217, 33.70324], [-117.14155, 33.70321], [-117.14142, 33.70306], [-117.14087, 33.70291], [-117.14087, 33.70237], [-117.14228, 33.7028], [-117.14268, 33.70289], [-117.14308, 33.70294], [-117.1436, 33.70297], [-117.14407, 33.70296], [-117.14459, 33.70289], [-117.14505, 33.70279], [-117.14505, 33.7032]]]} | Open Access 1 | Mahogany Creek Park | https://www.gorecreation.org/mahogany-creek-park-8d59dd1 | 32943 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 3.94 | Mahogany Creek Park | |
1356 | 1356 | 1355 | {"type": "Polygon", "coordinates": [[[-117.14454, 33.70443], [-117.14404, 33.70443], [-117.14404, 33.70421], [-117.14454, 33.70421], [-117.14454, 33.70443]]]} | Open Access 1 | Mahogany Creek Pocket Park | 32944 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.281 | Mahogany Creek PP | ||
1357 | 1357 | 1356 | {"type": "Polygon", "coordinates": [[[-117.13273, 33.61299], [-117.13267, 33.61334], [-117.13238, 33.61333], [-117.13235, 33.61297], [-117.13273, 33.61299]]]} | Open Access 1 | Mahogany Meadows Pocket Park | https://www.gorecreation.org/mahogany-meadows-pocket-park | 32945 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.3 | Mahogany Meadows PP | |
1371 | 1371 | 1370 | {"type": "Polygon", "coordinates": [[[-117.13403, 33.61701], [-117.13395, 33.61707], [-117.13333, 33.617], [-117.13282, 33.61699], [-117.13274, 33.61693], [-117.13274, 33.61668], [-117.13278, 33.61651], [-117.13278, 33.61645], [-117.13273, 33.61639], [-117.13265, 33.61637], [-117.13264, 33.61635], [-117.13261, 33.61635], [-117.1325, 33.61602], [-117.13258, 33.616], [-117.13263, 33.61592], [-117.13259, 33.61572], [-117.13259, 33.61544], [-117.13266, 33.61539], [-117.13289, 33.61536], [-117.13311, 33.61532], [-117.13381, 33.61508], [-117.13391, 33.61513], [-117.13398, 33.61534], [-117.13402, 33.61557], [-117.13403, 33.61701]]]} | Open Access 1 | Mahogany Meadows Park | https://github.com/GreenInfo-Network/cpad/issues/37 | 32946 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 6.166 | Mahogany Meadows Park | |
1406 | 1406 | 1405 | {"type": "Polygon", "coordinates": [[[-117.1093, 33.59153], [-117.1089, 33.59184], [-117.10882, 33.59184], [-117.10882, 33.59154], [-117.10914, 33.59157], [-117.10922, 33.59155], [-117.10929, 33.59152], [-117.1093, 33.59153]]]} | Open Access 1 | Pompei Pocket Park | https://www.gorecreation.org/pompei-pocket-park | 32947 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.197 | Pompei PP | |
1428 | 1428 | 1427 | {"type": "Polygon", "coordinates": [[[-117.10253, 33.61115], [-117.1013, 33.61115], [-117.10128, 33.60911], [-117.10251, 33.60901], [-117.10253, 33.61115]]]} | Open Access 1 | Pourroy Fields | https://www.gorecreation.org/pourroy-fields | 32948 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 6.551 | Pourroy Fields | |
1429 | 1429 | 1428 | {"type": "Polygon", "coordinates": [[[-117.10871, 33.60376], [-117.10808, 33.60376], [-117.10803, 33.6038], [-117.10795, 33.60373], [-117.108, 33.60362], [-117.10791, 33.60312], [-117.10865, 33.60308], [-117.10871, 33.60312], [-117.10871, 33.60376]]]} | Open Access 1 | Primrose Park | https://www.gorecreation.org/primrose-park | 32949 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 1.259 | Primrose Park | |
1694 | 1694 | 1693 | {"type": "Polygon", "coordinates": [[[-117.16253, 33.66383], [-117.16252, 33.66493], [-117.16247, 33.66497], [-117.16218, 33.66497], [-117.16213, 33.66493], [-117.16211, 33.66466], [-117.16206, 33.66446], [-117.16195, 33.66425], [-117.16181, 33.66408], [-117.16181, 33.66403], [-117.16204, 33.6639], [-117.1621, 33.66382], [-117.16253, 33.66383]]]} | Open Access 1 | Autumn Breeze Park | 15715 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 1.485 | Autumn Breeze 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
1856 | 1856 | 1855 | {"type": "Polygon", "coordinates": [[[-117.1099, 33.59108], [-117.10987, 33.59122], [-117.10982, 33.59131], [-117.10976, 33.59136], [-117.10963, 33.59141], [-117.10945, 33.59141], [-117.1093, 33.59153], [-117.10929, 33.59152], [-117.10934, 33.59147], [-117.10936, 33.5914], [-117.10933, 33.59112], [-117.10941, 33.59108], [-117.1099, 33.59108]]]} | Open Access 1 | Capri Park | https://www.gorecreation.org/capri-pocket-park | 32961 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.419 | Capri Park | |
1891 | 1891 | 1890 | {"type": "Polygon", "coordinates": [[[-117.01524, 33.75152], [-117.01524, 33.75213], [-117.01462, 33.75212], [-117.01463, 33.75152], [-117.01524, 33.75152]]]} | Open Access 1 | Cawtson Park | https://www.gorecreation.org/devonshire | 32962 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.956 | Cawtson 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]);