superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where PARK_NAME = "Cascade Park"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2675 | 2675 | 2674 | {"type": "Polygon", "coordinates": [[[-122.56647, 37.91441], [-122.56646, 37.91444], [-122.56619, 37.91437], [-122.56597, 37.91439], [-122.56582, 37.91451], [-122.56554, 37.9153], [-122.56551, 37.91531], [-122.56544, 37.91507], [-122.56532, 37.91502], [-122.56538, 37.91479], [-122.56531, 37.9145], [-122.56531, 37.91435], [-122.56558, 37.91403], [-122.56538, 37.91367], [-122.56502, 37.9133], [-122.56466, 37.91325], [-122.56417, 37.9131], [-122.56358, 37.91219], [-122.56333, 37.91182], [-122.56367, 37.91199], [-122.56407, 37.91182], [-122.56432, 37.9118], [-122.56457, 37.9119], [-122.56457, 37.91204], [-122.56463, 37.91223], [-122.56548, 37.91275], [-122.56565, 37.91279], [-122.56571, 37.91277], [-122.56594, 37.913], [-122.56591, 37.91321], [-122.56607, 37.91357], [-122.56614, 37.91414], [-122.56647, 37.91441]]]} | Open Access 1 | Cascade Park | 16935 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 7.428 | Cascade Park | ||
2676 | 2676 | 2675 | {"type": "Polygon", "coordinates": [[[-118.13797, 34.05473], [-118.13779, 34.05502], [-118.13711, 34.05474], [-118.13729, 34.05444], [-118.13797, 34.05473]]]} | Open Access 1 | Cascade Park | 16936 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 0.643 | Cascade Park | ||
2677 | 2677 | 2676 | {"type": "Polygon", "coordinates": [[[-122.36896, 40.51309], [-122.36699, 40.51305], [-122.3666, 40.51308], [-122.36632, 40.51312], [-122.36511, 40.51361], [-122.36487, 40.51304], [-122.36543, 40.51252], [-122.36562, 40.51249], [-122.36554, 40.51242], [-122.36559, 40.51219], [-122.36569, 40.51201], [-122.36576, 40.51177], [-122.36586, 40.51154], [-122.36596, 40.51122], [-122.36598, 40.51068], [-122.36607, 40.51041], [-122.36627, 40.51003], [-122.36693, 40.50869], [-122.3669, 40.50884], [-122.36706, 40.50928], [-122.36729, 40.50934], [-122.36774, 40.50967], [-122.36774, 40.50972], [-122.3682, 40.51029], [-122.36853, 40.51047], [-122.3687, 40.5105], [-122.36871, 40.51136], [-122.36891, 40.51214], [-122.36862, 40.51213], [-122.36861, 40.51215], [-122.36895, 40.51291], [-122.36896, 40.51309]]]} | Open Access 1 | Cascade Park | 16937 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 24.096 | Cascade Park | ||
2678 | 2678 | 2677 | {"type": "Polygon", "coordinates": [[[-118.02242, 33.75773], [-118.02137, 33.75769], [-118.0211, 33.75765], [-118.02093, 33.7576], [-118.02077, 33.75752], [-118.02035, 33.75721], [-118.02241, 33.75719], [-118.02242, 33.75773]]]} | Open Access 1 | Cascade Park | 16938 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 2.179 | Cascade Park | ||
2679 | 2679 | 2678 | {"type": "Polygon", "coordinates": [[[-117.7745, 33.6464], [-117.77409, 33.64642], [-117.77402, 33.64586], [-117.77398, 33.64527], [-117.77395, 33.64518], [-117.77384, 33.64503], [-117.77389, 33.6449], [-117.77386, 33.64479], [-117.77383, 33.64478], [-117.77388, 33.64474], [-117.77385, 33.64453], [-117.77371, 33.64448], [-117.77371, 33.64441], [-117.77368, 33.64437], [-117.77378, 33.6443], [-117.77374, 33.64398], [-117.77357, 33.64362], [-117.77347, 33.64359], [-117.77345, 33.64351], [-117.77342, 33.64347], [-117.77348, 33.64339], [-117.77344, 33.64323], [-117.77344, 33.64295], [-117.77347, 33.64291], [-117.77331, 33.64267], [-117.77328, 33.64258], [-117.77321, 33.64254], [-117.77326, 33.64242], [-117.77312, 33.6422], [-117.7735, 33.64203], [-117.77358, 33.64201], [-117.77377, 33.64198], [-117.77402, 33.64202], [-117.77425, 33.6421], [-117.77441, 33.64219], [-117.77446, 33.64223], [-117.77445, 33.64226], [-117.77431, 33.64238], [-117.77417, 33.64252], [-117.77408, 33.64265], [-117.77401, 33.64278], [-117.77397, 33.64291], [-117.77394, 33.64317], [-117.77396, 33.6433], [-117.77399, 33.6434], [-117.77447, 33.64453], [-117.77457, 33.6449], [-117.7746, 33.64528], [-117.7746, 33.64546], [-117.7745, 33.6464]]]} | Restricted Access 2 | Cascade Park | 16939 | 6019 | Quail Hill Community Association 402 | Private 7 | Home Owners Association 15 | http://www.quailhillhoa.org/ | Private 14 | 7.141 | Cascade Park |
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]);