units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where ACCESS_TYP = 1, MNG_AGENCY = 411 and YR_EST = 1973
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
- City Agency 13
ACCESS_TYP 1
- Open Access · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1744 | 1744 | 1743 | {"type": "Polygon", "coordinates": [[[-121.88461, 37.43237], [-121.88435, 37.43242], [-121.88427, 37.4322], [-121.88428, 37.43213], [-121.88432, 37.43208], [-121.88439, 37.43203], [-121.88449, 37.43201], [-121.88461, 37.43237]]]} | Open Access 1 | 14998 | Selwyn Park | 25293 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 0.227 | Selwyn Park | 1973 | Local Park 2 | 4 | |
1950 | 1950 | 1949 | {"type": "Polygon", "coordinates": [[[-121.87669, 37.4267], [-121.87498, 37.42707], [-121.87494, 37.42706], [-121.87495, 37.42699], [-121.87476, 37.42644], [-121.87469, 37.42638], [-121.87473, 37.42633], [-121.87455, 37.42582], [-121.8745, 37.42579], [-121.87451, 37.42571], [-121.87432, 37.42517], [-121.8743, 37.42514], [-121.87425, 37.4251], [-121.87428, 37.42506], [-121.8741, 37.42453], [-121.87423, 37.42451], [-121.87438, 37.42468], [-121.87441, 37.42469], [-121.87517, 37.42452], [-121.87517, 37.4243], [-121.87527, 37.42428], [-121.8754, 37.42466], [-121.87527, 37.42488], [-121.87547, 37.4251], [-121.87542, 37.42514], [-121.87538, 37.42518], [-121.87537, 37.42522], [-121.87539, 37.42528], [-121.87581, 37.42574], [-121.87588, 37.42577], [-121.87589, 37.42582], [-121.87629, 37.42626], [-121.87636, 37.42627], [-121.87637, 37.42635], [-121.87669, 37.4267]]]} | Open Access 1 | 15011 | Murphy Park | 22608 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 7.798 | Murphy Park | 1973 | Local Park 2 | 4 | |
5418 | 5418 | 5417 | {"type": "Polygon", "coordinates": [[[-121.8988, 37.45054], [-121.8986, 37.45066], [-121.89844, 37.45038], [-121.89824, 37.45045], [-121.89799, 37.45049], [-121.89792, 37.4502], [-121.89827, 37.45014], [-121.89814, 37.44962], [-121.89803, 37.44943], [-121.8956, 37.44692], [-121.89593, 37.4469], [-121.89822, 37.44927], [-121.89829, 37.44931], [-121.89836, 37.4494], [-121.89846, 37.44943], [-121.89854, 37.44942], [-121.89861, 37.44938], [-121.89867, 37.44929], [-121.8988, 37.44927], [-121.899, 37.44927], [-121.89915, 37.44931], [-121.89919, 37.44933], [-121.89921, 37.4494], [-121.8988, 37.45054]]]} | Open Access 1 | 14971 | Sandalwood Park | 25014 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 4.668 | Sandalwood Park | 1973 | Local Park 2 | 4 | |
9027 | 9027 | 9026 | {"type": "Polygon", "coordinates": [[[-121.90435, 37.45781], [-121.90357, 37.45808], [-121.90341, 37.45809], [-121.9031, 37.45827], [-121.90308, 37.45825], [-121.90337, 37.45806], [-121.90247, 37.45707], [-121.90199, 37.45642], [-121.9025, 37.45622], [-121.90329, 37.45598], [-121.90435, 37.45781]]]} | Open Access 1 | 14962 | Albert Augustine Park | 15337 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 6.105 | Albert Augustine Park | 1973 | Local Park 2 | 4 | |
9047 | 9047 | 9046 | {"type": "Polygon", "coordinates": [[[-121.91419, 37.44264], [-121.91413, 37.44265], [-121.91413, 37.4427], [-121.91412, 37.44271], [-121.91413, 37.44284], [-121.91417, 37.44284], [-121.91418, 37.44297], [-121.91415, 37.44298], [-121.91415, 37.443], [-121.91391, 37.44302], [-121.91383, 37.44309], [-121.91378, 37.44307], [-121.91369, 37.44306], [-121.91354, 37.44309], [-121.9126, 37.44315], [-121.91221, 37.44319], [-121.9113, 37.44186], [-121.91167, 37.4414], [-121.91219, 37.44072], [-121.91219, 37.44142], [-121.91342, 37.44145], [-121.91343, 37.44134], [-121.91404, 37.44136], [-121.91404, 37.44152], [-121.91411, 37.44218], [-121.91407, 37.44219], [-121.9141, 37.44249], [-121.91416, 37.4425], [-121.91416, 37.44258], [-121.91419, 37.44264]]]} | Open Access 1 | 14974 | Hall Memorial Park | 19606 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 10.502 | Hall Memorial Park | 1973 | Local Park 2 | 4 | |
9049 | 9049 | 9048 | {"type": "Polygon", "coordinates": [[[-121.89603, 37.44665], [-121.89539, 37.44669], [-121.89337, 37.44461], [-121.89368, 37.44304], [-121.89396, 37.44307], [-121.89366, 37.44455], [-121.89463, 37.44555], [-121.89536, 37.44528], [-121.89574, 37.44556], [-121.8957, 37.44559], [-121.89568, 37.44565], [-121.89573, 37.44623], [-121.89577, 37.44629], [-121.89583, 37.44632], [-121.896, 37.44632], [-121.89603, 37.44665]]]} | Open Access 1 | 14991 | Walter Reuther Park | 27247 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 4.913 | Walter Reuther Park | 1973 | Local Park 2 | 4 | |
9050 | 9050 | 9049 | {"type": "Polygon", "coordinates": [[[-121.87348, 37.42105], [-121.87306, 37.42114], [-121.873, 37.42095], [-121.87255, 37.42105], [-121.87214, 37.42074], [-121.87225, 37.42063], [-121.87232, 37.4205], [-121.87237, 37.42036], [-121.87238, 37.42022], [-121.87236, 37.42008], [-121.87231, 37.41994], [-121.87222, 37.41982], [-121.87204, 37.41966], [-121.87223, 37.41947], [-121.87216, 37.41924], [-121.87239, 37.41914], [-121.87245, 37.41915], [-121.87261, 37.41922], [-121.87273, 37.41926], [-121.87291, 37.41926], [-121.87308, 37.41923], [-121.87329, 37.41988], [-121.87336, 37.41994], [-121.87347, 37.41995], [-121.87333, 37.42057], [-121.87348, 37.42105]]]} | Open Access 1 | 15008 | Sinnott Park | 25519 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 4.684 | Sinnott Park | 1973 | Local Park 2 | 4 | |
9052 | 9052 | 9051 | {"type": "Polygon", "coordinates": [[[-121.91609, 37.43119], [-121.915, 37.43135], [-121.91492, 37.43133], [-121.9149, 37.4313], [-121.91464, 37.43027], [-121.91461, 37.43009], [-121.91461, 37.4299], [-121.9148, 37.42992], [-121.91572, 37.43029], [-121.91593, 37.43053], [-121.91609, 37.43119]]]} | Open Access 1 | 14982 | Starlite Park | 25807 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 3.463 | Starlite Park | 1973 | Local Park 2 | 4 | |
9057 | 9057 | 9056 | {"type": "Polygon", "coordinates": [[[-121.88581, 37.44192], [-121.88306, 37.44251], [-121.88177, 37.43851], [-121.88258, 37.43834], [-121.88292, 37.43833], [-121.88319, 37.43838], [-121.88339, 37.43847], [-121.88461, 37.43821], [-121.88581, 37.44192]]]} | Open Access 1 | 14996 | Cardoza Park | 16848 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 27.457 | Cardoza Park | 1973 | Local Park 2 | 4 | |
9059 | 9059 | 9058 | {"type": "Polygon", "coordinates": [[[-121.87665, 37.43119], [-121.87414, 37.43175], [-121.87409, 37.4316], [-121.87446, 37.43152], [-121.87426, 37.43094], [-121.87555, 37.43066], [-121.87569, 37.43072], [-121.87643, 37.43056], [-121.87665, 37.43119]]]} | Open Access 1 | 14999 | Foothill Park | 18977 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 4.004 | Foothill Park | 1973 | Local Park 2 | 4 | |
9060 | 9060 | 9059 | {"type": "Polygon", "coordinates": [[[-121.86868, 37.42908], [-121.86866, 37.42913], [-121.86821, 37.42913], [-121.86811, 37.42885], [-121.86779, 37.42872], [-121.86771, 37.429], [-121.86767, 37.429], [-121.86761, 37.42873], [-121.8668, 37.42895], [-121.86674, 37.42899], [-121.86671, 37.42896], [-121.86679, 37.42889], [-121.8667, 37.42863], [-121.86709, 37.42853], [-121.867, 37.42827], [-121.86694, 37.42825], [-121.86695, 37.42817], [-121.86677, 37.42764], [-121.86672, 37.42758], [-121.86679, 37.42751], [-121.86669, 37.42724], [-121.86672, 37.42722], [-121.86654, 37.42696], [-121.86649, 37.42693], [-121.86654, 37.42675], [-121.86654, 37.42662], [-121.86652, 37.42643], [-121.86653, 37.42632], [-121.86656, 37.4262], [-121.86664, 37.42605], [-121.86669, 37.42604], [-121.86701, 37.42607], [-121.86727, 37.42605], [-121.86762, 37.42703], [-121.86798, 37.42704], [-121.86794, 37.42709], [-121.86794, 37.42716], [-121.868, 37.42722], [-121.86807, 37.42725], [-121.86809, 37.42751], [-121.86819, 37.42778], [-121.86824, 37.42781], [-121.86823, 37.42784], [-121.86823, 37.42789], [-121.86842, 37.42842], [-121.86847, 37.42849], [-121.86845, 37.42854], [-121.86863, 37.42906], [-121.86868, 37.42908]]]} | Open Access 1 | 15000 | Ben Rogers Park | 16003 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 8.681 | Ben Rogers Park | 1973 | Local Park 2 | 4 | |
9069 | 9069 | 9068 | {"type": "Polygon", "coordinates": [[[-121.87716, 37.42305], [-121.8772, 37.42313], [-121.87718, 37.42318], [-121.87715, 37.42321], [-121.87623, 37.42374], [-121.87588, 37.42391], [-121.87549, 37.42403], [-121.87405, 37.42435], [-121.87385, 37.4237], [-121.87716, 37.42305]]]} | Open Access 1 | 15010 | Yellowstone Park | 27768 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 4.333 | Yellowstone Park | 1973 | Local Park 2 | 4 | |
9071 | 9071 | 9070 | {"type": "Polygon", "coordinates": [[[-121.8818, 37.42393], [-121.88153, 37.42402], [-121.88146, 37.42415], [-121.88135, 37.42414], [-121.88138, 37.42376], [-121.88118, 37.42355], [-121.8811, 37.42354], [-121.88108, 37.42348], [-121.88065, 37.42301], [-121.88054, 37.42298], [-121.88033, 37.42275], [-121.88002, 37.42252], [-121.87991, 37.42253], [-121.87984, 37.4224], [-121.8798, 37.42217], [-121.88001, 37.42207], [-121.88004, 37.42211], [-121.88011, 37.42213], [-121.88022, 37.42212], [-121.88027, 37.42208], [-121.8803, 37.42205], [-121.8803, 37.42199], [-121.88028, 37.42195], [-121.88051, 37.42183], [-121.8808, 37.42184], [-121.8808, 37.42188], [-121.88084, 37.42194], [-121.8809, 37.42197], [-121.88095, 37.42198], [-121.88102, 37.42197], [-121.88108, 37.42193], [-121.88114, 37.42196], [-121.88151, 37.42189], [-121.88161, 37.42223], [-121.88136, 37.4225], [-121.88158, 37.42323], [-121.88168, 37.42327], [-121.88167, 37.42335], [-121.88172, 37.42342], [-121.88166, 37.42347], [-121.8818, 37.42393]]]} | Open Access 1 | 15013 | Creighton Park | 17790 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 5.06 | Creighton Park | 1973 | 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]);