units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, DES_TP = 16 and UNIT_NAME = "San Vicente Redwoods (CEMEX)"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14133 | 14133 | 14132 | {"type": "MultiPolygon", "coordinates": [[[[-122.20849, 37.03895], [-122.20774, 37.04537], [-122.20299, 37.06543], [-122.19842, 37.08504], [-122.18438, 37.08286], [-122.18407, 37.08499], [-122.18456, 37.08659], [-122.18512, 37.08703], [-122.18582, 37.08725], [-122.18595, 37.08895], [-122.18438, 37.08984], [-122.18419, 37.09107], [-122.18314, 37.09157], [-122.18216, 37.09181], [-122.18187, 37.09228], [-122.1819, 37.09257], [-122.1816, 37.09318], [-122.1813, 37.09353], [-122.18131, 37.09355], [-122.19588, 37.09597], [-122.19473, 37.10089], [-122.1884, 37.12545], [-122.18624, 37.13506], [-122.1861, 37.13497], [-122.18557, 37.13479], [-122.18461, 37.13435], [-122.18395, 37.13375], [-122.18343, 37.13349], [-122.18229, 37.13277], [-122.18236, 37.1309], [-122.1819, 37.13049], [-122.18223, 37.13005], [-122.18227, 37.12981], [-122.18261, 37.1298], [-122.18278, 37.13035], [-122.18335, 37.13025], [-122.18308, 37.12927], [-122.18249, 37.12937], [-122.18258, 37.1297], [-122.17618, 37.12994], [-122.17542, 37.12787], [-122.17376, 37.12442], [-122.16521, 37.12842], [-122.1644, 37.12829], [-122.16424, 37.12807], [-122.16405, 37.12776], [-122.1632, 37.12631], [-122.16293, 37.12597], [-122.16275, 37.1258], [-122.16245, 37.12559], [-122.16152, 37.1252], [-122.16122, 37.12444], [-122.16116, 37.12436], [-122.16006, 37.12376], [-122.15975, 37.12338], [-122.15883, 37.12287], [-122.1587, 37.1226], [-122.15861, 37.12227], [-122.15884, 37.12155], [-122.15884, 37.12139], [-122.15869, 37.12093], [-122.15726, 37.11922], [-122.15619, 37.11778], [-122.15531, 37.11642], [-122.15489, 37.11582], [-122.15374, 37.11427], [-122.15329, 37.1139], [-122.15189, 37.1132], [-122.1516, 37.11304], [-122.15133, 37.11285], [-122.15108, 37.11265], [-122.15064, 37.11224], [-122.14951, 37.11109], [-122.14858, 37.11051], [-122.14695, 37.11007], [-122.14663, 37.10979], [-122.1459, 37.10868], [-122.14507, 37.10836], [-122.1451, 37.10768], [-122.14323, 37.10677], [-122.14216, 37.10396], [-122.14289, 37.10266], [-122.14355, 37.10188], [-122.14419, 37.10142], [-122.14459, 37.10103], [-122.145, 37.10046], [-122.14599, 37.09888], [-122.14813, 37.09608], [-122.1526, 37.09031], [-122.15435, 37.08702], [-122.15368, 37.08583], [-122.15319, 37.08545], [-122.1535, 37.08473], [-122.15315, 37.08383], [-122.15361, 37.08288], [-122.15423, 37.08234], [-122.15509, 37.08177], [-122.15449, 37.07867], [-122.15532, 37.07661], [-122.15469, 37.07477], [-122.16265, 37.06826], [-122.16347, 37.06734], [-122.16394, 37.06713], [-122.16448, 37.06601], [-122.16446, 37.0658], [-122.16456, 37.06463], [-122.16383, 37.06289], [-122.16492, 37.06221], [-122.16664, 37.06137], [-122.16756, 37.06135], [-122.16806, 37.06095], [-122.16785, 37.06029], [-122.16833, 37.06012], [-122.16848, 37.06056], [-122.1689, 37.06068], [-122.16921, 37.06037], [-122.16966, 37.06046], [-122.16983, 37.06047], [-122.17014, 37.06047], [-122.17061, 37.06042], [-122.17084, 37.06043], [-122.17118, 37.0605], [-122.17141, 37.06058], [-122.17177, 37.06075], [-122.17206, 37.06094], [-122.17214, 37.06098], [-122.17231, 37.06101], [-122.17245, 37.06102], [-122.17261, 37.06101], [-122.17299, 37.06092], [-122.17325, 37.06089], [-122.17343, 37.06089], [-122.17379, 37.06095], [-122.174, 37.06103], [-122.17398, 37.05437], [-122.17845, 37.05438], [-122.17844, 37.05084], [-122.17396, 37.05083], [-122.17396, 37.04733], [-122.16939, 37.0473], [-122.16065, 37.04754], [-122.1608, 37.04027], [-122.17396, 37.04019], [-122.17451, 37.0396], [-122.17648, 37.03937], [-122.17738, 37.03965], [-122.17719, 37.03971], [-122.17661, 37.03985], [-122.17629, 37.03999], [-122.1761, 37.04011], [-122.17593, 37.04026], [-122.17573, 37.0405], [-122.17563, 37.04068], [-122.17554, 37.04096], [-122.17549, 37.04159], [-122.17546, 37.04175], [-122.17537, 37.04196], [-122.17521, 37.0422], [-122.17511, 37.04246], [-122.17509, 37.04264], [-122.1751, 37.04282], [-122.17514, 37.043], [-122.17518, 37.04309], [-122.17556, 37.04313], [-122.17548, 37.04298], [-122.17544, 37.04282], [-122.17544, 37.04257], [-122.17551, 37.04233], [-122.17571, 37.04202], [-122.17578, 37.04186], [-122.17582, 37.04169], [-122.17587, 37.04107], [-122.1759, 37.04094], [-122.17598, 37.04072], [-122.1761, 37.04054], [-122.1763, 37.04034], [-122.17656, 37.04018], [-122.17685, 37.04007], [-122.17739, 37.03995], [-122.17758, 37.03987], [-122.17777, 37.03977], [-122.18066, 37.04065], [-122.18094, 37.04163], [-122.18109, 37.04201], [-122.18147, 37.04244], [-122.18205, 37.04278], [-122.18244, 37.04391], [-122.20017, 37.04577], [-122.20022, 37.04569], [-122.20041, 37.04519], [-122.2004, 37.04498], [-122.20136, 37.04424], [-122.20252, 37.04371], [-122.20661, 37.04251], [-122.20646, 37.04228], [-122.20681, 37.0422], [-122.20708, 37.04229], [-122.20729, 37.04229], [-122.20786, 37.04143], [-122.20802, 37.04078], [-122.20811, 37.04063], [-122.20796, 37.04005], [-122.20816, 37.03988], [-122.20837, 37.03901], [-122.20849, 37.03895]], [[-122.19563, 37.05623], [-122.19595, 37.05595], [-122.19627, 37.05545], [-122.19701, 37.05489], [-122.19743, 37.05451], [-122.19149, 37.04872], [-122.18633, 37.05292], [-122.18883, 37.05685], [-122.19538, 37.05764], [-122.19545, 37.05742], [-122.19554, 37.05726], [-122.19557, 37.05714], [-122.19548, 37.05701], [-122.19556, 37.05644], [-122.19563, 37.05623]]], [[[-122.18623, 37.13512], [-122.18531, 37.13922], [-122.17559, 37.13654], [-122.17015, 37.13295], [-122.17627, 37.13022], [-122.17622, 37.13003], [-122.1822, 37.12981], [-122.18216, 37.13004], [-122.1818, 37.1305], [-122.18232, 37.13093], [-122.18225, 37.13281], [-122.18339, 37.13353], [-122.18391, 37.13379], [-122.18456, 37.13439], [-122.18556, 37.13484], [-122.18606, 37.13501], [-122.18623, 37.13512]]]]} | No Public Access 3 | 42002 | San Vicente Redwoods (CEMEX) | 30543 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 8195.668 | San Vicente Redwoods (CEMEX) | 0 | Private Conservation 16 | 2 |
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]);