units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
77 rows where ACCESS_TYP = 1, AGNCY_LEV = 2 and MNG_AGENCY = 396
This data as json, copyable, CSV (advanced)
DES_TP 5
MNG_AG_TYP 1
- City Agency 57
MNG_AGENCY 1
- Stockton, City of · 57 ✖
ACCESS_TYP 1
- Open Access · 57 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
3194 | 3194 | 3193 | {"type": "Polygon", "coordinates": [[[-121.30763, 37.95252], [-121.30731, 37.9527], [-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 | 28057 | Morelli Park | 22475 | 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 | 3.239 | Morelli Park | 0 | Local Park 2 | 4 | |
3197 | 3197 | 3196 | {"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 | 28073 | Unity Park | 26672 | 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 | 5.001 | Unity Park | 0 | Local Park 2 | 4 | |
3402 | 3402 | 3401 | {"type": "Polygon", "coordinates": [[[-121.36136, 37.98621], [-121.36133, 37.98643], [-121.36097, 37.98725], [-121.36089, 37.98729], [-121.36082, 37.98736], [-121.36083, 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 | 24755 | Nelson Park | 22697 | 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 | 11.879 | Nelson Park | 0 | Local Park 2 | 4 | |
3527 | 3527 | 3526 | {"type": "Polygon", "coordinates": [[[-121.34589, 38.0487], [-121.34578, 38.04902], [-121.3457, 38.04939], [-121.34566, 38.04976], [-121.34565, 38.0503], [-121.34558, 38.05035], [-121.3447, 38.05035], [-121.34443, 38.05038], [-121.34418, 38.05044], [-121.34393, 38.05052], [-121.34367, 38.05063], [-121.3434, 38.0508], [-121.34319, 38.05098], [-121.34309, 38.051], [-121.34245, 38.05072], [-121.34236, 38.0507], [-121.34188, 38.05044], [-121.34185, 38.05006], [-121.34456, 38.05007], [-121.34459, 38.04833], [-121.34587, 38.04866], [-121.34589, 38.0487]]]} | Open Access 1 | 28069 | Baxter Park | 15869 | 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 | 9.101 | Baxter 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 | |
10188 | 10188 | 10187 | {"type": "Polygon", "coordinates": [[[-121.31092, 38.00933], [-121.31092, 38.00963], [-121.31022, 38.00963], [-121.3102, 38.01179], [-121.30897, 38.01178], [-121.30893, 38.01177], [-121.30892, 38.01174], [-121.30893, 38.00949], [-121.30949, 38.00949], [-121.3095, 38.00894], [-121.31055, 38.00895], [-121.31055, 38.00933], [-121.31092, 38.00933]]]} | Open Access 1 | 17812 | Anderson Park | 15479 | 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.908 | Anderson Park | 0 | Local Park 2 | 4 | |
10190 | 10190 | 10189 | {"type": "Polygon", "coordinates": [[[-121.33522, 37.99548], [-121.33521, 37.9955], [-121.33481, 37.99563], [-121.33433, 37.99586], [-121.3339, 37.99615], [-121.33368, 37.99633], [-121.33248, 37.99445], [-121.33309, 37.99375], [-121.33327, 37.9936], [-121.33345, 37.99347], [-121.33348, 37.99346], [-121.33481, 37.99472], [-121.33496, 37.9949], [-121.33508, 37.9951], [-121.33514, 37.99523], [-121.33522, 37.99548]]]} | Open Access 1 | 17816 | Atherton Park | 15667 | 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 | 9.8 | Atherton Park | 0 | Local Park 2 | 4 | |
10193 | 10193 | 10192 | {"type": "Polygon", "coordinates": [[[-121.30608, 37.9781], [-121.30536, 37.97719], [-121.30527, 37.97715], [-121.30518, 37.97716], [-121.30485, 37.97732], [-121.30438, 37.97671], [-121.30466, 37.97657], [-121.30476, 37.9766], [-121.30485, 37.97658], [-121.3049, 37.97655], [-121.30497, 37.97646], [-121.30503, 37.97643], [-121.30562, 37.97629], [-121.30568, 37.9763], [-121.30616, 37.97749], [-121.3062, 37.97761], [-121.30621, 37.97774], [-121.30619, 37.97787], [-121.30615, 37.97799], [-121.30608, 37.9781]]]} | Open Access 1 | 17824 | Caldwell Park | 16676 | 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 | 3.405 | Caldwell Park | 0 | Local Park 2 | 4 | |
10199 | 10199 | 10198 | {"type": "Polygon", "coordinates": [[[-121.29528, 37.94336], [-121.29425, 37.94354], [-121.29402, 37.94272], [-121.29506, 37.94255], [-121.29528, 37.94336]]]} | Open Access 1 | 17828 | Columbus Square | 17552 | 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.132 | Columbus Square | 0 | Local Park 2 | 4 | |
10209 | 10209 | 10208 | {"type": "Polygon", "coordinates": [[[-121.33167, 38.03553], [-121.33169, 38.03669], [-121.33167, 38.03673], [-121.33162, 38.03675], [-121.33058, 38.03674], [-121.33054, 38.03672], [-121.33052, 38.03669], [-121.33052, 38.03595], [-121.33045, 38.03589], [-121.33039, 38.03588], [-121.33033, 38.03589], [-121.33033, 38.03552], [-121.33043, 38.03551], [-121.33044, 38.03391], [-121.33101, 38.03362], [-121.33159, 38.03362], [-121.33163, 38.03364], [-121.33167, 38.03553]]]} | Open Access 1 | 17844 | Aj Bart Detoni Park | 15306 | 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.945 | Aj Bart Detoni Park | 0 | Local Park 2 | 4 | |
10212 | 10212 | 10211 | {"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 | 17860 | Friedberger Park | 19114 | 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.562 | Friedberger Park | 0 | Local Park 2 | 4 | |
10216 | 10216 | 10215 | {"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.35642, 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.99882], [-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 | 17864 | Fritz Grupe Park | 19128 | 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 | 20.415 | Fritz Grupe 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 | |
10221 | 10221 | 10220 | {"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 | 17875 | Holiday Park | 20032 | 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.381 | Holiday Park | 0 | Local Park 2 | 4 | |
10223 | 10223 | 10222 | {"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 | 17879 | Lafayette Square | 20835 | 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.106 | Lafayette Square | 0 | Local Park 2 | 4 | |
10224 | 10224 | 10223 | {"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 | 17883 | Laughlin Park | 21085 | 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 | 5.196 | Laughlin Park | 0 | Local Park 2 | 4 | |
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 |
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]);