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 sorted by UNIT_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
1835 | 1835 | 1834 | {"type": "Polygon", "coordinates": [[[-119.01169, 35.36081], [-119.01169, 35.36208], [-119.01092, 35.3621], [-119.01092, 35.36252], [-119.00964, 35.36251], [-119.00964, 35.36083], [-119.01067, 35.36084], [-119.01169, 35.36081]]]} | Open Access 1 | 15745 | Lowell Park | 21556 | 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.789 | Lowell 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 | |
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 | |
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 | |
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 | |
2089 | 2089 | 2088 | {"type": "Polygon", "coordinates": [[[-119.08688, 35.35815], [-119.0863, 35.35809], [-119.08464, 35.35808], [-119.08465, 35.35618], [-119.08519, 35.35581], [-119.08537, 35.35573], [-119.08562, 35.35569], [-119.08616, 35.35571], [-119.08618, 35.35651], [-119.08619, 35.35658], [-119.08625, 35.35674], [-119.08632, 35.35687], [-119.08646, 35.35703], [-119.08666, 35.35717], [-119.08677, 35.35726], [-119.08683, 35.35734], [-119.08688, 35.35746], [-119.08692, 35.35753], [-119.08695, 35.35775], [-119.08688, 35.35815]]]} | Open Access 1 | 15782 | Quailwood Park | 24054 | 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.603 | Quailwood 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 | |
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 | |
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 | |
1848 | 1848 | 1847 | {"type": "Polygon", "coordinates": [[[-119.06364, 35.30097], [-119.06363, 35.30281], [-119.06336, 35.30281], [-119.06335, 35.30314], [-119.06185, 35.30313], [-119.06178, 35.30308], [-119.0618, 35.30095], [-119.06364, 35.30097]]]} | Open Access 1 | 15806 | Seasons Park | 25269 | 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.786 | Seasons 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 | |
1852 | 1852 | 1851 | {"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 | 15821 | Silver Creek Park | 25485 | 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.436 | Silver Creek 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 | |
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 | |
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 | |
1853 | 1853 | 1852 | {"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 | 15841 | University Park | 26685 | 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.772 | University 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 | |
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 | |
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 |
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]);