superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
58 rows where MNG_AGENCY = 68 sorted by LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13792 | 13792 | 13791 | {"type": "Polygon", "coordinates": [[[-121.92429, 37.73448], [-121.92386, 37.73452], [-121.92261, 37.73371], [-121.92234, 37.73207], [-121.92317, 37.73206], [-121.9232, 37.7322], [-121.92324, 37.73234], [-121.92329, 37.73243], [-121.92342, 37.73259], [-121.92358, 37.73273], [-121.92376, 37.73283], [-121.92426, 37.73299], [-121.92428, 37.73302], [-121.9242, 37.73331], [-121.92418, 37.73362], [-121.92429, 37.73448]]]} | Open Access 1 | Alcosta Senior and Community Center Park and Gardens | 31296 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 7.203 | Alcosta Senior and Community Ctr. Park and Gardens | ||
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 | ||
13770 | 13770 | 13769 | {"type": "Polygon", "coordinates": [[[-121.9589, 37.75072], [-121.95656, 37.75167], [-121.95627, 37.75124], [-121.95597, 37.75097], [-121.95558, 37.75036], [-121.95489, 37.74989], [-121.95533, 37.74942], [-121.95561, 37.74904], [-121.95572, 37.74886], [-121.9561, 37.74807], [-121.95647, 37.74778], [-121.95661, 37.7477], [-121.95692, 37.74756], [-121.95773, 37.74884], [-121.9589, 37.75072]]]} | Open Access 1 | Athan Downs Park | 31278 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 20.517 | Athan Downs Park | ||
13785 | 13785 | 13784 | {"type": "Polygon", "coordinates": [[[-121.92043, 37.76879], [-121.92022, 37.76935], [-121.92015, 37.76946], [-121.91996, 37.77015], [-121.9196, 37.7709], [-121.91936, 37.77167], [-121.91898, 37.77268], [-121.91884, 37.77322], [-121.91886, 37.77329], [-121.91837, 37.77321], [-121.91835, 37.77319], [-121.91841, 37.77292], [-121.91842, 37.7728], [-121.9184, 37.77277], [-121.91844, 37.77253], [-121.91846, 37.77251], [-121.91852, 37.77235], [-121.9186, 37.77218], [-121.91888, 37.77178], [-121.91902, 37.77149], [-121.91926, 37.7707], [-121.91929, 37.77047], [-121.91929, 37.77023], [-121.91987, 37.76866], [-121.92043, 37.76879]]]} | Open Access 1 | Bark and Ride | 31297 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 5.774 | Bark and Ride | ||
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 | ||
2126 | 2126 | 2125 | {"type": "Polygon", "coordinates": [[[-121.97293, 37.76113], [-121.97254, 37.7613], [-121.97237, 37.76105], [-121.97216, 37.76105], [-121.97219, 37.7609], [-121.9704, 37.76037], [-121.9707, 37.75957], [-121.97077, 37.75953], [-121.97127, 37.75964], [-121.97156, 37.75969], [-121.97186, 37.75971], [-121.97215, 37.7597], [-121.97243, 37.75968], [-121.97293, 37.76113]]]} | Restricted Access 2 | Bollinger Canyon School Park | 16244 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 5.797 | Bollinger Canyon School Park | ||
13773 | 13773 | 13772 | {"type": "Polygon", "coordinates": [[[-121.94697, 37.73689], [-121.94504, 37.73765], [-121.94449, 37.73676], [-121.94458, 37.73673], [-121.94465, 37.73663], [-121.9447, 37.7366], [-121.94629, 37.73598], [-121.94635, 37.73601], [-121.94661, 37.73631], [-121.94697, 37.73689]]]} | Open Access 1 | Boone Acres | 31281 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 5.451 | Boone Acres | ||
13786 | 13786 | 13785 | {"type": "Polygon", "coordinates": [[[-121.94848, 37.74904], [-121.94621, 37.74996], [-121.94536, 37.74865], [-121.94551, 37.7483], [-121.94569, 37.74815], [-121.94589, 37.7481], [-121.94621, 37.74811], [-121.94644, 37.7482], [-121.94681, 37.74876], [-121.94796, 37.74823], [-121.94848, 37.74904]]]} | Restricted Access 2 | California High School Tennis Courts and Track | 31298 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 7.776 | California High School Tennis Courts and Track | ||
2751 | 2751 | 2750 | {"type": "Polygon", "coordinates": [[[-121.94855, 37.72697], [-121.94802, 37.72737], [-121.94747, 37.72752], [-121.94722, 37.7271], [-121.9467, 37.7264], [-121.94669, 37.72636], [-121.94658, 37.72614], [-121.94652, 37.72592], [-121.94646, 37.72549], [-121.94641, 37.72526], [-121.94638, 37.72523], [-121.94627, 37.72499], [-121.94613, 37.72477], [-121.94586, 37.72446], [-121.94572, 37.72427], [-121.94539, 37.72367], [-121.94653, 37.72513], [-121.94832, 37.72678], [-121.94855, 37.72697]]]} | Open Access 1 | Centennial Park | 17028 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 5.528 | Centennial Park | ||
13771 | 13771 | 13770 | {"type": "Polygon", "coordinates": [[[-121.95991, 37.77099], [-121.95916, 37.77133], [-121.95755, 37.76909], [-121.95614, 37.76973], [-121.95547, 37.76887], [-121.95514, 37.76854], [-121.95568, 37.76829], [-121.95516, 37.76776], [-121.95458, 37.76799], [-121.95222, 37.76585], [-121.95221, 37.76579], [-121.95401, 37.76453], [-121.95488, 37.76399], [-121.95991, 37.77099]]]} | Open Access 1 | Central Park | 31279 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 41.392 | Central Park | ||
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 | ||
3232 | 3232 | 3231 | {"type": "Polygon", "coordinates": [[[-121.94225, 37.72945], [-121.94179, 37.72969], [-121.94168, 37.72982], [-121.94162, 37.73001], [-121.94075, 37.73035], [-121.94089, 37.73059], [-121.9408, 37.73065], [-121.94061, 37.73042], [-121.9403, 37.73014], [-121.9393, 37.7297], [-121.93903, 37.72966], [-121.93913, 37.72914], [-121.9392, 37.72899], [-121.93932, 37.72886], [-121.93956, 37.72875], [-121.93968, 37.72887], [-121.93995, 37.72874], [-121.94032, 37.72919], [-121.94159, 37.7286], [-121.94225, 37.72945]]]} | Restricted Access 2 | Country Club School Park | 17695 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 8.168 | Country Club School Park | ||
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 | ||
13778 | 13778 | 13777 | {"type": "Polygon", "coordinates": [[[-121.92827, 37.77727], [-121.92804, 37.77725], [-121.9277, 37.77676], [-121.92634, 37.77723], [-121.92635, 37.77729], [-121.92603, 37.77741], [-121.9262, 37.77696], [-121.9263, 37.77648], [-121.92639, 37.77623], [-121.92667, 37.7756], [-121.9268, 37.77502], [-121.92685, 37.77498], [-121.9269, 37.775], [-121.927, 37.7751], [-121.92718, 37.77522], [-121.92806, 37.7757], [-121.92824, 37.7757], [-121.92827, 37.77727]]]} | Restricted Access 2 | Coyote Creek School Park | 31288 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 7.425 | Coyote Creek School Park | ||
13775 | 13775 | 13774 | {"type": "Polygon", "coordinates": [[[-121.94319, 37.7784], [-121.94287, 37.77837], [-121.9428, 37.77864], [-121.94262, 37.77909], [-121.94262, 37.77953], [-121.94256, 37.7805], [-121.94264, 37.78069], [-121.94276, 37.78085], [-121.94257, 37.78093], [-121.94238, 37.78094], [-121.94237, 37.78121], [-121.94228, 37.78121], [-121.94222, 37.77953], [-121.94219, 37.77951], [-121.94215, 37.77903], [-121.9422, 37.77889], [-121.94239, 37.77851], [-121.94253, 37.77815], [-121.94258, 37.77791], [-121.94252, 37.77766], [-121.94239, 37.77737], [-121.94211, 37.77743], [-121.94209, 37.77737], [-121.94197, 37.7773], [-121.94185, 37.77732], [-121.94177, 37.77742], [-121.94095, 37.7778], [-121.94018, 37.7767], [-121.94014, 37.77662], [-121.94011, 37.77647], [-121.94012, 37.77631], [-121.94019, 37.77615], [-121.94024, 37.77606], [-121.94037, 37.77593], [-121.9405, 37.77585], [-121.94071, 37.77576], [-121.94091, 37.77573], [-121.94111, 37.77572], [-121.94136, 37.77577], [-121.94151, 37.77583], [-121.9417, 37.77596], [-121.94247, 37.77695], [-121.94272, 37.7773], [-121.94314, 37.7782], [-121.94319, 37.7784]]]} | Open Access 1 | Coyote Crossing | 31283 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 11.596 | Coyote Crossing | ||
3273 | 3273 | 3272 | {"type": "Polygon", "coordinates": [[[-121.92463, 37.77037], [-121.92461, 37.77057], [-121.92454, 37.77086], [-121.92429, 37.77082], [-121.92344, 37.77075], [-121.92226, 37.77054], [-121.92228, 37.77016], [-121.92218, 37.76978], [-121.92198, 37.76942], [-121.92295, 37.76955], [-121.9242, 37.76983], [-121.92429, 37.76993], [-121.92434, 37.77005], [-121.92454, 37.77001], [-121.92461, 37.77021], [-121.92463, 37.77037]]]} | Open Access 1 | Creekside Park | 17779 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 6.013 | Creekside Park | ||
13787 | 13787 | 13786 | {"type": "Polygon", "coordinates": [[[-121.9904, 37.7715], [-121.99027, 37.77177], [-121.98956, 37.77195], [-121.98838, 37.77269], [-121.98832, 37.77273], [-121.98827, 37.77281], [-121.98819, 37.7728], [-121.98823, 37.77261], [-121.98795, 37.77253], [-121.98794, 37.77251], [-121.9878, 37.77248], [-121.98778, 37.77242], [-121.98765, 37.77244], [-121.98763, 37.7724], [-121.98748, 37.77243], [-121.98745, 37.77231], [-121.98754, 37.77184], [-121.98773, 37.77156], [-121.98771, 37.77114], [-121.98801, 37.77143], [-121.98812, 37.7711], [-121.98896, 37.77142], [-121.98924, 37.77116], [-121.98911, 37.77088], [-121.98923, 37.77073], [-121.98976, 37.77051], [-121.9901, 37.77079], [-121.98963, 37.77112], [-121.98963, 37.77115], [-121.98981, 37.77129], [-121.99035, 37.77145], [-121.9904, 37.7715]]]} | Open Access 1 | Crow Canyon Gardens | 31299 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 7.47 | Crow Canyon Gardens | ||
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 | ||
6398 | 6398 | 6397 | {"type": "Polygon", "coordinates": [[[-121.92994, 37.74522], [-121.92625, 37.74667], [-121.92569, 37.74579], [-121.92459, 37.74622], [-121.92512, 37.74711], [-121.92389, 37.74691], [-121.92427, 37.74849], [-121.92332, 37.74921], [-121.92193, 37.74844], [-121.91908, 37.7461], [-121.91927, 37.74613], [-121.91968, 37.74602], [-121.91983, 37.74603], [-121.92007, 37.7457], [-121.92025, 37.74584], [-121.92066, 37.74583], [-121.92071, 37.74569], [-121.92042, 37.74544], [-121.92047, 37.74537], [-121.92045, 37.74529], [-121.92075, 37.74515], [-121.92082, 37.74491], [-121.92083, 37.74461], [-121.92073, 37.7445], [-121.92078, 37.74446], [-121.9208, 37.7444], [-121.92088, 37.7444], [-121.92123, 37.74427], [-121.9212, 37.74406], [-121.92109, 37.74379], [-121.9207, 37.74358], [-121.92072, 37.74349], [-121.92068, 37.74342], [-121.92078, 37.74332], [-121.92065, 37.74309], [-121.91977, 37.74301], [-121.91985, 37.74232], [-121.9201, 37.74232], [-121.92032, 37.74197], [-121.92017, 37.74139], [-121.92017, 37.74113], [-121.92062, 37.74071], [-121.92054, 37.74038], [-121.92035, 37.74031], [-121.92036, 37.74026], [-121.92035, 37.74022], [-121.92058, 37.74012], [-121.92075, 37.73983], [-121.92097, 37.73938], [-121.92089, 37.73929], [-121.92106, 37.73914], [-121.9213, 37.73889], [-121.9215, 37.73864], [-121.92162, 37.73848], [-121.92172, 37.73866], [-121.92185, 37.7385], [-121.92201, 37.73855], [-121.92228, 37.73867], [-121.92246, 37.73881], [-121.92256, 37.73893], [-121.92262, 37.73906], [-121.92276, 37.73954], [-121.92287, 37.73974], [-121.9226, 37.73987], [-121.92258, 37.74002], [-121.9226, 37.74014], [-121.9227, 37.7404], [-121.92283, 37.74055], [-121.92298, 37.74068], [-121.92344, 37.74066], [-121.92396, 37.74073], [-121.92441, 37.74073], [-121.9246, 37.74075], [-121.9248, 37.74079], [-121.92491, 37.74089], [-121.92502, 37.74095], [-121.92519, 37.74109], [-121.92533, 37.74126], [-121.92543, 37.74145], [-121.92548, 37.74167], [-121.92547, 37.74189], [-121.92553, 37.74205], [-121.92563, 37.74213], [-121.92575, 37.74238], [-121.9259, 37.74263], [-121.92617, 37.74292], [-121.92625, 37.74304], [-121.92638, 37.74333], [-121.92669, 37.74351], [-121.92698, 37.74389], [-121.92725, 37.74414], [-121.92715, 37.74427], [-121.92706, 37.74444], [-121.92692, 37.74464], [-121.92691, 37.74469], [-121.92693, 37.74481], [-121.92801, 37.74475], [-121.92843, 37.74481], [-121.92869, 37.74482], [-121.92892, 37.74479], [-121.9294, 37.74467], [-121.92994, 37.74522]]]} | Open Access 1 | Dougherty Valley Ridge Trail | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | 33643 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 117.32 | Dougherty Valley Ridge Trail | |
3789 | 3789 | 3788 | {"type": "Polygon", "coordinates": [[[-121.90018, 37.76147], [-121.90014, 37.76151], [-121.89894, 37.76161], [-121.89888, 37.76156], [-121.89882, 37.76113], [-121.89873, 37.7609], [-121.89847, 37.76033], [-121.89847, 37.7603], [-121.89851, 37.76019], [-121.8988, 37.76016], [-121.89905, 37.76012], [-121.8996, 37.75986], [-121.89982, 37.75979], [-121.89984, 37.75977], [-121.89991, 37.76], [-121.89983, 37.76005], [-121.89981, 37.76012], [-121.89987, 37.76021], [-121.89991, 37.76029], [-121.90009, 37.76085], [-121.90013, 37.76102], [-121.90018, 37.76147]]]} | Open Access 1 | East Branch Park | 18364 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 5.077 | East Branch 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]);