units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
60 rows where ACCESS_TYP = 3, DES_TP = 14 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY, LABEL_NAME
MNG_AGENCY 19
- Los Angeles, City of 12
- Escondido, City of 9
- San Diego, City of 8
- Napa, City of 8
- Rocklin, City of 6
- Los Angeles - Department of Water and Power, City of 2
- Rancho Palos Verdes, City of 2
- Torrance, City of 2
- Watsonville, City of 1
- Chula Vista, City of 1
- Petaluma, City of 1
- Davis, City of 1
- San Marcos, City of 1
- Paramount, City of 1
- Diamond Bar, City of 1
- American Canyon, City of 1
- Soledad, City of 1
- Sacramento, City of 1
- Pasadena Department of Water and Power 1
MNG_AG_TYP 1
- City Agency · 60 ✖
DES_TP 1
- Local Other or Unknown · 60 ✖
ACCESS_TYP 1
- No Public Access · 60 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15478 | 15478 | 15477 | {"type": "Polygon", "coordinates": [[[-121.79324, 36.88092], [-121.79324, 36.88092], [-121.78808, 36.88474], [-121.78767, 36.88399], [-121.79284, 36.88016], [-121.79324, 36.88092]]]} | No Public Access 3 | 36631 | Unnamed site - Watsonville, City of | 28700 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 13.356 | 0 | Local Other or Unknown 14 | 4 | ||
15449 | 15449 | 15448 | {"type": "Polygon", "coordinates": [[[-122.30439, 38.26326], [-122.30382, 38.2634], [-122.30362, 38.26287], [-122.30419, 38.26274], [-122.30439, 38.26326]]]} | No Public Access 3 | 36595 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.78 | 0 | Local Other or Unknown 14 | 4 | ||
15325 | 15325 | 15324 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19586], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | 48970 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1153 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | Los Angeles 6 | 5.621 | 0 | Local Other or Unknown 14 | 4 | ||
13981 | 13981 | 13980 | {"type": "Polygon", "coordinates": [[[-118.37443, 33.82141], [-118.37442, 33.82234], [-118.37432, 33.82233], [-118.37398, 33.82192], [-118.37365, 33.822], [-118.37358, 33.82193], [-118.37359, 33.82188], [-118.37374, 33.82172], [-118.374, 33.82188], [-118.37443, 33.82141]]]} | No Public Access 3 | 36651 | Torrance holding 11 | 26417 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.738 | Torrance holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13883 | 13883 | 13882 | {"type": "Polygon", "coordinates": [[[-121.25613, 38.82953], [-121.25455, 38.83106], [-121.25434, 38.83148], [-121.25459, 38.83065], [-121.25495, 38.83003], [-121.25525, 38.82964], [-121.25526, 38.82948], [-121.25506, 38.82931], [-121.25526, 38.82919], [-121.25549, 38.82909], [-121.25567, 38.82935], [-121.25594, 38.82924], [-121.25613, 38.82953]]]} | No Public Access 3 | 36473 | Rocklin holding 9 | 24532 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.565 | Rocklin holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13882 | 13882 | 13881 | {"type": "Polygon", "coordinates": [[[-121.25806, 38.82755], [-121.25787, 38.82775], [-121.25752, 38.82708], [-121.25728, 38.82686], [-121.25697, 38.82662], [-121.25692, 38.82637], [-121.25716, 38.82632], [-121.25735, 38.82645], [-121.25806, 38.82755]]]} | No Public Access 3 | 36472 | Rocklin holding 8 | 24531 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.03 | Rocklin holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13881 | 13881 | 13880 | {"type": "Polygon", "coordinates": [[[-121.25251, 38.82722], [-121.25091, 38.82731], [-121.25113, 38.82719], [-121.25077, 38.82655], [-121.25226, 38.82667], [-121.25237, 38.82663], [-121.25251, 38.82722]]]} | No Public Access 3 | 36471 | Rocklin holding 6 | 24529 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.285 | Rocklin holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13880 | 13880 | 13879 | {"type": "Polygon", "coordinates": [[[-121.25747, 38.82554], [-121.25724, 38.82581], [-121.25685, 38.82593], [-121.25694, 38.82622], [-121.25666, 38.82626], [-121.25656, 38.82592], [-121.25645, 38.82581], [-121.25608, 38.82602], [-121.25539, 38.82611], [-121.25449, 38.82674], [-121.25371, 38.82681], [-121.25267, 38.82716], [-121.25254, 38.82656], [-121.25284, 38.82645], [-121.25367, 38.82638], [-121.25449, 38.82624], [-121.25513, 38.82583], [-121.25571, 38.82557], [-121.25628, 38.82504], [-121.25671, 38.82444], [-121.25736, 38.82486], [-121.25717, 38.82502], [-121.25743, 38.82524], [-121.25747, 38.82554]]]} | No Public Access 3 | 36470 | Rocklin holding 7 | 24530 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 7.963 | Rocklin holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13877 | 13877 | 13876 | {"type": "Polygon", "coordinates": [[[-121.26559, 38.82111], [-121.26234, 38.82106], [-121.26396, 38.81851], [-121.26338, 38.81563], [-121.26341, 38.81439], [-121.26407, 38.81448], [-121.26519, 38.8147], [-121.26558, 38.81763], [-121.26582, 38.81916], [-121.26559, 38.82111]]]} | No Public Access 3 | 36468 | Rocklin holding 17 | 24524 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 33.242 | Rocklin holding 17 | 0 | Local Other or Unknown 14 | 4 | |
13854 | 13854 | 13853 | {"type": "Polygon", "coordinates": [[[-121.26424, 38.82108], [-121.26403, 38.82133], [-121.26303, 38.82156], [-121.26234, 38.82151], [-121.26169, 38.82177], [-121.26083, 38.82268], [-121.26025, 38.82268], [-121.25958, 38.8232], [-121.25959, 38.82321], [-121.26023, 38.82329], [-121.26016, 38.8237], [-121.25865, 38.82437], [-121.25774, 38.82444], [-121.25753, 38.82471], [-121.25701, 38.82425], [-121.25747, 38.82401], [-121.25869, 38.82323], [-121.26023, 38.82202], [-121.26138, 38.82135], [-121.26194, 38.82112], [-121.26234, 38.82107], [-121.26424, 38.82108]]]} | No Public Access 3 | 36443 | Rocklin holding 3 | 24526 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 12.656 | Rocklin holding 3 | 0 | Local Other or Unknown 14 | 4 | |
11558 | 11558 | 11557 | {"type": "MultiPolygon", "coordinates": [[[[-116.9417, 32.65977], [-116.94153, 32.66001], [-116.94146, 32.66001], [-116.94134, 32.6601], [-116.94109, 32.66002], [-116.94043, 32.66015], [-116.94013, 32.66023], [-116.93992, 32.66038], [-116.93985, 32.66099], [-116.93993, 32.66109], [-116.9397, 32.66127], [-116.93967, 32.66141], [-116.9396, 32.6615], [-116.93959, 32.66161], [-116.93963, 32.66169], [-116.93962, 32.66217], [-116.93965, 32.66241], [-116.93987, 32.66274], [-116.94009, 32.66304], [-116.94024, 32.66334], [-116.94034, 32.66367], [-116.94033, 32.66399], [-116.94054, 32.66419], [-116.9404, 32.66434], [-116.94029, 32.66436], [-116.94008, 32.66444], [-116.94005, 32.66456], [-116.94009, 32.66474], [-116.94001, 32.66501], [-116.93996, 32.66512], [-116.93976, 32.66522], [-116.9396, 32.66538], [-116.93934, 32.66555], [-116.93931, 32.66565], [-116.93918, 32.66573], [-116.93914, 32.66578], [-116.93875, 32.66581], [-116.93873, 32.6657], [-116.93858, 32.66549], [-116.93836, 32.66534], [-116.938, 32.66531], [-116.93731, 32.66566], [-116.93724, 32.66576], [-116.93717, 32.66597], [-116.93703, 32.66611], [-116.9369, 32.66631], [-116.93668, 32.66655], [-116.93668, 32.66669], [-116.93654, 32.66682], [-116.93654, 32.66609], [-116.93437, 32.66605], [-116.93437, 32.66514], [-116.93657, 32.66518], [-116.93658, 32.65806], [-116.93693, 32.65833], [-116.93729, 32.65869], [-116.93758, 32.65884], [-116.93762, 32.65906], [-116.93794, 32.6591], [-116.93841, 32.65947], [-116.93842, 32.65946], [-116.93836, 32.65931], [-116.93804, 32.65879], [-116.93796, 32.6586], [-116.93774, 32.65835], [-116.93772, 32.658], [-116.93753, 32.65766], [-116.93762, 32.65749], [-116.93789, 32.65742], [-116.93831, 32.65764], [-116.93832, 32.65762], [-116.93807, 32.65723], [-116.9378, 32.65714], [-116.93724, 32.65649], [-116.93706, 32.65639], [-116.93678, 32.65633], [-116.93682, 32.65603], [-116.93777, 32.65605], [-116.9417, 32.65977]]], [[[-116.95166, 32.66641], [-116.95161, 32.66692], [-116.95163, 32.66696], [-116.9516, 32.66703], [-116.95159, 32.66721], [-116.94962, 32.66719], [-116.94953, 32.67814], [-116.93649, 32.67798], [-116.93651, 32.67515], [-116.93667, 32.67515], [-116.93683, 32.67519], [-116.93694, 32.6752], [-116.937, 32.6752], [-116.93708, 32.67517], [-116.937, 32.67534], [-116.93703, 32.67544], [-116.93686, 32.67577], [-116.93682, 32.67622], [-116.93675, 32.6765], [-116.93679, 32.67697], [-116.93684, 32.67708], [-116.93688, 32.67715], [-116.93696, 32.67721], [-116.93752, 32.67753], [-116.93754, 32.67758], [-116.93807, 32.6779], [-116.93872, 32.67798], [-116.93913, 32.67797], [-116.93933, 32.678], [-116.9401, 32.67801], [-116.94019, 32.67798], [-116.94054, 32.6777], [-116.94082, 32.67743], [-116.94095, 32.67737], [-116.94108, 32.67716], [-116.94113, 32.67717], [-116.9413, 32.67694], [-116.94143, 32.67692], [-116.94154, 32.67667], [-116.94162, 32.67667], [-116.94173, 32.67639], [-116.94186, 32.67643], [-116.94196, 32.67616], [-116.94206, 32.67615], [-116.94218, 32.6761], [-116.94226, 32.67602], [-116.94231, 32.67586], [-116.94232, 32.67553], [-116.94247, 32.67554], [-116.94248, 32.67527], [-116.94261, 32.67524], [-116.94262, 32.67502], [-116.9427, 32.67497], [-116.9427, 32.6743], [-116.94259, 32.67397], [-116.9425, 32.67384], [-116.94237, 32.67376], [-116.9422, 32.67371], [-116.94199, 32.67373], [-116.94189, 32.67371], [-116.94183, 32.67364], [-116.94184, 32.67335], [-116.94216, 32.67292], [-116.94273, 32.67265], [-116.94281, 32.67271], [-116.94307, 32.67268], [-116.9431, 32.6727], [-116.94321, 32.67272], [-116.94386, 32.67371], [-116.94389, 32.67392], [-116.94388, 32.67401], [-116.94378, 32.67405], [-116.94361, 32.67418], [-116.94352, 32.67448], [-116.94349, 32.67461], [-116.94354, 32.67466], [-116.94361, 32.67464], [-116.94367, 32.67484], [-116.9436, 32.67485], [-116.94359, 32.67486], [-116.94364, 32.67493], [-116.94377, 32.67508], [-116.94364, 32.67528], [-116.94367, 32.67533], [-116.94377, 32.67536], [-116.94392, 32.67554], [-116.94405, 32.67567], [-116.94417, 32.67587], [-116.9444, 32.67615], [-116.94486, 32.67639], [-116.94499, 32.6764], [-116.94518, 32.67651], [-116.94561, 32.67672], [-116.94595, 32.67672], [-116.94643, 32.67668], [-116.94681, 32.67689], [-116.94765, 32.67679], [-116.94767, 32.67675], [-116.94821, 32.67687], [-116.94836, 32.67646], [-116.94841, 32.67642], [-116.94863, 32.67585], [-116.9488, 32.6756], [-116.94889, 32.6755], [-116.94905, 32.67487], [-116.94904, 32.67475], [-116.94922, 32.67465], [-116.94934, 32.67443], [-116.94939, 32.67418], [-116.94922, 32.67339], [-116.94905, 32.67322], [-116.94902, 32.6731], [-116.94906, 32.67297], [-116.94905, 32.67283], [-116.94899, 32.67268], [-116.94892, 32.67261], [-116.94877, 32.67259], [-116.94868, 32.67261], [-116.94839, 32.67254], [-116.94823, 32.67256], [-116.94812, 32.67262], [-116.94805, 32.67271], [-116.94797, 32.67256], [-116.94782, 32.67248], [-116.94781, 32.67244], [-116.94765, 32.67235], [-116.94762, 32.67222], [-116.94757, 32.67219], [-116.9474, 32.67187], [-116.9473, 32.67183], [-116.94711, 32.67171], [-116.94694, 32.67167], [-116.94687, 32.67167], [-116.94685, 32.67147], [-116.94674, 32.6711], [-116.94672, 32.67073], [-116.94623, 32.66956], [-116.94603, 32.66927], [-116.94582, 32.669], [-116.94544, 32.66843], [-116.94568, 32.66829], [-116.946, 32.66758], [-116.94619, 32.66724], [-116.94636, 32.66705], [-116.9466, 32.66689], [-116.94664, 32.66679], [-116.94665, 32.66668], [-116.94654, 32.66642], [-116.94644, 32.66624], [-116.94634, 32.66615], [-116.94631, 32.66601], [-116.94627, 32.6659], [-116.94631, 32.66543], [-116.94648, 32.66474], [-116.94674, 32.66383], [-116.94672, 32.66346], [-116.94657, 32.66294], [-116.94649, 32.66275], [-116.94638, 32.66256], [-116.94624, 32.66246], [-116.9466, 32.66252], [-116.94774, 32.66266], [-116.94797, 32.66272], [-116.94821, 32.6627], [-116.94838, 32.66276], [-116.94856, 32.66278], [-116.94865, 32.6629], [-116.94881, 32.66299], [-116.9488, 32.66337], [-116.94888, 32.66345], [-116.94893, 32.66362], [-116.94902, 32.66379], [-116.94918, 32.6639], [-116.94948, 32.66429], [-116.94966, 32.66433], [-116.94978, 32.66455], [-116.9497, 32.66458], [-116.94975, 32.66464], [-116.94956, 32.66493], [-116.94962, 32.66499], [-116.94996, 32.66495], [-116.94998, 32.665], [-116.95009, 32.66509], [-116.95012, 32.66529], [-116.95016, 32.66532], [-116.95016, 32.66563], [-116.95029, 32.66579], [-116.95029, 32.66615], [-116.95016, 32.66624], [-116.95023, 32.66633], [-116.95041, 32.66644], [-116.95078, 32.66678], [-116.95134, 32.66642], [-116.95136, 32.66638], [-116.95139, 32.66638], [-116.95153, 32.66627], [-116.95166, 32.66641]]]]} | No Public Access 3 | 46837 | Rolling Hills Ranch | 30306 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 221.546 | Rolling Hills Ranch | 0 | Local Other or Unknown 14 | 4 | |
10935 | 10935 | 10934 | {"type": "Polygon", "coordinates": [[[-121.67546, 38.55795], [-121.67529, 38.56745], [-121.65712, 38.56762], [-121.65699, 38.57488], [-121.64781, 38.57492], [-121.63857, 38.57489], [-121.63885, 38.56638], [-121.66534, 38.56043], [-121.66535, 38.5608], [-121.66612, 38.5608], [-121.66614, 38.5602], [-121.66638, 38.56014], [-121.6664, 38.55998], [-121.67546, 38.55795]]]} | No Public Access 3 | 20963 | Howatt/Clayton Ranch | 20123 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 786.039 | Howatt/Clayton Ranch | 0 | Local Other or Unknown 14 | 4 | |
10235 | 10235 | 10234 | {"type": "MultiPolygon", "coordinates": [[[[-122.24463, 38.36675], [-122.24135, 38.37065], [-122.24136, 38.37067], [-122.24174, 38.37068], [-122.24269, 38.37071], [-122.24268, 38.3709], [-122.24261, 38.37117], [-122.24256, 38.37144], [-122.24251, 38.37156], [-122.24248, 38.37182], [-122.24255, 38.37251], [-122.24262, 38.37271], [-122.24271, 38.37278], [-122.24286, 38.37324], [-122.24362, 38.37352], [-122.24399, 38.37363], [-122.244, 38.37381], [-122.24379, 38.3739], [-122.24301, 38.37397], [-122.24243, 38.37411], [-122.24202, 38.37433], [-122.24175, 38.37461], [-122.24165, 38.375], [-122.24195, 38.37565], [-122.24199, 38.37584], [-122.24197, 38.37601], [-122.2419, 38.37616], [-122.24188, 38.37625], [-122.24189, 38.37634], [-122.24202, 38.3766], [-122.24205, 38.37676], [-122.24204, 38.37718], [-122.24197, 38.37771], [-122.24194, 38.37777], [-122.24185, 38.37784], [-122.24083, 38.37907], [-122.24064, 38.37951], [-122.24064, 38.37954], [-122.24017, 38.37955], [-122.24014, 38.38], [-122.24007, 38.38019], [-122.24008, 38.3802], [-122.24069, 38.38016], [-122.24088, 38.38114], [-122.24112, 38.38194], [-122.24107, 38.38199], [-122.2404, 38.38207], [-122.2401, 38.38214], [-122.23996, 38.38223], [-122.23985, 38.38236], [-122.23986, 38.38259], [-122.23991, 38.38282], [-122.23987, 38.383], [-122.23964, 38.3833], [-122.23924, 38.38351], [-122.23882, 38.38364], [-122.23842, 38.38371], [-122.23818, 38.38363], [-122.2379, 38.38348], [-122.23764, 38.3835], [-122.2375, 38.38354], [-122.23719, 38.38369], [-122.23698, 38.38382], [-122.23667, 38.38406], [-122.23599, 38.38426], [-122.23583, 38.3838], [-122.23573, 38.38356], [-122.23563, 38.38323], [-122.23546, 38.38283], [-122.23536, 38.38248], [-122.23531, 38.38223], [-122.2353, 38.38202], [-122.2352, 38.38178], [-122.23506, 38.38167], [-122.23485, 38.38155], [-122.23472, 38.38141], [-122.2347, 38.38113], [-122.23461, 38.3808], [-122.2345, 38.38061], [-122.23425, 38.38039], [-122.23412, 38.38032], [-122.23394, 38.38025], [-122.2338, 38.38015], [-122.23368, 38.37993], [-122.23363, 38.3798], [-122.23353, 38.37959], [-122.23339, 38.3794], [-122.23328, 38.37928], [-122.233, 38.37918], [-122.23286, 38.37908], [-122.23278, 38.37895], [-122.23276, 38.37881], [-122.23278, 38.37867], [-122.23278, 38.37851], [-122.23271, 38.3784], [-122.23252, 38.37836], [-122.23236, 38.37827], [-122.23197, 38.37814], [-122.23176, 38.37798], [-122.23155, 38.37772], [-122.23139, 38.37735], [-122.23131, 38.37697], [-122.23115, 38.37661], [-122.23113, 38.37651], [-122.23104, 38.37643], [-122.23091, 38.37635], [-122.23073, 38.37633], [-122.23023, 38.37635], [-122.23002, 38.37638], [-122.22974, 38.37649], [-122.22965, 38.37663], [-122.22959, 38.37681], [-122.22959, 38.37704], [-122.22963, 38.3773], [-122.22964, 38.37753], [-122.22981, 38.37811], [-122.23021, 38.37894], [-122.23028, 38.37911], [-122.23033, 38.37932], [-122.23052, 38.37954], [-122.23086, 38.3798], [-122.23173, 38.38018], [-122.23187, 38.38028], [-122.23186, 38.3804], [-122.23174, 38.38047], [-122.2311, 38.38053], [-122.23061, 38.38074], [-122.23048, 38.38084], [-122.23043, 38.38084], [-122.23049, 38.38074], [-122.23083, 38.38054], [-122.23084, 38.38044], [-122.23074, 38.38039], [-122.23059, 38.38024], [-122.23055, 38.3804], [-122.23061, 38.38048], [-122.23057, 38.38053], [-122.23045, 38.3806], [-122.23031, 38.38075], [-122.23023, 38.38093], [-122.23021, 38.38126], [-122.23016, 38.38146], [-122.23014, 38.38187], [-122.23016, 38.38217], [-122.23031, 38.38277], [-122.23034, 38.38297], [-122.23055, 38.38347], [-122.23068, 38.38364], [-122.23085, 38.38377], [-122.23109, 38.38387], [-122.23166, 38.3845], [-122.23181, 38.38464], [-122.23191, 38.3847], [-122.23227, 38.3848], [-122.23251, 38.38481], [-122.23293, 38.38481], [-122.23336, 38.38474], [-122.23377, 38.38472], [-122.23419, 38.3847], [-122.2344, 38.3847], [-122.23456, 38.38474], [-122.2348, 38.38485], [-122.23492, 38.38489], [-122.23517, 38.38492], [-122.23533, 38.3849], [-122.2355, 38.38483], [-122.23563, 38.38474], [-122.23585, 38.3845], [-122.23602, 38.38443], [-122.23633, 38.38436], [-122.23665, 38.38426], [-122.23691, 38.38409], [-122.23708, 38.38394], [-122.23736, 38.38378], [-122.2377, 38.38367], [-122.23787, 38.3837], [-122.23816, 38.3838], [-122.23854, 38.38384], [-122.23894, 38.38377], [-122.23939, 38.3836], [-122.2397, 38.38343], [-122.23994, 38.38324], [-122.2401, 38.38309], [-122.24015, 38.38291], [-122.24014, 38.38275], [-122.2401, 38.38263], [-122.24007, 38.38241], [-122.24011, 38.38231], [-122.24023, 38.38225], [-122.24062, 38.38218], [-122.24078, 38.38218], [-122.24112, 38.38211], [-122.24121, 38.38215], [-122.2421, 38.38406], [-122.24237, 38.38472], [-122.24272, 38.3854], [-122.24295, 38.38578], [-122.24321, 38.38637], [-122.2434, 38.38666], [-122.2431, 38.387], [-122.24309, 38.38705], [-122.24316, 38.38743], [-122.24308, 38.38773], [-122.24289, 38.3883], [-122.24269, 38.38873], [-122.24256, 38.38891], [-122.24219, 38.38933], [-122.24182, 38.38963], [-122.24156, 38.38968], [-122.24134, 38.38976], [-122.24126, 38.38983], [-122.24121, 38.38995], [-122.24122, 38.3903], [-122.24117, 38.39046], [-122.24111, 38.39055], [-122.24058, 38.3911], [-122.24, 38.3915], [-122.23996, 38.3917], [-122.23999, 38.3919], [-122.24017, 38.3922], [-122.24031, 38.39239], [-122.23976, 38.39238], [-122.2397, 38.3924], [-122.23965, 38.39488], [-122.23957, 38.39508], [-122.23953, 38.39531], [-122.23954, 38.3957], [-122.23966, 38.39602], [-122.23709, 38.396], [-122.23521, 38.396], [-122.23516, 38.40366], [-122.22631, 38.4035], [-122.22627, 38.39597], [-122.22176, 38.39593], [-122.22164, 38.38869], [-122.21244, 38.38862], [-122.21238, 38.37403], [-122.22656, 38.37413], [-122.2311, 38.37409], [-122.23107, 38.36982], [-122.231, 38.36687], [-122.24463, 38.36675]]], [[[-122.23506, 38.38194], [-122.23511, 38.38212], [-122.23514, 38.38236], [-122.23526, 38.38286], [-122.23544, 38.38326], [-122.23547, 38.38344], [-122.23555, 38.38363], [-122.23571, 38.38399], [-122.23574, 38.38423], [-122.2357, 38.38438], [-122.2356, 38.3845], [-122.23537, 38.38469], [-122.23524, 38.38475], [-122.23504, 38.38477], [-122.2348, 38.38465], [-122.23468, 38.38461], [-122.23441, 38.38455], [-122.23414, 38.38455], [-122.23336, 38.38461], [-122.23279, 38.3847], [-122.23243, 38.38468], [-122.23218, 38.38463], [-122.23197, 38.38454], [-122.23184, 38.38442], [-122.23138, 38.38388], [-122.2312, 38.38371], [-122.2309, 38.38358], [-122.23073, 38.38344], [-122.23058, 38.38309], [-122.23048, 38.38257], [-122.23037, 38.38223], [-122.23035, 38.38205], [-122.23043, 38.38117], [-122.23053, 38.38103], [-122.23068, 38.3809], [-122.2309, 38.38078], [-122.23121, 38.38068], [-122.23158, 38.38063], [-122.23201, 38.38052], [-122.2321, 38.38044], [-122.23214, 38.38034], [-122.2321, 38.38024], [-122.23202, 38.38016], [-122.2315, 38.37992], [-122.23132, 38.3798], [-122.23113, 38.37973], [-122.23099, 38.37965], [-122.23086, 38.37956], [-122.23063, 38.37933], [-122.23042, 38.37894], [-122.23026, 38.37859], [-122.23019, 38.37841], [-122.23013, 38.37832], [-122.2299, 38.37769], [-122.2298, 38.37692], [-122.22981, 38.37677], [-122.22988, 38.37667], [-122.23017, 38.37654], [-122.23042, 38.3765], [-122.23076, 38.37655], [-122.23085, 38.37659], [-122.23094, 38.37667], [-122.23101, 38.37681], [-122.23128, 38.37762], [-122.2314, 38.37785], [-122.2316, 38.37809], [-122.23186, 38.37828], [-122.23257, 38.37855], [-122.23257, 38.37887], [-122.23265, 38.37905], [-122.23286, 38.37927], [-122.23298, 38.37931], [-122.23313, 38.37942], [-122.23327, 38.37957], [-122.23341, 38.3798], [-122.23357, 38.38016], [-122.23368, 38.38029], [-122.23385, 38.38039], [-122.23407, 38.38048], [-122.23423, 38.38057], [-122.23441, 38.38083], [-122.23449, 38.38104], [-122.23452, 38.38122], [-122.23452, 38.38141], [-122.23459, 38.38153], [-122.23471, 38.38169], [-122.23493, 38.3818], [-122.23506, 38.38194]]], [[[-122.24403, 38.37272], [-122.24398, 38.37358], [-122.24306, 38.37325], [-122.24305, 38.37274], [-122.24375, 38.3727], [-122.24403, 38.37272]]]]} | No Public Access 3 | 17909 | Milliken Reservoir Property | 22252 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1712.398 | Milliken Reservoir Property | 0 | Local Other or Unknown 14 | 4 | |
9993 | 9993 | 9992 | {"type": "Polygon", "coordinates": [[[-117.00987, 32.55768], [-117.00557, 32.5576], [-117.00555, 32.56025], [-117.00128, 32.56018], [-117.00126, 32.55751], [-116.99834, 32.55745], [-116.99769, 32.55743], [-116.99699, 32.55743], [-116.99699, 32.55385], [-116.99614, 32.55382], [-116.99588, 32.55353], [-116.99536, 32.55264], [-116.99513, 32.55248], [-116.99481, 32.55243], [-116.99449, 32.55257], [-116.99356, 32.55323], [-116.993, 32.55322], [-116.99287, 32.55313], [-116.99284, 32.55268], [-116.99337, 32.55212], [-116.99346, 32.55187], [-116.99337, 32.55162], [-116.99317, 32.55135], [-116.9927, 32.55115], [-116.99269, 32.55005], [-116.99912, 32.55022], [-116.99914, 32.55328], [-116.99985, 32.5533], [-116.99986, 32.55391], [-117.00986, 32.55413], [-117.00985, 32.55619], [-117.00987, 32.55768]]]} | No Public Access 3 | 47971 | Otay Mitigation Site | 32285 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 200.028 | Otay Mitigation Site | 0 | Local Other or Unknown 14 | 4 | |
8218 | 8218 | 8217 | {"type": "MultiPolygon", "coordinates": [[[[-117.15598, 33.10707], [-117.15561, 33.10724], [-117.15541, 33.10729], [-117.15513, 33.10743], [-117.15484, 33.1075], [-117.15451, 33.10766], [-117.15398, 33.10779], [-117.15382, 33.10784], [-117.15357, 33.10796], [-117.15344, 33.10805], [-117.1534, 33.10809], [-117.15337, 33.10818], [-117.1534, 33.10835], [-117.15356, 33.10863], [-117.15377, 33.10915], [-117.15402, 33.10997], [-117.15394, 33.10991], [-117.15386, 33.10987], [-117.15326, 33.10975], [-117.15296, 33.10964], [-117.15283, 33.11018], [-117.15297, 33.11064], [-117.15345, 33.11053], [-117.15394, 33.11036], [-117.15385, 33.11066], [-117.1538, 33.11078], [-117.15369, 33.11096], [-117.15363, 33.111], [-117.15356, 33.11101], [-117.15302, 33.11098], [-117.15136, 33.11131], [-117.15112, 33.11093], [-117.15102, 33.11072], [-117.151, 33.11064], [-117.151, 33.11048], [-117.15098, 33.11037], [-117.15081, 33.10999], [-117.1507, 33.10967], [-117.1507, 33.10956], [-117.15072, 33.10945], [-117.15071, 33.10937], [-117.15038, 33.10894], [-117.15017, 33.10859], [-117.15012, 33.10852], [-117.15003, 33.10847], [-117.14962, 33.10829], [-117.14952, 33.10827], [-117.14942, 33.10828], [-117.14875, 33.10845], [-117.14855, 33.10847], [-117.14838, 33.10846], [-117.14822, 33.10849], [-117.14822, 33.1055], [-117.14954, 33.10548], [-117.1506, 33.10609], [-117.15282, 33.10654], [-117.15402, 33.10642], [-117.15598, 33.10707]]], [[[-117.16972, 33.11406], [-117.16939, 33.11424], [-117.16912, 33.11452], [-117.16906, 33.11473], [-117.16849, 33.11523], [-117.16743, 33.1153], [-117.16683, 33.11496], [-117.16594, 33.11491], [-117.16555, 33.11498], [-117.16536, 33.11482], [-117.16487, 33.11397], [-117.1649, 33.1136], [-117.1652, 33.11353], [-117.16583, 33.11369], [-117.16658, 33.11343], [-117.16665, 33.11328], [-117.1677, 33.11329], [-117.16765, 33.11374], [-117.16779, 33.11418], [-117.1683, 33.11424], [-117.16868, 33.11397], [-117.16907, 33.11344], [-117.16928, 33.11337], [-117.16945, 33.11372], [-117.16972, 33.11395], [-117.16972, 33.11406]]]]} | No Public Access 3 | 47787 | South Lake Mitigation | 31663 | 2170 | Vallecitos Water District 879 | Special District 4 | Water District 13 | http://www.vwd.org/ | Special District 4 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 72.132 | South Lake Mitigation | 0 | Local Other or Unknown 14 | 4 | |
8209 | 8209 | 8208 | {"type": "Polygon", "coordinates": [[[-118.34266, 34.12073], [-118.34239, 34.12092], [-118.34236, 34.12088], [-118.34217, 34.12072], [-118.3424, 34.12055], [-118.34256, 34.12064], [-118.34266, 34.12073]]]} | No Public Access 3 | 12464 | Los Angeles Department of Water and Power | 21482 | 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 | 0.23 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
8208 | 8208 | 8207 | {"type": "MultiPolygon", "coordinates": [[[[-118.34152, 34.1213], [-118.34152, 34.12134], [-118.34148, 34.12139], [-118.34142, 34.1215], [-118.34141, 34.12163], [-118.34115, 34.12183], [-118.34097, 34.12159], [-118.34146, 34.12124], [-118.34152, 34.1213]]], [[[-118.34202, 34.12109], [-118.34195, 34.12117], [-118.3418, 34.12119], [-118.34166, 34.12124], [-118.34159, 34.12124], [-118.34154, 34.12118], [-118.34192, 34.1209], [-118.34202, 34.121], [-118.34202, 34.12109]]]]} | No Public Access 3 | 12463 | Los Angeles Department of Water and Power | 21482 | 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 | 0.578 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
8207 | 8207 | 8206 | {"type": "Polygon", "coordinates": [[[-118.34724, 34.11998], [-118.34703, 34.11998], [-118.34699, 34.11995], [-118.34697, 34.11996], [-118.34677, 34.11971], [-118.34724, 34.1197], [-118.34724, 34.11998]]]} | No Public Access 3 | 12461 | Los Angeles Department of Water and Power | 21482 | 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 | 0.25 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
8206 | 8206 | 8205 | {"type": "MultiPolygon", "coordinates": [[[[-118.35903, 34.10633], [-118.35888, 34.10635], [-118.35902, 34.10725], [-118.35784, 34.10989], [-118.35508, 34.11224], [-118.35508, 34.11246], [-118.35482, 34.11246], [-118.35456, 34.11268], [-118.35061, 34.1192], [-118.35056, 34.11915], [-118.35048, 34.11913], [-118.35045, 34.1191], [-118.35045, 34.11906], [-118.35054, 34.11892], [-118.35054, 34.11881], [-118.35051, 34.11875], [-118.35429, 34.11252], [-118.3551, 34.11182], [-118.35542, 34.11156], [-118.35756, 34.10974], [-118.35868, 34.10723], [-118.35847, 34.10581], [-118.35835, 34.10582], [-118.35832, 34.1057], [-118.35883, 34.10517], [-118.35887, 34.10522], [-118.35888, 34.10529], [-118.35888, 34.10543], [-118.35903, 34.10633]]], [[[-118.35052, 34.11935], [-118.3503, 34.1197], [-118.3503, 34.11974], [-118.35023, 34.11985], [-118.35012, 34.11986], [-118.35002, 34.11989], [-118.34983, 34.11999], [-118.34977, 34.12001], [-118.34962, 34.12001], [-118.34946, 34.11999], [-118.34934, 34.12], [-118.34923, 34.12002], [-118.34903, 34.12012], [-118.34901, 34.12012], [-118.349, 34.11997], [-118.34841, 34.11998], [-118.34776, 34.11971], [-118.34993, 34.11969], [-118.35021, 34.11926], [-118.35045, 34.11935], [-118.35052, 34.11935]]]]} | No Public Access 3 | 12460 | Los Angeles Department of Water and Power | 21482 | 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 | 15.526 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
8202 | 8202 | 8201 | {"type": "Polygon", "coordinates": [[[-118.33726, 34.1416], [-118.33447, 34.14462], [-118.33195, 34.14673], [-118.33158, 34.14719], [-118.33121, 34.14736], [-118.33087, 34.14757], [-118.33172, 34.14655], [-118.33181, 34.14647], [-118.33421, 34.14444], [-118.33691, 34.14153], [-118.33594, 34.1372], [-118.33525, 34.13611], [-118.33514, 34.1361], [-118.33504, 34.13595], [-118.33491, 34.13583], [-118.3349, 34.13579], [-118.33491, 34.13557], [-118.3348, 34.13541], [-118.33462, 34.1353], [-118.33461, 34.13527], [-118.33462, 34.13512], [-118.33431, 34.13463], [-118.33375, 34.13174], [-118.33405, 34.12667], [-118.33463, 34.12624], [-118.33474, 34.12622], [-118.33484, 34.12622], [-118.33491, 34.12625], [-118.335, 34.12634], [-118.33437, 34.1268], [-118.33408, 34.13172], [-118.33454, 34.13412], [-118.33449, 34.13422], [-118.33457, 34.13423], [-118.33464, 34.13456], [-118.33626, 34.13712], [-118.33726, 34.1416]]]} | No Public Access 3 | 12457 | Los Angeles Department of Water and Power | 21482 | 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 | 19.655 | Los Angeles Department of Water and Power | 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]);