units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
45 rows where DES_TP = 2, MNG_AGENCY = 68 and MNG_AG_TYP = 2 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
ACCESS_TYP 2
- Open Access 32
- Restricted Access 13
MNG_AG_TYP 1
- City Agency · 45 ✖
MNG_AGENCY 1
- San Ramon, City of · 45 ✖
DES_TP 1
- Local Park · 45 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13093 | 13093 | 13092 | {"type": "Polygon", "coordinates": [[[-121.89342, 37.74775], [-121.89308, 37.74836], [-121.89295, 37.74847], [-121.89281, 37.74855], [-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.89268, 37.74762], [-121.89289, 37.74762], [-121.89312, 37.74764], [-121.89336, 37.74769], [-121.89338, 37.7477], [-121.89342, 37.74775]]]} | Open Access 1 | 35013 | Arlington Park | 15591 | 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.03 | Arlington Park | 0 | Local Park 2 | 4 | |
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 | |
11602 | 11602 | 11601 | {"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 | 23708 | Bellingham Square | 15991 | 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.044 | Bellingham Square | 0 | Local Park 2 | 4 | |
14237 | 14237 | 14236 | {"type": "Polygon", "coordinates": [[[-121.97293, 37.76113], [-121.97254, 37.7613], [-121.97237, 37.76105], [-121.97216, 37.76105], [-121.9722, 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 | 44124 | Bollinger Canyon School Park | 16244 | 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 | 5.795 | Bollinger Canyon 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 | |
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 | |
13096 | 13096 | 13095 | {"type": "Polygon", "coordinates": [[[-121.88576, 37.74692], [-121.88539, 37.74704], [-121.88548, 37.74724], [-121.88454, 37.74731], [-121.88447, 37.74671], [-121.88488, 37.74668], [-121.88492, 37.74664], [-121.88502, 37.74667], [-121.88511, 37.74664], [-121.88515, 37.74667], [-121.88554, 37.74664], [-121.88561, 37.74671], [-121.88555, 37.74678], [-121.88557, 37.74685], [-121.88563, 37.74689], [-121.88576, 37.74692]]]} | Open Access 1 | 35015 | Compass Point Park | 17570 | 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.496 | Compass Point Park | 0 | Local Park 2 | 4 | |
14227 | 14227 | 14226 | {"type": "Polygon", "coordinates": [[[-121.94225, 37.72945], [-121.94179, 37.72969], [-121.94173, 37.72975], [-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.93967, 37.72887], [-121.93995, 37.72874], [-121.94032, 37.7292], [-121.94159, 37.7286], [-121.94225, 37.72945]]]} | Restricted Access 2 | 44105 | Country Club School Park | 17695 | 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.158 | Country Club School 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 | |
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 | |
13102 | 13102 | 13101 | {"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.77015], [-121.92218, 37.76978], [-121.92198, 37.76942], [-121.92295, 37.76955], [-121.9242, 37.76983], [-121.92429, 37.76993], [-121.92433, 37.77005], [-121.92454, 37.77001], [-121.92461, 37.77022], [-121.92463, 37.77037]]]} | Open Access 1 | 35020 | Creekside Park | 17779 | 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 | 6.012 | Creekside Park | 0 | Local Park 2 | 4 | |
14588 | 14588 | 14587 | {"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.98764, 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.77144], [-121.98812, 37.7711], [-121.98896, 37.77143], [-121.98925, 37.77116], [-121.98911, 37.77088], [-121.98923, 37.77073], [-121.98976, 37.77051], [-121.9901, 37.77079], [-121.98962, 37.77112], [-121.98963, 37.77115], [-121.98981, 37.77129], [-121.99035, 37.77145], [-121.9904, 37.7715]]]} | Open Access 1 | 47574 | Crow Canyon Gardens | 31299 | 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 | 7.457 | Crow Canyon Gardens | 0 | Local Park 2 | 4 | |
11292 | 11292 | 11291 | {"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 | 21970 | Del Mar Dog Park | 18030 | 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 | 3.734 | Del Mar Dog Park | 0 | Local Park 2 | 4 | |
11605 | 11605 | 11604 | {"type": "Polygon", "coordinates": [[[-121.90018, 37.76147], [-121.90015, 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.89906, 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.7602], [-121.89991, 37.76029], [-121.90009, 37.76085], [-121.90013, 37.76102], [-121.90018, 37.76147]]]} | Open Access 1 | 23709 | East Branch Park | 18364 | 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.077 | East Branch Park | 0 | Local Park 2 | 4 | |
13098 | 13098 | 13097 | {"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 | 35017 | Fire Truck Park | 18909 | 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.143 | Fire Truck Park | 0 | Local Park 2 | 4 | |
13103 | 13103 | 13102 | {"type": "Polygon", "coordinates": [[[-121.91287, 37.76913], [-121.91284, 37.76942], [-121.91276, 37.76971], [-121.91183, 37.77083], [-121.91053, 37.77015], [-121.91165, 37.76845], [-121.91176, 37.76849], [-121.91249, 37.76818], [-121.91267, 37.76845], [-121.91277, 37.76865], [-121.91284, 37.76889], [-121.91287, 37.76913]]]} | Restricted Access 2 | 35021 | Gale Ranch Middle School Park | 31290 | 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.61 | Gale Ranch Middle School Park | 0 | Local Park 2 | 4 | |
14215 | 14215 | 14214 | {"type": "Polygon", "coordinates": [[[-121.94491, 37.78771], [-121.94478, 37.78784], [-121.94467, 37.78781], [-121.94454, 37.78785], [-121.94428, 37.78813], [-121.94429, 37.78815], [-121.94463, 37.7882], [-121.94463, 37.78826], [-121.94451, 37.78824], [-121.94394, 37.78832], [-121.9436, 37.78851], [-121.94337, 37.78825], [-121.94307, 37.78788], [-121.94292, 37.78777], [-121.9427, 37.78767], [-121.94282, 37.78743], [-121.9428, 37.78741], [-121.94396, 37.78677], [-121.94429, 37.78718], [-121.94454, 37.78743], [-121.94491, 37.78771]]]} | Restricted Access 2 | 44122 | Golden View School Park | 19375 | 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 | 4.778 | Golden View School Park | 0 | Local Park 2 | 4 | |
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 | |
11904 | 11904 | 11903 | {"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 | 24473 | Hidden Crest Park | 19906 | 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 | 2.067 | Hidden Crest 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 |
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]);