units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where DES_TP = 2 and MNG_AGENCY = 396 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 67
MNG_AGENCY 1
- Stockton, City of · 67 ✖
DES_TP 1
- Local Park · 67 ✖
ACCESS_TYP 1
- Open Access 67
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
14382 | 14382 | 14381 | {"type": "Polygon", "coordinates": [[[-121.29836, 37.95423], [-121.29765, 37.95435], [-121.29745, 37.95427], [-121.29721, 37.95431], [-121.29711, 37.95444], [-121.29674, 37.9545], [-121.29678, 37.95444], [-121.29671, 37.9544], [-121.2965, 37.95444], [-121.29635, 37.95436], [-121.29585, 37.95445], [-121.29569, 37.95464], [-121.29559, 37.95466], [-121.2956, 37.95476], [-121.29554, 37.95483], [-121.29543, 37.95486], [-121.29531, 37.95484], [-121.29515, 37.95515], [-121.29519, 37.95522], [-121.2951, 37.95538], [-121.29501, 37.95541], [-121.29489, 37.95563], [-121.29482, 37.95566], [-121.29491, 37.95601], [-121.29449, 37.95608], [-121.29341, 37.9568], [-121.29338, 37.9567], [-121.29346, 37.9567], [-121.29454, 37.95597], [-121.29454, 37.95595], [-121.29472, 37.95561], [-121.2948, 37.95558], [-121.29499, 37.95534], [-121.29518, 37.955], [-121.29518, 37.95492], [-121.29532, 37.95469], [-121.29538, 37.95461], [-121.29544, 37.95461], [-121.29564, 37.95457], [-121.29579, 37.95439], [-121.29636, 37.95429], [-121.29651, 37.95436], [-121.29671, 37.95433], [-121.29676, 37.95435], [-121.29713, 37.95428], [-121.29716, 37.95426], [-121.29722, 37.95425], [-121.29724, 37.95423], [-121.29745, 37.9542], [-121.29762, 37.95426], [-121.29834, 37.95414], [-121.29836, 37.95423]]]} | Open Access 1 | 44481 | North Seawall Park | 22858 | 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.457 | North Seawall 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 | |
14408 | 14408 | 14407 | {"type": "Polygon", "coordinates": [[[-121.34974, 37.99512], [-121.34936, 37.99513], [-121.34921, 37.99498], [-121.34905, 37.99488], [-121.34854, 37.99465], [-121.34831, 37.99453], [-121.34808, 37.99433], [-121.34972, 37.99431], [-121.34974, 37.99512]]]} | Open Access 1 | 44521 | Barkleyville Dog Park | 15818 | 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.985 | Barkleyville Dog 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
12060 | 12060 | 12059 | {"type": "Polygon", "coordinates": [[[-121.29255, 37.9584], [-121.29152, 37.95858], [-121.2913, 37.95776], [-121.29233, 37.95758], [-121.29255, 37.9584]]]} | Open Access 1 | 24754 | King Plaza | 20658 | 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.121 | King Plaza | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);