superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
21 rows where MNG_AG_ID = 322 and MNG_AG_LEV = 3
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2115 | 2115 | 2114 | {"type": "Polygon", "coordinates": [[[-121.31622, 37.94343], [-121.31499, 37.94363], [-121.31475, 37.94273], [-121.31599, 37.94252], [-121.31622, 37.94343]]]} | Open Access 1 | Boggs Tract Park | 16230 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 2.823 | Boggs Tract Park | ||
3617 | 3617 | 3616 | {"type": "Polygon", "coordinates": [[[-121.25782, 37.97688], [-121.25553, 37.97747], [-121.25452, 37.975], [-121.25676, 37.97445], [-121.25782, 37.97688]]]} | Open Access 1 | Gianone Park | 19284 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 14.782 | Gianone Park | ||
3676 | 3676 | 3675 | {"type": "Polygon", "coordinates": [[[-121.31256, 37.83266], [-121.31039, 37.83267], [-121.30989, 37.83016], [-121.31117, 37.83016], [-121.31128, 37.83097], [-121.31134, 37.83117], [-121.31147, 37.83145], [-121.31164, 37.83172], [-121.31197, 37.83207], [-121.31256, 37.83266]]]} | Open Access 1 | Dos Reis Regional Park | 18229 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 8.925 | Dos Reis RP | ||
3753 | 3753 | 3752 | {"type": "Polygon", "coordinates": [[[-121.24742, 37.78011], [-121.24712, 37.78043], [-121.24704, 37.78042], [-121.24697, 37.78038], [-121.24671, 37.78028], [-121.24642, 37.7802], [-121.24629, 37.78019], [-121.24604, 37.78017], [-121.24437, 37.78015], [-121.24434, 37.77915], [-121.24664, 37.77916], [-121.24685, 37.77948], [-121.247, 37.77966], [-121.24742, 37.78011]]]} | Open Access 1 | Dutra Farms Park | 18322 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 6.845 | Dutra Farms Park | ||
3800 | 3800 | 3799 | {"type": "Polygon", "coordinates": [[[-121.22907, 37.96168], [-121.22714, 37.96217], [-121.2263, 37.96022], [-121.22824, 37.95977], [-121.22907, 37.96168]]]} | Open Access 1 | East Side Community Park | 18381 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 9.963 | East Side Community Park | ||
4482 | 4482 | 4481 | {"type": "Polygon", "coordinates": [[[-121.21867, 37.96331], [-121.21754, 37.96361], [-121.21746, 37.96343], [-121.2171, 37.96283], [-121.21657, 37.96156], [-121.21777, 37.96124], [-121.21867, 37.96331]]]} | Open Access 1 | Garden Acres Park | 19194 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 6.669 | Garden Acres Park | ||
4591 | 4591 | 4590 | {"type": "Polygon", "coordinates": [[[-121.24947, 37.92989], [-121.24648, 37.93063], [-121.24614, 37.92975], [-121.2453, 37.92996], [-121.24497, 37.92916], [-121.24572, 37.92894], [-121.24604, 37.9288], [-121.24873, 37.92808], [-121.24947, 37.92989]]]} | Open Access 1 | Kennedy Park and Center | 20604 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 15.918 | Kennedy Park and Ctr. | ||
5996 | 5996 | 5995 | {"type": "Polygon", "coordinates": [[[-121.44381, 37.76634], [-121.44267, 37.76647], [-121.44266, 37.7651], [-121.4438, 37.7651], [-121.44381, 37.76634]]]} | Open Access 1 | Larch Clover Park | 21021 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 3.615 | Larch Clover Park | ||
6519 | 6519 | 6518 | {"type": "Polygon", "coordinates": [[[-121.3286, 37.97085], [-121.32856, 37.9709], [-121.32746, 37.97116], [-121.32692, 37.96977], [-121.32799, 37.96951], [-121.32807, 37.96952], [-121.32826, 37.96996], [-121.3286, 37.97085]]]} | Open Access 1 | Madison Park | 21658 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 4.221 | Madison Park | ||
7230 | 7230 | 7229 | {"type": "Polygon", "coordinates": [[[-121.3073, 37.78699], [-121.30725, 37.78709], [-121.30726, 37.78716], [-121.30443, 37.78792], [-121.30469, 37.78763], [-121.30484, 37.7875], [-121.30653, 37.7863], [-121.30659, 37.78638], [-121.3073, 37.78699]]]} | Open Access 1 | Mossdale Crossing Park | 22513 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 4.049 | Mossdale Crossing Park | ||
7240 | 7240 | 7239 | {"type": "Polygon", "coordinates": [[[-121.30752, 37.78825], [-121.30752, 37.78843], [-121.30743, 37.78897], [-121.30731, 37.78924], [-121.30701, 37.79015], [-121.30278, 37.79034], [-121.30342, 37.78935], [-121.30752, 37.78825]]]} | Open Access 1 | Mossdale Crossing Regional Park | 22514 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 13.924 | Mossdale Crossing RP | ||
8567 | 8567 | 8566 | {"type": "Polygon", "coordinates": [[[-121.21493, 37.83128], [-121.21276, 37.83129], [-121.21216, 37.8312], [-121.21197, 37.83116], [-121.2124, 37.8302], [-121.21203, 37.83013], [-121.21229, 37.83013], [-121.21297, 37.8302], [-121.21302, 37.82992], [-121.21309, 37.82994], [-121.21308, 37.8302], [-121.21358, 37.83025], [-121.21406, 37.83028], [-121.21458, 37.83048], [-121.21483, 37.83072], [-121.21495, 37.83107], [-121.21493, 37.83128]]]} | Open Access 1 | Raymus Village Park | 24207 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 6.547 | Raymus Village Park | ||
8627 | 8627 | 8626 | {"type": "Polygon", "coordinates": [[[-121.22742, 37.89554], [-121.2208, 37.89719], [-121.22073, 37.89205], [-121.2254, 37.8909], [-121.22742, 37.89554]]]} | Open Access 1 | Regional Sports Complex | 24276 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 70.208 | Reg. Sports Complex | ||
9514 | 9514 | 9513 | {"type": "Polygon", "coordinates": [[[-121.27031, 37.97923], [-121.26981, 37.97935], [-121.26951, 37.97862], [-121.27001, 37.9785], [-121.27031, 37.97923]]]} | Open Access 1 | West Jackson Park | 27364 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 0.965 | West Jackson Park | ||
9971 | 9971 | 9970 | {"type": "Polygon", "coordinates": [[[-121.09587, 38.20221], [-121.09573, 38.20244], [-121.09539, 38.20279], [-121.09495, 38.2033], [-121.09441, 38.20379], [-121.09392, 38.20414], [-121.09368, 38.20446], [-121.09316, 38.20486], [-121.09294, 38.20498], [-121.09139, 38.2034], [-121.09121, 38.20317], [-121.09066, 38.20236], [-121.09587, 38.20221]]]} | Open Access 1 | Stillman Magee Park | 25851 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 18.429 | Stillman Magee Park | ||
10210 | 10210 | 10209 | {"type": "Polygon", "coordinates": [[[-121.28771, 37.91609], [-121.28666, 37.91634], [-121.28651, 37.91618], [-121.28658, 37.9166], [-121.28621, 37.91636], [-121.28454, 37.91538], [-121.28396, 37.9149], [-121.28249, 37.91436], [-121.28422, 37.91391], [-121.28444, 37.91451], [-121.28469, 37.91506], [-121.28663, 37.91491], [-121.28678, 37.91541], [-121.2875, 37.91536], [-121.28771, 37.91609]]]} | Open Access 1 | Taft Park | 26165 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 10.151 | Taft Park | ||
11357 | 11357 | 11356 | {"type": "Polygon", "coordinates": [[[-121.30573, 38.15534], [-121.30566, 38.15567], [-121.30497, 38.15557], [-121.30501, 38.15536], [-121.30488, 38.15512], [-121.305, 38.1546], [-121.30535, 38.15465], [-121.30573, 38.15534]]]} | Open Access 1 | Woodbridge Community Park | 27683 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 1.491 | Woodbridge Community Park | ||
11372 | 11372 | 11371 | {"type": "Polygon", "coordinates": [[[-121.31549, 38.16334], [-121.31531, 38.16334], [-121.31523, 38.16345], [-121.31476, 38.16386], [-121.3135, 38.16385], [-121.31336, 38.16368], [-121.31335, 38.16359], [-121.31338, 38.16349], [-121.31374, 38.163], [-121.31386, 38.16277], [-121.31411, 38.16245], [-121.31416, 38.16237], [-121.31418, 38.1623], [-121.31417, 38.16212], [-121.31414, 38.16205], [-121.31396, 38.1618], [-121.31384, 38.16167], [-121.31377, 38.16162], [-121.3136, 38.16147], [-121.3133, 38.16128], [-121.31285, 38.16112], [-121.31259, 38.16107], [-121.31208, 38.16107], [-121.31085, 38.16126], [-121.31056, 38.16127], [-121.31033, 38.16126], [-121.31021, 38.16124], [-121.31015, 38.16078], [-121.31019, 38.15968], [-121.31067, 38.15967], [-121.31194, 38.15973], [-121.31208, 38.15969], [-121.31234, 38.15953], [-121.31297, 38.15966], [-121.31414, 38.16067], [-121.31442, 38.16097], [-121.3147, 38.16131], [-121.31514, 38.16195], [-121.31519, 38.16209], [-121.31529, 38.16229], [-121.31549, 38.16293], [-121.31549, 38.16334]]]} | Open Access 1 | Woodbridge Wilderness Area Regional Park | 27697 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 22.348 | Woodbridge Wilderness Area RP | ||
15097 | 15097 | 15096 | {"type": "Polygon", "coordinates": [[[-121.2753, 38.07718], [-121.27501, 38.0812], [-121.27502, 38.08121], [-121.27518, 38.08121], [-121.27479, 38.08647], [-121.26953, 38.08661], [-121.26943, 38.08653], [-121.26929, 38.07723], [-121.2693, 38.07721], [-121.27056, 38.07722], [-121.2753, 38.07718]]]} | Open Access 1 | Micke Grove Regional Park | 22202 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 128.052 | Micke Grove RP | ||
15100 | 15100 | 15099 | {"type": "Polygon", "coordinates": [[[-121.37192, 38.0577], [-121.37186, 38.05778], [-121.3718, 38.05781], [-121.37037, 38.05782], [-121.36106, 38.05763], [-121.36026, 38.05038], [-121.36994, 38.05064], [-121.3703, 38.05175], [-121.37157, 38.05586], [-121.37192, 38.0577]]]} | Open Access 1 | Oak Grove Regional Park | 22975 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 179.766 | Oak Grove RP |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);