superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
58 rows where MNG_AGENCY = 68 sorted by ACRES
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 43
- Restricted Access 15
MNG_AG_TYP 1
- City Agency 58
MNG_AGENCY 1
- San Ramon, City of · 58 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13774 | 13774 | 13773 | {"type": "Polygon", "coordinates": [[[-121.9403, 37.7533], [-121.94009, 37.75336], [-121.94005, 37.75335], [-121.93993, 37.75311], [-121.94019, 37.75304], [-121.9403, 37.7533]]]} | Open Access 1 | County Fair Park | 31282 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 0.177 | County Fair Park | ||
10235 | 10235 | 10234 | {"type": "Polygon", "coordinates": [[[-121.88491, 37.74319], [-121.88485, 37.74344], [-121.88438, 37.74336], [-121.88393, 37.74334], [-121.88354, 37.74336], [-121.88309, 37.74344], [-121.88316, 37.74317], [-121.88335, 37.74314], [-121.88386, 37.7431], [-121.88391, 37.7431], [-121.88394, 37.74312], [-121.88407, 37.74312], [-121.88408, 37.7431], [-121.88414, 37.7431], [-121.88453, 37.74313], [-121.88491, 37.74319]]]} | Open Access 1 | Tassajara Ridge Staging Area | 26196 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1.033 | Tassajara Ridge Staging Area | ||
4230 | 4230 | 4229 | {"type": "Polygon", "coordinates": [[[-121.89228, 37.75084], [-121.89225, 37.7512], [-121.89157, 37.75121], [-121.89156, 37.75058], [-121.89162, 37.75053], [-121.89222, 37.75053], [-121.89228, 37.75057], [-121.89228, 37.75084]]]} | Open Access 1 | Fire Truck Park | 18909 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1.143 | Fire Truck Park | ||
11333 | 11333 | 11332 | {"type": "Polygon", "coordinates": [[[-121.9392, 37.7711], [-121.93917, 37.77112], [-121.93842, 37.77114], [-121.93831, 37.77113], [-121.9382, 37.77109], [-121.93808, 37.77101], [-121.93801, 37.7709], [-121.93796, 37.77068], [-121.93799, 37.77056], [-121.93804, 37.77047], [-121.9386, 37.77065], [-121.93861, 37.77073], [-121.93918, 37.77072], [-121.9392, 37.7711]]]} | Open Access 1 | Windy Hills Park | 27643 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1.36 | Windy Hills Park | 2000 | |
3135 | 3135 | 3134 | {"type": "Polygon", "coordinates": [[[-121.88576, 37.74692], [-121.88539, 37.74704], [-121.88548, 37.74724], [-121.88454, 37.74731], [-121.88447, 37.74671], [-121.88487, 37.74668], [-121.88492, 37.74664], [-121.88502, 37.74667], [-121.88511, 37.74664], [-121.88516, 37.74667], [-121.88554, 37.74664], [-121.88561, 37.74671], [-121.88556, 37.74678], [-121.88557, 37.74685], [-121.88563, 37.74689], [-121.88576, 37.74692]]]} | Open Access 1 | Compass Point Park | 17570 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1.499 | Compass Point Park | ||
8169 | 8169 | 8168 | {"type": "Polygon", "coordinates": [[[-121.90239, 37.7501], [-121.90238, 37.75016], [-121.90211, 37.75031], [-121.90179, 37.75044], [-121.90155, 37.75049], [-121.90122, 37.75051], [-121.90117, 37.75045], [-121.90142, 37.75038], [-121.9013, 37.7498], [-121.90202, 37.74968], [-121.90239, 37.7501]]]} | Open Access 1 | Sherwood Park | 25404 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1.5 | Sherwood Park | ||
13776 | 13776 | 13775 | {"type": "Polygon", "coordinates": [[[-121.91707, 37.76661], [-121.91705, 37.76667], [-121.91633, 37.76697], [-121.91632, 37.76695], [-121.91635, 37.76685], [-121.91607, 37.76644], [-121.91547, 37.76669], [-121.91538, 37.76656], [-121.91666, 37.76601], [-121.91707, 37.76661]]]} | Open Access 1 | Mosaic Park | 31284 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1.613 | Mosaic Park | ||
5110 | 5110 | 5109 | {"type": "Polygon", "coordinates": [[[-121.92089, 37.78122], [-121.92073, 37.7813], [-121.9201, 37.7815], [-121.91992, 37.78151], [-121.91983, 37.78173], [-121.91963, 37.78164], [-121.91938, 37.78148], [-121.91938, 37.78143], [-121.92004, 37.78079], [-121.92017, 37.78059], [-121.92047, 37.78065], [-121.92065, 37.78077], [-121.92071, 37.78083], [-121.92082, 37.78115], [-121.92089, 37.78122]]]} | Open Access 1 | Hidden Crest Park | 19906 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 2.067 | Hidden Crest Park | ||
9790 | 9790 | 9789 | {"type": "Polygon", "coordinates": [[[-121.90838, 37.76325], [-121.90837, 37.76335], [-121.90827, 37.76345], [-121.90824, 37.76355], [-121.9078, 37.76405], [-121.90772, 37.76392], [-121.90746, 37.76359], [-121.90734, 37.76335], [-121.90729, 37.76322], [-121.90726, 37.76303], [-121.90726, 37.76289], [-121.90729, 37.76271], [-121.90799, 37.7627], [-121.90806, 37.76282], [-121.90832, 37.76309], [-121.90836, 37.76316], [-121.90838, 37.76325]]]} | Open Access 1 | Souyen Park | 25706 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 2.392 | Souyen Park | ||
9705 | 9705 | 9704 | {"type": "Polygon", "coordinates": [[[-121.89083, 37.74554], [-121.89075, 37.74561], [-121.89041, 37.74563], [-121.89041, 37.74558], [-121.89038, 37.74553], [-121.89032, 37.74549], [-121.89024, 37.74549], [-121.89018, 37.74551], [-121.89014, 37.74556], [-121.89013, 37.74561], [-121.89015, 37.74566], [-121.88977, 37.74573], [-121.88961, 37.74541], [-121.88938, 37.74506], [-121.88914, 37.74475], [-121.88885, 37.74446], [-121.88911, 37.74428], [-121.88915, 37.74432], [-121.88921, 37.74435], [-121.88927, 37.74435], [-121.88933, 37.74432], [-121.88938, 37.74427], [-121.88938, 37.7442], [-121.88933, 37.74415], [-121.88925, 37.74413], [-121.88944, 37.74396], [-121.88958, 37.74398], [-121.88959, 37.74419], [-121.88966, 37.74442], [-121.88976, 37.7446], [-121.88998, 37.7449], [-121.89025, 37.74519], [-121.89038, 37.74531], [-121.89054, 37.74541], [-121.89083, 37.74554]]]} | Open Access 1 | Six Pillars Park | 25523 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 2.764 | Six Pillars Park | ||
6177 | 6177 | 6176 | {"type": "Polygon", "coordinates": [[[-121.89013, 37.75908], [-121.88996, 37.75937], [-121.88997, 37.75971], [-121.88991, 37.75987], [-121.88982, 37.76003], [-121.88939, 37.7599], [-121.88887, 37.7598], [-121.8888, 37.75978], [-121.88877, 37.75972], [-121.88897, 37.75933], [-121.88903, 37.7591], [-121.88903, 37.75896], [-121.88901, 37.75883], [-121.88895, 37.75869], [-121.88884, 37.75853], [-121.88887, 37.75852], [-121.88911, 37.75868], [-121.88927, 37.75876], [-121.89013, 37.75908]]]} | Open Access 1 | Limerick Park | 21242 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 2.775 | Limerick Park | ||
13780 | 13780 | 13779 | {"type": "Polygon", "coordinates": [[[-121.89439, 37.76297], [-121.89423, 37.76359], [-121.89427, 37.76362], [-121.89343, 37.76401], [-121.89292, 37.76331], [-121.89275, 37.7633], [-121.89268, 37.76317], [-121.89342, 37.76277], [-121.89439, 37.76297]]]} | Restricted Access 2 | Hidden Hills School Park | 31291 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 3.033 | Hidden Hills School Park | ||
13781 | 13781 | 13780 | {"type": "Polygon", "coordinates": [[[-121.89542, 37.75272], [-121.89511, 37.75373], [-121.89391, 37.75351], [-121.89423, 37.75248], [-121.89542, 37.75272]]]} | Restricted Access 2 | Live Oak School Park | 31293 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 3.116 | Live Oak School Park | ||
6985 | 6985 | 6984 | {"type": "Polygon", "coordinates": [[[-121.99072, 37.77668], [-121.99044, 37.77695], [-121.98929, 37.77606], [-121.98814, 37.77604], [-121.98826, 37.77573], [-121.98834, 37.77549], [-121.98841, 37.77517], [-121.98844, 37.77492], [-121.99072, 37.77668]]]} | Open Access 1 | Mill Creek Hollow | 22223 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 3.524 | Mill Creek Hollow | ||
2791 | 2791 | 2790 | {"type": "Polygon", "coordinates": [[[-121.94007, 37.74339], [-121.93937, 37.74367], [-121.93873, 37.74277], [-121.93857, 37.74256], [-121.93822, 37.74221], [-121.93808, 37.74203], [-121.93887, 37.74172], [-121.94007, 37.74339]]]} | Open Access 1 | Del Mar Dog Park | 18030 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 3.734 | Del Mar Dog Park | ||
1570 | 1570 | 1569 | {"type": "Polygon", "coordinates": [[[-121.89342, 37.74775], [-121.89308, 37.74836], [-121.89295, 37.74847], [-121.89281, 37.74856], [-121.89266, 37.7486], [-121.89251, 37.74862], [-121.8915, 37.74863], [-121.89145, 37.74859], [-121.89143, 37.74772], [-121.89149, 37.74768], [-121.89184, 37.74768], [-121.89289, 37.74762], [-121.89312, 37.74764], [-121.89336, 37.74769], [-121.89338, 37.7477], [-121.89342, 37.74775]]]} | Open Access 1 | Arlington Park | 15591 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 4.017 | Arlington Park | ||
1938 | 1938 | 1937 | {"type": "Polygon", "coordinates": [[[-121.89919, 37.76468], [-121.90011, 37.76471], [-121.90024, 37.76475], [-121.90032, 37.7648], [-121.90038, 37.76489], [-121.9004, 37.76498], [-121.90037, 37.76562], [-121.90035, 37.7657], [-121.90031, 37.76575], [-121.90018, 37.76584], [-121.90002, 37.76586], [-121.89914, 37.76584], [-121.89902, 37.7658], [-121.89893, 37.76574], [-121.89887, 37.76566], [-121.89885, 37.76558], [-121.89888, 37.7649], [-121.89892, 37.76482], [-121.89899, 37.76475], [-121.89909, 37.7647], [-121.89919, 37.76468]]]} | Open Access 1 | Bellingham Square | 15991 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 4.043 | Bellingham Square | ||
8501 | 8501 | 8500 | {"type": "Polygon", "coordinates": [[[-121.88812, 37.74969], [-121.88807, 37.74974], [-121.88643, 37.74975], [-121.88637, 37.74971], [-121.88633, 37.74886], [-121.88639, 37.74881], [-121.88797, 37.74874], [-121.88803, 37.74877], [-121.8881, 37.74903], [-121.88812, 37.74922], [-121.88812, 37.74969]]]} | Open Access 1 | Ramona Park | 24121 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 4.097 | Ramona Park | ||
8126 | 8126 | 8125 | {"type": "Polygon", "coordinates": [[[-121.89848, 37.77685], [-121.89825, 37.7779], [-121.89822, 37.77794], [-121.89817, 37.77794], [-121.89686, 37.77776], [-121.8968, 37.77773], [-121.8968, 37.7777], [-121.89703, 37.77665], [-121.89706, 37.77662], [-121.89711, 37.77661], [-121.89842, 37.77679], [-121.89847, 37.77682], [-121.89848, 37.77685]]]} | Open Access 1 | Picadilly Park | 23647 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 4.141 | Picadilly Park | ||
7326 | 7326 | 7325 | {"type": "Polygon", "coordinates": [[[-121.95047, 37.74159], [-121.95043, 37.74164], [-121.9484, 37.74261], [-121.94834, 37.74259], [-121.94817, 37.74236], [-121.94777, 37.74195], [-121.94951, 37.74127], [-121.94991, 37.74104], [-121.95019, 37.74134], [-121.95043, 37.74153], [-121.95047, 37.74159]]]} | Restricted Access 2 | Neil Armstrong School Park | 22687 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 4.399 | Neil Armstrong School Park |
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]);