units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3 and LABEL_NAME = "Windy Hill 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15894 | 15894 | 15893 | {"type": "MultiPolygon", "coordinates": [[[[-122.20982, 37.37039], [-122.20887, 37.37105], [-122.20806, 37.37168], [-122.20262, 37.37508], [-122.20255, 37.37509], [-122.20245, 37.37504], [-122.20271, 37.37258], [-122.20107, 37.37121], [-122.20101, 37.37069], [-122.20091, 37.36895], [-122.20083, 37.36864], [-122.20076, 37.36845], [-122.20023, 37.36745], [-122.20022, 37.36736], [-122.20023, 37.36728], [-122.20029, 37.36716], [-122.20053, 37.36698], [-122.20063, 37.36683], [-122.20072, 37.36745], [-122.20425, 37.36964], [-122.20555, 37.36808], [-122.20594, 37.36822], [-122.20766, 37.36894], [-122.20803, 37.36915], [-122.20982, 37.37039]]], [[[-122.24146, 37.36729], [-122.24071, 37.36794], [-122.23971, 37.36858], [-122.23856, 37.36888], [-122.23835, 37.36899], [-122.23831, 37.36919], [-122.23627, 37.37058], [-122.23392, 37.37184], [-122.23143, 37.37293], [-122.22941, 37.37372], [-122.22702, 37.37412], [-122.22512, 37.3743], [-122.22438, 37.37591], [-122.22425, 37.37613], [-122.22408, 37.37632], [-122.22385, 37.3765], [-122.22358, 37.37664], [-122.2233, 37.37674], [-122.22264, 37.37575], [-122.22254, 37.37568], [-122.22264, 37.37563], [-122.22268, 37.37563], [-122.22275, 37.3756], [-122.2228, 37.3756], [-122.22311, 37.37526], [-122.22329, 37.3751], [-122.22352, 37.37499], [-122.22399, 37.37452], [-122.22284, 37.37292], [-122.22236, 37.37177], [-122.22231, 37.37145], [-122.22199, 37.37089], [-122.22193, 37.37033], [-122.22167, 37.37013], [-122.22136, 37.36967], [-122.2212, 37.36913], [-122.21838, 37.36967], [-122.21818, 37.3692], [-122.21819, 37.36903], [-122.21838, 37.36824], [-122.21689, 37.36701], [-122.21679, 37.36705], [-122.2167, 37.36685], [-122.21625, 37.3655], [-122.21609, 37.36532], [-122.21609, 37.36491], [-122.21628, 37.36499], [-122.21688, 37.36456], [-122.21817, 37.36479], [-122.21885, 37.36474], [-122.21933, 37.36484], [-122.21988, 37.36443], [-122.22037, 37.36435], [-122.22102, 37.3639], [-122.22118, 37.36365], [-122.22131, 37.3636], [-122.22133, 37.36354], [-122.22151, 37.36323], [-122.22209, 37.3636], [-122.22092, 37.36514], [-122.22321, 37.36635], [-122.22474, 37.36555], [-122.22513, 37.36403], [-122.22542, 37.36402], [-122.22567, 37.36403], [-122.22614, 37.36421], [-122.22656, 37.36433], [-122.22702, 37.36435], [-122.22743, 37.36449], [-122.2279, 37.36471], [-122.22926, 37.36498], [-122.22983, 37.36475], [-122.2303, 37.36439], [-122.23059, 37.36431], [-122.2307, 37.36415], [-122.23112, 37.36407], [-122.23117, 37.36408], [-122.23128, 37.36405], [-122.23138, 37.36409], [-122.23151, 37.36411], [-122.2317, 37.36407], [-122.23195, 37.36408], [-122.23202, 37.36401], [-122.23236, 37.36382], [-122.23251, 37.36363], [-122.23274, 37.36356], [-122.23317, 37.3635], [-122.23366, 37.36324], [-122.23384, 37.36307], [-122.23413, 37.36305], [-122.23432, 37.36295], [-122.23477, 37.36298], [-122.23525, 37.36278], [-122.2362, 37.36249], [-122.23644, 37.36249], [-122.23723, 37.36231], [-122.23743, 37.3622], [-122.23782, 37.3621], [-122.23816, 37.36206], [-122.23838, 37.36207], [-122.23847, 37.36209], [-122.23874, 37.36223], [-122.23882, 37.36223], [-122.23854, 37.36312], [-122.23943, 37.36495], [-122.24028, 37.36525], [-122.24146, 37.36729]], [[-122.22541, 37.37388], [-122.22541, 37.37386], [-122.22522, 37.37383], [-122.22495, 37.37376], [-122.22476, 37.37349], [-122.22437, 37.37322], [-122.22416, 37.373], [-122.22398, 37.37267], [-122.22413, 37.37238], [-122.22445, 37.37208], [-122.2245, 37.37183], [-122.22459, 37.37158], [-122.22438, 37.3714], [-122.22414, 37.37133], [-122.22385, 37.37132], [-122.22268, 37.37177], [-122.22285, 37.37221], [-122.22316, 37.37275], [-122.2232, 37.37298], [-122.22335, 37.37324], [-122.22376, 37.37369], [-122.22399, 37.37367], [-122.22407, 37.37385], [-122.22399, 37.374], [-122.22416, 37.37419], [-122.22461, 37.37407], [-122.22475, 37.37397], [-122.22506, 37.3739], [-122.22541, 37.37388]]]]} | No Public Access 3 | 47718 | Windy Hill Open Space Preserve | 31500 | 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_windy_hill.asp | San Mateo 15 | 504.837 | Windy Hill OSP | 0 | 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]);