units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
96 rows where ACCESS_TYP = 3 and DES_TP = 14 sorted by AGNCY_LEV
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles County Flood Control District 10
- Los Angeles, City of 7
- Rocklin, City of 6
- Napa, City of 5
- Mountains Recreation and Conservation Authority 4
- Escondido, City of 4
- San Diego, City of 3
- Santa Barbara Flood Control and Water Conserv. District 3
- San Diego, County of 3
- Natomas Basin Conservancy 3
- Los Angeles - Department of Water and Power, City of 2
- Rancho Palos Verdes, City of 2
- Santa Barbara, County of 1
- Watsonville, City of 1
- Los Angeles, County of 1
- Monterey, County of 1
- Napa County Regional Park and Open Space District 1
- Chula Vista, City of 1
- Davis, City of 1
- San Marcos, City of 1
- Paramount, City of 1
- Torrance, City of 1
- Diamond Bar, City of 1
- Sonoma County Agricultural Preservation and Open Space District 1
- American Canyon, City of 1
- Santa Clara Valley Open Space Authority 1
- Soledad, City of 1
- Napa, County of 1
- Sacramento, City of 1
- Riverside County Habitat Conservation Agency 1
- …
MNG_AG_TYP 6
DES_TP 1
- Local Other or Unknown · 76 ✖
ACCESS_TYP 1
- No Public Access · 76 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4661 | 4661 | 4660 | {"type": "Polygon", "coordinates": [[[-117.78588, 34.00726], [-117.78565, 34.00739], [-117.78506, 34.00701], [-117.78504, 34.00526], [-117.78514, 34.00526], [-117.78514, 34.0053], [-117.78517, 34.00534], [-117.78508, 34.00536], [-117.78509, 34.00642], [-117.78513, 34.00642], [-117.7853, 34.00662], [-117.78543, 34.00667], [-117.78578, 34.00669], [-117.78585, 34.00678], [-117.78583, 34.00699], [-117.78588, 34.00726]]]} | No Public Access 3 | 36593 | Unnamed site - Diamond Bar, City of | 31868 | 1085 | Diamond Bar, City of 315 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | Los Angeles 6 | 1.381 | 0 | Local Other or Unknown 14 | 4 | ||
4667 | 4667 | 4666 | {"type": "Polygon", "coordinates": [[[-122.26819, 38.3106], [-122.26761, 38.3104], [-122.26755, 38.31017], [-122.26748, 38.31002], [-122.26773, 38.30992], [-122.26819, 38.3106]]]} | No Public Access 3 | 36614 | 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.487 | 0 | Local Other or Unknown 14 | 4 | ||
4669 | 4669 | 4668 | {"type": "Polygon", "coordinates": [[[-122.34815, 38.318], [-122.34756, 38.31831], [-122.34706, 38.31768], [-122.34742, 38.31748], [-122.34791, 38.31776], [-122.34815, 38.318]]]} | No Public Access 3 | 36618 | 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 | 1.089 | 0 | Local Other or Unknown 14 | 4 | ||
4672 | 4672 | 4671 | {"type": "Polygon", "coordinates": [[[-122.34393, 38.31701], [-122.34317, 38.31651], [-122.34302, 38.31644], [-122.34282, 38.31622], [-122.343, 38.31604], [-122.34304, 38.31589], [-122.34292, 38.31573], [-122.34268, 38.31564], [-122.34243, 38.31559], [-122.34204, 38.31569], [-122.34134, 38.31566], [-122.34134, 38.31545], [-122.3427, 38.31551], [-122.34283, 38.31553], [-122.34294, 38.31558], [-122.34305, 38.31567], [-122.34311, 38.31575], [-122.34319, 38.31614], [-122.34327, 38.31631], [-122.34337, 38.31643], [-122.34367, 38.31671], [-122.34393, 38.31701]]]} | No Public Access 3 | 36636 | 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 | 1.35 | 0 | Local Other or Unknown 14 | 4 | ||
4749 | 4749 | 4748 | {"type": "Polygon", "coordinates": [[[-118.25828, 33.88611], [-118.25795, 33.88612], [-118.25789, 33.88584], [-118.25805, 33.88581], [-118.25821, 33.88581], [-118.25828, 33.88611]]]} | No Public Access 3 | 46441 | Unnamed site - Carson, City of | 29713 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 0.248 | 0 | Local Other or Unknown 14 | 4 | ||
4780 | 4780 | 4779 | {"type": "Polygon", "coordinates": [[[-118.47366, 34.29783], [-118.47355, 34.29793], [-118.47333, 34.2977], [-118.47324, 34.29763], [-118.47288, 34.29749], [-118.47272, 34.29746], [-118.47223, 34.29752], [-118.47187, 34.29753], [-118.47171, 34.2975], [-118.47156, 34.29743], [-118.47049, 34.29842], [-118.47038, 34.29838], [-118.47028, 34.29842], [-118.47025, 34.29846], [-118.47024, 34.29851], [-118.47025, 34.29856], [-118.47029, 34.2986], [-118.46993, 34.29891], [-118.469, 34.29819], [-118.46832, 34.29879], [-118.46779, 34.29838], [-118.46751, 34.29861], [-118.46695, 34.29818], [-118.4664, 34.29866], [-118.46584, 34.29823], [-118.4659, 34.29817], [-118.4659, 34.29816], [-118.46567, 34.29798], [-118.4656, 34.29804], [-118.46529, 34.2978], [-118.46558, 34.29754], [-118.46494, 34.29704], [-118.46518, 34.29675], [-118.466, 34.29475], [-118.46893, 34.29378], [-118.46908, 34.29382], [-118.46937, 34.29407], [-118.47092, 34.29532], [-118.47113, 34.29569], [-118.47219, 34.29665], [-118.47274, 34.2972], [-118.47291, 34.29709], [-118.47366, 34.29783]]]} | No Public Access 3 | 47096 | Unnamed site - Los Angeles - Department of Water and Power, City of | 30755 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 61.962 | 0 | Local Other or Unknown 14 | 4 | ||
4785 | 4785 | 4784 | {"type": "Polygon", "coordinates": [[[-117.23137, 32.88833], [-117.22878, 32.89057], [-117.22879, 32.89385], [-117.22675, 32.89645], [-117.22675, 32.89619], [-117.22726, 32.89551], [-117.22708, 32.8954], [-117.22721, 32.89514], [-117.22753, 32.89435], [-117.22772, 32.89381], [-117.22795, 32.89294], [-117.22797, 32.89271], [-117.22797, 32.89157], [-117.22795, 32.89107], [-117.22798, 32.89083], [-117.22816, 32.89009], [-117.22833, 32.89009], [-117.22872, 32.88902], [-117.22917, 32.88808], [-117.22989, 32.8883], [-117.23011, 32.88786], [-117.23073, 32.88808], [-117.23137, 32.88833]]]} | No Public Access 3 | 47655 | Unnamed site - San Diego, City of | 31719 | 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 | 20.801 | 0 | Local Other or Unknown 14 | 4 | ||
4786 | 4786 | 4785 | {"type": "MultiPolygon", "coordinates": [[[[-116.87263, 32.64332], [-116.87061, 32.64522], [-116.87029, 32.64505], [-116.87093, 32.64366], [-116.87252, 32.64297], [-116.87263, 32.64332]]], [[[-116.87285, 32.64414], [-116.87285, 32.64414], [-116.87206, 32.64428], [-116.87271, 32.64366], [-116.87285, 32.64414]]]]} | No Public Access 3 | 47661 | Unnamed site - San Diego, City of | 31719 | 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 | 5.302 | 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 | ||
5007 | 5007 | 5006 | {"type": "Polygon", "coordinates": [[[-117.08308, 33.12563], [-117.083, 33.12566], [-117.08273, 33.12596], [-117.08261, 33.1257], [-117.08295, 33.12535], [-117.08308, 33.12563]]]} | No Public Access 3 | 689 | Escondido Creek | 18706 | 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.332 | Escondido Creek | 0 | Local Other or Unknown 14 | 4 | |
5863 | 5863 | 5862 | {"type": "MultiPolygon", "coordinates": [[[[-117.02636, 33.16692], [-117.02637, 33.16744], [-117.0263, 33.16767], [-117.02627, 33.16768], [-117.02381, 33.1705], [-117.0228, 33.17041], [-117.02244, 33.17066], [-117.02191, 33.17075], [-117.02157, 33.17076], [-117.0211, 33.17036], [-117.02039, 33.17028], [-117.0193, 33.16949], [-117.01888, 33.1689], [-117.01829, 33.16863], [-117.0182, 33.16854], [-117.01809, 33.16833], [-117.01805, 33.16832], [-117.01805, 33.16822], [-117.01821, 33.16823], [-117.01836, 33.16851], [-117.01841, 33.16856], [-117.019, 33.16883], [-117.01907, 33.16893], [-117.01899, 33.16898], [-117.01935, 33.16949], [-117.02041, 33.17025], [-117.02111, 33.17033], [-117.02157, 33.17072], [-117.02186, 33.17071], [-117.02188, 33.17067], [-117.02237, 33.17059], [-117.02276, 33.17032], [-117.02381, 33.17041], [-117.02579, 33.16812], [-117.02611, 33.1677], [-117.02619, 33.16744], [-117.02618, 33.16691], [-117.02636, 33.16692]]], [[[-117.03026, 33.16085], [-117.02978, 33.16201], [-117.02983, 33.16203], [-117.02952, 33.16302], [-117.02949, 33.16333], [-117.02954, 33.16362], [-117.02927, 33.16475], [-117.02785, 33.16432], [-117.02829, 33.16321], [-117.02812, 33.16305], [-117.02818, 33.16299], [-117.02891, 33.16214], [-117.029, 33.16188], [-117.02906, 33.16187], [-117.02931, 33.16168], [-117.02936, 33.16148], [-117.02948, 33.16128], [-117.02963, 33.16113], [-117.02986, 33.16099], [-117.03026, 33.16085]]], [[[-117.047, 33.14542], [-117.0464, 33.14577], [-117.04613, 33.14599], [-117.04568, 33.14639], [-117.04536, 33.1466], [-117.04502, 33.14677], [-117.04494, 33.1468], [-117.04431, 33.14709], [-117.04386, 33.14733], [-117.04316, 33.14765], [-117.04287, 33.14774], [-117.04248, 33.14783], [-117.04224, 33.14786], [-117.04113, 33.1479], [-117.04094, 33.14799], [-117.04089, 33.14791], [-117.04015, 33.14791], [-117.03971, 33.14795], [-117.03949, 33.14801], [-117.03909, 33.14814], [-117.0387, 33.1484], [-117.03852, 33.14855], [-117.03758, 33.14944], [-117.03759, 33.14947], [-117.03744, 33.14963], [-117.03729, 33.14987], [-117.03692, 33.14982], [-117.03731, 33.14903], [-117.03754, 33.14905], [-117.03827, 33.14831], [-117.03842, 33.14818], [-117.03841, 33.14815], [-117.03858, 33.14803], [-117.03896, 33.14783], [-117.03932, 33.14768], [-117.03981, 33.14758], [-117.04015, 33.14756], [-117.04116, 33.14756], [-117.04121, 33.14762], [-117.04189, 33.14763], [-117.04224, 33.1476], [-117.04252, 33.14756], [-117.04277, 33.14749], [-117.043, 33.14741], [-117.04507, 33.14646], [-117.04528, 33.14635], [-117.04539, 33.14627], [-117.04584, 33.14587], [-117.04623, 33.14554], [-117.04685, 33.14517], [-117.047, 33.14542]]], [[[-117.0675, 33.13214], [-117.06677, 33.13264], [-117.06648, 33.13289], [-117.06619, 33.13307], [-117.06584, 33.13324], [-117.06561, 33.13332], [-117.06516, 33.13344], [-117.06488, 33.13347], [-117.06459, 33.13312], [-117.06483, 33.1331], [-117.06485, 33.13313], [-117.06512, 33.13308], [-117.06552, 33.13296], [-117.06601, 33.13276], [-117.06651, 33.13245], [-117.06738, 33.13176], [-117.0675, 33.13214]]], [[[-117.06901, 33.13096], [-117.06874, 33.13109], [-117.06832, 33.13136], [-117.06801, 33.13163], [-117.06802, 33.13165], [-117.06769, 33.13191], [-117.06757, 33.13154], [-117.0683, 33.13093], [-117.0688, 33.13065], [-117.06901, 33.13096]]], [[[-117.0704, 33.13036], [-117.06983, 33.13063], [-117.0698, 33.1306], [-117.06925, 33.13085], [-117.06904, 33.13054], [-117.07019, 33.13002], [-117.0704, 33.13036]]], [[[-117.07179, 33.12972], [-117.07063, 33.13026], [-117.07043, 33.12995], [-117.07073, 33.12981], [-117.07071, 33.12977], [-117.07158, 33.12938], [-117.07179, 33.12972]]], [[[-117.07317, 33.12909], [-117.07202, 33.12961], [-117.07181, 33.12927], [-117.07295, 33.12874], [-117.07317, 33.12909]]], [[[-117.07456, 33.12844], [-117.07339, 33.12896], [-117.07334, 33.1289], [-117.07432, 33.12843], [-117.07448, 33.12836], [-117.07456, 33.12844]]], [[[-117.07591, 33.12782], [-117.07479, 33.12835], [-117.07472, 33.12824], [-117.07586, 33.12772], [-117.07591, 33.12782]]], [[[-117.07746, 33.12743], [-117.07699, 33.12747], [-117.07676, 33.12751], [-117.07641, 33.12762], [-117.07616, 33.12773], [-117.07608, 33.12761], [-117.07724, 33.12709], [-117.07746, 33.12743]]], [[[-117.08144, 33.1271], [-117.08115, 33.12721], [-117.08078, 33.1273], [-117.08026, 33.12738], [-117.07774, 33.12741], [-117.07754, 33.12707], [-117.07901, 33.12707], [-117.08015, 33.12704], [-117.08067, 33.12695], [-117.08102, 33.12686], [-117.08124, 33.12678], [-117.08144, 33.1271]]], [[[-117.08226, 33.12655], [-117.08202, 33.12674], [-117.08199, 33.12672], [-117.08166, 33.12695], [-117.08146, 33.12667], [-117.08176, 33.12645], [-117.08176, 33.12644], [-117.08207, 33.12614], [-117.08226, 33.12655]]], [[[-117.08271, 33.12607], [-117.08237, 33.12643], [-117.0822, 33.12601], [-117.08225, 33.12599], [-117.08254, 33.12569], [-117.08271, 33.12607]]], [[[-117.08966, 33.12061], [-117.08939, 33.12075], [-117.08924, 33.12087], [-117.08838, 33.12158], [-117.08823, 33.12129], [-117.08922, 33.12051], [-117.08949, 33.12035], [-117.08966, 33.12061]]], [[[-117.09276, 33.11986], [-117.09207, 33.11988], [-117.09152, 33.11994], [-117.09127, 33.11998], [-117.09056, 33.12017], [-117.09021, 33.1203], [-117.08986, 33.12046], [-117.0897, 33.12024], [-117.08998, 33.12008], [-117.09025, 33.11996], [-117.09048, 33.11986], [-117.09078, 33.11978], [-117.09107, 33.11977], [-117.09148, 33.11968], [-117.09186, 33.11961], [-117.09222, 33.11958], [-117.09265, 33.11958], [-117.09276, 33.11986]]], [[[-117.09679, 33.11874], [-117.09593, 33.11947], [-117.09577, 33.11965], [-117.09533, 33.11949], [-117.09538, 33.1194], [-117.09539, 33.11936], [-117.09511, 33.11927], [-117.09567, 33.119], [-117.09571, 33.11901], [-117.09634, 33.11858], [-117.09679, 33.11874]]], [[[-117.09969, 33.11766], [-117.09946, 33.1182], [-117.0989, 33.11818], [-117.09888, 33.11815], [-117.09867, 33.11815], [-117.09837, 33.11816], [-117.09803, 33.11822], [-117.09776, 33.11828], [-117.0975, 33.11838], [-117.09728, 33.11849], [-117.09706, 33.11865], [-117.09653, 33.11844], [-117.09691, 33.11816], [-117.09712, 33.11804], [-117.09749, 33.11788], [-117.09798, 33.11774], [-117.09798, 33.11772], [-117.09829, 33.11767], [-117.09893, 33.11765], [-117.09894, 33.11768], [-117.09931, 33.11768], [-117.09969, 33.11766]]], [[[-117.1043, 33.11385], [-117.10384, 33.11409], [-117.10355, 33.11429], [-117.10326, 33.11453], [-117.10283, 33.11502], [-117.10252, 33.11554], [-117.10242, 33.11581], [-117.10218, 33.11658], [-117.10203, 33.11686], [-117.10177, 33.1172], [-117.10174, 33.11727], [-117.10161, 33.11742], [-117.10146, 33.11755], [-117.10118, 33.11774], [-117.10097, 33.11726], [-117.10097, 33.11723], [-117.10128, 33.11699], [-117.1015, 33.11676], [-117.10182, 33.11591], [-117.10195, 33.1155], [-117.10213, 33.11513], [-117.10232, 33.11481], [-117.10255, 33.11452], [-117.10257, 33.11437], [-117.10284, 33.11418], [-117.10307, 33.11393], [-117.10311, 33.11394], [-117.10358, 33.11365], [-117.1043, 33.11385]]], [[[-117.11185, 33.10955], [-117.11069, 33.11042], [-117.11039, 33.11068], [-117.11003, 33.11107], [-117.10985, 33.11132], [-117.10976, 33.11149], [-117.10961, 33.1117], [-117.10939, 33.11195], [-117.10889, 33.11244], [-117.10817, 33.11317], [-117.10811, 33.11314], [-117.10768, 33.11353], [-117.10742, 33.11388], [-117.10735, 33.11405], [-117.10729, 33.11442], [-117.10718, 33.11439], [-117.10723, 33.11402], [-117.10738, 33.11364], [-117.10735, 33.11362], [-117.1076, 33.11327], [-117.10792, 33.11298], [-117.10786, 33.11293], [-117.10723, 33.11311], [-117.10723, 33.11314], [-117.10474, 33.11367], [-117.10402, 33.11348], [-117.10445, 33.11328], [-117.10496, 33.11313], [-117.10644, 33.11287], [-117.10742, 33.11262], [-117.10777, 33.1125], [-117.10831, 33.11222], [-117.10878, 33.11189], [-117.1092, 33.11145], [-117.10968, 33.11079], [-117.10997, 33.11045], [-117.11033, 33.11011], [-117.11091, 33.10963], [-117.11124, 33.1093], [-117.11185, 33.10955]]]]} | No Public Access 3 | 192 | Escondido Creek | 18706 | 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 | 62.151 | Escondido Creek | 0 | Local Other or Unknown 14 | 4 | |
6015 | 6015 | 6014 | {"type": "Polygon", "coordinates": [[[-117.09363, 33.12972], [-117.0934, 33.12982], [-117.09332, 33.12983], [-117.09264, 33.12819], [-117.09301, 33.12807], [-117.09327, 33.1289], [-117.09363, 33.12972]]]} | No Public Access 3 | 675 | 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 | 1.523 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
6250 | 6250 | 6249 | {"type": "Polygon", "coordinates": [[[-117.1192, 33.10579], [-117.11901, 33.10627], [-117.11885, 33.10655], [-117.11637, 33.10688], [-117.11677, 33.10621], [-117.11701, 33.10622], [-117.11704, 33.1061], [-117.11691, 33.10609], [-117.11713, 33.10571], [-117.11708, 33.10568], [-117.1178, 33.10446], [-117.1192, 33.10579]]]} | No Public Access 3 | 1410 | Escondido Creek | 18706 | 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 | 8.905 | Escondido Creek | 0 | Local Other or Unknown 14 | 4 | |
6428 | 6428 | 6427 | {"type": "Polygon", "coordinates": [[[-121.33786, 36.47151], [-121.33187, 36.47323], [-121.3318, 36.46281], [-121.3377, 36.46284], [-121.33786, 36.47151]]]} | No Public Access 3 | 1938 | Windmill Property | 27628 | 1336 | Soledad, City of 485 | City 2 | City Agency 2 | http://www.cityofsoledad.com/ | City 2 | 1336 | Soledad, City of 476 | City 2 | City Agency 2 | Monterey 14 | 139.773 | Windmill Property | 0 | Local Other or Unknown 14 | 4 | |
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 | |
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 | |
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 |
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]);