units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where AGNCY_LEV = 2 and MNG_AGENCY = 244 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
DES_TP 4
- Local Park 38
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 41
MNG_AGENCY 1
- Bakersfield, City of · 41 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
9262 | 9262 | 9261 | {"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 | 15427 | Beale Park | 15915 | 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.344 | Beale 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 | |
9298 | 9298 | 9297 | {"type": "Polygon", "coordinates": [[[-119.1059, 35.3198], [-119.10595, 35.31985], [-119.10597, 35.31993], [-119.10609, 35.32014], [-119.1061, 35.3202], [-119.10615, 35.32027], [-119.10616, 35.32034], [-119.10619, 35.3204], [-119.10623, 35.32053], [-119.10627, 35.32076], [-119.10628, 35.32118], [-119.10624, 35.32145], [-119.10619, 35.32167], [-119.10602, 35.32211], [-119.10597, 35.32217], [-119.10574, 35.32251], [-119.10559, 35.32267], [-119.10552, 35.32274], [-119.10542, 35.32275], [-119.10524, 35.32261], [-119.10496, 35.32237], [-119.10476, 35.32216], [-119.10454, 35.32191], [-119.1043, 35.32156], [-119.10377, 35.32068], [-119.1059, 35.3198]]]} | Open Access 1 | 15493 | Campus Park North | 16788 | 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 | 11.116 | Campus Park North | 0 | Local Park 2 | 4 | |
9321 | 9321 | 9320 | {"type": "Polygon", "coordinates": [[[-119.00864, 35.37632], [-119.00863, 35.37719], [-119.00843, 35.37723], [-119.00844, 35.37794], [-119.00843, 35.37799], [-119.00643, 35.37799], [-119.00669, 35.37726], [-119.00715, 35.37631], [-119.00864, 35.37632]]]} | Open Access 1 | 15595 | Central Park | 17050 | 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.424 | Central 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 | |
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 | |
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 | |
9371 | 9371 | 9370 | {"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 | 15663 | Corvallis Park | 17667 | 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.784 | Corvallis 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 | |
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 | |
9398 | 9398 | 9397 | {"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 | 15705 | Grissom Park | 19522 | 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 | 11.244 | Grissom Park | 0 | Local Park 2 | 4 | |
9410 | 9410 | 9409 | {"type": "Polygon", "coordinates": [[[-119.0162, 35.34305], [-119.01619, 35.34662], [-119.01587, 35.34662], [-119.01595, 35.34514], [-119.01543, 35.34384], [-119.01476, 35.34282], [-119.01463, 35.34233], [-119.01457, 35.33954], [-119.0157, 35.33953], [-119.01569, 35.34304], [-119.0162, 35.34305]]]} | Open Access 1 | 15846 | Wayside Park | 27323 | 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 | 14.07 | Wayside Park | 0 | Local Park 2 | 4 | |
9418 | 9418 | 9417 | {"type": "Polygon", "coordinates": [[[-119.10606, 35.3285], [-119.10597, 35.32863], [-119.10596, 35.32869], [-119.10599, 35.32888], [-119.10372, 35.32889], [-119.10372, 35.32853], [-119.10379, 35.32848], [-119.10383, 35.32842], [-119.10385, 35.32836], [-119.10385, 35.32829], [-119.1038, 35.32783], [-119.10376, 35.32767], [-119.10366, 35.32737], [-119.10353, 35.32711], [-119.10326, 35.32673], [-119.10302, 35.32649], [-119.10282, 35.32633], [-119.10265, 35.32621], [-119.10263, 35.32614], [-119.10359, 35.32514], [-119.1037, 35.32514], [-119.10408, 35.3254], [-119.10462, 35.32592], [-119.10487, 35.32624], [-119.105, 35.32641], [-119.10515, 35.32673], [-119.1052, 35.32679], [-119.10552, 35.32753], [-119.10552, 35.32759], [-119.10556, 35.32765], [-119.10563, 35.32772], [-119.10574, 35.32777], [-119.10592, 35.32811], [-119.10606, 35.3285]]]} | Open Access 1 | 15772 | Pin Oak Park | 23673 | 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 | 16.742 | Pin Oak Park | 0 | Local Park 2 | 4 | |
9421 | 9421 | 9420 | {"type": "Polygon", "coordinates": [[[-118.99398, 35.36618], [-118.99392, 35.36646], [-118.99389, 35.36684], [-118.99388, 35.3683], [-118.99197, 35.3683], [-118.99196, 35.36736], [-118.99087, 35.36736], [-118.99088, 35.36618], [-118.99398, 35.36618]]]} | Open Access 1 | 15749 | Martin Luther King Jr. Park | 21911 | 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 | 13.437 | Martin Luther King Jr. Park | 0 | Local Park 2 | 4 | |
9425 | 9425 | 9424 | {"type": "Polygon", "coordinates": [[[-118.88948, 35.39532], [-118.88947, 35.39791], [-118.8892, 35.39793], [-118.88865, 35.39794], [-118.88598, 35.39794], [-118.88606, 35.39586], [-118.88782, 35.39587], [-118.88887, 35.39527], [-118.88948, 35.39532]]]} | Open Access 1 | 15760 | Mesa Marin Ball Diamonds | 22176 | 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 | 19.472 | Mesa Marin Ball Diamonds | None 777 | |||
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 |
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]);