superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 468 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14723 | 14723 | 14722 | {"type": "Polygon", "coordinates": [[[-121.84279, 37.09464], [-121.84249, 37.09949], [-121.81535, 37.09979], [-121.80309, 37.09987], [-121.80308, 37.09892], [-121.80307, 37.09891], [-121.8017, 37.09894], [-121.79263, 37.09906], [-121.79233, 37.08564], [-121.79413, 37.08608], [-121.79463, 37.08629], [-121.79596, 37.08665], [-121.79604, 37.08665], [-121.79689, 37.08693], [-121.81035, 37.08688], [-121.81049, 37.09054], [-121.81889, 37.09054], [-121.83285, 37.09024], [-121.83333, 37.09051], [-121.83344, 37.09063], [-121.83349, 37.09078], [-121.83358, 37.0909], [-121.83411, 37.09126], [-121.83427, 37.0913], [-121.83439, 37.0913], [-121.83491, 37.09111], [-121.83504, 37.09108], [-121.83518, 37.09109], [-121.83526, 37.09112], [-121.83532, 37.09117], [-121.83545, 37.09139], [-121.83554, 37.09149], [-121.83565, 37.09157], [-121.83585, 37.09165], [-121.83651, 37.0918], [-121.83658, 37.09365], [-121.83961, 37.09362], [-121.8398, 37.0936], [-121.84008, 37.09352], [-121.84015, 37.09351], [-121.84021, 37.09354], [-121.84025, 37.09359], [-121.84035, 37.09392], [-121.84049, 37.09418], [-121.84059, 37.09429], [-121.84071, 37.09439], [-121.84092, 37.0945], [-121.84134, 37.09462], [-121.84171, 37.09467], [-121.84189, 37.09466], [-121.84215, 37.09462], [-121.84236, 37.09461], [-121.84279, 37.09464]]]} | No Public Access 3 | Upper Uvas Creek Open Space Preserve | 26738 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 1215.896 | Upper Uvas Creek OSP | 2001 | |
14720 | 14720 | 14719 | {"type": "Polygon", "coordinates": [[[-121.85815, 37.22884], [-121.85695, 37.22901], [-121.85587, 37.22908], [-121.85461, 37.22903], [-121.85435, 37.22903], [-121.85412, 37.22913], [-121.85392, 37.22915], [-121.84989, 37.22873], [-121.84962, 37.22856], [-121.84824, 37.2282], [-121.84765, 37.22588], [-121.84714, 37.22428], [-121.84525, 37.22442], [-121.84525, 37.22462], [-121.84431, 37.22466], [-121.84366, 37.22463], [-121.84346, 37.22335], [-121.8435, 37.2233], [-121.84432, 37.22403], [-121.8454, 37.2238], [-121.84606, 37.22367], [-121.84744, 37.22335], [-121.84798, 37.22337], [-121.84832, 37.22282], [-121.84828, 37.22297], [-121.84831, 37.22313], [-121.84837, 37.22322], [-121.84843, 37.22328], [-121.84859, 37.22337], [-121.84801, 37.22351], [-121.84835, 37.22395], [-121.84894, 37.22421], [-121.84983, 37.2247], [-121.84979, 37.22477], [-121.84967, 37.22532], [-121.84947, 37.22559], [-121.84898, 37.22589], [-121.84897, 37.22612], [-121.84915, 37.22614], [-121.84856, 37.22667], [-121.84856, 37.22669], [-121.8501, 37.22725], [-121.85178, 37.22751], [-121.8518, 37.22756], [-121.85275, 37.22781], [-121.85286, 37.22778], [-121.85307, 37.22767], [-121.8534, 37.22777], [-121.85375, 37.2276], [-121.8542, 37.22755], [-121.85524, 37.22754], [-121.85548, 37.22748], [-121.85626, 37.22758], [-121.85664, 37.22779], [-121.85769, 37.22855], [-121.85815, 37.22884]]]} | Restricted Access 2 | Santa Teresa Foothills Open Space Preserve | 33751 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 53.101 | Santa Teresa Foothills OSP | ||
13039 | 13039 | 13038 | {"type": "Polygon", "coordinates": [[[-121.86443, 37.2402], [-121.86348, 37.24014], [-121.86302, 37.23952], [-121.86246, 37.23953], [-121.8623, 37.23942], [-121.86313, 37.23732], [-121.86382, 37.23753], [-121.86443, 37.2402]]]} | No Public Access 3 | Santa Teresa Foothills Open Space Preserve | http://www.openspaceauthority.org | 31575 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 8.631 | Santa Teresa Foothills OSP | 2016 |
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]);