units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
60 rows where MNG_AGENCY = 68 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, 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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17026 | 17026 | 17025 | {"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 | 13203 | Alcosta Senior and Community Center Park and Gardens | 31296 | 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.203 | Alcosta Senior and Community Ctr. Park and Gardens | 0 | Local Recreation Area 3 | 4 | |
16148 | 16148 | 16147 | {"type": "MultiPolygon", "coordinates": [[[[-121.92414, 37.73649], [-121.92312, 37.73694], [-121.92384, 37.73797], [-121.92359, 37.73798], [-121.92319, 37.73795], [-121.92281, 37.73784], [-121.92246, 37.73768], [-121.92216, 37.73746], [-121.92204, 37.73734], [-121.92147, 37.73656], [-121.92135, 37.7364], [-121.92121, 37.73626], [-121.92104, 37.73612], [-121.92086, 37.73601], [-121.92067, 37.7359], [-121.92042, 37.73581], [-121.92078, 37.73564], [-121.92073, 37.73482], [-121.92053, 37.73475], [-121.92019, 37.73442], [-121.91904, 37.73433], [-121.9188, 37.73408], [-121.9184, 37.73421], [-121.91836, 37.73402], [-121.91828, 37.73383], [-121.91868, 37.73371], [-121.91857, 37.73344], [-121.91842, 37.73321], [-121.91809, 37.73281], [-121.9177, 37.73244], [-121.91719, 37.73187], [-121.91715, 37.73165], [-121.91695, 37.73119], [-121.91681, 37.73095], [-121.9167, 37.7307], [-121.91659, 37.73056], [-121.91622, 37.73048], [-121.91595, 37.73065], [-121.91608, 37.73088], [-121.91615, 37.73111], [-121.91608, 37.73115], [-121.91602, 37.7309], [-121.91589, 37.73069], [-121.91564, 37.73039], [-121.91497, 37.73023], [-121.91465, 37.73028], [-121.91464, 37.7303], [-121.91476, 37.73055], [-121.91473, 37.73068], [-121.91471, 37.73074], [-121.91454, 37.73078], [-121.91451, 37.73084], [-121.91471, 37.73128], [-121.91481, 37.73156], [-121.91497, 37.73186], [-121.91475, 37.7323], [-121.91473, 37.73254], [-121.91461, 37.73269], [-121.91467, 37.73281], [-121.915, 37.73276], [-121.91531, 37.7328], [-121.91543, 37.73312], [-121.91544, 37.73342], [-121.91573, 37.73374], [-121.91583, 37.73376], [-121.91585, 37.73389], [-121.91599, 37.73399], [-121.91615, 37.73404], [-121.91648, 37.73399], [-121.91668, 37.73401], [-121.91678, 37.73404], [-121.91676, 37.73411], [-121.91691, 37.73418], [-121.9174, 37.73418], [-121.91759, 37.73415], [-121.91775, 37.73415], [-121.91778, 37.73422], [-121.91781, 37.73446], [-121.91824, 37.73445], [-121.91836, 37.73509], [-121.91866, 37.73576], [-121.91863, 37.73581], [-121.91841, 37.7359], [-121.91822, 37.73601], [-121.91804, 37.73612], [-121.91787, 37.73625], [-121.91773, 37.7364], [-121.91761, 37.73655], [-121.9175, 37.73672], [-121.91742, 37.73689], [-121.91714, 37.73761], [-121.9171, 37.73764], [-121.91707, 37.73765], [-121.91692, 37.73759], [-121.91687, 37.73754], [-121.91676, 37.73741], [-121.91713, 37.73713], [-121.91717, 37.73627], [-121.91719, 37.7361], [-121.91718, 37.73609], [-121.91723, 37.7359], [-121.91726, 37.7359], [-121.91732, 37.73575], [-121.91731, 37.73567], [-121.91726, 37.7356], [-121.91712, 37.73549], [-121.91673, 37.7353], [-121.91624, 37.73496], [-121.91585, 37.73474], [-121.91569, 37.73467], [-121.91559, 37.73464], [-121.91557, 37.73465], [-121.91537, 37.73458], [-121.91519, 37.73447], [-121.91488, 37.73435], [-121.91463, 37.73411], [-121.91451, 37.73411], [-121.9145, 37.73413], [-121.91447, 37.73414], [-121.91443, 37.73407], [-121.91438, 37.73405], [-121.9143, 37.73406], [-121.91424, 37.73409], [-121.91418, 37.73417], [-121.91406, 37.73424], [-121.91377, 37.73437], [-121.91375, 37.73435], [-121.91368, 37.73434], [-121.91326, 37.73403], [-121.91326, 37.73397], [-121.91325, 37.73395], [-121.91345, 37.73376], [-121.9135, 37.7337], [-121.91353, 37.7336], [-121.91351, 37.73352], [-121.91343, 37.73332], [-121.91333, 37.73316], [-121.91285, 37.73268], [-121.91276, 37.73253], [-121.91274, 37.73245], [-121.91271, 37.73229], [-121.91279, 37.73168], [-121.91286, 37.73137], [-121.91315, 37.73033], [-121.91311, 37.73029], [-121.91314, 37.72992], [-121.92226, 37.72771], [-121.92254, 37.72843], [-121.92259, 37.72862], [-121.92261, 37.72875], [-121.92257, 37.72929], [-121.92259, 37.72955], [-121.92264, 37.72973], [-121.92312, 37.73104], [-121.92316, 37.73131], [-121.92317, 37.73206], [-121.92235, 37.73208], [-121.9226, 37.73371], [-121.92386, 37.73452], [-121.92414, 37.73649]]], [[[-121.91703, 37.73787], [-121.91682, 37.73839], [-121.91664, 37.73867], [-121.91652, 37.7388], [-121.91638, 37.73891], [-121.91606, 37.73911], [-121.91589, 37.73919], [-121.91586, 37.73919], [-121.91581, 37.73918], [-121.91568, 37.73883], [-121.91566, 37.7387], [-121.91567, 37.73763], [-121.91565, 37.73748], [-121.91559, 37.73733], [-121.9155, 37.7372], [-121.91537, 37.73708], [-121.9146, 37.73667], [-121.91444, 37.73657], [-121.91354, 37.73582], [-121.91339, 37.73566], [-121.91313, 37.73525], [-121.91304, 37.73506], [-121.91302, 37.7349], [-121.91303, 37.73439], [-121.91305, 37.73426], [-121.91309, 37.73417], [-121.91313, 37.73414], [-121.91319, 37.73414], [-121.91323, 37.73416], [-121.91362, 37.73445], [-121.91366, 37.73452], [-121.91382, 37.73492], [-121.91389, 37.73507], [-121.91401, 37.7352], [-121.91463, 37.73578], [-121.91482, 37.73605], [-121.91493, 37.73618], [-121.91509, 37.7363], [-121.91572, 37.73668], [-121.91639, 37.73719], [-121.91651, 37.73732], [-121.91671, 37.73767], [-121.91686, 37.73779], [-121.917, 37.73784], [-121.91703, 37.73787]]], [[[-121.91801, 37.74363], [-121.91747, 37.74583], [-121.91653, 37.74567], [-121.91661, 37.74537], [-121.91691, 37.74541], [-121.91699, 37.74539], [-121.91708, 37.74531], [-121.91717, 37.74513], [-121.91722, 37.74495], [-121.91726, 37.74476], [-121.91727, 37.74457], [-121.91726, 37.74446], [-121.91724, 37.74439], [-121.9172, 37.74435], [-121.91712, 37.74431], [-121.91644, 37.74429], [-121.91639, 37.74428], [-121.91637, 37.74424], [-121.91634, 37.74355], [-121.91635, 37.7433], [-121.91655, 37.7425], [-121.91657, 37.74238], [-121.91657, 37.74221], [-121.91667, 37.74185], [-121.91667, 37.74173], [-121.91661, 37.74155], [-121.91646, 37.74131], [-121.91607, 37.74048], [-121.91602, 37.74033], [-121.91599, 37.74017], [-121.91598, 37.7398], [-121.91592, 37.73952], [-121.91594, 37.73949], [-121.91617, 37.73939], [-121.9164, 37.73928], [-121.91664, 37.7395], [-121.91653, 37.7396], [-121.91647, 37.73972], [-121.91647, 37.74004], [-121.91654, 37.7403], [-121.91663, 37.74048], [-121.91729, 37.74149], [-121.91734, 37.74164], [-121.91734, 37.74175], [-121.91732, 37.74184], [-121.91715, 37.74213], [-121.91711, 37.74223], [-121.9171, 37.74233], [-121.91709, 37.74262], [-121.91691, 37.74313], [-121.91691, 37.74335], [-121.91693, 37.7434], [-121.91698, 37.74344], [-121.91699, 37.74372], [-121.91724, 37.74372], [-121.91801, 37.74363]]]]} | Open Access 1 | 48561 | Old Ranch Open Space | 33275 | 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 | 160.066 | Old Ranch OS | 0 | Local Recreation Area 3 | 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 | |
14579 | 14579 | 14578 | {"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.91883, 37.77323], [-121.91886, 37.77329], [-121.91837, 37.77321], [-121.91835, 37.77319], [-121.91841, 37.77292], [-121.91842, 37.77279], [-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 | 47571 | Bark and Ride | 31297 | 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.774 | Bark and Ride | 0 | None 1242 | ||
14252 | 14252 | 14251 | {"type": "Polygon", "coordinates": [[[-121.91434, 37.76167], [-121.91237, 37.76248], [-121.9117, 37.76149], [-121.91173, 37.76142], [-121.91358, 37.76063], [-121.91365, 37.76065], [-121.91434, 37.76167]]]} | Restricted Access 2 | 44172 | Quail Run Park | 31591 | 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 | 6.391 | Quail Run Park | 0 | Local Park 2 | 4 | |
14238 | 14238 | 14237 | {"type": "Polygon", "coordinates": [[[-121.95137, 37.75529], [-121.95025, 37.75568], [-121.95026, 37.75575], [-121.94955, 37.75603], [-121.94872, 37.75487], [-121.95042, 37.75417], [-121.95075, 37.75467], [-121.95116, 37.75511], [-121.95137, 37.75529]]]} | Restricted Access 2 | 44126 | Montevideo School Park | 22435 | 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 | 6.15 | Montevideo School Park | 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 | |
14234 | 14234 | 14233 | {"type": "Polygon", "coordinates": [[[-121.9381, 37.74068], [-121.93767, 37.74085], [-121.93742, 37.74094], [-121.93721, 37.74099], [-121.93699, 37.74102], [-121.93652, 37.74105], [-121.93627, 37.74109], [-121.93549, 37.7397], [-121.93684, 37.73917], [-121.9381, 37.74068]]]} | Restricted Access 2 | 44112 | Walt Disney School Park | 27245 | 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 | 6.985 | Walt Disney School Park | 0 | Local Park 2 | 4 | |
14229 | 14229 | 14228 | {"type": "Polygon", "coordinates": [[[-121.95043, 37.74153], [-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]]]} | Restricted Access 2 | 44108 | Neil Armstrong School Park | 22687 | 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.399 | Neil Armstrong School 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 | |
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 | |
14214 | 14214 | 14213 | {"type": "Polygon", "coordinates": [[[-121.9876, 37.76853], [-121.98744, 37.76865], [-121.98732, 37.76882], [-121.98698, 37.76998], [-121.98688, 37.7701], [-121.98675, 37.77019], [-121.98566, 37.76912], [-121.98609, 37.7689], [-121.98606, 37.76878], [-121.98611, 37.76873], [-121.98623, 37.76869], [-121.98634, 37.7685], [-121.98633, 37.76837], [-121.98622, 37.76824], [-121.98677, 37.76779], [-121.98701, 37.76794], [-121.9876, 37.76853]]]} | Restricted Access 2 | 44087 | Twin Creeks School Park | 26613 | 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.487 | Twin Creeks School Park | 0 | Local Park 2 | 4 | |
13105 | 13105 | 13104 | {"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 | 35023 | Picadilly Park | 23647 | 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.141 | Picadilly Park | 0 | Local Park 2 | 4 | |
13104 | 13104 | 13103 | {"type": "Polygon", "coordinates": [[[-121.91045, 37.77535], [-121.91011, 37.77538], [-121.91021, 37.77566], [-121.90999, 37.77574], [-121.90979, 37.77588], [-121.90969, 37.77601], [-121.90941, 37.77644], [-121.90936, 37.77645], [-121.90923, 37.77638], [-121.90909, 37.77628], [-121.90879, 37.77595], [-121.90866, 37.77575], [-121.90855, 37.77554], [-121.90849, 37.77532], [-121.90847, 37.77512], [-121.9085, 37.77488], [-121.90857, 37.77468], [-121.90868, 37.77448], [-121.90886, 37.77427], [-121.90893, 37.77427], [-121.90924, 37.77445], [-121.90979, 37.77471], [-121.90994, 37.77474], [-121.91007, 37.77476], [-121.91039, 37.77472], [-121.91044, 37.77494], [-121.91045, 37.77535]]]} | Open Access 1 | 35022 | Monarch Park | 22366 | 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.352 | Monarch 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 | |
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 | |
13101 | 13101 | 13100 | {"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 | 35019 | Tassajara Ridge Staging Area | 26196 | 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.033 | Tassajara Ridge Staging Area | None 1136 | |||
13100 | 13100 | 13099 | {"type": "Polygon", "coordinates": [[[-121.89815, 37.75171], [-121.89815, 37.75174], [-121.89683, 37.75276], [-121.89652, 37.75305], [-121.89618, 37.75341], [-121.89535, 37.75294], [-121.89541, 37.75271], [-121.89423, 37.75248], [-121.89437, 37.75216], [-121.89453, 37.75187], [-121.89473, 37.75157], [-121.89489, 37.75139], [-121.89512, 37.75121], [-121.89648, 37.75034], [-121.89787, 37.75148], [-121.89786, 37.7515], [-121.89789, 37.75153], [-121.89792, 37.75152], [-121.89815, 37.75171]]]} | Open Access 1 | 35018 | San Ramon Sports Park | 24987 | 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 | 15.01 | San Ramon Sports Park | 0 | Local Recreation Area 3 | 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 | |
13097 | 13097 | 13096 | {"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 | 35016 | Ramona Park | 24121 | 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.098 | Ramona 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]);