units_with_maps

Table actions

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

1 row where AGNCY_TYP = 9, DES_TP = 79 and MNG_AG_TYP = 8

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency - Other · 1 ✖

DES_TP 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
862 862 861 {"type": "MultiPolygon", "coordinates": [[[[-122.44333, 37.73556], [-122.44313, 37.73558], [-122.44241, 37.73578], [-122.44241, 37.73539], [-122.44331, 37.73537], [-122.44333, 37.73556]]], [[[-122.44368, 37.73938], [-122.44259, 37.73944], [-122.44255, 37.73931], [-122.44256, 37.73921], [-122.44259, 37.73912], [-122.44267, 37.73868], [-122.44269, 37.73845], [-122.44264, 37.73816], [-122.44246, 37.73767], [-122.44246, 37.73757], [-122.44249, 37.73744], [-122.44257, 37.73728], [-122.44269, 37.73716], [-122.44346, 37.73669], [-122.44358, 37.7381], [-122.44349, 37.73818], [-122.44344, 37.73829], [-122.44338, 37.73885], [-122.44341, 37.73894], [-122.44347, 37.73903], [-122.44356, 37.73911], [-122.44367, 37.73917], [-122.44368, 37.73938]]], [[[-122.44373, 37.73995], [-122.44352, 37.73987], [-122.44296, 37.73975], [-122.44281, 37.73967], [-122.44271, 37.7396], [-122.4437, 37.73954], [-122.44373, 37.73995]]], [[[-122.44456, 37.74017], [-122.44413, 37.74021], [-122.44402, 37.74012], [-122.44397, 37.7396], [-122.44443, 37.73996], [-122.44456, 37.74017]]], [[[-122.44606, 37.74084], [-122.44535, 37.74089], [-122.44491, 37.74082], [-122.44474, 37.74076], [-122.44454, 37.74065], [-122.44437, 37.7405], [-122.44425, 37.74033], [-122.44464, 37.7403], [-122.4448, 37.74057], [-122.4449, 37.74061], [-122.44511, 37.74067], [-122.44576, 37.74076], [-122.44606, 37.74084]]], [[[-122.44842, 37.74265], [-122.44711, 37.74253], [-122.44681, 37.74245], [-122.44656, 37.74233], [-122.44641, 37.74222], [-122.4463, 37.74206], [-122.44626, 37.74193], [-122.44622, 37.7415], [-122.44617, 37.74137], [-122.44609, 37.74122], [-122.44609, 37.74118], [-122.4462, 37.74109], [-122.44632, 37.74106], [-122.44643, 37.74117], [-122.44652, 37.74132], [-122.44657, 37.74144], [-122.4466, 37.74158], [-122.44659, 37.74176], [-122.44665, 37.74191], [-122.44677, 37.74209], [-122.44687, 37.74219], [-122.44699, 37.74227], [-122.44714, 37.74234], [-122.4473, 37.74235], [-122.44731, 37.74229], [-122.44768, 37.74232], [-122.44765, 37.7425], [-122.44842, 37.74257], [-122.44842, 37.74265]]], [[[-122.44946, 37.74283], [-122.44941, 37.7429], [-122.44925, 37.74282], [-122.44905, 37.74275], [-122.44863, 37.74267], [-122.44863, 37.74259], [-122.44905, 37.74267], [-122.44926, 37.74274], [-122.44946, 37.74283]]], [[[-122.45165, 37.74524], [-122.45158, 37.74527], [-122.45152, 37.74525], [-122.45075, 37.74432], [-122.45075, 37.74419], [-122.45081, 37.74427], [-122.45083, 37.74426], [-122.45083, 37.74424], [-122.45093, 37.74441], [-122.45165, 37.74524]]]]} Open Access 1 5544 Reservoir Lands (Glen Park) 24301 321 San Francisco - Public Utilities Commission, City and County of 31 County 3 County Agency - Other 9 http://sfwater.org/ County 3 321 San Francisco - Public Utilities Commission, City and County of 30 County 3 County Agency - Other 8   San Francisco 13 10.112 Reservoir Lands (Glen Park)   None 79  

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]);