units_with_maps

Table actions

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

10 rows where AGNCY_NAME = 480, DES_TP = 14 and MNG_AGENCY = 472

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Guadalupe, City of · 10 ✖

DES_TP 1

  • Local Other or Unknown · 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
4927 4927 4926 {"type": "Polygon", "coordinates": [[[-120.57718, 34.95846], [-120.57722, 34.95871], [-120.57726, 34.95884], [-120.57749, 34.95931], [-120.57749, 34.95936], [-120.57745, 34.95938], [-120.57717, 34.95939], [-120.57718, 34.95846]]]} Open Access 1 35362 Guadalupe holding 1 19545 1126 Guadalupe, City of 480 City 2 City Agency 2   City 2 1126 Guadalupe, City of 472 City 2 City Agency 2   Santa Barbara 7 0.328 Guadalupe holding 1 0 Local Other or Unknown 14 4
4928 4928 4927 {"type": "Polygon", "coordinates": [[[-120.58052, 34.96254], [-120.58034, 34.96267], [-120.57983, 34.9626], [-120.57981, 34.9625], [-120.58012, 34.96231], [-120.58041, 34.96249], [-120.58052, 34.96254]]]} Open Access 1 35363 Guadalupe holding 2 19547 1126 Guadalupe, City of 480 City 2 City Agency 2   City 2 1126 Guadalupe, City of 472 City 2 City Agency 2   Santa Barbara 7 0.371 Guadalupe holding 2 0 Local Other or Unknown 14 4
5141 5141 5140 {"type": "Polygon", "coordinates": [[[-120.57892, 34.964], [-120.57887, 34.96401], [-120.57829, 34.96412], [-120.57829, 34.964], [-120.57892, 34.964]]]} Open Access 1 35415 Guadalupe holding 6 19551 1126 Guadalupe, City of 480 City 2 City Agency 2   City 2 1126 Guadalupe, City of 472 City 2 City Agency 2   Santa Barbara 7 0.1 Guadalupe holding 6 0 Local Other or Unknown 14 4
13147 13147 13146 {"type": "Polygon", "coordinates": [[[-120.58049, 34.96217], [-120.58041, 34.96249], [-120.58017, 34.96234], [-120.58038, 34.96212], [-120.58049, 34.96217]]]} Open Access 1 35256 Guadalupe holding 7 19552 1126 Guadalupe, City of 480 City 2 City Agency 2   City 2 1126 Guadalupe, City of 472 City 2 City Agency 2   Santa Barbara 7 0.158 Guadalupe holding 7 0 Local Other or Unknown 14 4
13233 13233 13232 {"type": "Polygon", "coordinates": [[[-120.57104, 34.97032], [-120.57096, 34.97044], [-120.57051, 34.97024], [-120.57058, 34.97012], [-120.57104, 34.97032]]]} Open Access 1 35277 Guadalupe holding 10 19546 1126 Guadalupe, City of 480 City 2 City Agency 2   City 2 1126 Guadalupe, City of 472 City 2 City Agency 2   Santa Barbara 7 0.174 Guadalupe holding 10 0 Local Other or Unknown 14 4
13234 13234 13233 {"type": "Polygon", "coordinates": [[[-120.57752, 34.96378], [-120.57752, 34.96399], [-120.57714, 34.96399], [-120.57714, 34.96377], [-120.57752, 34.96378]]]} Unknown Access 4 35278 Guadalupe holding 9 19554 1126 Guadalupe, City of 480 City 2 City Agency 2   City 2 1126 Guadalupe, City of 472 City 2 City Agency 2   Santa Barbara 7 0.206 Guadalupe holding 9 0 Local Other or Unknown 14 4
13237 13237 13236 {"type": "Polygon", "coordinates": [[[-120.57643, 34.96381], [-120.57642, 34.96423], [-120.57588, 34.96423], [-120.57589, 34.96395], [-120.57624, 34.96395], [-120.57625, 34.96381], [-120.57643, 34.96381]]]} Open Access 1 35281 Guadalupe holding 8 19553 1126 Guadalupe, City of 480 City 2 City Agency 2   City 2 1126 Guadalupe, City of 472 City 2 City Agency 2   Santa Barbara 7 0.436 Guadalupe holding 8 0 Local Other or Unknown 14 4
13305 13305 13304 {"type": "Polygon", "coordinates": [[[-120.5712, 34.97007], [-120.57104, 34.97032], [-120.57058, 34.97012], [-120.5709, 34.96963], [-120.57109, 34.96971], [-120.57094, 34.96996], [-120.5712, 34.97007]]]} Open Access 1 35367 Guadalupe holding 3 19548 1126 Guadalupe, City of 480 City 2 City Agency 2   City 2 1126 Guadalupe, City of 472 City 2 City Agency 2   Santa Barbara 7 0.514 Guadalupe holding 3 0 Local Other or Unknown 14 4
13306 13306 13305 {"type": "Polygon", "coordinates": [[[-120.57089, 34.97056], [-120.57073, 34.9708], [-120.57028, 34.97061], [-120.57051, 34.97024], [-120.57088, 34.9704], [-120.57081, 34.97052], [-120.57089, 34.97056]]]} Open Access 1 35368 Guadalupe holding 4 19549 1126 Guadalupe, City of 480 City 2 City Agency 2   City 2 1126 Guadalupe, City of 472 City 2 City Agency 2   Santa Barbara 7 0.5 Guadalupe holding 4 0 Local Other or Unknown 14 4
13339 13339 13338 {"type": "Polygon", "coordinates": [[[-120.58072, 34.9624], [-120.58052, 34.96254], [-120.58041, 34.96249], [-120.58049, 34.96217], [-120.58062, 34.96216], [-120.58072, 34.9624]]]} Open Access 1 35417 Guadalupe holding 5 19550 1126 Guadalupe, City of 480 City 2 City Agency 2   City 2 1126 Guadalupe, City of 472 City 2 City Agency 2   Santa Barbara 7 0.189 Guadalupe holding 5 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]);