units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
151 rows where ACCESS_TYP = 2, DES_TP = 2 and MNG_AG_TYP = 2 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, PARK_URL, COUNTY, YR_EST
MNG_AGENCY >30
- Whittier, City of 20
- San Ramon, City of 13
- Los Angeles, City of 7
- Arcadia, City of 7
- Manhattan Beach, City of 7
- Beverly Hills, City of 5
- San Diego, City of 4
- Fullerton, City of 4
- Vacaville, City of 4
- Hollister, City of 4
- Pasadena, City of 4
- Lawndale, City of 4
- Modesto, City of 4
- Glendora, City of 3
- Carlsbad, City of 3
- Palmdale, City of 3
- Mountain View, City of 3
- Garden Grove, City of 2
- Oceanside, City of 2
- Lake Elsinore, City of 2
- Cerritos, City of 2
- Bell Gardens, City of 2
- Long Beach, City of 2
- Sierra Madre, City of 2
- Sacramento, City of 2
- South El Monte, City of 2
- San Gabriel, City of 2
- Watsonville, City of 1
- Fresno, City of 1
- Santa Ana, City of 1
- …
MNG_AG_TYP 1
- City Agency · 151 ✖
DES_TP 1
- Local Park · 151 ✖
ACCESS_TYP 1
- Restricted Access · 151 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16267 | 16267 | 16266 | {"type": "MultiPolygon", "coordinates": [[[[-120.96798, 37.62431], [-120.9679, 37.62465], [-120.96772, 37.62462], [-120.9678, 37.62428], [-120.96798, 37.62431]]], [[[-120.96854, 37.6244], [-120.96834, 37.62437], [-120.96827, 37.6247], [-120.96809, 37.62467], [-120.96817, 37.62428], [-120.96853, 37.62433], [-120.96854, 37.6244]]], [[[-120.97082, 37.62484], [-120.97024, 37.62472], [-120.97023, 37.62482], [-120.96997, 37.62477], [-120.9698, 37.62476], [-120.96964, 37.62479], [-120.96944, 37.62487], [-120.96906, 37.62491], [-120.96905, 37.62476], [-120.96863, 37.62475], [-120.96864, 37.62414], [-120.9675, 37.62391], [-120.96745, 37.62417], [-120.96763, 37.6242], [-120.96754, 37.6246], [-120.96736, 37.62457], [-120.96744, 37.62418], [-120.96708, 37.62412], [-120.96672, 37.62408], [-120.96663, 37.62447], [-120.96632, 37.62442], [-120.96629, 37.6244], [-120.96626, 37.62432], [-120.96624, 37.6242], [-120.96623, 37.62277], [-120.96846, 37.62263], [-120.96924, 37.62277], [-120.97081, 37.62292], [-120.97082, 37.62484]]]]} | Restricted Access 2 | 34896 | Tuolumne River Regional Park | 6748 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 19.414 | Tuolumne River RP | 0 | Local Park 2 | 4 | |
16368 | 16368 | 16367 | {"type": "MultiPolygon", "coordinates": [[[[-120.96864, 37.62414], [-120.96864, 37.62434], [-120.96817, 37.62428], [-120.96808, 37.62467], [-120.9679, 37.62465], [-120.96799, 37.62426], [-120.96782, 37.62423], [-120.96772, 37.62462], [-120.96754, 37.6246], [-120.96762, 37.62421], [-120.96745, 37.62418], [-120.96736, 37.62457], [-120.96663, 37.62447], [-120.96672, 37.62407], [-120.9669, 37.6241], [-120.96689, 37.62415], [-120.96706, 37.62418], [-120.96708, 37.62412], [-120.96744, 37.62417], [-120.96749, 37.62391], [-120.96864, 37.62414]]], [[[-120.96854, 37.62474], [-120.96827, 37.6247], [-120.96834, 37.62437], [-120.96854, 37.6244], [-120.96854, 37.62474]]], [[[-120.9746, 37.62611], [-120.97324, 37.62554], [-120.97195, 37.62512], [-120.97082, 37.62484], [-120.97081, 37.62292], [-120.97343, 37.62388], [-120.97378, 37.62412], [-120.97459, 37.62461], [-120.9746, 37.62611]]]]} | Restricted Access 2 | 34897 | Tuolumne River Regional Park | 6748 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 17.831 | Tuolumne River RP | 0 | Local Park 2 | 4 | |
672 | 672 | 671 | {"type": "Polygon", "coordinates": [[[-122.10311, 37.87618], [-122.10304, 37.87629], [-122.10157, 37.87704], [-122.10079, 37.87704], [-122.10071, 37.87693], [-122.10056, 37.87677], [-122.09956, 37.8759], [-122.09896, 37.87548], [-122.09889, 37.87537], [-122.09866, 37.87468], [-122.09864, 37.87453], [-122.10311, 37.87618]]]} | Restricted Access 2 | 5104 | 711 St. Mary's Road Park | 15210 | 1163 | Lafayette, City of 236 | City 2 | City Agency 2 | http://www.ci.lafayette.ca.us/index.aspx?page=87 | City 2 | 1163 | Lafayette, City of 232 | City 2 | City Agency 2 | Contra Costa 12 | 11.502 | 711 St. Mary's Road Park | 1983 | 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 | |
14210 | 14210 | 14209 | {"type": "Polygon", "coordinates": [[[-117.89549, 33.9268], [-117.89549, 33.92741], [-117.89547, 33.92752], [-117.89199, 33.92753], [-117.89193, 33.92519], [-117.89201, 33.9251], [-117.8935, 33.92506], [-117.89355, 33.9268], [-117.89549, 33.9268]]]} | Restricted Access 2 | 44076 | Brea Junior High Park | 16342 | 2311 | Brea Olinda Unified School District 1100 | Special District 4 | School District 14 | http://www.bousd.k12.ca.us/ | Special District 4 | 1033 | Brea, City of 229 | City 2 | City Agency 2 | Orange 3 | 13.284 | Brea Junior High Park | 0 | Local Park 2 | 4 | |
14208 | 14208 | 14207 | {"type": "Polygon", "coordinates": [[[-121.51769, 38.52549], [-121.51733, 38.52654], [-121.51561, 38.52607], [-121.51615, 38.52487], [-121.51653, 38.52496], [-121.51707, 38.52504], [-121.51707, 38.52545], [-121.51769, 38.52549]]]} | Restricted Access 2 | 44071 | Cabrillo School Park | 16644 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.003 | Cabrillo School Park | 0 | Local Park 2 | 4 | |
14270 | 14270 | 14269 | {"type": "Polygon", "coordinates": [[[-121.41823, 36.85522], [-121.41821, 36.85579], [-121.41762, 36.85577], [-121.41756, 36.85611], [-121.41681, 36.85613], [-121.41681, 36.85719], [-121.41572, 36.85714], [-121.4157, 36.85711], [-121.41574, 36.85598], [-121.41578, 36.85511], [-121.41823, 36.85522]]]} | Restricted Access 2 | 44193 | Calaveras School Park | 16672 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | San Benito 38 | 8.022 | Calaveras School Park | 0 | Local Park 2 | 4 | |
13045 | 13045 | 13044 | {"type": "Polygon", "coordinates": [[[-122.17111, 37.72884], [-122.17104, 37.72922], [-122.17093, 37.7291], [-122.17108, 37.72899], [-122.17109, 37.7289], [-122.17023, 37.72814], [-122.16981, 37.72808], [-122.16974, 37.72827], [-122.16965, 37.72826], [-122.16952, 37.72826], [-122.16913, 37.7282], [-122.16888, 37.72809], [-122.16876, 37.728], [-122.16863, 37.72786], [-122.16855, 37.7277], [-122.16845, 37.7274], [-122.16827, 37.72711], [-122.16811, 37.72693], [-122.1679, 37.72677], [-122.16765, 37.72669], [-122.16744, 37.72668], [-122.16672, 37.72685], [-122.16664, 37.72686], [-122.1665, 37.72685], [-122.1664, 37.72683], [-122.16629, 37.72676], [-122.16623, 37.72672], [-122.16624, 37.7267], [-122.16616, 37.72657], [-122.16677, 37.7265], [-122.16698, 37.72645], [-122.16711, 37.72639], [-122.16755, 37.72638], [-122.16774, 37.72639], [-122.16826, 37.72681], [-122.16855, 37.72713], [-122.16894, 37.72763], [-122.1689, 37.72781], [-122.17018, 37.72802], [-122.17111, 37.72884]]]} | Restricted Access 2 | 34888 | Cherrywood Park | 17175 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 3.331 | Cherrywood 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 | |
9733 | 9733 | 9732 | {"type": "Polygon", "coordinates": [[[-122.20028, 37.35643], [-122.20024, 37.35647], [-122.19706, 37.35796], [-122.1956, 37.35913], [-122.19551, 37.35915], [-122.19283, 37.36128], [-122.19343, 37.364], [-122.19163, 37.36491], [-122.19121, 37.36486], [-122.18979, 37.36548], [-122.18785, 37.36605], [-122.18758, 37.36631], [-122.18746, 37.3668], [-122.18581, 37.36661], [-122.18362, 37.36568], [-122.1833, 37.36619], [-122.18307, 37.36647], [-122.18209, 37.36668], [-122.18172, 37.36693], [-122.18155, 37.3674], [-122.18133, 37.36761], [-122.18086, 37.36775], [-122.18039, 37.36775], [-122.17994, 37.36759], [-122.17931, 37.36763], [-122.17847, 37.36744], [-122.17787, 37.36834], [-122.17612, 37.3684], [-122.17396, 37.37054], [-122.17031, 37.37008], [-122.17135, 37.36699], [-122.17198, 37.36518], [-122.17335, 37.36092], [-122.17368, 37.36063], [-122.1744, 37.36062], [-122.17451, 37.36045], [-122.17473, 37.36023], [-122.17521, 37.35985], [-122.17572, 37.35871], [-122.17541, 37.35837], [-122.17478, 37.35829], [-122.1746, 37.35829], [-122.17433, 37.35832], [-122.17417, 37.35828], [-122.17865, 37.34535], [-122.18261, 37.33356], [-122.18261, 37.33335], [-122.18272, 37.333], [-122.18278, 37.33298], [-122.18293, 37.33313], [-122.18307, 37.33336], [-122.18316, 37.3336], [-122.18354, 37.33423], [-122.18396, 37.33471], [-122.18422, 37.33493], [-122.18425, 37.33503], [-122.18425, 37.33511], [-122.18433, 37.33527], [-122.18455, 37.33559], [-122.18472, 37.33589], [-122.18511, 37.33643], [-122.18569, 37.33745], [-122.18575, 37.33774], [-122.18573, 37.33808], [-122.18575, 37.33829], [-122.1858, 37.33847], [-122.18587, 37.33862], [-122.18598, 37.33872], [-122.18642, 37.33897], [-122.18674, 37.33917], [-122.18701, 37.33938], [-122.18755, 37.33983], [-122.18816, 37.34023], [-122.18896, 37.34079], [-122.18981, 37.34152], [-122.19022, 37.34193], [-122.19054, 37.34227], [-122.19063, 37.34234], [-122.19078, 37.34256], [-122.19104, 37.34304], [-122.19123, 37.34331], [-122.19132, 37.3434], [-122.19172, 37.34369], [-122.19225, 37.34397], [-122.19245, 37.34411], [-122.19334, 37.34485], [-122.19415, 37.34572], [-122.19477, 37.34656], [-122.19495, 37.34674], [-122.19507, 37.3469], [-122.19527, 37.34727], [-122.19537, 37.34737], [-122.19573, 37.34791], [-122.19587, 37.34819], [-122.19587, 37.34861], [-122.19583, 37.3488], [-122.19585, 37.34915], [-122.19597, 37.3496], [-122.19595, 37.34979], [-122.19585, 37.34997], [-122.19578, 37.35027], [-122.19576, 37.35063], [-122.19589, 37.35103], [-122.19597, 37.35123], [-122.19616, 37.35138], [-122.19628, 37.35152], [-122.19681, 37.35201], [-122.19698, 37.35212], [-122.19724, 37.35244], [-122.19734, 37.35259], [-122.19748, 37.35297], [-122.19769, 37.35325], [-122.19788, 37.35361], [-122.19802, 37.35406], [-122.19823, 37.35432], [-122.19849, 37.35445], [-122.19866, 37.35465], [-122.19887, 37.35483], [-122.1992, 37.35517], [-122.19939, 37.35529], [-122.19955, 37.35533], [-122.19972, 37.35545], [-122.19997, 37.35579], [-122.20002, 37.35596], [-122.20014, 37.35615], [-122.20028, 37.35643]]]} | Restricted Access 2 | 16498 | Foothills Park | 18984 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 1303.372 | Foothills Park | 2000 | Local Park 2 | 4 | |
1030 | 1030 | 1029 | {"type": "Polygon", "coordinates": [[[-118.04152, 33.87135], [-118.04149, 33.87145], [-118.04152, 33.87159], [-118.04153, 33.87191], [-118.04149, 33.87195], [-118.04002, 33.87196], [-118.03998, 33.87195], [-118.03997, 33.87192], [-118.04, 33.87181], [-118.03999, 33.87176], [-118.03996, 33.87172], [-118.0399, 33.87171], [-118.03989, 33.87119], [-118.04023, 33.87119], [-118.04045, 33.87115], [-118.04068, 33.87106], [-118.04094, 33.87089], [-118.04112, 33.87082], [-118.04125, 33.8708], [-118.04146, 33.8708], [-118.0415, 33.87082], [-118.04152, 33.87135]]]} | Restricted Access 2 | 5646 | Friendship Park | 19120 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 3.848 | Friendship Park | 0 | Local Park 2 | 4 | |
14241 | 14241 | 14240 | {"type": "Polygon", "coordinates": [[[-117.90149, 33.74169], [-117.90036, 33.7417], [-117.90037, 33.74], [-117.90142, 33.73999], [-117.90142, 33.7407], [-117.90149, 33.74074], [-117.90149, 33.74169]]]} | Restricted Access 2 | 44131 | Friendship Park | 19123 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 4.747 | Friendship Park | 0 | Local Park 2 | 4 | |
6022 | 6022 | 6021 | {"type": "Polygon", "coordinates": [[[-118.06026, 33.87842], [-118.05959, 33.87842], [-118.05956, 33.87688], [-118.06001, 33.87688], [-118.06019, 33.87686], [-118.06024, 33.87689], [-118.06026, 33.87842]]]} | Restricted Access 2 | 729 | Frontier Park | 19131 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 2.643 | Frontier 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 | |
9833 | 9833 | 9832 | {"type": "MultiPolygon", "coordinates": [[[[-121.90925, 37.34333], [-121.90916, 37.3434], [-121.90913, 37.34339], [-121.90887, 37.3436], [-121.90847, 37.34388], [-121.9075, 37.34298], [-121.90857, 37.34223], [-121.90949, 37.34309], [-121.90948, 37.34314], [-121.90925, 37.34331], [-121.90925, 37.34333]]], [[[-121.9128, 37.35228], [-121.91234, 37.35264], [-121.91191, 37.3534], [-121.9114, 37.35387], [-121.91081, 37.35295], [-121.90954, 37.35053], [-121.90947, 37.35042], [-121.91082, 37.34945], [-121.91086, 37.34946], [-121.91123, 37.34978], [-121.91112, 37.34984], [-121.91122, 37.34994], [-121.91167, 37.3509], [-121.91219, 37.35054], [-121.91252, 37.35098], [-121.91199, 37.35129], [-121.91255, 37.35174], [-121.9128, 37.35228]]]]} | Restricted Access 2 | 16812 | Guadalupe Gardens | 19544 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 21.614 | Guadalupe Gardens | 0 | Local Park 2 | 4 | |
14223 | 14223 | 14222 | {"type": "Polygon", "coordinates": [[[-118.19795, 33.88644], [-118.1967, 33.88649], [-118.19658, 33.88513], [-118.19786, 33.88512], [-118.19795, 33.88644]]]} | Restricted Access 2 | 44117 | Kelly Park | 20587 | 1065 | Compton, City of 276 | City 2 | City Agency 2 | http://www.comptoncity.org/index.php/Parks-and-Recreation/parks-and-recreation-overview.htm | City 2 | 1065 | Compton, City of 271 | City 2 | City Agency 2 | Los Angeles 6 | 4.325 | Kelly Park | 0 | Local Park 2 | 4 | |
7199 | 7199 | 7198 | {"type": "Polygon", "coordinates": [[[-120.97533, 37.62623], [-120.97481, 37.62623], [-120.97482, 37.62608], [-120.97533, 37.62607], [-120.97533, 37.62623]]]} | Restricted Access 2 | 34894 | Legion Park | 21143 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 0.197 | Legion Park | 0 | Local Park 2 | 4 | |
13046 | 13046 | 13045 | {"type": "Polygon", "coordinates": [[[-120.97835, 37.62482], [-120.97835, 37.6252], [-120.97609, 37.62409], [-120.9755, 37.62372], [-120.97562, 37.62339], [-120.97585, 37.62358], [-120.97681, 37.62388], [-120.97819, 37.62474], [-120.97835, 37.62482]]]} | Restricted Access 2 | 34895 | Mancini Park | 21733 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 3.106 | Mancini Park | 0 | Local Park 2 | 4 | |
14212 | 14212 | 14211 | {"type": "Polygon", "coordinates": [[[-121.49653, 38.54876], [-121.49596, 38.55049], [-121.49243, 38.54982], [-121.49273, 38.54884], [-121.493, 38.54889], [-121.4931, 38.54873], [-121.49326, 38.54876], [-121.49334, 38.54854], [-121.49353, 38.54857], [-121.49363, 38.54821], [-121.49653, 38.54876]]]} | Restricted Access 2 | 44078 | McClatchy School Park | 21999 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 14.624 | McClatchy School 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 |
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]);