units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where DES_TP = 2 and MNG_AGENCY = 244
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 36
MNG_AGENCY 1
- Bakersfield, City of · 36 ✖
DES_TP 1
- Local Park · 36 ✖
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 | |
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 | |
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 | |
9429 | 9429 | 9428 | {"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.05916, 35.33963], [-119.06094, 35.33963]]]} | Open Access 1 | 15768 | Patriots Park | 23517 | 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.92 | Patriots 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 | |
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 |
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]);