units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
81 rows where MNG_AGENCY = 396 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | UNIT_ID ▼ | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10229 | 10229 | 10228 | {"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 | 17896 | Loch Lomond Park | 21393 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 6.111 | Loch Lomond Park | 0 | Local Park 2 | 4 | |
10230 | 10230 | 10229 | {"type": "Polygon", "coordinates": [[[-121.35335, 37.95744], [-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.34986, 37.95654], [-121.34942, 37.95637], [-121.34846, 37.95608], [-121.34776, 37.95584], [-121.3473, 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.95752], [-121.34663, 37.95761], [-121.34604, 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.34318, 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.34402, 37.95477], [-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]]]} | Open Access 1 | 17899 | Louis Park | 21548 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 52.026 | Louis Park | 0 | Local Park 2 | 4 | |
2580 | 2580 | 2579 | {"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.92716], [-121.28809, 37.92717], [-121.28757, 37.92588], [-121.28923, 37.92551], [-121.28976, 37.92681], [-121.28969, 37.92684], [-121.28996, 37.92752]]]} | Open Access 1 | 17902 | Mattie Harrell Park | 21958 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 8.493 | Mattie Harrell Park | 0 | Local Park 2 | 4 | |
9745 | 9745 | 9744 | {"type": "Polygon", "coordinates": [[[-121.28245, 37.92874], [-121.27979, 37.92942], [-121.2792, 37.92798], [-121.27958, 37.92788], [-121.27941, 37.92749], [-121.27925, 37.92753], [-121.27934, 37.92777], [-121.27827, 37.92804], [-121.27816, 37.92777], [-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.27965, 37.92736], [-121.2813, 37.92706], [-121.2813, 37.92702], [-121.28171, 37.92692], [-121.28245, 37.92874]]]} | Open Access 1 | 17905 | McKinley Park | 22048 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 22.56 | McKinley Park | 0 | Local Park 2 | 4 | |
9747 | 9747 | 9746 | {"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 | 17908 | Oak Park | 23003 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 56.221 | Oak Park | 0 | Local Park 2 | 4 | |
10236 | 10236 | 10235 | {"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 | 17911 | Panella Park | 23387 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 14.777 | Panella Park | 0 | Local Park 2 | 4 | |
2582 | 2582 | 2581 | {"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 | 17914 | Reverend Holmes Park | 24304 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 1.993 | Reverend Holmes Park | 0 | Local Park 2 | 4 | |
2584 | 2584 | 2583 | {"type": "Polygon", "coordinates": [[[-121.27101, 37.92818], [-121.27075, 37.92822], [-121.27051, 37.92832], [-121.27041, 37.92831], [-121.27025, 37.92836], [-121.27013, 37.92796], [-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 | 17917 | Reverend Peterson Park | 24305 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.931 | Reverend Peterson Park | 0 | Local Park 2 | 4 | |
10241 | 10241 | 10240 | {"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 | 17921 | Sandman Park | 25019 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 15.281 | Sandman Park | 0 | Local Park 2 | 4 | |
2586 | 2586 | 2585 | {"type": "Polygon", "coordinates": [[[-121.31049, 37.99986], [-121.31053, 37.99986], [-121.31057, 37.99989], [-121.31087, 38.00067], [-121.31122, 38.00163], [-121.31118, 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]]]} | Open Access 1 | 17924 | Sherwood Forest Park | 25398 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 6.435 | Sherwood Forest Park | 0 | Local Park 2 | 4 | |
2592 | 2592 | 2591 | {"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 | 17933 | Sousa Park | 25635 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 4.796 | Sousa Park | 0 | Local Park 2 | 4 | |
2226 | 2226 | 2225 | {"type": "Polygon", "coordinates": [[[-121.26759, 37.95177], [-121.26567, 37.95226], [-121.26566, 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 | 17937 | Stribley Park | 25923 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 17.823 | Stribley Park | 0 | Local Park 2 | 4 | |
10217 | 10217 | 10216 | {"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 | 17944 | Union Square | 26662 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.629 | Union Square | 0 | Local Park 2 | 4 | |
2595 | 2595 | 2594 | {"type": "Polygon", "coordinates": [[[-121.28536, 38.02967], [-121.28534, 38.02969], [-121.28486, 38.02975], [-121.28453, 38.02985], [-121.28421, 38.02999], [-121.28391, 38.03009], [-121.2836, 38.03014], [-121.28343, 38.03014], [-121.28342, 38.03011], [-121.2834, 38.02909], [-121.28344, 38.02886], [-121.2834, 38.02878], [-121.28329, 38.02871], [-121.28338, 38.02845], [-121.28526, 38.02844], [-121.28527, 38.02864], [-121.28535, 38.02916], [-121.28536, 38.02967]]]} | Open Access 1 | 17948 | Valverde Park | 26816 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 6.85 | Valverde Park | 0 | Local Park 2 | 4 | |
2596 | 2596 | 2595 | {"type": "Polygon", "coordinates": [[[-121.29689, 37.91962], [-121.29622, 37.91967], [-121.29563, 37.91976], [-121.29481, 37.91994], [-121.29413, 37.92014], [-121.29298, 37.92035], [-121.29282, 37.92025], [-121.29246, 37.91942], [-121.29174, 37.9175], [-121.29183, 37.91739], [-121.29307, 37.91779], [-121.29447, 37.91827], [-121.29514, 37.91847], [-121.29566, 37.91859], [-121.29688, 37.91858], [-121.29689, 37.91962]]]} | Open Access 1 | 17951 | Van Buskirk Municipal Park | 26822 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 19.859 | Van Buskirk Municipal Park | 0 | Local Park 2 | 4 | |
10255 | 10255 | 10254 | {"type": "Polygon", "coordinates": [[[-121.31225, 37.95933], [-121.31281, 37.95924], [-121.31297, 37.95924], [-121.31341, 37.95927], [-121.31368, 37.95927], [-121.31396, 37.95924], [-121.31423, 37.95919], [-121.31449, 37.95913], [-121.31474, 37.95904], [-121.31515, 37.95885], [-121.31533, 37.9588], [-121.31552, 37.95877], [-121.31571, 37.95876], [-121.31591, 37.95877], [-121.3161, 37.9588], [-121.31628, 37.95886], [-121.31645, 37.95894], [-121.31665, 37.95907], [-121.31671, 37.95916], [-121.31673, 37.95926], [-121.31671, 37.95937], [-121.31668, 37.95941], [-121.31654, 37.95959], [-121.31645, 37.95973], [-121.31629, 37.96011], [-121.31617, 37.96033], [-121.31602, 37.96054], [-121.31585, 37.96073], [-121.31565, 37.96091], [-121.31543, 37.96108], [-121.31519, 37.96122], [-121.31493, 37.96135], [-121.31466, 37.96146], [-121.31417, 37.9616], [-121.31398, 37.96168], [-121.3138, 37.96178], [-121.31364, 37.9619], [-121.31312, 37.96231], [-121.31304, 37.96233], [-121.31298, 37.96232], [-121.31295, 37.96227], [-121.31217, 37.95942], [-121.31219, 37.95936], [-121.31225, 37.95933]]]} | Open Access 1 | 17954 | Victory Park | 27091 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 22.822 | Victory Park | 0 | Local Park 2 | 4 | |
2599 | 2599 | 2598 | {"type": "Polygon", "coordinates": [[[-121.29933, 37.95829], [-121.29831, 37.95846], [-121.29808, 37.95766], [-121.29911, 37.95749], [-121.29933, 37.95829]]]} | Open Access 1 | 17958 | Weber Square | 27327 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.072 | Weber Square | 0 | Local Park 2 | 4 | |
2601 | 2601 | 2600 | {"type": "Polygon", "coordinates": [[[-121.30193, 37.9956], [-121.30189, 37.99563], [-121.3017, 37.99569], [-121.30153, 37.99577], [-121.30104, 37.9961], [-121.30098, 37.99611], [-121.3005, 37.9957], [-121.30036, 37.99566], [-121.30022, 37.99569], [-121.29979, 37.99531], [-121.29992, 37.99526], [-121.30048, 37.99487], [-121.30071, 37.99473], [-121.30108, 37.99453], [-121.30127, 37.99445], [-121.30131, 37.99445], [-121.30135, 37.99447], [-121.30146, 37.99464], [-121.30168, 37.99503], [-121.30186, 37.9954], [-121.30193, 37.99556], [-121.30193, 37.9956]]]} | Open Access 1 | 17962 | Weberstown Park | 27328 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 4.586 | Weberstown Park | 0 | Local Park 2 | 4 | |
12025 | 12025 | 12024 | {"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.29315, 37.95698], [-121.29347, 37.95677], [-121.29358, 37.95718]]]} | Open Access 1 | 24695 | McLeod Park | 22056 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.236 | McLeod Park | 0 | Local Park 2 | 4 | |
12055 | 12055 | 12054 | {"type": "Polygon", "coordinates": [[[-121.35774, 38.04766], [-121.35702, 38.04778], [-121.35683, 38.04716], [-121.35755, 38.04706], [-121.35774, 38.04766]]]} | Open Access 1 | 24749 | Corren Park | 17656 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 1.098 | Corren Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);