units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_TYP = 9, DES_TP = 472 and MNG_AG_TYP = 8
This data as json, copyable, CSV (advanced)
| 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
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]);