superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
81 rows where MNG_AGENCY = 396 sorted by rowid 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9977 | 9977 | 9976 | {"type": "Polygon", "coordinates": [[[-121.38181, 38.05445], [-121.38174, 38.05451], [-121.38084, 38.05451], [-121.38077, 38.05445], [-121.38077, 38.05333], [-121.38084, 38.05327], [-121.38174, 38.05327], [-121.38181, 38.05333], [-121.38181, 38.05445]]]} | Open Access 1 | Stockton holding 1 | 25858 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 3.079 | Stockton holding 1 | ||
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 | ||
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 | ||
9715 | 9715 | 9714 | {"type": "Polygon", "coordinates": [[[-121.32409, 37.90976], [-121.32415, 37.91003], [-121.32411, 37.91047], [-121.32387, 37.91089], [-121.32342, 37.91076], [-121.32332, 37.9107], [-121.32311, 37.91066], [-121.32196, 37.91031], [-121.32193, 37.91024], [-121.32207, 37.90998], [-121.32249, 37.90947], [-121.32258, 37.90946], [-121.32307, 37.90967], [-121.32326, 37.90978], [-121.32333, 37.9098], [-121.32341, 37.90981], [-121.32349, 37.90979], [-121.32356, 37.90976], [-121.32361, 37.90971], [-121.32409, 37.90976]]]} | Open Access 1 | Smith Park | 25571 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 4.715 | Smith 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 | ||
9602 | 9602 | 9601 | {"type": "Polygon", "coordinates": [[[-121.31122, 38.00163], [-121.31117, 38.00167], [-121.31078, 38.00177], [-121.31001, 38.00203], [-121.30997, 38.00203], [-121.30991, 38.00199], [-121.30923, 38.00018], [-121.30927, 38.00014], [-121.31049, 37.99986], [-121.31053, 37.99986], [-121.31057, 37.99989], [-121.31087, 38.00067], [-121.31122, 38.00163]]]} | Open Access 1 | Sherwood Forest Park | 25398 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 6.435 | Sherwood Forest Park | ||
9268 | 9268 | 9267 | {"type": "Polygon", "coordinates": [[[-121.35015, 38.02981], [-121.35013, 38.02981], [-121.35007, 38.02977], [-121.35001, 38.02976], [-121.34983, 38.02982], [-121.34566, 38.02985], [-121.34562, 38.02842], [-121.35009, 38.02841], [-121.35015, 38.02981]]]} | Open Access 1 | Sandman Park | 25019 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 15.28 | Sandman 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 | ||
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 | ||
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 | ||
8093 | 8093 | 8092 | {"type": "Polygon", "coordinates": [[[-121.32721, 37.92871], [-121.32679, 37.92881], [-121.32637, 37.92852], [-121.32606, 37.92838], [-121.3258, 37.92829], [-121.32509, 37.92854], [-121.32503, 37.92834], [-121.32491, 37.92817], [-121.32475, 37.92804], [-121.3245, 37.92792], [-121.32447, 37.92788], [-121.32449, 37.92773], [-121.32449, 37.92713], [-121.32456, 37.92701], [-121.32456, 37.92696], [-121.32455, 37.92691], [-121.32451, 37.92688], [-121.3244, 37.92684], [-121.32435, 37.92671], [-121.32435, 37.92662], [-121.3248, 37.92662], [-121.32518, 37.92716], [-121.32556, 37.92764], [-121.32591, 37.92788], [-121.32594, 37.92792], [-121.32624, 37.92803], [-121.32693, 37.92837], [-121.32704, 37.92844], [-121.32721, 37.92871]]]} | Open Access 1 | Peri Park | 23610 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 5.057 | Peri 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 | ||
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 | ||
7469 | 7469 | 7468 | {"type": "Polygon", "coordinates": [[[-121.29836, 37.95423], [-121.29765, 37.95435], [-121.29745, 37.95427], [-121.29721, 37.95431], [-121.29711, 37.95444], [-121.29674, 37.9545], [-121.29678, 37.95444], [-121.29671, 37.9544], [-121.2965, 37.95444], [-121.29635, 37.95436], [-121.29585, 37.95445], [-121.29569, 37.95464], [-121.29559, 37.95466], [-121.2956, 37.95476], [-121.29554, 37.95483], [-121.29543, 37.95486], [-121.29531, 37.95485], [-121.29515, 37.95515], [-121.29519, 37.95522], [-121.2951, 37.95538], [-121.29501, 37.95541], [-121.29489, 37.95563], [-121.29482, 37.95566], [-121.29491, 37.95601], [-121.29449, 37.95608], [-121.29341, 37.9568], [-121.29338, 37.9567], [-121.29347, 37.9567], [-121.29454, 37.95598], [-121.29472, 37.95561], [-121.2948, 37.95558], [-121.29499, 37.95534], [-121.29518, 37.95501], [-121.29518, 37.95492], [-121.29532, 37.95469], [-121.29538, 37.95461], [-121.29544, 37.95461], [-121.29564, 37.95457], [-121.29579, 37.95439], [-121.29636, 37.95429], [-121.29651, 37.95436], [-121.29671, 37.95433], [-121.29676, 37.95435], [-121.29712, 37.95428], [-121.29716, 37.95426], [-121.29722, 37.95425], [-121.29724, 37.95423], [-121.29745, 37.9542], [-121.29763, 37.95426], [-121.29834, 37.95414], [-121.29836, 37.95423]]]} | Open Access 1 | North Seawall Park | 22858 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1.46 | North Seawall Park | ||
7337 | 7337 | 7336 | {"type": "Polygon", "coordinates": [[[-121.36136, 37.98621], [-121.36133, 37.98643], [-121.36097, 37.98725], [-121.36089, 37.98729], [-121.36082, 37.98737], [-121.36084, 37.98748], [-121.36095, 37.9875], [-121.36103, 37.9875], [-121.36116, 37.98745], [-121.36116, 37.98823], [-121.35912, 37.98821], [-121.35913, 37.98797], [-121.3591, 37.98777], [-121.35898, 37.98745], [-121.35879, 37.98715], [-121.35854, 37.98689], [-121.35808, 37.98654], [-121.35827, 37.98636], [-121.35862, 37.98624], [-121.36004, 37.98613], [-121.36036, 37.98613], [-121.36136, 37.98621]]]} | Open Access 1 | Nelson Park | 22697 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 11.881 | Nelson Park | ||
7202 | 7202 | 7201 | {"type": "Polygon", "coordinates": [[[-121.30763, 37.95252], [-121.30732, 37.95269], [-121.30735, 37.9528], [-121.30728, 37.95289], [-121.30719, 37.95295], [-121.30706, 37.95294], [-121.30686, 37.95287], [-121.3052, 37.95215], [-121.30588, 37.95168], [-121.30763, 37.95252]]]} | Open Access 1 | Morelli Park | 22475 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 3.24 | Morelli Park | ||
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 | ||
6849 | 6849 | 6848 | {"type": "Polygon", "coordinates": [[[-121.29358, 37.95718], [-121.29262, 37.95734], [-121.29215, 37.95577], [-121.29266, 37.9557], [-121.29287, 37.9566], [-121.29267, 37.95658], [-121.29266, 37.95659], [-121.29314, 37.95697], [-121.29347, 37.95677], [-121.29358, 37.95718]]]} | Open Access 1 | McLeod Park | 22056 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 2.239 | McLeod Park | ||
6837 | 6837 | 6836 | {"type": "Polygon", "coordinates": [[[-121.28245, 37.92874], [-121.27979, 37.92942], [-121.2792, 37.92798], [-121.27957, 37.92788], [-121.27941, 37.9275], [-121.27925, 37.92754], [-121.27934, 37.92777], [-121.27827, 37.92804], [-121.27816, 37.92778], [-121.278, 37.9278], [-121.27799, 37.92782], [-121.2781, 37.92808], [-121.27745, 37.92825], [-121.2773, 37.92789], [-121.27722, 37.9278], [-121.27711, 37.92774], [-121.27709, 37.92771], [-121.27668, 37.9267], [-121.27872, 37.9262], [-121.27873, 37.92618], [-121.27868, 37.92606], [-121.27915, 37.92595], [-121.27966, 37.92736], [-121.28129, 37.92706], [-121.2813, 37.92702], [-121.28171, 37.92692], [-121.28245, 37.92874]]]} | Open Access 1 | McKinley Park | 22048 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 22.576 | McKinley 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]);