units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 1985
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_WEB
MNG_AGENCY 7
DES_TP 4
- Local Park 7
- Local Recreation Area 2
- None 1
- None 1
MNG_AG_TYP 1
- City Agency · 11 ✖
ACCESS_TYP 1
- Open Access · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
404 | 404 | 403 | {"type": "MultiPolygon", "coordinates": [[[[-121.87633, 37.26877], [-121.87629, 37.26882], [-121.87618, 37.26884], [-121.87574, 37.26885], [-121.87552, 37.26887], [-121.87461, 37.26909], [-121.87453, 37.26908], [-121.87449, 37.26904], [-121.87439, 37.26876], [-121.87434, 37.26866], [-121.87424, 37.26856], [-121.87417, 37.26852], [-121.87404, 37.26847], [-121.87423, 37.26803], [-121.87413, 37.26777], [-121.87434, 37.26772], [-121.87445, 37.26772], [-121.87451, 37.26768], [-121.87452, 37.26763], [-121.87484, 37.26755], [-121.87519, 37.2675], [-121.87526, 37.26756], [-121.87535, 37.26757], [-121.87541, 37.26755], [-121.8755, 37.26747], [-121.87592, 37.26738], [-121.87603, 37.26737], [-121.87607, 37.26738], [-121.87612, 37.26742], [-121.87614, 37.26746], [-121.87633, 37.26877]]], [[[-121.87705, 37.26835], [-121.87652, 37.26841], [-121.87646, 37.2684], [-121.87641, 37.26836], [-121.87625, 37.26729], [-121.87626, 37.26697], [-121.87624, 37.26684], [-121.87658, 37.26676], [-121.87676, 37.26782], [-121.87699, 37.26776], [-121.87705, 37.26835]]]]} | Open Access 1 | 1546 | Thousand Oaks | 26323 | 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.805 | Thousand Oaks | 1985 | None 42 | ||
453 | 453 | 452 | {"type": "Polygon", "coordinates": [[[-122.12673, 37.40193], [-122.12661, 37.40184], [-122.12648, 37.40197], [-122.12604, 37.40189], [-122.12565, 37.40208], [-122.12556, 37.40226], [-122.12552, 37.40242], [-122.1254, 37.40246], [-122.12533, 37.40254], [-122.12512, 37.40323], [-122.12444, 37.40294], [-122.1239, 37.40228], [-122.12396, 37.40223], [-122.12422, 37.40168], [-122.12432, 37.40153], [-122.12442, 37.40133], [-122.12661, 37.40112], [-122.12673, 37.40193]]]} | Open Access 1 | 1453 | Terman Park | 26250 | 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 | 7.663 | Terman Park | 1985 | Local Park 2 | 4 | |
1999 | 1999 | 1998 | {"type": "Polygon", "coordinates": [[[-121.82582, 37.2727], [-121.82555, 37.27295], [-121.82555, 37.27309], [-121.82505, 37.2734], [-121.82524, 37.2741], [-121.82307, 37.27331], [-121.82274, 37.2722], [-121.82283, 37.27213], [-121.82287, 37.27199], [-121.82297, 37.27176], [-121.823, 37.27172], [-121.82304, 37.27172], [-121.82351, 37.27185], [-121.82582, 37.2727]]]} | Open Access 1 | 15311 | Danna Rock Park | 17921 | 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.56 | Danna Rock Park | 1985 | Local Park 2 | 4 | |
8538 | 8538 | 8537 | {"type": "Polygon", "coordinates": [[[-122.02209, 37.39289], [-122.02121, 37.39553], [-122.02121, 37.39564], [-122.02125, 37.39572], [-122.02114, 37.39605], [-122.01914, 37.39562], [-122.01932, 37.3955], [-122.01936, 37.39536], [-122.0193, 37.39526], [-122.01933, 37.39512], [-122.01922, 37.39508], [-122.01936, 37.39468], [-122.02007, 37.39483], [-122.02037, 37.39391], [-122.02043, 37.3939], [-122.02074, 37.39298], [-122.02073, 37.39296], [-122.02023, 37.39286], [-122.02009, 37.39284], [-122.02004, 37.39286], [-122.01987, 37.39279], [-122.01983, 37.39272], [-122.01984, 37.39261], [-122.01991, 37.39243], [-122.02209, 37.39289]]]} | Open Access 1 | 13433 | Columbia Park | 17546 | 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 | 12.727 | Columbia Park | 1985 | Local Park 2 | 4 | |
8548 | 8548 | 8547 | {"type": "Polygon", "coordinates": [[[-122.30643, 37.5152], [-122.3063, 37.51554], [-122.30563, 37.51589], [-122.30555, 37.51599], [-122.30558, 37.51659], [-122.30571, 37.51676], [-122.30528, 37.51679], [-122.30504, 37.51605], [-122.30535, 37.51597], [-122.30526, 37.51583], [-122.30523, 37.51565], [-122.30527, 37.5155], [-122.30573, 37.51505], [-122.30599, 37.51496], [-122.30615, 37.51495], [-122.30643, 37.5152]]]} | Open Access 1 | 13483 | Cipriani Field | 17261 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 2.609 | Cipriani Field | 1985 | Local Recreation Area 3 | 4 | |
8549 | 8549 | 8548 | {"type": "Polygon", "coordinates": [[[-122.29224, 37.5137], [-122.29177, 37.51383], [-122.29167, 37.5136], [-122.29124, 37.51373], [-122.29101, 37.51321], [-122.29192, 37.51294], [-122.29224, 37.5137]]]} | Open Access 1 | 13485 | Barrett Park | 15832 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 1.589 | Barrett Park | 1985 | Local Park 2 | 4 | |
8553 | 8553 | 8552 | {"type": "Polygon", "coordinates": [[[-122.34875, 37.57389], [-122.34862, 37.57404], [-122.34775, 37.5738], [-122.34734, 37.57365], [-122.34762, 37.57306], [-122.34768, 37.57305], [-122.34773, 37.57307], [-122.34875, 37.57389]]]} | Open Access 1 | 13514 | Pershing Park | 23617 | 1039 | Burlingame, City of 390 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | San Mateo 15 | 1.525 | Pershing Park | 1985 | Local Park 2 | 4 | |
8782 | 8782 | 8781 | {"type": "Polygon", "coordinates": [[[-122.42028, 37.7016], [-122.41998, 37.70231], [-122.41862, 37.70194], [-122.41903, 37.70091], [-122.42007, 37.70115], [-122.42028, 37.7016]]]} | Open Access 1 | 14285 | Bayshore Heights | 15892 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 3.701 | Bayshore Heights | 1985 | None 741 | ||
8887 | 8887 | 8886 | {"type": "Polygon", "coordinates": [[[-121.95452, 37.28882], [-121.95338, 37.28882], [-121.95342, 37.29059], [-121.95184, 37.2906], [-121.95184, 37.29016], [-121.95207, 37.29016], [-121.9521, 37.28978], [-121.95206, 37.28972], [-121.95194, 37.28963], [-121.95194, 37.28922], [-121.95192, 37.28892], [-121.95194, 37.28877], [-121.95199, 37.28868], [-121.95215, 37.28861], [-121.95233, 37.28861], [-121.95244, 37.28868], [-121.95263, 37.28871], [-121.95281, 37.28871], [-121.953, 37.28867], [-121.95319, 37.2886], [-121.95337, 37.28845], [-121.95348, 37.28828], [-121.95347, 37.28711], [-121.9545, 37.28709], [-121.95452, 37.28882]]]} | Open Access 1 | 14512 | Campbell Community Center | 16778 | 1043 | Campbell, City of 448 | City 2 | City Agency 2 | http://www.ci.campbell.ca.us/226/Recreation-Parks | City 2 | 1043 | Campbell, City of 442 | City 2 | City Agency 2 | Santa Clara 19 | 11.3 | Campbell Community Ctr. | 1985 | Local Recreation Area 3 | 4 | |
9664 | 9664 | 9663 | {"type": "Polygon", "coordinates": [[[-121.96605, 37.3077], [-121.96589, 37.30789], [-121.96586, 37.30806], [-121.96586, 37.3084], [-121.96581, 37.30846], [-121.96575, 37.30848], [-121.96447, 37.30856], [-121.96429, 37.30857], [-121.96425, 37.30855], [-121.96423, 37.30853], [-121.96423, 37.3085], [-121.96434, 37.30655], [-121.96605, 37.30654], [-121.96605, 37.3077]]]} | Open Access 1 | 16294 | Starbird Park | 25802 | 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.149 | Starbird Park | 1985 | Local Park 2 | 4 | |
10641 | 10641 | 10640 | {"type": "Polygon", "coordinates": [[[-121.81329, 37.2961], [-121.81329, 37.29614], [-121.81326, 37.29617], [-121.813, 37.29628], [-121.8123, 37.29672], [-121.81215, 37.29673], [-121.81209, 37.29676], [-121.81183, 37.29657], [-121.8116, 37.29678], [-121.81166, 37.29689], [-121.81147, 37.29697], [-121.8112, 37.29654], [-121.81095, 37.296], [-121.81176, 37.29608], [-121.81177, 37.29603], [-121.81215, 37.29608], [-121.81219, 37.29596], [-121.81212, 37.29593], [-121.81214, 37.2958], [-121.81162, 37.29575], [-121.81164, 37.29567], [-121.81144, 37.29564], [-121.81136, 37.29534], [-121.8115, 37.29542], [-121.81162, 37.29542], [-121.81168, 37.29539], [-121.81192, 37.2952], [-121.81204, 37.29513], [-121.81297, 37.29488], [-121.81301, 37.29489], [-121.81304, 37.29493], [-121.81321, 37.29533], [-121.81324, 37.29546], [-121.81325, 37.29588], [-121.81329, 37.2961]]]} | Open Access 1 | 18969 | Ramblewood Park | 24107 | 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 | 6.423 | Ramblewood Park | 1985 | 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]);