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_WEB descending
This data as json, copyable, CSV (advanced)
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 | ||
13218 | 13218 | 13217 | {"type": "Polygon", "coordinates": [[[-119.18391, 34.16307], [-119.18388, 34.16515], [-119.18338, 34.16516], [-119.18325, 34.16511], [-119.18315, 34.16513], [-119.18312, 34.16516], [-119.18312, 34.16559], [-119.18135, 34.16558], [-119.18132, 34.16526], [-119.18123, 34.16495], [-119.18107, 34.16461], [-119.1808, 34.1642], [-119.18072, 34.16402], [-119.18067, 34.16387], [-119.18063, 34.16355], [-119.18063, 34.16304], [-119.18389, 34.16305], [-119.18391, 34.16307]]]} | Open Access 1 | 35262 | Oxnard holding 1 | 23282 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 18.2 | Oxnard holding 1 | 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 | ||
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 | |
13900 | 13900 | 13899 | {"type": "Polygon", "coordinates": [[[-117.82228, 33.75125], [-117.82228, 33.75167], [-117.82173, 33.75148], [-117.82135, 33.75141], [-117.82115, 33.75139], [-117.82031, 33.75139], [-117.82031, 33.75125], [-117.82033, 33.75123], [-117.82032, 33.75122], [-117.82009, 33.75122], [-117.82011, 33.75126], [-117.82011, 33.75139], [-117.81842, 33.7514], [-117.81842, 33.75123], [-117.81874, 33.75122], [-117.81875, 33.75106], [-117.81913, 33.75115], [-117.81948, 33.7512], [-117.82221, 33.7512], [-117.82228, 33.75125]]]} | Open Access 1 | 36510 | Tustin holding 1 | 26604 | 1360 | Tustin, City of 278 | City 2 | City Agency 2 | http://www.tustinca.org/departments/parksrec/index.html | City 2 | 1360 | Tustin, City of 274 | City 2 | City Agency 2 | Orange 3 | 2.198 | Tustin 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 | |
3580 | 3580 | 3579 | {"type": "Polygon", "coordinates": [[[-118.36897, 33.80456], [-118.36893, 33.80458], [-118.36878, 33.80431], [-118.36871, 33.80428], [-118.36847, 33.80438], [-118.36821, 33.80455], [-118.36778, 33.80419], [-118.3688, 33.8042], [-118.36897, 33.80456]]]} | Open Access 1 | 36686 | Torrance holding 28 | 26435 | 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.536 | Torrance holding 28 | 0 | Local Other or Unknown 14 | 4 | |
3582 | 3582 | 3581 | {"type": "Polygon", "coordinates": [[[-118.32429, 33.80965], [-118.32389, 33.80965], [-118.32389, 33.80924], [-118.32429, 33.80924], [-118.32429, 33.80965]]]} | No Public Access 3 | 36688 | Empty Lot 237th and Vine | 29082 | 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.419 | Empty Lot 237th and Vine | 0 | Local Other or Unknown 14 | 4 | |
13426 | 13426 | 13425 | {"type": "Polygon", "coordinates": [[[-118.31626, 33.83389], [-118.31603, 33.83406], [-118.31569, 33.83375], [-118.31591, 33.83358], [-118.31626, 33.83389]]]} | Open Access 1 | 35568 | Torrance holding 13 | 26419 | 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.334 | Torrance holding 13 | 0 | Local Other or Unknown 14 | 4 | |
13503 | 13503 | 13502 | {"type": "Polygon", "coordinates": [[[-118.37443, 33.81802], [-118.37442, 33.81909], [-118.37381, 33.81909], [-118.37372, 33.81907], [-118.37354, 33.819], [-118.37335, 33.81885], [-118.37326, 33.81869], [-118.37325, 33.81846], [-118.3733, 33.81831], [-118.37343, 33.81815], [-118.37363, 33.81804], [-118.37383, 33.81799], [-118.37443, 33.81799], [-118.37443, 33.81802]]]} | Open Access 1 | 35795 | Torrance holding 23 | 26430 | 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 | 2.901 | Torrance holding 23 | 0 | Local Other or Unknown 14 | 4 | |
13518 | 13518 | 13517 | {"type": "Polygon", "coordinates": [[[-118.37289, 33.82747], [-118.37259, 33.82737], [-118.37257, 33.82732], [-118.37286, 33.82735], [-118.37289, 33.82747]]]} | Open Access 1 | 35830 | Torrance holding 6 | 26464 | 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.06 | Torrance holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13548 | 13548 | 13547 | {"type": "Polygon", "coordinates": [[[-118.3621, 33.80422], [-118.36198, 33.80426], [-118.36183, 33.80426], [-118.36171, 33.80424], [-118.36154, 33.80416], [-118.36131, 33.80396], [-118.3611, 33.80383], [-118.36028, 33.80313], [-118.36024, 33.80307], [-118.36032, 33.80301], [-118.36169, 33.80417], [-118.36209, 33.80417], [-118.3621, 33.80422]]]} | Open Access 1 | 35864 | Torrance holding 16 | 26422 | 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.59 | Torrance holding 16 | 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 | |
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 | |
13973 | 13973 | 13972 | {"type": "Polygon", "coordinates": [[[-121.38181, 38.05445], [-121.38174, 38.05451], [-121.38084, 38.05451], [-121.38077, 38.05445], [-121.38077, 38.05333], [-121.38083, 38.05327], [-121.38174, 38.05327], [-121.38181, 38.05333], [-121.38181, 38.05445]]]} | Open Access 1 | 36640 | Stockton holding 1 | 25858 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 3.08 | Stockton holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13974 | 13974 | 13973 | {"type": "Polygon", "coordinates": [[[-121.39101, 38.04978], [-121.39099, 38.0498], [-121.3903, 38.04991], [-121.39027, 38.04989], [-121.39015, 38.04943], [-121.39083, 38.04932], [-121.39101, 38.04978]]]} | Open Access 1 | 36641 | Stockton holding 2 | 25859 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 0.86 | Stockton holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13975 | 13975 | 13974 | {"type": "Polygon", "coordinates": [[[-121.3818, 38.05196], [-121.38173, 38.05202], [-121.38083, 38.05202], [-121.38076, 38.05197], [-121.38075, 38.05126], [-121.38082, 38.0512], [-121.38173, 38.0512], [-121.3818, 38.05125], [-121.3818, 38.05196]]]} | Open Access 1 | 36642 | Stockton holding 3 | 25860 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.046 | Stockton holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13976 | 13976 | 13975 | {"type": "Polygon", "coordinates": [[[-121.38323, 38.04933], [-121.38318, 38.0494], [-121.3823, 38.04957], [-121.38221, 38.04953], [-121.382, 38.04884], [-121.38205, 38.04877], [-121.38293, 38.0486], [-121.38301, 38.04864], [-121.38323, 38.04933]]]} | Open Access 1 | 36643 | Stockton holding 5 | 25862 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.047 | Stockton holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13977 | 13977 | 13976 | {"type": "Polygon", "coordinates": [[[-121.38992, 38.04625], [-121.3899, 38.04627], [-121.38944, 38.04634], [-121.38941, 38.04632], [-121.38933, 38.04599], [-121.38933, 38.04586], [-121.38935, 38.04585], [-121.38971, 38.04588], [-121.38992, 38.04625]]]} | Open Access 1 | 36644 | Stockton holding 4 | 25861 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 0.498 | Stockton holding 4 | 0 | Local Other or Unknown 14 | 4 | |
5194 | 5194 | 5193 | {"type": "Polygon", "coordinates": [[[-122.40018, 37.66434], [-122.40011, 37.66463], [-122.39923, 37.66446], [-122.39958, 37.66423], [-122.40018, 37.66434]]]} | Open Access 1 | 15580 | Gardiner Lot | 19209 | 1341 | South San Francisco, City of 60 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | San Mateo 15 | 0.528 | Gardiner Lot | 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]);