units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

562 rows where ACCESS_TYP = 1 and COUNTY = 19

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 562 ✖
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
74 74 73 {"type": "Polygon", "coordinates": [[[-121.88839, 37.30077], [-121.88844, 37.30077], [-121.88849, 37.3008], [-121.88874, 37.30116], [-121.88913, 37.30175], [-121.88914, 37.3018], [-121.88912, 37.30184], [-121.88672, 37.30289], [-121.88666, 37.30289], [-121.88661, 37.30287], [-121.88592, 37.30185], [-121.88593, 37.3018], [-121.88839, 37.30077]]]} Open Access 1 173 River Glen Park 24409 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 8.688 River Glen Park 1983 Local Park 2 4
119 119 118 {"type": "Polygon", "coordinates": [[[-121.89805, 37.34221], [-121.89766, 37.34234], [-121.89763, 37.34236], [-121.89768, 37.34241], [-121.89676, 37.34271], [-121.89668, 37.34258], [-121.89615, 37.3428], [-121.8958, 37.34297], [-121.89546, 37.34252], [-121.89603, 37.34227], [-121.89719, 37.34189], [-121.89753, 37.34165], [-121.89768, 37.34174], [-121.89805, 37.34221]]]} Open Access 1 332 Ryland Park 24761 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 3.418 Ryland Park 1986 Local Park 2 4
194 194 193 {"type": "Polygon", "coordinates": [[[-121.94552, 37.31845], [-121.94347, 37.31848], [-121.94348, 37.31762], [-121.94351, 37.31759], [-121.94354, 37.31758], [-121.94357, 37.31766], [-121.94364, 37.31768], [-121.94368, 37.31766], [-121.9437, 37.31764], [-121.94369, 37.31755], [-121.94377, 37.31753], [-121.94543, 37.31734], [-121.94548, 37.31734], [-121.94551, 37.31739], [-121.94552, 37.31845]]]} Open Access 1 550 Santana Park 25148 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 5.009 Santana Park 1978 Local Park 2 4
206 206 205 {"type": "MultiPolygon", "coordinates": [[[[-121.99722, 37.29824], [-121.99724, 37.29876], [-121.99723, 37.29911], [-121.99718, 37.29963], [-121.99712, 37.29992], [-121.997, 37.30027], [-121.9964, 37.30157], [-121.9961, 37.30227], [-121.99595, 37.30272], [-121.99534, 37.30257], [-121.99527, 37.30258], [-121.9952, 37.30263], [-121.99491, 37.30257], [-121.99598, 37.30099], [-121.99615, 37.30072], [-121.99637, 37.30026], [-121.99654, 37.2998], [-121.99664, 37.29932], [-121.99675, 37.29863], [-121.99676, 37.29847], [-121.99683, 37.29818], [-121.99722, 37.29824]]], [[[-121.9971, 37.29508], [-121.99705, 37.29557], [-121.99704, 37.29596], [-121.99705, 37.29647], [-121.99709, 37.29688], [-121.99697, 37.29747], [-121.99635, 37.29738], [-121.99677, 37.29505], [-121.9971, 37.29508]]]]} Open Access 1 559 Saratoga Creek Park 25158 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 10.274 Saratoga Creek Park 1982 Local Park 2 4
283 283 282 {"type": "Polygon", "coordinates": [[[-121.83395, 37.28668], [-121.83326, 37.28716], [-121.83159, 37.28524], [-121.83237, 37.2848], [-121.83246, 37.28472], [-121.83255, 37.28474], [-121.83263, 37.28484], [-121.83263, 37.28489], [-121.83258, 37.28503], [-121.83268, 37.28506], [-121.83261, 37.28527], [-121.83299, 37.28536], [-121.83302, 37.2853], [-121.83308, 37.28531], [-121.83315, 37.2851], [-121.83366, 37.28521], [-121.83379, 37.28482], [-121.83386, 37.28484], [-121.83388, 37.28486], [-121.8339, 37.28555], [-121.83392, 37.28556], [-121.83395, 37.28668]]]} Open Access 1 962 Solari Park 25596 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 7.564 Solari Park 1976 Local Park 2 4
396 396 395 {"type": "Polygon", "coordinates": [[[-122.13963, 37.41148], [-122.13861, 37.41094], [-122.13867, 37.41065], [-122.1386, 37.41047], [-122.13841, 37.41035], [-122.13814, 37.41004], [-122.13828, 37.40965], [-122.13811, 37.40928], [-122.13786, 37.40907], [-122.13807, 37.40875], [-122.13818, 37.40851], [-122.13834, 37.40845], [-122.13963, 37.41148]]]} Open Access 1 1442 Bol Park 16235 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 4.248 Bol Park 1974 Local Park 2 4
404 404 403 {"type": "MultiPolygon", "coordinates": [[[[-121.87633, 37.26877], [-121.87629, 37.26882], [-121.87618, 37.26884], [-121.87574, 37.26885], [-121.87552, 37.26887], [-121.87461, 37.26909], [-121.87453, 37.26908], [-121.87449, 37.26904], [-121.87439, 37.26876], [-121.87434, 37.26866], [-121.87424, 37.26856], [-121.87417, 37.26852], [-121.87404, 37.26847], [-121.87423, 37.26803], [-121.87413, 37.26777], [-121.87434, 37.26772], [-121.87445, 37.26772], [-121.87451, 37.26768], [-121.87452, 37.26763], [-121.87484, 37.26755], [-121.87519, 37.2675], [-121.87526, 37.26756], [-121.87535, 37.26757], [-121.87541, 37.26755], [-121.8755, 37.26747], [-121.87592, 37.26738], [-121.87603, 37.26737], [-121.87607, 37.26738], [-121.87612, 37.26742], [-121.87614, 37.26746], [-121.87633, 37.26877]]], [[[-121.87705, 37.26835], [-121.87652, 37.26841], [-121.87646, 37.2684], [-121.87641, 37.26836], [-121.87625, 37.26729], [-121.87626, 37.26697], [-121.87624, 37.26684], [-121.87658, 37.26676], [-121.87676, 37.26782], [-121.87699, 37.26776], [-121.87705, 37.26835]]]]} Open Access 1 1546 Thousand Oaks 26323 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 8.805 Thousand Oaks 1985 None 42  
444 444 443 {"type": "MultiPolygon", "coordinates": [[[[-121.88809, 37.23293], [-121.88443, 37.23292], [-121.88436, 37.2328], [-121.88432, 37.23268], [-121.88428, 37.23249], [-121.88427, 37.23234], [-121.88429, 37.23231], [-121.88433, 37.2323], [-121.88805, 37.23232], [-121.88808, 37.23234], [-121.8881, 37.23237], [-121.88809, 37.23293]]], [[[-121.8943, 37.23234], [-121.89418, 37.23251], [-121.89397, 37.23297], [-121.89231, 37.23296], [-121.89231, 37.2329], [-121.89229, 37.23286], [-121.89224, 37.23284], [-121.89219, 37.23282], [-121.89201, 37.23288], [-121.89035, 37.23287], [-121.89019, 37.23282], [-121.8901, 37.23284], [-121.89006, 37.2329], [-121.89007, 37.23301], [-121.89006, 37.23351], [-121.89005, 37.23355], [-121.89, 37.23358], [-121.88853, 37.23362], [-121.88844, 37.23359], [-121.88836, 37.23354], [-121.88832, 37.2335], [-121.88829, 37.23342], [-121.88831, 37.2323], [-121.89136, 37.23232], [-121.89157, 37.23209], [-121.89176, 37.23215], [-121.89197, 37.23217], [-121.89217, 37.23213], [-121.89241, 37.23201], [-121.89241, 37.23233], [-121.8943, 37.23234]]]]} Open Access 1 1383 T.J. Martin 26157 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 17.459 T.J. Martin 1984 None 46  
453 453 452 {"type": "Polygon", "coordinates": [[[-122.12673, 37.40193], [-122.12661, 37.40184], [-122.12648, 37.40197], [-122.12604, 37.40189], [-122.12565, 37.40208], [-122.12556, 37.40226], [-122.12552, 37.40242], [-122.1254, 37.40246], [-122.12533, 37.40254], [-122.12512, 37.40323], [-122.12444, 37.40294], [-122.1239, 37.40228], [-122.12396, 37.40223], [-122.12422, 37.40168], [-122.12432, 37.40153], [-122.12442, 37.40133], [-122.12661, 37.40112], [-122.12673, 37.40193]]]} Open Access 1 1453 Terman Park 26250 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 7.663 Terman Park 1985 Local Park 2 4
519 519 518 {"type": "Polygon", "coordinates": [[[-122.02204, 37.31857], [-122.02204, 37.31871], [-122.02193, 37.31872], [-122.02188, 37.31876], [-122.02186, 37.31879], [-122.02187, 37.31884], [-122.02191, 37.31892], [-122.02191, 37.31979], [-122.02189, 37.31981], [-122.02178, 37.3198], [-122.02146, 37.31969], [-122.02119, 37.31965], [-122.02101, 37.31966], [-122.02062, 37.31972], [-122.02055, 37.31966], [-122.02025, 37.31966], [-122.02024, 37.31975], [-122.01989, 37.31974], [-122.01988, 37.3197], [-122.01985, 37.31967], [-122.01976, 37.31964], [-122.01962, 37.31968], [-122.0186, 37.31968], [-122.01922, 37.31816], [-122.02042, 37.31832], [-122.02043, 37.31836], [-122.02204, 37.31857]]]} Open Access 1 2166 Wilson Park 27609 1076 Cupertino, City of 195 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 1076 Cupertino, City of 191 City 2 City Agency 2   Santa Clara 19 9.936 Wilson Park 1966 Local Park 2 4
536 536 535 {"type": "Polygon", "coordinates": [[[-122.15574, 37.44328], [-122.1555, 37.44352], [-122.15524, 37.44335], [-122.15548, 37.44311], [-122.15574, 37.44328]]]} Open Access 1 15226 Scott Park 25205 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 0.258 Scott Park 1973 Local Park 2 4
578 578 577 {"type": "Polygon", "coordinates": [[[-121.898, 37.28754], [-121.89626, 37.28829], [-121.89597, 37.28788], [-121.89477, 37.2884], [-121.89439, 37.28785], [-121.89402, 37.288], [-121.89388, 37.28779], [-121.89389, 37.28775], [-121.89394, 37.28772], [-121.89732, 37.28649], [-121.89751, 37.28681], [-121.898, 37.28754]]]} Open Access 1 1926 Wallenburg Park 27220 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 9.119 Wallenburg Park 1961 Local Park 2 4
588 588 587 {"type": "Polygon", "coordinates": [[[-121.8244, 37.32448], [-121.82588, 37.32597], [-121.82589, 37.32601], [-121.82586, 37.32606], [-121.82416, 37.3272], [-121.82262, 37.32574], [-121.82324, 37.32527], [-121.8244, 37.32448]]]} Open Access 1 1999 Welch 27336 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 11.064 Welch 1995 None 59  
606 606 605 {"type": "Polygon", "coordinates": [[[-121.86951, 37.33581], [-121.86875, 37.33619], [-121.86867, 37.33624], [-121.86862, 37.3363], [-121.86823, 37.33704], [-121.8674, 37.33676], [-121.86703, 37.33577], [-121.86697, 37.33548], [-121.86694, 37.33478], [-121.86711, 37.33392], [-121.86791, 37.33383], [-121.86822, 37.33441], [-121.8684, 37.33465], [-121.86852, 37.33479], [-121.86892, 37.33513], [-121.86918, 37.33538], [-121.86951, 37.33581]]]} Open Access 1 2110 William Street Park 27559 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 11.685 William Street Park 0 Local Park 2 4
612 612 611 {"type": "Polygon", "coordinates": [[[-121.82499, 37.30827], [-121.82371, 37.30909], [-121.82343, 37.3088], [-121.82334, 37.30882], [-121.82205, 37.30749], [-121.82291, 37.30696], [-121.82374, 37.30779], [-121.82412, 37.30778], [-121.82438, 37.30764], [-121.82443, 37.30767], [-121.82455, 37.30771], [-121.82492, 37.3081], [-121.82494, 37.30814], [-121.82491, 37.30819], [-121.82499, 37.30827]]]} Open Access 1 2196 Windmill Springs Park 27629 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 6.859 Windmill Springs Park 1983 Local Park 2 4
620 620 619 {"type": "Polygon", "coordinates": [[[-121.90776, 37.25402], [-121.90738, 37.25423], [-121.90704, 37.25406], [-121.90677, 37.2541], [-121.90671, 37.25396], [-121.90666, 37.2539], [-121.90622, 37.2536], [-121.90607, 37.25347], [-121.90602, 37.25341], [-121.90597, 37.25326], [-121.906, 37.2529], [-121.90599, 37.25284], [-121.90585, 37.25248], [-121.90672, 37.25225], [-121.90776, 37.25402]]]} Open Access 1 2365 Branham Park 16332 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 4.919 Branham Park 1973 Local Park 2 4
665 665 664 {"type": "Polygon", "coordinates": [[[-121.91687, 37.25892], [-121.91694, 37.25895], [-121.9176, 37.25989], [-121.9176, 37.25993], [-121.91518, 37.26101], [-121.91514, 37.26101], [-121.91509, 37.26099], [-121.91444, 37.26006], [-121.91444, 37.26002], [-121.91445, 37.25999], [-121.91687, 37.25892]]]} Open Access 1 5056 Butcher 16545 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 8.116 Butcher 1981 None 63  
751 751 750 {"type": "Polygon", "coordinates": [[[-122.02681, 37.30115], [-122.02645, 37.30262], [-122.02649, 37.30263], [-122.02622, 37.30302], [-122.02611, 37.30314], [-122.02528, 37.30385], [-122.02406, 37.30433], [-122.02399, 37.30413], [-122.02384, 37.30385], [-122.0238, 37.30366], [-122.02375, 37.30168], [-122.0238, 37.30147], [-122.02381, 37.30133], [-122.02383, 37.30129], [-122.02389, 37.30126], [-122.02608, 37.30126], [-122.02635, 37.30123], [-122.02668, 37.30115], [-122.02681, 37.30115]]]} Open Access 1 5576 Calabazas 16668 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 16.77 Calabazas 1978 None 69  
870 870 869 {"type": "Polygon", "coordinates": [[[-121.81872, 37.23996], [-121.81869, 37.24127], [-121.8181, 37.24107], [-121.81777, 37.241], [-121.81742, 37.24099], [-121.81736, 37.24095], [-121.81724, 37.24045], [-121.81706, 37.23993], [-121.81872, 37.23996]]]} Open Access 1 5610 Calero Park 16680 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 4.064 Calero Park 1980 Local Park 2 4
1009 1009 1008 {"type": "Polygon", "coordinates": [[[-121.85208, 37.24596], [-121.85169, 37.24702], [-121.85135, 37.24693], [-121.85055, 37.24676], [-121.8482, 37.24621], [-121.84858, 37.24515], [-121.85208, 37.24596]]]} Open Access 1 5500 Cahalan 16655 1303 San Jose, City of 33 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1303 San Jose, City of 32 City 2 City Agency 2   Santa Clara 19 9.757 Cahalan 1978 None 91  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);