units_with_maps

Table actions

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

35 rows where DES_TP = 3, LAYER = 4 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, MNG_AG_ID, PARK_URL, YR_EST

MNG_AG_TYP 1

  • City Agency · 35 ✖

DES_TP 1

  • Local Recreation Area · 35 ✖
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
1709 1709 1708 {"type": "Polygon", "coordinates": [[[-117.75671, 34.13628], [-117.7567, 34.1363], [-117.75036, 34.13633], [-117.75034, 34.13665], [-117.75035, 34.13666], [-117.75656, 34.13663], [-117.75559, 34.13883], [-117.75547, 34.13901], [-117.75533, 34.13918], [-117.75515, 34.13932], [-117.75367, 34.14035], [-117.75356, 34.14041], [-117.75326, 34.14053], [-117.75215, 34.14084], [-117.75214, 34.14092], [-117.75193, 34.14107], [-117.75169, 34.1413], [-117.75165, 34.14129], [-117.75133, 34.14113], [-117.75127, 34.14107], [-117.75121, 34.14102], [-117.7511, 34.141], [-117.7511, 34.14067], [-117.75024, 34.14008], [-117.75024, 34.13986], [-117.74992, 34.13986], [-117.74843, 34.13883], [-117.74818, 34.13785], [-117.7485, 34.13662], [-117.75064, 34.13454], [-117.75064, 34.13451], [-117.75208, 34.13314], [-117.75433, 34.13264], [-117.75616, 34.13503], [-117.75671, 34.13628]]]} No Public Access 3 12846 Live Oak Reservoir 21375 2078 Metropolitan Water District of Southern California 413 Special District 4 Water District 13 http://www.mwdh2o.com/ Special District 4 1162 La Verne, City of 301 City 2 City Agency 2   Los Angeles 6 112.516 Live Oak Reservoir 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
2710 2710 2709 {"type": "Polygon", "coordinates": [[[-118.17189, 33.79348], [-118.17189, 33.79369], [-118.17147, 33.79396], [-118.17068, 33.79345], [-118.17083, 33.79329], [-118.17083, 33.79327], [-118.16931, 33.79229], [-118.16929, 33.79021], [-118.17188, 33.79021], [-118.17189, 33.79321], [-118.17163, 33.79322], [-118.17163, 33.79347], [-118.17189, 33.79348]]]} Open Access 1 6683 Chittick Field 29942 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 1184 Long Beach, City of 294 City 2 City Agency 2   Los Angeles 6 19.452 Chittick Field 2014 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
4411 4411 4410 {"type": "Polygon", "coordinates": [[[-118.35352, 34.18058], [-118.3535, 34.18106], [-118.35346, 34.18107], [-118.35306, 34.18107], [-118.35307, 34.18057], [-118.35352, 34.18058]]]} Restricted Access 2 46266 Maple Street Playground 31626 2391 Burbank Unified School District 759 Special District 4 School District 14 http://www.burbankusd.org/ Special District 4 1038 Burbank, City of 135 City 2 City Agency 2 http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/maple-street-playground Los Angeles 6 0.55 Maple Street Playground 0 Local Recreation Area 3 4
5739 5739 5738 {"type": "Polygon", "coordinates": [[[-117.86368, 33.71492], [-117.86366, 33.71591], [-117.86257, 33.71591], [-117.86257, 33.715], [-117.86248, 33.71499], [-117.86248, 33.71487], [-117.86359, 33.71488], [-117.86359, 33.71492], [-117.86368, 33.71492]]]} Restricted Access 2 47437 Monroe Elementary School Field 31153 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 2.918 Monroe Elementary School Field 0 Local Recreation Area 3 4
5740 5740 5739 {"type": "Polygon", "coordinates": [[[-117.90815, 33.749], [-117.90761, 33.74987], [-117.90711, 33.75063], [-117.9066, 33.75137], [-117.9061, 33.75206], [-117.90563, 33.75177], [-117.9056, 33.75179], [-117.90382, 33.75069], [-117.90435, 33.74984], [-117.90502, 33.75014], [-117.90503, 33.75021], [-117.90483, 33.75055], [-117.90576, 33.75095], [-117.90624, 33.75015], [-117.90651, 33.75028], [-117.90653, 33.75028], [-117.90651, 33.74904], [-117.90667, 33.74904], [-117.90668, 33.74906], [-117.90714, 33.74906], [-117.90715, 33.74901], [-117.90815, 33.749]]]} Restricted Access 2 47438 Spurgeon Intermediate School Field 31154 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 12.376 Spurgeon Intermediate School Field 0 Local Recreation Area 3 4
6317 6317 6316 {"type": "Polygon", "coordinates": [[[-117.28211, 34.15967], [-117.28207, 34.15968], [-117.28207, 34.16048], [-117.28042, 34.16048], [-117.28041, 34.16006], [-117.28015, 34.16006], [-117.28015, 34.15949], [-117.28008, 34.15948], [-117.28007, 34.15884], [-117.2821, 34.15884], [-117.28211, 34.15967]]]} Restricted Access 2 47434 Golden Valley School Field 31151 2314 San Bernardino City Unified School District 832 Special District 4 School District 14 http://www.sbcusd.k12.ca.us/ Special District 4 1293 San Bernardino, City of 163 City 2 City Agency 2   San Bernardino 22 7.872 Golden Valley School Field 0 Local Recreation Area 3 4
6328 6328 6327 {"type": "Polygon", "coordinates": [[[-117.89836, 33.72183], [-117.8983, 33.72317], [-117.89797, 33.72315], [-117.89796, 33.72316], [-117.89797, 33.72355], [-117.89832, 33.72355], [-117.89835, 33.72428], [-117.8943, 33.72425], [-117.8943, 33.72338], [-117.89435, 33.72295], [-117.89452, 33.72237], [-117.89471, 33.72195], [-117.89481, 33.72179], [-117.89488, 33.72177], [-117.89525, 33.72176], [-117.89683, 33.72176], [-117.897, 33.72177], [-117.89752, 33.72184], [-117.89836, 33.72183]]]} Restricted Access 2 47436 Valley High School Field 31152 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 24.28 Valley High School Field 0 Local Recreation Area 3 4
6335 6335 6334 {"type": "Polygon", "coordinates": [[[-117.91058, 33.72179], [-117.91047, 33.72176], [-117.91041, 33.72186], [-117.91048, 33.72189], [-117.91044, 33.72198], [-117.91045, 33.722], [-117.91032, 33.72232], [-117.91024, 33.72234], [-117.91017, 33.72238], [-117.91007, 33.72251], [-117.90997, 33.7225], [-117.90995, 33.72254], [-117.90986, 33.72251], [-117.90986, 33.72247], [-117.90977, 33.72248], [-117.9096, 33.72254], [-117.90953, 33.72264], [-117.90952, 33.72269], [-117.9094, 33.72266], [-117.90937, 33.72271], [-117.90927, 33.7227], [-117.90916, 33.72291], [-117.90914, 33.72327], [-117.90867, 33.72327], [-117.90855, 33.72329], [-117.90838, 33.72335], [-117.90792, 33.72336], [-117.90848, 33.72176], [-117.90871, 33.72179], [-117.90924, 33.72182], [-117.90951, 33.72176], [-117.90978, 33.72154], [-117.90996, 33.72132], [-117.91058, 33.72179]]]} Restricted Access 2 47439 Hector G. Godinez High School Field 31155 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 6.664 Hector G. Godinez High School Field 0 Local Recreation Area 3 4
6341 6341 6340 {"type": "Polygon", "coordinates": [[[-117.84173, 33.89423], [-117.83972, 33.89424], [-117.83966, 33.89199], [-117.8408, 33.89197], [-117.84079, 33.89285], [-117.84024, 33.89286], [-117.84024, 33.89331], [-117.84092, 33.89332], [-117.84092, 33.89378], [-117.84123, 33.89378], [-117.84122, 33.89348], [-117.84171, 33.89348], [-117.84173, 33.89423]]]} Restricted Access 2 47441 Rose Drive Elementary School Recreational Facilities 31157 2410 Placentia-Yorba Linda Unified School District 833 Special District 4 School District 14 http://www.pylusd.org/ Special District 4 1384 Yorba Linda, City of 62 City 2 City Agency 2   Orange 3 7.295 Rose Drive Elementary School Recreational Facilities 0 Local Recreation Area 3 4
7251 7251 7250 {"type": "Polygon", "coordinates": [[[-121.92994, 37.74522], [-121.92625, 37.74667], [-121.92569, 37.74579], [-121.92458, 37.74623], [-121.92512, 37.74711], [-121.92071, 37.74637], [-121.92092, 37.7457], [-121.92094, 37.7455], [-121.92092, 37.74535], [-121.921, 37.74482], [-121.9211, 37.7447], [-121.9213, 37.74459], [-121.92141, 37.74449], [-121.92146, 37.7444], [-121.92148, 37.74426], [-121.92136, 37.74378], [-121.92055, 37.74282], [-121.9205, 37.74268], [-121.92049, 37.74258], [-121.92053, 37.7422], [-121.92061, 37.74194], [-121.92088, 37.74171], [-121.9209, 37.74166], [-121.92086, 37.74144], [-121.921, 37.74106], [-121.92102, 37.74085], [-121.92096, 37.74024], [-121.92146, 37.73929], [-121.92181, 37.73883], [-121.92232, 37.73901], [-121.92245, 37.73928], [-121.92249, 37.73962], [-121.92256, 37.73977], [-121.92257, 37.73977], [-121.92276, 37.73954], [-121.92277, 37.73957], [-121.92258, 37.73982], [-121.9226, 37.73986], [-121.92258, 37.74002], [-121.9226, 37.74014], [-121.9227, 37.7404], [-121.92283, 37.74054], [-121.92298, 37.74068], [-121.92344, 37.74066], [-121.92396, 37.74073], [-121.92441, 37.74073], [-121.9246, 37.74075], [-121.9248, 37.74079], [-121.92491, 37.74089], [-121.92502, 37.74095], [-121.92519, 37.74109], [-121.92534, 37.74126], [-121.92543, 37.74145], [-121.92548, 37.74167], [-121.92547, 37.74189], [-121.92553, 37.74205], [-121.92563, 37.74213], [-121.92575, 37.74238], [-121.9259, 37.74263], [-121.92617, 37.74292], [-121.92625, 37.74304], [-121.92638, 37.74333], [-121.92669, 37.74351], [-121.92698, 37.74389], [-121.92725, 37.74414], [-121.92715, 37.74428], [-121.92706, 37.74444], [-121.92692, 37.74464], [-121.92691, 37.74469], [-121.92692, 37.74481], [-121.92801, 37.74475], [-121.92843, 37.74481], [-121.92869, 37.74482], [-121.92892, 37.74479], [-121.9294, 37.74467], [-121.92994, 37.74522]]]} Open Access 1 48920 Dougherty Valley Ridge Trail 33643 2300 Geologic Hazard Abatement District (San Ramon) 853 Special District 4 Special District - Other 26 http://www.sanramon.ca.gov/engr/ghad.html Special District 4 1313 San Ramon, City of 68 City 2 City Agency 2 http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail Contra Costa 12 89.586 Dougherty Valley Ridge Trail 0 Local Recreation Area 3 4
7255 7255 7254 {"type": "Polygon", "coordinates": [[[-121.92427, 37.74849], [-121.92332, 37.74921], [-121.92193, 37.74844], [-121.91908, 37.7461], [-121.92388, 37.7469], [-121.92427, 37.74849]]]} Open Access 1 48922 Dougherty Valley Ridge Trail 33643 2031 East Bay Municipal Utility District 433 Special District 4 Water District 13 http://www.ebmud.com/ Special District 4 1313 San Ramon, City of 68 City 2 City Agency 2 http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail Contra Costa 12 17.382 Dougherty Valley Ridge Trail 0 Local Recreation Area 3 4
10780 10780 10779 {"type": "Polygon", "coordinates": [[[-117.76612, 34.10899], [-117.7652, 34.11126], [-117.76228, 34.1103], [-117.76223, 34.11016], [-117.76212, 34.10995], [-117.76202, 34.1098], [-117.7623, 34.10965], [-117.76255, 34.10947], [-117.76279, 34.10925], [-117.76296, 34.10904], [-117.76318, 34.10868], [-117.7637, 34.10752], [-117.76409, 34.10765], [-117.76407, 34.10773], [-117.76441, 34.10784], [-117.76461, 34.10794], [-117.76462, 34.10793], [-117.76466, 34.10782], [-117.76493, 34.10789], [-117.76612, 34.10899]]]} Restricted Access 2 20550 La Verne Sports Park 31619 2398 Bonita Unified School District 956 Special District 4 School District 14 http://do.bonita.k12.ca.us/ Special District 4 1162 La Verne, City of 301 City 2 City Agency 2   Los Angeles 6 22.089 La Verne Sports Park 0 Local Recreation Area 3 4
10843 10843 10842 {"type": "Polygon", "coordinates": [[[-118.41941, 33.92466], [-118.4187, 33.92467], [-118.4187, 33.92444], [-118.41841, 33.92444], [-118.41841, 33.92366], [-118.41941, 33.92366], [-118.41941, 33.92466]]]} Restricted Access 2 20624 Richmond Street Field 31642 2378 El Segundo Unified School District 958 Special District 4 School District 14 http://www.elsegundousd.net/ Special District 4 1096 El Segundo, City of 296 City 2 City Agency 2   Los Angeles 6 2.392 Richmond Street Field 0 Local Recreation Area 3 4
10863 10863 10862 {"type": "Polygon", "coordinates": [[[-118.82414, 34.0228], [-118.82415, 34.02343], [-118.8242, 34.02514], [-118.82383, 34.02594], [-118.82355, 34.02636], [-118.82309, 34.02697], [-118.8214, 34.02658], [-118.82087, 34.0264], [-118.82069, 34.02541], [-118.82061, 34.02514], [-118.82048, 34.02484], [-118.82045, 34.02472], [-118.82044, 34.02459], [-118.82046, 34.02446], [-118.82054, 34.02429], [-118.82093, 34.02387], [-118.82105, 34.02371], [-118.82121, 34.02343], [-118.82192, 34.02391], [-118.82243, 34.02344], [-118.8217, 34.02273], [-118.82181, 34.0226], [-118.82192, 34.0225], [-118.82258, 34.02203], [-118.82271, 34.02189], [-118.82412, 34.02284], [-118.82414, 34.02283], [-118.82414, 34.0228]]]} Restricted Access 2 20661 Malibu Equestrian Park 32834 2423 Santa Monica-Malibu Unified School District 960 Special District 4 School District 14 www.smmusd.org Special District 4 1193 Malibu, City of 928 City 2 City Agency 2   Los Angeles 6 32.463 Malibu Equestrian Park 0 Local Recreation Area 3 4
11431 11431 11430 {"type": "Polygon", "coordinates": [[[-118.34535, 33.89046], [-118.34465, 33.89053], [-118.34471, 33.89095], [-118.34436, 33.89096], [-118.34432, 33.88985], [-118.34484, 33.88984], [-118.34485, 33.88999], [-118.34528, 33.88995], [-118.34535, 33.89046]]]} Restricted Access 2 48114 Bollinger Gymnasium 32629 2396 Lawndale Elementary School District 670 Special District 4 School District 14 http://www.lawndale.k12.ca.us/ Special District 4 1172 Lawndale, City of 475 City 2 City Agency 2 http://www.lawndalecity.org/ASSETS/PDF/Parks/bollinger.pdf Los Angeles 6 1.856 Bollinger Gymnasium 0 Local Recreation Area 3 4
11436 11436 11435 {"type": "Polygon", "coordinates": [[[-117.97437, 34.13762], [-117.97437, 34.13876], [-117.97364, 34.13876], [-117.97363, 34.13856], [-117.9732, 34.13856], [-117.97319, 34.13882], [-117.97203, 34.13883], [-117.97202, 34.13765], [-117.97437, 34.13762]]]} Open Access 1 48129 Montgomery Fields 32649 2316 Duarte Unified School District 978 Special District 4 School District 14 http://www.duarte.k12.ca.us/ Special District 4 1089 Duarte, City of 325 City 2 City Agency 2   Los Angeles 6 6.662 Montgomery Fields 0 Local Recreation Area 3 4
11503 11503 11502 {"type": "Polygon", "coordinates": [[[-121.38663, 36.85252], [-121.38651, 36.85489], [-121.38407, 36.85481], [-121.38414, 36.85323], [-121.38515, 36.85329], [-121.38551, 36.85316], [-121.38596, 36.8531], [-121.38603, 36.85232], [-121.3862, 36.85233], [-121.38623, 36.85252], [-121.38663, 36.85252]]]} Restricted Access 2 48191 Marguerite Maze Sports Complex 32728 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 http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ San Benito 38 10.915 Marguerite Maze Sports Complex 0 Local Recreation Area 3 4
12087 12087 12086 {"type": "MultiPolygon", "coordinates": [[[[-118.41597, 33.98684], [-118.41682, 33.98637], [-118.4172, 33.9861], [-118.42424, 33.98091], [-118.42423, 33.98089], [-118.42749, 33.97856], [-118.42905, 33.97752], [-118.43012, 33.97684], [-118.43162, 33.97594], [-118.4325, 33.97537], [-118.43253, 33.97541], [-118.43245, 33.97547], [-118.4325, 33.97555], [-118.43243, 33.97558], [-118.4323, 33.9756], [-118.43172, 33.97596], [-118.43135, 33.97616], [-118.43008, 33.97693], [-118.42908, 33.97756], [-118.42733, 33.97874], [-118.42729, 33.97875], [-118.42705, 33.97891], [-118.4252, 33.98023], [-118.42496, 33.98044], [-118.42282, 33.98202], [-118.42282, 33.98203], [-118.42297, 33.98218], [-118.42288, 33.98224], [-118.42275, 33.98209], [-118.42269, 33.98213], [-118.41929, 33.9846], [-118.41722, 33.98613], [-118.41612, 33.98697], [-118.41605, 33.98692], [-118.41584, 33.98705], [-118.41533, 33.98744], [-118.41532, 33.98748], [-118.41257, 33.98955], [-118.4119, 33.98993], [-118.41174, 33.99009], [-118.4118, 33.99018], [-118.41172, 33.9902], [-118.40635, 33.99335], [-118.40617, 33.99349], [-118.40518, 33.99448], [-118.40502, 33.99457], [-118.405, 33.99449], [-118.40512, 33.99441], [-118.40631, 33.99332], [-118.41069, 33.99074], [-118.41186, 33.98988], [-118.41254, 33.98952], [-118.41525, 33.98747], [-118.41575, 33.98698], [-118.41597, 33.98684]]], [[[-118.40476, 33.9948], [-118.40448, 33.99506], [-118.40385, 33.99577], [-118.40371, 33.99594], [-118.403, 33.99677], [-118.40288, 33.99699], [-118.40277, 33.99766], [-118.40238, 33.99838], [-118.40239, 33.99842], [-118.4016, 33.9998], [-118.40152, 33.99976], [-118.40198, 33.99897], [-118.40229, 33.99853], [-118.40229, 33.99852], [-118.40137, 33.99966], [-118.40126, 33.99987], [-118.4012, 33.99986], [-118.40137, 33.99952], [-118.40229, 33.99834], [-118.40271, 33.99759], [-118.40282, 33.99697], [-118.40295, 33.99674], [-118.4036, 33.996], [-118.40378, 33.99575], [-118.40399, 33.99553], [-118.40442, 33.99499], [-118.4045, 33.99491], [-118.40476, 33.9948]]], [[[-118.40076, 34.00143], [-118.40066, 34.00171], [-118.40048, 34.00221], [-118.40042, 34.00218], [-118.40059, 34.00163], [-118.40068, 34.00143], [-118.40076, 34.00143]]], [[[-118.37695, 34.02689], [-118.37693, 34.02697], [-118.37689, 34.02697], [-118.37687, 34.02699], [-118.37674, 34.02699], [-118.37649, 34.02765], [-118.3765, 34.02765], [-118.37664, 34.02745], [-118.3768, 34.02705], [-118.37687, 34.02701], [-118.37669, 34.02745], [-118.37653, 34.0277], [-118.3764, 34.02785], [-118.37638, 34.0279], [-118.37635, 34.02789], [-118.37669, 34.02699], [-118.37625, 34.02698], [-118.37626, 34.02689], [-118.37623, 34.02686], [-118.37627, 34.02684], [-118.37632, 34.02687], [-118.37672, 34.02687], [-118.37681, 34.02654], [-118.37689, 34.02614], [-118.37694, 34.02617], [-118.37688, 34.02654], [-118.37678, 34.02687], [-118.37692, 34.02687], [-118.37692, 34.02688], [-118.37695, 34.02689]]]]} Open Access 1 46847 Ballona Creek Trail and Bike Path 30330 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 7.103 Ballona Creek Trail and Bike Path 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]);