units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
663 rows where DES_TP = 14 and MNG_AG_TYP = 2 sorted by AGNCY_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV
MNG_AGENCY >30
- Ventura, City of 106
- Roseville, City of 46
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Napa, City of 21
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Santa Cruz, City of 12
- Oroville, City of 12
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- Watsonville, City of 7
- Scotts Valley, City of 7
- Torrance, City of 7
- San Luis Obispo, City of 6
- Los Angeles - Department of Water and Power, City of 6
- Salinas, City of 5
- Anaheim, City of 5
- Stockton, City of 5
- San Marcos, City of 4
- Marina, City of 4
- …
ACCESS_TYP 4
- Open Access 581
- No Public Access 60
- Unknown Access 16
- Restricted Access 6
MNG_AG_TYP 1
- City Agency · 663 ✖
DES_TP 1
- Local Other or Unknown · 663 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4756 | 4756 | 4755 | {"type": "Polygon", "coordinates": [[[-118.1743, 33.90349], [-118.17321, 33.9035], [-118.17318, 33.89977], [-118.17427, 33.89978], [-118.1743, 33.90349]]]} | No Public Access 3 | 46526 | Unnamed site - Paramount, City of | 29815 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | Los Angeles 6 | 10.254 | 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 | |
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 | ||
4788 | 4788 | 4787 | {"type": "Polygon", "coordinates": [[[-123.69419, 38.90966], [-123.69413, 38.91095], [-123.69408, 38.91142], [-123.69342, 38.91138], [-123.69342, 38.91022], [-123.69387, 38.91002], [-123.69374, 38.90991], [-123.69342, 38.90992], [-123.69342, 38.9096], [-123.69319, 38.9096], [-123.69319, 38.90939], [-123.69351, 38.90939], [-123.69352, 38.90931], [-123.69407, 38.90932], [-123.69406, 38.90939], [-123.69388, 38.90964], [-123.69419, 38.90966]]]} | Open Access 1 | 48100 | Unnamed site - Point Arena, City of | 32605 | 1697 | Point Arena, City of 781 | City 2 | City Agency 2 | http://www.cityofpointarena.com/ | City 2 | 1697 | Point Arena, City of 761 | City 2 | City Agency 2 | Mendocino 24 | 3.377 | 0 | Local Other or Unknown 14 | 4 | ||
4803 | 4803 | 4802 | {"type": "Polygon", "coordinates": [[[-120.3318, 36.13129], [-120.33179, 36.13193], [-120.33029, 36.13194], [-120.33022, 36.1319], [-120.33024, 36.13147], [-120.33026, 36.13134], [-120.33033, 36.13129], [-120.3318, 36.13129]]]} | Open Access 1 | 48596 | Unknown park - Coalinga, City of | 33305 | 1683 | Coalinga, City of 786 | City 2 | City Agency 2 | http://www.coalinga.com/ | City 2 | 1683 | Coalinga, City of 765 | City 2 | City Agency 2 | Fresno 9 | 2.455 | 0 | Local Other or Unknown 14 | 4 | ||
12706 | 12706 | 12705 | {"type": "MultiPolygon", "coordinates": [[[[-121.96763, 38.52098], [-121.96701, 38.5212], [-121.96672, 38.5215], [-121.96547, 38.5215], [-121.96632, 38.52116], [-121.96658, 38.52099], [-121.96684, 38.52075], [-121.9673, 38.52038], [-121.96763, 38.52098]]], [[[-121.9695, 38.51971], [-121.96831, 38.52051], [-121.96826, 38.52042], [-121.96813, 38.52047], [-121.96786, 38.52001], [-121.96813, 38.51983], [-121.9683, 38.51977], [-121.96869, 38.51958], [-121.96895, 38.51938], [-121.96913, 38.5192], [-121.9695, 38.51971]]]]} | Open Access 1 | 29710 | Putah Creek | 24032 | 1675 | Winters, City of 581 | City 2 | City Agency 2 | http://www.cityofwinters.org/recreation/recreation_gen.htm | City 2 | 1675 | Winters, City of 573 | City 2 | City Agency 2 | Yolo 33 | 4.189 | Putah Creek | 0 | Local Other or Unknown 14 | 4 | |
13969 | 13969 | 13968 | {"type": "Polygon", "coordinates": [[[-121.97688, 38.51984], [-121.97524, 38.52043], [-121.97486, 38.51977], [-121.97649, 38.51918], [-121.97669, 38.51951], [-121.97633, 38.51964], [-121.97632, 38.51966], [-121.97635, 38.51968], [-121.97671, 38.51955], [-121.97688, 38.51984]]]} | Open Access 1 | 36635 | Winters holding 1 | 27655 | 1675 | Winters, City of 581 | City 2 | City Agency 2 | http://www.cityofwinters.org/recreation/recreation_gen.htm | City 2 | 1675 | Winters, City of 573 | City 2 | City Agency 2 | Yolo 33 | 3.09 | Winters holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13965 | 13965 | 13964 | {"type": "Polygon", "coordinates": [[[-121.77936, 38.67377], [-121.77932, 38.67379], [-121.77838, 38.67379], [-121.77836, 38.67377], [-121.77838, 38.67215], [-121.77934, 38.67215], [-121.77937, 38.67216], [-121.77936, 38.67377]]]} | Open Access 1 | 36630 | Woodland holding 1 | 27720 | 1665 | Woodland, City of 547 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | Yolo 33 | 3.889 | Woodland holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13968 | 13968 | 13967 | {"type": "Polygon", "coordinates": [[[-124.15321, 41.05423], [-124.15271, 41.05488], [-124.15229, 41.05661], [-124.15206, 41.05669], [-124.15203, 41.05709], [-124.14985, 41.05669], [-124.14873, 41.05627], [-124.14866, 41.05582], [-124.14772, 41.05465], [-124.14731, 41.05383], [-124.14725, 41.05301], [-124.14791, 41.0522], [-124.14977, 41.0522], [-124.15099, 41.05294], [-124.15272, 41.05295], [-124.15297, 41.05333], [-124.1532, 41.05337], [-124.15321, 41.05423]], [[-124.15021, 41.05434], [-124.15022, 41.05435], [-124.15082, 41.05449], [-124.15108, 41.05383], [-124.15048, 41.05369], [-124.15021, 41.05434]]]} | Open Access 1 | 36634 | Trinidad holding 1 | 26538 | 1664 | Trinidad, City of 718 | City 2 | City Agency 2 | http://www.trinidad.ca.gov/ | City 2 | 1664 | Trinidad, City of 701 | City 2 | City Agency 2 | Humboldt 45 | 45.982 | Trinidad holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13967 | 13967 | 13966 | {"type": "Polygon", "coordinates": [[[-118.43001, 35.11787], [-118.43, 35.11814], [-118.42927, 35.11814], [-118.42927, 35.11787], [-118.42934, 35.11781], [-118.42994, 35.11782], [-118.43001, 35.11787]]]} | Open Access 1 | 36633 | Tehachapi holding 1 | 26217 | 1467 | Tehachapi, City of 310 | City 2 | City Agency 2 | http://www.tehachapicityhall.com/ | City 2 | 1467 | Tehachapi, City of 307 | City 2 | City Agency 2 | Kern 36 | 0.591 | Tehachapi holding 1 | 0 | Local Other or Unknown 14 | 4 | |
4805 | 4805 | 4804 | {"type": "Polygon", "coordinates": [[[-119.53725, 36.60759], [-119.53721, 36.60762], [-119.53704, 36.60762], [-119.53704, 36.60709], [-119.5372, 36.60709], [-119.53725, 36.60713], [-119.53725, 36.60759]]]} | Open Access 1 | 48593 | Unknown park - Parlier, City of | 33302 | 1461 | Parlier, City of 425 | City 2 | City Agency 2 | http://www.parlier.ca.us/ | City 2 | 1461 | Parlier, City of 419 | City 2 | City Agency 2 | Fresno 9 | 0.269 | 0 | Local Other or Unknown 14 | 4 | ||
15528 | 15528 | 15527 | {"type": "Polygon", "coordinates": [[[-120.63297, 36.97684], [-120.63292, 36.97688], [-120.63232, 36.97688], [-120.63228, 36.97685], [-120.63228, 36.97652], [-120.63297, 36.97652], [-120.63297, 36.97684]]]} | Open Access 1 | 48941 | Unknown park - Dos Palos, City of | 33657 | 1460 | Dos Palos, City of 194 | City 2 | City Agency 2 | City 2 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | Merced 37 | 0.607 | 0 | Local Other or Unknown 14 | 4 | |||
13913 | 13913 | 13912 | {"type": "Polygon", "coordinates": [[[-115.48723, 32.672], [-115.48723, 32.67277], [-115.48625, 32.67276], [-115.48625, 32.672], [-115.48723, 32.672]]]} | Open Access 1 | 36518 | Calexico holding 1 | 16681 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 1.937 | Calexico holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13623 | 13623 | 13622 | {"type": "Polygon", "coordinates": [[[-123.9952, 40.88232], [-123.99346, 40.88304], [-123.99352, 40.88318], [-123.99339, 40.88307], [-123.99237, 40.8823], [-123.99232, 40.88233], [-123.99196, 40.88206], [-123.99202, 40.88201], [-123.99228, 40.88221], [-123.99325, 40.88144], [-123.9952, 40.88232]]]} | Open Access 1 | 36330 | Blue Lake holding 1 | 16178 | 1443 | Blue Lake, City of 716 | City 2 | City Agency 2 | http://bluelake.ca.gov/ | City 2 | 1443 | Blue Lake, City of 699 | City 2 | City Agency 2 | Humboldt 45 | 5.606 | Blue Lake holding 1 | 0 | Local Other or Unknown 14 | 4 | |
4769 | 4769 | 4768 | {"type": "Polygon", "coordinates": [[[-124.10344, 40.4928], [-124.10326, 40.49301], [-124.10325, 40.49313], [-124.10297, 40.49314], [-124.10296, 40.49296], [-124.103, 40.49297], [-124.10313, 40.4928], [-124.10344, 40.4928]]]} | Unknown Access 4 | 46929 | Unnamed site - Rio Dell, City of | 30545 | 1435 | Rio Dell, City of 642 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | Humboldt 45 | 0.236 | 0 | Local Other or Unknown 14 | 4 | ||
4770 | 4770 | 4769 | {"type": "MultiPolygon", "coordinates": [[[[-124.10601, 40.49914], [-124.10572, 40.49916], [-124.10573, 40.49867], [-124.10555, 40.49848], [-124.10587, 40.49829], [-124.10601, 40.49914]]], [[[-124.10652, 40.49814], [-124.10615, 40.49811], [-124.10585, 40.49742], [-124.10652, 40.49814], [-124.10652, 40.49814]]]]} | Open Access 1 | 46930 | Unknown park - Rio Dell, City of | 30546 | 1435 | Rio Dell, City of 642 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | http://www.riodellcity.com/planning-pdf/Rio%20Dell%20Zoning%20Map.pdf | Humboldt 45 | 0.75 | 0 | Local Other or Unknown 14 | 4 | |
4774 | 4774 | 4773 | {"type": "Polygon", "coordinates": [[[-124.10655, 40.50715], [-124.10654, 40.50718], [-124.10649, 40.5072], [-124.10591, 40.5071], [-124.10587, 40.50708], [-124.10587, 40.50705], [-124.10588, 40.50702], [-124.10605, 40.50694], [-124.10617, 40.50686], [-124.1063, 40.50671], [-124.10635, 40.50669], [-124.1064, 40.50673], [-124.10649, 40.50701], [-124.10655, 40.50715]]]} | Open Access 1 | 46937 | Unnamed site - Rio Dell, City of | 30560 | 1435 | Rio Dell, City of 642 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | Humboldt 45 | 0.418 | 0 | Local Other or Unknown 14 | 4 | ||
13771 | 13771 | 13770 | {"type": "Polygon", "coordinates": [[[-124.26652, 40.57397], [-124.26609, 40.57438], [-124.26519, 40.5738], [-124.2651, 40.57372], [-124.26489, 40.57389], [-124.26428, 40.57333], [-124.26398, 40.5731], [-124.2646, 40.57245], [-124.26652, 40.57397]]]} | Open Access 1 | 36312 | Fortuna holding 1 | 19012 | 1434 | Fortuna, City of 1012 | City 2 | City Agency 2 | http://friendlyfortuna.com/index.aspx?nid=95 | City 2 | 1434 | Fortuna, City of 974 | City 2 | City Agency 2 | Humboldt 45 | 4.43 | Fortuna holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13795 | 13795 | 13794 | {"type": "Polygon", "coordinates": [[[-124.14761, 40.57317], [-124.14645, 40.57224], [-124.14644, 40.5716], [-124.14561, 40.57078], [-124.14527, 40.57023], [-124.14525, 40.57021], [-124.1473, 40.57025], [-124.14761, 40.57317]]]} | Open Access 1 | 36363 | Fortuna holding 2 | 19013 | 1434 | Fortuna, City of 1012 | City 2 | City Agency 2 | http://friendlyfortuna.com/index.aspx?nid=95 | City 2 | 1434 | Fortuna, City of 974 | City 2 | City Agency 2 | Humboldt 45 | 7.731 | Fortuna holding 2 | 0 | Local Other or Unknown 14 | 4 | |
4816 | 4816 | 4815 | {"type": "Polygon", "coordinates": [[[-117.01983, 33.78712], [-117.01846, 33.78712], [-117.01837, 33.78705], [-117.01838, 33.78608], [-117.01843, 33.78604], [-117.019, 33.78604], [-117.01925, 33.78607], [-117.01936, 33.78603], [-117.01943, 33.78595], [-117.01981, 33.78608], [-117.01983, 33.78712]]]} | Open Access 1 | 48837 | Unknown park - San Jacinto, City of | 33557 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | Riverside 10 | 3.986 | 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]);