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 7,605
- County Agency 814
- Recreation/Parks District 789
- State Agency 605
- Non Profit - Land Trust 399
- Open Space District 187
- Federal Agency 172
- County Agency - Parks 168
- Water District 153
- Community Services District 145
- Home Owners Association 131
- Non Profit - Conservation 95
- Flood District 69
- Cemetery District 44
- Non Profit - Other 32
- County Agency - Other 27
- Port/Harbor District 23
- Irrigation District 16
- School District 13
- Commercial 10
- Sanitation District 8
- Special District - Other 6
- Other 5
- Joint Powers Authority 4
- Non Profit - Cemetery District 4
- Mitigation Bank 4
- Conservation District 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 367
- Los Angeles, City of 367
- California Department of Fish and Wildlife 295
- San Jose, City of 180
- San Francisco, City and County of 165
- California Department of Parks and Recreation 162
- Sacramento, City of 160
- Mountains Recreation and Conservation Authority 141
- Ventura, City of 140
- Los Angeles, County of 133
- Long Beach, City of 119
- San Diego, County of 107
- Roseville, City of 104
- East Bay Regional Park District 102
- Oakland, City of 81
- Irvine, City of 81
- Fresno, City of 77
- Consumnes Community Services District 74
- Santa Barbara, County of 69
- Orange, County of 65
- Huntington Beach, City of 61
- Poway, City of 61
- Torrance, City of 61
- Stockton, City of 61
- Hayward Area Recreation and Park District 59
- Santa Cruz, City of 58
- Los Angeles - Department of Parks and Recreation, County of 57
- Chula Vista, City of 56
- Napa, City of 56
- Modesto, City of 55
- …
ACCESS_TYP 4
- Open Access 9,873
- Restricted Access 846
- No Public Access 601
- Unknown Access 224
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4095 | 4095 | 4094 | {"type": "Polygon", "coordinates": [[[-122.27532, 38.3019], [-122.27529, 38.30218], [-122.27527, 38.30222], [-122.27509, 38.30234], [-122.27503, 38.30233], [-122.27496, 38.30228], [-122.27477, 38.30207], [-122.27525, 38.30186], [-122.27529, 38.30188], [-122.27532, 38.3019]]]} | Open Access 1 | Evans Park | 18755 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 0.373 | Evans Park | 1999 | |
4096 | 4096 | 4095 | {"type": "Polygon", "coordinates": [[[-115.56564, 32.84427], [-115.56515, 32.84427], [-115.56515, 32.84344], [-115.56564, 32.84344], [-115.56564, 32.84427]]]} | Open Access 1 | Evans Park | 18756 | 1450 | Imperial, City of 34 | City 2 | City Agency 2 | http://www.cityofimperial.org/dept.php?id=33 | City 2 | 1.035 | Evans Park | ||
4097 | 4097 | 4096 | {"type": "Polygon", "coordinates": [[[-117.24873, 33.68638], [-117.2485, 33.68644], [-117.24818, 33.68657], [-117.24804, 33.68685], [-117.24806, 33.68707], [-117.24841, 33.68707], [-117.24841, 33.68713], [-117.24805, 33.68714], [-117.24806, 33.68804], [-117.24786, 33.68805], [-117.24784, 33.68777], [-117.24738, 33.68777], [-117.24738, 33.68776], [-117.24755, 33.68771], [-117.24773, 33.6876], [-117.24782, 33.68731], [-117.24776, 33.68715], [-117.24775, 33.68698], [-117.24771, 33.68676], [-117.2475, 33.68652], [-117.24733, 33.68645], [-117.24758, 33.68644], [-117.24759, 33.68616], [-117.24786, 33.68616], [-117.24788, 33.68642], [-117.24836, 33.68641], [-117.24871, 33.68635], [-117.24873, 33.68638]]]} | Open Access 1 | Evans Park | 18757 | 1458 | Canyon Lake, City of 644 | City 2 | City Agency 2 | http://www.cityofcanyonlake.com/ | City 2 | 1.857 | Evans Park | ||
4098 | 4098 | 4097 | {"type": "Polygon", "coordinates": [[[-121.44278, 37.71963], [-121.44271, 37.7197], [-121.4427, 37.71975], [-121.44272, 37.7198], [-121.44263, 37.71983], [-121.44257, 37.71994], [-121.44224, 37.71989], [-121.4423, 37.71951], [-121.44235, 37.7194], [-121.4424, 37.71932], [-121.44264, 37.71944], [-121.44278, 37.71963]]]} | Open Access 1 | Evelyn Costa Park | 18758 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.529 | Evelyn Costa Park | ||
4099 | 4099 | 4098 | {"type": "Polygon", "coordinates": [[[-121.54328, 38.50023], [-121.54324, 38.50055], [-121.54269, 38.50051], [-121.54277, 38.50022], [-121.54289, 38.50019], [-121.54328, 38.50023]]]} | Open Access 1 | Evelyn Dutra Park | 18759 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.413 | Evelyn Dutra Park | ||
4100 | 4100 | 4099 | {"type": "Polygon", "coordinates": [[[-122.52168, 37.93833], [-122.52146, 37.93845], [-122.52134, 37.938], [-122.52124, 37.93801], [-122.52118, 37.9379], [-122.52087, 37.93787], [-122.52102, 37.93776], [-122.52144, 37.93755], [-122.52168, 37.93833]]]} | Open Access 1 | Higgins Dock | 19926 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 0.626 | Higgins Dock | ||
4101 | 4101 | 4100 | {"type": "Polygon", "coordinates": [[[-118.83634, 34.15327], [-118.83465, 34.1532], [-118.83495, 34.15262], [-118.83501, 34.15232], [-118.835, 34.15207], [-118.8353, 34.15199], [-118.8356, 34.15199], [-118.83615, 34.15185], [-118.83612, 34.15261], [-118.83634, 34.15327]]]} | Open Access 1 | Evenstar Park | 18760 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 4.109 | Evenstar Park | ||
4102 | 4102 | 4101 | {"type": "Polygon", "coordinates": [[[-121.95707, 37.33348], [-121.9567, 37.33392], [-121.9564, 37.33377], [-121.95614, 37.3337], [-121.95611, 37.3328], [-121.95639, 37.33287], [-121.95664, 37.33299], [-121.95684, 37.33315], [-121.95707, 37.33343], [-121.95707, 37.33348]]]} | Open Access 1 | Everett Alvarez Park | 18761 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.695 | Everett Alvarez Park | 1961 | |
4103 | 4103 | 4102 | {"type": "Polygon", "coordinates": [[[-117.96673, 34.52821], [-117.9667, 34.52825], [-117.96665, 34.52827], [-117.96573, 34.52827], [-117.96572, 34.52596], [-117.96673, 34.52596], [-117.96673, 34.52821]]]} | Open Access 1 | Everett Martin Park | 18762 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 5.821 | Everett Martin Park | ||
4104 | 4104 | 4103 | {"type": "Polygon", "coordinates": [[[-121.77104, 37.29929], [-121.771, 37.29934], [-121.77064, 37.29948], [-121.77039, 37.29955], [-121.77011, 37.2996], [-121.76972, 37.29963], [-121.76945, 37.29962], [-121.76919, 37.29959], [-121.76893, 37.29954], [-121.76869, 37.29947], [-121.76844, 37.29938], [-121.76823, 37.29927], [-121.76724, 37.29862], [-121.76692, 37.29844], [-121.76659, 37.29828], [-121.76622, 37.29814], [-121.76588, 37.29803], [-121.76471, 37.29776], [-121.76452, 37.29773], [-121.76414, 37.29769], [-121.76375, 37.29769], [-121.76328, 37.29774], [-121.76297, 37.29775], [-121.76276, 37.29775], [-121.76234, 37.2977], [-121.76187, 37.29768], [-121.76116, 37.2977], [-121.76066, 37.29777], [-121.76037, 37.29785], [-121.76012, 37.29794], [-121.75978, 37.2981], [-121.75874, 37.29878], [-121.758, 37.29924], [-121.7578, 37.29934], [-121.75774, 37.29933], [-121.75763, 37.29921], [-121.75742, 37.29909], [-121.75726, 37.29905], [-121.75704, 37.29904], [-121.75694, 37.29901], [-121.75663, 37.29888], [-121.75651, 37.29836], [-121.7577, 37.29818], [-121.75776, 37.29837], [-121.75784, 37.29837], [-121.7579, 37.29842], [-121.75799, 37.29843], [-121.75804, 37.2984], [-121.75813, 37.2983], [-121.75854, 37.29805], [-121.75876, 37.29797], [-121.75911, 37.2979], [-121.7593, 37.29785], [-121.7595, 37.29775], [-121.75996, 37.29749], [-121.76014, 37.29744], [-121.76065, 37.29735], [-121.7612, 37.29714], [-121.76136, 37.29709], [-121.76161, 37.29706], [-121.7618, 37.29705], [-121.76204, 37.29707], [-121.76294, 37.29721], [-121.76372, 37.29717], [-121.76504, 37.29721], [-121.7653, 37.29724], [-121.76771, 37.2977], [-121.76778, 37.29767], [-121.76782, 37.29762], [-121.76799, 37.2969], [-121.768, 37.29688], [-121.76843, 37.29676], [-121.769, 37.2965], [-121.76905, 37.29652], [-121.77087, 37.29895], [-121.77103, 37.29925], [-121.77104, 37.29929]]]} | Open Access 1 | Evergreen | 18764 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 34.375 | Evergreen | 1966 | |
4105 | 4105 | 4104 | {"type": "MultiPolygon", "coordinates": [[[[-119.89265, 34.43988], [-119.89261, 34.4399], [-119.89232, 34.4398], [-119.89214, 34.43966], [-119.89204, 34.43955], [-119.89163, 34.43896], [-119.89154, 34.43885], [-119.89133, 34.43865], [-119.89101, 34.43845], [-119.89073, 34.43834], [-119.89043, 34.43827], [-119.89028, 34.43826], [-119.88921, 34.43829], [-119.88894, 34.43834], [-119.88879, 34.4384], [-119.88854, 34.43802], [-119.8882, 34.43768], [-119.88786, 34.43766], [-119.88738, 34.43779], [-119.8877, 34.43814], [-119.88789, 34.4383], [-119.88793, 34.43836], [-119.888, 34.43839], [-119.8881, 34.4384], [-119.88817, 34.43844], [-119.88764, 34.43883], [-119.88747, 34.43903], [-119.88774, 34.43919], [-119.88766, 34.43931], [-119.88757, 34.43951], [-119.88754, 34.43952], [-119.88704, 34.43953], [-119.88708, 34.4393], [-119.88708, 34.43889], [-119.8874, 34.43825], [-119.88673, 34.43805], [-119.88627, 34.43734], [-119.88582, 34.43694], [-119.88519, 34.43694], [-119.88516, 34.43552], [-119.88529, 34.43552], [-119.88647, 34.43593], [-119.88718, 34.43652], [-119.89012, 34.43693], [-119.89012, 34.43702], [-119.88962, 34.43701], [-119.88989, 34.43746], [-119.89066, 34.43751], [-119.89169, 34.43778], [-119.89209, 34.4381], [-119.8921, 34.43842], [-119.89218, 34.43853], [-119.8923, 34.43889], [-119.89262, 34.43884], [-119.89269, 34.43916], [-119.89271, 34.4395], [-119.8927, 34.43963], [-119.89265, 34.43988]]], [[[-119.88815, 34.4414], [-119.88811, 34.44143], [-119.88793, 34.44143], [-119.88788, 34.44135], [-119.88786, 34.44123], [-119.88781, 34.44125], [-119.88781, 34.44143], [-119.88746, 34.44144], [-119.88744, 34.44059], [-119.88687, 34.44047], [-119.88701, 34.43969], [-119.88749, 34.43967], [-119.88754, 34.4397], [-119.88757, 34.43995], [-119.88763, 34.44013], [-119.88767, 34.44021], [-119.88793, 34.44059], [-119.88803, 34.44081], [-119.88807, 34.44093], [-119.88815, 34.4414]]]]} | Open Access 1 | Evergreen Acres | 18765 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 28.796 | Evergreen Acres | ||
4106 | 4106 | 4105 | {"type": "Polygon", "coordinates": [[[-118.04559, 33.82791], [-118.04349, 33.82792], [-118.04347, 33.82704], [-118.04558, 33.82702], [-118.04559, 33.82791]]]} | Open Access 1 | Evergreen Park | 18766 | 1077 | Cypress, City of 214 | City 2 | City Agency 2 | http://www.ci.cypress.ca.us/ | City 2 | 4.741 | Evergreen Park | ||
4107 | 4107 | 4106 | {"type": "Polygon", "coordinates": [[[-121.77436, 37.31377], [-121.77415, 37.31422], [-121.77351, 37.31402], [-121.77373, 37.31357], [-121.77436, 37.31377]]]} | Open Access 1 | Evergreen Village Park | 18768 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.805 | Evergreen Village Park | 2004 | |
4108 | 4108 | 4107 | {"type": "Polygon", "coordinates": [[[-121.76949, 38.66654], [-121.76949, 38.66668], [-121.76897, 38.66668], [-121.76896, 38.66711], [-121.76896, 38.6678], [-121.76948, 38.66781], [-121.76948, 38.66784], [-121.76792, 38.66784], [-121.76793, 38.66653], [-121.76949, 38.66654]]]} | Open Access 1 | Everman Park | 18769 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 3.446 | Everman Park | ||
4109 | 4109 | 4108 | {"type": "Polygon", "coordinates": [[[-120.69928, 35.55395], [-120.69932, 35.55471], [-120.69929, 35.55506], [-120.69913, 35.5555], [-120.69877, 35.55592], [-120.69793, 35.5567], [-120.69731, 35.5564], [-120.69876, 35.55393], [-120.69928, 35.55395]]]} | Open Access 1 | Evers Park | 18770 | 2289 | Templeton Community Services District 1000 | Special District 4 | Community Services District 17 | http://templetoncsd.org | Special District 4 | 6.748 | Evers Park | ||
4110 | 4110 | 4109 | {"type": "Polygon", "coordinates": [[[-116.74026, 33.1805], [-116.73988, 33.18051], [-116.73975, 33.18053], [-116.73967, 33.18056], [-116.7395, 33.18056], [-116.73938, 33.18052], [-116.73921, 33.18041], [-116.73815, 33.18042], [-116.73818, 33.18262], [-116.73708, 33.18261], [-116.73375, 33.18275], [-116.73377, 33.17923], [-116.74025, 33.17921], [-116.74026, 33.1805]]]} | No Public Access 3 | Ewing Oak Preserve | 18771 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 45.462 | Ewing Oak Preserve | ||
4111 | 4111 | 4110 | {"type": "Polygon", "coordinates": [[[-122.43383, 37.72008], [-122.4332, 37.72091], [-122.43261, 37.72063], [-122.43324, 37.7198], [-122.43383, 37.72008]]]} | Open Access 1 | Excelsior Playground | 18772 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.612 | Excelsior Playground | ||
4112 | 4112 | 4111 | {"type": "Polygon", "coordinates": [[[-119.13521, 36.30947], [-119.1351, 36.31147], [-119.13075, 36.31143], [-119.13077, 36.31043], [-119.1323, 36.31043], [-119.13238, 36.30936], [-119.13521, 36.30947]]]} | Open Access 1 | Exeter Cemetery | 18773 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Special District 4 | 18.077 | Exeter Cemetery | |||
4113 | 4113 | 4112 | {"type": "Polygon", "coordinates": [[[-118.2058, 34.03807], [-118.20518, 34.03902], [-118.20469, 34.03879], [-118.2044, 34.03922], [-118.20354, 34.03884], [-118.20443, 34.03747], [-118.20518, 34.0378], [-118.20519, 34.03783], [-118.20534, 34.0379], [-118.20536, 34.03788], [-118.2058, 34.03807]]]} | Open Access 1 | Evergreen Recreation Center | 18767 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 5.396 | Evergreen Rec. Ctr. | ||
4114 | 4114 | 4113 | {"type": "Polygon", "coordinates": [[[-124.18466, 40.77683], [-124.18464, 40.77692], [-124.18432, 40.77692], [-124.18424, 40.77685], [-124.18405, 40.77686], [-124.18395, 40.77717], [-124.18357, 40.77717], [-124.18357, 40.7769], [-124.18356, 40.77682], [-124.1833, 40.77646], [-124.18325, 40.77636], [-124.18325, 40.77576], [-124.18415, 40.77576], [-124.18416, 40.77599], [-124.18462, 40.776], [-124.18461, 40.77678], [-124.18466, 40.77683]]]} | Open Access 1 | Highland Park | 19936 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 3.39 | Highland 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]);