units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where DES_TP = 2, MNG_AG_TYP = 2 and YR_EST = 1972
This data as json, copyable, CSV (advanced)
MNG_AGENCY 10
MNG_AG_TYP 1
- City Agency · 11 ✖
DES_TP 1
- Local Park · 11 ✖
ACCESS_TYP 1
- Open Access 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1749 | 1749 | 1748 | {"type": "Polygon", "coordinates": [[[-121.99986, 37.58564], [-121.99972, 37.58581], [-121.99965, 37.58593], [-121.99961, 37.58596], [-121.99911, 37.58586], [-121.99892, 37.5858], [-121.99868, 37.58569], [-121.99852, 37.58557], [-121.99854, 37.58553], [-121.99871, 37.58539], [-121.99882, 37.58528], [-121.99909, 37.58507], [-121.99915, 37.58506], [-121.9992, 37.58507], [-121.99985, 37.58559], [-121.99986, 37.58564]]]} | Open Access 1 | 12992 | California Terrace Park | 16729 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 1.669 | California Terrace Park | 1972 | Local Park 2 | 4 | |
1810 | 1810 | 1809 | {"type": "Polygon", "coordinates": [[[-121.91563, 37.36258], [-121.91482, 37.36298], [-121.91447, 37.36254], [-121.91522, 37.36207], [-121.91563, 37.36258]]]} | Open Access 1 | 13739 | Rosemary Gardens Park | 24619 | 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 | 1.306 | Rosemary Gardens Park | 1972 | Local Park 2 | 4 | |
1925 | 1925 | 1924 | {"type": "Polygon", "coordinates": [[[-121.98763, 37.22898], [-121.98664, 37.23005], [-121.98605, 37.22969], [-121.98657, 37.22857], [-121.9868, 37.22863], [-121.98697, 37.22826], [-121.98756, 37.22845], [-121.98719, 37.22871], [-121.98763, 37.22898]]]} | Open Access 1 | 14896 | Bachman Park | 15750 | 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 | 3.488 | Bachman Park | 1972 | Local Park 2 | 4 | |
3767 | 3767 | 3766 | {"type": "Polygon", "coordinates": [[[-122.07881, 37.59741], [-122.07881, 37.59746], [-122.07762, 37.59746], [-122.07762, 37.59685], [-122.07796, 37.59684], [-122.07796, 37.59657], [-122.0788, 37.59656], [-122.0788, 37.59704], [-122.07846, 37.59706], [-122.07847, 37.59741], [-122.07881, 37.59741]]]} | Open Access 1 | 34950 | Old Alvarado Park | 23081 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 2.059 | Old Alvarado Park | 1972 | Local Park 2 | 4 | |
4954 | 4954 | 4953 | {"type": "Polygon", "coordinates": [[[-122.27862, 37.83725], [-122.27859, 37.83726], [-122.27861, 37.83733], [-122.27849, 37.83735], [-122.27845, 37.8372], [-122.27826, 37.83713], [-122.27819, 37.83699], [-122.27755, 37.8371], [-122.27731, 37.83727], [-122.27716, 37.83724], [-122.27698, 37.83701], [-122.27691, 37.83695], [-122.2768, 37.83694], [-122.27638, 37.83702], [-122.27623, 37.83695], [-122.2763, 37.83674], [-122.27705, 37.83658], [-122.27707, 37.8368], [-122.27721, 37.83686], [-122.27734, 37.83687], [-122.27811, 37.83684], [-122.27826, 37.83686], [-122.2784, 37.83694], [-122.27842, 37.837], [-122.2785, 37.83709], [-122.2786, 37.83711], [-122.27861, 37.83715], [-122.27854, 37.83717], [-122.2786, 37.83719], [-122.27862, 37.83725]], [[-122.27837, 37.8371], [-122.27839, 37.83709], [-122.27837, 37.83706], [-122.27824, 37.83693], [-122.27818, 37.8369], [-122.2781, 37.83692], [-122.2781, 37.83693], [-122.27819, 37.83697], [-122.27828, 37.83705], [-122.27837, 37.8371]]]} | Open Access 1 | 14781 | Temescal Creek Park | 26230 | 1098 | Emeryville, City of 790 | City 2 | City Agency 2 | http://www.ci.emeryville.ca.us/158/City-Parks | City 2 | 1098 | Emeryville, City of 769 | City 2 | City Agency 2 | Alameda 17 | 1.527 | Temescal Creek Park | 1972 | Local Park 2 | 4 | |
6365 | 6365 | 6364 | {"type": "Polygon", "coordinates": [[[-121.87324, 37.38089], [-121.87302, 37.38111], [-121.8729, 37.38119], [-121.87276, 37.38125], [-121.87261, 37.3813], [-121.87246, 37.38132], [-121.87229, 37.38132], [-121.87214, 37.3813], [-121.87199, 37.38126], [-121.87182, 37.38118], [-121.87145, 37.38088], [-121.87135, 37.38077], [-121.87127, 37.38064], [-121.87123, 37.38044], [-121.87324, 37.38089]]]} | Open Access 1 | 1900 | Vinci Park | 27130 | 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.295 | Vinci Park | 1972 | Local Park 2 | 4 | |
8850 | 8850 | 8849 | {"type": "Polygon", "coordinates": [[[-122.31686, 38.3307], [-122.31648, 38.33101], [-122.3164, 38.33098], [-122.31619, 38.3307], [-122.31612, 38.33066], [-122.31613, 38.33062], [-122.31599, 38.33046], [-122.3158, 38.33025], [-122.31567, 38.33021], [-122.31517, 38.32963], [-122.3157, 38.32936], [-122.31686, 38.3307]]]} | Open Access 1 | 14466 | Klamath Park | 20685 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.352 | Klamath Park | 1972 | Local Park 2 | 4 | |
8866 | 8866 | 8865 | {"type": "Polygon", "coordinates": [[[-121.96063, 37.28436], [-121.96048, 37.28438], [-121.96041, 37.2843], [-121.96029, 37.28428], [-121.96018, 37.28432], [-121.96012, 37.28441], [-121.96008, 37.28444], [-121.9586, 37.28465], [-121.9579, 37.28199], [-121.95721, 37.28139], [-121.95575, 37.2814], [-121.95575, 37.28072], [-121.95599, 37.28069], [-121.95626, 37.28062], [-121.95651, 37.28049], [-121.95685, 37.28025], [-121.95701, 37.28022], [-121.95715, 37.28028], [-121.9579, 37.28083], [-121.95956, 37.28238], [-121.9598, 37.28262], [-121.96001, 37.28288], [-121.9602, 37.28316], [-121.96042, 37.2836], [-121.96053, 37.2839], [-121.96063, 37.28436]]]} | Open Access 1 | 14514 | John D. Morgan Park | 20434 | 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 | 18.397 | John D. Morgan Park | 1972 | Local Park 2 | 4 | |
8918 | 8918 | 8917 | {"type": "Polygon", "coordinates": [[[-122.00749, 37.28292], [-122.00732, 37.28324], [-122.00725, 37.28341], [-122.00677, 37.28341], [-122.00676, 37.28291], [-122.00749, 37.28292]]]} | Open Access 1 | 14630 | Brookglen Park | 16421 | 1326 | Saratoga, City of 520 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | Santa Clara 19 | 0.725 | Brookglen Park | 1972 | Local Park 2 | 4 | |
9340 | 9340 | 9339 | {"type": "Polygon", "coordinates": [[[-122.46686, 37.66099], [-122.4665, 37.66111], [-122.46638, 37.66086], [-122.46652, 37.66082], [-122.4667, 37.66082], [-122.46677, 37.66079], [-122.46686, 37.66099]]]} | Open Access 1 | 15607 | Norwood Park | 22907 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 0.228 | Norwood Park | 1972 | Local Park 2 | 4 | |
10182 | 10182 | 10181 | {"type": "Polygon", "coordinates": [[[-122.06507, 37.31451], [-122.06468, 37.31447], [-122.06458, 37.31473], [-122.06457, 37.31479], [-122.06453, 37.31481], [-122.06441, 37.31482], [-122.06442, 37.31515], [-122.06431, 37.31515], [-122.0643, 37.31518], [-122.06399, 37.31518], [-122.06364, 37.31557], [-122.06362, 37.3156], [-122.06364, 37.31577], [-122.0634, 37.31566], [-122.06327, 37.31562], [-122.06277, 37.31562], [-122.06254, 37.31558], [-122.06236, 37.31551], [-122.06235, 37.31535], [-122.06217, 37.31527], [-122.0619, 37.31506], [-122.06179, 37.31479], [-122.06128, 37.31465], [-122.06149, 37.31457], [-122.0613, 37.31345], [-122.06164, 37.31332], [-122.06201, 37.31325], [-122.06226, 37.31318], [-122.06315, 37.31282], [-122.06344, 37.31279], [-122.06363, 37.31282], [-122.06374, 37.31286], [-122.06426, 37.31311], [-122.0648, 37.31329], [-122.06492, 37.31335], [-122.06502, 37.31344], [-122.06509, 37.31354], [-122.06513, 37.31365], [-122.06515, 37.31389], [-122.06514, 37.31417], [-122.06507, 37.31451]]]} | Open Access 1 | 17773 | McClellan Ranch Park | 22000 | 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 | 18.972 | McClellan Ranch Park | 1972 | 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]);