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 AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6548 | 6548 | 6547 | {"type": "Polygon", "coordinates": [[[-122.27836, 38.16698], [-122.27244, 38.16694], [-122.27213, 38.16617], [-122.26881, 38.16606], [-122.26808, 38.16422], [-122.27137, 38.16431], [-122.27832, 38.16431], [-122.27836, 38.16698]]]} | No Public Access 3 | 3636 | American Canyon Property | 15448 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 55.469 | American Canyon Property | 0 | Local Other or Unknown 14 | 4 | |
1216 | 1216 | 1215 | {"type": "Polygon", "coordinates": [[[-122.58991, 38.30992], [-122.57891, 38.32201], [-122.57277, 38.31852], [-122.58368, 38.30636], [-122.58991, 38.30992]]]} | No Public Access 3 | 7007 | Lafferty Ranch | 20837 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 272.49 | Lafferty Ranch | 0 | Local Other or Unknown 14 | 4 | |
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 | ||
1437 | 1437 | 1436 | {"type": "MultiPolygon", "coordinates": [[[[-118.34031, 34.12245], [-118.33893, 34.12345], [-118.33872, 34.12325], [-118.34008, 34.12224], [-118.34031, 34.12245]]], [[[-118.33885, 34.12352], [-118.33618, 34.12548], [-118.33607, 34.12549], [-118.33599, 34.12546], [-118.33595, 34.12544], [-118.3359, 34.12532], [-118.33855, 34.12337], [-118.33863, 34.12331], [-118.33885, 34.12352]]]]} | No Public Access 3 | 12459 | 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 | 3.847 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
1634 | 1634 | 1633 | {"type": "Polygon", "coordinates": [[[-118.33735, 34.1239], [-118.33702, 34.12408], [-118.33683, 34.12383], [-118.33721, 34.12367], [-118.33731, 34.12385], [-118.33735, 34.1239]]]} | No Public Access 3 | 12456 | 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.284 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
1637 | 1637 | 1636 | {"type": "Polygon", "coordinates": [[[-118.34683, 34.11999], [-118.34463, 34.11999], [-118.34429, 34.11994], [-118.34428, 34.12], [-118.34364, 34.12], [-118.3434, 34.12018], [-118.34321, 34.11995], [-118.34352, 34.11973], [-118.34369, 34.11972], [-118.3438, 34.11978], [-118.34393, 34.11981], [-118.34412, 34.1198], [-118.34424, 34.11974], [-118.34427, 34.11972], [-118.34662, 34.11971], [-118.34683, 34.11999]]]} | No Public Access 3 | 12462 | 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 | 2.35 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
2461 | 2461 | 2460 | {"type": "Polygon", "coordinates": [[[-118.34315, 34.12036], [-118.34289, 34.12054], [-118.34274, 34.1204], [-118.34265, 34.12036], [-118.34296, 34.12013], [-118.34315, 34.12036]]]} | No Public Access 3 | 12465 | 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.255 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
2462 | 2462 | 2461 | {"type": "Polygon", "coordinates": [[[-118.35722, 34.10552], [-118.35702, 34.10564], [-118.35703, 34.10532], [-118.35722, 34.10533], [-118.35722, 34.10552]]]} | No Public Access 3 | 12466 | 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.129 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
7024 | 7024 | 7023 | {"type": "MultiPolygon", "coordinates": [[[[-118.29936, 33.76462], [-118.29901, 33.76463], [-118.2977, 33.76459], [-118.29684, 33.76458], [-118.29636, 33.76464], [-118.29634, 33.7645], [-118.29695, 33.76443], [-118.29897, 33.76449], [-118.29936, 33.76447], [-118.29936, 33.76462]]], [[[-118.30254, 33.76446], [-118.30187, 33.76451], [-118.29974, 33.76461], [-118.29957, 33.76461], [-118.29955, 33.76452], [-118.29957, 33.76448], [-118.30224, 33.76435], [-118.30244, 33.7643], [-118.3025, 33.76432], [-118.30254, 33.76446]]], [[[-118.30313, 33.76447], [-118.30304, 33.76446], [-118.30276, 33.76452], [-118.30271, 33.76437], [-118.3028, 33.76437], [-118.30307, 33.76431], [-118.30313, 33.76447]]]]} | No Public Access 3 | 5974 | City of Los Angeles Flood Control | 17320 | 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 | 2.225 | City of Los Angeles Flood Control | 0 | Local Other or Unknown 14 | 4 | |
8200 | 8200 | 8199 | {"type": "MultiPolygon", "coordinates": [[[[-118.33463, 34.12624], [-118.33405, 34.12668], [-118.33375, 34.13173], [-118.33423, 34.13423], [-118.33134, 34.13425], [-118.33127, 34.12836], [-118.33126, 34.12624], [-118.3314, 34.12622], [-118.33151, 34.12623], [-118.33199, 34.12651], [-118.33206, 34.12654], [-118.3322, 34.12653], [-118.33229, 34.12646], [-118.33233, 34.1264], [-118.33231, 34.12629], [-118.33189, 34.12568], [-118.33186, 34.12556], [-118.33185, 34.12534], [-118.33189, 34.12527], [-118.33198, 34.12521], [-118.33226, 34.1252], [-118.33236, 34.12517], [-118.33241, 34.12512], [-118.33246, 34.12505], [-118.33247, 34.12491], [-118.3325, 34.12483], [-118.33258, 34.12473], [-118.33266, 34.12471], [-118.33271, 34.1247], [-118.33281, 34.12475], [-118.33288, 34.12486], [-118.33294, 34.12491], [-118.33301, 34.12494], [-118.33318, 34.12493], [-118.33321, 34.12493], [-118.33327, 34.12498], [-118.33328, 34.12505], [-118.33322, 34.1254], [-118.33325, 34.1255], [-118.33335, 34.12558], [-118.33341, 34.1256], [-118.33351, 34.1256], [-118.3338, 34.12547], [-118.33393, 34.12544], [-118.33422, 34.12543], [-118.33431, 34.12547], [-118.33435, 34.12552], [-118.33437, 34.12561], [-118.33421, 34.12606], [-118.33422, 34.12616], [-118.33429, 34.12624], [-118.33439, 34.12627], [-118.33463, 34.12624]]], [[[-118.34284, 34.1246], [-118.34175, 34.12562], [-118.34119, 34.12633], [-118.3416, 34.12668], [-118.34143, 34.12682], [-118.34141, 34.12682], [-118.34113, 34.12705], [-118.34105, 34.12717], [-118.34101, 34.12744], [-118.34101, 34.12754], [-118.3411, 34.12786], [-118.3411, 34.12797], [-118.34101, 34.12831], [-118.34098, 34.12834], [-118.3409, 34.12834], [-118.34052, 34.12814], [-118.34048, 34.12809], [-118.34041, 34.12807], [-118.34037, 34.12807], [-118.34024, 34.12822], [-118.34033, 34.12828], [-118.34028, 34.12827], [-118.33996, 34.1283], [-118.33987, 34.12837], [-118.33987, 34.12839], [-118.3403, 34.12878], [-118.34018, 34.12884], [-118.34025, 34.12909], [-118.34014, 34.12929], [-118.3393, 34.12926], [-118.33936, 34.12981], [-118.33931, 34.13018], [-118.33901, 34.13021], [-118.339, 34.13027], [-118.33897, 34.13033], [-118.33882, 34.13046], [-118.33869, 34.13065], [-118.33862, 34.13071], [-118.33836, 34.13081], [-118.33831, 34.13087], [-118.3383, 34.13091], [-118.33834, 34.13103], [-118.33835, 34.13111], [-118.33832, 34.13123], [-118.33825, 34.13137], [-118.33824, 34.13145], [-118.33825, 34.13153], [-118.33837, 34.13154], [-118.33834, 34.13175], [-118.33836, 34.13205], [-118.338, 34.13208], [-118.33796, 34.13204], [-118.33785, 34.131], [-118.33779, 34.13068], [-118.33772, 34.13043], [-118.33763, 34.13019], [-118.33731, 34.12941], [-118.33723, 34.12926], [-118.3371, 34.12911], [-118.33697, 34.12901], [-118.33678, 34.12891], [-118.33638, 34.12896], [-118.33638, 34.12897], [-118.33653, 34.12899], [-118.33665, 34.12903], [-118.33687, 34.12913], [-118.33703, 34.12927], [-118.33716, 34.12947], [-118.33747, 34.13022], [-118.33762, 34.13065], [-118.33768, 34.13095], [-118.33779, 34.1321], [-118.33774, 34.13213], [-118.33741, 34.13225], [-118.33733, 34.13226], [-118.33728, 34.13224], [-118.33722, 34.13219], [-118.33718, 34.1321], [-118.3371, 34.13203], [-118.33705, 34.13201], [-118.33695, 34.13201], [-118.33688, 34.13204], [-118.33682, 34.13209], [-118.33672, 34.13225], [-118.33663, 34.13233], [-118.33647, 34.1324], [-118.33641, 34.13248], [-118.3364, 34.13258], [-118.33644, 34.13272], [-118.33644, 34.13284], [-118.3364, 34.13298], [-118.3363, 34.13313], [-118.33616, 34.13322], [-118.33592, 34.13325], [-118.33568, 34.1334], [-118.33556, 34.13345], [-118.33532, 34.1335], [-118.33497, 34.13349], [-118.33486, 34.13353], [-118.33478, 34.13359], [-118.33468, 34.13377], [-118.33454, 34.13412], [-118.33408, 34.13172], [-118.33437, 34.1268], [-118.335, 34.12634], [-118.33512, 34.1268], [-118.33512, 34.1269], [-118.33508, 34.12699], [-118.33502, 34.12703], [-118.33485, 34.12713], [-118.33479, 34.12718], [-118.33476, 34.12725], [-118.33477, 34.12734], [-118.33482, 34.1274], [-118.33489, 34.12746], [-118.33492, 34.12751], [-118.33495, 34.1276], [-118.33494, 34.12767], [-118.33477, 34.12796], [-118.33467, 34.12805], [-118.33448, 34.12815], [-118.33441, 34.12822], [-118.33437, 34.12829], [-118.33437, 34.12836], [-118.33442, 34.12845], [-118.33452, 34.12853], [-118.33466, 34.12857], [-118.33474, 34.12863], [-118.33478, 34.1287], [-118.3348, 34.12882], [-118.33485, 34.12888], [-118.33491, 34.12894], [-118.33503, 34.12898], [-118.33515, 34.12898], [-118.33524, 34.12895], [-118.33532, 34.12889], [-118.33542, 34.12878], [-118.33555, 34.12873], [-118.33562, 34.12873], [-118.3357, 34.12876], [-118.3358, 34.12883], [-118.33589, 34.12888], [-118.33598, 34.1289], [-118.33609, 34.12889], [-118.33617, 34.12886], [-118.33624, 34.12881], [-118.33632, 34.12868], [-118.33632, 34.12856], [-118.33622, 34.12827], [-118.33619, 34.12816], [-118.33619, 34.12796], [-118.33633, 34.12742], [-118.33643, 34.12732], [-118.33649, 34.1273], [-118.33669, 34.12728], [-118.33675, 34.12726], [-118.3368, 34.12722], [-118.33685, 34.12714], [-118.33685, 34.12706], [-118.3368, 34.12699], [-118.33635, 34.12672], [-118.33621, 34.12657], [-118.33621, 34.12649], [-118.33627, 34.12643], [-118.33631, 34.12634], [-118.33631, 34.12625], [-118.33627, 34.12602], [-118.33626, 34.12601], [-118.33626, 34.12593], [-118.33629, 34.12585], [-118.33639, 34.12573], [-118.3364, 34.12562], [-118.33637, 34.12555], [-118.33631, 34.12551], [-118.33624, 34.12548], [-118.33618, 34.12548], [-118.33827, 34.12394], [-118.3384, 34.1244], [-118.3385, 34.12457], [-118.33865, 34.12471], [-118.33881, 34.12458], [-118.33906, 34.1248], [-118.33947, 34.12448], [-118.33986, 34.12462], [-118.33996, 34.1242], [-118.34003, 34.12419], [-118.34016, 34.12414], [-118.34024, 34.1241], [-118.34042, 34.12395], [-118.34048, 34.12383], [-118.34049, 34.12365], [-118.34051, 34.12361], [-118.34075, 34.12347], [-118.34101, 34.12347], [-118.34111, 34.1235], [-118.3414, 34.12367], [-118.34176, 34.12397], [-118.3418, 34.12402], [-118.34179, 34.12407], [-118.34174, 34.12411], [-118.34171, 34.12415], [-118.34174, 34.12467], [-118.34182, 34.12466], [-118.3418, 34.12415], [-118.34183, 34.12414], [-118.34186, 34.12415], [-118.34191, 34.12423], [-118.34197, 34.12428], [-118.34211, 34.12433], [-118.34228, 34.12432], [-118.34242, 34.12425], [-118.34284, 34.1246]]], [[[-118.33549, 34.13381], [-118.33545, 34.13405], [-118.3354, 34.13414], [-118.3354, 34.13422], [-118.33457, 34.13422], [-118.33484, 34.13365], [-118.3349, 34.13359], [-118.33497, 34.13356], [-118.33531, 34.13358], [-118.33549, 34.13381]]]]} | No Public Access 3 | 12455 | 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 | 166.66 | 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 | |
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 | |
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 | |
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 | |
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 | |
6952 | 6952 | 6951 | {"type": "MultiPolygon", "coordinates": [[[[-118.36586, 33.74172], [-118.36573, 33.74211], [-118.36423, 33.74199], [-118.36421, 33.74194], [-118.36354, 33.74194], [-118.36342, 33.7416], [-118.36408, 33.74169], [-118.36424, 33.74176], [-118.36433, 33.74168], [-118.36443, 33.74165], [-118.36534, 33.74164], [-118.36536, 33.74158], [-118.36536, 33.74124], [-118.36571, 33.74125], [-118.36574, 33.74162], [-118.36572, 33.74169], [-118.36586, 33.74172]]], [[[-118.36682, 33.74147], [-118.36644, 33.74187], [-118.36637, 33.74183], [-118.36622, 33.7418], [-118.36635, 33.74143], [-118.3663, 33.7412], [-118.36673, 33.74113], [-118.36682, 33.74147]]]]} | No Public Access 3 | 5857 | Cherry Hill Lots | 29428 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 3.173 | Cherry Hill Lots | 0 | Local Other or Unknown 14 | 4 | |
6995 | 6995 | 6994 | {"type": "Polygon", "coordinates": [[[-118.36582, 33.77009], [-118.36565, 33.7707], [-118.36519, 33.7703], [-118.36438, 33.76974], [-118.36407, 33.76975], [-118.36455, 33.7693], [-118.36507, 33.76969], [-118.36541, 33.7699], [-118.36582, 33.77009]]]} | No Public Access 3 | 5928 | McKay Property Open Space - RPV | 29430 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 2.037 | McKay Property OS - RPV | 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 | |
4796 | 4796 | 4795 | {"type": "Polygon", "coordinates": [[[-121.38313, 38.64166], [-121.38312, 38.64229], [-121.38237, 38.64219], [-121.38248, 38.64206], [-121.38216, 38.64167], [-121.38223, 38.64159], [-121.38189, 38.64137], [-121.38288, 38.64043], [-121.38306, 38.64097], [-121.38306, 38.64164], [-121.38313, 38.64166]]]} | No Public Access 3 | 48339 | Unnamed Site - Sacramento, City of | 32902 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.149 | 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 |
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]);