units_with_maps

Table actions

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

1 row where COUNTY = 19 and MNG_AGENCY = 30

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Francisco - Public Utilities Commission, City and County of · 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
5918 5918 5917 {"type": "MultiPolygon", "coordinates": [[[[-121.86265, 37.48073], [-121.86083, 37.48075], [-121.8608, 37.48154], [-121.85622, 37.48155], [-121.85526, 37.48196], [-121.85507, 37.48167], [-121.85411, 37.48208], [-121.85389, 37.48184], [-121.85161, 37.48277], [-121.85164, 37.48457], [-121.85097, 37.48456], [-121.85097, 37.4845], [-121.85057, 37.48444], [-121.84627, 37.48444], [-121.83287, 37.48434], [-121.83148, 37.48424], [-121.82337, 37.48423], [-121.80073, 37.48399], [-121.79589, 37.48398], [-121.79079, 37.48417], [-121.77335, 37.48406], [-121.7729, 37.47663], [-121.75463, 37.47663], [-121.75462, 37.47664], [-121.75505, 37.48395], [-121.75466, 37.48392], [-121.75465, 37.48358], [-121.74464, 37.48352], [-121.74457, 37.47948], [-121.73632, 37.47954], [-121.73627, 37.47662], [-121.7317, 37.47662], [-121.7315, 37.46495], [-121.72694, 37.465], [-121.72706, 37.47229], [-121.71793, 37.47239], [-121.71775, 37.46179], [-121.70047, 37.46178], [-121.70055, 37.44705], [-121.7175, 37.44689], [-121.71726, 37.43234], [-121.7355, 37.43217], [-121.73551, 37.4321], [-121.73272, 37.41764], [-121.74183, 37.41755], [-121.74324, 37.42482], [-121.75184, 37.42474], [-121.75239, 37.43204], [-121.7605, 37.43225], [-121.79671, 37.43247], [-121.79669, 37.43103], [-121.79503, 37.43014], [-121.79212, 37.4264], [-121.79438, 37.4263], [-121.80515, 37.43031], [-121.80514, 37.43246], [-121.80521, 37.43247], [-121.80522, 37.43292], [-121.80889, 37.43288], [-121.81458, 37.43646], [-121.81425, 37.43644], [-121.81424, 37.43645], [-121.81432, 37.44375], [-121.82248, 37.44366], [-121.82343, 37.44274], [-121.82343, 37.44202], [-121.81987, 37.43978], [-121.82127, 37.43898], [-121.82137, 37.43898], [-121.8217, 37.43891], [-121.82187, 37.4389], [-121.82204, 37.43893], [-121.8222, 37.43898], [-121.82234, 37.43905], [-121.82336, 37.4397], [-121.82602, 37.44009], [-121.82833, 37.44004], [-121.82947, 37.43958], [-121.82999, 37.44046], [-121.83033, 37.44071], [-121.83116, 37.4406], [-121.83224, 37.44034], [-121.83258, 37.44068], [-121.83278, 37.44146], [-121.83313, 37.44233], [-121.83415, 37.44381], [-121.8345, 37.44418], [-121.83333, 37.44494], [-121.8324, 37.44607], [-121.83034, 37.44633], [-121.83079, 37.44704], [-121.83104, 37.44732], [-121.83207, 37.44734], [-121.83802, 37.45256], [-121.84034, 37.45206], [-121.84083, 37.45218], [-121.84095, 37.45225], [-121.841, 37.45232], [-121.84103, 37.4524], [-121.84102, 37.45274], [-121.841, 37.45282], [-121.84089, 37.45303], [-121.84088, 37.45318], [-121.84095, 37.45332], [-121.84117, 37.45359], [-121.84131, 37.45396], [-121.84133, 37.4541], [-121.84128, 37.45425], [-121.84121, 37.45434], [-121.84081, 37.45459], [-121.84074, 37.45465], [-121.8407, 37.45476], [-121.84072, 37.45487], [-121.84078, 37.45494], [-121.84086, 37.45499], [-121.84172, 37.45531], [-121.84194, 37.45542], [-121.84213, 37.45558], [-121.84228, 37.4558], [-121.84234, 37.45586], [-121.84294, 37.45618], [-121.84326, 37.45654], [-121.84333, 37.45663], [-121.84337, 37.45678], [-121.84334, 37.45694], [-121.84302, 37.45751], [-121.84265, 37.45791], [-121.84262, 37.45804], [-121.84264, 37.45817], [-121.84278, 37.45817], [-121.84284, 37.45824], [-121.84292, 37.45829], [-121.84307, 37.45832], [-121.84322, 37.45829], [-121.8438, 37.45807], [-121.84396, 37.45806], [-121.84406, 37.45809], [-121.84418, 37.45817], [-121.84459, 37.45863], [-121.84468, 37.45877], [-121.84474, 37.45891], [-121.84477, 37.45907], [-121.84476, 37.45923], [-121.84472, 37.45939], [-121.84461, 37.4596], [-121.84443, 37.45979], [-121.84365, 37.46044], [-121.84355, 37.46056], [-121.84348, 37.46069], [-121.84344, 37.46082], [-121.84343, 37.46097], [-121.84355, 37.46152], [-121.84358, 37.46184], [-121.84365, 37.46201], [-121.84379, 37.46215], [-121.84398, 37.46224], [-121.84475, 37.46239], [-121.84496, 37.46245], [-121.84513, 37.46257], [-121.84521, 37.46267], [-121.84527, 37.46278], [-121.84722, 37.46284], [-121.85118, 37.46612], [-121.85182, 37.46598], [-121.85621, 37.46949], [-121.85634, 37.47677], [-121.86213, 37.47675], [-121.86255, 37.47893], [-121.86265, 37.48073]], [[-121.73576, 37.44673], [-121.71751, 37.44689], [-121.71775, 37.46178], [-121.73601, 37.46179], [-121.73576, 37.44673]], [[-121.75238, 37.43205], [-121.75162, 37.43202], [-121.73551, 37.43217], [-121.73576, 37.44672], [-121.75346, 37.44655], [-121.75238, 37.43205]], [[-121.75461, 37.47663], [-121.75462, 37.47662], [-121.75374, 37.46181], [-121.73602, 37.4618], [-121.73628, 37.47662], [-121.75461, 37.47663]]], [[[-121.78782, 37.42515], [-121.78242, 37.42512], [-121.78227, 37.42554], [-121.782, 37.42562], [-121.78175, 37.42566], [-121.78145, 37.42574], [-121.78097, 37.42574], [-121.78063, 37.42586], [-121.7803, 37.42578], [-121.78006, 37.42606], [-121.7792, 37.42742], [-121.77879, 37.42736], [-121.77873, 37.42247], [-121.78681, 37.42249], [-121.7871, 37.42283], [-121.78743, 37.42315], [-121.78758, 37.42337], [-121.78781, 37.42378], [-121.78782, 37.42515]]]]} Restricted Access 2 402 San Francisco Watershed Lands 24889 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   Santa Clara 19 13844.721 San Francisco Watershed Lands   None 472  

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