superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 468
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14772 | 14772 | 14771 | {"type": "Polygon", "coordinates": [[[-121.72757, 37.22352], [-121.71451, 37.23235], [-121.71451, 37.23237], [-121.7172, 37.23464], [-121.70907, 37.23466], [-121.70896, 37.22767], [-121.68349, 37.20613], [-121.66781, 37.20618], [-121.67335, 37.20336], [-121.67909, 37.20242], [-121.67911, 37.20067], [-121.69238, 37.20067], [-121.70295, 37.20346], [-121.70715, 37.20748], [-121.71486, 37.20753], [-121.71586, 37.20847], [-121.71755, 37.20724], [-121.71888, 37.2083], [-121.72, 37.20859], [-121.72022, 37.20878], [-121.71982, 37.20963], [-121.71971, 37.21025], [-121.71957, 37.21069], [-121.71982, 37.21106], [-121.71977, 37.21155], [-121.71979, 37.21168], [-121.71983, 37.21181], [-121.7199, 37.21193], [-121.71999, 37.21205], [-121.72039, 37.21246], [-121.72062, 37.21273], [-121.72078, 37.21297], [-121.72108, 37.21354], [-121.72124, 37.21377], [-121.72235, 37.2151], [-121.72259, 37.21534], [-121.72293, 37.21562], [-121.7233, 37.21586], [-121.72358, 37.216], [-121.72322, 37.21628], [-121.72303, 37.21652], [-121.72234, 37.21764], [-121.72235, 37.21797], [-121.72757, 37.22352]]]} | No Public Access 3 | Coyote Ridge Open Space Preserve | http://www.openspaceauthority.org/ | 31566 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 1829.882 | Coyote Ridge OSP | 2015 |
14777 | 14777 | 14776 | {"type": "MultiPolygon", "coordinates": [[[[-121.79163, 37.13104], [-121.79163, 37.13104], [-121.78526, 37.1279], [-121.79161, 37.12787], [-121.79163, 37.13104]]], [[[-121.79695, 37.11703], [-121.79678, 37.11736], [-121.79688, 37.11795], [-121.79666, 37.11821], [-121.7966, 37.11863], [-121.79641, 37.11911], [-121.79628, 37.1195], [-121.79608, 37.11974], [-121.79609, 37.12064], [-121.79686, 37.12065], [-121.79686, 37.12087], [-121.79642, 37.12086], [-121.79621, 37.12087], [-121.79591, 37.12093], [-121.79571, 37.121], [-121.79569, 37.12065], [-121.78705, 37.12069], [-121.787, 37.11351], [-121.79607, 37.11347], [-121.79609, 37.11702], [-121.79695, 37.11703]]], [[[-121.82152, 37.1465], [-121.80335, 37.13681], [-121.80332, 37.13293], [-121.82138, 37.13218], [-121.82152, 37.1465]]]]} | No Public Access 3 | Rancho Cañada del Oro Open Space Preserve | http://www.openspaceauthority.org | 31571 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 588.025 | Rancho Cañada del Oro OSP | 2000 |
14779 | 14779 | 14778 | {"type": "MultiPolygon", "coordinates": [[[[-121.79333, 37.13188], [-121.79238, 37.13241], [-121.79211, 37.13263], [-121.79195, 37.1328], [-121.79174, 37.13309], [-121.79157, 37.13338], [-121.79142, 37.13374], [-121.79129, 37.13416], [-121.79119, 37.13462], [-121.79113, 37.13477], [-121.79102, 37.13536], [-121.79099, 37.13544], [-121.79086, 37.13567], [-121.79066, 37.1359], [-121.79049, 37.13604], [-121.79026, 37.13618], [-121.78941, 37.13636], [-121.78913, 37.13648], [-121.78877, 37.13669], [-121.78845, 37.13689], [-121.7881, 37.13707], [-121.78762, 37.13726], [-121.78744, 37.13735], [-121.78647, 37.13794], [-121.78628, 37.13807], [-121.78616, 37.13818], [-121.78605, 37.13835], [-121.78595, 37.13854], [-121.78592, 37.13885], [-121.78583, 37.13916], [-121.78603, 37.13977], [-121.78614, 37.14004], [-121.78613, 37.14012], [-121.78591, 37.14035], [-121.78575, 37.14044], [-121.78551, 37.1405], [-121.78492, 37.14049], [-121.78462, 37.14052], [-121.78414, 37.1406], [-121.78401, 37.14064], [-121.78391, 37.14069], [-121.78384, 37.14076], [-121.78383, 37.14084], [-121.78386, 37.14121], [-121.78384, 37.14142], [-121.78372, 37.14172], [-121.78362, 37.14183], [-121.78329, 37.14207], [-121.78321, 37.14219], [-121.78307, 37.14237], [-121.78294, 37.14247], [-121.78279, 37.14255], [-121.78241, 37.1427], [-121.78219, 37.14282], [-121.78198, 37.14305], [-121.78189, 37.14319], [-121.78174, 37.14332], [-121.78162, 37.14339], [-121.7814, 37.14345], [-121.78078, 37.14345], [-121.78049, 37.14347], [-121.78022, 37.14354], [-121.78014, 37.14358], [-121.78011, 37.14363], [-121.78012, 37.14376], [-121.7802, 37.14391], [-121.78029, 37.14405], [-121.78031, 37.14414], [-121.78029, 37.14422], [-121.78022, 37.14431], [-121.78, 37.14453], [-121.77947, 37.14479], [-121.77905, 37.14502], [-121.77871, 37.14522], [-121.7784, 37.14537], [-121.77796, 37.14566], [-121.77783, 37.14578], [-121.77769, 37.14593], [-121.77705, 37.14545], [-121.77673, 37.14548], [-121.77614, 37.14532], [-121.77581, 37.14548], [-121.77551, 37.14567], [-121.77532, 37.1459], [-121.77476, 37.14624], [-121.77443, 37.1468], [-121.77454, 37.14748], [-121.77428, 37.14783], [-121.76345, 37.13979], [-121.76651, 37.13763], [-121.76651, 37.13761], [-121.74558, 37.12204], [-121.74134, 37.12008], [-121.74137, 37.11983], [-121.74137, 37.11958], [-121.74148, 37.11951], [-121.74153, 37.11938], [-121.7416, 37.11915], [-121.74174, 37.11896], [-121.74279, 37.11838], [-121.74308, 37.11838], [-121.74338, 37.11846], [-121.74372, 37.11851], [-121.7447, 37.11852], [-121.74492, 37.11844], [-121.74502, 37.1182], [-121.74829, 37.11806], [-121.7491, 37.11698], [-121.75102, 37.11648], [-121.75061, 37.11495], [-121.75284, 37.11195], [-121.76286, 37.11685], [-121.76549, 37.11806], [-121.77168, 37.1212], [-121.79333, 37.13188]]], [[[-121.8305, 37.1323], [-121.82138, 37.13232], [-121.82134, 37.12872], [-121.82128, 37.12507], [-121.83043, 37.12505], [-121.8305, 37.1323]]], [[[-121.8415, 37.16061], [-121.84057, 37.16122], [-121.83917, 37.1616], [-121.83798, 37.16174], [-121.83576, 37.16133], [-121.83397, 37.15718], [-121.8395, 37.15564], [-121.8415, 37.16061]]]]} | Restricted Access 2 | Rancho Cañada del Oro Open Space Preserve | http://www.openspaceauthority.org | 31572 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2087.272 | Rancho Cañada del Oro OSP | 2000 |
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]);