units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 4, DES_TP = 14 and MNG_AGENCY = 45

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Santa Barbara Flood Control and Water Conserv. District · 4 ✖

DES_TP 1

  • Local Other or Unknown · 4 ✖

ACCESS_TYP 1

  • Unknown Access · 4 ✖
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
108 108 107 {"type": "Polygon", "coordinates": [[[-119.80165, 34.44381], [-119.80106, 34.44387], [-119.79957, 34.44402], [-119.79959, 34.44377], [-119.80161, 34.44357], [-119.80165, 34.44381]]]} Unknown Access 4 295 San Antonio Creek 24829 2141 Santa Barbara Flood Control and Water Conserv. District 46 Special District 4 Flood District 8 http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 Special District 4 2141 Santa Barbara Flood Control and Water Conserv. District 45 Special District 4 Flood District 9   Santa Barbara 7 1.291 San Antonio Creek 0 Local Other or Unknown 14 4
4872 4872 4871 {"type": "Polygon", "coordinates": [[[-119.72189, 34.42619], [-119.72175, 34.42632], [-119.72033, 34.42628], [-119.72017, 34.42625], [-119.72001, 34.4262], [-119.71978, 34.42606], [-119.71997, 34.42593], [-119.72024, 34.42605], [-119.72189, 34.42619]]]} Unknown Access 4 14721 El Mission Creek 18515 2141 Santa Barbara Flood Control and Water Conserv. District 46 Special District 4 Flood District 8 http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 Special District 4 2141 Santa Barbara Flood Control and Water Conserv. District 45 Special District 4 Flood District 9   Santa Barbara 7 0.939 El Mission Creek 0 Local Other or Unknown 14 4
6625 6625 6624 {"type": "Polygon", "coordinates": [[[-119.50841, 34.395], [-119.5075, 34.3955], [-119.50689, 34.39577], [-119.50682, 34.39566], [-119.50722, 34.39559], [-119.50754, 34.39538], [-119.50776, 34.39528], [-119.50804, 34.39502], [-119.50825, 34.39477], [-119.50841, 34.395]]]} Unknown Access 4 4393 Carpinteria Creek 16898 2141 Santa Barbara Flood Control and Water Conserv. District 46 Special District 4 Flood District 8 http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 Special District 4 2141 Santa Barbara Flood Control and Water Conserv. District 45 Special District 4 Flood District 9   Santa Barbara 7 0.458 Carpinteria Creek 0 Local Other or Unknown 14 4
10130 10130 10129 {"type": "MultiPolygon", "coordinates": [[[[-119.79298, 34.45997], [-119.79252, 34.45991], [-119.7921, 34.46012], [-119.79188, 34.4602], [-119.7916, 34.46027], [-119.79158, 34.46041], [-119.79162, 34.46056], [-119.79145, 34.46063], [-119.79126, 34.46065], [-119.79126, 34.4609], [-119.79072, 34.4611], [-119.7886, 34.46125], [-119.78792, 34.46073], [-119.78791, 34.46056], [-119.79093, 34.45917], [-119.79247, 34.45875], [-119.79289, 34.45965], [-119.79298, 34.45997]]], [[[-119.80355, 34.44549], [-119.80304, 34.44557], [-119.80256, 34.44575], [-119.80212, 34.44575], [-119.80227, 34.44563], [-119.80246, 34.44553], [-119.80285, 34.4454], [-119.80309, 34.44528], [-119.80312, 34.44528], [-119.80355, 34.44549]]], [[[-119.8054, 34.44317], [-119.80527, 34.44343], [-119.80481, 34.44368], [-119.80461, 34.44386], [-119.80474, 34.44426], [-119.80438, 34.44456], [-119.8039, 34.44475], [-119.80365, 34.44499], [-119.80358, 34.44532], [-119.80331, 34.44519], [-119.80329, 34.44516], [-119.8033, 34.44512], [-119.80453, 34.44362], [-119.80464, 34.44344], [-119.80471, 34.44324], [-119.8054, 34.44317]]]]} Unknown Access 4 17605 Maria Ygnacia Creek 21811 2141 Santa Barbara Flood Control and Water Conserv. District 46 Special District 4 Flood District 8 http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 Special District 4 2141 Santa Barbara Flood Control and Water Conserv. District 45 Special District 4 Flood District 9   Santa Barbara 7 19.072 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]);