units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AGENCY = 631, MNG_AG_LEV = 4 and YR_EST = 2003
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15904 | 15904 | 15903 | {"type": "MultiPolygon", "coordinates": [[[[-122.03602, 37.23153], [-122.03122, 37.23158], [-122.03129, 37.23551], [-122.0271, 37.23558], [-122.02511, 37.23557], [-122.0254, 37.23494], [-122.0246, 37.23381], [-122.02373, 37.2338], [-122.02363, 37.23395], [-122.02283, 37.2343], [-122.02158, 37.23459], [-122.02107, 37.23483], [-122.02049, 37.2349], [-122.01991, 37.23482], [-122.01979, 37.23466], [-122.01953, 37.23406], [-122.01927, 37.23362], [-122.01927, 37.23341], [-122.01931, 37.23323], [-122.01834, 37.23322], [-122.01848, 37.23264], [-122.01849, 37.23223], [-122.01764, 37.23219], [-122.01767, 37.23191], [-122.01862, 37.23145], [-122.01803, 37.23096], [-122.01758, 37.23099], [-122.01758, 37.23121], [-122.01762, 37.23148], [-122.01758, 37.23178], [-122.01746, 37.23176], [-122.01736, 37.23181], [-122.01719, 37.23207], [-122.01637, 37.23281], [-122.016, 37.23282], [-122.0154, 37.233], [-122.01507, 37.23292], [-122.01464, 37.23294], [-122.014, 37.2326], [-122.01351, 37.23244], [-122.01347, 37.2311], [-122.01353, 37.23066], [-122.01372, 37.2303], [-122.01371, 37.23029], [-122.01344, 37.23029], [-122.01339, 37.22855], [-122.01459, 37.22846], [-122.0145, 37.22838], [-122.01441, 37.22816], [-122.01414, 37.22798], [-122.01411, 37.22789], [-122.01414, 37.22777], [-122.01426, 37.22755], [-122.01368, 37.22738], [-122.01403, 37.22694], [-122.01377, 37.22689], [-122.01314, 37.22673], [-122.01287, 37.22671], [-122.01278, 37.22699], [-122.01239, 37.22708], [-122.01218, 37.22718], [-122.01152, 37.227], [-122.01146, 37.22719], [-122.01154, 37.22826], [-122.01027, 37.2279], [-122.01021, 37.22754], [-122.01007, 37.22714], [-122.00996, 37.22703], [-122.01016, 37.22674], [-122.01038, 37.22669], [-122.0105, 37.22661], [-122.01062, 37.22614], [-122.01087, 37.22585], [-122.01108, 37.22569], [-122.01124, 37.22551], [-122.01171, 37.22538], [-122.01212, 37.22522], [-122.01221, 37.22515], [-122.01247, 37.22467], [-122.0134, 37.22466], [-122.0134, 37.2247], [-122.01341, 37.2247], [-122.01806, 37.22454], [-122.0183, 37.22824], [-122.02247, 37.22799], [-122.02228, 37.22055], [-122.01803, 37.22064], [-122.01793, 37.21695], [-122.01322, 37.21707], [-122.01329, 37.22074], [-122.00941, 37.22263], [-122.00941, 37.22295], [-122.00826, 37.22332], [-122.00764, 37.22383], [-122.00726, 37.22398], [-122.00696, 37.22403], [-122.00702, 37.22426], [-122.00521, 37.22447], [-122.00506, 37.22472], [-122.00489, 37.22495], [-122.00452, 37.22573], [-122.00428, 37.2259], [-122.00425, 37.22363], [-122.00045, 37.22212], [-122.00004, 37.22203], [-121.99971, 37.22219], [-121.99944, 37.22244], [-121.99915, 37.22234], [-121.99913, 37.22096], [-122.0003, 37.22094], [-122.00028, 37.22005], [-121.99857, 37.22007], [-121.99858, 37.22096], [-121.99485, 37.22101], [-121.99471, 37.21385], [-121.99509, 37.21384], [-121.99504, 37.21137], [-121.99408, 37.21138], [-121.99401, 37.20684], [-121.99496, 37.20682], [-121.99956, 37.20623], [-121.99955, 37.21004], [-122.00411, 37.20953], [-122.00413, 37.21366], [-122.02188, 37.21358], [-122.0309, 37.21349], [-122.03093, 37.21521], [-122.03319, 37.2152], [-122.03322, 37.21598], [-122.03547, 37.21595], [-122.03549, 37.21685], [-122.03221, 37.21691], [-122.03224, 37.21839], [-122.03187, 37.2184], [-122.03183, 37.21692], [-122.03145, 37.21691], [-122.03148, 37.2184], [-122.03098, 37.21842], [-122.03108, 37.22406], [-122.0347, 37.22403], [-122.03478, 37.22781], [-122.03592, 37.22781], [-122.03602, 37.23153]], [[-122.01897, 37.23276], [-122.01897, 37.23275], [-122.01882, 37.2327], [-122.01855, 37.23277], [-122.01848, 37.23306], [-122.01864, 37.23313], [-122.01868, 37.23308], [-122.01885, 37.23301], [-122.01897, 37.23295], [-122.01901, 37.23287], [-122.01894, 37.23284], [-122.01897, 37.23276]]], [[[-122.00993, 37.2269], [-122.00988, 37.22696], [-122.00963, 37.2268], [-122.0095, 37.22686], [-122.00939, 37.22688], [-122.00937, 37.22682], [-122.00963, 37.22672], [-122.00993, 37.2269]]]]} | Open Access 1 | 16018 | El Sereno Open Space Preserve | 31503 | 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_el_sereno.asp | Santa Clara 19 | 1356.684 | El Sereno OSP | 2003 | Local Conservation Area 4 | 2 |
15928 | 15928 | 15927 | {"type": "Polygon", "coordinates": [[[-122.01096, 37.17045], [-122.01066, 37.17058], [-122.0105, 37.17074], [-122.0103, 37.17084], [-122.00975, 37.17124], [-122.00965, 37.17139], [-122.00932, 37.17152], [-122.00919, 37.17162], [-122.00907, 37.17163], [-122.00898, 37.17167], [-122.00854, 37.17155], [-122.00786, 37.17166], [-122.00758, 37.17183], [-122.00748, 37.17194], [-122.0073, 37.17197], [-122.00706, 37.17214], [-122.00678, 37.17245], [-122.00663, 37.1725], [-122.00652, 37.17265], [-122.00631, 37.17276], [-122.00628, 37.17289], [-122.00607, 37.17308], [-122.00594, 37.17325], [-122.00586, 37.17333], [-122.00564, 37.17343], [-122.00553, 37.17351], [-122.00539, 37.17356], [-122.00523, 37.17371], [-122.0052, 37.17384], [-122.00478, 37.17427], [-122.00493, 37.17449], [-122.00529, 37.1748], [-122.00566, 37.17501], [-122.00595, 37.17514], [-122.00624, 37.17533], [-122.00649, 37.17542], [-122.0068, 37.17558], [-122.00708, 37.17577], [-122.00746, 37.17586], [-122.00912, 37.17491], [-122.00915, 37.17502], [-122.00921, 37.17511], [-122.00935, 37.17526], [-122.00979, 37.17563], [-122.00993, 37.1757], [-122.01007, 37.17574], [-122.01035, 37.17576], [-122.01039, 37.17602], [-122.01024, 37.17631], [-122.01016, 37.17661], [-122.00971, 37.17712], [-122.00978, 37.17759], [-122.00995, 37.17776], [-122.01007, 37.17791], [-122.0101, 37.17808], [-122.01006, 37.1782], [-122.01002, 37.17823], [-122.00978, 37.17824], [-122.00927, 37.17869], [-122.00968, 37.17911], [-122.00968, 37.17931], [-122.00955, 37.17977], [-122.00931, 37.1799], [-122.00893, 37.17991], [-122.00843, 37.17999], [-122.00776, 37.17978], [-122.00713, 37.18034], [-122.00687, 37.18045], [-122.00652, 37.18045], [-122.00617, 37.18083], [-122.0057, 37.18106], [-122.0053, 37.18114], [-122.00509, 37.18109], [-122.0048, 37.18086], [-122.00442, 37.1804], [-122.00418, 37.18021], [-122.00373, 37.18015], [-122.00288, 37.18041], [-122.00259, 37.18084], [-122.00256, 37.18115], [-122.0031, 37.18184], [-122.00354, 37.18234], [-122.00452, 37.18287], [-122.00463, 37.18315], [-122.00485, 37.18341], [-122.00503, 37.18392], [-122.00501, 37.18399], [-122.00497, 37.18401], [-122.00443, 37.18397], [-122.00423, 37.18399], [-122.00388, 37.18413], [-122.00329, 37.1843], [-122.0032, 37.18431], [-122.00307, 37.18427], [-122.00275, 37.18414], [-122.00239, 37.18403], [-122.00238, 37.18429], [-122.0026, 37.1847], [-122.00273, 37.18509], [-122.0031, 37.18521], [-122.00276, 37.18561], [-122.00258, 37.18563], [-122.00218, 37.18559], [-122.00186, 37.18569], [-122.00186, 37.18571], [-122.00188, 37.18572], [-122.00154, 37.18585], [-122.00154, 37.18588], [-122.00128, 37.18594], [-122.00051, 37.18632], [-121.99863, 37.187], [-121.9984, 37.18703], [-121.99796, 37.18715], [-121.9978, 37.18717], [-121.99763, 37.18714], [-121.99731, 37.18705], [-121.99615, 37.18697], [-121.99586, 37.18703], [-121.99546, 37.18716], [-121.99524, 37.18728], [-121.9951, 37.18749], [-121.99508, 37.18772], [-121.99465, 37.18773], [-121.99471, 37.18951], [-121.99455, 37.18969], [-121.99421, 37.18993], [-121.99378, 37.19009], [-121.99339, 37.18947], [-121.99281, 37.1891], [-121.99224, 37.18819], [-121.99172, 37.18702], [-121.99235, 37.18586], [-121.99179, 37.18542], [-121.99214, 37.18481], [-121.9925, 37.18442], [-121.99327, 37.18282], [-121.99434, 37.18216], [-121.99402, 37.18107], [-121.99486, 37.17957], [-121.99613, 37.17899], [-121.99618, 37.17738], [-121.9968, 37.17713], [-121.99712, 37.17722], [-121.99772, 37.17722], [-121.99788, 37.17741], [-121.99816, 37.17741], [-121.99819, 37.1777], [-121.99827, 37.17777], [-121.99871, 37.17777], [-121.99875, 37.17773], [-121.99877, 37.17761], [-121.99923, 37.17747], [-121.99934, 37.17719], [-121.99966, 37.17714], [-121.9996, 37.17693], [-122.00016, 37.17675], [-122.00024, 37.17649], [-122.00024, 37.17631], [-122.00015, 37.176], [-122.00003, 37.17262], [-122.00092, 37.17054], [-122.00091, 37.17053], [-122.00017, 37.17054], [-122.00011, 37.16903], [-122.00007, 37.16708], [-122.0, 37.16707], [-121.9999, 37.1636], [-122.0034, 37.1636], [-122.00335, 37.15994], [-122.00784, 37.15996], [-122.008, 37.17047], [-122.01096, 37.17045]]]} | Restricted Access 2 | 18511 | Bear Creek Redwoods Open Space Preserve | 31478 | 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 | Santa Clara 19 | 577.047 | Bear Creek Redwoods OSP | 2003 | 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]);