units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where UNIT_NAME = "Saratoga Gap Open Space Preserve"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 2
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 |
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]);