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 map
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3237 | 3237 | 3236 | {"type": "MultiPolygon", "coordinates": [[[[-115.58465, 32.79644], [-115.5824, 32.79643], [-115.58235, 32.79448], [-115.58464, 32.79447], [-115.58465, 32.79644]]], [[[-115.58623, 32.79447], [-115.58623, 32.79645], [-115.58486, 32.79644], [-115.58485, 32.79446], [-115.58623, 32.79447]]]]} | Restricted Access 2 | 48110 | Sunflower Park | 32835 | 2422 | El Centro Elementary School District 602 | Special District 4 | School District 14 | www.ecesd.org | Special District 4 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 18.451 | Sunflower Park | 2000 | Local Park 2 | 4 |
2799 | 2799 | 2798 | {"type": "MultiPolygon", "coordinates": [[[[-117.05969, 32.76384], [-117.05963, 32.76392], [-117.05829, 32.76395], [-117.05834, 32.7639], [-117.05835, 32.76382], [-117.05963, 32.76378], [-117.05966, 32.76379], [-117.05969, 32.76384]]], [[[-117.06115, 32.76232], [-117.06114, 32.76248], [-117.06111, 32.76257], [-117.06106, 32.76264], [-117.06009, 32.76351], [-117.06004, 32.76235], [-117.06115, 32.76232]]]]} | Restricted Access 2 | 18582 | Clay Neighborhood Park | 31592 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.413 | Clay Neighborhood Park | 0 | Local Park 2 | 4 | |
9066 | 9066 | 9065 | {"type": "MultiPolygon", "coordinates": [[[[-117.36226, 33.19259], [-117.3624, 33.19418], [-117.36239, 33.19436], [-117.36236, 33.1945], [-117.36229, 33.19468], [-117.36217, 33.19484], [-117.36184, 33.19519], [-117.36174, 33.19536], [-117.36168, 33.19556], [-117.36166, 33.19568], [-117.36167, 33.19787], [-117.35722, 33.19787], [-117.35719, 33.19485], [-117.3578, 33.1945], [-117.35787, 33.19463], [-117.35788, 33.19477], [-117.35789, 33.19478], [-117.35989, 33.1938], [-117.35892, 33.19244], [-117.35886, 33.1924], [-117.35923, 33.19222], [-117.36, 33.1934], [-117.36139, 33.19286], [-117.36187, 33.1922], [-117.36216, 33.19256], [-117.36226, 33.19259]]], [[[-117.36694, 33.19659], [-117.36651, 33.19688], [-117.36621, 33.19699], [-117.36599, 33.19702], [-117.3651, 33.19703], [-117.36509, 33.19795], [-117.36187, 33.19796], [-117.36185, 33.1957], [-117.36187, 33.19558], [-117.36191, 33.19546], [-117.36199, 33.19529], [-117.36232, 33.19494], [-117.36246, 33.19475], [-117.36253, 33.19461], [-117.36259, 33.19439], [-117.3626, 33.19418], [-117.36246, 33.19267], [-117.3633, 33.19295], [-117.36402, 33.19299], [-117.36569, 33.19499], [-117.36694, 33.19659]]]]} | Restricted Access 2 | 15007 | Goat Hill Park | 29108 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.goathillpark.com/ | San Diego 4 | 94.712 | Goat Hill Park | 0 | Local Park 2 | 4 |
7504 | 7504 | 7503 | {"type": "MultiPolygon", "coordinates": [[[[-117.86421, 34.11739], [-117.86389, 34.11734], [-117.86388, 34.11715], [-117.8639, 34.11707], [-117.86404, 34.11685], [-117.86421, 34.11739]]], [[[-117.86747, 34.11601], [-117.86702, 34.11747], [-117.86454, 34.11747], [-117.8645, 34.11742], [-117.86414, 34.11629], [-117.86409, 34.11607], [-117.86563, 34.11606], [-117.86563, 34.11468], [-117.86708, 34.11467], [-117.86708, 34.11404], [-117.86746, 34.11404], [-117.86747, 34.11601]]]]} | Restricted Access 2 | 7039 | Glenoaks Golf Course and Park | 32648 | 1120 | Glendora, City of 76 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | http://www.cityofglendora.org/departments-services/parks-recreation-senior-services/glen-oaks-golf-course | Los Angeles 6 | 17.737 | Glenoaks GC and Park | 0 | Local Park 2 | 4 |
14186 | 14186 | 14185 | {"type": "MultiPolygon", "coordinates": [[[[-117.90223, 33.90123], [-117.90203, 33.90123], [-117.90195, 33.90126], [-117.90189, 33.90133], [-117.9019, 33.90164], [-117.90137, 33.90168], [-117.9013, 33.90184], [-117.90058, 33.90185], [-117.90057, 33.90126], [-117.90037, 33.90108], [-117.90105, 33.90102], [-117.90222, 33.90088], [-117.90223, 33.90123]]], [[[-117.90115, 33.90289], [-117.90087, 33.90313], [-117.90081, 33.90314], [-117.90073, 33.90276], [-117.90072, 33.90264], [-117.90113, 33.90261], [-117.90115, 33.90289]]]]} | Restricted Access 2 | 44001 | Rolling Hills School Park | 31645 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 3.343 | Rolling Hills School Park | 0 | Local Park 2 | 4 | |
7375 | 7375 | 7374 | {"type": "MultiPolygon", "coordinates": [[[[-117.98765, 33.90292], [-117.98765, 33.90335], [-117.9876, 33.90368], [-117.98739, 33.90458], [-117.98734, 33.90462], [-117.98634, 33.90446], [-117.98612, 33.90441], [-117.9859, 33.90433], [-117.98565, 33.90419], [-117.98544, 33.904], [-117.98527, 33.9038], [-117.98524, 33.90364], [-117.98521, 33.9036], [-117.98511, 33.90356], [-117.98502, 33.9036], [-117.98488, 33.90349], [-117.98521, 33.90315], [-117.9855, 33.90276], [-117.98687, 33.90275], [-117.98688, 33.90286], [-117.98757, 33.90286], [-117.98762, 33.90288], [-117.98765, 33.90292]]], [[[-117.98975, 33.90265], [-117.9879, 33.90266], [-117.98554, 33.90268], [-117.98574, 33.90226], [-117.98587, 33.90182], [-117.98592, 33.90143], [-117.98593, 33.90094], [-117.98973, 33.90093], [-117.98975, 33.90265]]]]} | Restricted Access 2 | 6769 | Behringer Park | 29779 | 1158 | La Mirada, City of 326 | City 2 | City Agency 2 | http://www.cityoflamirada.org/index.aspx?page=58 | City 2 | 1158 | La Mirada, City of 323 | City 2 | City Agency 2 | Los Angeles 6 | 26.715 | Behringer Park | 0 | Local Park 2 | 4 | |
15404 | 15404 | 15403 | {"type": "MultiPolygon", "coordinates": [[[[-118.19426, 33.9184], [-118.19422, 33.91851], [-118.19419, 33.91851], [-118.19416, 33.91858], [-118.19409, 33.91861], [-118.19408, 33.91863], [-118.18946, 33.91662], [-118.18957, 33.91635], [-118.19426, 33.9184]]], [[[-118.2018, 33.92167], [-118.20172, 33.92179], [-118.20163, 33.92175], [-118.20157, 33.92184], [-118.2009, 33.92156], [-118.20088, 33.92158], [-118.19826, 33.92045], [-118.19827, 33.92042], [-118.19825, 33.92037], [-118.19826, 33.92031], [-118.1981, 33.92025], [-118.19808, 33.92028], [-118.19801, 33.92031], [-118.19799, 33.92033], [-118.19479, 33.91894], [-118.19434, 33.91875], [-118.19436, 33.91872], [-118.19433, 33.91867], [-118.19436, 33.9186], [-118.19433, 33.91858], [-118.19438, 33.91845], [-118.2018, 33.92167]]], [[[-118.2066, 33.92375], [-118.20651, 33.92402], [-118.20411, 33.92299], [-118.20412, 33.92296], [-118.20411, 33.9229], [-118.20414, 33.92288], [-118.20413, 33.92286], [-118.20397, 33.92279], [-118.20392, 33.92284], [-118.20386, 33.92285], [-118.20384, 33.92287], [-118.20191, 33.92203], [-118.20193, 33.92201], [-118.20191, 33.92195], [-118.20204, 33.92178], [-118.2066, 33.92375]]]]} | Restricted Access 2 | 46625 | Ricardo Lara Linear Park | 31641 | 1191 | Lynwood, City of 258 | City 2 | City Agency 2 | http://www.lynwood.ca.us/ | City 2 | 1191 | Lynwood, City of 254 | City 2 | City Agency 2 | Los Angeles 6 | 12.923 | Ricardo Lara Linear Park | 0 | Local Park 2 | 4 | |
15352 | 15352 | 15351 | {"type": "MultiPolygon", "coordinates": [[[[-118.40196, 33.89025], [-118.40048, 33.89025], [-118.40048, 33.889], [-118.40097, 33.889], [-118.40098, 33.88903], [-118.40143, 33.88903], [-118.40137, 33.88956], [-118.40195, 33.88957], [-118.40196, 33.89025]]], [[[-118.40318, 33.88807], [-118.40273, 33.88807], [-118.40272, 33.88836], [-118.40218, 33.88834], [-118.40217, 33.88748], [-118.40318, 33.88748], [-118.40318, 33.88807]]]]} | Restricted Access 2 | 46537 | Pacific Elementary School Park | 31902 | 2380 | Manhattan Beach Unified School District 971 | Special District 4 | School District 14 | http://www.mbusd.org/ | Special District 4 | 1194 | Manhattan Beach, City of 486 | City 2 | City Agency 2 | Los Angeles 6 | 5.754 | Pacific Elementary School Park | 0 | Local Park 2 | 4 | |
15265 | 15265 | 15264 | {"type": "MultiPolygon", "coordinates": [[[[-118.40382, 34.07823], [-118.40328, 34.0785], [-118.40298, 34.07798], [-118.40351, 34.07775], [-118.40382, 34.07823]]], [[[-118.40519, 34.07988], [-118.404, 34.08055], [-118.40365, 34.08016], [-118.40422, 34.07986], [-118.40483, 34.07951], [-118.40519, 34.07988]]]]} | Restricted Access 2 | 46329 | Hawthorne Elementary School Park | 31883 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.583 | Hawthorne Elementary School Park | 0 | Local Park 2 | 4 | |
15260 | 15260 | 15259 | {"type": "MultiPolygon", "coordinates": [[[[-118.41144, 34.06053], [-118.41139, 34.0606], [-118.41083, 34.06087], [-118.41086, 34.06092], [-118.41072, 34.06099], [-118.41068, 34.06094], [-118.40952, 34.06146], [-118.40927, 34.06126], [-118.40916, 34.06114], [-118.40908, 34.061], [-118.40903, 34.06085], [-118.40902, 34.0607], [-118.40902, 34.06015], [-118.40961, 34.05987], [-118.40985, 34.05982], [-118.40998, 34.05983], [-118.41003, 34.05986], [-118.4101, 34.05989], [-118.41017, 34.05998], [-118.41025, 34.05995], [-118.4103, 34.06003], [-118.41097, 34.05971], [-118.4114, 34.06031], [-118.41144, 34.06044], [-118.41144, 34.06053]]], [[[-118.41243, 34.06254], [-118.41205, 34.06271], [-118.41213, 34.06284], [-118.41212, 34.06285], [-118.41172, 34.06272], [-118.41123, 34.06236], [-118.411, 34.06223], [-118.41066, 34.0618], [-118.41142, 34.06141], [-118.41159, 34.06162], [-118.41191, 34.06147], [-118.41232, 34.06203], [-118.41217, 34.06212], [-118.41226, 34.06224], [-118.41224, 34.06227], [-118.41243, 34.06254]]]]} | Restricted Access 2 | 46326 | Beverly Hills High School Park | 31849 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 10.447 | Beverly Hills High School Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |
14009 | 14009 | 14008 | {"type": "Polygon", "coordinates": [[[-116.3736, 33.7155], [-116.3736, 33.71665], [-116.37357, 33.71669], [-116.37171, 33.71671], [-116.37166, 33.71668], [-116.37165, 33.7155], [-116.3736, 33.7155]]]} | Restricted Access 2 | 39070 | Washington Charter School Park | 31654 | 1240 | Palm Desert, City of 215 | City 2 | City Agency 2 | http://www.cityofpalmdesert.org/Index.aspx?page=174 | City 2 | 1240 | Palm Desert, City of 211 | City 2 | City Agency 2 | Riverside 10 | 5.945 | Washington Charter School Park | 0 | Local Park 2 | 4 | |
10693 | 10693 | 10692 | {"type": "Polygon", "coordinates": [[[-117.04937, 33.13247], [-117.04883, 33.13273], [-117.0484, 33.13207], [-117.04842, 33.13205], [-117.04818, 33.13167], [-117.04871, 33.13143], [-117.04937, 33.13247]]]} | Restricted Access 2 | 19848 | Oak Hill City Park | 31522 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 1.876 | Oak Hill City Park | 0 | Local Park 2 | 4 | |
5896 | 5896 | 5895 | {"type": "Polygon", "coordinates": [[[-117.06009, 32.76351], [-117.05994, 32.76363], [-117.05895, 32.76366], [-117.05892, 32.76238], [-117.06004, 32.76235], [-117.06009, 32.76351]]]} | Restricted Access 2 | 46816 | Clay Elementary School Park | 31950 | 2310 | San Diego Unified School District 820 | Special District 4 | School District 14 | http://www.sandi.net/sandi | Special District 4 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.701 | Clay Elementary School Park | 0 | Local Park 2 | 4 | |
14490 | 14490 | 14489 | {"type": "Polygon", "coordinates": [[[-117.15766, 32.9055], [-117.15651, 32.90626], [-117.1561, 32.90582], [-117.15673, 32.90517], [-117.15693, 32.90501], [-117.15764, 32.9055], [-117.15766, 32.9055]]]} | Restricted Access 2 | 47149 | Salk Neighborhood Park | 31627 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.342 | Salk Neighborhood Park | 0 | Local Park 2 | 4 | |
14230 | 14230 | 14229 | {"type": "Polygon", "coordinates": [[[-117.21517, 33.55612], [-117.21408, 33.55696], [-117.21341, 33.55748], [-117.21339, 33.55643], [-117.21366, 33.55642], [-117.21366, 33.55608], [-117.2134, 33.55607], [-117.2134, 33.55585], [-117.2142, 33.55523], [-117.21517, 33.55612]]]} | Restricted Access 2 | 44109 | Murrieta Elementary School Park | 31631 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 5.132 | Murrieta Elementary School Park | 0 | Local Park 2 | 4 | |
15420 | 15420 | 15419 | {"type": "Polygon", "coordinates": [[[-117.2429, 33.08001], [-117.24288, 33.08032], [-117.24286, 33.08034], [-117.24286, 33.08075], [-117.24204, 33.08076], [-117.24201, 33.07859], [-117.24207, 33.07859], [-117.24218, 33.07904], [-117.24283, 33.07906], [-117.24279, 33.07988], [-117.2429, 33.08001]]]} | Restricted Access 2 | 46658 | Levante School Park | 29992 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 3.673 | Levante School Park | 0 | Local Park 2 | 4 | |
6425 | 6425 | 6424 | {"type": "Polygon", "coordinates": [[[-117.24324, 33.10452], [-117.24295, 33.10466], [-117.24254, 33.10499], [-117.2424, 33.10498], [-117.24176, 33.10484], [-117.24171, 33.10478], [-117.24165, 33.10475], [-117.24152, 33.10476], [-117.24146, 33.10481], [-117.24127, 33.10477], [-117.24119, 33.10472], [-117.24122, 33.10468], [-117.24122, 33.10467], [-117.24082, 33.10455], [-117.24083, 33.10447], [-117.24077, 33.10443], [-117.2408, 33.10434], [-117.24077, 33.10432], [-117.24092, 33.10403], [-117.24145, 33.10412], [-117.24144, 33.10416], [-117.24172, 33.10428], [-117.24255, 33.10361], [-117.24285, 33.10394], [-117.24324, 33.10452]]]} | Restricted Access 2 | 1929 | Fuerte Park | 31613 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 4.633 | Fuerte 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]);