units_with_maps

Table actions

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

4 rows where AGNCY_NAME = 104, DES_TP = 14 and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • County Agency · 4 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Other or Unknown · 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
7421 7421 7420 {"type": "MultiPolygon", "coordinates": [[[[-117.03935, 32.56205], [-117.03896, 32.56244], [-117.03867, 32.56267], [-117.0382, 32.563], [-117.03798, 32.56312], [-117.03799, 32.56315], [-117.03687, 32.56394], [-117.03653, 32.56411], [-117.03624, 32.56419], [-117.03603, 32.56422], [-117.0356, 32.56422], [-117.03527, 32.56414], [-117.03507, 32.56405], [-117.03489, 32.56394], [-117.03478, 32.56389], [-117.03462, 32.56384], [-117.03447, 32.56381], [-117.03419, 32.56381], [-117.0341, 32.56383], [-117.03301, 32.56389], [-117.03268, 32.56395], [-117.03246, 32.56402], [-117.03233, 32.56408], [-117.03243, 32.56189], [-117.03219, 32.55451], [-117.03357, 32.55452], [-117.03369, 32.55819], [-117.03658, 32.55822], [-117.03665, 32.56184], [-117.03935, 32.56184], [-117.03935, 32.56205]], [[-117.03532, 32.56185], [-117.03521, 32.56166], [-117.03511, 32.5616], [-117.03493, 32.56161], [-117.03517, 32.56209], [-117.03524, 32.56207], [-117.0353, 32.56197], [-117.03527, 32.56192], [-117.03532, 32.56185]]], [[[-117.03934, 32.56405], [-117.03934, 32.56405], [-117.03714, 32.56405], [-117.0382, 32.56327], [-117.03934, 32.56308], [-117.03934, 32.56405]]], [[[-117.03935, 32.56227], [-117.03935, 32.56266], [-117.03899, 32.56267], [-117.03898, 32.56259], [-117.03935, 32.56227]]]]} No Public Access 3 47593 Furby-North Property 31320 319 San Diego, County of 104 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/ County 3 319 San Diego, County of 101 County 3 County Agency 3   San Diego 4 89.107 Furby-North Property 0 Local Other or Unknown 14 4
13225 13225 13224 {"type": "Polygon", "coordinates": [[[-117.12022, 33.25594], [-117.11798, 33.25608], [-117.11133, 33.25648], [-117.11148, 33.25634], [-117.11161, 33.25629], [-117.11177, 33.25622], [-117.11191, 33.25612], [-117.11201, 33.25602], [-117.11211, 33.256], [-117.11224, 33.25577], [-117.11221, 33.25567], [-117.11279, 33.25455], [-117.11293, 33.25435], [-117.11314, 33.25414], [-117.11321, 33.25417], [-117.11343, 33.25402], [-117.11339, 33.25397], [-117.11357, 33.25388], [-117.11582, 33.25311], [-117.1161, 33.25299], [-117.11637, 33.25284], [-117.12005, 33.2528], [-117.12022, 33.25594]]]} No Public Access 3 45242 Old Castle Mitigation Area 23082 319 San Diego, County of 104 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/ County 3 319 San Diego, County of 101 County 3 County Agency 3   San Diego 4 58.565 Old Castle Mitigation Area 0 Local Other or Unknown 14 4
14553 14553 14552 {"type": "Polygon", "coordinates": [[[-117.142, 33.36266], [-117.14183, 33.36576], [-117.13969, 33.36579], [-117.13986, 33.36259], [-117.142, 33.36266]]]} No Public Access 3 45226 Pala Mesa Mitigation Property 29252 319 San Diego, County of 104 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/ County 3 319 San Diego, County of 101 County 3 County Agency 3   San Diego 4 17.191 Pala Mesa Mitigation Property 0 Local Other or Unknown 14 4
14716 14716 14715 {"type": "Polygon", "coordinates": [[[-116.38556, 32.97589], [-116.38485, 32.97959], [-116.38064, 32.97968], [-116.37621, 32.97986], [-116.37679, 32.97617], [-116.3768, 32.9758], [-116.38134, 32.97552], [-116.38136, 32.97593], [-116.38556, 32.97589]]]} Unknown Access 4 47814 Unnamed site - San Diego, County of 31715 319 San Diego, County of 104 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/ County 3 319 San Diego, County of 101 County 3 County Agency 3   San Diego 4 87.174   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]);