units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
207 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, PARK_URL, YR_EST, GAP_STS
MNG_AGENCY >30
- Los Angeles, City of 36
- Torrance, City of 20
- San Diego, City of 19
- Napa, City of 12
- Escondido, City of 10
- Santa Rosa, City of 9
- Rocklin, City of 8
- Los Angeles - Department of Water and Power, City of 7
- Vallejo, City of 7
- Saint Helena, City of 5
- Petaluma, City of 4
- Vacaville, City of 4
- San Marcos, City of 4
- Long Beach, City of 4
- Rolling Hills, City of 3
- La Verne, City of 3
- Chico, City of 3
- Roseville, City of 3
- Poway, City of 2
- Rancho Palos Verdes, City of 2
- Palos Verdes Estates, City of 2
- Redding, City of 2
- Arcata, City of 2
- Sebastopol, City of 2
- Watsonville, City of 1
- Santee, City of 1
- Glendora, City of 1
- Oceanside, City of 1
- Chula Vista, City of 1
- Rosemead, City of 1
- …
DES_TP >30
- Local Other or Unknown 60
- Local Recreation Area 40
- Local Park 38
- Local Conservation Area 6
- Local Resource Management Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 1
- City Agency · 207 ✖
ACCESS_TYP 1
- No Public Access · 207 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4532 | 4532 | 4531 | {"type": "MultiPolygon", "coordinates": [[[[-117.21241, 32.80723], [-117.21239, 32.80731], [-117.21232, 32.80734], [-117.2111, 32.80742], [-117.21111, 32.80697], [-117.21157, 32.80696], [-117.21172, 32.80698], [-117.21219, 32.80709], [-117.21237, 32.80716], [-117.21241, 32.80723]]], [[[-117.21219, 32.80689], [-117.21219, 32.80695], [-117.21195, 32.80689], [-117.21219, 32.80689], [-117.21219, 32.80689]]]]} | No Public Access 3 | 18410 | 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 | 1.217 | 0 | Local Other or Unknown 14 | 4 | ||
4535 | 4535 | 4534 | {"type": "Polygon", "coordinates": [[[-117.23982, 32.87111], [-117.23981, 32.87152], [-117.23927, 32.87152], [-117.23951, 32.87136], [-117.23982, 32.87111]]]} | No Public Access 3 | 19896 | 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 | 0.273 | 0 | Local Other or Unknown 14 | 4 | ||
4536 | 4536 | 4535 | {"type": "Polygon", "coordinates": [[[-117.1276, 32.76738], [-117.12717, 32.76784], [-117.12705, 32.76778], [-117.12742, 32.76738], [-117.1276, 32.76738]]]} | No Public Access 3 | 19905 | 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 | 0.196 | 0 | Local Other or Unknown 14 | 4 | ||
4537 | 4537 | 4536 | {"type": "Polygon", "coordinates": [[[-117.10461, 32.76969], [-117.10445, 32.76969], [-117.10461, 32.76951], [-117.10461, 32.76969], [-117.10461, 32.76969]]]} | No Public Access 3 | 19907 | 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 | 0.035 | 0 | Local Other or Unknown 14 | 4 | ||
4616 | 4616 | 4615 | {"type": "Polygon", "coordinates": [[[-122.25499, 38.35941], [-122.25411, 38.35979], [-122.25361, 38.35995], [-122.25326, 38.35997], [-122.25289, 38.3599], [-122.25265, 38.35979], [-122.25242, 38.35946], [-122.25248, 38.35927], [-122.25284, 38.35909], [-122.2538, 38.35892], [-122.2543, 38.35893], [-122.25499, 38.35941]]]} | No Public Access 3 | 35922 | 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 | 4.386 | 0 | Local Other or Unknown 14 | 4 | ||
4630 | 4630 | 4629 | {"type": "Polygon", "coordinates": [[[-122.22625, 38.22568], [-122.22229, 38.22571], [-122.22225, 38.22421], [-122.22224, 38.22254], [-122.22307, 38.22433], [-122.2237, 38.22472], [-122.2237, 38.22525], [-122.22475, 38.22524], [-122.22476, 38.22438], [-122.22452, 38.22437], [-122.22415, 38.22431], [-122.22384, 38.22431], [-122.22307, 38.22385], [-122.22241, 38.22243], [-122.22242, 38.22209], [-122.22261, 38.22185], [-122.22315, 38.22161], [-122.22316, 38.22152], [-122.22322, 38.22151], [-122.22325, 38.22127], [-122.22366, 38.2211], [-122.22393, 38.22126], [-122.22421, 38.22139], [-122.22447, 38.22149], [-122.2248, 38.22157], [-122.22525, 38.22163], [-122.2262, 38.22165], [-122.22625, 38.22568]]]} | No Public Access 3 | 36293 | 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 | 35.376 | 0 | Local Other or Unknown 14 | 4 | ||
4633 | 4633 | 4632 | {"type": "Polygon", "coordinates": [[[-122.26376, 38.30317], [-122.26366, 38.30341], [-122.26313, 38.30317], [-122.26295, 38.30314], [-122.26275, 38.30314], [-122.26311, 38.30284], [-122.26376, 38.30317]]]} | No Public Access 3 | 36317 | 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.57 | 0 | Local Other or Unknown 14 | 4 | ||
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 | ||
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 | ||
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 | ||
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 | ||
15449 | 15449 | 15448 | {"type": "Polygon", "coordinates": [[[-122.30439, 38.26326], [-122.30382, 38.2634], [-122.30362, 38.26287], [-122.30419, 38.26274], [-122.30439, 38.26326]]]} | No Public Access 3 | 36595 | 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.78 | 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 |
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]);