superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 631 and YR_EST = 1986
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Midpeninsula Regional Open Space District · 1 ✖
ACCESS_TYP 1
- Open Access · 1 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14769 | 14769 | 14768 | {"type": "MultiPolygon", "coordinates": [[[[-122.26147, 37.39074], [-122.26003, 37.39168], [-122.26004, 37.39172], [-122.2593, 37.3922], [-122.2593, 37.39222], [-122.25936, 37.39228], [-122.25933, 37.39229], [-122.25933, 37.39231], [-122.2579, 37.39229], [-122.25767, 37.39233], [-122.2575, 37.39239], [-122.25736, 37.3925], [-122.25725, 37.39263], [-122.25721, 37.39274], [-122.25712, 37.39283], [-122.257, 37.39288], [-122.25676, 37.39289], [-122.25661, 37.39294], [-122.25647, 37.39304], [-122.25637, 37.39318], [-122.25634, 37.39331], [-122.25635, 37.3934], [-122.2566, 37.39397], [-122.25661, 37.39406], [-122.2566, 37.39424], [-122.25663, 37.39435], [-122.25671, 37.39446], [-122.25682, 37.39455], [-122.25686, 37.39466], [-122.25694, 37.39475], [-122.25704, 37.39482], [-122.25718, 37.39487], [-122.25725, 37.39492], [-122.25729, 37.39498], [-122.25735, 37.39517], [-122.25733, 37.39526], [-122.25711, 37.3956], [-122.25704, 37.39577], [-122.25702, 37.39596], [-122.25707, 37.39641], [-122.25705, 37.39646], [-122.257, 37.39651], [-122.25696, 37.39658], [-122.25694, 37.39665], [-122.25695, 37.39674], [-122.25707, 37.39701], [-122.25715, 37.39712], [-122.25792, 37.39764], [-122.25802, 37.39769], [-122.25813, 37.39772], [-122.25824, 37.39772], [-122.2584, 37.3977], [-122.25848, 37.3977], [-122.25861, 37.39775], [-122.25868, 37.39781], [-122.25872, 37.39786], [-122.25873, 37.39793], [-122.25872, 37.39799], [-122.25869, 37.39803], [-122.25851, 37.39817], [-122.25829, 37.39824], [-122.25814, 37.39825], [-122.25799, 37.3982], [-122.25782, 37.39807], [-122.25769, 37.39789], [-122.25692, 37.39736], [-122.2566, 37.39722], [-122.25633, 37.39715], [-122.25615, 37.39713], [-122.25594, 37.39713], [-122.25534, 37.39716], [-122.25506, 37.39715], [-122.25496, 37.39712], [-122.25478, 37.39702], [-122.2556, 37.39647], [-122.25501, 37.39589], [-122.25508, 37.39589], [-122.25503, 37.39584], [-122.25448, 37.39571], [-122.25423, 37.39558], [-122.25393, 37.39549], [-122.25356, 37.3955], [-122.25353, 37.39547], [-122.25331, 37.39556], [-122.25268, 37.39574], [-122.25268, 37.39565], [-122.25262, 37.39565], [-122.25227, 37.39554], [-122.25189, 37.39539], [-122.25185, 37.39519], [-122.25155, 37.39516], [-122.2514, 37.3951], [-122.25117, 37.39509], [-122.25082, 37.39468], [-122.25047, 37.39446], [-122.25042, 37.3943], [-122.25053, 37.39377], [-122.25051, 37.39365], [-122.25046, 37.39363], [-122.25045, 37.39364], [-122.25011, 37.39348], [-122.24985, 37.39328], [-122.24989, 37.39286], [-122.24988, 37.39252], [-122.24979, 37.39252], [-122.24954, 37.39303], [-122.24946, 37.39339], [-122.24962, 37.39367], [-122.24929, 37.39408], [-122.24928, 37.39424], [-122.2492, 37.39404], [-122.24931, 37.39372], [-122.24901, 37.39341], [-122.24875, 37.39324], [-122.24877, 37.39291], [-122.24865, 37.39285], [-122.24921, 37.39193], [-122.2491, 37.3918], [-122.2491, 37.39178], [-122.24901, 37.39171], [-122.24951, 37.39124], [-122.25092, 37.38976], [-122.25089, 37.38951], [-122.25121, 37.38917], [-122.25131, 37.38873], [-122.25117, 37.38817], [-122.25101, 37.38787], [-122.25101, 37.38756], [-122.2515, 37.38767], [-122.25158, 37.3875], [-122.25188, 37.38727], [-122.25193, 37.38707], [-122.25205, 37.38681], [-122.25222, 37.38656], [-122.25242, 37.38658], [-122.25244, 37.38677], [-122.25265, 37.38715], [-122.25285, 37.38724], [-122.25291, 37.38745], [-122.25272, 37.38806], [-122.25276, 37.38816], [-122.25344, 37.38834], [-122.25369, 37.38849], [-122.2544, 37.38842], [-122.255, 37.38866], [-122.25525, 37.38865], [-122.25544, 37.38871], [-122.25607, 37.38887], [-122.25658, 37.38902], [-122.25679, 37.3891], [-122.25691, 37.38911], [-122.25763, 37.38956], [-122.25765, 37.38955], [-122.25781, 37.38963], [-122.2578, 37.38966], [-122.25787, 37.3897], [-122.25803, 37.38961], [-122.25985, 37.38932], [-122.26019, 37.38939], [-122.26135, 37.3905], [-122.26147, 37.39074]], [[-122.25088, 37.39353], [-122.25086, 37.39351], [-122.25082, 37.39356], [-122.25087, 37.39358], [-122.25088, 37.39353]], [[-122.25524, 37.39278], [-122.2558, 37.39221], [-122.25524, 37.39189], [-122.25524, 37.39187], [-122.25514, 37.39181], [-122.25501, 37.3918], [-122.25467, 37.3916], [-122.25437, 37.392], [-122.25461, 37.39235], [-122.25451, 37.39303], [-122.25429, 37.3931], [-122.25423, 37.3937], [-122.2544, 37.394], [-122.25481, 37.39398], [-122.25519, 37.39392], [-122.25554, 37.39382], [-122.25553, 37.39356], [-122.25538, 37.3932], [-122.25524, 37.39278]]], [[[-122.25791, 37.38103], [-122.2571, 37.38216], [-122.25721, 37.38258], [-122.25685, 37.38328], [-122.25661, 37.38355], [-122.25654, 37.38364], [-122.25628, 37.38388], [-122.25613, 37.38405], [-122.25576, 37.38419], [-122.25581, 37.38408], [-122.25603, 37.38399], [-122.2568, 37.38316], [-122.2571, 37.38254], [-122.25698, 37.38214], [-122.25782, 37.38098], [-122.25791, 37.38103]]]]} | Open Access 1 | Thornewood Open Space Preserve | http://www.openspace.org/preserves/pr_thornewood.asp | 31491 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 149.425 | Thornewood OSP | 1986 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);