units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
81 rows where MNG_AGENCY = 396 sorted by ACCESS_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
14379 | 14379 | 14378 | {"type": "Polygon", "coordinates": [[[-121.34316, 37.94914], [-121.34325, 37.94926], [-121.34326, 37.94932], [-121.34324, 37.94938], [-121.34313, 37.94957], [-121.34173, 37.95234], [-121.3416, 37.95228], [-121.34148, 37.95221], [-121.341, 37.95207], [-121.34081, 37.95199], [-121.34051, 37.95191], [-121.34013, 37.95182], [-121.33985, 37.95179], [-121.33969, 37.95173], [-121.33942, 37.95168], [-121.33918, 37.95161], [-121.33824, 37.95147], [-121.33732, 37.95115], [-121.3371, 37.95109], [-121.33674, 37.95076], [-121.33654, 37.95056], [-121.33643, 37.95034], [-121.33631, 37.95005], [-121.33633, 37.94978], [-121.33644, 37.94953], [-121.33674, 37.94895], [-121.33698, 37.94858], [-121.33734, 37.94815], [-121.33747, 37.94788], [-121.33766, 37.94759], [-121.33778, 37.94745], [-121.33789, 37.94737], [-121.33809, 37.9473], [-121.33818, 37.9473], [-121.33854, 37.94714], [-121.33886, 37.94774], [-121.339, 37.94794], [-121.33917, 37.94814], [-121.33935, 37.94831], [-121.33965, 37.94854], [-121.33997, 37.94874], [-121.34022, 37.94886], [-121.34048, 37.94896], [-121.3408, 37.94906], [-121.34114, 37.94914], [-121.34137, 37.94917], [-121.34148, 37.94918], [-121.34149, 37.94912], [-121.34316, 37.94914]]]} | Restricted Access 2 | 44469 | Lyons Golf Course | 33104 | 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 | 47.107 | Lyons GC | 0 | Local Recreation Area 3 | 4 | |
15165 | 15165 | 15164 | {"type": "Polygon", "coordinates": [[[-121.34597, 37.95779], [-121.34588, 37.95797], [-121.34548, 37.95813], [-121.34457, 37.95838], [-121.34326, 37.95858], [-121.34331, 37.95855], [-121.34331, 37.95847], [-121.34327, 37.95843], [-121.34318, 37.95841], [-121.34314, 37.95834], [-121.34307, 37.95812], [-121.34308, 37.95799], [-121.34298, 37.95774], [-121.34296, 37.95756], [-121.34295, 37.95735], [-121.34301, 37.95719], [-121.34318, 37.95688], [-121.34321, 37.95678], [-121.34333, 37.95665], [-121.34346, 37.95654], [-121.34358, 37.9565], [-121.34379, 37.95652], [-121.34384, 37.95655], [-121.34391, 37.95665], [-121.3439, 37.95681], [-121.34379, 37.95719], [-121.34597, 37.95779]]]} | Restricted Access 2 | 46016 | Pixie Woods | 29339 | 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 | http://www.stocktongov.com/government/departments/communityServices/attPixWood.html | San Joaquin 39 | 7.563 | Pixie Woods | None 1322 | ||
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 | |
1645 | 1645 | 1644 | {"type": "Polygon", "coordinates": [[[-121.27757, 37.98952], [-121.27753, 37.98957], [-121.27653, 37.98983], [-121.2759, 37.98828], [-121.27639, 37.98797], [-121.27641, 37.98792], [-121.27642, 37.98777], [-121.27646, 37.98766], [-121.2765, 37.9876], [-121.2766, 37.98751], [-121.27663, 37.98751], [-121.27678, 37.98768], [-121.2769, 37.98789], [-121.27757, 37.98952]]]} | Open Access 1 | 47779 | Shady Forest | 31579 | 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.969 | Shady Forest | 0 | Local Resource Management Area 83 | 3 | |
2196 | 2196 | 2195 | {"type": "Polygon", "coordinates": [[[-121.30277, 38.02613], [-121.30065, 38.02612], [-121.30063, 38.02519], [-121.30068, 38.02516], [-121.30275, 38.02517], [-121.30278, 38.02522], [-121.30277, 38.02613]]]} | Open Access 1 | 17836 | Cortez Park | 17663 | 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.922 | Cortez 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 | |
2553 | 2553 | 2552 | {"type": "Polygon", "coordinates": [[[-121.31057, 37.96761], [-121.3089, 37.96803], [-121.30876, 37.96808], [-121.30862, 37.96818], [-121.30856, 37.96822], [-121.30762, 37.96844], [-121.30743, 37.96844], [-121.30734, 37.96843], [-121.30631, 37.96816], [-121.3062, 37.96813], [-121.30602, 37.96801], [-121.3059, 37.96786], [-121.30587, 37.96777], [-121.30562, 37.96686], [-121.30561, 37.9667], [-121.30563, 37.96662], [-121.30872, 37.9661], [-121.31008, 37.96585], [-121.31016, 37.96617], [-121.30984, 37.96623], [-121.30987, 37.96638], [-121.31004, 37.96636], [-121.31026, 37.96721], [-121.31041, 37.96718], [-121.31057, 37.96761]]]} | Open Access 1 | 17808 | American Legion Park | 15451 | 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.625 | American Legion Park | 0 | Local Park 2 | 4 | |
2556 | 2556 | 2555 | {"type": "Polygon", "coordinates": [[[-121.37991, 37.97763], [-121.37336, 37.9769], [-121.37042, 37.97837], [-121.37205, 37.97398], [-121.37356, 37.9716], [-121.37991, 37.97763]]]} | Open Access 1 | 17820 | Buckley Cove Park | 16475 | 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 | 63.792 | Buckley Cove Park | 0 | Local Park 2 | 4 | |
2559 | 2559 | 2558 | {"type": "Polygon", "coordinates": [[[-121.27796, 37.95986], [-121.27692, 37.96003], [-121.2767, 37.95923], [-121.27774, 37.95905], [-121.27796, 37.95986]]]} | Open Access 1 | 17832 | Constitution Park | 17599 | 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.112 | Constitution Park | 0 | Local Park 2 | 4 | |
2560 | 2560 | 2559 | {"type": "Polygon", "coordinates": [[[-121.31395, 38.01764], [-121.31393, 38.01767], [-121.31188, 38.019], [-121.31064, 38.01784], [-121.31128, 38.01783], [-121.31152, 38.01779], [-121.31174, 38.0177], [-121.31195, 38.01759], [-121.31213, 38.01746], [-121.31227, 38.0173], [-121.31238, 38.01711], [-121.31246, 38.01706], [-121.31282, 38.01707], [-121.313, 38.0171], [-121.31318, 38.01716], [-121.3134, 38.01726], [-121.31371, 38.01743], [-121.31394, 38.0176], [-121.31395, 38.01764]]]} | Open Access 1 | 17840 | Angel Cruz Park | 15490 | 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 | 7.137 | Angel Cruz Park | 0 | Local Park 2 | 4 | |
2569 | 2569 | 2568 | {"type": "Polygon", "coordinates": [[[-121.29231, 37.96254], [-121.29129, 37.96272], [-121.29107, 37.9619], [-121.29209, 37.96173], [-121.29231, 37.96254]]]} | Open Access 1 | 17852 | Eden Square | 18429 | 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.114 | Eden Square | 0 | Local Park 2 | 4 | |
2572 | 2572 | 2571 | {"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 | 17856 | Fremont Square | 19103 | 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.102 | Fremont Square | 0 | Local Park 2 | 4 | |
2574 | 2574 | 2573 | {"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 | 17868 | Gibbons Park | 19286 | 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.95 | Gibbons Park | 0 | Local Park 2 | 4 | |
2576 | 2576 | 2575 | {"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 | 17871 | Gleason Park | 19312 | 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.173 | Gleason Park | 0 | Local Park 2 | 4 | |
2578 | 2578 | 2577 | {"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 | 17887 | Liberty Square | 21214 | 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.142 | Liberty Square | 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 | |
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 | |
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 |
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]);