units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where DES_TP = 4, MNG_AG_TYP = 4 and YR_EST = 2006
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY
ACCESS_TYP 3
MNG_AGENCY 2
MNG_AG_TYP 1
- Recreation/Parks District · 4 ✖
DES_TP 1
- Local Conservation Area · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9975 | 9975 | 9974 | {"type": "Polygon", "coordinates": [[[-122.11034, 37.25814], [-122.1099, 37.25831], [-122.10963, 37.25848], [-122.10956, 37.25855], [-122.10952, 37.25863], [-122.10951, 37.25873], [-122.10953, 37.25882], [-122.10846, 37.25883], [-122.10844, 37.25755], [-122.11032, 37.25756], [-122.11034, 37.25814]]]} | No Public Access 3 | 47967 | Saratoga Gap Open Space Preserve | 31468 | 373 | Santa Clara, County of 941 | County 3 | County Agency 3 | http://www.sccgov.org/sites/scc/Pages/default.aspx | County 3 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 4.827 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
15868 | 15868 | 15867 | {"type": "MultiPolygon", "coordinates": [[[[-122.1074, 37.25755], [-122.10725, 37.25764], [-122.10719, 37.2577], [-122.1067, 37.2583], [-122.10656, 37.25845], [-122.10638, 37.25859], [-122.10618, 37.25869], [-122.10587, 37.25883], [-122.10568, 37.25889], [-122.10479, 37.25891], [-122.10456, 37.25896], [-122.10436, 37.25907], [-122.10338, 37.25976], [-122.10328, 37.25752], [-122.1074, 37.25755]]], [[[-122.11989, 37.26453], [-122.11783, 37.26453], [-122.11775, 37.26433], [-122.1169, 37.26452], [-122.11691, 37.26466], [-122.11282, 37.2656], [-122.11282, 37.26502], [-122.11281, 37.26501], [-122.11279, 37.26451], [-122.10751, 37.26456], [-122.10747, 37.26592], [-122.10403, 37.26591], [-122.10404, 37.26461], [-122.10365, 37.2646], [-122.10339, 37.25995], [-122.10359, 37.25983], [-122.1045, 37.25919], [-122.10464, 37.25911], [-122.10482, 37.25908], [-122.10572, 37.25905], [-122.10597, 37.25897], [-122.10646, 37.25875], [-122.10662, 37.25864], [-122.10676, 37.25852], [-122.10736, 37.25779], [-122.10749, 37.2577], [-122.10785, 37.25755], [-122.10844, 37.25755], [-122.10847, 37.25883], [-122.10953, 37.25882], [-122.10965, 37.25911], [-122.10966, 37.25921], [-122.10962, 37.25931], [-122.10955, 37.2594], [-122.1094, 37.2595], [-122.10926, 37.25963], [-122.10918, 37.25978], [-122.10916, 37.25986], [-122.10918, 37.26025], [-122.10921, 37.26034], [-122.10925, 37.26042], [-122.10939, 37.26056], [-122.10957, 37.26065], [-122.10967, 37.26068], [-122.10988, 37.2607], [-122.10999, 37.26068], [-122.1101, 37.26066], [-122.11095, 37.26023], [-122.1112, 37.26015], [-122.11133, 37.26014], [-122.1116, 37.26016], [-122.11244, 37.26049], [-122.11253, 37.26051], [-122.11263, 37.26051], [-122.11272, 37.26048], [-122.1128, 37.26044], [-122.11287, 37.26034], [-122.11288, 37.26026], [-122.11285, 37.26015], [-122.11257, 37.25989], [-122.11242, 37.25967], [-122.11242, 37.25961], [-122.11247, 37.25948], [-122.11256, 37.25937], [-122.113, 37.25911], [-122.11379, 37.259], [-122.11391, 37.25896], [-122.11402, 37.25889], [-122.1141, 37.25882], [-122.11434, 37.25845], [-122.11444, 37.25836], [-122.11453, 37.25832], [-122.11501, 37.25818], [-122.1153, 37.25802], [-122.11544, 37.25802], [-122.11723, 37.26288], [-122.11725, 37.26301], [-122.1172, 37.26315], [-122.11722, 37.26323], [-122.11727, 37.2633], [-122.11739, 37.26337], [-122.11749, 37.26339], [-122.11834, 37.26332], [-122.11841, 37.26326], [-122.11849, 37.2631], [-122.11853, 37.26306], [-122.11939, 37.26269], [-122.11979, 37.26239], [-122.11986, 37.26236], [-122.12033, 37.26232], [-122.12055, 37.26242], [-122.1206, 37.26246], [-122.12062, 37.26253], [-122.12059, 37.26262], [-122.12052, 37.2627], [-122.12035, 37.26275], [-122.12028, 37.2628], [-122.11998, 37.26333], [-122.11994, 37.26337], [-122.11992, 37.26344], [-122.11993, 37.26349], [-122.11997, 37.26355], [-122.12045, 37.26383], [-122.1205, 37.26391], [-122.12049, 37.26399], [-122.12044, 37.26407], [-122.11989, 37.26453]]], [[[-122.13449, 37.27921], [-122.12327, 37.27902], [-122.12325, 37.27177], [-122.12328, 37.27176], [-122.11989, 37.25762], [-122.11586, 37.25759], [-122.11594, 37.25742], [-122.11594, 37.25724], [-122.11587, 37.25707], [-122.11573, 37.25686], [-122.11571, 37.25672], [-122.11574, 37.25658], [-122.11577, 37.25651], [-122.11589, 37.25639], [-122.11599, 37.25632], [-122.11624, 37.25624], [-122.1165, 37.25622], [-122.11664, 37.25624], [-122.11676, 37.25627], [-122.11745, 37.25658], [-122.11804, 37.25687], [-122.11842, 37.25709], [-122.11863, 37.25714], [-122.1191, 37.25717], [-122.11921, 37.25719], [-122.12019, 37.25764], [-122.12034, 37.25774], [-122.12045, 37.25787], [-122.12056, 37.25818], [-122.12061, 37.25828], [-122.12067, 37.25838], [-122.12121, 37.25865], [-122.12134, 37.25866], [-122.12132, 37.25869], [-122.12133, 37.2587], [-122.12161, 37.25868], [-122.12177, 37.2587], [-122.12192, 37.25874], [-122.12206, 37.2588], [-122.12324, 37.25961], [-122.12342, 37.25971], [-122.12362, 37.25979], [-122.12383, 37.25984], [-122.12405, 37.25986], [-122.12427, 37.25986], [-122.12448, 37.25982], [-122.12469, 37.25976], [-122.12517, 37.25958], [-122.12536, 37.25951], [-122.12557, 37.25948], [-122.12578, 37.25947], [-122.12599, 37.25948], [-122.12646, 37.25953], [-122.12671, 37.25955], [-122.12696, 37.25952], [-122.12768, 37.25934], [-122.12789, 37.25932], [-122.12809, 37.25932], [-122.12829, 37.25936], [-122.12848, 37.25942], [-122.12866, 37.2595], [-122.1297, 37.26009], [-122.13077, 37.26059], [-122.13112, 37.26079], [-122.13211, 37.26145], [-122.13223, 37.26155], [-122.13262, 37.26207], [-122.13281, 37.26225], [-122.13304, 37.2624], [-122.13329, 37.26252], [-122.13365, 37.26267], [-122.1343, 37.27166], [-122.13449, 37.27921]]]]} | Open Access 1 | 563 | Saratoga Gap Open Space Preserve | 31466 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 770.098 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
15940 | 15940 | 15939 | {"type": "MultiPolygon", "coordinates": [[[[-122.12327, 37.27902], [-122.11983, 37.27905], [-122.11985, 37.28017], [-122.11975, 37.28018], [-122.11957, 37.28045], [-122.11951, 37.28047], [-122.11949, 37.27906], [-122.1174, 37.27908], [-122.11738, 37.27836], [-122.11932, 37.27566], [-122.11931, 37.27565], [-122.11773, 37.27566], [-122.11686, 37.27688], [-122.11462, 37.2769], [-122.11464, 37.27878], [-122.11403, 37.27863], [-122.11326, 37.27857], [-122.11297, 37.27842], [-122.11296, 37.2785], [-122.1128, 37.27841], [-122.11273, 37.27832], [-122.11269, 37.2783], [-122.11247, 37.27826], [-122.11221, 37.27825], [-122.11199, 37.27817], [-122.11155, 37.2779], [-122.11143, 37.2778], [-122.11134, 37.27769], [-122.11129, 37.27747], [-122.1113, 37.27736], [-122.11124, 37.27721], [-122.11114, 37.27708], [-122.11, 37.27661], [-122.10962, 37.27637], [-122.10916, 37.27605], [-122.10906, 37.27602], [-122.10875, 37.27604], [-122.10859, 37.276], [-122.10844, 37.27593], [-122.10838, 37.27587], [-122.10823, 37.27581], [-122.10791, 37.27555], [-122.10794, 37.27554], [-122.10792, 37.27551], [-122.10687, 37.27479], [-122.10666, 37.27462], [-122.10643, 37.27448], [-122.10595, 37.27426], [-122.10573, 37.27408], [-122.10573, 37.27389], [-122.10571, 37.27374], [-122.10581, 37.27345], [-122.10582, 37.27322], [-122.10546, 37.27286], [-122.10567, 37.27291], [-122.10576, 37.27296], [-122.10581, 37.273], [-122.10583, 37.273], [-122.10581, 37.27195], [-122.10279, 37.27196], [-122.10288, 37.27176], [-122.103, 37.27178], [-122.10326, 37.27174], [-122.10361, 37.27176], [-122.10399, 37.27185], [-122.10402, 37.27175], [-122.10363, 37.27165], [-122.10325, 37.27163], [-122.10299, 37.27167], [-122.10283, 37.27165], [-122.10242, 37.27135], [-122.10214, 37.27123], [-122.10186, 37.27109], [-122.10136, 37.27072], [-122.10109, 37.27055], [-122.10087, 37.27034], [-122.10052, 37.27027], [-122.10031, 37.27017], [-122.09993, 37.26988], [-122.09964, 37.26971], [-122.09936, 37.26949], [-122.09911, 37.26933], [-122.0987, 37.26913], [-122.09823, 37.26929], [-122.09783, 37.26933], [-122.09742, 37.26927], [-122.0971, 37.26913], [-122.09695, 37.26889], [-122.09604, 37.26866], [-122.09574, 37.26865], [-122.09541, 37.26867], [-122.09529, 37.26865], [-122.09519, 37.26856], [-122.09517, 37.26823], [-122.09508, 37.2681], [-122.09527, 37.26819], [-122.09528, 37.26819], [-122.09527, 37.26469], [-122.0996, 37.26465], [-122.09965, 37.26816], [-122.10386, 37.26845], [-122.10387, 37.26844], [-122.10365, 37.26461], [-122.10404, 37.2646], [-122.10404, 37.26591], [-122.10746, 37.26592], [-122.1075, 37.26457], [-122.1128, 37.26451], [-122.11281, 37.265], [-122.11282, 37.26501], [-122.11282, 37.26561], [-122.11294, 37.27187], [-122.12325, 37.27177], [-122.12327, 37.27902]]], [[[-122.11221, 37.25757], [-122.10328, 37.25752], [-122.10342, 37.26073], [-122.10073, 37.26076], [-122.10118, 37.26091], [-122.10241, 37.26141], [-122.10247, 37.26145], [-122.10255, 37.26153], [-122.10259, 37.26163], [-122.10259, 37.26174], [-122.10257, 37.26179], [-122.10251, 37.26189], [-122.10234, 37.26197], [-122.1022, 37.26199], [-122.10207, 37.26198], [-122.10189, 37.26189], [-122.10154, 37.26151], [-122.10134, 37.26133], [-122.1011, 37.26114], [-122.10097, 37.26107], [-122.10082, 37.26105], [-122.10067, 37.26106], [-122.10015, 37.26124], [-122.09992, 37.26126], [-122.09974, 37.26122], [-122.09941, 37.26111], [-122.09921, 37.26102], [-122.09836, 37.26089], [-122.09823, 37.26083], [-122.09785, 37.2606], [-122.09768, 37.26054], [-122.09741, 37.26048], [-122.09723, 37.2604], [-122.09607, 37.2597], [-122.096, 37.25959], [-122.09597, 37.25946], [-122.09598, 37.2594], [-122.09603, 37.25927], [-122.09619, 37.25902], [-122.09622, 37.25891], [-122.0962, 37.2588], [-122.09609, 37.25861], [-122.09555, 37.25805], [-122.09536, 37.25793], [-122.09528, 37.25791], [-122.09527, 37.25745], [-122.09546, 37.2553], [-122.09738, 37.25427], [-122.098, 37.25379], [-122.09924, 37.25377], [-122.09914, 37.25029], [-122.10334, 37.25026], [-122.10326, 37.24757], [-122.1077, 37.24756], [-122.10775, 37.25023], [-122.11215, 37.25021], [-122.11221, 37.25757]]], [[[-122.12203, 37.28043], [-122.1217, 37.28053], [-122.12169, 37.28023], [-122.12186, 37.28019], [-122.12203, 37.2802], [-122.12203, 37.28043]]]]} | No Public Access 3 | 29584 | Saratoga Gap Open Space Preserve | 31468 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 810.535 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
16944 | 16944 | 16943 | {"type": "Polygon", "coordinates": [[[-122.64929, 38.49868], [-122.64914, 38.49872], [-122.64901, 38.4988], [-122.6489, 38.4989], [-122.64884, 38.49901], [-122.6488, 38.49912], [-122.6488, 38.49924], [-122.64817, 38.49896], [-122.648, 38.49906], [-122.64602, 38.49904], [-122.64464, 38.49892], [-122.64157, 38.49828], [-122.64048, 38.4982], [-122.63995, 38.49843], [-122.63855, 38.49832], [-122.63752, 38.49783], [-122.63694, 38.498], [-122.63675, 38.49867], [-122.63629, 38.49901], [-122.63575, 38.49931], [-122.63418, 38.50055], [-122.63629, 38.50362], [-122.64069, 38.5036], [-122.64077, 38.50728], [-122.64017, 38.50767], [-122.6393, 38.50829], [-122.63932, 38.50826], [-122.6393, 38.50821], [-122.639, 38.50804], [-122.63784, 38.5084], [-122.63158, 38.51022], [-122.62288, 38.50997], [-122.6228, 38.50987], [-122.62239, 38.50957], [-122.62224, 38.50941], [-122.62216, 38.50927], [-122.62202, 38.50917], [-122.62177, 38.50893], [-122.62175, 38.50886], [-122.62151, 38.50868], [-122.62101, 38.50848], [-122.62053, 38.50846], [-122.62019, 38.50842], [-122.6199, 38.50829], [-122.61969, 38.50828], [-122.61957, 38.50824], [-122.6193, 38.50804], [-122.61911, 38.50738], [-122.61907, 38.50735], [-122.619, 38.50719], [-122.61875, 38.50706], [-122.61842, 38.50707], [-122.61802, 38.50695], [-122.61785, 38.50695], [-122.61776, 38.50693], [-122.61763, 38.50696], [-122.61743, 38.50694], [-122.61698, 38.50677], [-122.61629, 38.50629], [-122.61625, 38.50628], [-122.61568, 38.50593], [-122.61495, 38.50564], [-122.61414, 38.50543], [-122.61408, 38.50545], [-122.61396, 38.50544], [-122.61302, 38.50578], [-122.61262, 38.50579], [-122.61255, 38.50583], [-122.61239, 38.50584], [-122.61207, 38.50581], [-122.61183, 38.50568], [-122.61169, 38.50555], [-122.61153, 38.50552], [-122.61152, 38.50553], [-122.61159, 38.5076], [-122.61405, 38.50761], [-122.6166, 38.50994], [-122.60967, 38.50997], [-122.60857, 38.49909], [-122.60853, 38.4956], [-122.6135, 38.49559], [-122.61367, 38.4994], [-122.63133, 38.49922], [-122.63517, 38.49898], [-122.63515, 38.49793], [-122.63588, 38.49767], [-122.63584, 38.49644], [-122.64068, 38.49719], [-122.64382, 38.49558], [-122.64277, 38.49505], [-122.64275, 38.49291], [-122.64348, 38.4925], [-122.64292, 38.49197], [-122.64279, 38.49202], [-122.64265, 38.49203], [-122.64252, 38.49199], [-122.64234, 38.49191], [-122.64166, 38.4915], [-122.64144, 38.49133], [-122.64134, 38.49118], [-122.6413, 38.49106], [-122.6412, 38.49053], [-122.6411, 38.49036], [-122.64079, 38.49006], [-122.64066, 38.48988], [-122.64049, 38.48942], [-122.6404, 38.4893], [-122.64028, 38.48924], [-122.64017, 38.48922], [-122.64001, 38.48584], [-122.64922, 38.48596], [-122.64926, 38.48754], [-122.64935, 38.49519], [-122.64929, 38.49868]], [[-122.63965, 38.50753], [-122.63965, 38.50752], [-122.63829, 38.5068], [-122.63821, 38.50687], [-122.63793, 38.50722], [-122.63914, 38.5079], [-122.63965, 38.50753]]]} | Restricted Access 2 | 29388 | Saddle Mountain Open Space Preserve | 24775 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 975.177 | Saddle Mtn. OSP | 2006 | Local Conservation Area 4 | 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]);