units_with_maps

Table actions

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

1 row where LABEL_NAME = "Maria Ygnacia Creek", MNG_AGENCY = 7 and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency · 1 ✖

MNG_AGENCY 1

  • Santa Barbara, County of · 1 ✖

ACCESS_TYP 1

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
10124 10124 10123 {"type": "MultiPolygon", "coordinates": [[[[-119.80818, 34.42783], [-119.80793, 34.42827], [-119.80768, 34.42863], [-119.80753, 34.42918], [-119.80753, 34.42957], [-119.80738, 34.43021], [-119.80738, 34.43068], [-119.80766, 34.43127], [-119.80766, 34.43204], [-119.80759, 34.43228], [-119.80758, 34.43254], [-119.80761, 34.43273], [-119.80782, 34.43341], [-119.80783, 34.43357], [-119.80781, 34.43369], [-119.80775, 34.43386], [-119.80769, 34.43396], [-119.80749, 34.43418], [-119.80694, 34.43476], [-119.80655, 34.43475], [-119.80662, 34.43457], [-119.80671, 34.43458], [-119.80679, 34.43454], [-119.80682, 34.43449], [-119.80683, 34.43443], [-119.8069, 34.43442], [-119.80717, 34.43408], [-119.80713, 34.4338], [-119.80705, 34.43375], [-119.80706, 34.43369], [-119.80705, 34.43363], [-119.80714, 34.43359], [-119.80722, 34.43323], [-119.80737, 34.43319], [-119.80729, 34.43293], [-119.80721, 34.43289], [-119.80724, 34.4328], [-119.80719, 34.43256], [-119.80717, 34.43226], [-119.80724, 34.43176], [-119.80724, 34.43145], [-119.80722, 34.43129], [-119.80709, 34.4308], [-119.80705, 34.43058], [-119.80703, 34.43036], [-119.80703, 34.43014], [-119.80712, 34.42909], [-119.8072, 34.42878], [-119.80735, 34.42839], [-119.80738, 34.42824], [-119.80739, 34.42809], [-119.80737, 34.42787], [-119.80818, 34.42783]]], [[[-119.80555, 34.44363], [-119.80546, 34.44368], [-119.80534, 34.44379], [-119.80523, 34.44397], [-119.80497, 34.44513], [-119.80464, 34.4451], [-119.80449, 34.44531], [-119.80419, 34.44525], [-119.80402, 34.4453], [-119.80393, 34.44547], [-119.80358, 34.44532], [-119.80365, 34.44499], [-119.8039, 34.44475], [-119.80438, 34.44456], [-119.80474, 34.44427], [-119.8046, 34.44386], [-119.80481, 34.44368], [-119.80527, 34.44343], [-119.80532, 34.44334], [-119.80551, 34.44332], [-119.80555, 34.44363]]], [[[-119.80378, 34.44592], [-119.80366, 34.4463], [-119.80325, 34.44624], [-119.80324, 34.44625], [-119.80335, 34.44727], [-119.80368, 34.44726], [-119.80373, 34.44775], [-119.80371, 34.44782], [-119.80365, 34.44786], [-119.80355, 34.44789], [-119.80349, 34.44795], [-119.80328, 34.4479], [-119.80257, 34.44813], [-119.80238, 34.44837], [-119.80211, 34.44842], [-119.80196, 34.44856], [-119.80178, 34.44857], [-119.80166, 34.44894], [-119.80137, 34.44905], [-119.8013, 34.44915], [-119.80126, 34.44928], [-119.80139, 34.44946], [-119.80159, 34.44962], [-119.80128, 34.44962], [-119.80088, 34.44918], [-119.80098, 34.44907], [-119.8012, 34.44877], [-119.80138, 34.44859], [-119.80223, 34.44801], [-119.8023, 34.44795], [-119.80235, 34.44786], [-119.80262, 34.44773], [-119.80269, 34.44762], [-119.80241, 34.44694], [-119.8021, 34.44669], [-119.80182, 34.4467], [-119.80174, 34.44684], [-119.80123, 34.44716], [-119.80119, 34.44729], [-119.80113, 34.44766], [-119.80087, 34.44796], [-119.80047, 34.44833], [-119.80041, 34.44828], [-119.80029, 34.44828], [-119.80051, 34.44786], [-119.80059, 34.44762], [-119.80067, 34.44731], [-119.80079, 34.44707], [-119.80091, 34.44694], [-119.8015, 34.44645], [-119.80169, 34.44626], [-119.80199, 34.44589], [-119.80212, 34.44575], [-119.80256, 34.44575], [-119.80304, 34.44557], [-119.80355, 34.44549], [-119.80368, 34.44556], [-119.80351, 34.44585], [-119.80378, 34.44592]]], [[[-119.7952, 34.45576], [-119.79519, 34.45606], [-119.79483, 34.45606], [-119.79478, 34.45662], [-119.79471, 34.45677], [-119.79433, 34.45736], [-119.79434, 34.45737], [-119.79472, 34.45738], [-119.79463, 34.45757], [-119.79373, 34.45755], [-119.7937, 34.45659], [-119.79444, 34.45608], [-119.79437, 34.45575], [-119.7952, 34.45576]]], [[[-119.79526, 34.4592], [-119.79501, 34.45939], [-119.79428, 34.45963], [-119.79402, 34.45956], [-119.79374, 34.45963], [-119.79341, 34.45957], [-119.79319, 34.45991], [-119.79298, 34.45997], [-119.79289, 34.45965], [-119.79349, 34.45947], [-119.79401, 34.45938], [-119.79428, 34.45928], [-119.79438, 34.45922], [-119.79483, 34.45924], [-119.79525, 34.45902], [-119.79526, 34.4592]]]]} Unknown Access 4 17594 Maria Ygnacia Creek 21810 325 Santa Barbara, County of 7 County 3 County Agency 3 http://cosb.countyofsb.org/parks/ County 3 325 Santa Barbara, County of 7 County 3 County Agency 3   Santa Barbara 7 28.798 Maria Ygnacia Creek 0 Local Other or Unknown 14 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]);