units_with_maps

Table actions

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

10 rows where ACCESS_TYP = 1, COUNTY = 36 and DES_TP = 3

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 10 ✖
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
3562 3562 3561 {"type": "Polygon", "coordinates": [[[-119.25831, 35.7417], [-119.2583, 35.74291], [-119.25009, 35.74289], [-119.24959, 35.74256], [-119.24962, 35.74173], [-119.25831, 35.7417]]]} Open Access 1 28352 Soccer Park 25588 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 25.252 Soccer Park 0 Local Recreation Area 3 4
4346 4346 4345 {"type": "Polygon", "coordinates": [[[-119.27012, 35.49626], [-119.27011, 35.49689], [-119.26949, 35.49688], [-119.26949, 35.49626], [-119.27012, 35.49626]]]} Open Access 1 48440 Skate Park 33145 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 0.977 Skate Park 2001 Local Recreation Area 3 4
9185 9185 9184 {"type": "MultiPolygon", "coordinates": [[[[-119.44742, 35.15369], [-119.44736, 35.1537], [-119.44736, 35.15446], [-119.44283, 35.15448], [-119.43856, 35.15446], [-119.43858, 35.15264], [-119.43862, 35.15144], [-119.44741, 35.15143], [-119.44742, 35.15369]]], [[[-119.44785, 35.15654], [-119.44345, 35.15653], [-119.44343, 35.15646], [-119.44238, 35.15646], [-119.44237, 35.15533], [-119.43971, 35.15532], [-119.43971, 35.15463], [-119.44343, 35.15465], [-119.44743, 35.15465], [-119.44743, 35.15505], [-119.44756, 35.15505], [-119.44757, 35.15546], [-119.44763, 35.15584], [-119.44772, 35.1562], [-119.44785, 35.15654]]]]} Open Access 1 15249 Franklin Field 19058 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 95.954 Franklin Field 0 Local Recreation Area 3 4
9203 9203 9202 {"type": "Polygon", "coordinates": [[[-119.46792, 35.14555], [-119.46787, 35.14565], [-119.46753, 35.1456], [-119.46697, 35.14543], [-119.46709, 35.14517], [-119.46637, 35.14446], [-119.46546, 35.14447], [-119.46546, 35.14411], [-119.4675, 35.14408], [-119.46791, 35.1441], [-119.46789, 35.14418], [-119.46792, 35.14555]]]} Open Access 1 15283 Taft Community Center and Skate Park 26163 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 5.19 Taft Community Ctr. and Skate Park 0 Local Recreation Area 3 4
9614 9614 9613 {"type": "Polygon", "coordinates": [[[-117.69009, 35.62124], [-117.68804, 35.62125], [-117.68804, 35.61959], [-117.69009, 35.6196], [-117.69009, 35.62124]]]} Open Access 1 16183 Kerr McGee Baseball Fields 20634 1275 Ridgecrest, City of 761 City 2 City Agency 2 http://ridgecrest-ca.gov/recreation City 2 1275 Ridgecrest, City of 744 City 2 City Agency 2   Kern 36 8.417 Kerr McGee Baseball Fields 0 Local Recreation Area 3 4
9685 9685 9684 {"type": "MultiPolygon", "coordinates": [[[[-119.30563, 35.2353], [-119.30545, 35.23513], [-119.30517, 35.23486], [-119.3056, 35.23496], [-119.30563, 35.2353]]], [[[-119.3058, 35.23952], [-119.30548, 35.23941], [-119.30568, 35.23894], [-119.30579, 35.23899], [-119.3058, 35.23952]]], [[[-119.30565, 35.23862], [-119.30561, 35.23877], [-119.30536, 35.23934], [-119.30517, 35.23932], [-119.30488, 35.23973], [-119.30337, 35.24084], [-119.30262, 35.24121], [-119.30201, 35.2405], [-119.3035, 35.2389], [-119.30306, 35.23859], [-119.30383, 35.23859], [-119.3029, 35.23803], [-119.30249, 35.23804], [-119.30177, 35.23774], [-119.30056, 35.2374], [-119.28883, 35.23473], [-119.28882, 35.23474], [-119.2889, 35.23849], [-119.28635, 35.23847], [-119.28635, 35.23529], [-119.28021, 35.23526], [-119.27987, 35.23525], [-119.2792, 35.23519], [-119.27852, 35.2351], [-119.27819, 35.23503], [-119.2777, 35.23492], [-119.27722, 35.23479], [-119.27629, 35.23446], [-119.27199, 35.2325], [-119.27135, 35.23225], [-119.27025, 35.23194], [-119.26938, 35.2318], [-119.26879, 35.23174], [-119.26835, 35.23173], [-119.26019, 35.23176], [-119.25927, 35.23169], [-119.25813, 35.23154], [-119.257, 35.2313], [-119.25592, 35.23098], [-119.25528, 35.23076], [-119.25486, 35.23059], [-119.25388, 35.23015], [-119.2537, 35.23003], [-119.2535, 35.22995], [-119.25269, 35.22947], [-119.25204, 35.22903], [-119.25138, 35.2285], [-119.25061, 35.22779], [-119.2495, 35.22664], [-119.23717, 35.23667], [-119.23704, 35.23659], [-119.23632, 35.2372], [-119.23611, 35.23751], [-119.23597, 35.23791], [-119.23597, 35.23797], [-119.23549, 35.23797], [-119.23557, 35.23767], [-119.23566, 35.23745], [-119.23581, 35.23719], [-119.23595, 35.23701], [-119.23616, 35.23679], [-119.23674, 35.23633], [-119.23669, 35.23625], [-119.24905, 35.22618], [-119.24654, 35.22363], [-119.23598, 35.21269], [-119.23589, 35.20903], [-119.23857, 35.20905], [-119.2527, 35.21503], [-119.27023, 35.22232], [-119.27027, 35.22295], [-119.27246, 35.22385], [-119.28807, 35.23043], [-119.28888, 35.23064], [-119.28925, 35.23044], [-119.28946, 35.23015], [-119.28949, 35.22964], [-119.28958, 35.22945], [-119.28968, 35.22936], [-119.28988, 35.22932], [-119.29037, 35.22933], [-119.29072, 35.22943], [-119.30292, 35.23352], [-119.30535, 35.23718], [-119.30536, 35.23732], [-119.30536, 35.23752], [-119.30533, 35.23775], [-119.30526, 35.23804], [-119.30512, 35.23836], [-119.30498, 35.23858], [-119.30538, 35.23862], [-119.30565, 35.23862]]]]} Open Access 1 16326 Buena Vista Aquatic Recreation Area 4788 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 http://www.co.kern.ca.us/parks/buena-vista.asp Kern 36 1578.796 Buena Vista Aquatic Rec. Area 0 Local Recreation Area 3 4
12167 12167 12166 {"type": "Polygon", "coordinates": [[[-119.10975, 35.37746], [-119.10975, 35.37803], [-119.10971, 35.37821], [-119.10971, 35.37828], [-119.10974, 35.37835], [-119.10974, 35.37846], [-119.10684, 35.37845], [-119.10682, 35.37976], [-119.10631, 35.37976], [-119.10632, 35.37746], [-119.10975, 35.37746]]]} Open Access 1 25360 Greenacres Community Center 19470 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 10.147 Greenacres Community Ctr. 0 Local Recreation Area 3 4
12574 12574 12573 {"type": "Polygon", "coordinates": [[[-119.33565, 35.61001], [-119.33563, 35.61241], [-119.33394, 35.61241], [-119.33397, 35.60885], [-119.33445, 35.60886], [-119.33445, 35.61], [-119.33565, 35.61001]]]} Open Access 1 29318 Annin Ave Soccer Fields 15505 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 11.506 Annin Ave Soccer Fields 0 Local Recreation Area 3 4
14414 14414 14413 {"type": "Polygon", "coordinates": [[[-119.01983, 35.40852], [-119.01888, 35.40852], [-119.01887, 35.40797], [-119.01983, 35.40797], [-119.01983, 35.40852]]]} Open Access 1 44536 Rasmussen Center 24188 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 1.31 Rasmussen Ctr. 0 Local Recreation Area 3 4
16925 16925 16924 {"type": "Polygon", "coordinates": [[[-119.02667, 35.39563], [-119.02663, 35.3959], [-119.02664, 35.39629], [-119.02662, 35.39646], [-119.02651, 35.39681], [-119.02638, 35.39701], [-119.02618, 35.39724], [-119.02598, 35.3974], [-119.02582, 35.39749], [-119.02557, 35.39761], [-119.02484, 35.39761], [-119.02316, 35.39817], [-119.02118, 35.39851], [-119.02117, 35.39894], [-119.01888, 35.39893], [-119.01891, 35.39267], [-119.01979, 35.39267], [-119.01979, 35.39195], [-119.02098, 35.39198], [-119.02096, 35.3976], [-119.02119, 35.39758], [-119.02118, 35.39217], [-119.02214, 35.39216], [-119.02667, 35.39563]]]} Open Access 1 16493 Metropolitan Recreation Center 22188 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 93.734 Metropolitan Rec. Ctr. 0 Local Recreation Area 3 4

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