units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where MNG_AGENCY = 244 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, LABEL_NAME, GAP_STS
DES_TP 6
- Local Park 56
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 61
MNG_AGENCY 1
- Bakersfield, City of · 61 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6401 | 6401 | 6400 | {"type": "Polygon", "coordinates": [[[-119.00787, 35.38439], [-119.00719, 35.38439], [-119.00718, 35.38415], [-119.00787, 35.38396], [-119.00787, 35.38439]]]} | Open Access 1 | 15722 | Joshua Park | 20505 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 0.57 | Joshua Park | 0 | Local Park 2 | 4 | |
9428 | 9428 | 9427 | {"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 | 15850 | Weill Park | 27331 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 1.71 | Weill Park | 0 | Local Park 2 | 4 | |
9363 | 9363 | 9362 | {"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 | 15640 | Coral Keys Park | 17630 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 2.255 | Coral Keys Park | 0 | Local Park 2 | 4 | |
9244 | 9244 | 9243 | {"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 | 15370 | Amberton Park | 15444 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 2.612 | Amberton Park | 0 | Local Park 2 | 4 | |
9280 | 9280 | 9279 | {"type": "Polygon", "coordinates": [[[-119.15905, 35.35146], [-119.15904, 35.35179], [-119.15876, 35.3518], [-119.15874, 35.3521], [-119.15868, 35.35212], [-119.1573, 35.35211], [-119.15727, 35.3518], [-119.15731, 35.35147], [-119.15905, 35.35146]]]} | Open Access 1 | 15461 | Bill Park Greens Park | 16109 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 2.619 | Bill Park Greens Park | 0 | Local Park 2 | 4 | |
741 | 741 | 740 | {"type": "Polygon", "coordinates": [[[-119.09273, 35.41839], [-119.09269, 35.4184], [-119.0927, 35.41955], [-119.0925, 35.41955], [-119.09243, 35.41949], [-119.09241, 35.41509], [-119.09269, 35.41509], [-119.09269, 35.41693], [-119.09273, 35.41694], [-119.09273, 35.41839]]]} | Open Access 1 | 47535 | Coffee Road Dog Park | 31240 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 3.164 | Coffee Road Dog Park | 0 | Local Park 2 | 4 | |
4071 | 4071 | 4070 | {"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.84447, 35.40874], [-118.84447, 35.4086], [-118.84576, 35.40858]]]} | Open Access 1 | 44489 | Solera Gardens Park | 25599 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 3.672 | Solera Gardens Park | 0 | Local Park 2 | 4 | |
14388 | 14388 | 14387 | {"type": "Polygon", "coordinates": [[[-119.03165, 35.28241], [-119.03164, 35.28339], [-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 | 44488 | Granite Pointe Park | 19431 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 4.033 | Granite Pointe Park | 0 | Local Park 2 | 4 | |
2072 | 2072 | 2071 | {"type": "Polygon", "coordinates": [[[-119.08788, 35.34847], [-119.08765, 35.34958], [-119.08739, 35.34955], [-119.0873, 35.34987], [-119.08642, 35.34968], [-119.08619, 35.34962], [-119.08615, 35.34959], [-119.08615, 35.34954], [-119.08649, 35.349], [-119.08668, 35.34876], [-119.08709, 35.34828], [-119.08715, 35.34827], [-119.08753, 35.34839], [-119.08788, 35.34847]]]} | Open Access 1 | 15736 | Kroll Park | 20725 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 4.23 | Kroll Park | 0 | Local Park 2 | 4 | |
9325 | 9325 | 9324 | {"type": "Polygon", "coordinates": [[[-119.06768, 35.32841], [-119.06762, 35.32839], [-119.06588, 35.3284], [-119.06587, 35.32714], [-119.06637, 35.32714], [-119.06638, 35.32755], [-119.06768, 35.32755], [-119.06768, 35.32841]]]} | Open Access 1 | 15548 | Castle Park | 16952 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 4.337 | Castle Park | 0 | Local Park 2 | 4 | |
5341 | 5341 | 5340 | {"type": "Polygon", "coordinates": [[[-119.09118, 35.33179], [-119.09102, 35.33191], [-119.09102, 35.33198], [-119.09091, 35.33199], [-119.09089, 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 | 15855 | Westwold Park | 27436 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 4.455 | Westwold Park | 0 | Local Park 2 | 4 | |
1857 | 1857 | 1856 | {"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 | 15859 | Wilderness Park | 27511 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 4.843 | Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
14391 | 14391 | 14390 | {"type": "Polygon", "coordinates": [[[-119.00787, 35.29826], [-119.00786, 35.299], [-119.00781, 35.29903], [-119.00766, 35.29902], [-119.00753, 35.29904], [-119.00742, 35.29911], [-119.00737, 35.29921], [-119.00736, 35.29929], [-119.00738, 35.29937], [-119.00738, 35.30008], [-119.00731, 35.30013], [-119.00612, 35.30013], [-119.00605, 35.30008], [-119.00606, 35.30002], [-119.00614, 35.29996], [-119.00618, 35.2999], [-119.00618, 35.29985], [-119.00615, 35.29979], [-119.00637, 35.29965], [-119.00637, 35.29952], [-119.00657, 35.29952], [-119.00657, 35.2992], [-119.00667, 35.29918], [-119.00673, 35.2991], [-119.00673, 35.29903], [-119.0067, 35.29898], [-119.00677, 35.29893], [-119.00678, 35.2986], [-119.0067, 35.29825], [-119.00699, 35.29821], [-119.0078, 35.29821], [-119.00784, 35.29822], [-119.00787, 35.29826]]]} | Open Access 1 | 44508 | Linnel & Brahma Park | 21307 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 5.006 | Linnel & Brahma Park | 0 | Local Park 2 | 4 | |
9343 | 9343 | 9342 | {"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 | 15611 | Challenger Park | 17116 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 5.123 | Challenger Park | 0 | Local Park 2 | 4 | |
9382 | 9382 | 9381 | {"type": "MultiPolygon", "coordinates": [[[[-119.09687, 35.32357], [-119.09686, 35.32507], [-119.09583, 35.32509], [-119.09583, 35.32486], [-119.09578, 35.32478], [-119.09604, 35.32471], [-119.09605, 35.32356], [-119.09687, 35.32357]]], [[[-119.09685, 35.32533], [-119.09681, 35.32638], [-119.09682, 35.32659], [-119.09681, 35.32667], [-119.09595, 35.32584], [-119.09589, 35.32577], [-119.09582, 35.32556], [-119.09584, 35.32533], [-119.09649, 35.32532], [-119.09685, 35.32533]]]]} | Open Access 1 | 15695 | Garden Park | 19201 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 5.458 | Garden Park | 0 | Local Park 2 | 4 | |
9476 | 9476 | 9475 | {"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 | 15871 | Windermere Park | 27624 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 5.812 | Windermere Park | 0 | Local Park 2 | 4 | |
9376 | 9376 | 9375 | {"type": "Polygon", "coordinates": [[[-119.12268, 35.34463], [-119.12205, 35.34473], [-119.12121, 35.34482], [-119.12109, 35.34405], [-119.12101, 35.34324], [-119.12148, 35.3431], [-119.12173, 35.343], [-119.12182, 35.34294], [-119.12189, 35.34294], [-119.12226, 35.3433], [-119.12239, 35.34348], [-119.12254, 35.34374], [-119.12263, 35.34395], [-119.1227, 35.34431], [-119.12271, 35.34452], [-119.12268, 35.34463]]]} | Open Access 1 | 15686 | Deer Peak Park | 18000 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 5.931 | Deer Peak Park | 0 | Local Park 2 | 4 | |
5343 | 5343 | 5342 | {"type": "Polygon", "coordinates": [[[-119.11756, 35.35004], [-119.11751, 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 | 15875 | Windsor Park | 27637 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 5.964 | Windsor Park | 0 | Local Park 2 | 4 | |
14389 | 14389 | 14388 | {"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 | 44490 | Weston Park | 27413 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 5.967 | Weston Park | 0 | Local Park 2 | 4 | |
2093 | 2093 | 2092 | {"type": "Polygon", "coordinates": [[[-119.05003, 35.27664], [-119.05002, 35.27782], [-119.04797, 35.27782], [-119.04796, 35.27669], [-119.04803, 35.27664], [-119.05003, 35.27664]]]} | Open Access 1 | 15831 | Stonecreek Park | 25884 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 6.07 | Stonecreek 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]);