superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
81 rows where MNG_AGENCY = 396 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7047 | 7047 | 7046 | {"type": "MultiPolygon", "coordinates": [[[[-121.24276, 37.94494], [-121.24241, 37.94502], [-121.2421, 37.94427], [-121.24212, 37.94424], [-121.24242, 37.94415], [-121.24276, 37.94494]]], [[[-121.24417, 37.94457], [-121.24348, 37.94475], [-121.24316, 37.94397], [-121.24386, 37.94379], [-121.24417, 37.94457]]]]} | Open Access 1 | Missassi Park | 22291 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 2.165 | Missassi Park | ||
7900 | 7900 | 7899 | {"type": "MultiPolygon", "coordinates": [[[[-121.28364, 38.01096], [-121.28243, 38.0118], [-121.28042, 38.0132], [-121.28056, 38.01121], [-121.28104, 38.01109], [-121.28115, 38.01113], [-121.28128, 38.01113], [-121.28143, 38.01107], [-121.2833, 38.01061], [-121.28336, 38.01062], [-121.28364, 38.01096]]], [[[-121.28451, 38.01223], [-121.28448, 38.01226], [-121.282, 38.01288], [-121.28175, 38.01291], [-121.28167, 38.01295], [-121.28161, 38.01301], [-121.28159, 38.01307], [-121.28159, 38.01314], [-121.2805, 38.01336], [-121.28382, 38.01116], [-121.28405, 38.01143], [-121.28423, 38.01168], [-121.28438, 38.01195], [-121.28451, 38.01223]]]]} | Open Access 1 | Panella Park | 23387 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 14.776 | Panella Park | ||
7585 | 7585 | 7584 | {"type": "MultiPolygon", "coordinates": [[[[-121.2903, 37.9856], [-121.2888, 37.98595], [-121.28776, 37.98324], [-121.2892, 37.98287], [-121.2903, 37.9856]]], [[[-121.29659, 37.98407], [-121.29051, 37.98555], [-121.28941, 37.98282], [-121.29117, 37.98237], [-121.29137, 37.9823], [-121.29178, 37.98212], [-121.292, 37.98203], [-121.29224, 37.98196], [-121.29542, 37.98117], [-121.29611, 37.98284], [-121.29659, 37.98407]]]]} | Open Access 1 | Oak Park | 23003 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 56.219 | Oak Park | ||
9628 | 9628 | 9627 | {"type": "Polygon", "coordinates": [[[-121.23922, 37.91548], [-121.23916, 37.9155], [-121.23909, 37.91543], [-121.239, 37.91542], [-121.23892, 37.91546], [-121.23884, 37.9156], [-121.23767, 37.91589], [-121.23728, 37.9149], [-121.23723, 37.91485], [-121.23717, 37.91485], [-121.23717, 37.91445], [-121.23862, 37.91406], [-121.23922, 37.91548]]]} | Open Access 1 | Shropshire Park | 25434 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 5.817 | Shropshire Park | ||
9786 | 9786 | 9785 | {"type": "Polygon", "coordinates": [[[-121.25057, 37.95815], [-121.24988, 37.95834], [-121.24983, 37.95828], [-121.24975, 37.95823], [-121.24966, 37.95822], [-121.24957, 37.95823], [-121.24948, 37.95829], [-121.24943, 37.95839], [-121.24914, 37.95865], [-121.24876, 37.95839], [-121.24837, 37.95831], [-121.24836, 37.9582], [-121.24819, 37.95775], [-121.24824, 37.9577], [-121.24977, 37.9573], [-121.24993, 37.95724], [-121.25013, 37.95713], [-121.25057, 37.95815]]]} | Open Access 1 | Sousa Park | 25635 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 4.796 | Sousa Park | ||
8648 | 8648 | 8647 | {"type": "Polygon", "coordinates": [[[-121.25678, 37.92133], [-121.25525, 37.92171], [-121.25505, 37.92122], [-121.25658, 37.92084], [-121.25678, 37.92133]]]} | Open Access 1 | Reverend Holmes Park | 24304 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1.992 | Reverend Holmes Park | ||
7982 | 7982 | 7981 | {"type": "Polygon", "coordinates": [[[-121.26311, 38.03324], [-121.26307, 38.03328], [-121.26169, 38.03329], [-121.26164, 38.03325], [-121.26163, 38.03207], [-121.26168, 38.03204], [-121.26236, 38.03215], [-121.26302, 38.03222], [-121.26306, 38.03225], [-121.26311, 38.03273], [-121.26311, 38.03324]]]} | Open Access 1 | Parma Sister City Park | 23469 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 4.017 | Parma Sister City Park | ||
3586 | 3586 | 3585 | {"type": "Polygon", "coordinates": [[[-121.2634, 38.04678], [-121.25918, 38.04681], [-121.25898, 38.04416], [-121.25901, 38.04388], [-121.2591, 38.04355], [-121.25911, 38.04302], [-121.26311, 38.04296], [-121.2634, 38.04678]]]} | Open Access 1 | Detention Basin Soccer Complex | 18118 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 38.289 | Detention Basin Soccer Complex | ||
4458 | 4458 | 4457 | {"type": "Polygon", "coordinates": [[[-121.26468, 38.04968], [-121.26465, 38.04973], [-121.26465, 38.04998], [-121.26374, 38.04998], [-121.26363, 38.0485], [-121.26402, 38.04848], [-121.26403, 38.04863], [-121.26402, 38.04882], [-121.26405, 38.04889], [-121.26411, 38.04893], [-121.26421, 38.04896], [-121.26447, 38.04893], [-121.26459, 38.04893], [-121.26461, 38.04895], [-121.26461, 38.04935], [-121.26458, 38.04955], [-121.26461, 38.04963], [-121.26468, 38.04968]]]} | Open Access 1 | Future Stockton City Park 2 | 19163 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 2.713 | Future Stockton City Park 2 | ||
8522 | 8522 | 8521 | {"type": "Polygon", "coordinates": [[[-121.26759, 37.95177], [-121.26567, 37.95226], [-121.26567, 37.95227], [-121.2657, 37.95235], [-121.26318, 37.95299], [-121.26262, 37.95157], [-121.26601, 37.95053], [-121.26631, 37.95045], [-121.26724, 37.95031], [-121.26752, 37.95152], [-121.26759, 37.95177]]]} | Open Access 1 | Stribley Park | 25923 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 17.822 | Stribley Park | ||
11266 | 11266 | 11265 | {"type": "Polygon", "coordinates": [[[-121.26768, 37.93402], [-121.2646, 37.9347], [-121.2642, 37.9336], [-121.26728, 37.9329], [-121.26768, 37.93402]]]} | Open Access 1 | Williams Brotherhood Park | 27561 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 8.872 | Williams Brotherhood Park | ||
8649 | 8649 | 8648 | {"type": "Polygon", "coordinates": [[[-121.27101, 37.92818], [-121.27075, 37.92822], [-121.27051, 37.92832], [-121.27041, 37.92832], [-121.27025, 37.92836], [-121.27013, 37.92797], [-121.26961, 37.92805], [-121.2695, 37.92765], [-121.26957, 37.92756], [-121.26957, 37.92749], [-121.26953, 37.92743], [-121.26943, 37.92738], [-121.26943, 37.92737], [-121.27073, 37.92715], [-121.27101, 37.92818]]]} | Open Access 1 | Reverend Peterson Park | 24305 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 2.934 | Reverend Peterson Park | ||
4421 | 4421 | 4420 | {"type": "Polygon", "coordinates": [[[-121.27386, 37.97288], [-121.27313, 37.97306], [-121.27281, 37.97227], [-121.27358, 37.97208], [-121.27373, 37.97255], [-121.27386, 37.97288]]]} | Open Access 1 | Friedberger Park | 19114 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1.562 | Friedberger Park | ||
4457 | 4457 | 4456 | {"type": "Polygon", "coordinates": [[[-121.27479, 38.0433], [-121.27478, 38.04383], [-121.27472, 38.04441], [-121.27212, 38.04445], [-121.27204, 38.04335], [-121.27211, 38.04329], [-121.27476, 38.04327], [-121.27479, 38.0433]]]} | Open Access 1 | Future Stockton City Park | 19162 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 7.464 | Future Stockton City Park | ||
10529 | 10529 | 10528 | {"type": "Polygon", "coordinates": [[[-121.27519, 37.94883], [-121.27391, 37.94905], [-121.27369, 37.94823], [-121.27497, 37.94801], [-121.27519, 37.94883]]]} | Open Access 1 | Union Square | 26662 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 2.628 | Union Square | ||
10563 | 10563 | 10562 | {"type": "Polygon", "coordinates": [[[-121.27641, 38.01005], [-121.27423, 38.01078], [-121.27414, 38.01074], [-121.27391, 38.00992], [-121.27598, 38.00924], [-121.27641, 38.01005]]]} | Open Access 1 | Unity Park | 26672 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 5.0 | Unity Park | ||
2787 | 2787 | 2786 | {"type": "Polygon", "coordinates": [[[-121.27664, 38.03557], [-121.27664, 38.03661], [-121.27655, 38.03688], [-121.2724, 38.03689], [-121.2723, 38.03682], [-121.27228, 38.03675], [-121.27225, 38.03654], [-121.27227, 38.03634], [-121.27231, 38.03621], [-121.27236, 38.03611], [-121.27247, 38.03599], [-121.27259, 38.0359], [-121.27448, 38.03519], [-121.27664, 38.03557]]]} | Open Access 1 | Matt Equinoa Park | 32973 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 14.515 | Matt Equinoa Park | ||
14138 | 14138 | 14137 | {"type": "Polygon", "coordinates": [[[-121.27757, 37.98952], [-121.27753, 37.98957], [-121.27653, 37.98983], [-121.2759, 37.98828], [-121.27639, 37.98797], [-121.27641, 37.98792], [-121.27642, 37.98777], [-121.27646, 37.98766], [-121.2765, 37.9876], [-121.2766, 37.98751], [-121.27663, 37.98751], [-121.27678, 37.98768], [-121.2769, 37.98789], [-121.27757, 37.98952]]]} | Open Access 1 | Shady Forest | 31579 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 4.968 | Shady Forest | ||
9730 | 9730 | 9729 | {"type": "Polygon", "coordinates": [[[-121.2776, 38.00211], [-121.27728, 38.00219], [-121.27736, 38.00241], [-121.27624, 38.0027], [-121.27615, 38.00266], [-121.27579, 38.00178], [-121.27575, 38.00165], [-121.27566, 38.00154], [-121.27553, 38.0015], [-121.2754, 38.00123], [-121.27548, 38.00119], [-121.27536, 38.00095], [-121.27694, 38.00044], [-121.27746, 38.00171], [-121.27749, 38.00185], [-121.2776, 38.00211]]]} | Open Access 1 | SL Fong Park | 25550 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 7.463 | SL Fong Park | ||
3163 | 3163 | 3162 | {"type": "Polygon", "coordinates": [[[-121.27796, 37.95986], [-121.27692, 37.96003], [-121.2767, 37.95923], [-121.27774, 37.95905], [-121.27796, 37.95986]]]} | Open Access 1 | Constitution Park | 17599 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 2.112 | Constitution 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]);