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 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
DES_TP 6
MNG_AG_TYP 1
- City Agency 77
MNG_AGENCY 1
- Stockton, City of · 77 ✖
ACCESS_TYP 1
- Open Access · 77 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
13674 | 13674 | 13673 | {"type": "Polygon", "coordinates": [[[-121.28708, 37.99348], [-121.28675, 37.99352], [-121.28606, 37.99371], [-121.28533, 37.99376], [-121.28547, 37.99414], [-121.28515, 37.99423], [-121.28504, 37.99413], [-121.28495, 37.99411], [-121.28488, 37.99411], [-121.28464, 37.99419], [-121.28354, 37.99448], [-121.28329, 37.99451], [-121.28319, 37.99457], [-121.28291, 37.99438], [-121.28261, 37.99453], [-121.28239, 37.99399], [-121.28292, 37.99369], [-121.28409, 37.9933], [-121.28514, 37.99319], [-121.28651, 37.99308], [-121.28687, 37.99299], [-121.28704, 37.99345], [-121.28707, 37.99345], [-121.28708, 37.99348]]]} | Open Access 1 | 36047 | Arnold Rue Park | 15604 | 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.526 | Arnold Rue 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 | |
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 | |
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 | |
12402 | 12402 | 12401 | {"type": "Polygon", "coordinates": [[[-121.30992, 37.99079], [-121.3096, 37.99094], [-121.3092, 37.991], [-121.30891, 37.9912], [-121.3086, 37.99132], [-121.30829, 37.99114], [-121.30829, 37.99106], [-121.30824, 37.991], [-121.30861, 37.99074], [-121.3089, 37.99012], [-121.30939, 37.99], [-121.30959, 37.98988], [-121.30979, 37.98999], [-121.30985, 37.99025], [-121.30972, 37.99028], [-121.30969, 37.99036], [-121.30971, 37.99042], [-121.30978, 37.9905], [-121.30992, 37.99079]]]} | Open Access 1 | 27003 | Brooking Park | 16424 | 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.03 | Brooking 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 | |
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 | |
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 | |
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 | |
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 | |
12056 | 12056 | 12055 | {"type": "Polygon", "coordinates": [[[-121.29144, 37.95434], [-121.29041, 37.95452], [-121.29024, 37.95388], [-121.29126, 37.95371], [-121.29144, 37.95434]]]} | Open Access 1 | 24750 | DeCarli Waterfront | 17984 | 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.638 | DeCarli Waterfront | None 1060 | |||
13703 | 13703 | 13702 | {"type": "Polygon", "coordinates": [[[-121.2634, 38.04678], [-121.25918, 38.04681], [-121.25898, 38.04416], [-121.25901, 38.04388], [-121.2591, 38.04355], [-121.25911, 38.04302], [-121.26311, 38.04296], [-121.2634, 38.04678]]]} | Open Access 1 | 36079 | Detention Basin Soccer Complex | 18118 | 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 | 38.293 | Detention Basin Soccer Complex | 0 | Local Recreation Area 3 | 4 | |
14380 | 14380 | 14379 | {"type": "Polygon", "coordinates": [[[-121.32358, 38.0547], [-121.32333, 38.05496], [-121.3228, 38.05477], [-121.32161, 38.05457], [-121.32162, 38.05455], [-121.32168, 38.05455], [-121.32174, 38.05453], [-121.32179, 38.0545], [-121.32182, 38.05445], [-121.32182, 38.0544], [-121.3218, 38.05435], [-121.32176, 38.05431], [-121.3217, 38.05429], [-121.3216, 38.05429], [-121.32148, 38.05435], [-121.32139, 38.05437], [-121.32061, 38.05424], [-121.32001, 38.05422], [-121.32003, 38.05355], [-121.32033, 38.05349], [-121.32063, 38.05341], [-121.3217, 38.05304], [-121.32192, 38.053], [-121.322, 38.05294], [-121.3225, 38.05277], [-121.32358, 38.0547]]]} | Open Access 1 | 44473 | Dortha May Pitts Park | 18224 | 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.994 | Dortha May Pitts 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 | |
13671 | 13671 | 13670 | {"type": "Polygon", "coordinates": [[[-121.37976, 38.04623], [-121.37927, 38.0471], [-121.37933, 38.04716], [-121.37939, 38.04725], [-121.37957, 38.04735], [-121.37973, 38.04748], [-121.37974, 38.04756], [-121.37952, 38.04779], [-121.37928, 38.04813], [-121.37905, 38.04855], [-121.37897, 38.04882], [-121.37889, 38.04886], [-121.37778, 38.04873], [-121.3771, 38.0486], [-121.37638, 38.04842], [-121.37674, 38.04714], [-121.37655, 38.04645], [-121.37782, 38.04624], [-121.37796, 38.04625], [-121.37833, 38.04621], [-121.3784, 38.04658], [-121.37905, 38.04651], [-121.3792, 38.04625], [-121.37918, 38.04612], [-121.3797, 38.04606], [-121.37976, 38.04623]]]} | Open Access 1 | 36039 | Faklis Community Park | 18828 | 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 | 16.18 | Faklis Community 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]);