units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where MNG_AGENCY = 244 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14404 | 14404 | 14403 | {"type": "Polygon", "coordinates": [[[-119.092, 35.27191], [-119.0793, 35.27188], [-119.07927, 35.27426], [-119.07449, 35.27424], [-119.07447, 35.26752], [-119.0746, 35.26751], [-119.0746, 35.26739], [-119.07462, 35.26735], [-119.07467, 35.2673], [-119.07475, 35.26727], [-119.07955, 35.26727], [-119.07956, 35.26717], [-119.08661, 35.26719], [-119.08662, 35.26726], [-119.09181, 35.26728], [-119.09198, 35.26742], [-119.092, 35.27191]]]} | Open Access 1 | 44510 | State Farm Sports Village | 442 | 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 | http://www.bakersfieldcity.us/recreation/2011_New_facilities/sports_village.html | Kern 36 | 231.537 | State Farm Sports Village | None 1223 | ||
14403 | 14403 | 14402 | {"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.39804], [-119.02594, 35.39804], [-119.02589, 35.39812], [-119.02574, 35.39843], [-119.02569, 35.39859], [-119.02556, 35.39872], [-119.02529, 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.02125, 35.40024], [-119.02125, 35.40031], [-119.02113, 35.40045], [-119.02093, 35.4005], [-119.02085, 35.40057], [-119.02083, 35.40063], [-119.02072, 35.40067], [-119.02059, 35.40069], [-119.02043, 35.40073], [-119.02027, 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.02308, 35.39873], [-119.02293, 35.39821], [-119.02305, 35.39819], [-119.02325, 35.39872], [-119.02508, 35.39826], [-119.02559, 35.39802], [-119.02593, 35.39793], [-119.02621, 35.39794], [-119.02638, 35.39792], [-119.02662, 35.39782], [-119.02669, 35.39771], [-119.02674, 35.39755], [-119.02674, 35.39741], [-119.02683, 35.39731], [-119.02703, 35.397], [-119.02711, 35.39673], [-119.02713, 35.39614], [-119.02715, 35.39597], [-119.02715, 35.39578], [-119.0272, 35.39566], [-119.02868, 35.39679]]]} | Open Access 1 | 44509 | Uplands of the Kern River Parkway Park | 26724 | 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 | 23.286 | Uplands of the Kern River Parkway Park | 0 | Local Park 2 | 4 | |
14393 | 14393 | 14392 | {"type": "MultiPolygon", "coordinates": [[[[-119.25231, 35.30226], [-119.25231, 35.30309], [-119.25223, 35.3031], [-119.25222, 35.30377], [-119.25231, 35.30378], [-119.2523, 35.30706], [-119.24691, 35.30706], [-119.24689, 35.31068], [-119.24357, 35.31069], [-119.24355, 35.31431], [-119.23467, 35.3143], [-119.23463, 35.31794], [-119.23106, 35.31795], [-119.23105, 35.31986], [-119.21949, 35.32], [-119.21947, 35.32536], [-119.21637, 35.3254], [-119.21635, 35.32721], [-119.21203, 35.32721], [-119.21196, 35.33231], [-119.21237, 35.33267], [-119.19869, 35.33266], [-119.19417, 35.33263], [-119.19407, 35.33993], [-119.18531, 35.33985], [-119.18533, 35.34355], [-119.1809, 35.34352], [-119.18092, 35.34642], [-119.17282, 35.34638], [-119.17282, 35.34627], [-119.17216, 35.3462], [-119.17025, 35.34618], [-119.16994, 35.3462], [-119.16942, 35.34631], [-119.16922, 35.34633], [-119.16921, 35.34661], [-119.16335, 35.34659], [-119.16335, 35.34614], [-119.16316, 35.34614], [-119.16314, 35.34659], [-119.1549, 35.34666], [-119.15433, 35.34673], [-119.15381, 35.34673], [-119.1538, 35.34675], [-119.14748, 35.3468], [-119.14747, 35.34678], [-119.14733, 35.34678], [-119.14702, 35.34685], [-119.14677, 35.34695], [-119.14658, 35.34707], [-119.14631, 35.34729], [-119.14553, 35.3473], [-119.14553, 35.34797], [-119.145, 35.34843], [-119.14497, 35.34841], [-119.14437, 35.34892], [-119.14412, 35.34909], [-119.1438, 35.34925], [-119.14342, 35.34939], [-119.14313, 35.34947], [-119.14132, 35.34975], [-119.14085, 35.34986], [-119.14051, 35.34998], [-119.13735, 35.3512], [-119.13734, 35.35119], [-119.13699, 35.3513], [-119.1356, 35.35161], [-119.13549, 35.35161], [-119.13497, 35.3515], [-119.13484, 35.35151], [-119.133, 35.35189], [-119.13144, 35.35085], [-119.13213, 35.35018], [-119.13545, 35.34873], [-119.1366, 35.34848], [-119.13659, 35.34756], [-119.13714, 35.3473], [-119.14146, 35.34564], [-119.14337, 35.34493], [-119.14412, 35.34462], [-119.14552, 35.34446], [-119.14552, 35.3456], [-119.14554, 35.34561], [-119.14565, 35.34507], [-119.15013, 35.34469], [-119.15125, 35.34468], [-119.15439, 35.3431], [-119.16039, 35.34305], [-119.16326, 35.34385], [-119.16327, 35.34414], [-119.16498, 35.34432], [-119.16768, 35.34402], [-119.16837, 35.34364], [-119.16913, 35.34254], [-119.16938, 35.34184], [-119.1713, 35.33983], [-119.17208, 35.33982], [-119.17212, 35.33618], [-119.17652, 35.33617], [-119.17656, 35.33253], [-119.18096, 35.33252], [-119.18107, 35.32415], [-119.18682, 35.32194], [-119.18726, 35.32181], [-119.197, 35.32044], [-119.19726, 35.32038], [-119.19748, 35.32027], [-119.19882, 35.32142], [-119.20352, 35.32537], [-119.20396, 35.32537], [-119.20396, 35.32535], [-119.19775, 35.32011], [-119.21331, 35.31076], [-119.21743, 35.30838], [-119.21775, 35.30826], [-119.21817, 35.30814], [-119.21859, 35.30805], [-119.21893, 35.30799], [-119.23869, 35.30597], [-119.2387, 35.30596], [-119.23866, 35.3057], [-119.24602, 35.30491], [-119.24784, 35.30307], [-119.25231, 35.30226]]], [[[-119.26408, 35.30353], [-119.25461, 35.30346], [-119.25393, 35.30397], [-119.25258, 35.30426], [-119.25258, 35.30378], [-119.25266, 35.30377], [-119.25266, 35.30311], [-119.25258, 35.30309], [-119.25258, 35.30216], [-119.25321, 35.30159], [-119.25464, 35.30088], [-119.25577, 35.30059], [-119.25736, 35.30052], [-119.25921, 35.30106], [-119.26113, 35.30122], [-119.26408, 35.30353]]]]} | Restricted Access 2 | 44492 | 2800 Acre Water Bank | 15189 | 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 | 3053.963 | 2800 Acre Water Bank | None 1220 | |||
14392 | 14392 | 14391 | {"type": "Polygon", "coordinates": [[[-119.0697, 35.32864], [-119.06838, 35.32934], [-119.06763, 35.3284], [-119.06767, 35.32841], [-119.06768, 35.3284], [-119.06768, 35.32755], [-119.06886, 35.32754], [-119.06911, 35.32757], [-119.06936, 35.32809], [-119.0695, 35.32834], [-119.0697, 35.32864]]]} | No Public Access 3 | 44533 | Castle Park | 16951 | 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.243 | Castle Park | 0 | Local Park 2 | 4 | |
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 | |
14390 | 14390 | 14389 | {"type": "Polygon", "coordinates": [[[-118.853, 35.42737], [-118.85233, 35.4275], [-118.85224, 35.42756], [-118.85217, 35.42753], [-118.85183, 35.4276], [-118.85182, 35.42812], [-118.85173, 35.42816], [-118.85168, 35.42824], [-118.85158, 35.42823], [-118.85154, 35.4284], [-118.85135, 35.42839], [-118.85127, 35.42841], [-118.85118, 35.42845], [-118.85088, 35.42875], [-118.85052, 35.42852], [-118.85038, 35.42865], [-118.84965, 35.42802], [-118.84831, 35.42726], [-118.85175, 35.4272], [-118.85169, 35.42722], [-118.85164, 35.42725], [-118.8516, 35.42729], [-118.85159, 35.42735], [-118.85161, 35.4274], [-118.85165, 35.42744], [-118.85176, 35.42748], [-118.85185, 35.42746], [-118.85193, 35.42738], [-118.85197, 35.42736], [-118.85261, 35.42736], [-118.85275, 35.4273], [-118.85283, 35.42719], [-118.853, 35.42718], [-118.853, 35.42737]]]} | Open Access 1 | 44491 | Rivers Edge Park | 24444 | 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 | 8.201 | Rivers Edge 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 | |
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 | |
14387 | 14387 | 14386 | {"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.10166, 35.30409], [-119.10177, 35.30405], [-119.10323, 35.30405], [-119.1033, 35.3041]]]} | Open Access 1 | 44487 | Tradewinds Park | 26506 | 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 | 7.858 | Tradewinds Park | 0 | Local Park 2 | 4 | |
14386 | 14386 | 14385 | {"type": "Polygon", "coordinates": [[[-119.12173, 35.30218], [-119.12172, 35.30329], [-119.12165, 35.30334], [-119.11978, 35.3033], [-119.119, 35.30329], [-119.1189, 35.30321], [-119.11889, 35.30212], [-119.12002, 35.30212], [-119.12013, 35.30215], [-119.12026, 35.30213], [-119.12167, 35.30213], [-119.12171, 35.30215], [-119.12173, 35.30218]]]} | Open Access 1 | 44486 | Greystone Park | 19505 | 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 | 8.334 | Greystone Park | 0 | Local Park 2 | 4 | |
14385 | 14385 | 14384 | {"type": "Polygon", "coordinates": [[[-118.89374, 35.40325], [-118.89371, 35.4033], [-118.89307, 35.40346], [-118.89123, 35.40408], [-118.89117, 35.40405], [-118.89098, 35.40369], [-118.89052, 35.40294], [-118.89051, 35.4029], [-118.89052, 35.40287], [-118.89056, 35.40283], [-118.89074, 35.40277], [-118.89241, 35.40222], [-118.89279, 35.40211], [-118.89336, 35.40198], [-118.89345, 35.40202], [-118.89374, 35.40325]]]} | Open Access 1 | 44484 | City in the Hills Park | 17303 | 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 | 9.908 | City in the Hills Park | 0 | Local Park 2 | 4 | |
12163 | 12163 | 12162 | {"type": "Polygon", "coordinates": [[[-119.00931, 35.40411], [-119.0079, 35.40468], [-119.00719, 35.40388], [-119.00688, 35.40348], [-119.0066, 35.40306], [-119.00627, 35.40248], [-119.00623, 35.40238], [-119.00624, 35.40222], [-119.00634, 35.40206], [-119.00607, 35.40189], [-119.00599, 35.40197], [-119.00591, 35.4021], [-119.00586, 35.40223], [-119.00584, 35.40236], [-119.00563, 35.402], [-119.00586, 35.40186], [-119.00598, 35.40174], [-119.00712, 35.40101], [-119.00745, 35.40128], [-119.0084, 35.40275], [-119.00866, 35.40304], [-119.00843, 35.4033], [-119.00883, 35.40333], [-119.00931, 35.40411]]]} | Open Access 1 | 48747 | San Miguel Commemorative Grove | 33473 | 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 | https://kernriverparkway.org/parks-and-open-space-in-the-parkway/ | Kern 36 | 14.658 | San Miguel Commemorative Grove | 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 | |
9470 | 9470 | 9469 | {"type": "Polygon", "coordinates": [[[-119.11572, 35.32089], [-119.11439, 35.3209], [-119.11417, 35.32089], [-119.11356, 35.32089], [-119.11358, 35.32013], [-119.11354, 35.32006], [-119.11342, 35.31995], [-119.11336, 35.31962], [-119.11337, 35.31931], [-119.11351, 35.31923], [-119.11355, 35.31918], [-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 | 15836 | Tevis Park | 26272 | 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 | 10.605 | Tevis Park | 0 | Local Park 2 | 4 | |
9459 | 9459 | 9458 | {"type": "Polygon", "coordinates": [[[-118.95668, 35.40007], [-118.95754, 35.40009], [-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]]]} | Open Access 1 | 15816 | Siemon Park | 25440 | 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 | 8.187 | Siemon Park | 0 | Local Park 2 | 4 | |
9454 | 9454 | 9453 | {"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.01278, 35.30677], [-119.01411, 35.30677], [-119.01411, 35.30818]]]} | Open Access 1 | 15826 | Stiern Park | 25850 | 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 | 7.927 | Stiern Park | 0 | Local Park 2 | 4 | |
9449 | 9449 | 9448 | {"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 | 15800 | Saunders Park | 25171 | 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 | 9.098 | Saunders Park | 0 | Local Park 2 | 4 | |
9445 | 9445 | 9444 | {"type": "Polygon", "coordinates": [[[-119.14472, 35.34436], [-119.14417, 35.34461], [-119.14412, 35.34462], [-119.14337, 35.34493], [-119.14146, 35.34564], [-119.13714, 35.3473], [-119.1366, 35.34756], [-119.1366, 35.34847], [-119.13545, 35.34872], [-119.13213, 35.35018], [-119.13143, 35.35086], [-119.13097, 35.35054], [-119.131, 35.35048], [-119.13106, 35.35045], [-119.13113, 35.35049], [-119.13127, 35.35046], [-119.13132, 35.3504], [-119.13132, 35.3503], [-119.13202, 35.34976], [-119.13241, 35.34953], [-119.13279, 35.34938], [-119.13366, 35.34907], [-119.13514, 35.34831], [-119.13532, 35.34834], [-119.13538, 35.3483], [-119.13544, 35.34824], [-119.13543, 35.34817], [-119.1354, 35.34811], [-119.13549, 35.3481], [-119.13559, 35.34812], [-119.13566, 35.3481], [-119.13574, 35.34803], [-119.13576, 35.34793], [-119.13626, 35.34762], [-119.13678, 35.3472], [-119.13793, 35.34654], [-119.14053, 35.34541], [-119.14217, 35.34498], [-119.14231, 35.34496], [-119.14244, 35.34485], [-119.14246, 35.34479], [-119.14246, 35.3447], [-119.14244, 35.34461], [-119.14232, 35.34437], [-119.14228, 35.34431], [-119.14206, 35.34394], [-119.14224, 35.34384], [-119.1427, 35.3437], [-119.14279, 35.34383], [-119.14288, 35.344], [-119.14308, 35.34425], [-119.14312, 35.34434], [-119.14331, 35.34443], [-119.14456, 35.34428], [-119.14472, 35.34436]]]} | Open Access 1 | 15792 | River Oaks Park | 24413 | 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 | 18.365 | River Oaks Park | 0 | Local Park 2 | 4 | |
9441 | 9441 | 9440 | {"type": "Polygon", "coordinates": [[[-119.1364, 35.35392], [-119.13618, 35.35476], [-119.13553, 35.35556], [-119.13484, 35.3562], [-119.13383, 35.35682], [-119.13254, 35.35736], [-119.13046, 35.35455], [-119.13061, 35.35455], [-119.13074, 35.3545], [-119.13061, 35.35429], [-119.13363, 35.35294], [-119.13374, 35.35293], [-119.1344, 35.35328], [-119.13509, 35.35353], [-119.13576, 35.35375], [-119.1364, 35.35392]]]} | Open Access 1 | 15787 | Aera Park | 15280 | 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 | 38.002 | Aera Park | 0 | Local Park 2 | 4 | |
9436 | 9436 | 9435 | {"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 | 15777 | Planz Park | 23769 | 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 | 8.279 | Planz 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]);