units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where AGNCY_LEV = 2, DES_TP = 2 and MNG_AGENCY = 396 sorted by map
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14407 | 14407 | 14406 | {"type": "MultiPolygon", "coordinates": [[[[-121.24276, 37.94494], [-121.24241, 37.94502], [-121.2421, 37.94427], [-121.24212, 37.94424], [-121.24242, 37.94415], [-121.24276, 37.94494]]], [[[-121.24417, 37.94457], [-121.24348, 37.94475], [-121.24316, 37.94397], [-121.24386, 37.94379], [-121.24417, 37.94457]]]]} | Open Access 1 | 44520 | Missassi Park | 22291 | 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.166 | Missassi 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 | |
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 | |
12061 | 12061 | 12060 | {"type": "Polygon", "coordinates": [[[-121.23922, 37.91548], [-121.23916, 37.9155], [-121.23909, 37.91543], [-121.239, 37.91542], [-121.23892, 37.91546], [-121.23884, 37.9156], [-121.23767, 37.91589], [-121.23728, 37.91489], [-121.23723, 37.91485], [-121.23717, 37.91485], [-121.23717, 37.91445], [-121.23862, 37.91406], [-121.23922, 37.91548]]]} | Open Access 1 | 24756 | Shropshire Park | 25434 | 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.817 | Shropshire 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 | |
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 | |
12452 | 12452 | 12451 | {"type": "Polygon", "coordinates": [[[-121.26311, 38.03324], [-121.26307, 38.03328], [-121.26168, 38.03329], [-121.26164, 38.03325], [-121.26163, 38.03207], [-121.26168, 38.03204], [-121.26236, 38.03215], [-121.26302, 38.03222], [-121.26306, 38.03225], [-121.26311, 38.03273], [-121.26311, 38.03324]]]} | Open Access 1 | 28094 | Parma Sister City Park | 23469 | 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.018 | Parma Sister City 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 | |
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 | |
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 | |
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 | |
14341 | 14341 | 14340 | {"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 | 44475 | Future Stockton City Park | 19162 | 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.464 | Future Stockton City 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 | |
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 | |
12057 | 12057 | 12056 | {"type": "Polygon", "coordinates": [[[-121.27664, 38.03557], [-121.27664, 38.03661], [-121.27655, 38.03688], [-121.2724, 38.03689], [-121.2723, 38.03682], [-121.27228, 38.03675], [-121.27225, 38.03654], [-121.27227, 38.03634], [-121.27231, 38.03621], [-121.27236, 38.03611], [-121.27247, 38.03599], [-121.27259, 38.0359], [-121.27448, 38.03519], [-121.27664, 38.03557]]]} | Open Access 1 | 24751 | Matt Equinoa Park | 32973 | 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.516 | Matt Equinoa Park | 0 | Local Park 2 | 4 | |
12339 | 12339 | 12338 | {"type": "Polygon", "coordinates": [[[-121.2776, 38.00211], [-121.27728, 38.00219], [-121.27736, 38.00241], [-121.27624, 38.0027], [-121.27615, 38.00266], [-121.27579, 38.00178], [-121.27575, 38.00165], [-121.27566, 38.00154], [-121.27553, 38.0015], [-121.2754, 38.00123], [-121.27549, 38.00119], [-121.27536, 38.00095], [-121.27694, 38.00044], [-121.27746, 38.00171], [-121.27749, 38.00185], [-121.2776, 38.00211]]]} | Open Access 1 | 26031 | SL Fong Park | 25550 | 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.461 | SL Fong 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 | |
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 | |
12059 | 12059 | 12058 | {"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 | 24753 | Independence Park | 20192 | 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.177 | Independence 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 |
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]);