units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

240 rows where ACCESS_TYP = 1 and COUNTY = 36

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 240 ✖
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
1062 1062 1061 {"type": "MultiPolygon", "coordinates": [[[[-118.45673, 35.11371], [-118.45597, 35.11371], [-118.45593, 35.11377], [-118.45581, 35.11377], [-118.45578, 35.11371], [-118.45496, 35.11372], [-118.45493, 35.11377], [-118.45481, 35.11377], [-118.45478, 35.11372], [-118.45396, 35.11372], [-118.45393, 35.11377], [-118.45381, 35.11378], [-118.45377, 35.11372], [-118.4533, 35.11373], [-118.4533, 35.11405], [-118.45325, 35.1142], [-118.45294, 35.11456], [-118.45264, 35.11437], [-118.45246, 35.11418], [-118.45238, 35.11404], [-118.45233, 35.11388], [-118.45231, 35.11363], [-118.45234, 35.11342], [-118.45246, 35.11307], [-118.45265, 35.11274], [-118.45281, 35.11254], [-118.45313, 35.11274], [-118.45334, 35.11296], [-118.45335, 35.11356], [-118.45376, 35.11356], [-118.45378, 35.11354], [-118.45388, 35.11355], [-118.45395, 35.11353], [-118.45397, 35.11355], [-118.45476, 35.11355], [-118.45478, 35.11353], [-118.45488, 35.11355], [-118.45495, 35.11353], [-118.45497, 35.11355], [-118.45573, 35.11355], [-118.45575, 35.11353], [-118.45582, 35.11354], [-118.45592, 35.11353], [-118.45594, 35.11354], [-118.45672, 35.11354], [-118.45673, 35.11371]]], [[[-118.45822, 35.1139], [-118.45803, 35.11388], [-118.45779, 35.11378], [-118.45764, 35.11374], [-118.45703, 35.11373], [-118.45698, 35.11369], [-118.45698, 35.11358], [-118.45822, 35.11358], [-118.45822, 35.1139]]]]} Open Access 1 48916 Warrior Park 33637 1467 Tehachapi, City of 310 City 2 City Agency 2 http://www.tehachapicityhall.com/ City 2 1467 Tehachapi, City of 307 City 2 City Agency 2 https://www.tvrpd.org/ Kern 36 5.909 Warrior Park 0 Local Park 2 4
1569 1569 1568 {"type": "Polygon", "coordinates": [[[-119.03325, 35.4423], [-119.03318, 35.445], [-119.03099, 35.44499], [-119.031, 35.44318], [-119.03103, 35.44277], [-119.03106, 35.44272], [-119.03106, 35.44265], [-119.03103, 35.4426], [-119.03096, 35.44256], [-119.03092, 35.4423], [-119.03325, 35.4423]]]} Open Access 1 13234 North Highland Park 22822 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 14.884 North Highland Park 0 Local Park 2 4
1633 1633 1632 {"type": "MultiPolygon", "coordinates": [[[[-118.34266, 35.15005], [-118.34249, 35.15361], [-118.33695, 35.15354], [-118.33372, 35.15351], [-118.33378, 35.14973], [-118.33373, 35.14974], [-118.3249, 35.14975], [-118.32482, 35.14239], [-118.34265, 35.14248], [-118.34284, 35.14648], [-118.34266, 35.15005]]], [[[-118.34316, 35.13936], [-118.33398, 35.13904], [-118.33392, 35.13169], [-118.343, 35.13192], [-118.34316, 35.13936]]]]} Open Access 1 12446 Tomo-Kahni State Historic Park 1771 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/?page_id=610 Kern 36 579.352 Tomo-Kahni SHP 1993 State Historic or Cultural Area 132 4
1638 1638 1637 {"type": "Polygon", "coordinates": [[[-119.43775, 35.1571], [-119.43547, 35.15711], [-119.43547, 35.15585], [-119.43514, 35.15584], [-119.43497, 35.15576], [-119.43496, 35.15468], [-119.43774, 35.15467], [-119.43775, 35.1571]]]} Open Access 1 14097 Westside Cemetery 27421 303 Kern, County of 399 County 3 County Agency 3 http://www.co.kern.ca.us/parks/ County 3 303 Kern, County of 393 County 3 County Agency 3   Kern 36 15.293 Westside Cemetery 0 Local Historic or Cultural Area 19 4
1746 1746 1745 {"type": "Polygon", "coordinates": [[[-119.2751, 35.50217], [-119.2748, 35.50242], [-119.27445, 35.50212], [-119.27474, 35.50188], [-119.2751, 35.50217]]]} Open Access 1 48487 Town Square Park 33197 1668 Shafter, City of 418 City 2 City Agency 2 http://www.shafter.com/73/Parks City 2 1668 Shafter, City of 412 City 2 City Agency 2 https://www.shafter.com/73/Parks Kern 36 0.43 Town Square Park 0 Local Park 2 4
1766 1766 1765 {"type": "Polygon", "coordinates": [[[-119.10684, 35.36219], [-119.1064, 35.36249], [-119.10628, 35.36247], [-119.1062, 35.36252], [-119.10617, 35.36259], [-119.10618, 35.36266], [-119.10622, 35.36272], [-119.10623, 35.36359], [-119.10405, 35.36358], [-119.10402, 35.36351], [-119.10397, 35.36345], [-119.10389, 35.36343], [-119.1038, 35.36345], [-119.10374, 35.36351], [-119.10352, 35.36355], [-119.10352, 35.36371], [-119.10311, 35.36371], [-119.10311, 35.36282], [-119.10313, 35.36265], [-119.10311, 35.36259], [-119.10302, 35.36248], [-119.10389, 35.36248], [-119.10389, 35.36255], [-119.10563, 35.36255], [-119.10564, 35.36218], [-119.10684, 35.36219]]]} Open Access 1 13184 Mondavi Park 22368 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 8.983 Mondavi Park 0 Local Park 2 4
1792 1792 1791 {"type": "Polygon", "coordinates": [[[-119.02987, 35.40131], [-119.02821, 35.40131], [-119.02822, 35.40213], [-119.02791, 35.4021], [-119.02791, 35.40263], [-119.0276, 35.40263], [-119.02758, 35.40338], [-119.02754, 35.40312], [-119.02753, 35.40284], [-119.02712, 35.40285], [-119.02711, 35.40337], [-119.02688, 35.40337], [-119.02688, 35.40299], [-119.02672, 35.40298], [-119.02672, 35.40131], [-119.02623, 35.4013], [-119.02651, 35.40111], [-119.02658, 35.40101], [-119.02666, 35.40086], [-119.02669, 35.40048], [-119.02662, 35.39998], [-119.0267, 35.39991], [-119.02983, 35.39908], [-119.02987, 35.40131]]]} Open Access 1 13492 Riverview Park 24467 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 19.963 Riverview 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
1839 1839 1838 {"type": "Polygon", "coordinates": [[[-118.46441, 35.13789], [-118.4644, 35.13906], [-118.46227, 35.13906], [-118.46228, 35.13789], [-118.46441, 35.13789]]]} Open Access 1 14074 Tehachapi West Side Cemetery 26219 303 Kern, County of 399 County 3 County Agency 3 http://www.co.kern.ca.us/parks/ County 3 303 Kern, County of 393 County 3 County Agency 3   Kern 36 6.23 Tehachapi West Side Cemetery 0 Local Historic or Cultural Area 19 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
1862 1862 1861 {"type": "Polygon", "coordinates": [[[-119.28173, 35.49267], [-119.2817, 35.49523], [-119.28068, 35.49522], [-119.28072, 35.49266], [-119.28173, 35.49267]]]} Open Access 1 14207 Rodriguez Park 24555 2149 Shafter Recreation and Park District 436 Special District 4 Recreation/Parks District 4 http://shafterrecreation.com/ Special District 4 2149 Shafter Recreation and Park District 430 Special District 4 Recreation/Parks District 4   Kern 36 6.455 Rodriguez Park 0 Local Park 2 4
1872 1872 1871 {"type": "Polygon", "coordinates": [[[-119.24538, 35.78849], [-119.24484, 35.7886], [-119.24426, 35.78859], [-119.24423, 35.78721], [-119.24536, 35.78719], [-119.24538, 35.78849]]]} Open Access 1 16021 Kalibo Park 20545 1084 Delano, City of 442 City 2 City Agency 2 http://www.cityofdelano.org/index.aspx?NID=90 City 2 1084 Delano, City of 436 City 2 City Agency 2   Kern 36 3.803 Kalibo Park 0 Local Park 2 4
1898 1898 1897 {"type": "Polygon", "coordinates": [[[-118.82903, 35.21447], [-118.82877, 35.21447], [-118.82876, 35.21446], [-118.82777, 35.21446], [-118.82774, 35.21281], [-118.82875, 35.2128], [-118.82875, 35.21304], [-118.82894, 35.21327], [-118.82902, 35.21345], [-118.82903, 35.21447]]]} Open Access 1 14599 Kovacevich Park 20721 1011 Arvin, City of 452 City 2 City Agency 2 http://www.arvin.org/parks.html City 2 1011 Arvin, City of 446 City 2 City Agency 2   Kern 36 4.957 Kovacevich Park 0 Local Park 2 4
1932 1932 1931 {"type": "Polygon", "coordinates": [[[-118.22001, 35.69046], [-118.21999, 35.69219], [-118.21919, 35.69218], [-118.21924, 35.69048], [-118.22001, 35.69046]]]} Open Access 1 16545 Scodie Park 25200 303 Kern, County of 399 County 3 County Agency 3 http://www.co.kern.ca.us/parks/ County 3 303 Kern, County of 393 County 3 County Agency 3   Kern 36 3.31 Scodie Park 0 Local Park 2 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);