units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,190 rows where DES_TP = 14
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL, COUNTY, LABEL_NAME, YR_EST
SUID_NMA 915 ✖
- 28644 108
- 28662 24
- 29458 19
- 28641 15
- 28646 12
- 21482 11
- 29566 11
- 11349 8
- 18953 8
- 28645 7
- 24281 6
- 28638 6
- 29513 6
- 31719 6
- 28674 5
- 28675 5
- 28663 4
- 28688 4
- 28704 4
- 29443 4
- 18706 3
- 25214 3
- 27294 3
- 28631 3
- 28661 3
- 28664 3
- 4595 2
- 5513 2
- 18952 2
- 21580 2
- 24117 2
- 27205 2
- 28642 2
- 28656 2
- 28666 2
- 28686 2
- 6348 1
- 8673 1
- 15293 1
- 15318 1
- 15319 1
- 15448 1
- 15449 1
- 15466 1
- 15467 1
- 15468 1
- 15469 1
- 15524 1
- 15628 1
- 15661 1
- 15679 1
- 15684 1
- 15685 1
- 15686 1
- 15687 1
- 15688 1
- 15689 1
- 15690 1
- 15691 1
- 15692 1
- 15693 1
- 15694 1
- 16011 1
- 16036 1
- 16178 1
- 16400 1
- 16484 1
- 16523 1
- 16552 1
- 16553 1
- 16554 1
- 16555 1
- 16556 1
- 16557 1
- 16558 1
- 16559 1
- 16560 1
- 16561 1
- 16562 1
- 16563 1
- 16564 1
- 16565 1
- 16566 1
- 16567 1
- 16568 1
- 16569 1
- 16570 1
- 16571 1
- 16572 1
- 16573 1
- 16574 1
- 16575 1
- 16576 1
- 16577 1
- 16578 1
- 16579 1
- 16580 1
- 16581 1
- 16582 1
- 16583 1
- 16584 1
- 16585 1
- 16586 1
- 16587 1
- 16588 1
- 16589 1
- 16590 1
- 16591 1
- 16592 1
- 16593 1
- 16594 1
- 16595 1
- 16596 1
- 16597 1
- 16598 1
- 16599 1
- 16600 1
- 16601 1
- 16602 1
- 16603 1
- 16681 1
- 16689 1
- 16690 1
- 16691 1
- 16692 1
- 16693 1
- 16694 1
- 16695 1
- 16696 1
- 16697 1
- 16698 1
- 16699 1
- 16700 1
- 16701 1
- 16702 1
- 16703 1
- 16704 1
- 16705 1
- 16706 1
- 16707 1
- 16708 1
- 16709 1
- 16710 1
- 16711 1
- 16712 1
- 16713 1
- 16791 1
- 16896 1
- 16897 1
- 16898 1
- 17217 1
- 17320 1
- 17446 1
- 17466 1
- 17524 1
- 17659 1
- 17756 1
- 17911 1
- 18142 1
- 18172 1
- 18237 1
- 18278 1
- 18279 1
- 18295 1
- 18301 1
- 18513 1
- 18514 1
- 18515 1
- 18645 1
- 18646 1
- 18647 1
- 18648 1
- 18649 1
- 18650 1
- 18651 1
- 18652 1
- 18653 1
- 18654 1
- 18655 1
- 18656 1
- 18657 1
- 18658 1
- 18659 1
- 18660 1
- 18661 1
- 18662 1
- 18663 1
- 18664 1
- 18707 1
- 18795 1
- 18971 1
- 19002 1
- 19012 1
- 19013 1
- 19023 1
- 19024 1
- 19209 1
- 19382 1
- 19436 1
- 19508 1
- 19509 1
- 19511 1
- 19519 1
- 19545 1
- 19546 1
- 19547 1
- 19548 1
- 19549 1
- 19550 1
- 19551 1
- 19552 1
- 19553 1
- 19554 1
- 19639 1
- 19640 1
- 19903 1
- 19962 1
- 20123 1
- 20238 1
- 20239 1
- 20241 1
- 20242 1
- 20243 1
- 20245 1
- 20247 1
- 20248 1
- 20249 1
- 20250 1
- 20251 1
- 20252 1
- 20253 1
- 20254 1
- 20255 1
- 20256 1
- 20257 1
- 20258 1
- 20259 1
- 20260 1
- 20261 1
- 20262 1
- 20263 1
- 20264 1
- 20265 1
- 20266 1
- 20268 1
- 20269 1
- 20270 1
- 20539 1
- 20837 1
- 20889 1
- 20895 1
- 20898 1
- 20900 1
- 20901 1
- 20902 1
- 20906 1
- 20908 1
- 20909 1
- 20910 1
- 20912 1
- 20913 1
- 20914 1
- 20916 1
- 20918 1
- 20919 1
- 20920 1
- 20921 1
- 20922 1
- 20923 1
- 20926 1
- 20927 1
- 20929 1
- 20930 1
- 20932 1
- 20933 1
- 20934 1
- 20935 1
- 20936 1
- 20937 1
- 20938 1
- 20939 1
- 20940 1
- 20941 1
- 20942 1
- 20943 1
- 21158 1
- 21252 1
- 21255 1
- 21257 1
- 21381 1
- 21413 1
- 21420 1
- 21422 1
- 21423 1
- 21424 1
- 21425 1
- 21426 1
- 21427 1
- 21428 1
- 21429 1
- 21430 1
- 21431 1
- 21432 1
- 21434 1
- 21435 1
- 21485 1
- 21486 1
- 21489 1
- 21491 1
- 21492 1
- 21493 1
- 21494 1
- 21495 1
- 21543 1
- 21544 1
- 21545 1
- 21718 1
- 21719 1
- 21720 1
- 21721 1
- 21722 1
- 21723 1
- 21724 1
- 21725 1
- 21726 1
- 21727 1
- 21728 1
- 21810 1
- 21811 1
- 21825 1
- 21826 1
- 21827 1
- 21828 1
- 21885 1
- 22015 1
- 22040 1
- 22161 1
- 22232 1
- 22248 1
- 22251 1
- 22252 1
- 22337 1
- 22338 1
- 22339 1
- 22421 1
- 22422 1
- 22463 1
- 22464 1
- 22480 1
- 22481 1
- 22482 1
- 22483 1
- 22696 1
- 22729 1
- 22733 1
- 22817 1
- 22930 1
- 23024 1
- 23082 1
- 23136 1
- 23155 1
- 23157 1
- 23158 1
- 23159 1
- 23160 1
- 23161 1
- 23162 1
- 23163 1
- 23164 1
- 23165 1
- 23166 1
- 23167 1
- 23168 1
- 23169 1
- 23170 1
- 23171 1
- 23172 1
- 23173 1
- 23174 1
- 23175 1
- 23176 1
- 23210 1
- 23211 1
- 23212 1
- 23213 1
- 23214 1
- 23215 1
- 23216 1
- 23217 1
- 23218 1
- 23219 1
- 23220 1
- 23221 1
- 23242 1
- 23282 1
- 23519 1
- 23749 1
- 23750 1
- 23804 1
- 23806 1
- 23807 1
- 23932 1
- 23933 1
- 23934 1
- 23935 1
- 23936 1
- 23937 1
- 23938 1
- 23939 1
- 23940 1
- 23941 1
- 23942 1
- 23943 1
- 23944 1
- 23945 1
- 23946 1
- 23947 1
- 23948 1
- 23949 1
- 23950 1
- 23951 1
- 23953 1
- 23954 1
- 23955 1
- 23956 1
- 23957 1
- 23958 1
- 23959 1
- 23960 1
- 23961 1
- 23962 1
- 23963 1
- 23964 1
- 23965 1
- 23966 1
- 23967 1
- 23980 1
- 24032 1
- 24232 1
- 24236 1
- 24246 1
- 24262 1
- 24263 1
- 24283 1
- 24284 1
- 24285 1
- 24351 1
- 24397 1
- 24398 1
- 24399 1
- 24516 1
- 24517 1
- 24518 1
- 24519 1
- 24520 1
- 24521 1
- 24522 1
- 24523 1
- 24524 1
- 24525 1
- 24526 1
- 24527 1
- 24528 1
- 24529 1
- 24530 1
- 24531 1
- 24532 1
- 24548 1
- 24627 1
- 24628 1
- 24629 1
- 24630 1
- 24631 1
- 24632 1
- 24633 1
- 24634 1
- 24635 1
- 24636 1
- 24637 1
- 24638 1
- 24639 1
- 24640 1
- 24641 1
- 24642 1
- 24643 1
- 24644 1
- 24645 1
- 24646 1
- 24647 1
- 24648 1
- 24649 1
- 24650 1
- 24651 1
- 24652 1
- 24653 1
- 24654 1
- 24655 1
- 24656 1
- 24657 1
- 24658 1
- 24659 1
- 24660 1
- 24661 1
- 24662 1
- 24663 1
- 24664 1
- 24665 1
- 24666 1
- 24667 1
- 24668 1
- 24669 1
- 24724 1
- 24729 1
- 24767 1
- 24799 1
- 24800 1
- 24801 1
- 24802 1
- 24803 1
- 24828 1
- 24829 1
- 24849 1
- 24923 1
- 24928 1
- 24934 1
- 24935 1
- 24954 1
- 24990 1
- 25028 1
- 25042 1
- 25043 1
- 25044 1
- 25045 1
- 25046 1
- 25047 1
- 25048 1
- 25049 1
- 25050 1
- 25051 1
- 25064 1
- 25067 1
- 25070 1
- 25072 1
- 25073 1
- 25074 1
- 25078 1
- 25079 1
- 25104 1
- 25105 1
- 25106 1
- 25107 1
- 25108 1
- 25110 1
- 25111 1
- 25112 1
- 25113 1
- 25116 1
- 25117 1
- 25118 1
- 25157 1
- 25197 1
- 25207 1
- 25208 1
- 25209 1
- 25210 1
- 25211 1
- 25212 1
- 25213 1
- 25240 1
- 25251 1
- 25252 1
- 25253 1
- 25254 1
- 25255 1
- 25256 1
- 25257 1
- 25258 1
- 25259 1
- 25260 1
- 25261 1
- 25262 1
- 25263 1
- 25264 1
- 25265 1
- 25278 1
- 25286 1
- 25601 1
- 25612 1
- 25613 1
- 25793 1
- 25794 1
- 25858 1
- 25859 1
- 25860 1
- 25861 1
- 25862 1
- 26015 1
- 26121 1
- 26183 1
- 26217 1
- 26312 1
- 26407 1
- 26417 1
- 26419 1
- 26422 1
- 26430 1
- 26435 1
- 26464 1
- 26538 1
- 26540 1
- 26567 1
- 26568 1
- 26581 1
- 26604 1
- 26753 1
- 26778 1
- 26851 1
- 26852 1
- 26853 1
- 26854 1
- 26855 1
- 26856 1
- 26857 1
- 26858 1
- 26859 1
- 26860 1
- 26861 1
- 26862 1
- 26863 1
- 26864 1
- 26865 1
- 26866 1
- 26867 1
- 26868 1
- 26869 1
- 26870 1
- 26871 1
- 26872 1
- 26873 1
- 26874 1
- 26875 1
- 26877 1
- 26878 1
- 26879 1
- 26880 1
- 26884 1
- 26885 1
- 26888 1
- 26889 1
- 26890 1
- 26891 1
- 26892 1
- 26893 1
- 26894 1
- 26895 1
- 26896 1
- 26897 1
- 26898 1
- 26899 1
- 26900 1
- 26901 1
- 26902 1
- 26903 1
- 26904 1
- 26907 1
- 26918 1
- 26923 1
- 26925 1
- 26926 1
- 26929 1
- 26931 1
- 26932 1
- 26933 1
- 26934 1
- 26935 1
- 26936 1
- 26937 1
- 26938 1
- 26939 1
- 26940 1
- 26941 1
- 26942 1
- 26943 1
- 26944 1
- 26945 1
- 26946 1
- 26947 1
- 26950 1
- 26951 1
- 26952 1
- 26953 1
- 26954 1
- 26955 1
- 26956 1
- 26957 1
- 26958 1
- 26959 1
- 26960 1
- 26961 1
- 26962 1
- 26963 1
- 26964 1
- 26965 1
- 26966 1
- 26967 1
- 26968 1
- 26969 1
- 26970 1
- 26971 1
- 26972 1
- 26973 1
- 26974 1
- 26975 1
- 26976 1
- 26977 1
- 26978 1
- 26979 1
- 26980 1
- 26981 1
- 26982 1
- 26983 1
- 27087 1
- 27293 1
- 27309 1
- 27494 1
- 27564 1
- 27575 1
- 27591 1
- 27628 1
- 27655 1
- 27673 1
- 27714 1
- 27715 1
- 27716 1
- 27720 1
- 27797 1
- 27798 1
- 27799 1
- 27800 1
- 27801 1
- 27802 1
- 27803 1
- 27804 1
- 27805 1
- 27806 1
- 27807 1
- 27808 1
- 27809 1
- 27810 1
- 27811 1
- 27812 1
- 27813 1
- 27814 1
- 27815 1
- 27816 1
- 27817 1
- 27818 1
- 27819 1
- 27820 1
- 27821 1
- 27822 1
- 27823 1
- 27824 1
- 27825 1
- 27826 1
- 27827 1
- 27828 1
- 27829 1
- 27830 1
- 27831 1
- 27832 1
- 27833 1
- 27834 1
- 27835 1
- 27836 1
- 27837 1
- 27838 1
- 27839 1
- 27840 1
- 27841 1
- 27842 1
- 27843 1
- 27844 1
- 28172 1
- 28173 1
- 28176 1
- 28177 1
- 28252 1
- 28353 1
- 28604 1
- 28622 1
- 28635 1
- 28639 1
- 28648 1
- 28650 1
- 28651 1
- 28653 1
- 28659 1
- 28660 1
- 28665 1
- 28668 1
- 28669 1
- 28670 1
- 28676 1
- 28677 1
- 28684 1
- 28689 1
- 28690 1
- 28691 1
- 28697 1
- 28700 1
- 28701 1
- 28714 1
- 28715 1
- 28716 1
- 28718 1
- 28720 1
- 28745 1
- 28772 1
- 28785 1
- 28805 1
- 28810 1
- 28822 1
- 28830 1
- 28834 1
- 28848 1
- 28859 1
- 28862 1
- 29046 1
- 29082 1
- 29115 1
- 29252 1
- 29428 1
- 29430 1
- 29506 1
- 29525 1
- 29627 1
- 29676 1
- 29713 1
- 29714 1
- 29750 1
- 29809 1
- 29815 1
- 29858 1
- 29921 1
- 29996 1
- 30015 1
- 30035 1
- 30306 1
- 30320 1
- 30380 1
- 30393 1
- 30545 1
- 30546 1
- 30560 1
- 30720 1
- 30741 1
- 30753 1
- 30755 1
- 30959 1
- 30960 1
- 30961 1
- 31073 1
- 31145 1
- 31217 1
- 31268 1
- 31320 1
- 31361 1
- 31400 1
- 31410 1
- 31578 1
- 31663 1
- 31715 1
- 31796 1
- 31868 1
- 32173 1
- 32285 1
- 32605 1
- 32659 1
- 32671 1
- 32704 1
- 32788 1
- 32816 1
- 32826 1
- 32849 1
- 32892 1
- 32902 1
- 33178 1
- 33230 1
- 33238 1
- 33300 1
- 33301 1
- 33302 1
- 33303 1
- 33305 1
- 33314 1
- 33324 1
- 33386 1
- 33406 1
- 33428 1
- 33479 1
- 33491 1
- 33493 1
- 33557 1
- 33575 1
- 33604 1
- 33607 1
- 33611 1
- 33612 1
- 33636 1
- 33649 1
- 33652 1
- 33657 1
- 33667 1
- 33710 1
MNG_AGENCY 214
- Mountains Recreation and Conservation Authority 152
- Ventura, City of 106
- Butte, County of 52
- Yuba County Water Agency 48
- Roseville, City of 46
- Santa Barbara, County of 39
- Lake, County of 36
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Orange, County of 21
- Napa, City of 21
- Monterey, County of 18
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Los Angeles County Flood Control District 13
- Santa Cruz, City of 12
- Santa Barbara Flood Control and Water Conserv. District 12
- Oroville, City of 12
- Los Angeles, County of 11
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- San Lorenzo Valley Water District 9
- La Selva Beach Recreation District 8
- Watsonville, City of 7
- Scotts Valley, City of 7
- Torrance, City of 7
- San Luis Obispo, City of 6
- Los Angeles - Department of Water and Power, City of 6
- Sacramento, County of 6
- San Francisco - Public Utilities Commission, City and County of 5
- Salinas, City of 5
- Anaheim, City of 5
- Ventura, County of 5
- Stockton, City of 5
- Santa Cruz, County of 4
- San Diego, County of 4
- San Marcos, City of 4
- Marina, City of 4
- Morgan Hill, City of 4
- Lincoln, City of 4
- Calistoga, City of 4
- Pleasanton, City of 3
- Marin County Open Space District 3
- Solvang, City of 3
- Tulare, County of 3
- Riverside, County of 3
- Moorpark, City of 3
- Woodlake, City of 3
- Reedley, City of 3
- Clovis, City of 3
- Gridley, City of 3
- Ripon, City of 3
- Scotts Valley Water District 3
- Natomas Basin Conservancy 3
- Rio Dell, City of 3
- Santa Clara Valley Water District 3
- Patterson, City of 2
- San Francisco, City and County of 2
- Monterey, City of 2
- Carpinteria, City of 2
- Vista, City of 2
- Livermore, City of 2
- Hayward Area Recreation and Park District 2
- Riverside County Regional Park and Open Space District 2
- Fountain Valley, City of 2
- Rancho Palos Verdes, City of 2
- Orange, City of 2
- Hanford, City of 2
- Sonoma, City of 2
- Imperial Irrigation District 2
- Pittsburg, City of 2
- Sonoma County Agricultural Preservation and Open Space District 2
- American Canyon, City of 2
- Merced, County of 2
- Modesto, City of 2
- Vallejo, City of 2
- Winters, City of 2
- Truckee Tahoe Airport District 2
- North County Recreation and Park District 2
- Stanton, City of 2
- Orange County Water District 2
- Westfield Recreation and Park District 2
- Ramona Municipal Water District 2
- Western Riverside County Regional Conservation Authority 2
- Fortuna, City of 2
- Oakdale, City of 1
- Seal Beach, City of 1
- Claremont, City of 1
- Conejo Recreation and Park District 1
- Fresno, City of 1
- Santa Ana, City of 1
- San Jose, City of 1
- Santee, City of 1
- Victorville, City of 1
- Monterey Peninsula Regional Park District 1
- Newport Beach, City of 1
- South San Francisco, City of 1
- Oceanside, City of 1
- Coachella, City of 1
- Oxnard, City of 1
- Redlands, City of 1
- Napa County Regional Park and Open Space District 1
- Paso Robles, City of 1
- Chula Vista, City of 1
- Dana Point, City of 1
- Petaluma, City of 1
- Vacaville, City of 1
- Visalia, City of 1
- Fontana, City of 1
- Davis, City of 1
- Goleta, City of 1
- Laguna Beach, City of 1
- San Leandro, City of 1
- Loma Linda, City of 1
- Sonoma County Regional Parks Dept., County of 1
- Dos Palos, City of 1
- Fairfield, City of 1
- Placer, County of 1
- San Jacinto, City of 1
- Cerritos, City of 1
- Mill Valley, City of 1
- San Joaquin, City of 1
- Sanger, City of 1
- Lake Forest, City of 1
- Marin Municipal Water District 1
- Tustin, City of 1
- Paramount, City of 1
- Whittier, City of 1
- Long Beach, City of 1
- Pasadena, City of 1
- South Pasadena, City of 1
- Tehachapi, City of 1
- Monrovia, City of 1
- Diamond Bar, City of 1
- Benicia, City of 1
- Imperial, County of 1
- Antioch, City of 1
- San Rafael, City of 1
- San Clemente, City of 1
- San Bernardino, County of 1
- Lemoore, City of 1
- Fremont, City of 1
- North of the River Recreation and Park District 1
- Burlingame, City of 1
- Concord, City of 1
- Redwood City, City of 1
- Redding, City of 1
- Metropolitan Water District of Southern California 1
- Sunnyvale, City of 1
- Parlier, City of 1
- Dixon, City of 1
- Corte Madera, Town of 1
- Foster City, City of 1
- Lomita, City of 1
- Atwater, City of 1
- Santa Clara Valley Open Space Authority 1
- Soledad, City of 1
- Red Bluff, City of 1
- Napa, County of 1
- Newman, City of 1
- Sacramento, City of 1
- Yolo, County of 1
- Woodland, City of 1
- Humboldt, County of 1
- Olivehurst Public Utility District 1
- Folsom, City of 1
- Riverside County Habitat Conservation Agency 1
- Tehama, County of 1
- Sacramento Regional County Sanitation District 1
- Soquel Creek Water District 1
- Calexico, City of 1
- Galt, City of 1
- Sacramento and San Joaquin Drainage District 1
- Brisbane, City of 1
- Coloma-Lotus 1
- Blue Lake, City of 1
- Trinidad, City of 1
- Fresno Metropolitan Flood Control District 1
- Williams, City of 1
- Ridgecrest, City of 1
- Borrego Water District 1
- Orange County Department of Education, County of 1
- Alameda County Flood Control and Water Conservation District 1
- Soledad-Mission Recreation District 1
- Helix Water District 1
- California Reclamation District 2140 1
- Point Arena, City of 1
- Georgetown Divide Recreation District 1
- Coalinga, City of 1
- Coachella Valley Association of Governments 1
- Watershed Conservation Authority 1
- Olivenhain Municipal Water District 1
- Coastside County Water District 1
- Marina County Water District 1
- Aptos Sanitation District 1
- Marin Public Works Dept/Flood Control 1
- Novato Sanitary District 1
- Santa Ynez River Water Conservation District 1
- Modesto Irrigation District 1
- Turlock Irrigation District 1
- Trinity, County of 1
- Marin, County of 1
- Solano, County of 1
- North County Transit District 1
- Pasadena Department of Water and Power 1
MNG_AG_TYP 15
- City Agency 663
- County Agency 214
- Open Space District 155
- Water District 78
- Flood District 32
- Recreation/Parks District 28
- County Agency - Other 6
- Irrigation District 4
- Sanitation District 3
- Community Services District 2
- County Agency - Parks 1
- Special District - Other 1
- Metropolitan Planning Organization 1
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 859
- Unknown Access 204
- No Public Access 96
- Restricted Access 31
DES_TP 1
- Local Other or Unknown · 1,190 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108 | 108 | 107 | {"type": "Polygon", "coordinates": [[[-119.80165, 34.44381], [-119.80106, 34.44387], [-119.79957, 34.44402], [-119.79959, 34.44377], [-119.80161, 34.44357], [-119.80165, 34.44381]]]} | Unknown Access 4 | 295 | San Antonio Creek | 24829 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 1.291 | San Antonio Creek | 0 | Local Other or Unknown 14 | 4 | |
133 | 133 | 132 | {"type": "Polygon", "coordinates": [[[-119.74246, 34.44054], [-119.74244, 34.44072], [-119.74241, 34.44073], [-119.74215, 34.44091], [-119.74194, 34.44113], [-119.74168, 34.44129], [-119.74157, 34.44128], [-119.7414, 34.44128], [-119.74181, 34.44101], [-119.74204, 34.44079], [-119.74227, 34.44062], [-119.74234, 34.44054], [-119.74246, 34.44054]]]} | Unknown Access 4 | 414 | San Roque Creek | 24990 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.477 | San Roque Creek | 0 | Local Other or Unknown 14 | 4 | |
185 | 185 | 184 | {"type": "Polygon", "coordinates": [[[-119.52773, 34.40703], [-119.52713, 34.40837], [-119.52698, 34.40879], [-119.52686, 34.40923], [-119.52678, 34.40968], [-119.52672, 34.40966], [-119.52675, 34.4094], [-119.52682, 34.40907], [-119.52689, 34.40883], [-119.52701, 34.40848], [-119.52766, 34.40701], [-119.52773, 34.40703]]]} | Unknown Access 4 | 592 | Santa Monica Creek | 25117 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 0.489 | Santa Monica Creek | 0 | Local Other or Unknown 14 | 4 | |
208 | 208 | 207 | {"type": "Polygon", "coordinates": [[[-117.09538, 33.13695], [-117.09362, 33.13752], [-117.09362, 33.1357], [-117.09365, 33.13567], [-117.09379, 33.1356], [-117.0939, 33.13563], [-117.09401, 33.1356], [-117.09406, 33.13557], [-117.09407, 33.13551], [-117.09406, 33.1355], [-117.09382, 33.13558], [-117.09362, 33.13548], [-117.09357, 33.13283], [-117.09348, 33.13177], [-117.09397, 33.13182], [-117.09425, 33.13159], [-117.09432, 33.13154], [-117.09436, 33.13154], [-117.09442, 33.13154], [-117.09451, 33.13179], [-117.09458, 33.13207], [-117.09474, 33.13462], [-117.09453, 33.13534], [-117.09455, 33.13535], [-117.0948, 33.13527], [-117.09484, 33.13577], [-117.09489, 33.13594], [-117.09494, 33.13615], [-117.09502, 33.13635], [-117.09522, 33.13672], [-117.0953, 33.13686], [-117.09538, 33.13695]]]} | No Public Access 3 | 654 | Reidy Canyon Creek | 24281 | 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 | 16.798 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
235 | 235 | 234 | {"type": "MultiPolygon", "coordinates": [[[[-117.09432, 33.11987], [-117.09377, 33.1199], [-117.09333, 33.11988], [-117.09298, 33.11971], [-117.09292, 33.11957], [-117.0934, 33.11955], [-117.09432, 33.11987]]], [[[-117.09563, 33.1199], [-117.09552, 33.12002], [-117.09533, 33.1203], [-117.09524, 33.12049], [-117.09521, 33.1206], [-117.09497, 33.12181], [-117.09491, 33.12286], [-117.09486, 33.12319], [-117.09477, 33.12344], [-117.0946, 33.1235], [-117.09447, 33.1232], [-117.09458, 33.12282], [-117.0946, 33.12228], [-117.09473, 33.12119], [-117.09482, 33.12061], [-117.09498, 33.12015], [-117.09521, 33.11975], [-117.09563, 33.1199]]]]} | No Public Access 3 | 684 | Reidy Canyon Creek | 24281 | 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 | 4.055 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
236 | 236 | 235 | {"type": "Polygon", "coordinates": [[[-117.09461, 33.12373], [-117.09348, 33.12592], [-117.09308, 33.12668], [-117.09291, 33.12629], [-117.09353, 33.12505], [-117.09345, 33.12492], [-117.09371, 33.12472], [-117.09415, 33.12388], [-117.09461, 33.12373]]]} | No Public Access 3 | 687 | Reidy Canyon Creek | 24281 | 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 | 2.732 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
251 | 251 | 250 | {"type": "Polygon", "coordinates": [[[-117.0929, 33.12785], [-117.09258, 33.12797], [-117.09245, 33.12767], [-117.09253, 33.12696], [-117.09276, 33.12662], [-117.09289, 33.12693], [-117.09286, 33.12698], [-117.09278, 33.12727], [-117.09278, 33.12756], [-117.0929, 33.12785]]]} | No Public Access 3 | 683 | Reidy Canyon Creek | 24281 | 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 | 0.966 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
275 | 275 | 274 | {"type": "Polygon", "coordinates": [[[-119.19704, 34.28676], [-119.1969, 34.28706], [-119.19612, 34.28715], [-119.19612, 34.28713], [-119.19635, 34.28707], [-119.19658, 34.28696], [-119.19673, 34.28683], [-119.19685, 34.28668], [-119.19704, 34.28676]]]} | Open Access 1 | 35439 | Ventura holding 73 | 26955 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.367 | Ventura holding 73 | 0 | Local Other or Unknown 14 | 4 | |
276 | 276 | 275 | {"type": "Polygon", "coordinates": [[[-119.17054, 34.28047], [-119.17066, 34.2806], [-119.17066, 34.28063], [-119.17064, 34.28066], [-119.16734, 34.28261], [-119.16727, 34.2826], [-119.16717, 34.28249], [-119.16745, 34.28232], [-119.16748, 34.28234], [-119.16892, 34.28149], [-119.16889, 34.28144], [-119.17054, 34.28047]]]} | Open Access 1 | 35440 | Ventura holding 72 | 26954 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.844 | Ventura holding 72 | 0 | Local Other or Unknown 14 | 4 | |
364 | 364 | 363 | {"type": "Polygon", "coordinates": [[[-119.67342, 34.42333], [-119.67318, 34.42356], [-119.67274, 34.42324], [-119.67299, 34.42301], [-119.67342, 34.42333]]]} | Unknown Access 4 | 1276 | Sycamore Creek | 26121 | 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 | 0.446 | Sycamore Creek | 0 | Local Other or Unknown 14 | 4 | |
392 | 392 | 391 | {"type": "Polygon", "coordinates": [[[-117.64422, 33.55212], [-117.64418, 33.55263], [-117.64416, 33.55266], [-117.64412, 33.55267], [-117.64351, 33.55263], [-117.6435, 33.5526], [-117.64355, 33.55204], [-117.64422, 33.55212]]]} | Open Access 1 | 35760 | Orange holding 14 | 23161 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.99 | Orange holding 14 | 0 | Local Other or Unknown 14 | 4 | |
393 | 393 | 392 | {"type": "Polygon", "coordinates": [[[-117.63356, 33.5534], [-117.63355, 33.55342], [-117.63311, 33.55365], [-117.63308, 33.55364], [-117.63287, 33.55333], [-117.6327, 33.553], [-117.63271, 33.55298], [-117.63319, 33.55282], [-117.63322, 33.55283], [-117.63338, 33.55312], [-117.63356, 33.5534]]]} | Open Access 1 | 35761 | Orange holding 15 | 23162 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.023 | Orange holding 15 | 0 | Local Other or Unknown 14 | 4 | |
472 | 472 | 471 | {"type": "Polygon", "coordinates": [[[-118.60788, 34.06942], [-118.60718, 34.06977], [-118.60688, 34.06935], [-118.60758, 34.069], [-118.60788, 34.06942]]]} | Open Access 1 | 35762 | Los Angeles holding 8 | 21495 | 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 | 1.024 | Los Angeles holding 8 | 0 | Local Other or Unknown 14 | 4 | |
740 | 740 | 739 | {"type": "MultiPolygon", "coordinates": [[[[-122.43261, 37.73842], [-122.43248, 37.73852], [-122.4324, 37.73848], [-122.43211, 37.73825], [-122.432, 37.7382], [-122.43185, 37.73817], [-122.43168, 37.73818], [-122.43124, 37.7383], [-122.43104, 37.73798], [-122.43159, 37.73777], [-122.43195, 37.73779], [-122.43261, 37.73842]]], [[[-122.43549, 37.74395], [-122.43519, 37.74397], [-122.43518, 37.7439], [-122.435, 37.74391], [-122.43495, 37.74329], [-122.43544, 37.74326], [-122.43547, 37.74327], [-122.43549, 37.74395]]]]} | Open Access 1 | 5519 | Diamond Hights Lot3 | 18142 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.023 | Diamond Hights Lot3 | 0 | Local Other or Unknown 14 | 4 | |
884 | 884 | 883 | {"type": "Polygon", "coordinates": [[[-122.78298, 39.06985], [-122.78285, 39.07024], [-122.78253, 39.07024], [-122.78268, 39.06984], [-122.78298, 39.06985]]]} | Open Access 1 | 35936 | Lake holding 49 | 20938 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 0.292 | Lake holding 49 | 0 | Local Other or Unknown 14 | 4 | |
927 | 927 | 926 | {"type": "Polygon", "coordinates": [[[-122.84377, 39.00039], [-122.84353, 39.00038], [-122.84353, 38.99972], [-122.84377, 38.99973], [-122.84377, 39.00039]]]} | Open Access 1 | 35937 | Lake holding 33 | 20921 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 0.38 | Lake holding 33 | 0 | Local Other or Unknown 14 | 4 | |
928 | 928 | 927 | {"type": "MultiPolygon", "coordinates": [[[[-118.59921, 34.0992], [-118.59903, 34.09939], [-118.59861, 34.09959], [-118.59848, 34.0997], [-118.59839, 34.10003], [-118.59832, 34.10038], [-118.59776, 34.10077], [-118.59771, 34.10077], [-118.5977, 34.10064], [-118.59805, 34.10038], [-118.59816, 34.10024], [-118.59822, 34.10008], [-118.59827, 34.09982], [-118.59832, 34.09971], [-118.59838, 34.09965], [-118.59873, 34.09941], [-118.59894, 34.09917], [-118.59904, 34.09909], [-118.59921, 34.0992]]], [[[-118.60098, 34.097], [-118.60043, 34.09746], [-118.60002, 34.09794], [-118.59991, 34.09786], [-118.60007, 34.09761], [-118.60025, 34.09742], [-118.60077, 34.0971], [-118.60089, 34.09699], [-118.60096, 34.09691], [-118.60098, 34.097]]], [[[-118.60123, 34.09661], [-118.60104, 34.09701], [-118.60099, 34.09686], [-118.60102, 34.09679], [-118.60106, 34.0966], [-118.60103, 34.09619], [-118.60109, 34.09619], [-118.6011, 34.09645], [-118.60123, 34.09661]]]]} | Open Access 1 | 6426 | Topanga Creek | 26407 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 1.477 | Topanga Creek | 0 | Local Other or Unknown 14 | 4 | |
1046 | 1046 | 1045 | {"type": "Polygon", "coordinates": [[[-118.34139, 34.12342], [-118.34119, 34.12342], [-118.34101, 34.12338], [-118.34082, 34.12338], [-118.34041, 34.12313], [-118.34051, 34.12301], [-118.34068, 34.12311], [-118.34077, 34.12313], [-118.34087, 34.12313], [-118.341, 34.12307], [-118.34139, 34.12342]]]} | Open Access 1 | 6900 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.464 | 0 | Local Other or Unknown 14 | 4 | ||
1066 | 1066 | 1065 | {"type": "Polygon", "coordinates": [[[-118.16257, 34.20755], [-118.16261, 34.2077], [-118.16261, 34.20779], [-118.16252, 34.20798], [-118.16232, 34.20798], [-118.16232, 34.20756], [-118.16257, 34.20755]]]} | Open Access 1 | 6963 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.283 | 0 | Local Other or Unknown 14 | 4 | ||
1149 | 1149 | 1148 | {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} | Restricted Access 2 | 6734 | Hillcrest And Ocean View Lots | 19962 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 0.08 | Hillcrest And Ocean View Lots | 0 | Local Other or Unknown 14 | 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]);