units_with_maps

Table actions

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

11 rows where DES_TP = 14, GAP_STS = 4 and MNG_AGENCY = 26

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Santa Barbara, City of · 11 ✖

DES_TP 1

  • Local Other or Unknown · 11 ✖
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
364 364 363 {"type": "Polygon", "coordinates": [[[-119.67342, 34.42333], [-119.67318, 34.42356], [-119.67274, 34.42324], [-119.67299, 34.42301], [-119.67342, 34.42333]]]} Unknown Access 4 1276 Sycamore Creek 26121 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 0.446 Sycamore Creek 0 Local Other or Unknown 14 4
1412 1412 1411 {"type": "Polygon", "coordinates": [[[-119.67034, 34.43903], [-119.67034, 34.4395], [-119.66917, 34.4395], [-119.66941, 34.43903], [-119.67034, 34.43903]]]} Unknown Access 4 36486 Santa Barbara holding 9 25051 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 1.234 Santa Barbara holding 9 0 Local Other or Unknown 14 4
4946 4946 4945 {"type": "Polygon", "coordinates": [[[-119.7272, 34.4336], [-119.72698, 34.43445], [-119.72664, 34.43545], [-119.72639, 34.43526], [-119.72657, 34.43483], [-119.72679, 34.43462], [-119.72695, 34.43445], [-119.72702, 34.43416], [-119.72681, 34.43413], [-119.72683, 34.43397], [-119.72706, 34.43399], [-119.72716, 34.43359], [-119.7272, 34.4336]]]} Unknown Access 4 14659 El Mission Creek 18514 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 0.719 El Mission Creek 0 Local Other or Unknown 14 4
12995 12995 12994 {"type": "Polygon", "coordinates": [[[-119.69167, 34.45419], [-119.69138, 34.45435], [-119.691, 34.45433], [-119.69056, 34.45403], [-119.69059, 34.45371], [-119.69063, 34.45361], [-119.69071, 34.45352], [-119.69083, 34.45346], [-119.6913, 34.45343], [-119.69167, 34.45419]]]} Unknown Access 4 35356 Santa Barbara holding 1 25042 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 1.835 Santa Barbara holding 1 0 Local Other or Unknown 14 4
13274 13274 13273 {"type": "Polygon", "coordinates": [[[-119.69412, 34.43749], [-119.69405, 34.43786], [-119.69394, 34.43819], [-119.6938, 34.43814], [-119.69358, 34.43802], [-119.69348, 34.43794], [-119.69344, 34.43785], [-119.69344, 34.43781], [-119.69346, 34.43774], [-119.69351, 34.43769], [-119.69393, 34.43752], [-119.69402, 34.43753], [-119.69412, 34.43749]]]} Open Access 1 35327 Santa Barbara holding 4 25046 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 0.736 Santa Barbara holding 4 0 Local Other or Unknown 14 4
13328 13328 13327 {"type": "Polygon", "coordinates": [[[-119.7227, 34.41018], [-119.72259, 34.41048], [-119.72256, 34.4105], [-119.72219, 34.41042], [-119.72232, 34.41009], [-119.7227, 34.41018]]]} Unknown Access 4 35396 Santa Barbara holding 2 25044 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 0.342 Santa Barbara holding 2 0 Local Other or Unknown 14 4
13330 13330 13329 {"type": "Polygon", "coordinates": [[[-119.70057, 34.42254], [-119.70013, 34.42294], [-119.6997, 34.42262], [-119.69979, 34.42251], [-119.69992, 34.4226], [-119.70003, 34.4225], [-119.70007, 34.42252], [-119.70029, 34.42233], [-119.70057, 34.42254]]]} Open Access 1 35400 Santa Barbara holding 3 25045 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 0.614 Santa Barbara holding 3 0 Local Other or Unknown 14 4
13943 13943 13942 {"type": "Polygon", "coordinates": [[[-119.67454, 34.43385], [-119.6741, 34.43428], [-119.67275, 34.43326], [-119.67318, 34.43286], [-119.67454, 34.43385]]]} Unknown Access 4 36569 Santa Barbara holding 8 25050 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 2.52 Santa Barbara holding 8 0 Local Other or Unknown 14 4
13944 13944 13943 {"type": "Polygon", "coordinates": [[[-119.7227, 34.41018], [-119.72251, 34.41013], [-119.72261, 34.40986], [-119.72277, 34.4099], [-119.7228, 34.40994], [-119.7227, 34.41018]]]} Unknown Access 4 36570 Santa Barbara holding 5 25047 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 0.148 Santa Barbara holding 5 0 Local Other or Unknown 14 4
13945 13945 13944 {"type": "Polygon", "coordinates": [[[-119.72232, 34.41009], [-119.72219, 34.41042], [-119.722, 34.41037], [-119.72213, 34.41004], [-119.72232, 34.41009]]]} Unknown Access 4 36575 Santa Barbara holding 7 25049 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 0.176 Santa Barbara holding 7 0 Local Other or Unknown 14 4
13946 13946 13945 {"type": "Polygon", "coordinates": [[[-119.72261, 34.40986], [-119.72251, 34.41013], [-119.72213, 34.41004], [-119.72223, 34.40976], [-119.72261, 34.40986]]]} Unknown Access 4 36576 Santa Barbara holding 6 25048 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 0.289 Santa Barbara holding 6 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]);