superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where MNG_AGENCY = 244 and MNG_AG_TYP = 2 sorted by LABEL_NAME descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
11329 | 11329 | 11328 | {"type": "Polygon", "coordinates": [[[-119.11756, 35.35004], [-119.1175, 35.35008], [-119.11691, 35.35006], [-119.11646, 35.34992], [-119.11632, 35.34986], [-119.11616, 35.34976], [-119.11592, 35.34954], [-119.11571, 35.34922], [-119.11566, 35.34907], [-119.11564, 35.34891], [-119.11564, 35.34882], [-119.11567, 35.34856], [-119.11613, 35.34859], [-119.11752, 35.34862], [-119.11755, 35.34892], [-119.11756, 35.35004]]]} | Open Access 1 | Windsor Park | 27637 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 5.964 | Windsor Park | ||
11315 | 11315 | 11314 | {"type": "Polygon", "coordinates": [[[-119.13443, 35.32752], [-119.13344, 35.32788], [-119.13326, 35.32759], [-119.13319, 35.32756], [-119.13322, 35.32748], [-119.13322, 35.3274], [-119.13317, 35.32734], [-119.13316, 35.32725], [-119.13316, 35.32675], [-119.13318, 35.32669], [-119.13317, 35.32658], [-119.13314, 35.32653], [-119.13308, 35.32648], [-119.13293, 35.32641], [-119.13282, 35.3264], [-119.13267, 35.32642], [-119.13267, 35.32597], [-119.13269, 35.32588], [-119.13416, 35.32588], [-119.13437, 35.32728], [-119.13443, 35.32752]]]} | Open Access 1 | Windermere Park | 27624 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 5.812 | Windermere 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 | ||
11215 | 11215 | 11214 | {"type": "Polygon", "coordinates": [[[-119.08916, 35.30331], [-119.0891, 35.30338], [-119.08883, 35.30342], [-119.08844, 35.30351], [-119.08824, 35.30353], [-119.08751, 35.30203], [-119.08796, 35.30189], [-119.08883, 35.30171], [-119.0889, 35.30193], [-119.08916, 35.30331]]]} | Open Access 1 | Wilderness Park | 27511 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 4.842 | Wilderness Park | ||
11160 | 11160 | 11159 | {"type": "Polygon", "coordinates": [[[-119.09118, 35.33179], [-119.09102, 35.33191], [-119.09102, 35.33198], [-119.09091, 35.33199], [-119.09088, 35.33192], [-119.0906, 35.33184], [-119.09057, 35.33144], [-119.08986, 35.33144], [-119.08986, 35.33028], [-119.09117, 35.33028], [-119.09118, 35.33179]]]} | Open Access 1 | Westwold Park | 27436 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 4.459 | Westwold 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 | ||
11081 | 11081 | 11080 | {"type": "Polygon", "coordinates": [[[-119.01156, 35.38314], [-119.01156, 35.38402], [-119.01067, 35.38358], [-119.01067, 35.3829], [-119.01115, 35.38305], [-119.01156, 35.38314]]]} | Open Access 1 | Weill Park | 27331 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1.71 | Weill Park | ||
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 | ||
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 | ||
10573 | 10573 | 10572 | {"type": "Polygon", "coordinates": [[[-118.94539, 35.40501], [-118.94194, 35.40505], [-118.94195, 35.40379], [-118.94538, 35.40375], [-118.94539, 35.40501]]]} | Open Access 1 | University Park | 26685 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 10.769 | University Park | ||
10437 | 10437 | 10436 | {"type": "Polygon", "coordinates": [[[-119.1033, 35.3041], [-119.10329, 35.30583], [-119.10223, 35.30583], [-119.10141, 35.3053], [-119.1014, 35.30396], [-119.10144, 35.30396], [-119.10145, 35.30401], [-119.10149, 35.30407], [-119.1016, 35.3041], [-119.10167, 35.30409], [-119.10177, 35.30405], [-119.10323, 35.30405], [-119.1033, 35.3041]]]} | Open Access 1 | Tradewinds Park | 26506 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 7.857 | Tradewinds Park | ||
10316 | 10316 | 10315 | {"type": "Polygon", "coordinates": [[[-119.13121, 35.35109], [-119.13109, 35.3512], [-119.1288, 35.35123], [-119.12832, 35.35117], [-119.12806, 35.35122], [-119.12658, 35.35228], [-119.12614, 35.35219], [-119.12489, 35.35236], [-119.12289, 35.35228], [-119.12266, 35.35225], [-119.12258, 35.35176], [-119.12368, 35.35086], [-119.12652, 35.35088], [-119.12679, 35.35006], [-119.12715, 35.34915], [-119.1274, 35.34918], [-119.12754, 35.34913], [-119.12827, 35.34935], [-119.12886, 35.34961], [-119.12941, 35.34991], [-119.13121, 35.35109]]]} | Open Access 1 | The Park at River Walk | 26290 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 30.043 | The Park at River Walk | ||
10299 | 10299 | 10298 | {"type": "Polygon", "coordinates": [[[-119.11572, 35.32089], [-119.11439, 35.3209], [-119.11417, 35.32089], [-119.11356, 35.32089], [-119.11358, 35.32014], [-119.11354, 35.32006], [-119.11342, 35.31995], [-119.11336, 35.31962], [-119.11337, 35.31931], [-119.11351, 35.31923], [-119.11355, 35.31917], [-119.11357, 35.31909], [-119.11356, 35.3189], [-119.11411, 35.3189], [-119.11481, 35.31884], [-119.1148, 35.31891], [-119.11484, 35.31904], [-119.11496, 35.31914], [-119.11514, 35.31917], [-119.1152, 35.31915], [-119.11572, 35.31918], [-119.11574, 35.32029], [-119.11572, 35.32089]]]} | Open Access 1 | Tevis Park | 26272 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 10.605 | Tevis 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 | ||
9970 | 9970 | 9969 | {"type": "Polygon", "coordinates": [[[-119.01411, 35.30818], [-119.01245, 35.3082], [-119.01206, 35.30819], [-119.01206, 35.30647], [-119.01212, 35.30641], [-119.01277, 35.30641], [-119.01279, 35.30677], [-119.01411, 35.30677], [-119.01411, 35.30818]]]} | Open Access 1 | Stiern Park | 25850 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 7.93 | Stiern Park | ||
14236 | 14236 | 14235 | {"type": "Polygon", "coordinates": [[[-119.092, 35.27191], [-119.07931, 35.27188], [-119.07927, 35.27426], [-119.07449, 35.27424], [-119.07447, 35.26752], [-119.0746, 35.26751], [-119.07462, 35.26735], [-119.07467, 35.2673], [-119.07475, 35.26727], [-119.07954, 35.26727], [-119.07956, 35.26717], [-119.08661, 35.26719], [-119.08663, 35.26726], [-119.09181, 35.26728], [-119.09198, 35.26742], [-119.092, 35.27191]]]} | Open Access 1 | State Farm Sports Village | http://www.bakersfieldcity.us/recreation/2011_New_facilities/sports_village.html | 442 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 231.554 | State Farm Sports Village | |
9759 | 9759 | 9758 | {"type": "Polygon", "coordinates": [[[-118.84576, 35.40858], [-118.84563, 35.40886], [-118.84545, 35.40907], [-118.84519, 35.40927], [-118.84487, 35.40941], [-118.84463, 35.40947], [-118.84433, 35.4095], [-118.84432, 35.40956], [-118.84396, 35.40956], [-118.8436, 35.40926], [-118.84359, 35.40874], [-118.84446, 35.40874], [-118.84447, 35.4086], [-118.84576, 35.40858]]]} | Open Access 1 | Solera Gardens Park | 25599 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 3.674 | Solera Gardens Park | ||
9674 | 9674 | 9673 | {"type": "Polygon", "coordinates": [[[-119.08385, 35.30273], [-119.08229, 35.30339], [-119.08218, 35.30485], [-119.082, 35.30482], [-119.08163, 35.30473], [-119.08113, 35.30457], [-119.07997, 35.30404], [-119.07995, 35.30395], [-119.08142, 35.30189], [-119.08327, 35.30222], [-119.08343, 35.30228], [-119.08359, 35.30236], [-119.08381, 35.30261], [-119.08385, 35.30273]]]} | Open Access 1 | Silver Creek Park | 25485 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 14.441 | Silver Creek Park | ||
9633 | 9633 | 9632 | {"type": "Polygon", "coordinates": [[[-118.95756, 35.40127], [-118.95671, 35.40127], [-118.95407, 35.40129], [-118.95526, 35.40028], [-118.95542, 35.40016], [-118.95552, 35.40011], [-118.95563, 35.40009], [-118.95668, 35.40007], [-118.95754, 35.40009], [-118.95756, 35.40127]]]} | Open Access 1 | Siemon Park | 25440 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 8.186 | Siemon 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]);