superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,352 rows where MNG_AG_LEV = 3 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 171
- San Diego, County of 120
- Santa Barbara, County of 89
- Orange, County of 82
- Los Angeles - Department of Parks and Recreation, County of 63
- Lake, County of 56
- Butte, County of 53
- Santa Cruz, County of 50
- Sonoma County Regional Parks Dept., County of 48
- Sacramento, County of 48
- Kern, County of 47
- Santa Clara County Parks and Recreation Dept., County of 42
- Riverside, County of 39
- Marin County Parks Department, County of 34
- San Luis Obispo, County of 31
- Monterey, County of 31
- Placer, County of 28
- San Mateo County Parks and Recreation Dept., County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- Ventura, County of 20
- San Bernardino, County of 18
- Fresno, County of 17
- Merced, County of 16
- Yolo, County of 16
- Tulare, County of 15
- San Francisco - Public Utilities Commission, City and County of 12
- Humboldt, County of 12
- Contra Costa County Public Works Dept., County of 11
- El Dorado, County of 9
- …
ACCESS_TYP 4
- Open Access 1,191
- Restricted Access 78
- No Public Access 46
- Unknown Access 37
MNG_AG_TYP 3
- County Agency 1,102
- County Agency - Parks 218
- County Agency - Other 32
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID ▼ | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
779 | 779 | 778 | {"type": "Polygon", "coordinates": [[[-122.28132, 37.9134], [-122.28121, 37.91336], [-122.28073, 37.91357], [-122.28038, 37.91363], [-122.28008, 37.91364], [-122.28059, 37.91414], [-122.28033, 37.91429], [-122.28033, 37.91433], [-122.28017, 37.91443], [-122.28014, 37.91447], [-122.28011, 37.91455], [-122.27999, 37.91464], [-122.27974, 37.91375], [-122.27977, 37.91354], [-122.27953, 37.91348], [-122.27932, 37.91337], [-122.27914, 37.9133], [-122.27894, 37.91332], [-122.27856, 37.91344], [-122.27849, 37.9134], [-122.27855, 37.91313], [-122.27855, 37.91292], [-122.28025, 37.91174], [-122.28106, 37.91239], [-122.2812, 37.91267], [-122.28075, 37.91276], [-122.28074, 37.91278], [-122.28092, 37.91334], [-122.28129, 37.91319], [-122.28132, 37.9134]]]} | Open Access 1 | Kensington Park | 32713 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 8.475 | Kensington Park | ||
781 | 781 | 780 | {"type": "Polygon", "coordinates": [[[-122.27841, 37.90357], [-122.27835, 37.9037], [-122.2783, 37.90383], [-122.27824, 37.90357], [-122.27841, 37.90357]]]} | Open Access 1 | Kensington Pocket Park | 32715 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 0.053 | Kensington PP | ||
1083 | 1083 | 1082 | {"type": "Polygon", "coordinates": [[[-121.59683, 37.91452], [-121.59681, 37.91464], [-121.59673, 37.91472], [-121.59644, 37.91529], [-121.59643, 37.91542], [-121.59661, 37.91574], [-121.5967, 37.9161], [-121.59664, 37.91618], [-121.59635, 37.91627], [-121.596, 37.91633], [-121.59546, 37.91637], [-121.59503, 37.91646], [-121.59462, 37.91649], [-121.59405, 37.91522], [-121.59426, 37.91509], [-121.5945, 37.91486], [-121.59474, 37.91466], [-121.59492, 37.91418], [-121.59501, 37.9138], [-121.59505, 37.91347], [-121.59532, 37.91343], [-121.59553, 37.91343], [-121.59577, 37.91346], [-121.59603, 37.91361], [-121.59619, 37.91376], [-121.59653, 37.91426], [-121.59673, 37.91442], [-121.59683, 37.91452]]]} | Open Access 1 | Cornell Park | 32842 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 13.523 | Cornell Park | ||
3337 | 3337 | 3336 | {"type": "Polygon", "coordinates": [[[-122.21997, 38.05377], [-122.21956, 38.05348], [-122.21836, 38.05306], [-122.21781, 38.05289], [-122.21792, 38.05262], [-122.21939, 38.05234], [-122.21949, 38.05202], [-122.21938, 38.05173], [-122.21992, 38.05179], [-122.21998, 38.05209], [-122.22007, 38.05311], [-122.22003, 38.05357], [-122.21997, 38.05377]]]} | Open Access 1 | Crockett | 17826 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 5.155 | Crockett | ||
6081 | 6081 | 6080 | {"type": "Polygon", "coordinates": [[[-122.2701, 38.03192], [-122.26926, 38.03205], [-122.26919, 38.03185], [-122.26869, 38.03192], [-122.26872, 38.03213], [-122.26707, 38.03237], [-122.26663, 38.03052], [-122.26966, 38.03007], [-122.2701, 38.03192]]]} | Open Access 1 | Lefty Gomez Ballfield Complex | 21138 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 13.712 | Lefty Gomez Ballfield Complex | ||
6311 | 6311 | 6310 | {"type": "Polygon", "coordinates": [[[-122.02017, 37.86622], [-122.02016, 37.86639], [-122.01993, 37.86641], [-122.01969, 37.86648], [-122.01952, 37.86657], [-122.01934, 37.86672], [-122.0192, 37.86692], [-122.01905, 37.86733], [-122.01897, 37.86749], [-122.01882, 37.86767], [-122.01862, 37.86783], [-122.01852, 37.86783], [-122.01826, 37.8676], [-122.01798, 37.86742], [-122.01815, 37.86697], [-122.01795, 37.86683], [-122.0179, 37.86666], [-122.01792, 37.86629], [-122.01939, 37.86633], [-122.01944, 37.86632], [-122.0195, 37.86629], [-122.01953, 37.86625], [-122.01954, 37.8662], [-122.02017, 37.86622]]]} | Open Access 1 | Livorna Park | 21386 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 4.389 | Livorna Park | ||
6472 | 6472 | 6471 | {"type": "Polygon", "coordinates": [[[-121.95664, 38.0308], [-121.95557, 38.03164], [-121.95456, 38.03083], [-121.95562, 38.03], [-121.95664, 38.0308]]]} | Open Access 1 | Lynbrook Park | 21606 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 4.143 | Lynbrook Park | ||
7117 | 7117 | 7116 | {"type": "Polygon", "coordinates": [[[-122.3308, 37.99984], [-122.32883, 38.00027], [-122.32826, 37.99972], [-122.32874, 37.9994], [-122.32795, 37.99863], [-122.32906, 37.99841], [-122.32936, 37.9984], [-122.33043, 37.9986], [-122.33057, 37.99918], [-122.33065, 37.99944], [-122.33072, 37.9996], [-122.3308, 37.99984]]]} | Open Access 1 | Montalvin Park | 22382 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 8.503 | Montalvin Park | ||
8271 | 8271 | 8270 | {"type": "Polygon", "coordinates": [[[-122.09793, 38.0339], [-122.09769, 38.03914], [-122.09158, 38.04066], [-122.09096, 38.03986], [-122.08905, 38.03774], [-122.08812, 38.03657], [-122.08732, 38.03561], [-122.08642, 38.03459], [-122.08564, 38.03378], [-122.08448, 38.0328], [-122.08348, 38.03204], [-122.08255, 38.03143], [-122.09011, 38.02928], [-122.09118, 38.03176], [-122.09429, 38.0309], [-122.09428, 38.03188], [-122.09338, 38.03401], [-122.09417, 38.03471], [-122.09447, 38.03495], [-122.09577, 38.03467], [-122.09706, 38.03377], [-122.09793, 38.0339]]]} | Restricted Access 2 | Point Edith Wetlands | 23847 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 211.393 | Point Edith Wetlands | 2001 | |
11596 | 11596 | 11595 | {"type": "Polygon", "coordinates": [[[-122.00274, 37.90517], [-122.00231, 37.90516], [-122.00213, 37.90513], [-122.00195, 37.90508], [-122.00169, 37.90499], [-121.99863, 37.90492], [-121.99859, 37.90475], [-121.99682, 37.90477], [-121.99628, 37.90372], [-121.994, 37.90374], [-121.99403, 37.90334], [-121.99401, 37.90309], [-121.99395, 37.90283], [-121.99387, 37.90259], [-121.99375, 37.90235], [-121.9936, 37.90213], [-121.99346, 37.90195], [-121.9981, 37.90237], [-121.99812, 37.90235], [-121.99811, 37.90229], [-122.00015, 37.90249], [-122.0002, 37.90249], [-122.00021, 37.90255], [-122.00096, 37.90262], [-122.00103, 37.90334], [-122.00094, 37.90337], [-122.00101, 37.90354], [-122.00107, 37.90407], [-122.00116, 37.90431], [-122.00123, 37.90442], [-122.00141, 37.90462], [-122.00151, 37.90471], [-122.00176, 37.90486], [-122.0019, 37.90492], [-122.00219, 37.905], [-122.00235, 37.90503], [-122.00268, 37.90503], [-122.00274, 37.90517]]]} | No Public Access 3 | Mount Diablo Gateway | 28139 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 38.146 | Mount Diablo Gateway | ||
15583 | 15583 | 15582 | {"type": "Polygon", "coordinates": [[[-122.32946, 38.00168], [-122.32842, 38.00225], [-122.32756, 38.00145], [-122.32721, 38.00108], [-122.32859, 38.00069], [-122.32946, 38.00168]]]} | Open Access 1 | Montara Bay Community Center | 22384 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 4.395 | Montara Bay Community Ctr. | ||
72 | 72 | 71 | {"type": "Polygon", "coordinates": [[[-119.42108, 36.77855], [-119.42081, 36.78005], [-119.41857, 36.78242], [-119.41777, 36.78378], [-119.41743, 36.78551], [-119.41756, 36.78608], [-119.41728, 36.7867], [-119.41689, 36.78775], [-119.4136, 36.79017], [-119.41289, 36.79018], [-119.4129, 36.78956], [-119.41265, 36.78957], [-119.41263, 36.78953], [-119.41164, 36.78953], [-119.41163, 36.79007], [-119.41169, 36.79008], [-119.41169, 36.7902], [-119.41163, 36.79022], [-119.41163, 36.79075], [-119.41051, 36.79098], [-119.40972, 36.79183], [-119.4092, 36.79286], [-119.40806, 36.79282], [-119.40253, 36.79276], [-119.4029, 36.79203], [-119.40398, 36.79025], [-119.40444, 36.79042], [-119.40454, 36.79041], [-119.40454, 36.79034], [-119.4045, 36.79033], [-119.40438, 36.79018], [-119.40409, 36.79007], [-119.40466, 36.78911], [-119.40589, 36.7856], [-119.40682, 36.7856], [-119.40682, 36.78531], [-119.40608, 36.7853], [-119.40697, 36.78457], [-119.40753, 36.78396], [-119.40776, 36.78365], [-119.4092, 36.78367], [-119.40889, 36.78446], [-119.40818, 36.78559], [-119.40819, 36.78561], [-119.41158, 36.78567], [-119.41163, 36.78946], [-119.41292, 36.78906], [-119.41329, 36.78548], [-119.41363, 36.78402], [-119.41156, 36.78247], [-119.41151, 36.78205], [-119.41573, 36.78208], [-119.41818, 36.77991], [-119.41917, 36.78014], [-119.42026, 36.77852], [-119.42108, 36.77855]]]} | Open Access 1 | Avocado Lake Park | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51947 | 3936 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 225.868 | Avocado Lake Park | |
404 | 404 | 403 | {"type": "Polygon", "coordinates": [[[-119.7034, 36.73503], [-119.70336, 36.73509], [-119.70325, 36.73514], [-119.70255, 36.73514], [-119.70247, 36.73512], [-119.70241, 36.73508], [-119.70238, 36.735], [-119.70237, 36.73404], [-119.70239, 36.734], [-119.70244, 36.73399], [-119.70282, 36.73399], [-119.70289, 36.73401], [-119.70294, 36.73405], [-119.7034, 36.73496], [-119.7034, 36.73503]]]} | Open Access 1 | Montecito | 33484 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 2.258 | Montecito | ||
2132 | 2132 | 2131 | {"type": "Polygon", "coordinates": [[[-119.50625, 36.72095], [-119.50623, 36.7228], [-119.50624, 36.72462], [-119.50195, 36.72458], [-119.50192, 36.72283], [-119.50197, 36.72277], [-119.50198, 36.7227], [-119.50194, 36.72262], [-119.50188, 36.72258], [-119.5018, 36.72256], [-119.50169, 36.72257], [-119.50161, 36.72263], [-119.50158, 36.72271], [-119.5016, 36.72279], [-119.50166, 36.72285], [-119.5017, 36.72766], [-119.50164, 36.72783], [-119.50148, 36.72797], [-119.50134, 36.72816], [-119.49746, 36.72813], [-119.49741, 36.72098], [-119.50625, 36.72095]]]} | Open Access 1 | China Creek Park | 17202 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 113.795 | China Creek Park | ||
2908 | 2908 | 2907 | {"type": "Polygon", "coordinates": [[[-119.36499, 36.82156], [-119.36484, 36.82167], [-119.36465, 36.82269], [-119.3645, 36.82277], [-119.36352, 36.82264], [-119.36305, 36.8226], [-119.36273, 36.82261], [-119.36239, 36.82267], [-119.36177, 36.82273], [-119.36155, 36.82272], [-119.36075, 36.8225], [-119.36008, 36.82242], [-119.35953, 36.82239], [-119.35875, 36.82224], [-119.35845, 36.82216], [-119.35796, 36.82194], [-119.35762, 36.82183], [-119.35627, 36.82122], [-119.35558, 36.82116], [-119.35494, 36.82132], [-119.35425, 36.82166], [-119.3521, 36.82457], [-119.35158, 36.82517], [-119.3513, 36.82527], [-119.3507, 36.82524], [-119.35048, 36.82532], [-119.3503, 36.82541], [-119.34938, 36.82674], [-119.3481, 36.82793], [-119.34605, 36.82777], [-119.34969, 36.8246], [-119.35288, 36.82119], [-119.35294, 36.8202], [-119.354, 36.81915], [-119.35626, 36.81834], [-119.35729, 36.81815], [-119.35755, 36.81813], [-119.36022, 36.81832], [-119.36486, 36.81775], [-119.36499, 36.82156]]]} | Open Access 1 | Choinumni Park | 17214 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 140.596 | Choinumni Park | ||
3915 | 3915 | 3914 | {"type": "Polygon", "coordinates": [[[-120.39086, 36.50214], [-120.39079, 36.50243], [-120.39079, 36.50283], [-120.39059, 36.50287], [-120.39032, 36.50283], [-120.39015, 36.50274], [-120.38996, 36.50251], [-120.38987, 36.50246], [-120.38984, 36.5023], [-120.38984, 36.50215], [-120.38985, 36.50208], [-120.3899, 36.502], [-120.39023, 36.50191], [-120.39072, 36.50197], [-120.39086, 36.50214]]]} | Open Access 1 | El Parque de la Communida El Porvenir | 18524 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 1.861 | El Parque de la Communida El Porvenir | ||
5360 | 5360 | 5359 | {"type": "Polygon", "coordinates": [[[-120.5772, 36.23014], [-120.576, 36.23388], [-120.57199, 36.23385], [-120.57198, 36.23372], [-120.57111, 36.23372], [-120.57112, 36.2293], [-120.57146, 36.22934], [-120.57203, 36.22947], [-120.57274, 36.22952], [-120.57507, 36.22999], [-120.57554, 36.23005], [-120.57601, 36.23004], [-120.5772, 36.23014]]]} | Open Access 1 | Los Gatos Creek County Park | 21515 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 55.581 | Los Gatos Creek County Park | ||
5667 | 5667 | 5666 | {"type": "Polygon", "coordinates": [[[-119.92531, 36.72346], [-119.92527, 36.72786], [-119.91225, 36.72797], [-119.91225, 36.72353], [-119.92531, 36.72346]]]} | Open Access 1 | Kearney Park | 20564 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 141.047 | Kearney Park | ||
5736 | 5736 | 5735 | {"type": "Polygon", "coordinates": [[[-119.44789, 36.74967], [-119.44787, 36.75316], [-119.44786, 36.75324], [-119.44785, 36.75402], [-119.44542, 36.75484], [-119.44438, 36.75684], [-119.44384, 36.75753], [-119.44321, 36.75812], [-119.4432, 36.75928], [-119.44317, 36.76005], [-119.44202, 36.76162], [-119.44126, 36.76044], [-119.43947, 36.76041], [-119.43884, 36.75948], [-119.43886, 36.75681], [-119.43707, 36.75679], [-119.43755, 36.7563], [-119.43776, 36.7561], [-119.43831, 36.75579], [-119.43972, 36.75506], [-119.4399, 36.75496], [-119.44006, 36.75484], [-119.44026, 36.75466], [-119.44042, 36.75443], [-119.44053, 36.75416], [-119.4406, 36.75388], [-119.44062, 36.75264], [-119.44234, 36.75208], [-119.44351, 36.75166], [-119.44407, 36.75142], [-119.44732, 36.74965], [-119.44789, 36.74967]]]} | Open Access 1 | Kings River Green Belt Park | 20662 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 136.486 | Kings River Green Belt Park | ||
5744 | 5744 | 5743 | {"type": "Polygon", "coordinates": [[[-119.47502, 36.7331], [-119.47483, 36.73317], [-119.47481, 36.73326], [-119.47375, 36.73264], [-119.47308, 36.73291], [-119.47161, 36.73203], [-119.47134, 36.73246], [-119.47051, 36.73212], [-119.47043, 36.7321], [-119.47052, 36.73197], [-119.47095, 36.7312], [-119.47206, 36.73151], [-119.47297, 36.73185], [-119.47502, 36.7331]]]} | Open Access 1 | Kings river Access Park | 20661 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 7.293 | Kings river Access Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);