superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 395 sorted by AGNCY_WEB
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6786 | 6786 | 6785 | {"type": "Polygon", "coordinates": [[[-121.98997, 37.32963], [-121.98969, 37.33024], [-121.98951, 37.33049], [-121.98935, 37.33065], [-121.98918, 37.33078], [-121.98864, 37.33106], [-121.98806, 37.33073], [-121.98785, 37.33064], [-121.9876, 37.33055], [-121.98719, 37.33046], [-121.9863, 37.33037], [-121.98626, 37.33034], [-121.98624, 37.33031], [-121.98632, 37.32911], [-121.98635, 37.32896], [-121.98641, 37.32882], [-121.98658, 37.32851], [-121.9866, 37.32973], [-121.98899, 37.33013], [-121.98919, 37.32973], [-121.98924, 37.32975], [-121.98932, 37.32977], [-121.9894, 37.32974], [-121.98945, 37.3297], [-121.98946, 37.32962], [-121.98939, 37.32953], [-121.98939, 37.3295], [-121.9894, 37.32947], [-121.98997, 37.32963]]]} | Open Access 1 | Maywood Park | 21983 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 7.322 | Maywood Park | 1973 | |
6907 | 6907 | 6906 | {"type": "Polygon", "coordinates": [[[-121.94126, 37.36692], [-121.94088, 37.36692], [-121.94088, 37.36656], [-121.94114, 37.36658], [-121.94122, 37.36662], [-121.94126, 37.36667], [-121.94126, 37.36692]]]} | Open Access 1 | Memorial Cross Park | 22118 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 0.314 | Memorial Cross Park | ||
7116 | 7116 | 7115 | {"type": "Polygon", "coordinates": [[[-121.94701, 37.38786], [-121.94445, 37.38895], [-121.94438, 37.38881], [-121.94432, 37.38867], [-121.94427, 37.38843], [-121.94427, 37.38788], [-121.94664, 37.38686], [-121.9469, 37.38724], [-121.94694, 37.38733], [-121.94695, 37.38743], [-121.94695, 37.38768], [-121.94697, 37.38777], [-121.94701, 37.38786]]]} | Open Access 1 | Montague Park | 22381 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 7.197 | Montague Park | 1973 | |
7974 | 7974 | 7973 | {"type": "Polygon", "coordinates": [[[-121.96591, 37.32753], [-121.96443, 37.32754], [-121.96432, 37.32724], [-121.96425, 37.32712], [-121.96434, 37.32709], [-121.96442, 37.32703], [-121.96444, 37.32695], [-121.96443, 37.3269], [-121.9644, 37.32685], [-121.96432, 37.3268], [-121.96421, 37.32679], [-121.96412, 37.32682], [-121.964, 37.32691], [-121.96386, 37.32693], [-121.96386, 37.32519], [-121.96399, 37.32519], [-121.96407, 37.32546], [-121.96418, 37.32573], [-121.96431, 37.32598], [-121.96457, 37.32635], [-121.96489, 37.32668], [-121.96543, 37.32711], [-121.96591, 37.32753]]]} | Open Access 1 | Parkway Park | 23462 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 4.131 | Parkway Park | 1961 | |
9022 | 9022 | 9021 | {"type": "Polygon", "coordinates": [[[-121.9558, 37.35623], [-121.95576, 37.35648], [-121.95576, 37.3574], [-121.9557, 37.35753], [-121.95559, 37.35766], [-121.95543, 37.35775], [-121.95531, 37.35779], [-121.95528, 37.35751], [-121.95472, 37.35753], [-121.95411, 37.35645], [-121.95434, 37.3564], [-121.9545, 37.35624], [-121.95494, 37.3564], [-121.95497, 37.35637], [-121.95504, 37.35639], [-121.95507, 37.3563], [-121.95515, 37.35628], [-121.95519, 37.35629], [-121.95524, 37.35627], [-121.95543, 37.35634], [-121.9555, 37.35632], [-121.95556, 37.35622], [-121.95538, 37.35615], [-121.95531, 37.35604], [-121.95533, 37.35599], [-121.95574, 37.35616], [-121.95578, 37.35619], [-121.9558, 37.35623]]]} | Open Access 1 | Rotary Park | 24696 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 4.343 | Rotary Park | 1961 | |
9302 | 9302 | 9301 | {"type": "Polygon", "coordinates": [[[-121.96928, 37.40492], [-121.96927, 37.40497], [-121.96923, 37.40501], [-121.96887, 37.40518], [-121.96877, 37.40527], [-121.96814, 37.40557], [-121.96732, 37.40583], [-121.96686, 37.40594], [-121.96674, 37.40599], [-121.96611, 37.40504], [-121.96611, 37.40496], [-121.96616, 37.40483], [-121.96613, 37.40474], [-121.96608, 37.4047], [-121.96602, 37.40466], [-121.96595, 37.40465], [-121.96586, 37.40466], [-121.96853, 37.40347], [-121.96857, 37.40376], [-121.96869, 37.40406], [-121.96886, 37.40434], [-121.96927, 37.40487], [-121.96928, 37.40492]]]} | Open Access 1 | Santa Clara Youth Soccer Park | 25058 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 11.229 | Santa Clara Youth Soccer Park | ||
9523 | 9523 | 9522 | {"type": "Polygon", "coordinates": [[[-121.95422, 37.3521], [-121.95419, 37.35217], [-121.95414, 37.3522], [-121.9539, 37.35222], [-121.95422, 37.3521]]]} | Open Access 1 | Sesquicentennial Park | 25322 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 0.032 | Sesquicentennial Park | ||
9567 | 9567 | 9566 | {"type": "Polygon", "coordinates": [[[-122.00096, 37.33108], [-122.00082, 37.33125], [-122.00061, 37.3316], [-121.99998, 37.33135], [-121.99971, 37.33126], [-121.99986, 37.33096], [-121.99997, 37.33067], [-122.00051, 37.33078], [-122.00074, 37.33076], [-122.00096, 37.33108]]]} | Open Access 1 | Westwood Oaks Park | 27439 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.737 | Westwood Oaks Park | 1961 | |
9960 | 9960 | 9959 | {"type": "Polygon", "coordinates": [[[-121.96482, 37.34592], [-121.96334, 37.34593], [-121.96334, 37.34547], [-121.96482, 37.34547], [-121.96482, 37.34592]]]} | Open Access 1 | Steve Carli Park | 25839 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.631 | Steve Carli Park | 1961 | |
10302 | 10302 | 10301 | {"type": "Polygon", "coordinates": [[[-121.94791, 37.40005], [-121.94789, 37.4001], [-121.94772, 37.4003], [-121.94771, 37.40037], [-121.94772, 37.40042], [-121.94725, 37.40095], [-121.94679, 37.4008], [-121.94635, 37.40068], [-121.946, 37.40061], [-121.94546, 37.40053], [-121.94742, 37.39972], [-121.94787, 37.4], [-121.94791, 37.40005]]]} | Open Access 1 | Thamien Park | 26276 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 3.491 | Thamien Park | ||
10547 | 10547 | 10546 | {"type": "Polygon", "coordinates": [[[-121.96133, 37.4083], [-121.96132, 37.40834], [-121.96127, 37.4084], [-121.961, 37.40863], [-121.96084, 37.4088], [-121.96041, 37.4094], [-121.9599, 37.40918], [-121.95662, 37.40804], [-121.95591, 37.40775], [-121.9554, 37.40749], [-121.95485, 37.40715], [-121.95433, 37.40676], [-121.95376, 37.40626], [-121.95343, 37.40591], [-121.95318, 37.4056], [-121.95296, 37.40528], [-121.95273, 37.40489], [-121.9525, 37.40458], [-121.95219, 37.40423], [-121.95183, 37.4039], [-121.95371, 37.4031], [-121.95399, 37.40346], [-121.95417, 37.40364], [-121.95436, 37.40379], [-121.95468, 37.404], [-121.95566, 37.40454], [-121.95582, 37.40464], [-121.95598, 37.40478], [-121.95617, 37.405], [-121.95649, 37.40543], [-121.95668, 37.40565], [-121.95757, 37.40687], [-121.95772, 37.40703], [-121.95789, 37.40717], [-121.95815, 37.40732], [-121.95945, 37.40794], [-121.95971, 37.40801], [-121.96001, 37.40806], [-121.96075, 37.40805], [-121.96095, 37.40806], [-121.96106, 37.4081], [-121.96124, 37.4082], [-121.9613, 37.40825], [-121.96133, 37.4083]]]} | Open Access 1 | Ulistac Natural Area | 26648 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 42.464 | Ulistac Natural Area | ||
11041 | 11041 | 11040 | {"type": "Polygon", "coordinates": [[[-121.9452, 37.34354], [-121.94488, 37.34366], [-121.94502, 37.34393], [-121.94417, 37.34424], [-121.94332, 37.3427], [-121.94323, 37.34272], [-121.94313, 37.34255], [-121.94184, 37.34301], [-121.94165, 37.34264], [-121.94178, 37.34259], [-121.94178, 37.34258], [-121.94115, 37.34143], [-121.94312, 37.34098], [-121.94385, 37.34228], [-121.94439, 37.34209], [-121.9452, 37.34354]]]} | Open Access 1 | Washington Park | 27281 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 13.567 | Washington Park | ||
11815 | 11815 | 11814 | {"type": "Polygon", "coordinates": [[[-121.94763, 37.35929], [-121.94758, 37.35936], [-121.94749, 37.35938], [-121.94726, 37.35926], [-121.94714, 37.359], [-121.94718, 37.35896], [-121.94685, 37.3583], [-121.94669, 37.3584], [-121.94653, 37.35811], [-121.94731, 37.35842], [-121.94763, 37.35929]]]} | Open Access 1 | Reed Street Dog Park | 28453 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.008 | Reed Street Dog Park | ||
13078 | 13078 | 13077 | {"type": "Polygon", "coordinates": [[[-121.96487, 37.3561], [-121.96487, 37.35727], [-121.96485, 37.35732], [-121.96477, 37.35735], [-121.96353, 37.35735], [-121.96353, 37.3561], [-121.96487, 37.3561]]]} | Open Access 1 | Warburton Park | 31670 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 4.062 | Warburton Park | 1961 |
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]);