units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
60 rows where MNG_AGENCY = 68 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, LABEL_NAME, YR_EST
DES_TP 10
- Local Park 45
- Local Recreation Area 7
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
AGNCY_TYP 4 ✖
ACCESS_TYP 2
- Open Access 45
- Restricted Access 15
MNG_AG_TYP 1
- City Agency 60
MNG_AGENCY 1
- San Ramon, City of · 60 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
183 | 183 | 182 | {"type": "Polygon", "coordinates": [[[-121.9589, 37.75072], [-121.95656, 37.75167], [-121.95627, 37.75123], [-121.95597, 37.75097], [-121.95558, 37.75036], [-121.95489, 37.74989], [-121.95534, 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 | 506 | Athan Downs Park | 31278 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 20.518 | Athan Downs Park | 0 | Local Park 2 | 4 | |
2098 | 2098 | 2097 | {"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 | 47568 | Live Oak School Park | 31293 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 3.116 | Live Oak School Park | 0 | Local Park 2 | 4 | |
2099 | 2099 | 2098 | {"type": "Polygon", "coordinates": [[[-121.94503, 37.73765], [-121.94369, 37.73818], [-121.94322, 37.73744], [-121.94227, 37.7378], [-121.94234, 37.73798], [-121.94192, 37.73811], [-121.94168, 37.73772], [-121.94145, 37.73739], [-121.94426, 37.7363], [-121.9444, 37.73653], [-121.94433, 37.7366], [-121.94433, 37.73668], [-121.94438, 37.73674], [-121.94449, 37.73676], [-121.94503, 37.73765]]]} | Restricted Access 2 | 47569 | Pine Valley Middle School Parks and Community Gym | 31294 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 8.075 | Pine Valley Middle School Parks and Community Gym | 0 | Local Recreation Area 3 | 4 | |
2216 | 2216 | 2215 | {"type": "Polygon", "coordinates": [[[-121.90955, 37.75216], [-121.90924, 37.75257], [-121.90894, 37.75304], [-121.90858, 37.75288], [-121.90819, 37.75274], [-121.90782, 37.75266], [-121.90741, 37.75261], [-121.90741, 37.7522], [-121.90735, 37.75209], [-121.90718, 37.752], [-121.90702, 37.75197], [-121.90676, 37.75208], [-121.9058, 37.75097], [-121.9068, 37.75041], [-121.90754, 37.75103], [-121.90769, 37.7511], [-121.90786, 37.75114], [-121.90802, 37.75114], [-121.90823, 37.75111], [-121.90845, 37.75099], [-121.90955, 37.75216]]]} | Restricted Access 2 | 47570 | Windemere Ranch School Park | 31295 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 11.225 | Windemere Ranch School Park | 0 | Local Park 2 | 4 | |
3369 | 3369 | 3368 | {"type": "Polygon", "coordinates": [[[-121.90239, 37.7501], [-121.90238, 37.75016], [-121.90211, 37.75031], [-121.90179, 37.75044], [-121.90156, 37.75048], [-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 | 24476 | Sherwood Park | 25404 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 1.498 | Sherwood Park | 0 | Local Park 2 | 4 | |
4159 | 4159 | 4158 | {"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 | 47562 | County Fair Park | 31282 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 0.178 | County Fair Park | 0 | Local Park 2 | 4 | |
4165 | 4165 | 4164 | {"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.9468, 37.74876], [-121.94796, 37.74823], [-121.94848, 37.74904]]]} | Restricted Access 2 | 47573 | California High School Tennis Courts and Track | 31298 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 7.772 | California High School Tennis Courts and Track | None 360 | |||
5499 | 5499 | 5498 | {"type": "Polygon", "coordinates": [[[-121.96432, 37.73865], [-121.95873, 37.74082], [-121.9587, 37.74074], [-121.95922, 37.74054], [-121.95956, 37.74032], [-121.95984, 37.74023], [-121.96, 37.74016], [-121.9602, 37.74003], [-121.96036, 37.73986], [-121.96041, 37.73976], [-121.96042, 37.73965], [-121.96039, 37.73951], [-121.96033, 37.73898], [-121.96019, 37.73852], [-121.96038, 37.73849], [-121.96048, 37.73844], [-121.96118, 37.73791], [-121.96115, 37.73775], [-121.96175, 37.73738], [-121.96179, 37.73659], [-121.96358, 37.73746], [-121.96432, 37.73865]]]} | Open Access 1 | 47788 | Henry Ranch Park | 31666 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 18.636 | Henry Ranch Park | 0 | Local Park 2 | 4 | |
5500 | 5500 | 5499 | {"type": "Polygon", "coordinates": [[[-121.98475, 37.76566], [-121.98361, 37.76644], [-121.98328, 37.76637], [-121.98263, 37.76614], [-121.98252, 37.76603], [-121.98355, 37.76533], [-121.98328, 37.76506], [-121.98381, 37.76457], [-121.98394, 37.7647], [-121.98406, 37.76485], [-121.98433, 37.76526], [-121.98446, 37.7654], [-121.98475, 37.76566]]]} | Open Access 1 | 47789 | San Catanio Creek Park and Woodlot | 31667 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 4.624 | San Catanio Creek Park and Woodlot | None 446 | |||
6734 | 6734 | 6733 | {"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 | 5066 | Boone Acres | 31281 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 5.452 | Boone Acres | None 546 | |||
7081 | 7081 | 7080 | {"type": "Polygon", "coordinates": [[[-121.92134, 37.75018], [-121.9213, 37.75017], [-121.92118, 37.75035], [-121.92103, 37.75052], [-121.92089, 37.75063], [-121.92074, 37.75072], [-121.9204, 37.75087], [-121.92041, 37.7509], [-121.91949, 37.75122], [-121.91947, 37.75119], [-121.9195, 37.75114], [-121.91943, 37.75102], [-121.91937, 37.751], [-121.91899, 37.7504], [-121.91864, 37.74994], [-121.91826, 37.7495], [-121.91761, 37.74884], [-121.91764, 37.74881], [-121.9175, 37.74867], [-121.91744, 37.74867], [-121.91742, 37.74865], [-121.91833, 37.7481], [-121.91839, 37.74803], [-121.91872, 37.74752], [-121.91885, 37.74739], [-121.91902, 37.74728], [-121.91926, 37.74718], [-121.91953, 37.74714], [-121.91985, 37.74715], [-121.92011, 37.74723], [-121.92029, 37.74732], [-121.92045, 37.74743], [-121.92057, 37.74757], [-121.92066, 37.74773], [-121.92137, 37.74947], [-121.92141, 37.74967], [-121.92142, 37.74982], [-121.92138, 37.75003], [-121.92134, 37.75018]]]} | Open Access 1 | 47561 | Rancho San Ramon Park | 31280 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 23.464 | Rancho San Ramon Park | 0 | Local Park 2 | 4 | |
7086 | 7086 | 7085 | {"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 | 47563 | Mosaic Park | 31284 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 1.609 | Mosaic Park | 0 | Local Park 2 | 4 | |
7087 | 7087 | 7086 | {"type": "Polygon", "coordinates": [[[-121.92827, 37.77727], [-121.92804, 37.77725], [-121.92771, 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 | 47564 | Coyote Creek School Park | 31288 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 7.42 | Coyote Creek School Park | 0 | Local Park 2 | 4 | |
7088 | 7088 | 7087 | {"type": "Polygon", "coordinates": [[[-121.89439, 37.76297], [-121.89423, 37.7636], [-121.89427, 37.76362], [-121.89343, 37.76401], [-121.89292, 37.7633], [-121.89275, 37.7633], [-121.89268, 37.76317], [-121.89342, 37.76277], [-121.89439, 37.76297]]]} | Restricted Access 2 | 47566 | Hidden Hills School Park | 31291 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 3.032 | Hidden Hills School Park | 0 | Local Park 2 | 4 | |
8470 | 8470 | 8469 | {"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 | 13199 | Centennial Park | 17028 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 5.528 | Centennial Park | 0 | Local Park 2 | 4 | |
8471 | 8471 | 8470 | {"type": "Polygon", "coordinates": [[[-121.93101, 37.72813], [-121.93092, 37.72817], [-121.93056, 37.7283], [-121.9304, 37.72839], [-121.93026, 37.72841], [-121.92975, 37.7287], [-121.92917, 37.72874], [-121.92848, 37.72913], [-121.92835, 37.72899], [-121.92849, 37.72891], [-121.92856, 37.72879], [-121.9287, 37.72876], [-121.92915, 37.7285], [-121.9292, 37.72846], [-121.92923, 37.72838], [-121.92921, 37.7283], [-121.92901, 37.72806], [-121.92902, 37.728], [-121.92937, 37.72775], [-121.93021, 37.72728], [-121.93024, 37.72727], [-121.93101, 37.72813]]]} | Open Access 1 | 13201 | Richard Fahey Village Green | 31285 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 4.407 | Richard Fahey Village Green | 0 | Local Park 2 | 4 | |
8473 | 8473 | 8472 | {"type": "Polygon", "coordinates": [[[-121.94319, 37.7784], [-121.94287, 37.77836], [-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.94237, 37.78093], [-121.94237, 37.78121], [-121.94228, 37.78121], [-121.94222, 37.77952], [-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.94198, 37.7773], [-121.94184, 37.77732], [-121.94177, 37.77742], [-121.94095, 37.7778], [-121.94018, 37.7767], [-121.94014, 37.77661], [-121.94011, 37.77647], [-121.94012, 37.77631], [-121.94019, 37.77615], [-121.94025, 37.77606], [-121.94037, 37.77593], [-121.94049, 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 | 13209 | Coyote Crossing | 31283 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 11.589 | Coyote Crossing | None 709 | |||
8474 | 8474 | 8473 | {"type": "Polygon", "coordinates": [[[-121.92385, 37.78744], [-121.92375, 37.78823], [-121.92185, 37.78835], [-121.92151, 37.78783], [-121.92175, 37.78771], [-121.92181, 37.78772], [-121.92187, 37.78771], [-121.92192, 37.78769], [-121.922, 37.78759], [-121.9226, 37.78726], [-121.92295, 37.78703], [-121.923, 37.78705], [-121.92312, 37.78715], [-121.92329, 37.78726], [-121.92349, 37.78734], [-121.92385, 37.78744]]]} | Open Access 1 | 13211 | Red Willow Park | 24229 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 4.827 | Red Willow Park | 0 | Local Park 2 | 4 | |
8475 | 8475 | 8474 | {"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.9386, 37.77073], [-121.93918, 37.77072], [-121.9392, 37.7711]]]} | Open Access 1 | 13213 | Windy Hills Park | 27643 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 1.359 | Windy Hills Park | 2000 | Local Park 2 | 4 | |
11265 | 11265 | 11264 | {"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.76775], [-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 | 21945 | Central Park | 31279 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 41.371 | Central 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]);