units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 1999
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2567 | 2567 | 2566 | {"type": "Polygon", "coordinates": [[[-121.81491, 37.31728], [-121.81229, 37.31735], [-121.81162, 37.31721], [-121.81136, 37.31723], [-121.80948, 37.31751], [-121.80948, 37.31745], [-121.80962, 37.31726], [-121.80962, 37.31714], [-121.81091, 37.31695], [-121.81093, 37.31699], [-121.812, 37.31683], [-121.81359, 37.31577], [-121.81397, 37.31591], [-121.81396, 37.31597], [-121.81399, 37.31612], [-121.81404, 37.31626], [-121.81417, 37.31643], [-121.81442, 37.31671], [-121.81474, 37.31702], [-121.81491, 37.31728]]]} | Open Access 1 | 17850 | Meadowfair Park | 22085 | 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.727 | Meadowfair Park | 1999 | Local Park 2 | 4 | |
6741 | 6741 | 6740 | {"type": "MultiPolygon", "coordinates": [[[[-121.87194, 37.64739], [-121.87184, 37.64769], [-121.87168, 37.64784], [-121.87161, 37.64812], [-121.87143, 37.64811], [-121.87124, 37.64811], [-121.87109, 37.64787], [-121.87092, 37.64767], [-121.87067, 37.64752], [-121.87044, 37.64734], [-121.86941, 37.64669], [-121.86909, 37.64642], [-121.86933, 37.64636], [-121.86961, 37.64634], [-121.87065, 37.64645], [-121.8706, 37.64677], [-121.87138, 37.64686], [-121.8716, 37.64691], [-121.8716, 37.64693], [-121.87176, 37.64705], [-121.87187, 37.64719], [-121.87194, 37.64739]]], [[[-121.87319, 37.65007], [-121.87297, 37.65046], [-121.87262, 37.65034], [-121.87256, 37.65055], [-121.87075, 37.64993], [-121.87068, 37.64995], [-121.87046, 37.65015], [-121.87027, 37.65039], [-121.8702, 37.65037], [-121.87017, 37.65033], [-121.87018, 37.6503], [-121.87068, 37.64963], [-121.87078, 37.64946], [-121.87091, 37.64906], [-121.87095, 37.64884], [-121.87097, 37.64865], [-121.87093, 37.64838], [-121.87098, 37.64834], [-121.87129, 37.64827], [-121.87147, 37.64827], [-121.87169, 37.64831], [-121.87189, 37.6484], [-121.87203, 37.6485], [-121.8721, 37.64859], [-121.87217, 37.64869], [-121.87225, 37.64898], [-121.87229, 37.64906], [-121.87236, 37.64915], [-121.87246, 37.64923], [-121.87259, 37.6493], [-121.87274, 37.64935], [-121.87285, 37.64937], [-121.87276, 37.64976], [-121.87314, 37.64979], [-121.87313, 37.64985], [-121.87307, 37.64992], [-121.87306, 37.64997], [-121.87311, 37.65004], [-121.87319, 37.65007]]]]} | Open Access 1 | 5080 | Mission Hills Park | 22300 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 13.718 | Mission Hills Park | 1999 | Local Park 2 | 4 | |
8581 | 8581 | 8580 | {"type": "Polygon", "coordinates": [[[-121.89681, 37.35637], [-121.896, 37.35675], [-121.8946, 37.35487], [-121.89458, 37.35484], [-121.8946, 37.35479], [-121.89463, 37.35476], [-121.89528, 37.35445], [-121.89534, 37.35444], [-121.89539, 37.35446], [-121.89681, 37.35637]]]} | Open Access 1 | 13630 | Bernal Park | 16029 | 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.214 | Bernal Park | 1999 | Local Park 2 | 4 | |
8605 | 8605 | 8604 | {"type": "Polygon", "coordinates": [[[-121.85388, 37.32993], [-121.85219, 37.33108], [-121.85189, 37.33079], [-121.85358, 37.32963], [-121.85388, 37.32993]]]} | Open Access 1 | 13694 | McLaughlin Park | 22053 | 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.063 | McLaughlin Park | 1999 | Local Park 2 | 4 | |
8806 | 8806 | 8805 | {"type": "MultiPolygon", "coordinates": [[[[-122.29626, 37.49513], [-122.29533, 37.49497], [-122.29554, 37.49456], [-122.29556, 37.49432], [-122.29538, 37.49415], [-122.29519, 37.49415], [-122.29569, 37.49395], [-122.29607, 37.49464], [-122.29626, 37.49513]]], [[[-122.29714, 37.49365], [-122.29613, 37.49413], [-122.29593, 37.49384], [-122.29572, 37.4936], [-122.29544, 37.49334], [-122.2952, 37.49317], [-122.29593, 37.49249], [-122.2964, 37.4927], [-122.29714, 37.49365]]]]} | Open Access 1 | 14329 | Vista Park | 27184 | 1295 | San Carlos, City of 438 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | San Mateo 15 | 5.356 | Vista Park | 1999 | Local Park 2 | 4 | |
8838 | 8838 | 8837 | {"type": "Polygon", "coordinates": [[[-122.27532, 38.3019], [-122.27529, 38.30218], [-122.27527, 38.30222], [-122.27509, 38.30234], [-122.27503, 38.30233], [-122.27496, 38.30228], [-122.27477, 38.30207], [-122.27525, 38.30186], [-122.27529, 38.30188], [-122.27532, 38.3019]]]} | Open Access 1 | 14442 | Evans Park | 18755 | 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 | 0.373 | Evans Park | 1999 | Local Park 2 | 4 | |
9234 | 9234 | 9233 | {"type": "Polygon", "coordinates": [[[-121.89309, 37.24407], [-121.89147, 37.24481], [-121.891, 37.24416], [-121.89087, 37.244], [-121.8906, 37.24374], [-121.89032, 37.24354], [-121.8905, 37.24335], [-121.89078, 37.24288], [-121.891, 37.24257], [-121.89119, 37.24236], [-121.89147, 37.24214], [-121.89181, 37.24244], [-121.89218, 37.24285], [-121.89216, 37.24288], [-121.89264, 37.24344], [-121.89309, 37.24407]]]} | Open Access 1 | 15425 | De Anza | 17965 | 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.242 | De Anza | 1999 | None 761 | ||
15997 | 15997 | 15996 | {"type": "MultiPolygon", "coordinates": [[[[-122.17097, 38.14107], [-122.17086, 38.14153], [-122.17007, 38.14193], [-122.17015, 38.14258], [-122.16941, 38.14362], [-122.16924, 38.14268], [-122.16917, 38.14194], [-122.17097, 38.14107]]], [[[-122.17703, 38.16025], [-122.17606, 38.16017], [-122.17525, 38.16013], [-122.17469, 38.16007], [-122.17443, 38.16012], [-122.17416, 38.16015], [-122.17404, 38.16012], [-122.17383, 38.16026], [-122.17376, 38.1604], [-122.17374, 38.16049], [-122.1738, 38.16069], [-122.17395, 38.16075], [-122.17418, 38.16072], [-122.17428, 38.16078], [-122.17443, 38.16074], [-122.17467, 38.16109], [-122.17556, 38.16105], [-122.17606, 38.16114], [-122.17606, 38.16141], [-122.17601, 38.16171], [-122.17599, 38.16225], [-122.1759, 38.16316], [-122.17585, 38.16338], [-122.17627, 38.1639], [-122.17641, 38.16401], [-122.17633, 38.16426], [-122.1763, 38.16452], [-122.17619, 38.16479], [-122.17601, 38.16505], [-122.17581, 38.16529], [-122.17466, 38.166], [-122.17436, 38.16604], [-122.17419, 38.16594], [-122.17403, 38.16576], [-122.17383, 38.16564], [-122.17368, 38.16566], [-122.17331, 38.16583], [-122.17308, 38.16588], [-122.17224, 38.16075], [-122.17088, 38.15287], [-122.1697, 38.1454], [-122.17062, 38.14401], [-122.17114, 38.14481], [-122.17109, 38.14497], [-122.17141, 38.1462], [-122.17171, 38.14626], [-122.17174, 38.14654], [-122.17208, 38.14665], [-122.17219, 38.14677], [-122.17229, 38.14714], [-122.17263, 38.14747], [-122.17287, 38.14785], [-122.17325, 38.14893], [-122.17321, 38.14934], [-122.17363, 38.14981], [-122.17402, 38.15021], [-122.17414, 38.15071], [-122.1746, 38.151], [-122.17488, 38.15096], [-122.17509, 38.15084], [-122.17526, 38.15092], [-122.17509, 38.15122], [-122.17495, 38.15138], [-122.17453, 38.15197], [-122.17431, 38.15218], [-122.17462, 38.15269], [-122.17464, 38.15288], [-122.17473, 38.15331], [-122.17479, 38.15369], [-122.17499, 38.15364], [-122.17533, 38.15345], [-122.17562, 38.15326], [-122.1757, 38.1534], [-122.17565, 38.15351], [-122.17531, 38.15377], [-122.17527, 38.15394], [-122.17494, 38.15426], [-122.17501, 38.15451], [-122.17504, 38.15479], [-122.17515, 38.15534], [-122.17497, 38.1555], [-122.1749, 38.15568], [-122.17488, 38.15581], [-122.17482, 38.15618], [-122.17483, 38.15743], [-122.17518, 38.1575], [-122.17524, 38.1581], [-122.17386, 38.15839], [-122.17368, 38.15926], [-122.17362, 38.15976], [-122.17461, 38.15983], [-122.17512, 38.15978], [-122.17545, 38.15966], [-122.17558, 38.15986], [-122.17601, 38.15994], [-122.17701, 38.16005], [-122.17703, 38.16025]]], [[[-122.19871, 38.15935], [-122.19863, 38.15957], [-122.19852, 38.15972], [-122.19836, 38.15986], [-122.19805, 38.16004], [-122.1977, 38.16037], [-122.1972, 38.1608], [-122.19696, 38.16076], [-122.1962, 38.16052], [-122.19562, 38.16018], [-122.19552, 38.16006], [-122.19563, 38.16011], [-122.19621, 38.15972], [-122.19748, 38.15907], [-122.19787, 38.15879], [-122.19807, 38.15873], [-122.19815, 38.15852], [-122.19803, 38.15828], [-122.19765, 38.15812], [-122.19699, 38.15833], [-122.19684, 38.15851], [-122.19661, 38.15839], [-122.19649, 38.15805], [-122.19654, 38.15784], [-122.19688, 38.15766], [-122.19704, 38.15751], [-122.19689, 38.15721], [-122.19658, 38.15711], [-122.19635, 38.15699], [-122.19605, 38.15677], [-122.19582, 38.15659], [-122.19559, 38.15653], [-122.19517, 38.15631], [-122.19501, 38.15613], [-122.19471, 38.15588], [-122.19452, 38.15554], [-122.19445, 38.15522], [-122.19428, 38.15519], [-122.19371, 38.15469], [-122.19337, 38.1545], [-122.19293, 38.15442], [-122.19244, 38.15451], [-122.19126, 38.15486], [-122.19053, 38.15524], [-122.19035, 38.15539], [-122.19033, 38.15578], [-122.18966, 38.15666], [-122.18964, 38.15666], [-122.18969, 38.15685], [-122.19003, 38.15725], [-122.19084, 38.15765], [-122.19261, 38.15787], [-122.19357, 38.15779], [-122.1945, 38.15749], [-122.1948, 38.15753], [-122.19557, 38.15832], [-122.19483, 38.15889], [-122.1943, 38.15889], [-122.19386, 38.15892], [-122.19294, 38.15912], [-122.19251, 38.15915], [-122.19186, 38.15927], [-122.1902, 38.15932], [-122.18959, 38.1584], [-122.18749, 38.15742], [-122.18629, 38.15759], [-122.18606, 38.15728], [-122.1856, 38.15679], [-122.18526, 38.15655], [-122.18482, 38.15487], [-122.18501, 38.15484], [-122.18516, 38.15508], [-122.18527, 38.15533], [-122.18562, 38.15567], [-122.18592, 38.15588], [-122.18673, 38.15586], [-122.18724, 38.15562], [-122.18751, 38.15544], [-122.18786, 38.15516], [-122.1878, 38.15456], [-122.18717, 38.1533], [-122.18448, 38.15092], [-122.18364, 38.15098], [-122.18303, 38.15105], [-122.18247, 38.15104], [-122.18055, 38.15133], [-122.18025, 38.1514], [-122.17987, 38.15157], [-122.17959, 38.15125], [-122.18044, 38.15112], [-122.1811, 38.15097], [-122.18226, 38.15065], [-122.18264, 38.15038], [-122.18298, 38.15003], [-122.18396, 38.14997], [-122.1843, 38.14958], [-122.18474, 38.14932], [-122.18614, 38.14861], [-122.18513, 38.14698], [-122.18419, 38.14666], [-122.18367, 38.14722], [-122.18229, 38.14795], [-122.18184, 38.14809], [-122.18139, 38.14809], [-122.18102, 38.14804], [-122.18004, 38.14741], [-122.18006, 38.14722], [-122.17993, 38.14702], [-122.17983, 38.14678], [-122.18028, 38.14638], [-122.18046, 38.14598], [-122.18001, 38.14568], [-122.17964, 38.14599], [-122.17882, 38.14558], [-122.17866, 38.14512], [-122.17672, 38.14431], [-122.17648, 38.14391], [-122.17604, 38.14393], [-122.17526, 38.1438], [-122.17486, 38.14381], [-122.1745, 38.14357], [-122.17468, 38.14288], [-122.17497, 38.14279], [-122.1754, 38.14256], [-122.1754, 38.14254], [-122.17514, 38.14221], [-122.17483, 38.14193], [-122.17434, 38.142], [-122.17389, 38.14146], [-122.17369, 38.14143], [-122.17344, 38.14131], [-122.17304, 38.14097], [-122.17272, 38.14139], [-122.17218, 38.14136], [-122.17248, 38.14069], [-122.17291, 38.14042], [-122.17323, 38.14032], [-122.17439, 38.14115], [-122.17709, 38.14318], [-122.18073, 38.14577], [-122.18048, 38.14596], [-122.18048, 38.14598], [-122.181, 38.14603], [-122.18197, 38.14671], [-122.18499, 38.14511], [-122.19094, 38.14174], [-122.1916, 38.14396], [-122.19183, 38.14502], [-122.19361, 38.14526], [-122.19342, 38.14641], [-122.19344, 38.14685], [-122.19363, 38.14756], [-122.19366, 38.14792], [-122.19374, 38.14817], [-122.19425, 38.14846], [-122.19385, 38.1495], [-122.19366, 38.1501], [-122.19533, 38.15225], [-122.19571, 38.15271], [-122.19593, 38.15296], [-122.19627, 38.15434], [-122.1961, 38.15471], [-122.19561, 38.15479], [-122.19556, 38.15487], [-122.19532, 38.15487], [-122.19526, 38.15506], [-122.19526, 38.15524], [-122.19532, 38.15531], [-122.19529, 38.15537], [-122.19548, 38.15558], [-122.1957, 38.15573], [-122.19578, 38.15581], [-122.19695, 38.15655], [-122.19726, 38.15679], [-122.19741, 38.15688], [-122.19754, 38.157], [-122.19758, 38.15707], [-122.1977, 38.15739], [-122.19789, 38.1577], [-122.19808, 38.15798], [-122.19841, 38.15838], [-122.19851, 38.15896], [-122.19868, 38.15919], [-122.19871, 38.15935]], [[-122.19236, 38.15205], [-122.19302, 38.15155], [-122.19134, 38.14984], [-122.18977, 38.1493], [-122.19132, 38.15093], [-122.19236, 38.15205]]], [[[-122.19538, 38.16025], [-122.19392, 38.16102], [-122.19345, 38.15933], [-122.19093, 38.15984], [-122.1914, 38.16222], [-122.19097, 38.16252], [-122.18605, 38.16501], [-122.18458, 38.16552], [-122.18126, 38.1665], [-122.18032, 38.16692], [-122.17906, 38.16745], [-122.17755, 38.16812], [-122.17541, 38.16897], [-122.1737, 38.1696], [-122.17352, 38.16878], [-122.17347, 38.16778], [-122.17363, 38.16787], [-122.17406, 38.16799], [-122.17428, 38.16793], [-122.17565, 38.16731], [-122.17617, 38.16705], [-122.17675, 38.16674], [-122.17742, 38.16634], [-122.17839, 38.16615], [-122.17868, 38.16627], [-122.17939, 38.16663], [-122.17971, 38.16667], [-122.17995, 38.16667], [-122.1803, 38.16631], [-122.18072, 38.16604], [-122.1813, 38.16562], [-122.18188, 38.16538], [-122.18354, 38.16551], [-122.18454, 38.16533], [-122.18535, 38.16513], [-122.1859, 38.16486], [-122.18636, 38.1645], [-122.18675, 38.16429], [-122.18679, 38.16404], [-122.18691, 38.1638], [-122.18722, 38.1638], [-122.18738, 38.16386], [-122.18768, 38.16377], [-122.18783, 38.16366], [-122.18768, 38.16338], [-122.18696, 38.16334], [-122.18688, 38.1631], [-122.18765, 38.16295], [-122.18897, 38.16266], [-122.18989, 38.16242], [-122.19025, 38.16215], [-122.19074, 38.16194], [-122.19063, 38.16179], [-122.1906, 38.16145], [-122.19075, 38.16115], [-122.19037, 38.16099], [-122.19027, 38.16023], [-122.19012, 38.15956], [-122.19135, 38.15948], [-122.19224, 38.15939], [-122.1934, 38.15918], [-122.1934, 38.15913], [-122.19394, 38.15907], [-122.19421, 38.1591], [-122.19436, 38.15938], [-122.19459, 38.15968], [-122.19501, 38.15993], [-122.19524, 38.16011], [-122.1953, 38.16009], [-122.19538, 38.16025]]]]} | Open Access 1 | 896 | Hiddenbrooke Open Space | 14435 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 547.175 | Hiddenbrooke OS | 1999 | 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]);