units_with_maps

Table actions

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

140 rows where ACCESS_TYP = 2, DES_TP = 3 and LAYER = 2

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

DES_TP 1

  • Local Recreation Area · 140 ✖

ACCESS_TYP 1

  • Restricted Access · 140 ✖
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
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
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
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
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
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
4114 4114 4113 {"type": "Polygon", "coordinates": [[[-121.95833, 37.55749], [-121.95738, 37.55758], [-121.95719, 37.55717], [-121.95711, 37.55712], [-121.95703, 37.55709], [-121.95693, 37.55709], [-121.95685, 37.55712], [-121.95677, 37.55717], [-121.95673, 37.55724], [-121.95672, 37.55731], [-121.95674, 37.55737], [-121.9568, 37.55744], [-121.95688, 37.55748], [-121.95697, 37.5575], [-121.95708, 37.55749], [-121.95713, 37.55751], [-121.95743, 37.55814], [-121.95587, 37.55859], [-121.95559, 37.55471], [-121.95566, 37.55461], [-121.95552, 37.55247], [-121.95541, 37.55221], [-121.95531, 37.55064], [-121.95513, 37.55065], [-121.95499, 37.54848], [-121.95581, 37.54785], [-121.95674, 37.54713], [-121.95833, 37.55749]]]} Restricted Access 2 47146 Fremont Park Golf Club 33120 1113 Fremont, City of 381 City 2 City Agency 2 http://www.fremont.gov/316/Parks City 2 1113 Fremont, City of 376 City 2 City Agency 2   Alameda 17 53.791 Fremont Park Golf Club 1960 Local Recreation Area 3 4
4394 4394 4393 {"type": "Polygon", "coordinates": [[[-118.23041, 34.19871], [-118.23092, 34.19917], [-118.23092, 34.19922], [-118.23089, 34.19923], [-118.23031, 34.19921], [-118.23026, 34.19919], [-118.23025, 34.19914], [-118.23034, 34.19874], [-118.23037, 34.19871], [-118.23041, 34.19871]]]} Restricted Access 2 46024 Sparr Heights Community Center 29349 1119 Glendale, City of 103 City 2 City Agency 2 http://www.glendaleca.gov/government/city-departments/community-services-parks City 2 1119 Glendale, City of 100 City 2 City Agency 2 http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/sparr-heights-community-center Los Angeles 6 0.504 Sparr Heights Community Ctr. 0 Local Recreation Area 3 4
4885 4885 4884 {"type": "Polygon", "coordinates": [[[-121.14717, 37.72653], [-121.145, 37.72656], [-121.14453, 37.72659], [-121.14304, 37.72659], [-121.1424, 37.7266], [-121.142, 37.72657], [-121.14198, 37.72631], [-121.1419, 37.72282], [-121.14224, 37.7226], [-121.14268, 37.72235], [-121.1428, 37.72219], [-121.14288, 37.72189], [-121.14279, 37.72164], [-121.14261, 37.72157], [-121.14239, 37.72159], [-121.14219, 37.72148], [-121.14206, 37.72129], [-121.14189, 37.72117], [-121.14187, 37.72094], [-121.14187, 37.72084], [-121.14213, 37.72065], [-121.14225, 37.72053], [-121.14321, 37.71995], [-121.14367, 37.71974], [-121.14396, 37.71968], [-121.14447, 37.71965], [-121.1449, 37.71984], [-121.14518, 37.72002], [-121.14541, 37.72005], [-121.14564, 37.71991], [-121.14571, 37.71959], [-121.14583, 37.71926], [-121.14572, 37.7187], [-121.14564, 37.71847], [-121.14564, 37.71823], [-121.14577, 37.71796], [-121.14604, 37.71776], [-121.14635, 37.71762], [-121.14693, 37.71756], [-121.14715, 37.71763], [-121.14713, 37.72287], [-121.14711, 37.72294], [-121.14711, 37.72322], [-121.14717, 37.7262], [-121.14717, 37.72653]]]} Restricted Access 2 17783 Jack Tone Golf Course 33060 1277 Ripon, City of 534 City 2 City Agency 2 http://www.cityofripon.org/ City 2 1277 Ripon, City of 527 City 2 City Agency 2   San Joaquin 39 88.453 Jack Tone GC 0 Local Recreation Area 3 4
4887 4887 4886 {"type": "Polygon", "coordinates": [[[-122.01786, 38.01685], [-122.01615, 38.01606], [-122.01379, 38.01187], [-122.01827, 38.01106], [-122.02232, 38.01073], [-122.02266, 38.01085], [-122.02298, 38.01167], [-122.0232, 38.01212], [-122.02344, 38.01272], [-122.02371, 38.01327], [-122.0239, 38.01321], [-122.02459, 38.01463], [-122.02429, 38.01472], [-122.02586, 38.01793], [-122.02616, 38.01785], [-122.02649, 38.01854], [-122.02529, 38.01892], [-122.02508, 38.01872], [-122.02404, 38.01933], [-122.01786, 38.01685]]]} Restricted Access 2 13617 Diablo Creek Golf Course 33034 1066 Concord, City of 391 City 2 City Agency 2 http://www.ci.concord.ca.us/page.asp?pid=3002 City 2 1066 Concord, City of 385 City 2 City Agency 2   Contra Costa 12 150.576 Diablo Creek GC 0 Local Recreation Area 3 4
5091 5091 5090 {"type": "Polygon", "coordinates": [[[-118.14026, 33.782], [-118.14026, 33.78244], [-118.13519, 33.78245], [-118.13518, 33.78214], [-118.13189, 33.78191], [-118.1286, 33.77948], [-118.1286, 33.77543], [-118.13159, 33.77543], [-118.13155, 33.77619], [-118.13253, 33.77718], [-118.13431, 33.77757], [-118.13696, 33.77795], [-118.1371, 33.77794], [-118.13729, 33.77819], [-118.13734, 33.77832], [-118.13746, 33.77879], [-118.13743, 33.77907], [-118.13769, 33.77961], [-118.13781, 33.77978], [-118.13825, 33.78024], [-118.1386, 33.78072], [-118.13873, 33.78094], [-118.13906, 33.78131], [-118.13928, 33.78148], [-118.13951, 33.78164], [-118.13984, 33.78183], [-118.14026, 33.782]]]} Restricted Access 2 45923 Recreation Park 18 Hole Golf Course 33116 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 119.647 Rec. Park 18 Hole GC 0 Local Recreation Area 3 4
5702 5702 5701 {"type": "Polygon", "coordinates": [[[-118.21106, 34.03932], [-118.21067, 34.03991], [-118.21062, 34.03994], [-118.21057, 34.03993], [-118.20993, 34.03964], [-118.21034, 34.03899], [-118.21106, 34.03932]]]} Restricted Access 2 45762 Roosevelt High School Pool 28767 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/dos/aquatic/facility/rooseveltPool.htm Los Angeles 6 1.493 Roosevelt High School Pool 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]);