units_with_maps

Table actions

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

3 rows where AGNCY_NAME = 399, DES_TP = 3 and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • County Agency · 3 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Recreation Area · 3 ✖
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
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
15718 15718 15717 {"type": "Polygon", "coordinates": [[[-118.86048, 35.43724], [-118.86016, 35.4381], [-118.86002, 35.43895], [-118.85983, 35.4394], [-118.8594, 35.44002], [-118.85729, 35.4433], [-118.85404, 35.44375], [-118.85191, 35.44323], [-118.85136, 35.44191], [-118.85208, 35.44189], [-118.85209, 35.44188], [-118.85187, 35.44165], [-118.85179, 35.44152], [-118.8517, 35.44143], [-118.85151, 35.44114], [-118.85136, 35.4408], [-118.85127, 35.44037], [-118.85124, 35.4397], [-118.85125, 35.43952], [-118.85142, 35.43847], [-118.85168, 35.4376], [-118.85179, 35.43699], [-118.85188, 35.43672], [-118.85194, 35.43629], [-118.85201, 35.43606], [-118.85205, 35.43585], [-118.85218, 35.43553], [-118.85249, 35.43501], [-118.85257, 35.43462], [-118.85274, 35.43427], [-118.85284, 35.43411], [-118.85288, 35.4338], [-118.85293, 35.43364], [-118.85293, 35.4334], [-118.853, 35.43324], [-118.85845, 35.4332], [-118.85874, 35.43316], [-118.85964, 35.43288], [-118.86022, 35.43526], [-118.86031, 35.43629], [-118.86048, 35.43724]]]} Restricted Access 2 44512 Kern River Golf Course 33105 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 196.033 Kern River GC 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]);