units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 395 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST, GAP_STS
DES_TP 3
MNG_AG_TYP 1
- City Agency 34
MNG_AGENCY 1
- Santa Clara, City of · 34 ✖
ACCESS_TYP 1
- Open Access 34
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES ▼ | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8712 | 8712 | 8711 | {"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 | 14150 | Sesquicentennial Park | 25322 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 0.032 | Sesquicentennial Park | 0 | Local Park 2 | 4 | |
14291 | 14291 | 14290 | {"type": "Polygon", "coordinates": [[[-121.94126, 37.36692], [-121.94088, 37.36692], [-121.94088, 37.36656], [-121.94114, 37.36657], [-121.94122, 37.36662], [-121.94126, 37.36667], [-121.94126, 37.36692]]]} | Open Access 1 | 44225 | Memorial Cross Park | 22118 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 0.314 | Memorial Cross Park | 0 | Local Park 2 | 4 | |
4434 | 4434 | 4433 | {"type": "Polygon", "coordinates": [[[-121.95471, 37.32693], [-121.95432, 37.327], [-121.95364, 37.327], [-121.95364, 37.32676], [-121.95367, 37.32675], [-121.95377, 37.32665], [-121.95387, 37.32661], [-121.95415, 37.32662], [-121.95426, 37.3266], [-121.95437, 37.32654], [-121.95445, 37.32662], [-121.95471, 37.32662], [-121.95471, 37.32693]]]} | Open Access 1 | 48912 | Thomas Barrett Park | 33633 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | https://www.santaclaraca.gov/Home/Components/ServiceDirectory/ServiceDirectory/4116/2654 | Santa Clara 19 | 0.948 | Thomas Barrett Park | 0 | Local Park 2 | 4 |
14990 | 14990 | 14989 | {"type": "Polygon", "coordinates": [[[-121.94752, 37.35899], [-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.35829], [-121.94669, 37.3584], [-121.94653, 37.35811], [-121.94731, 37.35842], [-121.94752, 37.35899]]]} | Open Access 1 | 45635 | Reed Street Dog Park | 28453 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 1.01 | Reed Street Dog Park | 0 | Local Park 2 | 4 | |
8729 | 8729 | 8728 | {"type": "Polygon", "coordinates": [[[-121.94535, 37.34767], [-121.94528, 37.34773], [-121.94498, 37.34787], [-121.94446, 37.34801], [-121.94438, 37.34793], [-121.94414, 37.34745], [-121.94414, 37.34731], [-121.94418, 37.34725], [-121.94426, 37.34721], [-121.94477, 37.34704], [-121.94483, 37.34703], [-121.94492, 37.34705], [-121.94501, 37.34711], [-121.9451, 37.34725], [-121.94501, 37.34727], [-121.945, 37.34722], [-121.94489, 37.34719], [-121.94453, 37.34717], [-121.94447, 37.34719], [-121.94446, 37.3472], [-121.94455, 37.34746], [-121.9449, 37.34748], [-121.94491, 37.3474], [-121.94505, 37.34741], [-121.94516, 37.34735], [-121.94524, 37.34747], [-121.94535, 37.34767]]]} | Open Access 1 | 14173 | City Plaza Park | 17344 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 1.539 | City Plaza Park | 1940 | Local Park 2 | 4 | |
8719 | 8719 | 8718 | {"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 | 14158 | Steve Carli Park | 25839 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 1.632 | Steve Carli Park | 1961 | Local Park 2 | 4 | |
8724 | 8724 | 8723 | {"type": "Polygon", "coordinates": [[[-121.9567, 37.33392], [-121.9564, 37.33377], [-121.95614, 37.3337], [-121.95611, 37.3328], [-121.95639, 37.33287], [-121.95664, 37.33299], [-121.95683, 37.33315], [-121.95707, 37.33343], [-121.95707, 37.33348], [-121.9567, 37.33392]]]} | Open Access 1 | 14164 | Everett Alvarez Park | 18761 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 1.695 | Everett Alvarez Park | 1961 | Local Park 2 | 4 | |
8717 | 8717 | 8716 | {"type": "Polygon", "coordinates": [[[-121.95423, 37.35323], [-121.95394, 37.35323], [-121.95366, 37.35326], [-121.95353, 37.35304], [-121.95364, 37.35294], [-121.95358, 37.35256], [-121.95439, 37.35255], [-121.95447, 37.35257], [-121.95476, 37.35308], [-121.95477, 37.35316], [-121.95473, 37.35322], [-121.95465, 37.35326], [-121.95423, 37.35323]]]} | Open Access 1 | 14149 | Civic Center Park | 17364 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 1.735 | Civic Ctr. Park | 1954 | Local Park 2 | 4 | |
8725 | 8725 | 8724 | {"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 | 14165 | Westwood Oaks Park | 27439 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 1.737 | Westwood Oaks Park | 1961 | Local Park 2 | 4 | |
1854 | 1854 | 1853 | {"type": "Polygon", "coordinates": [[[-121.95191, 37.35045], [-121.95084, 37.35083], [-121.95041, 37.35006], [-121.95102, 37.34985], [-121.95123, 37.35023], [-121.95169, 37.35007], [-121.95191, 37.35045]]]} | Open Access 1 | 14157 | Fremont Park | 19101 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 1.878 | Fremont Park | 2000 | Local Park 2 | 4 | |
1644 | 1644 | 1643 | {"type": "Polygon", "coordinates": [[[-121.96249, 37.39315], [-121.96184, 37.39343], [-121.96118, 37.39246], [-121.96183, 37.39218], [-121.96249, 37.39315]]]} | Open Access 1 | 14134 | Agnew Park | 15287 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 1.999 | Agnew Park | 1973 | Local Park 2 | 4 | |
8707 | 8707 | 8706 | {"type": "Polygon", "coordinates": [[[-121.96563, 37.39796], [-121.96499, 37.39824], [-121.96491, 37.39816], [-121.96458, 37.39769], [-121.96438, 37.39777], [-121.96431, 37.39773], [-121.96432, 37.39768], [-121.96448, 37.3976], [-121.9642, 37.39717], [-121.96427, 37.39718], [-121.96433, 37.39715], [-121.9644, 37.39704], [-121.96447, 37.39699], [-121.9648, 37.39685], [-121.96488, 37.39686], [-121.96563, 37.39796]]]} | Open Access 1 | 14128 | Fuller Street Park | 19142 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 2.43 | Fuller Street Park | 1984 | Local Park 2 | 4 | |
1840 | 1840 | 1839 | {"type": "Polygon", "coordinates": [[[-121.99006, 37.35984], [-121.98834, 37.35985], [-121.98799, 37.35981], [-121.98766, 37.35971], [-121.98965, 37.35905], [-121.99006, 37.35984]]]} | Open Access 1 | 14139 | Machado Park | 21630 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 2.572 | Machado Park | 1961 | Local Park 2 | 4 | |
8721 | 8721 | 8720 | {"type": "Polygon", "coordinates": [[[-121.98313, 37.3352], [-121.98301, 37.33532], [-121.98292, 37.33545], [-121.98268, 37.33595], [-121.98253, 37.33613], [-121.98227, 37.33638], [-121.9814, 37.33704], [-121.98125, 37.33718], [-121.98112, 37.33735], [-121.98111, 37.33648], [-121.98174, 37.33647], [-121.98215, 37.33519], [-121.98299, 37.33518], [-121.98307, 37.33521], [-121.98313, 37.3352]]]} | Open Access 1 | 14161 | Homeridge Park | 20062 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 3.361 | Homeridge Park | 1961 | Local Park 2 | 4 | |
14023 | 14023 | 14022 | {"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 | 38014 | Thamien Park | 26276 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 3.491 | Thamien Park | 0 | Local Park 2 | 4 | |
8699 | 8699 | 8698 | {"type": "Polygon", "coordinates": [[[-121.9766, 37.37015], [-121.97596, 37.37005], [-121.97532, 37.3699], [-121.97545, 37.36958], [-121.97534, 37.36893], [-121.97528, 37.36883], [-121.97562, 37.36873], [-121.97577, 37.36875], [-121.97588, 37.36871], [-121.97638, 37.36873], [-121.9766, 37.37015]]]} | Open Access 1 | 14137 | Bracher Park | 16320 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 3.503 | Bracher Park | 1973 | Local Park 2 | 4 | |
4226 | 4226 | 4225 | {"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 | 47793 | Warburton Park | 31670 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 4.063 | Warburton Park | 1961 | Local Park 2 | 4 | |
8705 | 8705 | 8704 | {"type": "Polygon", "coordinates": [[[-121.96284, 37.40502], [-121.9613, 37.40567], [-121.96112, 37.40543], [-121.96115, 37.40536], [-121.96112, 37.40529], [-121.96107, 37.40526], [-121.96094, 37.40524], [-121.96086, 37.40521], [-121.96077, 37.40514], [-121.9607, 37.40506], [-121.96066, 37.40497], [-121.96065, 37.40481], [-121.96058, 37.40461], [-121.96062, 37.40457], [-121.96163, 37.40414], [-121.96205, 37.40477], [-121.96284, 37.40502]]]} | Open Access 1 | 14124 | Fairway Glen Park | 18822 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 4.07 | Fairway Glen Park | 1984 | Local Park 2 | 4 | |
8728 | 8728 | 8727 | {"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 | 14172 | Parkway Park | 23462 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 4.131 | Parkway Park | 1961 | Local Park 2 | 4 | |
8730 | 8730 | 8729 | {"type": "Polygon", "coordinates": [[[-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.35641], [-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], [-121.95576, 37.35648], [-121.95576, 37.3574]]]} | Open Access 1 | 14175 | Rotary Park | 24696 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 4.338 | Rotary Park | 1961 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);