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 AGNCY_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, COUNTY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754 | 2754 | 2753 | {"type": "Polygon", "coordinates": [[[-117.24499, 32.80093], [-117.24419, 32.8011], [-117.24283, 32.80145], [-117.24267, 32.80102], [-117.24251, 32.80051], [-117.24472, 32.80004], [-117.24499, 32.80093]]]} | Restricted Access 2 | 18441 | Pacific Beach Community Park | 33345 | 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 | 5.466 | Pacific Beach Community Park | 0 | 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 | |
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 | |
4215 | 4215 | 4214 | {"type": "Polygon", "coordinates": [[[-121.7549, 36.91849], [-121.7545, 36.91871], [-121.75429, 36.91848], [-121.75388, 36.91869], [-121.75349, 36.91824], [-121.75322, 36.91838], [-121.75291, 36.91799], [-121.75268, 36.91773], [-121.75158, 36.91849], [-121.75102, 36.91787], [-121.7528, 36.91657], [-121.75302, 36.91683], [-121.75341, 36.91661], [-121.7542, 36.91753], [-121.7549, 36.91849]]]} | Restricted Access 2 | 44966 | E.A. Hall School Park | 32705 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 9.82 | E.A. Hall School Park | 0 | Local Park 2 | 4 | |
6374 | 6374 | 6373 | {"type": "Polygon", "coordinates": [[[-119.77927, 36.84098], [-119.77927, 36.84288], [-119.77707, 36.84288], [-119.77708, 36.84133], [-119.77769, 36.84134], [-119.77794, 36.84127], [-119.77843, 36.84127], [-119.77869, 36.84135], [-119.77899, 36.84134], [-119.77918, 36.84111], [-119.77919, 36.84097], [-119.77927, 36.84098]]]} | Restricted Access 2 | 1738 | Harry Goorabian Park | 31253 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.566 | Harry Goorabian Park | 0 | Local Park 2 | 4 | |
2946 | 2946 | 2945 | {"type": "Polygon", "coordinates": [[[-118.43139, 34.07349], [-118.43133, 34.0739], [-118.43131, 34.07413], [-118.43128, 34.07416], [-118.43123, 34.07417], [-118.4312, 34.07415], [-118.43081, 34.0738], [-118.4306, 34.07366], [-118.4303, 34.07352], [-118.42983, 34.0734], [-118.42965, 34.0733], [-118.4295, 34.07319], [-118.42916, 34.07276], [-118.42892, 34.07255], [-118.42767, 34.07171], [-118.42764, 34.07166], [-118.42764, 34.0716], [-118.4278, 34.0712], [-118.42784, 34.07119], [-118.42921, 34.07171], [-118.42952, 34.07187], [-118.42979, 34.07208], [-118.43009, 34.07242], [-118.43027, 34.0726], [-118.43138, 34.07347], [-118.43139, 34.07349]]]} | Restricted Access 2 | 1906 | Holmby Park | 32999 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 8.535 | Holmby Park | 0 | Local Park 2 | 4 | |
5696 | 5696 | 5695 | {"type": "Polygon", "coordinates": [[[-118.29818, 34.06162], [-118.29723, 34.06162], [-118.29617, 34.06163], [-118.29617, 34.06159], [-118.29669, 34.06159], [-118.2967, 34.06149], [-118.29818, 34.06147], [-118.29818, 34.06162]]]} | Restricted Access 2 | 45735 | Robert F Kennedy Inspiration Park | 31643 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/commissionerhtm/pdf2010/oct06/10-266.pdf | Los Angeles 6 | 0.574 | Robert F Kennedy Inspiration Park | 0 | Local Park 2 | 4 |
12284 | 12284 | 12283 | {"type": "Polygon", "coordinates": [[[-118.53366, 34.03505], [-118.5333, 34.0359], [-118.53307, 34.0362], [-118.53297, 34.03611], [-118.5328, 34.0361], [-118.53282, 34.036], [-118.53279, 34.03592], [-118.53275, 34.03587], [-118.53261, 34.03578], [-118.53232, 34.03565], [-118.53202, 34.03557], [-118.53186, 34.03554], [-118.53161, 34.03554], [-118.53137, 34.03557], [-118.53079, 34.03574], [-118.53049, 34.03581], [-118.53031, 34.03583], [-118.52994, 34.03584], [-118.52955, 34.0358], [-118.52938, 34.03577], [-118.52913, 34.0357], [-118.52881, 34.03558], [-118.52863, 34.03548], [-118.52845, 34.03537], [-118.52837, 34.03533], [-118.52812, 34.03498], [-118.52804, 34.03454], [-118.52803, 34.03408], [-118.52811, 34.03394], [-118.52793, 34.03354], [-118.52755, 34.03327], [-118.52702, 34.03309], [-118.52664, 34.03355], [-118.52628, 34.03352], [-118.52621, 34.03414], [-118.52671, 34.03416], [-118.52669, 34.03442], [-118.52672, 34.03507], [-118.5268, 34.03551], [-118.52684, 34.03567], [-118.52638, 34.03577], [-118.52637, 34.0358], [-118.52644, 34.03597], [-118.52653, 34.03613], [-118.52676, 34.03645], [-118.5267, 34.03653], [-118.52656, 34.0365], [-118.52642, 34.03631], [-118.52627, 34.03618], [-118.52608, 34.03607], [-118.52593, 34.036], [-118.52578, 34.03596], [-118.52557, 34.03594], [-118.52538, 34.03594], [-118.52528, 34.03596], [-118.52539, 34.03581], [-118.52527, 34.03562], [-118.52498, 34.03597], [-118.52501, 34.03602], [-118.52476, 34.03616], [-118.52463, 34.03626], [-118.52454, 34.03636], [-118.52441, 34.03656], [-118.52436, 34.03671], [-118.52434, 34.03683], [-118.52434, 34.03702], [-118.52438, 34.03721], [-118.52449, 34.03748], [-118.52596, 34.03959], [-118.52609, 34.03975], [-118.52628, 34.03994], [-118.52668, 34.04025], [-118.527, 34.04042], [-118.52706, 34.04049], [-118.52704, 34.04085], [-118.52694, 34.04149], [-118.52664, 34.04146], [-118.5264, 34.0416], [-118.52632, 34.04182], [-118.52584, 34.04176], [-118.52603, 34.04073], [-118.52589, 34.04059], [-118.52501, 34.04047], [-118.52447, 34.03997], [-118.52465, 34.03924], [-118.52323, 34.03721], [-118.52313, 34.03653], [-118.52336, 34.0359], [-118.52367, 34.03554], [-118.52419, 34.03514], [-118.52423, 34.03517], [-118.52427, 34.03515], [-118.52484, 34.03422], [-118.52484, 34.03421], [-118.52478, 34.03419], [-118.52574, 34.03263], [-118.5256, 34.03206], [-118.52621, 34.03192], [-118.52648, 34.03206], [-118.52849, 34.03324], [-118.52951, 34.03374], [-118.52992, 34.03392], [-118.53077, 34.03423], [-118.53142, 34.03444], [-118.53366, 34.03505]]]} | Restricted Access 2 | 25935 | Potrero Canyon Park | 28872 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 59.924 | Potrero Canyon Park | 0 | Local Park 2 | 4 | |
15065 | 15065 | 15064 | {"type": "Polygon", "coordinates": [[[-118.46931, 34.16258], [-118.46866, 34.16231], [-118.46826, 34.16216], [-118.46633, 34.16157], [-118.46632, 34.16106], [-118.46918, 34.16165], [-118.46924, 34.16182], [-118.46929, 34.16204], [-118.46931, 34.16258]]]} | Restricted Access 2 | 45827 | Sherman Oaks Castle Park | 28846 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/shermanoaks_castlepk/ | Los Angeles 6 | 4.982 | Sherman Oaks Castle 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 | |
12890 | 12890 | 12889 | {"type": "Polygon", "coordinates": [[[-117.97433, 33.78835], [-117.97248, 33.78836], [-117.97246, 33.7879], [-117.97181, 33.78791], [-117.97177, 33.78617], [-117.9738, 33.78616], [-117.97382, 33.78667], [-117.9743, 33.78667], [-117.97433, 33.78835]]]} | Restricted Access 2 | 30348 | Hare School Park | 31617 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 12.599 | Hare School Park | 0 | Local Park 2 | 4 | |
12981 | 12981 | 12980 | {"type": "Polygon", "coordinates": [[[-117.9457, 33.79772], [-117.94256, 33.79772], [-117.9419, 33.79773], [-117.94149, 33.79777], [-117.94147, 33.79608], [-117.94155, 33.79602], [-117.94358, 33.79601], [-117.94358, 33.79701], [-117.94321, 33.79702], [-117.94321, 33.79736], [-117.94383, 33.79737], [-117.94384, 33.79745], [-117.94411, 33.79744], [-117.94411, 33.79725], [-117.94417, 33.79724], [-117.94417, 33.79719], [-117.94431, 33.79719], [-117.94432, 33.79717], [-117.94461, 33.79718], [-117.94462, 33.79709], [-117.94526, 33.79709], [-117.94527, 33.79698], [-117.94568, 33.79699], [-117.9457, 33.79772]]]} | Restricted Access 2 | 30455 | Lake School Park | 31620 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 11.739 | Lake School 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 |
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 |
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 | |
12857 | 12857 | 12856 | {"type": "Polygon", "coordinates": [[[-117.92663, 33.9084], [-117.92635, 33.90978], [-117.92622, 33.90981], [-117.92598, 33.90991], [-117.92543, 33.90885], [-117.92549, 33.90833], [-117.92663, 33.9084]]]} | Restricted Access 2 | 30308 | Hermosa School Park | 31593 | 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.279 | Hermosa School Park | 0 | Local Park 2 | 4 | |
12868 | 12868 | 12867 | {"type": "Polygon", "coordinates": [[[-117.93319, 33.89474], [-117.93316, 33.89535], [-117.93309, 33.89568], [-117.93278, 33.89561], [-117.93269, 33.8958], [-117.93199, 33.89562], [-117.93177, 33.89614], [-117.93144, 33.89605], [-117.93131, 33.89545], [-117.93168, 33.89521], [-117.93261, 33.89468], [-117.93285, 33.89466], [-117.93289, 33.89473], [-117.93319, 33.89474]]]} | Restricted Access 2 | 30311 | Laguna Road School Park | 31597 | 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.908 | Laguna Road School 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 | |
14235 | 14235 | 14234 | {"type": "Polygon", "coordinates": [[[-117.95912, 33.85653], [-117.95701, 33.85656], [-117.957, 33.85652], [-117.95681, 33.85652], [-117.95681, 33.85643], [-117.95683, 33.85632], [-117.95687, 33.85621], [-117.95692, 33.85617], [-117.95779, 33.85624], [-117.95908, 33.85624], [-117.95911, 33.85624], [-117.95912, 33.85626], [-117.95912, 33.85653]]]} | Restricted Access 2 | 44113 | Orangethorpe School Park | 31634 | 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 | 1.856 | Orangethorpe 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]);