units_with_maps

Table actions

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

167 rows where ACCESS_TYP = 1, COUNTY = 36 and DES_TP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 167 ✖
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
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
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
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
1980 1980 1979 {"type": "Polygon", "coordinates": [[[-119.34363, 35.59497], [-119.34362, 35.59606], [-119.34157, 35.59606], [-119.34158, 35.59496], [-119.34363, 35.59497]]]} Open Access 1 15152 Cormack Park 17638 2175 Wasco Recreation and Park District 465 Special District 4 Recreation/Parks District 4 http://www.wascoparks.com/ Special District 4 2175 Wasco Recreation and Park District 458 Special District 4 Recreation/Parks District 4   Kern 36 5.609 Cormack Park 0 Local Park 2 4
2002 2002 2001 {"type": "MultiPolygon", "coordinates": [[[[-119.21208, 34.85022], [-119.21204, 34.855], [-119.21179, 34.8556], [-119.21179, 34.85575], [-119.21177, 34.85589], [-119.21178, 34.85606], [-119.21176, 34.85645], [-119.21168, 34.85661], [-119.21156, 34.8568], [-119.21132, 34.85712], [-119.21077, 34.85763], [-119.208, 34.85771], [-119.20798, 34.85387], [-119.20347, 34.85379], [-119.20325, 34.8428], [-119.20756, 34.84279], [-119.20798, 34.85028], [-119.21208, 34.85022]]], [[[-119.21201, 34.8565], [-119.21199, 34.8576], [-119.21114, 34.85762], [-119.21153, 34.85726], [-119.21168, 34.85707], [-119.21192, 34.85669], [-119.21201, 34.8565]]]]} Open Access 1 15343 Westside Mountain Park 27422 2178 West Side Recreation and Park District 467 Special District 4 Recreation/Parks District 4 http://www.wsrpd.com/ Special District 4 2178 West Side Recreation and Park District 460 Special District 4 Recreation/Parks District 4   Kern 36 197.583 Westside Mtn. 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
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

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