units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

220 rows where ACCESS_TYP = 2, DES_TP = 3 and GAP_STS = 4

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV

DES_TP 1

  • Local Recreation Area · 220 ✖

ACCESS_TYP 1

  • Restricted Access · 220 ✖
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
3 3 2 {"type": "Polygon", "coordinates": [[[-120.81796, 37.78801], [-120.81602, 37.78793], [-120.81565, 37.78787], [-120.81358, 37.7878], [-120.81268, 37.78774], [-120.8117, 37.78776], [-120.8111, 37.78789], [-120.81064, 37.78764], [-120.80991, 37.78733], [-120.80928, 37.78757], [-120.80895, 37.78704], [-120.80743, 37.78568], [-120.80702, 37.78537], [-120.80701, 37.78515], [-120.80703, 37.78338], [-120.80993, 37.78254], [-120.81293, 37.78022], [-120.81292, 37.77802], [-120.81434, 37.77723], [-120.81693, 37.77715], [-120.81697, 37.78113], [-120.81726, 37.78253], [-120.81756, 37.78477], [-120.81686, 37.78479], [-120.81635, 37.78482], [-120.8157, 37.78465], [-120.81513, 37.78463], [-120.81405, 37.78454], [-120.81371, 37.7843], [-120.81343, 37.78428], [-120.81288, 37.78427], [-120.81092, 37.78458], [-120.81058, 37.78429], [-120.81017, 37.78433], [-120.80902, 37.785], [-120.80861, 37.78529], [-120.80875, 37.78561], [-120.80897, 37.78583], [-120.80941, 37.78606], [-120.80994, 37.78614], [-120.81072, 37.78613], [-120.81093, 37.78596], [-120.8114, 37.78609], [-120.81224, 37.78639], [-120.81288, 37.78655], [-120.8129, 37.78674], [-120.81368, 37.78684], [-120.8148, 37.78683], [-120.81525, 37.78688], [-120.81579, 37.78697], [-120.81674, 37.78697], [-120.81725, 37.78683], [-120.81777, 37.7866], [-120.81796, 37.78801]], [[-120.81641, 37.7829], [-120.81637, 37.78261], [-120.81576, 37.78291], [-120.81539, 37.78302], [-120.81522, 37.78337], [-120.81521, 37.78348], [-120.8154, 37.78386], [-120.81556, 37.78389], [-120.81566, 37.78395], [-120.81602, 37.78396], [-120.81609, 37.784], [-120.81655, 37.78409], [-120.81655, 37.78401], [-120.81644, 37.78328], [-120.81641, 37.7829]]]} Restricted Access 2 9 Oakdale Golf & Country Club 32983 1227 Oakdale, City of 2 City 2 City Agency 2 http://www.oakdalegov.com/#!recreation/c222d City 2 1227 Oakdale, City of 2 City 2 City Agency 2   Stanislaus 2 137.317 Oakdale Golf & Country Club 0 Local Recreation Area 3 4
177 177 176 {"type": "Polygon", "coordinates": [[[-119.74164, 34.43295], [-119.74153, 34.43576], [-119.73893, 34.43575], [-119.73887, 34.43693], [-119.73869, 34.43693], [-119.73853, 34.43695], [-119.73837, 34.437], [-119.73822, 34.43708], [-119.73804, 34.43724], [-119.73783, 34.43753], [-119.73766, 34.43766], [-119.73751, 34.43772], [-119.73402, 34.43838], [-119.73394, 34.43798], [-119.73391, 34.43769], [-119.73392, 34.43573], [-119.73369, 34.43572], [-119.73366, 34.43384], [-119.73517, 34.43387], [-119.73518, 34.43141], [-119.73888, 34.43138], [-119.73888, 34.42908], [-119.73969, 34.42935], [-119.74016, 34.42954], [-119.74079, 34.42982], [-119.7407, 34.4325], [-119.74164, 34.43295]]]} Restricted Access 2 492 Santa Barbara Golf Club 32988 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 110.039 Santa Barbara Golf Club 0 Local Recreation Area 3 4
781 781 780 {"type": "Polygon", "coordinates": [[[-121.83892, 37.69284], [-121.83892, 37.69497], [-121.83838, 37.69541], [-121.83777, 37.69567], [-121.83724, 37.69614], [-121.83653, 37.69638], [-121.83615, 37.6966], [-121.8359, 37.6971], [-121.83545, 37.69735], [-121.83435, 37.69759], [-121.83308, 37.69793], [-121.83316, 37.69844], [-121.83289, 37.69879], [-121.83205, 37.69921], [-121.83202, 37.6983], [-121.82998, 37.69835], [-121.82998, 37.70055], [-121.82094, 37.70062], [-121.81888, 37.69912], [-121.81883, 37.69713], [-121.82405, 37.69676], [-121.8243, 37.69635], [-121.82403, 37.6952], [-121.82983, 37.6953], [-121.83021, 37.69279], [-121.83892, 37.69284]]]} Restricted Access 2 5062 Las Positas Golf Course 33002 1178 Livermore, City of 256 City 2 City Agency 2 http://www.larpd.org/parks/parks.html City 2 1178 Livermore, City of 252 City 2 City Agency 2   Alameda 17 216.12 Las Positas GC 0 Local Recreation Area 3 4
968 968 967 {"type": "Polygon", "coordinates": [[[-118.10763, 33.83029], [-118.10763, 33.83204], [-118.10759, 33.8321], [-118.09924, 33.83206], [-118.09919, 33.83205], [-118.09916, 33.83201], [-118.09956, 33.8307], [-118.09974, 33.83027], [-118.10362, 33.83028], [-118.10363, 33.83055], [-118.10507, 33.83056], [-118.10508, 33.83028], [-118.10763, 33.83029]]]} Restricted Access 2 6607 Heartwell Golf Course 33019 1184 Long Beach, City of 298 City 2 City Agency 2 http://www.longbeach.gov/park/default.asp City 2 1184 Long Beach, City of 294 City 2 City Agency 2   Los Angeles 6 36.514 Heartwell GC 0 Local Recreation Area 3 4
1070 1070 1069 {"type": "Polygon", "coordinates": [[[-118.12169, 34.18412], [-118.12169, 34.18484], [-118.12109, 34.18492], [-118.12098, 34.18506], [-118.12057, 34.18506], [-118.12058, 34.18579], [-118.11862, 34.1858], [-118.11862, 34.18574], [-118.11762, 34.1841], [-118.11755, 34.18393], [-118.1175, 34.18371], [-118.11747, 34.18334], [-118.11742, 34.18334], [-118.11734, 34.18092], [-118.11782, 34.18092], [-118.11781, 34.18075], [-118.11767, 34.18048], [-118.11767, 34.18009], [-118.11806, 34.18009], [-118.1181, 34.1796], [-118.12141, 34.17957], [-118.12144, 34.18233], [-118.12147, 34.18248], [-118.12158, 34.18276], [-118.12162, 34.18294], [-118.12162, 34.18319], [-118.12154, 34.18358], [-118.12153, 34.18373], [-118.12155, 34.18386], [-118.12159, 34.18403], [-118.12162, 34.18407], [-118.12169, 34.18412]]]} Restricted Access 2 6971 Altadena Golf Course 33022 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 57.739 Altadena GC 0 Local Recreation Area 3 4
1140 1140 1139 {"type": "Polygon", "coordinates": [[[-118.1547, 33.95388], [-118.15452, 33.95422], [-118.15424, 33.9546], [-118.15397, 33.95488], [-118.15371, 33.95511], [-118.15347, 33.95528], [-118.14778, 33.95833], [-118.14294, 33.95579], [-118.14293, 33.95577], [-118.14293, 33.95574], [-118.14549, 33.95228], [-118.14787, 33.95356], [-118.14876, 33.95237], [-118.15149, 33.95385], [-118.15239, 33.95264], [-118.1547, 33.95388]]]} Restricted Access 2 6710 Rio Hondo Golf Club 33020 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 101.146 Rio Hondo Golf Club 0 Local Recreation Area 3 4
1392 1392 1391 {"type": "MultiPolygon", "coordinates": [[[[-117.69075, 33.62392], [-117.68979, 33.62464], [-117.6881, 33.62602], [-117.68796, 33.62602], [-117.68764, 33.62571], [-117.68732, 33.6253], [-117.68703, 33.62485], [-117.68795, 33.62401], [-117.68946, 33.62275], [-117.69075, 33.62392]]], [[[-117.69308, 33.61785], [-117.69279, 33.61798], [-117.69244, 33.61822], [-117.69209, 33.61852], [-117.69108, 33.62006], [-117.69044, 33.6209], [-117.69044, 33.62091], [-117.69115, 33.62121], [-117.69006, 33.62215], [-117.68996, 33.62243], [-117.68983, 33.62274], [-117.68763, 33.62065], [-117.68806, 33.62016], [-117.68832, 33.61992], [-117.68852, 33.6197], [-117.68907, 33.61929], [-117.68969, 33.61891], [-117.69138, 33.61803], [-117.69201, 33.61773], [-117.69254, 33.61741], [-117.69268, 33.61741], [-117.69308, 33.61785]]]]} Restricted Access 2 30526 Lake Forest Golf Course 33099 1167 Lake Forest, City of 235 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 1167 Lake Forest, City of 231 City 2 City Agency 2   Orange 3 40.437 Lake Forest GC 0 Local Recreation Area 3 4
1632 1632 1631 {"type": "Polygon", "coordinates": [[[-118.00413, 33.90582], [-118.00266, 33.9058], [-118.00229, 33.90591], [-118.0005, 33.9071], [-118.00033, 33.90729], [-118.00022, 33.90737], [-118.00018, 33.90743], [-117.99885, 33.90986], [-117.99444, 33.90988], [-117.99438, 33.90984], [-117.99434, 33.90424], [-117.99435, 33.90374], [-117.99441, 33.90318], [-117.99449, 33.90284], [-117.99455, 33.9028], [-118.00302, 33.90275], [-118.00303, 33.9028], [-118.00324, 33.90281], [-118.00329, 33.90286], [-118.0033, 33.90333], [-118.00333, 33.90358], [-118.00337, 33.90378], [-118.00343, 33.90396], [-118.00405, 33.90551], [-118.00413, 33.90582]]]} Restricted Access 2 45404 La Mirada Golf Course 33111 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/La_Mirada_Golf_Course Los Angeles 6 131.179 La Mirada GC 0 Local Recreation Area 3 4
1684 1684 1683 {"type": "Polygon", "coordinates": [[[-121.62835, 37.01723], [-121.62822, 37.01731], [-121.62818, 37.01737], [-121.62816, 37.01744], [-121.62812, 37.01964], [-121.6281, 37.01972], [-121.6266, 37.01771], [-121.62576, 37.0171], [-121.62163, 37.01641], [-121.62107, 37.016], [-121.62127, 37.0158], [-121.62088, 37.01542], [-121.62085, 37.01515], [-121.61929, 37.01516], [-121.61925, 37.01194], [-121.62047, 37.01194], [-121.62137, 37.0119], [-121.62504, 37.01167], [-121.62506, 37.01172], [-121.62571, 37.0117], [-121.62583, 37.01172], [-121.62595, 37.01177], [-121.62605, 37.01184], [-121.62614, 37.01198], [-121.62619, 37.01246], [-121.62661, 37.01244], [-121.62667, 37.01302], [-121.62678, 37.01382], [-121.62688, 37.01413], [-121.62707, 37.01457], [-121.62725, 37.01481], [-121.62808, 37.01556], [-121.62821, 37.01575], [-121.62828, 37.01596], [-121.62832, 37.01616], [-121.62833, 37.01637], [-121.62831, 37.01698], [-121.62835, 37.01723]]]} Restricted Access 2 14574 Gilroy Golf Course 33040 1118 Gilroy, City of 407 City 2 City Agency 2 http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx City 2 1118 Gilroy, City of 401 City 2 City Agency 2   Santa Clara 19 96.909 Gilroy GC 0 Local Recreation Area 3 4
2092 2092 2091 {"type": "Polygon", "coordinates": [[[-118.39572, 33.91443], [-118.39518, 33.91444], [-118.39517, 33.91445], [-118.39529, 33.9147], [-118.39505, 33.91479], [-118.39406, 33.91293], [-118.39392, 33.9127], [-118.39375, 33.91247], [-118.39352, 33.9122], [-118.39318, 33.91187], [-118.39199, 33.91086], [-118.39445, 33.90986], [-118.39456, 33.90961], [-118.39553, 33.9096], [-118.39553, 33.90815], [-118.3951, 33.90815], [-118.3951, 33.90799], [-118.39556, 33.90798], [-118.39562, 33.908], [-118.39567, 33.90806], [-118.39568, 33.9096], [-118.39569, 33.9098], [-118.39572, 33.90991], [-118.39572, 33.91443]]]} Restricted Access 2 6138 The Lakes at El Segundo Municipal Golf Course 33006 1096 El Segundo, City of 300 City 2 City Agency 2 http://www.elsegundo.org/depts/recreation/default.asp City 2 1096 El Segundo, City of 296 City 2 City Agency 2   Los Angeles 6 26.418 The Lakes at El Segundo Municipal GC 0 Local Recreation Area 3 4
2099 2099 2098 {"type": "Polygon", "coordinates": [[[-121.94503, 37.73765], [-121.94369, 37.73818], [-121.94322, 37.73744], [-121.94227, 37.7378], [-121.94234, 37.73798], [-121.94192, 37.73811], [-121.94168, 37.73772], [-121.94145, 37.73739], [-121.94426, 37.7363], [-121.9444, 37.73653], [-121.94433, 37.7366], [-121.94433, 37.73668], [-121.94438, 37.73674], [-121.94449, 37.73676], [-121.94503, 37.73765]]]} Restricted Access 2 47569 Pine Valley Middle School Parks and Community Gym 31294 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.075 Pine Valley Middle School Parks and Community Gym 0 Local Recreation Area 3 4
2202 2202 2201 {"type": "Polygon", "coordinates": [[[-118.27588, 33.85284], [-118.2733, 33.85587], [-118.27289, 33.855], [-118.27131, 33.85628], [-118.27096, 33.85622], [-118.27087, 33.85665], [-118.26832, 33.85666], [-118.26831, 33.85663], [-118.26621, 33.85662], [-118.26616, 33.85657], [-118.26515, 33.84858], [-118.26738, 33.84759], [-118.26891, 33.84731], [-118.26947, 33.84787], [-118.26991, 33.84825], [-118.26994, 33.84841], [-118.27012, 33.84858], [-118.2705, 33.84889], [-118.27057, 33.84885], [-118.2725, 33.85028], [-118.2731, 33.85068], [-118.27588, 33.85284]]]} Restricted Access 2 6243 Victoria Golf Course 33008 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 167.229 Victoria GC 0 Local Recreation Area 3 4
2405 2405 2404 {"type": "Polygon", "coordinates": [[[-118.40176, 34.26476], [-118.40163, 34.26535], [-118.40154, 34.26562], [-118.40143, 34.26588], [-118.40129, 34.26614], [-118.40113, 34.26638], [-118.40076, 34.26685], [-118.39988, 34.26605], [-118.39946, 34.26558], [-118.39897, 34.26483], [-118.39843, 34.26433], [-118.39782, 34.26399], [-118.39746, 34.26329], [-118.39631, 34.26249], [-118.3954, 34.26242], [-118.39351, 34.26158], [-118.39344, 34.2618], [-118.39335, 34.2618], [-118.39148, 34.26078], [-118.39103, 34.26066], [-118.39073, 34.26044], [-118.39031, 34.26113], [-118.38941, 34.26086], [-118.38925, 34.26121], [-118.38666, 34.26042], [-118.3866, 34.26035], [-118.38665, 34.259], [-118.38713, 34.25817], [-118.3865, 34.2579], [-118.38587, 34.25895], [-118.38448, 34.25843], [-118.38394, 34.2583], [-118.38325, 34.25843], [-118.38262, 34.25846], [-118.38042, 34.25817], [-118.37936, 34.25812], [-118.37816, 34.25822], [-118.37725, 34.25823], [-118.37614, 34.2584], [-118.37506, 34.25861], [-118.37403, 34.25861], [-118.37343, 34.25859], [-118.37384, 34.2578], [-118.37427, 34.25756], [-118.37765, 34.25587], [-118.37789, 34.25571], [-118.3781, 34.25552], [-118.37827, 34.25531], [-118.3784, 34.2551], [-118.38172, 34.25574], [-118.38181, 34.25558], [-118.38262, 34.25451], [-118.38266, 34.25435], [-118.38485, 34.25642], [-118.38492, 34.25637], [-118.39338, 34.25803], [-118.39555, 34.25899], [-118.39564, 34.25907], [-118.39587, 34.25891], [-118.39595, 34.25904], [-118.3961, 34.2592], [-118.39638, 34.25958], [-118.39669, 34.25992], [-118.40172, 34.26468], [-118.40173, 34.26475], [-118.40176, 34.26476]]]} Restricted Access 2 45520 Hansen Dam Golf Course 28354 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://golf.lacity.org/cdp_hansen.htm Los Angeles 6 201.493 Hansen Dam GC 0 Local Recreation Area 3 4
2504 2504 2503 {"type": "Polygon", "coordinates": [[[-118.4665, 34.00437], [-118.46104, 34.00726], [-118.46085, 34.00737], [-118.46087, 34.00741], [-118.45724, 34.00933], [-118.45601, 34.00775], [-118.4616, 34.00479], [-118.46148, 34.00472], [-118.46244, 34.00421], [-118.46252, 34.00428], [-118.46267, 34.00422], [-118.46531, 34.00282], [-118.4665, 34.00437]]]} Restricted Access 2 6334 Penmar Golf Course 33009 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 52.132 Penmar GC 0 Local Recreation Area 3 4
2890 2890 2889 {"type": "Polygon", "coordinates": [[[-121.39678, 36.84126], [-121.39678, 36.84159], [-121.39616, 36.84157], [-121.39614, 36.84183], [-121.39515, 36.8418], [-121.39507, 36.842], [-121.39507, 36.84215], [-121.39527, 36.84217], [-121.39527, 36.84247], [-121.39543, 36.84248], [-121.39542, 36.84336], [-121.39404, 36.84334], [-121.39252, 36.84106], [-121.39624, 36.84113], [-121.39633, 36.8412], [-121.39644, 36.84126], [-121.39678, 36.84126]]]} Restricted Access 2 18924 Rancho San Justo Sports Complex 32730 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 13.179 Rancho San Justo Sports Complex 0 Local Recreation Area 3 4
2998 2998 2997 {"type": "Polygon", "coordinates": [[[-117.78863, 34.0562], [-117.78469, 34.05669], [-117.78406, 34.05571], [-117.78833, 34.05518], [-117.78863, 34.0562]]]} Restricted Access 2 20562 Veterans Park Soccer Complex 29804 1258 Pomona, City of 128 City 2 City Agency 2 http://ci.pomona.ca.us/index.php/visitors/park-directory City 2 1258 Pomona, City of 125 City 2 City Agency 2 http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/84-veterans-park Los Angeles 6 10.986 Veterans Park Soccer Complex 0 Local Recreation Area 3 4
3123 3123 3122 {"type": "Polygon", "coordinates": [[[-118.41805, 34.31271], [-118.4166, 34.314], [-118.4166, 34.31401], [-118.41582, 34.3146], [-118.41577, 34.31471], [-118.41592, 34.31502], [-118.41611, 34.31503], [-118.41609, 34.31522], [-118.41572, 34.31521], [-118.41572, 34.31529], [-118.41544, 34.31527], [-118.41495, 34.31527], [-118.4138, 34.31568], [-118.41347, 34.31573], [-118.41317, 34.3157], [-118.411, 34.31509], [-118.41012, 34.31425], [-118.41031, 34.31237], [-118.41054, 34.3115], [-118.41012, 34.31103], [-118.41026, 34.31092], [-118.41148, 34.31205], [-118.41155, 34.31189], [-118.4113, 34.31165], [-118.41147, 34.31141], [-118.412, 34.31043], [-118.41191, 34.30973], [-118.41258, 34.3094], [-118.41299, 34.3091], [-118.41356, 34.30864], [-118.4136, 34.30864], [-118.41634, 34.31122], [-118.41805, 34.31271]]]} Restricted Access 2 48023 El Cariso Golf Course 32460 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 381 Los Angeles - Department of Parks and Recreation, County of 273 County 3 County Agency - Parks 7   Los Angeles 6 85.199 El Cariso GC 0 Local Recreation Area 3 4
3214 3214 3213 {"type": "Polygon", "coordinates": [[[-122.039, 37.00381], [-122.03783, 37.00449], [-122.03729, 37.00412], [-122.03759, 37.00374], [-122.03715, 37.00342], [-122.03683, 37.00294], [-122.03674, 37.00261], [-122.03807, 37.00344], [-122.039, 37.00381]]]} Restricted Access 2 367 San Lorenzo River Open Space 28168 1320 Santa Cruz, City of 9 City 2 City Agency 2 http://www.cityofsantacruz.com/departments/parks-recreation City 2 1320 Santa Cruz, City of 9 City 2 City Agency 2   Santa Cruz 5 3.51 San Lorenzo River OS 0 Local Recreation Area 3 4
3250 3250 3249 {"type": "Polygon", "coordinates": [[[-118.04684, 34.0465], [-118.04683, 34.0474], [-118.04642, 34.04739], [-118.04643, 34.0465], [-118.04684, 34.0465]]]} Restricted Access 2 48154 South El Monte Senior Center 32691 1402 South El Monte, City of 606 City 2 City Agency 2 http://www.ci.south-el-monte.ca.us/CITYDEPARTMENTSSERVICES/CommunityServices/ParksandRecreationDivision.aspx City 2 1402 South El Monte, City of 595 City 2 City Agency 2 http://www.ci.south-el-monte.ca.us/CITYDEPARTMENTSSERVICES/CommunityServices/SeniorServices.aspx Los Angeles 6 0.924 South El Monte Senior Ctr. 0 Local Recreation Area 3 4
3419 3419 3418 {"type": "Polygon", "coordinates": [[[-117.18086, 32.69355], [-117.18013, 32.69481], [-117.17921, 32.69442], [-117.17996, 32.69317], [-117.18086, 32.69355]], [[-117.18043, 32.6934], [-117.18043, 32.69338], [-117.18037, 32.69337], [-117.17965, 32.69459], [-117.17972, 32.69461], [-117.18043, 32.6934]]]} Restricted Access 2 25118 Cutler Field 31610 1069 Coronado, City of 105 City 2 City Agency 2 http://www.coronado.ca.us/category/subcategory-rec.php City 2 1069 Coronado, City of 102 City 2 City Agency 2   San Diego 4 3.436 Cutler Field 0 Local Recreation Area 3 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);