units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where ACCESS_TYP = 1, MNG_AGENCY = 32 and YR_EST = 1984
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP 4
- Local Park 9
- Local Recreation Area 1
- None 1
- None 1
ACCESS_TYP 1
- Open Access · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
444 | 444 | 443 | {"type": "MultiPolygon", "coordinates": [[[[-121.88809, 37.23293], [-121.88443, 37.23292], [-121.88436, 37.2328], [-121.88432, 37.23268], [-121.88428, 37.23249], [-121.88427, 37.23234], [-121.88429, 37.23231], [-121.88433, 37.2323], [-121.88805, 37.23232], [-121.88808, 37.23234], [-121.8881, 37.23237], [-121.88809, 37.23293]]], [[[-121.8943, 37.23234], [-121.89418, 37.23251], [-121.89397, 37.23297], [-121.89231, 37.23296], [-121.89231, 37.2329], [-121.89229, 37.23286], [-121.89224, 37.23284], [-121.89219, 37.23282], [-121.89201, 37.23288], [-121.89035, 37.23287], [-121.89019, 37.23282], [-121.8901, 37.23284], [-121.89006, 37.2329], [-121.89007, 37.23301], [-121.89006, 37.23351], [-121.89005, 37.23355], [-121.89, 37.23358], [-121.88853, 37.23362], [-121.88844, 37.23359], [-121.88836, 37.23354], [-121.88832, 37.2335], [-121.88829, 37.23342], [-121.88831, 37.2323], [-121.89136, 37.23232], [-121.89157, 37.23209], [-121.89176, 37.23215], [-121.89197, 37.23217], [-121.89217, 37.23213], [-121.89241, 37.23201], [-121.89241, 37.23233], [-121.8943, 37.23234]]]]} | Open Access 1 | 1383 | T.J. Martin | 26157 | 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 | 17.459 | T.J. Martin | 1984 | None 46 | ||
1423 | 1423 | 1422 | {"type": "MultiPolygon", "coordinates": [[[[-121.78009, 37.31127], [-121.77989, 37.31137], [-121.77994, 37.31162], [-121.77991, 37.31167], [-121.77993, 37.31173], [-121.77978, 37.31181], [-121.78003, 37.31291], [-121.77984, 37.31293], [-121.7796, 37.31189], [-121.77937, 37.31162], [-121.77968, 37.31144], [-121.78008, 37.31124], [-121.78009, 37.31127]]], [[[-121.78054, 37.31411], [-121.77993, 37.31421], [-121.77983, 37.31377], [-121.78044, 37.31368], [-121.78054, 37.31411]]], [[[-121.7802, 37.31358], [-121.78, 37.31361], [-121.7799, 37.31318], [-121.7801, 37.31315], [-121.7802, 37.31358]]], [[[-121.78046, 37.31471], [-121.78026, 37.31474], [-121.78016, 37.3143], [-121.78036, 37.31427], [-121.78046, 37.31471]]]]} | Open Access 1 | 9205 | Tapestry Park | 26184 | 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.08 | Tapestry Park | 1984 | Local Park 2 | 4 | |
3177 | 3177 | 3176 | {"type": "Polygon", "coordinates": [[[-121.85221, 37.26366], [-121.85167, 37.2637], [-121.85132, 37.26394], [-121.85132, 37.26373], [-121.8511, 37.26358], [-121.85036, 37.26427], [-121.84899, 37.26287], [-121.84939, 37.26237], [-121.84996, 37.26184], [-121.85001, 37.26183], [-121.85049, 37.26213], [-121.85077, 37.26228], [-121.85097, 37.26241], [-121.85184, 37.26308], [-121.85201, 37.26325], [-121.85208, 37.26334], [-121.85216, 37.2635], [-121.85221, 37.26366]]]} | Open Access 1 | 1912 | Vista Park | 27185 | 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.593 | Vista Park | 1984 | Local Park 2 | 4 | |
5475 | 5475 | 5474 | {"type": "Polygon", "coordinates": [[[-121.83923, 37.359], [-121.83914, 37.35909], [-121.83875, 37.35927], [-121.83871, 37.35928], [-121.83867, 37.35926], [-121.83633, 37.35687], [-121.83565, 37.35587], [-121.83599, 37.35588], [-121.83666, 37.35661], [-121.83681, 37.35652], [-121.83923, 37.359]]]} | Open Access 1 | 17405 | Lo Bue Park | 21390 | 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.833 | Lo Bue Park | 1984 | Local Park 2 | 4 | |
6077 | 6077 | 6076 | {"type": "Polygon", "coordinates": [[[-121.8399, 37.21622], [-121.83961, 37.2161], [-121.83965, 37.21605], [-121.83964, 37.21604], [-121.83923, 37.21594], [-121.83739, 37.21489], [-121.8362, 37.2147], [-121.83507, 37.21412], [-121.83433, 37.21407], [-121.83417, 37.21402], [-121.83305, 37.2138], [-121.83255, 37.21372], [-121.83138, 37.2133], [-121.82978, 37.2127], [-121.82883, 37.21165], [-121.82736, 37.2108], [-121.82611, 37.20976], [-121.8254, 37.2092], [-121.82373, 37.20715], [-121.82398, 37.20696], [-121.82419, 37.20722], [-121.82437, 37.20754], [-121.82451, 37.20773], [-121.82494, 37.20819], [-121.82558, 37.20884], [-121.82608, 37.20927], [-121.82631, 37.20944], [-121.82672, 37.2098], [-121.82767, 37.21065], [-121.82801, 37.21094], [-121.82817, 37.21104], [-121.82868, 37.21128], [-121.82899, 37.21148], [-121.82918, 37.21165], [-121.82933, 37.21183], [-121.82946, 37.21201], [-121.82962, 37.21219], [-121.82977, 37.21233], [-121.83008, 37.21252], [-121.83038, 37.21265], [-121.83067, 37.21273], [-121.83097, 37.21279], [-121.83133, 37.2128], [-121.83159, 37.21279], [-121.8319, 37.21274], [-121.83377, 37.21223], [-121.83403, 37.21219], [-121.83436, 37.21218], [-121.83476, 37.21223], [-121.83528, 37.2124], [-121.8356, 37.21254], [-121.83579, 37.21265], [-121.8358, 37.21271], [-121.83708, 37.21396], [-121.83744, 37.21429], [-121.83795, 37.2146], [-121.8395, 37.21541], [-121.83982, 37.21556], [-121.8399, 37.21622]]]} | Open Access 1 | 860 | Singer Park | 25518 | 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 | 31.405 | Singer Park | 1984 | Local Park 2 | 4 | |
8590 | 8590 | 8589 | {"type": "Polygon", "coordinates": [[[-121.79518, 37.23742], [-121.79515, 37.23746], [-121.79513, 37.23751], [-121.79514, 37.2387], [-121.79513, 37.23879], [-121.7951, 37.23884], [-121.79504, 37.23888], [-121.79496, 37.23889], [-121.79468, 37.23884], [-121.79447, 37.23881], [-121.79399, 37.2388], [-121.79393, 37.23878], [-121.79391, 37.23873], [-121.79387, 37.23693], [-121.79388, 37.2369], [-121.79394, 37.23688], [-121.79461, 37.23701], [-121.79518, 37.23708], [-121.79518, 37.23742]]]} | Open Access 1 | 13660 | George Page Park | 19272 | 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.628 | George Page Park | 1984 | Local Park 2 | 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 | |
9530 | 9530 | 9529 | {"type": "Polygon", "coordinates": [[[-121.91257, 37.24638], [-121.91193, 37.24639], [-121.91168, 37.24645], [-121.91163, 37.24644], [-121.91158, 37.24641], [-121.91142, 37.24648], [-121.91143, 37.24653], [-121.9114, 37.24657], [-121.91116, 37.24668], [-121.91031, 37.24549], [-121.91017, 37.24517], [-121.90953, 37.24426], [-121.91011, 37.244], [-121.91017, 37.24399], [-121.91021, 37.24401], [-121.91111, 37.24526], [-121.91129, 37.24543], [-121.91151, 37.24556], [-121.91177, 37.24564], [-121.91196, 37.24566], [-121.91256, 37.24566], [-121.91257, 37.24638]]]} | Open Access 1 | 17421 | Lone Hill Park | 21438 | 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 | 7.082 | Lone Hill Park | 1984 | Local Park 2 | 4 | |
9701 | 9701 | 9700 | {"type": "Polygon", "coordinates": [[[-121.79758, 37.34781], [-121.79725, 37.34797], [-121.79713, 37.34796], [-121.79703, 37.34799], [-121.7965, 37.34825], [-121.79535, 37.34749], [-121.79509, 37.34736], [-121.79483, 37.34728], [-121.7948, 37.34725], [-121.79479, 37.34721], [-121.79492, 37.34706], [-121.79539, 37.34659], [-121.79553, 37.34638], [-121.79758, 37.34781]]]} | Open Access 1 | 16394 | Fernish Park | 18881 | 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.483 | Fernish Park | 1984 | Local Park 2 | 4 | |
9838 | 9838 | 9837 | {"type": "Polygon", "coordinates": [[[-121.88306, 37.23598], [-121.88282, 37.23622], [-121.88261, 37.23649], [-121.88268, 37.23667], [-121.88284, 37.23692], [-121.88238, 37.23705], [-121.88186, 37.23728], [-121.88159, 37.23744], [-121.88065, 37.23811], [-121.88052, 37.23825], [-121.88041, 37.23841], [-121.88029, 37.23876], [-121.88017, 37.23895], [-121.87981, 37.23938], [-121.8797, 37.23947], [-121.87956, 37.23956], [-121.87916, 37.23973], [-121.8789, 37.23953], [-121.8787, 37.23941], [-121.87844, 37.23928], [-121.87819, 37.23919], [-121.87803, 37.23948], [-121.87701, 37.23919], [-121.87697, 37.23916], [-121.87698, 37.23895], [-121.87695, 37.23881], [-121.87697, 37.23875], [-121.87716, 37.2386], [-121.87729, 37.23847], [-121.87755, 37.23816], [-121.87764, 37.23799], [-121.87767, 37.23781], [-121.87767, 37.23731], [-121.87801, 37.23725], [-121.87825, 37.23724], [-121.87836, 37.23668], [-121.87836, 37.23665], [-121.87764, 37.2361], [-121.87779, 37.23596], [-121.87789, 37.23578], [-121.87792, 37.23569], [-121.87794, 37.2355], [-121.87785, 37.23515], [-121.87784, 37.23498], [-121.87781, 37.23481], [-121.87774, 37.23464], [-121.87758, 37.23438], [-121.87755, 37.23428], [-121.87754, 37.23412], [-121.87765, 37.23381], [-121.87775, 37.23361], [-121.87786, 37.2335], [-121.87805, 37.23337], [-121.87812, 37.23327], [-121.87816, 37.23317], [-121.87816, 37.23309], [-121.87814, 37.23294], [-121.87815, 37.23285], [-121.87814, 37.2328], [-121.88021, 37.23293], [-121.88005, 37.23334], [-121.88034, 37.23378], [-121.88057, 37.23417], [-121.88125, 37.23452], [-121.88183, 37.23457], [-121.882, 37.23454], [-121.88218, 37.23447], [-121.88226, 37.23446], [-121.88239, 37.23454], [-121.88269, 37.23456], [-121.88271, 37.23468], [-121.88251, 37.23471], [-121.88232, 37.23482], [-121.8822, 37.235], [-121.88204, 37.23511], [-121.88195, 37.23532], [-121.882, 37.2354], [-121.88232, 37.23541], [-121.88233, 37.2355], [-121.88228, 37.23562], [-121.88237, 37.23576], [-121.88253, 37.23578], [-121.88281, 37.23578], [-121.883, 37.2359], [-121.88306, 37.23598]]]} | Open Access 1 | 16817 | Guadalupe Oak Grove | 19555 | 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 | 57.826 | Guadalupe Oak Grove | 1984 | Local Park 2 | 4 | |
10151 | 10151 | 10150 | {"type": "Polygon", "coordinates": [[[-121.86456, 37.33387], [-121.86435, 37.33498], [-121.86409, 37.33515], [-121.86367, 37.3373], [-121.86253, 37.3362], [-121.8631, 37.3358], [-121.86285, 37.33557], [-121.86285, 37.3355], [-121.86282, 37.33545], [-121.86253, 37.33517], [-121.8625, 37.33512], [-121.86251, 37.33507], [-121.86254, 37.335], [-121.86412, 37.33396], [-121.86417, 37.3339], [-121.8642, 37.33383], [-121.86456, 37.33387]]]} | Open Access 1 | 17689 | Martin | 21901 | 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.334 | Martin | 1984 | None 880 | ||
17063 | 17063 | 17062 | {"type": "Polygon", "coordinates": [[[-121.76351, 37.30514], [-121.76338, 37.30509], [-121.76282, 37.30517], [-121.76274, 37.30486], [-121.76297, 37.30491], [-121.76349, 37.30511], [-121.76351, 37.30514]]]} | Open Access 1 | 13733 | Pocket Park No. 20 | 23830 | 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.259 | PP No. 20 | 1984 | 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]);