superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP >30
- City Agency 5,308
- Recreation/Parks District 601
- County Agency 538
- State Agency 509
- Non Profit - Land Trust 333
- Home Owners Association 175
- Open Space District 156
- County Agency - Parks 147
- Water District 129
- Federal Agency 102
- Community Services District 88
- Non Profit - Conservation 73
- Flood District 54
- School District 38
- Non Profit - Other 33
- Cemetery District 27
- County Agency - Other 24
- Port/Harbor District 20
- Commercial 14
- Joint Powers Authority 8
- Irrigation District 6
- Other 6
- Special District - Other 4
- Conservation District 4
- Sanitation District 3
- Non Profit - Cemetery District 3
- Mitigation Bank 3
- Metropolitan Planning Organization 2
- Non Profit - Education 2
- Transportation Agency 2
- …
ACCESS_TYP 4
- Open Access 6,849
- Restricted Access 860
- No Public Access 542
- Unknown Access 164
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7568 | 7568 | 7567 | {"type": "Polygon", "coordinates": [[[-123.19386, 39.14724], [-123.19337, 39.14723], [-123.19227, 39.14734], [-123.19201, 39.14546], [-123.19224, 39.14543], [-123.19277, 39.14585], [-123.19307, 39.14606], [-123.19316, 39.14619], [-123.19357, 39.14691], [-123.19386, 39.14724]]]} | Open Access 1 | Oak Manor Park | 22986 | 1413 | Ukiah, City of 776 | City 2 | City Agency 2 | http://www.cityofukiah.com/recreation/ | City 2 | 4.526 | Oak Manor Park | ||
7569 | 7569 | 7568 | {"type": "Polygon", "coordinates": [[[-121.74099, 37.92084], [-121.74088, 37.92104], [-121.73758, 37.92103], [-121.73758, 37.92009], [-121.73789, 37.92015], [-121.7388, 37.91986], [-121.73899, 37.91952], [-121.73934, 37.91955], [-121.73955, 37.91953], [-121.73976, 37.91948], [-121.73999, 37.91936], [-121.74004, 37.91935], [-121.7403, 37.91955], [-121.74008, 37.91976], [-121.74047, 37.92002], [-121.74069, 37.92022], [-121.74085, 37.92045], [-121.74099, 37.92069], [-121.74099, 37.92084]]]} | Open Access 1 | Oak Meadow Park | 22987 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 9.683 | Oak Meadow Park | ||
7570 | 7570 | 7569 | {"type": "Polygon", "coordinates": [[[-121.97598, 37.23543], [-121.97615, 37.23607], [-121.97616, 37.2362], [-121.97615, 37.23637], [-121.97611, 37.23654], [-121.97604, 37.2367], [-121.97578, 37.23708], [-121.9752, 37.2368], [-121.97508, 37.23678], [-121.97504, 37.23682], [-121.97488, 37.23674], [-121.97473, 37.23672], [-121.97429, 37.23722], [-121.97408, 37.237], [-121.9741, 37.23694], [-121.9741, 37.23656], [-121.97414, 37.23649], [-121.97364, 37.23546], [-121.97358, 37.23447], [-121.97394, 37.23455], [-121.9749, 37.23485], [-121.97492, 37.23484], [-121.97518, 37.23494], [-121.97543, 37.23506], [-121.97585, 37.2353], [-121.97598, 37.23543]]]} | Open Access 1 | Oak Meadow Park | 22988 | 1190 | Los Gatos, Town of 448 | City 2 | City Agency 2 | http://www.losgatosca.gov/48/Parks-and-Public-Works | City 2 | 11.122 | Oak Meadow Park | 1958 | |
7555 | 7555 | 7554 | {"type": "MultiPolygon", "coordinates": [[[[-121.39662, 38.56736], [-121.3962, 38.56742], [-121.39581, 38.56744], [-121.39409, 38.56573], [-121.39478, 38.56552], [-121.39662, 38.56736]]], [[[-121.39747, 38.56799], [-121.39733, 38.56851], [-121.39675, 38.56838], [-121.39602, 38.56765], [-121.39641, 38.56761], [-121.39681, 38.56755], [-121.39716, 38.5679], [-121.39747, 38.56799]]]]} | Open Access 1 | Oak Meadow Park | 22989 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 5.551 | Oak Meadow Park | ||
7572 | 7572 | 7571 | {"type": "Polygon", "coordinates": [[[-117.77663, 34.12982], [-117.77661, 34.13156], [-117.77578, 34.13149], [-117.77575, 34.13155], [-117.77515, 34.13155], [-117.77513, 34.13183], [-117.77507, 34.13184], [-117.77506, 34.13155], [-117.77469, 34.13155], [-117.77463, 34.13149], [-117.77468, 34.13124], [-117.77483, 34.1311], [-117.77496, 34.13091], [-117.77512, 34.1306], [-117.7752, 34.13035], [-117.77523, 34.13014], [-117.7753, 34.12981], [-117.77531, 34.12968], [-117.77561, 34.12968], [-117.77569, 34.12972], [-117.77577, 34.12968], [-117.77609, 34.12968], [-117.77609, 34.12973], [-117.77612, 34.12977], [-117.77622, 34.12983], [-117.77663, 34.12982]]]} | Open Access 1 | Oak Mesa Park | 22990 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 7.313 | Oak Mesa Park | ||
7573 | 7573 | 7572 | {"type": "Polygon", "coordinates": [[[-117.20672, 33.59726], [-117.20656, 33.59751], [-117.20573, 33.59841], [-117.20419, 33.59741], [-117.20482, 33.59637], [-117.20549, 33.59669], [-117.20516, 33.59719], [-117.20517, 33.59721], [-117.20564, 33.59742], [-117.20598, 33.59691], [-117.20672, 33.59726]]]} | Open Access 1 | Oak Mesa Park | 22991 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 5.992 | Oak Mesa Park | ||
7574 | 7574 | 7573 | {"type": "Polygon", "coordinates": [[[-121.90768, 36.60961], [-121.9071, 36.60989], [-121.90663, 36.60934], [-121.90603, 36.60842], [-121.90675, 36.60842], [-121.90711, 36.60881], [-121.90705, 36.60884], [-121.90705, 36.60886], [-121.90768, 36.60961]]]} | Open Access 1 | Oak Newton Park | 22992 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 2.585 | Oak Newton Park | ||
7576 | 7576 | 7575 | {"type": "MultiPolygon", "coordinates": [[[[-118.82837, 34.28883], [-118.82756, 34.29078], [-118.82605, 34.29033], [-118.82604, 34.29002], [-118.82514, 34.28993], [-118.82504, 34.29067], [-118.82482, 34.29087], [-118.82301, 34.29112], [-118.82013, 34.29098], [-118.81961, 34.29067], [-118.81913, 34.29065], [-118.81838, 34.29091], [-118.81713, 34.29077], [-118.81742, 34.28732], [-118.81387, 34.28711], [-118.81386, 34.28684], [-118.82324, 34.28737], [-118.82426, 34.28747], [-118.82492, 34.28758], [-118.82541, 34.28769], [-118.82693, 34.28812], [-118.82694, 34.28841], [-118.82837, 34.28883]]], [[[-118.83611, 34.2928], [-118.83604, 34.2928], [-118.83544, 34.29239], [-118.83335, 34.29227], [-118.83289, 34.29177], [-118.83124, 34.29189], [-118.83026, 34.2917], [-118.82828, 34.29155], [-118.82764, 34.29087], [-118.82847, 34.28886], [-118.83037, 34.28943], [-118.83032, 34.28956], [-118.83084, 34.28976], [-118.83081, 34.28984], [-118.83137, 34.29009], [-118.83202, 34.29043], [-118.83209, 34.29037], [-118.83225, 34.29046], [-118.83234, 34.29035], [-118.83505, 34.29206], [-118.83555, 34.29234], [-118.83591, 34.29252], [-118.83611, 34.2928]]]]} | Open Access 1 | Oak Park | 22993 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 122.055 | Oak Park | ||
7577 | 7577 | 7576 | {"type": "Polygon", "coordinates": [[[-117.73406, 33.56494], [-117.73385, 33.56509], [-117.73401, 33.56555], [-117.73298, 33.56582], [-117.73269, 33.56569], [-117.73282, 33.56524], [-117.73297, 33.56489], [-117.73314, 33.56456], [-117.73328, 33.56434], [-117.7335, 33.56441], [-117.73363, 33.56437], [-117.73371, 33.56446], [-117.73388, 33.5646], [-117.73392, 33.56466], [-117.734, 33.56481], [-117.73406, 33.56494]]]} | Open Access 1 | Oak Park | 22994 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 3.358 | Oak Park | ||
7578 | 7578 | 7577 | {"type": "Polygon", "coordinates": [[[-117.76934, 33.83943], [-117.76919, 33.8398], [-117.76877, 33.83968], [-117.76842, 33.83961], [-117.76782, 33.83956], [-117.76746, 33.83956], [-117.76578, 33.83972], [-117.76531, 33.83981], [-117.76502, 33.83983], [-117.76473, 33.83983], [-117.76452, 33.83979], [-117.76455, 33.83963], [-117.76457, 33.83965], [-117.76481, 33.83965], [-117.76506, 33.83962], [-117.76628, 33.83904], [-117.76643, 33.83894], [-117.76644, 33.83892], [-117.76669, 33.83878], [-117.76667, 33.83852], [-117.76725, 33.83858], [-117.76811, 33.83826], [-117.7675, 33.83775], [-117.76856, 33.83801], [-117.76925, 33.83878], [-117.76934, 33.83943]]]} | Open Access 1 | Oak Park | 22995 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 10.916 | Oak Park | ||
7579 | 7579 | 7578 | {"type": "Polygon", "coordinates": [[[-122.24374, 37.85662], [-122.24374, 37.85706], [-122.24373, 37.85708], [-122.24362, 37.857], [-122.24337, 37.85676], [-122.24374, 37.85662]]]} | Open Access 1 | Oak Park | 22996 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.22 | Oak Park | ||
7580 | 7580 | 7579 | {"type": "Polygon", "coordinates": [[[-120.20549, 34.62013], [-120.20458, 34.62171], [-120.20416, 34.62157], [-120.20415, 34.62153], [-120.20431, 34.6212], [-120.20442, 34.621], [-120.2045, 34.62088], [-120.20479, 34.62055], [-120.20487, 34.62043], [-120.20504, 34.62006], [-120.2051, 34.62005], [-120.20549, 34.62013]]]} | Open Access 1 | Oak Park | 22997 | 1036 | Buellton, City of 86 | City 2 | City Agency 2 | http://www.cityofbuellton.com/Parks&Rec/parks.asp | City 2 | 2.003 | Oak Park | ||
7581 | 7581 | 7580 | {"type": "Polygon", "coordinates": [[[-117.49797, 34.03513], [-117.49753, 34.03552], [-117.49748, 34.03551], [-117.497, 34.03593], [-117.49702, 34.03597], [-117.49689, 34.03608], [-117.49555, 34.03502], [-117.49576, 34.03499], [-117.49733, 34.03499], [-117.4976, 34.03502], [-117.49765, 34.03505], [-117.49769, 34.03511], [-117.49777, 34.03514], [-117.49786, 34.03514], [-117.49794, 34.0351], [-117.49797, 34.03513]]]} | Open Access 1 | Oak Park | 22998 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 3.382 | Oak Park | ||
7582 | 7582 | 7581 | {"type": "Polygon", "coordinates": [[[-121.46394, 38.5431], [-121.46359, 38.54311], [-121.46358, 38.54387], [-121.46331, 38.54389], [-121.46331, 38.54451], [-121.46245, 38.54451], [-121.46245, 38.54312], [-121.46189, 38.5431], [-121.46189, 38.54231], [-121.46295, 38.54232], [-121.46394, 38.5431]]]} | Open Access 1 | Oak Park | 22999 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.353 | Oak Park | ||
7583 | 7583 | 7582 | {"type": "MultiPolygon", "coordinates": [[[[-122.57174, 37.9877], [-122.57157, 37.98793], [-122.5715, 37.98795], [-122.57136, 37.98792], [-122.57122, 37.98785], [-122.57112, 37.98781], [-122.5709, 37.98781], [-122.57063, 37.98785], [-122.57061, 37.98783], [-122.57079, 37.98761], [-122.57139, 37.98731], [-122.57174, 37.9877]]], [[[-122.57181, 37.98811], [-122.57174, 37.98818], [-122.5716, 37.98804], [-122.57162, 37.98803], [-122.57181, 37.98811]]]]} | Open Access 1 | Oak Park | 23000 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 0.94 | Oak Park | ||
7584 | 7584 | 7583 | {"type": "MultiPolygon", "coordinates": [[[[-119.72877, 34.4307], [-119.72837, 34.43096], [-119.72829, 34.43092], [-119.72818, 34.43091], [-119.72808, 34.43094], [-119.72799, 34.431], [-119.72781, 34.43118], [-119.72776, 34.43126], [-119.72774, 34.43137], [-119.72774, 34.43162], [-119.7277, 34.43173], [-119.72764, 34.4318], [-119.72727, 34.43209], [-119.72714, 34.43214], [-119.72701, 34.43216], [-119.72653, 34.43211], [-119.72666, 34.43129], [-119.7267, 34.43114], [-119.72674, 34.43099], [-119.72713, 34.42993], [-119.72715, 34.42981], [-119.72715, 34.42968], [-119.72712, 34.42956], [-119.72708, 34.42944], [-119.72697, 34.42928], [-119.72687, 34.42918], [-119.72623, 34.42871], [-119.72773, 34.42732], [-119.72773, 34.42735], [-119.7279, 34.42748], [-119.7282, 34.42791], [-119.72826, 34.42846], [-119.72814, 34.42903], [-119.72803, 34.42974], [-119.72832, 34.43009], [-119.72859, 34.43049], [-119.72877, 34.4307]]], [[[-119.72833, 34.43216], [-119.72769, 34.43231], [-119.72715, 34.43226], [-119.7273, 34.43224], [-119.72744, 34.43218], [-119.72784, 34.43187], [-119.72789, 34.4318], [-119.72792, 34.43172], [-119.72792, 34.43143], [-119.72795, 34.43132], [-119.72815, 34.43109], [-119.72822, 34.43105], [-119.72828, 34.43104], [-119.72825, 34.43108], [-119.72813, 34.43138], [-119.72824, 34.43162], [-119.72833, 34.43216]]]]} | Open Access 1 | Oak Park | 23002 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 16.202 | Oak Park | ||
7585 | 7585 | 7584 | {"type": "MultiPolygon", "coordinates": [[[[-121.2903, 37.9856], [-121.2888, 37.98595], [-121.28776, 37.98324], [-121.2892, 37.98287], [-121.2903, 37.9856]]], [[[-121.29659, 37.98407], [-121.29051, 37.98555], [-121.28941, 37.98282], [-121.29117, 37.98237], [-121.29137, 37.9823], [-121.29178, 37.98212], [-121.292, 37.98203], [-121.29224, 37.98196], [-121.29542, 37.98117], [-121.29611, 37.98284], [-121.29659, 37.98407]]]]} | Open Access 1 | Oak Park | 23003 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 56.219 | Oak Park | ||
7587 | 7587 | 7586 | {"type": "Polygon", "coordinates": [[[-121.46189, 38.5431], [-121.46127, 38.5431], [-121.46126, 38.54227], [-121.46073, 38.54226], [-121.46073, 38.54214], [-121.46126, 38.54214], [-121.46127, 38.5419], [-121.46189, 38.54189], [-121.46189, 38.5431]]]} | Open Access 1 | Oak Park Open Space | 23005 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.966 | Oak Park OS | ||
7586 | 7586 | 7585 | {"type": "Polygon", "coordinates": [[[-118.41508, 34.43102], [-118.41508, 34.43191], [-118.41454, 34.4314], [-118.41426, 34.4312], [-118.41413, 34.43116], [-118.41379, 34.43115], [-118.41378, 34.43104], [-118.41362, 34.43103], [-118.41335, 34.43038], [-118.41411, 34.43019], [-118.41439, 34.43019], [-118.41447, 34.42991], [-118.41505, 34.42992], [-118.41508, 34.42995], [-118.41508, 34.43102]]]} | Open Access 1 | Oak Spring Park | 23006 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 4.918 | Oak Spring Park | ||
7571 | 7571 | 7570 | {"type": "Polygon", "coordinates": [[[-117.77792, 33.53377], [-117.77753, 33.53399], [-117.77746, 33.53383], [-117.77787, 33.53361], [-117.77792, 33.53377]]]} | Open Access 1 | Oak Street Park | 23007 | 1164 | Laguna Beach, City of 177 | City 2 | City Agency 2 | http://www.lagunabeachcity.net/cityhall/pw/parks.asp | City 2 | 0.201 | Oak Street 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]);