superunits_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)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1307 | 1307 | 1306 | {"type": "Polygon", "coordinates": [[[-122.29224, 37.5137], [-122.29177, 37.51383], [-122.29167, 37.51361], [-122.29124, 37.51373], [-122.29101, 37.51321], [-122.29192, 37.51294], [-122.29224, 37.5137]]]} | Open Access 1 | Barrett Park | 15832 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1.59 | Barrett Park | 1985 | |
1838 | 1838 | 1837 | {"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 | Bayshore Heights | 15892 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 3.701 | Bayshore Heights | 1985 | |
2709 | 2709 | 2708 | {"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.27198], [-121.82297, 37.27176], [-121.823, 37.27172], [-121.82304, 37.27172], [-121.82351, 37.27185], [-121.82582, 37.2727]]]} | Open Access 1 | Danna Rock Park | 17921 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 9.563 | Danna Rock Park | 1985 | |
2944 | 2944 | 2943 | {"type": "Polygon", "coordinates": [[[-122.30643, 37.5152], [-122.3063, 37.51554], [-122.30563, 37.51589], [-122.30555, 37.51599], [-122.30558, 37.51658], [-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 | Cipriani Field | 17261 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 2.613 | Cipriani Field | 1985 | |
3118 | 3118 | 3117 | {"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.01931, 37.3955], [-122.01936, 37.39537], [-122.0193, 37.39526], [-122.01933, 37.39513], [-122.01922, 37.39508], [-122.01936, 37.39468], [-122.02007, 37.39483], [-122.02037, 37.39391], [-122.02043, 37.3939], [-122.02073, 37.39298], [-122.02072, 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 | Columbia Park | 17546 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 12.735 | Columbia Park | 1985 | |
8101 | 8101 | 8100 | {"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 | Pershing Park | 23617 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 1.525 | Pershing Park | 1985 | |
8490 | 8490 | 8489 | {"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.29658], [-121.8116, 37.29678], [-121.81166, 37.29689], [-121.81147, 37.29697], [-121.8112, 37.29654], [-121.81095, 37.296], [-121.81175, 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.81163, 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 | Ramblewood Park | 24107 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 6.432 | Ramblewood Park | 1985 | |
9919 | 9919 | 9918 | {"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.30856], [-121.96425, 37.30855], [-121.96423, 37.30853], [-121.96423, 37.30849], [-121.96434, 37.30655], [-121.96605, 37.30654], [-121.96605, 37.3077]]]} | Open Access 1 | Starbird Park | 25802 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.149 | Starbird Park | 1985 | |
10286 | 10286 | 10285 | {"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 | Terman Park | 26250 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 7.665 | Terman Park | 1985 | |
10339 | 10339 | 10338 | {"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.87551, 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.26781], [-121.87699, 37.26776], [-121.87705, 37.26835]]]]} | Open Access 1 | Thousand Oaks | 26323 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.809 | Thousand Oaks | 1985 | |
15531 | 15531 | 15530 | {"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.28979], [-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 | Campbell Community Center | 16778 | 1043 | Campbell, City of 442 | City 2 | City Agency 2 | http://www.ci.campbell.ca.us/226/Recreation-Parks | City 2 | 11.311 | Campbell Community Ctr. | 1985 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);