superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
81 rows where MNG_AGENCY = 396 sorted by AGNCY_WEB
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4165 | 4165 | 4164 | {"type": "Polygon", "coordinates": [[[-121.37976, 38.04623], [-121.37927, 38.0471], [-121.37933, 38.04716], [-121.37939, 38.04725], [-121.37957, 38.04736], [-121.37973, 38.04748], [-121.37974, 38.04756], [-121.37952, 38.04779], [-121.37928, 38.04813], [-121.37905, 38.04855], [-121.37897, 38.04882], [-121.37889, 38.04886], [-121.37778, 38.04873], [-121.3771, 38.0486], [-121.37638, 38.04842], [-121.37674, 38.04714], [-121.37655, 38.04645], [-121.37782, 38.04624], [-121.37796, 38.04625], [-121.37833, 38.04621], [-121.37841, 38.04658], [-121.37905, 38.04651], [-121.3792, 38.04625], [-121.37918, 38.04612], [-121.3797, 38.04606], [-121.37976, 38.04623]]]} | Open Access 1 | Faklis Community Park | 18828 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 16.188 | Faklis Community Park | ||
4413 | 4413 | 4412 | {"type": "Polygon", "coordinates": [[[-121.28838, 37.95808], [-121.28734, 37.95826], [-121.28712, 37.95745], [-121.28814, 37.95727], [-121.28838, 37.95808]]]} | Open Access 1 | Fremont Square | 19103 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 2.102 | Fremont Square | ||
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 | ||
4434 | 4434 | 4433 | {"type": "Polygon", "coordinates": [[[-121.35707, 37.99503], [-121.35688, 37.99516], [-121.35675, 37.9953], [-121.35667, 37.99546], [-121.35663, 37.99566], [-121.35666, 37.99829], [-121.35669, 37.99847], [-121.35675, 37.99863], [-121.35687, 37.99882], [-121.35699, 37.99895], [-121.35699, 37.99899], [-121.35697, 37.99901], [-121.35657, 37.99928], [-121.35641, 37.99934], [-121.35625, 37.99938], [-121.35597, 37.99941], [-121.35493, 37.99941], [-121.35488, 37.99936], [-121.35488, 37.99911], [-121.35495, 37.99883], [-121.35503, 37.99881], [-121.355, 37.99595], [-121.35498, 37.99583], [-121.35494, 37.99572], [-121.35493, 37.99454], [-121.3566, 37.99445], [-121.35707, 37.99503]]]} | Open Access 1 | Fritz Grupe Park | 19128 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 20.416 | Fritz Grupe 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 | ||
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 | ||
4503 | 4503 | 4502 | {"type": "Polygon", "coordinates": [[[-121.36682, 38.04354], [-121.36682, 38.0438], [-121.3667, 38.04389], [-121.36664, 38.04386], [-121.36503, 38.04499], [-121.36481, 38.04467], [-121.36459, 38.04445], [-121.36429, 38.04425], [-121.36396, 38.04409], [-121.36424, 38.04362], [-121.36459, 38.04358], [-121.36682, 38.04354]]]} | Open Access 1 | Garrigan Park | 19224 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 5.518 | Garrigan Park | ||
4556 | 4556 | 4555 | {"type": "Polygon", "coordinates": [[[-121.33843, 38.02211], [-121.33576, 38.02212], [-121.33575, 38.02155], [-121.33596, 38.0216], [-121.3361, 38.02161], [-121.33628, 38.02159], [-121.33665, 38.02149], [-121.33684, 38.02146], [-121.33841, 38.02147], [-121.33843, 38.02211]]]} | Open Access 1 | Gibbons Park | 19286 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 3.948 | Gibbons Park | ||
4579 | 4579 | 4578 | {"type": "Polygon", "coordinates": [[[-121.28336, 37.94962], [-121.28232, 37.9498], [-121.28209, 37.94898], [-121.28313, 37.9488], [-121.28336, 37.94962]]]} | Open Access 1 | Gleason Park | 19312 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 2.173 | Gleason Park | ||
4634 | 4634 | 4633 | {"type": "Polygon", "coordinates": [[[-121.29255, 37.9584], [-121.29152, 37.95858], [-121.2913, 37.95776], [-121.29233, 37.95758], [-121.29255, 37.9584]]]} | Open Access 1 | King Plaza | 20658 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 2.121 | King Plaza | ||
5206 | 5206 | 5205 | {"type": "Polygon", "coordinates": [[[-121.30198, 38.00577], [-121.30165, 38.00587], [-121.30156, 38.00583], [-121.30138, 38.00583], [-121.30132, 38.00585], [-121.30127, 38.00589], [-121.30081, 38.006], [-121.30077, 38.006], [-121.30073, 38.00596], [-121.30065, 38.0057], [-121.3005, 38.00529], [-121.3005, 38.00527], [-121.30054, 38.00524], [-121.30099, 38.00513], [-121.30115, 38.00512], [-121.30125, 38.00506], [-121.30163, 38.00497], [-121.30198, 38.00577]]]} | Open Access 1 | Holiday Park | 20032 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 2.381 | Holiday Park | ||
5325 | 5325 | 5324 | {"type": "Polygon", "coordinates": [[[-121.28026, 37.95321], [-121.2792, 37.95339], [-121.279, 37.95257], [-121.28005, 37.9524], [-121.28026, 37.95321]]]} | Open Access 1 | Independence Park | 20192 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 2.177 | Independence Park | ||
5329 | 5329 | 5328 | {"type": "Polygon", "coordinates": [[[-121.39013, 38.05312], [-121.39003, 38.05314], [-121.39003, 38.05438], [-121.38907, 38.05438], [-121.38864, 38.05441], [-121.38817, 38.0545], [-121.38749, 38.05468], [-121.38748, 38.05466], [-121.38829, 38.054], [-121.38859, 38.05372], [-121.38954, 38.05243], [-121.38953, 38.05235], [-121.38981, 38.05231], [-121.38993, 38.05279], [-121.38994, 38.05301], [-121.39002, 38.05309], [-121.39013, 38.05312]]]} | Open Access 1 | Iloilo Park | 20177 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 6.107 | Iloilo Park | ||
5738 | 5738 | 5737 | {"type": "Polygon", "coordinates": [[[-121.28996, 37.92752], [-121.28994, 37.92753], [-121.28844, 37.92785], [-121.2884, 37.92785], [-121.28833, 37.92758], [-121.28816, 37.92717], [-121.28809, 37.92717], [-121.28757, 37.92588], [-121.28923, 37.92551], [-121.28976, 37.92681], [-121.28969, 37.92685], [-121.28996, 37.92752]]]} | Open Access 1 | Mattie Harrell Park | 21958 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 8.494 | Mattie Harrell Park | ||
5871 | 5871 | 5870 | {"type": "Polygon", "coordinates": [[[-121.28747, 37.9447], [-121.28646, 37.94488], [-121.28622, 37.94406], [-121.28724, 37.94388], [-121.28747, 37.9447]]]} | Open Access 1 | Lafayette Square | 20835 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 2.105 | Lafayette Square | ||
6034 | 6034 | 6033 | {"type": "Polygon", "coordinates": [[[-121.35181, 38.0412], [-121.3518, 38.04233], [-121.35177, 38.04239], [-121.3517, 38.04246], [-121.35168, 38.04251], [-121.35171, 38.04259], [-121.35178, 38.04264], [-121.35076, 38.04263], [-121.35031, 38.04265], [-121.35031, 38.04117], [-121.35179, 38.04118], [-121.35181, 38.0412]]]} | Open Access 1 | Laughlin Park | 21085 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 5.196 | Laughlin Park | ||
6153 | 6153 | 6152 | {"type": "Polygon", "coordinates": [[[-121.27912, 37.94406], [-121.27807, 37.94424], [-121.27785, 37.94344], [-121.2789, 37.94326], [-121.27912, 37.94406]]]} | Open Access 1 | Liberty Square | 21214 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 2.142 | Liberty Square | ||
6315 | 6315 | 6314 | {"type": "Polygon", "coordinates": [[[-121.31945, 38.02776], [-121.3194, 38.028], [-121.3194, 38.02819], [-121.31641, 38.02818], [-121.31641, 38.0271], [-121.31677, 38.0271], [-121.31707, 38.02707], [-121.31708, 38.02711], [-121.31711, 38.02716], [-121.31723, 38.02723], [-121.31731, 38.02724], [-121.31751, 38.02721], [-121.31782, 38.02725], [-121.31797, 38.02729], [-121.31902, 38.02764], [-121.31941, 38.02774], [-121.31945, 38.02776]]]} | Open Access 1 | Loch Lomond Park | 21393 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 6.111 | Loch Lomond Park | ||
6361 | 6361 | 6360 | {"type": "Polygon", "coordinates": [[[-121.29923, 37.90144], [-121.29918, 37.90161], [-121.29802, 37.90143], [-121.29753, 37.90143], [-121.2975, 37.90157], [-121.29756, 37.90168], [-121.29768, 37.90179], [-121.29776, 37.90175], [-121.29785, 37.90175], [-121.29794, 37.90176], [-121.29793, 37.90182], [-121.29783, 37.9018], [-121.29771, 37.90184], [-121.29769, 37.9019], [-121.29769, 37.90197], [-121.29774, 37.90201], [-121.29781, 37.90204], [-121.29781, 37.90208], [-121.29775, 37.9022], [-121.29768, 37.90228], [-121.29748, 37.90241], [-121.29739, 37.90245], [-121.29724, 37.90258], [-121.29718, 37.90282], [-121.29624, 37.90289], [-121.2962, 37.90275], [-121.29598, 37.90279], [-121.29585, 37.90251], [-121.29551, 37.9026], [-121.29539, 37.90236], [-121.29535, 37.90233], [-121.29519, 37.90232], [-121.29495, 37.90235], [-121.29492, 37.90207], [-121.29589, 37.90207], [-121.29598, 37.90205], [-121.29603, 37.902], [-121.29604, 37.90192], [-121.29596, 37.90182], [-121.29593, 37.90174], [-121.29593, 37.90054], [-121.296, 37.90049], [-121.29659, 37.90052], [-121.29691, 37.90058], [-121.29716, 37.90065], [-121.2992, 37.90137], [-121.29923, 37.90144]]]} | Open Access 1 | Long Park | 21449 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 11.296 | Long Park | ||
6430 | 6430 | 6429 | {"type": "Polygon", "coordinates": [[[-121.35337, 37.95751], [-121.35333, 37.95762], [-121.3532, 37.95766], [-121.35303, 37.95763], [-121.35206, 37.95732], [-121.35197, 37.95727], [-121.35133, 37.957], [-121.35082, 37.95683], [-121.35037, 37.95666], [-121.34985, 37.95654], [-121.34942, 37.95637], [-121.34846, 37.95608], [-121.34776, 37.95584], [-121.34731, 37.95576], [-121.34699, 37.95577], [-121.34689, 37.95581], [-121.34682, 37.95586], [-121.3468, 37.95591], [-121.34683, 37.95598], [-121.34749, 37.95638], [-121.34789, 37.95665], [-121.34802, 37.95676], [-121.34806, 37.95681], [-121.34805, 37.95687], [-121.34765, 37.95709], [-121.3471, 37.95733], [-121.34682, 37.95751], [-121.34663, 37.95761], [-121.34605, 37.95764], [-121.34597, 37.95779], [-121.34378, 37.95719], [-121.3439, 37.95681], [-121.34391, 37.95665], [-121.34384, 37.95655], [-121.34379, 37.95652], [-121.34357, 37.9565], [-121.34345, 37.95654], [-121.34321, 37.95678], [-121.34318, 37.95688], [-121.34301, 37.95719], [-121.34295, 37.95735], [-121.34296, 37.95756], [-121.34298, 37.95774], [-121.34303, 37.95789], [-121.34308, 37.95799], [-121.34307, 37.95811], [-121.34309, 37.95819], [-121.34314, 37.95834], [-121.34317, 37.9584], [-121.34327, 37.95843], [-121.34331, 37.95847], [-121.34331, 37.95855], [-121.34326, 37.95858], [-121.34286, 37.95864], [-121.34079, 37.95921], [-121.33981, 37.95547], [-121.34401, 37.95477], [-121.34402, 37.95476], [-121.34397, 37.95458], [-121.34452, 37.95473], [-121.34538, 37.95518], [-121.34578, 37.95536], [-121.34604, 37.95553], [-121.34696, 37.9555], [-121.35169, 37.95684], [-121.35298, 37.95725], [-121.35335, 37.95744], [-121.35337, 37.95751]]]} | Open Access 1 | Louis Park | 21548 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 52.029 | Louis 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]);