units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
661 rows where AGNCY_LEV = 2 and DES_TP = 14 sorted by AGNCY_WEB descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, YR_EST
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
- Marina, City of 4
- Morgan Hill, City of 4
- …
ACCESS_TYP 4
- Open Access 581
- No Public Access 58
- Unknown Access 16
- Restricted Access 6
MNG_AG_TYP 1
- City Agency 661
DES_TP 1
- Local Other or Unknown · 661 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |
13762 | 13762 | 13761 | {"type": "Polygon", "coordinates": [[[-122.44326, 38.2855], [-122.44321, 38.28582], [-122.4422, 38.28573], [-122.44253, 38.28549], [-122.44264, 38.28551], [-122.44274, 38.2855], [-122.44281, 38.28545], [-122.44326, 38.2855]]]} | Open Access 1 | 36282 | Sonoma holding 2 | 25613 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 0.635 | Sonoma holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13805 | 13805 | 13804 | {"type": "Polygon", "coordinates": [[[-122.44718, 38.28907], [-122.447, 38.29026], [-122.44655, 38.29023], [-122.44662, 38.28979], [-122.44643, 38.28956], [-122.44649, 38.28952], [-122.44655, 38.28942], [-122.4466, 38.2891], [-122.44671, 38.28903], [-122.44718, 38.28907]]]} | Open Access 1 | 36376 | Sonoma holding 1 | 25612 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 1.524 | Sonoma holding 1 | 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]);