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 UNIT_NAME
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);