units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 4 and LABEL_NAME = "Skyline Ridge OSP"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15876 | 15876 | 15875 | {"type": "Polygon", "coordinates": [[[-122.19788, 37.31259], [-122.19734, 37.31318], [-122.19634, 37.31243], [-122.19512, 37.31263], [-122.19479, 37.31321], [-122.19457, 37.31393], [-122.19651, 37.31469], [-122.19637, 37.31486], [-122.19649, 37.31511], [-122.19677, 37.31531], [-122.19678, 37.31573], [-122.19699, 37.31607], [-122.19696, 37.31612], [-122.19657, 37.31632], [-122.19604, 37.31634], [-122.19587, 37.31666], [-122.19566, 37.31687], [-122.19547, 37.31683], [-122.19504, 37.31651], [-122.19456, 37.31658], [-122.19444, 37.31652], [-122.1943, 37.31618], [-122.19402, 37.31611], [-122.19386, 37.31614], [-122.19376, 37.31639], [-122.19367, 37.31649], [-122.19352, 37.31645], [-122.19297, 37.31617], [-122.19267, 37.31617], [-122.1924, 37.31599], [-122.19242, 37.31584], [-122.1924, 37.31566], [-122.19229, 37.31555], [-122.19188, 37.31533], [-122.19124, 37.31537], [-122.19108, 37.31511], [-122.19086, 37.31497], [-122.19074, 37.31469], [-122.19023, 37.31457], [-122.18987, 37.31438], [-122.18816, 37.31498], [-122.18749, 37.315], [-122.18738, 37.31497], [-122.18716, 37.31473], [-122.18694, 37.31453], [-122.18666, 37.31432], [-122.18635, 37.31414], [-122.18605, 37.314], [-122.18567, 37.31385], [-122.18536, 37.31377], [-122.18499, 37.31369], [-122.18473, 37.31366], [-122.18435, 37.31364], [-122.18402, 37.31365], [-122.1837, 37.31368], [-122.18339, 37.31373], [-122.18304, 37.31382], [-122.18235, 37.31408], [-122.18218, 37.31413], [-122.18202, 37.31415], [-122.18185, 37.31415], [-122.18169, 37.31413], [-122.18152, 37.31408], [-122.18138, 37.31402], [-122.18124, 37.31394], [-122.18112, 37.31383], [-122.18102, 37.3137], [-122.18095, 37.31354], [-122.18089, 37.31323], [-122.18082, 37.31301], [-122.18075, 37.31285], [-122.18063, 37.3127], [-122.18051, 37.31258], [-122.18031, 37.31246], [-122.18015, 37.31239], [-122.17991, 37.31233], [-122.17962, 37.31231], [-122.17935, 37.31234], [-122.17781, 37.31279], [-122.17738, 37.31287], [-122.17706, 37.31289], [-122.17675, 37.31288], [-122.17648, 37.31285], [-122.17618, 37.31278], [-122.17593, 37.3127], [-122.17573, 37.31262], [-122.1689, 37.30948], [-122.16861, 37.30882], [-122.16854, 37.30873], [-122.16853, 37.30874], [-122.16885, 37.30946], [-122.16864, 37.30934], [-122.16845, 37.3092], [-122.1683, 37.30904], [-122.16818, 37.30885], [-122.1681, 37.30866], [-122.1679, 37.30805], [-122.16775, 37.30774], [-122.16757, 37.30745], [-122.16734, 37.30717], [-122.16709, 37.30691], [-122.1668, 37.30667], [-122.16649, 37.30645], [-122.16615, 37.30626], [-122.1658, 37.30609], [-122.1647, 37.30564], [-122.16457, 37.30564], [-122.1638, 37.30531], [-122.16355, 37.30517], [-122.16335, 37.30503], [-122.16319, 37.3049], [-122.16299, 37.3047], [-122.16275, 37.3044], [-122.16257, 37.30408], [-122.16232, 37.30354], [-122.16236, 37.30345], [-122.16177, 37.30214], [-122.1617, 37.30195], [-122.16167, 37.30177], [-122.16168, 37.30157], [-122.16173, 37.30137], [-122.16182, 37.30118], [-122.16195, 37.30101], [-122.16211, 37.30085], [-122.1627, 37.30046], [-122.16285, 37.30032], [-122.16298, 37.30017], [-122.16307, 37.29999], [-122.16307, 37.29997], [-122.16314, 37.29972], [-122.16316, 37.29942], [-122.16321, 37.29928], [-122.16328, 37.29915], [-122.16337, 37.29902], [-122.16348, 37.29892], [-122.16388, 37.29868], [-122.16411, 37.29849], [-122.1643, 37.29824], [-122.16443, 37.298], [-122.16449, 37.29777], [-122.16451, 37.2975], [-122.16447, 37.29723], [-122.16437, 37.29703], [-122.16432, 37.29682], [-122.1643, 37.29655], [-122.16434, 37.29634], [-122.1644, 37.29617], [-122.1646, 37.29576], [-122.16464, 37.29576], [-122.16465, 37.29574], [-122.16513, 37.29555], [-122.16485, 37.29499], [-122.16477, 37.29476], [-122.16466, 37.29454], [-122.16451, 37.29434], [-122.16619, 37.29509], [-122.16883, 37.29411], [-122.1707, 37.29412], [-122.17077, 37.29059], [-122.17083, 37.28873], [-122.17105, 37.28877], [-122.17118, 37.28884], [-122.17169, 37.28899], [-122.1719, 37.28903], [-122.17229, 37.28917], [-122.17248, 37.28923], [-122.17283, 37.28939], [-122.17312, 37.28948], [-122.17327, 37.28955], [-122.17366, 37.28969], [-122.1738, 37.28975], [-122.17391, 37.28983], [-122.17401, 37.28985], [-122.17445, 37.28985], [-122.1746, 37.28979], [-122.17505, 37.28971], [-122.17562, 37.28952], [-122.17575, 37.28939], [-122.17585, 37.28935], [-122.17598, 37.28933], [-122.17636, 37.28934], [-122.17675, 37.2893], [-122.1772, 37.28932], [-122.1773, 37.28934], [-122.17737, 37.2894], [-122.17744, 37.28942], [-122.1776, 37.28944], [-122.17776, 37.28944], [-122.1779, 37.28948], [-122.17824, 37.28975], [-122.17849, 37.2899], [-122.17871, 37.29014], [-122.17886, 37.29027], [-122.17904, 37.29034], [-122.17943, 37.29039], [-122.17929, 37.29238], [-122.18765, 37.29745], [-122.18733, 37.30127], [-122.18704, 37.30506], [-122.19623, 37.30499], [-122.19621, 37.3058], [-122.19332, 37.3058], [-122.19331, 37.30581], [-122.19403, 37.30612], [-122.19456, 37.30706], [-122.19516, 37.30775], [-122.1957, 37.3087], [-122.19737, 37.30869], [-122.19748, 37.30942], [-122.1975, 37.31059], [-122.1978, 37.31136], [-122.19783, 37.31155], [-122.19777, 37.31174], [-122.19766, 37.31193], [-122.19761, 37.31214], [-122.19781, 37.31241], [-122.19788, 37.31259]], [[-122.17642, 37.29416], [-122.1707, 37.29412], [-122.1696, 37.30123], [-122.17866, 37.30117], [-122.17916, 37.29419], [-122.17642, 37.29416]]]} | Open Access 1 | 581 | Skyline Ridge Open Space Preserve | 29302 | 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_skyline_ridge.asp | San Mateo 15 | 1148.046 | Skyline Ridge OSP | 2000 | Local Conservation Area 4 | 2 |
15941 | 15941 | 15940 | {"type": "MultiPolygon", "coordinates": [[[[-122.21276, 37.28858], [-122.21236, 37.28943], [-122.21079, 37.29062], [-122.21033, 37.29139], [-122.21053, 37.29215], [-122.21047, 37.29291], [-122.21098, 37.29355], [-122.21141, 37.29423], [-122.21115, 37.29435], [-122.21099, 37.29436], [-122.21055, 37.29426], [-122.21014, 37.29434], [-122.20964, 37.2946], [-122.20902, 37.29473], [-122.20817, 37.29525], [-122.20762, 37.29529], [-122.20725, 37.29525], [-122.20689, 37.29503], [-122.20626, 37.29474], [-122.20589, 37.29466], [-122.20564, 37.2947], [-122.2055, 37.29489], [-122.2055, 37.29522], [-122.20585, 37.2954], [-122.20609, 37.29572], [-122.20664, 37.29605], [-122.20675, 37.29627], [-122.20672, 37.29645], [-122.20649, 37.29671], [-122.20661, 37.29736], [-122.20657, 37.29754], [-122.20618, 37.29783], [-122.20607, 37.29795], [-122.206, 37.29811], [-122.20598, 37.29829], [-122.20599, 37.29847], [-122.20593, 37.29864], [-122.20583, 37.29876], [-122.20561, 37.29893], [-122.20549, 37.29905], [-122.20519, 37.29953], [-122.20515, 37.29962], [-122.20514, 37.29973], [-122.20517, 37.29986], [-122.20541, 37.30021], [-122.20542, 37.30029], [-122.2054, 37.30038], [-122.20535, 37.30046], [-122.20527, 37.30052], [-122.20513, 37.30057], [-122.20514, 37.3014], [-122.20377, 37.3014], [-122.20363, 37.30159], [-122.20353, 37.30167], [-122.2034, 37.30171], [-122.20319, 37.30175], [-122.20308, 37.3018], [-122.20299, 37.30187], [-122.20293, 37.30198], [-122.20289, 37.30217], [-122.20287, 37.30242], [-122.20282, 37.30256], [-122.20247, 37.30293], [-122.2024, 37.303], [-122.20232, 37.30304], [-122.20224, 37.30305], [-122.20216, 37.30304], [-122.202, 37.30297], [-122.20183, 37.30281], [-122.20167, 37.30274], [-122.20136, 37.30272], [-122.20115, 37.30269], [-122.20106, 37.3027], [-122.20099, 37.30273], [-122.20093, 37.30279], [-122.2009, 37.30287], [-122.20094, 37.30319], [-122.20093, 37.30338], [-122.20083, 37.30363], [-122.20068, 37.30392], [-122.20052, 37.30417], [-122.20047, 37.30421], [-122.20009, 37.30434], [-122.19995, 37.30443], [-122.1999, 37.30452], [-122.1997, 37.30512], [-122.1996, 37.30526], [-122.19947, 37.30536], [-122.19933, 37.3054], [-122.19916, 37.30542], [-122.19902, 37.30539], [-122.19871, 37.30528], [-122.19846, 37.30523], [-122.19818, 37.30523], [-122.19792, 37.30526], [-122.19756, 37.30536], [-122.19725, 37.30548], [-122.1969, 37.30568], [-122.19666, 37.30587], [-122.19641, 37.30616], [-122.19637, 37.30627], [-122.19638, 37.30637], [-122.19643, 37.3064], [-122.19648, 37.30642], [-122.19676, 37.30637], [-122.19704, 37.30637], [-122.19726, 37.30642], [-122.19741, 37.30649], [-122.1975, 37.30658], [-122.19755, 37.30668], [-122.19756, 37.30674], [-122.19754, 37.30697], [-122.19755, 37.30703], [-122.19782, 37.30724], [-122.19789, 37.30734], [-122.19792, 37.30743], [-122.19793, 37.30755], [-122.19789, 37.30767], [-122.19744, 37.30844], [-122.19739, 37.30856], [-122.19737, 37.30869], [-122.1957, 37.3087], [-122.19516, 37.30775], [-122.19456, 37.30706], [-122.19403, 37.30612], [-122.19327, 37.3058], [-122.1962, 37.3058], [-122.19622, 37.30499], [-122.18703, 37.30506], [-122.18733, 37.30127], [-122.18853, 37.28719], [-122.19712, 37.28713], [-122.19716, 37.28342], [-122.20152, 37.28339], [-122.20147, 37.2871], [-122.20577, 37.28708], [-122.20572, 37.28853], [-122.21276, 37.28858]], [[-122.19644, 37.28924], [-122.19625, 37.28898], [-122.19613, 37.28874], [-122.19521, 37.28877], [-122.19481, 37.28832], [-122.19405, 37.28832], [-122.19363, 37.28812], [-122.19285, 37.28877], [-122.19297, 37.28914], [-122.19317, 37.28921], [-122.1941, 37.28957], [-122.19444, 37.28965], [-122.19555, 37.29011], [-122.19641, 37.29016], [-122.19662, 37.29036], [-122.19703, 37.29023], [-122.1974, 37.28994], [-122.19749, 37.28971], [-122.19751, 37.28933], [-122.19644, 37.28924]]], [[[-122.19734, 37.31318], [-122.19698, 37.31358], [-122.19691, 37.31381], [-122.19697, 37.31402], [-122.19715, 37.31444], [-122.19698, 37.31458], [-122.19656, 37.31464], [-122.19651, 37.31469], [-122.19456, 37.31393], [-122.19479, 37.31322], [-122.19511, 37.31263], [-122.19634, 37.31243], [-122.19734, 37.31318]]]]} | No Public Access 3 | 29585 | Skyline Ridge Open Space Preserve | 29301 | 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_skyline_ridge.asp | San Mateo 15 | 887.136 | Skyline Ridge OSP | 2000 | 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]);