units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where DES_TP = 2 and YR_EST = 1965
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
783 | 783 | 782 | {"type": "Polygon", "coordinates": [[[-122.09551, 37.63544], [-122.09549, 37.63615], [-122.0955, 37.63682], [-122.09501, 37.63684], [-122.09505, 37.63746], [-122.09413, 37.63754], [-122.0942, 37.63815], [-122.09387, 37.63819], [-122.09387, 37.63901], [-122.09249, 37.63911], [-122.09222, 37.63912], [-122.0919, 37.63901], [-122.09449, 37.63532], [-122.09496, 37.63539], [-122.09551, 37.63544]]]} | Open Access 1 | 5069 | Southgate Park | 25689 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 14.46 | Southgate Park | 1965 | Local Park 2 | 4 | |
2732 | 2732 | 2731 | {"type": "Polygon", "coordinates": [[[-122.02779, 37.34303], [-122.02552, 37.34304], [-122.02544, 37.343], [-122.02535, 37.34299], [-122.02399, 37.34299], [-122.02391, 37.343], [-122.0238, 37.34305], [-122.02333, 37.34305], [-122.02333, 37.34134], [-122.02391, 37.3413], [-122.02779, 37.3413], [-122.02779, 37.34303]]]} | Open Access 1 | 18370 | Ortega Park | 23227 | 1345 | Sunnyvale, City of 419 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | Santa Clara 19 | 18.602 | Ortega Park | 1965 | Local Park 2 | 4 | |
4164 | 4164 | 4163 | {"type": "Polygon", "coordinates": [[[-122.15709, 37.29222], [-122.15694, 37.29781], [-122.15191, 37.29801], [-122.13507, 37.29727], [-122.13513, 37.29368], [-122.12847, 37.29362], [-122.12844, 37.2829], [-122.12328, 37.28294], [-122.12327, 37.27902], [-122.13449, 37.27921], [-122.1343, 37.27166], [-122.13365, 37.26267], [-122.13387, 37.26277], [-122.13405, 37.26288], [-122.1342, 37.26301], [-122.13434, 37.26319], [-122.13528, 37.26524], [-122.13545, 37.26551], [-122.13559, 37.26569], [-122.13581, 37.26589], [-122.13604, 37.26604], [-122.13623, 37.26613], [-122.13713, 37.2665], [-122.13741, 37.26666], [-122.13763, 37.26681], [-122.13787, 37.26701], [-122.13807, 37.26723], [-122.13862, 37.26795], [-122.13881, 37.26817], [-122.13907, 37.26841], [-122.13937, 37.26865], [-122.13962, 37.26883], [-122.13992, 37.26901], [-122.14025, 37.26917], [-122.14054, 37.26929], [-122.14095, 37.26941], [-122.14327, 37.27001], [-122.14332, 37.27229], [-122.14345, 37.27662], [-122.14393, 37.2764], [-122.14422, 37.27631], [-122.1447, 37.27609], [-122.1449, 37.27609], [-122.14524, 37.27593], [-122.14558, 37.27594], [-122.14583, 37.27603], [-122.14601, 37.27617], [-122.14651, 37.27608], [-122.14667, 37.27679], [-122.1467, 37.27712], [-122.14681, 37.27748], [-122.14726, 37.27774], [-122.14746, 37.27806], [-122.14755, 37.27894], [-122.14934, 37.27891], [-122.1493, 37.27906], [-122.14923, 37.27923], [-122.14892, 37.27964], [-122.14725, 37.28033], [-122.14749, 37.28068], [-122.1475, 37.28076], [-122.14355, 37.28028], [-122.14373, 37.28652], [-122.15227, 37.2869], [-122.15248, 37.28838], [-122.1526, 37.28879], [-122.15254, 37.28883], [-122.15235, 37.28909], [-122.15337, 37.2902], [-122.15393, 37.29035], [-122.1559, 37.29165], [-122.15645, 37.29195], [-122.15709, 37.29222]]]} | Open Access 1 | 1787 | Upper Stevens Creek County Park | 29311 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/parkfinder/Pages/StevensCreek.aspx | Santa Clara 19 | 1279.701 | Upper Stevens Creek County Park | 1965 | Local Park 2 | 4 |
6404 | 6404 | 6403 | {"type": "Polygon", "coordinates": [[[-122.13545, 37.42156], [-122.13539, 37.42163], [-122.13501, 37.42143], [-122.13497, 37.42147], [-122.13433, 37.42114], [-122.13446, 37.42098], [-122.13477, 37.42113], [-122.13515, 37.42068], [-122.1353, 37.42076], [-122.13529, 37.42096], [-122.13531, 37.42112], [-122.13535, 37.42128], [-122.13545, 37.42156]]]} | Open Access 1 | 1989 | Boulware Park | 16300 | 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 | 1.094 | Boulware Park | 1965 | Local Park 2 | 4 | |
6743 | 6743 | 6742 | {"type": "Polygon", "coordinates": [[[-122.06367, 37.67916], [-122.06302, 37.67937], [-122.06319, 37.67989], [-122.06191, 37.6806], [-122.06121, 37.68082], [-122.06083, 37.68007], [-122.06126, 37.67992], [-122.06086, 37.67911], [-122.0635, 37.67828], [-122.06367, 37.67916]]]} | Open Access 1 | 5083 | San Felipe Park | 24884 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 9.766 | San Felipe Park | 1965 | Local Park 2 | 4 | |
8914 | 8914 | 8913 | {"type": "Polygon", "coordinates": [[[-122.00525, 37.27052], [-122.00483, 37.2707], [-122.00477, 37.27066], [-122.00461, 37.27079], [-122.00462, 37.27097], [-122.00302, 37.27073], [-122.00301, 37.27049], [-122.00464, 37.27044], [-122.00475, 37.27042], [-122.00492, 37.27035], [-122.00514, 37.27032], [-122.00525, 37.27052]]]} | Open Access 1 | 14624 | Gardiner Park | 19210 | 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 | 1.899 | Gardiner Park | 1965 | Local Park 2 | 4 | |
9092 | 9092 | 9091 | {"type": "Polygon", "coordinates": [[[-122.02106, 37.36325], [-122.02073, 37.36357], [-122.02061, 37.36384], [-122.02016, 37.36515], [-122.01939, 37.36508], [-122.01942, 37.36502], [-122.01941, 37.36495], [-122.01936, 37.3649], [-122.01929, 37.36489], [-122.01996, 37.36297], [-122.02056, 37.36311], [-122.02056, 37.36314], [-122.02106, 37.36325]]]} | Open Access 1 | 15067 | Braly Park | 16327 | 1345 | Sunnyvale, City of 419 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | Santa Clara 19 | 4.773 | Braly Park | 1965 | Local Park 2 | 4 | |
9157 | 9157 | 9156 | {"type": "Polygon", "coordinates": [[[-122.12795, 37.4072], [-122.12739, 37.40802], [-122.12736, 37.40801], [-122.12732, 37.40803], [-122.12572, 37.40734], [-122.12569, 37.40729], [-122.12625, 37.40646], [-122.12795, 37.4072]]]} | Open Access 1 | 15202 | Briones Park | 16393 | 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.57 | Briones Park | 1965 | Local Park 2 | 4 | |
9612 | 9612 | 9611 | {"type": "Polygon", "coordinates": [[[-122.14069, 37.3925], [-122.13956, 37.39227], [-122.1395, 37.39221], [-122.1394, 37.39219], [-122.1387, 37.39224], [-122.1384, 37.39233], [-122.1383, 37.3923], [-122.13823, 37.3923], [-122.13728, 37.39099], [-122.13634, 37.39095], [-122.13633, 37.38957], [-122.13507, 37.38952], [-122.13507, 37.38854], [-122.13633, 37.38859], [-122.13695, 37.38912], [-122.13824, 37.38917], [-122.13824, 37.38964], [-122.13879, 37.38967], [-122.13879, 37.39107], [-122.14017, 37.39108], [-122.14069, 37.3925]]]} | Open Access 1 | 16180 | Esther Clark Park | 18727 | 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 | 21.824 | Esther Clark Park | 1965 | Local Park 2 | 4 | |
9980 | 9980 | 9979 | {"type": "MultiPolygon", "coordinates": [[[[-122.28084, 38.26895], [-122.28084, 38.27065], [-122.28078, 38.27066], [-122.28075, 38.27122], [-122.27676, 38.26949], [-122.27697, 38.26817], [-122.2763, 38.26736], [-122.27678, 38.26709], [-122.2782, 38.26902], [-122.28084, 38.26895]]], [[[-122.28633, 38.26048], [-122.28614, 38.2617], [-122.2858, 38.26258], [-122.2852, 38.26332], [-122.28333, 38.26476], [-122.28307, 38.26529], [-122.28421, 38.26589], [-122.28535, 38.26679], [-122.28569, 38.26761], [-122.28592, 38.26907], [-122.28652, 38.27045], [-122.28658, 38.27099], [-122.28632, 38.27184], [-122.28571, 38.27254], [-122.28367, 38.27364], [-122.2831, 38.27429], [-122.28261, 38.27516], [-122.28201, 38.27648], [-122.28188, 38.27691], [-122.28155, 38.27833], [-122.28202, 38.27914], [-122.28124, 38.28027], [-122.28108, 38.28014], [-122.28107, 38.2803], [-122.28091, 38.28017], [-122.2809, 38.27706], [-122.28092, 38.27665], [-122.28092, 38.27597], [-122.28089, 38.27503], [-122.28088, 38.27174], [-122.28091, 38.27156], [-122.28092, 38.27125], [-122.28093, 38.26712], [-122.28096, 38.26588], [-122.28097, 38.25989], [-122.28193, 38.25952], [-122.28176, 38.2591], [-122.28243, 38.25826], [-122.28334, 38.25722], [-122.28341, 38.2572], [-122.28344, 38.25727], [-122.2835, 38.25807], [-122.28363, 38.25841], [-122.28389, 38.25882], [-122.28427, 38.25916], [-122.28584, 38.25996], [-122.28633, 38.26048]]]]} | Open Access 1 | 17175 | John F. Kennedy Park | 31350 | 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 | http://www.visitnapavalley.com/hiking_biking-kennedy_park_612.htm | Napa 11 | 196.492 | John F. Kennedy Park | 1965 | 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]);