units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where ACCESS_TYP = 1, AGNCY_TYP = 2, COUNTY = 19 and DES_TP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY 9
MNG_AG_TYP 1
- City Agency 24
DES_TP 1
- Local Recreation Area · 24 ✖
ACCESS_TYP 1
- Open Access · 24 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1397 | 1397 | 1396 | {"type": "MultiPolygon", "coordinates": [[[[-121.79422, 37.23369], [-121.79422, 37.23411], [-121.79394, 37.2341], [-121.79396, 37.23297], [-121.7941, 37.23298], [-121.79415, 37.23301], [-121.79415, 37.2334], [-121.79412, 37.23355], [-121.79415, 37.23363], [-121.79422, 37.23369]]], [[[-121.79425, 37.23083], [-121.79424, 37.23137], [-121.79415, 37.23143], [-121.79411, 37.23151], [-121.79411, 37.23157], [-121.79414, 37.2317], [-121.79414, 37.23196], [-121.79409, 37.23208], [-121.7941, 37.23215], [-121.79413, 37.2322], [-121.79422, 37.23227], [-121.79422, 37.23281], [-121.79396, 37.23281], [-121.79398, 37.23083], [-121.79425, 37.23083]]], [[[-121.79425, 37.23012], [-121.79425, 37.23066], [-121.79397, 37.23067], [-121.79398, 37.23012], [-121.79425, 37.23012]]]]} | Open Access 1 | 8689 | Albertson Parkway | 15341 | 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 | 2.047 | Albertson Parkway | 1998 | Local Recreation Area 3 | 4 | |
1414 | 1414 | 1413 | {"type": "Polygon", "coordinates": [[[-121.8079, 37.3073], [-121.80762, 37.30745], [-121.80746, 37.30774], [-121.80743, 37.30773], [-121.80752, 37.30753], [-121.80727, 37.30715], [-121.80759, 37.30702], [-121.80764, 37.30702], [-121.80768, 37.30704], [-121.8079, 37.3073]]]} | Open Access 1 | 8882 | Brigadoon Tot Lot | 16388 | 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 | 0.454 | Brigadoon Tot Lot | 1996 | Local Recreation Area 3 | 4 | |
3977 | 3977 | 3976 | {"type": "Polygon", "coordinates": [[[-121.85453, 37.34889], [-121.85442, 37.34894], [-121.85423, 37.34868], [-121.85434, 37.34863], [-121.85453, 37.34889]]]} | Open Access 1 | 48844 | San Antonio Tot Lot | 33564 | 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 | https://www.sanjoseca.gov/Home/Components/FacilityDirectory/FacilityDirectory/2945/37 | Santa Clara 19 | 0.09 | San Antonio Tot Lot | 0 | Local Recreation Area 3 | 4 |
4102 | 4102 | 4101 | {"type": "Polygon", "coordinates": [[[-121.62608, 37.1293], [-121.62373, 37.12536], [-121.62667, 37.12424], [-121.62672, 37.12423], [-121.62676, 37.12426], [-121.62906, 37.12814], [-121.62902, 37.12819], [-121.62608, 37.1293]]]} | Open Access 1 | 47046 | Morgan Hill Outdoor Sports Center | 30696 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 35.375 | Morgan Hill Outdoor Sports Ctr. | 0 | Local Recreation Area 3 | 4 | |
4110 | 4110 | 4109 | {"type": "Polygon", "coordinates": [[[-122.12438, 37.45281], [-122.12411, 37.45285], [-122.12288, 37.45323], [-122.12265, 37.4533], [-122.12237, 37.45344], [-122.12221, 37.45356], [-122.12202, 37.45376], [-122.12188, 37.454], [-122.12182, 37.45426], [-122.12182, 37.45448], [-122.12097, 37.45356], [-122.1202, 37.45301], [-122.11907, 37.45273], [-122.12031, 37.45188], [-122.12045, 37.45182], [-122.12362, 37.45227], [-122.12392, 37.45261], [-122.12438, 37.45281]]]} | Open Access 1 | 47071 | Baylands Athletic Center | 30722 | 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 | 14.189 | Baylands Athletic Ctr. | 0 | Local Recreation Area 3 | 4 | |
4313 | 4313 | 4312 | {"type": "Polygon", "coordinates": [[[-121.84378, 37.30875], [-121.84355, 37.30896], [-121.84336, 37.30881], [-121.84333, 37.30882], [-121.84321, 37.30875], [-121.84336, 37.3085], [-121.84378, 37.30875]]]} | Open Access 1 | 45393 | La Raggione Tot Lot | 27912 | 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 | http://www.sanjoseca.gov/Facilities?clear=True | Santa Clara 19 | 0.304 | La Raggione Tot Lot | 0 | Local Recreation Area 3 | 4 |
5020 | 5020 | 5019 | {"type": "Polygon", "coordinates": [[[-121.92594, 37.3438], [-121.92465, 37.3447], [-121.92459, 37.34464], [-121.92486, 37.34438], [-121.9254, 37.34394], [-121.92553, 37.34388], [-121.92575, 37.34382], [-121.92594, 37.3438]]]} | Open Access 1 | 1034 | Southside Community Center | 25697 | 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 | 0.528 | Southside Community Ctr. | 1980 | Local Recreation Area 3 | 4 | |
7270 | 7270 | 7269 | {"type": "Polygon", "coordinates": [[[-121.93454, 37.26366], [-121.93454, 37.26383], [-121.93449, 37.26388], [-121.93447, 37.26395], [-121.93446, 37.2643], [-121.93449, 37.26439], [-121.93448, 37.26468], [-121.9316, 37.2647], [-121.9316, 37.26461], [-121.93187, 37.26459], [-121.93183, 37.26378], [-121.93196, 37.2638], [-121.93212, 37.26384], [-121.93211, 37.26389], [-121.93241, 37.26393], [-121.93261, 37.26393], [-121.93285, 37.26391], [-121.93302, 37.26387], [-121.93309, 37.26392], [-121.9331, 37.26427], [-121.93378, 37.26427], [-121.93379, 37.26407], [-121.93376, 37.26406], [-121.93375, 37.26376], [-121.93367, 37.26376], [-121.93365, 37.26359], [-121.93396, 37.26359], [-121.93396, 37.26373], [-121.93439, 37.26372], [-121.9344, 37.26367], [-121.93454, 37.26366]]]} | Open Access 1 | 6499 | Camden Park Center | 16755 | 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.013 | Camden Park Ctr. | 1961 | Local Recreation Area 3 | 4 | |
8589 | 8589 | 8588 | {"type": "Polygon", "coordinates": [[[-121.8648, 37.33265], [-121.8647, 37.33318], [-121.86433, 37.33313], [-121.86441, 37.33274], [-121.8648, 37.33265]]]} | Open Access 1 | 13657 | Forestdale Tot Lot | 18999 | 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 | 0.418 | Forestdale Tot Lot | 1988 | Local Recreation Area 3 | 4 | |
8593 | 8593 | 8592 | {"type": "Polygon", "coordinates": [[[-121.90177, 37.31871], [-121.90143, 37.31907], [-121.90143, 37.31907], [-121.90145, 37.3187], [-121.90177, 37.31871]]]} | Open Access 1 | 13668 | Gregory Plaza Tot Lot | 19501 | 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 | 0.146 | Gregory Plaza Tot Lot | 1998 | Local Recreation Area 3 | 4 | |
8596 | 8596 | 8595 | {"type": "Polygon", "coordinates": [[[-121.91488, 37.26568], [-121.91464, 37.26579], [-121.9143, 37.2652], [-121.91456, 37.26513], [-121.91488, 37.26568]]]} | Open Access 1 | 13673 | Huerta Tot Lot | 20137 | 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 | 0.427 | Huerta Tot Lot | 2002 | Local Recreation Area 3 | 4 | |
8604 | 8604 | 8603 | {"type": "Polygon", "coordinates": [[[-121.77261, 37.22524], [-121.77226, 37.22632], [-121.77218, 37.22638], [-121.77202, 37.22639], [-121.77177, 37.22636], [-121.7713, 37.22671], [-121.77114, 37.22687], [-121.76979, 37.22607], [-121.77015, 37.22476], [-121.77007, 37.22474], [-121.77007, 37.22473], [-121.77243, 37.22517], [-121.77261, 37.22524]]]} | Open Access 1 | 13691 | Martin Murphy Playfield | 21923 | 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.388 | Martin Murphy Playfield | 1984 | Local Recreation Area 3 | 4 | |
8887 | 8887 | 8886 | {"type": "Polygon", "coordinates": [[[-121.95452, 37.28882], [-121.95338, 37.28882], [-121.95342, 37.29059], [-121.95184, 37.2906], [-121.95184, 37.29016], [-121.95207, 37.29016], [-121.9521, 37.28978], [-121.95206, 37.28972], [-121.95194, 37.28963], [-121.95194, 37.28922], [-121.95192, 37.28892], [-121.95194, 37.28877], [-121.95199, 37.28868], [-121.95215, 37.28861], [-121.95233, 37.28861], [-121.95244, 37.28868], [-121.95263, 37.28871], [-121.95281, 37.28871], [-121.953, 37.28867], [-121.95319, 37.2886], [-121.95337, 37.28845], [-121.95348, 37.28828], [-121.95347, 37.28711], [-121.9545, 37.28709], [-121.95452, 37.28882]]]} | Open Access 1 | 14512 | Campbell Community Center | 16778 | 1043 | Campbell, City of 448 | City 2 | City Agency 2 | http://www.ci.campbell.ca.us/226/Recreation-Parks | City 2 | 1043 | Campbell, City of 442 | City 2 | City Agency 2 | Santa Clara 19 | 11.3 | Campbell Community Ctr. | 1985 | Local Recreation Area 3 | 4 | |
9369 | 9369 | 9368 | {"type": "Polygon", "coordinates": [[[-121.8548, 37.31737], [-121.85467, 37.31744], [-121.8546, 37.31739], [-121.85458, 37.31695], [-121.85444, 37.31663], [-121.85461, 37.31658], [-121.85474, 37.31677], [-121.8548, 37.31705], [-121.85478, 37.31731], [-121.8548, 37.31737]]]} | Open Access 1 | 15651 | Rocksprings Playground | 24534 | 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 | 0.408 | Rocksprings Playground | 1962 | Local Recreation Area 3 | 4 | |
13074 | 13074 | 13073 | {"type": "Polygon", "coordinates": [[[-121.93029, 37.23962], [-121.93021, 37.23964], [-121.93017, 37.23967], [-121.93006, 37.23962], [-121.92978, 37.23962], [-121.92944, 37.23972], [-121.92935, 37.23964], [-121.92955, 37.23939], [-121.93025, 37.23938], [-121.93029, 37.23962]]]} | Open Access 1 | 34953 | Howes Play Lot | 20126 | 1190 | Los Gatos, Town of 454 | City 2 | City Agency 2 | http://www.losgatosca.gov/48/Parks-and-Public-Works | City 2 | 1190 | Los Gatos, Town of 448 | City 2 | City Agency 2 | Santa Clara 19 | 0.522 | Howes Play Lot | 0 | Local Recreation Area 3 | 4 | |
13075 | 13075 | 13074 | {"type": "Polygon", "coordinates": [[[-121.95911, 37.24677], [-121.95895, 37.24698], [-121.95784, 37.24644], [-121.95791, 37.24641], [-121.95805, 37.24643], [-121.95815, 37.24642], [-121.9584, 37.24632], [-121.95844, 37.24632], [-121.9586, 37.24647], [-121.95874, 37.24659], [-121.95891, 37.24669], [-121.95911, 37.24677]]]} | Open Access 1 | 34954 | Oak Hill Play Lot | 22981 | 1190 | Los Gatos, Town of 454 | City 2 | City Agency 2 | http://www.losgatosca.gov/48/Parks-and-Public-Works | City 2 | 1190 | Los Gatos, Town of 448 | City 2 | City Agency 2 | Santa Clara 19 | 0.735 | Oak Hill Play Lot | 0 | Local Recreation Area 3 | 4 | |
13085 | 13085 | 13084 | {"type": "Polygon", "coordinates": [[[-121.92561, 37.22705], [-121.92201, 37.22709], [-121.92202, 37.22896], [-121.92022, 37.22898], [-121.92022, 37.22869], [-121.91836, 37.22781], [-121.91629, 37.22722], [-121.91595, 37.2274], [-121.91581, 37.22723], [-121.91455, 37.22633], [-121.91454, 37.22634], [-121.91453, 37.22643], [-121.91443, 37.22634], [-121.915, 37.22556], [-121.91536, 37.22524], [-121.91603, 37.2238], [-121.91633, 37.22366], [-121.91604, 37.22301], [-121.91608, 37.22297], [-121.91689, 37.22472], [-121.91782, 37.22484], [-121.9186, 37.22424], [-121.91864, 37.22401], [-121.91831, 37.22343], [-121.91838, 37.22341], [-121.91871, 37.224], [-121.91865, 37.22443], [-121.91809, 37.22577], [-121.91756, 37.22585], [-121.91744, 37.22582], [-121.91734, 37.22584], [-121.91671, 37.22539], [-121.91623, 37.2254], [-121.91599, 37.22563], [-121.91617, 37.22605], [-121.91682, 37.22669], [-121.91827, 37.2266], [-121.9192, 37.22659], [-121.92002, 37.22644], [-121.92032, 37.22548], [-121.92048, 37.22456], [-121.92048, 37.22423], [-121.92059, 37.22372], [-121.92067, 37.22375], [-121.92057, 37.22424], [-121.92058, 37.22449], [-121.92196, 37.22447], [-121.92196, 37.22396], [-121.92206, 37.22399], [-121.92217, 37.224], [-121.92218, 37.225], [-121.92272, 37.22491], [-121.92325, 37.22552], [-121.92421, 37.2262], [-121.92521, 37.22619], [-121.92504, 37.22546], [-121.92522, 37.22546], [-121.92561, 37.22705]]]} | Open Access 1 | 34961 | Santa Rosa Open Space | 25133 | 1190 | Los Gatos, Town of 454 | City 2 | City Agency 2 | http://www.losgatosca.gov/48/Parks-and-Public-Works | City 2 | 1190 | Los Gatos, Town of 448 | City 2 | City Agency 2 | Santa Clara 19 | 58.354 | Santa Rosa OS | 0 | Local Recreation Area 3 | 4 | |
14282 | 14282 | 14281 | {"type": "Polygon", "coordinates": [[[-121.96853, 37.40347], [-121.96857, 37.40376], [-121.96869, 37.40406], [-121.96886, 37.40434], [-121.96927, 37.40488], [-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.96685, 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]]]} | Open Access 1 | 44213 | Santa Clara Youth Soccer Park | 25058 | 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 | 11.229 | Santa Clara Youth Soccer Park | 0 | Local Recreation Area 3 | 4 | |
14440 | 14440 | 14439 | {"type": "Polygon", "coordinates": [[[-121.56506, 36.98952], [-121.56467, 36.9896], [-121.56371, 36.98985], [-121.56259, 36.98839], [-121.56249, 36.98724], [-121.56058, 36.98775], [-121.56037, 36.98746], [-121.56293, 36.98677], [-121.56318, 36.98696], [-121.56438, 36.98698], [-121.56442, 36.98752], [-121.56463, 36.9881], [-121.56469, 36.98849], [-121.56478, 36.98881], [-121.56506, 36.98952]]]} | Open Access 1 | 47049 | Gilroy Sports Park | 30699 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | Santa Clara 19 | 14.417 | Gilroy Sports Park | 0 | Local Recreation Area 3 | 4 | |
14441 | 14441 | 14440 | {"type": "Polygon", "coordinates": [[[-121.57138, 37.00561], [-121.57106, 37.00569], [-121.57098, 37.0055], [-121.57129, 37.00541], [-121.57138, 37.00561]]]} | Open Access 1 | 47051 | Wheeler Tot Lot | 30701 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | Santa Clara 19 | 0.169 | Wheeler Tot Lot | 0 | Local Recreation Area 3 | 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]);