units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
175 rows where DES_TP = 2 and MNG_AGENCY = 32 sorted by ACRES
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 174
- Restricted Access 1
MNG_AG_TYP 1
- City Agency 175
MNG_AGENCY 1
- San Jose, City of · 175 ✖
DES_TP 1
- Local Park · 175 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8607 | 8607 | 8606 | {"type": "Polygon", "coordinates": [[[-121.82996, 37.36133], [-121.82978, 37.36141], [-121.82971, 37.36133], [-121.82965, 37.36131], [-121.82992, 37.36119], [-121.8299, 37.36125], [-121.82996, 37.36133]]]} | Open Access 1 | 13699 | Nancy Lane Plaza | 22625 | 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.075 | Nancy Lane Plaza | 0 | Local Park 2 | 4 | |
1609 | 1609 | 1608 | {"type": "Polygon", "coordinates": [[[-121.87741, 37.32001], [-121.87733, 37.32006], [-121.8769, 37.31949], [-121.87741, 37.32001], [-121.87741, 37.32001]]]} | Open Access 1 | 13645 | Caldwallder Park | 16674 | 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.082 | Caldwallder Park | 0 | Local Park 2 | 4 | |
9368 | 9368 | 9367 | {"type": "Polygon", "coordinates": [[[-121.92157, 37.31987], [-121.92107, 37.31987], [-121.92107, 37.31975], [-121.92153, 37.31975], [-121.92157, 37.31977], [-121.92157, 37.31987]]]} | Open Access 1 | 15649 | Buena Vista Park | 16493 | 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.148 | Buena Vista Park | 2004 | Local Park 2 | 4 | |
16403 | 16403 | 16402 | {"type": "Polygon", "coordinates": [[[-121.7745, 37.32534], [-121.77408, 37.32537], [-121.77333, 37.32544], [-121.77339, 37.32537], [-121.77346, 37.32538], [-121.77353, 37.32535], [-121.77356, 37.32537], [-121.7743, 37.3253], [-121.77434, 37.32527], [-121.77441, 37.3253], [-121.77448, 37.32529], [-121.7745, 37.32534]]]} | Open Access 1 | 9115 | Pocket Park No. 21 | 23831 | 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.155 | PP No. 21 | 1994 | Local Park 2 | 4 | |
14873 | 14873 | 14872 | {"type": "Polygon", "coordinates": [[[-121.89511, 37.33384], [-121.89479, 37.334], [-121.89467, 37.33357], [-121.89511, 37.33384], [-121.89511, 37.33384]]]} | Open Access 1 | 45394 | Almaden Entrance Triangle Park | 27910 | 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 | http://www.sanjoseca.gov/prns | Santa Clara 19 | 0.191 | Almaden Entrance Triangle Park | 0 | Local Park 2 | 4 |
1805 | 1805 | 1804 | {"type": "Polygon", "coordinates": [[[-121.88006, 37.33079], [-121.87965, 37.33098], [-121.87955, 37.33084], [-121.87991, 37.33067], [-121.87982, 37.33052], [-121.87985, 37.33051], [-121.88006, 37.33079]]]} | Open Access 1 | 13703 | O'Donnell Garden Park | 22946 | 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.201 | O'Donnell Garden Park | 1940 | Local Park 2 | 4 | |
14030 | 14030 | 14029 | {"type": "Polygon", "coordinates": [[[-121.96308, 37.29872], [-121.96265, 37.29819], [-121.96239, 37.29789], [-121.96265, 37.2979], [-121.96266, 37.29797], [-121.9628, 37.29824], [-121.96308, 37.29872]]]} | Open Access 1 | 38028 | Gleason Park | 19311 | 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.215 | Gleason Park | 0 | Local Park 2 | 4 | |
8594 | 8594 | 8593 | {"type": "Polygon", "coordinates": [[[-121.87021, 37.35546], [-121.86975, 37.35577], [-121.86972, 37.35574], [-121.8697, 37.35568], [-121.86965, 37.35565], [-121.86965, 37.35564], [-121.8697, 37.35564], [-121.86975, 37.35561], [-121.86978, 37.35557], [-121.86979, 37.35553], [-121.87014, 37.3553], [-121.87021, 37.35546]]]} | Open Access 1 | 13670 | Hacienda Park | 19589 | 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.228 | Hacienda Park | 2004 | Local Park 2 | 4 | |
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 | |
7530 | 7530 | 7529 | {"type": "Polygon", "coordinates": [[[-121.76202, 37.3228], [-121.76181, 37.32286], [-121.76161, 37.32298], [-121.76142, 37.32279], [-121.76175, 37.32258], [-121.76187, 37.32271], [-121.76202, 37.3228]]]} | Open Access 1 | 9183 | Pocket Park No. 8 | 23838 | 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.273 | PP No. 8 | 0 | Local Park 2 | 4 | |
1427 | 1427 | 1426 | {"type": "Polygon", "coordinates": [[[-121.75911, 37.31065], [-121.75911, 37.31077], [-121.75894, 37.31093], [-121.75867, 37.31081], [-121.75863, 37.31078], [-121.7587, 37.31058], [-121.75902, 37.3106], [-121.75911, 37.31065]]]} | Open Access 1 | 9084 | Pocket Park No. 18 | 23827 | 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.285 | PP No. 18 | 2004 | Local Park 2 | 4 | |
7787 | 7787 | 7786 | {"type": "Polygon", "coordinates": [[[-121.84487, 37.36184], [-121.84462, 37.362], [-121.8445, 37.36188], [-121.84451, 37.36186], [-121.84448, 37.36183], [-121.84446, 37.36184], [-121.84431, 37.36167], [-121.84456, 37.36152], [-121.84463, 37.36159], [-121.84462, 37.36161], [-121.84469, 37.36168], [-121.84471, 37.36167], [-121.84473, 37.3617], [-121.84472, 37.36172], [-121.84475, 37.36174], [-121.84477, 37.36174], [-121.84487, 37.36184]]]} | Open Access 1 | 47664 | Jackson Madden Park | 31404 | 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 | http://www.sanjoseca.gov/Facilities/Facility/Details/187 | Santa Clara 19 | 0.311 | Jackson Madden Park | 0 | Local Park 2 | 4 |
8585 | 8585 | 8584 | {"type": "Polygon", "coordinates": [[[-121.89616, 37.33775], [-121.89607, 37.3379], [-121.89601, 37.33804], [-121.89584, 37.33812], [-121.89562, 37.33784], [-121.89606, 37.33763], [-121.89616, 37.33775]]]} | Open Access 1 | 13727 | Pellier Park | 23570 | 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.342 | Pellier Park | 1988 | Local Park 2 | 4 | |
7821 | 7821 | 7820 | {"type": "MultiPolygon", "coordinates": [[[[-121.77933, 37.31566], [-121.7791, 37.31572], [-121.77901, 37.31526], [-121.77923, 37.31547], [-121.77933, 37.31563], [-121.77933, 37.31566]]], [[[-121.77976, 37.31553], [-121.77956, 37.31557], [-121.77951, 37.31556], [-121.77939, 37.31537], [-121.77917, 37.31515], [-121.77914, 37.3151], [-121.77915, 37.31507], [-121.77918, 37.31505], [-121.77928, 37.31503], [-121.77939, 37.31536], [-121.77966, 37.31535], [-121.77962, 37.31542], [-121.77963, 37.31547], [-121.77968, 37.31551], [-121.77976, 37.31553]]]]} | Open Access 1 | 9035 | Pocket Park No. 14 | 23823 | 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.346 | PP No. 14 | 2004 | Local Park 2 | 4 | |
7822 | 7822 | 7821 | {"type": "Polygon", "coordinates": [[[-121.76143, 37.31313], [-121.76078, 37.31323], [-121.76083, 37.31318], [-121.7608, 37.31299], [-121.76085, 37.31282], [-121.76091, 37.31279], [-121.76098, 37.31279], [-121.76143, 37.31313]]]} | Open Access 1 | 9062 | Pocket Park No. 16 | 23825 | 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.382 | PP No. 16 | 1994 | Local Park 2 | 4 | |
1812 | 1812 | 1811 | {"type": "Polygon", "coordinates": [[[-121.89561, 37.25718], [-121.89547, 37.25727], [-121.89533, 37.25733], [-121.89499, 37.25756], [-121.89484, 37.2574], [-121.89484, 37.25737], [-121.89487, 37.25734], [-121.89544, 37.25705], [-121.89551, 37.25706], [-121.89561, 37.25718]]]} | Open Access 1 | 13746 | Scottsdale Park | 25216 | 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.386 | Scottsdale Park | 1997 | Local Park 2 | 4 | |
14029 | 14029 | 14028 | {"type": "Polygon", "coordinates": [[[-121.88207, 37.25467], [-121.88187, 37.25473], [-121.88159, 37.25404], [-121.88169, 37.254], [-121.88176, 37.25392], [-121.88207, 37.25467]]]} | Open Access 1 | 38025 | Russo Park | 24747 | 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.386 | Russo Park | 0 | Local Park 2 | 4 | |
8597 | 8597 | 8596 | {"type": "Polygon", "coordinates": [[[-121.89793, 37.31439], [-121.89792, 37.31475], [-121.89747, 37.31474], [-121.89748, 37.31438], [-121.89793, 37.31439]]]} | Open Access 1 | 13675 | Hummingbird Park | 20150 | 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.388 | Hummingbird Park | 2003 | Local Park 2 | 4 | |
8193 | 8193 | 8192 | {"type": "Polygon", "coordinates": [[[-121.76509, 37.32215], [-121.7655, 37.32231], [-121.7656, 37.32238], [-121.7656, 37.32244], [-121.76549, 37.32254], [-121.76537, 37.32259], [-121.76523, 37.3226], [-121.76507, 37.32258], [-121.76509, 37.32215]]]} | Open Access 1 | 9147 | Pocket Park No. 5 | 23835 | 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.395 | PP No. 5 | 0 | Local Park 2 | 4 | |
4314 | 4314 | 4313 | {"type": "Polygon", "coordinates": [[[-121.89634, 37.32873], [-121.89614, 37.32883], [-121.89583, 37.32829], [-121.8955, 37.32782], [-121.89562, 37.32786], [-121.89574, 37.32795], [-121.89634, 37.32873]]]} | Open Access 1 | 45398 | Delmas Dog Park | 27904 | 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 | http://www.sanjoseca.gov/Facilities/Facility/Details/Dog-Parks-140 | Santa Clara 19 | 0.426 | Delmas Dog Park | 0 | 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]);