superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where MNG_AGENCY = 244 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11074 | 11074 | 11073 | {"type": "Polygon", "coordinates": [[[-119.0162, 35.34305], [-119.01619, 35.34662], [-119.01587, 35.34662], [-119.01595, 35.34514], [-119.01543, 35.34385], [-119.01476, 35.34282], [-119.01463, 35.34234], [-119.01457, 35.33954], [-119.0157, 35.33953], [-119.01569, 35.34303], [-119.0162, 35.34305]]]} | Open Access 1 | Wayside Park | 27323 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 14.077 | Wayside Park | ||
8223 | 8223 | 8222 | {"type": "Polygon", "coordinates": [[[-119.02078, 35.32233], [-119.02077, 35.32484], [-119.01815, 35.32484], [-119.01821, 35.32477], [-119.02078, 35.32233]]]} | Open Access 1 | Planz Park | 23769 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 8.279 | Planz Park | ||
1860 | 1860 | 1859 | {"type": "Polygon", "coordinates": [[[-119.02535, 35.36143], [-119.02535, 35.36309], [-119.02381, 35.36309], [-119.02382, 35.36143], [-119.02535, 35.36143]]]} | Open Access 1 | Beale Park | 15915 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 6.344 | Beale Park | ||
10567 | 10567 | 10566 | {"type": "Polygon", "coordinates": [[[-119.02868, 35.39679], [-119.02821, 35.39709], [-119.0278, 35.39747], [-119.02762, 35.39767], [-119.02735, 35.39792], [-119.02715, 35.39817], [-119.02705, 35.39832], [-119.027, 35.39846], [-119.02684, 35.39878], [-119.02681, 35.39902], [-119.02658, 35.39913], [-119.02645, 35.39906], [-119.0261, 35.39805], [-119.02594, 35.39804], [-119.02589, 35.39812], [-119.02574, 35.39843], [-119.02569, 35.39859], [-119.02556, 35.39872], [-119.0253, 35.39889], [-119.02512, 35.39905], [-119.02489, 35.39919], [-119.02481, 35.39928], [-119.02467, 35.39929], [-119.02454, 35.39935], [-119.02439, 35.39951], [-119.02404, 35.39963], [-119.02381, 35.39966], [-119.02294, 35.39965], [-119.02279, 35.39968], [-119.02263, 35.39968], [-119.02236, 35.39976], [-119.02206, 35.39993], [-119.02189, 35.40007], [-119.02169, 35.40012], [-119.0215, 35.40012], [-119.02138, 35.40017], [-119.02126, 35.40024], [-119.02125, 35.40031], [-119.02113, 35.40045], [-119.02093, 35.40051], [-119.02085, 35.40057], [-119.02083, 35.40063], [-119.02072, 35.40067], [-119.02059, 35.40069], [-119.02043, 35.40073], [-119.02028, 35.40073], [-119.02024, 35.4008], [-119.02002, 35.40099], [-119.01979, 35.40127], [-119.01976, 35.40134], [-119.01976, 35.40142], [-119.01982, 35.40161], [-119.01975, 35.40174], [-119.01966, 35.40177], [-119.01956, 35.40177], [-119.01911, 35.40095], [-119.01903, 35.40059], [-119.01945, 35.40047], [-119.01991, 35.40029], [-119.0203, 35.40001], [-119.02148, 35.39921], [-119.02175, 35.39908], [-119.02256, 35.39881], [-119.02307, 35.39873], [-119.02293, 35.39821], [-119.02305, 35.39819], [-119.02326, 35.39872], [-119.02508, 35.39826], [-119.02559, 35.39802], [-119.02593, 35.39793], [-119.02621, 35.39794], [-119.02638, 35.39792], [-119.02661, 35.39782], [-119.0267, 35.39771], [-119.02674, 35.39755], [-119.02674, 35.39741], [-119.02683, 35.39731], [-119.02703, 35.39701], [-119.02711, 35.39673], [-119.02713, 35.39614], [-119.02715, 35.39596], [-119.02715, 35.39578], [-119.0272, 35.39566], [-119.02868, 35.39679]]]} | Open Access 1 | Uplands of the Kern River Parkway Park | 26724 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 23.301 | Uplands of the Kern River Parkway Park | ||
11299 | 11299 | 11298 | {"type": "Polygon", "coordinates": [[[-119.02991, 35.33394], [-119.02831, 35.33395], [-119.0283, 35.33234], [-119.0299, 35.33233], [-119.02991, 35.33394]]]} | Open Access 1 | Wilson Park | 27606 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 6.419 | Wilson Park | ||
4693 | 4693 | 4692 | {"type": "Polygon", "coordinates": [[[-119.03165, 35.28241], [-119.03165, 35.28338], [-119.03162, 35.28342], [-119.03159, 35.28344], [-119.03098, 35.28343], [-119.03087, 35.2834], [-119.03077, 35.2834], [-119.03066, 35.28343], [-119.03056, 35.2835], [-119.0301, 35.2835], [-119.0301, 35.2824], [-119.03165, 35.28241]]]} | Open Access 1 | Granite Pointe Park | 19431 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 4.033 | Granite Pointe Park | ||
5498 | 5498 | 5497 | {"type": "Polygon", "coordinates": [[[-119.0362, 35.37357], [-119.03618, 35.37524], [-119.03409, 35.37523], [-119.03411, 35.37355], [-119.0362, 35.37357]]]} | Open Access 1 | Jastro Park | 20371 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 8.711 | Jastro Park | ||
9360 | 9360 | 9359 | {"type": "Polygon", "coordinates": [[[-119.0422, 35.36146], [-119.04219, 35.36314], [-119.04004, 35.36314], [-119.04005, 35.36227], [-119.03993, 35.36147], [-119.04056, 35.36145], [-119.0422, 35.36146]]]} | Open Access 1 | Saunders Park | 25171 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 9.097 | Saunders Park | ||
2826 | 2826 | 2825 | {"type": "Polygon", "coordinates": [[[-119.04766, 35.30303], [-119.04761, 35.30307], [-119.04598, 35.30306], [-119.04598, 35.30183], [-119.04765, 35.30184], [-119.04766, 35.30303]]]} | Open Access 1 | Challenger Park | 17116 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 5.123 | Challenger Park | ||
11427 | 11427 | 11426 | {"type": "Polygon", "coordinates": [[[-119.04966, 35.37461], [-119.0492, 35.37486], [-119.04914, 35.37501], [-119.04889, 35.37516], [-119.04887, 35.37525], [-119.04905, 35.37533], [-119.04893, 35.37543], [-119.04879, 35.3755], [-119.04863, 35.37569], [-119.04859, 35.37584], [-119.04815, 35.37629], [-119.04788, 35.37643], [-119.04747, 35.37659], [-119.04715, 35.37664], [-119.04681, 35.37673], [-119.04662, 35.37681], [-119.04567, 35.37758], [-119.04545, 35.37772], [-119.04508, 35.37805], [-119.04492, 35.37801], [-119.04492, 35.37792], [-119.04485, 35.37748], [-119.04485, 35.37733], [-119.0452, 35.3766], [-119.04551, 35.37616], [-119.04696, 35.37516], [-119.04732, 35.37497], [-119.04784, 35.37448], [-119.04813, 35.37429], [-119.04848, 35.37415], [-119.0486, 35.37427], [-119.04882, 35.37431], [-119.04966, 35.37461]]]} | Open Access 1 | Yokuts Park | 27774 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 16.387 | Yokuts Park | ||
9994 | 9994 | 9993 | {"type": "Polygon", "coordinates": [[[-119.05003, 35.27664], [-119.05002, 35.27782], [-119.04797, 35.27782], [-119.04796, 35.2767], [-119.04803, 35.27664], [-119.05003, 35.27664]]]} | Open Access 1 | Stonecreek Park | 25884 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 6.069 | Stonecreek Park | ||
11101 | 11101 | 11100 | {"type": "Polygon", "coordinates": [[[-119.05992, 35.27041], [-119.05991, 35.2711], [-119.05985, 35.27115], [-119.0596, 35.27115], [-119.05932, 35.27117], [-119.05905, 35.27123], [-119.05885, 35.27129], [-119.05859, 35.27139], [-119.05837, 35.27152], [-119.05816, 35.27166], [-119.05801, 35.2718], [-119.05792, 35.27181], [-119.05761, 35.27158], [-119.05761, 35.27069], [-119.05757, 35.27042], [-119.05762, 35.27036], [-119.05985, 35.27035], [-119.05992, 35.27041]]]} | Open Access 1 | Weston Park | 27413 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 5.967 | Weston Park | ||
8017 | 8017 | 8016 | {"type": "Polygon", "coordinates": [[[-119.06094, 35.33963], [-119.06095, 35.33979], [-119.06093, 35.34185], [-119.05764, 35.34186], [-119.05764, 35.33943], [-119.05829, 35.33925], [-119.05916, 35.33895], [-119.05917, 35.33963], [-119.06094, 35.33963]]]} | Open Access 1 | Patriots Park | 23517 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 19.925 | Patriots Park | ||
9467 | 9467 | 9466 | {"type": "Polygon", "coordinates": [[[-119.06364, 35.30097], [-119.06363, 35.30281], [-119.06336, 35.30282], [-119.06335, 35.30314], [-119.06185, 35.30313], [-119.06178, 35.30308], [-119.0618, 35.30095], [-119.06364, 35.30097]]]} | Open Access 1 | Seasons Park | 25269 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 9.786 | Seasons Park | ||
4769 | 4769 | 4768 | {"type": "Polygon", "coordinates": [[[-119.06452, 35.3183], [-119.06267, 35.3203], [-119.06258, 35.32063], [-119.06141, 35.3204], [-119.06148, 35.31982], [-119.06149, 35.31863], [-119.06152, 35.31829], [-119.06452, 35.3183]]]} | Open Access 1 | Grissom Park | 19522 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 11.244 | Grissom Park | ||
2689 | 2689 | 2688 | {"type": "Polygon", "coordinates": [[[-119.06768, 35.32841], [-119.06762, 35.32839], [-119.06588, 35.3284], [-119.06587, 35.32714], [-119.06637, 35.32714], [-119.06639, 35.32755], [-119.06768, 35.32755], [-119.06768, 35.32841]]]} | Open Access 1 | Castle Park | 16952 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 4.341 | Castle Park | ||
2688 | 2688 | 2687 | {"type": "Polygon", "coordinates": [[[-119.0697, 35.32864], [-119.06838, 35.32934], [-119.06763, 35.3284], [-119.06767, 35.32841], [-119.06768, 35.32839], [-119.06768, 35.32755], [-119.06886, 35.32754], [-119.06911, 35.32757], [-119.06936, 35.32809], [-119.0695, 35.32835], [-119.0697, 35.32864]]]} | No Public Access 3 | Castle Park | 16951 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 6.242 | Castle Park | ||
3179 | 3179 | 3178 | {"type": "Polygon", "coordinates": [[[-119.07252, 35.30437], [-119.07156, 35.30436], [-119.07155, 35.30343], [-119.07246, 35.30343], [-119.07252, 35.30349], [-119.07252, 35.30437]]]} | Open Access 1 | Coral Keys Park | 17630 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 2.254 | Coral Keys Park | ||
3205 | 3205 | 3204 | {"type": "Polygon", "coordinates": [[[-119.07821, 35.32617], [-119.07819, 35.3266], [-119.07815, 35.32678], [-119.07806, 35.32693], [-119.07795, 35.32706], [-119.0778, 35.32719], [-119.07764, 35.32729], [-119.07746, 35.32738], [-119.07706, 35.32746], [-119.0753, 35.32745], [-119.07529, 35.32615], [-119.07651, 35.32614], [-119.07675, 35.32615], [-119.07805, 35.32615], [-119.07821, 35.32617]]]} | Open Access 1 | Corvallis Park | 17667 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 8.783 | Corvallis Park | ||
1472 | 1472 | 1471 | {"type": "Polygon", "coordinates": [[[-119.08123, 35.33969], [-119.08111, 35.33977], [-119.08053, 35.33992], [-119.08018, 35.33997], [-119.08, 35.33996], [-119.07999, 35.33917], [-119.08003, 35.33911], [-119.08003, 35.33903], [-119.08027, 35.33889], [-119.08093, 35.33889], [-119.08096, 35.33911], [-119.08101, 35.33926], [-119.08123, 35.33969]]]} | Open Access 1 | Amberton Park | 15444 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 2.612 | Amberton Park |
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]);