units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where ACCESS_TYP = 3, MNG_AGENCY = 335 and MNG_AG_TYP = 10
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Non Profit - Land Trust · 4 ✖
MNG_AGENCY 1
- Peninsula Open Space Trust · 4 ✖
DES_TP 1
ACCESS_TYP 1
- No Public Access · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
14665 | 14665 | 14664 | {"type": "Polygon", "coordinates": [[[-122.44108, 37.54003], [-122.43146, 37.53188], [-122.43058, 37.53081], [-122.42593, 37.52849], [-122.42307, 37.52674], [-122.43404, 37.52671], [-122.43635, 37.52551], [-122.43629, 37.52004], [-122.44068, 37.52022], [-122.44068, 37.51956], [-122.44303, 37.52127], [-122.44451, 37.525], [-122.44475, 37.52671], [-122.44367, 37.52984], [-122.44191, 37.53167], [-122.44132, 37.53337], [-122.45025, 37.53334], [-122.44915, 37.52752], [-122.45045, 37.52752], [-122.45254, 37.5511], [-122.44806, 37.5517], [-122.44808, 37.55069], [-122.44589, 37.54757], [-122.44557, 37.54633], [-122.44329, 37.54181], [-122.44108, 37.54003]]]} | No Public Access 3 | 44934 | Scarper Ridge | 30544 | 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 | http://www.openspacetrust.org/news/ls-fa14-pg14.html | San Mateo 15 | 789.772 | Scarper Ridge | 0 | Private Conservation 16 | 2 |
14911 | 14911 | 14910 | {"type": "Polygon", "coordinates": [[[-122.30297, 37.29664], [-122.30295, 37.29671], [-122.30267, 37.29704], [-122.30281, 37.2978], [-122.29738, 37.29781], [-122.29481, 37.29558], [-122.2951, 37.29432], [-122.29511, 37.29408], [-122.29507, 37.29385], [-122.29496, 37.2936], [-122.2948, 37.29337], [-122.29382, 37.29246], [-122.29373, 37.29235], [-122.2929, 37.29083], [-122.29276, 37.28996], [-122.29269, 37.28996], [-122.29269, 37.28969], [-122.29228, 37.28866], [-122.29228, 37.28856], [-122.29229, 37.28847], [-122.29243, 37.28816], [-122.29246, 37.28799], [-122.29246, 37.28782], [-122.2924, 37.28751], [-122.28755, 37.28742], [-122.28757, 37.28477], [-122.28646, 37.28328], [-122.28659, 37.28114], [-122.28663, 37.28115], [-122.28691, 37.28169], [-122.28695, 37.28179], [-122.28697, 37.28195], [-122.28703, 37.28206], [-122.2876, 37.28249], [-122.28813, 37.28301], [-122.28826, 37.28309], [-122.28843, 37.28316], [-122.2889, 37.28325], [-122.28914, 37.28332], [-122.28981, 37.28363], [-122.28998, 37.28374], [-122.29009, 37.28388], [-122.29028, 37.28434], [-122.29049, 37.28469], [-122.29079, 37.28504], [-122.29117, 37.2854], [-122.29125, 37.28552], [-122.29132, 37.28567], [-122.29139, 37.28574], [-122.29152, 37.28579], [-122.29179, 37.28581], [-122.29186, 37.28585], [-122.29192, 37.28591], [-122.29201, 37.28581], [-122.29211, 37.2858], [-122.29237, 37.28581], [-122.29262, 37.28588], [-122.29287, 37.286], [-122.29334, 37.28637], [-122.29359, 37.28652], [-122.29392, 37.28664], [-122.29411, 37.28667], [-122.29432, 37.28669], [-122.29447, 37.28676], [-122.29462, 37.28686], [-122.2947, 37.2869], [-122.2962, 37.28699], [-122.29958, 37.28635], [-122.30011, 37.28489], [-122.30214, 37.28543], [-122.30189, 37.28583], [-122.30182, 37.28617], [-122.30184, 37.28642], [-122.30198, 37.28672], [-122.30272, 37.28733], [-122.30287, 37.28749], [-122.30298, 37.28775], [-122.30304, 37.28825], [-122.30298, 37.28862], [-122.303, 37.28903], [-122.30281, 37.29024], [-122.30271, 37.29038], [-122.30232, 37.29072], [-122.30216, 37.29094], [-122.30178, 37.29188], [-122.30174, 37.2922], [-122.30207, 37.29344], [-122.30215, 37.29437], [-122.30224, 37.29437], [-122.30233, 37.29604], [-122.30238, 37.29628], [-122.30247, 37.29634], [-122.30292, 37.29655], [-122.30297, 37.29664]]]} | No Public Access 3 | 45467 | Burns Valley | 28293 | 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 | San Mateo 15 | 281.018 | Burns Valley | 0 | Private Conservation 16 | 2 | |
15416 | 15416 | 15415 | {"type": "Polygon", "coordinates": [[[-122.37853, 37.32895], [-122.37805, 37.32924], [-122.37762, 37.3292], [-122.3777, 37.32951], [-122.37792, 37.32985], [-122.37781, 37.33039], [-122.37842, 37.33132], [-122.37838, 37.33141], [-122.37455, 37.33007], [-122.37418, 37.3299], [-122.37247, 37.32936], [-122.37202, 37.32924], [-122.37168, 37.32917], [-122.37127, 37.32912], [-122.37086, 37.32908], [-122.37044, 37.32908], [-122.37003, 37.32909], [-122.36962, 37.32914], [-122.36922, 37.3292], [-122.36884, 37.32929], [-122.36907, 37.32827], [-122.36935, 37.32808], [-122.36969, 37.32792], [-122.3697, 37.32776], [-122.37017, 37.32769], [-122.37057, 37.3273], [-122.37075, 37.32726], [-122.37125, 37.32748], [-122.37164, 37.32756], [-122.37214, 37.32794], [-122.37264, 37.32808], [-122.37287, 37.32826], [-122.37326, 37.3284], [-122.37343, 37.32875], [-122.37367, 37.32896], [-122.37409, 37.32913], [-122.37495, 37.32931], [-122.37536, 37.3291], [-122.37556, 37.32903], [-122.3762, 37.32891], [-122.3773, 37.32889], [-122.37756, 37.32883], [-122.37813, 37.32896], [-122.37853, 37.32895]]]} | No Public Access 3 | 49048 | Rising Acres | 33757 | 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 | San Mateo 15 | 31.341 | Rising Acres | 2020 | 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]);