units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
81 rows where MNG_AGENCY = 396 sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13675 | 13675 | 13674 | {"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 | 36049 | Williams Brotherhood Park | 27561 | 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.873 | Williams Brotherhood Park | 0 | Local Park 2 | 4 | |
12340 | 12340 | 12339 | {"type": "Polygon", "coordinates": [[[-121.30865, 37.90889], [-121.30746, 37.909], [-121.30481, 37.90915], [-121.30474, 37.9091], [-121.30473, 37.90886], [-121.3046, 37.90803], [-121.30443, 37.90751], [-121.30415, 37.90675], [-121.30828, 37.90633], [-121.30839, 37.90763], [-121.30845, 37.90806], [-121.30845, 37.90826], [-121.30851, 37.90835], [-121.30861, 37.90839], [-121.30865, 37.90889]]]} | Open Access 1 | 26033 | Weston Park | 31211 | 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 | 23.89 | Weston Park | 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 | |
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 | |
17039 | 17039 | 17038 | {"type": "Polygon", "coordinates": [[[-121.29458, 37.95402], [-121.29455, 37.95407], [-121.29456, 37.95412], [-121.29396, 37.95531], [-121.29388, 37.95538], [-121.29374, 37.95544], [-121.29362, 37.95545], [-121.29271, 37.9554], [-121.2927, 37.95548], [-121.2927, 37.95549], [-121.29374, 37.95554], [-121.29215, 37.95577], [-121.29166, 37.95409], [-121.29334, 37.9539], [-121.2945, 37.95393], [-121.29454, 37.95394], [-121.29458, 37.95402]]]} | Open Access 1 | 29645 | Weber Point Event Center | 27326 | 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.256 | Weber Point Event Ctr. | 0 | Local Recreation Area 3 | 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 | |
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 | |
10103 | 10103 | 10102 | {"type": "Polygon", "coordinates": [[[-121.32473, 37.92651], [-121.32104, 37.92652], [-121.32104, 37.92626], [-121.32095, 37.92625], [-121.32094, 37.92441], [-121.31569, 37.9212], [-121.31269, 37.92108], [-121.31269, 37.92098], [-121.31223, 37.92096], [-121.31224, 37.92079], [-121.31223, 37.92078], [-121.30994, 37.92078], [-121.30589, 37.92053], [-121.30552, 37.92047], [-121.30513, 37.92036], [-121.30477, 37.92021], [-121.30443, 37.92], [-121.30436, 37.92006], [-121.30402, 37.91984], [-121.3039, 37.91979], [-121.30364, 37.91973], [-121.29916, 37.91973], [-121.29798, 37.9196], [-121.29689, 37.91962], [-121.29688, 37.91858], [-121.29819, 37.9185], [-121.29861, 37.91837], [-121.29907, 37.91813], [-121.30007, 37.9175], [-121.30078, 37.91683], [-121.3012, 37.91652], [-121.30166, 37.91644], [-121.30306, 37.9164], [-121.30379, 37.91636], [-121.3043, 37.91627], [-121.30461, 37.9163], [-121.30484, 37.9165], [-121.30516, 37.91707], [-121.30545, 37.91764], [-121.30567, 37.91817], [-121.30578, 37.9185], [-121.30597, 37.91889], [-121.30622, 37.91916], [-121.30663, 37.91943], [-121.30702, 37.91952], [-121.30733, 37.91948], [-121.30791, 37.91922], [-121.30853, 37.9192], [-121.30904, 37.91925], [-121.30957, 37.91936], [-121.31074, 37.91966], [-121.31114, 37.91969], [-121.31205, 37.91958], [-121.31236, 37.91952], [-121.31274, 37.91934], [-121.31338, 37.91895], [-121.31446, 37.91837], [-121.31488, 37.91831], [-121.31535, 37.91836], [-121.31599, 37.91849], [-121.3163, 37.91869], [-121.31715, 37.91969], [-121.31879, 37.92072], [-121.31971, 37.92114], [-121.32047, 37.92153], [-121.32158, 37.92223], [-121.3226, 37.92302], [-121.32291, 37.92344], [-121.32329, 37.92413], [-121.32355, 37.92467], [-121.32473, 37.92651]]]} | Restricted Access 2 | 28068 | Van Buskirk Municipal Golf Course | 33088 | 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 | 152.25 | Van Buskirk Municipal GC | 0 | Local Recreation Area 3 | 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 | |
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 | |
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 | |
15726 | 15726 | 15725 | {"type": "Polygon", "coordinates": [[[-121.35011, 38.00588], [-121.35004, 38.01275], [-121.34999, 38.01357], [-121.34999, 38.0139], [-121.34458, 38.01387], [-121.34456, 38.01382], [-121.3444, 38.01383], [-121.34423, 38.01388], [-121.34401, 38.01385], [-121.34353, 38.01386], [-121.34194, 38.01385], [-121.34193, 38.01343], [-121.34157, 38.01321], [-121.34097, 38.01292], [-121.34055, 38.01281], [-121.3402, 38.01281], [-121.33982, 38.01299], [-121.3398, 38.01271], [-121.3399, 38.01222], [-121.3399, 38.01198], [-121.33979, 38.01131], [-121.33974, 38.01117], [-121.33959, 38.01089], [-121.33949, 38.01042], [-121.33946, 38.01024], [-121.33946, 38.00978], [-121.33943, 38.00953], [-121.339, 38.00759], [-121.33895, 38.00678], [-121.33893, 38.00624], [-121.33893, 38.00616], [-121.33883, 38.00582], [-121.33885, 38.00578], [-121.33931, 38.0056], [-121.33958, 38.00551], [-121.33977, 38.00587], [-121.34029, 38.0058], [-121.34097, 38.00576], [-121.34363, 38.00548], [-121.34361, 38.00516], [-121.34536, 38.00526], [-121.34662, 38.00515], [-121.34957, 38.00503], [-121.34961, 38.00504], [-121.34964, 38.00507], [-121.34967, 38.00531], [-121.34978, 38.00555], [-121.3499, 38.00571], [-121.35011, 38.00588]], [[-121.34012, 38.00965], [-121.34012, 38.0096], [-121.34008, 38.0096], [-121.34008, 38.00965], [-121.34012, 38.00965]]]} | Restricted Access 2 | 44950 | Swenson Park Golf Course | 33122 | 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 | 213.574 | Swenson Park GC | 0 | Local Recreation Area 3 | 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 | |
13976 | 13976 | 13975 | {"type": "Polygon", "coordinates": [[[-121.38323, 38.04933], [-121.38318, 38.0494], [-121.3823, 38.04957], [-121.38221, 38.04953], [-121.382, 38.04884], [-121.38205, 38.04877], [-121.38293, 38.0486], [-121.38301, 38.04864], [-121.38323, 38.04933]]]} | Open Access 1 | 36643 | Stockton holding 5 | 25862 | 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.047 | Stockton holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13977 | 13977 | 13976 | {"type": "Polygon", "coordinates": [[[-121.38992, 38.04625], [-121.3899, 38.04627], [-121.38944, 38.04634], [-121.38941, 38.04632], [-121.38933, 38.04599], [-121.38933, 38.04586], [-121.38935, 38.04585], [-121.38971, 38.04588], [-121.38992, 38.04625]]]} | Open Access 1 | 36644 | Stockton holding 4 | 25861 | 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 | 0.498 | Stockton holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13975 | 13975 | 13974 | {"type": "Polygon", "coordinates": [[[-121.3818, 38.05196], [-121.38173, 38.05202], [-121.38083, 38.05202], [-121.38076, 38.05197], [-121.38075, 38.05126], [-121.38082, 38.0512], [-121.38173, 38.0512], [-121.3818, 38.05125], [-121.3818, 38.05196]]]} | Open Access 1 | 36642 | Stockton holding 3 | 25860 | 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.046 | Stockton holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13974 | 13974 | 13973 | {"type": "Polygon", "coordinates": [[[-121.39101, 38.04978], [-121.39099, 38.0498], [-121.3903, 38.04991], [-121.39027, 38.04989], [-121.39015, 38.04943], [-121.39083, 38.04932], [-121.39101, 38.04978]]]} | Open Access 1 | 36641 | Stockton holding 2 | 25859 | 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 | 0.86 | Stockton holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13973 | 13973 | 13972 | {"type": "Polygon", "coordinates": [[[-121.38181, 38.05445], [-121.38174, 38.05451], [-121.38084, 38.05451], [-121.38077, 38.05445], [-121.38077, 38.05333], [-121.38083, 38.05327], [-121.38174, 38.05327], [-121.38181, 38.05333], [-121.38181, 38.05445]]]} | Open Access 1 | 36640 | Stockton holding 1 | 25858 | 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.08 | Stockton holding 1 | 0 | Local Other or Unknown 14 | 4 | |
14819 | 14819 | 14818 | {"type": "Polygon", "coordinates": [[[-121.29389, 37.95337], [-121.29284, 37.95343], [-121.29154, 37.95366], [-121.29152, 37.95359], [-121.29384, 37.9532], [-121.29389, 37.95337]]]} | Open Access 1 | 47253 | South Seawall Park | 30964 | 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 | 0.536 | South Seawall 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 |
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]);