superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 4,913
- Recreation/Parks District 563
- State Agency 543
- County Agency 531
- Non Profit - Land Trust 308
- Open Space District 162
- Federal Agency 146
- County Agency - Parks 141
- Water District 130
- Home Owners Association 107
- Non Profit - Conservation 81
- Community Services District 79
- Flood District 54
- Cemetery District 26
- Non Profit - Other 23
- County Agency - Other 20
- Port/Harbor District 19
- School District 13
- Irrigation District 12
- Commercial 10
- Special District - Other 5
- Other 5
- Sanitation District 4
- Joint Powers Authority 4
- Non Profit - Cemetery District 4
- Conservation District 4
- Mitigation Bank 3
- Transportation Agency 3
- Metropolitan Planning Organization 2
- Non Profit - Education 2
- …
MNG_AGENCY >30
- San Diego, City of 326
- Los Angeles, City of 279
- California Department of Fish and Wildlife 263
- California Department of Parks and Recreation 160
- Ventura, City of 127
- Mountains Recreation and Conservation Authority 120
- San Jose, City of 99
- Los Angeles, County of 97
- Long Beach, City of 96
- San Francisco, City and County of 91
- East Bay Regional Park District 90
- San Diego, County of 88
- Sacramento, City of 86
- Roseville, City of 78
- Los Angeles - Department of Parks and Recreation, County of 56
- Fresno, City of 55
- Poway, City of 54
- Torrance, City of 51
- Santa Barbara, County of 50
- Yuba County Water Agency 48
- Santa Cruz, City of 45
- Orange, County of 42
- Davis, City of 41
- Midpeninsula Regional Open Space District 41
- Irvine, City of 40
- United States Fish and Wildlife Service 39
- Napa, City of 39
- Clovis, City of 38
- Oakland, City of 37
- Rocklin, City of 37
- …
ACCESS_TYP 4
- Open Access 6,566
- Restricted Access 695
- No Public Access 483
- Unknown Access 176
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7719 | 7719 | 7718 | {"type": "Polygon", "coordinates": [[[-117.62881, 33.68711], [-117.62823, 33.68765], [-117.62818, 33.6877], [-117.62837, 33.68738], [-117.62838, 33.68717], [-117.62881, 33.68711]]]} | Open Access 1 | Orange holding 2 | 23167 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.227 | Orange holding 2 | ||
7720 | 7720 | 7719 | {"type": "Polygon", "coordinates": [[[-117.63374, 33.56465], [-117.63372, 33.56475], [-117.63293, 33.56513], [-117.63284, 33.56515], [-117.63278, 33.5651], [-117.63282, 33.56505], [-117.63252, 33.5646], [-117.63244, 33.56458], [-117.63241, 33.56453], [-117.63243, 33.56448], [-117.6333, 33.56407], [-117.63336, 33.56409], [-117.63374, 33.56465]]]} | Open Access 1 | Orange holding 20 | 23168 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.059 | Orange holding 20 | ||
7721 | 7721 | 7720 | {"type": "Polygon", "coordinates": [[[-117.63393, 33.55687], [-117.63377, 33.55721], [-117.63341, 33.55741], [-117.63334, 33.55739], [-117.63329, 33.55683], [-117.63343, 33.55627], [-117.6335, 33.55627], [-117.63383, 33.55651], [-117.63393, 33.55687]]]} | Open Access 1 | Orange holding 21 | 23169 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.278 | Orange holding 21 | ||
7722 | 7722 | 7721 | {"type": "Polygon", "coordinates": [[[-117.62942, 33.68702], [-117.62839, 33.68717], [-117.62837, 33.68738], [-117.62818, 33.6877], [-117.62813, 33.68775], [-117.62743, 33.68762], [-117.62754, 33.6872], [-117.6276, 33.68684], [-117.62873, 33.68685], [-117.62887, 33.68684], [-117.62926, 33.68677], [-117.6293, 33.6868], [-117.62942, 33.68702]]]} | Open Access 1 | Orange holding 3 | 23170 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.453 | Orange holding 3 | ||
7723 | 7723 | 7722 | {"type": "Polygon", "coordinates": [[[-117.63087, 33.67292], [-117.63058, 33.67337], [-117.6304, 33.67329], [-117.63037, 33.67331], [-117.63009, 33.67319], [-117.62988, 33.67335], [-117.62977, 33.6733], [-117.62957, 33.67326], [-117.62939, 33.67329], [-117.62916, 33.6734], [-117.62909, 33.67337], [-117.62914, 33.67323], [-117.62913, 33.67308], [-117.62914, 33.67295], [-117.62924, 33.67274], [-117.62944, 33.67259], [-117.62946, 33.67244], [-117.62955, 33.67229], [-117.63087, 33.67292]]]} | Open Access 1 | Orange holding 4 | 23171 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.905 | Orange holding 4 | ||
7724 | 7724 | 7723 | {"type": "Polygon", "coordinates": [[[-117.63857, 33.57457], [-117.63787, 33.57431], [-117.63727, 33.57449], [-117.63726, 33.57438], [-117.63751, 33.574], [-117.63751, 33.57405], [-117.63754, 33.57408], [-117.63777, 33.57416], [-117.63788, 33.57415], [-117.63799, 33.57409], [-117.63806, 33.57413], [-117.63814, 33.57414], [-117.63825, 33.57418], [-117.63855, 33.57422], [-117.63857, 33.57457]]]} | Open Access 1 | Orange holding 5 | 23172 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.87 | Orange holding 5 | ||
7725 | 7725 | 7724 | {"type": "Polygon", "coordinates": [[[-117.63726, 33.57438], [-117.63727, 33.57449], [-117.63717, 33.57496], [-117.63702, 33.57514], [-117.63615, 33.57531], [-117.63567, 33.5756], [-117.63515, 33.57558], [-117.63505, 33.57538], [-117.63485, 33.57548], [-117.63422, 33.57516], [-117.63384, 33.57494], [-117.63357, 33.57506], [-117.63345, 33.57529], [-117.63341, 33.57524], [-117.63358, 33.57484], [-117.63367, 33.57479], [-117.63511, 33.57517], [-117.63594, 33.57518], [-117.63671, 33.5749], [-117.63726, 33.57438]]]} | Open Access 1 | Orange holding 6 | 23173 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.929 | Orange holding 6 | ||
7726 | 7726 | 7725 | {"type": "Polygon", "coordinates": [[[-117.63554, 33.54852], [-117.63528, 33.54875], [-117.63505, 33.549], [-117.63502, 33.54901], [-117.63462, 33.54878], [-117.6346, 33.54874], [-117.63495, 33.54837], [-117.63516, 33.54819], [-117.63522, 33.5482], [-117.63553, 33.5485], [-117.63554, 33.54852]]]} | Open Access 1 | Orange holding 7 | 23174 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.005 | Orange holding 7 | ||
7727 | 7727 | 7726 | {"type": "Polygon", "coordinates": [[[-117.62419, 33.69092], [-117.62398, 33.69096], [-117.62396, 33.69093], [-117.62377, 33.69096], [-117.62351, 33.69104], [-117.62298, 33.69101], [-117.62301, 33.69097], [-117.62305, 33.69074], [-117.6231, 33.69026], [-117.62314, 33.69005], [-117.62321, 33.6899], [-117.62345, 33.6895], [-117.62353, 33.68947], [-117.62395, 33.68963], [-117.62408, 33.69006], [-117.62399, 33.69007], [-117.62398, 33.69008], [-117.62419, 33.69092]]]} | Open Access 1 | Orange holding 8 | 23175 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 3.388 | Orange holding 8 | ||
7728 | 7728 | 7727 | {"type": "Polygon", "coordinates": [[[-117.63605, 33.54568], [-117.63574, 33.54607], [-117.6355, 33.54619], [-117.63546, 33.54618], [-117.63543, 33.54597], [-117.63539, 33.54497], [-117.63543, 33.54495], [-117.6355, 33.54496], [-117.63596, 33.54523], [-117.63605, 33.54568]]]} | Open Access 1 | Orange holding 9 | 23176 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 1.436 | Orange holding 9 | ||
7729 | 7729 | 7728 | {"type": "Polygon", "coordinates": [[[-122.42934, 37.65342], [-122.42888, 37.65473], [-122.42854, 37.65581], [-122.42848, 37.6558], [-122.4284, 37.65581], [-122.42728, 37.6556], [-122.42439, 37.65498], [-122.42698, 37.65216], [-122.42694, 37.6521], [-122.42697, 37.65207], [-122.42787, 37.65262], [-122.42934, 37.65342]]]} | Open Access 1 | Orange Memorial Park | 23177 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 25.117 | Orange Memorial Park | ||
7730 | 7730 | 7729 | {"type": "Polygon", "coordinates": [[[-117.31539, 33.89509], [-117.31542, 33.89745], [-117.31538, 33.89765], [-117.31531, 33.89784], [-117.3152, 33.89802], [-117.31503, 33.89823], [-117.31326, 33.89717], [-117.31293, 33.897], [-117.31258, 33.89686], [-117.31221, 33.89675], [-117.31182, 33.89668], [-117.31156, 33.89666], [-117.31167, 33.89567], [-117.31189, 33.89491], [-117.3126, 33.89505], [-117.3131, 33.8951], [-117.31539, 33.89509]]]} | Open Access 1 | Orange Terrace Community Park | 23178 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 21.8 | Orange Terrace Community Park | ||
7731 | 7731 | 7730 | {"type": "Polygon", "coordinates": [[[-121.22504, 38.69618], [-121.22493, 38.70013], [-121.22491, 38.70017], [-121.22488, 38.70019], [-121.22411, 38.70023], [-121.22067, 38.70019], [-121.22073, 38.69821], [-121.2205, 38.69781], [-121.21967, 38.69806], [-121.21938, 38.69791], [-121.2192, 38.6983], [-121.21807, 38.69848], [-121.21802, 38.70012], [-121.21555, 38.70008], [-121.21573, 38.6973], [-121.21818, 38.69737], [-121.21826, 38.69582], [-121.2195, 38.69585], [-121.22, 38.69567], [-121.21989, 38.69527], [-121.21985, 38.69489], [-121.2199, 38.69299], [-121.22035, 38.69301], [-121.22058, 38.69304], [-121.22058, 38.6932], [-121.22075, 38.6933], [-121.22081, 38.69345], [-121.2208, 38.6936], [-121.22067, 38.69375], [-121.22061, 38.69502], [-121.22077, 38.69566], [-121.22089, 38.69595], [-121.22145, 38.69625], [-121.22319, 38.69624], [-121.22362, 38.69606], [-121.22384, 38.69619], [-121.22504, 38.69618]]]} | Open Access 1 | Orangevale Community Park | 23181 | 2248 | Orangevale Recreation and Park District 901 | Special District 4 | Recreation/Parks District 4 | http://www.orangevalecommunitycenter.com/ | Special District 4 | 76.552 | Orangevale Community Park | ||
7732 | 7732 | 7731 | {"type": "Polygon", "coordinates": [[[-121.21603, 38.68469], [-121.21601, 38.68554], [-121.21259, 38.68548], [-121.21264, 38.68378], [-121.21382, 38.6838], [-121.21382, 38.68467], [-121.21603, 38.68469]]]} | Open Access 1 | Orangevale Sports Fields | 23183 | 2248 | Orangevale Recreation and Park District 901 | Special District 4 | Recreation/Parks District 4 | http://www.orangevalecommunitycenter.com/ | Special District 4 | 9.317 | Orangevale Sports Fields | ||
7733 | 7733 | 7732 | {"type": "Polygon", "coordinates": [[[-117.94932, 34.06384], [-117.94802, 34.06506], [-117.94817, 34.06556], [-117.94753, 34.06571], [-117.9465, 34.06495], [-117.9484, 34.06316], [-117.94932, 34.06384]]]} | Open Access 1 | Orangewood Park | 23184 | 1374 | West Covina, City of 315 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 7.994 | Orangewood Park | ||
7734 | 7734 | 7733 | {"type": "Polygon", "coordinates": [[[-121.94371, 37.28863], [-121.94342, 37.28862], [-121.9434, 37.28795], [-121.9437, 37.28795], [-121.94371, 37.28863]]]} | Open Access 1 | Orchard City Green | 23185 | 1043 | Campbell, City of 442 | City 2 | City Agency 2 | http://www.ci.campbell.ca.us/226/Recreation-Parks | City 2 | 0.481 | Orchard City Green | 1992 | |
7735 | 7735 | 7734 | {"type": "Polygon", "coordinates": [[[-117.88129, 33.66139], [-117.88076, 33.66102], [-117.88076, 33.66102], [-117.88085, 33.66093], [-117.88129, 33.66124], [-117.88125, 33.66131], [-117.88129, 33.66139]]]} | Open Access 1 | Orchard Drive Park | 23186 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.184 | Orchard Drive Park | ||
7736 | 7736 | 7735 | {"type": "Polygon", "coordinates": [[[-122.02539, 37.39972], [-122.02523, 37.4002], [-122.02479, 37.40011], [-122.0247, 37.40036], [-122.02448, 37.40026], [-122.02416, 37.40008], [-122.02424, 37.39977], [-122.02218, 37.39932], [-122.02225, 37.39912], [-122.0247, 37.39965], [-122.02474, 37.39958], [-122.02539, 37.39972]]]} | Open Access 1 | Orchard Gardens Park | 23187 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 2.603 | Orchard Gardens Park | 1955 | |
7737 | 7737 | 7736 | {"type": "Polygon", "coordinates": [[[-121.54882, 39.01498], [-121.54877, 39.01546], [-121.54875, 39.01551], [-121.54872, 39.01555], [-121.54865, 39.01556], [-121.54793, 39.01552], [-121.54787, 39.0155], [-121.54784, 39.01547], [-121.54789, 39.01494], [-121.54882, 39.01498]]]} | Open Access 1 | Orchard Glen Park | 23188 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 1.263 | Orchard Glen Park | ||
7738 | 7738 | 7737 | {"type": "Polygon", "coordinates": [[[-121.70481, 37.91848], [-121.7048, 37.91967], [-121.70475, 37.9197], [-121.70317, 37.9197], [-121.70313, 37.91968], [-121.70311, 37.91965], [-121.70311, 37.91848], [-121.70312, 37.91845], [-121.70317, 37.91843], [-121.70474, 37.91843], [-121.70478, 37.91844], [-121.70481, 37.91848]]]} | Open Access 1 | Orchard Park | 23189 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 5.171 | Orchard 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]);