units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where ACCESS_TYP = 1 and MNG_AGENCY = 244 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP 5
- Local Park 55
- Local Conservation Area 1
- None 1
- None 1
- None 1
ACCESS_TYP 1
- Open Access · 59 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
1828 | 1828 | 1827 | {"type": "Polygon", "coordinates": [[[-119.10455, 35.332], [-119.10449, 35.33213], [-119.1042, 35.33249], [-119.10409, 35.33265], [-119.10377, 35.33321], [-119.10345, 35.33315], [-119.10324, 35.33313], [-119.10202, 35.33313], [-119.10203, 35.33142], [-119.10265, 35.33141], [-119.10291, 35.33143], [-119.1035, 35.33153], [-119.10366, 35.33158], [-119.10407, 35.33173], [-119.10438, 35.33189], [-119.10455, 35.332]]]} | Open Access 1 | 15709 | Haggin Oaks Park | 19595 | 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.867 | Haggin Oaks Park | 0 | Local Park 2 | 4 | |
1832 | 1832 | 1831 | {"type": "Polygon", "coordinates": [[[-118.9871, 35.38807], [-118.98635, 35.39014], [-118.98528, 35.39015], [-118.98515, 35.39008], [-118.9851, 35.38998], [-118.98512, 35.38969], [-118.98579, 35.38777], [-118.9871, 35.38807]]]} | Open Access 1 | 15716 | Jefferson Park | 20379 | 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.672 | Jefferson 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 | |
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 | |
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 | |
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 | |
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 | |
2012 | 2012 | 2011 | {"type": "MultiPolygon", "coordinates": [[[[-119.04066, 35.38085], [-119.03996, 35.38135], [-119.03996, 35.38137], [-119.04001, 35.38139], [-119.03999, 35.3814], [-119.03994, 35.38136], [-119.03887, 35.38086], [-119.03876, 35.38068], [-119.03878, 35.37921], [-119.03902, 35.37912], [-119.03902, 35.37941], [-119.03905, 35.37966], [-119.03919, 35.38019], [-119.0393, 35.38037], [-119.03946, 35.38055], [-119.03971, 35.38073], [-119.03995, 35.38083], [-119.04029, 35.38088], [-119.04066, 35.38085]]], [[[-119.0408, 35.37833], [-119.04077, 35.37851], [-119.04078, 35.37858], [-119.04084, 35.37869], [-119.04113, 35.379], [-119.0413, 35.37924], [-119.0414, 35.37947], [-119.04145, 35.37963], [-119.04145, 35.37973], [-119.04147, 35.37981], [-119.04146, 35.38004], [-119.04133, 35.38029], [-119.04124, 35.38041], [-119.04089, 35.38068], [-119.04074, 35.38073], [-119.04044, 35.38078], [-119.0402, 35.38078], [-119.03998, 35.38073], [-119.03971, 35.3806], [-119.03947, 35.38041], [-119.03938, 35.38029], [-119.03928, 35.38005], [-119.03919, 35.37972], [-119.03914, 35.37927], [-119.03916, 35.37887], [-119.03922, 35.37859], [-119.03924, 35.37836], [-119.03931, 35.3783], [-119.03989, 35.37827], [-119.04073, 35.37827], [-119.0408, 35.37833]]], [[[-119.04392, 35.37812], [-119.04261, 35.37937], [-119.04157, 35.38017], [-119.04156, 35.3801], [-119.04159, 35.37994], [-119.04158, 35.3798], [-119.04152, 35.37946], [-119.04139, 35.37918], [-119.04132, 35.37907], [-119.04089, 35.37855], [-119.04094, 35.37832], [-119.04101, 35.37828], [-119.04195, 35.37828], [-119.04222, 35.37886], [-119.04252, 35.37876], [-119.04232, 35.37827], [-119.04295, 35.37829], [-119.04306, 35.37836], [-119.04317, 35.37837], [-119.04326, 35.37834], [-119.04331, 35.37827], [-119.04329, 35.3782], [-119.04376, 35.37811], [-119.04392, 35.37812]]]]} | Open Access 1 | 15400 | Beach Park | 15907 | 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 | 20.975 | Beach Park | 0 | Local Park 2 | 4 | |
2033 | 2033 | 2032 | {"type": "Polygon", "coordinates": [[[-119.10222, 35.31481], [-119.10201, 35.31491], [-119.1019, 35.31494], [-119.10156, 35.31509], [-119.10071, 35.31532], [-119.09985, 35.31547], [-119.09901, 35.31553], [-119.09895, 35.31548], [-119.09894, 35.31394], [-119.09901, 35.31388], [-119.09963, 35.31383], [-119.10035, 35.31369], [-119.10092, 35.31351], [-119.10133, 35.31334], [-119.10222, 35.31481]]]} | Open Access 1 | 15525 | Campus Park South | 16789 | 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 | 12.103 | Campus Park South | 0 | Local Park 2 | 4 | |
2040 | 2040 | 2039 | {"type": "MultiPolygon", "coordinates": [[[[-119.01395, 35.37273], [-119.01395, 35.37311], [-119.01318, 35.37311], [-119.01346, 35.37273], [-119.01395, 35.37273]]], [[[-119.05443, 35.35901], [-119.05445, 35.36059], [-119.05436, 35.36107], [-119.05426, 35.36139], [-119.05419, 35.36153], [-119.05255, 35.3611], [-119.05321, 35.35937], [-119.05339, 35.359], [-119.05351, 35.35899], [-119.05443, 35.35901]]]]} | Open Access 1 | 15572 | Centennial Park | 17017 | 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.321 | Centennial Park | 0 | Local Park 2 | 4 | |
2064 | 2064 | 2063 | {"type": "Polygon", "coordinates": [[[-119.0362, 35.37357], [-119.03618, 35.37524], [-119.03409, 35.37523], [-119.03411, 35.37355], [-119.0362, 35.37357]]]} | Open Access 1 | 15713 | Jastro Park | 20371 | 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.712 | Jastro 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 | |
2083 | 2083 | 2082 | {"type": "Polygon", "coordinates": [[[-119.13121, 35.35109], [-119.13109, 35.3512], [-119.1288, 35.35123], [-119.12832, 35.35117], [-119.12806, 35.35122], [-119.12658, 35.35228], [-119.12614, 35.35219], [-119.12489, 35.35236], [-119.12289, 35.35228], [-119.12266, 35.35225], [-119.12258, 35.35175], [-119.12368, 35.35086], [-119.12652, 35.35088], [-119.12679, 35.35006], [-119.12715, 35.34915], [-119.1274, 35.34918], [-119.12754, 35.34913], [-119.12827, 35.34936], [-119.12886, 35.34961], [-119.12941, 35.34991], [-119.13121, 35.35109]]]} | Open Access 1 | 15764 | The Park at River Walk | 26290 | 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 | 30.036 | The Park at River Walk | 0 | None 167 | ||
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 | |
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 | |
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 | |
4089 | 4089 | 4088 | {"type": "Polygon", "coordinates": [[[-119.04966, 35.37461], [-119.0492, 35.37487], [-119.04914, 35.37501], [-119.04888, 35.37516], [-119.04886, 35.37525], [-119.04905, 35.37533], [-119.04893, 35.37543], [-119.04879, 35.3755], [-119.04863, 35.37569], [-119.04859, 35.37584], [-119.04815, 35.37629], [-119.04788, 35.37643], [-119.04747, 35.37659], [-119.04715, 35.37664], [-119.04681, 35.37673], [-119.04662, 35.37681], [-119.04567, 35.37758], [-119.04545, 35.37772], [-119.04508, 35.37805], [-119.04492, 35.37801], [-119.04492, 35.37792], [-119.04485, 35.37748], [-119.04485, 35.37733], [-119.0452, 35.3766], [-119.04551, 35.37616], [-119.04696, 35.37516], [-119.04732, 35.37497], [-119.04784, 35.37448], [-119.04813, 35.37429], [-119.04848, 35.37415], [-119.0486, 35.37427], [-119.04882, 35.37431], [-119.04966, 35.37461]]]} | Open Access 1 | 44507 | Yokuts Park | 27774 | 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.385 | Yokuts Park | 0 | Local Park 2 | 4 | |
5186 | 5186 | 5185 | {"type": "Polygon", "coordinates": [[[-119.02991, 35.33394], [-119.02831, 35.33395], [-119.0283, 35.33234], [-119.0299, 35.33233], [-119.02991, 35.33394]]]} | Open Access 1 | 15867 | Wilson Park | 27606 | 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.42 | Wilson 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]);